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

13 rows where package_id = "CHRG-106shrg71527" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, location

id package_id name ▼ title organization organization_normalized location
7306 CLEAN AIR ACT: STATE REAUTHORIZATION ISSUES CHRG-106shrg71527 Dennis Hemmer director Wyoming Department of Environmental Quality WYOMING DEPARTMENT OF ENVIRONMENTAL QUALITY  
7307 CLEAN AIR ACT: STATE REAUTHORIZATION ISSUES CHRG-106shrg71527 Hon. Richard P. Homrighausen   mayor MAYOR city of Dover, OH
7315 CLEAN AIR ACT: STATE REAUTHORIZATION ISSUES CHRG-106shrg71527 Hon. Shawn Mitchell   State Representative STATE REPRESENTATIVE Broomfield, CO
7309 CLEAN AIR ACT: STATE REAUTHORIZATION ISSUES CHRG-106shrg71527 Jeff Saitas Executive Director Texas Natural Resources Conservation Commission TEXAS NATURAL RESOURCES CONSERVATION COMMISSION  
7317 CLEAN AIR ACT: STATE REAUTHORIZATION ISSUES CHRG-106shrg71527 Jim Thomas director Technical Analysis Division, Texas Natural Resources Conservation Commission TECHNICAL ANALYSIS DIVISION, TEXAS NATURAL RESOURCES CONSERVATION COMMISSION Austin, TX
7316 CLEAN AIR ACT: STATE REAUTHORIZATION ISSUES CHRG-106shrg71527 John S. Seitz director Office of Air Quality Planning and Standards, Research Triangle Park, North Carolina OFFICE OF AIR QUALITY PLANNING AND STANDARDS, RESEARCH TRIANGLE PARK, NORTH CAROLINA  
7312 CLEAN AIR ACT: STATE REAUTHORIZATION ISSUES CHRG-106shrg71527 John Terrill Director Air Quality Division, Oklahoma Department of Environmental Quality AIR QUALITY DIVISION, OKLAHOMA DEPARTMENT OF ENVIRONMENTAL QUALITY  
7310 CLEAN AIR ACT: STATE REAUTHORIZATION ISSUES CHRG-106shrg71527 Karen A. Studders Commissioner Minnesota Pollution Control Agency MINNESOTA POLLUTION CONTROL AGENCY  
7305 CLEAN AIR ACT: STATE REAUTHORIZATION ISSUES CHRG-106shrg71527 Kenneth Colburn director, New Hampshire Department of Environmental Services Air Resources Division AIR RESOURCES DIVISION  
7313 CLEAN AIR ACT: STATE REAUTHORIZATION ISSUES CHRG-106shrg71527 Marcia Willhite Assistant Chief of Environmental Health Lincoln-Lancaster County Department of Health     Lincoln, NE
7314 CLEAN AIR ACT: STATE REAUTHORIZATION ISSUES CHRG-106shrg71527 Mark S. Coleman director Oklahoma Department of Environmental Quality OKLAHOMA DEPARTMENT OF ENVIRONMENTAL QUALITY Oklahoma City, OK
7308 CLEAN AIR ACT: STATE REAUTHORIZATION ISSUES CHRG-106shrg71527 Ronald Methier Chief Air Protection Branch, Georgia Environmental Protection Division AIR PROTECTION BRANCH, GEORGIA ENVIRONMENTAL PROTECTION DIVISION  
7311 CLEAN AIR ACT: STATE REAUTHORIZATION ISSUES CHRG-106shrg71527 Zach Taylor Executive Director Association of Central Oklahoma Governments ASSOCIATION OF CENTRAL OKLAHOMA GOVERNMENTS Oklahoma City, OK

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;