hearing_members
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
18 rows where package_id = "CHRG-109shrg28849" sorted by name
This data as json, CSV (advanced)
role 1
| Link | package_id | name ▼ | role | bioguide_id |
|---|---|---|---|---|
| CHRG-109shrg28849,Barack Obama | PENDING NOMINATIONS CHRG-109shrg28849 | Barack Obama | committee member | O000167 |
| CHRG-109shrg28849,Barbara Boxer | PENDING NOMINATIONS CHRG-109shrg28849 | Barbara Boxer | committee member | B000711 |
| CHRG-109shrg28849,Christopher S. Bond | PENDING NOMINATIONS CHRG-109shrg28849 | Christopher S. Bond | committee member | B000611 |
| CHRG-109shrg28849,David Vitter | PENDING NOMINATIONS CHRG-109shrg28849 | David Vitter | committee member | V000127 |
| CHRG-109shrg28849,Frank R. Lautenberg | PENDING NOMINATIONS CHRG-109shrg28849 | Frank R. Lautenberg | committee member | L000123 |
| CHRG-109shrg28849,George V. Voinovich | PENDING NOMINATIONS CHRG-109shrg28849 | George V. Voinovich | committee member | V000126 |
| CHRG-109shrg28849,Hillary Rodham Clinton | PENDING NOMINATIONS CHRG-109shrg28849 | Hillary Rodham Clinton | committee member | C001041 |
| CHRG-109shrg28849,James M. Inhofe | PENDING NOMINATIONS CHRG-109shrg28849 | James M. Inhofe | committee member | I000024 |
| CHRG-109shrg28849,James M. Jeffords | PENDING NOMINATIONS CHRG-109shrg28849 | James M. Jeffords | committee member | J000072 |
| CHRG-109shrg28849,Jim DeMint | PENDING NOMINATIONS CHRG-109shrg28849 | Jim DeMint | committee member | D000595 |
| CHRG-109shrg28849,John Thune | PENDING NOMINATIONS CHRG-109shrg28849 | John Thune | committee member | T000250 |
| CHRG-109shrg28849,John Warner | PENDING NOMINATIONS CHRG-109shrg28849 | John Warner | committee member | W000153 |
| CHRG-109shrg28849,Johnny Isakson | PENDING NOMINATIONS CHRG-109shrg28849 | Johnny Isakson | committee member | I000055 |
| CHRG-109shrg28849,Joseph I. Lieberman | PENDING NOMINATIONS CHRG-109shrg28849 | Joseph I. Lieberman | committee member | L000304 |
| CHRG-109shrg28849,Lincoln Chafee | PENDING NOMINATIONS CHRG-109shrg28849 | Lincoln Chafee | committee member | C001040 |
| CHRG-109shrg28849,Lisa Murkowski | PENDING NOMINATIONS CHRG-109shrg28849 | Lisa Murkowski | committee member | M001153 |
| CHRG-109shrg28849,Max Baucus | PENDING NOMINATIONS CHRG-109shrg28849 | Max Baucus | committee member | B000243 |
| CHRG-109shrg28849,Thomas R. Carper | PENDING NOMINATIONS CHRG-109shrg28849 | Thomas R. Carper | committee member | C000174 |
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);