home / openregs

hearing_members

Committee members present at hearings.

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

39 rows where package_id = "CHRG-109hhrg45345" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

  • committee member 39
Link package_id name ▼ role bioguide_id
CHRG-109hhrg45345,Bernard Sanders H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Bernard Sanders committee member S000033
CHRG-109hhrg45345,Brian Higgins H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Brian Higgins committee member H001038
CHRG-109hhrg45345,Brian P. Bilbray H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Brian P. Bilbray committee member B000461
CHRG-109hhrg45345,Candice S. Miller H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Candice S. Miller committee member M001150
CHRG-109hhrg45345,Carolyn B. Maloney H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Carolyn B. Maloney committee member M000087
CHRG-109hhrg45345,Charles W. Dent H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Charles W. Dent committee member D000604
CHRG-109hhrg45345,Chris Cannon H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Chris Cannon committee member  
CHRG-109hhrg45345,Chris Van Hollen H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Chris Van Hollen committee member V000128
CHRG-109hhrg45345,Christopher Shays H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Christopher Shays committee member S001144
CHRG-109hhrg45345,Dan Burton H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Dan Burton committee member B001149
CHRG-109hhrg45345,Danny K. Davis H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Danny K. Davis committee member D000096
CHRG-109hhrg45345,Darrell E. Issa H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Darrell E. Issa committee member I000056
CHRG-109hhrg45345,Dennis J. Kucinich H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Dennis J. Kucinich committee member K000336
CHRG-109hhrg45345,Diane E. Watson H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Diane E. Watson committee member W000794
CHRG-109hhrg45345,Edolphus Towns H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Edolphus Towns committee member T000326
CHRG-109hhrg45345,Elijah E. Cummings H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Elijah E. Cummings committee member C000984
CHRG-109hhrg45345,Gil Gutknecht H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Gil Gutknecht committee member  
CHRG-109hhrg45345,Henry A. Waxman H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Henry A. Waxman committee member W000215
CHRG-109hhrg45345,Ileana Ros-Lehtinen H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Ileana Ros-Lehtinen committee member R000435
CHRG-109hhrg45345,Jean Schmidt H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Jean Schmidt committee member S001164
CHRG-109hhrg45345,John J. Duncan, Jr. H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 John J. Duncan, Jr. committee member D000533
CHRG-109hhrg45345,John L. Mica H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 John L. Mica committee member M000689
CHRG-109hhrg45345,John M. McHugh H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 John M. McHugh committee member M000472
CHRG-109hhrg45345,Jon C. Porter H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Jon C. Porter committee member P000589
CHRG-109hhrg45345,Kenny Marchant H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Kenny Marchant committee member M001158
CHRG-109hhrg45345,Linda T. Sanchez H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Linda T. Sanchez committee member  
CHRG-109hhrg45345,Lynn A. Westmoreland H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Lynn A. Westmoreland committee member W000796
CHRG-109hhrg45345,Major R. Owens H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Major R. Owens committee member O000159
CHRG-109hhrg45345,Mark E. Souder H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Mark E. Souder committee member S001143
CHRG-109hhrg45345,Michael R. Turner H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Michael R. Turner committee member T000463
CHRG-109hhrg45345,Patrick T. McHenry H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Patrick T. McHenry committee member M001156
CHRG-109hhrg45345,Paul E. Kanjorski H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Paul E. Kanjorski committee member K000008
CHRG-109hhrg45345,Stephen F. Lynch H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Stephen F. Lynch committee member L000562
CHRG-109hhrg45345,Steven C. LaTourette H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Steven C. LaTourette committee member L000553
CHRG-109hhrg45345,Todd Russell Platts H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Todd Russell Platts committee member P000585
CHRG-109hhrg45345,Tom Davis H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Tom Davis committee member  
CHRG-109hhrg45345,Tom Lantos H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Tom Lantos committee member L000090
CHRG-109hhrg45345,Virginia Foxx H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Virginia Foxx committee member F000450
CHRG-109hhrg45345,Wm. Lacy Clay H.R. 5242, THE SMALL BUSINESS PAPERWORK AMNESTY ACT CHRG-109hhrg45345 Wm. Lacy Clay committee member C001049

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);
Powered by Datasette · Queries took 3.033ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API