hearing_members

Committee members present at hearings.

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

22 rows where package_id = "CHRG-117shrg51393" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-117shrg51393,Amy Klobuchar WHY CONGRESS NEEDS TO ACT: LESSONS LEARNED FROM THE FTX COLLAPSE CHRG-117shrg51393 Amy Klobuchar committee member K000367
CHRG-117shrg51393,Ben Ray Lujan WHY CONGRESS NEEDS TO ACT: LESSONS LEARNED FROM THE FTX COLLAPSE CHRG-117shrg51393 Ben Ray Lujan committee member  
CHRG-117shrg51393,Chuck Grassley WHY CONGRESS NEEDS TO ACT: LESSONS LEARNED FROM THE FTX COLLAPSE CHRG-117shrg51393 Chuck Grassley committee member G000386
CHRG-117shrg51393,Cindy Hyde-Smith WHY CONGRESS NEEDS TO ACT: LESSONS LEARNED FROM THE FTX COLLAPSE CHRG-117shrg51393 Cindy Hyde-Smith committee member H001079
CHRG-117shrg51393,Cory A. Booker WHY CONGRESS NEEDS TO ACT: LESSONS LEARNED FROM THE FTX COLLAPSE CHRG-117shrg51393 Cory A. Booker committee member B001288
CHRG-117shrg51393,Deb Fischer WHY CONGRESS NEEDS TO ACT: LESSONS LEARNED FROM THE FTX COLLAPSE CHRG-117shrg51393 Deb Fischer committee member F000463
CHRG-117shrg51393,Debbie Stabenow WHY CONGRESS NEEDS TO ACT: LESSONS LEARNED FROM THE FTX COLLAPSE CHRG-117shrg51393 Debbie Stabenow committee member S000770
CHRG-117shrg51393,John Boozman WHY CONGRESS NEEDS TO ACT: LESSONS LEARNED FROM THE FTX COLLAPSE CHRG-117shrg51393 John Boozman committee member B001236
CHRG-117shrg51393,John Hoeven WHY CONGRESS NEEDS TO ACT: LESSONS LEARNED FROM THE FTX COLLAPSE CHRG-117shrg51393 John Hoeven committee member H001061
CHRG-117shrg51393,John Thune WHY CONGRESS NEEDS TO ACT: LESSONS LEARNED FROM THE FTX COLLAPSE CHRG-117shrg51393 John Thune committee member T000250
CHRG-117shrg51393,Joni Ernst WHY CONGRESS NEEDS TO ACT: LESSONS LEARNED FROM THE FTX COLLAPSE CHRG-117shrg51393 Joni Ernst committee member E000295
CHRG-117shrg51393,Kirsten E. Gillibrand WHY CONGRESS NEEDS TO ACT: LESSONS LEARNED FROM THE FTX COLLAPSE CHRG-117shrg51393 Kirsten E. Gillibrand committee member G000555
CHRG-117shrg51393,Michael F. Bennet WHY CONGRESS NEEDS TO ACT: LESSONS LEARNED FROM THE FTX COLLAPSE CHRG-117shrg51393 Michael F. Bennet committee member B001267
CHRG-117shrg51393,Mike Braun WHY CONGRESS NEEDS TO ACT: LESSONS LEARNED FROM THE FTX COLLAPSE CHRG-117shrg51393 Mike Braun committee member B001310
CHRG-117shrg51393,Mitch McConnell WHY CONGRESS NEEDS TO ACT: LESSONS LEARNED FROM THE FTX COLLAPSE CHRG-117shrg51393 Mitch McConnell committee member M000355
CHRG-117shrg51393,Patrick J. Leahy WHY CONGRESS NEEDS TO ACT: LESSONS LEARNED FROM THE FTX COLLAPSE CHRG-117shrg51393 Patrick J. Leahy committee member L000174
CHRG-117shrg51393,Raphael G. Warnock WHY CONGRESS NEEDS TO ACT: LESSONS LEARNED FROM THE FTX COLLAPSE CHRG-117shrg51393 Raphael G. Warnock committee member W000790
CHRG-117shrg51393,Richard J. Durbin WHY CONGRESS NEEDS TO ACT: LESSONS LEARNED FROM THE FTX COLLAPSE CHRG-117shrg51393 Richard J. Durbin committee member D000563
CHRG-117shrg51393,Roger Marshall WHY CONGRESS NEEDS TO ACT: LESSONS LEARNED FROM THE FTX COLLAPSE CHRG-117shrg51393 Roger Marshall committee member M001198
CHRG-117shrg51393,Sherrod Brown WHY CONGRESS NEEDS TO ACT: LESSONS LEARNED FROM THE FTX COLLAPSE CHRG-117shrg51393 Sherrod Brown committee member B000944
CHRG-117shrg51393,Tina Smith WHY CONGRESS NEEDS TO ACT: LESSONS LEARNED FROM THE FTX COLLAPSE CHRG-117shrg51393 Tina Smith committee member S001203
CHRG-117shrg51393,Tommy Tuberville WHY CONGRESS NEEDS TO ACT: LESSONS LEARNED FROM THE FTX COLLAPSE CHRG-117shrg51393 Tommy Tuberville committee member T000278

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