hearing_members

Committee members present at hearings.

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

44 rows where package_id = "CHRG-111hhrg48717" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-111hhrg48717,Bill Cassidy WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Bill Cassidy committee member C001075
CHRG-111hhrg48717,Brett Guthrie WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Brett Guthrie committee member G000558
CHRG-111hhrg48717,Carol Shea-Porter WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Carol Shea-Porter committee member S001170
CHRG-111hhrg48717,Carolyn McCarthy WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Carolyn McCarthy committee member M000309
CHRG-111hhrg48717,Cathy McMorris Rodgers WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Cathy McMorris Rodgers committee member M001159
CHRG-111hhrg48717,Dale E. Kildee WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Dale E. Kildee committee member K000172
CHRG-111hhrg48717,David Loebsack WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 David Loebsack committee member L000565
CHRG-111hhrg48717,David P. Roe WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 David P. Roe committee member R000582
CHRG-111hhrg48717,David Wu WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 David Wu committee member W000793
CHRG-111hhrg48717,Dennis J. Kucinich WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Dennis J. Kucinich committee member K000336
CHRG-111hhrg48717,Dina Titus WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Dina Titus committee member T000468
CHRG-111hhrg48717,Donald M. Payne WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Donald M. Payne committee member P000149
CHRG-111hhrg48717,Duncan Hunter WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Duncan Hunter committee member H000981
CHRG-111hhrg48717,George Miller WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 George Miller committee member M000726
CHRG-111hhrg48717,Glenn Thompson WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Glenn Thompson committee member T000467
CHRG-111hhrg48717,Jared Polis WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Jared Polis committee member P000598
CHRG-111hhrg48717,Jason Altmire WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Jason Altmire committee member A000362
CHRG-111hhrg48717,Joe Courtney WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Joe Courtney committee member C001069
CHRG-111hhrg48717,Joe Sestak WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Joe Sestak committee member S001169
CHRG-111hhrg48717,Joe Wilson WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Joe Wilson committee member W000795
CHRG-111hhrg48717,John F. Tierney WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 John F. Tierney committee member T000266
CHRG-111hhrg48717,John Kline WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 John Kline committee member K000363
CHRG-111hhrg48717,Judy Biggert WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Judy Biggert committee member B001232
CHRG-111hhrg48717,Lynn C. Woolsey WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Lynn C. Woolsey committee member W000738
CHRG-111hhrg48717,Marcia L. Fudge WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Marcia L. Fudge committee member F000455
CHRG-111hhrg48717,Mark E. Souder WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Mark E. Souder committee member S001143
CHRG-111hhrg48717,Mazie K. Hirono WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Mazie K. Hirono committee member H001042
CHRG-111hhrg48717,Michael N. Castle WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Michael N. Castle committee member C000243
CHRG-111hhrg48717,Paul Tonko WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Paul Tonko committee member T000469
CHRG-111hhrg48717,Peter Hoekstra WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Peter Hoekstra committee member H000676
CHRG-111hhrg48717,Phil Hare WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Phil Hare committee member H001040
CHRG-111hhrg48717,Raul M. Grijalva WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Raul M. Grijalva committee member  
CHRG-111hhrg48717,Rob Bishop WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Rob Bishop committee member B001250
CHRG-111hhrg48717,Robert E. Andrews WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Robert E. Andrews committee member A000210
CHRG-111hhrg48717,Ruben Hinojosa WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Ruben Hinojosa committee member  
CHRG-111hhrg48717,Rush Holt WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Rush Holt committee member H000749
CHRG-111hhrg48717,Susan A. Davis WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Susan A. Davis committee member D000598
CHRG-111hhrg48717,Thomas E. Petri WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Thomas E. Petri committee member P000265
CHRG-111hhrg48717,Timothy H. Bishop WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Timothy H. Bishop committee member B001242
CHRG-111hhrg48717,Todd Russell Platts WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Todd Russell Platts committee member P000585
CHRG-111hhrg48717,Tom McClintock WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Tom McClintock committee member M001177
CHRG-111hhrg48717,Tom Price WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Tom Price committee member P000591
CHRG-111hhrg48717,Vernon J. Ehlers WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 Vernon J. Ehlers committee member E000092
CHRG-111hhrg48717,Yvette D. Clarke WAYS TO REDUCE THE COST OF HEALTH INSURANCE FOR EMPLOYERS, EMPLOYEES AND THEIR FAMILIES CHRG-111hhrg48717 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);