legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
337 rows where "end" is on date 1879-03-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: state, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18095 | 18095 | Joseph Cannon C000121 | rep | IL | 1877-10-15 | 1879-03-03 | Republican | 14 | |||||||||||||
15656 | 15656 | Charles Morgan M000944 | rep | MO | 1877-10-15 | 1879-03-03 | Democrat | 6 | |||||||||||||
15566 | 15566 | Joseph Keifer K000048 | rep | OH | 1877-10-15 | 1879-03-03 | Republican | 8 | |||||||||||||
15252 | 15252 | Llewellyn Powers P000491 | rep | ME | 1877-10-15 | 1879-03-03 | Republican | 4 | |||||||||||||
15105 | 15105 | William Frye F000398 | rep | ME | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
14832 | 14832 | Hernando Money M000854 | rep | MS | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
14800 | 14800 | Benjamin Marsh M000145 | rep | IL | 1877-10-15 | 1879-03-03 | Republican | 10 | |||||||||||||
14744 | 14744 | John Ketcham K000152 | rep | NY | 1877-10-15 | 1879-03-03 | Republican | 13 | |||||||||||||
14689 | 14689 | Eugene Hale H000029 | rep | ME | 1877-10-15 | 1879-03-03 | Republican | 5 | |||||||||||||
14231 | 14231 | William Allison A000160 | sen | IA | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
14121 | 14121 | Thomas Patterson P000130 | rep | CO | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
14101 | 14101 | Nicholas Muller M001071 | rep | NY | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
14081 | 14081 | John Mitchell M000818 | sen | OR | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
14011 | 14011 | Charles Hooker H000758 | rep | MS | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
13864 | 13864 | Joseph Blackburn B000508 | rep | KY | 1877-10-15 | 1879-03-03 | Democrat | 7 | |||||||||||||
13771 | 13771 | Thomas Reed R000128 | rep | ME | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
13687 | 13687 | Alfred Harmer H000215 | rep | PA | 1877-10-15 | 1879-03-03 | Republican | 5 | |||||||||||||
13630 | 13630 | Lorenzo Danford D000028 | rep | OH | 1877-10-15 | 1879-03-03 | Republican | 16 | |||||||||||||
13578 | 13578 | Richard Bland B000544 | rep | MO | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
13432 | 13432 | Justin Morrill M000969 | sen | VT | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
13367 | 13367 | John Jones J000237 | sen | NV | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
13229 | 13229 | William McKinley M000522 | rep | OH | 1877-10-15 | 1879-03-03 | Republican | 17 | |||||||||||||
12981 | 12981 | David Culberson C000964 | rep | TX | 1877-10-15 | 1879-03-03 | Democrat | 2 | |||||||||||||
12797 | 12797 | William Springer S000757 | rep | IL | 1877-10-15 | 1879-03-03 | Democrat | 12 | |||||||||||||
12763 | 12763 | James Reilly R000153 | rep | PA | 1877-10-15 | 1879-03-03 | Democrat | 13 | |||||||||||||
12720 | 12720 | Charles O’Neill O000093 | rep | PA | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
12667 | 12667 | Daniel Lockwood L000392 | rep | NY | 1877-10-15 | 1879-03-03 | Democrat | 32 | |||||||||||||
12624 | 12624 | Thomas Henderson H000489 | rep | IL | 1877-10-15 | 1879-03-03 | Republican | 6 | |||||||||||||
12505 | 12505 | James Covert C000814 | rep | NY | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
12414 | 12414 | Henry Blair B000524 | rep | NH | 1877-10-15 | 1879-03-03 | Republican | 3 | |||||||||||||
12379 | 12379 | Roger Mills M000777 | rep | TX | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
12374 | 12374 | Eppa Hunton H000999 | rep | VA | 1877-10-15 | 1879-03-03 | Democrat | 8 | |||||||||||||
12350 | 12350 | Daniel Voorhees V000116 | sen | IN | 1877-10-15 | 1879-03-03 | 3 | Democrat | |||||||||||||
12200 | 12200 | Hilary Herbert H000524 | rep | AL | 1877-10-15 | 1879-03-03 | Democrat | 2 | |||||||||||||
12182 | 12182 | John Gordon G000313 | sen | GA | 1873-12-01 | 1879-03-03 | 3 | Democrat | |||||||||||||
12165 | 12165 | William Forney F000280 | rep | AL | 1877-10-15 | 1879-03-03 | Democrat | 7 | |||||||||||||
12126 | 12126 | James Cameron C000065 | sen | PA | 1877-10-15 | 1879-03-03 | 3 | Republican | |||||||||||||
12089 | 12089 | James Blount B000568 | rep | GA | 1877-10-15 | 1879-03-03 | Democrat | 6 | |||||||||||||
12056 | 12056 | John Carlisle C000152 | rep | KY | 1877-10-15 | 1879-03-03 | Democrat | 6 | |||||||||||||
12025 | 12025 | Washington Whitthorne W000429 | rep | TN | 1877-10-15 | 1879-03-03 | Democrat | 7 | |||||||||||||
12017 | 12017 | Lewis Watson W000204 | rep | PA | 1877-10-15 | 1879-03-03 | Republican | 27 | |||||||||||||
11987 | 11987 | Richard Townshend T000339 | rep | IL | 1877-10-15 | 1879-03-03 | Democrat | 19 | |||||||||||||
11946 | 11946 | Thomas Ryan R000559 | rep | KS | 1877-10-15 | 1879-03-03 | Republican | 3 | |||||||||||||
11919 | 11919 | Samuel Randall R000039 | rep | PA | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
11827 | 11827 | Levi Maish M000072 | rep | PA | 1877-10-15 | 1879-03-03 | Democrat | 19 | |||||||||||||
11799 | 11799 | John Kenna K000099 | rep | WV | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
11792 | 11792 | William Kelley K000062 | rep | PA | 1877-10-15 | 1879-03-03 | Republican | 4 | |||||||||||||
11765 | 11765 | Randall Gibson G000165 | rep | LA | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
11743 | 11743 | Mark Dunnell D000555 | rep | MN | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
11718 | 11718 | Robert Davidson D000085 | rep | FL | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
11699 | 11699 | Samuel Cox C000839 | rep | NY | 1877-10-15 | 1879-03-03 | Democrat | 6 | |||||||||||||
11658 | 11658 | Lucien Caswell C000245 | rep | WI | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
11622 | 11622 | Thomas Browne B000958 | rep | IN | 1877-10-15 | 1879-03-03 | Republican | 5 | |||||||||||||
11614 | 11614 | Mark Brewer B000811 | rep | MI | 1877-10-15 | 1879-03-03 | Republican | 6 | |||||||||||||
11592 | 11592 | Thomas Bayne B000261 | rep | PA | 1877-10-15 | 1879-03-03 | Republican | 23 | |||||||||||||
11583 | 11583 | Nathaniel Banks B000116 | rep | MA | 1877-10-15 | 1879-03-03 | Republican | 5 | |||||||||||||
11491 | 11491 | Edward Robertson R000321 | rep | LA | 1877-10-15 | 1879-03-03 | Democrat | 6 | |||||||||||||
11484 | 11484 | John Reagan R000098 | rep | TX | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
11452 | 11452 | Leopold Morse M001012 | rep | MA | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
11421 | 11421 | James Jones J000233 | rep | AL | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
11396 | 11396 | Frank Hiscock H000643 | rep | NY | 1877-10-15 | 1879-03-03 | Republican | 25 | |||||||||||||
11294 | 11294 | Archibald Bliss B000558 | rep | NY | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
11268 | 11268 | Albert Willis W000557 | rep | KY | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
11245 | 11245 | John Wait W000025 | rep | CT | 1877-10-15 | 1879-03-03 | Republican | 3 | |||||||||||||
11233 | 11233 | John Tucker T000401 | rep | VA | 1877-10-15 | 1879-03-03 | Democrat | 6 | |||||||||||||
11228 | 11228 | James Throckmorton T000246 | rep | TX | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
11216 | 11216 | Horace Strait S000988 | rep | MN | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
11197 | 11197 | Robert Smalls S000502 | rep | SC | 1877-10-15 | 1879-03-03 | Republican | 5 | |||||||||||||
11191 | 11191 | Otho Singleton S000445 | rep | MS | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
11172 | 11172 | William Rice R000205 | rep | MA | 1877-10-15 | 1879-03-03 | Republican | 9 | |||||||||||||
11137 | 11137 | William Morrison M001000 | rep | IL | 1877-10-15 | 1879-03-03 | Democrat | 17 | |||||||||||||
11086 | 11086 | John Ingalls I000012 | sen | KS | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
11079 | 11079 | Abram Hewitt H000552 | rep | NY | 1877-10-15 | 1879-03-03 | Democrat | 10 | |||||||||||||
11072 | 11072 | Henry Harris H000239 | rep | GA | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
11032 | 11032 | Isaac Evans E000244 | rep | PA | 1877-10-15 | 1879-03-03 | Republican | 7 | |||||||||||||
11030 | 11030 | James Eustis E000229 | sen | LA | 1876-01-01 | 1879-03-03 | 3 | Democrat | |||||||||||||
11022 | 11022 | John Eden E000042 | rep | IL | 1877-10-15 | 1879-03-03 | Democrat | 15 | |||||||||||||
11003 | 11003 | Thomas Cobb C000552 | rep | IN | 1877-10-15 | 1879-03-03 | Democrat | 2 | |||||||||||||
10994 | 10994 | Jacob Campbell C000086 | rep | PA | 1877-10-15 | 1879-03-03 | Republican | 17 | |||||||||||||
10987 | 10987 | George Cabell C000004 | rep | VA | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
10974 | 10974 | Edward Bragg B000757 | rep | WI | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
10953 | 10953 | David Aiken A000061 | rep | SC | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
10946 | 10946 | Hiram Young Y000037 | rep | TN | 1877-10-15 | 1879-03-03 | Democrat | 10 | |||||||||||||
10921 | 10921 | Robert Vance V000019 | rep | NC | 1877-10-15 | 1879-03-03 | Democrat | 8 | |||||||||||||
10897 | 10897 | Abraham Smith S000509 | rep | PA | 1877-10-15 | 1879-03-03 | Republican | 9 | |||||||||||||
10885 | 10885 | Charles Shelley S000326 | rep | AL | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
10879 | 10879 | Alfred Scales S000103 | rep | NC | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
10858 | 10858 | George Robinson R000335 | rep | MA | 1877-10-15 | 1879-03-03 | Republican | 11 | |||||||||||||
10820 | 10820 | Henry Muldrow M001068 | rep | MS | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
10807 | 10807 | Vannoy Manning M000111 | rep | MS | 1877-10-15 | 1879-03-03 | Democrat | 2 | |||||||||||||
10803 | 10803 | Martin Maginnis M000050 | rep | MT | 1877-10-15 | 1879-03-03 | Democrat | -1 | |||||||||||||
10749 | 10749 | Goldsmith Hewitt H000553 | rep | AL | 1877-10-15 | 1879-03-03 | Democrat | 6 | |||||||||||||
10740 | 10740 | Dudley Haskell H000316 | rep | KS | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
10715 | 10715 | John Evins E000272 | rep | SC | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
10710 | 10710 | Ezekiel Ellis E000134 | rep | LA | 1877-10-15 | 1879-03-03 | Democrat | 2 | |||||||||||||
10698 | 10698 | George Dibrell D000301 | rep | TN | 1877-10-15 | 1879-03-03 | Democrat | 3 | |||||||||||||
10668 | 10668 | James Chalmers C000272 | rep | MS | 1877-10-15 | 1879-03-03 | Democrat | 6 | |||||||||||||
10662 | 10662 | William Calkins C000048 | rep | IN | 1877-10-15 | 1879-03-03 | Republican | 10 | |||||||||||||
10657 | 10657 | Aylett Buckner B001031 | rep | MO | 1877-10-15 | 1879-03-03 | Democrat | 13 | |||||||||||||
10638 | 10638 | Horatio Bisbee B000485 | rep | FL | 1877-10-15 | 1879-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);