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-112hhrg78772" 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
59797 WADING THROUGH WAREHOUSES OF PAPER: THE CHALLENGES OF TRANSITIONING VETERANS RECORDS TO PAPERLESS TECHNOLOGY CHRG-112hhrg78772 Alan Bozeman Director Veterans Benefits Management System Program Office, Veterans Benefits Administration, U.S. Department of Veterans Affairs VETERANS BENEFITS MANAGEMENT SYSTEM PROGRAM OFFICE, VETERANS BENEFITS ADMINISTRATION, U.S. DEPARTMENT OF VETERANS AFFAIRS  
59793 WADING THROUGH WAREHOUSES OF PAPER: THE CHALLENGES OF TRANSITIONING VETERANS RECORDS TO PAPERLESS TECHNOLOGY CHRG-112hhrg78772 Executive Summary of Mr. Viterna Esq      
59795 WADING THROUGH WAREHOUSES OF PAPER: THE CHALLENGES OF TRANSITIONING VETERANS RECORDS TO PAPERLESS TECHNOLOGY CHRG-112hhrg78772 James G. Neighbors Director of DoD/VA Collaboration Office U.S. Department of Defense U.S. DEPARTMENT OF DEFENSE  
59794 WADING THROUGH WAREHOUSES OF PAPER: THE CHALLENGES OF TRANSITIONING VETERANS RECORDS TO PAPERLESS TECHNOLOGY CHRG-112hhrg78772 Jeffrey C. Hall Assistant National Legislative Director Disabled American Veterans DISABLED AMERICAN VETERANS  
59791 WADING THROUGH WAREHOUSES OF PAPER: THE CHALLENGES OF TRANSITIONING VETERANS RECORDS TO PAPERLESS TECHNOLOGY CHRG-112hhrg78772 Michael R. Viterna Esq., President, National Association of Veterans Advocates      
59792 WADING THROUGH WAREHOUSES OF PAPER: THE CHALLENGES OF TRANSITIONING VETERANS RECORDS TO PAPERLESS TECHNOLOGY CHRG-112hhrg78772 Prepared Statement of Mr. Viterna Esq      
59790 WADING THROUGH WAREHOUSES OF PAPER: THE CHALLENGES OF TRANSITIONING VETERANS RECORDS TO PAPERLESS TECHNOLOGY CHRG-112hhrg78772 Richard Dumancas Deputy Director for Claims      
59796 WADING THROUGH WAREHOUSES OF PAPER: THE CHALLENGES OF TRANSITIONING VETERANS RECORDS TO PAPERLESS TECHNOLOGY CHRG-112hhrg78772 Scott Levins Director of the National Personnel Records Center U.S. National Archives and Records Administration U.S. NATIONAL ARCHIVES AND RECORDS ADMINISTRATION  

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;