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 1863-03-03 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7646 | 7646 | Milton Latham L000110 | sen | CA | 1860-01-01 | 1863-03-03 | 1 | Democrat | |||||||||||||
7786 | 7786 | Frederick Low L000469 | rep | CA | 1861-07-04 | 1863-03-03 | Republican | -1 | |||||||||||||
7836 | 7836 | Timothy Phelps P000300 | rep | CA | 1861-07-04 | 1863-03-03 | Republican | -1 | |||||||||||||
9337 | 9337 | Aaron Sargent S000065 | rep | CA | 1861-07-04 | 1863-03-03 | Republican | -1 | |||||||||||||
7914 | 7914 | Hiram Bennet B000369 | rep | CO | 1861-07-04 | 1863-03-03 | Conservative Republican | -1 | |||||||||||||
7682 | 7682 | Alfred Burnham B001123 | rep | CT | 1861-07-04 | 1863-03-03 | Republican | 3 | |||||||||||||
7785 | 7785 | Dwight Loomis L000438 | rep | CT | 1861-07-04 | 1863-03-03 | Republican | 1 | |||||||||||||
7892 | 7892 | George Woodruff W000716 | rep | CT | 1861-07-04 | 1863-03-03 | Democrat | 4 | |||||||||||||
7946 | 7946 | James Dixon D000369 | sen | CT | 1857-12-07 | 1863-03-03 | 1 | Republican | |||||||||||||
9499 | 9499 | James English E000185 | rep | CT | 1861-07-04 | 1863-03-03 | Democrat | 2 | |||||||||||||
7750 | 7750 | George Fisher F000147 | rep | DE | 1861-07-04 | 1863-03-03 | Unionist | 0 | |||||||||||||
8263 | 8263 | James Bayard B000248 | sen | DE | 1857-12-07 | 1863-03-03 | 1 | Democrat | |||||||||||||
8046 | 8046 | John Todd T000292 | rep | DK | 1861-07-04 | 1863-03-03 | Democrat | -1 | |||||||||||||
7730 | 7730 | Samuel Curtis C001013 | rep | IA | 1861-07-04 | 1863-03-03 | Republican | 1 | |||||||||||||
12000 | 12000 | William Vandever V000031 | rep | IA | 1861-07-04 | 1863-03-03 | Republican | 2 | |||||||||||||
12042 | 12042 | James Wilson W000594 | rep | IA | 1861-07-04 | 1863-03-03 | Republican | 1 | |||||||||||||
7755 | 7755 | Philip Fouke F000316 | rep | IL | 1861-07-04 | 1863-03-03 | Democrat | 8 | |||||||||||||
7777 | 7777 | William Kellogg K000068 | rep | IL | 1861-07-04 | 1863-03-03 | Republican | 4 | |||||||||||||
7794 | 7794 | John McClernand M000337 | rep | IL | 1861-07-04 | 1863-03-03 | Democrat | 6 | |||||||||||||
7906 | 7906 | William Allen A000152 | rep | IL | 1861-07-04 | 1863-03-03 | Democrat | 9 | |||||||||||||
7909 | 7909 | Isaac Arnold A000288 | rep | IL | 1861-07-04 | 1863-03-03 | Republican | 2 | |||||||||||||
7979 | 7979 | Anthony Knapp K000276 | rep | IL | 1861-07-04 | 1863-03-03 | Democrat | 6 | |||||||||||||
7990 | 7990 | Owen Lovejoy L000462 | rep | IL | 1861-07-04 | 1863-03-03 | Republican | 3 | |||||||||||||
8027 | 8027 | William Richardson R000228 | rep | IL | 1861-07-04 | 1863-03-03 | Democrat | 5 | |||||||||||||
8771 | 8771 | Elihu Washburne W000176 | rep | IL | 1861-07-04 | 1863-03-03 | Republican | 1 | |||||||||||||
9332 | 9332 | James Robinson R000336 | rep | IL | 1861-07-04 | 1863-03-03 | Democrat | 7 | |||||||||||||
11111 | 11111 | John Logan L000403 | rep | IL | 1861-07-04 | 1863-03-03 | Democrat | 9 | |||||||||||||
6993 | 6993 | Jesse Bright B000835 | sen | IN | 1857-12-07 | 1863-03-03 | 1 | Democrat | |||||||||||||
7741 | 7741 | William Dunn D000554 | rep | IN | 1861-07-04 | 1863-03-03 | Republican | 3 | |||||||||||||
7805 | 7805 | William Mitchell M000830 | rep | IN | 1861-07-04 | 1863-03-03 | Republican | 10 | |||||||||||||
7838 | 7838 | Albert Porter P000435 | rep | IN | 1861-07-04 | 1863-03-03 | Republican | 6 | |||||||||||||
7881 | 7881 | Albert White W000351 | rep | IN | 1861-07-04 | 1863-03-03 | Republican | 8 | |||||||||||||
7902 | 7902 | Joseph Wright W000766 | sen | IN | 1862-01-01 | 1863-03-03 | 1 | Unionist | |||||||||||||
7935 | 7935 | James Cravens C000883 | rep | IN | 1861-07-04 | 1863-03-03 | Democrat | 2 | |||||||||||||
7982 | 7982 | John Law L000125 | rep | IN | 1861-07-04 | 1863-03-03 | Democrat | 1 | |||||||||||||
8293 | 8293 | Schuyler Colfax C000626 | rep | IN | 1861-07-04 | 1863-03-03 | Republican | 9 | |||||||||||||
8649 | 8649 | George Julian J000280 | rep | IN | 1861-07-04 | 1863-03-03 | Republican | 5 | |||||||||||||
9352 | 9352 | John Shanks S000284 | rep | IN | 1861-07-04 | 1863-03-03 | Republican | 11 | |||||||||||||
12345 | 12345 | Daniel Voorhees V000116 | rep | IN | 1861-07-04 | 1863-03-03 | Democrat | 7 | |||||||||||||
13334 | 13334 | William Holman H000732 | rep | IN | 1861-07-04 | 1863-03-03 | Democrat | 4 | |||||||||||||
7708 | 7708 | Martin Conway C000713 | rep | KS | 1861-07-04 | 1863-03-03 | Republican | 1 | |||||||||||||
7680 | 7680 | Henry Burnett B001120 | rep | KY | 1861-07-04 | 1863-03-03 | Democrat | 1 | |||||||||||||
7690 | 7690 | Samuel Casey C000229 | rep | KY | 1861-07-04 | 1863-03-03 | Unionist | 1 | |||||||||||||
7727 | 7727 | John Crittenden C000912 | rep | KY | 1861-07-04 | 1863-03-03 | Unionist | 8 | |||||||||||||
7739 | 7739 | George Dunlap D000542 | rep | KY | 1861-07-04 | 1863-03-03 | Unionist | 6 | |||||||||||||
7773 | 7773 | James Jackson J000019 | rep | KY | 1861-07-04 | 1863-03-03 | Unionist | 2 | |||||||||||||
7803 | 7803 | John Menzies M000641 | rep | KY | 1861-07-04 | 1863-03-03 | Unionist | 10 | |||||||||||||
7887 | 7887 | Charles Wickliffe W000442 | rep | KY | 1861-07-04 | 1863-03-03 | Unionist | 5 | |||||||||||||
7993 | 7993 | Robert Mallory M000082 | rep | KY | 1861-07-04 | 1863-03-03 | Unionist | 7 | |||||||||||||
8068 | 8068 | George Yeaman Y000015 | rep | KY | 1861-07-04 | 1863-03-03 | Unionist | 2 | |||||||||||||
8124 | 8124 | Henry Grider G000455 | rep | KY | 1861-07-04 | 1863-03-03 | Unionist | 3 | |||||||||||||
8132 | 8132 | Aaron Harding H000187 | rep | KY | 1861-07-04 | 1863-03-03 | Unionist | 4 | |||||||||||||
11241 | 11241 | William Wadsworth W000015 | rep | KY | 1861-07-04 | 1863-03-03 | Unionist | 9 | |||||||||||||
7751 | 7751 | Benjamin Flanders F000189 | rep | LA | 1861-07-04 | 1863-03-03 | Unionist | 1 | |||||||||||||
11054 | 11054 | Michael Hahn H000019 | rep | LA | 1861-07-04 | 1863-03-03 | Unionist | 2 | |||||||||||||
7649 | 7649 | Charles Adams A000032 | rep | MA | 1861-07-04 | 1863-03-03 | Republican | 3 | |||||||||||||
7656 | 7656 | William Appleton A000270 | rep | MA | 1861-07-04 | 1863-03-03 | Constitutional Unionist | 5 | |||||||||||||
7659 | 7659 | Goldsmith Bailey B000038 | rep | MA | 1861-07-04 | 1863-03-03 | Republican | 9 | |||||||||||||
7736 | 7736 | Charles Delano D000213 | rep | MA | 1861-07-04 | 1863-03-03 | Republican | 10 | |||||||||||||
7860 | 7860 | Benjamin Thomas T000157 | rep | MA | 1861-07-04 | 1863-03-03 | Unionist | 3 | |||||||||||||
7862 | 7862 | Charles Train T000352 | rep | MA | 1861-07-04 | 1863-03-03 | Republican | 8 | |||||||||||||
7872 | 7872 | Amasa Walker W000045 | rep | MA | 1861-07-04 | 1863-03-03 | Republican | 9 | |||||||||||||
8075 | 8075 | John Alley A000155 | rep | MA | 1861-07-04 | 1863-03-03 | Republican | 6 | |||||||||||||
8189 | 8189 | Alexander Rice R000193 | rep | MA | 1861-07-04 | 1863-03-03 | Republican | 4 | |||||||||||||
8326 | 8326 | Thomas Eliot E000106 | rep | MA | 1861-07-04 | 1863-03-03 | Republican | 1 | |||||||||||||
8742 | 8742 | Charles Sumner S001068 | sen | MA | 1857-12-07 | 1863-03-03 | 1 | Republican | |||||||||||||
9179 | 9179 | Daniel Gooch G000274 | rep | MA | 1861-07-04 | 1863-03-03 | Republican | 7 | |||||||||||||
9202 | 9202 | Samuel Hooper H000765 | rep | MA | 1861-07-04 | 1863-03-03 | Republican | 5 | |||||||||||||
9465 | 9465 | James Buffinton B001040 | rep | MA | 1861-07-04 | 1863-03-03 | Republican | 2 | |||||||||||||
11338 | 11338 | Henry Dawes D000148 | rep | MA | 1861-07-04 | 1863-03-03 | Republican | 11 | |||||||||||||
7117 | 7117 | Anthony Kennedy K000103 | sen | MD | 1857-12-07 | 1863-03-03 | 1 | Unionist | |||||||||||||
7683 | 7683 | Charles Calvert C000058 | rep | MD | 1861-07-04 | 1863-03-03 | Unionist | 6 | |||||||||||||
7721 | 7721 | John Crisfield C000907 | rep | MD | 1861-07-04 | 1863-03-03 | Unionist | 1 | |||||||||||||
7782 | 7782 | Cornelius Leary L000179 | rep | MD | 1861-07-04 | 1863-03-03 | Unionist | 3 | |||||||||||||
7788 | 7788 | Henry May M000275 | rep | MD | 1861-07-04 | 1863-03-03 | Unionist | 4 | |||||||||||||
7826 | 7826 | James Pearce P000161 | sen | MD | 1861-07-04 | 1863-03-03 | 3 | Democrat | |||||||||||||
8221 | 8221 | Edwin Webster W000239 | rep | MD | 1861-07-04 | 1863-03-03 | Unionist | 2 | |||||||||||||
8465 | 8465 | Francis Thomas T000166 | rep | MD | 1861-07-04 | 1863-03-03 | Unionist | 5 | |||||||||||||
7748 | 7748 | Samuel Fessenden F000097 | rep | ME | 1861-07-04 | 1863-03-03 | Republican | 3 | |||||||||||||
7749 | 7749 | Thomas Fessenden F000098 | rep | ME | 1861-07-04 | 1863-03-03 | Republican | 2 | |||||||||||||
7806 | 7806 | Anson Morrill M000967 | rep | ME | 1861-07-04 | 1863-03-03 | Republican | 4 | |||||||||||||
7874 | 7874 | Charles Walton W000112 | rep | ME | 1861-07-04 | 1863-03-03 | Republican | 2 | |||||||||||||
8118 | 8118 | John Goodwin G000301 | rep | ME | 1861-07-04 | 1863-03-03 | Republican | 1 | |||||||||||||
8192 | 8192 | John Rice R000201 | rep | ME | 1861-07-04 | 1863-03-03 | Republican | 5 | |||||||||||||
8421 | 8421 | Frederick Pike P000346 | rep | ME | 1861-07-04 | 1863-03-03 | Republican | 6 | |||||||||||||
8978 | 8978 | Lot Morrill M000970 | sen | ME | 1861-07-04 | 1863-03-03 | 1 | Republican | |||||||||||||
7757 | 7757 | Bradley Granger G000374 | rep | MI | 1861-07-04 | 1863-03-03 | Republican | 1 | |||||||||||||
8371 | 8371 | Francis Kellogg K000064 | rep | MI | 1861-07-04 | 1863-03-03 | Republican | 3 | |||||||||||||
8470 | 8470 | Rowland Trowbridge T000385 | rep | MI | 1861-07-04 | 1863-03-03 | Republican | 4 | |||||||||||||
8514 | 8514 | Fernando Beaman B000275 | rep | MI | 1861-07-04 | 1863-03-03 | Republican | 2 | |||||||||||||
10027 | 10027 | Zachariah Chandler C000299 | sen | MI | 1857-12-07 | 1863-03-03 | 1 | Republican | |||||||||||||
7270 | 7270 | Henry Rice R000198 | sen | MN | 1858-01-01 | 1863-03-03 | 1 | Democrat | |||||||||||||
7651 | 7651 | Cyrus Aldrich A000081 | rep | MN | 1861-07-04 | 1863-03-03 | Republican | -1 | |||||||||||||
10240 | 10240 | William Windom W000629 | rep | MN | 1861-07-04 | 1863-03-03 | Republican | -1 | |||||||||||||
7184 | 7184 | Trusten Polk P000411 | sen | MO | 1857-12-07 | 1863-03-03 | 1 | Democrat | |||||||||||||
7698 | 7698 | John Clark C000441 | rep | MO | 1861-07-04 | 1863-03-03 | Democrat | 3 | |||||||||||||
7774 | 7774 | Waldo Johnson J000179 | sen | MO | 1861-07-04 | 1863-03-03 | 3 | Democrat | |||||||||||||
7815 | 7815 | Elijah Norton N000148 | rep | MO | 1861-07-04 | 1863-03-03 | Democrat | 4 | |||||||||||||
7835 | 7835 | John Phelps P000296 | rep | MO | 1861-07-04 | 1863-03-03 | Democrat | 6 | |||||||||||||
7842 | 7842 | Thomas Price P000532 | rep | MO | 1861-07-04 | 1863-03-03 | Democrat | 5 |
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);