home / openregs

hearing_members

Committee members present at hearings.

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

42 rows where package_id = "CHRG-107hhrg89163" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

  • committee member 42
Link package_id name ▼ role bioguide_id
CHRG-107hhrg89163,Adam H. Putnam VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Adam H. Putnam committee member P000586
CHRG-107hhrg89163,Benjamin A. Gilman VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Benjamin A. Gilman committee member G000212
CHRG-107hhrg89163,Bernard Sanders VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Bernard Sanders committee member S000033
CHRG-107hhrg89163,Bob Barr VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Bob Barr committee member B000169
CHRG-107hhrg89163,Carolyn B. Maloney VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Carolyn B. Maloney committee member M000087
CHRG-107hhrg89163,Chris Cannon VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Chris Cannon committee member  
CHRG-107hhrg89163,Christopher Shays VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Christopher Shays committee member S001144
CHRG-107hhrg89163,Constance A. Morella VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Constance A. Morella committee member M000941
CHRG-107hhrg89163,Dan Burton VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Dan Burton committee member B001149
CHRG-107hhrg89163,Dan Miller VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Dan Miller committee member M000720
CHRG-107hhrg89163,Danny K. Davis VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Danny K. Davis committee member D000096
CHRG-107hhrg89163,Dave Weldon VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Dave Weldon committee member  
CHRG-107hhrg89163,Dennis J. Kucinich VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Dennis J. Kucinich committee member K000336
CHRG-107hhrg89163,Diane E. Watson VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Diane E. Watson committee member W000794
CHRG-107hhrg89163,Doug Ose VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Doug Ose committee member O000164
CHRG-107hhrg89163,ELEANOR HOLMES NORTON of Washington VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 ELEANOR HOLMES NORTON of Washington committee member  
CHRG-107hhrg89163,Edolphus Towns VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Edolphus Towns committee member T000326
CHRG-107hhrg89163,Edward L. Schrock VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Edward L. Schrock committee member S001151
CHRG-107hhrg89163,Elijah E. Cummings VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Elijah E. Cummings committee member C000984
CHRG-107hhrg89163,Henry A. Waxman VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Henry A. Waxman committee member W000215
CHRG-107hhrg89163,Ileana Ros-Lehtinen VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Ileana Ros-Lehtinen committee member R000435
CHRG-107hhrg89163,Janice D. Schakowsky VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Janice D. Schakowsky committee member S001145
CHRG-107hhrg89163,Jim Turner VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Jim Turner committee member  
CHRG-107hhrg89163,Jo Ann Davis VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Jo Ann Davis committee member D000597
CHRG-107hhrg89163,John F. Tierney VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 John F. Tierney committee member T000266
CHRG-107hhrg89163,John J. Duncan, Jr. VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 John J. Duncan, Jr. committee member D000533
CHRG-107hhrg89163,John L. Mica VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 John L. Mica committee member M000689
CHRG-107hhrg89163,John M. McHugh VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 John M. McHugh committee member M000472
CHRG-107hhrg89163,John Sullivan VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 John Sullivan committee member S001055
CHRG-107hhrg89163,Major R. Owens VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Major R. Owens committee member O000159
CHRG-107hhrg89163,Mark E. Souder VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Mark E. Souder committee member S001143
CHRG-107hhrg89163,Paul E. Kanjorski VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Paul E. Kanjorski committee member K000008
CHRG-107hhrg89163,Rod R. Blagojevich VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Rod R. Blagojevich committee member B000518
CHRG-107hhrg89163,Ron Lewis VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Ron Lewis committee member L000293
CHRG-107hhrg89163,Stephen F. Lynch VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Stephen F. Lynch committee member L000562
CHRG-107hhrg89163,Stephen Horn VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Stephen Horn committee member H000789
CHRG-107hhrg89163,Steven C. LaTourette VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Steven C. LaTourette committee member L000553
CHRG-107hhrg89163,Thomas H. Allen VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Thomas H. Allen committee member A000147
CHRG-107hhrg89163,Todd Russell Platts VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Todd Russell Platts committee member P000585
CHRG-107hhrg89163,Tom Davis VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Tom Davis committee member  
CHRG-107hhrg89163,Tom Lantos VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 Tom Lantos committee member L000090
CHRG-107hhrg89163,Wm. Lacy Clay VA HEALTH CARE: ACCESS DELAYED, ACCESS DENIED CHRG-107hhrg89163 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);
Powered by Datasette · Queries took 251.211ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API