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

44 rows where package_id = "CHRG-107hhrg80997" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

  • committee member 44
Link package_id name ▼ role bioguide_id
CHRG-107hhrg80997,Adam Smith JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Adam Smith committee member S000510
CHRG-107hhrg80997,Barbara Cubin JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Barbara Cubin committee member C000962
CHRG-107hhrg80997,Betty McCollum JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Betty McCollum committee member M001143
CHRG-107hhrg80997,Bob Schaffer JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Bob Schaffer committee member S000112
CHRG-107hhrg80997,Brad Carson JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Brad Carson committee member C001044
CHRG-107hhrg80997,Calvin M. Dooley JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Calvin M. Dooley committee member D000424
CHRG-107hhrg80997,Chris Cannon JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Chris Cannon committee member  
CHRG-107hhrg80997,Dale E. Kildee JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Dale E. Kildee committee member K000172
CHRG-107hhrg80997,Denny Rehberg JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Denny Rehberg committee member R000571
CHRG-107hhrg80997,Don Young JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Don Young committee member Y000033
CHRG-107hhrg80997,Edward J. Markey JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Edward J. Markey committee member M000133
CHRG-107hhrg80997,Elton Gallegly JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Elton Gallegly committee member G000021
CHRG-107hhrg80997,Frank Pallone, Jr. JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Frank Pallone, Jr. committee member P000034
CHRG-107hhrg80997,George Miller JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 George Miller committee member M000725
CHRG-107hhrg80997,George Radanovich JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 George Radanovich committee member R000004
CHRG-107hhrg80997,Grace F. Napolitano JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Grace F. Napolitano committee member N000179
CHRG-107hhrg80997,Greg Walden JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Greg Walden committee member W000791
CHRG-107hhrg80997,Hilda L. Solis JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Hilda L. Solis committee member S001153
CHRG-107hhrg80997,James V. Hansen JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 James V. Hansen committee member H000172
CHRG-107hhrg80997,Jay Inslee JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Jay Inslee committee member I000026
CHRG-107hhrg80997,Jeff Flake JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Jeff Flake committee member F000444
CHRG-107hhrg80997,Jim Gibbons JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Jim Gibbons committee member  
CHRG-107hhrg80997,Jim Saxton JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Jim Saxton committee member  
CHRG-107hhrg80997,Joel Hefley JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Joel Hefley committee member H000444
CHRG-107hhrg80997,John E. Peterson JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 John E. Peterson committee member P000262
CHRG-107hhrg80997,John J. Duncan, Jr. JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 John J. Duncan, Jr. committee member D000533
CHRG-107hhrg80997,Ken Calvert JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Ken Calvert committee member C000059
CHRG-107hhrg80997,Mac Thornberry JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Mac Thornberry committee member T000238
CHRG-107hhrg80997,Mark E. Souder JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Mark E. Souder committee member S001143
CHRG-107hhrg80997,Mark Udall JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Mark Udall committee member U000038
CHRG-107hhrg80997,Michael K. Simpson JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Michael K. Simpson committee member S001148
CHRG-107hhrg80997,Neil Abercrombie JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Neil Abercrombie committee member A000014
CHRG-107hhrg80997,Nick J. Rahall II JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Nick J. Rahall II committee member R000011
CHRG-107hhrg80997,Peter A. DeFazio JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Peter A. DeFazio committee member D000191
CHRG-107hhrg80997,Richard W. Pombo JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Richard W. Pombo committee member P000419
CHRG-107hhrg80997,Ron Kind JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Ron Kind committee member K000188
CHRG-107hhrg80997,Rush Holt JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Rush Holt committee member H000749
CHRG-107hhrg80997,Scott McInnis JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Scott McInnis committee member M000477
CHRG-107hhrg80997,Solomon P. Ortiz JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Solomon P. Ortiz committee member O000107
CHRG-107hhrg80997,Thomas G. Tancredo JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Thomas G. Tancredo committee member T000458
CHRG-107hhrg80997,Tim Holden JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Tim Holden committee member H000712
CHRG-107hhrg80997,Tom Osborne JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Tom Osborne committee member  
CHRG-107hhrg80997,Tom Udall JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 Tom Udall committee member U000039
CHRG-107hhrg80997,Wayne T. Gilchrest JARBIDGE RIVER POPULATION OF BULL TROUT CHRG-107hhrg80997 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 789.707ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API