home / openregs

hearing_members

Committee members present at hearings.

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

21 rows where package_id = "CHRG-112hhrg70865" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

  • committee member 21
Link package_id name ▼ role bioguide_id
CHRG-112hhrg70865,Aaron Schock AARP'S ORGANIZATIONAL STRUCTURE, MANAGEMENT, AND FINANCES CHRG-112hhrg70865 Aaron Schock committee member S001179
CHRG-112hhrg70865,David G. Reichert AARP'S ORGANIZATIONAL STRUCTURE, MANAGEMENT, AND FINANCES CHRG-112hhrg70865 David G. Reichert committee member R000578
CHRG-112hhrg70865,Dean Heller AARP'S ORGANIZATIONAL STRUCTURE, MANAGEMENT, AND FINANCES CHRG-112hhrg70865 Dean Heller committee member H001041
CHRG-112hhrg70865,Devin Nunes AARP'S ORGANIZATIONAL STRUCTURE, MANAGEMENT, AND FINANCES CHRG-112hhrg70865 Devin Nunes committee member N000181
CHRG-112hhrg70865,Diane Black AARP'S ORGANIZATIONAL STRUCTURE, MANAGEMENT, AND FINANCES CHRG-112hhrg70865 Diane Black committee member B001273
CHRG-112hhrg70865,Earl Blumenauer AARP'S ORGANIZATIONAL STRUCTURE, MANAGEMENT, AND FINANCES CHRG-112hhrg70865 Earl Blumenauer committee member B000574
CHRG-112hhrg70865,Fortney Pete Stark AARP'S ORGANIZATIONAL STRUCTURE, MANAGEMENT, AND FINANCES CHRG-112hhrg70865 Fortney Pete Stark committee member S000810
CHRG-112hhrg70865,Jim Gerlach AARP'S ORGANIZATIONAL STRUCTURE, MANAGEMENT, AND FINANCES CHRG-112hhrg70865 Jim Gerlach committee member G000549
CHRG-112hhrg70865,Jim McDermott AARP'S ORGANIZATIONAL STRUCTURE, MANAGEMENT, AND FINANCES CHRG-112hhrg70865 Jim McDermott committee member M000404
CHRG-112hhrg70865,John Lewis AARP'S ORGANIZATIONAL STRUCTURE, MANAGEMENT, AND FINANCES CHRG-112hhrg70865 John Lewis committee member L000285
CHRG-112hhrg70865,Kenny Marchant AARP'S ORGANIZATIONAL STRUCTURE, MANAGEMENT, AND FINANCES CHRG-112hhrg70865 Kenny Marchant committee member M001158
CHRG-112hhrg70865,Lynn Jenkins AARP'S ORGANIZATIONAL STRUCTURE, MANAGEMENT, AND FINANCES CHRG-112hhrg70865 Lynn Jenkins committee member J000290
CHRG-112hhrg70865,Mike Thompson AARP'S ORGANIZATIONAL STRUCTURE, MANAGEMENT, AND FINANCES CHRG-112hhrg70865 Mike Thompson committee member T000460
CHRG-112hhrg70865,Paul D. Ryan AARP'S ORGANIZATIONAL STRUCTURE, MANAGEMENT, AND FINANCES CHRG-112hhrg70865 Paul D. Ryan committee member R000570
CHRG-112hhrg70865,Peter J. Roskam AARP'S ORGANIZATIONAL STRUCTURE, MANAGEMENT, AND FINANCES CHRG-112hhrg70865 Peter J. Roskam committee member R000580
CHRG-112hhrg70865,Ron Kind AARP'S ORGANIZATIONAL STRUCTURE, MANAGEMENT, AND FINANCES CHRG-112hhrg70865 Ron Kind committee member K000188
CHRG-112hhrg70865,Sam Johnson AARP'S ORGANIZATIONAL STRUCTURE, MANAGEMENT, AND FINANCES CHRG-112hhrg70865 Sam Johnson committee member J000174
CHRG-112hhrg70865,Tom Price AARP'S ORGANIZATIONAL STRUCTURE, MANAGEMENT, AND FINANCES CHRG-112hhrg70865 Tom Price committee member P000591
CHRG-112hhrg70865,Vern Buchanan AARP'S ORGANIZATIONAL STRUCTURE, MANAGEMENT, AND FINANCES CHRG-112hhrg70865 Vern Buchanan committee member B001260
CHRG-112hhrg70865,Wally Herger AARP'S ORGANIZATIONAL STRUCTURE, MANAGEMENT, AND FINANCES CHRG-112hhrg70865 Wally Herger committee member H000528
CHRG-112hhrg70865,Xavier Becerra AARP'S ORGANIZATIONAL STRUCTURE, MANAGEMENT, AND FINANCES CHRG-112hhrg70865 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);
Powered by Datasette · Queries took 25.2ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API