legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,123 rows where state = "TN"
This data as json, copyable, CSV (advanced)
party 12 ✖
- Democrat 611
- Republican 276
- Whig 66
- Jackson 31
- American 9
- Ind. Republican-Democrat 8
- Unionist 8
- Jacksonian 4
- Anti Jacksonian 3
- Unconditional Unionist 3
- Ind. Democrat 2
- Anti-Jacksonian 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3650 | 3650 | David Crockett C000918 | rep | TN | 1827-12-03 | 1829-03-03 | Jackson | 9 | |||||||||||||
3651 | 3651 | David Crockett C000918 | rep | TN | 1829-12-07 | 1831-03-03 | Anti Jacksonian | 9 | |||||||||||||
3652 | 3652 | David Crockett C000918 | rep | TN | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 12 | |||||||||||||
3705 | 3705 | William Inge I000014 | rep | TN | 1833-12-02 | 1835-03-03 | Jackson | 10 | |||||||||||||
3857 | 3857 | Samuel Bunch B001058 | rep | TN | 1833-12-02 | 1835-03-03 | Jackson | 2 | |||||||||||||
3858 | 3858 | Samuel Bunch B001058 | rep | TN | 1835-12-07 | 1837-03-03 | Jacksonian | 2 | |||||||||||||
3896 | 3896 | William Dunlap D000544 | rep | TN | 1833-12-02 | 1835-03-03 | Jackson | 13 | |||||||||||||
3897 | 3897 | William Dunlap D000544 | rep | TN | 1835-12-07 | 1837-03-03 | Jackson | 13 | |||||||||||||
3901 | 3901 | John Forester F000273 | rep | TN | 1833-12-02 | 1835-03-03 | Jackson | 5 | |||||||||||||
3902 | 3902 | John Forester F000273 | rep | TN | 1835-12-07 | 1837-03-03 | Anti-Jacksonian | 5 | |||||||||||||
3946 | 3946 | Adam Huntsman H001000 | rep | TN | 1835-12-07 | 1837-03-03 | Jackson | 12 | |||||||||||||
3990 | 3990 | Luke Lea L000164 | rep | TN | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
3991 | 3991 | Luke Lea L000164 | rep | TN | 1835-12-07 | 1837-03-03 | Jacksonian | 3 | |||||||||||||
4038 | 4038 | Balie Peyton P000282 | rep | TN | 1833-12-02 | 1835-03-03 | Jackson | 6 | |||||||||||||
4039 | 4039 | Balie Peyton P000282 | rep | TN | 1835-12-07 | 1837-03-03 | Jacksonian | 6 | |||||||||||||
4103 | 4103 | Hugh White W000376 | sen | TN | 1825-12-05 | 1829-03-03 | 2 | Jackson | |||||||||||||
4104 | 4104 | Hugh White W000376 | sen | TN | 1829-12-07 | 1835-03-03 | 2 | Jackson | |||||||||||||
4105 | 4105 | Hugh White W000376 | sen | TN | 1835-12-07 | 1841-03-03 | 2 | Whig | |||||||||||||
4168 | 4168 | Richard Cheatham C000341 | rep | TN | 1837-09-04 | 1839-03-03 | Whig | 11 | |||||||||||||
4272 | 4272 | Abram Maury M000262 | rep | TN | 1835-12-07 | 1837-03-03 | Whig | 8 | |||||||||||||
4273 | 4273 | Abram Maury M000262 | rep | TN | 1837-09-04 | 1839-03-03 | Whig | 8 | |||||||||||||
4344 | 4344 | Ebenezer Shields S000360 | rep | TN | 1835-12-07 | 1837-03-03 | Whig | 10 | |||||||||||||
4345 | 4345 | Ebenezer Shields S000360 | rep | TN | 1837-09-04 | 1839-03-03 | Whig | 10 | |||||||||||||
4356 | 4356 | James Standifer S000789 | rep | TN | 1823-12-01 | 1825-03-03 | Jacksonian | 3 | |||||||||||||
4357 | 4357 | James Standifer S000789 | rep | TN | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
4358 | 4358 | James Standifer S000789 | rep | TN | 1831-12-05 | 1833-03-03 | Jackson | 3 | |||||||||||||
4359 | 4359 | James Standifer S000789 | rep | TN | 1833-12-02 | 1835-03-03 | Jackson | 4 | |||||||||||||
4360 | 4360 | James Standifer S000789 | rep | TN | 1835-12-07 | 1837-03-03 | Whig | 4 | |||||||||||||
4361 | 4361 | James Standifer S000789 | rep | TN | 1837-09-04 | 1839-03-03 | Whig | 4 | |||||||||||||
4362 | 4362 | William Stone S000965 | rep | TN | 1837-09-04 | 1839-03-03 | Whig | 4 | |||||||||||||
4419 | 4419 | William Carter C000204 | rep | TN | 1835-12-07 | 1837-03-03 | Whig | 1 | |||||||||||||
4420 | 4420 | William Carter C000204 | rep | TN | 1837-09-04 | 1839-03-03 | Whig | 1 | |||||||||||||
4421 | 4421 | William Carter C000204 | rep | TN | 1839-12-02 | 1841-03-03 | Whig | 1 | |||||||||||||
4446 | 4446 | John Crockett C000920 | rep | TN | 1837-09-04 | 1839-03-03 | Whig | 12 | |||||||||||||
4447 | 4447 | John Crockett C000920 | rep | TN | 1839-12-02 | 1841-03-03 | Whig | 12 | |||||||||||||
4492 | 4492 | Felix Grundy G000509 | rep | TN | 1811-11-04 | 1813-03-03 | Republican | 3 | |||||||||||||
4493 | 4493 | Felix Grundy G000509 | rep | TN | 1813-05-24 | 1815-03-03 | Republican | 5 | |||||||||||||
4494 | 4494 | Felix Grundy G000509 | sen | TN | 1829-12-07 | 1833-03-03 | 1 | Jackson | |||||||||||||
4495 | 4495 | Felix Grundy G000509 | sen | TN | 1833-12-02 | 1839-03-03 | 1 | Democrat | |||||||||||||
4496 | 4496 | Felix Grundy G000509 | sen | TN | 1839-12-02 | 1841-03-03 | 1 | Democrat | |||||||||||||
4646 | 4646 | Alexander Anderson A000181 | sen | TN | 1840-01-01 | 1841-03-03 | 2 | Democrat | |||||||||||||
4676 | 4676 | Thomas Arnold A000297 | rep | TN | 1831-12-05 | 1833-03-03 | Anti Jacksonian | 2 | |||||||||||||
4677 | 4677 | Thomas Arnold A000297 | rep | TN | 1841-05-31 | 1843-03-03 | Whig | 1 | |||||||||||||
4727 | 4727 | Thomas Campbell C000101 | rep | TN | 1841-05-31 | 1843-03-03 | Whig | 4 | |||||||||||||
4728 | 4728 | Robert Caruthers C000209 | rep | TN | 1841-05-31 | 1843-03-03 | Whig | 7 | |||||||||||||
4886 | 4886 | Abraham McClellan M000328 | rep | TN | 1837-09-04 | 1839-03-03 | Democrat | 2 | |||||||||||||
4887 | 4887 | Abraham McClellan M000328 | rep | TN | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
4888 | 4888 | Abraham McClellan M000328 | rep | TN | 1841-05-31 | 1843-03-03 | Democrat | 2 | |||||||||||||
5057 | 5057 | Harvey Watterson W000208 | rep | TN | 1839-12-02 | 1841-03-03 | Democrat | 9 | |||||||||||||
5058 | 5058 | Harvey Watterson W000208 | rep | TN | 1841-05-31 | 1843-03-03 | Democrat | 9 | |||||||||||||
5067 | 5067 | Joseph Williams W000524 | rep | TN | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
5068 | 5068 | Joseph Williams W000524 | rep | TN | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
5069 | 5069 | Joseph Williams W000524 | rep | TN | 1841-05-31 | 1843-03-03 | Whig | 3 | |||||||||||||
5117 | 5117 | John Ashe A000308 | rep | TN | 1843-12-04 | 1845-03-03 | Whig | 10 | |||||||||||||
5137 | 5137 | Julius Blackwell B000516 | rep | TN | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
5138 | 5138 | Julius Blackwell B000516 | rep | TN | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
5144 | 5144 | Aaron Brown B000899 | rep | TN | 1839-12-02 | 1841-03-03 | Democrat | 10 | |||||||||||||
5145 | 5145 | Aaron Brown B000899 | rep | TN | 1841-05-31 | 1843-03-03 | Democrat | 10 | |||||||||||||
5146 | 5146 | Aaron Brown B000899 | rep | TN | 1843-12-04 | 1845-03-03 | Democrat | 6 | |||||||||||||
5191 | 5191 | David Dickinson D000318 | rep | TN | 1833-12-02 | 1835-03-03 | Jackson | 8 | |||||||||||||
5192 | 5192 | David Dickinson D000318 | rep | TN | 1843-12-04 | 1845-03-03 | Whig | 7 | |||||||||||||
5200 | 5200 | Ephraim Foster F000302 | sen | TN | 1838-01-01 | 1839-03-03 | 1 | Whig | |||||||||||||
5201 | 5201 | Ephraim Foster F000302 | sen | TN | 1843-12-04 | 1845-03-03 | 1 | Whig | |||||||||||||
5223 | 5223 | Spencer Jarnagin J000059 | sen | TN | 1843-12-04 | 1847-03-03 | 2 | Whig | |||||||||||||
5225 | 5225 | Cave Johnson J000122 | rep | TN | 1829-12-07 | 1831-03-03 | Jackson | 8 | |||||||||||||
5226 | 5226 | Cave Johnson J000122 | rep | TN | 1831-12-05 | 1833-03-03 | Jackson | 8 | |||||||||||||
5227 | 5227 | Cave Johnson J000122 | rep | TN | 1833-12-02 | 1835-03-03 | Jackson | 11 | |||||||||||||
5228 | 5228 | Cave Johnson J000122 | rep | TN | 1835-12-07 | 1837-03-03 | Jackson | 11 | |||||||||||||
5229 | 5229 | Cave Johnson J000122 | rep | TN | 1839-12-02 | 1841-03-03 | Democrat | 11 | |||||||||||||
5230 | 5230 | Cave Johnson J000122 | rep | TN | 1841-05-31 | 1843-03-03 | Democrat | 11 | |||||||||||||
5231 | 5231 | Cave Johnson J000122 | rep | TN | 1843-12-04 | 1845-03-03 | Democrat | 9 | |||||||||||||
5288 | 5288 | William Senter S000245 | rep | TN | 1843-12-04 | 1845-03-03 | Whig | 2 | |||||||||||||
5348 | 5348 | James Polk P000409 | rep | TN | 1825-12-05 | 1827-03-03 | Jackson | 6 | |||||||||||||
5349 | 5349 | James Polk P000409 | rep | TN | 1827-12-03 | 1829-03-03 | Jackson | 6 | |||||||||||||
5350 | 5350 | James Polk P000409 | rep | TN | 1829-12-07 | 1831-03-03 | Jackson | 6 | |||||||||||||
5351 | 5351 | James Polk P000409 | rep | TN | 1831-12-05 | 1833-03-03 | Jackson | 6 | |||||||||||||
5352 | 5352 | James Polk P000409 | rep | TN | 1833-12-02 | 1835-03-03 | Jackson | 9 | |||||||||||||
5353 | 5353 | James Polk P000409 | rep | TN | 1835-12-07 | 1837-03-03 | Jackson | 9 | |||||||||||||
5354 | 5354 | James Polk P000409 | rep | TN | 1837-09-04 | 1839-03-03 | Democrat | 9 | |||||||||||||
5367 | 5367 | Milton Brown B000938 | rep | TN | 1841-05-31 | 1843-03-03 | Whig | 12 | |||||||||||||
5368 | 5368 | Milton Brown B000938 | rep | TN | 1843-12-04 | 1845-03-03 | Whig | 11 | |||||||||||||
5369 | 5369 | Milton Brown B000938 | rep | TN | 1845-12-01 | 1847-03-03 | Whig | 11 | |||||||||||||
5392 | 5392 | Alvan Cullom C000972 | rep | TN | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
5393 | 5393 | Alvan Cullom C000972 | rep | TN | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
5418 | 5418 | Edwin Ewing E000276 | rep | TN | 1845-12-01 | 1847-03-03 | Whig | 8 | |||||||||||||
5471 | 5471 | Barclay Martin M000168 | rep | TN | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
5501 | 5501 | Joseph Peyton P000283 | rep | TN | 1843-12-04 | 1845-03-03 | Whig | 8 | |||||||||||||
5502 | 5502 | Joseph Peyton P000283 | rep | TN | 1845-12-01 | 1847-03-03 | Whig | 8 | |||||||||||||
5551 | 5551 | Hopkins Turney T000430 | rep | TN | 1837-09-04 | 1839-03-03 | Democrat | 5 | |||||||||||||
5552 | 5552 | Hopkins Turney T000430 | rep | TN | 1839-12-02 | 1841-03-03 | Democrat | 5 | |||||||||||||
5553 | 5553 | Hopkins Turney T000430 | rep | TN | 1841-05-31 | 1843-03-03 | Democrat | 5 | |||||||||||||
5554 | 5554 | Hopkins Turney T000430 | sen | TN | 1845-12-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
5610 | 5610 | Washington Barrow B000185 | rep | TN | 1847-12-06 | 1849-03-03 | Whig | 8 | |||||||||||||
5645 | 5645 | Lucien Chase C000330 | rep | TN | 1845-12-01 | 1847-03-03 | Democrat | 9 | |||||||||||||
5646 | 5646 | Lucien Chase C000330 | rep | TN | 1847-12-06 | 1849-03-03 | Democrat | 9 | |||||||||||||
5651 | 5651 | William Cocke C000573 | rep | TN | 1845-12-01 | 1847-03-03 | Whig | 2 | |||||||||||||
5652 | 5652 | William Cocke C000573 | rep | TN | 1847-12-06 | 1849-03-03 | Whig | 2 | |||||||||||||
5658 | 5658 | John Crozier C000951 | rep | TN | 1845-12-01 | 1847-03-03 | Whig | 3 | |||||||||||||
5659 | 5659 | John Crozier C000951 | rep | TN | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
5715 | 5715 | William Haskell H000320 | rep | TN | 1847-12-06 | 1849-03-03 | Whig | 11 |
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);