hearing_members

Committee members present at hearings.

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

53 rows where package_id = "CHRG-119hhrg60989" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-119hhrg60989,Al Green MEMBER DAY CHRG-119hhrg60989 Al Green committee member G000553
CHRG-119hhrg60989,Andrew Ogles MEMBER DAY CHRG-119hhrg60989 Andrew Ogles committee member O000175
CHRG-119hhrg60989,Andrew R. Garbarino MEMBER DAY CHRG-119hhrg60989 Andrew R. Garbarino committee member G000597
CHRG-119hhrg60989,Andy Barr MEMBER DAY CHRG-119hhrg60989 Andy Barr committee member B001282
CHRG-119hhrg60989,Ann Wagner MEMBER DAY CHRG-119hhrg60989 Ann Wagner committee member W000812
CHRG-119hhrg60989,Ayanna Pressley MEMBER DAY CHRG-119hhrg60989 Ayanna Pressley committee member P000617
CHRG-119hhrg60989,Barry Loudermilk MEMBER DAY CHRG-119hhrg60989 Barry Loudermilk committee member L000583
CHRG-119hhrg60989,Bill Foster MEMBER DAY CHRG-119hhrg60989 Bill Foster committee member F000454
CHRG-119hhrg60989,Bill Huizenga MEMBER DAY CHRG-119hhrg60989 Bill Huizenga committee member H001058
CHRG-119hhrg60989,Brad Sherman MEMBER DAY CHRG-119hhrg60989 Brad Sherman committee member S000344
CHRG-119hhrg60989,Brittany Pettersen MEMBER DAY CHRG-119hhrg60989 Brittany Pettersen committee member P000620
CHRG-119hhrg60989,Bryan Steil MEMBER DAY CHRG-119hhrg60989 Bryan Steil committee member S001213
CHRG-119hhrg60989,Byron Donalds MEMBER DAY CHRG-119hhrg60989 Byron Donalds committee member D000032
CHRG-119hhrg60989,Cleo Fields MEMBER DAY CHRG-119hhrg60989 Cleo Fields committee member F000110
CHRG-119hhrg60989,Daniel Meuser MEMBER DAY CHRG-119hhrg60989 Daniel Meuser committee member M001204
CHRG-119hhrg60989,David Scott MEMBER DAY CHRG-119hhrg60989 David Scott committee member S001157
CHRG-119hhrg60989,Emanuel Cleaver MEMBER DAY CHRG-119hhrg60989 Emanuel Cleaver committee member C001061
CHRG-119hhrg60989,Frank D. Lucas MEMBER DAY CHRG-119hhrg60989 Frank D. Lucas committee member L000491
CHRG-119hhrg60989,Gregory W. Meeks MEMBER DAY CHRG-119hhrg60989 Gregory W. Meeks committee member M001137
CHRG-119hhrg60989,J. French Hill MEMBER DAY CHRG-119hhrg60989 J. French Hill committee member H001072
CHRG-119hhrg60989,James A. Himes MEMBER DAY CHRG-119hhrg60989 James A. Himes committee member H001047
CHRG-119hhrg60989,Janelle S. Bynum MEMBER DAY CHRG-119hhrg60989 Janelle S. Bynum committee member B001326
CHRG-119hhrg60989,John W. Rose MEMBER DAY CHRG-119hhrg60989 John W. Rose committee member R000612
CHRG-119hhrg60989,Josh Gottheimer MEMBER DAY CHRG-119hhrg60989 Josh Gottheimer committee member G000583
CHRG-119hhrg60989,Joyce Beatty MEMBER DAY CHRG-119hhrg60989 Joyce Beatty committee member B001281
CHRG-119hhrg60989,Juan Vargas MEMBER DAY CHRG-119hhrg60989 Juan Vargas committee member V000130
CHRG-119hhrg60989,Lisa C. McClain MEMBER DAY CHRG-119hhrg60989 Lisa C. McClain committee member M001136
CHRG-119hhrg60989,MONICA DE LA CRUZ of Texas MEMBER DAY CHRG-119hhrg60989 MONICA DE LA CRUZ of Texas committee member  
CHRG-119hhrg60989,Maria Elvira Salazar MEMBER DAY CHRG-119hhrg60989 Maria Elvira Salazar committee member S000168
CHRG-119hhrg60989,Marlin A. Stutzman MEMBER DAY CHRG-119hhrg60989 Marlin A. Stutzman committee member S001188
CHRG-119hhrg60989,Maxine Waters MEMBER DAY CHRG-119hhrg60989 Maxine Waters committee member W000187
CHRG-119hhrg60989,Michael Lawler MEMBER DAY CHRG-119hhrg60989 Michael Lawler committee member L000599
CHRG-119hhrg60989,Mike Flood MEMBER DAY CHRG-119hhrg60989 Mike Flood committee member F000474
CHRG-119hhrg60989,Mike Haridopolos MEMBER DAY CHRG-119hhrg60989 Mike Haridopolos committee member H001099
CHRG-119hhrg60989,Nikema Williams MEMBER DAY CHRG-119hhrg60989 Nikema Williams committee member W000788
CHRG-119hhrg60989,Nydia M. Velazquez MEMBER DAY CHRG-119hhrg60989 Nydia M. Velazquez committee member  
CHRG-119hhrg60989,Pete Sessions MEMBER DAY CHRG-119hhrg60989 Pete Sessions committee member S000250
CHRG-119hhrg60989,Ralph Norman MEMBER DAY CHRG-119hhrg60989 Ralph Norman committee member N000190
CHRG-119hhrg60989,Rashida Tlaib MEMBER DAY CHRG-119hhrg60989 Rashida Tlaib committee member T000481
CHRG-119hhrg60989,Ritchie Torres MEMBER DAY CHRG-119hhrg60989 Ritchie Torres committee member T000486
CHRG-119hhrg60989,Roger Williams MEMBER DAY CHRG-119hhrg60989 Roger Williams committee member W000816
CHRG-119hhrg60989,Sam T. Liccardo MEMBER DAY CHRG-119hhrg60989 Sam T. Liccardo committee member L000607
CHRG-119hhrg60989,Scott Fitzgerald MEMBER DAY CHRG-119hhrg60989 Scott Fitzgerald committee member F000471
CHRG-119hhrg60989,Sean Casten MEMBER DAY CHRG-119hhrg60989 Sean Casten committee member C001117
CHRG-119hhrg60989,Stephen F. Lynch MEMBER DAY CHRG-119hhrg60989 Stephen F. Lynch committee member L000562
CHRG-119hhrg60989,Sylvia R. Garcia MEMBER DAY CHRG-119hhrg60989 Sylvia R. Garcia committee member G000587
CHRG-119hhrg60989,Tim Moore MEMBER DAY CHRG-119hhrg60989 Tim Moore committee member M001236
CHRG-119hhrg60989,Tom Emmer MEMBER DAY CHRG-119hhrg60989 Tom Emmer committee member E000294
CHRG-119hhrg60989,Troy Downing MEMBER DAY CHRG-119hhrg60989 Troy Downing committee member D000634
CHRG-119hhrg60989,Vicente Gonzalez MEMBER DAY CHRG-119hhrg60989 Vicente Gonzalez committee member G000581
CHRG-119hhrg60989,Warren Davidson MEMBER DAY CHRG-119hhrg60989 Warren Davidson committee member D000626
CHRG-119hhrg60989,Young Kim MEMBER DAY CHRG-119hhrg60989 Young Kim committee member K000397
CHRG-119hhrg60989,Zachary Nunn MEMBER DAY CHRG-119hhrg60989 Zachary Nunn committee member N000193

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