legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
244 rows where "start" is on date 1831-12-05 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, party, end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8460 | 8460 | Francis Thomas T000166 | rep | MD | 1831-12-05 | 1833-03-03 | Jackson | 4 | |||||||||||||
7886 | 7886 | Charles Wickliffe W000442 | rep | KY | 1831-12-05 | 1833-03-03 | Jackson | 9 | |||||||||||||
7710 | 7710 | Thomas Corwin C000791 | rep | OH | 1831-12-05 | 1833-03-03 | Whig | 2 | |||||||||||||
6585 | 6585 | Edward Everett E000264 | rep | MA | 1831-12-05 | 1833-03-03 | Whig | 4 | |||||||||||||
6505 | 6505 | John Bell B000340 | rep | TN | 1831-12-05 | 1833-03-03 | Jackson | 7 | |||||||||||||
6186 | 6186 | Thomas Ewing E000281 | sen | OH | 1831-12-05 | 1837-03-03 | 3 | Anti-Jacksonian | |||||||||||||
6181 | 6181 | Robert Barnwell B000168 | rep | SC | 1831-12-05 | 1833-03-03 | Nullifier | 2 | |||||||||||||
6159 | 6159 | Samuel Vinton V000107 | rep | OH | 1831-12-05 | 1833-03-03 | Whig | 7 | |||||||||||||
6116 | 6116 | Augustine Shepperd S000338 | rep | NC | 1831-12-05 | 1833-03-03 | Jackson | 9 | |||||||||||||
5937 | 5937 | Henry Clay C000482 | sen | KY | 1831-12-05 | 1837-03-03 | 3 | Whig | |||||||||||||
5917 | 5917 | Henry Bullard B001049 | rep | LA | 1831-12-05 | 1833-03-03 | Anti Jacksonian | 3 | |||||||||||||
5832 | 5832 | Andrew Stewart S000899 | rep | PA | 1831-12-05 | 1833-03-03 | Anti Masonic | 14 | |||||||||||||
5784 | 5784 | James McKay M000489 | rep | NC | 1831-12-05 | 1833-03-03 | Jackson | 5 | |||||||||||||
5770 | 5770 | Willie Mangum M000096 | sen | NC | 1831-12-05 | 1836-11-26 | 3 | Jackson | |||||||||||||
5756 | 5756 | Dixon Lewis L000278 | rep | AL | 1831-12-05 | 1833-03-03 | Jackson | 3 | |||||||||||||
5666 | 5666 | John Davis D000117 | rep | MA | 1831-12-05 | 1833-03-03 | Whig | 5 | |||||||||||||
5592 | 5592 | John Adams A000041 | rep | MA | 1831-12-05 | 1833-03-03 | Whig | 11 | |||||||||||||
5560 | 5560 | Joseph Vance V000017 | rep | OH | 1831-12-05 | 1833-03-03 | Anti Jacksonian | 4 | |||||||||||||
5525 | 5525 | Jesse Speight S000715 | rep | NC | 1831-12-05 | 1833-03-03 | Jackson | 4 | |||||||||||||
5457 | 5457 | Joseph Johnson J000155 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 18 | |||||||||||||
5450 | 5450 | Jabez Huntington H000997 | rep | CT | 1831-12-05 | 1833-03-03 | Whig | -1 | |||||||||||||
5351 | 5351 | James Polk P000409 | rep | TN | 1831-12-05 | 1833-03-03 | Jackson | 6 | |||||||||||||
5333 | 5333 | Silas Wright W000770 | rep | NY | 1831-12-05 | 1833-03-03 | Jacksonian | -1 | |||||||||||||
5322 | 5322 | William Wilkins W000475 | sen | PA | 1831-12-05 | 1835-03-03 | 3 | Jackson | |||||||||||||
5291 | 5291 | Ambrose Sevier S000256 | rep | AR | 1831-12-05 | 1833-03-03 | Jacksonian | -1 | |||||||||||||
5226 | 5226 | Cave Johnson J000122 | rep | TN | 1831-12-05 | 1833-03-03 | Jackson | 8 | |||||||||||||
5127 | 5127 | Samuel Beardsley B000281 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 14 | |||||||||||||
5105 | 5105 | George McDuffie M000426 | rep | SC | 1831-12-05 | 1833-03-03 | Nullifier | 5 | |||||||||||||
5078 | 5078 | Lewis Williams W000527 | rep | NC | 1831-12-05 | 1833-03-03 | Whig | 13 | |||||||||||||
5061 | 5061 | Edward White W000365 | rep | LA | 1831-12-05 | 1833-03-03 | Whig | 1 | |||||||||||||
5050 | 5050 | Aaron Ward W000125 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 4 | |||||||||||||
5004 | 5004 | William Slade S000475 | rep | VT | 1831-12-05 | 1833-03-03 | Anti Masonic | 2 | |||||||||||||
4997 | 4997 | Charles Sewall S000258 | rep | MD | 1831-12-05 | 1833-03-03 | Jackson | 6 | |||||||||||||
4983 | 4983 | William Russell R000540 | rep | OH | 1831-12-05 | 1833-03-03 | Jackson | 5 | |||||||||||||
4956 | 4956 | Abraham Rencher R000162 | rep | NC | 1831-12-05 | 1833-03-03 | Jackson | 10 | |||||||||||||
4891 | 4891 | Thomas McKennan M000501 | rep | PA | 1831-12-05 | 1833-03-03 | Anti Masonic | 15 | |||||||||||||
4853 | 4853 | John Kerr K000139 | rep | MD | 1831-12-05 | 1833-03-03 | Whig | 7 | |||||||||||||
4815 | 4815 | Hiland Hall H000052 | rep | VT | 1831-12-05 | 1833-03-03 | Anti Jacksonian | 1 | |||||||||||||
4794 | 4794 | Thomas Foster F000314 | rep | GA | 1831-12-05 | 1833-03-03 | Jackson | -1 | |||||||||||||
4781 | 4781 | Horace Everett E000265 | rep | VT | 1831-12-05 | 1833-03-03 | Whig | 3 | |||||||||||||
4774 | 4774 | George Evans E000241 | rep | ME | 1831-12-05 | 1833-03-03 | Whig | 4 | |||||||||||||
4741 | 4741 | Rufus Choate C000375 | rep | MA | 1831-12-05 | 1833-03-03 | Whig | 2 | |||||||||||||
4707 | 4707 | George Briggs B000830 | rep | MA | 1831-12-05 | 1833-03-03 | Whig | 9 | |||||||||||||
4689 | 4689 | Isaac Bates B000233 | rep | MA | 1831-12-05 | 1833-03-03 | Whig | 8 | |||||||||||||
4676 | 4676 | Thomas Arnold A000297 | rep | TN | 1831-12-05 | 1833-03-03 | Anti Jacksonian | 2 | |||||||||||||
4673 | 4673 | William Archer A000275 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 3 | |||||||||||||
4665 | 4665 | Nathan Appleton A000269 | rep | MA | 1831-12-05 | 1833-03-03 | Anti Jacksonian | 1 | |||||||||||||
4643 | 4643 | John Worthington W000748 | rep | MD | 1831-12-05 | 1833-03-03 | Jackson | 5 | |||||||||||||
4617 | 4617 | William Storrs S000977 | rep | CT | 1831-12-05 | 1833-03-03 | Whig | -1 | |||||||||||||
4591 | 4591 | John Reed R000121 | rep | MA | 1831-12-05 | 1833-03-03 | Whig | 13 | |||||||||||||
4553 | 4553 | Charles Mercer M000642 | rep | VA | 1831-12-05 | 1833-03-03 | Whig | 14 | |||||||||||||
4521 | 4521 | Daniel Jenifer J000078 | rep | MD | 1831-12-05 | 1833-03-03 | Anti Jacksonian | 1 | |||||||||||||
4505 | 4505 | Micajah Hawkins H000373 | rep | NC | 1831-12-05 | 1833-03-03 | Jackson | 6 | |||||||||||||
4486 | 4486 | John Griffin G000462 | rep | SC | 1831-12-05 | 1833-03-03 | Nullifier | 9 | |||||||||||||
4439 | 4439 | Robert Craig C000859 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 20 | |||||||||||||
4430 | 4430 | Henry Connor C000700 | rep | NC | 1831-12-05 | 1833-03-03 | Jackson | 11 | |||||||||||||
4414 | 4414 | John Carr C000177 | rep | IN | 1831-12-05 | 1833-03-03 | Jackson | 2 | |||||||||||||
4379 | 4379 | Elisha Whittlesey W000431 | rep | OH | 1831-12-05 | 1833-03-03 | Whig | 13 | |||||||||||||
4358 | 4358 | James Standifer S000789 | rep | TN | 1831-12-05 | 1833-03-03 | Jackson | 3 | |||||||||||||
4326 | 4326 | Samuel Prentiss P000510 | sen | VT | 1831-12-05 | 1837-03-03 | 3 | Anti-Jacksonian | |||||||||||||
4322 | 4322 | David, Potts P000472 | rep | PA | 1831-12-05 | 1833-03-03 | Anti Masonic | 4 | |||||||||||||
4313 | 4313 | John Patton P000140 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 11 | |||||||||||||
4298 | 4298 | Henry Muhlenberg M001065 | rep | PA | 1831-12-05 | 1833-03-03 | Jackson | 7 | |||||||||||||
4286 | 4286 | John Milligan M000767 | rep | DE | 1831-12-05 | 1833-03-03 | Whig | 0 | |||||||||||||
4266 | 4266 | Wilson Lumpkin L000512 | rep | GA | 1831-12-05 | 1833-03-03 | Jackson | -1 | |||||||||||||
4239 | 4239 | Benjamin Howard H000835 | rep | MD | 1831-12-05 | 1833-03-03 | Jackson | 5 | |||||||||||||
4215 | 4215 | George Grennell G000451 | rep | MA | 1831-12-05 | 1833-03-03 | Whig | 7 | |||||||||||||
4173 | 4173 | Clement Clay C000481 | rep | AL | 1831-12-05 | 1833-03-03 | Jackson | 1 | |||||||||||||
4157 | 4157 | Churchill Cambreleng C000061 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 3 | |||||||||||||
4143 | 4143 | John Brodhead B000859 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 7 | |||||||||||||
4136 | 4136 | Ratliff Boon B000628 | rep | IN | 1831-12-05 | 1833-03-03 | Jackson | 1 | |||||||||||||
4126 | 4126 | Heman Allen A000123 | rep | VT | 1831-12-05 | 1833-03-03 | Whig | 4 | |||||||||||||
4118 | 4118 | John Spence S000719 | rep | MD | 1831-12-05 | 1833-03-03 | Anti-Jacksonian | 8 | |||||||||||||
4109 | 4109 | Joseph White W000383 | rep | FL | 1831-12-05 | 1833-03-03 | -1 | ||||||||||||||
4100 | 4100 | Campbell White W000358 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 3 | |||||||||||||
4096 | 4096 | James Wayne W000218 | rep | GA | 1831-12-05 | 1833-03-03 | Jackson | -1 | |||||||||||||
4093 | 4093 | George Washington W000179 | rep | MD | 1831-12-05 | 1833-03-03 | Anti Jacksonian | 3 | |||||||||||||
4088 | 4088 | Daniel Wardwell W000146 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 20 | |||||||||||||
4080 | 4080 | John Thomson T000230 | rep | OH | 1831-12-05 | 1833-03-03 | Jackson | 12 | |||||||||||||
4074 | 4074 | Joel Sutherland S001083 | rep | PA | 1831-12-05 | 1833-03-03 | Jackson | 1 | |||||||||||||
4059 | 4059 | William Shepard S000331 | rep | NC | 1831-12-05 | 1833-03-03 | Whig | 1 | |||||||||||||
4033 | 4033 | Dutee Pearce P000160 | rep | RI | 1831-12-05 | 1833-03-03 | Anti Mason | -1 | |||||||||||||
4012 | 4012 | Johnathan McCarty M000320 | rep | IN | 1831-12-05 | 1833-03-03 | Jackson | 3 | |||||||||||||
4006 | 4006 | John Mason M000220 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 2 | |||||||||||||
3983 | 3983 | Gerrit Lansing L000086 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 10 | |||||||||||||
3971 | 3971 | William Kennon K000123 | rep | OH | 1831-12-05 | 1833-03-03 | Jackson | 10 | |||||||||||||
3964 | 3964 | Richard Johnson J000170 | rep | KY | 1831-12-05 | 1833-03-03 | Jackson | 5 | |||||||||||||
3952 | 3952 | Leonard Jarvis J000062 | rep | ME | 1831-12-05 | 1833-03-03 | Jackson | 6 | |||||||||||||
3941 | 3941 | Henry Hubbard H000883 | rep | NH | 1831-12-05 | 1833-03-03 | Jackson | -1 | |||||||||||||
3935 | 3935 | William Hiester H000575 | rep | PA | 1831-12-05 | 1833-03-03 | Anti Masonic | 4 | |||||||||||||
3928 | 3928 | Albert Hawes H000360 | rep | KY | 1831-12-05 | 1833-03-03 | Jackson | 11 | |||||||||||||
3894 | 3894 | Ulysses Doubleday D000444 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 24 | |||||||||||||
3890 | 3890 | Harmar Denny D000248 | rep | PA | 1831-12-05 | 1833-03-03 | Anti Masonic | 16 | |||||||||||||
3886 | 3886 | Warren Davis D000142 | rep | SC | 1831-12-05 | 1833-03-03 | Nullifier | 6 | |||||||||||||
3881 | 3881 | Joseph Crane C000872 | rep | OH | 1831-12-05 | 1833-03-03 | Whig | 3 | |||||||||||||
3871 | 3871 | Nathaniel Claiborne C000405 | rep | VA | 1831-12-05 | 1833-03-03 | Jackson | 7 | |||||||||||||
3841 | 3841 | John Banks B000114 | rep | PA | 1831-12-05 | 1833-03-03 | Anti Masonic | 18 | |||||||||||||
3837 | 3837 | William Ashley A000315 | rep | MO | 1831-12-05 | 1833-03-03 | Jacksonian | 1 | |||||||||||||
3831 | 3831 | Chilton Allan A000108 | rep | KY | 1831-12-05 | 1833-03-03 | Whig | 3 | |||||||||||||
3827 | 3827 | Ebenezer Young Y000034 | rep | CT | 1831-12-05 | 1833-03-03 | -1 |
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);