legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
220 rows where "end" is on date 1865-03-03 sorted by end
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7429 | 7429 | John Hale H000034 | sen | NH | 1859-12-05 | 1865-03-03 | 2 | Republican | |||||||||||||
7546 | 7546 | Lazarus Powell P000481 | sen | KY | 1859-12-05 | 1865-03-03 | 2 | Democrat | |||||||||||||
7600 | 7600 | John Ten Eyck T000122 | sen | NJ | 1859-12-05 | 1865-03-03 | 2 | Republican | |||||||||||||
7689 | 7689 | John Carlile C000150 | sen | VA | 1861-07-09 | 1865-03-03 | 2 | Unionist | |||||||||||||
7896 | 7896 | Benjamin Harding H000189 | sen | OR | 1862-01-01 | 1865-03-03 | 2 | Democrat | |||||||||||||
7905 | 7905 | James Allen A000128 | rep | IL | 1863-12-07 | 1865-03-03 | Democrat | -1 | |||||||||||||
7907 | 7907 | William Allen A000152 | rep | IL | 1863-12-07 | 1865-03-03 | Democrat | 13 | |||||||||||||
7908 | 7908 | Lucien Anderson A000201 | rep | KY | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 1 | |||||||||||||
7910 | 7910 | Isaac Arnold A000288 | rep | IL | 1863-12-07 | 1865-03-03 | Republican | 1 | |||||||||||||
7912 | 7912 | Joseph Bailey B000043 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 15 | |||||||||||||
7913 | 7913 | Augustus Baldwin B000085 | rep | MI | 1863-12-07 | 1865-03-03 | Democrat | 5 | |||||||||||||
7915 | 7915 | Hiram Bennet B000369 | rep | CO | 1863-12-07 | 1865-03-03 | Conservative Republican | -1 | |||||||||||||
7917 | 7917 | Jacob Blair B000525 | rep | WV | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 1 | |||||||||||||
7919 | 7919 | George Bliss B000559 | rep | OH | 1863-12-07 | 1865-03-03 | Democrat | 14 | |||||||||||||
7920 | 7920 | Lemuel Bowden B000678 | sen | VA | 1863-12-07 | 1865-03-03 | 1 | Unionist | |||||||||||||
7922 | 7922 | James Brown B000922 | rep | WI | 1863-12-07 | 1865-03-03 | Democrat | 1 | |||||||||||||
7926 | 7926 | William Brown B000948 | rep | VA | 1863-12-07 | 1865-03-03 | Unconditional Unionist | -1 | |||||||||||||
7928 | 7928 | Ambrose Clark C000420 | rep | NY | 1863-12-07 | 1865-03-03 | Republican | 20 | |||||||||||||
7929 | 7929 | Brutus Clay C000479 | rep | KY | 1863-12-07 | 1865-03-03 | Unionist | 7 | |||||||||||||
7930 | 7930 | George Cole C000609 | rep | WA | 1863-12-07 | 1865-03-03 | Democrat | -1 | |||||||||||||
7934 | 7934 | Erastus Corning C000784 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 14 | |||||||||||||
7936 | 7936 | James Cravens C000883 | rep | IN | 1863-12-07 | 1865-03-03 | Democrat | 2 | |||||||||||||
7939 | 7939 | Samuel Daily D000006 | rep | NE | 1863-12-07 | 1865-03-03 | Republican | -1 | |||||||||||||
7943 | 7943 | Henry Davis D000104 | rep | MD | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 3 | |||||||||||||
7950 | 7950 | Joseph Edgerton E000047 | rep | IN | 1863-12-07 | 1865-03-03 | Democrat | 10 | |||||||||||||
7958 | 7958 | Augustus Frank F000338 | rep | NY | 1863-12-07 | 1865-03-03 | Republican | 29 | |||||||||||||
7959 | 7959 | John Ganson G000042 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 30 | |||||||||||||
7962 | 7962 | James Hale H000032 | rep | PA | 1863-12-07 | 1865-03-03 | Ind. Republican | 18 | |||||||||||||
7964 | 7964 | William Hall H000079 | rep | MO | 1863-12-07 | 1865-03-03 | Unionist | 8 | |||||||||||||
7965 | 7965 | Henry Harrington H000229 | rep | IN | 1863-12-07 | 1865-03-03 | Democrat | 3 | |||||||||||||
7966 | 7966 | Charles Harris H000234 | rep | IL | 1863-12-07 | 1865-03-03 | Democrat | 4 | |||||||||||||
7970 | 7970 | Anson Herrick H000537 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 9 | |||||||||||||
7971 | 7971 | Wells Hutchins H001010 | rep | OH | 1863-12-07 | 1865-03-03 | Democrat | 11 | |||||||||||||
7972 | 7972 | William Jayne J000066 | rep | DK | 1863-12-07 | 1865-03-03 | -1 | ||||||||||||||
7975 | 7975 | William Johnston J000201 | rep | OH | 1863-12-07 | 1865-03-03 | Democrat | 8 | |||||||||||||
7976 | 7976 | Martin Kalbfleisch K000005 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 2 | |||||||||||||
7977 | 7977 | Austin King K000194 | rep | MO | 1863-12-07 | 1865-03-03 | Unionist | 6 | |||||||||||||
7978 | 7978 | John Kinney K000225 | rep | UT | 1863-12-07 | 1865-03-03 | Democrat | -1 | |||||||||||||
7980 | 7980 | Anthony Knapp K000276 | rep | IL | 1863-12-07 | 1865-03-03 | Democrat | 10 | |||||||||||||
7981 | 7981 | Samuel Knox K000297 | rep | MO | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 1 | |||||||||||||
7983 | 7983 | John Law L000125 | rep | IN | 1863-12-07 | 1865-03-03 | Democrat | 1 | |||||||||||||
7985 | 7985 | Jesse Lazear L000154 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 24 | |||||||||||||
7986 | 7986 | De Littlejohn L000357 | rep | NY | 1863-12-07 | 1865-03-03 | Republican | 22 | |||||||||||||
7987 | 7987 | Alexander Long L000410 | rep | OH | 1863-12-07 | 1865-03-03 | Democrat | 2 | |||||||||||||
7991 | 7991 | Owen Lovejoy L000462 | rep | IL | 1863-12-07 | 1865-03-03 | Republican | 5 | |||||||||||||
7994 | 7994 | Robert Mallory M000082 | rep | KY | 1863-12-07 | 1865-03-03 | Unionist | 5 | |||||||||||||
7995 | 7995 | Daniel Marcy M000126 | rep | NH | 1863-12-07 | 1865-03-03 | Democrat | 1 | |||||||||||||
7996 | 7996 | Archibald McAllister M000295 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 17 | |||||||||||||
7997 | 7997 | John McBride M000301 | rep | OR | 1863-12-07 | 1865-03-03 | Republican | 1 | |||||||||||||
7998 | 7998 | James McDowell M000420 | rep | IN | 1863-12-07 | 1865-03-03 | Democrat | 11 | |||||||||||||
7999 | 7999 | George Middleton M000697 | rep | NJ | 1863-12-07 | 1865-03-03 | Democrat | 2 | |||||||||||||
8000 | 8000 | William Miller M000763 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 14 | |||||||||||||
8003 | 8003 | James Morris M000978 | rep | OH | 1863-12-07 | 1865-03-03 | Democrat | 15 | |||||||||||||
8004 | 8004 | Gordon Mott M001038 | rep | NV | 1863-12-07 | 1865-03-03 | Republican | 0 | |||||||||||||
8005 | 8005 | Amos Myers M001126 | rep | PA | 1863-12-07 | 1865-03-03 | Republican | 20 | |||||||||||||
8006 | 8006 | Homer Nelson N000034 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 12 | |||||||||||||
8008 | 8008 | Warren Noble N000119 | rep | OH | 1863-12-07 | 1865-03-03 | Democrat | 9 | |||||||||||||
8011 | 8011 | John Noell N000122 | rep | MO | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 3 | |||||||||||||
8014 | 8014 | Jesse Norton N000151 | rep | IL | 1863-12-07 | 1865-03-03 | Republican | 6 | |||||||||||||
8015 | 8015 | John O’Neill O000096 | rep | OH | 1863-12-07 | 1865-03-03 | Democrat | 13 | |||||||||||||
8017 | 8017 | Moses Odell O000037 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 3 | |||||||||||||
8018 | 8018 | Francisco Perea P000224 | rep | NM | 1863-12-07 | 1865-03-03 | Republican | -1 | |||||||||||||
8020 | 8020 | Nehemiah Perry P000244 | rep | NJ | 1863-12-07 | 1865-03-03 | Democrat | 5 | |||||||||||||
8021 | 8021 | Charles Poston P000458 | rep | AZ | 1863-12-07 | 1865-03-03 | Republican | 0 | |||||||||||||
8028 | 8028 | William Richardson R000228 | sen | IL | 1863-12-07 | 1865-03-03 | 2 | Democrat | |||||||||||||
8030 | 8030 | James Rollins R000412 | rep | MO | 1863-12-07 | 1865-03-03 | Unionist | 9 | |||||||||||||
8031 | 8031 | John Scott S000178 | rep | MO | 1863-12-07 | 1865-03-03 | Democrat | 3 | |||||||||||||
8033 | 8033 | Joseph Segar S000227 | rep | VA | 1863-12-07 | 1865-03-03 | Unionist | -1 | |||||||||||||
8034 | 8034 | Thomas Shannon S000290 | rep | CA | 1863-12-07 | 1865-03-03 | Republican | -1 | |||||||||||||
8035 | 8035 | Nathaniel Smithers S000642 | rep | DE | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 0 | |||||||||||||
8036 | 8036 | Henry Stebbins S000825 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 1 | |||||||||||||
8038 | 8038 | John Steele S000833 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 13 | |||||||||||||
8040 | 8040 | William Steele S000839 | rep | NJ | 1863-12-07 | 1865-03-03 | Democrat | 3 | |||||||||||||
8043 | 8043 | John Stuart S001035 | rep | IL | 1863-12-07 | 1865-03-03 | Democrat | 8 | |||||||||||||
8044 | 8044 | Lorenzo Sweat S001100 | rep | ME | 1863-12-07 | 1865-03-03 | Democrat | 1 | |||||||||||||
8045 | 8045 | William Temple T000120 | rep | DE | 1863-12-07 | 1865-03-03 | Democrat | 0 | |||||||||||||
8047 | 8047 | John Todd T000292 | rep | DK | 1863-12-07 | 1865-03-03 | Democrat | -1 | |||||||||||||
8048 | 8048 | Henry Tracy T000345 | rep | PA | 1863-12-07 | 1865-03-03 | Ind. Republican | 13 | |||||||||||||
8050 | 8050 | Robert Van Valkenburgh V000061 | rep | NY | 1863-12-07 | 1865-03-03 | Republican | 27 | |||||||||||||
8057 | 8057 | William Wallace W000086 | rep | ID | 1863-12-07 | 1865-03-03 | Republican | -1 | |||||||||||||
8058 | 8058 | Ezra Wheeler W000332 | rep | WI | 1863-12-07 | 1865-03-03 | Democrat | 5 | |||||||||||||
8060 | 8060 | Chilton White W000360 | rep | OH | 1863-12-07 | 1865-03-03 | Democrat | 6 | |||||||||||||
8061 | 8061 | Joseph White W000384 | rep | OH | 1863-12-07 | 1865-03-03 | Democrat | 16 | |||||||||||||
8062 | 8062 | Abel Wilder W000461 | rep | KS | 1863-12-07 | 1865-03-03 | Republican | 1 | |||||||||||||
8063 | 8063 | Henry Worthington W000747 | rep | NV | 1863-12-07 | 1865-03-03 | Republican | 0 | |||||||||||||
8069 | 8069 | George Yeaman Y000015 | rep | KY | 1863-12-07 | 1865-03-03 | Unionist | 2 | |||||||||||||
8070 | 8070 | Nathan Farwell F000038 | sen | ME | 1864-01-01 | 1865-03-03 | 2 | Republican | |||||||||||||
8076 | 8076 | John Alley A000155 | rep | MA | 1863-12-07 | 1865-03-03 | Republican | 5 | |||||||||||||
8079 | 8079 | Sydenham Ancona A000178 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 8 | |||||||||||||
8083 | 8083 | Portus Baxter B000246 | rep | VT | 1863-12-07 | 1865-03-03 | Republican | 3 | |||||||||||||
8087 | 8087 | Henry Blow B000572 | rep | MO | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 2 | |||||||||||||
8089 | 8089 | Augustus Brandegee B000768 | rep | CT | 1863-12-07 | 1865-03-03 | Republican | 3 | |||||||||||||
8096 | 8096 | John Creswell C000904 | rep | MD | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 1 | |||||||||||||
8100 | 8100 | Thomas Davis D000139 | rep | NY | 1863-12-07 | 1865-03-03 | Republican | 23 | |||||||||||||
8104 | 8104 | John Dawson D000153 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 21 | |||||||||||||
8107 | 8107 | Henry Deming D000227 | rep | CT | 1863-12-07 | 1865-03-03 | Republican | 1 | |||||||||||||
8111 | 8111 | Ebenezer Dumont D000524 | rep | IN | 1863-12-07 | 1865-03-03 | Republican | 6 | |||||||||||||
8116 | 8116 | William Fessenden F000099 | sen | ME | 1859-12-05 | 1865-03-03 | 2 | Republican | |||||||||||||
8125 | 8125 | Henry Grider G000455 | rep | KY | 1863-12-07 | 1865-03-03 | Unionist | 3 | |||||||||||||
8127 | 8127 | James Grimes G000475 | sen | IA | 1859-12-05 | 1865-03-03 | 2 | 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);