legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
381 rows where "start" is on date 1883-12-03 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18098 | 18098 | Joseph Cannon C000121 | rep | IL | 1883-12-03 | 1885-03-03 | Republican | 15 | |||||||||||||
17860 | 17860 | Knute Nelson N000040 | rep | MN | 1883-12-03 | 1885-03-03 | Republican | 5 | |||||||||||||
17479 | 17479 | Joshua Talbott T000021 | rep | MD | 1883-12-03 | 1885-03-03 | Democrat | 2 | |||||||||||||
16956 | 16956 | Benjamin Shively S000371 | rep | IN | 1883-12-03 | 1885-03-03 | National Greenbacker | 13 | |||||||||||||
16885 | 16885 | Samuel Miller M000753 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 26 | |||||||||||||
16509 | 16509 | Sereno Payne P000153 | rep | NY | 1883-12-03 | 1885-03-03 | Republican | 26 | |||||||||||||
16374 | 16374 | Nathan Goff G000255 | rep | WV | 1883-12-03 | 1885-03-03 | Republican | 1 | |||||||||||||
15856 | 15856 | Henry Bingham B000469 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 1 | |||||||||||||
15761 | 15761 | Isaac Stephenson S000863 | rep | WI | 1883-12-03 | 1885-03-03 | Republican | 9 | |||||||||||||
15657 | 15657 | Charles Morgan M000944 | rep | MO | 1883-12-03 | 1885-03-03 | Democrat | 12 | |||||||||||||
15569 | 15569 | Joseph Keifer K000048 | rep | OH | 1883-12-03 | 1885-03-03 | Republican | 8 | |||||||||||||
15315 | 15315 | John Stewart S000917 | rep | VT | 1883-12-03 | 1885-03-03 | Republican | 1 | |||||||||||||
15143 | 15143 | William Hepburn H000523 | rep | IA | 1883-12-03 | 1885-03-03 | Republican | 8 | |||||||||||||
15108 | 15108 | William Frye F000398 | sen | ME | 1883-12-03 | 1889-03-03 | 2 | Republican | |||||||||||||
15059 | 15059 | Shelby Cullom C000973 | sen | IL | 1883-12-03 | 1889-03-03 | 2 | Republican | |||||||||||||
14999 | 14999 | Charles Brumm B000977 | rep | PA | 1883-12-03 | 1885-03-03 | National Greenbacker | 13 | |||||||||||||
14933 | 14933 | James Wadsworth W000011 | rep | NY | 1883-12-03 | 1885-03-03 | Republican | 27 | |||||||||||||
14835 | 14835 | Hernando Money M000854 | rep | MS | 1883-12-03 | 1885-03-03 | Democrat | 4 | |||||||||||||
14747 | 14747 | John Ketcham K000152 | rep | NY | 1883-12-03 | 1885-03-03 | Republican | 13 | |||||||||||||
14735 | 14735 | John Kean K000028 | rep | NJ | 1883-12-03 | 1885-03-03 | Republican | 3 | |||||||||||||
14716 | 14716 | Robert Hitt H000649 | rep | IL | 1883-12-03 | 1885-03-03 | Republican | 6 | |||||||||||||
14426 | 14426 | Rice Pierce P000337 | rep | TN | 1883-12-03 | 1885-03-03 | Democrat | 9 | |||||||||||||
14178 | 14178 | George Steele S000830 | rep | IN | 1883-12-03 | 1885-03-03 | Republican | 11 | |||||||||||||
14129 | 14129 | George Ray R000076 | rep | NY | 1883-12-03 | 1885-03-03 | Republican | 21 | |||||||||||||
14103 | 14103 | Nicholas Muller M001071 | rep | NY | 1883-12-03 | 1885-03-03 | Democrat | 5 | |||||||||||||
14093 | 14093 | John Morgan M000954 | sen | AL | 1883-12-03 | 1889-03-03 | 2 | Democrat | |||||||||||||
14041 | 14041 | Samuel Lanham L000078 | rep | TX | 1883-12-03 | 1885-03-03 | Democrat | 11 | |||||||||||||
14006 | 14006 | George Hoar H000654 | sen | MA | 1883-12-03 | 1889-03-03 | 2 | Republican | |||||||||||||
13990 | 13990 | David Henderson H000478 | rep | IA | 1883-12-03 | 1885-03-03 | Republican | 3 | |||||||||||||
13871 | 13871 | Charles Boutelle B000673 | rep | ME | 1883-12-03 | 1885-03-03 | Republican | -1 | |||||||||||||
13867 | 13867 | Joseph Blackburn B000508 | rep | KY | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
13774 | 13774 | Thomas Reed R000128 | rep | ME | 1883-12-03 | 1885-03-03 | Republican | -1 | |||||||||||||
13736 | 13736 | Louis McComas M000351 | rep | MD | 1883-12-03 | 1885-03-03 | Republican | 6 | |||||||||||||
13690 | 13690 | Alfred Harmer H000215 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 5 | |||||||||||||
13657 | 13657 | Daniel Ermentrout E000205 | rep | PA | 1883-12-03 | 1885-03-03 | Democrat | 8 | |||||||||||||
13643 | 13643 | Nelson Dingley D000356 | rep | ME | 1883-12-03 | 1885-03-03 | Republican | -1 | |||||||||||||
13581 | 13581 | Richard Bland B000544 | rep | MO | 1883-12-03 | 1885-03-03 | Democrat | 11 | |||||||||||||
13414 | 13414 | Seth Milliken M000769 | rep | ME | 1883-12-03 | 1885-03-03 | Republican | -1 | |||||||||||||
13404 | 13404 | Benton McMillin M000575 | rep | TN | 1883-12-03 | 1885-03-03 | Democrat | 4 | |||||||||||||
13363 | 13363 | James Jones J000231 | rep | AR | 1883-12-03 | 1885-03-03 | Democrat | 2 | |||||||||||||
13343 | 13343 | William Holman H000732 | rep | IN | 1883-12-03 | 1885-03-03 | Democrat | 4 | |||||||||||||
13290 | 13290 | Alexander Dockery D000384 | rep | MO | 1883-12-03 | 1885-03-03 | Democrat | 3 | |||||||||||||
13232 | 13232 | William McKinley M000522 | rep | OH | 1883-12-03 | 1885-03-03 | Republican | 18 | |||||||||||||
13184 | 13184 | Henry Turner T000421 | rep | GA | 1883-12-03 | 1885-03-03 | Democrat | 2 | |||||||||||||
13024 | 13024 | Isham Harris H000243 | sen | TN | 1883-12-03 | 1889-03-03 | 2 | Democrat | |||||||||||||
12984 | 12984 | David Culberson C000964 | rep | TX | 1883-12-03 | 1885-03-03 | Democrat | 4 | |||||||||||||
12971 | 12971 | Charles Crisp C000908 | rep | GA | 1883-12-03 | 1885-03-03 | Democrat | 3 | |||||||||||||
12877 | 12877 | Newton Blanchard B000541 | rep | LA | 1883-12-03 | 1885-03-03 | Democrat | 4 | |||||||||||||
12865 | 12865 | George Wise W000648 | rep | VA | 1883-12-03 | 1885-03-03 | Democrat | 3 | |||||||||||||
12858 | 12858 | William Wilson W000623 | rep | WV | 1883-12-03 | 1885-03-03 | Democrat | 2 | |||||||||||||
12800 | 12800 | William Springer S000757 | rep | IL | 1883-12-03 | 1885-03-03 | Democrat | 13 | |||||||||||||
12735 | 12735 | William Oates O000005 | rep | AL | 1883-12-03 | 1885-03-03 | Democrat | 3 | |||||||||||||
12729 | 12729 | John O’Neill O000097 | rep | MO | 1883-12-03 | 1885-03-03 | Democrat | 8 | |||||||||||||
12723 | 12723 | Charles O’Neill O000093 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 2 | |||||||||||||
12705 | 12705 | Charles O’Ferrall O000040 | rep | VA | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
12701 | 12701 | William Mutchler M001125 | rep | PA | 1883-12-03 | 1885-03-03 | Democrat | 10 | |||||||||||||
12627 | 12627 | Thomas Henderson H000489 | rep | IL | 1883-12-03 | 1885-03-03 | Republican | 7 | |||||||||||||
12599 | 12599 | William Hatch H000339 | rep | MO | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
12563 | 12563 | Robert Fyan F000436 | rep | MO | 1883-12-03 | 1885-03-03 | Democrat | 13 | |||||||||||||
12557 | 12557 | Edward Funston F000429 | rep | KS | 1883-12-03 | 1885-03-03 | Republican | 2 | |||||||||||||
12425 | 12425 | Clifton Breckinridge B000784 | rep | AR | 1883-12-03 | 1885-03-03 | Democrat | -1 | |||||||||||||
12389 | 12389 | Bishop Perkins P000228 | rep | KS | 1883-12-03 | 1885-03-03 | Republican | -1 | |||||||||||||
12382 | 12382 | Roger Mills M000777 | rep | TX | 1883-12-03 | 1885-03-03 | Democrat | 9 | |||||||||||||
12331 | 12331 | George Tillman T000275 | rep | SC | 1883-12-03 | 1885-03-03 | Democrat | 2 | |||||||||||||
12324 | 12324 | Joseph Taylor T000093 | rep | OH | 1883-12-03 | 1885-03-03 | Republican | 17 | |||||||||||||
12318 | 12318 | Ezra Taylor T000073 | rep | OH | 1883-12-03 | 1885-03-03 | Republican | 19 | |||||||||||||
12306 | 12306 | Charles Stewart S000904 | rep | TX | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
12265 | 12265 | Samuel Peel P000184 | rep | AR | 1883-12-03 | 1885-03-03 | Democrat | 4 | |||||||||||||
12211 | 12211 | Leonidas Houk H000818 | rep | TN | 1883-12-03 | 1885-03-03 | Republican | 2 | |||||||||||||
12203 | 12203 | Hilary Herbert H000524 | rep | AL | 1883-12-03 | 1885-03-03 | Democrat | 2 | |||||||||||||
12195 | 12195 | John Hemphill H000469 | rep | SC | 1883-12-03 | 1885-03-03 | Democrat | 5 | |||||||||||||
12185 | 12185 | Halbert Greenleaf G000432 | rep | NY | 1883-12-03 | 1885-03-03 | Democrat | 30 | |||||||||||||
12168 | 12168 | William Forney F000280 | rep | AL | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
12118 | 12118 | John Caine C000023 | rep | UT | 1883-12-03 | 1885-03-03 | Democrat | -1 | |||||||||||||
12092 | 12092 | James Blount B000568 | rep | GA | 1883-12-03 | 1885-03-03 | Democrat | 6 | |||||||||||||
12070 | 12070 | Louis Atkinson A000331 | rep | PA | 1883-12-03 | 1885-03-03 | Republican | 18 | |||||||||||||
12059 | 12059 | John Carlisle C000152 | rep | KY | 1883-12-03 | 1885-03-03 | Democrat | 6 | |||||||||||||
12046 | 12046 | James Wilson W000594 | sen | IA | 1883-12-03 | 1889-03-03 | 2 | Republican | |||||||||||||
12015 | 12015 | William Washburn W000175 | rep | MN | 1883-12-03 | 1885-03-03 | Republican | 4 | |||||||||||||
11990 | 11990 | Richard Townshend T000339 | rep | IL | 1883-12-03 | 1885-03-03 | Democrat | 19 | |||||||||||||
11975 | 11975 | Isaac Struble S001028 | rep | IA | 1883-12-03 | 1885-03-03 | Republican | 11 | |||||||||||||
11967 | 11967 | Henry Spooner S000740 | rep | RI | 1883-12-03 | 1885-03-03 | Republican | 1 | |||||||||||||
11961 | 11961 | Thomas Skinner S000470 | rep | NC | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
11956 | 11956 | George Seney S000241 | rep | OH | 1883-12-03 | 1885-03-03 | Democrat | 5 | |||||||||||||
11949 | 11949 | Thomas Ryan R000559 | rep | KS | 1883-12-03 | 1885-03-03 | Republican | 3 | |||||||||||||
11940 | 11940 | Jonathan Rowell R000478 | rep | IL | 1883-12-03 | 1885-03-03 | Republican | 14 | |||||||||||||
11936 | 11936 | John Rogers R000399 | rep | AR | 1883-12-03 | 1885-03-03 | Democrat | 3 | |||||||||||||
11932 | 11932 | Francis Rockwell R000365 | rep | MA | 1883-12-03 | 1885-03-03 | Republican | 12 | |||||||||||||
11928 | 11928 | Matt Ransom R000062 | sen | NC | 1883-12-03 | 1889-03-03 | 2 | Democrat | |||||||||||||
11922 | 11922 | Samuel Randall R000039 | rep | PA | 1883-12-03 | 1885-03-03 | Democrat | 3 | |||||||||||||
11907 | 11907 | Preston Plumb P000389 | sen | KS | 1883-12-03 | 1889-03-03 | 2 | Republican | |||||||||||||
11897 | 11897 | Samuel Peters P000256 | rep | KS | 1883-12-03 | 1885-03-03 | Republican | -1 | |||||||||||||
11888 | 11888 | Lewis Payson P000157 | rep | IL | 1883-12-03 | 1885-03-03 | Republican | 9 | |||||||||||||
11876 | 11876 | Newton Nutting N000174 | rep | NY | 1883-12-03 | 1885-03-03 | Republican | 24 | |||||||||||||
11867 | 11867 | Edmund Morrill M000968 | rep | KS | 1883-12-03 | 1885-03-03 | Republican | -1 | |||||||||||||
11862 | 11862 | Henry Morey M000943 | rep | OH | 1883-12-03 | 1885-03-03 | Republican | 7 | |||||||||||||
11851 | 11851 | John McPherson M000593 | sen | NJ | 1883-12-03 | 1889-03-03 | 2 | Democrat | |||||||||||||
11839 | 11839 | William McAdoo M000292 | rep | NJ | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
11830 | 11830 | Charles Manderson M000095 | sen | NE | 1883-12-03 | 1889-03-03 | 2 | Republican | |||||||||||||
11813 | 11813 | James Laird L000023 | rep | NE | 1883-12-03 | 1885-03-03 | Republican | 2 |
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);