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 state
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3738 | 3738 | Samuel Mardis M000128 | rep | AL | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
3763 | 3763 | John Murphy M001097 | rep | AL | 1833-12-02 | 1835-03-03 | Jackson | 5 | |||||||||||||
4174 | 4174 | Clement Clay C000481 | rep | AL | 1833-12-02 | 1835-03-03 | Jackson | 1 | |||||||||||||
4283 | 4283 | John McKinley M000519 | rep | AL | 1833-12-02 | 1835-03-03 | Jackson | 2 | |||||||||||||
5757 | 5757 | Dixon Lewis L000278 | rep | AL | 1833-12-02 | 1835-03-03 | Nullifier | 4 | |||||||||||||
5875 | 5875 | William King K000217 | sen | AL | 1829-12-07 | 1835-03-03 | 2 | Jackson | |||||||||||||
5292 | 5292 | Ambrose Sevier S000256 | rep | AR | 1833-12-02 | 1835-03-03 | Jacksonian | -1 | |||||||||||||
3601 | 3601 | Noyes Barber B000125 | rep | CT | 1833-12-02 | 1835-03-03 | -1 | ||||||||||||||
3671 | 3671 | William Ellsworth E000150 | rep | CT | 1833-12-02 | 1835-03-03 | -1 | ||||||||||||||
3706 | 3706 | Ebenezer Jackson J000009 | rep | CT | 1833-12-02 | 1835-03-03 | -1 | ||||||||||||||
3755 | 3755 | Phineas Miner M000793 | rep | CT | 1833-12-02 | 1835-03-03 | -1 | ||||||||||||||
3812 | 3812 | Samuel Tweedy T000442 | rep | CT | 1833-12-02 | 1835-03-03 | Anti Jacksonian | -1 | |||||||||||||
3828 | 3828 | Ebenezer Young Y000034 | rep | CT | 1833-12-02 | 1835-03-03 | -1 | ||||||||||||||
5040 | 5040 | Joseph Trumbull T000391 | rep | CT | 1833-12-02 | 1835-03-03 | Whig | -1 | |||||||||||||
5451 | 5451 | Jabez Huntington H000997 | rep | CT | 1833-12-02 | 1835-03-03 | Whig | -1 | |||||||||||||
4287 | 4287 | John Milligan M000767 | rep | DE | 1833-12-02 | 1835-03-03 | Whig | 0 | |||||||||||||
6549 | 6549 | John Clayton C000496 | sen | DE | 1829-12-07 | 1835-03-03 | 2 | ||||||||||||||
4110 | 4110 | Joseph White W000383 | rep | FL | 1833-12-02 | 1835-03-03 | -1 | ||||||||||||||
3645 | 3645 | Augustin Clayton C000491 | rep | GA | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
3682 | 3682 | George Gilmer G000216 | rep | GA | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
3824 | 3824 | Richard Wilde W000460 | rep | GA | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
3876 | 3876 | John Coffee C000583 | rep | GA | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
3973 | 3973 | John King K000207 | sen | GA | 1833-12-02 | 1835-03-03 | 2 | Jackson | |||||||||||||
4055 | 4055 | William Schley S000130 | rep | GA | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
4097 | 4097 | James Wayne W000218 | rep | GA | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
4188 | 4188 | Alfred Cuthbert C001023 | rep | GA | 1833-12-02 | 1835-03-03 | Republican | -1 | |||||||||||||
4795 | 4795 | Thomas Foster F000314 | rep | GA | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
4799 | 4799 | Roger Gamble G000033 | rep | GA | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
5462 | 5462 | Seaborn Jones J000252 | rep | GA | 1833-12-02 | 1835-03-03 | Jackson | -1 | |||||||||||||
3668 | 3668 | Joseph Duncan D000535 | rep | IL | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
3794 | 3794 | Charles Slade S000474 | rep | IL | 1833-12-02 | 1835-03-03 | Jackson | 1 | |||||||||||||
4049 | 4049 | John Robinson R000344 | sen | IL | 1830-01-01 | 1835-03-03 | 2 | Jackson | |||||||||||||
4274 | 4274 | William May M000277 | rep | IL | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
4730 | 4730 | Zadok Casey C000230 | rep | IL | 1833-12-02 | 1835-03-03 | Jackson | 2 | |||||||||||||
4961 | 4961 | John Reynolds R000174 | rep | IL | 1833-12-02 | 1835-03-03 | Jackson | 1 | |||||||||||||
3975 | 3975 | George Kinnard K000224 | rep | IN | 1833-12-02 | 1835-03-03 | Jackson | 6 | |||||||||||||
3981 | 3981 | Amos Lane L000057 | rep | IN | 1833-12-02 | 1835-03-03 | Jackson | 4 | |||||||||||||
4013 | 4013 | Johnathan McCarty M000320 | rep | IN | 1833-12-02 | 1835-03-03 | Jackson | 5 | |||||||||||||
4137 | 4137 | Ratliff Boon B000628 | rep | IN | 1833-12-02 | 1835-03-03 | Jackson | 1 | |||||||||||||
4198 | 4198 | John Ewing E000277 | rep | IN | 1833-12-02 | 1835-03-03 | Whig | 2 | |||||||||||||
4415 | 4415 | John Carr C000177 | rep | IN | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
3056 | 3056 | George Bibb B000433 | sen | KY | 1829-12-07 | 1835-03-03 | 2 | Jackson | |||||||||||||
3612 | 3612 | Martin Beaty B000285 | rep | KY | 1833-12-02 | 1835-03-03 | Anti Jackson | 4 | |||||||||||||
3641 | 3641 | Thomas Chilton C000359 | rep | KY | 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 | |||||||||||||
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 | |||||||||||||
3740 | 3740 | Thomas Marshall M000161 | rep | KY | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 12 | |||||||||||||
3771 | 3771 | Patrick Pope P000433 | rep | KY | 1833-12-02 | 1835-03-03 | Jackson | 8 | |||||||||||||
3811 | 3811 | Christopher Tompkins T000304 | rep | KY | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 3 | |||||||||||||
3832 | 3832 | Chilton Allan A000108 | rep | KY | 1833-12-02 | 1835-03-03 | Whig | 10 | |||||||||||||
3922 | 3922 | Benjamin Hardin H000184 | rep | KY | 1833-12-02 | 1835-03-03 | Whig | 7 | |||||||||||||
3929 | 3929 | Albert Hawes H000360 | rep | KY | 1833-12-02 | 1835-03-03 | Jackson | 2 | |||||||||||||
3965 | 3965 | Richard Johnson J000170 | rep | KY | 1833-12-02 | 1835-03-03 | Jackson | 13 | |||||||||||||
3580 | 3580 | George Waggaman W000017 | sen | LA | 1831-12-05 | 1835-03-03 | 2 | Anti-Jacksonian | |||||||||||||
3809 | 3809 | Philemon Thomas T000181 | rep | LA | 1833-12-02 | 1835-03-03 | 2 | ||||||||||||||
4479 | 4479 | Rice Garland G000070 | rep | LA | 1833-12-02 | 1835-03-03 | Anti-Jacksonian | 3 | |||||||||||||
5062 | 5062 | Edward White W000365 | rep | LA | 1833-12-02 | 1835-03-03 | Whig | 1 | |||||||||||||
5344 | 5344 | Henry Johnson J000137 | rep | LA | 1833-12-02 | 1835-03-03 | Whig | 1 | |||||||||||||
5918 | 5918 | Henry Bullard B001049 | rep | LA | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 3 | |||||||||||||
3209 | 3209 | Nathaniel Silsbee S000411 | sen | MA | 1829-12-07 | 1835-03-03 | 2 | Adams | |||||||||||||
3611 | 3611 | William Baylies B000256 | rep | MA | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 10 | |||||||||||||
3690 | 3690 | Benjamin Gorham G000324 | rep | MA | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 1 | |||||||||||||
3766 | 3766 | Gayton Osgood O000115 | rep | MA | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
3947 | 3947 | William Jackson J000028 | rep | MA | 1833-12-02 | 1835-03-03 | Anti Masonic | 9 | |||||||||||||
4216 | 4216 | George Grennell G000451 | rep | MA | 1833-12-02 | 1835-03-03 | Whig | 6 | |||||||||||||
4319 | 4319 | Stephen Phillips P000312 | rep | MA | 1833-12-02 | 1835-03-03 | Whig | 2 | |||||||||||||
4592 | 4592 | John Reed R000121 | rep | MA | 1833-12-02 | 1835-03-03 | Whig | 11 | |||||||||||||
4690 | 4690 | Isaac Bates B000233 | rep | MA | 1833-12-02 | 1835-03-03 | Whig | 8 | |||||||||||||
4708 | 4708 | George Briggs B000830 | rep | MA | 1833-12-02 | 1835-03-03 | Whig | 7 | |||||||||||||
4742 | 4742 | Rufus Choate C000375 | rep | MA | 1833-12-02 | 1835-03-03 | Whig | 2 | |||||||||||||
4858 | 4858 | Levi Lincoln L000315 | rep | MA | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 5 | |||||||||||||
5593 | 5593 | John Adams A000041 | rep | MA | 1833-12-02 | 1835-03-03 | Anti Masonic | 12 | |||||||||||||
5667 | 5667 | John Davis D000117 | rep | MA | 1833-12-02 | 1835-03-03 | Whig | 5 | |||||||||||||
6586 | 6586 | Edward Everett E000264 | rep | MA | 1833-12-02 | 1835-03-03 | Whig | 4 | |||||||||||||
3332 | 3332 | Ezekiel Chambers C000282 | sen | MD | 1831-12-05 | 1835-03-03 | 3 | Adams | |||||||||||||
3638 | 3638 | Richard Carmichael C000160 | rep | MD | 1833-12-02 | 1835-03-03 | Jackson | 2 | |||||||||||||
3662 | 3662 | Littleton Dennis D000245 | rep | MD | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 1 | |||||||||||||
3703 | 3703 | James Heath H000430 | rep | MD | 1833-12-02 | 1835-03-03 | Jackson | 4 | |||||||||||||
3803 | 3803 | John Stoddert S000944 | rep | MD | 1833-12-02 | 1835-03-03 | Jackson | 8 | |||||||||||||
4069 | 4069 | John Steele S000834 | rep | MD | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 1 | |||||||||||||
4083 | 4083 | James Turner T000422 | rep | MD | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
4279 | 4279 | Isaac McKim M000516 | rep | MD | 1833-12-02 | 1835-03-03 | Jackson | 5 | |||||||||||||
4843 | 4843 | William Johnson J000180 | rep | MD | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 6 | |||||||||||||
8461 | 8461 | Francis Thomas T000166 | rep | MD | 1833-12-02 | 1835-03-03 | Jackson | 7 | |||||||||||||
3220 | 3220 | Peleg Sprague S000744 | sen | ME | 1829-12-07 | 1835-03-03 | 2 | Anti-Jacksonian | |||||||||||||
3709 | 3709 | Edward Kavanagh K000022 | rep | ME | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
3749 | 3749 | Rufus McIntire M000479 | rep | ME | 1833-12-02 | 1835-03-03 | Jackson | 1 | |||||||||||||
3915 | 3915 | Joseph Hall H000056 | rep | ME | 1833-12-02 | 1835-03-03 | Jackson | 6 | |||||||||||||
3953 | 3953 | Leonard Jarvis J000062 | rep | ME | 1833-12-02 | 1835-03-03 | Jackson | 7 | |||||||||||||
4009 | 4009 | Moses Mason M000223 | rep | ME | 1833-12-02 | 1835-03-03 | Jackson | 5 | |||||||||||||
4026 | 4026 | Gorham Parks P000074 | rep | ME | 1833-12-02 | 1835-03-03 | Jackson | 7 | |||||||||||||
4347 | 4347 | Francis Smith S000531 | rep | ME | 1833-12-02 | 1835-03-03 | Jackson | 2 | |||||||||||||
4775 | 4775 | George Evans E000241 | rep | ME | 1833-12-02 | 1835-03-03 | Whig | 4 | |||||||||||||
5247 | 5247 | Lucius Lyon L000544 | rep | MI | 1833-12-02 | 1835-03-03 | Democrat | -1 | |||||||||||||
3629 | 3629 | John Bull B001046 | rep | MO | 1833-12-02 | 1835-03-03 | -1 | ||||||||||||||
3838 | 3838 | William Ashley A000315 | rep | MO | 1833-12-02 | 1835-03-03 | Jacksonian | -1 | |||||||||||||
3283 | 3283 | George Poindexter P000402 | sen | MS | 1830-01-01 | 1835-03-03 | 2 | Jackson | |||||||||||||
3637 | 3637 | Harry Cage C000018 | rep | MS | 1833-12-02 | 1835-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);