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-106hhrg67603" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

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