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

11 rows where package_id = "CHRG-112jhrg73772" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title

id package_id name ▼ title organization organization_normalized location
60479 JOINT HEARING TO RECEIVE LEGISLATIVE PRESENTATION OF VETERANS SERVICE ORGANIZATIONS CHRG-112jhrg73772 Allen E. Falk   National Commander, Jewish War Veterans NATIONAL COMMANDER, JEWISH WAR VETERANS  
60480 JOINT HEARING TO RECEIVE LEGISLATIVE PRESENTATION OF VETERANS SERVICE ORGANIZATIONS CHRG-112jhrg73772 Bill Lawson National President Paralyzed Veterans of America PARALYZED VETERANS OF AMERICA  
60474 JOINT HEARING TO RECEIVE LEGISLATIVE PRESENTATION OF VETERANS SERVICE ORGANIZATIONS CHRG-112jhrg73772 Charles Susino Senior Vice Commander American Ex-Prisoners of War AMERICAN EX-PRISONERS OF WAR  
60476 JOINT HEARING TO RECEIVE LEGISLATIVE PRESENTATION OF VETERANS SERVICE ORGANIZATIONS CHRG-112jhrg73772 Colonel Bob Norton (USA-Ret) Deputy Director of Government Relations, Military Officers Association of America      
60484 JOINT HEARING TO RECEIVE LEGISLATIVE PRESENTATION OF VETERANS SERVICE ORGANIZATIONS CHRG-112jhrg73772 Gary L. Fry   National Commander, AMVETS NATIONAL COMMANDER, AMVETS  
60477 JOINT HEARING TO RECEIVE LEGISLATIVE PRESENTATION OF VETERANS SERVICE ORGANIZATIONS CHRG-112jhrg73772 Jamie H. Tomek   Chair, Government Relations Committee, Gold Star Wives CHAIR, GOVERNMENT RELATIONS COMMITTEE, GOLD STAR WIVES  
60475 JOINT HEARING TO RECEIVE LEGISLATIVE PRESENTATION OF VETERANS SERVICE ORGANIZATIONS CHRG-112jhrg73772 John R. Davis Director of Legislative Programs Fleet Reserve Association FLEET RESERVE ASSOCIATION  
60482 JOINT HEARING TO RECEIVE LEGISLATIVE PRESENTATION OF VETERANS SERVICE ORGANIZATIONS CHRG-112jhrg73772 John R. ``Doc'' McCauslin (CMSGT-Ret) Chief Executive Officer, Air Force Sergeants Association      
60483 JOINT HEARING TO RECEIVE LEGISLATIVE PRESENTATION OF VETERANS SERVICE ORGANIZATIONS CHRG-112jhrg73772 MG Gus Hargett President National Guard Association of the United States NATIONAL GUARD ASSOCIATION OF THE UNITED STATES  
60478 JOINT HEARING TO RECEIVE LEGISLATIVE PRESENTATION OF VETERANS SERVICE ORGANIZATIONS CHRG-112jhrg73772 Prepared Statement of Mrs   Tomek TOMEK  
60481 JOINT HEARING TO RECEIVE LEGISLATIVE PRESENTATION OF VETERANS SERVICE ORGANIZATIONS CHRG-112jhrg73772 Sam Huhn National President Blinded Veterans Association BLINDED VETERANS ASSOCIATION  

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;