hearing_members
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
28 rows where package_id = "CHRG-105shrg49637" sorted by name
This data as json, CSV (advanced)
role 1
| Link | package_id | name ▼ | role | bioguide_id |
|---|---|---|---|---|
| CHRG-105shrg49637,Arlen Specter | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Arlen Specter | committee member | S000709 |
| CHRG-105shrg49637,Barbara A. Mikulski | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Barbara A. Mikulski | committee member | M000702 |
| CHRG-105shrg49637,Barbara Boxer | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Barbara Boxer | committee member | B000711 |
| CHRG-105shrg49637,Ben Nighthorse Campbell | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Ben Nighthorse Campbell | committee member | C000077 |
| CHRG-105shrg49637,Byron L. Dorgan | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Byron L. Dorgan | committee member | D000432 |
| CHRG-105shrg49637,Christopher S. Bond | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Christopher S. Bond | committee member | B000611 |
| CHRG-105shrg49637,Conrad R. Burns | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Conrad R. Burns | committee member | B001126 |
| CHRG-105shrg49637,Dale Bumpers | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Dale Bumpers | committee member | B001057 |
| CHRG-105shrg49637,Daniel K. Inouye | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Daniel K. Inouye | committee member | I000025 |
| CHRG-105shrg49637,Ernest F. Hollings | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Ernest F. Hollings | committee member | H000725 |
| CHRG-105shrg49637,Frank R. Lautenberg | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Frank R. Lautenberg | committee member | L000123 |
| CHRG-105shrg49637,Harry Reid | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Harry Reid | committee member | R000146 |
| CHRG-105shrg49637,Herb Kohl | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Herb Kohl | committee member | K000305 |
| CHRG-105shrg49637,Judd Gregg | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Judd Gregg | committee member | G000445 |
| CHRG-105shrg49637,Kay Bailey Hutchison | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Kay Bailey Hutchison | committee member | H001016 |
| CHRG-105shrg49637,Larry E. Craig | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Larry E. Craig | committee member | C000858 |
| CHRG-105shrg49637,Lauch Faircloth | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Lauch Faircloth | committee member | |
| CHRG-105shrg49637,Mitch McConnell | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Mitch McConnell | committee member | M000355 |
| CHRG-105shrg49637,Patrick J. Leahy | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Patrick J. Leahy | committee member | L000174 |
| CHRG-105shrg49637,Patty Murray | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Patty Murray | committee member | M001111 |
| CHRG-105shrg49637,Pete V. Domenici | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Pete V. Domenici | committee member | D000407 |
| CHRG-105shrg49637,Richard C. Shelby | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Richard C. Shelby | committee member | S000320 |
| CHRG-105shrg49637,Robert C. Byrd | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Robert C. Byrd | committee member | B001210 |
| CHRG-105shrg49637,Robert F. Bennett | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Robert F. Bennett | committee member | B000382 |
| CHRG-105shrg49637,Slade Gorton | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Slade Gorton | committee member | |
| CHRG-105shrg49637,Ted Stevens | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Ted Stevens | committee member | S000888 |
| CHRG-105shrg49637,Thad Cochran | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Thad Cochran | committee member | C000567 |
| CHRG-105shrg49637,Tom Harkin | ALZHEIMER'S DISEASE CHRG-105shrg49637 | Tom Harkin | committee member | H000206 |
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);