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-110hhrg61959" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

id package_id name ▼ title organization organization_normalized location
37794 THE GREEN ROAD TO ECONOMIC RECOVERY CHRG-110hhrg61959 Byron Kennard Executive Director The Center for Small Business and the Environment THE CENTER FOR SMALL BUSINESS AND THE ENVIRONMENT  
37793 THE GREEN ROAD TO ECONOMIC RECOVERY CHRG-110hhrg61959 Fred Redmond International Vice President United Steelworkers UNITED STEELWORKERS  
37795 THE GREEN ROAD TO ECONOMIC RECOVERY CHRG-110hhrg61959 Margo Thorning Ph.D., Senior Vice President and Chief Economist American Council for Capital Formation AMERICAN COUNCIL FOR CAPITAL FORMATION  
37791 THE GREEN ROAD TO ECONOMIC RECOVERY CHRG-110hhrg61959 Mr. Bracken Hendricks Senior Fellow Center for American Progress CENTER FOR AMERICAN PROGRESS  
37792 THE GREEN ROAD TO ECONOMIC RECOVERY CHRG-110hhrg61959 Robert Pollin Ph.D., Professor of Economics and Co-Director Political Economy Research Institute, University of Massachusetts Amherst POLITICAL ECONOMY RESEARCH INSTITUTE, UNIVERSITY OF MASSACHUSETTS AMHERST  
37796 THE GREEN ROAD TO ECONOMIC RECOVERY CHRG-110hhrg61959 Submitted for the Record: Analysis of the Lieberman-Warner Climate Security Act (S. 2191) Using The National Energy Modeling System (NEMS/ACCF/NAM)   a report by the American Council for Capital Formation and the National Association of Manufacturers and analysis conducted by Science Applications International Corporation (SAIC) A REPORT BY THE AMERICAN COUNCIL FOR CAPITAL FORMATION AND THE NATIONAL ASSOCIATION OF MANUFACTURERS AND ANALYSIS CONDUCTED BY SCIENCE APPLICATIONS INTERNATIONAL CORPORATION (SAIC)  

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;