hearing_members

Committee members present at hearings.

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

43 rows where package_id = "CHRG-106hhrg74099" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-106hhrg74099,Asa Hutchinson POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Asa Hutchinson committee member H001014
CHRG-106hhrg74099,Benjamin A. Gilman POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Benjamin A. Gilman committee member G000212
CHRG-106hhrg74099,Bernard Sanders POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Bernard Sanders committee member S000033
CHRG-106hhrg74099,Bob Barr POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Bob Barr committee member B000169
CHRG-106hhrg74099,Carolyn B. Maloney POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Carolyn B. Maloney committee member M000087
CHRG-106hhrg74099,Chaka Fattah POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Chaka Fattah committee member F000043
CHRG-106hhrg74099,Christopher Shays POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Christopher Shays committee member S001144
CHRG-106hhrg74099,Constance A. Morella POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Constance A. Morella committee member M000941
CHRG-106hhrg74099,Dan Burton POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Dan Burton committee member B001149
CHRG-106hhrg74099,Dan Miller POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Dan Miller committee member M000720
CHRG-106hhrg74099,Danny K. Davis POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Danny K. Davis committee member D000096
CHRG-106hhrg74099,David M. McIntosh POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 David M. McIntosh committee member M000481
CHRG-106hhrg74099,David Vitter POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 David Vitter committee member V000127
CHRG-106hhrg74099,Dennis J. Kucinich POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Dennis J. Kucinich committee member K000336
CHRG-106hhrg74099,Doug Ose POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Doug Ose committee member O000164
CHRG-106hhrg74099,ELEANOR HOLMES NORTON of Washington POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 ELEANOR HOLMES NORTON of Washington committee member  
CHRG-106hhrg74099,Edolphus Towns POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Edolphus Towns committee member T000326
CHRG-106hhrg74099,Elijah E. Cummings POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Elijah E. Cummings committee member C000984
CHRG-106hhrg74099,Greg Walden POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Greg Walden committee member W000791
CHRG-106hhrg74099,Harold E. Ford Jr. POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Harold E. Ford Jr. committee member  
CHRG-106hhrg74099,Helen Chenoweth-Hage POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Helen Chenoweth-Hage committee member C000345
CHRG-106hhrg74099,Henry A. Waxman POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Henry A. Waxman committee member W000215
CHRG-106hhrg74099,Ileana Ros-Lehtinen POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Ileana Ros-Lehtinen committee member R000435
CHRG-106hhrg74099,Janice D. Schakowsky POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Janice D. Schakowsky committee member S001145
CHRG-106hhrg74099,Jim Turner POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Jim Turner committee member  
CHRG-106hhrg74099,Joe Scarborough POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Joe Scarborough committee member S000106
CHRG-106hhrg74099,John F. Tierney POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 John F. Tierney committee member T000266
CHRG-106hhrg74099,John L. Mica POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 John L. Mica committee member M000689
CHRG-106hhrg74099,John M. McHugh POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 John M. McHugh committee member M000472
CHRG-106hhrg74099,Judy Biggert POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Judy Biggert committee member B001232
CHRG-106hhrg74099,Lee Terry POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Lee Terry committee member T000459
CHRG-106hhrg74099,Major R. Owens POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Major R. Owens committee member O000159
CHRG-106hhrg74099,Mark E. Souder POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Mark E. Souder committee member S001143
CHRG-106hhrg74099,Patsy T. Mink POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Patsy T. Mink committee member M000797
CHRG-106hhrg74099,Paul D. Ryan POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Paul D. Ryan committee member R000570
CHRG-106hhrg74099,Paul E. Kanjorski POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Paul E. Kanjorski committee member K000008
CHRG-106hhrg74099,Robert E. Wise Jr. POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Robert E. Wise Jr. committee member  
CHRG-106hhrg74099,Rod R. Blagojevich POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Rod R. Blagojevich committee member B000518
CHRG-106hhrg74099,Stephen Horn POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Stephen Horn committee member H000789
CHRG-106hhrg74099,Steven C. LaTourette POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Steven C. LaTourette committee member L000553
CHRG-106hhrg74099,Thomas H. Allen POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Thomas H. Allen committee member A000147
CHRG-106hhrg74099,Tom Davis POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Tom Davis committee member  
CHRG-106hhrg74099,Tom Lantos POTENTIAL ENERGY CRISIS IN THE WINTER OF 2000 CHRG-106hhrg74099 Tom Lantos committee member L000090

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);