hearing_members

Committee members present at hearings.

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

34 rows where package_id = "CHRG-113hhrg89810" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-113hhrg89810,Blake Farenthold U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Blake Farenthold committee member F000460
CHRG-113hhrg89810,Bob Goodlatte U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Bob Goodlatte committee member G000289
CHRG-113hhrg89810,Cedric L. Richmond U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Cedric L. Richmond committee member R000588
CHRG-113hhrg89810,Darrell E. Issa U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Darrell E. Issa committee member I000056
CHRG-113hhrg89810,David N. Cicilline U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 David N. Cicilline committee member C001084
CHRG-113hhrg89810,Doug Collins U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Doug Collins committee member C001093
CHRG-113hhrg89810,George Holding U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 George Holding committee member H001065
CHRG-113hhrg89810,Hakeem S. Jeffries U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Hakeem S. Jeffries committee member J000294
CHRG-113hhrg89810,Howard Coble U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Howard Coble committee member C000556
CHRG-113hhrg89810,Jason Chaffetz U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Jason Chaffetz committee member C001076
CHRG-113hhrg89810,Jason Smith U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Jason Smith committee member S001195
CHRG-113hhrg89810,Jerrold Nadler U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Jerrold Nadler committee member N000002
CHRG-113hhrg89810,Jim Jordan U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Jim Jordan committee member J000289
CHRG-113hhrg89810,Joe Garcia U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Joe Garcia committee member G000573
CHRG-113hhrg89810,John Conyers, Jr. U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 John Conyers, Jr. committee member C000714
CHRG-113hhrg89810,Judy Chu U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Judy Chu committee member C001080
CHRG-113hhrg89810,Karen Bass U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Karen Bass committee member B001270
CHRG-113hhrg89810,Lamar Smith U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Lamar Smith committee member S000583
CHRG-113hhrg89810,Louie Gohmert U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Louie Gohmert committee member G000552
CHRG-113hhrg89810,Luis V. Gutierrez U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Luis V. Gutierrez committee member  
CHRG-113hhrg89810,Raul R. Labrador U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Raul R. Labrador committee member  
CHRG-113hhrg89810,Ron DeSantis U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Ron DeSantis committee member D000621
CHRG-113hhrg89810,Sheila Jackson Lee U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Sheila Jackson Lee committee member J000032
CHRG-113hhrg89810,Spencer Bachus U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Spencer Bachus committee member B000013
CHRG-113hhrg89810,Steve Chabot U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Steve Chabot committee member C000266
CHRG-113hhrg89810,Steve Cohen U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Steve Cohen committee member C001068
CHRG-113hhrg89810,Steve King U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Steve King committee member K000362
CHRG-113hhrg89810,Suzan K. DelBene U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Suzan K. DelBene committee member D000617
CHRG-113hhrg89810,Ted Poe U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Ted Poe committee member P000592
CHRG-113hhrg89810,Theodore E. Deutch U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Theodore E. Deutch committee member D000610
CHRG-113hhrg89810,Tom Marino U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Tom Marino committee member M001179
CHRG-113hhrg89810,Trent Franks U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Trent Franks committee member F000448
CHRG-113hhrg89810,Trey Gowdy U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Trey Gowdy committee member G000566
CHRG-113hhrg89810,Zoe Lofgren U.S. COPYRIGHT OFFICE CHRG-113hhrg89810 Zoe Lofgren committee member L000397

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