hearing_members

Committee members present at hearings.

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

39 rows where package_id = "CHRG-112jhrg78769" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-112jhrg78769,Ann Marie Buerkle LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Ann Marie Buerkle committee member B001276
CHRG-112jhrg78769,Bill Flores LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Bill Flores committee member F000461
CHRG-112jhrg78769,Bill Johnson LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Bill Johnson committee member J000292
CHRG-112jhrg78769,Bob Filner LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Bob Filner committee member F000116
CHRG-112jhrg78769,Bruce L. Braley LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Bruce L. Braley committee member B001259
CHRG-112jhrg78769,Cliff Stearns LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Cliff Stearns committee member S000822
CHRG-112jhrg78769,Corrine Brown LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Corrine Brown committee member B000911
CHRG-112jhrg78769,Dan Benishek LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Dan Benishek committee member B001271
CHRG-112jhrg78769,Daniel K. Akaka LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Daniel K. Akaka committee member A000069
CHRG-112jhrg78769,David P. Roe LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 David P. Roe committee member R000582
CHRG-112jhrg78769,Doug Lamborn LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Doug Lamborn committee member L000564
CHRG-112jhrg78769,Gus M. Bilirakis LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Gus M. Bilirakis committee member B001257
CHRG-112jhrg78769,JOHN D. ROCKEFELLER IV of West LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 JOHN D. ROCKEFELLER IV of West committee member  
CHRG-112jhrg78769,Jeff Denham LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Jeff Denham committee member D000612
CHRG-112jhrg78769,Jeff Miller LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Jeff Miller committee member M001144
CHRG-112jhrg78769,Jerry McNerney LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Jerry McNerney committee member M001166
CHRG-112jhrg78769,Jerry Moran LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Jerry Moran committee member M000934
CHRG-112jhrg78769,Jim Webb LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Jim Webb committee member W000803
CHRG-112jhrg78769,Joe Donnelly LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Joe Donnelly committee member D000607
CHRG-112jhrg78769,John Barrow LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 John Barrow committee member B001252
CHRG-112jhrg78769,John Boozman LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 John Boozman committee member B001236
CHRG-112jhrg78769,Johnny Isakson LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Johnny Isakson committee member I000055
CHRG-112jhrg78769,Jon Runyan LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Jon Runyan committee member R000594
CHRG-112jhrg78769,Jon Tester LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Jon Tester committee member T000464
CHRG-112jhrg78769,Linda T. Sanchez LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Linda T. Sanchez committee member  
CHRG-112jhrg78769,Mark Begich LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Mark Begich committee member B001265
CHRG-112jhrg78769,Mark E. Amodei LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Mark E. Amodei committee member A000369
CHRG-112jhrg78769,Marlin A. Stutzman LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Marlin A. Stutzman committee member S001188
CHRG-112jhrg78769,Michael H. Michaud LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Michael H. Michaud committee member M001149
CHRG-112jhrg78769,Mike Johanns LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Mike Johanns committee member J000291
CHRG-112jhrg78769,Patty Murray LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Patty Murray committee member M001111
CHRG-112jhrg78769,Robert L. Turner LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Robert L. Turner committee member T000471
CHRG-112jhrg78769,Roger F. Wicker LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Roger F. Wicker committee member W000437
CHRG-112jhrg78769,Russ Carnahan LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Russ Carnahan committee member C001060
CHRG-112jhrg78769,Scott P. Brown LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Scott P. Brown committee member B001268
CHRG-112jhrg78769,Sherrod Brown LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Sherrod Brown committee member B000944
CHRG-112jhrg78769,Silvestre Reyes LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Silvestre Reyes committee member R000170
CHRG-112jhrg78769,Tim Huelskamp LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Tim Huelskamp committee member H001057
CHRG-112jhrg78769,Timothy J. Walz LEGISLATIVE PRESENTATION OF THE AMERICAN LEGION CHRG-112jhrg78769 Timothy J. Walz committee member W000799

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