hearing_members

Committee members present at hearings.

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

43 rows where package_id = "CHRG-108hhrg87737" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-108hhrg87737,Barbara Cubin H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Barbara Cubin committee member C000962
CHRG-108hhrg87737,Betty McCollum H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Betty McCollum committee member M001143
CHRG-108hhrg87737,Brad Carson H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Brad Carson committee member C001044
CHRG-108hhrg87737,Calvin M. Dooley H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Calvin M. Dooley committee member D000424
CHRG-108hhrg87737,Chris Cannon H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Chris Cannon committee member  
CHRG-108hhrg87737,Ciro D. Rodriguez H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Ciro D. Rodriguez committee member R000568
CHRG-108hhrg87737,Dale E. Kildee H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Dale E. Kildee committee member K000172
CHRG-108hhrg87737,Dennis A. Cardoza H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Dennis A. Cardoza committee member C001050
CHRG-108hhrg87737,Denny Rehberg H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Denny Rehberg committee member R000571
CHRG-108hhrg87737,Devin Nunes H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Devin Nunes committee member N000181
CHRG-108hhrg87737,Don Young H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Don Young committee member Y000033
CHRG-108hhrg87737,Edward J. Markey H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Edward J. Markey committee member M000133
CHRG-108hhrg87737,Elton Gallegly H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Elton Gallegly committee member G000021
CHRG-108hhrg87737,Frank Pallone, Jr. H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Frank Pallone, Jr. committee member P000034
CHRG-108hhrg87737,George Miller H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 George Miller committee member M000726
CHRG-108hhrg87737,George Radanovich H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 George Radanovich committee member R000004
CHRG-108hhrg87737,Grace F. Napolitano H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Grace F. Napolitano committee member N000179
CHRG-108hhrg87737,Greg Walden H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Greg Walden committee member W000791
CHRG-108hhrg87737,Jeff Flake H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Jeff Flake committee member F000444
CHRG-108hhrg87737,Jim Gibbons H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Jim Gibbons committee member  
CHRG-108hhrg87737,Jim Saxton H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Jim Saxton committee member  
CHRG-108hhrg87737,Joe Baca H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Joe Baca committee member B001234
CHRG-108hhrg87737,John E. Peterson H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 John E. Peterson committee member P000262
CHRG-108hhrg87737,John J. Duncan, Jr. H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 John J. Duncan, Jr. committee member D000533
CHRG-108hhrg87737,Ken Calvert H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Ken Calvert committee member C000059
CHRG-108hhrg87737,Mark E. Souder H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Mark E. Souder committee member S001143
CHRG-108hhrg87737,Mark Udall H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Mark Udall committee member U000038
CHRG-108hhrg87737,Neil Abercrombie H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Neil Abercrombie committee member A000014
CHRG-108hhrg87737,Nick J. Rahall II H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Nick J. Rahall II committee member R000011
CHRG-108hhrg87737,Raul M. Grijalva H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Raul M. Grijalva committee member  
CHRG-108hhrg87737,Richard W. Pombo H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Richard W. Pombo committee member P000419
CHRG-108hhrg87737,Rick Renzi H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Rick Renzi committee member R000574
CHRG-108hhrg87737,Rob Bishop H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Rob Bishop committee member B001250
CHRG-108hhrg87737,Ron Kind H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Ron Kind committee member K000188
CHRG-108hhrg87737,Ruben Hinojosa H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Ruben Hinojosa committee member  
CHRG-108hhrg87737,Scott McInnis H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Scott McInnis committee member M000477
CHRG-108hhrg87737,Solomon P. Ortiz H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Solomon P. Ortiz committee member O000107
CHRG-108hhrg87737,Stevan Pearce H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Stevan Pearce committee member P000588
CHRG-108hhrg87737,Thomas G. Tancredo H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Thomas G. Tancredo committee member T000458
CHRG-108hhrg87737,Tom Cole H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Tom Cole committee member C001053
CHRG-108hhrg87737,Tom Osborne H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Tom Osborne committee member  
CHRG-108hhrg87737,Tom Udall H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 Tom Udall committee member U000039
CHRG-108hhrg87737,Wayne T. Gilchrest H.R. 1616 and H.R. 1964 CHRG-108hhrg87737 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);