legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
275 rows where "end" is on date 1861-03-03 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, state, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13976 | 13976 | Galusha Grow G000507 | rep | PA | 1859-12-05 | 1861-03-03 | Republican | 14 | |||||||||||||
13427 | 13427 | Justin Morrill M000969 | rep | VT | 1859-12-05 | 1861-03-03 | Republican | 2 | |||||||||||||
13333 | 13333 | William Holman H000732 | rep | IN | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
12786 | 12786 | Daniel Sickles S000402 | rep | NY | 1859-12-05 | 1861-03-03 | Democrat | 3 | |||||||||||||
12778 | 12778 | John Sherman S000346 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 13 | |||||||||||||
12340 | 12340 | Zebulon Vance V000021 | rep | NC | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 8 | |||||||||||||
12271 | 12271 | James Pugh P000561 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 2 | |||||||||||||
11999 | 11999 | William Vandever V000031 | rep | IA | 1859-12-05 | 1861-03-03 | Republican | 2 | |||||||||||||
11832 | 11832 | Gilman Marston M000165 | rep | NH | 1859-12-05 | 1861-03-03 | Republican | 1 | |||||||||||||
11692 | 11692 | Samuel Cox C000839 | rep | OH | 1859-12-05 | 1861-03-03 | Democrat | 12 | |||||||||||||
11482 | 11482 | John Reagan R000098 | rep | TX | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
11337 | 11337 | Henry Dawes D000148 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 11 | |||||||||||||
11189 | 11189 | Otho Singleton S000445 | rep | MS | 1859-12-05 | 1861-03-03 | Democrat | 4 | |||||||||||||
11110 | 11110 | John Logan L000403 | rep | IL | 1859-12-05 | 1861-03-03 | Democrat | 9 | |||||||||||||
10785 | 10785 | Lucius Lamar L000030 | rep | MS | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
10735 | 10735 | Thomas Hardeman H000181 | rep | GA | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 3 | |||||||||||||
10579 | 10579 | Charles Van Wyck V000067 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 10 | |||||||||||||
10239 | 10239 | William Windom W000629 | rep | MN | 1859-12-05 | 1861-03-03 | Republican | -1 | |||||||||||||
10163 | 10163 | George Pendleton P000203 | rep | OH | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
10122 | 10122 | John Killinger K000179 | rep | PA | 1859-12-05 | 1861-03-03 | Republican | 10 | |||||||||||||
10115 | 10115 | George Houston H000822 | rep | AL | 1859-12-05 | 1861-03-03 | Democrat | 5 | |||||||||||||
10092 | 10092 | John Harris H000247 | rep | VA | 1859-12-05 | 1861-03-03 | Ind. Democrat | 9 | |||||||||||||
10049 | 10049 | Roscoe Conkling C000681 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 20 | |||||||||||||
9667 | 9667 | Henry Waldron W000041 | rep | MI | 1859-12-05 | 1861-03-03 | Republican | 2 | |||||||||||||
9464 | 9464 | James Buffinton B001040 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 2 | |||||||||||||
9456 | 9456 | John Brown B000933 | rep | KY | 1859-12-05 | 1861-03-03 | Democrat | 5 | |||||||||||||
9331 | 9331 | James Robinson R000336 | rep | IL | 1859-12-05 | 1861-03-03 | Democrat | 7 | |||||||||||||
9290 | 9290 | William Niblack N000083 | rep | IN | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
9253 | 9253 | Horace Maynard M000284 | rep | TN | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 2 | |||||||||||||
9232 | 9232 | James Leach L000170 | rep | NC | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 6 | |||||||||||||
9178 | 9178 | Daniel Gooch G000274 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 7 | |||||||||||||
9167 | 9167 | Orris Ferry F000094 | rep | CT | 1859-12-05 | 1861-03-03 | Republican | 4 | |||||||||||||
9155 | 9155 | Rodolphus Duell D000513 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 21 | |||||||||||||
9028 | 9028 | John Stevenson S000894 | rep | KY | 1859-12-05 | 1861-03-03 | Democrat | 10 | |||||||||||||
8934 | 8934 | William Hooper H000767 | rep | UT | 1859-12-05 | 1861-03-03 | Democrat | -1 | |||||||||||||
8930 | 8930 | Joshua Hill H000599 | rep | GA | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 7 | |||||||||||||
8888 | 8888 | John Farnsworth F000024 | rep | IL | 1859-12-05 | 1861-03-03 | Republican | 2 | |||||||||||||
8829 | 8829 | Francis Blair B000523 | rep | MO | 1859-12-05 | 1861-03-03 | Republican | 1 | |||||||||||||
8817 | 8817 | John Bingham B000471 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 21 | |||||||||||||
8770 | 8770 | Elihu Washburne W000176 | rep | IL | 1859-12-05 | 1861-03-03 | Republican | 1 | |||||||||||||
8764 | 8764 | Cadwallader Washburn W000170 | rep | WI | 1859-12-05 | 1861-03-03 | Republican | 2 | |||||||||||||
8733 | 8733 | William Stokes S000950 | rep | TN | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 4 | |||||||||||||
8591 | 8591 | Reuben Fenton F000077 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 33 | |||||||||||||
8564 | 8564 | John Covode C000818 | rep | PA | 1859-12-05 | 1861-03-03 | Republican | 19 | |||||||||||||
8473 | 8473 | Lyman Trumbull T000392 | sen | IL | 1855-12-03 | 1861-03-03 | 3 | Republican | |||||||||||||
8450 | 8450 | Thaddeus Stevens S000887 | rep | PA | 1859-12-05 | 1861-03-03 | Republican | 9 | |||||||||||||
8397 | 8397 | James Moorhead M000929 | rep | PA | 1859-12-05 | 1861-03-03 | Republican | 21 | |||||||||||||
8370 | 8370 | Francis Kellogg K000064 | rep | MI | 1859-12-05 | 1861-03-03 | Republican | 3 | |||||||||||||
8346 | 8346 | James Harlan H000211 | sen | IA | 1855-12-03 | 1861-03-03 | 3 | Republican | |||||||||||||
8325 | 8325 | Thomas Eliot E000106 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 1 | |||||||||||||
8292 | 8292 | Schuyler Colfax C000626 | rep | IN | 1859-12-05 | 1861-03-03 | Republican | 9 | |||||||||||||
8252 | 8252 | James Ashley A000314 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 5 | |||||||||||||
8220 | 8220 | Edwin Webster W000239 | rep | MD | 1859-12-05 | 1861-03-03 | American | 2 | |||||||||||||
8188 | 8188 | Alexander Rice R000193 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 4 | |||||||||||||
8150 | 8150 | James Humphrey H000954 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 2 | |||||||||||||
8074 | 8074 | John Alley A000155 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 6 | |||||||||||||
8009 | 8009 | John Noell N000122 | rep | MO | 1859-12-05 | 1861-03-03 | Democrat | 7 | |||||||||||||
7992 | 7992 | Robert Mallory M000082 | rep | KY | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 7 | |||||||||||||
7989 | 7989 | Owen Lovejoy L000462 | rep | IL | 1859-12-05 | 1861-03-03 | Republican | 3 | |||||||||||||
7960 | 7960 | James Hale H000032 | rep | PA | 1859-12-05 | 1861-03-03 | Republican | 15 | |||||||||||||
7956 | 7956 | Augustus Frank F000338 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 30 | |||||||||||||
7942 | 7942 | Henry Davis D000104 | rep | MD | 1859-12-05 | 1861-03-03 | American | 4 | |||||||||||||
7937 | 7937 | Samuel Daily D000006 | rep | NE | 1859-12-05 | 1861-03-03 | Republican | -1 | |||||||||||||
7876 | 7876 | Eliakim Walton W000113 | rep | VT | 1859-12-05 | 1861-03-03 | Republican | 1 | |||||||||||||
7869 | 7869 | John Verree V000090 | rep | PA | 1859-12-05 | 1861-03-03 | Republican | 3 | |||||||||||||
7867 | 7867 | Clement Vallandigham V000008 | rep | OH | 1859-12-05 | 1861-03-03 | Democrat | 3 | |||||||||||||
7863 | 7863 | Carey Trimble T000371 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 10 | |||||||||||||
7861 | 7861 | Charles Train T000352 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 8 | |||||||||||||
7857 | 7857 | John Stratton S000995 | rep | NJ | 1859-12-05 | 1861-03-03 | Republican | 2 | |||||||||||||
7854 | 7854 | Elbridge Spaulding S000705 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 32 | |||||||||||||
7847 | 7847 | Charles Sedgwick S000221 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 24 | |||||||||||||
7845 | 7845 | George Scranton S000191 | rep | PA | 1859-12-05 | 1861-03-03 | Republican | 12 | |||||||||||||
7840 | 7840 | John Potter P000465 | rep | WI | 1859-12-05 | 1861-03-03 | Republican | 1 | |||||||||||||
7837 | 7837 | Albert Porter P000435 | rep | IN | 1859-12-05 | 1861-03-03 | Republican | 6 | |||||||||||||
7834 | 7834 | John Phelps P000296 | rep | MO | 1859-12-05 | 1861-03-03 | Democrat | 6 | |||||||||||||
7825 | 7825 | James Pearce P000161 | sen | MD | 1855-12-03 | 1861-03-03 | 3 | Democrat | |||||||||||||
7818 | 7818 | Abram Olin O000066 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 13 | |||||||||||||
7813 | 7813 | John Nixon N000115 | rep | NJ | 1859-12-05 | 1861-03-03 | Republican | 1 | |||||||||||||
7811 | 7811 | Thomas Nelson N000042 | rep | TN | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 1 | |||||||||||||
7809 | 7809 | Edward Morris M000975 | rep | PA | 1859-12-05 | 1861-03-03 | Republican | 2 | |||||||||||||
7801 | 7801 | Edward McPherson M000591 | rep | PA | 1859-12-05 | 1861-03-03 | Republican | 17 | |||||||||||||
7799 | 7799 | Robert McKnight M000531 | rep | PA | 1859-12-05 | 1861-03-03 | Republican | 22 | |||||||||||||
7797 | 7797 | James McKean M000491 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 15 | |||||||||||||
7793 | 7793 | John McClernand M000337 | rep | IL | 1859-12-05 | 1861-03-03 | Democrat | 6 | |||||||||||||
7784 | 7784 | Dwight Loomis L000438 | rep | CT | 1859-12-05 | 1861-03-03 | Republican | 1 | |||||||||||||
7776 | 7776 | William Kellogg K000068 | rep | IL | 1859-12-05 | 1861-03-03 | Republican | 4 | |||||||||||||
7771 | 7771 | John Hutchins H001008 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 20 | |||||||||||||
7766 | 7766 | John Hickman H000562 | rep | PA | 1859-12-05 | 1861-03-03 | Anti-Lecompton Democrat | 6 | |||||||||||||
7758 | 7758 | John Gurley G000530 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 2 | |||||||||||||
7754 | 7754 | Philip Fouke F000316 | rep | IL | 1859-12-05 | 1861-03-03 | Democrat | 8 | |||||||||||||
7752 | 7752 | Lafayette Foster F000308 | sen | CT | 1855-12-03 | 1861-03-03 | 3 | Republican | |||||||||||||
7746 | 7746 | Alfred Ely E000164 | rep | NY | 1859-12-05 | 1861-03-03 | Republican | 29 | |||||||||||||
7744 | 7744 | Thomas Edwards E000081 | rep | NH | 1859-12-05 | 1861-03-03 | Republican | 3 | |||||||||||||
7742 | 7742 | Sidney Edgerton E000048 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 18 | |||||||||||||
7740 | 7740 | William Dunn D000554 | rep | IN | 1859-12-05 | 1861-03-03 | Republican | 3 | |||||||||||||
7735 | 7735 | Charles Delano D000213 | rep | MA | 1859-12-05 | 1861-03-03 | Republican | 10 | |||||||||||||
7733 | 7733 | Daniel De Jarnette D000202 | rep | VA | 1859-12-05 | 1861-03-03 | Ind. Democrat | 3 | |||||||||||||
7729 | 7729 | Samuel Curtis C001013 | rep | IA | 1859-12-05 | 1861-03-03 | Republican | 1 | |||||||||||||
7726 | 7726 | John Crittenden C000912 | sen | KY | 1855-12-03 | 1861-03-03 | 3 | American | |||||||||||||
7716 | 7716 | Thomas Corwin C000791 | rep | OH | 1859-12-05 | 1861-03-03 | Republican | 7 |
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);