hearing_members

Committee members present at hearings.

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

43 rows where package_id = "CHRG-117hhrg50157" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-117hhrg50157,Alexandria Ocasio-Cortez FITARA 15.0 CHRG-117hhrg50157 Alexandria Ocasio-Cortez committee member O000172
CHRG-117hhrg50157,Andrew S. Clyde FITARA 15.0 CHRG-117hhrg50157 Andrew S. Clyde committee member C001116
CHRG-117hhrg50157,Andy Biggs FITARA 15.0 CHRG-117hhrg50157 Andy Biggs committee member B001302
CHRG-117hhrg50157,Ayanna Pressley FITARA 15.0 CHRG-117hhrg50157 Ayanna Pressley committee member P000617
CHRG-117hhrg50157,Bob Gibbs FITARA 15.0 CHRG-117hhrg50157 Bob Gibbs committee member G000563
CHRG-117hhrg50157,Brenda L. Lawrence FITARA 15.0 CHRG-117hhrg50157 Brenda L. Lawrence committee member L000581
CHRG-117hhrg50157,Byron Donalds FITARA 15.0 CHRG-117hhrg50157 Byron Donalds committee member D000032
CHRG-117hhrg50157,C. Scott Franklin FITARA 15.0 CHRG-117hhrg50157 C. Scott Franklin committee member  
CHRG-117hhrg50157,Carolyn B. Maloney FITARA 15.0 CHRG-117hhrg50157 Carolyn B. Maloney committee member M000087
CHRG-117hhrg50157,Clay Higgins FITARA 15.0 CHRG-117hhrg50157 Clay Higgins committee member H001077
CHRG-117hhrg50157,Cori Bush FITARA 15.0 CHRG-117hhrg50157 Cori Bush committee member B001224
CHRG-117hhrg50157,Danny K. Davis FITARA 15.0 CHRG-117hhrg50157 Danny K. Davis committee member D000096
CHRG-117hhrg50157,Debbie Wasserman Schultz FITARA 15.0 CHRG-117hhrg50157 Debbie Wasserman Schultz committee member W000797
CHRG-117hhrg50157,Fred Keller FITARA 15.0 CHRG-117hhrg50157 Fred Keller committee member K000395
CHRG-117hhrg50157,Gerald E. Connolly FITARA 15.0 CHRG-117hhrg50157 Gerald E. Connolly committee member C001078
CHRG-117hhrg50157,Glenn Grothman FITARA 15.0 CHRG-117hhrg50157 Glenn Grothman committee member G000576
CHRG-117hhrg50157,Jackie Speier FITARA 15.0 CHRG-117hhrg50157 Jackie Speier committee member S001175
CHRG-117hhrg50157,Jake LaTurner FITARA 15.0 CHRG-117hhrg50157 Jake LaTurner committee member L000266
CHRG-117hhrg50157,James Comer FITARA 15.0 CHRG-117hhrg50157 James Comer committee member C001108
CHRG-117hhrg50157,Jamie Raskin FITARA 15.0 CHRG-117hhrg50157 Jamie Raskin committee member R000606
CHRG-117hhrg50157,Jim Cooper FITARA 15.0 CHRG-117hhrg50157 Jim Cooper committee member C000754
CHRG-117hhrg50157,Jim Jordan FITARA 15.0 CHRG-117hhrg50157 Jim Jordan committee member J000289
CHRG-117hhrg50157,Jimmy Gomez FITARA 15.0 CHRG-117hhrg50157 Jimmy Gomez committee member G000585
CHRG-117hhrg50157,Jody B. Hice FITARA 15.0 CHRG-117hhrg50157 Jody B. Hice committee member H001071
CHRG-117hhrg50157,John P. Sarbanes FITARA 15.0 CHRG-117hhrg50157 John P. Sarbanes committee member S001168
CHRG-117hhrg50157,Katie Porter FITARA 15.0 CHRG-117hhrg50157 Katie Porter committee member P000618
CHRG-117hhrg50157,Kweisi Mfume FITARA 15.0 CHRG-117hhrg50157 Kweisi Mfume committee member M000687
CHRG-117hhrg50157,Mark DeSaulnier FITARA 15.0 CHRG-117hhrg50157 Mark DeSaulnier committee member D000623
CHRG-117hhrg50157,Michael Cloud FITARA 15.0 CHRG-117hhrg50157 Michael Cloud committee member C001115
CHRG-117hhrg50157,Mike Flood FITARA 15.0 CHRG-117hhrg50157 Mike Flood committee member F000474
CHRG-117hhrg50157,Nancy Mace FITARA 15.0 CHRG-117hhrg50157 Nancy Mace committee member M000194
CHRG-117hhrg50157,Pat Fallon FITARA 15.0 CHRG-117hhrg50157 Pat Fallon committee member F000246
CHRG-117hhrg50157,Pete Sessions FITARA 15.0 CHRG-117hhrg50157 Pete Sessions committee member S000250
CHRG-117hhrg50157,Peter Welch FITARA 15.0 CHRG-117hhrg50157 Peter Welch committee member W000800
CHRG-117hhrg50157,Raja Krishnamoorthi FITARA 15.0 CHRG-117hhrg50157 Raja Krishnamoorthi committee member K000391
CHRG-117hhrg50157,Ralph Norman FITARA 15.0 CHRG-117hhrg50157 Ralph Norman committee member N000190
CHRG-117hhrg50157,Rashida Tlaib FITARA 15.0 CHRG-117hhrg50157 Rashida Tlaib committee member T000481
CHRG-117hhrg50157,Ro Khanna FITARA 15.0 CHRG-117hhrg50157 Ro Khanna committee member K000389
CHRG-117hhrg50157,Robin L. Kelly FITARA 15.0 CHRG-117hhrg50157 Robin L. Kelly committee member K000385
CHRG-117hhrg50157,Shontel M. Brown FITARA 15.0 CHRG-117hhrg50157 Shontel M. Brown committee member B001313
CHRG-117hhrg50157,Stephen F. Lynch FITARA 15.0 CHRG-117hhrg50157 Stephen F. Lynch committee member L000562
CHRG-117hhrg50157,Virginia Foxx FITARA 15.0 CHRG-117hhrg50157 Virginia Foxx committee member F000450
CHRG-117hhrg50157,Yvette Herrell FITARA 15.0 CHRG-117hhrg50157 Yvette Herrell committee member H001084

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);