hearing_members

Committee members present at hearings.

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

22 rows where package_id = "CHRG-110hhrg38190" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-110hhrg38190,Alcee L. Hastings CLASSIFICATION OF NATIONAL SECURITY INFORMATION CHRG-110hhrg38190 Alcee L. Hastings committee member H000324
CHRG-110hhrg38190,Anna G. Eshoo CLASSIFICATION OF NATIONAL SECURITY INFORMATION CHRG-110hhrg38190 Anna G. Eshoo committee member E000215
CHRG-110hhrg38190,Darrell E. Issa CLASSIFICATION OF NATIONAL SECURITY INFORMATION CHRG-110hhrg38190 Darrell E. Issa committee member I000056
CHRG-110hhrg38190,Elton Gallegly CLASSIFICATION OF NATIONAL SECURITY INFORMATION CHRG-110hhrg38190 Elton Gallegly committee member G000021
CHRG-110hhrg38190,Heather Wilson CLASSIFICATION OF NATIONAL SECURITY INFORMATION CHRG-110hhrg38190 Heather Wilson committee member W000789
CHRG-110hhrg38190,James R. Langevin CLASSIFICATION OF NATIONAL SECURITY INFORMATION CHRG-110hhrg38190 James R. Langevin committee member L000559
CHRG-110hhrg38190,Janice D. Schakowsky CLASSIFICATION OF NATIONAL SECURITY INFORMATION CHRG-110hhrg38190 Janice D. Schakowsky committee member S001145
CHRG-110hhrg38190,John A. Boehner CLASSIFICATION OF NATIONAL SECURITY INFORMATION CHRG-110hhrg38190 John A. Boehner committee member B000589
CHRG-110hhrg38190,John F. Tierney CLASSIFICATION OF NATIONAL SECURITY INFORMATION CHRG-110hhrg38190 John F. Tierney committee member T000266
CHRG-110hhrg38190,John M. McHugh CLASSIFICATION OF NATIONAL SECURITY INFORMATION CHRG-110hhrg38190 John M. McHugh committee member M000472
CHRG-110hhrg38190,Leonard L. Boswell CLASSIFICATION OF NATIONAL SECURITY INFORMATION CHRG-110hhrg38190 Leonard L. Boswell committee member B000652
CHRG-110hhrg38190,Mac Thornberry CLASSIFICATION OF NATIONAL SECURITY INFORMATION CHRG-110hhrg38190 Mac Thornberry committee member T000238
CHRG-110hhrg38190,Mike Rogers CLASSIFICATION OF NATIONAL SECURITY INFORMATION CHRG-110hhrg38190 Mike Rogers committee member R000575
CHRG-110hhrg38190,Mike Thompson CLASSIFICATION OF NATIONAL SECURITY INFORMATION CHRG-110hhrg38190 Mike Thompson committee member T000460
CHRG-110hhrg38190,Nancy Pelosi CLASSIFICATION OF NATIONAL SECURITY INFORMATION CHRG-110hhrg38190 Nancy Pelosi committee member P000197
CHRG-110hhrg38190,Patrick J. Murphy CLASSIFICATION OF NATIONAL SECURITY INFORMATION CHRG-110hhrg38190 Patrick J. Murphy committee member M001168
CHRG-110hhrg38190,Peter Hoekstra CLASSIFICATION OF NATIONAL SECURITY INFORMATION CHRG-110hhrg38190 Peter Hoekstra committee member H000676
CHRG-110hhrg38190,Robert E. (Bud) Cramer Jr. CLASSIFICATION OF NATIONAL SECURITY INFORMATION CHRG-110hhrg38190 Robert E. (Bud) Cramer Jr. committee member  
CHRG-110hhrg38190,Rush Holt CLASSIFICATION OF NATIONAL SECURITY INFORMATION CHRG-110hhrg38190 Rush Holt committee member H000749
CHRG-110hhrg38190,Silvestre Reyes CLASSIFICATION OF NATIONAL SECURITY INFORMATION CHRG-110hhrg38190 Silvestre Reyes committee member R000170
CHRG-110hhrg38190,Terry Everett CLASSIFICATION OF NATIONAL SECURITY INFORMATION CHRG-110hhrg38190 Terry Everett committee member E000268
CHRG-110hhrg38190,Todd Tiahrt CLASSIFICATION OF NATIONAL SECURITY INFORMATION CHRG-110hhrg38190 Todd Tiahrt committee member T000260

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