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-114hhrg22124" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-114hhrg22124,Blake Farenthold NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Blake Farenthold committee member F000460
CHRG-114hhrg22124,Bob Goodlatte NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Bob Goodlatte committee member G000289
CHRG-114hhrg22124,Cedric L. Richmond NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Cedric L. Richmond committee member R000588
CHRG-114hhrg22124,Darrell Issa NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Darrell Issa committee member I000056
CHRG-114hhrg22124,David A. Trott NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 David A. Trott committee member T000475
CHRG-114hhrg22124,David N. Cicilline NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 David N. Cicilline committee member C001084
CHRG-114hhrg22124,Doug Collins NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Doug Collins committee member C001093
CHRG-114hhrg22124,Hakeem S. Jeffries NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Hakeem S. Jeffries committee member J000294
CHRG-114hhrg22124,Jason Chaffetz NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Jason Chaffetz committee member C001076
CHRG-114hhrg22124,Jerrold Nadler NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Jerrold Nadler committee member N000002
CHRG-114hhrg22124,Jim Jordan NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Jim Jordan committee member J000289
CHRG-114hhrg22124,John Conyers, Jr. NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 John Conyers, Jr. committee member C000714
CHRG-114hhrg22124,John Ratcliffe NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 John Ratcliffe committee member R000601
CHRG-114hhrg22124,Judy Chu NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Judy Chu committee member C001080
CHRG-114hhrg22124,Karen Bass NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Karen Bass committee member B001270
CHRG-114hhrg22124,Ken Buck NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Ken Buck committee member B001297
CHRG-114hhrg22124,Lamar Smith NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Lamar Smith committee member S000583
CHRG-114hhrg22124,Louie Gohmert NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Louie Gohmert committee member G000552
CHRG-114hhrg22124,Luis V. Gutierrez NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Luis V. Gutierrez committee member  
CHRG-114hhrg22124,Mike Bishop NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Mike Bishop committee member B001293
CHRG-114hhrg22124,Mimi Walters NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Mimi Walters committee member W000820
CHRG-114hhrg22124,Raul R. Labrador NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Raul R. Labrador committee member  
CHRG-114hhrg22124,Ron DeSantis NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Ron DeSantis committee member D000621
CHRG-114hhrg22124,Scott H. Peters NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Scott H. Peters committee member P000608
CHRG-114hhrg22124,Sheila Jackson Lee NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Sheila Jackson Lee committee member J000032
CHRG-114hhrg22124,Steve Chabot NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Steve Chabot committee member C000266
CHRG-114hhrg22124,Steve Cohen NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Steve Cohen committee member C001068
CHRG-114hhrg22124,Steve King NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Steve King committee member K000362
CHRG-114hhrg22124,Suzan K. DelBene NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Suzan K. DelBene committee member D000617
CHRG-114hhrg22124,Ted Poe NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Ted Poe committee member P000592
CHRG-114hhrg22124,Theodore E. Deutch NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Theodore E. Deutch committee member D000610
CHRG-114hhrg22124,Tom Marino NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Tom Marino committee member M001179
CHRG-114hhrg22124,Trent Franks NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Trent Franks committee member F000448
CHRG-114hhrg22124,Trey Gowdy NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 Trey Gowdy committee member G000566
CHRG-114hhrg22124,Zoe Lofgren NEW ORLEANS: HOW THE CRESCENT CITY BECAME A SANCTUARY CITY CHRG-114hhrg22124 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);
CREATE INDEX idx_hearing_members_bioguide ON hearing_members(bioguide_id);