legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
415 rows where "end" is on date 1895-03-03
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12608 | 12608 | Nils Haugen H000351 | rep | WI | 1893-08-07 | 1895-03-03 | Republican | 10 | |||||||||||||
12612 | 12612 | Walter Hayes H000394 | rep | IA | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
12617 | 12617 | John Heard H000427 | rep | MO | 1893-08-07 | 1895-03-03 | Democrat | 7 | |||||||||||||
12622 | 12622 | John Henderson H000485 | rep | NC | 1893-08-07 | 1895-03-03 | Democrat | 7 | |||||||||||||
12632 | 12632 | Thomas Henderson H000489 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 7 | |||||||||||||
12633 | 12633 | Joseph Hendrix H000496 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12634 | 12634 | Winder Henry H000521 | rep | MD | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12635 | 12635 | William Hines H000635 | rep | PA | 1893-08-07 | 1895-03-03 | Democrat | 12 | |||||||||||||
12637 | 12637 | Albert Hopkins H000769 | rep | PA | 1893-08-07 | 1895-03-03 | Republican | 16 | |||||||||||||
12639 | 12639 | George Houk H000816 | rep | OH | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12641 | 12641 | John Houk H000817 | rep | TN | 1893-08-07 | 1895-03-03 | Republican | 2 | |||||||||||||
12642 | 12642 | Thomas Hudson H000909 | rep | KS | 1893-08-07 | 1895-03-03 | Populist | 3 | |||||||||||||
12643 | 12643 | George Ikirt I000008 | rep | OH | 1893-08-07 | 1895-03-03 | Democrat | 18 | |||||||||||||
12644 | 12644 | James Izlar I000054 | rep | SC | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12646 | 12646 | Tom Johnson J000178 | rep | OH | 1893-08-07 | 1895-03-03 | Democrat | 21 | |||||||||||||
12647 | 12647 | Edwin Jorden J000270 | rep | PA | 1893-08-07 | 1895-03-03 | Republican | 15 | |||||||||||||
12652 | 12652 | Antonio Joseph J000272 | rep | NM | 1893-08-07 | 1895-03-03 | Democrat | -1 | |||||||||||||
12656 | 12656 | Constantine Kilgore K000173 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12658 | 12658 | George Kribbs K000330 | rep | PA | 1893-08-07 | 1895-03-03 | Democrat | 28 | |||||||||||||
12662 | 12662 | Edward Lane L000058 | rep | IL | 1893-08-07 | 1895-03-03 | Democrat | 17 | |||||||||||||
12664 | 12664 | Oscar Lapham L000093 | rep | RI | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12665 | 12665 | William Lilly L000312 | rep | PA | 1893-08-07 | 1895-03-03 | Republican | -1 | |||||||||||||
12666 | 12666 | Marcus Lisle L000345 | rep | KY | 1893-08-07 | 1895-03-03 | Democrat | 10 | |||||||||||||
12669 | 12669 | Daniel Lockwood L000392 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 32 | |||||||||||||
12670 | 12670 | William Lucas L000495 | rep | SD | 1893-08-07 | 1895-03-03 | Republican | -1 | |||||||||||||
12672 | 12672 | Thomas Lynch L000534 | rep | WI | 1893-08-07 | 1895-03-03 | Democrat | 9 | |||||||||||||
12675 | 12675 | Thomas Magner M000051 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
12676 | 12676 | James Marshall M000156 | rep | VA | 1893-08-07 | 1895-03-03 | Democrat | 9 | |||||||||||||
12679 | 12679 | Augustus Martin M000167 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 11 | |||||||||||||
12680 | 12680 | John Martin M000185 | sen | KS | 1893-08-07 | 1895-03-03 | 2 | Democrat | |||||||||||||
12681 | 12681 | Francis Marvin M000209 | rep | NY | 1893-08-07 | 1895-03-03 | Republican | 17 | |||||||||||||
12682 | 12682 | John McDannold M000401 | rep | IL | 1893-08-07 | 1895-03-03 | Democrat | 12 | |||||||||||||
12683 | 12683 | Alexander McDowell M000417 | rep | PA | 1893-08-07 | 1895-03-03 | Republican | -1 | |||||||||||||
12684 | 12684 | Michael McEttrick M000430 | rep | MA | 1893-08-07 | 1895-03-03 | Ind. Democrat | 10 | |||||||||||||
12686 | 12686 | William McKaig M000488 | rep | MD | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
12688 | 12688 | William McKeighan M000498 | rep | NE | 1893-08-07 | 1895-03-03 | Populist | 5 | |||||||||||||
12689 | 12689 | William McNagny M000580 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 12 | |||||||||||||
12695 | 12695 | Alexander Montgomery M000863 | rep | KY | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
12696 | 12696 | John Moon M000885 | rep | MI | 1893-08-07 | 1895-03-03 | Republican | 9 | |||||||||||||
12697 | 12697 | Horace Moore M000901 | rep | KS | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
12704 | 12704 | William Mutchler M001125 | rep | PA | 1893-08-07 | 1895-03-03 | Democrat | 8 | |||||||||||||
12710 | 12710 | Charles O’Ferrall O000040 | rep | VA | 1893-08-07 | 1895-03-03 | Democrat | 7 | |||||||||||||
12713 | 12713 | Joseph O’Neil O000092 | rep | MA | 1893-08-07 | 1895-03-03 | Democrat | 9 | |||||||||||||
12728 | 12728 | Charles O’Neill O000093 | rep | PA | 1893-08-07 | 1895-03-03 | Republican | 2 | |||||||||||||
12733 | 12733 | John O’Neill O000097 | rep | MO | 1893-08-07 | 1895-03-03 | Democrat | 11 | |||||||||||||
12740 | 12740 | William Oates O000005 | rep | AL | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12745 | 12745 | Joseph Outhwaite O000136 | rep | OH | 1893-08-07 | 1895-03-03 | Democrat | 12 | |||||||||||||
12748 | 12748 | Charles Page P000015 | rep | RI | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
12749 | 12749 | Thomas Paschal P000094 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 12 | |||||||||||||
12753 | 12753 | Albert Pearson P000164 | rep | OH | 1893-08-07 | 1895-03-03 | Democrat | 16 | |||||||||||||
12754 | 12754 | Lafayette Pence P000199 | rep | CO | 1893-08-07 | 1895-03-03 | Populist | 1 | |||||||||||||
12757 | 12757 | John Pendleton P000205 | rep | WV | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12758 | 12758 | James Pigott P000344 | rep | CT | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
12761 | 12761 | Charles Randall R000037 | rep | MA | 1893-08-07 | 1895-03-03 | Republican | 13 | |||||||||||||
12766 | 12766 | James Reilly R000153 | rep | PA | 1893-08-07 | 1895-03-03 | Democrat | 13 | |||||||||||||
12767 | 12767 | James Richards R000213 | rep | OH | 1893-08-07 | 1895-03-03 | Democrat | 17 | |||||||||||||
12768 | 12768 | George Richardson R000220 | rep | MI | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
12769 | 12769 | Byron Ritchie R000272 | rep | OH | 1893-08-07 | 1895-03-03 | Democrat | 9 | |||||||||||||
12771 | 12771 | William Ryan R000561 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 16 | |||||||||||||
12772 | 12772 | Simon Schermerhorn S000123 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 21 | |||||||||||||
12773 | 12773 | George Shaw S000305 | rep | WI | 1893-08-07 | 1895-03-03 | Republican | 7 | |||||||||||||
12775 | 12775 | George Shell S000324 | rep | SC | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
12787 | 12787 | Daniel Sickles S000402 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 10 | |||||||||||||
12789 | 12789 | William Sipe S000451 | rep | PA | 1893-08-07 | 1895-03-03 | Democrat | 24 | |||||||||||||
12792 | 12792 | Henry Snodgrass S000655 | rep | TN | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12793 | 12793 | Peter Somers S000677 | rep | WI | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
12795 | 12795 | Lewis Sperry S000732 | rep | CT | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12805 | 12805 | William Springer S000757 | rep | IL | 1893-08-07 | 1895-03-03 | Democrat | 13 | |||||||||||||
12807 | 12807 | Moses Stevens S000884 | rep | MA | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
12809 | 12809 | Francis Stockbridge S000932 | sen | MI | 1893-08-07 | 1895-03-03 | 1 | Republican | |||||||||||||
12813 | 12813 | Thomas Stockdale S000934 | rep | MS | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
12818 | 12818 | William Stone S000969 | rep | KY | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12820 | 12820 | Bellamy Storer S000970 | rep | OH | 1893-08-07 | 1895-03-03 | Republican | 1 | |||||||||||||
12821 | 12821 | Isidor Straus S001000 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 15 | |||||||||||||
12824 | 12824 | Willis Sweet S001110 | rep | ID | 1893-08-07 | 1895-03-03 | Republican | 1 | |||||||||||||
12827 | 12827 | Alfred Taylor T000064 | rep | TN | 1893-08-07 | 1895-03-03 | Republican | 1 | |||||||||||||
12828 | 12828 | Arthur Taylor T000065 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12832 | 12832 | Charles Tracey T000341 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 20 | |||||||||||||
12838 | 12838 | Louis Turpin T000434 | rep | AL | 1893-08-07 | 1895-03-03 | Democrat | 9 | |||||||||||||
12841 | 12841 | John Van Voorhis V000063 | rep | NY | 1893-08-07 | 1895-03-03 | Republican | 31 | |||||||||||||
12843 | 12843 | John Warner W000153 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 13 | |||||||||||||
12845 | 12845 | Daniel Waugh W000214 | rep | IN | 1893-08-07 | 1895-03-03 | Republican | 9 | |||||||||||||
12847 | 12847 | Thomas Weadock W000219 | rep | MI | 1893-08-07 | 1895-03-03 | Democrat | 10 | |||||||||||||
12848 | 12848 | Owen Wells W000286 | rep | WI | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
12850 | 12850 | John Wever W000313 | rep | NY | 1893-08-07 | 1895-03-03 | Republican | 23 | |||||||||||||
12851 | 12851 | Hamilton Wheeler W000335 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 9 | |||||||||||||
12853 | 12853 | William White W000398 | rep | OH | 1893-08-07 | 1895-03-03 | Republican | 20 | |||||||||||||
12857 | 12857 | Justin Whiting W000415 | rep | MI | 1893-08-07 | 1895-03-03 | Democrat | 7 | |||||||||||||
12863 | 12863 | William Wilson W000623 | rep | WV | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
12870 | 12870 | George Wise W000648 | rep | VA | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12872 | 12872 | Simon Wolverton W000685 | rep | PA | 1893-08-07 | 1895-03-03 | Democrat | 17 | |||||||||||||
12875 | 12875 | Myron Wright W000767 | rep | PA | 1893-08-07 | 1895-03-03 | Republican | 15 | |||||||||||||
12885 | 12885 | Patrick Walsh W000103 | sen | GA | 1894-01-01 | 1895-03-03 | 2 | Democrat | |||||||||||||
12889 | 12889 | Jo Abbott A000005 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
12891 | 12891 | David Aitken A000068 | rep | MI | 1893-08-07 | 1895-03-03 | Republican | 6 | |||||||||||||
12893 | 12893 | James Aldrich A000082 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 1 | |||||||||||||
12898 | 12898 | Lewis Apsley A000271 | rep | MA | 1893-08-07 | 1895-03-03 | Republican | 4 | |||||||||||||
12904 | 12904 | John Avery A000346 | rep | MI | 1893-08-07 | 1895-03-03 | Republican | 11 | |||||||||||||
12906 | 12906 | Henry Baker B000061 | rep | NH | 1893-08-07 | 1895-03-03 | Republican | 2 | |||||||||||||
12910 | 12910 | William Baker B000075 | rep | KS | 1893-08-07 | 1895-03-03 | Populist | 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);