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

13 rows where package_id = "CHRG-111hhrg58477" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, organization_normalized

id package_id name ▼ title organization organization_normalized location
47825 COMPREHENSIVE ALCOHOL REGULATORY EFFECTIVENESS (CARE) ACT OF 2010 CHRG-111hhrg58477 Mr. Einer Elhauge Petrie Professor of Law Harvard Law School HARVARD LAW SCHOOL  
47823 COMPREHENSIVE ALCOHOL REGULATORY EFFECTIVENESS (CARE) ACT OF 2010 CHRG-111hhrg58477 Mr. Richard A. Doyle Chairman and CEO Harpoon Brewery HARPOON BREWERY  
47824 COMPREHENSIVE ALCOHOL REGULATORY EFFECTIVENESS (CARE) ACT OF 2010 CHRG-111hhrg58477 Mr. Stephen M. Diamond Professor of Law University of Miami UNIVERSITY OF MIAMI  
47827 COMPREHENSIVE ALCOHOL REGULATORY EFFECTIVENESS (CARE) ACT OF 2010 CHRG-111hhrg58477 Ms. Michele Simon Research and Policy Director Marin Institute MARIN INSTITUTE  
47822 COMPREHENSIVE ALCOHOL REGULATORY EFFECTIVENESS (CARE) ACT OF 2010 CHRG-111hhrg58477 Ms. Nida Samona   Chairperson, Michigan Liquor Control Commission CHAIRPERSON, MICHIGAN LIQUOR CONTROL COMMISSION  
47826 COMPREHENSIVE ALCOHOL REGULATORY EFFECTIVENESS (CARE) ACT OF 2010 CHRG-111hhrg58477 Ms. Tracy K. Genesen   Partner, Kirkland & Ellis, LLP PARTNER, KIRKLAND & ELLIS, LLP  
47817 COMPREHENSIVE ALCOHOL REGULATORY EFFECTIVENESS (CARE) ACT OF 2010 CHRG-111hhrg58477 The Honorable Bruce Braley   a Representative in Congress from the State of Iowa A REPRESENTATIVE IN CONGRESS FROM THE STATE OF IOWA  
47818 COMPREHENSIVE ALCOHOL REGULATORY EFFECTIVENESS (CARE) ACT OF 2010 CHRG-111hhrg58477 The Honorable Edolphus Towns   a Representative in Congress from the State of New York A REPRESENTATIVE IN CONGRESS FROM THE STATE OF NEW YORK  
47820 COMPREHENSIVE ALCOHOL REGULATORY EFFECTIVENESS (CARE) ACT OF 2010 CHRG-111hhrg58477 The Honorable Gary G. Miller   a Representative in Congress from the State of California A REPRESENTATIVE IN CONGRESS FROM THE STATE OF CALIFORNIA  
47819 COMPREHENSIVE ALCOHOL REGULATORY EFFECTIVENESS (CARE) ACT OF 2010 CHRG-111hhrg58477 The Honorable George Radanovich   a Representative in Congress from the State of California A REPRESENTATIVE IN CONGRESS FROM THE STATE OF CALIFORNIA  
47821 COMPREHENSIVE ALCOHOL REGULATORY EFFECTIVENESS (CARE) ACT OF 2010 CHRG-111hhrg58477 The Honorable Mark L. Shurtleff   Attorney General for the State of Utah ATTORNEY GENERAL FOR THE STATE OF UTAH  
47815 COMPREHENSIVE ALCOHOL REGULATORY EFFECTIVENESS (CARE) ACT OF 2010 CHRG-111hhrg58477 The Honorable Mike Thompson   a Representative in Congress from the State of California A REPRESENTATIVE IN CONGRESS FROM THE STATE OF CALIFORNIA  
47816 COMPREHENSIVE ALCOHOL REGULATORY EFFECTIVENESS (CARE) ACT OF 2010 CHRG-111hhrg58477 The Honorable Peter DeFazio   a Representative in Congress from the State of Oregon A REPRESENTATIVE IN CONGRESS FROM THE STATE OF OREGON  

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;