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-106jhrg63866" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-106jhrg63866,Anthony D. Weiner BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Anthony D. Weiner committee member W000792
CHRG-106jhrg63866,Arlen Specter BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Arlen Specter committee member S000709
CHRG-106jhrg63866,Asa Hutchinson BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Asa Hutchinson committee member H001014
CHRG-106jhrg63866,Barney Frank BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Barney Frank committee member F000339
CHRG-106jhrg63866,Bill Delahunt BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Bill Delahunt committee member  
CHRG-106jhrg63866,Bill McCollum BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Bill McCollum committee member M000350
CHRG-106jhrg63866,Bob Barr BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Bob Barr committee member B000169
CHRG-106jhrg63866,Bob Goodlatte BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Bob Goodlatte committee member G000289
CHRG-106jhrg63866,Charles T. Canady BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Charles T. Canady committee member C000107
CHRG-106jhrg63866,Chris Cannon BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Chris Cannon committee member  
CHRG-106jhrg63866,Chuck Grassley BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Chuck Grassley committee member G000386
CHRG-106jhrg63866,David Vitter BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 David Vitter committee member V000127
CHRG-106jhrg63866,Edward A. Pease BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Edward A. Pease committee member P000171
CHRG-106jhrg63866,Edward M. Kennedy BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Edward M. Kennedy committee member K000105
CHRG-106jhrg63866,Elton Gallegly BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Elton Gallegly committee member G000021
CHRG-106jhrg63866,George W. Gekas BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 George W. Gekas committee member G000121
CHRG-106jhrg63866,Henry J. Hyde BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Henry J. Hyde committee member H001022
CHRG-106jhrg63866,Howard Coble BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Howard Coble committee member C000556
CHRG-106jhrg63866,Howard L. Berman BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Howard L. Berman committee member B000410
CHRG-106jhrg63866,James E. Rogan BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 James E. Rogan committee member R000386
CHRG-106jhrg63866,Jerrold Nadler BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Jerrold Nadler committee member N000002
CHRG-106jhrg63866,Joe Scarborough BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Joe Scarborough committee member S000106
CHRG-106jhrg63866,John Conyers, Jr. BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 John Conyers, Jr. committee member C000714
CHRG-106jhrg63866,Lamar Smith BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Lamar Smith committee member S000583
CHRG-106jhrg63866,Lindsey Graham BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Lindsey Graham committee member G000359
CHRG-106jhrg63866,Martin T. Meehan BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Martin T. Meehan committee member M000627
CHRG-106jhrg63866,Mary Bono Mack BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Mary Bono Mack committee member B001228
CHRG-106jhrg63866,Maxine Waters BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Maxine Waters committee member W000187
CHRG-106jhrg63866,Melvin L. Watt BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Melvin L. Watt committee member W000207
CHRG-106jhrg63866,Orrin G. Hatch BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Orrin G. Hatch committee member H000338
CHRG-106jhrg63866,Patrick J. Leahy BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Patrick J. Leahy committee member L000174
CHRG-106jhrg63866,Rick Boucher BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Rick Boucher committee member  
CHRG-106jhrg63866,Robert C. "Bobby" Scott BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Robert C. "Bobby" Scott committee member S000185
CHRG-106jhrg63866,Robert Wexler BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Robert Wexler committee member W000314
CHRG-106jhrg63866,SHEILA JACKSON LEE of Texas BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 SHEILA JACKSON LEE of Texas committee member  
CHRG-106jhrg63866,Spencer Bachus BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Spencer Bachus committee member B000013
CHRG-106jhrg63866,Steve Chabot BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Steve Chabot committee member C000266
CHRG-106jhrg63866,Steven R. Rothman BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Steven R. Rothman committee member R000462
CHRG-106jhrg63866,Strom Thurmond BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Strom Thurmond committee member  
CHRG-106jhrg63866,Tammy Baldwin BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 Tammy Baldwin committee member B001230
CHRG-106jhrg63866,William L. Jenkins BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 William L. Jenkins committee member J000082
CHRG-106jhrg63866,Zoe Lofgren BANKRUPTCY JUDGESHIP NEEDS CHRG-106jhrg63866 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);