hearing_members
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
16 rows where package_id = "CHRG-113shrg92907" sorted by name
This data as json, CSV (advanced)
role 1
| Link | package_id | name ▼ | role | bioguide_id |
|---|---|---|---|---|
| CHRG-113shrg92907,Carl Levin | NOMINATION OF EARL L. GAY CHRG-113shrg92907 | Carl Levin | committee member | L000261 |
| CHRG-113shrg92907,Claire McCaskill | NOMINATION OF EARL L. GAY CHRG-113shrg92907 | Claire McCaskill | committee member | M001170 |
| CHRG-113shrg92907,Heidi Heitkamp | NOMINATION OF EARL L. GAY CHRG-113shrg92907 | Heidi Heitkamp | committee member | H001069 |
| CHRG-113shrg92907,John McCain | NOMINATION OF EARL L. GAY CHRG-113shrg92907 | John McCain | committee member | M000303 |
| CHRG-113shrg92907,Jon Tester | NOMINATION OF EARL L. GAY CHRG-113shrg92907 | Jon Tester | committee member | T000464 |
| CHRG-113shrg92907,Kelly Ayotte | NOMINATION OF EARL L. GAY CHRG-113shrg92907 | Kelly Ayotte | committee member | A000368 |
| CHRG-113shrg92907,Mark Begich | NOMINATION OF EARL L. GAY CHRG-113shrg92907 | Mark Begich | committee member | B001265 |
| CHRG-113shrg92907,Mark L. Pryor | NOMINATION OF EARL L. GAY CHRG-113shrg92907 | Mark L. Pryor | committee member | P000590 |
| CHRG-113shrg92907,Mary L. Landrieu | NOMINATION OF EARL L. GAY CHRG-113shrg92907 | Mary L. Landrieu | committee member | L000550 |
| CHRG-113shrg92907,Michael B. Enzi | NOMINATION OF EARL L. GAY CHRG-113shrg92907 | Michael B. Enzi | committee member | E000285 |
| CHRG-113shrg92907,Rand Paul | NOMINATION OF EARL L. GAY CHRG-113shrg92907 | Rand Paul | committee member | P000603 |
| CHRG-113shrg92907,Rob Portman | NOMINATION OF EARL L. GAY CHRG-113shrg92907 | Rob Portman | committee member | P000449 |
| CHRG-113shrg92907,Ron Johnson | NOMINATION OF EARL L. GAY CHRG-113shrg92907 | Ron Johnson | committee member | J000293 |
| CHRG-113shrg92907,Tammy Baldwin | NOMINATION OF EARL L. GAY CHRG-113shrg92907 | Tammy Baldwin | committee member | B001230 |
| CHRG-113shrg92907,Thomas R. Carper | NOMINATION OF EARL L. GAY CHRG-113shrg92907 | Thomas R. Carper | committee member | C000174 |
| CHRG-113shrg92907,Tom Coburn | NOMINATION OF EARL L. GAY CHRG-113shrg92907 | Tom Coburn | committee member | C000560 |
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);