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-115hhrg25470" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

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