legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,123 rows where state = "TN" sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: class, district, phone, fax, state_rank, rss_url, start (date), end (date)
party 15 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
222 | 222 | James White W000377 | rep | TN | 1793-12-02 | 1795-03-03 | -1 | ||||||||||||||
223 | 223 | James White W000377 | rep | TN | 1795-12-07 | 1797-03-03 | -1 | ||||||||||||||
2551 | 2551 | Robert Allen A000142 | rep | TN | 1823-12-01 | 1825-03-03 | 5 | ||||||||||||||
2578 | 2578 | John Cocke C000571 | rep | TN | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2831 | 2831 | John Eaton E000024 | sen | TN | 1821-12-03 | 1825-03-03 | 1 | ||||||||||||||
7812 | 7812 | Thomas Nelson N000042 | rep | TN | 1861-07-04 | 1863-03-03 | -1 | ||||||||||||||
6511 | 6511 | John Bell B000340 | sen | TN | 1853-12-05 | 1859-03-03 | 2 | American | |||||||||||||
6907 | 6907 | Thomas Rivers R000283 | rep | TN | 1855-12-03 | 1857-03-03 | American | 10 | |||||||||||||
6927 | 6927 | William Sneed S000651 | rep | TN | 1855-12-03 | 1857-03-03 | American | 2 | |||||||||||||
7195 | 7195 | Charles Ready R000097 | rep | TN | 1855-12-03 | 1857-03-03 | American | 5 | |||||||||||||
7196 | 7196 | Charles Ready R000097 | rep | TN | 1857-12-07 | 1859-03-03 | American | 5 | |||||||||||||
7256 | 7256 | Felix Zollicoffer Z000012 | rep | TN | 1855-12-03 | 1857-03-03 | American | 8 | |||||||||||||
7257 | 7257 | Felix Zollicoffer Z000012 | rep | TN | 1857-12-07 | 1859-03-03 | American | 8 | |||||||||||||
7403 | 7403 | Emerson Etheridge E000227 | rep | TN | 1855-12-03 | 1857-03-03 | American | 9 | |||||||||||||
9252 | 9252 | Horace Maynard M000284 | rep | TN | 1857-12-07 | 1859-03-03 | American | 2 | |||||||||||||
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 | |||||||||||||
4676 | 4676 | Thomas Arnold A000297 | rep | TN | 1831-12-05 | 1833-03-03 | Anti Jacksonian | 2 | |||||||||||||
3902 | 3902 | John Forester F000273 | rep | TN | 1835-12-07 | 1837-03-03 | Anti-Jacksonian | 5 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
5354 | 5354 | James Polk P000409 | rep | TN | 1837-09-04 | 1839-03-03 | Democrat | 9 | |||||||||||||
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 | |||||||||||||
5471 | 5471 | Barclay Martin M000168 | rep | TN | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
5719 | 5719 | Hugh Hill H000592 | rep | TN | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
5973 | 5973 | Andrew Ewing E000275 | rep | TN | 1849-12-03 | 1851-03-03 | Democrat | 8 | |||||||||||||
6532 | 6532 | Brookins Campbell C000078 | rep | TN | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6545 | 6545 | William Churchwell C000393 | rep | TN | 1851-12-01 | 1853-03-03 | Democrat | 3 | |||||||||||||
6546 | 6546 | William Churchwell C000393 | rep | TN | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6615 | 6615 | Samuel Houston H000827 | rep | TN | 1823-12-01 | 1825-03-03 | Democrat | 7 | |||||||||||||
6697 | 6697 | Frederick Stanton S000802 | rep | TN | 1845-12-01 | 1847-03-03 | Democrat | 10 | |||||||||||||
6698 | 6698 | Frederick Stanton S000802 | rep | TN | 1847-12-06 | 1849-03-03 | Democrat | 10 | |||||||||||||
6699 | 6699 | Frederick Stanton S000802 | rep | TN | 1849-12-03 | 1851-03-03 | Democrat | 10 | |||||||||||||
6700 | 6700 | Frederick Stanton S000802 | rep | TN | 1851-12-01 | 1853-03-03 | Democrat | 10 | |||||||||||||
6701 | 6701 | Frederick Stanton S000802 | rep | TN | 1853-12-05 | 1855-03-03 | Democrat | 10 | |||||||||||||
7101 | 7101 | George Jones J000222 | rep | TN | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
7102 | 7102 | George Jones J000222 | rep | TN | 1845-12-01 | 1847-03-03 | Democrat | 5 | |||||||||||||
7103 | 7103 | George Jones J000222 | rep | TN | 1847-12-06 | 1849-03-03 | Democrat | 5 | |||||||||||||
7104 | 7104 | George Jones J000222 | rep | TN | 1849-12-03 | 1851-03-03 | Democrat | 5 | |||||||||||||
7105 | 7105 | George Jones J000222 | rep | TN | 1851-12-01 | 1853-03-03 | Democrat | 5 | |||||||||||||
7106 | 7106 | George Jones J000222 | rep | TN | 1853-12-05 | 1855-03-03 | Democrat | 6 | |||||||||||||
7107 | 7107 | George Jones J000222 | rep | TN | 1855-12-03 | 1857-03-03 | Democrat | 6 | |||||||||||||
7108 | 7108 | George Jones J000222 | rep | TN | 1857-12-07 | 1859-03-03 | Democrat | 6 | |||||||||||||
7210 | 7210 | John Savage S000083 | rep | TN | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
7211 | 7211 | John Savage S000083 | rep | TN | 1851-12-01 | 1853-03-03 | Democrat | 4 | |||||||||||||
7212 | 7212 | John Savage S000083 | rep | TN | 1855-12-03 | 1857-03-03 | Democrat | 4 | |||||||||||||
7213 | 7213 | John Savage S000083 | rep | TN | 1857-12-07 | 1859-03-03 | Democrat | 4 | |||||||||||||
7229 | 7229 | Samuel Smith S000612 | rep | TN | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
7230 | 7230 | Samuel Smith S000612 | rep | TN | 1855-12-03 | 1857-03-03 | Democrat | 3 | |||||||||||||
7231 | 7231 | Samuel Smith S000612 | rep | TN | 1857-12-07 | 1859-03-03 | Democrat | 3 | |||||||||||||
7248 | 7248 | Albert Watkins W000189 | rep | TN | 1855-12-03 | 1857-03-03 | Democrat | 1 | |||||||||||||
7249 | 7249 | Albert Watkins W000189 | rep | TN | 1857-12-07 | 1859-03-03 | Democrat | 1 | |||||||||||||
7280 | 7280 | William Avery A000347 | rep | TN | 1857-12-07 | 1859-03-03 | Democrat | 10 | |||||||||||||
7281 | 7281 | William Avery A000347 | rep | TN | 1859-12-05 | 1861-03-03 | Democrat | 10 | |||||||||||||
7526 | 7526 | Alfred Nicholson N000096 | sen | TN | 1840-01-01 | 1843-03-03 | 1 | Democrat | |||||||||||||
7527 | 7527 | Alfred Nicholson N000096 | sen | TN | 1859-12-05 | 1861-12-31 | 2 | Democrat | |||||||||||||
7604 | 7604 | James Thomas T000170 | rep | TN | 1847-12-06 | 1849-03-03 | Democrat | 6 | |||||||||||||
7605 | 7605 | James Thomas T000170 | rep | TN | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
7606 | 7606 | James Thomas T000170 | rep | TN | 1859-12-05 | 1861-03-03 | Democrat | 6 | |||||||||||||
7639 | 7639 | John Wright W000765 | rep | TN | 1855-12-03 | 1857-03-03 | Democrat | 7 | |||||||||||||
7640 | 7640 | John Wright W000765 | rep | TN | 1857-12-07 | 1859-03-03 | Democrat | 7 | |||||||||||||
7641 | 7641 | John Wright W000765 | rep | TN | 1859-12-05 | 1861-03-03 | Democrat | 7 | |||||||||||||
8246 | 8246 | David Patterson P000110 | sen | TN | 1866-01-01 | 1869-03-03 | 1 | Democrat | |||||||||||||
8847 | 8847 | Robert Caldwell C000040 | rep | TN | 1871-03-04 | 1873-03-03 | Democrat | 7 | |||||||||||||
8866 | 8866 | Henry Cooper C000751 | sen | TN | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
8907 | 8907 | Abraham Garrett G000079 | rep | TN | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
8912 | 8912 | Edward Golladay G000270 | rep | TN | 1871-03-04 | 1873-03-03 | Democrat | 5 | |||||||||||||
9050 | 9050 | William Vaughan V000076 | rep | TN | 1871-03-04 | 1873-03-03 | Democrat | 8 | |||||||||||||
9508 | 9508 | Samuel Fite F000160 | rep | TN | 1875-12-06 | 1877-03-03 | Democrat | 4 | |||||||||||||
9540 | 9540 | Andrew Johnson J000116 | rep | TN | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
9541 | 9541 | Andrew Johnson J000116 | rep | TN | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
9542 | 9542 | Andrew Johnson J000116 | rep | TN | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
9543 | 9543 | Andrew Johnson J000116 | rep | TN | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
9544 | 9544 | Andrew Johnson J000116 | rep | TN | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
9545 | 9545 | Andrew Johnson J000116 | sen | TN | 1857-12-07 | 1863-03-03 | 1 | Democrat | |||||||||||||
9546 | 9546 | Andrew Johnson J000116 | sen | TN | 1875-12-06 | 1875-12-31 | 1 | Democrat | |||||||||||||
9559 | 9559 | David Key K000156 | sen | TN | 1875-12-06 | 1877-12-31 | 1 | Democrat | |||||||||||||
9583 | 9583 | William McFarland M000439 | rep | TN | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9733 | 9733 | James Bailey B000039 | sen | TN | 1877-10-15 | 1881-03-03 | 1 | Democrat |
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);