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

5 rows where package_id = "CHRG-118hhrg56400" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location

id package_id name ▼ title organization organization_normalized location
104674 H.R. 6489, H.R. 8942, H.R. 8955, AND H.R. 8956 CHRG-118hhrg56400 Amber Torres Chief Operating Officer National Indian Health Board (NIHB) NATIONAL INDIAN HEALTH BOARD (NIHB) Washington, DC
104675 H.R. 6489, H.R. 8942, H.R. 8955, AND H.R. 8956 CHRG-118hhrg56400 Ben Mallott Vice President for External Affairs Alaska Federation of Natives (AFN), Anchorage, Alaska ALASKA FEDERATION OF NATIVES (AFN), ANCHORAGE, ALASKA  
104673 H.R. 6489, H.R. 8942, H.R. 8955, AND H.R. 8956 CHRG-118hhrg56400 Hon. Jarred-Micheal Erickson Chairman Confederated Tribes of the Colville Reservation, Nespelem, Washington CONFEDERATED TRIBES OF THE COLVILLE RESERVATION, NESPELEM, WASHINGTON  
104676 H.R. 6489, H.R. 8942, H.R. 8955, AND H.R. 8956 CHRG-118hhrg56400 Jerilyn Church Executive Director Great Plains Tribal Leader's Health Board (GPTLHB), Rapid City, South Dakota GREAT PLAINS TRIBAL LEADER'S HEALTH BOARD (GPTLHB), RAPID CITY, SOUTH DAKOTA  
104672 H.R. 6489, H.R. 8942, H.R. 8955, AND H.R. 8956 CHRG-118hhrg56400 Panel II: Smith Deputy Director, Indian Health Services, U.S. Department of Health and Human Services Benjamin, Rockville, Maryland BENJAMIN, ROCKVILLE, 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;