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-119shrg60405" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-119shrg60405,Adam B. Schiff PERSPECTIVES FROM THE FIELD, PART 4: CONSERVATION CHRG-119shrg60405 Adam B. Schiff committee member S001150
CHRG-119shrg60405,Amy Klobuchar PERSPECTIVES FROM THE FIELD, PART 4: CONSERVATION CHRG-119shrg60405 Amy Klobuchar committee member K000367
CHRG-119shrg60405,Ben Ray Lujan PERSPECTIVES FROM THE FIELD, PART 4: CONSERVATION CHRG-119shrg60405 Ben Ray Lujan committee member  
CHRG-119shrg60405,Chuck Grassley PERSPECTIVES FROM THE FIELD, PART 4: CONSERVATION CHRG-119shrg60405 Chuck Grassley committee member G000386
CHRG-119shrg60405,Cindy Hyde-Smith PERSPECTIVES FROM THE FIELD, PART 4: CONSERVATION CHRG-119shrg60405 Cindy Hyde-Smith committee member H001079
CHRG-119shrg60405,Cory A. Booker PERSPECTIVES FROM THE FIELD, PART 4: CONSERVATION CHRG-119shrg60405 Cory A. Booker committee member B001288
CHRG-119shrg60405,Deb Fischer PERSPECTIVES FROM THE FIELD, PART 4: CONSERVATION CHRG-119shrg60405 Deb Fischer committee member F000463
CHRG-119shrg60405,Elissa Slotkin PERSPECTIVES FROM THE FIELD, PART 4: CONSERVATION CHRG-119shrg60405 Elissa Slotkin committee member S001208
CHRG-119shrg60405,James C. Justice PERSPECTIVES FROM THE FIELD, PART 4: CONSERVATION CHRG-119shrg60405 James C. Justice committee member J000312
CHRG-119shrg60405,Jerry Moran PERSPECTIVES FROM THE FIELD, PART 4: CONSERVATION CHRG-119shrg60405 Jerry Moran committee member M000934
CHRG-119shrg60405,John Boozman PERSPECTIVES FROM THE FIELD, PART 4: CONSERVATION CHRG-119shrg60405 John Boozman committee member B001236
CHRG-119shrg60405,John Fetterman PERSPECTIVES FROM THE FIELD, PART 4: CONSERVATION CHRG-119shrg60405 John Fetterman committee member F000479
CHRG-119shrg60405,John Hoeven PERSPECTIVES FROM THE FIELD, PART 4: CONSERVATION CHRG-119shrg60405 John Hoeven committee member H001061
CHRG-119shrg60405,John Thune PERSPECTIVES FROM THE FIELD, PART 4: CONSERVATION CHRG-119shrg60405 John Thune committee member T000250
CHRG-119shrg60405,Joni Ernst PERSPECTIVES FROM THE FIELD, PART 4: CONSERVATION CHRG-119shrg60405 Joni Ernst committee member E000295
CHRG-119shrg60405,Michael F. Bennet PERSPECTIVES FROM THE FIELD, PART 4: CONSERVATION CHRG-119shrg60405 Michael F. Bennet committee member B001267
CHRG-119shrg60405,Mitch McConnell PERSPECTIVES FROM THE FIELD, PART 4: CONSERVATION CHRG-119shrg60405 Mitch McConnell committee member M000355
CHRG-119shrg60405,Peter Welch PERSPECTIVES FROM THE FIELD, PART 4: CONSERVATION CHRG-119shrg60405 Peter Welch committee member W000800
CHRG-119shrg60405,Raphael G. Warnock PERSPECTIVES FROM THE FIELD, PART 4: CONSERVATION CHRG-119shrg60405 Raphael G. Warnock committee member W000790
CHRG-119shrg60405,Richard J. Durbin PERSPECTIVES FROM THE FIELD, PART 4: CONSERVATION CHRG-119shrg60405 Richard J. Durbin committee member D000563
CHRG-119shrg60405,Roger Marshall PERSPECTIVES FROM THE FIELD, PART 4: CONSERVATION CHRG-119shrg60405 Roger Marshall committee member M001198
CHRG-119shrg60405,Tina Smith PERSPECTIVES FROM THE FIELD, PART 4: CONSERVATION CHRG-119shrg60405 Tina Smith committee member S001203
CHRG-119shrg60405,Tommy Tuberville PERSPECTIVES FROM THE FIELD, PART 4: CONSERVATION CHRG-119shrg60405 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);