hearing_members
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
20 rows where package_id = "CHRG-113jhrg88497" sorted by name
This data as json, CSV (advanced)
role 1
| Link | package_id | name ▼ | role | bioguide_id |
|---|---|---|---|---|
| CHRG-113jhrg88497,Amy Klobuchar | THE ECONOMIC OUTLOOK CHRG-113jhrg88497 | Amy Klobuchar | committee member | K000367 |
| CHRG-113jhrg88497,Bernard Sanders | THE ECONOMIC OUTLOOK CHRG-113jhrg88497 | Bernard Sanders | committee member | S000033 |
| CHRG-113jhrg88497,Carolyn B. Maloney | THE ECONOMIC OUTLOOK CHRG-113jhrg88497 | Carolyn B. Maloney | committee member | M000087 |
| CHRG-113jhrg88497,Christopher Murphy | THE ECONOMIC OUTLOOK CHRG-113jhrg88497 | Christopher Murphy | committee member | M001169 |
| CHRG-113jhrg88497,Daniel Coats | THE ECONOMIC OUTLOOK CHRG-113jhrg88497 | Daniel Coats | committee member | C000542 |
| CHRG-113jhrg88497,Elijah E. Cummings | THE ECONOMIC OUTLOOK CHRG-113jhrg88497 | Elijah E. Cummings | committee member | C000984 |
| CHRG-113jhrg88497,Erik Paulsen | THE ECONOMIC OUTLOOK CHRG-113jhrg88497 | Erik Paulsen | committee member | P000594 |
| CHRG-113jhrg88497,John Campbell | THE ECONOMIC OUTLOOK CHRG-113jhrg88497 | John Campbell | committee member | C000091 |
| CHRG-113jhrg88497,John K. Delaney | THE ECONOMIC OUTLOOK CHRG-113jhrg88497 | John K. Delaney | committee member | D000620 |
| CHRG-113jhrg88497,Justin Amash | THE ECONOMIC OUTLOOK CHRG-113jhrg88497 | Justin Amash | committee member | A000367 |
| CHRG-113jhrg88497,Kevin Brady | THE ECONOMIC OUTLOOK CHRG-113jhrg88497 | Kevin Brady | committee member | B000755 |
| CHRG-113jhrg88497,Loretta Sanchez | THE ECONOMIC OUTLOOK CHRG-113jhrg88497 | Loretta Sanchez | committee member | S000030 |
| CHRG-113jhrg88497,Mark L. Pryor | THE ECONOMIC OUTLOOK CHRG-113jhrg88497 | Mark L. Pryor | committee member | P000590 |
| CHRG-113jhrg88497,Martin Heinrich | THE ECONOMIC OUTLOOK CHRG-113jhrg88497 | Martin Heinrich | committee member | H001046 |
| CHRG-113jhrg88497,Mike Lee | THE ECONOMIC OUTLOOK CHRG-113jhrg88497 | Mike Lee | committee member | L000577 |
| CHRG-113jhrg88497,Patrick J. Toomey | THE ECONOMIC OUTLOOK CHRG-113jhrg88497 | Patrick J. Toomey | committee member | T000461 |
| CHRG-113jhrg88497,Richard L. Hanna | THE ECONOMIC OUTLOOK CHRG-113jhrg88497 | Richard L. Hanna | committee member | H001051 |
| CHRG-113jhrg88497,Robert P. Casey Jr. | THE ECONOMIC OUTLOOK CHRG-113jhrg88497 | Robert P. Casey Jr. | committee member | |
| CHRG-113jhrg88497,Roger F. Wicker | THE ECONOMIC OUTLOOK CHRG-113jhrg88497 | Roger F. Wicker | committee member | W000437 |
| CHRG-113jhrg88497,Sean P. Duffy | THE ECONOMIC OUTLOOK CHRG-113jhrg88497 | Sean P. Duffy | committee member | D000614 |
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);