hearing_members

Committee members present at hearings.

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

24 rows where package_id = "CHRG-114shrg24732" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-114shrg24732,Amy Klobuchar ASSESSING THE SECURITY OF OUR CRITICAL TRANSPORTATION INFRASTRUCTURE CHRG-114shrg24732 Amy Klobuchar committee member K000367
CHRG-114shrg24732,Bill Nelson ASSESSING THE SECURITY OF OUR CRITICAL TRANSPORTATION INFRASTRUCTURE CHRG-114shrg24732 Bill Nelson committee member N000032
CHRG-114shrg24732,Brian Schatz ASSESSING THE SECURITY OF OUR CRITICAL TRANSPORTATION INFRASTRUCTURE CHRG-114shrg24732 Brian Schatz committee member S001194
CHRG-114shrg24732,Claire McCaskill ASSESSING THE SECURITY OF OUR CRITICAL TRANSPORTATION INFRASTRUCTURE CHRG-114shrg24732 Claire McCaskill committee member M001170
CHRG-114shrg24732,Cory A. Booker ASSESSING THE SECURITY OF OUR CRITICAL TRANSPORTATION INFRASTRUCTURE CHRG-114shrg24732 Cory A. Booker committee member B001288
CHRG-114shrg24732,Cory Gardner ASSESSING THE SECURITY OF OUR CRITICAL TRANSPORTATION INFRASTRUCTURE CHRG-114shrg24732 Cory Gardner committee member G000562
CHRG-114shrg24732,Dan Sullivan ASSESSING THE SECURITY OF OUR CRITICAL TRANSPORTATION INFRASTRUCTURE CHRG-114shrg24732 Dan Sullivan committee member S001198
CHRG-114shrg24732,Dean Heller ASSESSING THE SECURITY OF OUR CRITICAL TRANSPORTATION INFRASTRUCTURE CHRG-114shrg24732 Dean Heller committee member H001041
CHRG-114shrg24732,Deb Fischer ASSESSING THE SECURITY OF OUR CRITICAL TRANSPORTATION INFRASTRUCTURE CHRG-114shrg24732 Deb Fischer committee member F000463
CHRG-114shrg24732,Edward J. Markey ASSESSING THE SECURITY OF OUR CRITICAL TRANSPORTATION INFRASTRUCTURE CHRG-114shrg24732 Edward J. Markey committee member M000133
CHRG-114shrg24732,Gary C. Peters ASSESSING THE SECURITY OF OUR CRITICAL TRANSPORTATION INFRASTRUCTURE CHRG-114shrg24732 Gary C. Peters committee member P000595
CHRG-114shrg24732,Jerry Moran ASSESSING THE SECURITY OF OUR CRITICAL TRANSPORTATION INFRASTRUCTURE CHRG-114shrg24732 Jerry Moran committee member M000934
CHRG-114shrg24732,Joe Manchin III ASSESSING THE SECURITY OF OUR CRITICAL TRANSPORTATION INFRASTRUCTURE CHRG-114shrg24732 Joe Manchin III committee member  
CHRG-114shrg24732,John Thune ASSESSING THE SECURITY OF OUR CRITICAL TRANSPORTATION INFRASTRUCTURE CHRG-114shrg24732 John Thune committee member T000250
CHRG-114shrg24732,Kelly Ayotte ASSESSING THE SECURITY OF OUR CRITICAL TRANSPORTATION INFRASTRUCTURE CHRG-114shrg24732 Kelly Ayotte committee member A000368
CHRG-114shrg24732,Marco Rubio ASSESSING THE SECURITY OF OUR CRITICAL TRANSPORTATION INFRASTRUCTURE CHRG-114shrg24732 Marco Rubio committee member R000595
CHRG-114shrg24732,Maria Cantwell ASSESSING THE SECURITY OF OUR CRITICAL TRANSPORTATION INFRASTRUCTURE CHRG-114shrg24732 Maria Cantwell committee member C000127
CHRG-114shrg24732,Richard Blumenthal ASSESSING THE SECURITY OF OUR CRITICAL TRANSPORTATION INFRASTRUCTURE CHRG-114shrg24732 Richard Blumenthal committee member B001277
CHRG-114shrg24732,Roger F. Wicker ASSESSING THE SECURITY OF OUR CRITICAL TRANSPORTATION INFRASTRUCTURE CHRG-114shrg24732 Roger F. Wicker committee member W000437
CHRG-114shrg24732,Ron Johnson ASSESSING THE SECURITY OF OUR CRITICAL TRANSPORTATION INFRASTRUCTURE CHRG-114shrg24732 Ron Johnson committee member J000293
CHRG-114shrg24732,Roy Blunt ASSESSING THE SECURITY OF OUR CRITICAL TRANSPORTATION INFRASTRUCTURE CHRG-114shrg24732 Roy Blunt committee member B000575
CHRG-114shrg24732,Steve Daines ASSESSING THE SECURITY OF OUR CRITICAL TRANSPORTATION INFRASTRUCTURE CHRG-114shrg24732 Steve Daines committee member D000618
CHRG-114shrg24732,Ted Cruz ASSESSING THE SECURITY OF OUR CRITICAL TRANSPORTATION INFRASTRUCTURE CHRG-114shrg24732 Ted Cruz committee member C001098
CHRG-114shrg24732,Tom Udall ASSESSING THE SECURITY OF OUR CRITICAL TRANSPORTATION INFRASTRUCTURE CHRG-114shrg24732 Tom Udall committee member U000039

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