legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
281 rows where "end" is on date 1835-03-03 sorted by office
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3054 | 3054 | Samuel Bell B000345 | sen | NH | 1829-12-07 | 1835-03-03 | 2 | ||||||||||||||
3056 | 3056 | George Bibb B000433 | sen | KY | 1829-12-07 | 1835-03-03 | 2 | Jackson | |||||||||||||
3104 | 3104 | Theodore Frelinghuysen F000373 | sen | NJ | 1829-12-07 | 1835-03-03 | 2 | Anti-Jacksonian | |||||||||||||
3209 | 3209 | Nathaniel Silsbee S000411 | sen | MA | 1829-12-07 | 1835-03-03 | 2 | Adams | |||||||||||||
3220 | 3220 | Peleg Sprague S000744 | sen | ME | 1829-12-07 | 1835-03-03 | 2 | Anti-Jacksonian | |||||||||||||
3283 | 3283 | George Poindexter P000402 | sen | MS | 1830-01-01 | 1835-03-03 | 2 | Jackson | |||||||||||||
3332 | 3332 | Ezekiel Chambers C000282 | sen | MD | 1831-12-05 | 1835-03-03 | 3 | Adams | |||||||||||||
3580 | 3580 | George Waggaman W000017 | sen | LA | 1831-12-05 | 1835-03-03 | 2 | Anti-Jacksonian | |||||||||||||
3593 | 3593 | John Adams A000038 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 8 | |||||||||||||
3594 | 3594 | John Allen A000132 | rep | VA | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 20 | |||||||||||||
3601 | 3601 | Noyes Barber B000125 | rep | CT | 1833-12-02 | 1835-03-03 | -1 | ||||||||||||||
3602 | 3602 | Charles Barnitz B000165 | rep | PA | 1833-12-02 | 1835-03-03 | Anti Masonic | 11 | |||||||||||||
3607 | 3607 | Daniel Barringer B000181 | rep | NC | 1833-12-02 | 1835-03-03 | 8 | ||||||||||||||
3611 | 3611 | William Baylies B000256 | rep | MA | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 10 | |||||||||||||
3612 | 3612 | Martin Beaty B000285 | rep | KY | 1833-12-02 | 1835-03-03 | Anti Jackson | 4 | |||||||||||||
3613 | 3613 | James Bell B000338 | rep | OH | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 11 | |||||||||||||
3614 | 3614 | Horace Binney B000475 | rep | PA | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 2 | |||||||||||||
3618 | 3618 | James Blair B000526 | rep | SC | 1833-12-02 | 1835-03-03 | Jackson | 8 | |||||||||||||
3624 | 3624 | John Blair B000528 | rep | TN | 1833-12-02 | 1835-03-03 | Jackson | 1 | |||||||||||||
3625 | 3625 | Charles Bodle B000585 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 7 | |||||||||||||
3628 | 3628 | Thomas Bouldin B000663 | rep | VA | 1833-12-02 | 1835-03-03 | Jackson | 5 | |||||||||||||
3629 | 3629 | John Bull B001046 | rep | MO | 1833-12-02 | 1835-03-03 | -1 | ||||||||||||||
3631 | 3631 | George Burd B001073 | rep | PA | 1833-12-02 | 1835-03-03 | 18 | ||||||||||||||
3636 | 3636 | Tristam Burges B001082 | rep | RI | 1833-12-02 | 1835-03-03 | Anti Jacksonian | -1 | |||||||||||||
3637 | 3637 | Harry Cage C000018 | rep | MS | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
3638 | 3638 | Richard Carmichael C000160 | rep | MD | 1833-12-02 | 1835-03-03 | Jackson | 2 | |||||||||||||
3641 | 3641 | Thomas Chilton C000359 | rep | KY | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 6 | |||||||||||||
3643 | 3643 | Joseph Chinn C000362 | rep | VA | 1833-12-02 | 1835-03-03 | Jackson | 10 | |||||||||||||
3645 | 3645 | Augustin Clayton C000491 | rep | GA | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
3649 | 3649 | Richard Coulter C000808 | rep | PA | 1833-12-02 | 1835-03-03 | Jackson | 19 | |||||||||||||
3652 | 3652 | David Crockett C000918 | rep | TN | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 12 | |||||||||||||
3657 | 3657 | Thomas Davenport D000079 | rep | VA | 1833-12-02 | 1835-03-03 | Anti-Jacksonian | 6 | |||||||||||||
3658 | 3658 | Amos Davis D000092 | rep | KY | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 11 | |||||||||||||
3660 | 3660 | Rowland Day D000159 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 24 | |||||||||||||
3661 | 3661 | Benjamin Deming D000226 | rep | VT | 1833-12-02 | 1835-03-03 | Anti Masonic | 5 | |||||||||||||
3662 | 3662 | Littleton Dennis D000245 | rep | MD | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 1 | |||||||||||||
3664 | 3664 | John Dickson D000330 | rep | NY | 1833-12-02 | 1835-03-03 | Anti Masonic | 26 | |||||||||||||
3668 | 3668 | Joseph Duncan D000535 | rep | IL | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
3671 | 3671 | William Ellsworth E000150 | rep | CT | 1833-12-02 | 1835-03-03 | -1 | ||||||||||||||
3673 | 3673 | John Felder F000064 | rep | SC | 1833-12-02 | 1835-03-03 | Nullifier | 4 | |||||||||||||
3678 | 3678 | John Fulton F000423 | rep | VA | 1833-12-02 | 1835-03-03 | Jackson | 18 | |||||||||||||
3679 | 3679 | James Gholson G000148 | rep | VA | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 4 | |||||||||||||
3682 | 3682 | George Gilmer G000216 | rep | GA | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
3685 | 3685 | William Gordon G000319 | rep | VA | 1833-12-02 | 1835-03-03 | Jackson | 12 | |||||||||||||
3690 | 3690 | Benjamin Gorham G000324 | rep | MA | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 1 | |||||||||||||
3698 | 3698 | Thomas Hall H000072 | rep | NC | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
3699 | 3699 | Nicoll Halsey H000089 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 22 | |||||||||||||
3701 | 3701 | Joseph Harper H000224 | rep | NH | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
3702 | 3702 | Samuel Hathaway H000345 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 22 | |||||||||||||
3703 | 3703 | James Heath H000430 | rep | MD | 1833-12-02 | 1835-03-03 | Jackson | 4 | |||||||||||||
3704 | 3704 | Edward Howell H000860 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 27 | |||||||||||||
3705 | 3705 | William Inge I000014 | rep | TN | 1833-12-02 | 1835-03-03 | Jackson | 10 | |||||||||||||
3706 | 3706 | Ebenezer Jackson J000009 | rep | CT | 1833-12-02 | 1835-03-03 | -1 | ||||||||||||||
3707 | 3707 | Noadiah Johnson J000164 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 20 | |||||||||||||
3709 | 3709 | Edward Kavanagh K000022 | rep | ME | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
3718 | 3718 | Henry King K000202 | rep | PA | 1833-12-02 | 1835-03-03 | Jackson | 8 | |||||||||||||
3719 | 3719 | Cornelius Lawrence L000131 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
3722 | 3722 | Humphrey Leavitt L000183 | rep | OH | 1833-12-02 | 1835-03-03 | Jackson | 19 | |||||||||||||
3728 | 3728 | Robert Letcher L000257 | rep | KY | 1833-12-02 | 1835-03-03 | 5 | ||||||||||||||
3729 | 3729 | James Love L000455 | rep | KY | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 9 | |||||||||||||
3733 | 3733 | Chittenden Lyon L000541 | rep | KY | 1833-12-02 | 1835-03-03 | Jackson | 1 | |||||||||||||
3734 | 3734 | Robert Lytle L000546 | rep | OH | 1833-12-02 | 1835-03-03 | Jackson | 1 | |||||||||||||
3736 | 3736 | Joel Mann M000107 | rep | PA | 1833-12-02 | 1835-03-03 | Jackson | 5 | |||||||||||||
3738 | 3738 | Samuel Mardis M000128 | rep | AL | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
3740 | 3740 | Thomas Marshall M000161 | rep | KY | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 12 | |||||||||||||
3745 | 3745 | Henry Martindale M000204 | rep | NY | 1833-12-02 | 1835-03-03 | Anti Masonic | 12 | |||||||||||||
3749 | 3749 | Rufus McIntire M000479 | rep | ME | 1833-12-02 | 1835-03-03 | Jackson | 1 | |||||||||||||
3754 | 3754 | Charles McVean M000607 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 15 | |||||||||||||
3755 | 3755 | Phineas Miner M000793 | rep | CT | 1833-12-02 | 1835-03-03 | -1 | ||||||||||||||
3756 | 3756 | Henry Mitchell M000813 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 21 | |||||||||||||
3757 | 3757 | Robert Mitchell M000827 | rep | OH | 1833-12-02 | 1835-03-03 | Jackson | 12 | |||||||||||||
3758 | 3758 | Samuel Moore M000917 | rep | VA | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 17 | |||||||||||||
3761 | 3761 | John Morgan M000953 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
3763 | 3763 | John Murphy M001097 | rep | AL | 1833-12-02 | 1835-03-03 | Jackson | 5 | |||||||||||||
3766 | 3766 | Gayton Osgood O000115 | rep | MA | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
3768 | 3768 | Job Pierson P000343 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 9 | |||||||||||||
3770 | 3770 | Franklin Plummer P000397 | rep | MS | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
3771 | 3771 | Patrick Pope P000433 | rep | KY | 1833-12-02 | 1835-03-03 | Jackson | 8 | |||||||||||||
3787 | 3787 | John Randolph R000047 | rep | VA | 1833-12-02 | 1835-03-03 | -1 | ||||||||||||||
3791 | 3791 | Dudley Selden S000233 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
3793 | 3793 | Thomas Singleton S000446 | rep | SC | 1833-12-02 | 1835-03-03 | Nullifier | -1 | |||||||||||||
3794 | 3794 | Charles Slade S000474 | rep | IL | 1833-12-02 | 1835-03-03 | Jackson | 1 | |||||||||||||
3802 | 3802 | Andrew Stevenson S000891 | rep | VA | 1833-12-02 | 1835-03-03 | Jackson | 11 | |||||||||||||
3803 | 3803 | John Stoddert S000944 | rep | MD | 1833-12-02 | 1835-03-03 | Jackson | 8 | |||||||||||||
3807 | 3807 | William Taylor T000105 | rep | VA | 1833-12-02 | 1835-03-03 | Anti-Jacksonian | 9 | |||||||||||||
3809 | 3809 | Philemon Thomas T000181 | rep | LA | 1833-12-02 | 1835-03-03 | 2 | ||||||||||||||
3811 | 3811 | Christopher Tompkins T000304 | rep | KY | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 3 | |||||||||||||
3812 | 3812 | Samuel Tweedy T000442 | rep | CT | 1833-12-02 | 1835-03-03 | Anti Jacksonian | -1 | |||||||||||||
3813 | 3813 | Isaac Van Houten V000046 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 2 | |||||||||||||
3815 | 3815 | John Watmough W000195 | rep | PA | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 3 | |||||||||||||
3816 | 3816 | Reuben Whallon W000321 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 13 | |||||||||||||
3818 | 3818 | Frederick Whittlesey W000432 | rep | NY | 1833-12-02 | 1835-03-03 | Anti Masonic | 28 | |||||||||||||
3824 | 3824 | Richard Wilde W000460 | rep | GA | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
3825 | 3825 | Edgar Wilson W000574 | rep | VA | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 21 | |||||||||||||
3828 | 3828 | Ebenezer Young Y000034 | rep | CT | 1833-12-02 | 1835-03-03 | -1 | ||||||||||||||
3829 | 3829 | Benjamin Leigh L000232 | sen | VA | 1834-02-26 | 1835-03-03 | 2 | Anti-Jacksonian | |||||||||||||
3832 | 3832 | Chilton Allan A000108 | rep | KY | 1833-12-02 | 1835-03-03 | Whig | 10 | |||||||||||||
3834 | 3834 | Joseph Anthony A000263 | rep | PA | 1833-12-02 | 1835-03-03 | Jackson | 16 | |||||||||||||
3838 | 3838 | William Ashley A000315 | rep | MO | 1833-12-02 | 1835-03-03 | Jacksonian | -1 | |||||||||||||
3842 | 3842 | John Banks B000114 | rep | PA | 1833-12-02 | 1835-03-03 | Anti Masonic | 24 |
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);