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

6 rows where package_id = "CHRG-111hhrg62682" 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
48161 PERSPECTIVES ON THE LIVABLE COMMUNITIES ACT OF 2010 CHRG-111hhrg62682 Andriana Abariotes Executive Director Twin Cities Local Initiative Support Corporation (LISC) TWIN CITIES LOCAL INITIATIVE SUPPORT CORPORATION (LISC)  
48164 PERSPECTIVES ON THE LIVABLE COMMUNITIES ACT OF 2010 CHRG-111hhrg62682 Bruce A. Knight Planning Director, and President City of Champaign, Illinois, American Planning Association (APA) CITY OF CHAMPAIGN, ILLINOIS, AMERICAN PLANNING ASSOCIATION (APA)  
48166 PERSPECTIVES ON THE LIVABLE COMMUNITIES ACT OF 2010 CHRG-111hhrg62682 Hon. Albio Sires   a Representative in Congress from the State of New Jersey A REPRESENTATIVE IN CONGRESS FROM THE STATE OF NEW JERSEY  
48165 PERSPECTIVES ON THE LIVABLE COMMUNITIES ACT OF 2010 CHRG-111hhrg62682 Hon. Bob Murphy   Mayor, City of Lakewood, Colorado MAYOR, CITY OF LAKEWOOD, COLORADO  
48162 PERSPECTIVES ON THE LIVABLE COMMUNITIES ACT OF 2010 CHRG-111hhrg62682 Hon. Earl Blumenauer   a Representative in Congress from the State of Oregon A REPRESENTATIVE IN CONGRESS FROM THE STATE OF OREGON  
48163 PERSPECTIVES ON THE LIVABLE COMMUNITIES ACT OF 2010 CHRG-111hhrg62682 Julia W. Gouge President, Board of County Commissioners Carroll County, Maryland CARROLL COUNTY, MARYLAND  

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;