hearing_members

Committee members present at hearings.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

13 rows where package_id = "CHRG-116hhrg42928" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-116hhrg42928,Debra A. Haaland [H.A.S.C. No. 116-96] FORT HOOD 2020: THE FINDINGS AND RECOMMENDATION OF THE FORT HOOD INDEPENDENT REVIEW COMMITTEE CHRG-116hhrg42928 Debra A. Haaland committee member H001080
CHRG-116hhrg42928,Elaine G. Luria [H.A.S.C. No. 116-96] FORT HOOD 2020: THE FINDINGS AND RECOMMENDATION OF THE FORT HOOD INDEPENDENT REVIEW COMMITTEE CHRG-116hhrg42928 Elaine G. Luria committee member L000591
CHRG-116hhrg42928,Jack Bergman [H.A.S.C. No. 116-96] FORT HOOD 2020: THE FINDINGS AND RECOMMENDATION OF THE FORT HOOD INDEPENDENT REVIEW COMMITTEE CHRG-116hhrg42928 Jack Bergman committee member B001301
CHRG-116hhrg42928,Jackie Speier [H.A.S.C. No. 116-96] FORT HOOD 2020: THE FINDINGS AND RECOMMENDATION OF THE FORT HOOD INDEPENDENT REVIEW COMMITTEE CHRG-116hhrg42928 Jackie Speier committee member S001175
CHRG-116hhrg42928,Liz Cheney [H.A.S.C. No. 116-96] FORT HOOD 2020: THE FINDINGS AND RECOMMENDATION OF THE FORT HOOD INDEPENDENT REVIEW COMMITTEE CHRG-116hhrg42928 Liz Cheney committee member C001109
CHRG-116hhrg42928,Lori Trahan [H.A.S.C. No. 116-96] FORT HOOD 2020: THE FINDINGS AND RECOMMENDATION OF THE FORT HOOD INDEPENDENT REVIEW COMMITTEE CHRG-116hhrg42928 Lori Trahan committee member T000482
CHRG-116hhrg42928,Matt Gaetz [H.A.S.C. No. 116-96] FORT HOOD 2020: THE FINDINGS AND RECOMMENDATION OF THE FORT HOOD INDEPENDENT REVIEW COMMITTEE CHRG-116hhrg42928 Matt Gaetz committee member G000578
CHRG-116hhrg42928,Paul Mitchell [H.A.S.C. No. 116-96] FORT HOOD 2020: THE FINDINGS AND RECOMMENDATION OF THE FORT HOOD INDEPENDENT REVIEW COMMITTEE CHRG-116hhrg42928 Paul Mitchell committee member M001201
CHRG-116hhrg42928,Ralph Lee Abraham [H.A.S.C. No. 116-96] FORT HOOD 2020: THE FINDINGS AND RECOMMENDATION OF THE FORT HOOD INDEPENDENT REVIEW COMMITTEE CHRG-116hhrg42928 Ralph Lee Abraham committee member A000374
CHRG-116hhrg42928,Ruben Gallego [H.A.S.C. No. 116-96] FORT HOOD 2020: THE FINDINGS AND RECOMMENDATION OF THE FORT HOOD INDEPENDENT REVIEW COMMITTEE CHRG-116hhrg42928 Ruben Gallego committee member G000574
CHRG-116hhrg42928,Susan A. Davis [H.A.S.C. No. 116-96] FORT HOOD 2020: THE FINDINGS AND RECOMMENDATION OF THE FORT HOOD INDEPENDENT REVIEW COMMITTEE CHRG-116hhrg42928 Susan A. Davis committee member D000598
CHRG-116hhrg42928,Trent Kelly [H.A.S.C. No. 116-96] FORT HOOD 2020: THE FINDINGS AND RECOMMENDATION OF THE FORT HOOD INDEPENDENT REVIEW COMMITTEE CHRG-116hhrg42928 Trent Kelly committee member K000388
CHRG-116hhrg42928,Veronica Escobar [H.A.S.C. No. 116-96] FORT HOOD 2020: THE FINDINGS AND RECOMMENDATION OF THE FORT HOOD INDEPENDENT REVIEW COMMITTEE CHRG-116hhrg42928 Veronica Escobar committee member E000299

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE hearing_members (
    package_id TEXT NOT NULL REFERENCES hearings(package_id),
    name TEXT NOT NULL,
    role TEXT,
    bioguide_id TEXT,
    PRIMARY KEY (package_id, name)
);
CREATE INDEX idx_hm_name ON hearing_members(name);
CREATE INDEX idx_hm_bioguide ON hearing_members(bioguide_id);