hearing_members

Committee members present at hearings.

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

17 rows where package_id = "CHRG-114hhrg22458" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-114hhrg22458,Bradley Byrne [H.A.S.C. No. 114-140] SEAPOWER AND PROJECTION FORCES IN THE SOUTH CHINA SEA CHRG-114hhrg22458 Bradley Byrne committee member B001289
CHRG-114hhrg22458,Duncan Hunter [H.A.S.C. No. 114-140] SEAPOWER AND PROJECTION FORCES IN THE SOUTH CHINA SEA CHRG-114hhrg22458 Duncan Hunter committee member H000981
CHRG-114hhrg22458,Gwen Graham [H.A.S.C. No. 114-140] SEAPOWER AND PROJECTION FORCES IN THE SOUTH CHINA SEA CHRG-114hhrg22458 Gwen Graham committee member G000575
CHRG-114hhrg22458,Jackie Walorski [H.A.S.C. No. 114-140] SEAPOWER AND PROJECTION FORCES IN THE SOUTH CHINA SEA CHRG-114hhrg22458 Jackie Walorski committee member W000813
CHRG-114hhrg22458,James R. Langevin [H.A.S.C. No. 114-140] SEAPOWER AND PROJECTION FORCES IN THE SOUTH CHINA SEA CHRG-114hhrg22458 James R. Langevin committee member L000559
CHRG-114hhrg22458,Jim Bridenstine [H.A.S.C. No. 114-140] SEAPOWER AND PROJECTION FORCES IN THE SOUTH CHINA SEA CHRG-114hhrg22458 Jim Bridenstine committee member B001283
CHRG-114hhrg22458,Joe Courtney [H.A.S.C. No. 114-140] SEAPOWER AND PROJECTION FORCES IN THE SOUTH CHINA SEA CHRG-114hhrg22458 Joe Courtney committee member C001069
CHRG-114hhrg22458,Paul Cook [H.A.S.C. No. 114-140] SEAPOWER AND PROJECTION FORCES IN THE SOUTH CHINA SEA CHRG-114hhrg22458 Paul Cook committee member C001094
CHRG-114hhrg22458,Rick Larsen [H.A.S.C. No. 114-140] SEAPOWER AND PROJECTION FORCES IN THE SOUTH CHINA SEA CHRG-114hhrg22458 Rick Larsen committee member L000560
CHRG-114hhrg22458,Robert J. Wittman [H.A.S.C. No. 114-140] SEAPOWER AND PROJECTION FORCES IN THE SOUTH CHINA SEA CHRG-114hhrg22458 Robert J. Wittman committee member W000804
CHRG-114hhrg22458,Ryan K. Zinke [H.A.S.C. No. 114-140] SEAPOWER AND PROJECTION FORCES IN THE SOUTH CHINA SEA CHRG-114hhrg22458 Ryan K. Zinke committee member Z000018
CHRG-114hhrg22458,Scott H. Peters [H.A.S.C. No. 114-140] SEAPOWER AND PROJECTION FORCES IN THE SOUTH CHINA SEA CHRG-114hhrg22458 Scott H. Peters committee member P000608
CHRG-114hhrg22458,Seth Moulton [H.A.S.C. No. 114-140] SEAPOWER AND PROJECTION FORCES IN THE SOUTH CHINA SEA CHRG-114hhrg22458 Seth Moulton committee member M001196
CHRG-114hhrg22458,Stephen Knight [H.A.S.C. No. 114-140] SEAPOWER AND PROJECTION FORCES IN THE SOUTH CHINA SEA CHRG-114hhrg22458 Stephen Knight committee member K000387
CHRG-114hhrg22458,Steve Russell [H.A.S.C. No. 114-140] SEAPOWER AND PROJECTION FORCES IN THE SOUTH CHINA SEA CHRG-114hhrg22458 Steve Russell committee member R000604
CHRG-114hhrg22458,Tulsi Gabbard [H.A.S.C. No. 114-140] SEAPOWER AND PROJECTION FORCES IN THE SOUTH CHINA SEA CHRG-114hhrg22458 Tulsi Gabbard committee member G000571
CHRG-114hhrg22458,Vicky Hartzler [H.A.S.C. No. 114-140] SEAPOWER AND PROJECTION FORCES IN THE SOUTH CHINA SEA CHRG-114hhrg22458 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);
CREATE INDEX idx_hearing_members_package ON hearing_members(package_id);