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

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

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

  • committee member 43
Link package_id name ▼ role bioguide_id
CHRG-106hhrg73924,Asa Hutchinson ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Asa Hutchinson committee member H001014
CHRG-106hhrg73924,Benjamin A. Gilman ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Benjamin A. Gilman committee member G000212
CHRG-106hhrg73924,Bernard Sanders ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Bernard Sanders committee member S000033
CHRG-106hhrg73924,Bob Barr ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Bob Barr committee member B000169
CHRG-106hhrg73924,Carolyn B. Maloney ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Carolyn B. Maloney committee member M000087
CHRG-106hhrg73924,Chaka Fattah ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Chaka Fattah committee member F000043
CHRG-106hhrg73924,Christopher Shays ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Christopher Shays committee member S001144
CHRG-106hhrg73924,Constance A. Morella ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Constance A. Morella committee member M000941
CHRG-106hhrg73924,Dan Burton ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Dan Burton committee member B001149
CHRG-106hhrg73924,Dan Miller ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Dan Miller committee member M000720
CHRG-106hhrg73924,Danny K. Davis ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Danny K. Davis committee member D000096
CHRG-106hhrg73924,David M. McIntosh ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 David M. McIntosh committee member M000481
CHRG-106hhrg73924,David Vitter ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 David Vitter committee member V000127
CHRG-106hhrg73924,Dennis J. Kucinich ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Dennis J. Kucinich committee member K000336
CHRG-106hhrg73924,Doug Ose ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Doug Ose committee member O000164
CHRG-106hhrg73924,ELEANOR HOLMES NORTON of Washington ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 ELEANOR HOLMES NORTON of Washington committee member  
CHRG-106hhrg73924,Edolphus Towns ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Edolphus Towns committee member T000326
CHRG-106hhrg73924,Elijah E. Cummings ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Elijah E. Cummings committee member C000984
CHRG-106hhrg73924,Greg Walden ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Greg Walden committee member W000791
CHRG-106hhrg73924,Harold E. Ford Jr. ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Harold E. Ford Jr. committee member  
CHRG-106hhrg73924,Helen Chenoweth-Hage ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Helen Chenoweth-Hage committee member C000345
CHRG-106hhrg73924,Henry A. Waxman ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Henry A. Waxman committee member W000215
CHRG-106hhrg73924,Ileana Ros-Lehtinen ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Ileana Ros-Lehtinen committee member R000435
CHRG-106hhrg73924,Janice D. Schakowsky ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Janice D. Schakowsky committee member S001145
CHRG-106hhrg73924,Jim Turner ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Jim Turner committee member  
CHRG-106hhrg73924,Joe Scarborough ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Joe Scarborough committee member S000106
CHRG-106hhrg73924,John F. Tierney ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 John F. Tierney committee member T000266
CHRG-106hhrg73924,John L. Mica ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 John L. Mica committee member M000689
CHRG-106hhrg73924,John M. McHugh ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 John M. McHugh committee member M000472
CHRG-106hhrg73924,Judy Biggert ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Judy Biggert committee member B001232
CHRG-106hhrg73924,Lee Terry ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Lee Terry committee member T000459
CHRG-106hhrg73924,Major R. Owens ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Major R. Owens committee member O000159
CHRG-106hhrg73924,Mark E. Souder ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Mark E. Souder committee member S001143
CHRG-106hhrg73924,Patsy T. Mink ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Patsy T. Mink committee member M000797
CHRG-106hhrg73924,Paul D. Ryan ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Paul D. Ryan committee member R000570
CHRG-106hhrg73924,Paul E. Kanjorski ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Paul E. Kanjorski committee member K000008
CHRG-106hhrg73924,Robert E. Wise Jr. ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Robert E. Wise Jr. committee member  
CHRG-106hhrg73924,Rod R. Blagojevich ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Rod R. Blagojevich committee member B000518
CHRG-106hhrg73924,Stephen Horn ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Stephen Horn committee member H000789
CHRG-106hhrg73924,Steven C. LaTourette ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Steven C. LaTourette committee member L000553
CHRG-106hhrg73924,Thomas H. Allen ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Thomas H. Allen committee member A000147
CHRG-106hhrg73924,Tom Davis ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 Tom Davis committee member  
CHRG-106hhrg73924,Tom Lantos ACCUTANE--IS THIS ACNE DRUG TREATMENT LINKED TO DEPRESSION AND SUICIDE? CHRG-106hhrg73924 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);
CREATE INDEX idx_hearing_members_package ON hearing_members(package_id);
Powered by Datasette · Queries took 80.912ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API