hearing_members

Committee members present at hearings.

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

30 rows where package_id = "CHRG-116jhrg39417" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-116jhrg39417,Al Green HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 Al Green committee member G000553
CHRG-116jhrg39417,Bennie G. Thompson HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 Bennie G. Thompson committee member T000193
CHRG-116jhrg39417,Bonnie Watson Coleman of New Jersey HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 Bonnie Watson Coleman of New Jersey committee member  
CHRG-116jhrg39417,Cedric L. Richmond HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 Cedric L. Richmond committee member R000588
CHRG-116jhrg39417,Clay Higgins HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 Clay Higgins committee member H001077
CHRG-116jhrg39417,Dan Crenshaw HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 Dan Crenshaw committee member C001120
CHRG-116jhrg39417,Debbie Lesko HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 Debbie Lesko committee member L000589
CHRG-116jhrg39417,Dina Titus HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 Dina Titus committee member T000468
CHRG-116jhrg39417,Donald M. Payne, Jr. HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 Donald M. Payne, Jr. committee member P000604
CHRG-116jhrg39417,Elissa Slotkin HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 Elissa Slotkin committee member S001208
CHRG-116jhrg39417,Emanuel Cleaver HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 Emanuel Cleaver committee member C001061
CHRG-116jhrg39417,James R. Langevin HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 James R. Langevin committee member L000559
CHRG-116jhrg39417,John Joyce HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 John Joyce committee member J000302
CHRG-116jhrg39417,John Katko HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 John Katko committee member K000386
CHRG-116jhrg39417,John Ratcliffe HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 John Ratcliffe committee member R000601
CHRG-116jhrg39417,Kathleen M. Rice HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 Kathleen M. Rice committee member R000602
CHRG-116jhrg39417,Lauren Underwood HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 Lauren Underwood committee member U000040
CHRG-116jhrg39417,Mark E. Green HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 Mark E. Green committee member G000590
CHRG-116jhrg39417,Mark Walker HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 Mark Walker committee member W000819
CHRG-116jhrg39417,Max Rose HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 Max Rose committee member R000613
CHRG-116jhrg39417,Michael Guest HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 Michael Guest committee member G000591
CHRG-116jhrg39417,Michael T. McCaul HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 Michael T. McCaul committee member M001157
CHRG-116jhrg39417,Mike Rogers HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 Mike Rogers committee member R000572
CHRG-116jhrg39417,Nanette Diaz Barragan HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 Nanette Diaz Barragan committee member  
CHRG-116jhrg39417,Peter T. King HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 Peter T. King committee member K000210
CHRG-116jhrg39417,Sheila Jackson Lee of Texas HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 Sheila Jackson Lee of Texas committee member  
CHRG-116jhrg39417,Val Butler Demings HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 Val Butler Demings committee member D000627
CHRG-116jhrg39417,Van Taylor HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 Van Taylor committee member T000479
CHRG-116jhrg39417,Xochitl Torres Small of New Mexico HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 Xochitl Torres Small of New Mexico committee member  
CHRG-116jhrg39417,Yvette D. Clarke HOMELAND SECURITY IMPLICATIONS OF THE OPIOID CRISIS CHRG-116jhrg39417 Yvette D. Clarke committee member C001067

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);
CREATE INDEX idx_hearing_members_package ON hearing_members(package_id);