legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
604 rows where party = "Democrat" and state = "KY"
This data as json, copyable, CSV (advanced)
Suggested facets: class, district, url, address, fax, contact_form, office, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
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 | |||||||||||||
8342 | 8342 | Asa Grover G000503 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 5 | |||||||||||||
8354 | 8354 | Elijah Hise H000644 | rep | KY | 1865-12-04 | 1867-03-03 | Democrat | 3 | |||||||||||||
8355 | 8355 | Elijah Hise H000644 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 3 | |||||||||||||
8605 | 8605 | Jacob Golladay G000271 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 3 | |||||||||||||
8606 | 8606 | Jacob Golladay G000271 | rep | KY | 1869-03-04 | 1871-03-03 | Democrat | 3 | |||||||||||||
8745 | 8745 | William Sweeney S001104 | rep | KY | 1869-03-04 | 1871-03-03 | Democrat | 2 | |||||||||||||
8754 | 8754 | Lawrence Trimble T000375 | rep | KY | 1865-12-04 | 1867-03-03 | Democrat | 1 | |||||||||||||
8755 | 8755 | Lawrence Trimble T000375 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 1 | |||||||||||||
8756 | 8756 | Lawrence Trimble T000375 | rep | KY | 1869-03-04 | 1871-03-03 | Democrat | 1 | |||||||||||||
8943 | 8943 | Joseph Lewis L000289 | rep | KY | 1869-03-04 | 1871-03-03 | Democrat | 3 | |||||||||||||
8944 | 8944 | Joseph Lewis L000289 | rep | KY | 1871-03-04 | 1873-03-03 | Democrat | 3 | |||||||||||||
8958 | 8958 | Henry McHenry M000468 | rep | KY | 1871-03-04 | 1873-03-03 | Democrat | 2 | |||||||||||||
8999 | 8999 | John Rice R000202 | rep | KY | 1869-03-04 | 1871-03-03 | Democrat | 9 | |||||||||||||
9000 | 9000 | John Rice R000202 | rep | KY | 1871-03-04 | 1873-03-03 | Democrat | 9 | |||||||||||||
9027 | 9027 | John Stevenson S000894 | rep | KY | 1857-12-07 | 1859-03-03 | Democrat | 10 | |||||||||||||
9028 | 9028 | John Stevenson S000894 | rep | KY | 1859-12-05 | 1861-03-03 | Democrat | 10 | |||||||||||||
9029 | 9029 | John Stevenson S000894 | sen | KY | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
9063 | 9063 | Boyd Winchester W000628 | rep | KY | 1869-03-04 | 1871-03-03 | Democrat | 5 | |||||||||||||
9064 | 9064 | Boyd Winchester W000628 | rep | KY | 1871-03-04 | 1873-03-03 | Democrat | 5 | |||||||||||||
9066 | 9066 | Willis Machen M000012 | sen | KY | 1872-09-27 | 1873-03-03 | 3 | Democrat | |||||||||||||
9067 | 9067 | George Adams A000035 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 8 | |||||||||||||
9068 | 9068 | George Adams A000035 | rep | KY | 1869-03-04 | 1871-03-03 | Democrat | 8 | |||||||||||||
9069 | 9069 | George Adams A000035 | rep | KY | 1871-03-04 | 1873-03-03 | Democrat | 8 | |||||||||||||
9070 | 9070 | George Adams A000035 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 9 | |||||||||||||
9079 | 9079 | William Arthur A000304 | rep | KY | 1871-03-04 | 1873-03-03 | Democrat | 6 | |||||||||||||
9080 | 9080 | William Arthur A000304 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 6 | |||||||||||||
9140 | 9140 | Edward Crossland C000933 | rep | KY | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
9141 | 9141 | Edward Crossland C000933 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
9323 | 9323 | William Read R000094 | rep | KY | 1871-03-04 | 1873-03-03 | Democrat | 4 | |||||||||||||
9324 | 9324 | William Read R000094 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
9386 | 9386 | Elisha Standiford S000790 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 5 | |||||||||||||
9427 | 9427 | John Young Y000044 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 10 | |||||||||||||
9456 | 9456 | John Brown B000933 | rep | KY | 1859-12-05 | 1861-03-03 | Democrat | 5 | |||||||||||||
9457 | 9457 | John Brown B000933 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | -1 | |||||||||||||
9458 | 9458 | John Brown B000933 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 2 | |||||||||||||
9459 | 9459 | John Brown B000933 | rep | KY | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
9547 | 9547 | Thomas Jones J000253 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 6 | |||||||||||||
9548 | 9548 | Thomas Jones J000253 | rep | KY | 1869-03-04 | 1871-03-03 | Democrat | 6 | |||||||||||||
9549 | 9549 | Thomas Jones J000253 | rep | KY | 1875-12-06 | 1877-03-03 | Democrat | 6 | |||||||||||||
9588 | 9588 | Charles Milliken M000768 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 3 | |||||||||||||
9589 | 9589 | Charles Milliken M000768 | rep | KY | 1875-12-06 | 1877-03-03 | Democrat | 3 |
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);