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

5 rows where package_id = "CHRG-112shrg25113" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

id package_id name ▼ title organization organization_normalized location
60783 WATER RESOURCES DEVELOPMENT ACT: GROWING THE ECONOMY AND PROTECTING PUBLIC SAFETY CHRG-112shrg25113 Andrew Herrmann P.E., President American Society of Civil Engineers AMERICAN SOCIETY OF CIVIL ENGINEERS  
60787 WATER RESOURCES DEVELOPMENT ACT: GROWING THE ECONOMY AND PROTECTING PUBLIC SAFETY CHRG-112shrg25113 Janet Kavinoky Executive Director, and Vice President Transportation and Infrastructure, Americans for Transportation Mobility Coalition, U.S. Chamber of Commerce TRANSPORTATION AND INFRASTRUCTURE, AMERICANS FOR TRANSPORTATION MOBILITY COALITION, U.S. CHAMBER OF COMMERCE  
60786 WATER RESOURCES DEVELOPMENT ACT: GROWING THE ECONOMY AND PROTECTING PUBLIC SAFETY CHRG-112shrg25113 Jeffrey Soth Assistant Director Legislative and Political Department, International Union of Operating Engineers LEGISLATIVE AND POLITICAL DEPARTMENT, INTERNATIONAL UNION OF OPERATING ENGINEERS  
60784 WATER RESOURCES DEVELOPMENT ACT: GROWING THE ECONOMY AND PROTECTING PUBLIC SAFETY CHRG-112shrg25113 Jerry A. Bridges Chairman of the Board, and Executive Director American Association of Port Authorities, Virginia Port Authority AMERICAN ASSOCIATION OF PORT AUTHORITIES, VIRGINIA PORT AUTHORITY  
60785 WATER RESOURCES DEVELOPMENT ACT: GROWING THE ECONOMY AND PROTECTING PUBLIC SAFETY CHRG-112shrg25113 Rick Calhoun President Cargo Carriers, Cargill, Incorporated CARGO CARRIERS, CARGILL, INCORPORATED  

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;