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 state
This data as json, copyable, CSV (advanced)
Suggested facets: state, start, class, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10041 | 10041 | Newton Clements C000509 | rep | AL | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
10133 | 10133 | Burwell Lewis L000272 | rep | AL | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
10181 | 10181 | William Samford S000022 | rep | AL | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10436 | 10436 | William Lowe L000474 | rep | AL | 1879-03-18 | 1881-03-03 | National Greenbacker | 8 | |||||||||||||
10745 | 10745 | Thomas Herndon H000534 | rep | AL | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10850 | 10850 | Luke Pryor P000557 | sen | AL | 1880-01-01 | 1881-03-03 | 3 | Democrat | |||||||||||||
10886 | 10886 | Charles Shelley S000326 | rep | AL | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
10933 | 10933 | Thomas Williams W000537 | rep | AL | 1879-03-18 | 1881-03-03 | Democrat | 5 | |||||||||||||
12166 | 12166 | William Forney F000280 | rep | AL | 1879-03-18 | 1881-03-03 | Democrat | 7 | |||||||||||||
12201 | 12201 | Hilary Herbert H000524 | rep | AL | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10195 | 10195 | William Slemons S000484 | rep | AR | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10318 | 10318 | Jordan Cravens C000885 | rep | AR | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10360 | 10360 | Thomas Gunter G000527 | rep | AR | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
11353 | 11353 | Poindexter Dunn D000552 | rep | AR | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10024 | 10024 | John Campbell C000092 | rep | AZ | 1879-03-18 | 1881-03-03 | Democrat | 0 | |||||||||||||
9452 | 9452 | Newton Booth B000630 | sen | CA | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
10058 | 10058 | Horace Davis D000105 | rep | CA | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10267 | 10267 | Campbell Berry B000415 | rep | CA | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10493 | 10493 | Romualdo Pacheco P000003 | rep | CA | 1879-03-18 | 1881-03-03 | Republican | 4 | |||||||||||||
10498 | 10498 | Horace Page P000017 | rep | CA | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
10635 | 10635 | James Belford B000326 | rep | CO | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10503 | 10503 | James Phelps P000295 | rep | CT | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10706 | 10706 | William Eaton E000028 | sen | CT | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
11246 | 11246 | John Wait W000025 | rep | CT | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
11853 | 11853 | Frederick Miles M000704 | rep | CT | 1879-03-18 | 1881-03-03 | Republican | 4 | |||||||||||||
13701 | 13701 | Joseph Hawley H000377 | rep | CT | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10265 | 10265 | Thomas Bayard B000253 | sen | DE | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
10442 | 10442 | Edward Martin M000178 | rep | DE | 1879-03-18 | 1881-03-03 | Democrat | 0 | |||||||||||||
10010 | 10010 | Granville Bennett B000374 | rep | DK | 1879-03-18 | 1881-03-03 | Republican | -1 | |||||||||||||
10117 | 10117 | Noble Hull H000945 | rep | FL | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10404 | 10404 | Charles Jones J000214 | sen | FL | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
10639 | 10639 | Horatio Bisbee B000485 | rep | FL | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
11719 | 11719 | Robert Davidson D000085 | rep | FL | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
10076 | 10076 | William Felton F000070 | rep | GA | 1879-03-18 | 1881-03-03 | Ind. Democrat | 7 | |||||||||||||
10167 | 10167 | Henry Persons P000248 | rep | GA | 1879-03-18 | 1881-03-03 | Ind. Democrat | 4 | |||||||||||||
10199 | 10199 | William Smith S000631 | rep | GA | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10309 | 10309 | Philip Cook C000724 | rep | GA | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10547 | 10547 | Emory Speer S000711 | rep | GA | 1879-03-18 | 1881-03-03 | Ind. Democrat | 9 | |||||||||||||
10560 | 10560 | Alexander Stephens S000854 | rep | GA | 1879-03-18 | 1881-03-03 | Democrat | 8 | |||||||||||||
10825 | 10825 | John Nicholls N000087 | rep | GA | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
11062 | 11062 | Nathaniel Hammond H000130 | rep | GA | 1879-03-18 | 1881-03-03 | Democrat | 5 | |||||||||||||
12090 | 12090 | James Blount B000568 | rep | GA | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
12183 | 12183 | John Gordon G000313 | sen | GA | 1879-03-18 | 1881-03-03 | 3 | Democrat | |||||||||||||
10040 | 10040 | Rush Clark C000450 | rep | IA | 1879-03-18 | 1881-03-03 | Republican | 5 | |||||||||||||
10087 | 10087 | Edward Gillette G000203 | rep | IA | 1879-03-18 | 1881-03-03 | National Greenbacker | 7 | |||||||||||||
10176 | 10176 | Hiram Price P000525 | rep | IA | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
10183 | 10183 | William Sapp S000060 | rep | IA | 1879-03-18 | 1881-03-03 | Republican | 8 | |||||||||||||
10289 | 10289 | Cyrus Carpenter C000166 | rep | IA | 1879-03-18 | 1881-03-03 | Republican | 9 | |||||||||||||
10331 | 10331 | Nathaniel Deering D000188 | rep | IA | 1879-03-18 | 1881-03-03 | Republican | 4 | |||||||||||||
10562 | 10562 | William Thompson T000224 | rep | IA | 1879-03-18 | 1881-03-03 | Republican | 5 | |||||||||||||
10813 | 10813 | Moses McCoid M000348 | rep | IA | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
11534 | 11534 | James Weaver W000225 | rep | IA | 1879-03-18 | 1881-03-03 | National Greenbacker | 6 | |||||||||||||
13509 | 13509 | Thomas Updegraff U000019 | rep | IA | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10248 | 10248 | George Ainslie A000066 | rep | ID | 1879-03-18 | 1881-03-03 | Democrat | -1 | |||||||||||||
10004 | 10004 | Hiram Barber B000120 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10017 | 10017 | Thomas Boyd B000721 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 9 | |||||||||||||
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 | |||||||||||||
10099 | 10099 | Philip Hayes H000391 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 7 | |||||||||||||
10205 | 10205 | Adlai Stevenson S000889 | rep | IL | 1879-03-18 | 1881-03-03 | Democrat | 13 | |||||||||||||
10251 | 10251 | William Aldrich A000086 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10375 | 10375 | Robert Hawk H000364 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 5 | |||||||||||||
10533 | 10533 | John Sherwin S000353 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 4 | |||||||||||||
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 | |||||||||||||
10688 | 10688 | George Davis D000100 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
11138 | 11138 | William Morrison M001000 | rep | IL | 1879-03-18 | 1881-03-03 | Democrat | 17 | |||||||||||||
11523 | 11523 | John Thomas T000176 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 18 | |||||||||||||
11988 | 11988 | Richard Townshend T000339 | rep | IL | 1879-03-18 | 1881-03-03 | Democrat | 19 | |||||||||||||
12625 | 12625 | Thomas Henderson H000489 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 6 | |||||||||||||
12798 | 12798 | William Springer S000757 | rep | IL | 1879-03-18 | 1881-03-03 | Democrat | 12 | |||||||||||||
14801 | 14801 | Benjamin Marsh M000145 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 10 | |||||||||||||
18096 | 18096 | Joseph Cannon C000121 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 14 | |||||||||||||
9582 | 9582 | Joseph McDonald M000412 | sen | IN | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
9999 | 9999 | John Baker B000068 | rep | IN | 1879-03-18 | 1881-03-03 | Republican | 13 | |||||||||||||
10012 | 10012 | George Bicknell B000438 | rep | IN | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10055 | 10055 | Calvin Cowgill C000824 | rep | IN | 1879-03-18 | 1881-03-03 | Republican | 11 | |||||||||||||
10062 | 10062 | Gilbert De La Matyr D000204 | rep | IN | 1879-03-18 | 1881-03-03 | National Greenbacker | 7 | |||||||||||||
10106 | 10106 | Abraham Hostetler H000805 | rep | IN | 1879-03-18 | 1881-03-03 | Democrat | 8 | |||||||||||||
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 | |||||||||||||
10297 | 10297 | Walpole Colerick C000623 | rep | IN | 1879-03-18 | 1881-03-03 | Democrat | 12 | |||||||||||||
10381 | 10381 | William Heilman H000451 | rep | IN | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10490 | 10490 | Godlove Orth O000106 | rep | IN | 1879-03-18 | 1881-03-03 | Republican | 9 | |||||||||||||
10663 | 10663 | William Calkins C000048 | rep | IN | 1879-03-18 | 1881-03-03 | Republican | 10 | |||||||||||||
11004 | 11004 | Thomas Cobb C000552 | rep | IN | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
11623 | 11623 | Thomas Browne B000958 | rep | IN | 1879-03-18 | 1881-03-03 | Republican | 5 | |||||||||||||
10741 | 10741 | Dudley Haskell H000316 | rep | KS | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
11565 | 11565 | John Anderson A000194 | rep | KS | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
11947 | 11947 | Thomas Ryan R000559 | rep | KS | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10209 | 10209 | Thomas Turner T000428 | rep | KY | 1879-03-18 | 1881-03-03 | Democrat | 9 | |||||||||||||
10277 | 10277 | John Caldwell C000036 | rep | KY | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10422 | 10422 | James Knott K000290 | rep | KY | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
10455 | 10455 | James McKenzie M000505 | rep | KY | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10505 | 10505 | Elijah Phister P000318 | rep | KY | 1879-03-18 | 1881-03-03 | Democrat | 10 | |||||||||||||
10908 | 10908 | Philip Thompson T000212 | rep | KY | 1879-03-18 | 1881-03-03 | Democrat | 8 | |||||||||||||
10912 | 10912 | Oscar Turner T000425 | rep | KY | 1879-03-18 | 1881-03-03 | Ind. Democrat | 1 | |||||||||||||
11269 | 11269 | Albert Willis W000557 | rep | KY | 1879-03-18 | 1881-03-03 | Democrat | 5 | |||||||||||||
12057 | 12057 | John Carlisle C000152 | rep | KY | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
13865 | 13865 | Joseph Blackburn B000508 | rep | KY | 1879-03-18 | 1881-03-03 | Democrat | 7 |
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);