legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
345 rows where "end" is on date 1875-03-03 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18839 | 18839 | Isaac Sherwood S000355 | rep | OH | 1873-12-01 | 1875-03-03 | Republican | 6 | |||||||||||||
18093 | 18093 | Joseph Cannon C000121 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 14 | |||||||||||||
15103 | 15103 | William Frye F000398 | rep | ME | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
15093 | 15093 | Stephen Elkins E000110 | rep | NM | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
14687 | 14687 | Eugene Hale H000029 | rep | ME | 1873-12-01 | 1875-03-03 | Republican | 5 | |||||||||||||
14603 | 14603 | Julius Burrows B001142 | rep | MI | 1873-12-01 | 1875-03-03 | Republican | 4 | |||||||||||||
14438 | 14438 | Thomas Platt P000383 | rep | NY | 1873-12-01 | 1875-03-03 | Republican | 27 | |||||||||||||
14003 | 14003 | George Hoar H000654 | rep | MA | 1873-12-01 | 1875-03-03 | Republican | 9 | |||||||||||||
13916 | 13916 | Thomas Creamer C000899 | rep | NY | 1873-12-01 | 1875-03-03 | Democrat | 7 | |||||||||||||
13802 | 13802 | William Stewart S000922 | sen | NV | 1869-03-04 | 1875-03-03 | 1 | Republican | |||||||||||||
13700 | 13700 | Joseph Hawley H000377 | rep | CT | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
13686 | 13686 | Alfred Harmer H000215 | rep | PA | 1873-12-01 | 1875-03-03 | Republican | 5 | |||||||||||||
13628 | 13628 | Lorenzo Danford D000028 | rep | OH | 1873-12-01 | 1875-03-03 | Republican | 16 | |||||||||||||
13576 | 13576 | Richard Bland B000544 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 5 | |||||||||||||
13340 | 13340 | William Holman H000732 | rep | IN | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
13079 | 13079 | Richard McCormick M000371 | rep | AZ | 1873-12-01 | 1875-03-03 | Unionist | 0 | |||||||||||||
12718 | 12718 | Charles O’Neill O000093 | rep | PA | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
12450 | 12450 | Hezekiah Bundy B001059 | rep | OH | 1873-12-01 | 1875-03-03 | Republican | 11 | |||||||||||||
12377 | 12377 | Roger Mills M000777 | rep | TX | 1873-12-01 | 1875-03-03 | Democrat | -1 | |||||||||||||
12372 | 12372 | Eppa Hunton H000999 | rep | VA | 1873-12-01 | 1875-03-03 | Democrat | 8 | |||||||||||||
12087 | 12087 | James Blount B000568 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 6 | |||||||||||||
12033 | 12033 | David Wilber W000452 | rep | NY | 1873-12-01 | 1875-03-03 | Republican | 20 | |||||||||||||
12023 | 12023 | Washington Whitthorne W000429 | rep | TN | 1873-12-01 | 1875-03-03 | Democrat | 6 | |||||||||||||
11917 | 11917 | Samuel Randall R000039 | rep | PA | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
11790 | 11790 | William Kelley K000062 | rep | PA | 1873-12-01 | 1875-03-03 | Republican | 4 | |||||||||||||
11741 | 11741 | Mark Dunnell D000555 | rep | MN | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
11697 | 11697 | Samuel Cox C000839 | rep | NY | 1873-12-01 | 1875-03-03 | Democrat | 6 | |||||||||||||
11602 | 11602 | James Beck B000289 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 7 | |||||||||||||
11502 | 11502 | Philetus Sawyer S000091 | rep | WI | 1873-12-01 | 1875-03-03 | Republican | 6 | |||||||||||||
11472 | 11472 | William Phelps P000302 | rep | NJ | 1873-12-01 | 1875-03-03 | Republican | 5 | |||||||||||||
11364 | 11364 | Charles Farwell F000037 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
11359 | 11359 | George Edmunds E000056 | sen | VT | 1869-03-04 | 1875-03-03 | 1 | Republican | |||||||||||||
11344 | 11344 | Henry Dawes D000148 | rep | MA | 1873-12-01 | 1875-03-03 | Republican | 11 | |||||||||||||
11315 | 11315 | Roderick Butler B001188 | rep | TN | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
11273 | 11273 | Ephraim Wilson W000577 | rep | MD | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
11214 | 11214 | Horace Strait S000988 | rep | MN | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
11211 | 11211 | John Storm S000975 | rep | PA | 1873-12-01 | 1875-03-03 | Democrat | 11 | |||||||||||||
11183 | 11183 | Walter Sessions S000251 | rep | NY | 1873-12-01 | 1875-03-03 | Republican | 32 | |||||||||||||
11148 | 11148 | James Negley N000024 | rep | PA | 1873-12-01 | 1875-03-03 | Republican | 22 | |||||||||||||
11135 | 11135 | William Morrison M001000 | rep | IL | 1873-12-01 | 1875-03-03 | Democrat | 17 | |||||||||||||
11070 | 11070 | Henry Harris H000239 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
11056 | 11056 | John Hailey H000023 | rep | ID | 1873-12-01 | 1875-03-03 | Democrat | -1 | |||||||||||||
11020 | 11020 | John Eden E000042 | rep | IL | 1873-12-01 | 1875-03-03 | Democrat | 15 | |||||||||||||
10936 | 10936 | James Wilson W000590 | rep | IA | 1873-12-01 | 1875-03-03 | Republican | 5 | |||||||||||||
10919 | 10919 | Robert Vance V000019 | rep | NC | 1873-12-01 | 1875-03-03 | Democrat | 8 | |||||||||||||
10895 | 10895 | Abraham Smith S000509 | rep | PA | 1873-12-01 | 1875-03-03 | Republican | 9 | |||||||||||||
10843 | 10843 | Luke Poland P000406 | rep | VT | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
10837 | 10837 | Austin Pike P000345 | rep | NH | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
10801 | 10801 | Martin Maginnis M000050 | rep | MT | 1873-12-01 | 1875-03-03 | Democrat | -1 | |||||||||||||
10786 | 10786 | Lucius Lamar L000030 | rep | MS | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
10775 | 10775 | John Kasson K000018 | rep | IA | 1873-12-01 | 1875-03-03 | Republican | 7 | |||||||||||||
10732 | 10732 | John Hancock H000150 | rep | TX | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
10655 | 10655 | Aylett Buckner B001031 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 13 | |||||||||||||
10611 | 10611 | Fernando Wood W000694 | rep | NY | 1873-12-01 | 1875-03-03 | Democrat | 10 | |||||||||||||
10589 | 10589 | Charles Williams W000492 | rep | WI | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
10557 | 10557 | Alexander Stephens S000854 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 8 | |||||||||||||
10495 | 10495 | Horace Page P000017 | rep | CA | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
10489 | 10489 | Godlove Orth O000106 | rep | IN | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
10451 | 10451 | James McDill M000407 | rep | IA | 1873-12-01 | 1875-03-03 | Republican | 8 | |||||||||||||
10438 | 10438 | John Lynch L000533 | rep | MS | 1873-12-01 | 1875-03-03 | Republican | 6 | |||||||||||||
10392 | 10392 | Jay Hubbell H000894 | rep | MI | 1873-12-01 | 1875-03-03 | Republican | 9 | |||||||||||||
10369 | 10369 | Benjamin Harris H000233 | rep | MA | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
10357 | 10357 | Thomas Gunter G000527 | rep | AR | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
10324 | 10324 | Chester Darrall D000062 | rep | LA | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
10306 | 10306 | Philip Cook C000724 | rep | GA | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
10301 | 10301 | Omar Conger C000678 | rep | MI | 1873-12-01 | 1875-03-03 | Republican | 7 | |||||||||||||
10292 | 10292 | John Clark C000442 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 11 | |||||||||||||
10284 | 10284 | George Cannon C000119 | rep | UT | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
10264 | 10264 | Thomas Bayard B000253 | sen | DE | 1869-03-04 | 1875-03-03 | 1 | Democrat | |||||||||||||
10259 | 10259 | John Atkins A000327 | rep | TN | 1873-12-01 | 1875-03-03 | Democrat | 7 | |||||||||||||
10235 | 10235 | James Garfield G000063 | rep | OH | 1873-12-01 | 1875-03-03 | Republican | 19 | |||||||||||||
10215 | 10215 | Erastus Wells W000282 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 2 | |||||||||||||
10148 | 10148 | James Monroe M000857 | rep | OH | 1873-12-01 | 1875-03-03 | Republican | 18 | |||||||||||||
10125 | 10125 | John Killinger K000179 | rep | PA | 1873-12-01 | 1875-03-03 | Republican | 10 | |||||||||||||
10094 | 10094 | John Harris H000247 | rep | VA | 1873-12-01 | 1875-03-03 | Democrat | 7 | |||||||||||||
10083 | 10083 | Greenbury Fort F000288 | rep | IL | 1873-12-01 | 1875-03-03 | Republican | 8 | |||||||||||||
10042 | 10042 | Hiester Clymer C000539 | rep | PA | 1873-12-01 | 1875-03-03 | Democrat | 8 | |||||||||||||
10031 | 10031 | Simeon Chittenden C000373 | rep | NY | 1873-12-01 | 1875-03-03 | Ind. Republican | 3 | |||||||||||||
10029 | 10029 | Zachariah Chandler C000299 | sen | MI | 1869-03-04 | 1875-03-03 | 1 | Republican | |||||||||||||
10025 | 10025 | Matthew Carpenter C000171 | sen | WI | 1869-03-04 | 1875-03-03 | 1 | Republican | |||||||||||||
10020 | 10020 | John Bright B000836 | rep | TN | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
9966 | 9966 | Alfred Waddell W000002 | rep | NC | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
9954 | 9954 | Jacob Thornburgh T000239 | rep | TN | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9952 | 9952 | John Thompson T000209 | rep | PA | 1873-12-01 | 1875-03-03 | Republican | 23 | |||||||||||||
9949 | 9949 | Thomas Swann S001092 | rep | MD | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
9938 | 9938 | Milton Southard S000688 | rep | OH | 1873-12-01 | 1875-03-03 | Democrat | 13 | |||||||||||||
9932 | 9932 | Milton Sayler S000101 | rep | OH | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
9917 | 9917 | William Robbins R000302 | rep | NC | 1873-12-01 | 1875-03-03 | Democrat | 7 | |||||||||||||
9907 | 9907 | Joseph Rainey R000016 | rep | SC | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9900 | 9900 | Clarkson Potter P000461 | rep | NY | 1873-12-01 | 1875-03-03 | Democrat | 11 | |||||||||||||
9894 | 9894 | William Phillips P000315 | rep | KS | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9878 | 9878 | John Luttrell L000522 | rep | CA | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
9871 | 9871 | Robert Knapp K000281 | rep | IL | 1873-12-01 | 1875-03-03 | Democrat | 11 | |||||||||||||
9854 | 9854 | Morton Hunter H000985 | rep | IN | 1873-12-01 | 1875-03-03 | Republican | 6 | |||||||||||||
9847 | 9847 | Frank Hereford H000527 | rep | WV | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
9843 | 9843 | George Hendee H000474 | rep | VT | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
9840 | 9840 | Robert Hatcher H000341 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
9825 | 9825 | John Glover G000245 | rep | MO | 1873-12-01 | 1875-03-03 | Democrat | 12 | |||||||||||||
9823 | 9823 | De Giddings G000166 | rep | TX | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
9809 | 9809 | Charles Foster F000299 | rep | OH | 1873-12-01 | 1875-03-03 | Republican | 10 |
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);