legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
236 rows where "end" is on date 1867-03-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, state, district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15056 | 15056 | Shelby Cullom C000973 | rep | IL | 1865-12-04 | 1867-03-03 | Republican | 8 | |||||||||||||
14740 | 14740 | John Ketcham K000152 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 12 | |||||||||||||
14228 | 14228 | William Allison A000160 | rep | IA | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
13430 | 13430 | Justin Morrill M000969 | rep | VT | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
13336 | 13336 | William Holman H000732 | rep | IN | 1865-12-04 | 1867-03-03 | Democrat | -1 | |||||||||||||
13238 | 13238 | Jehu Baker B000066 | rep | IL | 1865-12-04 | 1867-03-03 | Republican | 12 | |||||||||||||
13195 | 13195 | Robert Van Horn V000042 | rep | MO | 1865-12-04 | 1867-03-03 | Republican | 6 | |||||||||||||
12779 | 12779 | John Sherman S000346 | sen | OH | 1861-07-04 | 1867-03-03 | 3 | Republican | |||||||||||||
12715 | 12715 | Charles O’Neill O000093 | rep | PA | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
12449 | 12449 | Hezekiah Bundy B001059 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 11 | |||||||||||||
12347 | 12347 | Daniel Voorhees V000116 | rep | IN | 1865-12-04 | 1867-03-03 | Democrat | 7 | |||||||||||||
12044 | 12044 | James Wilson W000594 | rep | IA | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
11913 | 11913 | Samuel Randall R000039 | rep | PA | 1865-12-04 | 1867-03-03 | Democrat | 1 | |||||||||||||
11834 | 11834 | Gilman Marston M000165 | rep | NH | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
11786 | 11786 | William Kelley K000062 | rep | PA | 1865-12-04 | 1867-03-03 | Republican | 4 | |||||||||||||
11578 | 11578 | Nathaniel Banks B000116 | rep | MA | 1865-12-04 | 1867-03-03 | Republican | 6 | |||||||||||||
11498 | 11498 | Philetus Sawyer S000091 | rep | WI | 1865-12-04 | 1867-03-03 | Republican | 5 | |||||||||||||
11340 | 11340 | Henry Dawes D000148 | rep | MA | 1865-12-04 | 1867-03-03 | Republican | 10 | |||||||||||||
11204 | 11204 | Louis St. Martin S000768 | rep | LA | 1865-12-04 | 1867-03-03 | Democrat | -1 | |||||||||||||
10839 | 10839 | Luke Poland P000406 | sen | VT | 1865-12-04 | 1867-03-03 | 3 | Republican | |||||||||||||
10817 | 10817 | Samuel Moulton M001047 | rep | IL | 1865-12-04 | 1867-03-03 | Republican | -1 | |||||||||||||
10791 | 10791 | George Lawrence L000134 | rep | PA | 1865-12-04 | 1867-03-03 | Republican | 24 | |||||||||||||
10774 | 10774 | John Kasson K000018 | rep | IA | 1865-12-04 | 1867-03-03 | Republican | 5 | |||||||||||||
10575 | 10575 | Henry Van Aernam V000010 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 31 | |||||||||||||
10486 | 10486 | Godlove Orth O000106 | rep | IN | 1865-12-04 | 1867-03-03 | Republican | 8 | |||||||||||||
10242 | 10242 | William Windom W000629 | rep | MN | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
10231 | 10231 | James Garfield G000063 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 19 | |||||||||||||
10173 | 10173 | Hiram Price P000525 | rep | IA | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
10051 | 10051 | Roscoe Conkling C000681 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 21 | |||||||||||||
10047 | 10047 | Alexander Coffroth C000593 | rep | PA | 1865-12-04 | 1867-03-03 | Democrat | 16 | |||||||||||||
9926 | 9926 | Edward Rollins R000411 | rep | NH | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
9869 | 9869 | Samuel Kirkwood K000242 | sen | IA | 1866-01-01 | 1867-03-03 | 3 | Republican | |||||||||||||
9802 | 9802 | Thomas Ferry F000095 | rep | MI | 1865-12-04 | 1867-03-03 | Republican | 4 | |||||||||||||
9727 | 9727 | Rutherford Hayes H000393 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
9715 | 9715 | James Blaine B000519 | rep | ME | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
9565 | 9565 | William Lawrence L000140 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 4 | |||||||||||||
9553 | 9553 | Michael Kerr K000143 | rep | IN | 1865-12-04 | 1867-03-03 | Democrat | 2 | |||||||||||||
9435 | 9435 | William Washburn W000174 | rep | MA | 1865-12-04 | 1867-03-03 | Republican | 9 | |||||||||||||
9344 | 9344 | Glenni Scofield S000164 | rep | PA | 1865-12-04 | 1867-03-03 | Republican | 19 | |||||||||||||
9291 | 9291 | William Niblack N000083 | rep | IN | 1865-12-04 | 1867-03-03 | Democrat | 1 | |||||||||||||
9287 | 9287 | James Nesmith N000050 | sen | OR | 1861-07-04 | 1867-03-03 | 3 | Democrat | |||||||||||||
9282 | 9282 | Leonard Myers M001131 | rep | PA | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
9255 | 9255 | Horace Maynard M000284 | rep | TN | 1865-12-04 | 1867-03-03 | Unconditional Unionist | 2 | |||||||||||||
9246 | 9246 | Samuel Marshall M000160 | rep | IL | 1865-12-04 | 1867-03-03 | Democrat | 11 | |||||||||||||
9212 | 9212 | Timothy Howe H000856 | sen | WI | 1861-07-04 | 1867-03-03 | 3 | Republican | |||||||||||||
9204 | 9204 | Samuel Hooper H000765 | rep | MA | 1865-12-04 | 1867-03-03 | Republican | 4 | |||||||||||||
9186 | 9186 | Robert Hale H000037 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 16 | |||||||||||||
9181 | 9181 | Daniel Gooch G000274 | rep | MA | 1865-12-04 | 1867-03-03 | Republican | 6 | |||||||||||||
9172 | 9172 | William Finck F000118 | rep | OH | 1865-12-04 | 1867-03-03 | Democrat | 12 | |||||||||||||
9160 | 9160 | Charles Eldredge E000103 | rep | WI | 1865-12-04 | 1867-03-03 | Democrat | 4 | |||||||||||||
9103 | 9103 | James Brooks B000881 | rep | NY | 1865-12-04 | 1867-03-03 | Democrat | 8 | |||||||||||||
9094 | 9094 | George Boutwell B000674 | rep | MA | 1865-12-04 | 1867-03-03 | Republican | 7 | |||||||||||||
9010 | 9010 | Samuel Shellabarger S000325 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 7 | |||||||||||||
8963 | 8963 | Ulysses Mercur M000646 | rep | PA | 1865-12-04 | 1867-03-03 | Republican | 13 | |||||||||||||
8945 | 8945 | John Lynch L000531 | rep | ME | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8935 | 8935 | William Hooper H000767 | rep | UT | 1865-12-04 | 1867-03-03 | Democrat | -1 | |||||||||||||
8932 | 8932 | Phineas Hitchcock H000648 | rep | NE | 1865-12-04 | 1867-03-03 | Republican | -1 | |||||||||||||
8890 | 8890 | John Farnsworth F000024 | rep | IL | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8862 | 8862 | Burton Cook C000715 | rep | IL | 1865-12-04 | 1867-03-03 | Republican | 6 | |||||||||||||
8819 | 8819 | John Bingham B000471 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 16 | |||||||||||||
8803 | 8803 | Oakes Ames A000175 | rep | MA | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8776 | 8776 | Martin Welker W000270 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 14 | |||||||||||||
8773 | 8773 | Elihu Washburne W000176 | rep | IL | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8759 | 8759 | Hamilton Ward W000133 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 27 | |||||||||||||
8754 | 8754 | Lawrence Trimble T000375 | rep | KY | 1865-12-04 | 1867-03-03 | Democrat | 1 | |||||||||||||
8734 | 8734 | William Stokes S000950 | rep | TN | 1865-12-04 | 1867-03-03 | Unconditional Unionist | 3 | |||||||||||||
8731 | 8731 | John Stockton S000939 | sen | NJ | 1865-12-04 | 1867-03-03 | 2 | Democrat | |||||||||||||
8712 | 8712 | Robert Schenck S000118 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8685 | 8685 | Halbert Paine P000028 | rep | WI | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8659 | 8659 | Addison Laflin L000017 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 20 | |||||||||||||
8651 | 8651 | George Julian J000280 | rep | IN | 1865-12-04 | 1867-03-03 | Republican | 5 | |||||||||||||
8643 | 8643 | Alexander Jones J000208 | rep | NC | 1865-12-04 | 1867-03-03 | Republican | -1 | |||||||||||||
8638 | 8638 | Thomas Jenckes J000076 | rep | RI | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8634 | 8634 | Ebon Ingersoll I000017 | rep | IL | 1865-12-04 | 1867-03-03 | Republican | 5 | |||||||||||||
8631 | 8631 | Giles Hotchkiss H000808 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 26 | |||||||||||||
8620 | 8620 | Isaac Hawkins H000370 | rep | TN | 1865-12-04 | 1867-03-03 | Unionist | 7 | |||||||||||||
8577 | 8577 | Nathan Dixon D000375 | rep | RI | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8558 | 8558 | Amasa Cobb C000543 | rep | WI | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8551 | 8551 | Sidney Clarke C000470 | rep | KS | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8546 | 8546 | José Chaves C000337 | rep | NM | 1865-12-04 | 1867-03-03 | Republican | -1 | |||||||||||||
8532 | 8532 | Allen Bradford B000737 | rep | CO | 1865-12-04 | 1867-03-03 | Republican | -1 | |||||||||||||
8519 | 8519 | John Benjamin B000364 | rep | MO | 1865-12-04 | 1867-03-03 | Republican | 8 | |||||||||||||
8516 | 8516 | Fernando Beaman B000275 | rep | MI | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8504 | 8504 | Samuel Arnell A000286 | rep | TN | 1865-12-04 | 1867-03-03 | Unconditional Unionist | 6 | |||||||||||||
8491 | 8491 | Frederick Woodbridge W000708 | rep | VT | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8488 | 8488 | Stephen Wilson W000613 | rep | PA | 1865-12-04 | 1867-03-03 | Republican | 18 | |||||||||||||
8486 | 8486 | Thomas Williams W000538 | rep | PA | 1865-12-04 | 1867-03-03 | Republican | 23 | |||||||||||||
8483 | 8483 | Henry Washburn W000172 | rep | IN | 1865-12-04 | 1867-03-03 | Republican | 7 | |||||||||||||
8480 | 8480 | Burt Van Horn V000040 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 29 | |||||||||||||
8477 | 8477 | Charles Upson U000027 | rep | MI | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8474 | 8474 | Lyman Trumbull T000392 | sen | IL | 1861-07-04 | 1867-03-03 | 3 | Republican | |||||||||||||
8471 | 8471 | Rowland Trowbridge T000385 | rep | MI | 1865-12-04 | 1867-03-03 | Republican | 5 | |||||||||||||
8467 | 8467 | Francis Thomas T000166 | rep | MD | 1865-12-04 | 1867-03-03 | Unconditional Unionist | 4 | |||||||||||||
8457 | 8457 | Stephen Taber T000002 | rep | NY | 1865-12-04 | 1867-03-03 | Democrat | 1 | |||||||||||||
8453 | 8453 | Thaddeus Stevens S000887 | rep | PA | 1865-12-04 | 1867-03-03 | Republican | 9 | |||||||||||||
8446 | 8446 | Rufus Spalding S000697 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 18 | |||||||||||||
8443 | 8443 | Charles Sitgreaves S000458 | rep | NJ | 1865-12-04 | 1867-03-03 | Democrat | 3 | |||||||||||||
8440 | 8440 | Lewis Ross R000451 | rep | IL | 1865-12-04 | 1867-03-03 | Democrat | 9 | |||||||||||||
8433 | 8433 | Theodore Pomeroy P000424 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 24 | |||||||||||||
8429 | 8429 | Samuel Pomeroy P000423 | sen | KS | 1861-07-04 | 1867-03-03 | 3 | Republican |
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);