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

15 rows where package_id = "CHRG-118shrg56048" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

role 1

  • committee member 15
Link package_id name ▼ role bioguide_id
CHRG-118shrg56048,Gary C. Peters ORIGINS OF COVID-19: AN EXAMINATION OF AVAILABLE EVIDENCE CHRG-118shrg56048 Gary C. Peters committee member P000595
CHRG-118shrg56048,Jacky Rosen ORIGINS OF COVID-19: AN EXAMINATION OF AVAILABLE EVIDENCE CHRG-118shrg56048 Jacky Rosen committee member R000608
CHRG-118shrg56048,James Lankford ORIGINS OF COVID-19: AN EXAMINATION OF AVAILABLE EVIDENCE CHRG-118shrg56048 James Lankford committee member L000575
CHRG-118shrg56048,Jon Ossoff ORIGINS OF COVID-19: AN EXAMINATION OF AVAILABLE EVIDENCE CHRG-118shrg56048 Jon Ossoff committee member O000174
CHRG-118shrg56048,Josh Hawley ORIGINS OF COVID-19: AN EXAMINATION OF AVAILABLE EVIDENCE CHRG-118shrg56048 Josh Hawley committee member H001089
CHRG-118shrg56048,Kyrsten Sinema ORIGINS OF COVID-19: AN EXAMINATION OF AVAILABLE EVIDENCE CHRG-118shrg56048 Kyrsten Sinema committee member S001191
CHRG-118shrg56048,Laphonza R. Butler ORIGINS OF COVID-19: AN EXAMINATION OF AVAILABLE EVIDENCE CHRG-118shrg56048 Laphonza R. Butler committee member B001320
CHRG-118shrg56048,Margaret Wood Hassan ORIGINS OF COVID-19: AN EXAMINATION OF AVAILABLE EVIDENCE CHRG-118shrg56048 Margaret Wood Hassan committee member H001076
CHRG-118shrg56048,Mitt Romney ORIGINS OF COVID-19: AN EXAMINATION OF AVAILABLE EVIDENCE CHRG-118shrg56048 Mitt Romney committee member R000615
CHRG-118shrg56048,Rand Paul ORIGINS OF COVID-19: AN EXAMINATION OF AVAILABLE EVIDENCE CHRG-118shrg56048 Rand Paul committee member P000603
CHRG-118shrg56048,Richard Blumenthal ORIGINS OF COVID-19: AN EXAMINATION OF AVAILABLE EVIDENCE CHRG-118shrg56048 Richard Blumenthal committee member B001277
CHRG-118shrg56048,Rick Scott ORIGINS OF COVID-19: AN EXAMINATION OF AVAILABLE EVIDENCE CHRG-118shrg56048 Rick Scott committee member S001217
CHRG-118shrg56048,Roger Marshall ORIGINS OF COVID-19: AN EXAMINATION OF AVAILABLE EVIDENCE CHRG-118shrg56048 Roger Marshall committee member M001198
CHRG-118shrg56048,Ron Johnson ORIGINS OF COVID-19: AN EXAMINATION OF AVAILABLE EVIDENCE CHRG-118shrg56048 Ron Johnson committee member J000293
CHRG-118shrg56048,Thomas R. Carper ORIGINS OF COVID-19: AN EXAMINATION OF AVAILABLE EVIDENCE CHRG-118shrg56048 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);
Powered by Datasette · Queries took 3.393ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API