legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,175 rows where state = "KY"
This data as json, copyable, CSV (advanced)
Suggested facets: class, address, fax, contact_form, state_rank, rss_url, start (date), end (date)
party 17 ✖
- Democrat 604
- Republican 353
- Whig 93
- Jackson 43
- Unionist 17
- Adams 14
- American 10
- Anti Jacksonian 7
- Unconditional Unionist 7
- Ind. Republican-Democrat 5
- Democratic Republican 2
- Federalist 2
- Ind. Democrat 2
- Anti Jackson 1
- Anti-Administration 1
- Independent 1
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
70 | 70 | John Edwards E000075 | sen | KY | 1792-01-01 | 1795-03-03 | 3 | Anti-Administration | |||||||||||||
164 | 164 | Christopher Greenup G000434 | rep | KY | 1791-10-24 | 1793-03-03 | Republican | 1 | |||||||||||||
165 | 165 | Christopher Greenup G000434 | rep | KY | 1793-12-02 | 1795-03-03 | Republican | 1 | |||||||||||||
166 | 166 | Christopher Greenup G000434 | rep | KY | 1795-12-07 | 1797-03-03 | Republican | 1 | |||||||||||||
185 | 185 | Humphrey Marshall M000155 | sen | KY | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
193 | 193 | Alexander Orr O000101 | rep | KY | 1791-10-24 | 1793-03-03 | Republican | 2 | |||||||||||||
194 | 194 | Alexander Orr O000101 | rep | KY | 1793-12-02 | 1795-03-03 | Republican | 2 | |||||||||||||
195 | 195 | Alexander Orr O000101 | rep | KY | 1795-12-07 | 1797-03-03 | Republican | 2 | |||||||||||||
328 | 328 | John Brown B000929 | sen | KY | 1792-06-18 | 1793-03-03 | 2 | Republican | |||||||||||||
329 | 329 | John Brown B000929 | sen | KY | 1793-03-04 | 1799-03-03 | 2 | Republican | |||||||||||||
330 | 330 | John Brown B000929 | sen | KY | 1799-12-02 | 1805-03-03 | 2 | Republican | |||||||||||||
459 | 459 | John Breckinridge B000787 | sen | KY | 1801-12-07 | 1805-12-31 | 3 | Republican | |||||||||||||
465 | 465 | Thomas Davis D000138 | rep | KY | 1797-05-15 | 1799-03-03 | Republican | 1 | |||||||||||||
466 | 466 | Thomas Davis D000138 | rep | KY | 1799-12-02 | 1801-03-03 | Republican | 1 | |||||||||||||
467 | 467 | Thomas Davis D000138 | rep | KY | 1801-12-07 | 1803-03-03 | Republican | 1 | |||||||||||||
663 | 663 | George Bedinger B000301 | rep | KY | 1803-10-17 | 1805-03-03 | Republican | 6 | |||||||||||||
664 | 664 | George Bedinger B000301 | rep | KY | 1805-12-02 | 1807-03-03 | Republican | 6 | |||||||||||||
692 | 692 | John Fowler F000322 | rep | KY | 1797-05-15 | 1799-03-03 | Republican | 2 | |||||||||||||
693 | 693 | John Fowler F000322 | rep | KY | 1799-12-02 | 1801-03-03 | Republican | 2 | |||||||||||||
694 | 694 | John Fowler F000322 | rep | KY | 1801-12-07 | 1803-03-03 | Republican | 2 | |||||||||||||
695 | 695 | John Fowler F000322 | rep | KY | 1803-10-17 | 1805-03-03 | Republican | 5 | |||||||||||||
696 | 696 | John Fowler F000322 | rep | KY | 1805-12-02 | 1807-03-03 | Republican | 5 | |||||||||||||
743 | 743 | Thomas Sandford S000041 | rep | KY | 1803-10-17 | 1805-03-03 | Republican | 4 | |||||||||||||
744 | 744 | Thomas Sandford S000041 | rep | KY | 1805-12-02 | 1807-03-03 | Republican | 4 | |||||||||||||
772 | 772 | Buckner Thruston T000249 | sen | KY | 1805-12-02 | 1809-12-31 | 2 | Republican | |||||||||||||
780 | 780 | Matthew Walton W000116 | rep | KY | 1803-10-17 | 1805-03-03 | Republican | 3 | |||||||||||||
781 | 781 | Matthew Walton W000116 | rep | KY | 1805-12-02 | 1807-03-03 | Republican | 3 | |||||||||||||
806 | 806 | John Boyle B000729 | rep | KY | 1803-10-17 | 1805-03-03 | Republican | 2 | |||||||||||||
807 | 807 | John Boyle B000729 | rep | KY | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
808 | 808 | John Boyle B000729 | rep | KY | 1807-10-26 | 1809-03-03 | Republican | 2 | |||||||||||||
968 | 968 | Henry Crist C000910 | rep | KY | 1809-05-22 | 1811-03-03 | Republican | 3 | |||||||||||||
996 | 996 | Benjamin Howard H000834 | rep | KY | 1807-10-26 | 1809-03-03 | Republican | 5 | |||||||||||||
997 | 997 | Benjamin Howard H000834 | rep | KY | 1809-05-22 | 1811-03-03 | Republican | 5 | |||||||||||||
1024 | 1024 | Matthew Lyon L000545 | rep | KY | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
1025 | 1025 | Matthew Lyon L000545 | rep | KY | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
1026 | 1026 | Matthew Lyon L000545 | rep | KY | 1807-10-26 | 1809-03-03 | Republican | 1 | |||||||||||||
1027 | 1027 | Matthew Lyon L000545 | rep | KY | 1809-05-22 | 1811-03-03 | Republican | 1 | |||||||||||||
1289 | 1289 | Jesse Bledsoe B000554 | sen | KY | 1813-05-24 | 1815-03-03 | 3 | Republican | |||||||||||||
1329 | 1329 | William Duval D000577 | rep | KY | 1813-05-24 | 1815-03-03 | Republican | 10 | |||||||||||||
1348 | 1348 | Joseph Hawkins H000372 | rep | KY | 1813-05-24 | 1815-03-03 | Republican | 2 | |||||||||||||
1352 | 1352 | Samuel Hopkins H000778 | rep | KY | 1813-05-24 | 1815-03-03 | Republican | 5 | |||||||||||||
1434 | 1434 | William Barry B000192 | rep | KY | 1809-05-22 | 1811-03-03 | Republican | 5 | |||||||||||||
1435 | 1435 | William Barry B000192 | sen | KY | 1814-01-01 | 1817-03-03 | 2 | Republican | |||||||||||||
1444 | 1444 | George Walker W000053 | sen | KY | 1814-01-01 | 1815-03-03 | 2 | Republican | |||||||||||||
1567 | 1567 | Thomas Fletcher F000204 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1660 | 1660 | Samuel McKee M000496 | rep | KY | 1809-05-22 | 1811-03-03 | Republican | 2 | |||||||||||||
1661 | 1661 | Samuel McKee M000496 | rep | KY | 1811-11-04 | 1813-03-03 | Republican | 2 | |||||||||||||
1662 | 1662 | Samuel McKee M000496 | rep | KY | 1813-05-24 | 1815-03-03 | Republican | 7 | |||||||||||||
1663 | 1663 | Samuel McKee M000496 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 7 | |||||||||||||
1684 | 1684 | Stephen Ormsby O000100 | rep | KY | 1811-11-04 | 1813-03-03 | Republican | 3 | |||||||||||||
1685 | 1685 | Stephen Ormsby O000100 | rep | KY | 1813-05-24 | 1815-03-03 | Republican | 8 | |||||||||||||
1686 | 1686 | Stephen Ormsby O000100 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 8 | |||||||||||||
1703 | 1703 | Solomon Sharp S000295 | rep | KY | 1813-05-24 | 1815-03-03 | Republican | 6 | |||||||||||||
1704 | 1704 | Solomon Sharp S000295 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 6 | |||||||||||||
1747 | 1747 | Micah Taul T000054 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 9 | |||||||||||||
1782 | 1782 | Martin Hardin H000186 | sen | KY | 1816-01-01 | 1817-03-03 | 2 | Federalist | |||||||||||||
1822 | 1822 | Joseph Desha D000271 | rep | KY | 1807-10-26 | 1809-03-03 | Republican | 6 | |||||||||||||
1823 | 1823 | Joseph Desha D000271 | rep | KY | 1809-05-22 | 1811-03-03 | Republican | 6 | |||||||||||||
1824 | 1824 | Joseph Desha D000271 | rep | KY | 1811-11-04 | 1813-03-03 | Republican | 6 | |||||||||||||
1825 | 1825 | Joseph Desha D000271 | rep | KY | 1813-05-24 | 1815-03-03 | Republican | 4 | |||||||||||||
1826 | 1826 | Joseph Desha D000271 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 4 | |||||||||||||
1827 | 1827 | Joseph Desha D000271 | rep | KY | 1817-12-01 | 1819-03-03 | Republican | 4 | |||||||||||||
1926 | 1926 | Thomas Speed S000710 | rep | KY | 1817-12-01 | 1819-03-03 | Republican | 10 | |||||||||||||
1964 | 1964 | Richard Anderson A000230 | rep | KY | 1817-12-01 | 1819-03-03 | Republican | 8 | |||||||||||||
1965 | 1965 | Richard Anderson A000230 | rep | KY | 1819-12-06 | 1821-03-03 | Republican | 8 | |||||||||||||
1978 | 1978 | William Brown B000947 | rep | KY | 1819-12-06 | 1821-03-03 | Republican | 3 | |||||||||||||
2061 | 2061 | William Logan L000405 | sen | KY | 1819-12-06 | 1821-03-03 | 3 | Republican | |||||||||||||
2074 | 2074 | Alney McLean M000544 | rep | KY | 1815-12-04 | 1817-03-03 | Republican | 5 | |||||||||||||
2075 | 2075 | Alney McLean M000544 | rep | KY | 1819-12-06 | 1821-03-03 | Republican | 5 | |||||||||||||
2110 | 2110 | Tunstall Quarles Q000005 | rep | KY | 1817-12-01 | 1819-03-03 | Republican | 9 | |||||||||||||
2111 | 2111 | Tunstall Quarles Q000005 | rep | KY | 1819-12-06 | 1821-03-03 | Republican | 9 | |||||||||||||
2164 | 2164 | David Walker W000048 | rep | KY | 1817-12-01 | 1819-03-03 | Republican | 6 | |||||||||||||
2165 | 2165 | David Walker W000048 | rep | KY | 1819-12-06 | 1821-03-03 | Republican | 6 | |||||||||||||
2186 | 2186 | Isham Talbot T000017 | sen | KY | 1815-12-04 | 1819-03-03 | 3 | Republican | |||||||||||||
2187 | 2187 | Isham Talbot T000017 | sen | KY | 1820-01-01 | 1825-03-03 | 3 | Republican | |||||||||||||
2206 | 2206 | James Breckinridge B000786 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 8 | |||||||||||||
2209 | 2209 | Wingfield Bullock B001054 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2271 | 2271 | Thomas Montgomery M000872 | rep | KY | 1813-05-24 | 1815-03-03 | Republican | 9 | |||||||||||||
2272 | 2272 | Thomas Montgomery M000872 | rep | KY | 1819-12-06 | 1821-03-03 | Republican | 9 | |||||||||||||
2273 | 2273 | Thomas Montgomery M000872 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 9 | |||||||||||||
2293 | 2293 | Anthony New N000058 | rep | KY | 1811-11-04 | 1813-03-03 | Republican | 1 | |||||||||||||
2294 | 2294 | Anthony New N000058 | rep | KY | 1817-12-01 | 1819-03-03 | Republican | 5 | |||||||||||||
2295 | 2295 | Anthony New N000058 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 5 | |||||||||||||
2321 | 2321 | George Robertson R000322 | rep | KY | 1817-12-01 | 1819-03-03 | Republican | 7 | |||||||||||||
2322 | 2322 | George Robertson R000322 | rep | KY | 1819-12-06 | 1821-03-03 | Republican | 7 | |||||||||||||
2323 | 2323 | George Robertson R000322 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | -1 | |||||||||||||
2330 | 2330 | John Smith S000575 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 7 | |||||||||||||
2351 | 2351 | Samuel Woodson W000729 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2432 | 2432 | John Johnson J000154 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 3 | |||||||||||||
2433 | 2433 | John Johnson J000154 | rep | KY | 1823-12-01 | 1825-03-03 | 5 | ||||||||||||||
2502 | 2502 | Philip Thompson T000211 | rep | KY | 1823-12-01 | 1825-03-03 | 11 | ||||||||||||||
2529 | 2529 | David White W000363 | rep | KY | 1823-12-01 | 1825-03-03 | 6 | ||||||||||||||
2627 | 2627 | John Henry H000509 | rep | KY | 1825-12-05 | 1827-03-03 | Adams | 12 | |||||||||||||
2628 | 2628 | Robert Henry H000517 | rep | KY | 1823-12-01 | 1825-03-03 | 12 | ||||||||||||||
2629 | 2629 | Robert Henry H000517 | rep | KY | 1825-12-05 | 1827-03-03 | Jackson | 12 | |||||||||||||
2641 | 2641 | Francis Johnson J000129 | rep | KY | 1819-12-06 | 1821-03-03 | Republican | 6 | |||||||||||||
2642 | 2642 | Francis Johnson J000129 | rep | KY | 1821-12-03 | 1823-03-03 | Republican | 6 | |||||||||||||
2643 | 2643 | Francis Johnson J000129 | rep | KY | 1823-12-01 | 1825-03-03 | 10 | ||||||||||||||
2644 | 2644 | Francis Johnson J000129 | rep | KY | 1825-12-05 | 1827-03-03 | Adams | 10 | |||||||||||||
2645 | 2645 | James Johnson J000143 | rep | KY | 1825-12-05 | 1827-03-03 | Jackson | 5 |
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);