hearing_members

Committee members present at hearings.

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

56 rows where package_id = "CHRG-113hhrg91811" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-113hhrg91811,Adam Smith [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Adam Smith committee member S000510
CHRG-113hhrg91811,Andre Carson [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Andre Carson committee member  
CHRG-113hhrg91811,Austin Scott [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Austin Scott committee member S001189
CHRG-113hhrg91811,Bill Shuster [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Bill Shuster committee member S001154
CHRG-113hhrg91811,Brad R. Wenstrup [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Brad R. Wenstrup committee member W000815
CHRG-113hhrg91811,Bradley Byrne [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Bradley Byrne committee member B001289
CHRG-113hhrg91811,Carol Shea-Porter [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Carol Shea-Porter committee member S001170
CHRG-113hhrg91811,Christopher P. Gibson [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Christopher P. Gibson committee member G000564
CHRG-113hhrg91811,Colleen Hanabusa [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Colleen Hanabusa committee member H001050
CHRG-113hhrg91811,Daniel B. Maffei [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Daniel B. Maffei committee member M001171
CHRG-113hhrg91811,David Loebsack [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 David Loebsack committee member L000565
CHRG-113hhrg91811,Derek Kilmer [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Derek Kilmer committee member K000381
CHRG-113hhrg91811,Doug Lamborn [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Doug Lamborn committee member L000564
CHRG-113hhrg91811,Duncan Hunter [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Duncan Hunter committee member H000981
CHRG-113hhrg91811,Frank A. LoBiondo [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Frank A. LoBiondo committee member L000554
CHRG-113hhrg91811,Jackie Speier [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Jackie Speier committee member S001175
CHRG-113hhrg91811,Jackie Walorski [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Jackie Walorski committee member W000813
CHRG-113hhrg91811,James R. Langevin [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 James R. Langevin committee member L000559
CHRG-113hhrg91811,Jeff Miller [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Jeff Miller committee member M001144
CHRG-113hhrg91811,Jim Bridenstine [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Jim Bridenstine committee member B001283
CHRG-113hhrg91811,Jim Cooper [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Jim Cooper committee member C000754
CHRG-113hhrg91811,Joaquin Castro [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Joaquin Castro committee member C001091
CHRG-113hhrg91811,Joe Courtney [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Joe Courtney committee member C001069
CHRG-113hhrg91811,Joe Wilson [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Joe Wilson committee member W000795
CHRG-113hhrg91811,John Fleming [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 John Fleming committee member F000456
CHRG-113hhrg91811,John Garamendi [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 John Garamendi committee member G000559
CHRG-113hhrg91811,John Kline [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 John Kline committee member K000363
CHRG-113hhrg91811,Jon Runyan [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Jon Runyan committee member R000594
CHRG-113hhrg91811,Joseph J. Heck [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Joseph J. Heck committee member H001055
CHRG-113hhrg91811,Kristi L. Noem [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Kristi L. Noem committee member N000184
CHRG-113hhrg91811,Loretta Sanchez [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Loretta Sanchez committee member S000030
CHRG-113hhrg91811,Mac Thornberry [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Mac Thornberry committee member T000238
CHRG-113hhrg91811,Marc A. Veasey [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Marc A. Veasey committee member V000131
CHRG-113hhrg91811,Michael R. Turner [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Michael R. Turner committee member T000463
CHRG-113hhrg91811,Mike Coffman [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Mike Coffman committee member C001077
CHRG-113hhrg91811,Mike McIntyre [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Mike McIntyre committee member M000485
CHRG-113hhrg91811,Mike Rogers [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Mike Rogers committee member R000572
CHRG-113hhrg91811,Mo Brooks [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Mo Brooks committee member B001274
CHRG-113hhrg91811,Niki Tsongas [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Niki Tsongas committee member T000465
CHRG-113hhrg91811,Paul Cook [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Paul Cook committee member C001094
CHRG-113hhrg91811,Pete P. Gallego [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Pete P. Gallego committee member G000572
CHRG-113hhrg91811,Richard B. Nugent [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Richard B. Nugent committee member N000185
CHRG-113hhrg91811,Rick Larsen [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Rick Larsen committee member L000560
CHRG-113hhrg91811,Rob Bishop [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Rob Bishop committee member B001250
CHRG-113hhrg91811,Robert A. Brady [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Robert A. Brady committee member B001227
CHRG-113hhrg91811,Robert J. Wittman [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Robert J. Wittman committee member W000804
CHRG-113hhrg91811,Ron Barber [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Ron Barber committee member B001279
CHRG-113hhrg91811,Scott H. Peters [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Scott H. Peters committee member P000608
CHRG-113hhrg91811,Steven M. Palazzo [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Steven M. Palazzo committee member P000601
CHRG-113hhrg91811,Susan A. Davis [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Susan A. Davis committee member D000598
CHRG-113hhrg91811,Tammy Duckworth [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Tammy Duckworth committee member D000622
CHRG-113hhrg91811,Trent Franks [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Trent Franks committee member F000448
CHRG-113hhrg91811,Tulsi Gabbard [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Tulsi Gabbard committee member G000571
CHRG-113hhrg91811,Vicky Hartzler [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Vicky Hartzler committee member H001053
CHRG-113hhrg91811,Walter B. Jones [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 Walter B. Jones committee member J000255
CHRG-113hhrg91811,William L. Enyart [H.A.S.C. No.113-126]THE ADMINISTRATION'S STRATEGY FOR THE ISLAMIC STATE IN IRAQ AND THE LEVANT CHRG-113hhrg91811 William L. Enyart committee member E000292

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