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

11 rows where package_id = "CHRG-109hhrg31552" 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
25018 PROTECTING AMERICANS FROM CATASTROPHIC TERRORISM RISK CHRG-109hhrg31552 Christopher J. Nassetta President and Chief Executive Officer Host Hotels and Resorts, Inc HOST HOTELS AND RESORTS, INC  
25013 PROTECTING AMERICANS FROM CATASTROPHIC TERRORISM RISK CHRG-109hhrg31552 Dr. Sharon Emek   CBS Coverage Group, Inc., on behalf of the Independent Insurance Agents and Brokers of America, Inc CBS COVERAGE GROUP, INC., ON BEHALF OF THE INDEPENDENT INSURANCE AGENTS AND BROKERS OF AMERICA, INC  
25016 PROTECTING AMERICANS FROM CATASTROPHIC TERRORISM RISK CHRG-109hhrg31552 Edmund F. (Ted) Kelly Chief Executive Officer Liberty Mutual Insurance Company LIBERTY MUTUAL INSURANCE COMPANY  
25014 PROTECTING AMERICANS FROM CATASTROPHIC TERRORISM RISK CHRG-109hhrg31552 Edwin L. Harper Senior Vice President Assurant, Inc ASSURANT, INC  
25011 PROTECTING AMERICANS FROM CATASTROPHIC TERRORISM RISK CHRG-109hhrg31552 Gregory C. Case President and Chief Executive Officer Aon Corporation AON CORPORATION  
25019 PROTECTING AMERICANS FROM CATASTROPHIC TERRORISM RISK CHRG-109hhrg31552 Ira Shapiro Chief Executive Officer Fisher Harris Shapiro, on behalf of the Real Estate Board of New York FISHER HARRIS SHAPIRO, ON BEHALF OF THE REAL ESTATE BOARD OF NEW YORK  
25012 PROTECTING AMERICANS FROM CATASTROPHIC TERRORISM RISK CHRG-109hhrg31552 Jacques E. Dubois Chairman and Chief Executive Officer Swiss Re America Holding Company SWISS RE AMERICA HOLDING COMPANY  
25009 PROTECTING AMERICANS FROM CATASTROPHIC TERRORISM RISK CHRG-109hhrg31552 Janice M. Abraham President and Chief Executive Officer United Educators Insurance, on behalf of the Property Casualty Insurers Association of America UNITED EDUCATORS INSURANCE, ON BEHALF OF THE PROPERTY CASUALTY INSURERS ASSOCIATION OF AMERICA  
25017 PROTECTING AMERICANS FROM CATASTROPHIC TERRORISM RISK CHRG-109hhrg31552 Jonathan W. Knipe Senior Vice President, General Counsel and Director of Business Affairs World Trade Center Properties, LLC WORLD TRADE CENTER PROPERTIES, LLC  
25010 PROTECTING AMERICANS FROM CATASTROPHIC TERRORISM RISK CHRG-109hhrg31552 Ramani Ayer Chairman, President, and Chief Executive Officer, Hartford Financial Services Group      
25015 PROTECTING AMERICANS FROM CATASTROPHIC TERRORISM RISK CHRG-109hhrg31552 Warren Heck Chairman and Chief Executive Officer Greater New York Mutual Insurance Company, on behalf of the National Association of Mutual Insurance Companies GREATER NEW YORK MUTUAL INSURANCE COMPANY, ON BEHALF OF THE NATIONAL ASSOCIATION OF MUTUAL INSURANCE COMPANIES  

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;