hearing_members

Committee members present at hearings.

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

28 rows where package_id = "CHRG-119shrg61428" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-119shrg61428,Amy Klobuchar PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 Amy Klobuchar committee member K000367
CHRG-119shrg61428,Andy Kim PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 Andy Kim committee member K000394
CHRG-119shrg61428,Ben Ray Lujan PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 Ben Ray Lujan committee member  
CHRG-119shrg61428,Bernie Moreno PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 Bernie Moreno committee member M001242
CHRG-119shrg61428,Brian Schatz PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 Brian Schatz committee member S001194
CHRG-119shrg61428,Cynthia M. Lummis PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 Cynthia M. Lummis committee member L000571
CHRG-119shrg61428,Dan Sullivan PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 Dan Sullivan committee member S001198
CHRG-119shrg61428,Deb Fischer PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 Deb Fischer committee member F000463
CHRG-119shrg61428,Edward J. Markey PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 Edward J. Markey committee member M000133
CHRG-119shrg61428,Eric Schmitt PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 Eric Schmitt committee member S001227
CHRG-119shrg61428,Gary C. Peters PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 Gary C. Peters committee member P000595
CHRG-119shrg61428,Jacky Rosen PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 Jacky Rosen committee member R000608
CHRG-119shrg61428,Jerry Moran PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 Jerry Moran committee member M000934
CHRG-119shrg61428,John Fetterman PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 John Fetterman committee member F000479
CHRG-119shrg61428,John R. Curtis PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 John R. Curtis committee member C001114
CHRG-119shrg61428,John Thune PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 John Thune committee member T000250
CHRG-119shrg61428,John W. Hickenlooper PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 John W. Hickenlooper committee member H000273
CHRG-119shrg61428,Lisa Blunt Rochester PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 Lisa Blunt Rochester committee member B001303
CHRG-119shrg61428,Maria Cantwell PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 Maria Cantwell committee member C000127
CHRG-119shrg61428,Marsha Blackburn PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 Marsha Blackburn committee member B001243
CHRG-119shrg61428,Roger F. Wicker PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 Roger F. Wicker committee member W000437
CHRG-119shrg61428,Shelley Moore Capito PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 Shelley Moore Capito committee member C001047
CHRG-119shrg61428,Tammy Baldwin PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 Tammy Baldwin committee member B001230
CHRG-119shrg61428,Tammy Duckworth PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 Tammy Duckworth committee member D000622
CHRG-119shrg61428,Ted Budd PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 Ted Budd committee member B001305
CHRG-119shrg61428,Ted Cruz PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 Ted Cruz committee member C001098
CHRG-119shrg61428,Tim Sheehy PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 Tim Sheehy committee member S001232
CHRG-119shrg61428,Todd Young PIPELINE SAFETY REAUTHORIZATION: ENSURING THE SAFE AND EFFICIENT MOVEMENT OF AMERICAN ENERGY CHRG-119shrg61428 Todd Young committee member Y000064

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