legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
338 rows where "end" is on date 1881-03-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9552 | 9552 | Francis Kernan K000133 | sen | NY | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
9582 | 9582 | Joseph McDonald M000412 | sen | IN | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
9617 | 9617 | Theodore Randolph R000050 | sen | NJ | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
9658 | 9658 | Allen Thurman T000251 | sen | OH | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
9678 | 9678 | William Wallace W000084 | sen | PA | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
9705 | 9705 | Robert Withers W000659 | sen | VA | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
9733 | 9733 | James Bailey B000039 | sen | TN | 1877-10-15 | 1881-03-03 | 1 | Democrat | |||||||||||||
9849 | 9849 | Frank Hereford H000527 | sen | WV | 1877-10-15 | 1881-03-03 | 1 | Democrat | |||||||||||||
9993 | 9993 | Joseph Acklen A000023 | rep | LA | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
9994 | 9994 | Reuben Bachman B000011 | rep | PA | 1879-03-18 | 1881-03-03 | Democrat | 10 | |||||||||||||
10008 | 10008 | Richard Beale B000268 | rep | VA | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10012 | 10012 | George Bicknell B000438 | rep | IN | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10015 | 10015 | Gabriel Bouck B000658 | rep | WI | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
10023 | 10023 | John Bright B000836 | rep | TN | 1879-03-18 | 1881-03-03 | Democrat | 5 | |||||||||||||
10024 | 10024 | John Campbell C000092 | rep | AZ | 1879-03-18 | 1881-03-03 | Democrat | 0 | |||||||||||||
10038 | 10038 | Alvah Clark C000419 | rep | NJ | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
10041 | 10041 | Newton Clements C000509 | rep | AL | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
10045 | 10045 | Hiester Clymer C000539 | rep | PA | 1879-03-18 | 1881-03-03 | Democrat | 8 | |||||||||||||
10048 | 10048 | Alexander Coffroth C000593 | rep | PA | 1879-03-18 | 1881-03-03 | Democrat | 17 | |||||||||||||
10061 | 10061 | Joseph Davis D000123 | rep | NC | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
10065 | 10065 | Henry Dickey D000311 | rep | OH | 1879-03-18 | 1881-03-03 | Democrat | 11 | |||||||||||||
10069 | 10069 | Joseph Elam E000100 | rep | LA | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
10071 | 10071 | Thomas Ewing E000280 | rep | OH | 1879-03-18 | 1881-03-03 | Democrat | 10 | |||||||||||||
10081 | 10081 | Ebenezer Finley F000132 | rep | OH | 1879-03-18 | 1881-03-03 | Democrat | 8 | |||||||||||||
10090 | 10090 | John Goode G000277 | rep | VA | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10097 | 10097 | John Harris H000247 | rep | VA | 1879-03-18 | 1881-03-03 | Democrat | 7 | |||||||||||||
10102 | 10102 | Eli Henkle H000497 | rep | MD | 1879-03-18 | 1881-03-03 | Democrat | 5 | |||||||||||||
10104 | 10104 | Daniel Henry H000504 | rep | MD | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10106 | 10106 | Abraham Hostetler H000805 | rep | IN | 1879-03-18 | 1881-03-03 | Democrat | 8 | |||||||||||||
10117 | 10117 | Noble Hull H000945 | rep | FL | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10120 | 10120 | Joseph Johnston J000192 | rep | VA | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10129 | 10129 | William Kimmel K000185 | rep | MD | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10130 | 10130 | William Kitchin K000251 | rep | NC | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10131 | 10131 | Alfred Lay L000149 | rep | MO | 1879-03-18 | 1881-03-03 | Democrat | 7 | |||||||||||||
10133 | 10133 | Burwell Lewis L000272 | rep | AL | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
10136 | 10136 | William Lounsbery L000452 | rep | NY | 1879-03-18 | 1881-03-03 | Democrat | 15 | |||||||||||||
10140 | 10140 | Benjamin Martin M000169 | rep | WV | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10146 | 10146 | John McMahon M000561 | rep | OH | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10152 | 10152 | William Myers M001133 | rep | IN | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
10154 | 10154 | Jeptha New N000060 | rep | IN | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
10169 | 10169 | John Philips P000304 | rep | MO | 1879-03-18 | 1881-03-03 | Democrat | 7 | |||||||||||||
10171 | 10171 | Henry Poehler P000400 | rep | MN | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10177 | 10177 | James Richmond R000234 | rep | VA | 1879-03-18 | 1881-03-03 | Democrat | 9 | |||||||||||||
10178 | 10178 | Gideon Rothwell R000463 | rep | MO | 1879-03-18 | 1881-03-03 | Democrat | 10 | |||||||||||||
10180 | 10180 | John Ryon R000564 | rep | PA | 1879-03-18 | 1881-03-03 | Democrat | 13 | |||||||||||||
10181 | 10181 | William Samford S000022 | rep | AL | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10187 | 10187 | Gustave Schleicher S000129 | rep | TX | 1879-03-18 | 1881-03-03 | Democrat | -1 | |||||||||||||
10195 | 10195 | William Slemons S000484 | rep | AR | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10196 | 10196 | Hezekiah Smith S000549 | rep | NJ | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10199 | 10199 | William Smith S000631 | rep | GA | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10203 | 10203 | Walter Steele S000838 | rep | NC | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
10205 | 10205 | Adlai Stevenson S000889 | rep | IL | 1879-03-18 | 1881-03-03 | Democrat | 13 | |||||||||||||
10209 | 10209 | Thomas Turner T000428 | rep | KY | 1879-03-18 | 1881-03-03 | Democrat | 9 | |||||||||||||
10211 | 10211 | James Waddill W000004 | rep | MO | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
10217 | 10217 | Erastus Wells W000282 | rep | MO | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10220 | 10220 | John Whiteaker W000399 | rep | OR | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10228 | 10228 | Jesse Yeates Y000016 | rep | NC | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10248 | 10248 | George Ainslie A000066 | rep | ID | 1879-03-18 | 1881-03-03 | Democrat | -1 | |||||||||||||
10254 | 10254 | Robert Armfield A000278 | rep | NC | 1879-03-18 | 1881-03-03 | Democrat | 7 | |||||||||||||
10256 | 10256 | Gibson Atherton A000325 | rep | OH | 1879-03-18 | 1881-03-03 | Democrat | 14 | |||||||||||||
10262 | 10262 | John Atkins A000327 | rep | TN | 1879-03-18 | 1881-03-03 | Democrat | 8 | |||||||||||||
10265 | 10265 | Thomas Bayard B000253 | sen | DE | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
10267 | 10267 | Campbell Berry B000415 | rep | CA | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10277 | 10277 | John Caldwell C000036 | rep | KY | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10295 | 10295 | John Clark C000442 | rep | MO | 1879-03-18 | 1881-03-03 | Democrat | 11 | |||||||||||||
10297 | 10297 | Walpole Colerick C000623 | rep | IN | 1879-03-18 | 1881-03-03 | Democrat | 12 | |||||||||||||
10309 | 10309 | Philip Cook C000724 | rep | GA | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10318 | 10318 | Jordan Cravens C000885 | rep | AR | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10352 | 10352 | Richard Frost F000393 | rep | MO | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10360 | 10360 | Thomas Gunter G000527 | rep | AR | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
10390 | 10390 | John House H000819 | rep | TN | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
10404 | 10404 | Charles Jones J000214 | sen | FL | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
10416 | 10416 | Robert Klotz K000272 | rep | PA | 1879-03-18 | 1881-03-03 | Democrat | 11 | |||||||||||||
10422 | 10422 | James Knott K000290 | rep | KY | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
10442 | 10442 | Edward Martin M000178 | rep | DE | 1879-03-18 | 1881-03-03 | Democrat | 0 | |||||||||||||
10446 | 10446 | Samuel Maxey M000265 | sen | TX | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
10455 | 10455 | James McKenzie M000505 | rep | KY | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10459 | 10459 | Robert McLane M000537 | rep | MD | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
10483 | 10483 | Michael O’Connor O000031 | rep | SC | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10503 | 10503 | James Phelps P000295 | rep | CT | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10505 | 10505 | Elijah Phister P000318 | rep | KY | 1879-03-18 | 1881-03-03 | Democrat | 10 | |||||||||||||
10517 | 10517 | John Richardson R000225 | rep | SC | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10524 | 10524 | Miles Ross R000452 | rep | NJ | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10526 | 10526 | Jonathan Scoville S000190 | rep | NY | 1879-03-18 | 1881-03-03 | Democrat | 32 | |||||||||||||
10536 | 10536 | Charles Simonton S000426 | rep | TN | 1879-03-18 | 1881-03-03 | Democrat | 9 | |||||||||||||
10538 | 10538 | James Singleton S000444 | rep | IL | 1879-03-18 | 1881-03-03 | Democrat | 11 | |||||||||||||
10544 | 10544 | William Sparks S000704 | rep | IL | 1879-03-18 | 1881-03-03 | Democrat | 16 | |||||||||||||
10560 | 10560 | Alexander Stephens S000854 | rep | GA | 1879-03-18 | 1881-03-03 | Democrat | 8 | |||||||||||||
10571 | 10571 | Christopher Upson U000028 | rep | TX | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
10599 | 10599 | Benjamin Wilson W000569 | rep | WV | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10601 | 10601 | Morgan Wise W000652 | rep | PA | 1879-03-18 | 1881-03-03 | Democrat | 21 | |||||||||||||
10614 | 10614 | Fernando Wood W000694 | rep | NY | 1879-03-18 | 1881-03-03 | Democrat | 9 | |||||||||||||
10658 | 10658 | Aylett Buckner B001031 | rep | MO | 1879-03-18 | 1881-03-03 | Democrat | 13 | |||||||||||||
10669 | 10669 | James Chalmers C000272 | rep | MS | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
10674 | 10674 | George Converse C000711 | rep | OH | 1879-03-18 | 1881-03-03 | Democrat | 9 | |||||||||||||
10691 | 10691 | Lowndes Davis D000124 | rep | MO | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
10694 | 10694 | Peter Deuster D000274 | rep | WI | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
10699 | 10699 | George Dibrell D000301 | rep | TN | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10706 | 10706 | William Eaton E000028 | sen | CT | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
10711 | 10711 | Ezekiel Ellis E000134 | rep | LA | 1879-03-18 | 1881-03-03 | Democrat | 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);