legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,175 rows where state = "KY" sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: class, address, phone, contact_form, office, state_rank, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||
2628 | 2628 | Robert Henry H000517 | rep | KY | 1823-12-01 | 1825-03-03 | 12 | ||||||||||||||
2643 | 2643 | Francis Johnson J000129 | rep | KY | 1823-12-01 | 1825-03-03 | 10 | ||||||||||||||
2808 | 2808 | Richard Buckner B001033 | rep | KY | 1823-12-01 | 1825-03-03 | 8 | ||||||||||||||
2911 | 2911 | Thomas Moore M000921 | rep | KY | 1823-12-01 | 1825-03-03 | 7 | ||||||||||||||
3016 | 3016 | William Young Y000057 | rep | KY | 1827-12-03 | 1829-03-03 | -1 | ||||||||||||||
3723 | 3723 | Robert Letcher L000257 | rep | KY | 1823-12-01 | 1825-03-03 | 4 | ||||||||||||||
3726 | 3726 | Robert Letcher L000257 | rep | KY | 1829-12-07 | 1831-03-03 | 4 | ||||||||||||||
3727 | 3727 | Robert Letcher L000257 | rep | KY | 1831-12-05 | 1833-03-03 | 4 | ||||||||||||||
3728 | 3728 | Robert Letcher L000257 | rep | KY | 1833-12-02 | 1835-03-03 | 5 | ||||||||||||||
2627 | 2627 | John Henry H000509 | rep | KY | 1825-12-05 | 1827-03-03 | Adams | 12 | |||||||||||||
2644 | 2644 | Francis Johnson J000129 | rep | KY | 1825-12-05 | 1827-03-03 | Adams | 10 | |||||||||||||
2733 | 2733 | David Trimble T000372 | rep | KY | 1825-12-05 | 1827-03-03 | Adams | 1 | |||||||||||||
2809 | 2809 | Richard Buckner B001033 | rep | KY | 1825-12-05 | 1827-03-03 | Adams | 8 | |||||||||||||
2810 | 2810 | Richard Buckner B001033 | rep | KY | 1827-12-03 | 1829-03-03 | Adams | 8 | |||||||||||||
3015 | 3015 | William Young Y000057 | rep | KY | 1825-12-05 | 1827-03-03 | Adams | 11 | |||||||||||||
3064 | 3064 | James Clark C000436 | rep | KY | 1825-12-05 | 1827-03-03 | Adams | 3 | |||||||||||||
3065 | 3065 | James Clark C000436 | rep | KY | 1827-12-03 | 1829-03-03 | Adams | 3 | |||||||||||||
3724 | 3724 | Robert Letcher L000257 | rep | KY | 1825-12-05 | 1827-03-03 | Adams | 4 | |||||||||||||
3725 | 3725 | Robert Letcher L000257 | rep | KY | 1827-12-03 | 1829-03-03 | Adams | 4 | |||||||||||||
4149 | 4149 | John Calhoon C000043 | rep | KY | 1827-12-03 | 1829-03-03 | Adams | 11 | |||||||||||||
4162 | 4162 | John Chambers C000285 | rep | KY | 1827-12-03 | 1829-03-03 | Adams | 2 | |||||||||||||
5883 | 5883 | Thomas Metcalfe M000676 | rep | KY | 1825-12-05 | 1827-03-03 | Adams | 2 | |||||||||||||
5884 | 5884 | Thomas Metcalfe M000676 | rep | KY | 1827-12-03 | 1829-03-03 | Adams | 2 | |||||||||||||
6724 | 6724 | John Thompson T000208 | sen | KY | 1853-12-05 | 1859-03-03 | 2 | American | |||||||||||||
6784 | 6784 | John Campbell C000094 | rep | KY | 1855-12-03 | 1857-03-03 | American | 2 | |||||||||||||
6794 | 6794 | Leander Cox C000837 | rep | KY | 1855-12-03 | 1857-03-03 | American | 9 | |||||||||||||
6868 | 6868 | Alexander Marshall M000149 | rep | KY | 1855-12-03 | 1857-03-03 | American | 8 | |||||||||||||
6929 | 6929 | Samuel Swope S001130 | rep | KY | 1855-12-03 | 1857-03-03 | American | 10 | |||||||||||||
7143 | 7143 | Humphrey Marshall M000154 | rep | KY | 1855-12-03 | 1857-03-03 | American | 7 | |||||||||||||
7144 | 7144 | Humphrey Marshall M000154 | rep | KY | 1857-12-07 | 1859-03-03 | American | 7 | |||||||||||||
7240 | 7240 | Warner Underwood U000016 | rep | KY | 1855-12-03 | 1857-03-03 | American | 3 | |||||||||||||
7241 | 7241 | Warner Underwood U000016 | rep | KY | 1857-12-07 | 1859-03-03 | American | 3 | |||||||||||||
7726 | 7726 | John Crittenden C000912 | sen | KY | 1855-12-03 | 1861-03-03 | 3 | American | |||||||||||||
3612 | 3612 | Martin Beaty B000285 | rep | KY | 1833-12-02 | 1835-03-03 | Anti Jackson | 4 | |||||||||||||
3641 | 3641 | Thomas Chilton C000359 | rep | KY | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 6 | |||||||||||||
3658 | 3658 | Amos Davis D000092 | rep | KY | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 11 | |||||||||||||
3729 | 3729 | James Love L000455 | rep | KY | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 9 | |||||||||||||
3739 | 3739 | Thomas Marshall M000161 | rep | KY | 1831-12-05 | 1833-03-03 | Anti Jacksonian | 2 | |||||||||||||
3740 | 3740 | Thomas Marshall M000161 | rep | KY | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 12 | |||||||||||||
3810 | 3810 | Christopher Tompkins T000304 | rep | KY | 1831-12-05 | 1833-03-03 | Anti Jacksonian | 10 | |||||||||||||
3811 | 3811 | Christopher Tompkins T000304 | rep | KY | 1833-12-02 | 1835-03-03 | Anti Jacksonian | 3 | |||||||||||||
70 | 70 | John Edwards E000075 | sen | KY | 1792-01-01 | 1795-03-03 | 3 | Anti-Administration | |||||||||||||
4302 | 4302 | John Murray M001110 | rep | KY | 1837-09-04 | 1839-03-03 | Democrat | 1 | |||||||||||||
4719 | 4719 | William Butler B001197 | rep | KY | 1839-12-02 | 1841-03-03 | Democrat | 13 | |||||||||||||
4720 | 4720 | William Butler B001197 | rep | KY | 1841-05-31 | 1843-03-03 | Democrat | 13 | |||||||||||||
5472 | 5472 | John Martin M000189 | rep | KY | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
5542 | 5542 | John Tibbatts T000261 | rep | KY | 1843-12-04 | 1845-03-03 | Democrat | 10 | |||||||||||||
5543 | 5543 | John Tibbatts T000261 | rep | KY | 1845-12-01 | 1847-03-03 | Democrat | 10 | |||||||||||||
5649 | 5649 | Beverly Clarke C000458 | rep | KY | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
5696 | 5696 | Richard French F000379 | rep | KY | 1843-12-04 | 1845-03-03 | Democrat | 9 | |||||||||||||
5697 | 5697 | Richard French F000379 | rep | KY | 1847-12-06 | 1849-03-03 | Democrat | 9 | |||||||||||||
5923 | 5923 | George Caldwell C000031 | rep | KY | 1843-12-04 | 1845-03-03 | Democrat | 4 | |||||||||||||
5924 | 5924 | George Caldwell C000031 | rep | KY | 1849-12-03 | 1851-03-03 | Democrat | 4 | |||||||||||||
6427 | 6427 | James Stone S000958 | rep | KY | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
6428 | 6428 | James Stone S000958 | rep | KY | 1851-12-01 | 1853-03-03 | Democrat | 5 | |||||||||||||
6475 | 6475 | David Meriwether M000650 | sen | KY | 1852-01-01 | 1853-03-03 | 3 | Democrat | |||||||||||||
6523 | 6523 | Linn Boyd B000719 | rep | KY | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
6524 | 6524 | Linn Boyd B000719 | rep | KY | 1841-05-31 | 1843-03-03 | Democrat | 1 | |||||||||||||
6525 | 6525 | Linn Boyd B000719 | rep | KY | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
6526 | 6526 | Linn Boyd B000719 | rep | KY | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
6527 | 6527 | Linn Boyd B000719 | rep | KY | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
6528 | 6528 | Linn Boyd B000719 | rep | KY | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6529 | 6529 | Linn Boyd B000719 | rep | KY | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
6530 | 6530 | Linn Boyd B000719 | rep | KY | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6544 | 6544 | James Chrisman C000376 | rep | KY | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
6702 | 6702 | Richard Stanton S000806 | rep | KY | 1849-12-03 | 1851-03-03 | Democrat | 10 | |||||||||||||
6703 | 6703 | Richard Stanton S000806 | rep | KY | 1851-12-01 | 1853-03-03 | Democrat | 10 | |||||||||||||
6704 | 6704 | Richard Stanton S000806 | rep | KY | 1853-12-05 | 1855-03-03 | Democrat | 10 | |||||||||||||
7014 | 7014 | James Clay C000483 | rep | KY | 1857-12-07 | 1859-03-03 | Democrat | 8 | |||||||||||||
7038 | 7038 | John Elliott E000125 | rep | KY | 1853-12-05 | 1855-03-03 | Democrat | 6 | |||||||||||||
7039 | 7039 | John Elliott E000125 | rep | KY | 1855-12-03 | 1857-03-03 | Democrat | 6 | |||||||||||||
7040 | 7040 | John Elliott E000125 | rep | KY | 1857-12-07 | 1859-03-03 | Democrat | 6 | |||||||||||||
7099 | 7099 | Joshua Jewett J000106 | rep | KY | 1855-12-03 | 1857-03-03 | Democrat | 5 | |||||||||||||
7100 | 7100 | Joshua Jewett J000106 | rep | KY | 1857-12-07 | 1859-03-03 | Democrat | 5 | |||||||||||||
7149 | 7149 | John Mason M000218 | rep | KY | 1849-12-03 | 1851-03-03 | Democrat | 9 | |||||||||||||
7150 | 7150 | John Mason M000218 | rep | KY | 1851-12-01 | 1853-03-03 | Democrat | 9 | |||||||||||||
7151 | 7151 | John Mason M000218 | rep | KY | 1857-12-07 | 1859-03-03 | Democrat | 9 | |||||||||||||
7232 | 7232 | Albert Talbott T000020 | rep | KY | 1855-12-03 | 1857-03-03 | Democrat | 4 | |||||||||||||
7233 | 7233 | Albert Talbott T000020 | rep | KY | 1857-12-07 | 1859-03-03 | Democrat | 4 | |||||||||||||
7541 | 7541 | Samuel Peyton P000284 | rep | KY | 1847-12-06 | 1849-03-03 | Democrat | 3 | |||||||||||||
7542 | 7542 | Samuel Peyton P000284 | rep | KY | 1857-12-07 | 1859-03-03 | Democrat | 2 | |||||||||||||
7543 | 7543 | Samuel Peyton P000284 | rep | KY | 1859-12-05 | 1861-03-03 | Democrat | 2 | |||||||||||||
7546 | 7546 | Lazarus Powell P000481 | sen | KY | 1859-12-05 | 1865-03-03 | 2 | Democrat | |||||||||||||
7567 | 7567 | William Simms S000421 | rep | KY | 1859-12-05 | 1861-03-03 | Democrat | 8 | |||||||||||||
7671 | 7671 | John Breckinridge B000789 | rep | KY | 1851-12-01 | 1853-03-03 | Democrat | 8 | |||||||||||||
7672 | 7672 | John Breckinridge B000789 | rep | KY | 1853-12-05 | 1855-03-03 | Democrat | 8 | |||||||||||||
7673 | 7673 | John Breckinridge B000789 | sen | KY | 1861-07-04 | 1861-12-31 | 3 | Democrat | |||||||||||||
7677 | 7677 | Henry Burnett B001120 | rep | KY | 1855-12-03 | 1857-03-03 | Democrat | 1 | |||||||||||||
7678 | 7678 | Henry Burnett B001120 | rep | KY | 1857-12-07 | 1859-03-03 | Democrat | 1 | |||||||||||||
7679 | 7679 | Henry Burnett B001120 | rep | KY | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
7680 | 7680 | Henry Burnett B001120 | rep | KY | 1861-07-04 | 1863-03-03 | Democrat | 1 | |||||||||||||
8126 | 8126 | Henry Grider G000455 | rep | KY | 1865-12-04 | 1867-03-03 | Democrat | 3 | |||||||||||||
8131 | 8131 | James Guthrie G000534 | sen | KY | 1865-12-04 | 1869-03-03 | 2 | Democrat | |||||||||||||
8134 | 8134 | Aaron Harding H000187 | rep | KY | 1865-12-04 | 1867-03-03 | Democrat | 4 | |||||||||||||
8195 | 8195 | Burwell Ritter R000276 | rep | KY | 1865-12-04 | 1867-03-03 | Democrat | 2 | |||||||||||||
8201 | 8201 | George Shanklin S000283 | rep | KY | 1865-12-04 | 1867-03-03 | Democrat | 7 | |||||||||||||
8218 | 8218 | Andrew Ward W000126 | rep | KY | 1865-12-04 | 1867-03-03 | Democrat | 6 |
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);