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-114shrg22170" 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
78736 OVERSIGHT OF THE IMPACT OF EPA AND FWS REGULATIONSON CITIZENS PRIVATE PROPERTY CHRG-114shrg22170 Chuck Clayton President Prairie Pothole Consulting on behalf of the Izaak Walton League of America PRAIRIE POTHOLE CONSULTING ON BEHALF OF THE IZAAK WALTON LEAGUE OF AMERICA  
78737 OVERSIGHT OF THE IMPACT OF EPA AND FWS REGULATIONSON CITIZENS PRIVATE PROPERTY CHRG-114shrg22170 Denise Parker   Volunteer, Humane Society of the United States VOLUNTEER, HUMANE SOCIETY OF THE UNITED STATES  
78739 OVERSIGHT OF THE IMPACT OF EPA AND FWS REGULATIONSON CITIZENS PRIVATE PROPERTY CHRG-114shrg22170 Jeff Lage President South Dakota Home Builders Association SOUTH DAKOTA HOME BUILDERS ASSOCIATION  
78738 OVERSIGHT OF THE IMPACT OF EPA AND FWS REGULATIONSON CITIZENS PRIVATE PROPERTY CHRG-114shrg22170 Larry Rhoden Rancher and former State Senator      
78740 OVERSIGHT OF THE IMPACT OF EPA AND FWS REGULATIONSON CITIZENS PRIVATE PROPERTY CHRG-114shrg22170 Myron Williams   South Dakota Cattlemen's Association SOUTH DAKOTA CATTLEMEN'S ASSOCIATION  
78735 OVERSIGHT OF THE IMPACT OF EPA AND FWS REGULATIONSON CITIZENS PRIVATE PROPERTY CHRG-114shrg22170 Noreen Walsh Regional Director, Fish and Wildlife Service Mountain-Prairie Region MOUNTAIN-PRAIRIE REGION  
78734 OVERSIGHT OF THE IMPACT OF EPA AND FWS REGULATIONSON CITIZENS PRIVATE PROPERTY CHRG-114shrg22170 Shaun McGrath Region 8 Administrator U.S. Environmental Protection Agency U.S. ENVIRONMENTAL PROTECTION AGENCY  

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;