hearing_members

Committee members present at hearings.

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

37 rows where package_id = "CHRG-108hhrg97275" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-108hhrg97275,Albert Russell Wynn MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Albert Russell Wynn committee member W000784
CHRG-108hhrg97275,Anna G. Eshoo MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Anna G. Eshoo committee member E000215
CHRG-108hhrg97275,Barbara Cubin MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Barbara Cubin committee member C000962
CHRG-108hhrg97275,Bart Gordon MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Bart Gordon committee member  
CHRG-108hhrg97275,Bart Stupak MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Bart Stupak committee member S001045
CHRG-108hhrg97275,Bobby L. Rush MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Bobby L. Rush committee member R000515
CHRG-108hhrg97275,Charles W. Norwood MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Charles W. Norwood committee member N000159
CHRG-108hhrg97275,Christopher Cox MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Christopher Cox committee member  
CHRG-108hhrg97275,Cliff Stearns MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Cliff Stearns committee member S000822
CHRG-108hhrg97275,Diana DeGette MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Diana DeGette committee member D000197
CHRG-108hhrg97275,Ed Whitfield MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Ed Whitfield committee member W000413
CHRG-108hhrg97275,Edolphus Towns MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Edolphus Towns committee member T000326
CHRG-108hhrg97275,Edward J. Markey MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Edward J. Markey committee member M000133
CHRG-108hhrg97275,Eliot L. Engel MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Eliot L. Engel committee member E000179
CHRG-108hhrg97275,Frank Pallone, Jr. MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Frank Pallone, Jr. committee member P000034
CHRG-108hhrg97275,Fred Upton MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Fred Upton committee member U000031
CHRG-108hhrg97275,Gene Green MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Gene Green committee member G000410
CHRG-108hhrg97275,Heather Wilson MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Heather Wilson committee member W000789
CHRG-108hhrg97275,Henry A. Waxman MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Henry A. Waxman committee member W000215
CHRG-108hhrg97275,James C. Greenwood MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 James C. Greenwood committee member G000439
CHRG-108hhrg97275,Joe Barton MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Joe Barton committee member B000213
CHRG-108hhrg97275,John B. Shadegg MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 John B. Shadegg committee member S000275
CHRG-108hhrg97275,John D. Dingell MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 John D. Dingell committee member D000355
CHRG-108hhrg97275,John Shimkus MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 John Shimkus committee member S000364
CHRG-108hhrg97275,Karen McCarthy MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Karen McCarthy committee member M000316
CHRG-108hhrg97275,Lois Capps MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Lois Capps committee member C001036
CHRG-108hhrg97275,Michael Bilirakis MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Michael Bilirakis committee member B000463
CHRG-108hhrg97275,Nathan Deal MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Nathan Deal committee member D000168
CHRG-108hhrg97275,Paul E. Gillmor MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Paul E. Gillmor committee member G000210
CHRG-108hhrg97275,Peter Deutsch MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Peter Deutsch committee member D000275
CHRG-108hhrg97275,Ralph M. Hall MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Ralph M. Hall committee member H000067
CHRG-108hhrg97275,Richard Burr MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Richard Burr committee member B001135
CHRG-108hhrg97275,Rick Boucher MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Rick Boucher committee member  
CHRG-108hhrg97275,Sherrod Brown MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Sherrod Brown committee member B000944
CHRG-108hhrg97275,Steve Buyer MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Steve Buyer committee member  
CHRG-108hhrg97275,Ted Strickland MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 Ted Strickland committee member S001004
CHRG-108hhrg97275,Vito Fossella MEDICAID PRESCRIPTION DRUG REIMBURSEMENT: WHY THE GOVERNMENT PAYS TOO MUCH CHRG-108hhrg97275 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);
CREATE INDEX idx_hearing_members_package ON hearing_members(package_id);