home / openregs

hearing_members

Committee members present at hearings.

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

23 rows where package_id = "CHRG-112hhrg76215" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

  • committee member 23
Link package_id name ▼ role bioguide_id
CHRG-112hhrg76215,Bill Shuster [H.A.S.C. No. 112-154] F-22 PILOT PHYSIOLOGICAL ISSUES CHRG-112hhrg76215 Bill Shuster committee member S001154
CHRG-112hhrg76215,Doug Lamborn [H.A.S.C. No. 112-154] F-22 PILOT PHYSIOLOGICAL ISSUES CHRG-112hhrg76215 Doug Lamborn committee member L000564
CHRG-112hhrg76215,Frank A. LoBiondo [H.A.S.C. No. 112-154] F-22 PILOT PHYSIOLOGICAL ISSUES CHRG-112hhrg76215 Frank A. LoBiondo committee member L000554
CHRG-112hhrg76215,Jackie Speier [H.A.S.C. No. 112-154] F-22 PILOT PHYSIOLOGICAL ISSUES CHRG-112hhrg76215 Jackie Speier committee member S001175
CHRG-112hhrg76215,Jim Cooper [H.A.S.C. No. 112-154] F-22 PILOT PHYSIOLOGICAL ISSUES CHRG-112hhrg76215 Jim Cooper committee member C000754
CHRG-112hhrg76215,Joe Wilson [H.A.S.C. No. 112-154] F-22 PILOT PHYSIOLOGICAL ISSUES CHRG-112hhrg76215 Joe Wilson committee member W000795
CHRG-112hhrg76215,John Garamendi [H.A.S.C. No. 112-154] F-22 PILOT PHYSIOLOGICAL ISSUES CHRG-112hhrg76215 John Garamendi committee member G000559
CHRG-112hhrg76215,Jon Runyan [H.A.S.C. No. 112-154] F-22 PILOT PHYSIOLOGICAL ISSUES CHRG-112hhrg76215 Jon Runyan committee member R000594
CHRG-112hhrg76215,Kathleen C. Hochul [H.A.S.C. No. 112-154] F-22 PILOT PHYSIOLOGICAL ISSUES CHRG-112hhrg76215 Kathleen C. Hochul committee member H001062
CHRG-112hhrg76215,Larry Kissell [H.A.S.C. No. 112-154] F-22 PILOT PHYSIOLOGICAL ISSUES CHRG-112hhrg76215 Larry Kissell committee member K000369
CHRG-112hhrg76215,Mark S. Critz [H.A.S.C. No. 112-154] F-22 PILOT PHYSIOLOGICAL ISSUES CHRG-112hhrg76215 Mark S. Critz committee member C001081
CHRG-112hhrg76215,Martha Roby [H.A.S.C. No. 112-154] F-22 PILOT PHYSIOLOGICAL ISSUES CHRG-112hhrg76215 Martha Roby committee member R000591
CHRG-112hhrg76215,Martin Heinrich [H.A.S.C. No. 112-154] F-22 PILOT PHYSIOLOGICAL ISSUES CHRG-112hhrg76215 Martin Heinrich committee member H001046
CHRG-112hhrg76215,Michael R. Turner [H.A.S.C. No. 112-154] F-22 PILOT PHYSIOLOGICAL ISSUES CHRG-112hhrg76215 Michael R. Turner committee member T000463
CHRG-112hhrg76215,Mike McIntyre [H.A.S.C. No. 112-154] F-22 PILOT PHYSIOLOGICAL ISSUES CHRG-112hhrg76215 Mike McIntyre committee member M000485
CHRG-112hhrg76215,Niki Tsongas [H.A.S.C. No. 112-154] F-22 PILOT PHYSIOLOGICAL ISSUES CHRG-112hhrg76215 Niki Tsongas committee member T000465
CHRG-112hhrg76215,Roscoe G. Bartlett [H.A.S.C. No. 112-154] F-22 PILOT PHYSIOLOGICAL ISSUES CHRG-112hhrg76215 Roscoe G. Bartlett committee member B000208
CHRG-112hhrg76215,Silvestre Reyes [H.A.S.C. No. 112-154] F-22 PILOT PHYSIOLOGICAL ISSUES CHRG-112hhrg76215 Silvestre Reyes committee member R000170
CHRG-112hhrg76215,Thomas J. Rooney [H.A.S.C. No. 112-154] F-22 PILOT PHYSIOLOGICAL ISSUES CHRG-112hhrg76215 Thomas J. Rooney committee member R000583
CHRG-112hhrg76215,Todd Russell Platts [H.A.S.C. No. 112-154] F-22 PILOT PHYSIOLOGICAL ISSUES CHRG-112hhrg76215 Todd Russell Platts committee member P000585
CHRG-112hhrg76215,Vicky Hartzler [H.A.S.C. No. 112-154] F-22 PILOT PHYSIOLOGICAL ISSUES CHRG-112hhrg76215 Vicky Hartzler committee member H001053
CHRG-112hhrg76215,Walter B. Jones [H.A.S.C. No. 112-154] F-22 PILOT PHYSIOLOGICAL ISSUES CHRG-112hhrg76215 Walter B. Jones committee member J000255
CHRG-112hhrg76215,William L. Owens [H.A.S.C. No. 112-154] F-22 PILOT PHYSIOLOGICAL ISSUES CHRG-112hhrg76215 William L. Owens committee member O000169

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);
Powered by Datasette · Queries took 403.749ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API