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

17 rows where package_id = "CHRG-108shrg26057" 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
19379 REGULATION NMS AND DEVELOPMENTS IN MARKET STRUCTURES CHRG-108shrg26057 Bernard Madoff Chairman and CEO Bernard L. Madoff Investment Securities BERNARD L. MADOFF INVESTMENT SECURITIES  
19385 REGULATION NMS AND DEVELOPMENTS IN MARKET STRUCTURES CHRG-108shrg26057 Charles Leven Vice President, Board of Directors Board Governance and Chair, AARP BOARD GOVERNANCE AND CHAIR, AARP  
19382 REGULATION NMS AND DEVELOPMENTS IN MARKET STRUCTURES CHRG-108shrg26057 Davi M. D'Agostino Director Financial Markets and Community Investment, U.S. General Accountibility Office FINANCIAL MARKETS AND COMMUNITY INVESTMENT, U.S. GENERAL ACCOUNTIBILITY OFFICE  
19375 REGULATION NMS AND DEVELOPMENTS IN MARKET STRUCTURES CHRG-108shrg26057 David Colker CEO and President the National Stock Exchange THE NATIONAL STOCK EXCHANGE  
19371 REGULATION NMS AND DEVELOPMENTS IN MARKET STRUCTURES CHRG-108shrg26057 David F. Harris Senior Vice President Strategic Planning, American Stock Exchange, LLC STRATEGIC PLANNING, AMERICAN STOCK EXCHANGE, LLC  
19372 REGULATION NMS AND DEVELOPMENTS IN MARKET STRUCTURES CHRG-108shrg26057 Edward J. Nicoll CEO Instinet Group Incorporated INSTINET GROUP INCORPORATED  
19373 REGULATION NMS AND DEVELOPMENTS IN MARKET STRUCTURES CHRG-108shrg26057 Gerald D. Putnam Chairman and Chief Executive Officer Archipelago Holdings, LLC ARCHIPELAGO HOLDINGS, LLC  
19374 REGULATION NMS AND DEVELOPMENTS IN MARKET STRUCTURES CHRG-108shrg26057 John A. Thain Chief Executive Officer New York Stock Exchange, Inc NEW YORK STOCK EXCHANGE, INC  
19384 REGULATION NMS AND DEVELOPMENTS IN MARKET STRUCTURES CHRG-108shrg26057 John C. Giesea President and CEO Security Traders Association SECURITY TRADERS ASSOCIATION  
19376 REGULATION NMS AND DEVELOPMENTS IN MARKET STRUCTURES CHRG-108shrg26057 Kevin Cronin Senior Vice President and Director of Equity Trading AIM Investments AIM INVESTMENTS  
19381 REGULATION NMS AND DEVELOPMENTS IN MARKET STRUCTURES CHRG-108shrg26057 Kim Bang President and Chief Executive Officer Bloomberg Tradebook, LLC BLOOMBERG TRADEBOOK, LLC  
19378 REGULATION NMS AND DEVELOPMENTS IN MARKET STRUCTURES CHRG-108shrg26057 Phylis M. Esposito Executive Vice President and Chief Strategy Officer Ameritrade Holding Corporation AMERITRADE HOLDING CORPORATION  
19383 REGULATION NMS AND DEVELOPMENTS IN MARKET STRUCTURES CHRG-108shrg26057 Robert B. Fagenson Vice Chairman Van der Moolen Specialists VAN DER MOOLEN SPECIALISTS  
19370 REGULATION NMS AND DEVELOPMENTS IN MARKET STRUCTURES CHRG-108shrg26057 Robert Greifeld CEO and President the Nasdaq Stock Market, Inc THE NASDAQ STOCK MARKET, INC  
19380 REGULATION NMS AND DEVELOPMENTS IN MARKET STRUCTURES CHRG-108shrg26057 Robert H. McCooey Jr., President and Chief Executive Officer the Griswold Company, Incorporated THE GRISWOLD COMPANY, INCORPORATED  
19377 REGULATION NMS AND DEVELOPMENTS IN MARKET STRUCTURES CHRG-108shrg26057 Scott DeSano Head of Equity Trading Desk Fidelity Investments FIDELITY INVESTMENTS  
19369 REGULATION NMS AND DEVELOPMENTS IN MARKET STRUCTURES CHRG-108shrg26057 William H. Donaldson Chairman U.S. Securities and Exchange Commission U.S. SECURITIES AND EXCHANGE COMMISSION  

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;