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

6 rows where package_id = "CHRG-112shrg25110" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

id package_id name ▼ title organization organization_normalized location
60767 OVERSIGHT OF EPA AUTHORITIES AND ACTIONS TO CONTROL EXPOSURES TO TOXIC CHEMICALS CHRG-112shrg25110 Hannah Pingree former Speaker of the Maine House of Representatives mother MOTHER  
60768 OVERSIGHT OF EPA AUTHORITIES AND ACTIONS TO CONTROL EXPOSURES TO TOXIC CHEMICALS CHRG-112shrg25110 Heather M. Stapleton Ph.D., Associate Professor Nicholas School of the Environment, Duke University NICHOLAS SCHOOL OF THE ENVIRONMENT, DUKE UNIVERSITY  
60766 OVERSIGHT OF EPA AUTHORITIES AND ACTIONS TO CONTROL EXPOSURES TO TOXIC CHEMICALS CHRG-112shrg25110 James J. Jones Acting Assistant Administrator Office of Chemical Safety and Pollution Prevention, U.S. Environmental Protection Agency OFFICE OF CHEMICAL SAFETY AND POLLUTION PREVENTION, U.S. ENVIRONMENTAL PROTECTION AGENCY  
60769 OVERSIGHT OF EPA AUTHORITIES AND ACTIONS TO CONTROL EXPOSURES TO TOXIC CHEMICALS CHRG-112shrg25110 Marshall Moore Director Technology, Advocacy and Marketing, Great Lakes Solutions, a Chemtura business TECHNOLOGY, ADVOCACY AND MARKETING, GREAT LAKES SOLUTIONS, A CHEMTURA BUSINESS  
60771 OVERSIGHT OF EPA AUTHORITIES AND ACTIONS TO CONTROL EXPOSURES TO TOXIC CHEMICALS CHRG-112shrg25110 Tony Stefani Founder, President San Francisco Firefighters Cancer Prevention Foundation SAN FRANCISCO FIREFIGHTERS CANCER PREVENTION FOUNDATION  
60770 OVERSIGHT OF EPA AUTHORITIES AND ACTIONS TO CONTROL EXPOSURES TO TOXIC CHEMICALS CHRG-112shrg25110 William K. Rawson   Partner and Chair of the Environment, Land and Resources Department in Washington, DC, Latham & Watkins PARTNER AND CHAIR OF THE ENVIRONMENT, LAND AND RESOURCES DEPARTMENT IN WASHINGTON, DC, LATHAM & WATKINS  

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;