legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
291 rows where "start" is on date 1871-03-04 sorted by district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8793 | 8793 | Morgan Hamilton H000115 | sen | TX | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
8799 | 8799 | James Alcorn A000079 | sen | MS | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
8832 | 8832 | Francis Blair B000523 | sen | MO | 1871-03-04 | 1873-03-03 | 3 | Democrat | |||||||||||||
8846 | 8846 | Alexander Caldwell C000027 | sen | KS | 1871-03-04 | 1873-12-31 | 2 | Republican | |||||||||||||
8858 | 8858 | Powell Clayton C000498 | sen | AR | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
8866 | 8866 | Henry Cooper C000751 | sen | TN | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
8870 | 8870 | Aaron Cragin C000852 | sen | NH | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
8901 | 8901 | Frederick Frelinghuysen F000369 | sen | NJ | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
8911 | 8911 | George Goldthwaite G000266 | sen | AL | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
8931 | 8931 | Joshua Hill H000599 | sen | GA | 1871-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
8933 | 8933 | Phineas Hitchcock H000648 | sen | NE | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
8940 | 8940 | James Kelly K000074 | sen | OR | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
8970 | 8970 | Homer Miller M000728 | sen | GA | 1871-03-04 | 1871-12-31 | 2 | Democrat | |||||||||||||
8981 | 8981 | Lot Morrill M000970 | sen | ME | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
9003 | 9003 | Thomas Robertson R000327 | sen | SC | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
9023 | 9023 | Ozora Stearns S000824 | sen | MN | 1871-03-04 | 1871-12-31 | 2 | Republican | |||||||||||||
9029 | 9029 | John Stevenson S000894 | sen | KY | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
9054 | 9054 | Joseph West W000303 | sen | LA | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
9059 | 9059 | Henry Wilson W000585 | sen | MA | 1871-03-04 | 1873-12-31 | 2 | Republican | |||||||||||||
9065 | 9065 | George Wright W000759 | sen | IA | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
9782 | 9782 | Henry Davis D000103 | sen | WV | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
9805 | 9805 | Thomas Ferry F000095 | sen | MI | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
10245 | 10245 | William Windom W000629 | sen | MN | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
10626 | 10626 | Henry Anthony A000262 | sen | RI | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
10874 | 10874 | Eli Saulsbury S000072 | sen | DE | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
11114 | 11114 | John Logan L000403 | sen | IL | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
11461 | 11461 | Thomas Norwood N000160 | sen | GA | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
8811 | 8811 | John Beveridge B000430 | rep | IL | 1871-03-04 | 1873-03-03 | Republican | -1 | |||||||||||||
8855 | 8855 | William Clagett C000400 | rep | MT | 1871-03-04 | 1873-03-03 | Republican | -1 | |||||||||||||
8904 | 8904 | José Gallegos G000022 | rep | NM | 1871-03-04 | 1873-03-03 | Democrat | -1 | |||||||||||||
8906 | 8906 | Selucius Garfielde G000064 | rep | WA | 1871-03-04 | 1873-03-03 | Republican | -1 | |||||||||||||
8938 | 8938 | William Hooper H000767 | rep | UT | 1871-03-04 | 1873-03-03 | Democrat | -1 | |||||||||||||
8968 | 8968 | Samuel Merritt M000662 | rep | ID | 1871-03-04 | 1873-03-03 | Democrat | -1 | |||||||||||||
9077 | 9077 | Moses Armstrong A000283 | rep | DK | 1871-03-04 | 1873-03-03 | Democrat | -1 | |||||||||||||
9723 | 9723 | Jerome Chaffee C000271 | rep | CO | 1871-03-04 | 1873-03-03 | Republican | -1 | |||||||||||||
8814 | 8814 | Benjamin Biggs B000457 | rep | DE | 1871-03-04 | 1873-03-03 | Democrat | 0 | |||||||||||||
8939 | 8939 | William Jones J000261 | rep | WY | 1871-03-04 | 1873-03-03 | Republican | 0 | |||||||||||||
9115 | 9115 | Norton Chipman C000370 | rep | DC | 1871-03-04 | 1873-03-03 | Republican | 0 | |||||||||||||
9221 | 9221 | Charles Kendall K000090 | rep | NV | 1871-03-04 | 1873-03-03 | Democrat | 0 | |||||||||||||
13078 | 13078 | Richard McCormick M000371 | rep | AZ | 1871-03-04 | 1873-03-03 | Unionist | 0 | |||||||||||||
8874 | 8874 | John Critcher C000911 | rep | VA | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
8879 | 8879 | Ozro Dodds D000393 | rep | OH | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
8920 | 8920 | Samuel Hambleton H000095 | rep | MD | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
8922 | 8922 | James Hanks H000157 | rep | AR | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
8925 | 8925 | George Harris H000238 | rep | MS | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
8928 | 8928 | Ellery Hibbard H000556 | rep | NH | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
8948 | 8948 | John Lynch L000531 | rep | ME | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
8949 | 8949 | Archibald MacIntyre M000017 | rep | GA | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
8982 | 8982 | Silas Niblack N000082 | rep | FL | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
8989 | 8989 | Aaron Perry P000241 | rep | OH | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9033 | 9033 | Julius Strong S001013 | rep | CT | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9037 | 9037 | John Taffe T000006 | rep | NE | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9039 | 9039 | Dwight Townsend T000331 | rep | NY | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
9040 | 9040 | Benjamin Turner T000414 | rep | AL | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9124 | 9124 | Clinton Cobb C000544 | rep | NC | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9140 | 9140 | Edward Crossland C000933 | rep | KY | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
9148 | 9148 | John Davis D000119 | rep | WV | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
9196 | 9196 | John Hazelton H000420 | rep | NJ | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9198 | 9198 | William Herndon H000535 | rep | TX | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
9209 | 9209 | Sherman Houghton H000815 | rep | CA | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9240 | 9240 | David Lowe L000473 | rep | KS | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9276 | 9276 | Alexander Mitchell M000802 | rep | WI | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
9294 | 9294 | William Niblack N000083 | rep | IN | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
9391 | 9391 | Jacob Sypher S001140 | rep | LA | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9414 | 9414 | Charles Willard W000478 | rep | VT | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9467 | 9467 | James Buffinton B001040 | rep | MA | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9578 | 9578 | George McCrary M000379 | rep | IA | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9668 | 9668 | Henry Waldron W000041 | rep | MI | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9680 | 9680 | Josiah Walls W000093 | rep | FL | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9792 | 9792 | Benjamin Eames E000005 | rep | RI | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
9906 | 9906 | Joseph Rainey R000016 | rep | SC | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
10191 | 10191 | James Slater S000476 | rep | OR | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
10214 | 10214 | Erastus Wells W000282 | rep | MO | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
11314 | 11314 | Roderick Butler B001188 | rep | TN | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
11363 | 11363 | Charles Farwell F000037 | rep | IL | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
11740 | 11740 | Mark Dunnell D000555 | rep | MN | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
11916 | 11916 | Samuel Randall R000039 | rep | PA | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
13699 | 13699 | Joseph Hawley H000377 | rep | CT | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
8806 | 8806 | Oakes Ames A000175 | rep | MA | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
8843 | 8843 | Charles Buckley B001025 | rep | AL | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
8861 | 8861 | John Conner C000691 | rep | TX | 1871-03-04 | 1873-03-03 | Democrat | 2 | |||||||||||||
8873 | 8873 | John Creely C000901 | rep | PA | 1871-03-04 | 1873-03-03 | Ind. Republican | 2 | |||||||||||||
8875 | 8875 | Robert De Large D000208 | rep | SC | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
8893 | 8893 | John Farnsworth F000024 | rep | IL | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
8895 | 8895 | Gustavus Finkelnburg F000129 | rep | MO | 1871-03-04 | 1873-03-03 | Liberal Republican | 2 | |||||||||||||
8896 | 8896 | Samuel Forker F000274 | rep | NJ | 1871-03-04 | 1873-03-03 | Democrat | 2 | |||||||||||||
8942 | 8942 | Thomas Kinsella K000226 | rep | NY | 1871-03-04 | 1873-03-03 | Democrat | 2 | |||||||||||||
8957 | 8957 | James McGrew M000461 | rep | WV | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
8958 | 8958 | Henry McHenry M000468 | rep | KY | 1871-03-04 | 1873-03-03 | Democrat | 2 | |||||||||||||
8977 | 8977 | Joseph Morphis M000963 | rep | MS | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
9026 | 9026 | Job Stevenson S000893 | rep | OH | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
9031 | 9031 | William Stoughton S000979 | rep | MI | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
9075 | 9075 | Stevenson Archer A000274 | rep | MD | 1871-03-04 | 1873-03-03 | Democrat | 2 | |||||||||||||
9081 | 9081 | John Averill A000344 | rep | MN | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
9135 | 9135 | Aylett Cotton C000801 | rep | IA | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
9194 | 9194 | Gerry Hazelton H000419 | rep | WI | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
9219 | 9219 | Stephen Kellogg K000067 | rep | CT | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
9258 | 9258 | Horace Maynard M000284 | rep | TN | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
9312 | 9312 | James Pendleton P000204 | rep | RI | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
9317 | 9317 | James Platt P000380 | rep | VA | 1871-03-04 | 1873-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);