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

4 rows where package_id = "CHRG-114shrg23557" 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
79051 S. 2285, S. 3234, S. 3261, AND H.R. 4685 CHRG-114shrg23557 Cheryl Andrews-Maltais Senior Policy Advisor to the Acting Assistant Secretary on Indian Affairs U.S. Department of the Interior U.S. DEPARTMENT OF THE INTERIOR  
79054 S. 2285, S. 3234, S. 3261, AND H.R. 4685 CHRG-114shrg23557 Derrick Watchman Chairman National Center for American Indian Enterprise Development NATIONAL CENTER FOR AMERICAN INDIAN ENTERPRISE DEVELOPMENT  
79053 S. 2285, S. 3234, S. 3261, AND H.R. 4685 CHRG-114shrg23557 Hon. Kenneth McDarment Vice Chairman Tule River Indian Tribe TULE RIVER INDIAN TRIBE  
79052 S. 2285, S. 3234, S. 3261, AND H.R. 4685 CHRG-114shrg23557 Jr. Godwin Chairman Hon. Harvey, Lumbee Tribe of North Carolina HON. HARVEY, LUMBEE TRIBE OF NORTH CAROLINA  

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;