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-113hhrg89472" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-113hhrg89472,Aaron Schock EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Aaron Schock committee member S001179
CHRG-113hhrg89472,Adrian Smith EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Adrian Smith committee member S001172
CHRG-113hhrg89472,Allyson Y. Schwartz EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Allyson Y. Schwartz committee member S001162
CHRG-113hhrg89472,Charles B. Rangel EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Charles B. Rangel committee member R000053
CHRG-113hhrg89472,Danny K. Davis EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Danny K. Davis committee member D000096
CHRG-113hhrg89472,Dave Camp EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Dave Camp committee member C000071
CHRG-113hhrg89472,David G. Reichert EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 David G. Reichert committee member R000578
CHRG-113hhrg89472,Devin Nunes EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Devin Nunes committee member N000181
CHRG-113hhrg89472,Diane Black EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Diane Black committee member B001273
CHRG-113hhrg89472,Earl Blumenauer EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Earl Blumenauer committee member B000574
CHRG-113hhrg89472,Erik Paulsen EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Erik Paulsen committee member P000594
CHRG-113hhrg89472,James B. Renacci EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 James B. Renacci committee member R000586
CHRG-113hhrg89472,Jim Gerlach EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Jim Gerlach committee member G000549
CHRG-113hhrg89472,Jim McDermott EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Jim McDermott committee member M000404
CHRG-113hhrg89472,John B. Larson EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 John B. Larson committee member L000557
CHRG-113hhrg89472,John Lewis EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 John Lewis committee member L000285
CHRG-113hhrg89472,Joseph Crowley EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Joseph Crowley committee member C000943
CHRG-113hhrg89472,Kenny Marchant EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Kenny Marchant committee member M001158
CHRG-113hhrg89472,Kevin Brady EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Kevin Brady committee member B000755
CHRG-113hhrg89472,Linda T. Sanchez EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Linda T. Sanchez committee member  
CHRG-113hhrg89472,Lloyd Doggett EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Lloyd Doggett committee member D000399
CHRG-113hhrg89472,Lynn Jenkins EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Lynn Jenkins committee member J000290
CHRG-113hhrg89472,Mike Kelly EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Mike Kelly committee member K000376
CHRG-113hhrg89472,Mike Thompson EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Mike Thompson committee member T000460
CHRG-113hhrg89472,Patrick J. Tiberi EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Patrick J. Tiberi committee member T000462
CHRG-113hhrg89472,Paul D. Ryan EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Paul D. Ryan committee member R000570
CHRG-113hhrg89472,Peter J. Roskam EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Peter J. Roskam committee member R000580
CHRG-113hhrg89472,Richard E. Neal EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Richard E. Neal committee member N000015
CHRG-113hhrg89472,Ron Kind EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Ron Kind committee member K000188
CHRG-113hhrg89472,Sam Johnson EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Sam Johnson committee member J000174
CHRG-113hhrg89472,Sander M. Levin EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Sander M. Levin committee member L000263
CHRG-113hhrg89472,Tim Griffin EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Tim Griffin committee member G000567
CHRG-113hhrg89472,Todd Young EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Todd Young committee member Y000064
CHRG-113hhrg89472,Tom Price EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Tom Price committee member P000591
CHRG-113hhrg89472,Tom Reed EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Tom Reed committee member R000585
CHRG-113hhrg89472,Vern Buchanan EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 Vern Buchanan committee member B001260
CHRG-113hhrg89472,Xavier Becerra EXAMINING TRADITIONAL MEDICARE'S BENEFIT DESIGN CHRG-113hhrg89472 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);