hearing_members
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
19 rows where package_id = "CHRG-116shrg42592" sorted by name
This data as json, CSV (advanced)
role 1
| Link | package_id | name ▼ | role | bioguide_id |
|---|---|---|---|---|
| CHRG-116shrg42592,Bernard Sanders | PENDING LEGISLATION CHRG-116shrg42592 | Bernard Sanders | committee member | S000033 |
| CHRG-116shrg42592,Bill Cassidy | PENDING LEGISLATION CHRG-116shrg42592 | Bill Cassidy | committee member | C001075 |
| CHRG-116shrg42592,CATHERINE CORTEZ MASTO of Nevada | PENDING LEGISLATION CHRG-116shrg42592 | CATHERINE CORTEZ MASTO of Nevada | committee member | |
| CHRG-116shrg42592,Cindy Hyde-Smith | PENDING LEGISLATION CHRG-116shrg42592 | Cindy Hyde-Smith | committee member | H001079 |
| CHRG-116shrg42592,Cory Gardner | PENDING LEGISLATION CHRG-116shrg42592 | Cory Gardner | committee member | G000562 |
| CHRG-116shrg42592,Debbie Stabenow | PENDING LEGISLATION CHRG-116shrg42592 | Debbie Stabenow | committee member | S000770 |
| CHRG-116shrg42592,James E. Risch | PENDING LEGISLATION CHRG-116shrg42592 | James E. Risch | committee member | R000584 |
| CHRG-116shrg42592,Joe Manchin III | PENDING LEGISLATION CHRG-116shrg42592 | Joe Manchin III | committee member | |
| CHRG-116shrg42592,John Barrasso | PENDING LEGISLATION CHRG-116shrg42592 | John Barrasso | committee member | B001261 |
| CHRG-116shrg42592,John Hoeven | PENDING LEGISLATION CHRG-116shrg42592 | John Hoeven | committee member | H001061 |
| CHRG-116shrg42592,Lamar Alexander | PENDING LEGISLATION CHRG-116shrg42592 | Lamar Alexander | committee member | A000360 |
| CHRG-116shrg42592,Lisa Murkowski | PENDING LEGISLATION CHRG-116shrg42592 | Lisa Murkowski | committee member | M001153 |
| CHRG-116shrg42592,Maria Cantwell | PENDING LEGISLATION CHRG-116shrg42592 | Maria Cantwell | committee member | C000127 |
| CHRG-116shrg42592,Martha McSally | PENDING LEGISLATION CHRG-116shrg42592 | Martha McSally | committee member | M001197 |
| CHRG-116shrg42592,Martin Heinrich | PENDING LEGISLATION CHRG-116shrg42592 | Martin Heinrich | committee member | H001046 |
| CHRG-116shrg42592,Mazie K. Hirono | PENDING LEGISLATION CHRG-116shrg42592 | Mazie K. Hirono | committee member | H001042 |
| CHRG-116shrg42592,Mike Lee | PENDING LEGISLATION CHRG-116shrg42592 | Mike Lee | committee member | L000577 |
| CHRG-116shrg42592,Ron Wyden | PENDING LEGISLATION CHRG-116shrg42592 | Ron Wyden | committee member | W000779 |
| CHRG-116shrg42592,Steve Daines | PENDING LEGISLATION CHRG-116shrg42592 | Steve Daines | committee member | D000618 |
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);
CREATE INDEX idx_hearing_members_bioguide ON hearing_members(bioguide_id);