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 party
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7972 | 7972 | William Jayne J000066 | rep | DK | 1863-12-07 | 1865-03-03 | -1 | ||||||||||||||
7915 | 7915 | Hiram Bennet B000369 | rep | CO | 1863-12-07 | 1865-03-03 | Conservative Republican | -1 | |||||||||||||
7546 | 7546 | Lazarus Powell P000481 | sen | KY | 1859-12-05 | 1865-03-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
7919 | 7919 | George Bliss B000559 | rep | OH | 1863-12-07 | 1865-03-03 | Democrat | 14 | |||||||||||||
7922 | 7922 | James Brown B000922 | rep | WI | 1863-12-07 | 1865-03-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
7950 | 7950 | Joseph Edgerton E000047 | rep | IN | 1863-12-07 | 1865-03-03 | Democrat | 10 | |||||||||||||
7959 | 7959 | John Ganson G000042 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 30 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
7987 | 7987 | Alexander Long L000410 | rep | OH | 1863-12-07 | 1865-03-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
8020 | 8020 | Nehemiah Perry P000244 | rep | NJ | 1863-12-07 | 1865-03-03 | Democrat | 5 | |||||||||||||
8028 | 8028 | William Richardson R000228 | sen | IL | 1863-12-07 | 1865-03-03 | 2 | Democrat | |||||||||||||
8031 | 8031 | John Scott S000178 | rep | MO | 1863-12-07 | 1865-03-03 | Democrat | 3 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
8079 | 8079 | Sydenham Ancona A000178 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 8 | |||||||||||||
8104 | 8104 | John Dawson D000153 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 21 | |||||||||||||
8135 | 8135 | Benjamin Harris H000232 | rep | MD | 1863-12-07 | 1865-03-03 | Democrat | 5 | |||||||||||||
8154 | 8154 | Philip Johnson J000168 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 11 | |||||||||||||
8166 | 8166 | Francis Le Blond L000156 | rep | OH | 1863-12-07 | 1865-03-03 | Democrat | 5 | |||||||||||||
8174 | 8174 | Samuel McLean M000551 | rep | MT | 1863-12-07 | 1865-03-03 | Democrat | -1 | |||||||||||||
8183 | 8183 | William Radford R000007 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 10 | |||||||||||||
8196 | 8196 | Andrew Rogers R000387 | rep | NJ | 1863-12-07 | 1865-03-03 | Democrat | 4 | |||||||||||||
8199 | 8199 | Willard Saulsbury S000074 | sen | DE | 1859-12-05 | 1865-03-03 | 2 | Democrat | |||||||||||||
8209 | 8209 | Myer Strouse S001026 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 10 | |||||||||||||
8237 | 8237 | Charles Winfield W000630 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 11 | |||||||||||||
8264 | 8264 | James Bayard B000248 | sen | DE | 1863-12-07 | 1865-03-03 | 1 | Democrat | |||||||||||||
8282 | 8282 | John Chanler C000302 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 7 | |||||||||||||
8308 | 8308 | Charles Denison D000235 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 12 | |||||||||||||
8339 | 8339 | John Griswold G000486 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 15 | |||||||||||||
8435 | 8435 | John Pruyn P000554 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 14 | |||||||||||||
8439 | 8439 | Lewis Ross R000451 | rep | IL | 1863-12-07 | 1865-03-03 | Democrat | 9 | |||||||||||||
8729 | 8729 | John Stiles S000924 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 6 | |||||||||||||
8959 | 8959 | John McKinney M000525 | rep | OH | 1863-12-07 | 1865-03-03 | Democrat | 4 | |||||||||||||
9038 | 9038 | Dwight Townsend T000331 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 1 | |||||||||||||
9102 | 9102 | James Brooks B000881 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 8 | |||||||||||||
9159 | 9159 | Charles Eldredge E000103 | rep | WI | 1863-12-07 | 1865-03-03 | Democrat | 4 | |||||||||||||
9171 | 9171 | William Finck F000118 | rep | OH | 1863-12-07 | 1865-03-03 | Democrat | 12 | |||||||||||||
9333 | 9333 | James Robinson R000336 | rep | IL | 1863-12-07 | 1865-03-03 | Democrat | 11 | |||||||||||||
9500 | 9500 | James English E000185 | rep | CT | 1863-12-07 | 1865-03-03 | Democrat | 2 | |||||||||||||
9551 | 9551 | Francis Kernan K000133 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 21 | |||||||||||||
9685 | 9685 | Elijah Ward W000131 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 6 | |||||||||||||
10046 | 10046 | Alexander Coffroth C000593 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 16 | |||||||||||||
10165 | 10165 | George Pendleton P000203 | rep | OH | 1863-12-07 | 1865-03-03 | Democrat | 1 | |||||||||||||
10604 | 10604 | Benjamin Wood W000690 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 4 | |||||||||||||
10607 | 10607 | Fernando Wood W000694 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 5 | |||||||||||||
11019 | 11019 | John Eden E000042 | rep | IL | 1863-12-07 | 1865-03-03 | Democrat | 7 | |||||||||||||
11134 | 11134 | William Morrison M001000 | rep | IL | 1863-12-07 | 1865-03-03 | Democrat | 12 | |||||||||||||
11694 | 11694 | Samuel Cox C000839 | rep | OH | 1863-12-07 | 1865-03-03 | Democrat | 7 | |||||||||||||
11912 | 11912 | Samuel Randall R000039 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 1 | |||||||||||||
12346 | 12346 | Daniel Voorhees V000116 | rep | IN | 1863-12-07 | 1865-03-03 | Democrat | 7 | |||||||||||||
13335 | 13335 | William Holman H000732 | rep | IN | 1863-12-07 | 1865-03-03 | Democrat | 4 | |||||||||||||
7962 | 7962 | James Hale H000032 | rep | PA | 1863-12-07 | 1865-03-03 | Ind. Republican | 18 | |||||||||||||
8048 | 8048 | Henry Tracy T000345 | rep | PA | 1863-12-07 | 1865-03-03 | Ind. Republican | 13 | |||||||||||||
7429 | 7429 | John Hale H000034 | sen | NH | 1859-12-05 | 1865-03-03 | 2 | Republican | |||||||||||||
7600 | 7600 | John Ten Eyck T000122 | sen | NJ | 1859-12-05 | 1865-03-03 | 2 | Republican | |||||||||||||
7910 | 7910 | Isaac Arnold A000288 | rep | IL | 1863-12-07 | 1865-03-03 | Republican | 1 | |||||||||||||
7928 | 7928 | Ambrose Clark C000420 | rep | NY | 1863-12-07 | 1865-03-03 | Republican | 20 | |||||||||||||
7939 | 7939 | Samuel Daily D000006 | rep | NE | 1863-12-07 | 1865-03-03 | Republican | -1 | |||||||||||||
7958 | 7958 | Augustus Frank F000338 | rep | NY | 1863-12-07 | 1865-03-03 | Republican | 29 | |||||||||||||
7986 | 7986 | De Littlejohn L000357 | rep | NY | 1863-12-07 | 1865-03-03 | Republican | 22 | |||||||||||||
7991 | 7991 | Owen Lovejoy L000462 | rep | IL | 1863-12-07 | 1865-03-03 | Republican | 5 | |||||||||||||
7997 | 7997 | John McBride M000301 | rep | OR | 1863-12-07 | 1865-03-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
8014 | 8014 | Jesse Norton N000151 | rep | IL | 1863-12-07 | 1865-03-03 | Republican | 6 |
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);