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

9 rows where package_id = "CHRG-114shrg28034" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

id package_id name ▼ title organization organization_normalized location
79331 THE FUTURE OF THE VA: EXAMINING THE COMMISSION ON CARE REPORT AND VA'S RESPONSE CHRG-114shrg28034 CDR Rene A. Campos USN (Ret.), Deputy Director of Government Relations, Military Officers Association of America      
79332 THE FUTURE OF THE VA: EXAMINING THE COMMISSION ON CARE REPORT AND VA'S RESPONSE CHRG-114shrg28034 Carlos Fuentes Deputy Director of National Legislative Service Veterans of Foreign Wars VETERANS OF FOREIGN WARS  
79325 THE FUTURE OF THE VA: EXAMINING THE COMMISSION ON CARE REPORT AND VA'S RESPONSE CHRG-114shrg28034 Hon. Robert A. McDonald Secretary, M.D., Under Secretary for Health Department of Veterans Affairs; accompanied by Hon. David J. Shulkin DEPARTMENT OF VETERANS AFFAIRS; ACCOMPANIED BY HON. DAVID J. SHULKIN  
79327 THE FUTURE OF THE VA: EXAMINING THE COMMISSION ON CARE REPORT AND VA'S RESPONSE CHRG-114shrg28034 Hon. Thomas E. Harvey Esq., Member Commission on Care COMMISSION ON CARE  
79328 THE FUTURE OF THE VA: EXAMINING THE COMMISSION ON CARE REPORT AND VA'S RESPONSE CHRG-114shrg28034 Jeff Steele Assistant Director Legislative Division, The American Legion LEGISLATIVE DIVISION, THE AMERICAN LEGION  
79329 THE FUTURE OF THE VA: EXAMINING THE COMMISSION ON CARE REPORT AND VA'S RESPONSE CHRG-114shrg28034 Joy J. Ilem National Legislative Director Disabled American Veterans DISABLED AMERICAN VETERANS  
79330 THE FUTURE OF THE VA: EXAMINING THE COMMISSION ON CARE REPORT AND VA'S RESPONSE CHRG-114shrg28034 Lauren Augustine Senior Legislative Associate Iraq and Afghanistan Veterans of America IRAQ AND AFGHANISTAN VETERANS OF AMERICA  
79326 THE FUTURE OF THE VA: EXAMINING THE COMMISSION ON CARE REPORT AND VA'S RESPONSE CHRG-114shrg28034 Nancy M. Schlichting   Chairperson, Commission on Care CHAIRPERSON, COMMISSION ON CARE  
79333 THE FUTURE OF THE VA: EXAMINING THE COMMISSION ON CARE REPORT AND VA'S RESPONSE CHRG-114shrg28034 Richard Weidman Executive Director for Policy and Government Affairs Vietnam Veterans of America VIETNAM VETERANS OF AMERICA  

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;