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-113shrg92272" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

id package_id name ▼ title organization organization_normalized location
71480 WHEN CATASTROPHE STRIKES: RESPONSES TO NATURAL DISASTERS IN INDIAN COUNTRY CHRG-113shrg92272 Elizabeth Zimmerman Deputy Associate Administrator Office of Response and Recovery, Federal Emergency Management Agency, U.S. Department of Homeland Security OFFICE OF RESPONSE AND RECOVERY, FEDERAL EMERGENCY MANAGEMENT AGENCY, U.S. DEPARTMENT OF HOMELAND SECURITY  
71475 WHEN CATASTROPHE STRIKES: RESPONSES TO NATURAL DISASTERS IN INDIAN COUNTRY CHRG-113shrg92272 Hon. J. Michael Chavarria   Governor, Pueblo of Santa Clara GOVERNOR, PUEBLO OF SANTA CLARA  
71479 WHEN CATASTROPHE STRIKES: RESPONSES TO NATURAL DISASTERS IN INDIAN COUNTRY CHRG-113shrg92272 Hon. Ronda Metcalf Secretary Sauk-Suiattle Indian Tribe SAUK-SUIATTLE INDIAN TRIBE  
71478 WHEN CATASTROPHE STRIKES: RESPONSES TO NATURAL DISASTERS IN INDIAN COUNTRY CHRG-113shrg92272 Jake Heflin President/CEO Tribal Emergency Management Association TRIBAL EMERGENCY MANAGEMENT ASSOCIATION  
71476 WHEN CATASTROPHE STRIKES: RESPONSES TO NATURAL DISASTERS IN INDIAN COUNTRY CHRG-113shrg92272 Mary David Executive Vice President Kawerak, Inc KAWERAK, INC  
71477 WHEN CATASTROPHE STRIKES: RESPONSES TO NATURAL DISASTERS IN INDIAN COUNTRY CHRG-113shrg92272 Matt Gregory Executive Director of Risk Management Choctaw Nation of Oklahoma CHOCTAW NATION OF OKLAHOMA  

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;