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-110hhrg34633" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title

id package_id name ▼ title organization organization_normalized location
29673 HAVE OSHA STANDARDS KEPT UP WITH WORKPLACE HAZARDS? CHRG-110hhrg34633 '' published in the International Journal of Occupational Health Negligence   dated Jan.-Mar. 2007 DATED JAN.-MAR. 2007  
29669 HAVE OSHA STANDARDS KEPT UP WITH WORKPLACE HAZARDS? CHRG-110hhrg34633 Baruch Fellner   attorney, Gibson, Dunn & Crutcher ATTORNEY, GIBSON, DUNN & CRUTCHER  
29672 HAVE OSHA STANDARDS KEPT UP WITH WORKPLACE HAZARDS? CHRG-110hhrg34633 Eric Peoples former employee of Glister-Mary Lee popcorn factory      
29671 HAVE OSHA STANDARDS KEPT UP WITH WORKPLACE HAZARDS? CHRG-110hhrg34633 Frank Mirer professor of environmental and occupational health sciences Hunter School of Urban Public Health HUNTER SCHOOL OF URBAN PUBLIC HEALTH  
29670 HAVE OSHA STANDARDS KEPT UP WITH WORKPLACE HAZARDS? CHRG-110hhrg34633 Hon. Edwin Foulke Assistant Secretary of Labor Occupational Safety and Health Administration OCCUPATIONAL SAFETY AND HEALTH ADMINISTRATION  
29674 HAVE OSHA STANDARDS KEPT UP WITH WORKPLACE HAZARDS? CHRG-110hhrg34633 Scott Schneider director of occupational safety and health Laborers' Health and Safety Fund of North America LABORERS' HEALTH AND SAFETY FUND OF NORTH 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;