hearing_members

Committee members present at hearings.

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

39 rows where package_id = "CHRG-116hhrg41987" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-116hhrg41987,Alexandria Ocasio-Cortez IRS IN THE PANDEMIC CHRG-116hhrg41987 Alexandria Ocasio-Cortez committee member O000172
CHRG-116hhrg41987,Ayanna Pressley IRS IN THE PANDEMIC CHRG-116hhrg41987 Ayanna Pressley committee member P000617
CHRG-116hhrg41987,Bob Gibbs IRS IN THE PANDEMIC CHRG-116hhrg41987 Bob Gibbs committee member G000563
CHRG-116hhrg41987,Brenda L. Lawrence IRS IN THE PANDEMIC CHRG-116hhrg41987 Brenda L. Lawrence committee member L000581
CHRG-116hhrg41987,Carol D. Miller IRS IN THE PANDEMIC CHRG-116hhrg41987 Carol D. Miller committee member M001205
CHRG-116hhrg41987,Carolyn B. Maloney IRS IN THE PANDEMIC CHRG-116hhrg41987 Carolyn B. Maloney committee member M000087
CHRG-116hhrg41987,Chip Roy IRS IN THE PANDEMIC CHRG-116hhrg41987 Chip Roy committee member R000614
CHRG-116hhrg41987,Clay Higgins IRS IN THE PANDEMIC CHRG-116hhrg41987 Clay Higgins committee member H001077
CHRG-116hhrg41987,Debbie Wasserman Schultz IRS IN THE PANDEMIC CHRG-116hhrg41987 Debbie Wasserman Schultz committee member W000797
CHRG-116hhrg41987,Fred Keller IRS IN THE PANDEMIC CHRG-116hhrg41987 Fred Keller committee member K000395
CHRG-116hhrg41987,Gary J. Palmer IRS IN THE PANDEMIC CHRG-116hhrg41987 Gary J. Palmer committee member P000609
CHRG-116hhrg41987,Gerald E. Connolly IRS IN THE PANDEMIC CHRG-116hhrg41987 Gerald E. Connolly committee member C001078
CHRG-116hhrg41987,Glenn Grothman IRS IN THE PANDEMIC CHRG-116hhrg41987 Glenn Grothman committee member G000576
CHRG-116hhrg41987,Harley Rouda IRS IN THE PANDEMIC CHRG-116hhrg41987 Harley Rouda committee member R000616
CHRG-116hhrg41987,Jackie Speier IRS IN THE PANDEMIC CHRG-116hhrg41987 Jackie Speier committee member S001175
CHRG-116hhrg41987,James Comer IRS IN THE PANDEMIC CHRG-116hhrg41987 James Comer committee member C001108
CHRG-116hhrg41987,Jamie Raskin IRS IN THE PANDEMIC CHRG-116hhrg41987 Jamie Raskin committee member R000606
CHRG-116hhrg41987,Jim Cooper IRS IN THE PANDEMIC CHRG-116hhrg41987 Jim Cooper committee member C000754
CHRG-116hhrg41987,Jim Jordan IRS IN THE PANDEMIC CHRG-116hhrg41987 Jim Jordan committee member J000289
CHRG-116hhrg41987,Jimmy Gomez IRS IN THE PANDEMIC CHRG-116hhrg41987 Jimmy Gomez committee member G000585
CHRG-116hhrg41987,Jody B. Hice IRS IN THE PANDEMIC CHRG-116hhrg41987 Jody B. Hice committee member H001071
CHRG-116hhrg41987,John P. Sarbanes IRS IN THE PANDEMIC CHRG-116hhrg41987 John P. Sarbanes committee member S001168
CHRG-116hhrg41987,Katie Porter IRS IN THE PANDEMIC CHRG-116hhrg41987 Katie Porter committee member P000618
CHRG-116hhrg41987,Kelly Armstrong IRS IN THE PANDEMIC CHRG-116hhrg41987 Kelly Armstrong committee member A000377
CHRG-116hhrg41987,Kweisi Mfume IRS IN THE PANDEMIC CHRG-116hhrg41987 Kweisi Mfume committee member M000687
CHRG-116hhrg41987,Mark DeSaulnier IRS IN THE PANDEMIC CHRG-116hhrg41987 Mark DeSaulnier committee member D000623
CHRG-116hhrg41987,Mark E. Green IRS IN THE PANDEMIC CHRG-116hhrg41987 Mark E. Green committee member G000590
CHRG-116hhrg41987,Michael Cloud IRS IN THE PANDEMIC CHRG-116hhrg41987 Michael Cloud committee member C001115
CHRG-116hhrg41987,Paul A. Gosar IRS IN THE PANDEMIC CHRG-116hhrg41987 Paul A. Gosar committee member G000565
CHRG-116hhrg41987,Peter Welch IRS IN THE PANDEMIC CHRG-116hhrg41987 Peter Welch committee member W000800
CHRG-116hhrg41987,Raja Krishnamoorthi IRS IN THE PANDEMIC CHRG-116hhrg41987 Raja Krishnamoorthi committee member K000391
CHRG-116hhrg41987,Ralph Norman IRS IN THE PANDEMIC CHRG-116hhrg41987 Ralph Norman committee member N000190
CHRG-116hhrg41987,Rashida Tlaib IRS IN THE PANDEMIC CHRG-116hhrg41987 Rashida Tlaib committee member T000481
CHRG-116hhrg41987,Ro Khanna IRS IN THE PANDEMIC CHRG-116hhrg41987 Ro Khanna committee member K000389
CHRG-116hhrg41987,Robin L. Kelly IRS IN THE PANDEMIC CHRG-116hhrg41987 Robin L. Kelly committee member K000385
CHRG-116hhrg41987,Stephen F. Lynch IRS IN THE PANDEMIC CHRG-116hhrg41987 Stephen F. Lynch committee member L000562
CHRG-116hhrg41987,Thomas Massie IRS IN THE PANDEMIC CHRG-116hhrg41987 Thomas Massie committee member M001184
CHRG-116hhrg41987,Virginia Foxx IRS IN THE PANDEMIC CHRG-116hhrg41987 Virginia Foxx committee member F000450
CHRG-116hhrg41987,Wm. Lacy Clay IRS IN THE PANDEMIC CHRG-116hhrg41987 Wm. Lacy Clay committee member C001049

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