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-113hhrg98631" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

id package_id name ▼ title organization organization_normalized location
69529 LEGISLATIVE HEARING ON H.R. 675, H.R. 677, H.R. 732, H.R. 800, H.R. 1067, H.R. 1331, H.R. 1379, H.R. 1414, H.R. 1569, AND H.R. 1607 CHRG-113hhrg98631 Accompanied by: Ms. Laura H. Eskenazi Executive-in-Charge and Vice Chairman, Assistant General Counsel, Office of General Counsel, Deputy Director for Claims Board Of Veterans' Appeals, U.S. Department of Veterans Affairs And Mr. David J. Barrans, U.S. Department of Veterans Affairs Mr. Zachary Hearn, Veterans Affairs and Rehabilitation Division, The American Legion BOARD OF VETERANS' APPEALS, U.S. DEPARTMENT OF VETERANS AFFAIRS AND MR. DAVID J. BARRANS, U.S. DEPARTMENT OF VETERANS AFFAIRS MR. ZACHARY HEARN, VETERANS AFFAIRS AND REHABILITATION DIVISION, THE AMERICAN LEGION  
69527 LEGISLATIVE HEARING ON H.R. 675, H.R. 677, H.R. 732, H.R. 800, H.R. 1067, H.R. 1331, H.R. 1379, H.R. 1414, H.R. 1569, AND H.R. 1607 CHRG-113hhrg98631 Hon. Chellie Pingree   U.S. House of Representatives U.S. HOUSE OF REPRESENTATIVES  
69530 LEGISLATIVE HEARING ON H.R. 675, H.R. 677, H.R. 732, H.R. 800, H.R. 1067, H.R. 1331, H.R. 1379, H.R. 1414, H.R. 1569, AND H.R. 1607 CHRG-113hhrg98631 Mr. Blake C. Ortner Deputy Government Relations Director Paralyzed Veterans of America      
69528 LEGISLATIVE HEARING ON H.R. 675, H.R. 677, H.R. 732, H.R. 800, H.R. 1067, H.R. 1331, H.R. 1379, H.R. 1414, H.R. 1569, AND H.R. 1607 CHRG-113hhrg98631 Mr. David R. McLenachen Acting Deputy Under Secretary for Disability Assistance VBA U.S. Department of Veterans Affairs U.S. DEPARTMENT OF VETERANS AFFAIRS  
69533 LEGISLATIVE HEARING ON H.R. 675, H.R. 677, H.R. 732, H.R. 800, H.R. 1067, H.R. 1331, H.R. 1379, H.R. 1414, H.R. 1569, AND H.R. 1607 CHRG-113hhrg98631 Mr. Kenneth M. Carpenter Founding Member, National Organization of Veterans' Advocates      
69531 LEGISLATIVE HEARING ON H.R. 675, H.R. 677, H.R. 732, H.R. 800, H.R. 1067, H.R. 1331, H.R. 1379, H.R. 1414, H.R. 1569, AND H.R. 1607 CHRG-113hhrg98631 Mr. Paul R. Varela Assistant National Legislative Director DAV DAV  
69532 LEGISLATIVE HEARING ON H.R. 675, H.R. 677, H.R. 732, H.R. 800, H.R. 1067, H.R. 1331, H.R. 1379, H.R. 1414, H.R. 1569, AND H.R. 1607 CHRG-113hhrg98631 Mr. Ronald B. Abrams Joint Executive Director, National Veterans Legal Services Program      

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;