hearing_members

Committee members present at hearings.

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

43 rows where package_id = "CHRG-110hhrg45030" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-110hhrg45030,Carol Shea-Porter BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Carol Shea-Porter committee member S001170
CHRG-110hhrg45030,Carolyn McCarthy BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Carolyn McCarthy committee member M000309
CHRG-110hhrg45030,Cathy McMorris Rodgers BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Cathy McMorris Rodgers committee member M001159
CHRG-110hhrg45030,Dale E. Kildee BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Dale E. Kildee committee member K000172
CHRG-110hhrg45030,Danny K. Davis BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Danny K. Davis committee member D000096
CHRG-110hhrg45030,David Davis BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 David Davis committee member D000097
CHRG-110hhrg45030,David Loebsack BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 David Loebsack committee member L000565
CHRG-110hhrg45030,David Wu BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 David Wu committee member W000793
CHRG-110hhrg45030,Dennis J. Kucinich BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Dennis J. Kucinich committee member K000336
CHRG-110hhrg45030,Donald M. Payne BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Donald M. Payne committee member P000149
CHRG-110hhrg45030,George Miller BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 George Miller committee member M000725
CHRG-110hhrg45030,Jason Altmire BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Jason Altmire committee member A000362
CHRG-110hhrg45030,Joe Courtney BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Joe Courtney committee member C001069
CHRG-110hhrg45030,Joe Sestak BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Joe Sestak committee member S001169
CHRG-110hhrg45030,Joe Wilson BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Joe Wilson committee member W000795
CHRG-110hhrg45030,John A. Yarmuth BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 John A. Yarmuth committee member Y000062
CHRG-110hhrg45030,John F. Tierney BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 John F. Tierney committee member T000266
CHRG-110hhrg45030,John Kline BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 John Kline committee member K000363
CHRG-110hhrg45030,John P. Sarbanes BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 John P. Sarbanes committee member S001168
CHRG-110hhrg45030,Judy Biggert BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Judy Biggert committee member B001232
CHRG-110hhrg45030,Kenny Marchant BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Kenny Marchant committee member M001158
CHRG-110hhrg45030,Linda T. Sanchez BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Linda T. Sanchez committee member  
CHRG-110hhrg45030,Lynn C. Woolsey BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Lynn C. Woolsey committee member W000738
CHRG-110hhrg45030,Mark E. Souder BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Mark E. Souder committee member S001143
CHRG-110hhrg45030,Mazie K. Hirono BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Mazie K. Hirono committee member H001042
CHRG-110hhrg45030,Michael N. Castle BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Michael N. Castle committee member C000243
CHRG-110hhrg45030,Peter Hoekstra BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Peter Hoekstra committee member H000676
CHRG-110hhrg45030,Phil Hare BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Phil Hare committee member H001040
CHRG-110hhrg45030,Raul M. Grijalva BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Raul M. Grijalva committee member  
CHRG-110hhrg45030,Ric Keller BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Ric Keller committee member K000361
CHRG-110hhrg45030,Rob Bishop BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Rob Bishop committee member B001250
CHRG-110hhrg45030,Robert E. Andrews BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Robert E. Andrews committee member A000210
CHRG-110hhrg45030,Ruben Hinojosa BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Ruben Hinojosa committee member  
CHRG-110hhrg45030,Rush Holt BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Rush Holt committee member H000749
CHRG-110hhrg45030,Susan A. Davis BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Susan A. Davis committee member D000598
CHRG-110hhrg45030,Thomas E. Petri BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Thomas E. Petri committee member P000265
CHRG-110hhrg45030,Tim Walberg BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Tim Walberg committee member W000798
CHRG-110hhrg45030,Timothy H. Bishop BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Timothy H. Bishop committee member B001242
CHRG-110hhrg45030,Todd Russell Platts BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Todd Russell Platts committee member P000585
CHRG-110hhrg45030,Tom Price BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Tom Price committee member P000591
CHRG-110hhrg45030,Vernon J. Ehlers BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Vernon J. Ehlers committee member E000092
CHRG-110hhrg45030,Virginia Foxx BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 Virginia Foxx committee member F000450
CHRG-110hhrg45030,Yvette D. Clarke BUILDING AN ECONOMIC RECOVERY PACKAGE: CREATING AND PRESERVING JOBS IN AMERICA CHRG-110hhrg45030 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);