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

8 rows where package_id = "CHRG-111hhrg62679" 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
48152 LEGISLATIVE PROPOSALS TO ADDRESS CONCERNS OVER THE SEC'S NEW CONFIDENTIALITY PROVISION CHRG-111hhrg62679 Angela Canterbury Director of Public Policy Project On Government Oversight PROJECT ON GOVERNMENT OVERSIGHT  
48153 LEGISLATIVE PROPOSALS TO ADDRESS CONCERNS OVER THE SEC'S NEW CONFIDENTIALITY PROVISION CHRG-111hhrg62679 Hon. Darrell E. Issa   a Representative in Congress from the State of California A REPRESENTATIVE IN CONGRESS FROM THE STATE OF CALIFORNIA  
48158 LEGISLATIVE PROPOSALS TO ADDRESS CONCERNS OVER THE SEC'S NEW CONFIDENTIALITY PROVISION CHRG-111hhrg62679 Hon. Edolphus Towns   a Representative in Congress from the State of New York A REPRESENTATIVE IN CONGRESS FROM THE STATE OF NEW YORK  
48156 LEGISLATIVE PROPOSALS TO ADDRESS CONCERNS OVER THE SEC'S NEW CONFIDENTIALITY PROVISION CHRG-111hhrg62679 Hon. Harvey L. Pitt Chief Executive Officer Kalorama Partners, LLC KALORAMA PARTNERS, LLC  
48157 LEGISLATIVE PROPOSALS TO ADDRESS CONCERNS OVER THE SEC'S NEW CONFIDENTIALITY PROVISION CHRG-111hhrg62679 Hon. Mary L. Schapiro Chairman U.S. Securities and Exchange Commission U.S. SECURITIES AND EXCHANGE COMMISSION  
48151 LEGISLATIVE PROPOSALS TO ADDRESS CONCERNS OVER THE SEC'S NEW CONFIDENTIALITY PROVISION CHRG-111hhrg62679 Rick Blum Coordinator Sunshine in Government Initiative SUNSHINE IN GOVERNMENT INITIATIVE  
48155 LEGISLATIVE PROPOSALS TO ADDRESS CONCERNS OVER THE SEC'S NEW CONFIDENTIALITY PROVISION CHRG-111hhrg62679 Steven G. Mintz   Founding Partner, Mintz & Gold LLP FOUNDING PARTNER, MINTZ & GOLD LLP  
48154 LEGISLATIVE PROPOSALS TO ADDRESS CONCERNS OVER THE SEC'S NEW CONFIDENTIALITY PROVISION CHRG-111hhrg62679 Susan L. Merrill   Partner, Bingham McCutchen LLP, on behalf of the Securities Industry and Financial Markets Association (SIFMA) PARTNER, BINGHAM MCCUTCHEN LLP, ON BEHALF OF THE SECURITIES INDUSTRY AND FINANCIAL MARKETS ASSOCIATION (SIFMA)  

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;