crec_speakers
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
957,309 rows sorted by speaker_name
This data as json, CSV (advanced)
speaker_name >30
- Harry Reid 19,332
- Mitch McConnell 15,946
- Richard J. Durbin 13,531
- Charles E. Schumer 10,977
- Sheila Jackson Lee 8,123
- John Thune 7,571
- Patrick J. Leahy 6,941
- Chuck Grassley 6,476
- William H. Frist 5,627
- John Cornyn 5,291
- Trent Lott 5,044
- John McCain 4,733
- Orrin G. Hatch 4,426
- Dianne Feinstein 4,150
- Edward M. Kennedy 3,973
- Carl Levin 3,965
- Byron L. Dorgan 3,880
- Barbara Boxer 3,877
- Benjamin L. Cardin 3,753
- Ron Wyden 3,640
- Steny H. Hoyer 3,546
- Dennis J. Kucinich 3,495
- Jack Reed 3,451
- Frank Pallone, Jr. 3,411
- Sherrod Brown 3,396
- Robert Menendez 3,394
- Patty Murray 3,386
- Tom Harkin 3,371
- Carolyn B. Maloney 3,309
- John Barrasso 3,296
- …
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);