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

51 rows where package_id = "CHRG-106hhrg67118" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

  • committee member 51
Link package_id name ▼ role bioguide_id
CHRG-106hhrg67118,Albert Russell Wynn THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Albert Russell Wynn committee member W000784
CHRG-106hhrg67118,Anna G. Eshoo THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Anna G. Eshoo committee member E000215
CHRG-106hhrg67118,Barbara Cubin THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Barbara Cubin committee member C000962
CHRG-106hhrg67118,Bart Gordon THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Bart Gordon committee member  
CHRG-106hhrg67118,Bart Stupak THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Bart Stupak committee member S001045
CHRG-106hhrg67118,Bill Luther THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Bill Luther committee member  
CHRG-106hhrg67118,Bobby L. Rush THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Bobby L. Rush committee member R000515
CHRG-106hhrg67118,Brian P. Bilbray THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Brian P. Bilbray committee member B000461
CHRG-106hhrg67118,Charles W. Norwood THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Charles W. Norwood committee member N000159
CHRG-106hhrg67118,Christopher Cox THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Christopher Cox committee member  
CHRG-106hhrg67118,Cliff Stearns THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Cliff Stearns committee member S000822
CHRG-106hhrg67118,Diana DeGette THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Diana DeGette committee member D000197
CHRG-106hhrg67118,Ed Bryant THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Ed Bryant committee member B000996
CHRG-106hhrg67118,Ed Whitfield THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Ed Whitfield committee member W000413
CHRG-106hhrg67118,Edolphus Towns THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Edolphus Towns committee member T000326
CHRG-106hhrg67118,Edward J. Markey THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Edward J. Markey committee member M000133
CHRG-106hhrg67118,Eliot L. Engel THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Eliot L. Engel committee member E000179
CHRG-106hhrg67118,Frank Pallone, Jr. THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Frank Pallone, Jr. committee member P000034
CHRG-106hhrg67118,Fred Upton THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Fred Upton committee member U000031
CHRG-106hhrg67118,Gene Green THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Gene Green committee member G000410
CHRG-106hhrg67118,Greg Ganske THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Greg Ganske committee member G000041
CHRG-106hhrg67118,Heather Wilson THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Heather Wilson committee member W000789
CHRG-106hhrg67118,Henry A. Waxman THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Henry A. Waxman committee member W000215
CHRG-106hhrg67118,James C. Greenwood THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 James C. Greenwood committee member G000439
CHRG-106hhrg67118,James E. Rogan THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 James E. Rogan committee member R000386
CHRG-106hhrg67118,Joe Barton THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Joe Barton committee member B000213
CHRG-106hhrg67118,John B. Shadegg THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 John B. Shadegg committee member S000275
CHRG-106hhrg67118,John D. Dingell THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 John D. Dingell committee member D000355
CHRG-106hhrg67118,John Shimkus THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 John Shimkus committee member S000364
CHRG-106hhrg67118,Karen McCarthy THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Karen McCarthy committee member M000316
CHRG-106hhrg67118,Lois Capps THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Lois Capps committee member C001036
CHRG-106hhrg67118,Michael Bilirakis THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Michael Bilirakis committee member B000463
CHRG-106hhrg67118,Michael G. Oxley THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Michael G. Oxley committee member O000163
CHRG-106hhrg67118,Nathan Deal THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Nathan Deal committee member D000168
CHRG-106hhrg67118,Paul E. Gillmor THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Paul E. Gillmor committee member G000210
CHRG-106hhrg67118,Peter Deutsch THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Peter Deutsch committee member D000275
CHRG-106hhrg67118,Ralph M. Hall THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Ralph M. Hall committee member H000067
CHRG-106hhrg67118,Richard Burr THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Richard Burr committee member B001135
CHRG-106hhrg67118,Rick Boucher THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Rick Boucher committee member  
CHRG-106hhrg67118,Rick Lazio THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Rick Lazio committee member L000155
CHRG-106hhrg67118,Robert L. Ehrlich Jr. THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Robert L. Ehrlich Jr. committee member  
CHRG-106hhrg67118,Ron Klink THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Ron Klink committee member K000270
CHRG-106hhrg67118,Roy Blunt THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Roy Blunt committee member B000575
CHRG-106hhrg67118,Sherrod Brown THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Sherrod Brown committee member B000944
CHRG-106hhrg67118,Steve Largent THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Steve Largent committee member L000096
CHRG-106hhrg67118,Ted Strickland THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Ted Strickland committee member S001004
CHRG-106hhrg67118,Thomas M. Barrett THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Thomas M. Barrett committee member B000177
CHRG-106hhrg67118,Tom Bliley THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Tom Bliley committee member B000556
CHRG-106hhrg67118,Tom Coburn THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Tom Coburn committee member C000560
CHRG-106hhrg67118,Tom Sawyer THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Tom Sawyer committee member  
CHRG-106hhrg67118,Vito Fossella THE PATIENT PROTECTION ACT OF 2000 CHRG-106hhrg67118 Vito Fossella committee member F000440

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