hearing_members
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
20 rows where package_id = "CHRG-108jhrg96536" sorted by name
This data as json, CSV (advanced)
role 1
| Link | package_id | name ▼ | role | bioguide_id |
|---|---|---|---|---|
| CHRG-108jhrg96536,Adam H. Putnam | THE ECONOMIC OUTLOOK CHRG-108jhrg96536 | Adam H. Putnam | committee member | P000586 |
| CHRG-108jhrg96536,Baron P. Hill | THE ECONOMIC OUTLOOK CHRG-108jhrg96536 | Baron P. Hill | committee member | H001030 |
| CHRG-108jhrg96536,Carolyn B. Maloney | THE ECONOMIC OUTLOOK CHRG-108jhrg96536 | Carolyn B. Maloney | committee member | M000087 |
| CHRG-108jhrg96536,Edward M. Kennedy | THE ECONOMIC OUTLOOK CHRG-108jhrg96536 | Edward M. Kennedy | committee member | K000105 |
| CHRG-108jhrg96536,Fortney Pete Stark | THE ECONOMIC OUTLOOK CHRG-108jhrg96536 | Fortney Pete Stark | committee member | S000810 |
| CHRG-108jhrg96536,Jack Reed | THE ECONOMIC OUTLOOK CHRG-108jhrg96536 | Jack Reed | committee member | R000122 |
| CHRG-108jhrg96536,Jeff Bingaman | THE ECONOMIC OUTLOOK CHRG-108jhrg96536 | Jeff Bingaman | committee member | B000468 |
| CHRG-108jhrg96536,Jeff Sessions | THE ECONOMIC OUTLOOK CHRG-108jhrg96536 | Jeff Sessions | committee member | S001141 |
| CHRG-108jhrg96536,Jennifer Dunn | THE ECONOMIC OUTLOOK CHRG-108jhrg96536 | Jennifer Dunn | committee member | D000549 |
| CHRG-108jhrg96536,Jim Saxton | THE ECONOMIC OUTLOOK CHRG-108jhrg96536 | Jim Saxton | committee member | |
| CHRG-108jhrg96536,John E. Sununu | THE ECONOMIC OUTLOOK CHRG-108jhrg96536 | John E. Sununu | committee member | S001078 |
| CHRG-108jhrg96536,Lamar Alexander | THE ECONOMIC OUTLOOK CHRG-108jhrg96536 | Lamar Alexander | committee member | A000360 |
| CHRG-108jhrg96536,Melvin L. Watt | THE ECONOMIC OUTLOOK CHRG-108jhrg96536 | Melvin L. Watt | committee member | W000207 |
| CHRG-108jhrg96536,Paul D. Ryan | THE ECONOMIC OUTLOOK CHRG-108jhrg96536 | Paul D. Ryan | committee member | R000570 |
| CHRG-108jhrg96536,Paul S. Sarbanes | THE ECONOMIC OUTLOOK CHRG-108jhrg96536 | Paul S. Sarbanes | committee member | S000064 |
| CHRG-108jhrg96536,Phil English | THE ECONOMIC OUTLOOK CHRG-108jhrg96536 | Phil English | committee member | |
| CHRG-108jhrg96536,Robert F. Bennett | THE ECONOMIC OUTLOOK CHRG-108jhrg96536 | Robert F. Bennett | committee member | B000382 |
| CHRG-108jhrg96536,Ron Paul | THE ECONOMIC OUTLOOK CHRG-108jhrg96536 | Ron Paul | committee member | P000583 |
| CHRG-108jhrg96536,Sam Brownback | THE ECONOMIC OUTLOOK CHRG-108jhrg96536 | Sam Brownback | committee member | |
| CHRG-108jhrg96536,Susan M. Collins | THE ECONOMIC OUTLOOK CHRG-108jhrg96536 | Susan M. Collins | committee member | C001035 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);