hearing_members

Committee members present at hearings.

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

18 rows where package_id = "CHRG-114hhrg22460" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-114hhrg22460,Bill Shuster [H.A.S.C. No. 114-142] Department of Defense Laboratories: Innovation Through Science and Engineering In Support of Military Operations CHRG-114hhrg22460 Bill Shuster committee member S001154
CHRG-114hhrg22460,Brad Ashford [H.A.S.C. No. 114-142] Department of Defense Laboratories: Innovation Through Science and Engineering In Support of Military Operations CHRG-114hhrg22460 Brad Ashford committee member A000373
CHRG-114hhrg22460,Bradley Byrne [H.A.S.C. No. 114-142] Department of Defense Laboratories: Innovation Through Science and Engineering In Support of Military Operations CHRG-114hhrg22460 Bradley Byrne committee member B001289
CHRG-114hhrg22460,Donald Norcross [H.A.S.C. No. 114-142] Department of Defense Laboratories: Innovation Through Science and Engineering In Support of Military Operations CHRG-114hhrg22460 Donald Norcross committee member N000188
CHRG-114hhrg22460,Doug Lamborn [H.A.S.C. No. 114-142] Department of Defense Laboratories: Innovation Through Science and Engineering In Support of Military Operations CHRG-114hhrg22460 Doug Lamborn committee member L000564
CHRG-114hhrg22460,Duncan Hunter [H.A.S.C. No. 114-142] Department of Defense Laboratories: Innovation Through Science and Engineering In Support of Military Operations CHRG-114hhrg22460 Duncan Hunter committee member H000981
CHRG-114hhrg22460,Elise M. Stefanik [H.A.S.C. No. 114-142] Department of Defense Laboratories: Innovation Through Science and Engineering In Support of Military Operations CHRG-114hhrg22460 Elise M. Stefanik committee member S001196
CHRG-114hhrg22460,James R. Langevin [H.A.S.C. No. 114-142] Department of Defense Laboratories: Innovation Through Science and Engineering In Support of Military Operations CHRG-114hhrg22460 James R. Langevin committee member L000559
CHRG-114hhrg22460,Jim Cooper [H.A.S.C. No. 114-142] Department of Defense Laboratories: Innovation Through Science and Engineering In Support of Military Operations CHRG-114hhrg22460 Jim Cooper committee member C000754
CHRG-114hhrg22460,Joe Wilson [H.A.S.C. No. 114-142] Department of Defense Laboratories: Innovation Through Science and Engineering In Support of Military Operations CHRG-114hhrg22460 Joe Wilson committee member W000795
CHRG-114hhrg22460,John Garamendi [H.A.S.C. No. 114-142] Department of Defense Laboratories: Innovation Through Science and Engineering In Support of Military Operations CHRG-114hhrg22460 John Garamendi committee member G000559
CHRG-114hhrg22460,John Kline [H.A.S.C. No. 114-142] Department of Defense Laboratories: Innovation Through Science and Engineering In Support of Military Operations CHRG-114hhrg22460 John Kline committee member K000363
CHRG-114hhrg22460,Marc A. Veasey [H.A.S.C. No. 114-142] Department of Defense Laboratories: Innovation Through Science and Engineering In Support of Military Operations CHRG-114hhrg22460 Marc A. Veasey committee member V000131
CHRG-114hhrg22460,Mo Brooks [H.A.S.C. No. 114-142] Department of Defense Laboratories: Innovation Through Science and Engineering In Support of Military Operations CHRG-114hhrg22460 Mo Brooks committee member B001274
CHRG-114hhrg22460,Pete Aguilar [H.A.S.C. No. 114-142] Department of Defense Laboratories: Innovation Through Science and Engineering In Support of Military Operations CHRG-114hhrg22460 Pete Aguilar committee member A000371
CHRG-114hhrg22460,Richard B. Nugent [H.A.S.C. No. 114-142] Department of Defense Laboratories: Innovation Through Science and Engineering In Support of Military Operations CHRG-114hhrg22460 Richard B. Nugent committee member N000185
CHRG-114hhrg22460,Ryan K. Zinke [H.A.S.C. No. 114-142] Department of Defense Laboratories: Innovation Through Science and Engineering In Support of Military Operations CHRG-114hhrg22460 Ryan K. Zinke committee member Z000018
CHRG-114hhrg22460,Trent Franks [H.A.S.C. No. 114-142] Department of Defense Laboratories: Innovation Through Science and Engineering In Support of Military Operations CHRG-114hhrg22460 Trent Franks committee member F000448

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