hearing_members

Committee members present at hearings.

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

16 rows where package_id = "CHRG-115hhrg33476" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-115hhrg33476,Bradley Byrne [H.A.S.C. No. 115-120]CONTRIBUTING FACTORS TO C-130 MISHAPS AND OTHER INTRA-THEATER AIRLIFT CHALLENGES CHRG-115hhrg33476 Bradley Byrne committee member B001289
CHRG-115hhrg33476,Colleen Hanabusa [H.A.S.C. No. 115-120]CONTRIBUTING FACTORS TO C-130 MISHAPS AND OTHER INTRA-THEATER AIRLIFT CHALLENGES CHRG-115hhrg33476 Colleen Hanabusa committee member H001050
CHRG-115hhrg33476,Donald Norcross [H.A.S.C. No. 115-120]CONTRIBUTING FACTORS TO C-130 MISHAPS AND OTHER INTRA-THEATER AIRLIFT CHALLENGES CHRG-115hhrg33476 Donald Norcross committee member N000188
CHRG-115hhrg33476,James R. Langevin [H.A.S.C. No. 115-120]CONTRIBUTING FACTORS TO C-130 MISHAPS AND OTHER INTRA-THEATER AIRLIFT CHALLENGES CHRG-115hhrg33476 James R. Langevin committee member L000559
CHRG-115hhrg33476,Joe Courtney [H.A.S.C. No. 115-120]CONTRIBUTING FACTORS TO C-130 MISHAPS AND OTHER INTRA-THEATER AIRLIFT CHALLENGES CHRG-115hhrg33476 Joe Courtney committee member C001069
CHRG-115hhrg33476,John Garamendi [H.A.S.C. No. 115-120]CONTRIBUTING FACTORS TO C-130 MISHAPS AND OTHER INTRA-THEATER AIRLIFT CHALLENGES CHRG-115hhrg33476 John Garamendi committee member G000559
CHRG-115hhrg33476,Mike Gallagher [H.A.S.C. No. 115-120]CONTRIBUTING FACTORS TO C-130 MISHAPS AND OTHER INTRA-THEATER AIRLIFT CHALLENGES CHRG-115hhrg33476 Mike Gallagher committee member G000579
CHRG-115hhrg33476,Paul Cook [H.A.S.C. No. 115-120]CONTRIBUTING FACTORS TO C-130 MISHAPS AND OTHER INTRA-THEATER AIRLIFT CHALLENGES CHRG-115hhrg33476 Paul Cook committee member C001094
CHRG-115hhrg33476,Paul Mitchell [H.A.S.C. No. 115-120]CONTRIBUTING FACTORS TO C-130 MISHAPS AND OTHER INTRA-THEATER AIRLIFT CHALLENGES CHRG-115hhrg33476 Paul Mitchell committee member M001201
CHRG-115hhrg33476,Ralph Lee Abraham [H.A.S.C. No. 115-120]CONTRIBUTING FACTORS TO C-130 MISHAPS AND OTHER INTRA-THEATER AIRLIFT CHALLENGES CHRG-115hhrg33476 Ralph Lee Abraham committee member A000374
CHRG-115hhrg33476,Robert J. Wittman [H.A.S.C. No. 115-120]CONTRIBUTING FACTORS TO C-130 MISHAPS AND OTHER INTRA-THEATER AIRLIFT CHALLENGES CHRG-115hhrg33476 Robert J. Wittman committee member W000804
CHRG-115hhrg33476,Scott DesJarlais [H.A.S.C. No. 115-120]CONTRIBUTING FACTORS TO C-130 MISHAPS AND OTHER INTRA-THEATER AIRLIFT CHALLENGES CHRG-115hhrg33476 Scott DesJarlais committee member D000616
CHRG-115hhrg33476,Seth Moulton [H.A.S.C. No. 115-120]CONTRIBUTING FACTORS TO C-130 MISHAPS AND OTHER INTRA-THEATER AIRLIFT CHALLENGES CHRG-115hhrg33476 Seth Moulton committee member M001196
CHRG-115hhrg33476,Stephen Knight [H.A.S.C. No. 115-120]CONTRIBUTING FACTORS TO C-130 MISHAPS AND OTHER INTRA-THEATER AIRLIFT CHALLENGES CHRG-115hhrg33476 Stephen Knight committee member K000387
CHRG-115hhrg33476,Susan A. Davis [H.A.S.C. No. 115-120]CONTRIBUTING FACTORS TO C-130 MISHAPS AND OTHER INTRA-THEATER AIRLIFT CHALLENGES CHRG-115hhrg33476 Susan A. Davis committee member D000598
CHRG-115hhrg33476,Vicky Hartzler [H.A.S.C. No. 115-120]CONTRIBUTING FACTORS TO C-130 MISHAPS AND OTHER INTRA-THEATER AIRLIFT CHALLENGES CHRG-115hhrg33476 Vicky Hartzler committee member H001053

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