legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
248 rows where "start" is on date 1829-12-07 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7885 | 7885 | Charles Wickliffe W000442 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 9 | |||||||||||||
6967 | 6967 | James Buchanan B001005 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 4 | |||||||||||||
6584 | 6584 | Edward Everett E000264 | rep | MA | 1829-12-07 | 1831-03-03 | Whig | 4 | |||||||||||||
6549 | 6549 | John Clayton C000496 | sen | DE | 1829-12-07 | 1835-03-03 | 2 | ||||||||||||||
6504 | 6504 | John Bell B000340 | rep | TN | 1829-12-07 | 1831-03-03 | Jackson | 7 | |||||||||||||
6180 | 6180 | Robert Barnwell B000168 | rep | SC | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
6158 | 6158 | Samuel Vinton V000107 | rep | OH | 1829-12-07 | 1831-03-03 | Whig | 7 | |||||||||||||
6115 | 6115 | Augustine Shepperd S000338 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 9 | |||||||||||||
5957 | 5957 | Edmund Deberry D000181 | rep | NC | 1829-12-07 | 1831-03-03 | Anti Jacksonian | 7 | |||||||||||||
5875 | 5875 | William King K000217 | sen | AL | 1829-12-07 | 1835-03-03 | 2 | Jackson | |||||||||||||
5755 | 5755 | Dixon Lewis L000278 | rep | AL | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
5665 | 5665 | John Davis D000117 | rep | MA | 1829-12-07 | 1831-03-03 | Whig | 5 | |||||||||||||
5559 | 5559 | Joseph Vance V000017 | rep | OH | 1829-12-07 | 1831-03-03 | Anti Jacksonian | 4 | |||||||||||||
5524 | 5524 | Jesse Speight S000715 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 4 | |||||||||||||
5449 | 5449 | Jabez Huntington H000997 | rep | CT | 1829-12-07 | 1831-03-03 | Whig | -1 | |||||||||||||
5350 | 5350 | James Polk P000409 | rep | TN | 1829-12-07 | 1831-03-03 | Jackson | 6 | |||||||||||||
5321 | 5321 | William Wilkins W000475 | rep | PA | 1829-12-07 | 1831-03-03 | Democrat | -1 | |||||||||||||
5290 | 5290 | Ambrose Sevier S000256 | rep | AR | 1829-12-07 | 1831-03-03 | Jacksonian | -1 | |||||||||||||
5225 | 5225 | Cave Johnson J000122 | rep | TN | 1829-12-07 | 1831-03-03 | Jackson | 8 | |||||||||||||
5154 | 5154 | John Campbell C000090 | rep | SC | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
5104 | 5104 | George McDuffie M000426 | rep | SC | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
5077 | 5077 | Lewis Williams W000527 | rep | NC | 1829-12-07 | 1831-03-03 | Whig | 13 | |||||||||||||
5060 | 5060 | Edward White W000365 | rep | LA | 1829-12-07 | 1831-03-03 | Whig | 1 | |||||||||||||
5025 | 5025 | John Taliaferro T000027 | rep | VA | 1829-12-07 | 1831-03-03 | Republican | 13 | |||||||||||||
4982 | 4982 | William Russell R000540 | rep | OH | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
4972 | 4972 | William Rives R000285 | rep | VA | 1829-12-07 | 1831-03-03 | Jacksonian | -1 | |||||||||||||
4955 | 4955 | Abraham Rencher R000162 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 10 | |||||||||||||
4793 | 4793 | Thomas Foster F000314 | rep | GA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
4780 | 4780 | Horace Everett E000265 | rep | VT | 1829-12-07 | 1831-03-03 | Whig | 3 | |||||||||||||
4773 | 4773 | George Evans E000241 | rep | ME | 1829-12-07 | 1831-03-03 | Whig | 4 | |||||||||||||
4735 | 4735 | Timothy Childs C000355 | rep | NY | 1829-12-07 | 1831-03-03 | Anti Masonic | 27 | |||||||||||||
4688 | 4688 | Isaac Bates B000233 | rep | MA | 1829-12-07 | 1831-03-03 | Whig | 8 | |||||||||||||
4672 | 4672 | William Archer A000275 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
4616 | 4616 | William Storrs S000977 | rep | CT | 1829-12-07 | 1831-03-03 | Whig | -1 | |||||||||||||
4590 | 4590 | John Reed R000121 | rep | MA | 1829-12-07 | 1831-03-03 | Whig | 13 | |||||||||||||
4552 | 4552 | Charles Mercer M000642 | rep | VA | 1829-12-07 | 1831-03-03 | Whig | 14 | |||||||||||||
4494 | 4494 | Felix Grundy G000509 | sen | TN | 1829-12-07 | 1833-03-03 | 1 | Jackson | |||||||||||||
4438 | 4438 | Robert Craig C000859 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 20 | |||||||||||||
4429 | 4429 | Henry Connor C000700 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
4378 | 4378 | Elisha Whittlesey W000431 | rep | OH | 1829-12-07 | 1831-03-03 | Whig | 13 | |||||||||||||
4357 | 4357 | James Standifer S000789 | rep | TN | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
4312 | 4312 | John Patton P000140 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
4297 | 4297 | Henry Muhlenberg M001065 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 7 | |||||||||||||
4265 | 4265 | Wilson Lumpkin L000512 | rep | GA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
4238 | 4238 | Benjamin Howard H000835 | rep | MD | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
4229 | 4229 | Charles Haynes H000399 | rep | GA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
4214 | 4214 | George Grennell G000451 | rep | MA | 1829-12-07 | 1831-03-03 | Whig | 7 | |||||||||||||
4172 | 4172 | Clement Clay C000481 | rep | AL | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
4156 | 4156 | Churchill Cambreleng C000061 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
4135 | 4135 | Ratliff Boon B000628 | rep | IN | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
4108 | 4108 | Joseph White W000383 | rep | FL | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
4104 | 4104 | Hugh White W000376 | sen | TN | 1829-12-07 | 1835-03-03 | 2 | Jackson | |||||||||||||
4099 | 4099 | Campbell White W000358 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
4095 | 4095 | James Wayne W000218 | rep | GA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
4092 | 4092 | George Washington W000179 | rep | MD | 1829-12-07 | 1831-03-03 | Anti Jacksonian | 3 | |||||||||||||
4079 | 4079 | John Thomson T000230 | rep | OH | 1829-12-07 | 1831-03-03 | Jackson | 12 | |||||||||||||
4073 | 4073 | Joel Sutherland S001083 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
4058 | 4058 | William Shepard S000331 | rep | NC | 1829-12-07 | 1831-03-03 | Whig | 1 | |||||||||||||
4047 | 4047 | John Roane R000291 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 12 | |||||||||||||
4032 | 4032 | Dutee Pearce P000160 | rep | RI | 1829-12-07 | 1831-03-03 | Anti Mason | -1 | |||||||||||||
3997 | 3997 | George Loyall L000488 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3979 | 3979 | Nehemiah Knight K000287 | sen | RI | 1829-12-07 | 1835-03-03 | 2 | Whig | |||||||||||||
3970 | 3970 | William Kennon K000123 | rep | OH | 1829-12-07 | 1831-03-03 | Jackson | 10 | |||||||||||||
3963 | 3963 | Richard Johnson J000170 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3951 | 3951 | Leonard Jarvis J000062 | rep | ME | 1829-12-07 | 1831-03-03 | Jackson | 6 | |||||||||||||
3940 | 3940 | Henry Hubbard H000883 | rep | NH | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
3889 | 3889 | Harmar Denny D000248 | rep | PA | 1829-12-07 | 1831-03-03 | Anti Masonic | 16 | |||||||||||||
3885 | 3885 | Warren Davis D000142 | rep | SC | 1829-12-07 | 1831-03-03 | Jackson | 6 | |||||||||||||
3880 | 3880 | Joseph Crane C000872 | rep | OH | 1829-12-07 | 1831-03-03 | Whig | 3 | |||||||||||||
3870 | 3870 | Nathaniel Claiborne C000405 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 7 | |||||||||||||
3853 | 3853 | Bedford Brown B000903 | sen | NC | 1829-12-07 | 1835-03-03 | 2 | Jackson | |||||||||||||
3849 | 3849 | Abraham Bockee B000581 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3826 | 3826 | Ebenezer Young Y000034 | rep | CT | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3822 | 3822 | Richard Wilde W000460 | rep | GA | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
3805 | 3805 | Benjamin Swift S001116 | rep | VT | 1829-12-07 | 1831-03-03 | Whig | 4 | |||||||||||||
3800 | 3800 | Andrew Stevenson S000891 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 9 | |||||||||||||
3747 | 3747 | Rufus McIntire M000479 | rep | ME | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3744 | 3744 | Henry Martindale M000204 | rep | NY | 1829-12-07 | 1831-03-03 | Anti Mason | 18 | |||||||||||||
3731 | 3731 | Chittenden Lyon L000541 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 12 | |||||||||||||
3726 | 3726 | Robert Letcher L000257 | rep | KY | 1829-12-07 | 1831-03-03 | 4 | ||||||||||||||
3720 | 3720 | Humphrey Leavitt L000183 | rep | OH | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
3696 | 3696 | Thomas Hall H000072 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
3689 | 3689 | Benjamin Gorham G000324 | rep | MA | 1829-12-07 | 1831-03-03 | Anti Jacksonian | 1 | |||||||||||||
3683 | 3683 | William Gordon G000319 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 10 | |||||||||||||
3669 | 3669 | William Ellsworth E000150 | rep | CT | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3666 | 3666 | Joseph Duncan D000535 | rep | IL | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3655 | 3655 | Thomas Davenport D000079 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 6 | |||||||||||||
3651 | 3651 | David Crockett C000918 | rep | TN | 1829-12-07 | 1831-03-03 | Anti Jacksonian | 9 | |||||||||||||
3647 | 3647 | Richard Coulter C000808 | rep | PA | 1829-12-07 | 1831-03-03 | Jackson | 17 | |||||||||||||
3640 | 3640 | Thomas Chilton C000359 | rep | KY | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
3634 | 3634 | Tristam Burges B001082 | rep | RI | 1829-12-07 | 1831-03-03 | Anti Jacksonian | -1 | |||||||||||||
3626 | 3626 | Thomas Bouldin B000663 | rep | VA | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3622 | 3622 | John Blair B000528 | rep | TN | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3616 | 3616 | James Blair B000526 | rep | SC | 1829-12-07 | 1831-03-03 | Jackson | 8 | |||||||||||||
3605 | 3605 | Daniel Barringer B000181 | rep | NC | 1829-12-07 | 1831-03-03 | Jackson | 8 | |||||||||||||
3599 | 3599 | Noyes Barber B000125 | rep | CT | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3581 | 3581 | John Weeks W000245 | rep | NH | 1829-12-07 | 1831-03-03 | Jackson | -1 | |||||||||||||
3578 | 3578 | Gulian Verplanck V000089 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
3574 | 3574 | Phineas Tracy T000346 | rep | NY | 1829-12-07 | 1831-03-03 | Anti Masonic | 29 | |||||||||||||
3566 | 3566 | Wiley Thompson T000222 | rep | GA | 1829-12-07 | 1831-03-03 | Jackson | -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);