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

8 rows where package_id = "CHRG-111hhrg61757" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

id package_id name ▼ title organization organization_normalized location
47906 UPDATE OF THE POST-9/11 GI BILL CHRG-111hhrg61757 American Association of State Colleges and Universities Ph.D., President Alan G. Merten, George Mason University ALAN G. MERTEN, GEORGE MASON UNIVERSITY  
47907 UPDATE OF THE POST-9/11 GI BILL CHRG-111hhrg61757 American Legion Assistant Director Robert Madden, National Economic Commission ROBERT MADDEN, NATIONAL ECONOMIC COMMISSION  
47908 UPDATE OF THE POST-9/11 GI BILL CHRG-111hhrg61757 Iraq and Afghanistan Veterans of America Legislative Associate Tim Embree TIM EMBREE  
47909 UPDATE OF THE POST-9/11 GI BILL CHRG-111hhrg61757 National Association of Veterans' Program Administrators Legislative Director Faith DesLauriers FAITH DESLAURIERS  
47904 UPDATE OF THE POST-9/11 GI BILL CHRG-111hhrg61757 U.S. Department of Defense Captain Mark Krause, USN (Ret.), U.S. Department of Veterans Affairs Program Manager Space and Naval War Systems Center Atlantic, Department of the Navy SPACE AND NAVAL WAR SYSTEMS CENTER ATLANTIC, DEPARTMENT OF THE NAVY  
47905 UPDATE OF THE POST-9/11 GI BILL CHRG-111hhrg61757 U.S. Department of Veterans Affairs Director, Education Service Keith M. Wilson, Veterans Benefits Administration KEITH M. WILSON, VETERANS BENEFITS ADMINISTRATION  
47911 UPDATE OF THE POST-9/11 GI BILL CHRG-111hhrg61757 Veterans of Foreign Wars of the United States Assistant Director, National Veterans Service James D. Wear JAMES D. WEAR  
47910 UPDATE OF THE POST-9/11 GI BILL CHRG-111hhrg61757 Veterans of Modern Warfare Jr., Executive Director Donald D. Overton DONALD D. OVERTON  

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;