legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
295 rows where "start" is on date 1869-03-04
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8698 | 8698 | Alexander Ramsey R000026 | sen | MN | 1869-03-04 | 1875-03-03 | 1 | Republican | |||||||||||||
8699 | 8699 | John Reading R000096 | rep | PA | 1869-03-04 | 1871-03-03 | Democrat | 5 | |||||||||||||
8700 | 8700 | Henry Reeves R000138 | rep | NY | 1869-03-04 | 1871-03-03 | Democrat | 1 | |||||||||||||
8702 | 8702 | Robert Ridgway R000248 | rep | VA | 1869-03-04 | 1871-03-03 | Conservative | 5 | |||||||||||||
8703 | 8703 | Anthony Rogers R000388 | rep | AR | 1869-03-04 | 1871-03-03 | Democrat | 2 | |||||||||||||
8705 | 8705 | Logan Roots R000434 | rep | AR | 1869-03-04 | 1871-03-03 | Republican | 1 | |||||||||||||
8706 | 8706 | Stephen Sanford S000054 | rep | NY | 1869-03-04 | 1871-03-03 | Republican | 18 | |||||||||||||
8714 | 8714 | Robert Schenck S000118 | rep | OH | 1869-03-04 | 1871-03-03 | Republican | 3 | |||||||||||||
8715 | 8715 | Carl Schurz S000151 | sen | MO | 1869-03-04 | 1875-03-03 | 1 | Liberal Republican | |||||||||||||
8716 | 8716 | John Scott S000177 | sen | PA | 1869-03-04 | 1875-03-03 | 1 | Republican | |||||||||||||
8717 | 8717 | Jacob Shafer S000276 | rep | ID | 1869-03-04 | 1871-03-03 | Democrat | -1 | |||||||||||||
8718 | 8718 | Porter Sheldon S000323 | rep | NY | 1869-03-04 | 1871-03-03 | Republican | 31 | |||||||||||||
8719 | 8719 | William Sherrod S000352 | rep | AL | 1869-03-04 | 1871-03-03 | Democrat | 6 | |||||||||||||
8720 | 8720 | Joseph Smith S000581 | rep | OR | 1869-03-04 | 1871-03-03 | Democrat | 1 | |||||||||||||
8721 | 8721 | William Smith S000632 | rep | TN | 1869-03-04 | 1871-03-03 | Republican | 8 | |||||||||||||
8722 | 8722 | William Smyth S000648 | rep | IA | 1869-03-04 | 1871-03-03 | Republican | 2 | |||||||||||||
8723 | 8723 | Solomon Spink S000736 | rep | DK | 1869-03-04 | 1871-03-03 | Republican | -1 | |||||||||||||
8725 | 8725 | William Sprague S000747 | sen | RI | 1869-03-04 | 1875-03-03 | 1 | Liberal Republican | |||||||||||||
8727 | 8727 | Aaron Stevens S000875 | rep | NH | 1869-03-04 | 1871-03-03 | Republican | 2 | |||||||||||||
8730 | 8730 | John Stiles S000924 | rep | PA | 1869-03-04 | 1871-03-03 | Democrat | 6 | |||||||||||||
8732 | 8732 | John Stockton S000939 | sen | NJ | 1869-03-04 | 1875-03-03 | 1 | Democrat | |||||||||||||
8736 | 8736 | William Stokes S000950 | rep | TN | 1869-03-04 | 1871-03-03 | Republican | 3 | |||||||||||||
8738 | 8738 | Frederick Stone S000957 | rep | MD | 1869-03-04 | 1871-03-03 | Democrat | 5 | |||||||||||||
8739 | 8739 | Peter Strader S000987 | rep | OH | 1869-03-04 | 1871-03-03 | Democrat | 1 | |||||||||||||
8740 | 8740 | Randolph Strickland S001003 | rep | MI | 1869-03-04 | 1871-03-03 | Republican | 6 | |||||||||||||
8744 | 8744 | Charles Sumner S001068 | sen | MA | 1869-03-04 | 1875-03-03 | 1 | Liberal Republican | |||||||||||||
8745 | 8745 | William Sweeney S001104 | rep | KY | 1869-03-04 | 1871-03-03 | Democrat | 2 | |||||||||||||
8746 | 8746 | Adolphus Tanner T000037 | rep | NY | 1869-03-04 | 1871-03-03 | Republican | 15 | |||||||||||||
8748 | 8748 | Caleb Taylor T000068 | rep | PA | 1869-03-04 | 1871-03-03 | Republican | 5 | |||||||||||||
8750 | 8750 | Nelson Tift T000269 | rep | GA | 1869-03-04 | 1871-03-03 | Democrat | -1 | |||||||||||||
8751 | 8751 | Lewis Tillman T000277 | rep | TN | 1869-03-04 | 1871-03-03 | Republican | 4 | |||||||||||||
8753 | 8753 | Thomas Tipton T000286 | sen | NE | 1869-03-04 | 1875-03-03 | 1 | Liberal Republican | |||||||||||||
8756 | 8756 | Lawrence Trimble T000375 | rep | KY | 1869-03-04 | 1871-03-03 | Democrat | 1 | |||||||||||||
8758 | 8758 | Daniel Van Auken V000014 | rep | PA | 1869-03-04 | 1871-03-03 | Democrat | 11 | |||||||||||||
8761 | 8761 | Hamilton Ward W000133 | rep | NY | 1869-03-04 | 1871-03-03 | Republican | 27 | |||||||||||||
8766 | 8766 | Cadwallader Washburn W000170 | rep | WI | 1869-03-04 | 1871-03-03 | Republican | 6 | |||||||||||||
8775 | 8775 | Elihu Washburne W000176 | rep | IL | 1869-03-04 | 1871-03-03 | Republican | 3 | |||||||||||||
8778 | 8778 | Martin Welker W000270 | rep | OH | 1869-03-04 | 1871-03-03 | Republican | 14 | |||||||||||||
8779 | 8779 | George Whitmore W000424 | rep | TX | 1869-03-04 | 1871-03-03 | Republican | 1 | |||||||||||||
8781 | 8781 | Benjamin Whittemore W000427 | rep | SC | 1869-03-04 | 1871-03-03 | Republican | 1 | |||||||||||||
8783 | 8783 | Morton Wilkinson W000476 | rep | MN | 1869-03-04 | 1871-03-03 | Republican | 1 | |||||||||||||
8784 | 8784 | Eugene Wilson W000578 | rep | MN | 1869-03-04 | 1871-03-03 | Democrat | 2 | |||||||||||||
8785 | 8785 | James Winans W000626 | rep | OH | 1869-03-04 | 1871-03-03 | Republican | 7 | |||||||||||||
8786 | 8786 | John Witcher W000656 | rep | WV | 1869-03-04 | 1871-03-03 | Republican | 3 | |||||||||||||
8787 | 8787 | William Wolf W000676 | rep | IA | 1869-03-04 | 1871-03-03 | Republican | 2 | |||||||||||||
8789 | 8789 | George Woodward W000730 | rep | PA | 1869-03-04 | 1871-03-03 | Democrat | 12 | |||||||||||||
8800 | 8800 | Jacob Ambler A000169 | rep | OH | 1869-03-04 | 1871-03-03 | Republican | 17 | |||||||||||||
8805 | 8805 | Oakes Ames A000175 | rep | MA | 1869-03-04 | 1871-03-03 | Republican | 2 | |||||||||||||
8808 | 8808 | John Beatty B000283 | rep | OH | 1869-03-04 | 1871-03-03 | Republican | 8 | |||||||||||||
8813 | 8813 | Benjamin Biggs B000457 | rep | DE | 1869-03-04 | 1871-03-03 | Democrat | 0 | |||||||||||||
8821 | 8821 | John Bingham B000471 | rep | OH | 1869-03-04 | 1871-03-03 | Republican | 16 | |||||||||||||
8823 | 8823 | John Bird B000478 | rep | NJ | 1869-03-04 | 1871-03-03 | Democrat | 3 | |||||||||||||
8826 | 8826 | Austin Blair B000521 | rep | MI | 1869-03-04 | 1871-03-03 | Republican | 3 | |||||||||||||
8836 | 8836 | Thomas Boles B000603 | rep | AR | 1869-03-04 | 1871-03-03 | Republican | 3 | |||||||||||||
8839 | 8839 | George Brooks B000879 | rep | MA | 1869-03-04 | 1871-03-03 | Republican | 7 | |||||||||||||
8842 | 8842 | Charles Buckley B001025 | rep | AL | 1869-03-04 | 1871-03-03 | Republican | 2 | |||||||||||||
8844 | 8844 | Samuel Burdett B001074 | rep | MO | 1869-03-04 | 1871-03-03 | Republican | 5 | |||||||||||||
8856 | 8856 | William Clark C000455 | rep | TX | 1869-03-04 | 1871-03-03 | Republican | 3 | |||||||||||||
8860 | 8860 | John Conner C000691 | rep | TX | 1869-03-04 | 1871-03-03 | Democrat | 2 | |||||||||||||
8864 | 8864 | Burton Cook C000715 | rep | IL | 1869-03-04 | 1871-03-03 | Republican | 6 | |||||||||||||
8871 | 8871 | John Crebs C000900 | rep | IL | 1869-03-04 | 1871-03-03 | Democrat | 13 | |||||||||||||
8877 | 8877 | Oliver Dickey D000315 | rep | PA | 1869-03-04 | 1871-03-03 | Republican | 9 | |||||||||||||
8880 | 8880 | Peter Dox D000478 | rep | AL | 1869-03-04 | 1871-03-03 | Democrat | 5 | |||||||||||||
8883 | 8883 | Richard Duke D000521 | rep | VA | 1869-03-04 | 1871-03-03 | Conservative | 5 | |||||||||||||
8892 | 8892 | John Farnsworth F000024 | rep | IL | 1869-03-04 | 1871-03-03 | Republican | 2 | |||||||||||||
8894 | 8894 | Gustavus Finkelnburg F000129 | rep | MO | 1869-03-04 | 1871-03-03 | Republican | 2 | |||||||||||||
8905 | 8905 | Selucius Garfielde G000064 | rep | WA | 1869-03-04 | 1871-03-03 | Republican | -1 | |||||||||||||
8909 | 8909 | James Getz G000145 | rep | PA | 1869-03-04 | 1871-03-03 | Democrat | 8 | |||||||||||||
8915 | 8915 | Richard Haldeman H000027 | rep | PA | 1869-03-04 | 1871-03-03 | Democrat | 15 | |||||||||||||
8919 | 8919 | Samuel Hambleton H000095 | rep | MD | 1869-03-04 | 1871-03-03 | Democrat | 1 | |||||||||||||
8924 | 8924 | George Harris H000238 | rep | MS | 1869-03-04 | 1871-03-03 | Republican | 1 | |||||||||||||
8926 | 8926 | John Hay H000383 | rep | IL | 1869-03-04 | 1871-03-03 | Republican | 12 | |||||||||||||
8937 | 8937 | William Hooper H000767 | rep | UT | 1869-03-04 | 1871-03-03 | Democrat | -1 | |||||||||||||
8943 | 8943 | Joseph Lewis L000289 | rep | KY | 1869-03-04 | 1871-03-03 | Democrat | 3 | |||||||||||||
8947 | 8947 | John Lynch L000531 | rep | ME | 1869-03-04 | 1871-03-03 | Republican | 1 | |||||||||||||
8954 | 8954 | James McCormick M000367 | rep | MO | 1869-03-04 | 1871-03-03 | Democrat | 3 | |||||||||||||
8956 | 8956 | James McGrew M000461 | rep | WV | 1869-03-04 | 1871-03-03 | Republican | 2 | |||||||||||||
8961 | 8961 | Thompson McNeely M000585 | rep | IL | 1869-03-04 | 1871-03-03 | Democrat | 9 | |||||||||||||
8965 | 8965 | Ulysses Mercur M000646 | rep | PA | 1869-03-04 | 1871-03-03 | Republican | 13 | |||||||||||||
8971 | 8971 | Jesse Moore M000902 | rep | IL | 1869-03-04 | 1871-03-03 | Republican | 7 | |||||||||||||
8974 | 8974 | George Morgan M000950 | rep | OH | 1869-03-04 | 1871-03-03 | Democrat | 13 | |||||||||||||
8976 | 8976 | Joseph Morphis M000963 | rep | MS | 1869-03-04 | 1871-03-03 | Republican | 2 | |||||||||||||
8980 | 8980 | Lot Morrill M000970 | sen | ME | 1869-03-04 | 1871-03-03 | 2 | Republican | |||||||||||||
8983 | 8983 | Francis Palmer P000038 | rep | IA | 1869-03-04 | 1871-03-03 | Republican | 5 | |||||||||||||
8985 | 8985 | Erasmus Peck P000175 | rep | OH | 1869-03-04 | 1871-03-03 | Republican | 10 | |||||||||||||
8987 | 8987 | Legrand Perce P000221 | rep | MS | 1869-03-04 | 1871-03-03 | Republican | 5 | |||||||||||||
8991 | 8991 | John Peters P000252 | rep | ME | 1869-03-04 | 1871-03-03 | Republican | 4 | |||||||||||||
8993 | 8993 | Charles Porter P000438 | rep | VA | 1869-03-04 | 1871-03-03 | Republican | 3 | |||||||||||||
8995 | 8995 | William Price P000533 | rep | GA | 1869-03-04 | 1871-03-03 | Democrat | 6 | |||||||||||||
8999 | 8999 | John Rice R000202 | rep | KY | 1869-03-04 | 1871-03-03 | Democrat | 9 | |||||||||||||
9014 | 9014 | Francis Shober S000372 | rep | NC | 1869-03-04 | 1871-03-03 | Democrat | 6 | |||||||||||||
9016 | 9016 | John Smith S000569 | rep | OH | 1869-03-04 | 1871-03-03 | Republican | 6 | |||||||||||||
9019 | 9019 | Worthington Smith S000641 | rep | VT | 1869-03-04 | 1871-03-03 | Republican | 3 | |||||||||||||
9025 | 9025 | Job Stevenson S000893 | rep | OH | 1869-03-04 | 1871-03-03 | Republican | 2 | |||||||||||||
9030 | 9030 | William Stoughton S000979 | rep | MI | 1869-03-04 | 1871-03-03 | Republican | 2 | |||||||||||||
9032 | 9032 | Julius Strong S001013 | rep | CT | 1869-03-04 | 1871-03-03 | Republican | 1 | |||||||||||||
9036 | 9036 | John Taffe T000006 | rep | NE | 1869-03-04 | 1871-03-03 | Republican | 1 | |||||||||||||
9043 | 9043 | Ginery Twichell T000443 | rep | MA | 1869-03-04 | 1871-03-03 | Republican | 3 | |||||||||||||
9045 | 9045 | William Upson U000029 | rep | OH | 1869-03-04 | 1871-03-03 | Republican | 18 | |||||||||||||
9048 | 9048 | Philadelph Van Trump V000060 | rep | OH | 1869-03-04 | 1871-03-03 | Democrat | 12 |
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);