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

4 rows where package_id = "CHRG-112shrg78022" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

id package_id name ▼ title organization organization_normalized location
62711 ENVIRONMENTAL RISKS OF GENETICALLY ENGINEERED FISH CHRG-112shrg78022 Dr. Ron L. Stotish President and Ceo Aquabounty Technologies, Inc AQUABOUNTY TECHNOLOGIES, INC  
62713 ENVIRONMENTAL RISKS OF GENETICALLY ENGINEERED FISH CHRG-112shrg78022 George H. Leonard Ph.D., Aquaculture Program Director Ocean Conservancy OCEAN CONSERVANCY  
62712 ENVIRONMENTAL RISKS OF GENETICALLY ENGINEERED FISH CHRG-112shrg78022 John Epifanio Ph.D. Fish Conservation Geneticist, Illinois Natural History Survey and University of Illinois FISH CONSERVATION GENETICIST, ILLINOIS NATURAL HISTORY SURVEY AND UNIVERSITY OF ILLINOIS  
62714 ENVIRONMENTAL RISKS OF GENETICALLY ENGINEERED FISH CHRG-112shrg78022 Paul Greenberg   Author of ``Four Fish: The Future of the Last Wild Food'' AUTHOR OF ``FOUR FISH: THE FUTURE OF THE LAST WILD FOOD''  

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;