legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
289 rows where "end" is on date 1873-03-03 sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8289 | 8289 | Cornelius Cole C000607 | sen | CA | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
8297 | 8297 | Henry Corbett C000771 | sen | OR | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
8304 | 8304 | Garrett Davis D000099 | sen | KY | 1867-03-04 | 1873-03-03 | 3 | Democrat | |||||||||||||
8348 | 8348 | James Harlan H000211 | sen | IA | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
8410 | 8410 | James Nye N000177 | sen | NV | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
8413 | 8413 | James Patterson P000120 | sen | NH | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
8430 | 8430 | Samuel Pomeroy P000423 | sen | KS | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
8475 | 8475 | Lyman Trumbull T000392 | sen | IL | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
8496 | 8496 | Thomas Osborn O000109 | sen | FL | 1868-01-01 | 1873-03-03 | 3 | Republican | |||||||||||||
8497 | 8497 | John Pool P000427 | sen | NC | 1868-01-01 | 1873-03-03 | 3 | Republican | |||||||||||||
8498 | 8498 | Benjamin Rice R000195 | sen | AR | 1868-01-01 | 1873-03-03 | 3 | Republican | |||||||||||||
8499 | 8499 | Frederick Sawyer S000086 | sen | SC | 1868-01-01 | 1873-03-03 | 3 | Republican | |||||||||||||
8500 | 8500 | George Vickers V000095 | sen | MD | 1868-01-01 | 1873-03-03 | 3 | Democrat | |||||||||||||
8832 | 8832 | Francis Blair B000523 | sen | MO | 1871-03-04 | 1873-03-03 | 3 | Democrat | |||||||||||||
8931 | 8931 | Joshua Hill H000599 | sen | GA | 1871-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
9066 | 9066 | Willis Machen M000012 | sen | KY | 1872-09-27 | 1873-03-03 | 3 | Democrat | |||||||||||||
9110 | 9110 | Simon Cameron C000068 | sen | PA | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
9168 | 9168 | Orris Ferry F000094 | sen | CT | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
9213 | 9213 | Timothy Howe H000856 | sen | WI | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
9279 | 9279 | Oliver Morton M001020 | sen | IN | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
9379 | 9379 | George Spencer S000723 | sen | AL | 1868-01-01 | 1873-03-03 | 3 | Republican | |||||||||||||
10052 | 10052 | Roscoe Conkling C000681 | sen | NY | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
10779 | 10779 | William Kellogg K000069 | sen | LA | 1868-01-01 | 1873-03-03 | 3 | Republican | |||||||||||||
12780 | 12780 | John Sherman S000346 | sen | OH | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
13431 | 13431 | Justin Morrill M000969 | sen | VT | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
9339 | 9339 | Aaron Sargent S000065 | rep | CA | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
9359 | 9359 | Lionel Sheldon S000322 | rep | LA | 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);