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

4 rows where package_id = "CHRG-111jhrg50107" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location

id package_id name ▼ title organization organization_normalized location
49447 RESTORING THE ECONOMY: STRATEGIES FOR SHORT-TERM AND LONG-TERM CHANGE CHRG-111jhrg50107 Dr. Adam S. Posen Deputy Director Peterson Institute for International Economics PETERSON INSTITUTE FOR INTERNATIONAL ECONOMICS Washington, DC
49448 RESTORING THE ECONOMY: STRATEGIES FOR SHORT-TERM AND LONG-TERM CHANGE CHRG-111jhrg50107 Dr. Joseph Mason Louisiana Bankers Association Endowed Professor of Finance, Louisiana State University and Senior Fellow The Wharton School THE WHARTON SCHOOL Berwyn, PA
49445 RESTORING THE ECONOMY: STRATEGIES FOR SHORT-TERM AND LONG-TERM CHANGE CHRG-111jhrg50107 Hon. Paul A. Volcker Chairman, President's Economic Advisory Board and Former Chairman of the Federal Reserve Board of Governors, New York, New York BOARD OF GOVERNORS, NEW YORK, NEW YORK  
49446 RESTORING THE ECONOMY: STRATEGIES FOR SHORT-TERM AND LONG-TERM CHANGE CHRG-111jhrg50107 Hon. Roger C. Altman Chairman and CEO Evercore Partners, Inc., New York, New York EVERCORE PARTNERS, INC., NEW YORK, NEW YORK  

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;