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-107jhrg75899" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-107jhrg75899,Adam H. Putnam THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Adam H. Putnam committee member P000586
CHRG-107jhrg75899,Benjamin A. Gilman THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Benjamin A. Gilman committee member G000212
CHRG-107jhrg75899,Bernard Sanders THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Bernard Sanders committee member S000033
CHRG-107jhrg75899,Bob Barr THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Bob Barr committee member B000169
CHRG-107jhrg75899,Carolyn B. Maloney THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Carolyn B. Maloney committee member M000087
CHRG-107jhrg75899,Chris Cannon THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Chris Cannon committee member  
CHRG-107jhrg75899,Christopher Shays THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Christopher Shays committee member S001144
CHRG-107jhrg75899,Constance A. Morella THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Constance A. Morella committee member M000941
CHRG-107jhrg75899,Dan Burton THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Dan Burton committee member B001149
CHRG-107jhrg75899,Dan Miller THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Dan Miller committee member M000720
CHRG-107jhrg75899,Danny K. Davis THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Danny K. Davis committee member D000096
CHRG-107jhrg75899,Dave Weldon THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Dave Weldon committee member  
CHRG-107jhrg75899,Dennis J. Kucinich THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Dennis J. Kucinich committee member K000336
CHRG-107jhrg75899,Doug Ose THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Doug Ose committee member O000164
CHRG-107jhrg75899,ELEANOR HOLMES NORTON of Washington THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 ELEANOR HOLMES NORTON of Washington committee member  
CHRG-107jhrg75899,Edolphus Towns THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Edolphus Towns committee member T000326
CHRG-107jhrg75899,Edward L. Schrock THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Edward L. Schrock committee member S001151
CHRG-107jhrg75899,Elijah E. Cummings THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Elijah E. Cummings committee member C000984
CHRG-107jhrg75899,Henry A. Waxman THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Henry A. Waxman committee member W000215
CHRG-107jhrg75899,Ileana Ros-Lehtinen THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Ileana Ros-Lehtinen committee member R000435
CHRG-107jhrg75899,Janice D. Schakowsky THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Janice D. Schakowsky committee member S001145
CHRG-107jhrg75899,Jim Turner THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Jim Turner committee member  
CHRG-107jhrg75899,Jo Ann Davis THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Jo Ann Davis committee member D000597
CHRG-107jhrg75899,Joe Scarborough THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Joe Scarborough committee member S000106
CHRG-107jhrg75899,John F. Tierney THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 John F. Tierney committee member T000266
CHRG-107jhrg75899,John L. Mica THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 John L. Mica committee member M000689
CHRG-107jhrg75899,John M. McHugh THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 John M. McHugh committee member M000472
CHRG-107jhrg75899,Major R. Owens THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Major R. Owens committee member O000159
CHRG-107jhrg75899,Mark E. Souder THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Mark E. Souder committee member S001143
CHRG-107jhrg75899,Patsy T. Mink THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Patsy T. Mink committee member M000797
CHRG-107jhrg75899,Paul E. Kanjorski THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Paul E. Kanjorski committee member K000008
CHRG-107jhrg75899,Rod R. Blagojevich THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Rod R. Blagojevich committee member B000518
CHRG-107jhrg75899,Ron Lewis THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Ron Lewis committee member L000293
CHRG-107jhrg75899,Stephen Horn THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Stephen Horn committee member H000789
CHRG-107jhrg75899,Steven C. LaTourette THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Steven C. LaTourette committee member L000553
CHRG-107jhrg75899,Thomas H. Allen THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Thomas H. Allen committee member A000147
CHRG-107jhrg75899,Todd Russell Platts THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Todd Russell Platts committee member P000585
CHRG-107jhrg75899,Tom Davis THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Tom Davis committee member  
CHRG-107jhrg75899,Tom Lantos THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 Tom Lantos committee member L000090
CHRG-107jhrg75899,Wm. Lacy Clay THE OUTLOOK FOR THE DISTRICT OF COLUMBIA GOVERNMENT: THE POST-CONTROL BOARD PERIOD CHRG-107jhrg75899 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);