hearing_members

Committee members present at hearings.

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

35 rows where package_id = "CHRG-111hhrg58478" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-111hhrg58478,Adam B. Schiff COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Adam B. Schiff committee member S001150
CHRG-111hhrg58478,Anthony D. Weiner COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Anthony D. Weiner committee member W000792
CHRG-111hhrg58478,Bill Delahunt COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Bill Delahunt committee member  
CHRG-111hhrg58478,Bob Goodlatte COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Bob Goodlatte committee member G000289
CHRG-111hhrg58478,Charles A. Gonzalez COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Charles A. Gonzalez committee member G000544
CHRG-111hhrg58478,Daniel B. Maffei COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Daniel B. Maffei committee member M001171
CHRG-111hhrg58478,Daniel E. Lungren COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Daniel E. Lungren committee member L000517
CHRG-111hhrg58478,Darrell E. Issa COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Darrell E. Issa committee member I000056
CHRG-111hhrg58478,Elton Gallegly COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Elton Gallegly committee member G000021
CHRG-111hhrg58478,Gregg Harper COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Gregg Harper committee member H001045
CHRG-111hhrg58478,Howard Coble COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Howard Coble committee member C000556
CHRG-111hhrg58478,Howard L. Berman COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Howard L. Berman committee member B000410
CHRG-111hhrg58478,Jared Polis COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Jared Polis committee member P000598
CHRG-111hhrg58478,Jason Chaffetz COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Jason Chaffetz committee member C001076
CHRG-111hhrg58478,Jerrold Nadler COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Jerrold Nadler committee member N000002
CHRG-111hhrg58478,Jim Jordan COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Jim Jordan committee member J000289
CHRG-111hhrg58478,John Conyers, Jr. COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 John Conyers, Jr. committee member C000714
CHRG-111hhrg58478,Judy Chu COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Judy Chu committee member C001080
CHRG-111hhrg58478,Lamar Smith COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Lamar Smith committee member S000583
CHRG-111hhrg58478,Linda T. Sanchez COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Linda T. Sanchez committee member  
CHRG-111hhrg58478,Louie Gohmert COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Louie Gohmert committee member G000552
CHRG-111hhrg58478,Luis V. Gutierrez COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Luis V. Gutierrez committee member  
CHRG-111hhrg58478,Maxine Waters COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Maxine Waters committee member W000187
CHRG-111hhrg58478,Melvin L. Watt COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Melvin L. Watt committee member W000207
CHRG-111hhrg58478,Mike Quigley COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Mike Quigley committee member Q000023
CHRG-111hhrg58478,Rick Boucher COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Rick Boucher committee member  
CHRG-111hhrg58478,Sheila Jackson Lee COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Sheila Jackson Lee committee member J000032
CHRG-111hhrg58478,Steve Cohen COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Steve Cohen committee member C001068
CHRG-111hhrg58478,Steve King COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Steve King committee member K000362
CHRG-111hhrg58478,Tammy Baldwin COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Tammy Baldwin committee member B001230
CHRG-111hhrg58478,Ted Poe COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Ted Poe committee member P000592
CHRG-111hhrg58478,Theodore E. Deutch COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Theodore E. Deutch committee member D000610
CHRG-111hhrg58478,Thomas J. Rooney COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Thomas J. Rooney committee member R000583
CHRG-111hhrg58478,Trent Franks COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Trent Franks committee member F000448
CHRG-111hhrg58478,Zoe Lofgren COURTROOM USE: ACCESS TO JUSTICE, EFFECTIVE JUDICIAL ADMINISTRATION, AND COURTROOM SECURITY CHRG-111hhrg58478 Zoe Lofgren committee member L000397

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