hearing_members

Committee members present at hearings.

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

41 rows where package_id = "CHRG-119hhrg61971" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-119hhrg61971,Andy Biggs MEMBER DAY CHRG-119hhrg61971 Andy Biggs committee member B001302
CHRG-119hhrg61971,Barry Moore MEMBER DAY CHRG-119hhrg61971 Barry Moore committee member M001212
CHRG-119hhrg61971,Becca Balint MEMBER DAY CHRG-119hhrg61971 Becca Balint committee member B001318
CHRG-119hhrg61971,Ben Cline MEMBER DAY CHRG-119hhrg61971 Ben Cline committee member C001118
CHRG-119hhrg61971,Brad Knott MEMBER DAY CHRG-119hhrg61971 Brad Knott committee member K000405
CHRG-119hhrg61971,Brandon Gill MEMBER DAY CHRG-119hhrg61971 Brandon Gill committee member G000603
CHRG-119hhrg61971,Chip Roy MEMBER DAY CHRG-119hhrg61971 Chip Roy committee member R000614
CHRG-119hhrg61971,Daniel S. Goldman MEMBER DAY CHRG-119hhrg61971 Daniel S. Goldman committee member G000599
CHRG-119hhrg61971,Darrell Issa MEMBER DAY CHRG-119hhrg61971 Darrell Issa committee member I000056
CHRG-119hhrg61971,Deborah K. Ross MEMBER DAY CHRG-119hhrg61971 Deborah K. Ross committee member R000305
CHRG-119hhrg61971,Derek Schmidt MEMBER DAY CHRG-119hhrg61971 Derek Schmidt committee member S001228
CHRG-119hhrg61971,Eric Swalwell MEMBER DAY CHRG-119hhrg61971 Eric Swalwell committee member S001193
CHRG-119hhrg61971,Glenn Grothman MEMBER DAY CHRG-119hhrg61971 Glenn Grothman committee member G000576
CHRG-119hhrg61971,Harriet M. Hageman MEMBER DAY CHRG-119hhrg61971 Harriet M. Hageman committee member H001096
CHRG-119hhrg61971,Jamie Raskin MEMBER DAY CHRG-119hhrg61971 Jamie Raskin committee member R000606
CHRG-119hhrg61971,Jared Moskowitz MEMBER DAY CHRG-119hhrg61971 Jared Moskowitz committee member M001217
CHRG-119hhrg61971,Jasmine Crockett MEMBER DAY CHRG-119hhrg61971 Jasmine Crockett committee member C001130
CHRG-119hhrg61971,Jefferson Van Drew MEMBER DAY CHRG-119hhrg61971 Jefferson Van Drew committee member V000133
CHRG-119hhrg61971,Jerrold Nadler MEMBER DAY CHRG-119hhrg61971 Jerrold Nadler committee member N000002
CHRG-119hhrg61971,Jim Jordan MEMBER DAY CHRG-119hhrg61971 Jim Jordan committee member J000289
CHRG-119hhrg61971,Joe Neguse MEMBER DAY CHRG-119hhrg61971 Joe Neguse committee member N000191
CHRG-119hhrg61971,Kevin Kiley MEMBER DAY CHRG-119hhrg61971 Kevin Kiley committee member K000401
CHRG-119hhrg61971,Lance Gooden MEMBER DAY CHRG-119hhrg61971 Lance Gooden committee member G000589
CHRG-119hhrg61971,Laurel M. Lee MEMBER DAY CHRG-119hhrg61971 Laurel M. Lee committee member L000597
CHRG-119hhrg61971,Lucy McBath MEMBER DAY CHRG-119hhrg61971 Lucy McBath committee member M001208
CHRG-119hhrg61971,Mark Harris MEMBER DAY CHRG-119hhrg61971 Mark Harris committee member H001102
CHRG-119hhrg61971,Mary Gay Scanlon MEMBER DAY CHRG-119hhrg61971 Mary Gay Scanlon committee member S001205
CHRG-119hhrg61971,Michael Baumgartner MEMBER DAY CHRG-119hhrg61971 Michael Baumgartner committee member B001322
CHRG-119hhrg61971,Pramila Jayapal MEMBER DAY CHRG-119hhrg61971 Pramila Jayapal committee member J000298
CHRG-119hhrg61971,Robert F. Onder, Jr. MEMBER DAY CHRG-119hhrg61971 Robert F. Onder, Jr. committee member O000177
CHRG-119hhrg61971,Russell Fry MEMBER DAY CHRG-119hhrg61971 Russell Fry committee member F000478
CHRG-119hhrg61971,Scott Fitzgerald MEMBER DAY CHRG-119hhrg61971 Scott Fitzgerald committee member F000471
CHRG-119hhrg61971,Steve Cohen MEMBER DAY CHRG-119hhrg61971 Steve Cohen committee member C001068
CHRG-119hhrg61971,Sydney Kamlager-Dove MEMBER DAY CHRG-119hhrg61971 Sydney Kamlager-Dove committee member K000400
CHRG-119hhrg61971,Ted Lieu MEMBER DAY CHRG-119hhrg61971 Ted Lieu committee member L000582
CHRG-119hhrg61971,Thomas Massie MEMBER DAY CHRG-119hhrg61971 Thomas Massie committee member M001184
CHRG-119hhrg61971,Thomas P. Tiffany MEMBER DAY CHRG-119hhrg61971 Thomas P. Tiffany committee member T000165
CHRG-119hhrg61971,Tom McClintock MEMBER DAY CHRG-119hhrg61971 Tom McClintock committee member M001177
CHRG-119hhrg61971,Troy E. Nehls MEMBER DAY CHRG-119hhrg61971 Troy E. Nehls committee member N000026
CHRG-119hhrg61971,Wesley Hunt MEMBER DAY CHRG-119hhrg61971 Wesley Hunt committee member H001095
CHRG-119hhrg61971,Zoe Lofgren MEMBER DAY CHRG-119hhrg61971 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);