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

✎ View and edit SQL

This data as json, CSV (advanced)

id package_id name ▼ title organization organization_normalized location
69521 EVALUATING FEDERAL AND COMMUNITY EFFORTS TO ELIMINATE VETERAN HOMELESSNESS CHRG-113hhrg96139 Accompanied by: Thomas O'Toole Acting Director, Senior Advisor on Housing and Services to the Secretary National Center for Homelessness Among Veterans, U.S. Department of Veterans Affairs Jennifer Ho, U.S. Department of Housing and Urban Development NATIONAL CENTER FOR HOMELESSNESS AMONG VETERANS, U.S. DEPARTMENT OF VETERANS AFFAIRS JENNIFER HO, U.S. DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT  
69514 EVALUATING FEDERAL AND COMMUNITY EFFORTS TO ELIMINATE VETERAN HOMELESSNESS CHRG-113hhrg96139 Baylee Crone Executive Director National Coalition for Homeless Veterans NATIONAL COALITION FOR HOMELESS VETERANS  
69518 EVALUATING FEDERAL AND COMMUNITY EFFORTS TO ELIMINATE VETERAN HOMELESSNESS CHRG-113hhrg96139 Casey O'Donnell Chief Operating Officer, Impact Services Corporation PsyD PSYD  
69522 EVALUATING FEDERAL AND COMMUNITY EFFORTS TO ELIMINATE VETERAN HOMELESSNESS CHRG-113hhrg96139 Hon. Keith Kelly Assistant Secretary of Labor, Veterans' Employment and Training Service U.S. Department of Labor U.S. DEPARTMENT OF LABOR  
69516 EVALUATING FEDERAL AND COMMUNITY EFFORTS TO ELIMINATE VETERAN HOMELESSNESS CHRG-113hhrg96139 John F. Downing Chief Executive Officer Soldier On SOLDIER ON  
69519 EVALUATING FEDERAL AND COMMUNITY EFFORTS TO ELIMINATE VETERAN HOMELESSNESS CHRG-113hhrg96139 Jon Sherin M.D., Ph.D., Executive Vice President for Military Communities and Chief Medical Officer Volunteers of America VOLUNTEERS OF AMERICA  
69520 EVALUATING FEDERAL AND COMMUNITY EFFORTS TO ELIMINATE VETERAN HOMELESSNESS CHRG-113hhrg96139 Lisa Pape Executive Diretctor Homeless Programs, VHA, U.S. Department of Veterans Affairs HOMELESS PROGRAMS, VHA, U.S. DEPARTMENT OF VETERANS AFFAIRS  
69517 EVALUATING FEDERAL AND COMMUNITY EFFORTS TO ELIMINATE VETERAN HOMELESSNESS CHRG-113hhrg96139 Phil Landis President and Chief Executive Officer Veterans Village of San Diego VETERANS VILLAGE OF SAN DIEGO  
69515 EVALUATING FEDERAL AND COMMUNITY EFFORTS TO ELIMINATE VETERAN HOMELESSNESS CHRG-113hhrg96139 Steve R. Berg Vice President for Programs and Policy National Alliance to End Homelessness NATIONAL ALLIANCE TO END HOMELESSNESS  

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;