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-116hhrg41910" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

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