hearing_members

Committee members present at hearings.

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

44 rows where package_id = "CHRG-111hhrg58429" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-111hhrg58429,Albio Sires RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Albio Sires committee member S001165
CHRG-111hhrg58429,Barbara Lee RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Barbara Lee committee member L000551
CHRG-111hhrg58429,Bill Delahunt RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Bill Delahunt committee member  
CHRG-111hhrg58429,Bob Inglis RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Bob Inglis committee member I000023
CHRG-111hhrg58429,Brad Miller RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Brad Miller committee member M001154
CHRG-111hhrg58429,Brad Sherman RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Brad Sherman committee member S000344
CHRG-111hhrg58429,Christopher H. Smith RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Christopher H. Smith committee member S000522
CHRG-111hhrg58429,Connie Mack RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Connie Mack committee member M000019
CHRG-111hhrg58429,Dan Burton RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Dan Burton committee member B001149
CHRG-111hhrg58429,Dana Rohrabacher RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Dana Rohrabacher committee member R000409
CHRG-111hhrg58429,David Scott RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 David Scott committee member S001157
CHRG-111hhrg58429,Diane E. Watson RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Diane E. Watson committee member W000794
CHRG-111hhrg58429,Donald A. Manzullo RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Donald A. Manzullo committee member M001138
CHRG-111hhrg58429,Donald M. Payne RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Donald M. Payne committee member P000149
CHRG-111hhrg58429,Edward R. Royce RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Edward R. Royce committee member R000487
CHRG-111hhrg58429,Eliot L. Engel RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Eliot L. Engel committee member E000179
CHRG-111hhrg58429,Elton Gallegly RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Elton Gallegly committee member G000021
CHRG-111hhrg58429,Gabrielle Giffords RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Gabrielle Giffords committee member G000554
CHRG-111hhrg58429,Gary L. Ackerman RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Gary L. Ackerman committee member A000022
CHRG-111hhrg58429,Gene Green RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Gene Green committee member G000410
CHRG-111hhrg58429,Gerald E. Connolly RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Gerald E. Connolly committee member C001078
CHRG-111hhrg58429,Gregory W. Meeks RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Gregory W. Meeks committee member M001137
CHRG-111hhrg58429,Gus M. Bilirakis RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Gus M. Bilirakis committee member B001257
CHRG-111hhrg58429,Howard L. Berman RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Howard L. Berman committee member B000410
CHRG-111hhrg58429,Ileana Ros-Lehtinen RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Ileana Ros-Lehtinen committee member R000435
CHRG-111hhrg58429,Jeff Flake RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Jeff Flake committee member F000444
CHRG-111hhrg58429,Jeff Fortenberry RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Jeff Fortenberry committee member F000449
CHRG-111hhrg58429,Jim Costa RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Jim Costa committee member C001059
CHRG-111hhrg58429,Joe Wilson RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Joe Wilson committee member W000795
CHRG-111hhrg58429,John Boozman RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 John Boozman committee member B001236
CHRG-111hhrg58429,John S. Tanner RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 John S. Tanner committee member T000038
CHRG-111hhrg58429,Joseph Crowley RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Joseph Crowley committee member C000943
CHRG-111hhrg58429,Keith Ellison RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Keith Ellison committee member E000288
CHRG-111hhrg58429,Lynn C. Woolsey RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Lynn C. Woolsey committee member W000738
CHRG-111hhrg58429,Michael E. McMahon RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Michael E. McMahon committee member M001174
CHRG-111hhrg58429,Michael T. McCaul RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Michael T. McCaul committee member M001157
CHRG-111hhrg58429,Mike Pence RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Mike Pence committee member P000587
CHRG-111hhrg58429,Mike Ross RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Mike Ross committee member R000573
CHRG-111hhrg58429,Ron Klein RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Ron Klein committee member K000366
CHRG-111hhrg58429,Ron Paul RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Ron Paul committee member P000583
CHRG-111hhrg58429,Russ Carnahan RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Russ Carnahan committee member C001060
CHRG-111hhrg58429,Sheila Jackson Lee RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Sheila Jackson Lee committee member J000032
CHRG-111hhrg58429,Shelley Berkley RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Shelley Berkley committee member B001231
CHRG-111hhrg58429,Ted Poe RENEGOTIATING THE SOUTH PACIFIC TUNA TREATY: CLOSING LOOPHOLES AND PROTECTING U.S. INTERESTS CHRG-111hhrg58429 Ted Poe committee member P000592

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