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

23 rows where package_id = "CHRG-111shrg65357" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

  • committee member 23
Link package_id name ▼ role bioguide_id
CHRG-111shrg65357,Bob Corker NOMINATION OF JOSEPH A. SMITH, JR. CHRG-111shrg65357 Bob Corker committee member C001071
CHRG-111shrg65357,Charles E. Schumer NOMINATION OF JOSEPH A. SMITH, JR. CHRG-111shrg65357 Charles E. Schumer committee member S000148
CHRG-111shrg65357,Christopher J. Dodd NOMINATION OF JOSEPH A. SMITH, JR. CHRG-111shrg65357 Christopher J. Dodd committee member D000388
CHRG-111shrg65357,Daniel K. Akaka NOMINATION OF JOSEPH A. SMITH, JR. CHRG-111shrg65357 Daniel K. Akaka committee member A000069
CHRG-111shrg65357,David Vitter NOMINATION OF JOSEPH A. SMITH, JR. CHRG-111shrg65357 David Vitter committee member V000127
CHRG-111shrg65357,Evan Bayh NOMINATION OF JOSEPH A. SMITH, JR. CHRG-111shrg65357 Evan Bayh committee member B001233
CHRG-111shrg65357,Herb Kohl NOMINATION OF JOSEPH A. SMITH, JR. CHRG-111shrg65357 Herb Kohl committee member K000305
CHRG-111shrg65357,Jack Reed NOMINATION OF JOSEPH A. SMITH, JR. CHRG-111shrg65357 Jack Reed committee member R000122
CHRG-111shrg65357,Jeff Merkley NOMINATION OF JOSEPH A. SMITH, JR. CHRG-111shrg65357 Jeff Merkley committee member M001176
CHRG-111shrg65357,Jim Bunning NOMINATION OF JOSEPH A. SMITH, JR. CHRG-111shrg65357 Jim Bunning committee member B001066
CHRG-111shrg65357,Jim DeMint NOMINATION OF JOSEPH A. SMITH, JR. CHRG-111shrg65357 Jim DeMint committee member D000595
CHRG-111shrg65357,Jon Tester NOMINATION OF JOSEPH A. SMITH, JR. CHRG-111shrg65357 Jon Tester committee member T000464
CHRG-111shrg65357,Kay Bailey Hutchison NOMINATION OF JOSEPH A. SMITH, JR. CHRG-111shrg65357 Kay Bailey Hutchison committee member H001016
CHRG-111shrg65357,Mark R. Warner NOMINATION OF JOSEPH A. SMITH, JR. CHRG-111shrg65357 Mark R. Warner committee member W000805
CHRG-111shrg65357,Mel Martinez NOMINATION OF JOSEPH A. SMITH, JR. CHRG-111shrg65357 Mel Martinez committee member M001162
CHRG-111shrg65357,Michael F. Bennet NOMINATION OF JOSEPH A. SMITH, JR. CHRG-111shrg65357 Michael F. Bennet committee member B001267
CHRG-111shrg65357,Mike Johanns NOMINATION OF JOSEPH A. SMITH, JR. CHRG-111shrg65357 Mike Johanns committee member J000291
CHRG-111shrg65357,Mike Crapo NOMINATION OF JOSEPH A. SMITH, JR. CHRG-111shrg65357 Mike Crapo committee member C000880
CHRG-111shrg65357,Richard C. Shelby NOMINATION OF JOSEPH A. SMITH, JR. CHRG-111shrg65357 Richard C. Shelby committee member S000320
CHRG-111shrg65357,Robert F. Bennett NOMINATION OF JOSEPH A. SMITH, JR. CHRG-111shrg65357 Robert F. Bennett committee member B000382
CHRG-111shrg65357,Robert Menendez NOMINATION OF JOSEPH A. SMITH, JR. CHRG-111shrg65357 Robert Menendez committee member M001226
CHRG-111shrg65357,Sherrod Brown NOMINATION OF JOSEPH A. SMITH, JR. CHRG-111shrg65357 Sherrod Brown committee member B000944
CHRG-111shrg65357,Tim Johnson NOMINATION OF JOSEPH A. SMITH, JR. CHRG-111shrg65357 Tim Johnson committee member J000177

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 2491.872ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API