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-110jhrg42773" 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
38044 WAR AT ANY COST? THE TOTAL ECONOMIC COSTS OF THE WAR BEYOND THE FEDERAL BUDGET CHRG-110jhrg42773 Statement of Dr. Rand Beers President National Security Network NATIONAL SECURITY NETWORK Washington, DC
38045 WAR AT ANY COST? THE TOTAL ECONOMIC COSTS OF THE WAR BEYOND THE FEDERAL BUDGET CHRG-110jhrg42773 Statement of Dr. Scott Wallsten Vice President for Research and Senior Fellow iGrowthGlobal IGROWTHGLOBAL Washington, DC
38042 WAR AT ANY COST? THE TOTAL ECONOMIC COSTS OF THE WAR BEYOND THE FEDERAL BUDGET CHRG-110jhrg42773 Statement of the Honorable Joseph E. Stiglitz Nobel Laureate; Professor Columbia University COLUMBIA UNIVERSITY New York, NY
38043 WAR AT ANY COST? THE TOTAL ECONOMIC COSTS OF THE WAR BEYOND THE FEDERAL BUDGET CHRG-110jhrg42773 Statement of the Honorable Robert Hormats Vice Chairman Goldman Sachs (International) GOLDMAN SACHS (INTERNATIONAL) New York, NY

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;