hearing_members

Committee members present at hearings.

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

23 rows where package_id = "CHRG-119shrg61814" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-119shrg61814,Adam B. Schiff NOMINATIONS OF MINDY BRASHEARS, STELLA YVETTE HERRELL, AND JOHN WALK CHRG-119shrg61814 Adam B. Schiff committee member S001150
CHRG-119shrg61814,Amy Klobuchar NOMINATIONS OF MINDY BRASHEARS, STELLA YVETTE HERRELL, AND JOHN WALK CHRG-119shrg61814 Amy Klobuchar committee member K000367
CHRG-119shrg61814,Ben Ray Lujan NOMINATIONS OF MINDY BRASHEARS, STELLA YVETTE HERRELL, AND JOHN WALK CHRG-119shrg61814 Ben Ray Lujan committee member  
CHRG-119shrg61814,Chuck Grassley NOMINATIONS OF MINDY BRASHEARS, STELLA YVETTE HERRELL, AND JOHN WALK CHRG-119shrg61814 Chuck Grassley committee member G000386
CHRG-119shrg61814,Cindy Hyde-Smith NOMINATIONS OF MINDY BRASHEARS, STELLA YVETTE HERRELL, AND JOHN WALK CHRG-119shrg61814 Cindy Hyde-Smith committee member H001079
CHRG-119shrg61814,Cory A. Booker NOMINATIONS OF MINDY BRASHEARS, STELLA YVETTE HERRELL, AND JOHN WALK CHRG-119shrg61814 Cory A. Booker committee member B001288
CHRG-119shrg61814,Deb Fischer NOMINATIONS OF MINDY BRASHEARS, STELLA YVETTE HERRELL, AND JOHN WALK CHRG-119shrg61814 Deb Fischer committee member F000463
CHRG-119shrg61814,Elissa Slotkin NOMINATIONS OF MINDY BRASHEARS, STELLA YVETTE HERRELL, AND JOHN WALK CHRG-119shrg61814 Elissa Slotkin committee member S001208
CHRG-119shrg61814,James C. Justice NOMINATIONS OF MINDY BRASHEARS, STELLA YVETTE HERRELL, AND JOHN WALK CHRG-119shrg61814 James C. Justice committee member J000312
CHRG-119shrg61814,Jerry Moran NOMINATIONS OF MINDY BRASHEARS, STELLA YVETTE HERRELL, AND JOHN WALK CHRG-119shrg61814 Jerry Moran committee member M000934
CHRG-119shrg61814,John Boozman NOMINATIONS OF MINDY BRASHEARS, STELLA YVETTE HERRELL, AND JOHN WALK CHRG-119shrg61814 John Boozman committee member B001236
CHRG-119shrg61814,John Fetterman NOMINATIONS OF MINDY BRASHEARS, STELLA YVETTE HERRELL, AND JOHN WALK CHRG-119shrg61814 John Fetterman committee member F000479
CHRG-119shrg61814,John Hoeven NOMINATIONS OF MINDY BRASHEARS, STELLA YVETTE HERRELL, AND JOHN WALK CHRG-119shrg61814 John Hoeven committee member H001061
CHRG-119shrg61814,John Thune NOMINATIONS OF MINDY BRASHEARS, STELLA YVETTE HERRELL, AND JOHN WALK CHRG-119shrg61814 John Thune committee member T000250
CHRG-119shrg61814,Joni Ernst NOMINATIONS OF MINDY BRASHEARS, STELLA YVETTE HERRELL, AND JOHN WALK CHRG-119shrg61814 Joni Ernst committee member E000295
CHRG-119shrg61814,Michael F. Bennet NOMINATIONS OF MINDY BRASHEARS, STELLA YVETTE HERRELL, AND JOHN WALK CHRG-119shrg61814 Michael F. Bennet committee member B001267
CHRG-119shrg61814,Mitch McConnell NOMINATIONS OF MINDY BRASHEARS, STELLA YVETTE HERRELL, AND JOHN WALK CHRG-119shrg61814 Mitch McConnell committee member M000355
CHRG-119shrg61814,Peter Welch NOMINATIONS OF MINDY BRASHEARS, STELLA YVETTE HERRELL, AND JOHN WALK CHRG-119shrg61814 Peter Welch committee member W000800
CHRG-119shrg61814,Raphael G. Warnock NOMINATIONS OF MINDY BRASHEARS, STELLA YVETTE HERRELL, AND JOHN WALK CHRG-119shrg61814 Raphael G. Warnock committee member W000790
CHRG-119shrg61814,Richard J. Durbin NOMINATIONS OF MINDY BRASHEARS, STELLA YVETTE HERRELL, AND JOHN WALK CHRG-119shrg61814 Richard J. Durbin committee member D000563
CHRG-119shrg61814,Roger Marshall NOMINATIONS OF MINDY BRASHEARS, STELLA YVETTE HERRELL, AND JOHN WALK CHRG-119shrg61814 Roger Marshall committee member M001198
CHRG-119shrg61814,Tina Smith NOMINATIONS OF MINDY BRASHEARS, STELLA YVETTE HERRELL, AND JOHN WALK CHRG-119shrg61814 Tina Smith committee member S001203
CHRG-119shrg61814,Tommy Tuberville NOMINATIONS OF MINDY BRASHEARS, STELLA YVETTE HERRELL, AND JOHN WALK CHRG-119shrg61814 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);
CREATE INDEX idx_hearing_members_package ON hearing_members(package_id);