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
This data as json, copyable, CSV (advanced)
Suggested facets: state, party, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9452 | 9452 | Newton Booth B000630 | sen | CA | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
9461 | 9461 | Blanche Bruce B000968 | sen | MS | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
9473 | 9473 | Ambrose Burnside B001130 | sen | RI | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
9520 | 9520 | Hannibal Hamlin H000121 | sen | ME | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
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 | |||||||||||||
9633 | 9633 | William Sharon S000292 | sen | NV | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
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 | |||||||||||||
9996 | 9996 | John Bailey B000042 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 16 | |||||||||||||
9999 | 9999 | John Baker B000068 | rep | IN | 1879-03-18 | 1881-03-03 | Republican | 13 | |||||||||||||
10000 | 10000 | Henry Baldwin B000089 | sen | MI | 1879-03-18 | 1881-03-03 | 1 | Republican | |||||||||||||
10003 | 10003 | Latimer Ballou B000106 | rep | RI | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
10004 | 10004 | Hiram Barber B000120 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10005 | 10005 | Bradley Barlow B000148 | rep | VT | 1879-03-18 | 1881-03-03 | National Greenbacker | 3 | |||||||||||||
10008 | 10008 | Richard Beale B000268 | rep | VA | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10010 | 10010 | Granville Bennett B000374 | rep | DK | 1879-03-18 | 1881-03-03 | Republican | -1 | |||||||||||||
10012 | 10012 | George Bicknell B000438 | rep | IN | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10013 | 10013 | John Blake B000532 | rep | NJ | 1879-03-18 | 1881-03-03 | Republican | 6 | |||||||||||||
10015 | 10015 | Gabriel Bouck B000658 | rep | WI | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
10017 | 10017 | Thomas Boyd B000721 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 9 | |||||||||||||
10018 | 10018 | Lewis Brigham B000834 | rep | NJ | 1879-03-18 | 1881-03-03 | Republican | 7 | |||||||||||||
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 | |||||||||||||
10034 | 10034 | Simeon Chittenden C000373 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10036 | 10036 | William Claflin C000398 | rep | MA | 1879-03-18 | 1881-03-03 | Republican | 8 | |||||||||||||
10038 | 10038 | Alvah Clark C000419 | rep | NJ | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
10040 | 10040 | Rush Clark C000450 | rep | IA | 1879-03-18 | 1881-03-03 | Republican | 5 | |||||||||||||
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 | |||||||||||||
10055 | 10055 | Calvin Cowgill C000824 | rep | IN | 1879-03-18 | 1881-03-03 | Republican | 11 | |||||||||||||
10056 | 10056 | Rollin Daggett D000003 | rep | NV | 1879-03-18 | 1881-03-03 | Republican | 0 | |||||||||||||
10058 | 10058 | Horace Davis D000105 | rep | CA | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10061 | 10061 | Joseph Davis D000123 | rep | NC | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
10062 | 10062 | Gilbert De La Matyr D000204 | rep | IN | 1879-03-18 | 1881-03-03 | National Greenbacker | 7 | |||||||||||||
10063 | 10063 | Samuel Dick D000305 | rep | PA | 1879-03-18 | 1881-03-03 | Republican | 26 | |||||||||||||
10065 | 10065 | Henry Dickey D000311 | rep | OH | 1879-03-18 | 1881-03-03 | Democrat | 11 | |||||||||||||
10066 | 10066 | Stephen Downey D000470 | rep | WY | 1879-03-18 | 1881-03-03 | Republican | 0 | |||||||||||||
10067 | 10067 | Edwin Einstein E000097 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 7 | |||||||||||||
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 | |||||||||||||
10073 | 10073 | Evarts Farr F000028 | rep | NH | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10076 | 10076 | William Felton F000070 | rep | GA | 1879-03-18 | 1881-03-03 | Ind. Democrat | 7 | |||||||||||||
10077 | 10077 | John Ferdon F000079 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 14 | |||||||||||||
10079 | 10079 | Walbridge Field F000108 | rep | MA | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10081 | 10081 | Ebenezer Finley F000132 | rep | OH | 1879-03-18 | 1881-03-03 | Democrat | 8 | |||||||||||||
10082 | 10082 | Albert Forsythe F000285 | rep | IL | 1879-03-18 | 1881-03-03 | National Greenbacker | 15 | |||||||||||||
10086 | 10086 | Greenbury Fort F000288 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 8 | |||||||||||||
10087 | 10087 | Edward Gillette G000203 | rep | IA | 1879-03-18 | 1881-03-03 | National Greenbacker | 7 | |||||||||||||
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 | |||||||||||||
10099 | 10099 | Philip Hayes H000391 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 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 | |||||||||||||
10119 | 10119 | Amaziah James J000044 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 19 | |||||||||||||
10120 | 10120 | Joseph Johnston J000192 | rep | VA | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10127 | 10127 | John Killinger K000179 | rep | PA | 1879-03-18 | 1881-03-03 | Republican | 14 | |||||||||||||
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 | |||||||||||||
10135 | 10135 | George Loring L000445 | rep | MA | 1879-03-18 | 1881-03-03 | Republican | 6 | |||||||||||||
10136 | 10136 | William Lounsbery L000452 | rep | NY | 1879-03-18 | 1881-03-03 | Democrat | 15 | |||||||||||||
10138 | 10138 | Thomas Majors M000075 | rep | NE | 1879-03-18 | 1881-03-03 | Republican | -1 | |||||||||||||
10140 | 10140 | Benjamin Martin M000169 | rep | WV | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10141 | 10141 | Joseph Martin M000190 | rep | NC | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10143 | 10143 | Jonas McGowan M000453 | rep | MI | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10146 | 10146 | John McMahon M000561 | rep | OH | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10151 | 10151 | James Monroe M000857 | rep | OH | 1879-03-18 | 1881-03-03 | Republican | 17 | |||||||||||||
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 | |||||||||||||
10155 | 10155 | John Newberry N000061 | rep | MI | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10156 | 10156 | James O’Brien O000011 | rep | NY | 1879-03-18 | 1881-03-03 | Ind. Democrat | 10 | |||||||||||||
10157 | 10157 | Daniel O’Reilly O000099 | rep | NY | 1879-03-18 | 1881-03-03 | Ind. Democrat | 2 | |||||||||||||
10158 | 10158 | James Osmer O000119 | rep | PA | 1879-03-18 | 1881-03-03 | Republican | 27 | |||||||||||||
10159 | 10159 | Mariano Otero O000124 | rep | NM | 1879-03-18 | 1881-03-03 | Republican | -1 | |||||||||||||
10161 | 10161 | Edward Overton O000145 | rep | PA | 1879-03-18 | 1881-03-03 | Republican | 15 | |||||||||||||
10167 | 10167 | Henry Persons P000248 | rep | GA | 1879-03-18 | 1881-03-03 | Ind. Democrat | 4 | |||||||||||||
10169 | 10169 | John Philips P000304 | rep | MO | 1879-03-18 | 1881-03-03 | Democrat | 7 | |||||||||||||
10170 | 10170 | Ray Pierce P000336 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 32 | |||||||||||||
10171 | 10171 | Henry Poehler P000400 | rep | MN | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10176 | 10176 | Hiram Price P000525 | rep | IA | 1879-03-18 | 1881-03-03 | Republican | 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 | |||||||||||||
10179 | 10179 | Daniel Russell R000523 | rep | NC | 1879-03-18 | 1881-03-03 | National Greenbacker | 3 | |||||||||||||
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 | |||||||||||||
10183 | 10183 | William Sapp S000060 | rep | IA | 1879-03-18 | 1881-03-03 | Republican | 8 | |||||||||||||
10184 | 10184 | Samuel Sawyer S000092 | rep | MO | 1879-03-18 | 1881-03-03 | Ind. Democrat | 8 | |||||||||||||
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 |
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);