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

10 rows where package_id = "CHRG-119hhrg61971" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

id package_id name ▼ title organization organization_normalized location
108735 MEMBER DAY CHRG-119hhrg61971 The Hon. Brian K. Fitzpatrick Member of Congress Pennsylvania PENNSYLVANIA  
108734 MEMBER DAY CHRG-119hhrg61971 The Hon. Dave Min Member of Congress California CALIFORNIA  
108738 MEMBER DAY CHRG-119hhrg61971 The Hon. Debbie Wasserman Schultz Member of Congress Florida FLORIDA  
108729 MEMBER DAY CHRG-119hhrg61971 The Hon. Emilia Strong Sykes Member of Congress Ohio OHIO  
108736 MEMBER DAY CHRG-119hhrg61971 The Hon. James C. Moylan Member of Congress Guam GUAM  
108732 MEMBER DAY CHRG-119hhrg61971 The Hon. Laura A. Gillen Member of Congress New York NEW YORK  
108733 MEMBER DAY CHRG-119hhrg61971 The Hon. Lizzie Fletcher Member of Congress Texas TEXAS  
108731 MEMBER DAY CHRG-119hhrg61971 The Hon. Melanie A. Stansbury Member of Congress New Mexico NEW MEXICO  
108730 MEMBER DAY CHRG-119hhrg61971 The Hon. Pat Harrigan Member of Congress North Carolina NORTH CAROLINA  
108737 MEMBER DAY CHRG-119hhrg61971 The Hon. Yassamin Ansari Member of Congress Arizona ARIZONA  

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;