hearing_members

Committee members present at hearings.

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

27 rows where package_id = "CHRG-116shrg56587" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-116shrg56587,Angus S. King Jr. SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 Angus S. King Jr. committee member  
CHRG-116shrg56587,Dan Sullivan SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 Dan Sullivan committee member S001198
CHRG-116shrg56587,David Perdue SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 David Perdue committee member P000612
CHRG-116shrg56587,Deb Fischer SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 Deb Fischer committee member F000463
CHRG-116shrg56587,Doug Jones SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 Doug Jones committee member J000300
CHRG-116shrg56587,Elizabeth Warren SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 Elizabeth Warren committee member W000817
CHRG-116shrg56587,Gary C. Peters SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 Gary C. Peters committee member P000595
CHRG-116shrg56587,Jack Reed SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 Jack Reed committee member R000122
CHRG-116shrg56587,James M. Inhofe SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 James M. Inhofe committee member I000024
CHRG-116shrg56587,Jeanne Shaheen SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 Jeanne Shaheen committee member S001181
CHRG-116shrg56587,Joe Manchin III SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 Joe Manchin III committee member  
CHRG-116shrg56587,Joni Ernst SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 Joni Ernst committee member E000295
CHRG-116shrg56587,Josh Hawley SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 Josh Hawley committee member H001089
CHRG-116shrg56587,Kevin Cramer SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 Kevin Cramer committee member C001096
CHRG-116shrg56587,Kirsten E. Gillibrand SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 Kirsten E. Gillibrand committee member G000555
CHRG-116shrg56587,Marsha Blackburn SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 Marsha Blackburn committee member B001243
CHRG-116shrg56587,Martha McSally SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 Martha McSally committee member M001197
CHRG-116shrg56587,Martin Heinrich SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 Martin Heinrich committee member H001046
CHRG-116shrg56587,Mazie K. Hirono SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 Mazie K. Hirono committee member H001042
CHRG-116shrg56587,Mike Rounds SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 Mike Rounds committee member R000605
CHRG-116shrg56587,Richard Blumenthal SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 Richard Blumenthal committee member B001277
CHRG-116shrg56587,Rick Scott SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 Rick Scott committee member S001217
CHRG-116shrg56587,Roger F. Wicker SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 Roger F. Wicker committee member W000437
CHRG-116shrg56587,Tammy Duckworth SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 Tammy Duckworth committee member D000622
CHRG-116shrg56587,Thom Tillis SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 Thom Tillis committee member T000476
CHRG-116shrg56587,Tim Kaine SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 Tim Kaine committee member K000384
CHRG-116shrg56587,Tom Cotton SUPPLY CHAIN INTEGRITY CHRG-116shrg56587 Tom Cotton committee member C001095

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