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

7 rows where package_id = "CHRG-111shrg65272" 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
52353 EXAMINING THE EFFICIENCY, STABILITY, AND INTEGRITY OF THE U.S. CAPITAL MARKETS CHRG-111shrg65272 Gary Gensler Chairman Commodity Futures Trading Commission COMMODITY FUTURES TRADING COMMISSION  
52354 EXAMINING THE EFFICIENCY, STABILITY, AND INTEGRITY OF THE U.S. CAPITAL MARKETS CHRG-111shrg65272 James J. Angel Associate Professor of Finance McDonough School of Business, Georgetown University MCDONOUGH SCHOOL OF BUSINESS, GEORGETOWN UNIVERSITY  
52357 EXAMINING THE EFFICIENCY, STABILITY, AND INTEGRITY OF THE U.S. CAPITAL MARKETS CHRG-111shrg65272 Kevin Cronin Global Head of Equity Trading Invesco Limited INVESCO LIMITED  
52356 EXAMINING THE EFFICIENCY, STABILITY, AND INTEGRITY OF THE U.S. CAPITAL MARKETS CHRG-111shrg65272 Manoj Narang Chief Executive Officer Tradeworx, Inc TRADEWORX, INC  
52352 EXAMINING THE EFFICIENCY, STABILITY, AND INTEGRITY OF THE U.S. CAPITAL MARKETS CHRG-111shrg65272 Mary L. Schapiro Chairman Securities and Exchange Commission SECURITIES AND EXCHANGE COMMISSION  
52358 EXAMINING THE EFFICIENCY, STABILITY, AND INTEGRITY OF THE U.S. CAPITAL MARKETS CHRG-111shrg65272 Steve Luparello Vice Chairman Financial Industry Regulatory Authority FINANCIAL INDUSTRY REGULATORY AUTHORITY  
52355 EXAMINING THE EFFICIENCY, STABILITY, AND INTEGRITY OF THE U.S. CAPITAL MARKETS CHRG-111shrg65272 Thomas Peterffy Chairman and Chief Executive Officer Interactive Brokers Group INTERACTIVE BROKERS GROUP  

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;