crec_speakers
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
52 rows where granule_id = "CREC-2018-04-26-pt1-PgH3643-2" sorted by speaker_name
This data as json, CSV (advanced)
Suggested facets: party, state
speaker_name >30
- A. Donald McEachin 1
- Adrian Smith 1
- Andre Carson 1
- Andy Biggs 1
- Barbara Comstock 1
- Bill Shuster 1
- Brenda L. Lawrence 1
- Charles J. "Chuck" Fleischmann 1
- Charlie Crist 1
- Clay Higgins 1
- Dana Rohrabacher 1
- Daniel Lipinski 1
- Daniel T. Kildee 1
- Darren Soto 1
- David N. Cicilline 1
- Derek Kilmer 1
- Donald S. Beyer, Jr. 1
- Ed Perlmutter 1
- Frederica S. Wilson 1
- Grace F. Napolitano 1
- Grace Meng 1
- Gwen Moore 1
- Henry Cuellar 1
- James R. Langevin 1
- Jared Polis 1
- Jason Lewis 1
- Jeff Denham 1
- Jenniffer Gonzalez-Colon 1
- Jim Banks 1
- Jim Costa 1
- …
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE crec_speakers (
granule_id TEXT NOT NULL REFERENCES congressional_record(granule_id),
speaker_name TEXT NOT NULL,
speaker_role TEXT,
bioguide_id TEXT,
party TEXT,
state TEXT,
PRIMARY KEY (granule_id, speaker_name)
);
CREATE INDEX idx_crec_speaker_name ON crec_speakers(speaker_name);
CREATE INDEX idx_crec_speaker_bioguide ON crec_speakers(bioguide_id);
CREATE INDEX idx_crec_speaker_granule ON crec_speakers(granule_id);