hearing_members

Committee members present at hearings.

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

47 rows where package_id = "CHRG-106hhrg69868" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-106hhrg69868,Alcee L. Hastings IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Alcee L. Hastings committee member H000324
CHRG-106hhrg69868,Amo Houghton IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Amo Houghton committee member  
CHRG-106hhrg69868,Barbara Lee IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Barbara Lee committee member L000551
CHRG-106hhrg69868,Benjamin A. Gilman IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Benjamin A. Gilman committee member G000212
CHRG-106hhrg69868,Bill Delahunt IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Bill Delahunt committee member  
CHRG-106hhrg69868,Brad Sherman IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Brad Sherman committee member S000344
CHRG-106hhrg69868,Cass Ballenger IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Cass Ballenger committee member B000104
CHRG-106hhrg69868,Christopher H. Smith IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Christopher H. Smith committee member S000522
CHRG-106hhrg69868,Cynthia A. McKinney IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Cynthia A. McKinney committee member M000523
CHRG-106hhrg69868,Dan Burton IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Dan Burton committee member B001149
CHRG-106hhrg69868,Dana Rohrabacher IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Dana Rohrabacher committee member R000409
CHRG-106hhrg69868,Donald A. Manzullo IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Donald A. Manzullo committee member M001138
CHRG-106hhrg69868,Donald M. Payne IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Donald M. Payne committee member P000149
CHRG-106hhrg69868,Doug Bereuter IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Doug Bereuter committee member  
CHRG-106hhrg69868,Earl F. Hilliard IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Earl F. Hilliard committee member H000621
CHRG-106hhrg69868,Earl Pomeroy IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Earl Pomeroy committee member P000422
CHRG-106hhrg69868,Edward R. Royce IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Edward R. Royce committee member R000487
CHRG-106hhrg69868,Elton Gallegly IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Elton Gallegly committee member G000021
CHRG-106hhrg69868,Gary L. Ackerman IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Gary L. Ackerman committee member A000022
CHRG-106hhrg69868,George Radanovich IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 George Radanovich committee member R000004
CHRG-106hhrg69868,Gregory W. Meeks IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Gregory W. Meeks committee member M001137
CHRG-106hhrg69868,Henry J. Hyde IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Henry J. Hyde committee member H001022
CHRG-106hhrg69868,Howard L. Berman IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Howard L. Berman committee member B000410
CHRG-106hhrg69868,Ileana Ros-Lehtinen IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Ileana Ros-Lehtinen committee member R000435
CHRG-106hhrg69868,James A. Leach IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 James A. Leach committee member L000170
CHRG-106hhrg69868,Jim Davis IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Jim Davis committee member  
CHRG-106hhrg69868,John Cooksey IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 John Cooksey committee member C000735
CHRG-106hhrg69868,John M. McHugh IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 John M. McHugh committee member M000472
CHRG-106hhrg69868,Joseph Crowley IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Joseph Crowley committee member C000943
CHRG-106hhrg69868,Joseph M. Hoeffel IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Joseph M. Hoeffel committee member H001031
CHRG-106hhrg69868,Kevin Brady IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Kevin Brady committee member B000755
CHRG-106hhrg69868,Matt Salmon IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Matt Salmon committee member S000018
CHRG-106hhrg69868,Matthew G. Martinez IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Matthew G. Martinez committee member  
CHRG-106hhrg69868,Pat Danner IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Pat Danner committee member D000046
CHRG-106hhrg69868,Paul E. Gillmor IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Paul E. Gillmor committee member G000210
CHRG-106hhrg69868,Peter T. King IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Peter T. King committee member K000210
CHRG-106hhrg69868,Richard Burr IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Richard Burr committee member B001135
CHRG-106hhrg69868,Robert Menendez IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Robert Menendez committee member M001226
CHRG-106hhrg69868,Robert Wexler IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Robert Wexler committee member W000314
CHRG-106hhrg69868,Sam Gejdenson IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Sam Gejdenson committee member G000120
CHRG-106hhrg69868,Sherrod Brown IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Sherrod Brown committee member B000944
CHRG-106hhrg69868,Steve Chabot IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Steve Chabot committee member C000266
CHRG-106hhrg69868,Steven R. Rothman IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Steven R. Rothman committee member R000462
CHRG-106hhrg69868,Thomas G. Tancredo IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Thomas G. Tancredo committee member T000458
CHRG-106hhrg69868,Tom Campbell IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Tom Campbell committee member C000100
CHRG-106hhrg69868,Tom Lantos IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 Tom Lantos committee member L000090
CHRG-106hhrg69868,William F. Goodling IMPLEMENTING PLAN COLOMBIA: THE U.S. ROLE CHRG-106hhrg69868 William F. Goodling committee member G000291

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