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

35 rows where package_id = "CHRG-111hhrg58476" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

  • committee member 35
Link package_id name ▼ role bioguide_id
CHRG-111hhrg58476,Adam B. Schiff REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Adam B. Schiff committee member S001150
CHRG-111hhrg58476,Anthony D. Weiner REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Anthony D. Weiner committee member W000792
CHRG-111hhrg58476,Bill Delahunt REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Bill Delahunt committee member  
CHRG-111hhrg58476,Bob Goodlatte REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Bob Goodlatte committee member G000289
CHRG-111hhrg58476,Charles A. Gonzalez REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Charles A. Gonzalez committee member G000544
CHRG-111hhrg58476,Daniel B. Maffei REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Daniel B. Maffei committee member M001171
CHRG-111hhrg58476,Daniel E. Lungren REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Daniel E. Lungren committee member L000517
CHRG-111hhrg58476,Darrell E. Issa REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Darrell E. Issa committee member I000056
CHRG-111hhrg58476,Elton Gallegly REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Elton Gallegly committee member G000021
CHRG-111hhrg58476,Gregg Harper REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Gregg Harper committee member H001045
CHRG-111hhrg58476,Howard Coble REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Howard Coble committee member C000556
CHRG-111hhrg58476,Howard L. Berman REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Howard L. Berman committee member B000410
CHRG-111hhrg58476,Jared Polis REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Jared Polis committee member P000598
CHRG-111hhrg58476,Jason Chaffetz REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Jason Chaffetz committee member C001076
CHRG-111hhrg58476,Jerrold Nadler REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Jerrold Nadler committee member N000002
CHRG-111hhrg58476,Jim Jordan REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Jim Jordan committee member J000289
CHRG-111hhrg58476,John Conyers, Jr. REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 John Conyers, Jr. committee member C000714
CHRG-111hhrg58476,Judy Chu REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Judy Chu committee member C001080
CHRG-111hhrg58476,Lamar Smith REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Lamar Smith committee member S000583
CHRG-111hhrg58476,Linda T. Sanchez REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Linda T. Sanchez committee member  
CHRG-111hhrg58476,Louie Gohmert REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Louie Gohmert committee member G000552
CHRG-111hhrg58476,Luis V. Gutierrez REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Luis V. Gutierrez committee member  
CHRG-111hhrg58476,Maxine Waters REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Maxine Waters committee member W000187
CHRG-111hhrg58476,Melvin L. Watt REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Melvin L. Watt committee member W000207
CHRG-111hhrg58476,Mike Quigley REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Mike Quigley committee member Q000023
CHRG-111hhrg58476,Rick Boucher REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Rick Boucher committee member  
CHRG-111hhrg58476,Sheila Jackson Lee REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Sheila Jackson Lee committee member J000032
CHRG-111hhrg58476,Steve Cohen REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Steve Cohen committee member C001068
CHRG-111hhrg58476,Steve King REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Steve King committee member K000362
CHRG-111hhrg58476,Tammy Baldwin REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Tammy Baldwin committee member B001230
CHRG-111hhrg58476,Ted Poe REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Ted Poe committee member P000592
CHRG-111hhrg58476,Theodore E. Deutch REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Theodore E. Deutch committee member D000610
CHRG-111hhrg58476,Thomas J. Rooney REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Thomas J. Rooney committee member R000583
CHRG-111hhrg58476,Trent Franks REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Trent Franks committee member F000448
CHRG-111hhrg58476,Zoe Lofgren REINING IN OVERCRIMINALIZATION: ASSESSING THE PROBLEM, PROPOSING SOLUTIONS CHRG-111hhrg58476 Zoe Lofgren committee member L000397

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 4.264ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API