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-110hhrg51701" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

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