legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
112 rows where state = "KY" and type = "sen"
This data as json, copyable, CSV (advanced)
Suggested facets: party, url, phone, fax, office, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
70 | 70 | John Edwards E000075 | sen | KY | 1792-01-01 | 1795-03-03 | 3 | Anti-Administration | |||||||||||||
185 | 185 | Humphrey Marshall M000155 | sen | KY | 1795-12-07 | 1801-03-03 | 3 | Federalist | |||||||||||||
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 | |||||||||||||
772 | 772 | Buckner Thruston T000249 | sen | KY | 1805-12-02 | 1809-12-31 | 2 | Republican | |||||||||||||
1289 | 1289 | Jesse Bledsoe B000554 | sen | KY | 1813-05-24 | 1815-03-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
1782 | 1782 | Martin Hardin H000186 | sen | KY | 1816-01-01 | 1817-03-03 | 2 | Federalist | |||||||||||||
2061 | 2061 | William Logan L000405 | sen | KY | 1819-12-06 | 1821-03-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
2711 | 2711 | John Rowan R000471 | sen | KY | 1825-12-05 | 1831-03-03 | 3 | Jackson | |||||||||||||
3055 | 3055 | George Bibb B000433 | sen | KY | 1811-11-04 | 1815-03-03 | 2 | Republican | |||||||||||||
3056 | 3056 | George Bibb B000433 | sen | KY | 1829-12-07 | 1835-03-03 | 2 | Jackson | |||||||||||||
3284 | 3284 | John Adair A000026 | sen | KY | 1805-12-02 | 1807-03-03 | 3 | Republican | |||||||||||||
3961 | 3961 | Richard Johnson J000170 | sen | KY | 1819-12-06 | 1823-03-03 | 2 | Republican | |||||||||||||
3962 | 3962 | Richard Johnson J000170 | sen | KY | 1823-12-01 | 1829-03-03 | 2 | Jackson | |||||||||||||
4906 | 4906 | James Morehead M000938 | sen | KY | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
4940 | 4940 | John Pope P000431 | sen | KY | 1807-10-26 | 1813-03-03 | 3 | Republican | |||||||||||||
5852 | 5852 | Joseph Underwood U000011 | sen | KY | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
5885 | 5885 | Thomas Metcalfe M000676 | sen | KY | 1848-01-01 | 1849-03-03 | 3 | Whig | |||||||||||||
5928 | 5928 | Henry Clay C000482 | sen | KY | 1806-01-01 | 1807-03-03 | 3 | Republican | |||||||||||||
5929 | 5929 | Henry Clay C000482 | sen | KY | 1810-01-01 | 1811-03-03 | 2 | Republican | |||||||||||||
5937 | 5937 | Henry Clay C000482 | sen | KY | 1831-12-05 | 1837-03-03 | 3 | Whig | |||||||||||||
5938 | 5938 | Henry Clay C000482 | sen | KY | 1837-09-04 | 1843-03-03 | 3 | Whig | |||||||||||||
5939 | 5939 | Henry Clay C000482 | sen | KY | 1849-12-03 | 1853-03-03 | 3 | Whig | |||||||||||||
6474 | 6474 | Archibald Dixon D000367 | sen | KY | 1852-01-01 | 1855-03-03 | 3 | Whig | |||||||||||||
6475 | 6475 | David Meriwether M000650 | sen | KY | 1852-01-01 | 1853-03-03 | 3 | Democrat | |||||||||||||
6724 | 6724 | John Thompson T000208 | sen | KY | 1853-12-05 | 1859-03-03 | 2 | American | |||||||||||||
7546 | 7546 | Lazarus Powell P000481 | sen | KY | 1859-12-05 | 1865-03-03 | 2 | Democrat | |||||||||||||
7673 | 7673 | John Breckinridge B000789 | sen | KY | 1861-07-04 | 1861-12-31 | 3 | Democrat | |||||||||||||
7722 | 7722 | John Crittenden C000912 | sen | KY | 1817-12-01 | 1819-03-03 | 2 | Republican | |||||||||||||
7723 | 7723 | John Crittenden C000912 | sen | KY | 1835-12-07 | 1841-03-03 | 2 | Whig | |||||||||||||
7724 | 7724 | John Crittenden C000912 | sen | KY | 1842-03-31 | 1843-03-03 | 3 | Whig | |||||||||||||
7725 | 7725 | John Crittenden C000912 | sen | KY | 1843-12-04 | 1848-06-12 | 3 | Whig | |||||||||||||
7726 | 7726 | John Crittenden C000912 | sen | KY | 1855-12-03 | 1861-03-03 | 3 | American | |||||||||||||
8131 | 8131 | James Guthrie G000534 | sen | KY | 1865-12-04 | 1869-03-03 | 2 | Democrat | |||||||||||||
8303 | 8303 | Garrett Davis D000099 | sen | KY | 1861-07-04 | 1867-03-03 | 3 | Democrat | |||||||||||||
8304 | 8304 | Garrett Davis D000099 | sen | KY | 1867-03-04 | 1873-03-03 | 3 | Democrat | |||||||||||||
9029 | 9029 | John Stevenson S000894 | sen | KY | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
9066 | 9066 | Willis Machen M000012 | sen | KY | 1872-09-27 | 1873-03-03 | 3 | Democrat | |||||||||||||
9260 | 9260 | Thomas McCreery M000385 | sen | KY | 1868-01-01 | 1871-03-03 | 2 | Democrat | |||||||||||||
9261 | 9261 | Thomas McCreery M000385 | sen | KY | 1873-12-01 | 1879-03-03 | 3 | Democrat | |||||||||||||
10221 | 10221 | John Williams W000522 | sen | KY | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
11603 | 11603 | James Beck B000289 | sen | KY | 1877-10-15 | 1883-03-03 | 2 | Democrat | |||||||||||||
11604 | 11604 | James Beck B000289 | sen | KY | 1883-12-03 | 1889-03-03 | 2 | Democrat | |||||||||||||
11605 | 11605 | James Beck B000289 | sen | KY | 1889-12-02 | 1891-03-03 | 2 | Democrat | |||||||||||||
12062 | 12062 | John Carlisle C000152 | sen | KY | 1890-01-01 | 1893-12-31 | 2 | Democrat | |||||||||||||
13067 | 13067 | William Lindsay L000327 | sen | KY | 1893-08-07 | 1895-03-03 | 2 | Democrat | |||||||||||||
13068 | 13068 | William Lindsay L000327 | sen | KY | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
13289 | 13289 | William Deboe D000182 | sen | KY | 1897-03-15 | 1903-03-03 | 3 | Republican | |||||||||||||
13868 | 13868 | Joseph Blackburn B000508 | sen | KY | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
13869 | 13869 | Joseph Blackburn B000508 | sen | KY | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
13870 | 13870 | Joseph Blackburn B000508 | sen | KY | 1901-12-02 | 1907-03-03 | 2 | Democrat | |||||||||||||
14412 | 14412 | James McCreary M000382 | sen | KY | 1903-11-09 | 1909-03-03 | 3 | Democrat | |||||||||||||
15248 | 15248 | Thomas Paynter P000156 | sen | KY | 1907-12-02 | 1913-03-03 | 2 | Democrat | |||||||||||||
15355 | 15355 | William Bradley B000749 | sen | KY | 1909-03-15 | 1915-03-03 | 3 | Republican | |||||||||||||
16415 | 16415 | Ollie James J000051 | sen | KY | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
16652 | 16652 | Johnson Camden C000063 | sen | KY | 1914-06-16 | 1915-03-03 | 3 | Democrat | appointment | ||||||||||||
16688 | 16688 | John Beckham B000293 | sen | KY | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
17526 | 17526 | George Martin M000181 | sen | KY | 1918-09-07 | 1919-03-03 | 2 | Democrat | appointment | ||||||||||||
17964 | 17964 | Augustus Stanley S000796 | sen | KY | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
18164 | 18164 | Richard Ernst E000206 | sen | KY | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
19096 | 19096 | Frederic Sackett S000006 | sen | KY | 1925-12-07 | 1931-03-03 | 2 | Republican | |||||||||||||
20072 | 20072 | Ben Williamson W000550 | sen | KY | 1930-01-01 | 1931-03-03 | 2 | Democrat | |||||||||||||
22279 | 22279 | Marvel Logan L000404 | sen | KY | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
22280 | 22280 | Marvel Logan L000404 | sen | KY | 1937-01-05 | 1939-12-31 | 2 | Democrat | |||||||||||||
23372 | 23372 | Albert Chandler C000290 | sen | KY | 1939-10-10 | 1943-01-03 | 2 | Democrat | appointment | ||||||||||||
23373 | 23373 | Albert Chandler C000290 | sen | KY | 1943-01-06 | 1945-12-31 | 2 | Democrat | |||||||||||||
24105 | 24105 | William Stanfill S000792 | sen | KY | 1945-11-19 | 1947-01-03 | 2 | Republican | appointment | ||||||||||||
24656 | 24656 | John Robsion R000358 | sen | KY | 1930-01-11 | 1930-11-30 | 2 | Republican | appointment | ||||||||||||
24802 | 24802 | Virgil Chapman C000317 | sen | KY | 1949-01-03 | 1951-03-08 | 2 | Democrat | |||||||||||||
25108 | 25108 | Earle Clements C000506 | sen | KY | 1950-11-27 | 1951-01-03 | 3 | Democrat | |||||||||||||
25109 | 25109 | Earle Clements C000506 | sen | KY | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
25533 | 25533 | Thomas Underwood U000015 | sen | KY | 1951-03-19 | 1952-11-04 | 2 | Democrat | appointment | ||||||||||||
25841 | 25841 | Garrett Withers W000658 | sen | KY | 1949-01-20 | 1950-11-26 | 3 | Democrat | appointment | ||||||||||||
25874 | 25874 | Alben Barkley B000145 | sen | KY | 1927-12-05 | 1933-03-03 | 3 | Democrat | |||||||||||||
25875 | 25875 | Alben Barkley B000145 | sen | KY | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
25876 | 25876 | Alben Barkley B000145 | sen | KY | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
25877 | 25877 | Alben Barkley B000145 | sen | KY | 1945-01-03 | 1949-01-19 | 3 | Democrat | |||||||||||||
25878 | 25878 | Alben Barkley B000145 | sen | KY | 1955-01-05 | 1956-04-30 | 2 | Democrat | |||||||||||||
26151 | 26151 | Robert Humphreys H000963 | sen | KY | 1956-06-21 | 1957-01-03 | 2 | Democrat | appointment | ||||||||||||
28039 | 28039 | Thruston Morton M001022 | sen | KY | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
28040 | 28040 | Thruston Morton M001022 | sen | KY | 1963-01-09 | 1968-12-16 | 3 | Republican | |||||||||||||
28802 | 28802 | John Cooper C000758 | sen | KY | 1946-01-01 | 1949-01-03 | 2 | Republican | |||||||||||||
28803 | 28803 | John Cooper C000758 | sen | KY | 1952-01-01 | 1955-01-03 | 2 | Republican | |||||||||||||
28804 | 28804 | John Cooper C000758 | sen | KY | 1956-01-01 | 1961-01-03 | 2 | Republican | |||||||||||||
28805 | 28805 | John Cooper C000758 | sen | KY | 1961-01-03 | 1967-01-03 | 2 | Republican | |||||||||||||
28806 | 28806 | John Cooper C000758 | sen | KY | 1967-01-10 | 1973-01-03 | 2 | Republican | |||||||||||||
29096 | 29096 | Marlow Cook C000721 | sen | KY | 1968-12-17 | 1969-01-03 | 3 | Republican | |||||||||||||
29097 | 29097 | Marlow Cook C000721 | sen | KY | 1969-01-03 | 1974-12-27 | 3 | Republican | |||||||||||||
32114 | 32114 | Walter Huddleston H000905 | sen | KY | 1973-01-03 | 1979-01-03 | 2 | Democrat | |||||||||||||
32115 | 32115 | Walter Huddleston H000905 | sen | KY | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
35260 | 35260 | Wendell Ford F000268 | sen | KY | 1974-12-28 | 1975-01-03 | 3 | Democrat | |||||||||||||
35261 | 35261 | Wendell Ford F000268 | sen | KY | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
35262 | 35262 | Wendell Ford F000268 | sen | KY | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
35263 | 35263 | Wendell Ford F000268 | sen | KY | 1987-01-06 | 1993-01-03 | 3 | 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);