hearing_members
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
22 rows where package_id = "CHRG-113shrg91860" sorted by name
This data as json, CSV (advanced)
role 1
| Link | package_id | name ▼ | role | bioguide_id |
|---|---|---|---|---|
| CHRG-113shrg91860,Al Franken | HONORABLE NOMINATION CHRG-113shrg91860 | Al Franken | committee member | F000457 |
| CHRG-113shrg91860,Bernard Sanders | HONORABLE NOMINATION CHRG-113shrg91860 | Bernard Sanders | committee member | S000033 |
| CHRG-113shrg91860,Brian Schatz | HONORABLE NOMINATION CHRG-113shrg91860 | Brian Schatz | committee member | S001194 |
| CHRG-113shrg91860,Dean Heller | HONORABLE NOMINATION CHRG-113shrg91860 | Dean Heller | committee member | H001041 |
| CHRG-113shrg91860,Debbie Stabenow | HONORABLE NOMINATION CHRG-113shrg91860 | Debbie Stabenow | committee member | S000770 |
| CHRG-113shrg91860,James E. Risch | HONORABLE NOMINATION CHRG-113shrg91860 | James E. Risch | committee member | R000584 |
| CHRG-113shrg91860,Jeff Flake | HONORABLE NOMINATION CHRG-113shrg91860 | Jeff Flake | committee member | F000444 |
| CHRG-113shrg91860,Joe Manchin III | HONORABLE NOMINATION CHRG-113shrg91860 | Joe Manchin III | committee member | |
| CHRG-113shrg91860,John Barrasso | HONORABLE NOMINATION CHRG-113shrg91860 | John Barrasso | committee member | B001261 |
| CHRG-113shrg91860,John Hoeven | HONORABLE NOMINATION CHRG-113shrg91860 | John Hoeven | committee member | H001061 |
| CHRG-113shrg91860,Lamar Alexander | HONORABLE NOMINATION CHRG-113shrg91860 | Lamar Alexander | committee member | A000360 |
| CHRG-113shrg91860,Lisa Murkowski | HONORABLE NOMINATION CHRG-113shrg91860 | Lisa Murkowski | committee member | M001153 |
| CHRG-113shrg91860,Maria Cantwell | HONORABLE NOMINATION CHRG-113shrg91860 | Maria Cantwell | committee member | C000127 |
| CHRG-113shrg91860,Mark Udall | HONORABLE NOMINATION CHRG-113shrg91860 | Mark Udall | committee member | U000038 |
| CHRG-113shrg91860,Martin Heinrich | HONORABLE NOMINATION CHRG-113shrg91860 | Martin Heinrich | committee member | H001046 |
| CHRG-113shrg91860,Mary L. Landrieu | HONORABLE NOMINATION CHRG-113shrg91860 | Mary L. Landrieu | committee member | L000550 |
| CHRG-113shrg91860,Mike Lee | HONORABLE NOMINATION CHRG-113shrg91860 | Mike Lee | committee member | L000577 |
| CHRG-113shrg91860,Rob Portman | HONORABLE NOMINATION CHRG-113shrg91860 | Rob Portman | committee member | P000449 |
| CHRG-113shrg91860,Ron Wyden | HONORABLE NOMINATION CHRG-113shrg91860 | Ron Wyden | committee member | W000779 |
| CHRG-113shrg91860,Tammy Baldwin | HONORABLE NOMINATION CHRG-113shrg91860 | Tammy Baldwin | committee member | B001230 |
| CHRG-113shrg91860,Tim Johnson | HONORABLE NOMINATION CHRG-113shrg91860 | Tim Johnson | committee member | J000177 |
| CHRG-113shrg91860,Tim Scott | HONORABLE NOMINATION CHRG-113shrg91860 | Tim Scott | committee member | S001184 |
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);