hearing_members

Committee members present at hearings.

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

37 rows where package_id = "CHRG-114hhrg23485" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-114hhrg23485,Blake Farenthold VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Blake Farenthold committee member F000460
CHRG-114hhrg23485,Bonnie Watson Coleman VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Bonnie Watson Coleman committee member W000822
CHRG-114hhrg23485,Brenda L. Lawrence VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Brenda L. Lawrence committee member L000581
CHRG-114hhrg23485,Brendan F. Boyle VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Brendan F. Boyle committee member B001296
CHRG-114hhrg23485,Carolyn B. Maloney VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Carolyn B. Maloney committee member M000087
CHRG-114hhrg23485,Cynthia M. Lummis VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Cynthia M. Lummis committee member L000571
CHRG-114hhrg23485,Elijah E. Cummings VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Elijah E. Cummings committee member C000984
CHRG-114hhrg23485,Gary J. Palmer VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Gary J. Palmer committee member P000609
CHRG-114hhrg23485,Gerald E. Connolly VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Gerald E. Connolly committee member C001078
CHRG-114hhrg23485,Glenn Grothman VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Glenn Grothman committee member G000576
CHRG-114hhrg23485,Jason Chaffetz VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Jason Chaffetz committee member C001076
CHRG-114hhrg23485,Jim Cooper VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Jim Cooper committee member C000754
CHRG-114hhrg23485,Jim Jordan VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Jim Jordan committee member J000289
CHRG-114hhrg23485,Jody B. Hice VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Jody B. Hice committee member H001071
CHRG-114hhrg23485,John L. Mica VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 John L. Mica committee member M000689
CHRG-114hhrg23485,Justin Amash VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Justin Amash committee member A000367
CHRG-114hhrg23485,Ken Buck VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Ken Buck committee member B001297
CHRG-114hhrg23485,Mark DeSaulnier VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Mark DeSaulnier committee member D000623
CHRG-114hhrg23485,Mark Meadows VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Mark Meadows committee member M001187
CHRG-114hhrg23485,Mark Walker VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Mark Walker committee member W000819
CHRG-114hhrg23485,Michael R. Turner VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Michael R. Turner committee member T000463
CHRG-114hhrg23485,Michelle Lujan Grisham VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Michelle Lujan Grisham committee member L000580
CHRG-114hhrg23485,Paul A. Gosar VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Paul A. Gosar committee member G000565
CHRG-114hhrg23485,Peter Welch VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Peter Welch committee member W000800
CHRG-114hhrg23485,ROD BLUM of Massachusetts VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 ROD BLUM of Massachusetts committee member  
CHRG-114hhrg23485,Robin L. Kelly VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Robin L. Kelly committee member K000385
CHRG-114hhrg23485,Ron DeSantis VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Ron DeSantis committee member D000621
CHRG-114hhrg23485,Scott DesJarlais VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Scott DesJarlais committee member D000616
CHRG-114hhrg23485,Stephen F. Lynch VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Stephen F. Lynch committee member L000562
CHRG-114hhrg23485,Steve Russell VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Steve Russell committee member R000604
CHRG-114hhrg23485,Tammy Duckworth VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Tammy Duckworth committee member D000622
CHRG-114hhrg23485,Ted Lieu VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Ted Lieu committee member L000582
CHRG-114hhrg23485,Thomas Massie VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Thomas Massie committee member M001184
CHRG-114hhrg23485,Tim Walberg VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Tim Walberg committee member W000798
CHRG-114hhrg23485,Trey Gowdy VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Trey Gowdy committee member G000566
CHRG-114hhrg23485,Will Hurd VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Will Hurd committee member H001073
CHRG-114hhrg23485,Wm. Lacy Clay VACANT FEDERAL PROPERTIES CHRG-114hhrg23485 Wm. Lacy Clay committee member C001049

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