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

51 rows where package_id = "CHRG-115hhrg36617" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

  • committee member 51
Link package_id name ▼ role bioguide_id
CHRG-115hhrg36617,Adam Kinzinger BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Adam Kinzinger committee member K000378
CHRG-115hhrg36617,Anna G. Eshoo BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Anna G. Eshoo committee member E000215
CHRG-115hhrg36617,Ben Ray Lujan BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Ben Ray Lujan committee member  
CHRG-115hhrg36617,Bill Flores BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Bill Flores committee member F000461
CHRG-115hhrg36617,Bill Johnson BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Bill Johnson committee member J000292
CHRG-115hhrg36617,Billy Long BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Billy Long committee member L000576
CHRG-115hhrg36617,Bobby L. Rush BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Bobby L. Rush committee member R000515
CHRG-115hhrg36617,Brett Guthrie BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Brett Guthrie committee member G000558
CHRG-115hhrg36617,Cathy McMorris Rodgers BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Cathy McMorris Rodgers committee member M001159
CHRG-115hhrg36617,Chris Collins BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Chris Collins committee member C001092
CHRG-115hhrg36617,David B. McKinley BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 David B. McKinley committee member M001180
CHRG-115hhrg36617,David Loebsack BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 David Loebsack committee member L000565
CHRG-115hhrg36617,Debbie Dingell BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Debbie Dingell committee member D000624
CHRG-115hhrg36617,Diana DeGette BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Diana DeGette committee member D000197
CHRG-115hhrg36617,Doris O. Matsui BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Doris O. Matsui committee member M001163
CHRG-115hhrg36617,Eliot L. Engel BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Eliot L. Engel committee member E000179
CHRG-115hhrg36617,Frank Pallone, Jr. BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Frank Pallone, Jr. committee member P000034
CHRG-115hhrg36617,Fred Upton BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Fred Upton committee member U000031
CHRG-115hhrg36617,Gene Green BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Gene Green committee member G000410
CHRG-115hhrg36617,Greg Walden BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Greg Walden committee member W000791
CHRG-115hhrg36617,Gregg Harper BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Gregg Harper committee member H001045
CHRG-115hhrg36617,Gus M. Bilirakis BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Gus M. Bilirakis committee member B001257
CHRG-115hhrg36617,Janice D. Schakowsky BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Janice D. Schakowsky committee member S001145
CHRG-115hhrg36617,Jeff Duncan BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Jeff Duncan committee member D000615
CHRG-115hhrg36617,Jerry McNerney BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Jerry McNerney committee member M001166
CHRG-115hhrg36617,Joe Barton BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Joe Barton committee member B000213
CHRG-115hhrg36617,John P. Sarbanes BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 John P. Sarbanes committee member S001168
CHRG-115hhrg36617,John Shimkus BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 John Shimkus committee member S000364
CHRG-115hhrg36617,Kathy Castor BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Kathy Castor committee member C001066
CHRG-115hhrg36617,Kevin Cramer BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Kevin Cramer committee member C001096
CHRG-115hhrg36617,Kurt Schrader BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Kurt Schrader committee member S001180
CHRG-115hhrg36617,Larry Bucshon BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Larry Bucshon committee member B001275
CHRG-115hhrg36617,Leonard Lance BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Leonard Lance committee member L000567
CHRG-115hhrg36617,Markwayne Mullin BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Markwayne Mullin committee member M001190
CHRG-115hhrg36617,Marsha Blackburn BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Marsha Blackburn committee member B001243
CHRG-115hhrg36617,Michael C. Burgess BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Michael C. Burgess committee member B001248
CHRG-115hhrg36617,Michael F. Doyle BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Michael F. Doyle committee member D000482
CHRG-115hhrg36617,Mimi Walters BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Mimi Walters committee member W000820
CHRG-115hhrg36617,Paul Tonko BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Paul Tonko committee member T000469
CHRG-115hhrg36617,Pete Olson BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Pete Olson committee member O000168
CHRG-115hhrg36617,Peter Welch BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Peter Welch committee member W000800
CHRG-115hhrg36617,Raul Ruiz BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Raul Ruiz committee member R000599
CHRG-115hhrg36617,Richard Hudson BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Richard Hudson committee member H001067
CHRG-115hhrg36617,Robert E. Latta BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Robert E. Latta committee member L000566
CHRG-115hhrg36617,Ryan A. Costello BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Ryan A. Costello committee member C001106
CHRG-115hhrg36617,Scott H. Peters BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Scott H. Peters committee member P000608
CHRG-115hhrg36617,Steve Scalise BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Steve Scalise committee member S001176
CHRG-115hhrg36617,Susan W. Brooks BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Susan W. Brooks committee member B001284
CHRG-115hhrg36617,Tim Walberg BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Tim Walberg committee member W000798
CHRG-115hhrg36617,Tony Cardenas BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 Tony Cardenas committee member  
CHRG-115hhrg36617,Yvette D. Clarke BUILT IN AMERICA: JOBS AND GROWTH IN THE MANUFACTURING SECTOR CHRG-115hhrg36617 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 1241.95ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API