hearing_members

Committee members present at hearings.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

20 rows where package_id = "CHRG-109shrg31449" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

Link package_id name ▼ role bioguide_id
CHRG-109shrg31449,Bill Nelson SECURING MEDICAID'S FUTURE: SPOTLIGHT ON MANAGED CARE CHRG-109shrg31449 Bill Nelson committee member N000032
CHRG-109shrg31449,Blanche L. Lincoln SECURING MEDICAID'S FUTURE: SPOTLIGHT ON MANAGED CARE CHRG-109shrg31449 Blanche L. Lincoln committee member L000035
CHRG-109shrg31449,Conrad R. Burns SECURING MEDICAID'S FUTURE: SPOTLIGHT ON MANAGED CARE CHRG-109shrg31449 Conrad R. Burns committee member B001126
CHRG-109shrg31449,Elizabeth Dole SECURING MEDICAID'S FUTURE: SPOTLIGHT ON MANAGED CARE CHRG-109shrg31449 Elizabeth Dole committee member D000601
CHRG-109shrg31449,Evan Bayh SECURING MEDICAID'S FUTURE: SPOTLIGHT ON MANAGED CARE CHRG-109shrg31449 Evan Bayh committee member B001233
CHRG-109shrg31449,Gordon H. Smith SECURING MEDICAID'S FUTURE: SPOTLIGHT ON MANAGED CARE CHRG-109shrg31449 Gordon H. Smith committee member S001142
CHRG-109shrg31449,Herb Kohl SECURING MEDICAID'S FUTURE: SPOTLIGHT ON MANAGED CARE CHRG-109shrg31449 Herb Kohl committee member K000305
CHRG-109shrg31449,Hillary Rodham Clinton SECURING MEDICAID'S FUTURE: SPOTLIGHT ON MANAGED CARE CHRG-109shrg31449 Hillary Rodham Clinton committee member C001041
CHRG-109shrg31449,James M. Jeffords SECURING MEDICAID'S FUTURE: SPOTLIGHT ON MANAGED CARE CHRG-109shrg31449 James M. Jeffords committee member J000072
CHRG-109shrg31449,Jim DeMint SECURING MEDICAID'S FUTURE: SPOTLIGHT ON MANAGED CARE CHRG-109shrg31449 Jim DeMint committee member D000595
CHRG-109shrg31449,Jim Talent SECURING MEDICAID'S FUTURE: SPOTLIGHT ON MANAGED CARE CHRG-109shrg31449 Jim Talent committee member  
CHRG-109shrg31449,Ken Salazar SECURING MEDICAID'S FUTURE: SPOTLIGHT ON MANAGED CARE CHRG-109shrg31449 Ken Salazar committee member S001163
CHRG-109shrg31449,Lamar Alexander SECURING MEDICAID'S FUTURE: SPOTLIGHT ON MANAGED CARE CHRG-109shrg31449 Lamar Alexander committee member A000360
CHRG-109shrg31449,Larry E. Craig SECURING MEDICAID'S FUTURE: SPOTLIGHT ON MANAGED CARE CHRG-109shrg31449 Larry E. Craig committee member C000858
CHRG-109shrg31449,Mel Martinez SECURING MEDICAID'S FUTURE: SPOTLIGHT ON MANAGED CARE CHRG-109shrg31449 Mel Martinez committee member M001162
CHRG-109shrg31449,Richard C. Shelby SECURING MEDICAID'S FUTURE: SPOTLIGHT ON MANAGED CARE CHRG-109shrg31449 Richard C. Shelby committee member S000320
CHRG-109shrg31449,Rick Santorum SECURING MEDICAID'S FUTURE: SPOTLIGHT ON MANAGED CARE CHRG-109shrg31449 Rick Santorum committee member  
CHRG-109shrg31449,Ron Wyden SECURING MEDICAID'S FUTURE: SPOTLIGHT ON MANAGED CARE CHRG-109shrg31449 Ron Wyden committee member W000779
CHRG-109shrg31449,Susan M. Collins SECURING MEDICAID'S FUTURE: SPOTLIGHT ON MANAGED CARE CHRG-109shrg31449 Susan M. Collins committee member C001035
CHRG-109shrg31449,Thomas R. Carper SECURING MEDICAID'S FUTURE: SPOTLIGHT ON MANAGED CARE CHRG-109shrg31449 Thomas R. Carper committee member C000174

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);