hearing_witnesses

Witnesses who testified at committee hearings, with parsed name, title, organization, and location.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

7 rows where package_id = "CHRG-110hhrg44932" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location

id package_id name ▼ title organization organization_normalized location
35906 EXAMINING THE EFFECTIVENESS OF THE VETERANS BENEFITS ADMINISTRATION'S TRAINING, PERFORMANCE MANAGEMENT AND ACCOUNTABILITY CHRG-110hhrg44932 American Federation of Government Employees Decision Review Officer AFL-CIO, Michael Ratajczak, Cleveland Veterans Affairs Regional Office, Veterans Benefits Administration, U.S. Department of Veterans AFL-CIO, MICHAEL RATAJCZAK, CLEVELAND VETERANS AFFAIRS REGIONAL OFFICE, VETERANS BENEFITS ADMINISTRATION, U.S. DEPARTMENT OF VETERANS  
35908 EXAMINING THE EFFECTIVENESS OF THE VETERANS BENEFITS ADMINISTRATION'S TRAINING, PERFORMANCE MANAGEMENT AND ACCOUNTABILITY CHRG-110hhrg44932 Disabled American Veterans Assistant National Legislative Director Kerry Baker KERRY BAKER  
35910 EXAMINING THE EFFECTIVENESS OF THE VETERANS BENEFITS ADMINISTRATION'S TRAINING, PERFORMANCE MANAGEMENT AND ACCOUNTABILITY CHRG-110hhrg44932 Human Resources Research Organization Ph.D., Program Manager Patricia A. Keenan PATRICIA A. KEENAN  
35909 EXAMINING THE EFFECTIVENESS OF THE VETERANS BENEFITS ADMINISTRATION'S TRAINING, PERFORMANCE MANAGEMENT AND ACCOUNTABILITY CHRG-110hhrg44932 National Veterans Legal Services Program Joint Executive Director Ronald B. Abrams RONALD B. ABRAMS  
35907 EXAMINING THE EFFECTIVENESS OF THE VETERANS BENEFITS ADMINISTRATION'S TRAINING, PERFORMANCE MANAGEMENT AND ACCOUNTABILITY CHRG-110hhrg44932 Nicholas T. Bartzis       Cleveland, OH
35905 EXAMINING THE EFFECTIVENESS OF THE VETERANS BENEFITS ADMINISTRATION'S TRAINING, PERFORMANCE MANAGEMENT AND ACCOUNTABILITY CHRG-110hhrg44932 U.S. Department of Veterans Affairs Deputy Under Secretary for Benefits Michael Walcoff, Veterans Benefits Administration MICHAEL WALCOFF, VETERANS BENEFITS ADMINISTRATION  
35904 EXAMINING THE EFFECTIVENESS OF THE VETERANS BENEFITS ADMINISTRATION'S TRAINING, PERFORMANCE MANAGEMENT AND ACCOUNTABILITY CHRG-110hhrg44932 U.S. Government Accountability Office Director Daniel Bertoni, Education, Workforce, and Income Security Issues DANIEL BERTONI, EDUCATION, WORKFORCE, AND INCOME SECURITY ISSUES  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE hearing_witnesses (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    package_id TEXT NOT NULL REFERENCES hearings(package_id),
    name TEXT,
    title TEXT,
    organization TEXT,
    organization_normalized TEXT,
    location TEXT
);
CREATE INDEX idx_hw_package ON hearing_witnesses(package_id);
CREATE INDEX idx_hw_name ON hearing_witnesses(name);
CREATE INDEX idx_hw_org ON hearing_witnesses(organization) WHERE organization IS NOT NULL AND organization != '';
CREATE INDEX idx_hw_org_norm ON hearing_witnesses(organization_normalized) WHERE organization_normalized IS NOT NULL;