legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
409 rows where "start" is on date 1901-12-02 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, party, end (date)
Link | rowid | legislator_id | type | state ▼ | start | end | class | party | district | how | party_affiliations | url | caucus | address | phone | fax | contact_form | office | state_rank | rss_url | end-type |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14096 | 14096 | John Morgan M000954 | sen | AL | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
14504 | 14504 | Charles Thompson T000196 | rep | AL | 1901-12-02 | 1903-03-03 | Democrat | 5 | |||||||||||||
14587 | 14587 | Sydney Bowie B000695 | rep | AL | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
15307 | 15307 | Ariosto Wiley W000466 | rep | AL | 1901-12-02 | 1903-03-03 | Democrat | 2 | |||||||||||||
16330 | 16330 | Henry Clayton C000495 | rep | AL | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
16542 | 16542 | William Richardson R000227 | rep | AL | 1901-12-02 | 1903-03-03 | Democrat | 8 | |||||||||||||
16605 | 16605 | George Taylor T000078 | rep | AL | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
17553 | 17553 | John Bankhead B000110 | rep | AL | 1901-12-02 | 1903-03-03 | Democrat | 6 | |||||||||||||
17581 | 17581 | John Burnett B001121 | rep | AL | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
18527 | 18527 | Oscar Underwood U000013 | rep | AL | 1901-12-02 | 1903-03-03 | Democrat | 9 | |||||||||||||
13861 | 13861 | James Berry B000418 | sen | AR | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
14061 | 14061 | Philip McCulloch M000391 | rep | AR | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
14073 | 14073 | Thomas McRae M000597 | rep | AR | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14296 | 14296 | Hugh Dinsmore D000358 | rep | AR | 1901-12-02 | 1903-03-03 | Democrat | 5 | |||||||||||||
14790 | 14790 | John Little L000352 | rep | AR | 1901-12-02 | 1903-03-03 | Democrat | 2 | |||||||||||||
15008 | 15008 | Stephen Brundidge B000979 | rep | AR | 1901-12-02 | 1903-03-03 | Democrat | 6 | |||||||||||||
15712 | 15712 | Charles Reid R000142 | rep | AR | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
16975 | 16975 | Marcus Smith S000589 | rep | AZ | 1901-12-02 | 1903-03-03 | Democrat | 0 | |||||||||||||
13908 | 13908 | Frank Coombs C000741 | rep | CA | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
14056 | 14056 | Eugene Loud L000448 | rep | CA | 1901-12-02 | 1903-03-03 | Republican | 5 | |||||||||||||
14219 | 14219 | Samuel Woods W000726 | rep | CA | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
14414 | 14414 | Victor Metcalf M000672 | rep | CA | 1901-12-02 | 1903-03-03 | Republican | 3 | |||||||||||||
15642 | 15642 | James McLachlan M000532 | rep | CA | 1901-12-02 | 1903-03-03 | Republican | 6 | |||||||||||||
16122 | 16122 | James Needham N000021 | rep | CA | 1901-12-02 | 1903-03-03 | Republican | 7 | |||||||||||||
18697 | 18697 | Julius Kahn K000003 | rep | CA | 1901-12-02 | 1903-03-03 | Republican | 4 | |||||||||||||
13854 | 13854 | John Bell B000341 | rep | CO | 1901-12-02 | 1903-03-03 | Populist | 2 | |||||||||||||
14122 | 14122 | Thomas Patterson P000130 | sen | CO | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
16562 | 16562 | John Shafroth S000279 | rep | CO | 1901-12-02 | 1903-03-03 | Silver Republican | 1 | |||||||||||||
14152 | 14152 | Charles Russell R000521 | rep | CT | 1901-12-02 | 1903-03-03 | Republican | 3 | |||||||||||||
15749 | 15749 | Nehemiah Sperry S000733 | rep | CT | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
16000 | 16000 | Edward Henry H000505 | rep | CT | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
17276 | 17276 | Ebenezer Hill H000591 | rep | CT | 1901-12-02 | 1903-03-03 | Republican | 4 | |||||||||||||
17543 | 17543 | Lewis Ball B000100 | rep | DE | 1901-12-02 | 1903-03-03 | Republican | 0 | |||||||||||||
14284 | 14284 | Robert Davis D000132 | rep | FL | 1901-12-02 | 1903-03-03 | Democrat | 2 | |||||||||||||
16990 | 16990 | Stephen Sparkman S000702 | rep | FL | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
13958 | 13958 | William Fleming F000198 | rep | GA | 1901-12-02 | 1903-03-03 | Democrat | 10 | |||||||||||||
14393 | 14393 | John Maddox M000040 | rep | GA | 1901-12-02 | 1903-03-03 | Democrat | 7 | |||||||||||||
14490 | 14490 | Farish Tate T000046 | rep | GA | 1901-12-02 | 1903-03-03 | Democrat | 9 | |||||||||||||
14777 | 14777 | Rufus Lester L000255 | rep | GA | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
15197 | 15197 | Elijah Lewis L000281 | rep | GA | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
15509 | 15509 | James Griggs G000473 | rep | GA | 1901-12-02 | 1903-03-03 | Democrat | 2 | |||||||||||||
15524 | 15524 | William Howard H000848 | rep | GA | 1901-12-02 | 1903-03-03 | Democrat | 8 | |||||||||||||
15605 | 15605 | Leonidas Livingston L000368 | rep | GA | 1901-12-02 | 1903-03-03 | Democrat | 5 | |||||||||||||
15881 | 15881 | William Brantley B000770 | rep | GA | 1901-12-02 | 1903-03-03 | Democrat | 11 | |||||||||||||
16257 | 16257 | Augustus Bacon B000014 | sen | GA | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
16276 | 16276 | Charles Bartlett B000199 | rep | GA | 1901-12-02 | 1903-03-03 | Democrat | 6 | |||||||||||||
17046 | 17046 | William Adamson A000051 | rep | GA | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
14217 | 14217 | Robert Wilcox W000459 | rep | HI | 1901-12-02 | 1903-03-03 | -1 | ||||||||||||||
13999 | 13999 | David Henderson H000478 | rep | IA | 1901-12-02 | 1903-03-03 | Republican | 3 | |||||||||||||
14144 | 14144 | John Rumple R000504 | rep | IA | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
14502 | 14502 | Lot Thomas T000179 | rep | IA | 1901-12-02 | 1903-03-03 | Republican | 11 | |||||||||||||
14698 | 14698 | Thomas Hedge H000441 | rep | IA | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
14765 | 14765 | John Lacey L000010 | rep | IA | 1901-12-02 | 1903-03-03 | Republican | 6 | |||||||||||||
15030 | 15030 | James Conner C000690 | rep | IA | 1901-12-02 | 1903-03-03 | Republican | 10 | |||||||||||||
15046 | 15046 | Robert Cousins C000811 | rep | IA | 1901-12-02 | 1903-03-03 | Republican | 5 | |||||||||||||
15149 | 15149 | William Hepburn H000523 | rep | IA | 1901-12-02 | 1903-03-03 | Republican | 8 | |||||||||||||
15551 | 15551 | John Hull H000942 | rep | IA | 1901-12-02 | 1903-03-03 | Republican | 7 | |||||||||||||
16187 | 16187 | Walter Smith S000623 | rep | IA | 1901-12-02 | 1903-03-03 | Republican | 9 | |||||||||||||
20481 | 20481 | Gilbert Haugen H000350 | rep | IA | 1901-12-02 | 1903-03-03 | Republican | 4 | |||||||||||||
13939 | 13939 | Fred Dubois D000509 | sen | ID | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
13967 | 13967 | Thomas Glenn G000239 | rep | ID | 1901-12-02 | 1903-03-03 | Populist | 1 | |||||||||||||
13954 | 13954 | John Feely F000058 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 2 | |||||||||||||
14025 | 14025 | Thomas Jett J000102 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 18 | |||||||||||||
14032 | 14032 | Frederick Kern K000131 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 21 | |||||||||||||
14079 | 14079 | J. Mickey M000694 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 15 | |||||||||||||
14139 | 14139 | Walter Reeves R000139 | rep | IL | 1901-12-02 | 1903-03-03 | Republican | 11 | |||||||||||||
14156 | 14156 | Thomas Selby S000231 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 16 | |||||||||||||
14279 | 14279 | Joseph Crowley C000943 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 19 | |||||||||||||
14314 | 14314 | George Foster F000303 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14355 | 14355 | Albert Hopkins H000770 | rep | IL | 1901-12-02 | 1903-03-03 | Republican | 8 | |||||||||||||
14395 | 14395 | William Mahoney M000069 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 5 | |||||||||||||
14524 | 14524 | Vespasian Warner W000158 | rep | IL | 1901-12-02 | 1903-03-03 | Republican | 13 | |||||||||||||
14532 | 14532 | James Williams W000508 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 20 | |||||||||||||
14725 | 14725 | Robert Hitt H000649 | rep | IL | 1901-12-02 | 1903-03-03 | Republican | 9 | |||||||||||||
15018 | 15018 | Ben Caldwell C000029 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 17 | |||||||||||||
15062 | 15062 | Shelby Cullom C000973 | sen | IL | 1901-12-02 | 1907-03-03 | 2 | Republican | |||||||||||||
15295 | 15295 | George Smith S000541 | rep | IL | 1901-12-02 | 1903-03-03 | Republican | 22 | |||||||||||||
15346 | 15346 | Henry Boutell B000672 | rep | IL | 1901-12-02 | 1903-03-03 | Republican | 6 | |||||||||||||
15495 | 15495 | Joseph Graff G000351 | rep | IL | 1901-12-02 | 1903-03-03 | Republican | 14 | |||||||||||||
16153 | 16153 | George Prince P000538 | rep | IL | 1901-12-02 | 1903-03-03 | Republican | 10 | |||||||||||||
17198 | 17198 | George Foss F000295 | rep | IL | 1901-12-02 | 1903-03-03 | Republican | 7 | |||||||||||||
18106 | 18106 | Joseph Cannon C000121 | rep | IL | 1901-12-02 | 1903-03-03 | Republican | 12 | |||||||||||||
18324 | 18324 | James Mann M000104 | rep | IL | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
22696 | 22696 | James McAndrews M000296 | rep | IL | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
14184 | 14184 | George Steele S000830 | rep | IN | 1901-12-02 | 1903-03-03 | Republican | 11 | |||||||||||||
14339 | 14339 | Francis Griffith G000468 | rep | IN | 1901-12-02 | 1903-03-03 | Democrat | 4 | |||||||||||||
14418 | 14418 | Robert Miers M000700 | rep | IN | 1901-12-02 | 1903-03-03 | Democrat | 2 | |||||||||||||
14467 | 14467 | James Robinson R000338 | rep | IN | 1901-12-02 | 1903-03-03 | Democrat | 12 | |||||||||||||
14622 | 14622 | George Cromer C000924 | rep | IN | 1901-12-02 | 1903-03-03 | Republican | 8 | |||||||||||||
14704 | 14704 | James Hemenway H000467 | rep | IN | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
14955 | 14955 | William Zenor Z000005 | rep | IN | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14991 | 14991 | Abraham Brick B000819 | rep | IN | 1901-12-02 | 1903-03-03 | Republican | 13 | |||||||||||||
15156 | 15156 | Elias Holliday H000724 | rep | IN | 1901-12-02 | 1903-03-03 | Republican | 5 | |||||||||||||
15188 | 15188 | Charles Landis L000050 | rep | IN | 1901-12-02 | 1903-03-03 | Republican | 9 | |||||||||||||
15240 | 15240 | Jesse Overstreet O000144 | rep | IN | 1901-12-02 | 1903-03-03 | Republican | 7 | |||||||||||||
15904 | 15904 | Edgar Crumpacker C000958 | rep | IN | 1901-12-02 | 1903-03-03 | Republican | 10 | |||||||||||||
19532 | 19532 | James Watson W000203 | rep | IN | 1901-12-02 | 1903-03-03 | Republican | 6 | |||||||||||||
13901 | 13901 | Joseph Burton B001154 | sen | KS | 1901-12-02 | 1907-03-03 | 2 | Republican | |||||||||||||
14022 | 14022 | Alfred Jackson J000003 | rep | KS | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14386 | 14386 | Chester Long L000412 | rep | KS | 1901-12-02 | 1903-03-03 | Republican | 7 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [legislator_terms] ( [legislator_id] TEXT REFERENCES [legislators]([id]), [type] TEXT, [state] TEXT, [start] TEXT, [end] TEXT, [class] INTEGER, [party] TEXT , [district] INTEGER, [how] TEXT, [party_affiliations] TEXT, [url] TEXT, [caucus] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);