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

12 rows where package_id = "CHRG-106shrg71529" 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
7334 COMPARATIVE RISK ASSESSMENT: SCIENCE ADVISORY BOARD'S RESIDUAL RISK REPORT CHRG-106shrg71529 Al McGartland Director National Center for Environmental Economics, Office of Policy, Economics, and Innovations, Environmental Protection Agency NATIONAL CENTER FOR ENVIRONMENTAL ECONOMICS, OFFICE OF POLICY, ECONOMICS, AND INNOVATIONS, ENVIRONMENTAL PROTECTION AGENCY  
7333 COMPARATIVE RISK ASSESSMENT: SCIENCE ADVISORY BOARD'S RESIDUAL RISK REPORT CHRG-106shrg71529 EPA...............................................132 Letters        
7325 COMPARATIVE RISK ASSESSMENT: SCIENCE ADVISORY BOARD'S RESIDUAL RISK REPORT CHRG-106shrg71529 Elizabeth L. Anderson President and CEO Sciences International, Inc SCIENCES INTERNATIONAL, INC  
7336 COMPARATIVE RISK ASSESSMENT: SCIENCE ADVISORY BOARD'S RESIDUAL RISK REPORT CHRG-106shrg71529 Felice Stadler National Policy Coordinator Clean the Rain Campaign, National Wildlife Federation CLEAN THE RAIN CAMPAIGN, NATIONAL WILDLIFE FEDERATION  
7327 COMPARATIVE RISK ASSESSMENT: SCIENCE ADVISORY BOARD'S RESIDUAL RISK REPORT CHRG-106shrg71529 J. Clarence Davies Senior Fellow Center for Risk Management, Resources for the Future CENTER FOR RISK MANAGEMENT, RESOURCES FOR THE FUTURE  
7329 COMPARATIVE RISK ASSESSMENT: SCIENCE ADVISORY BOARD'S RESIDUAL RISK REPORT CHRG-106shrg71529 Katherine Hartnett executive director New Hampshire Comparative Risk Project NEW HAMPSHIRE COMPARATIVE RISK PROJECT  
7331 COMPARATIVE RISK ASSESSMENT: SCIENCE ADVISORY BOARD'S RESIDUAL RISK REPORT CHRG-106shrg71529 Lee Hughes Vice President of Corporate Environmental Control Bayer Corporation BAYER CORPORATION  
7335 COMPARATIVE RISK ASSESSMENT: SCIENCE ADVISORY BOARD'S RESIDUAL RISK REPORT CHRG-106shrg71529 Michael J. Pompili Assistant Health Commissioner Columbus Health Department COLUMBUS HEALTH DEPARTMENT Columbus, OH
7332 COMPARATIVE RISK ASSESSMENT: SCIENCE ADVISORY BOARD'S RESIDUAL RISK REPORT CHRG-106shrg71529 Morton Lippman Professor New York University, chair, Science Advisory Board NEW YORK UNIVERSITY, CHAIR, SCIENCE ADVISORY BOARD  
7328 COMPARATIVE RISK ASSESSMENT: SCIENCE ADVISORY BOARD'S RESIDUAL RISK REPORT CHRG-106shrg71529 Peter Guerrero Director Environmental Protection Issues, General Accounting Office ENVIRONMENTAL PROTECTION ISSUES, GENERAL ACCOUNTING OFFICE  
7330 COMPARATIVE RISK ASSESSMENT: SCIENCE ADVISORY BOARD'S RESIDUAL RISK REPORT CHRG-106shrg71529 Philip Hopke   Chair, Residual Risk Subcommittee, Science Advisory Board CHAIR, RESIDUAL RISK SUBCOMMITTEE, SCIENCE ADVISORY BOARD  
7326 COMPARATIVE RISK ASSESSMENT: SCIENCE ADVISORY BOARD'S RESIDUAL RISK REPORT CHRG-106shrg71529 Robert Brenner Principal Deputy Assistant Administrator for Air and Radiation Environmental Protection Agency 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;