hearing_members

Committee members present at hearings.

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

44 rows where package_id = "CHRG-107hhrg80969" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-107hhrg80969,Adam Smith H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Adam Smith committee member S000510
CHRG-107hhrg80969,Barbara Cubin H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Barbara Cubin committee member C000962
CHRG-107hhrg80969,Betty McCollum H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Betty McCollum committee member M001143
CHRG-107hhrg80969,Bob Schaffer H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Bob Schaffer committee member S000112
CHRG-107hhrg80969,Brad Carson H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Brad Carson committee member C001044
CHRG-107hhrg80969,Calvin M. Dooley H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Calvin M. Dooley committee member D000424
CHRG-107hhrg80969,Chris Cannon H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Chris Cannon committee member  
CHRG-107hhrg80969,Dale E. Kildee H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Dale E. Kildee committee member K000172
CHRG-107hhrg80969,Denny Rehberg H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Denny Rehberg committee member R000571
CHRG-107hhrg80969,Don Young H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Don Young committee member Y000033
CHRG-107hhrg80969,Edward J. Markey H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Edward J. Markey committee member M000133
CHRG-107hhrg80969,Elton Gallegly H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Elton Gallegly committee member G000021
CHRG-107hhrg80969,Frank Pallone, Jr. H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Frank Pallone, Jr. committee member P000034
CHRG-107hhrg80969,George Miller H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 George Miller committee member M000725
CHRG-107hhrg80969,George Radanovich H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 George Radanovich committee member R000004
CHRG-107hhrg80969,Grace F. Napolitano H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Grace F. Napolitano committee member N000179
CHRG-107hhrg80969,Greg Walden H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Greg Walden committee member W000791
CHRG-107hhrg80969,Hilda L. Solis H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Hilda L. Solis committee member S001153
CHRG-107hhrg80969,James V. Hansen H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 James V. Hansen committee member H000172
CHRG-107hhrg80969,Jay Inslee H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Jay Inslee committee member I000026
CHRG-107hhrg80969,Jeff Flake H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Jeff Flake committee member F000444
CHRG-107hhrg80969,Jim Gibbons H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Jim Gibbons committee member  
CHRG-107hhrg80969,Jim Saxton H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Jim Saxton committee member  
CHRG-107hhrg80969,Joel Hefley H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Joel Hefley committee member H000444
CHRG-107hhrg80969,John E. Peterson H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 John E. Peterson committee member P000262
CHRG-107hhrg80969,John J. Duncan, Jr. H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 John J. Duncan, Jr. committee member D000533
CHRG-107hhrg80969,Ken Calvert H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Ken Calvert committee member C000059
CHRG-107hhrg80969,Mac Thornberry H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Mac Thornberry committee member T000238
CHRG-107hhrg80969,Mark E. Souder H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Mark E. Souder committee member S001143
CHRG-107hhrg80969,Mark Udall H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Mark Udall committee member U000038
CHRG-107hhrg80969,Michael K. Simpson H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Michael K. Simpson committee member S001148
CHRG-107hhrg80969,Neil Abercrombie H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Neil Abercrombie committee member A000014
CHRG-107hhrg80969,Nick J. Rahall II H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Nick J. Rahall II committee member R000011
CHRG-107hhrg80969,Peter A. DeFazio H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Peter A. DeFazio committee member D000191
CHRG-107hhrg80969,Richard W. Pombo H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Richard W. Pombo committee member P000419
CHRG-107hhrg80969,Ron Kind H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Ron Kind committee member K000188
CHRG-107hhrg80969,Rush Holt H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Rush Holt committee member H000749
CHRG-107hhrg80969,Scott McInnis H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Scott McInnis committee member M000477
CHRG-107hhrg80969,Solomon P. Ortiz H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Solomon P. Ortiz committee member O000107
CHRG-107hhrg80969,Thomas G. Tancredo H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Thomas G. Tancredo committee member T000458
CHRG-107hhrg80969,Tim Holden H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Tim Holden committee member H000712
CHRG-107hhrg80969,Tom Osborne H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Tom Osborne committee member  
CHRG-107hhrg80969,Tom Udall H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 Tom Udall committee member U000039
CHRG-107hhrg80969,Wayne T. Gilchrest H.R. 5032 and H.R. 5180 CHRG-107hhrg80969 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);
CREATE INDEX idx_hearing_members_package ON hearing_members(package_id);