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-113shrg98185" 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
72252 EXAMINING THE STRATEGY FOR ACHIEVING THE GOALS OF THE NEW VOLUNTARY CHESAPEAKE BAY WATERSHED AGREEMENT CHRG-113shrg98185 Hon. Mary Ann Lisanti Councilmember Harford County Council HARFORD COUNTY COUNCIL  
72251 EXAMINING THE STRATEGY FOR ACHIEVING THE GOALS OF THE NEW VOLUNTARY CHESAPEAKE BAY WATERSHED AGREEMENT CHRG-113shrg98185 Hon. Ronald Miller   Representative, Pennsylvania House of Representatives REPRESENTATIVE, PENNSYLVANIA HOUSE OF REPRESENTATIVES  
72253 EXAMINING THE STRATEGY FOR ACHIEVING THE GOALS OF THE NEW VOLUNTARY CHESAPEAKE BAY WATERSHED AGREEMENT CHRG-113shrg98185 Hon. Steve Hershey   Senator, Maryland Senate SENATOR, MARYLAND SENATE  
72248 EXAMINING THE STRATEGY FOR ACHIEVING THE GOALS OF THE NEW VOLUNTARY CHESAPEAKE BAY WATERSHED AGREEMENT CHRG-113shrg98185 Nick Dipasquale Director Chesapeake Bay Program, Environmental Protection Agency CHESAPEAKE BAY PROGRAM, ENVIRONMENTAL PROTECTION AGENCY  
72249 EXAMINING THE STRATEGY FOR ACHIEVING THE GOALS OF THE NEW VOLUNTARY CHESAPEAKE BAY WATERSHED AGREEMENT CHRG-113shrg98185 Robertson Peyton Director NOAA Chesapeake Bay Office NOAA CHESAPEAKE BAY OFFICE  
72250 EXAMINING THE STRATEGY FOR ACHIEVING THE GOALS OF THE NEW VOLUNTARY CHESAPEAKE BAY WATERSHED AGREEMENT CHRG-113shrg98185 Ward Hon. Molly Secretary of Natural Resources State of Virginia STATE OF VIRGINIA  

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;