hearing_members

Committee members present at hearings.

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

46 rows where package_id = "CHRG-115hhrg31450" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-115hhrg31450,Adam Kinzinger U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Adam Kinzinger committee member K000378
CHRG-115hhrg31450,Adriano Espaillat U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Adriano Espaillat committee member E000297
CHRG-115hhrg31450,Albio Sires U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Albio Sires committee member S001165
CHRG-115hhrg31450,Ami Bera U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Ami Bera committee member B001287
CHRG-115hhrg31450,Ann Wagner U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Ann Wagner committee member W000812
CHRG-115hhrg31450,Brad Sherman U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Brad Sherman committee member S000344
CHRG-115hhrg31450,Bradley Scott Schneider U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Bradley Scott Schneider committee member S001190
CHRG-115hhrg31450,Brendan F. Boyle U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Brendan F. Boyle committee member B001296
CHRG-115hhrg31450,Brian J. Mast U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Brian J. Mast committee member M001199
CHRG-115hhrg31450,Brian K. Fitzpatrick U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Brian K. Fitzpatrick committee member F000466
CHRG-115hhrg31450,Christopher H. Smith U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Christopher H. Smith committee member S000522
CHRG-115hhrg31450,Dana Rohrabacher U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Dana Rohrabacher committee member R000409
CHRG-115hhrg31450,Daniel M. Donovan, Jr. U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Daniel M. Donovan, Jr. committee member D000625
CHRG-115hhrg31450,Darrell Issa U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Darrell Issa committee member I000056
CHRG-115hhrg31450,David N. Cicilline U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 David N. Cicilline committee member C001084
CHRG-115hhrg31450,Dina Titus U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Dina Titus committee member T000468
CHRG-115hhrg31450,Edward R. Royce U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Edward R. Royce committee member R000487
CHRG-115hhrg31450,Eliot L. Engel U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Eliot L. Engel committee member E000179
CHRG-115hhrg31450,Francis Rooney U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Francis Rooney committee member R000607
CHRG-115hhrg31450,Gerald E. Connolly U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Gerald E. Connolly committee member C001078
CHRG-115hhrg31450,Gregory W. Meeks U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Gregory W. Meeks committee member M001137
CHRG-115hhrg31450,Ileana Ros-Lehtinen U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Ileana Ros-Lehtinen committee member R000435
CHRG-115hhrg31450,Joaquin Castro U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Joaquin Castro committee member C001091
CHRG-115hhrg31450,Joe Wilson U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Joe Wilson committee member W000795
CHRG-115hhrg31450,John R. Curtis U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 John R. Curtis committee member C001114
CHRG-115hhrg31450,Karen Bass U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Karen Bass committee member B001270
CHRG-115hhrg31450,Lee M. Zeldin U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Lee M. Zeldin committee member Z000017
CHRG-115hhrg31450,Lois Frankel U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Lois Frankel committee member F000462
CHRG-115hhrg31450,Mark Meadows U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Mark Meadows committee member M001187
CHRG-115hhrg31450,Michael T. McCaul U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Michael T. McCaul committee member M001157
CHRG-115hhrg31450,Mo Brooks U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Mo Brooks committee member B001274
CHRG-115hhrg31450,Norma J. Torres U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Norma J. Torres committee member T000474
CHRG-115hhrg31450,Paul Cook U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Paul Cook committee member C001094
CHRG-115hhrg31450,Robin L. Kelly U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Robin L. Kelly committee member K000385
CHRG-115hhrg31450,Ron DeSantis U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Ron DeSantis committee member D000621
CHRG-115hhrg31450,Scott Perry U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Scott Perry committee member P000605
CHRG-115hhrg31450,Steve Chabot U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Steve Chabot committee member C000266
CHRG-115hhrg31450,Ted Lieu U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Ted Lieu committee member L000582
CHRG-115hhrg31450,Ted Poe U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Ted Poe committee member P000592
CHRG-115hhrg31450,Ted S. Yoho U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Ted S. Yoho committee member Y000065
CHRG-115hhrg31450,Theodore E. Deutch U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Theodore E. Deutch committee member D000610
CHRG-115hhrg31450,Thomas A. Garrett, Jr. U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Thomas A. Garrett, Jr. committee member G000580
CHRG-115hhrg31450,Thomas R. Suozzi U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Thomas R. Suozzi committee member S001201
CHRG-115hhrg31450,Tom Marino U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Tom Marino committee member M001179
CHRG-115hhrg31450,Tulsi Gabbard U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 Tulsi Gabbard committee member G000571
CHRG-115hhrg31450,William R. Keating U.S. POLICY TOWARD CUBA CHRG-115hhrg31450 William R. Keating committee member K000375

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