hearing_members

Committee members present at hearings.

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

43 rows where package_id = "CHRG-106hhrg75061" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-106hhrg75061,Asa Hutchinson PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Asa Hutchinson committee member H001014
CHRG-106hhrg75061,Benjamin A. Gilman PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Benjamin A. Gilman committee member G000212
CHRG-106hhrg75061,Bernard Sanders PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Bernard Sanders committee member S000033
CHRG-106hhrg75061,Bob Barr PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Bob Barr committee member B000169
CHRG-106hhrg75061,Carolyn B. Maloney PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Carolyn B. Maloney committee member M000087
CHRG-106hhrg75061,Chaka Fattah PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Chaka Fattah committee member F000043
CHRG-106hhrg75061,Christopher Shays PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Christopher Shays committee member S001144
CHRG-106hhrg75061,Constance A. Morella PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Constance A. Morella committee member M000941
CHRG-106hhrg75061,Dan Burton PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Dan Burton committee member B001149
CHRG-106hhrg75061,Dan Miller PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Dan Miller committee member M000720
CHRG-106hhrg75061,Danny K. Davis PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Danny K. Davis committee member D000096
CHRG-106hhrg75061,David M. McIntosh PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 David M. McIntosh committee member M000481
CHRG-106hhrg75061,David Vitter PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 David Vitter committee member V000127
CHRG-106hhrg75061,Dennis J. Kucinich PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Dennis J. Kucinich committee member K000336
CHRG-106hhrg75061,Doug Ose PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Doug Ose committee member O000164
CHRG-106hhrg75061,ELEANOR HOLMES NORTON of Washington PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 ELEANOR HOLMES NORTON of Washington committee member  
CHRG-106hhrg75061,Edolphus Towns PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Edolphus Towns committee member T000326
CHRG-106hhrg75061,Elijah E. Cummings PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Elijah E. Cummings committee member C000984
CHRG-106hhrg75061,Greg Walden PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Greg Walden committee member W000791
CHRG-106hhrg75061,Harold E. Ford Jr. PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Harold E. Ford Jr. committee member  
CHRG-106hhrg75061,Helen Chenoweth-Hage PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Helen Chenoweth-Hage committee member C000345
CHRG-106hhrg75061,Henry A. Waxman PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Henry A. Waxman committee member W000215
CHRG-106hhrg75061,Ileana Ros-Lehtinen PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Ileana Ros-Lehtinen committee member R000435
CHRG-106hhrg75061,Janice D. Schakowsky PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Janice D. Schakowsky committee member S001145
CHRG-106hhrg75061,Jim Turner PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Jim Turner committee member  
CHRG-106hhrg75061,Joe Scarborough PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Joe Scarborough committee member S000106
CHRG-106hhrg75061,John F. Tierney PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 John F. Tierney committee member T000266
CHRG-106hhrg75061,John L. Mica PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 John L. Mica committee member M000689
CHRG-106hhrg75061,John M. McHugh PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 John M. McHugh committee member M000472
CHRG-106hhrg75061,Judy Biggert PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Judy Biggert committee member B001232
CHRG-106hhrg75061,Lee Terry PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Lee Terry committee member T000459
CHRG-106hhrg75061,Major R. Owens PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Major R. Owens committee member O000159
CHRG-106hhrg75061,Mark E. Souder PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Mark E. Souder committee member S001143
CHRG-106hhrg75061,Patsy T. Mink PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Patsy T. Mink committee member M000797
CHRG-106hhrg75061,Paul D. Ryan PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Paul D. Ryan committee member R000570
CHRG-106hhrg75061,Paul E. Kanjorski PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Paul E. Kanjorski committee member K000008
CHRG-106hhrg75061,Robert E. Wise Jr. PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Robert E. Wise Jr. committee member  
CHRG-106hhrg75061,Rod R. Blagojevich PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Rod R. Blagojevich committee member B000518
CHRG-106hhrg75061,Stephen Horn PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Stephen Horn committee member H000789
CHRG-106hhrg75061,Steven C. LaTourette PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Steven C. LaTourette committee member L000553
CHRG-106hhrg75061,Thomas H. Allen PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Thomas H. Allen committee member A000147
CHRG-106hhrg75061,Tom Davis PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Tom Davis committee member  
CHRG-106hhrg75061,Tom Lantos PORT SECURITY: PROTECTING FLORIDA'S PORTS FROM THE THREAT OF DRUG TRAFFICKING CHRG-106hhrg75061 Tom Lantos committee member L000090

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