crec_speakers
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
951,495 rows sorted by speaker_name
This data as json, CSV (advanced)
speaker_name >30
- Harry Reid 19,332
- Mitch McConnell 15,942
- Richard J. Durbin 13,384
- Charles E. Schumer 10,833
- Sheila Jackson Lee 8,123
- John Thune 7,262
- Patrick J. Leahy 6,941
- Chuck Grassley 6,427
- William H. Frist 5,627
- John Cornyn 5,258
- 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,612
- Steny H. Hoyer 3,542
- Dennis J. Kucinich 3,495
- Jack Reed 3,437
- Sherrod Brown 3,396
- Frank Pallone, Jr. 3,395
- Robert Menendez 3,391
- Tom Harkin 3,371
- Patty Murray 3,370
- Carolyn B. Maloney 3,309
- Susan M. Collins 3,272
- …
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);