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

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-107hhrg84606,Adam H. Putnam AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Adam H. Putnam committee member P000586
CHRG-107hhrg84606,Benjamin A. Gilman AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Benjamin A. Gilman committee member G000212
CHRG-107hhrg84606,Bernard Sanders AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Bernard Sanders committee member S000033
CHRG-107hhrg84606,Bob Barr AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Bob Barr committee member B000169
CHRG-107hhrg84606,Carolyn B. Maloney AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Carolyn B. Maloney committee member M000087
CHRG-107hhrg84606,Chris Cannon AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Chris Cannon committee member  
CHRG-107hhrg84606,Christopher Shays AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Christopher Shays committee member S001144
CHRG-107hhrg84606,Constance A. Morella AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Constance A. Morella committee member M000941
CHRG-107hhrg84606,Dan Burton AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Dan Burton committee member B001149
CHRG-107hhrg84606,Dan Miller AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Dan Miller committee member M000720
CHRG-107hhrg84606,Danny K. Davis AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Danny K. Davis committee member D000096
CHRG-107hhrg84606,Dave Weldon AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Dave Weldon committee member  
CHRG-107hhrg84606,Dennis J. Kucinich AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Dennis J. Kucinich committee member K000336
CHRG-107hhrg84606,Diane E. Watson AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Diane E. Watson committee member W000794
CHRG-107hhrg84606,Doug Ose AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Doug Ose committee member O000164
CHRG-107hhrg84606,ELEANOR HOLMES NORTON of Washington AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 ELEANOR HOLMES NORTON of Washington committee member  
CHRG-107hhrg84606,Edolphus Towns AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Edolphus Towns committee member T000326
CHRG-107hhrg84606,Edward L. Schrock AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Edward L. Schrock committee member S001151
CHRG-107hhrg84606,Elijah E. Cummings AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Elijah E. Cummings committee member C000984
CHRG-107hhrg84606,Henry A. Waxman AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Henry A. Waxman committee member W000215
CHRG-107hhrg84606,Ileana Ros-Lehtinen AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Ileana Ros-Lehtinen committee member R000435
CHRG-107hhrg84606,Janice D. Schakowsky AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Janice D. Schakowsky committee member S001145
CHRG-107hhrg84606,Jim Turner AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Jim Turner committee member  
CHRG-107hhrg84606,Jo Ann Davis AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Jo Ann Davis committee member D000597
CHRG-107hhrg84606,John F. Tierney AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 John F. Tierney committee member T000266
CHRG-107hhrg84606,John J. Duncan, Jr. AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 John J. Duncan, Jr. committee member D000533
CHRG-107hhrg84606,John L. Mica AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 John L. Mica committee member M000689
CHRG-107hhrg84606,John M. McHugh AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 John M. McHugh committee member M000472
CHRG-107hhrg84606,John Sullivan AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 John Sullivan committee member S001055
CHRG-107hhrg84606,Major R. Owens AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Major R. Owens committee member O000159
CHRG-107hhrg84606,Mark E. Souder AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Mark E. Souder committee member S001143
CHRG-107hhrg84606,Patsy T. Mink AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Patsy T. Mink committee member M000797
CHRG-107hhrg84606,Paul E. Kanjorski AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Paul E. Kanjorski committee member K000008
CHRG-107hhrg84606,Rod R. Blagojevich AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Rod R. Blagojevich committee member B000518
CHRG-107hhrg84606,Ron Lewis AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Ron Lewis committee member L000293
CHRG-107hhrg84606,Stephen F. Lynch AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Stephen F. Lynch committee member L000562
CHRG-107hhrg84606,Stephen Horn AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Stephen Horn committee member H000789
CHRG-107hhrg84606,Steven C. LaTourette AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Steven C. LaTourette committee member L000553
CHRG-107hhrg84606,Thomas H. Allen AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Thomas H. Allen committee member A000147
CHRG-107hhrg84606,Todd Russell Platts AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Todd Russell Platts committee member P000585
CHRG-107hhrg84606,Tom Davis AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Tom Davis committee member  
CHRG-107hhrg84606,Tom Lantos AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 Tom Lantos committee member L000090
CHRG-107hhrg84606,Wm. Lacy Clay AMERICA'S HEROIN CRISIS, COLOMBIAN HEROIN, AND HOW WE CAN IMPROVE PLAN COLOMBIA CHRG-107hhrg84606 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);