home / openregs

hearing_members

Committee members present at hearings.

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

21 rows where package_id = "CHRG-112shrg78020" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

  • committee member 21
Link package_id name ▼ role bioguide_id
CHRG-112shrg78020,Bill Nelson AMERICA'S INVISIBLE EPIDEMIC: PREVENTING ELDER FINANCIAL ABUSE CHRG-112shrg78020 Bill Nelson committee member N000032
CHRG-112shrg78020,Bob Corker AMERICA'S INVISIBLE EPIDEMIC: PREVENTING ELDER FINANCIAL ABUSE CHRG-112shrg78020 Bob Corker committee member C001071
CHRG-112shrg78020,Claire McCaskill AMERICA'S INVISIBLE EPIDEMIC: PREVENTING ELDER FINANCIAL ABUSE CHRG-112shrg78020 Claire McCaskill committee member M001170
CHRG-112shrg78020,Dean Heller AMERICA'S INVISIBLE EPIDEMIC: PREVENTING ELDER FINANCIAL ABUSE CHRG-112shrg78020 Dean Heller committee member H001041
CHRG-112shrg78020,Herb Kohl AMERICA'S INVISIBLE EPIDEMIC: PREVENTING ELDER FINANCIAL ABUSE CHRG-112shrg78020 Herb Kohl committee member K000305
CHRG-112shrg78020,Jerry Moran AMERICA'S INVISIBLE EPIDEMIC: PREVENTING ELDER FINANCIAL ABUSE CHRG-112shrg78020 Jerry Moran committee member M000934
CHRG-112shrg78020,Joe Manchin III AMERICA'S INVISIBLE EPIDEMIC: PREVENTING ELDER FINANCIAL ABUSE CHRG-112shrg78020 Joe Manchin III committee member  
CHRG-112shrg78020,Kirsten E. Gillibrand AMERICA'S INVISIBLE EPIDEMIC: PREVENTING ELDER FINANCIAL ABUSE CHRG-112shrg78020 Kirsten E. Gillibrand committee member G000555
CHRG-112shrg78020,Lindsey Graham AMERICA'S INVISIBLE EPIDEMIC: PREVENTING ELDER FINANCIAL ABUSE CHRG-112shrg78020 Lindsey Graham committee member G000359
CHRG-112shrg78020,Mark Kirk AMERICA'S INVISIBLE EPIDEMIC: PREVENTING ELDER FINANCIAL ABUSE CHRG-112shrg78020 Mark Kirk committee member K000360
CHRG-112shrg78020,Mark Udall AMERICA'S INVISIBLE EPIDEMIC: PREVENTING ELDER FINANCIAL ABUSE CHRG-112shrg78020 Mark Udall committee member U000038
CHRG-112shrg78020,Michael F. Bennet AMERICA'S INVISIBLE EPIDEMIC: PREVENTING ELDER FINANCIAL ABUSE CHRG-112shrg78020 Michael F. Bennet committee member B001267
CHRG-112shrg78020,Orrin G. Hatch AMERICA'S INVISIBLE EPIDEMIC: PREVENTING ELDER FINANCIAL ABUSE CHRG-112shrg78020 Orrin G. Hatch committee member H000338
CHRG-112shrg78020,Richard Blumenthal AMERICA'S INVISIBLE EPIDEMIC: PREVENTING ELDER FINANCIAL ABUSE CHRG-112shrg78020 Richard Blumenthal committee member B001277
CHRG-112shrg78020,Richard C. Shelby AMERICA'S INVISIBLE EPIDEMIC: PREVENTING ELDER FINANCIAL ABUSE CHRG-112shrg78020 Richard C. Shelby committee member S000320
CHRG-112shrg78020,Robert P. Casey Jr. AMERICA'S INVISIBLE EPIDEMIC: PREVENTING ELDER FINANCIAL ABUSE CHRG-112shrg78020 Robert P. Casey Jr. committee member  
CHRG-112shrg78020,Ron Johnson AMERICA'S INVISIBLE EPIDEMIC: PREVENTING ELDER FINANCIAL ABUSE CHRG-112shrg78020 Ron Johnson committee member J000293
CHRG-112shrg78020,Ron Wyden AMERICA'S INVISIBLE EPIDEMIC: PREVENTING ELDER FINANCIAL ABUSE CHRG-112shrg78020 Ron Wyden committee member W000779
CHRG-112shrg78020,Saxby Chambliss AMERICA'S INVISIBLE EPIDEMIC: PREVENTING ELDER FINANCIAL ABUSE CHRG-112shrg78020 Saxby Chambliss committee member C000286
CHRG-112shrg78020,Sheldon Whitehouse AMERICA'S INVISIBLE EPIDEMIC: PREVENTING ELDER FINANCIAL ABUSE CHRG-112shrg78020 Sheldon Whitehouse committee member W000802
CHRG-112shrg78020,Susan M. Collins AMERICA'S INVISIBLE EPIDEMIC: PREVENTING ELDER FINANCIAL ABUSE CHRG-112shrg78020 Susan M. Collins committee member C001035

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);
Powered by Datasette · Queries took 9.571ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API