hearing_members

Committee members present at hearings.

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

20 rows where package_id = "CHRG-110hhrg44612" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-110hhrg44612,Bill Delahunt FEDERAL, STATE, AND LOCAL EFFORTS TO PREPARE FOR THE 2008 ELECTION CHRG-110hhrg44612 Bill Delahunt committee member  
CHRG-110hhrg44612,Bob Goodlatte FEDERAL, STATE, AND LOCAL EFFORTS TO PREPARE FOR THE 2008 ELECTION CHRG-110hhrg44612 Bob Goodlatte committee member G000289
CHRG-110hhrg44612,Chris Cannon FEDERAL, STATE, AND LOCAL EFFORTS TO PREPARE FOR THE 2008 ELECTION CHRG-110hhrg44612 Chris Cannon committee member  
CHRG-110hhrg44612,Daniel E. Lungren FEDERAL, STATE, AND LOCAL EFFORTS TO PREPARE FOR THE 2008 ELECTION CHRG-110hhrg44612 Daniel E. Lungren committee member L000517
CHRG-110hhrg44612,Darrell E. Issa FEDERAL, STATE, AND LOCAL EFFORTS TO PREPARE FOR THE 2008 ELECTION CHRG-110hhrg44612 Darrell E. Issa committee member I000056
CHRG-110hhrg44612,Elton Gallegly FEDERAL, STATE, AND LOCAL EFFORTS TO PREPARE FOR THE 2008 ELECTION CHRG-110hhrg44612 Elton Gallegly committee member G000021
CHRG-110hhrg44612,Howard Coble FEDERAL, STATE, AND LOCAL EFFORTS TO PREPARE FOR THE 2008 ELECTION CHRG-110hhrg44612 Howard Coble committee member C000556
CHRG-110hhrg44612,Howard L. Berman FEDERAL, STATE, AND LOCAL EFFORTS TO PREPARE FOR THE 2008 ELECTION CHRG-110hhrg44612 Howard L. Berman committee member B000410
CHRG-110hhrg44612,Jerrold Nadler FEDERAL, STATE, AND LOCAL EFFORTS TO PREPARE FOR THE 2008 ELECTION CHRG-110hhrg44612 Jerrold Nadler committee member N000002
CHRG-110hhrg44612,John Conyers, Jr. FEDERAL, STATE, AND LOCAL EFFORTS TO PREPARE FOR THE 2008 ELECTION CHRG-110hhrg44612 John Conyers, Jr. committee member C000714
CHRG-110hhrg44612,Lamar Smith FEDERAL, STATE, AND LOCAL EFFORTS TO PREPARE FOR THE 2008 ELECTION CHRG-110hhrg44612 Lamar Smith committee member S000583
CHRG-110hhrg44612,Linda T. Sanchez FEDERAL, STATE, AND LOCAL EFFORTS TO PREPARE FOR THE 2008 ELECTION CHRG-110hhrg44612 Linda T. Sanchez committee member  
CHRG-110hhrg44612,Maxine Waters FEDERAL, STATE, AND LOCAL EFFORTS TO PREPARE FOR THE 2008 ELECTION CHRG-110hhrg44612 Maxine Waters committee member W000187
CHRG-110hhrg44612,Melvin L. Watt FEDERAL, STATE, AND LOCAL EFFORTS TO PREPARE FOR THE 2008 ELECTION CHRG-110hhrg44612 Melvin L. Watt committee member W000207
CHRG-110hhrg44612,Ric Keller FEDERAL, STATE, AND LOCAL EFFORTS TO PREPARE FOR THE 2008 ELECTION CHRG-110hhrg44612 Ric Keller committee member K000361
CHRG-110hhrg44612,Rick Boucher FEDERAL, STATE, AND LOCAL EFFORTS TO PREPARE FOR THE 2008 ELECTION CHRG-110hhrg44612 Rick Boucher committee member  
CHRG-110hhrg44612,Robert Wexler FEDERAL, STATE, AND LOCAL EFFORTS TO PREPARE FOR THE 2008 ELECTION CHRG-110hhrg44612 Robert Wexler committee member W000314
CHRG-110hhrg44612,Sheila Jackson Lee FEDERAL, STATE, AND LOCAL EFFORTS TO PREPARE FOR THE 2008 ELECTION CHRG-110hhrg44612 Sheila Jackson Lee committee member J000032
CHRG-110hhrg44612,Steve Chabot FEDERAL, STATE, AND LOCAL EFFORTS TO PREPARE FOR THE 2008 ELECTION CHRG-110hhrg44612 Steve Chabot committee member C000266
CHRG-110hhrg44612,Zoe Lofgren FEDERAL, STATE, AND LOCAL EFFORTS TO PREPARE FOR THE 2008 ELECTION CHRG-110hhrg44612 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);