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

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-119shrg62988,Amy Klobuchar FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 Amy Klobuchar committee member K000367
CHRG-119shrg62988,Andy Kim FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 Andy Kim committee member K000394
CHRG-119shrg62988,Ben Ray Lujan FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 Ben Ray Lujan committee member  
CHRG-119shrg62988,Bernie Moreno FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 Bernie Moreno committee member M001242
CHRG-119shrg62988,Brian Schatz FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 Brian Schatz committee member S001194
CHRG-119shrg62988,Cynthia M. Lummis FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 Cynthia M. Lummis committee member L000571
CHRG-119shrg62988,Dan Sullivan FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 Dan Sullivan committee member S001198
CHRG-119shrg62988,Deb Fischer FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 Deb Fischer committee member F000463
CHRG-119shrg62988,Edward J. Markey FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 Edward J. Markey committee member M000133
CHRG-119shrg62988,Eric Schmitt FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 Eric Schmitt committee member S001227
CHRG-119shrg62988,Gary C. Peters FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 Gary C. Peters committee member P000595
CHRG-119shrg62988,Jacky Rosen FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 Jacky Rosen committee member R000608
CHRG-119shrg62988,Jerry Moran FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 Jerry Moran committee member M000934
CHRG-119shrg62988,John Fetterman FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 John Fetterman committee member F000479
CHRG-119shrg62988,John R. Curtis FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 John R. Curtis committee member C001114
CHRG-119shrg62988,John Thune FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 John Thune committee member T000250
CHRG-119shrg62988,John W. Hickenlooper FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 John W. Hickenlooper committee member H000273
CHRG-119shrg62988,Lisa Blunt Rochester FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 Lisa Blunt Rochester committee member B001303
CHRG-119shrg62988,Maria Cantwell FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 Maria Cantwell committee member C000127
CHRG-119shrg62988,Marsha Blackburn FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 Marsha Blackburn committee member B001243
CHRG-119shrg62988,Roger F. Wicker FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 Roger F. Wicker committee member W000437
CHRG-119shrg62988,Shelley Moore Capito FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 Shelley Moore Capito committee member C001047
CHRG-119shrg62988,Tammy Baldwin FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 Tammy Baldwin committee member B001230
CHRG-119shrg62988,Tammy Duckworth FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 Tammy Duckworth committee member D000622
CHRG-119shrg62988,Ted Budd FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 Ted Budd committee member B001305
CHRG-119shrg62988,Ted Cruz FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 Ted Cruz committee member C001098
CHRG-119shrg62988,Tim Sheehy FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 Tim Sheehy committee member S001232
CHRG-119shrg62988,Todd Young FLYING ON EMPTY: HOW SHUTDOWNS THREATEN AIR SAFETY, TRAVEL, AND THE ECONOMY CHRG-119shrg62988 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);