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

9 rows where package_id = "CHRG-112hhrg79693" 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
59876 CHALLENGES FACING THE U.S. CAPITAL MARKETS TO EFFECTIVELY IMPLEMENT TITLE VII OF THE DODD-FRANK ACT CHRG-112hhrg79693 Eric DeGesero Executive Vice President Fuel Merchants Association of New Jersey, on behalf of the Petroleum Marketers Association of America (PMAA), the New England Fuel Institute (NEFI), and the Fuel Merchants Association of New Jersey (FMA) FUEL MERCHANTS ASSOCIATION OF NEW JERSEY, ON BEHALF OF THE PETROLEUM MARKETERS ASSOCIATION OF AMERICA (PMAA), THE NEW ENGLAND FUEL INSTITUTE (NEFI), AND THE FUEL MERCHANTS ASSOCIATION OF NEW JERSEY (FMA)  
59878 CHALLENGES FACING THE U.S. CAPITAL MARKETS TO EFFECTIVELY IMPLEMENT TITLE VII OF THE DODD-FRANK ACT CHRG-112hhrg79693 Hon. Gary Gensler Chairman Commodity Futures Trading Commission (CFTC) COMMODITY FUTURES TRADING COMMISSION (CFTC)  
59879 CHALLENGES FACING THE U.S. CAPITAL MARKETS TO EFFECTIVELY IMPLEMENT TITLE VII OF THE DODD-FRANK ACT CHRG-112hhrg79693 J. Christopher Giancarlo Executive Vice President, GFI Group Inc.; and Chairman Wholesale Markets Brokers Association, Americas (WMBAA), on behalf of WMBAA WHOLESALE MARKETS BROKERS ASSOCIATION, AMERICAS (WMBAA), ON BEHALF OF WMBAA  
59880 CHALLENGES FACING THE U.S. CAPITAL MARKETS TO EFFECTIVELY IMPLEMENT TITLE VII OF THE DODD-FRANK ACT CHRG-112hhrg79693 John E. Parsons Senior Lecturer, and Executive Director Finance Group, Sloan School of Management, Massachusetts Institute of Technology (MIT), MIT's Center for Energy and Environmental Policy Research FINANCE GROUP, SLOAN SCHOOL OF MANAGEMENT, MASSACHUSETTS INSTITUTE OF TECHNOLOGY (MIT), MIT'S CENTER FOR ENERGY AND ENVIRONMENTAL POLICY RESEARCH  
59872 CHALLENGES FACING THE U.S. CAPITAL MARKETS TO EFFECTIVELY IMPLEMENT TITLE VII OF THE DODD-FRANK ACT CHRG-112hhrg79693 Keith Bailey Managing Director Markets Division, Barclays, on behalf of the Institute of International Bankers (IIB) MARKETS DIVISION, BARCLAYS, ON BEHALF OF THE INSTITUTE OF INTERNATIONAL BANKERS (IIB)  
59873 CHALLENGES FACING THE U.S. CAPITAL MARKETS TO EFFECTIVELY IMPLEMENT TITLE VII OF THE DODD-FRANK ACT CHRG-112hhrg79693 Michael D. Bopp   Gibson, Dunn & Crutcher, LLP, on behalf of the Coalition for Derivatives End-Users GIBSON, DUNN & CRUTCHER, LLP, ON BEHALF OF THE COALITION FOR DERIVATIVES END-USERS  
59875 CHALLENGES FACING THE U.S. CAPITAL MARKETS TO EFFECTIVELY IMPLEMENT TITLE VII OF THE DODD-FRANK ACT CHRG-112hhrg79693 Robert Cook Director Division of Trading and Markets, U.S. Securities and Exchange Commission (SEC) DIVISION OF TRADING AND MARKETS, U.S. SECURITIES AND EXCHANGE COMMISSION (SEC)  
59874 CHALLENGES FACING THE U.S. CAPITAL MARKETS TO EFFECTIVELY IMPLEMENT TITLE VII OF THE DODD-FRANK ACT CHRG-112hhrg79693 Samara Cohen Managing Director Goldman, Sachs & Co GOLDMAN, SACHS & CO  
59877 CHALLENGES FACING THE U.S. CAPITAL MARKETS TO EFFECTIVELY IMPLEMENT TITLE VII OF THE DODD-FRANK ACT CHRG-112hhrg79693 Thomas Deutsch Executive Director American Securitization Forum (ASF) AMERICAN SECURITIZATION FORUM (ASF)  

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;