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 rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18096 | 18096 | Joseph Cannon C000121 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 14 | |||||||||||||
17477 | 17477 | Joshua Talbott T000021 | rep | MD | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
15854 | 15854 | Henry Bingham B000469 | rep | PA | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
15567 | 15567 | Joseph Keifer K000048 | rep | OH | 1879-03-18 | 1881-03-03 | Republican | 4 | |||||||||||||
15300 | 15300 | Robert Taylor T000098 | rep | TN | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
15106 | 15106 | William Frye F000398 | rep | ME | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
14960 | 14960 | William Whyte W000435 | sen | MD | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
14833 | 14833 | Hernando Money M000854 | rep | MS | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
14801 | 14801 | Benjamin Marsh M000145 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 10 | |||||||||||||
14745 | 14745 | John Ketcham K000152 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 13 | |||||||||||||
14604 | 14604 | Julius Burrows B001142 | rep | MI | 1879-03-18 | 1881-03-03 | Republican | 4 | |||||||||||||
14555 | 14555 | Nelson Aldrich A000083 | rep | RI | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
14102 | 14102 | Nicholas Muller M001071 | rep | NY | 1879-03-18 | 1881-03-03 | Democrat | 5 | |||||||||||||
14012 | 14012 | Charles Hooker H000758 | rep | MS | 1879-03-18 | 1881-03-03 | Democrat | 5 | |||||||||||||
13865 | 13865 | Joseph Blackburn B000508 | rep | KY | 1879-03-18 | 1881-03-03 | Democrat | 7 | |||||||||||||
13772 | 13772 | Thomas Reed R000128 | rep | ME | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
13701 | 13701 | Joseph Hawley H000377 | rep | CT | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
13688 | 13688 | Alfred Harmer H000215 | rep | PA | 1879-03-18 | 1881-03-03 | Republican | 5 | |||||||||||||
13616 | 13616 | Francis Cockrell C000576 | sen | MO | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
13579 | 13579 | Richard Bland B000544 | rep | MO | 1879-03-18 | 1881-03-03 | Democrat | 5 | |||||||||||||
13509 | 13509 | Thomas Updegraff U000019 | rep | IA | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
13402 | 13402 | Benton McMillin M000575 | rep | TN | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
13230 | 13230 | William McKinley M000522 | rep | OH | 1879-03-18 | 1881-03-03 | Republican | 16 | |||||||||||||
12982 | 12982 | David Culberson C000964 | rep | TX | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
12839 | 12839 | John Van Voorhis V000063 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 30 | |||||||||||||
12798 | 12798 | William Springer S000757 | rep | IL | 1879-03-18 | 1881-03-03 | Democrat | 12 | |||||||||||||
12721 | 12721 | Charles O’Neill O000093 | rep | PA | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
12625 | 12625 | Thomas Henderson H000489 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 6 | |||||||||||||
12597 | 12597 | William Hatch H000339 | rep | MO | 1879-03-18 | 1881-03-03 | Democrat | 12 | |||||||||||||
12506 | 12506 | James Covert C000814 | rep | NY | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
12408 | 12408 | Frank Beltzhoover B000355 | rep | PA | 1879-03-18 | 1881-03-03 | Democrat | 19 | |||||||||||||
12380 | 12380 | Roger Mills M000777 | rep | TX | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
12375 | 12375 | Eppa Hunton H000999 | rep | VA | 1879-03-18 | 1881-03-03 | Democrat | 8 | |||||||||||||
12329 | 12329 | George Tillman T000275 | rep | SC | 1879-03-18 | 1881-03-03 | Democrat | 5 | |||||||||||||
12316 | 12316 | Ezra Taylor T000073 | rep | OH | 1879-03-18 | 1881-03-03 | Republican | 19 | |||||||||||||
12209 | 12209 | Leonidas Houk H000818 | rep | TN | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
12201 | 12201 | Hilary Herbert H000524 | rep | AL | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
12183 | 12183 | John Gordon G000313 | sen | GA | 1879-03-18 | 1881-03-03 | 3 | Democrat | |||||||||||||
12166 | 12166 | William Forney F000280 | rep | AL | 1879-03-18 | 1881-03-03 | Democrat | 7 | |||||||||||||
12090 | 12090 | James Blount B000568 | rep | GA | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
12057 | 12057 | John Carlisle C000152 | rep | KY | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
12034 | 12034 | David Wilber W000452 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 21 | |||||||||||||
12026 | 12026 | Washington Whitthorne W000429 | rep | TN | 1879-03-18 | 1881-03-03 | Democrat | 7 | |||||||||||||
12013 | 12013 | William Washburn W000175 | rep | MN | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
11988 | 11988 | Richard Townshend T000339 | rep | IL | 1879-03-18 | 1881-03-03 | Democrat | 19 | |||||||||||||
11947 | 11947 | Thomas Ryan R000559 | rep | KS | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
11920 | 11920 | Samuel Randall R000039 | rep | PA | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
11853 | 11853 | Frederick Miles M000704 | rep | CT | 1879-03-18 | 1881-03-03 | Republican | 4 | |||||||||||||
11800 | 11800 | John Kenna K000099 | rep | WV | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
11793 | 11793 | William Kelley K000062 | rep | PA | 1879-03-18 | 1881-03-03 | Republican | 4 | |||||||||||||
11766 | 11766 | Randall Gibson G000165 | rep | LA | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
11744 | 11744 | Mark Dunnell D000555 | rep | MN | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
11719 | 11719 | Robert Davidson D000085 | rep | FL | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
11700 | 11700 | Samuel Cox C000839 | rep | NY | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
11659 | 11659 | Lucien Caswell C000245 | rep | WI | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
11639 | 11639 | Benjamin Butterworth B001200 | rep | OH | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
11623 | 11623 | Thomas Browne B000958 | rep | IN | 1879-03-18 | 1881-03-03 | Republican | 5 | |||||||||||||
11615 | 11615 | Mark Brewer B000811 | rep | MI | 1879-03-18 | 1881-03-03 | Republican | 6 | |||||||||||||
11593 | 11593 | Thomas Bayne B000261 | rep | PA | 1879-03-18 | 1881-03-03 | Republican | 23 | |||||||||||||
11565 | 11565 | John Anderson A000194 | rep | KS | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
11534 | 11534 | James Weaver W000225 | rep | IA | 1879-03-18 | 1881-03-03 | National Greenbacker | 6 | |||||||||||||
11523 | 11523 | John Thomas T000176 | rep | IL | 1879-03-18 | 1881-03-03 | Republican | 18 | |||||||||||||
11492 | 11492 | Edward Robertson R000321 | rep | LA | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
11485 | 11485 | John Reagan R000098 | rep | TX | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
11464 | 11464 | Algernon Paddock P000010 | sen | NE | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
11453 | 11453 | Leopold Morse M001012 | rep | MA | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
11397 | 11397 | Frank Hiscock H000643 | rep | NY | 1879-03-18 | 1881-03-03 | Republican | 25 | |||||||||||||
11360 | 11360 | George Edmunds E000056 | sen | VT | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
11353 | 11353 | Poindexter Dunn D000552 | rep | AR | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
11345 | 11345 | Henry Dawes D000148 | sen | MA | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
11320 | 11320 | Martin Clardy C000417 | rep | MO | 1879-03-18 | 1881-03-03 | Democrat | 1 | |||||||||||||
11295 | 11295 | Archibald Bliss B000558 | rep | NY | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
11269 | 11269 | Albert Willis W000557 | rep | KY | 1879-03-18 | 1881-03-03 | Democrat | 5 | |||||||||||||
11261 | 11261 | Olin Wellborn W000272 | rep | TX | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
11256 | 11256 | Adoniram Warner W000151 | rep | OH | 1879-03-18 | 1881-03-03 | Democrat | 13 | |||||||||||||
11246 | 11246 | John Wait W000025 | rep | CT | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
11234 | 11234 | John Tucker T000401 | rep | VA | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
11192 | 11192 | Otho Singleton S000445 | rep | MS | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
11173 | 11173 | William Rice R000205 | rep | MA | 1879-03-18 | 1881-03-03 | Republican | 9 | |||||||||||||
11138 | 11138 | William Morrison M001000 | rep | IL | 1879-03-18 | 1881-03-03 | Democrat | 17 | |||||||||||||
11102 | 11102 | Benjamin Le Fevre L000159 | rep | OH | 1879-03-18 | 1881-03-03 | Democrat | 5 | |||||||||||||
11096 | 11096 | John King K000206 | rep | LA | 1879-03-18 | 1881-03-03 | Democrat | 5 | |||||||||||||
11083 | 11083 | William Hill H000609 | rep | OH | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
11062 | 11062 | Nathaniel Hammond H000130 | rep | GA | 1879-03-18 | 1881-03-03 | Democrat | 5 | |||||||||||||
11044 | 11044 | George Geddes G000115 | rep | OH | 1879-03-18 | 1881-03-03 | Democrat | 15 | |||||||||||||
11004 | 11004 | Thomas Cobb C000552 | rep | IN | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10988 | 10988 | George Cabell C000004 | rep | VA | 1879-03-18 | 1881-03-03 | Democrat | 5 | |||||||||||||
10975 | 10975 | Edward Bragg B000757 | rep | WI | 1879-03-18 | 1881-03-03 | Democrat | 5 | |||||||||||||
10954 | 10954 | David Aiken A000061 | rep | SC | 1879-03-18 | 1881-03-03 | Democrat | 3 | |||||||||||||
10947 | 10947 | Hiram Young Y000037 | rep | TN | 1879-03-18 | 1881-03-03 | Democrat | 10 | |||||||||||||
10933 | 10933 | Thomas Williams W000537 | rep | AL | 1879-03-18 | 1881-03-03 | Democrat | 5 | |||||||||||||
10922 | 10922 | Robert Vance V000019 | rep | NC | 1879-03-18 | 1881-03-03 | Democrat | 8 | |||||||||||||
10915 | 10915 | Edward Valentine V000005 | rep | NE | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10912 | 10912 | Oscar Turner T000425 | rep | KY | 1879-03-18 | 1881-03-03 | Ind. Democrat | 1 | |||||||||||||
10908 | 10908 | Philip Thompson T000212 | rep | KY | 1879-03-18 | 1881-03-03 | Democrat | 8 | |||||||||||||
10898 | 10898 | Abraham Smith S000509 | rep | PA | 1879-03-18 | 1881-03-03 | Republican | 9 | |||||||||||||
10886 | 10886 | Charles Shelley S000326 | rep | AL | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
10880 | 10880 | Alfred Scales S000103 | rep | NC | 1879-03-18 | 1881-03-03 | Democrat | 5 | |||||||||||||
10870 | 10870 | William Russell R000541 | rep | MA | 1879-03-18 | 1881-03-03 | Republican | 7 | |||||||||||||
10859 | 10859 | George Robinson R000335 | rep | MA | 1879-03-18 | 1881-03-03 | Republican | 11 |
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);