legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
344 rows where "end" is on date 1883-03-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, district, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18097 | 18097 | Joseph Cannon C000121 | rep | IL | 1881-12-05 | 1883-03-03 | Republican | 14 | |||||||||||||
17478 | 17478 | Joshua Talbott T000021 | rep | MD | 1881-12-05 | 1883-03-03 | Democrat | 2 | |||||||||||||
16884 | 16884 | Samuel Miller M000753 | rep | PA | 1881-12-05 | 1883-03-03 | Republican | 26 | |||||||||||||
15855 | 15855 | Henry Bingham B000469 | rep | PA | 1881-12-05 | 1883-03-03 | Republican | 1 | |||||||||||||
15568 | 15568 | Joseph Keifer K000048 | rep | OH | 1881-12-05 | 1883-03-03 | Republican | 8 | |||||||||||||
15142 | 15142 | William Hepburn H000523 | rep | IA | 1881-12-05 | 1883-03-03 | Republican | 8 | |||||||||||||
15107 | 15107 | William Frye F000398 | sen | ME | 1881-12-05 | 1883-03-03 | 2 | Republican | |||||||||||||
14998 | 14998 | Charles Brumm B000977 | rep | PA | 1881-12-05 | 1883-03-03 | National Greenbacker | 13 | |||||||||||||
14932 | 14932 | James Wadsworth W000011 | rep | NY | 1881-12-05 | 1883-03-03 | Republican | 27 | |||||||||||||
14834 | 14834 | Hernando Money M000854 | rep | MS | 1881-12-05 | 1883-03-03 | Democrat | 3 | |||||||||||||
14802 | 14802 | Benjamin Marsh M000145 | rep | IL | 1881-12-05 | 1883-03-03 | Republican | 10 | |||||||||||||
14746 | 14746 | John Ketcham K000152 | rep | NY | 1881-12-05 | 1883-03-03 | Republican | 13 | |||||||||||||
14715 | 14715 | Robert Hitt H000649 | rep | IL | 1881-12-05 | 1883-03-03 | Republican | 5 | |||||||||||||
14605 | 14605 | Julius Burrows B001142 | rep | MI | 1881-12-05 | 1883-03-03 | Republican | 4 | |||||||||||||
14177 | 14177 | George Steele S000830 | rep | IN | 1881-12-05 | 1883-03-03 | Republican | 11 | |||||||||||||
14092 | 14092 | John Morgan M000954 | sen | AL | 1877-10-15 | 1883-03-03 | 2 | Democrat | |||||||||||||
14013 | 14013 | Charles Hooker H000758 | rep | MS | 1881-12-05 | 1883-03-03 | Democrat | 5 | |||||||||||||
14005 | 14005 | George Hoar H000654 | sen | MA | 1877-10-15 | 1883-03-03 | 2 | Republican | |||||||||||||
13866 | 13866 | Joseph Blackburn B000508 | rep | KY | 1881-12-05 | 1883-03-03 | Democrat | 7 | |||||||||||||
13821 | 13821 | Joseph Wheeler W000338 | rep | AL | 1881-12-05 | 1883-03-03 | Democrat | 8 | |||||||||||||
13773 | 13773 | Thomas Reed R000128 | rep | ME | 1881-12-05 | 1883-03-03 | Republican | 1 | |||||||||||||
13689 | 13689 | Alfred Harmer H000215 | rep | PA | 1881-12-05 | 1883-03-03 | Republican | 5 | |||||||||||||
13674 | 13674 | William Grout G000501 | rep | VT | 1881-12-05 | 1883-03-03 | Republican | 3 | |||||||||||||
13656 | 13656 | Daniel Ermentrout E000205 | rep | PA | 1881-12-05 | 1883-03-03 | Democrat | 8 | |||||||||||||
13642 | 13642 | Nelson Dingley D000356 | rep | ME | 1881-12-05 | 1883-03-03 | Republican | 2 | |||||||||||||
13580 | 13580 | Richard Bland B000544 | rep | MO | 1881-12-05 | 1883-03-03 | Democrat | 5 | |||||||||||||
13510 | 13510 | Thomas Updegraff U000019 | rep | IA | 1881-12-05 | 1883-03-03 | Republican | 3 | |||||||||||||
13403 | 13403 | Benton McMillin M000575 | rep | TN | 1881-12-05 | 1883-03-03 | Democrat | 4 | |||||||||||||
13362 | 13362 | James Jones J000231 | rep | AR | 1881-12-05 | 1883-03-03 | Democrat | 2 | |||||||||||||
13342 | 13342 | William Holman H000732 | rep | IN | 1881-12-05 | 1883-03-03 | Democrat | 4 | |||||||||||||
13231 | 13231 | William McKinley M000522 | rep | OH | 1881-12-05 | 1883-03-03 | Republican | 17 | |||||||||||||
13198 | 13198 | Robert Van Horn V000042 | rep | MO | 1881-12-05 | 1883-03-03 | Republican | 8 | |||||||||||||
13183 | 13183 | Henry Turner T000421 | rep | GA | 1881-12-05 | 1883-03-03 | Democrat | 2 | |||||||||||||
13150 | 13150 | Joseph Scranton S000192 | rep | PA | 1881-12-05 | 1883-03-03 | Republican | 12 | |||||||||||||
13117 | 13117 | Richard Pettigrew P000271 | rep | DK | 1881-12-05 | 1883-03-03 | Republican | -1 | |||||||||||||
13075 | 13075 | Addison McClure M000344 | rep | OH | 1881-12-05 | 1883-03-03 | Republican | 18 | |||||||||||||
13023 | 13023 | Isham Harris H000243 | sen | TN | 1877-10-15 | 1883-03-03 | 2 | Democrat | |||||||||||||
12983 | 12983 | David Culberson C000964 | rep | TX | 1881-12-05 | 1883-03-03 | Democrat | 2 | |||||||||||||
12876 | 12876 | Newton Blanchard B000541 | rep | LA | 1881-12-05 | 1883-03-03 | Democrat | 4 | |||||||||||||
12864 | 12864 | George Wise W000648 | rep | VA | 1881-12-05 | 1883-03-03 | Democrat | 3 | |||||||||||||
12840 | 12840 | John Van Voorhis V000063 | rep | NY | 1881-12-05 | 1883-03-03 | Republican | 30 | |||||||||||||
12799 | 12799 | William Springer S000757 | rep | IL | 1881-12-05 | 1883-03-03 | Democrat | 12 | |||||||||||||
12734 | 12734 | William Oates O000005 | rep | AL | 1881-12-05 | 1883-03-03 | Democrat | 3 | |||||||||||||
12722 | 12722 | Charles O’Neill O000093 | rep | PA | 1881-12-05 | 1883-03-03 | Republican | 2 | |||||||||||||
12700 | 12700 | William Mutchler M001125 | rep | PA | 1881-12-05 | 1883-03-03 | Democrat | 10 | |||||||||||||
12626 | 12626 | Thomas Henderson H000489 | rep | IL | 1881-12-05 | 1883-03-03 | Republican | 6 | |||||||||||||
12598 | 12598 | William Hatch H000339 | rep | MO | 1881-12-05 | 1883-03-03 | Democrat | 12 | |||||||||||||
12409 | 12409 | Frank Beltzhoover B000355 | rep | PA | 1881-12-05 | 1883-03-03 | Democrat | 19 | |||||||||||||
12381 | 12381 | Roger Mills M000777 | rep | TX | 1881-12-05 | 1883-03-03 | Democrat | 4 | |||||||||||||
12330 | 12330 | George Tillman T000275 | rep | SC | 1881-12-05 | 1883-03-03 | Democrat | 5 | |||||||||||||
12323 | 12323 | Joseph Taylor T000093 | rep | OH | 1881-12-05 | 1883-03-03 | Republican | 16 | |||||||||||||
12317 | 12317 | Ezra Taylor T000073 | rep | OH | 1881-12-05 | 1883-03-03 | Republican | 19 | |||||||||||||
12210 | 12210 | Leonidas Houk H000818 | rep | TN | 1881-12-05 | 1883-03-03 | Republican | 2 | |||||||||||||
12202 | 12202 | Hilary Herbert H000524 | rep | AL | 1881-12-05 | 1883-03-03 | Democrat | 2 | |||||||||||||
12167 | 12167 | William Forney F000280 | rep | AL | 1881-12-05 | 1883-03-03 | Democrat | 7 | |||||||||||||
12159 | 12159 | Roswell Flower F000217 | rep | NY | 1881-12-05 | 1883-03-03 | Democrat | 11 | |||||||||||||
12117 | 12117 | John Caine C000023 | rep | UT | 1881-12-05 | 1883-03-03 | Democrat | -1 | |||||||||||||
12091 | 12091 | James Blount B000568 | rep | GA | 1881-12-05 | 1883-03-03 | Democrat | 6 | |||||||||||||
12058 | 12058 | John Carlisle C000152 | rep | KY | 1881-12-05 | 1883-03-03 | Democrat | 6 | |||||||||||||
12027 | 12027 | Washington Whitthorne W000429 | rep | TN | 1881-12-05 | 1883-03-03 | Democrat | 7 | |||||||||||||
12018 | 12018 | Lewis Watson W000204 | rep | PA | 1881-12-05 | 1883-03-03 | Republican | 27 | |||||||||||||
12014 | 12014 | William Washburn W000175 | rep | MN | 1881-12-05 | 1883-03-03 | Republican | 3 | |||||||||||||
11989 | 11989 | Richard Townshend T000339 | rep | IL | 1881-12-05 | 1883-03-03 | Democrat | 19 | |||||||||||||
11966 | 11966 | Henry Spooner S000740 | rep | RI | 1881-12-05 | 1883-03-03 | Republican | 1 | |||||||||||||
11948 | 11948 | Thomas Ryan R000559 | rep | KS | 1881-12-05 | 1883-03-03 | Republican | 3 | |||||||||||||
11927 | 11927 | Matt Ransom R000062 | sen | NC | 1877-10-15 | 1883-03-03 | 2 | Democrat | |||||||||||||
11921 | 11921 | Samuel Randall R000039 | rep | PA | 1881-12-05 | 1883-03-03 | Democrat | 3 | |||||||||||||
11906 | 11906 | Preston Plumb P000389 | sen | KS | 1877-10-15 | 1883-03-03 | 2 | Republican | |||||||||||||
11887 | 11887 | Lewis Payson P000157 | rep | IL | 1881-12-05 | 1883-03-03 | Republican | 8 | |||||||||||||
11861 | 11861 | Henry Morey M000943 | rep | OH | 1881-12-05 | 1883-03-03 | Republican | 3 | |||||||||||||
11854 | 11854 | Frederick Miles M000704 | rep | CT | 1881-12-05 | 1883-03-03 | Republican | 4 | |||||||||||||
11850 | 11850 | John McPherson M000593 | sen | NJ | 1877-10-15 | 1883-03-03 | 2 | Democrat | |||||||||||||
11801 | 11801 | John Kenna K000099 | rep | WV | 1881-12-05 | 1883-03-03 | Democrat | 3 | |||||||||||||
11794 | 11794 | William Kelley K000062 | rep | PA | 1881-12-05 | 1883-03-03 | Republican | 4 | |||||||||||||
11767 | 11767 | Randall Gibson G000165 | rep | LA | 1881-12-05 | 1883-03-03 | Democrat | 1 | |||||||||||||
11745 | 11745 | Mark Dunnell D000555 | rep | MN | 1881-12-05 | 1883-03-03 | Republican | 1 | |||||||||||||
11728 | 11728 | Samuel Dibble D000300 | rep | SC | 1881-12-05 | 1883-03-03 | Democrat | 2 | |||||||||||||
11720 | 11720 | Robert Davidson D000085 | rep | FL | 1881-12-05 | 1883-03-03 | Democrat | 1 | |||||||||||||
11701 | 11701 | Samuel Cox C000839 | rep | NY | 1881-12-05 | 1883-03-03 | Democrat | 6 | |||||||||||||
11674 | 11674 | Richard Coke C000601 | sen | TX | 1877-10-15 | 1883-03-03 | 2 | Democrat | |||||||||||||
11668 | 11668 | Judson Clements C000508 | rep | GA | 1881-12-05 | 1883-03-03 | Democrat | 7 | |||||||||||||
11660 | 11660 | Lucien Caswell C000245 | rep | WI | 1881-12-05 | 1883-03-03 | Republican | 2 | |||||||||||||
11652 | 11652 | John Candler C000111 | rep | MA | 1881-12-05 | 1883-03-03 | Republican | 8 | |||||||||||||
11640 | 11640 | Benjamin Butterworth B001200 | rep | OH | 1881-12-05 | 1883-03-03 | Republican | 1 | |||||||||||||
11636 | 11636 | Matthew Butler B001184 | sen | SC | 1877-10-15 | 1883-03-03 | 2 | Democrat | |||||||||||||
11624 | 11624 | Thomas Browne B000958 | rep | IN | 1881-12-05 | 1883-03-03 | Republican | 6 | |||||||||||||
11603 | 11603 | James Beck B000289 | sen | KY | 1877-10-15 | 1883-03-03 | 2 | Democrat | |||||||||||||
11594 | 11594 | Thomas Bayne B000261 | rep | PA | 1881-12-05 | 1883-03-03 | Republican | 23 | |||||||||||||
11585 | 11585 | John Barbour B000129 | rep | VA | 1881-12-05 | 1883-03-03 | Democrat | 8 | |||||||||||||
11566 | 11566 | John Anderson A000194 | rep | KS | 1881-12-05 | 1883-03-03 | Republican | 1 | |||||||||||||
11539 | 11539 | George West W000302 | rep | NY | 1881-12-05 | 1883-03-03 | Republican | 20 | |||||||||||||
11524 | 11524 | John Thomas T000176 | rep | IL | 1881-12-05 | 1883-03-03 | Republican | 18 | |||||||||||||
11493 | 11493 | Edward Robertson R000321 | rep | LA | 1881-12-05 | 1883-03-03 | Democrat | 6 | |||||||||||||
11486 | 11486 | John Reagan R000098 | rep | TX | 1881-12-05 | 1883-03-03 | Democrat | 1 | |||||||||||||
11466 | 11466 | Abraham Parker P000053 | rep | NY | 1881-12-05 | 1883-03-03 | Republican | 19 | |||||||||||||
11454 | 11454 | Leopold Morse M001012 | rep | MA | 1881-12-05 | 1883-03-03 | Democrat | 4 | |||||||||||||
11442 | 11442 | Courtland Matson M000248 | rep | IN | 1881-12-05 | 1883-03-03 | Democrat | 5 | |||||||||||||
11430 | 11430 | Louis Latham L000109 | rep | NC | 1881-12-05 | 1883-03-03 | Democrat | 1 | |||||||||||||
11398 | 11398 | Frank Hiscock H000643 | rep | NY | 1881-12-05 | 1883-03-03 | Republican | 25 | |||||||||||||
11383 | 11383 | Richard Guenther G000516 | rep | WI | 1881-12-05 | 1883-03-03 | Republican | 6 |
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);