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

41 rows where package_id = "CHRG-109hhrg30100" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

  • committee member 41
Link package_id name ▼ role bioguide_id
CHRG-109hhrg30100,Barbara Cubin THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Barbara Cubin committee member C000962
CHRG-109hhrg30100,Bobby Jindal THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Bobby Jindal committee member J000287
CHRG-109hhrg30100,Charlie Melancon THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Charlie Melancon committee member  
CHRG-109hhrg30100,Chris Cannon THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Chris Cannon committee member  
CHRG-109hhrg30100,Dale E. Kildee THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Dale E. Kildee committee member K000172
CHRG-109hhrg30100,Dan Boren THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Dan Boren committee member B001254
CHRG-109hhrg30100,Dennis A. Cardoza THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Dennis A. Cardoza committee member C001050
CHRG-109hhrg30100,Don Young THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Don Young committee member Y000033
CHRG-109hhrg30100,Edward J. Markey THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Edward J. Markey committee member M000133
CHRG-109hhrg30100,Elton Gallegly THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Elton Gallegly committee member G000021
CHRG-109hhrg30100,Frank Pallone, Jr. THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Frank Pallone, Jr. committee member P000034
CHRG-109hhrg30100,George Miller THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 George Miller committee member M000725
CHRG-109hhrg30100,George Radanovich THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 George Radanovich committee member R000004
CHRG-109hhrg30100,Grace F. Napolitano THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Grace F. Napolitano committee member N000179
CHRG-109hhrg30100,Greg Walden THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Greg Walden committee member W000791
CHRG-109hhrg30100,Henry E. Brown, Jr. THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Henry E. Brown, Jr. committee member  
CHRG-109hhrg30100,Jay Inslee THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Jay Inslee committee member I000026
CHRG-109hhrg30100,Jeff Flake THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Jeff Flake committee member F000444
CHRG-109hhrg30100,Jim Costa THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Jim Costa committee member C001059
CHRG-109hhrg30100,Jim Gibbons THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Jim Gibbons committee member  
CHRG-109hhrg30100,Jim Saxton THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Jim Saxton committee member  
CHRG-109hhrg30100,John E. Peterson THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 John E. Peterson committee member P000262
CHRG-109hhrg30100,John J. Duncan, Jr. THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 John J. Duncan, Jr. committee member D000533
CHRG-109hhrg30100,Ken Calvert THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Ken Calvert committee member C000059
CHRG-109hhrg30100,Louie Gohmert THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Louie Gohmert committee member G000552
CHRG-109hhrg30100,Marilyn N. Musgrave THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Marilyn N. Musgrave committee member M001152
CHRG-109hhrg30100,Mark Udall THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Mark Udall committee member U000038
CHRG-109hhrg30100,Neil Abercrombie THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Neil Abercrombie committee member A000014
CHRG-109hhrg30100,Nick J. Rahall II THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Nick J. Rahall II committee member R000011
CHRG-109hhrg30100,Peter A. DeFazio THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Peter A. DeFazio committee member D000191
CHRG-109hhrg30100,Raul M. Grijalva THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Raul M. Grijalva committee member  
CHRG-109hhrg30100,Richard W. Pombo THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Richard W. Pombo committee member P000419
CHRG-109hhrg30100,Rick Renzi THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Rick Renzi committee member R000574
CHRG-109hhrg30100,Ron Kind THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Ron Kind committee member K000188
CHRG-109hhrg30100,Solomon P. Ortiz THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Solomon P. Ortiz committee member O000107
CHRG-109hhrg30100,Stephanie Herseth Sandlin THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Stephanie Herseth Sandlin committee member H001037
CHRG-109hhrg30100,Stevan Pearce THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Stevan Pearce committee member P000588
CHRG-109hhrg30100,Thelma D. Drake THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Thelma D. Drake committee member D000605
CHRG-109hhrg30100,Thomas G. Tancredo THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Thomas G. Tancredo committee member T000458
CHRG-109hhrg30100,Tom Udall THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Tom Udall committee member U000039
CHRG-109hhrg30100,Wayne T. Gilchrest THE SAN JOAQUIN RIVER RESTORATION SETTLEMENT ACT CHRG-109hhrg30100 Wayne T. Gilchrest committee member G000180

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);
Powered by Datasette · Queries took 8.413ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API