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-112hhrg86287" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

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