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-108jhrg85090" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-108jhrg85090,Anthony D. Weiner SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Anthony D. Weiner committee member W000792
CHRG-108jhrg85090,Bart Gordon SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Bart Gordon committee member  
CHRG-108jhrg85090,Brad Miller SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Brad Miller committee member M001154
CHRG-108jhrg85090,Brad Sherman SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Brad Sherman committee member S000344
CHRG-108jhrg85090,Brian Baird SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Brian Baird committee member B001229
CHRG-108jhrg85090,Chris Bell SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Chris Bell committee member B001241
CHRG-108jhrg85090,Curt Weldon SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Curt Weldon committee member  
CHRG-108jhrg85090,Dana Rohrabacher SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Dana Rohrabacher committee member R000409
CHRG-108jhrg85090,David Wu SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 David Wu committee member W000793
CHRG-108jhrg85090,Dennis A. Cardoza SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Dennis A. Cardoza committee member C001050
CHRG-108jhrg85090,Dennis Moore SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Dennis Moore committee member M001140
CHRG-108jhrg85090,Eddie Bernice Johnson SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Eddie Bernice Johnson committee member J000126
CHRG-108jhrg85090,Frank D. Lucas SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Frank D. Lucas committee member L000491
CHRG-108jhrg85090,Gil Gutknecht SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Gil Gutknecht committee member  
CHRG-108jhrg85090,Jerry F. Costello SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Jerry F. Costello committee member C000794
CHRG-108jhrg85090,Jim Matheson SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Jim Matheson committee member M001142
CHRG-108jhrg85090,Jo Bonner SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Jo Bonner committee member B001244
CHRG-108jhrg85090,Joe Barton SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Joe Barton committee member B000213
CHRG-108jhrg85090,John B. Larson SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 John B. Larson committee member L000557
CHRG-108jhrg85090,John Sullivan SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 John Sullivan committee member S001055
CHRG-108jhrg85090,Judy Biggert SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Judy Biggert committee member B001232
CHRG-108jhrg85090,Ken Calvert SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Ken Calvert committee member C000059
CHRG-108jhrg85090,Lamar Smith SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Lamar Smith committee member S000583
CHRG-108jhrg85090,Lincoln Davis SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Lincoln Davis committee member D000599
CHRG-108jhrg85090,Lynn C. Woolsey SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Lynn C. Woolsey committee member W000738
CHRG-108jhrg85090,Mark Udall SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Mark Udall committee member U000038
CHRG-108jhrg85090,Melissa A. Hart SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Melissa A. Hart committee member H001033
CHRG-108jhrg85090,Michael C. Burgess SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Michael C. Burgess committee member B001248
CHRG-108jhrg85090,Michael M. Honda SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Michael M. Honda committee member H001034
CHRG-108jhrg85090,Nick Lampson SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Nick Lampson committee member  
CHRG-108jhrg85090,Nick Smith SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Nick Smith committee member S000597
CHRG-108jhrg85090,Phil Gingrey SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Phil Gingrey committee member G000550
CHRG-108jhrg85090,Ralph M. Hall SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Ralph M. Hall committee member H000067
CHRG-108jhrg85090,Rob Bishop SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Rob Bishop committee member B001250
CHRG-108jhrg85090,Roscoe G. Bartlett SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Roscoe G. Bartlett committee member B000208
CHRG-108jhrg85090,SHEILA JACKSON LEE of Texas SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 SHEILA JACKSON LEE of Texas committee member  
CHRG-108jhrg85090,Sherwood Boehlert SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Sherwood Boehlert committee member B000586
CHRG-108jhrg85090,Timothy V. Johnson SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Timothy V. Johnson committee member J000285
CHRG-108jhrg85090,Tom Feeney SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Tom Feeney committee member F000447
CHRG-108jhrg85090,Vernon J. Ehlers SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Vernon J. Ehlers committee member E000092
CHRG-108jhrg85090,Wayne T. Gilchrest SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 Wayne T. Gilchrest committee member G000180
CHRG-108jhrg85090,Zoe Lofgren SPACE SHUTTLE COLUMBIA CHRG-108jhrg85090 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);