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-111hhrg62618" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-111hhrg62618,Adrian Smith A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Adrian Smith committee member S001172
CHRG-111hhrg62618,Alan Grayson A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Alan Grayson committee member G000556
CHRG-111hhrg62618,Baron P. Hill A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Baron P. Hill committee member H001030
CHRG-111hhrg62618,Bart Gordon A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Bart Gordon committee member  
CHRG-111hhrg62618,Ben Chandler A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Ben Chandler committee member C001058
CHRG-111hhrg62618,Ben Ray Lujan A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Ben Ray Lujan committee member  
CHRG-111hhrg62618,Bob Inglis A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Bob Inglis committee member I000023
CHRG-111hhrg62618,Brad Miller A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Brad Miller committee member M001154
CHRG-111hhrg62618,Brian Baird A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Brian Baird committee member B001229
CHRG-111hhrg62618,Brian P. Bilbray A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Brian P. Bilbray committee member B000461
CHRG-111hhrg62618,Charles A. Wilson A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Charles A. Wilson committee member W000571
CHRG-111hhrg62618,Dana Rohrabacher A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Dana Rohrabacher committee member R000409
CHRG-111hhrg62618,Daniel Lipinski A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Daniel Lipinski committee member L000563
CHRG-111hhrg62618,David Wu A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 David Wu committee member W000793
CHRG-111hhrg62618,Donna F. Edwards A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Donna F. Edwards committee member E000290
CHRG-111hhrg62618,Eddie Bernice Johnson A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Eddie Bernice Johnson committee member J000126
CHRG-111hhrg62618,Frank D. Lucas A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Frank D. Lucas committee member L000491
CHRG-111hhrg62618,Gabrielle Giffords A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Gabrielle Giffords committee member G000554
CHRG-111hhrg62618,Gary C. Peters A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Gary C. Peters committee member P000595
CHRG-111hhrg62618,Harry E. Mitchell A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Harry E. Mitchell committee member M001167
CHRG-111hhrg62618,Jerry F. Costello A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Jerry F. Costello committee member C000794
CHRG-111hhrg62618,Jim Matheson A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Jim Matheson committee member M001142
CHRG-111hhrg62618,John Garamendi A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 John Garamendi committee member G000559
CHRG-111hhrg62618,Judy Biggert A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Judy Biggert committee member B001232
CHRG-111hhrg62618,Kathleen A. Dahlkemper A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Kathleen A. Dahlkemper committee member D000608
CHRG-111hhrg62618,Lamar Smith A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Lamar Smith committee member S000583
CHRG-111hhrg62618,Lincoln Davis A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Lincoln Davis committee member D000599
CHRG-111hhrg62618,Lynn C. Woolsey A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Lynn C. Woolsey committee member W000738
CHRG-111hhrg62618,Marcia L. Fudge A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Marcia L. Fudge committee member F000455
CHRG-111hhrg62618,Mario Diaz-Balart A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Mario Diaz-Balart committee member D000600
CHRG-111hhrg62618,Michael T. McCaul A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Michael T. McCaul committee member M001157
CHRG-111hhrg62618,Paul C. Broun A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Paul C. Broun committee member B001262
CHRG-111hhrg62618,Paul Tonko A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Paul Tonko committee member T000469
CHRG-111hhrg62618,Pete Olson A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Pete Olson committee member O000168
CHRG-111hhrg62618,Ralph M. Hall A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Ralph M. Hall committee member H000067
CHRG-111hhrg62618,Randy Neugebauer A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Randy Neugebauer committee member N000182
CHRG-111hhrg62618,Roscoe G. Bartlett A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Roscoe G. Bartlett committee member B000208
CHRG-111hhrg62618,Russ Carnahan A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Russ Carnahan committee member C001060
CHRG-111hhrg62618,Steven R. Rothman A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Steven R. Rothman committee member R000462
CHRG-111hhrg62618,Suzanne M. Kosmas A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Suzanne M. Kosmas committee member K000370
CHRG-111hhrg62618,Vernon J. Ehlers A RATIONAL DISCUSSION OF CLIMATE CHANGE: THE SCIENCE, THE EVIDENCE, THE RESPONSE CHRG-111hhrg62618 Vernon J. Ehlers committee member E000092

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);