hearing_members

Committee members present at hearings.

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

44 rows where package_id = "CHRG-114hhrg21543" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-114hhrg21543,Alan Grayson NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Alan Grayson committee member G000556
CHRG-114hhrg21543,Alan S. Lowenthal NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Alan S. Lowenthal committee member L000579
CHRG-114hhrg21543,Albio Sires NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Albio Sires committee member S001165
CHRG-114hhrg21543,Ami Bera NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Ami Bera committee member B001287
CHRG-114hhrg21543,Brad Sherman NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Brad Sherman committee member S000344
CHRG-114hhrg21543,Brendan F. Boyle NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Brendan F. Boyle committee member B001296
CHRG-114hhrg21543,Brian Higgins NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Brian Higgins committee member H001038
CHRG-114hhrg21543,Christopher H. Smith NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Christopher H. Smith committee member S000522
CHRG-114hhrg21543,Curt Clawson NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Curt Clawson committee member C001102
CHRG-114hhrg21543,Dana Rohrabacher NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Dana Rohrabacher committee member R000409
CHRG-114hhrg21543,Daniel M. Donovan, Jr. NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Daniel M. Donovan, Jr. committee member D000625
CHRG-114hhrg21543,Darrell Issa NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Darrell Issa committee member I000056
CHRG-114hhrg21543,David A. Trott NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 David A. Trott committee member T000475
CHRG-114hhrg21543,David N. Cicilline NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 David N. Cicilline committee member C001084
CHRG-114hhrg21543,Edward R. Royce NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Edward R. Royce committee member R000487
CHRG-114hhrg21543,Eliot L. Engel NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Eliot L. Engel committee member E000179
CHRG-114hhrg21543,Gerald E. Connolly NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Gerald E. Connolly committee member C001078
CHRG-114hhrg21543,Grace Meng NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Grace Meng committee member M001188
CHRG-114hhrg21543,Gregory W. Meeks NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Gregory W. Meeks committee member M001137
CHRG-114hhrg21543,Ileana Ros-Lehtinen NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Ileana Ros-Lehtinen committee member R000435
CHRG-114hhrg21543,Jeff Duncan NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Jeff Duncan committee member D000615
CHRG-114hhrg21543,Joaquin Castro NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Joaquin Castro committee member C001091
CHRG-114hhrg21543,Joe Wilson NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Joe Wilson committee member W000795
CHRG-114hhrg21543,Karen Bass NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Karen Bass committee member B001270
CHRG-114hhrg21543,Lee M. Zeldin NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Lee M. Zeldin committee member Z000017
CHRG-114hhrg21543,Lois Frankel NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Lois Frankel committee member F000462
CHRG-114hhrg21543,Mark Meadows NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Mark Meadows committee member M001187
CHRG-114hhrg21543,Matt Salmon NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Matt Salmon committee member S000018
CHRG-114hhrg21543,Michael T. McCaul NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Michael T. McCaul committee member M001157
CHRG-114hhrg21543,Mo Brooks NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Mo Brooks committee member B001274
CHRG-114hhrg21543,Paul Cook NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Paul Cook committee member C001094
CHRG-114hhrg21543,Randy K. Weber, Sr. NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Randy K. Weber, Sr. committee member W000814
CHRG-114hhrg21543,Reid J. Ribble NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Reid J. Ribble committee member R000587
CHRG-114hhrg21543,Robin L. Kelly NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Robin L. Kelly committee member K000385
CHRG-114hhrg21543,Ron DeSantis NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Ron DeSantis committee member D000621
CHRG-114hhrg21543,Scott DesJarlais NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Scott DesJarlais committee member D000616
CHRG-114hhrg21543,Scott Perry NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Scott Perry committee member P000605
CHRG-114hhrg21543,Steve Chabot NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Steve Chabot committee member C000266
CHRG-114hhrg21543,Ted Poe NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Ted Poe committee member P000592
CHRG-114hhrg21543,Ted S. Yoho NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Ted S. Yoho committee member Y000065
CHRG-114hhrg21543,Theodore E. Deutch NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Theodore E. Deutch committee member D000610
CHRG-114hhrg21543,Tom Marino NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Tom Marino committee member M001179
CHRG-114hhrg21543,Tulsi Gabbard NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 Tulsi Gabbard committee member G000571
CHRG-114hhrg21543,William R. Keating NORTH KOREA'S PERPETUAL PROVOCATIONS: ANOTHER DANGEROUS, ESCALATORY NUCLEAR TEST CHRG-114hhrg21543 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);