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

15 rows where package_id = "CHRG-112hhrg65734" 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 organization_entity_id organization_government_unit_id match_method match_confidence
53678 H.R. CHRG-112hhrg65734 Answers to submitted questions \1\........................... Greg Abbott   Attorney General, State of Texas ATTORNEY GENERAL, STATE OF TEXAS          
53684 H.R. CHRG-112hhrg65734 Betsey Blaisdell Senior Manager of Environmental Stewardship The Timberland Company THE TIMBERLAND COMPANY   2278228   normalized_name 0.7
53688 H.R. CHRG-112hhrg65734 Fred T. Harnack General Manager Environmental Affairs, U.S. Steel Corporation ENVIRONMENTAL AFFAIRS, U.S. STEEL CORPORATION          
53679 H.R. CHRG-112hhrg65734 Harry C. Alford President and CEO National Black Chamber of Commerce NATIONAL BLACK CHAMBER OF COMMERCE          
53676 H.R. CHRG-112hhrg65734 James Inhofe   U.S. Senator, State of Oklahoma U.S. SENATOR, STATE OF OKLAHOMA          
53689 H.R. CHRG-112hhrg65734 James N. Goldstene Executive Officer California Air Resources Board CALIFORNIA AIR RESOURCES BOARD          
53681 H.R. CHRG-112hhrg65734 James Pearce Director of Manufacturing FMC Corporation FMC CORPORATION   166   normalized_name 0.7
53677 H.R. CHRG-112hhrg65734 Lisa Jackson Administrator Environmental Protection Agency ENVIRONMENTAL PROTECTION AGENCY          
53683 H.R. CHRG-112hhrg65734 Lonnie N. Carter President and CEO, Santee Cooper              
53690 H.R. CHRG-112hhrg65734 Lynn R. Goldman   American Public Health Association AMERICAN PUBLIC HEALTH ASSOCIATION   84401   normalized_name 0.7
53686 H.R. CHRG-112hhrg65734 Margo Thorning Senior Vice President and Chief Economist American Council for Capital Investment AMERICAN COUNCIL FOR CAPITAL INVESTMENT          
53685 H.R. CHRG-112hhrg65734 Peter S. Glaser President Troutman Sanders LLP TROUTMAN SANDERS LLP          
53687 H.R. CHRG-112hhrg65734 Philip Nelson President Illinois Farm Bureau ILLINOIS FARM BUREAU          
53682 H.R. CHRG-112hhrg65734 Steve Cousins Vice President Lions Oil Company LIONS OIL COMPANY          
53680 H.R. CHRG-112hhrg65734 Steve Rowlan General Manager Environmental Affairs, Nucor Corporation ENVIRONMENTAL AFFAIRS, NUCOR CORPORATION          

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
, organization_entity_id INTEGER, organization_government_unit_id INTEGER, match_method TEXT, match_confidence REAL);
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;