hearing_members

Committee members present at hearings.

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

38 rows where package_id = "CHRG-115hhrg24628" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-115hhrg24628,ALAN GRAYSON of Florida MAKING EPA GREAT AGAIN CHRG-115hhrg24628 ALAN GRAYSON of Florida committee member  
CHRG-115hhrg24628,Ami Bera MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Ami Bera committee member B001287
CHRG-115hhrg24628,Andy Biggs MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Andy Biggs committee member B001302
CHRG-115hhrg24628,Barbara Comstock MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Barbara Comstock committee member C001105
CHRG-115hhrg24628,Barry Loudermilk MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Barry Loudermilk committee member L000583
CHRG-115hhrg24628,Bill Foster MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Bill Foster committee member F000454
CHRG-115hhrg24628,Bill Posey MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Bill Posey committee member P000599
CHRG-115hhrg24628,Brian Babin MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Brian Babin committee member B001291
CHRG-115hhrg24628,Charlie Crist MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Charlie Crist committee member C001111
CHRG-115hhrg24628,Clay Higgins MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Clay Higgins committee member H001077
CHRG-115hhrg24628,Colleen Hanabusa MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Colleen Hanabusa committee member H001050
CHRG-115hhrg24628,Dana Rohrabacher MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Dana Rohrabacher committee member R000409
CHRG-115hhrg24628,Daniel Lipinski MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Daniel Lipinski committee member L000563
CHRG-115hhrg24628,Daniel Webster MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Daniel Webster committee member W000238
CHRG-115hhrg24628,Darin LaHood MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Darin LaHood committee member L000585
CHRG-115hhrg24628,Ed Perlmutter MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Ed Perlmutter committee member P000593
CHRG-115hhrg24628,Eddie Bernice Johnson MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Eddie Bernice Johnson committee member J000126
CHRG-115hhrg24628,Elizabeth H. Esty MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Elizabeth H. Esty committee member E000293
CHRG-115hhrg24628,Frank D. Lucas MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Frank D. Lucas committee member L000491
CHRG-115hhrg24628,Gary J. Palmer MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Gary J. Palmer committee member P000609
CHRG-115hhrg24628,Jacky Rosen MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Jacky Rosen committee member R000608
CHRG-115hhrg24628,Jerry McNerney MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Jerry McNerney committee member M001166
CHRG-115hhrg24628,Jim Banks MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Jim Banks committee member B001299
CHRG-115hhrg24628,Jim Bridenstine MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Jim Bridenstine committee member B001283
CHRG-115hhrg24628,Lamar Smith MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Lamar Smith committee member S000583
CHRG-115hhrg24628,Marc A. Veasey MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Marc A. Veasey committee member V000131
CHRG-115hhrg24628,Mark Takano MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Mark Takano committee member T000472
CHRG-115hhrg24628,Mo Brooks MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Mo Brooks committee member B001274
CHRG-115hhrg24628,Neal P. Dunn MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Neal P. Dunn committee member D000628
CHRG-115hhrg24628,Paul Tonko MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Paul Tonko committee member T000469
CHRG-115hhrg24628,Ralph Lee Abraham MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Ralph Lee Abraham committee member A000374
CHRG-115hhrg24628,Randy Hultgren MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Randy Hultgren committee member H001059
CHRG-115hhrg24628,Randy K. Weber, Sr. MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Randy K. Weber, Sr. committee member W000814
CHRG-115hhrg24628,Roger Marshall MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Roger Marshall committee member M001198
CHRG-115hhrg24628,Stephen Knight MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Stephen Knight committee member K000387
CHRG-115hhrg24628,Suzanne Bonamici MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Suzanne Bonamici committee member B001278
CHRG-115hhrg24628,Thomas Massie MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Thomas Massie committee member M001184
CHRG-115hhrg24628,Zoe Lofgren MAKING EPA GREAT AGAIN CHRG-115hhrg24628 Zoe Lofgren committee member L000397

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