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-105hhrg60840" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-105hhrg60840,Amo Houghton H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Amo Houghton committee member  
CHRG-105hhrg60840,Barbara B. Kennelly H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Barbara B. Kennelly committee member K000118
CHRG-105hhrg60840,Benjamin L. Cardin H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Benjamin L. Cardin committee member C000141
CHRG-105hhrg60840,Bill Archer H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Bill Archer committee member A000215
CHRG-105hhrg60840,Charles B. Rangel H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Charles B. Rangel committee member R000053
CHRG-105hhrg60840,Dave Camp H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Dave Camp committee member C000071
CHRG-105hhrg60840,Fortney Pete Stark H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Fortney Pete Stark committee member S000810
CHRG-105hhrg60840,Gerald D. Kleczka H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Gerald D. Kleczka committee member K000259
CHRG-105hhrg60840,Jennifer Dunn H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Jennifer Dunn committee member D000549
CHRG-105hhrg60840,Jerry Weller H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Jerry Weller committee member  
CHRG-105hhrg60840,Jim Bunning H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Jim Bunning committee member B001066
CHRG-105hhrg60840,Jim McCrery H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Jim McCrery committee member  
CHRG-105hhrg60840,Jim McDermott H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Jim McDermott committee member M000404
CHRG-105hhrg60840,Jim Nussle H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Jim Nussle committee member  
CHRG-105hhrg60840,Jim Ramstad H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Jim Ramstad committee member  
CHRG-105hhrg60840,John Ensign H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 John Ensign committee member E000194
CHRG-105hhrg60840,John Lewis H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 John Lewis committee member L000285
CHRG-105hhrg60840,John S. Tanner H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 John S. Tanner committee member T000038
CHRG-105hhrg60840,Jon Christensen H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Jon Christensen committee member C000377
CHRG-105hhrg60840,Karen L. Thurman H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Karen L. Thurman committee member T000253
CHRG-105hhrg60840,Kenny C. Hulshof H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Kenny C. Hulshof committee member H000948
CHRG-105hhrg60840,Mac Collins H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Mac Collins committee member  
CHRG-105hhrg60840,Michael R. McNulty H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Michael R. McNulty committee member M000590
CHRG-105hhrg60840,Nancy L. Johnson H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Nancy L. Johnson committee member J000163
CHRG-105hhrg60840,Phil English H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Phil English committee member  
CHRG-105hhrg60840,Philip M. Crane H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Philip M. Crane committee member C000873
CHRG-105hhrg60840,Richard E. Neal H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Richard E. Neal committee member N000015
CHRG-105hhrg60840,Rob Portman H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Rob Portman committee member P000449
CHRG-105hhrg60840,Robert T. Matsui H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Robert T. Matsui committee member M000249
CHRG-105hhrg60840,Sam Johnson H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Sam Johnson committee member J000174
CHRG-105hhrg60840,Sander M. Levin H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Sander M. Levin committee member L000263
CHRG-105hhrg60840,Wally Herger H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Wally Herger committee member H000528
CHRG-105hhrg60840,Wes Watkins H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 Wes Watkins committee member W000194
CHRG-105hhrg60840,William J. Coyne H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 William J. Coyne committee member C000846
CHRG-105hhrg60840,William J. Jefferson H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 William J. Jefferson committee member J000070
CHRG-105hhrg60840,William M. Thomas H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 William M. Thomas committee member T000186
CHRG-105hhrg60840,Xavier Becerra H.R. 3684, THE ``EMPLOYMENT SECURITY FINANCING ACT OF 1998'' CHRG-105hhrg60840 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);