hearing_members

Committee members present at hearings.

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

40 rows where package_id = "CHRG-110hhrg51757" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-110hhrg51757,Betty McCollum 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Betty McCollum committee member M001143
CHRG-110hhrg51757,Bill Sali 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Bill Sali committee member S001167
CHRG-110hhrg51757,Brian Higgins 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Brian Higgins committee member H001038
CHRG-110hhrg51757,Brian P. Bilbray 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Brian P. Bilbray committee member B000461
CHRG-110hhrg51757,Bruce L. Braley 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Bruce L. Braley committee member B001259
CHRG-110hhrg51757,Carolyn B. Maloney 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Carolyn B. Maloney committee member M000087
CHRG-110hhrg51757,Chris Cannon 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Chris Cannon committee member  
CHRG-110hhrg51757,Chris Van Hollen 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Chris Van Hollen committee member V000128
CHRG-110hhrg51757,Christopher Murphy 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Christopher Murphy committee member M001169
CHRG-110hhrg51757,Christopher Shays 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Christopher Shays committee member S001144
CHRG-110hhrg51757,Dan Burton 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Dan Burton committee member B001149
CHRG-110hhrg51757,Danny K. Davis 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Danny K. Davis committee member D000096
CHRG-110hhrg51757,Darrell E. Issa 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Darrell E. Issa committee member I000056
CHRG-110hhrg51757,Dennis J. Kucinich 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Dennis J. Kucinich committee member K000336
CHRG-110hhrg51757,Diane E. Watson 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Diane E. Watson committee member W000794
CHRG-110hhrg51757,Edolphus Towns 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Edolphus Towns committee member T000326
CHRG-110hhrg51757,Elijah E. Cummings 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Elijah E. Cummings committee member C000984
CHRG-110hhrg51757,Henry A. Waxman 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Henry A. Waxman committee member W000215
CHRG-110hhrg51757,Jackie Speier 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Jackie Speier committee member S001175
CHRG-110hhrg51757,Jim Cooper 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Jim Cooper committee member C000754
CHRG-110hhrg51757,Jim Jordan 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Jim Jordan committee member J000289
CHRG-110hhrg51757,John A. Yarmuth 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 John A. Yarmuth committee member Y000062
CHRG-110hhrg51757,John F. Tierney 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 John F. Tierney committee member T000266
CHRG-110hhrg51757,John J. Duncan, Jr. 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 John J. Duncan, Jr. committee member D000533
CHRG-110hhrg51757,John L. Mica 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 John L. Mica committee member M000689
CHRG-110hhrg51757,John M. McHugh 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 John M. McHugh committee member M000472
CHRG-110hhrg51757,John P. Sarbanes 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 John P. Sarbanes committee member S001168
CHRG-110hhrg51757,Kenny Marchant 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Kenny Marchant committee member M001158
CHRG-110hhrg51757,Lynn A. Westmoreland 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Lynn A. Westmoreland committee member W000796
CHRG-110hhrg51757,Mark E. Souder 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Mark E. Souder committee member S001143
CHRG-110hhrg51757,Michael R. Turner 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Michael R. Turner committee member T000463
CHRG-110hhrg51757,Patrick T. McHenry 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Patrick T. McHenry committee member M001156
CHRG-110hhrg51757,Paul E. Kanjorski 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Paul E. Kanjorski committee member K000008
CHRG-110hhrg51757,Paul W. Hodes 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Paul W. Hodes committee member H001043
CHRG-110hhrg51757,Peter Welch 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Peter Welch committee member W000800
CHRG-110hhrg51757,Stephen F. Lynch 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Stephen F. Lynch committee member L000562
CHRG-110hhrg51757,Todd Russell Platts 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Todd Russell Platts committee member P000585
CHRG-110hhrg51757,Tom Davis 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Tom Davis committee member  
CHRG-110hhrg51757,Virginia Foxx 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 Virginia Foxx committee member F000450
CHRG-110hhrg51757,Wm. Lacy Clay 2009 BLUE CROSS BLUE SHIELD HEALTH BENEFIT: WHAT IT MEANS FOR FEDERAL EMPLOYEES CHRG-110hhrg51757 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);