hearing_members

Committee members present at hearings.

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

27 rows where package_id = "CHRG-111hhrg61761" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-111hhrg61761,Ann Kirkpatrick THE TRUE COST OF THE WAR CHRG-111hhrg61761 Ann Kirkpatrick committee member K000368
CHRG-111hhrg61761,Bob Filner THE TRUE COST OF THE WAR CHRG-111hhrg61761 Bob Filner committee member F000116
CHRG-111hhrg61761,Brian P. Bilbray THE TRUE COST OF THE WAR CHRG-111hhrg61761 Brian P. Bilbray committee member B000461
CHRG-111hhrg61761,Ciro D. Rodriguez THE TRUE COST OF THE WAR CHRG-111hhrg61761 Ciro D. Rodriguez committee member R000568
CHRG-111hhrg61761,Cliff Stearns THE TRUE COST OF THE WAR CHRG-111hhrg61761 Cliff Stearns committee member S000822
CHRG-111hhrg61761,Corrine Brown THE TRUE COST OF THE WAR CHRG-111hhrg61761 Corrine Brown committee member B000911
CHRG-111hhrg61761,David P. Roe THE TRUE COST OF THE WAR CHRG-111hhrg61761 David P. Roe committee member R000582
CHRG-111hhrg61761,Deborah L. Halvorson THE TRUE COST OF THE WAR CHRG-111hhrg61761 Deborah L. Halvorson committee member H001044
CHRG-111hhrg61761,Doug Lamborn THE TRUE COST OF THE WAR CHRG-111hhrg61761 Doug Lamborn committee member L000564
CHRG-111hhrg61761,Glenn C. Nye THE TRUE COST OF THE WAR CHRG-111hhrg61761 Glenn C. Nye committee member N000183
CHRG-111hhrg61761,Gus M. Bilirakis THE TRUE COST OF THE WAR CHRG-111hhrg61761 Gus M. Bilirakis committee member B001257
CHRG-111hhrg61761,Harry E. Mitchell THE TRUE COST OF THE WAR CHRG-111hhrg61761 Harry E. Mitchell committee member M001167
CHRG-111hhrg61761,Harry Teague THE TRUE COST OF THE WAR CHRG-111hhrg61761 Harry Teague committee member T000466
CHRG-111hhrg61761,Jeff Miller THE TRUE COST OF THE WAR CHRG-111hhrg61761 Jeff Miller committee member M001144
CHRG-111hhrg61761,Jerry McNerney THE TRUE COST OF THE WAR CHRG-111hhrg61761 Jerry McNerney committee member M001166
CHRG-111hhrg61761,Jerry Moran THE TRUE COST OF THE WAR CHRG-111hhrg61761 Jerry Moran committee member M000934
CHRG-111hhrg61761,Joe Donnelly THE TRUE COST OF THE WAR CHRG-111hhrg61761 Joe Donnelly committee member D000607
CHRG-111hhrg61761,John Boozman THE TRUE COST OF THE WAR CHRG-111hhrg61761 John Boozman committee member B001236
CHRG-111hhrg61761,John H. Adler THE TRUE COST OF THE WAR CHRG-111hhrg61761 John H. Adler committee member A000364
CHRG-111hhrg61761,John J. Hall THE TRUE COST OF THE WAR CHRG-111hhrg61761 John J. Hall committee member H001039
CHRG-111hhrg61761,Michael H. Michaud THE TRUE COST OF THE WAR CHRG-111hhrg61761 Michael H. Michaud committee member M001149
CHRG-111hhrg61761,Steve Buyer THE TRUE COST OF THE WAR CHRG-111hhrg61761 Steve Buyer committee member  
CHRG-111hhrg61761,Thomas S.P. Perriello THE TRUE COST OF THE WAR CHRG-111hhrg61761 Thomas S.P. Perriello committee member P000600
CHRG-111hhrg61761,Timothy J. Walz THE TRUE COST OF THE WAR CHRG-111hhrg61761 Timothy J. Walz committee member W000799
CHRG-111hhrg61761,Vern Buchanan THE TRUE COST OF THE WAR CHRG-111hhrg61761 Vern Buchanan committee member B001260
CHRG-111hhrg61761,Vic Snyder THE TRUE COST OF THE WAR CHRG-111hhrg61761 Vic Snyder committee member  
CHRG-111hhrg61761,Zachary T. Space THE TRUE COST OF THE WAR CHRG-111hhrg61761 Zachary T. Space committee member S001173

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