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

5 rows where package_id = "CHRG-111hhrg61515" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

id package_id name ▼ title organization organization_normalized location
47859 PEPFAR: FROM EMERGENCY TO SUSTAINABILITY AND ADVANCES AGAINST HIV/AIDS CHRG-111hhrg61515 Anthony S. Fauci M.D., Director National Institute of Allergy and Infectious Diseases (NIAID), National Institutes of Health NATIONAL INSTITUTE OF ALLERGY AND INFECTIOUS DISEASES (NIAID), NATIONAL INSTITUTES OF HEALTH  
47860 PEPFAR: FROM EMERGENCY TO SUSTAINABILITY AND ADVANCES AGAINST HIV/AIDS CHRG-111hhrg61515 Ms. Paula Akugizibwe Advocacy Coordinator AIDS and Rights Alliance for Southern Africa (ARASA) AIDS AND RIGHTS ALLIANCE FOR SOUTHERN AFRICA (ARASA)  
47857 PEPFAR: FROM EMERGENCY TO SUSTAINABILITY AND ADVANCES AGAINST HIV/AIDS CHRG-111hhrg61515 The Honorable Eric Goosby United States Global AIDS Coordinator U.S. Department of State U.S. DEPARTMENT OF STATE  
47858 PEPFAR: FROM EMERGENCY TO SUSTAINABILITY AND ADVANCES AGAINST HIV/AIDS CHRG-111hhrg61515 Thomas R. Frieden M.D., M.P.H., Director, Administrator Centers for Disease Control and Prevention, and, Agency for Toxic Substances & Disease Registry CENTERS FOR DISEASE CONTROL AND PREVENTION, AND, AGENCY FOR TOXIC SUBSTANCES & DISEASE REGISTRY  
47861 PEPFAR: FROM EMERGENCY TO SUSTAINABILITY AND ADVANCES AGAINST HIV/AIDS CHRG-111hhrg61515 Wafaa El-Sadr M.D., M.P.H., Director International Center for AIDS Care and Treatment Programs (ICAP), Mailman School of Public Health, Columbia University INTERNATIONAL CENTER FOR AIDS CARE AND TREATMENT PROGRAMS (ICAP), MAILMAN SCHOOL OF PUBLIC HEALTH, COLUMBIA UNIVERSITY  

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;