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-118shrg55193" 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
106400 FENTANYL IN NATIVE COMMUNITIES: NATIVE PERSPECTIVES ON ADDRESSING THE GROWING CRISIS CHRG-118shrg55193 A. Aukahi Austin Seabury Ph.D., Executive Director/Licensed Clinical Psychologist I Ola Lahui, Inc I OLA LAHUI, INC  
106401 FENTANYL IN NATIVE COMMUNITIES: NATIVE PERSPECTIVES ON ADDRESSING THE GROWING CRISIS CHRG-118shrg55193 Claradina Soto Ph.D., Associate Professor Department of Population and Public Health Sciences, Keck School of Medicine, University of Southern California DEPARTMENT OF POPULATION AND PUBLIC HEALTH SCIENCES, KECK SCHOOL OF MEDICINE, UNIVERSITY OF SOUTHERN CALIFORNIA  
106397 FENTANYL IN NATIVE COMMUNITIES: NATIVE PERSPECTIVES ON ADDRESSING THE GROWING CRISIS CHRG-118shrg55193 Eric M. Gettis Senior Vice President of Behavioral Health, M.D., Clinical Director for Addiction Services Southeast Alaska Regional Health Consortium; accompanied by Corey P. Cox SOUTHEAST ALASKA REGIONAL HEALTH CONSORTIUM; ACCOMPANIED BY COREY P. COX  
106399 FENTANYL IN NATIVE COMMUNITIES: NATIVE PERSPECTIVES ON ADDRESSING THE GROWING CRISIS CHRG-118shrg55193 Hon. Bryce Kirk   Councilman, Assiniboine and Sioux Tribes of the Fort Peck Reservation COUNCILMAN, ASSINIBOINE AND SIOUX TRIBES OF THE FORT PECK RESERVATION  
106396 FENTANYL IN NATIVE COMMUNITIES: NATIVE PERSPECTIVES ON ADDRESSING THE GROWING CRISIS CHRG-118shrg55193 Hon. Jamie S. Azure Chairman Turtle Mountain Band of Chippewa Indians TURTLE MOUNTAIN BAND OF CHIPPEWA INDIANS  
106398 FENTANYL IN NATIVE COMMUNITIES: NATIVE PERSPECTIVES ON ADDRESSING THE GROWING CRISIS CHRG-118shrg55193 Hon. Tony Hillaire Chairman Lummi Nation LUMMI NATION  

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;