hearing_members
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
20 rows where package_id = "CHRG-109shrg71810" sorted by name
This data as json, CSV (advanced)
role 1
| Link | package_id | name ▼ | role | bioguide_id |
|---|---|---|---|---|
| CHRG-109shrg71810,Barbara Boxer | ONLINE CHILD PORNOGRAPHY CHRG-109shrg71810 | Barbara Boxer | committee member | B000711 |
| CHRG-109shrg71810,Bill Nelson | ONLINE CHILD PORNOGRAPHY CHRG-109shrg71810 | Bill Nelson | committee member | N000032 |
| CHRG-109shrg71810,Byron L. Dorgan | ONLINE CHILD PORNOGRAPHY CHRG-109shrg71810 | Byron L. Dorgan | committee member | D000432 |
| CHRG-109shrg71810,Conrad R. Burns | ONLINE CHILD PORNOGRAPHY CHRG-109shrg71810 | Conrad R. Burns | committee member | B001126 |
| CHRG-109shrg71810,Daniel K. Inouye | ONLINE CHILD PORNOGRAPHY CHRG-109shrg71810 | Daniel K. Inouye | committee member | I000025 |
| CHRG-109shrg71810,David Vitter | ONLINE CHILD PORNOGRAPHY CHRG-109shrg71810 | David Vitter | committee member | V000127 |
| CHRG-109shrg71810,Frank R. Lautenberg | ONLINE CHILD PORNOGRAPHY CHRG-109shrg71810 | Frank R. Lautenberg | committee member | L000123 |
| CHRG-109shrg71810,George Allen | ONLINE CHILD PORNOGRAPHY CHRG-109shrg71810 | George Allen | committee member | A000121 |
| CHRG-109shrg71810,Gordon H. Smith | ONLINE CHILD PORNOGRAPHY CHRG-109shrg71810 | Gordon H. Smith | committee member | S001142 |
| CHRG-109shrg71810,JOHN D. ROCKEFELLER IV of West | ONLINE CHILD PORNOGRAPHY CHRG-109shrg71810 | JOHN D. ROCKEFELLER IV of West | committee member | |
| CHRG-109shrg71810,Jim DeMint | ONLINE CHILD PORNOGRAPHY CHRG-109shrg71810 | Jim DeMint | committee member | D000595 |
| CHRG-109shrg71810,John E. Sununu | ONLINE CHILD PORNOGRAPHY CHRG-109shrg71810 | John E. Sununu | committee member | S001078 |
| CHRG-109shrg71810,John Ensign | ONLINE CHILD PORNOGRAPHY CHRG-109shrg71810 | John Ensign | committee member | E000194 |
| CHRG-109shrg71810,John F. Kerry | ONLINE CHILD PORNOGRAPHY CHRG-109shrg71810 | John F. Kerry | committee member | K000148 |
| CHRG-109shrg71810,John McCain | ONLINE CHILD PORNOGRAPHY CHRG-109shrg71810 | John McCain | committee member | M000303 |
| CHRG-109shrg71810,Maria Cantwell | ONLINE CHILD PORNOGRAPHY CHRG-109shrg71810 | Maria Cantwell | committee member | C000127 |
| CHRG-109shrg71810,Mark L. Pryor | ONLINE CHILD PORNOGRAPHY CHRG-109shrg71810 | Mark L. Pryor | committee member | P000590 |
| CHRG-109shrg71810,Olympia J. Snowe | ONLINE CHILD PORNOGRAPHY CHRG-109shrg71810 | Olympia J. Snowe | committee member | S000663 |
| CHRG-109shrg71810,Ted Stevens | ONLINE CHILD PORNOGRAPHY CHRG-109shrg71810 | Ted Stevens | committee member | S000888 |
| CHRG-109shrg71810,Trent Lott | ONLINE CHILD PORNOGRAPHY CHRG-109shrg71810 | 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);