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

9 rows where package_id = "CHRG-110shrg50420" 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
40579 EXAMINING THE STATE OF THE DOMESTIC AUTOMOBILE INDUSTRY CHRG-110shrg50420 Alan R. Mulally President and Chief Executive Officer Ford Motor Company FORD MOTOR COMPANY  
40584 EXAMINING THE STATE OF THE DOMESTIC AUTOMOBILE INDUSTRY CHRG-110shrg50420 Allan I. Mendelowitz Member of the Board of Directors Federal Housing Finance Board Prepared statement FEDERAL HOUSING FINANCE BOARD PREPARED STATEMENT  
40577 EXAMINING THE STATE OF THE DOMESTIC AUTOMOBILE INDUSTRY CHRG-110shrg50420 G. Richard Wagoner Jr., Chairman and Chief Executive Officer General Motors GENERAL MOTORS  
40576 EXAMINING THE STATE OF THE DOMESTIC AUTOMOBILE INDUSTRY CHRG-110shrg50420 Gene L. Dodaro Acting Comptroller General of the United States Government Accountability Office GOVERNMENT ACCOUNTABILITY OFFICE  
40581 EXAMINING THE STATE OF THE DOMESTIC AUTOMOBILE INDUSTRY CHRG-110shrg50420 James T. Fleming President Connecticut Automotive Retailers Association CONNECTICUT AUTOMOTIVE RETAILERS ASSOCIATION  
40582 EXAMINING THE STATE OF THE DOMESTIC AUTOMOBILE INDUSTRY CHRG-110shrg50420 Keith Wandell President Johnson Controls, Inc JOHNSON CONTROLS, INC  
40583 EXAMINING THE STATE OF THE DOMESTIC AUTOMOBILE INDUSTRY CHRG-110shrg50420 Mark Zandi Chief Economist and Co-Founder Moody's Economy.com MOODY'S ECONOMY.COM  
40580 EXAMINING THE STATE OF THE DOMESTIC AUTOMOBILE INDUSTRY CHRG-110shrg50420 Robert Nardelli Chairman and Chief Executive Officer Chrysler LLC CHRYSLER LLC  
40578 EXAMINING THE STATE OF THE DOMESTIC AUTOMOBILE INDUSTRY CHRG-110shrg50420 Ron Gettelfinger President International Union, United Automobile, Aerospace, and Agricultural Implement Workers of America INTERNATIONAL UNION, UNITED AUTOMOBILE, AEROSPACE, AND AGRICULTURAL IMPLEMENT WORKERS OF AMERICA  

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;