hearing_members

Committee members present at hearings.

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

15 rows where package_id = "CHRG-117hhrg49423" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-117hhrg49423,Anthony Gonzalez A BIG CLIMATE DEAL: LOWERING COSTS, CREATING JOBS, AND REDUCING POLLUTION WITH THE INFLATION REDUCTION ACT CHRG-117hhrg49423 Anthony Gonzalez committee member G000588
CHRG-117hhrg49423,Carol D. Miller A BIG CLIMATE DEAL: LOWERING COSTS, CREATING JOBS, AND REDUCING POLLUTION WITH THE INFLATION REDUCTION ACT CHRG-117hhrg49423 Carol D. Miller committee member M001205
CHRG-117hhrg49423,Dan Crenshaw A BIG CLIMATE DEAL: LOWERING COSTS, CREATING JOBS, AND REDUCING POLLUTION WITH THE INFLATION REDUCTION ACT CHRG-117hhrg49423 Dan Crenshaw committee member C001120
CHRG-117hhrg49423,Earl L. "Buddy" Carter A BIG CLIMATE DEAL: LOWERING COSTS, CREATING JOBS, AND REDUCING POLLUTION WITH THE INFLATION REDUCTION ACT CHRG-117hhrg49423 Earl L. "Buddy" Carter committee member C001103
CHRG-117hhrg49423,Garret Graves A BIG CLIMATE DEAL: LOWERING COSTS, CREATING JOBS, AND REDUCING POLLUTION WITH THE INFLATION REDUCTION ACT CHRG-117hhrg49423 Garret Graves committee member G000577
CHRG-117hhrg49423,Gary J. Palmer A BIG CLIMATE DEAL: LOWERING COSTS, CREATING JOBS, AND REDUCING POLLUTION WITH THE INFLATION REDUCTION ACT CHRG-117hhrg49423 Gary J. Palmer committee member P000609
CHRG-117hhrg49423,Jared Huffman A BIG CLIMATE DEAL: LOWERING COSTS, CREATING JOBS, AND REDUCING POLLUTION WITH THE INFLATION REDUCTION ACT CHRG-117hhrg49423 Jared Huffman committee member H001068
CHRG-117hhrg49423,Joe Neguse A BIG CLIMATE DEAL: LOWERING COSTS, CREATING JOBS, AND REDUCING POLLUTION WITH THE INFLATION REDUCTION ACT CHRG-117hhrg49423 Joe Neguse committee member N000191
CHRG-117hhrg49423,Julia Brownley A BIG CLIMATE DEAL: LOWERING COSTS, CREATING JOBS, AND REDUCING POLLUTION WITH THE INFLATION REDUCTION ACT CHRG-117hhrg49423 Julia Brownley committee member B001285
CHRG-117hhrg49423,Kathy Castor A BIG CLIMATE DEAL: LOWERING COSTS, CREATING JOBS, AND REDUCING POLLUTION WITH THE INFLATION REDUCTION ACT CHRG-117hhrg49423 Kathy Castor committee member C001066
CHRG-117hhrg49423,Kelly Armstrong A BIG CLIMATE DEAL: LOWERING COSTS, CREATING JOBS, AND REDUCING POLLUTION WITH THE INFLATION REDUCTION ACT CHRG-117hhrg49423 Kelly Armstrong committee member A000377
CHRG-117hhrg49423,Mike Levin A BIG CLIMATE DEAL: LOWERING COSTS, CREATING JOBS, AND REDUCING POLLUTION WITH THE INFLATION REDUCTION ACT CHRG-117hhrg49423 Mike Levin committee member L000593
CHRG-117hhrg49423,Sean Casten A BIG CLIMATE DEAL: LOWERING COSTS, CREATING JOBS, AND REDUCING POLLUTION WITH THE INFLATION REDUCTION ACT CHRG-117hhrg49423 Sean Casten committee member C001117
CHRG-117hhrg49423,Suzanne Bonamici A BIG CLIMATE DEAL: LOWERING COSTS, CREATING JOBS, AND REDUCING POLLUTION WITH THE INFLATION REDUCTION ACT CHRG-117hhrg49423 Suzanne Bonamici committee member B001278
CHRG-117hhrg49423,Veronica Escobar A BIG CLIMATE DEAL: LOWERING COSTS, CREATING JOBS, AND REDUCING POLLUTION WITH THE INFLATION REDUCTION ACT CHRG-117hhrg49423 Veronica Escobar committee member E000299

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