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-114shrg23011" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: title, organization_normalized

id package_id name ▼ title organization organization_normalized location
78994 OVERSIGHT OF THE HUD INSPECTION PROCESS CHRG-114shrg23011 Bill Nelson   a U.S. Senator from the State of Florida A U.S. SENATOR FROM THE STATE OF FLORIDA  
78996 OVERSIGHT OF THE HUD INSPECTION PROCESS CHRG-114shrg23011 Edgar Olsen Professor of Economics and Public Policy University of Virginia Batten School of Leadership and Public Policy UNIVERSITY OF VIRGINIA BATTEN SCHOOL OF LEADERSHIP AND PUBLIC POLICY  
78998 OVERSIGHT OF THE HUD INSPECTION PROCESS CHRG-114shrg23011 Major Josh Lewis   Riviera Beach Police Department, Riviera Beach, Florida RIVIERA BEACH POLICE DEPARTMENT, RIVIERA BEACH, FLORIDA  
78995 OVERSIGHT OF THE HUD INSPECTION PROCESS CHRG-114shrg23011 Marco Rubio   a U.S. Senator from the State of Florida A U.S. SENATOR FROM THE STATE OF FLORIDA  
78997 OVERSIGHT OF THE HUD INSPECTION PROCESS CHRG-114shrg23011 Tracy Grant President Eureka Gardens Tenants' Association, Jacksonville, Florida EUREKA GARDENS TENANTS' ASSOCIATION, JACKSONVILLE, FLORIDA  
78999 OVERSIGHT OF THE HUD INSPECTION PROCESS CHRG-114shrg23011 Vincent F. O'Donnell   Affordable Housing Consultant AFFORDABLE HOUSING CONSULTANT  

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;