hearing_members

Committee members present at hearings.

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

37 rows where package_id = "CHRG-106hhrg68040" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-106hhrg68040,Amo Houghton TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Amo Houghton committee member  
CHRG-106hhrg68040,Benjamin L. Cardin TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Benjamin L. Cardin committee member C000141
CHRG-106hhrg68040,Bill Archer TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Bill Archer committee member A000215
CHRG-106hhrg68040,Charles B. Rangel TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Charles B. Rangel committee member R000053
CHRG-106hhrg68040,Dave Camp TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Dave Camp committee member C000071
CHRG-106hhrg68040,Fortney Pete Stark TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Fortney Pete Stark committee member S000810
CHRG-106hhrg68040,Gerald D. Kleczka TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Gerald D. Kleczka committee member K000259
CHRG-106hhrg68040,Jennifer Dunn TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Jennifer Dunn committee member D000549
CHRG-106hhrg68040,Jerry Weller TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Jerry Weller committee member  
CHRG-106hhrg68040,Jim McCrery TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Jim McCrery committee member  
CHRG-106hhrg68040,Jim McDermott TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Jim McDermott committee member M000404
CHRG-106hhrg68040,Jim Nussle TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Jim Nussle committee member  
CHRG-106hhrg68040,Jim Ramstad TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Jim Ramstad committee member  
CHRG-106hhrg68040,John Lewis TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 John Lewis committee member L000285
CHRG-106hhrg68040,John S. Tanner TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 John S. Tanner committee member T000038
CHRG-106hhrg68040,Karen L. Thurman TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Karen L. Thurman committee member T000253
CHRG-106hhrg68040,Kenny C. Hulshof TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Kenny C. Hulshof committee member H000948
CHRG-106hhrg68040,Lloyd Doggett TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Lloyd Doggett committee member D000399
CHRG-106hhrg68040,Mac Collins TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Mac Collins committee member  
CHRG-106hhrg68040,Mark Foley TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Mark Foley committee member F000238
CHRG-106hhrg68040,Michael R. McNulty TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Michael R. McNulty committee member M000590
CHRG-106hhrg68040,Nancy L. Johnson TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Nancy L. Johnson committee member J000163
CHRG-106hhrg68040,Phil English TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Phil English committee member  
CHRG-106hhrg68040,Philip M. Crane TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Philip M. Crane committee member C000873
CHRG-106hhrg68040,Richard E. Neal TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Richard E. Neal committee member N000015
CHRG-106hhrg68040,Rob Portman TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Rob Portman committee member P000449
CHRG-106hhrg68040,Robert T. Matsui TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Robert T. Matsui committee member M000249
CHRG-106hhrg68040,Ron Lewis TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Ron Lewis committee member L000293
CHRG-106hhrg68040,Sam Johnson TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Sam Johnson committee member J000174
CHRG-106hhrg68040,Sander M. Levin TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Sander M. Levin committee member L000263
CHRG-106hhrg68040,Scott McInnis TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Scott McInnis committee member M000477
CHRG-106hhrg68040,Wally Herger TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Wally Herger committee member H000528
CHRG-106hhrg68040,Wes Watkins TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Wes Watkins committee member W000194
CHRG-106hhrg68040,William J. Coyne TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 William J. Coyne committee member C000846
CHRG-106hhrg68040,William J. Jefferson TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 William J. Jefferson committee member J000070
CHRG-106hhrg68040,William M. Thomas TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 William M. Thomas committee member T000186
CHRG-106hhrg68040,Xavier Becerra TRADE IN AFRICAN DIAMONDS CHRG-106hhrg68040 Xavier Becerra committee member B000287

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