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-115shrg33955" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

id package_id name ▼ title organization organization_normalized location
87595 THE FEDERAL ROLE IN THE TOXIC PFAS CHEMICAL CRISIS CHRG-115shrg33955 Andrea Amico Co-Founder Testing for Pease TESTING FOR PEASE  
87596 THE FEDERAL ROLE IN THE TOXIC PFAS CHEMICAL CRISIS CHRG-115shrg33955 Arnold Leriche   Community Co-Chair, Wurtsmith Restoration Advisory Board COMMUNITY CO-CHAIR, WURTSMITH RESTORATION ADVISORY BOARD  
87594 THE FEDERAL ROLE IN THE TOXIC PFAS CHEMICAL CRISIS CHRG-115shrg33955 Brian J. Lepore Director Defense Capabilities and Management, U.S. Government Accountability Office DEFENSE CAPABILITIES AND MANAGEMENT, U.S. GOVERNMENT ACCOUNTABILITY OFFICE  
87593 THE FEDERAL ROLE IN THE TOXIC PFAS CHEMICAL CRISIS CHRG-115shrg33955 Linda S. Birnbaum Ph.D., D.A.B.T., A.T.S., Director, Department of Health and Human Services National Institute of Environmental Health Sciences and National Toxicology Program, National Institutes of Health NATIONAL INSTITUTE OF ENVIRONMENTAL HEALTH SCIENCES AND NATIONAL TOXICOLOGY PROGRAM, NATIONAL INSTITUTES OF HEALTH  
87592 THE FEDERAL ROLE IN THE TOXIC PFAS CHEMICAL CRISIS CHRG-115shrg33955 Maureen Sullivan Deputy Assistant Secretary of Defense for Environment, Office of the Assistant Secretary of Defense for Energy Installations and Environment, U.S. Department of Defense INSTALLATIONS AND ENVIRONMENT, U.S. DEPARTMENT OF DEFENSE  
87591 THE FEDERAL ROLE IN THE TOXIC PFAS CHEMICAL CRISIS CHRG-115shrg33955 Peter C. Grevatt Ph.D., Director Office of Ground Water and Drinking Water, U.S. Environmental Protection Agency OFFICE OF GROUND WATER AND DRINKING WATER, U.S. ENVIRONMENTAL PROTECTION AGENCY  
87597 THE FEDERAL ROLE IN THE TOXIC PFAS CHEMICAL CRISIS CHRG-115shrg33955 Timothy Putnam Vice President Tidewater Federal Firefighters Local F-25, International Association of Fire Fighters TIDEWATER FEDERAL FIREFIGHTERS LOCAL F-25, INTERNATIONAL ASSOCIATION OF FIRE FIGHTERS  

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;