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

10 rows where package_id = "CHRG-111hhrg61761" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, location

id package_id name ▼ title organization organization_normalized location
47933 THE TRUE COST OF THE WAR CHRG-111hhrg61761 Corey Gibson       Terre Haute, IN
47932 THE TRUE COST OF THE WAR CHRG-111hhrg61761 Disabled American Veterans National Legislative Director Joseph A. Violante JOSEPH A. VIOLANTE  
47936 THE TRUE COST OF THE WAR CHRG-111hhrg61761 Joseph E. Stiglitz Ph.D., University Professor Columbia University COLUMBIA UNIVERSITY New York, NY
47931 THE TRUE COST OF THE WAR CHRG-111hhrg61761 Linda J. Bilmes Daniel Patrick Moynihan Senior Lecturer in Public Policy John F. Kennedy School of Government, Harvard University JOHN F. KENNEDY SCHOOL OF GOVERNMENT, HARVARD UNIVERSITY Cambridge, MA
47934 THE TRUE COST OF THE WAR CHRG-111hhrg61761 Lorrie Knight-Major       Silver Spring, MD
47930 THE TRUE COST OF THE WAR CHRG-111hhrg61761 Major General John Batiste USA (Ret.)     Rochester, NY
47935 THE TRUE COST OF THE WAR CHRG-111hhrg61761 Major General William L. Nash USA (Ret.)     Washington, DC
47937 THE TRUE COST OF THE WAR CHRG-111hhrg61761 Van Derveer Lieutenant Colonel Donna R., USA (Ret.)     Ashville, AL
47938 THE TRUE COST OF THE WAR CHRG-111hhrg61761 Veterans for Common Sense Executive Director Paul Sullivan PAUL SULLIVAN  
47939 THE TRUE COST OF THE WAR CHRG-111hhrg61761 Veterans' Outreach Center of Rochester Jr., USA (Ret.), President and Chief Executive Officer NY, Colonel James D. McDonough NY, COLONEL JAMES D. MCDONOUGH  

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;