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

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

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