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)
Suggested facets: class, phone, contact_form, 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 | ||||||||||||||
224 | 224 | William Blount B000570 | sen | TN | 1796-01-01 | 1797-12-31 | 2 | Republican | |||||||||||||
334 | 334 | William Cocke C000572 | sen | TN | 1796-01-01 | 1797-03-03 | 1 | Republican | |||||||||||||
335 | 335 | William Cocke C000572 | sen | TN | 1799-12-02 | 1805-03-03 | 2 | Republican | |||||||||||||
680 | 680 | William Dickson D000333 | rep | TN | 1801-12-07 | 1803-03-03 | Republican | 1 | |||||||||||||
681 | 681 | William Dickson D000333 | rep | TN | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
682 | 682 | William Dickson D000333 | rep | TN | 1805-12-02 | 1807-03-03 | Republican | 3 | |||||||||||||
746 | 746 | Daniel Smith S000524 | sen | TN | 1798-01-01 | 1799-12-31 | 1 | Republican | |||||||||||||
747 | 747 | Daniel Smith S000524 | sen | TN | 1805-12-02 | 1809-12-31 | 2 | Republican | |||||||||||||
940 | 940 | Joseph Anderson A000197 | sen | TN | 1797-05-15 | 1799-03-03 | 2 | Republican | |||||||||||||
941 | 941 | Joseph Anderson A000197 | sen | TN | 1799-12-02 | 1803-03-03 | 1 | Republican | |||||||||||||
942 | 942 | Joseph Anderson A000197 | sen | TN | 1803-10-17 | 1809-03-03 | 1 | Republican | |||||||||||||
943 | 943 | Joseph Anderson A000197 | sen | TN | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
1036 | 1036 | Pleasant Miller M000750 | rep | TN | 1809-05-22 | 1811-03-03 | Republican | 2 | |||||||||||||
1085 | 1085 | Robert Weakley W000220 | rep | TN | 1809-05-22 | 1811-03-03 | Republican | 3 | |||||||||||||
1086 | 1086 | Jenkin Whiteside W000411 | sen | TN | 1809-05-22 | 1811-03-03 | 2 | Republican | |||||||||||||
1292 | 1292 | John Bowen B000684 | rep | TN | 1813-05-24 | 1815-03-03 | Republican | 4 | |||||||||||||
1346 | 1346 | Thomas Harris H000254 | rep | TN | 1813-05-24 | 1815-03-03 | Republican | 3 | |||||||||||||
1359 | 1359 | Parry Humphreys H000962 | rep | TN | 1813-05-24 | 1815-03-03 | Republican | 6 | |||||||||||||
1445 | 1445 | Jesse Wharton W000324 | rep | TN | 1807-10-26 | 1809-03-03 | Republican | 3 | |||||||||||||
1446 | 1446 | Jesse Wharton W000324 | sen | TN | 1814-01-01 | 1815-12-31 | 2 | Republican | |||||||||||||
1484 | 1484 | George Campbell C000083 | rep | TN | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
1485 | 1485 | George Campbell C000083 | rep | TN | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
1486 | 1486 | George Campbell C000083 | rep | TN | 1807-10-26 | 1809-03-03 | Republican | 2 | |||||||||||||
1487 | 1487 | George Campbell C000083 | sen | TN | 1811-11-04 | 1815-03-03 | 2 | Republican | |||||||||||||
1488 | 1488 | George Campbell C000083 | sen | TN | 1815-12-04 | 1819-03-03 | 1 | Republican | |||||||||||||
1604 | 1604 | Bennett Henderson H000476 | rep | TN | 1815-12-04 | 1817-03-03 | Republican | 4 | |||||||||||||
1697 | 1697 | Samuel Powell P000484 | rep | TN | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1700 | 1700 | John Sevier S000257 | rep | TN | 1811-11-04 | 1813-03-03 | Republican | 2 | |||||||||||||
1701 | 1701 | John Sevier S000257 | rep | TN | 1813-05-24 | 1815-03-03 | Republican | 2 | |||||||||||||
1702 | 1702 | John Sevier S000257 | rep | TN | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1751 | 1751 | Isaac Thomas T000169 | rep | TN | 1815-12-04 | 1817-03-03 | Republican | 3 | |||||||||||||
1802 | 1802 | William Blount B000571 | rep | TN | 1815-12-04 | 1817-03-03 | Republican | 2 | |||||||||||||
1803 | 1803 | William Blount B000571 | rep | TN | 1817-12-01 | 1819-03-03 | Republican | 2 | |||||||||||||
1809 | 1809 | Thomas Claiborne C000407 | rep | TN | 1817-12-01 | 1819-03-03 | Republican | 5 | |||||||||||||
1810 | 1810 | William Claiborne C000408 | rep | TN | 1797-05-15 | 1799-03-03 | Republican | 1 | |||||||||||||
1811 | 1811 | William Claiborne C000408 | rep | TN | 1799-12-02 | 1801-03-03 | Republican | 1 | |||||||||||||
1859 | 1859 | Samuel Hogg H000705 | rep | TN | 1817-12-01 | 1819-03-03 | Republican | 4 | |||||||||||||
1875 | 1875 | George Marr M000142 | rep | TN | 1817-12-01 | 1819-03-03 | Republican | 6 | |||||||||||||
1948 | 1948 | John Williams W000516 | sen | TN | 1815-12-04 | 1817-03-03 | 2 | Republican | |||||||||||||
1949 | 1949 | John Williams W000516 | sen | TN | 1817-12-01 | 1823-03-03 | 2 | Republican | |||||||||||||
2207 | 2207 | Henry Bryan B000986 | rep | TN | 1819-12-06 | 1821-03-03 | Republican | 6 | |||||||||||||
2208 | 2208 | Henry Bryan B000986 | rep | TN | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
2215 | 2215 | Newton Cannon C000123 | rep | TN | 1813-05-24 | 1815-03-03 | Republican | 5 | |||||||||||||
2216 | 2216 | Newton Cannon C000123 | rep | TN | 1815-12-04 | 1817-03-03 | Republican | 5 | |||||||||||||
2217 | 2217 | Newton Cannon C000123 | rep | TN | 1819-12-06 | 1821-03-03 | Republican | 5 | |||||||||||||
2218 | 2218 | Newton Cannon C000123 | rep | TN | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
2252 | 2252 | Francis Jones J000218 | rep | TN | 1817-12-01 | 1819-03-03 | Republican | 3 | |||||||||||||
2253 | 2253 | Francis Jones J000218 | rep | TN | 1819-12-06 | 1821-03-03 | Republican | 3 | |||||||||||||
2254 | 2254 | Francis Jones J000218 | rep | TN | 1821-12-03 | 1823-03-03 | Republican | 3 | |||||||||||||
2312 | 2312 | John Rhea R000181 | rep | TN | 1803-10-17 | 1805-03-03 | Republican | -1 | |||||||||||||
2313 | 2313 | John Rhea R000181 | rep | TN | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
2314 | 2314 | John Rhea R000181 | rep | TN | 1807-10-26 | 1809-03-03 | Republican | 1 | |||||||||||||
2315 | 2315 | John Rhea R000181 | rep | TN | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
2316 | 2316 | John Rhea R000181 | rep | TN | 1811-11-04 | 1813-03-03 | Republican | 1 | |||||||||||||
2317 | 2317 | John Rhea R000181 | rep | TN | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
2318 | 2318 | John Rhea R000181 | rep | TN | 1817-12-01 | 1819-03-03 | Republican | 1 | |||||||||||||
2319 | 2319 | John Rhea R000181 | rep | TN | 1819-12-06 | 1821-03-03 | Republican | 1 | |||||||||||||
2320 | 2320 | John Rhea R000181 | rep | TN | 1821-12-03 | 1823-03-03 | Republican | 1 | |||||||||||||
2465 | 2465 | James Reynolds R000173 | rep | TN | 1815-12-04 | 1817-03-03 | Republican | 6 | |||||||||||||
2466 | 2466 | James Reynolds R000173 | rep | TN | 1823-12-01 | 1825-03-03 | Republican | 8 | |||||||||||||
2483 | 2483 | James Sandford S000040 | rep | TN | 1823-12-01 | 1825-03-03 | Jackson Republican | 6 | |||||||||||||
2547 | 2547 | Adam Alexander A000089 | rep | TN | 1823-12-01 | 1825-03-03 | Jacksonian Republican | 9 | |||||||||||||
2548 | 2548 | Adam Alexander A000089 | rep | TN | 1825-12-05 | 1827-03-03 | Jackson | 9 | |||||||||||||
2549 | 2549 | Robert Allen A000142 | rep | TN | 1819-12-06 | 1821-03-03 | Republican | 4 | |||||||||||||
2550 | 2550 | Robert Allen A000142 | rep | TN | 1821-12-03 | 1823-03-03 | Republican | 4 | |||||||||||||
2551 | 2551 | Robert Allen A000142 | rep | TN | 1823-12-01 | 1825-03-03 | 5 | ||||||||||||||
2552 | 2552 | Robert Allen A000142 | rep | TN | 1825-12-05 | 1827-03-03 | Jackson | 5 | |||||||||||||
2576 | 2576 | John Cocke C000571 | rep | TN | 1819-12-06 | 1821-03-03 | Republican | 2 | |||||||||||||
2577 | 2577 | John Cocke C000571 | rep | TN | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2578 | 2578 | John Cocke C000571 | rep | TN | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2579 | 2579 | John Cocke C000571 | rep | TN | 1825-12-05 | 1827-03-03 | Jackson | 2 | |||||||||||||
2830 | 2830 | John Eaton E000024 | sen | TN | 1818-09-05 | 1821-03-03 | 1 | Republican | |||||||||||||
2831 | 2831 | John Eaton E000024 | sen | TN | 1821-12-03 | 1825-03-03 | 1 | ||||||||||||||
2832 | 2832 | John Eaton E000024 | sen | TN | 1827-12-03 | 1829-03-09 | 1 | Jackson | |||||||||||||
2885 | 2885 | John Marable M000120 | rep | TN | 1825-12-05 | 1827-03-03 | Jackson | 8 | |||||||||||||
2886 | 2886 | John Marable M000120 | rep | TN | 1827-12-03 | 1829-03-03 | Jackson | 8 | |||||||||||||
2907 | 2907 | James Mitchell M000815 | rep | TN | 1825-12-05 | 1827-03-03 | Jackson | 3 | |||||||||||||
2908 | 2908 | James Mitchell M000815 | rep | TN | 1827-12-03 | 1829-03-03 | Jackson | 3 | |||||||||||||
3020 | 3020 | Andrew Jackson J000005 | rep | TN | 1795-12-07 | 1797-03-03 | Republican | 1 | |||||||||||||
3021 | 3021 | Andrew Jackson J000005 | sen | TN | 1797-05-15 | 1799-03-03 | 1 | Republican | |||||||||||||
3022 | 3022 | Andrew Jackson J000005 | sen | TN | 1823-12-01 | 1825-12-31 | 2 | Democratic Republican | |||||||||||||
3077 | 3077 | Robert Desha D000272 | rep | TN | 1827-12-03 | 1829-03-03 | Jackson | 5 | |||||||||||||
3078 | 3078 | Robert Desha D000272 | rep | TN | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3159 | 3159 | Pryor Lea L000166 | rep | TN | 1827-12-03 | 1829-03-03 | Jackson | 2 | |||||||||||||
3160 | 3160 | Pryor Lea L000166 | rep | TN | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3380 | 3380 | William Fitzgerald F000168 | rep | TN | 1831-12-05 | 1833-03-03 | Jackson | 9 | |||||||||||||
3395 | 3395 | William Hall H000078 | rep | TN | 1831-12-05 | 1833-03-03 | Jackson | 5 | |||||||||||||
3430 | 3430 | Jacob Isacks I000045 | rep | TN | 1823-12-01 | 1825-03-03 | Jackson Republican | 4 | |||||||||||||
3431 | 3431 | Jacob Isacks I000045 | rep | TN | 1825-12-05 | 1827-03-03 | Jackson | 4 | |||||||||||||
3432 | 3432 | Jacob Isacks I000045 | rep | TN | 1827-12-03 | 1829-03-03 | Jackson | 4 | |||||||||||||
3433 | 3433 | Jacob Isacks I000045 | rep | TN | 1829-12-07 | 1831-03-03 | Jackson | 4 | |||||||||||||
3434 | 3434 | Jacob Isacks I000045 | rep | TN | 1831-12-05 | 1833-03-03 | Jackson | 4 | |||||||||||||
3619 | 3619 | John Blair B000528 | rep | TN | 1823-12-01 | 1825-03-03 | Jacksonian | 1 | |||||||||||||
3620 | 3620 | John Blair B000528 | rep | TN | 1825-12-05 | 1827-03-03 | Jackson | 1 | |||||||||||||
3621 | 3621 | John Blair B000528 | rep | TN | 1827-12-03 | 1829-03-03 | Jackson | 1 | |||||||||||||
3622 | 3622 | John Blair B000528 | rep | TN | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3623 | 3623 | John Blair B000528 | rep | TN | 1831-12-05 | 1833-03-03 | Jackson | 1 | |||||||||||||
3624 | 3624 | John Blair B000528 | rep | TN | 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);