hearing_members

Committee members present at hearings.

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

42 rows where package_id = "CHRG-108hhrg97775" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-108hhrg97775,Adam H. Putnam STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Adam H. Putnam committee member P000586
CHRG-108hhrg97775,Bernard Sanders STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Bernard Sanders committee member S000033
CHRG-108hhrg97775,Betty McCollum STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Betty McCollum committee member M001143
CHRG-108hhrg97775,Candice S. Miller STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Candice S. Miller committee member M001150
CHRG-108hhrg97775,Carolyn B. Maloney STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Carolyn B. Maloney committee member M000087
CHRG-108hhrg97775,Chris Cannon STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Chris Cannon committee member  
CHRG-108hhrg97775,Chris Van Hollen STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Chris Van Hollen committee member V000128
CHRG-108hhrg97775,Christopher Shays STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Christopher Shays committee member S001144
CHRG-108hhrg97775,Dan Burton STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Dan Burton committee member B001149
CHRG-108hhrg97775,Danny K. Davis STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Danny K. Davis committee member D000096
CHRG-108hhrg97775,Dennis J. Kucinich STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Dennis J. Kucinich committee member K000336
CHRG-108hhrg97775,Diane E. Watson STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Diane E. Watson committee member W000794
CHRG-108hhrg97775,Doug Ose STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Doug Ose committee member O000164
CHRG-108hhrg97775,Edolphus Towns STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Edolphus Towns committee member T000326
CHRG-108hhrg97775,Edward L. Schrock STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Edward L. Schrock committee member S001151
CHRG-108hhrg97775,Elijah E. Cummings STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Elijah E. Cummings committee member C000984
CHRG-108hhrg97775,Henry A. Waxman STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Henry A. Waxman committee member W000215
CHRG-108hhrg97775,Ileana Ros-Lehtinen STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Ileana Ros-Lehtinen committee member R000435
CHRG-108hhrg97775,Jim Cooper STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Jim Cooper committee member C000754
CHRG-108hhrg97775,John F. Tierney STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 John F. Tierney committee member T000266
CHRG-108hhrg97775,John J. Duncan, Jr. STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 John J. Duncan, Jr. committee member D000533
CHRG-108hhrg97775,John L. Mica STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 John L. Mica committee member M000689
CHRG-108hhrg97775,John M. McHugh STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 John M. McHugh committee member M000472
CHRG-108hhrg97775,John R. Carter STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 John R. Carter committee member C001051
CHRG-108hhrg97775,Katherine Harris STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Katherine Harris committee member H001035
CHRG-108hhrg97775,Linda T. Sanchez STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Linda T. Sanchez committee member  
CHRG-108hhrg97775,Major R. Owens STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Major R. Owens committee member O000159
CHRG-108hhrg97775,Mark E. Souder STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Mark E. Souder committee member S001143
CHRG-108hhrg97775,Marsha Blackburn STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Marsha Blackburn committee member B001243
CHRG-108hhrg97775,Michael C. Burgess STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Michael C. Burgess committee member B001248
CHRG-108hhrg97775,Michael R. Turner STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Michael R. Turner committee member T000463
CHRG-108hhrg97775,Nathan Deal STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Nathan Deal committee member D000168
CHRG-108hhrg97775,Patrick J. Tiberi STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Patrick J. Tiberi committee member T000462
CHRG-108hhrg97775,Paul E. Kanjorski STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Paul E. Kanjorski committee member K000008
CHRG-108hhrg97775,Ron Lewis STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Ron Lewis committee member L000293
CHRG-108hhrg97775,Stephen F. Lynch STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Stephen F. Lynch committee member L000562
CHRG-108hhrg97775,Steven C. LaTourette STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Steven C. LaTourette committee member L000553
CHRG-108hhrg97775,Tim Murphy STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Tim Murphy committee member M001151
CHRG-108hhrg97775,Todd Russell Platts STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Todd Russell Platts committee member P000585
CHRG-108hhrg97775,Tom Davis STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Tom Davis committee member  
CHRG-108hhrg97775,Tom Lantos STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 Tom Lantos committee member L000090
CHRG-108hhrg97775,Wm. Lacy Clay STALKING A FURTIVE KILLER: A REVIEW OF THE FEDERAL GOVERNMENT'S EFFORTS TO COMBAT HEPATITIS C CHRG-108hhrg97775 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);