hearing_members

Committee members present at hearings.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

41 rows where package_id = "CHRG-109hhrg31026" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-109hhrg31026,Al Green H.R. 50 CHRG-109hhrg31026 Al Green committee member G000553
CHRG-109hhrg31026,Bart Gordon H.R. 50 CHRG-109hhrg31026 Bart Gordon committee member  
CHRG-109hhrg31026,Bob Inglis H.R. 50 CHRG-109hhrg31026 Bob Inglis committee member I000023
CHRG-109hhrg31026,Brad Miller H.R. 50 CHRG-109hhrg31026 Brad Miller committee member M001154
CHRG-109hhrg31026,Brad Sherman H.R. 50 CHRG-109hhrg31026 Brad Sherman committee member S000344
CHRG-109hhrg31026,Brian Baird H.R. 50 CHRG-109hhrg31026 Brian Baird committee member B001229
CHRG-109hhrg31026,Charlie Melancon H.R. 50 CHRG-109hhrg31026 Charlie Melancon committee member  
CHRG-109hhrg31026,Curt Weldon H.R. 50 CHRG-109hhrg31026 Curt Weldon committee member  
CHRG-109hhrg31026,Dana Rohrabacher H.R. 50 CHRG-109hhrg31026 Dana Rohrabacher committee member R000409
CHRG-109hhrg31026,Daniel Lipinski H.R. 50 CHRG-109hhrg31026 Daniel Lipinski committee member L000563
CHRG-109hhrg31026,Darlene Hooley H.R. 50 CHRG-109hhrg31026 Darlene Hooley committee member H000762
CHRG-109hhrg31026,David G. Reichert H.R. 50 CHRG-109hhrg31026 David G. Reichert committee member R000578
CHRG-109hhrg31026,David Wu H.R. 50 CHRG-109hhrg31026 David Wu committee member W000793
CHRG-109hhrg31026,Dennis Moore H.R. 50 CHRG-109hhrg31026 Dennis Moore committee member M001140
CHRG-109hhrg31026,Doris O. Matsui H.R. 50 CHRG-109hhrg31026 Doris O. Matsui committee member M001163
CHRG-109hhrg31026,Eddie Bernice Johnson H.R. 50 CHRG-109hhrg31026 Eddie Bernice Johnson committee member J000126
CHRG-109hhrg31026,Frank D. Lucas H.R. 50 CHRG-109hhrg31026 Frank D. Lucas committee member L000491
CHRG-109hhrg31026,Gil Gutknecht H.R. 50 CHRG-109hhrg31026 Gil Gutknecht committee member  
CHRG-109hhrg31026,Jerry F. Costello H.R. 50 CHRG-109hhrg31026 Jerry F. Costello committee member C000794
CHRG-109hhrg31026,Jim Costa H.R. 50 CHRG-109hhrg31026 Jim Costa committee member C001059
CHRG-109hhrg31026,Jim Matheson H.R. 50 CHRG-109hhrg31026 Jim Matheson committee member M001142
CHRG-109hhrg31026,Jo Bonner H.R. 50 CHRG-109hhrg31026 Jo Bonner committee member B001244
CHRG-109hhrg31026,Judy Biggert H.R. 50 CHRG-109hhrg31026 Judy Biggert committee member B001232
CHRG-109hhrg31026,Ken Calvert H.R. 50 CHRG-109hhrg31026 Ken Calvert committee member C000059
CHRG-109hhrg31026,Lamar Smith H.R. 50 CHRG-109hhrg31026 Lamar Smith committee member S000583
CHRG-109hhrg31026,Lincoln Davis H.R. 50 CHRG-109hhrg31026 Lincoln Davis committee member D000599
CHRG-109hhrg31026,Lynn C. Woolsey H.R. 50 CHRG-109hhrg31026 Lynn C. Woolsey committee member W000738
CHRG-109hhrg31026,Mario Diaz-Balart H.R. 50 CHRG-109hhrg31026 Mario Diaz-Balart committee member D000600
CHRG-109hhrg31026,Mark Udall H.R. 50 CHRG-109hhrg31026 Mark Udall committee member U000038
CHRG-109hhrg31026,Michael E. Sodrel H.R. 50 CHRG-109hhrg31026 Michael E. Sodrel committee member S001160
CHRG-109hhrg31026,Michael M. Honda H.R. 50 CHRG-109hhrg31026 Michael M. Honda committee member H001034
CHRG-109hhrg31026,Michael T. McCaul H.R. 50 CHRG-109hhrg31026 Michael T. McCaul committee member M001157
CHRG-109hhrg31026,Ralph M. Hall H.R. 50 CHRG-109hhrg31026 Ralph M. Hall committee member H000067
CHRG-109hhrg31026,Randy Neugebauer H.R. 50 CHRG-109hhrg31026 Randy Neugebauer committee member N000182
CHRG-109hhrg31026,Roscoe G. Bartlett H.R. 50 CHRG-109hhrg31026 Roscoe G. Bartlett committee member B000208
CHRG-109hhrg31026,Sheila Jackson Lee H.R. 50 CHRG-109hhrg31026 Sheila Jackson Lee committee member J000032
CHRG-109hhrg31026,Sherwood Boehlert H.R. 50 CHRG-109hhrg31026 Sherwood Boehlert committee member B000586
CHRG-109hhrg31026,Timothy V. Johnson H.R. 50 CHRG-109hhrg31026 Timothy V. Johnson committee member J000285
CHRG-109hhrg31026,Tom Feeney H.R. 50 CHRG-109hhrg31026 Tom Feeney committee member F000447
CHRG-109hhrg31026,Vernon J. Ehlers H.R. 50 CHRG-109hhrg31026 Vernon J. Ehlers committee member E000092
CHRG-109hhrg31026,Wayne T. Gilchrest H.R. 50 CHRG-109hhrg31026 Wayne T. Gilchrest committee member G000180

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);