hearing_members
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
21 rows where package_id = "CHRG-108shrg82205" sorted by name
This data as json, CSV (advanced)
role 1
| Link | package_id | name ▼ | role | bioguide_id |
|---|---|---|---|---|
| CHRG-108shrg82205,Barbara Boxer | THE VIEWS FROM SATURN CHRG-108shrg82205 | Barbara Boxer | committee member | B000711 |
| CHRG-108shrg82205,Bill Nelson | THE VIEWS FROM SATURN CHRG-108shrg82205 | Bill Nelson | committee member | N000032 |
| CHRG-108shrg82205,Byron L. Dorgan | THE VIEWS FROM SATURN CHRG-108shrg82205 | Byron L. Dorgan | committee member | D000432 |
| CHRG-108shrg82205,Conrad R. Burns | THE VIEWS FROM SATURN CHRG-108shrg82205 | Conrad R. Burns | committee member | B001126 |
| CHRG-108shrg82205,Daniel K. Inouye | THE VIEWS FROM SATURN CHRG-108shrg82205 | Daniel K. Inouye | committee member | I000025 |
| CHRG-108shrg82205,Frank R. Lautenberg | THE VIEWS FROM SATURN CHRG-108shrg82205 | Frank R. Lautenberg | committee member | L000123 |
| CHRG-108shrg82205,George Allen | THE VIEWS FROM SATURN CHRG-108shrg82205 | George Allen | committee member | A000121 |
| CHRG-108shrg82205,Gordon H. Smith | THE VIEWS FROM SATURN CHRG-108shrg82205 | Gordon H. Smith | committee member | S001142 |
| CHRG-108shrg82205,JOHN D. ROCKEFELLER IV of West | THE VIEWS FROM SATURN CHRG-108shrg82205 | JOHN D. ROCKEFELLER IV of West | committee member | |
| CHRG-108shrg82205,John B. Breaux | THE VIEWS FROM SATURN CHRG-108shrg82205 | John B. Breaux | committee member | B000780 |
| CHRG-108shrg82205,John E. Sununu | THE VIEWS FROM SATURN CHRG-108shrg82205 | John E. Sununu | committee member | S001078 |
| CHRG-108shrg82205,John Ensign | THE VIEWS FROM SATURN CHRG-108shrg82205 | John Ensign | committee member | E000194 |
| CHRG-108shrg82205,John F. Kerry | THE VIEWS FROM SATURN CHRG-108shrg82205 | John F. Kerry | committee member | K000148 |
| CHRG-108shrg82205,John McCain | THE VIEWS FROM SATURN CHRG-108shrg82205 | John McCain | committee member | M000303 |
| CHRG-108shrg82205,Kay Bailey Hutchison | THE VIEWS FROM SATURN CHRG-108shrg82205 | Kay Bailey Hutchison | committee member | H001016 |
| CHRG-108shrg82205,Maria Cantwell | THE VIEWS FROM SATURN CHRG-108shrg82205 | Maria Cantwell | committee member | C000127 |
| CHRG-108shrg82205,Peter Fitzgerald | THE VIEWS FROM SATURN CHRG-108shrg82205 | Peter Fitzgerald | committee member | F000442 |
| CHRG-108shrg82205,Ron Wyden | THE VIEWS FROM SATURN CHRG-108shrg82205 | Ron Wyden | committee member | W000779 |
| CHRG-108shrg82205,Sam Brownback | THE VIEWS FROM SATURN CHRG-108shrg82205 | Sam Brownback | committee member | |
| CHRG-108shrg82205,Ted Stevens | THE VIEWS FROM SATURN CHRG-108shrg82205 | Ted Stevens | committee member | S000888 |
| CHRG-108shrg82205,Trent Lott | THE VIEWS FROM SATURN CHRG-108shrg82205 | Trent Lott | committee member | L000447 |
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);