home / openregs

hearing_members

Committee members present at hearings.

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

47 rows where package_id = "CHRG-114jhrg20543" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

  • committee member 47
Link package_id name ▼ role bioguide_id
CHRG-114jhrg20543,Adam Kinzinger FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Adam Kinzinger committee member K000378
CHRG-114jhrg20543,Anna G. Eshoo FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Anna G. Eshoo committee member E000215
CHRG-114jhrg20543,BILL JOHNSON of Missouri FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 BILL JOHNSON of Missouri committee member  
CHRG-114jhrg20543,Ben Ray Lujan FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Ben Ray Lujan committee member  
CHRG-114jhrg20543,Bill Flores FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Bill Flores committee member F000461
CHRG-114jhrg20543,Billy Long FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Billy Long committee member L000576
CHRG-114jhrg20543,Bobby L. Rush FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Bobby L. Rush committee member R000515
CHRG-114jhrg20543,Brett Guthrie FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Brett Guthrie committee member G000558
CHRG-114jhrg20543,Cathy McMorris Rodgers FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Cathy McMorris Rodgers committee member M001159
CHRG-114jhrg20543,David B. McKinley FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 David B. McKinley committee member M001180
CHRG-114jhrg20543,David Loebsack FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 David Loebsack committee member L000565
CHRG-114jhrg20543,Diana DeGette FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Diana DeGette committee member D000197
CHRG-114jhrg20543,Doris O. Matsui FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Doris O. Matsui committee member M001163
CHRG-114jhrg20543,Ed Whitfield FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Ed Whitfield committee member W000413
CHRG-114jhrg20543,Eliot L. Engel FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Eliot L. Engel committee member E000179
CHRG-114jhrg20543,Frank Pallone, Jr. FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Frank Pallone, Jr. committee member P000034
CHRG-114jhrg20543,Fred Upton FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Fred Upton committee member U000031
CHRG-114jhrg20543,Gene Green FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Gene Green committee member G000410
CHRG-114jhrg20543,Greg Walden FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Greg Walden committee member W000791
CHRG-114jhrg20543,Gregg Harper FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Gregg Harper committee member H001045
CHRG-114jhrg20543,Gus M. Bilirakis FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Gus M. Bilirakis committee member B001257
CHRG-114jhrg20543,Janice D. Schakowsky FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Janice D. Schakowsky committee member S001145
CHRG-114jhrg20543,Jerry McNerney FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Jerry McNerney committee member M001166
CHRG-114jhrg20543,Joe Barton FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Joe Barton committee member B000213
CHRG-114jhrg20543,John A. Yarmuth FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 John A. Yarmuth committee member Y000062
CHRG-114jhrg20543,John P. Sarbanes FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 John P. Sarbanes committee member S001168
CHRG-114jhrg20543,John Shimkus FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 John Shimkus committee member S000364
CHRG-114jhrg20543,Joseph R. Pitts FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Joseph R. Pitts committee member P000373
CHRG-114jhrg20543,Kathy Castor FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Kathy Castor committee member C001066
CHRG-114jhrg20543,Kurt Schrader FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Kurt Schrader committee member S001180
CHRG-114jhrg20543,Larry Bucshon FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Larry Bucshon committee member B001275
CHRG-114jhrg20543,Leonard Lance FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Leonard Lance committee member L000567
CHRG-114jhrg20543,Lois Capps FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Lois Capps committee member C001036
CHRG-114jhrg20543,Marsha Blackburn FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Marsha Blackburn committee member B001243
CHRG-114jhrg20543,Michael C. Burgess FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Michael C. Burgess committee member B001248
CHRG-114jhrg20543,Michael F. Doyle FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Michael F. Doyle committee member D000482
CHRG-114jhrg20543,Mike Pompeo FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Mike Pompeo committee member P000602
CHRG-114jhrg20543,Paul Tonko FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Paul Tonko committee member T000469
CHRG-114jhrg20543,Pete Olson FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Pete Olson committee member O000168
CHRG-114jhrg20543,Peter Welch FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Peter Welch committee member W000800
CHRG-114jhrg20543,Renee L. Ellmers FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Renee L. Ellmers committee member E000291
CHRG-114jhrg20543,Robert E. Latta FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Robert E. Latta committee member L000566
CHRG-114jhrg20543,Steve Scalise FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Steve Scalise committee member S001176
CHRG-114jhrg20543,Susan W. Brooks FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Susan W. Brooks committee member B001284
CHRG-114jhrg20543,Tim Murphy FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Tim Murphy committee member M001151
CHRG-114jhrg20543,Tony Cardenas FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Tony Cardenas committee member  
CHRG-114jhrg20543,Yvette D. Clarke FISCAL YEAR 2017 EPA BUDGET CHRG-114jhrg20543 Yvette D. Clarke committee member C001067

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);
Powered by Datasette · Queries took 3.285ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API