hearing_members

Committee members present at hearings.

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

51 rows where package_id = "CHRG-112hhrg85564" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-112hhrg85564,Adam Kinzinger THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Adam Kinzinger committee member K000378
CHRG-112hhrg85564,Anna G. Eshoo THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Anna G. Eshoo committee member E000215
CHRG-112hhrg85564,Bill Cassidy THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Bill Cassidy committee member C001075
CHRG-112hhrg85564,Bobby L. Rush THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Bobby L. Rush committee member R000515
CHRG-112hhrg85564,Brett Guthrie THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Brett Guthrie committee member G000558
CHRG-112hhrg85564,Brian P. Bilbray THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Brian P. Bilbray committee member B000461
CHRG-112hhrg85564,Cathy McMorris Rodgers THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Cathy McMorris Rodgers committee member M001159
CHRG-112hhrg85564,Charles A. Gonzalez THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Charles A. Gonzalez committee member G000544
CHRG-112hhrg85564,Charles F. Bass THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Charles F. Bass committee member B000220
CHRG-112hhrg85564,Cliff Stearns THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Cliff Stearns committee member S000822
CHRG-112hhrg85564,Cory Gardner THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Cory Gardner committee member G000562
CHRG-112hhrg85564,David B. McKinley THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 David B. McKinley committee member M001180
CHRG-112hhrg85564,Diana DeGette THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Diana DeGette committee member D000197
CHRG-112hhrg85564,Doris O. Matsui THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Doris O. Matsui committee member M001163
CHRG-112hhrg85564,Ed Whitfield THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Ed Whitfield committee member W000413
CHRG-112hhrg85564,Edolphus Towns THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Edolphus Towns committee member T000326
CHRG-112hhrg85564,Edward J. Markey THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Edward J. Markey committee member M000133
CHRG-112hhrg85564,Eliot L. Engel THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Eliot L. Engel committee member E000179
CHRG-112hhrg85564,Frank Pallone, Jr. THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Frank Pallone, Jr. committee member P000034
CHRG-112hhrg85564,Fred Upton THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Fred Upton committee member U000031
CHRG-112hhrg85564,Gene Green THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Gene Green committee member G000410
CHRG-112hhrg85564,Greg Walden THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Greg Walden committee member W000791
CHRG-112hhrg85564,Gregg Harper THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Gregg Harper committee member H001045
CHRG-112hhrg85564,Henry A. Waxman THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Henry A. Waxman committee member W000215
CHRG-112hhrg85564,Janice D. Schakowsky THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Janice D. Schakowsky committee member S001145
CHRG-112hhrg85564,Jim Matheson THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Jim Matheson committee member M001142
CHRG-112hhrg85564,Joe Barton THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Joe Barton committee member B000213
CHRG-112hhrg85564,John Barrow THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 John Barrow committee member B001252
CHRG-112hhrg85564,John D. Dingell THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 John D. Dingell committee member D000355
CHRG-112hhrg85564,John P. Sarbanes THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 John P. Sarbanes committee member S001168
CHRG-112hhrg85564,John Shimkus THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 John Shimkus committee member S000364
CHRG-112hhrg85564,John Sullivan THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 John Sullivan committee member S001055
CHRG-112hhrg85564,Joseph R. Pitts THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Joseph R. Pitts committee member P000373
CHRG-112hhrg85564,Kathy Castor THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Kathy Castor committee member C001066
CHRG-112hhrg85564,Lee Terry THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Lee Terry committee member T000459
CHRG-112hhrg85564,Leonard Lance THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Leonard Lance committee member L000567
CHRG-112hhrg85564,Lois Capps THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Lois Capps committee member C001036
CHRG-112hhrg85564,Marsha Blackburn THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Marsha Blackburn committee member B001243
CHRG-112hhrg85564,Mary Bono Mack THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Mary Bono Mack committee member B001228
CHRG-112hhrg85564,Michael C. Burgess THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Michael C. Burgess committee member B001248
CHRG-112hhrg85564,Michael F. Doyle THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Michael F. Doyle committee member D000482
CHRG-112hhrg85564,Mike Pompeo THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Mike Pompeo committee member P000602
CHRG-112hhrg85564,Mike Rogers THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Mike Rogers committee member R000572
CHRG-112hhrg85564,Mike Ross THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Mike Ross committee member R000573
CHRG-112hhrg85564,Pete Olson THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Pete Olson committee member O000168
CHRG-112hhrg85564,Phil Gingrey THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Phil Gingrey committee member G000550
CHRG-112hhrg85564,Robert E. Latta THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Robert E. Latta committee member L000566
CHRG-112hhrg85564,Steve Scalise THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Steve Scalise committee member S001176
CHRG-112hhrg85564,Sue Wilkins Myrick THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Sue Wilkins Myrick committee member M001134
CHRG-112hhrg85564,Tammy Baldwin THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Tammy Baldwin committee member B001230
CHRG-112hhrg85564,Tim Murphy THE AMERICAN ENERGY INITIATIVE, PART 29: A FOCUS ON H.R. 6172 CHRG-112hhrg85564 Tim Murphy committee member M001151

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