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-108hhrg98604" 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-108hhrg98604,Adam H. Putnam THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Adam H. Putnam committee member P000586
CHRG-108hhrg98604,Bernard Sanders THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Bernard Sanders committee member S000033
CHRG-108hhrg98604,Betty McCollum THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Betty McCollum committee member M001143
CHRG-108hhrg98604,Candice S. Miller THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Candice S. Miller committee member M001150
CHRG-108hhrg98604,Carolyn B. Maloney THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Carolyn B. Maloney committee member M000087
CHRG-108hhrg98604,Chris Cannon THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Chris Cannon committee member  
CHRG-108hhrg98604,Chris Van Hollen THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Chris Van Hollen committee member V000128
CHRG-108hhrg98604,Christopher Shays THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Christopher Shays committee member S001144
CHRG-108hhrg98604,Dan Burton THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Dan Burton committee member B001149
CHRG-108hhrg98604,Danny K. Davis THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Danny K. Davis committee member D000096
CHRG-108hhrg98604,Dennis J. Kucinich THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Dennis J. Kucinich committee member K000336
CHRG-108hhrg98604,Diane E. Watson THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Diane E. Watson committee member W000794
CHRG-108hhrg98604,Doug Ose THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Doug Ose committee member O000164
CHRG-108hhrg98604,Edolphus Towns THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Edolphus Towns committee member T000326
CHRG-108hhrg98604,Edward L. Schrock THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Edward L. Schrock committee member S001151
CHRG-108hhrg98604,Elijah E. Cummings THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Elijah E. Cummings committee member C000984
CHRG-108hhrg98604,Henry A. Waxman THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Henry A. Waxman committee member W000215
CHRG-108hhrg98604,Ileana Ros-Lehtinen THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Ileana Ros-Lehtinen committee member R000435
CHRG-108hhrg98604,Jim Cooper THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Jim Cooper committee member C000754
CHRG-108hhrg98604,Jo Ann Davis THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Jo Ann Davis committee member D000597
CHRG-108hhrg98604,John F. Tierney THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 John F. Tierney committee member T000266
CHRG-108hhrg98604,John J. Duncan, Jr. THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 John J. Duncan, Jr. committee member D000533
CHRG-108hhrg98604,John L. Mica THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 John L. Mica committee member M000689
CHRG-108hhrg98604,John M. McHugh THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 John M. McHugh committee member M000472
CHRG-108hhrg98604,John R. Carter THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 John R. Carter committee member C001051
CHRG-108hhrg98604,Katherine Harris THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Katherine Harris committee member H001035
CHRG-108hhrg98604,Linda T. Sanchez THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Linda T. Sanchez committee member  
CHRG-108hhrg98604,Major R. Owens THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Major R. Owens committee member O000159
CHRG-108hhrg98604,Mark E. Souder THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Mark E. Souder committee member S001143
CHRG-108hhrg98604,Marsha Blackburn THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Marsha Blackburn committee member B001243
CHRG-108hhrg98604,Michael R. Turner THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Michael R. Turner committee member T000463
CHRG-108hhrg98604,Nathan Deal THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Nathan Deal committee member D000168
CHRG-108hhrg98604,Patrick J. Tiberi THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Patrick J. Tiberi committee member T000462
CHRG-108hhrg98604,Paul E. Kanjorski THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Paul E. Kanjorski committee member K000008
CHRG-108hhrg98604,Ron Lewis THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Ron Lewis committee member L000293
CHRG-108hhrg98604,Stephen F. Lynch THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Stephen F. Lynch committee member L000562
CHRG-108hhrg98604,Steven C. LaTourette THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Steven C. LaTourette committee member L000553
CHRG-108hhrg98604,Tim Murphy THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Tim Murphy committee member M001151
CHRG-108hhrg98604,Todd Russell Platts THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Todd Russell Platts committee member P000585
CHRG-108hhrg98604,Tom Davis THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Tom Davis committee member  
CHRG-108hhrg98604,Tom Lantos THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 Tom Lantos committee member L000090
CHRG-108hhrg98604,Wm. Lacy Clay THE POISONING OF PARADISE: CRYSTAL METHAMPHETAMINE IN HAWAII CHRG-108hhrg98604 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 28.673ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API