hearing_members

Committee members present at hearings.

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

39 rows where package_id = "CHRG-108hhrg99675" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-108hhrg99675,Amo Houghton ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Amo Houghton committee member  
CHRG-108hhrg99675,Benjamin L. Cardin ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Benjamin L. Cardin committee member C000141
CHRG-108hhrg99675,Charles B. Rangel ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Charles B. Rangel committee member R000053
CHRG-108hhrg99675,Dave Camp ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Dave Camp committee member C000071
CHRG-108hhrg99675,Earl Pomeroy ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Earl Pomeroy committee member P000422
CHRG-108hhrg99675,Eric Cantor ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Eric Cantor committee member C001046
CHRG-108hhrg99675,Fortney Pete Stark ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Fortney Pete Stark committee member S000810
CHRG-108hhrg99675,Gerald D. Kleczka ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Gerald D. Kleczka committee member K000259
CHRG-108hhrg99675,Jennifer Dunn ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Jennifer Dunn committee member D000549
CHRG-108hhrg99675,Jerry Weller ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Jerry Weller committee member  
CHRG-108hhrg99675,Jim McCrery ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Jim McCrery committee member  
CHRG-108hhrg99675,Jim McDermott ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Jim McDermott committee member M000404
CHRG-108hhrg99675,Jim Nussle ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Jim Nussle committee member  
CHRG-108hhrg99675,Jim Ramstad ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Jim Ramstad committee member  
CHRG-108hhrg99675,John Lewis ELECTRONIC PRESCRIBING CHRG-108hhrg99675 John Lewis committee member L000285
CHRG-108hhrg99675,John S. Tanner ELECTRONIC PRESCRIBING CHRG-108hhrg99675 John S. Tanner committee member T000038
CHRG-108hhrg99675,Kenny C. Hulshof ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Kenny C. Hulshof committee member H000948
CHRG-108hhrg99675,Kevin Brady ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Kevin Brady committee member B000755
CHRG-108hhrg99675,Lloyd Doggett ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Lloyd Doggett committee member D000399
CHRG-108hhrg99675,Mac Collins ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Mac Collins committee member  
CHRG-108hhrg99675,Mark Foley ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Mark Foley committee member F000238
CHRG-108hhrg99675,Max Sandlin ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Max Sandlin committee member S000044
CHRG-108hhrg99675,Michael R. McNulty ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Michael R. McNulty committee member M000590
CHRG-108hhrg99675,Nancy L. Johnson ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Nancy L. Johnson committee member J000163
CHRG-108hhrg99675,Paul D. Ryan ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Paul D. Ryan committee member R000570
CHRG-108hhrg99675,Phil English ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Phil English committee member  
CHRG-108hhrg99675,Philip M. Crane ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Philip M. Crane committee member C000873
CHRG-108hhrg99675,Richard E. Neal ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Richard E. Neal committee member N000015
CHRG-108hhrg99675,Rob Portman ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Rob Portman committee member P000449
CHRG-108hhrg99675,Robert T. Matsui ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Robert T. Matsui committee member M000249
CHRG-108hhrg99675,Ron Lewis ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Ron Lewis committee member L000293
CHRG-108hhrg99675,Sam Johnson ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Sam Johnson committee member J000174
CHRG-108hhrg99675,Sander M. Levin ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Sander M. Levin committee member L000263
CHRG-108hhrg99675,Scott McInnis ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Scott McInnis committee member M000477
CHRG-108hhrg99675,Stephanie Tubbs Jones ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Stephanie Tubbs Jones committee member J000284
CHRG-108hhrg99675,Wally Herger ELECTRONIC PRESCRIBING CHRG-108hhrg99675 Wally Herger committee member H000528
CHRG-108hhrg99675,William J. Jefferson ELECTRONIC PRESCRIBING CHRG-108hhrg99675 William J. Jefferson committee member J000070
CHRG-108hhrg99675,William M. Thomas ELECTRONIC PRESCRIBING CHRG-108hhrg99675 William M. Thomas committee member T000186
CHRG-108hhrg99675,Xavier Becerra ELECTRONIC PRESCRIBING CHRG-108hhrg99675 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);