legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
343 rows where party = "Republican" and state = "TN"
This data as json, copyable, CSV (advanced)
Suggested facets: class, district, phone, fax, contact_form, state_rank, rss_url, start (date), end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
2830 | 2830 | John Eaton E000024 | sen | TN | 1818-09-05 | 1821-03-03 | 1 | Republican | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
8245 | 8245 | Joseph Fowler F000324 | sen | TN | 1866-01-01 | 1871-03-03 | 2 | Republican | |||||||||||||
8402 | 8402 | James Mullins M001073 | rep | TN | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
8469 | 8469 | John Trimble T000374 | rep | TN | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8505 | 8505 | Samuel Arnell A000286 | rep | TN | 1867-03-04 | 1869-03-03 | Republican | 6 | |||||||||||||
8506 | 8506 | Samuel Arnell A000286 | rep | TN | 1869-03-04 | 1871-03-03 | Republican | 6 | |||||||||||||
8534 | 8534 | William Brownlow B000963 | sen | TN | 1869-03-04 | 1875-03-03 | 1 | Republican | |||||||||||||
8621 | 8621 | Isaac Hawkins H000370 | rep | TN | 1867-03-04 | 1869-03-03 | Republican | 7 | |||||||||||||
8622 | 8622 | Isaac Hawkins H000370 | rep | TN | 1869-03-04 | 1871-03-03 | Republican | 7 | |||||||||||||
8694 | 8694 | William Prosser P000550 | rep | TN | 1869-03-04 | 1871-03-03 | Republican | 5 | |||||||||||||
8721 | 8721 | William Smith S000632 | rep | TN | 1869-03-04 | 1871-03-03 | Republican | 8 | |||||||||||||
8735 | 8735 | William Stokes S000950 | rep | TN | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8736 | 8736 | William Stokes S000950 | rep | TN | 1869-03-04 | 1871-03-03 | Republican | 3 | |||||||||||||
8751 | 8751 | Lewis Tillman T000277 | rep | TN | 1869-03-04 | 1871-03-03 | Republican | 4 | |||||||||||||
9143 | 9143 | William Crutchfield C000961 | rep | TN | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
9188 | 9188 | Horace Harrison H000271 | rep | TN | 1873-12-01 | 1875-03-03 | Republican | 5 | |||||||||||||
9235 | 9235 | Barbour Lewis L000271 | rep | TN | 1873-12-01 | 1875-03-03 | Republican | 9 | |||||||||||||
9256 | 9256 | Horace Maynard M000284 | rep | TN | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
9257 | 9257 | Horace Maynard M000284 | rep | TN | 1869-03-04 | 1871-03-03 | Republican | 2 | |||||||||||||
9258 | 9258 | Horace Maynard M000284 | rep | TN | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
9259 | 9259 | Horace Maynard M000284 | rep | TN | 1873-12-01 | 1875-03-03 | Republican | -1 | |||||||||||||
9297 | 9297 | David Nunn N000170 | rep | TN | 1867-03-04 | 1869-03-03 | Republican | 8 | |||||||||||||
9298 | 9298 | David Nunn N000170 | rep | TN | 1873-12-01 | 1875-03-03 | Republican | 8 | |||||||||||||
9910 | 9910 | James Randolph R000045 | rep | TN | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
9954 | 9954 | Jacob Thornburgh T000239 | rep | TN | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9955 | 9955 | Jacob Thornburgh T000239 | rep | TN | 1875-12-06 | 1877-03-03 | Republican | 2 | |||||||||||||
9956 | 9956 | Jacob Thornburgh T000239 | rep | TN | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
10470 | 10470 | William Moore M000924 | rep | TN | 1881-12-05 | 1883-03-03 | Republican | 10 | |||||||||||||
11154 | 11154 | Augustus Pettibone P000269 | rep | TN | 1881-12-05 | 1883-03-03 | Republican | 1 | |||||||||||||
11155 | 11155 | Augustus Pettibone P000269 | rep | TN | 1883-12-03 | 1885-03-03 | Republican | 1 | |||||||||||||
11156 | 11156 | Augustus Pettibone P000269 | rep | TN | 1885-12-07 | 1887-03-03 | Republican | 1 | |||||||||||||
11226 | 11226 | Zachary Taylor T000106 | rep | TN | 1885-12-07 | 1887-03-03 | Republican | 10 |
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);