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 legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: class, district, url, phone, fax, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3284 | 3284 | John Adair A000026 | sen | KY | 1805-12-02 | 1807-03-03 | 3 | Republican | |||||||||||||
3285 | 3285 | John Adair A000026 | rep | KY | 1831-12-05 | 1833-03-03 | Jackson | 7 | |||||||||||||
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 | |||||||||||||
7272 | 7272 | Green Adams A000036 | rep | KY | 1847-12-06 | 1849-03-03 | Whig | 6 | |||||||||||||
7273 | 7273 | Green Adams A000036 | rep | KY | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 6 | |||||||||||||
12394 | 12394 | Silas Adams A000047 | rep | KY | 1893-08-07 | 1895-03-03 | Republican | 11 | |||||||||||||
3831 | 3831 | Chilton Allan A000108 | rep | KY | 1831-12-05 | 1833-03-03 | Whig | 3 | |||||||||||||
3832 | 3832 | Chilton Allan A000108 | rep | KY | 1833-12-02 | 1835-03-03 | Whig | 10 | |||||||||||||
3833 | 3833 | Chilton Allan A000108 | rep | KY | 1835-12-07 | 1837-03-03 | Whig | 10 | |||||||||||||
13843 | 13843 | Henry Allen A000125 | rep | KY | 1899-12-04 | 1901-03-03 | Democrat | 2 | |||||||||||||
13844 | 13844 | Henry Allen A000125 | rep | KY | 1901-12-02 | 1903-03-03 | Democrat | 2 | |||||||||||||
7908 | 7908 | Lucien Anderson A000201 | rep | KY | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 1 | |||||||||||||
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 | |||||||||||||
4397 | 4397 | Simeon Anderson A000232 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
7278 | 7278 | William Anderson A000237 | rep | KY | 1859-12-05 | 1861-03-03 | Ind. Republican-Democrat | 4 | |||||||||||||
4662 | 4662 | Landaff Andrews A000247 | rep | KY | 1839-12-02 | 1841-03-03 | Whig | 11 | |||||||||||||
4663 | 4663 | Landaff Andrews A000247 | rep | KY | 1841-05-31 | 1843-03-03 | Whig | 11 | |||||||||||||
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 | |||||||||||||
36133 | 36133 | Henry Baesler B000028 | rep | KY | 1993-01-05 | 1995-01-03 | Democrat | 6 | |||||||||||||
36134 | 36134 | Henry Baesler B000028 | rep | KY | 1995-01-04 | 1997-01-03 | Democrat | 6 | |||||||||||||
36135 | 36135 | Henry Baesler B000028 | rep | KY | 1997-01-07 | 1999-01-03 | Democrat | 6 | |||||||||||||
25867 | 25867 | Alben Barkley B000145 | rep | KY | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
25868 | 25868 | Alben Barkley B000145 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
25869 | 25869 | Alben Barkley B000145 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
25870 | 25870 | Alben Barkley B000145 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
25871 | 25871 | Alben Barkley B000145 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 1 | |||||||||||||
25872 | 25872 | Alben Barkley B000145 | rep | KY | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
25873 | 25873 | Alben Barkley B000145 | rep | KY | 1925-12-07 | 1927-03-04 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
35123 | 35123 | Thomas Barlow B000151 | rep | KY | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
25130 | 25130 | Joseph Bates B000237 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 8 | |||||||||||||
25131 | 25131 | Joseph Bates B000237 | rep | KY | 1939-01-03 | 1941-01-03 | Democrat | 8 | |||||||||||||
25132 | 25132 | Joseph Bates B000237 | rep | KY | 1941-01-03 | 1943-01-03 | Democrat | 8 | |||||||||||||
25133 | 25133 | Joseph Bates B000237 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
25134 | 25134 | Joseph Bates B000237 | rep | KY | 1945-01-03 | 1947-01-03 | Democrat | 8 | |||||||||||||
25135 | 25135 | Joseph Bates B000237 | rep | KY | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
25136 | 25136 | Joseph Bates B000237 | rep | KY | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
25137 | 25137 | Joseph Bates B000237 | rep | KY | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
3612 | 3612 | Martin Beaty B000285 | rep | KY | 1833-12-02 | 1835-03-03 | Anti Jackson | 4 | |||||||||||||
11599 | 11599 | James Beck B000289 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 7 | |||||||||||||
11600 | 11600 | James Beck B000289 | rep | KY | 1869-03-04 | 1871-03-03 | Democrat | 7 | |||||||||||||
11601 | 11601 | James Beck B000289 | rep | KY | 1871-03-04 | 1873-03-03 | Democrat | 7 | |||||||||||||
11602 | 11602 | James Beck B000289 | rep | KY | 1873-12-01 | 1875-03-03 | Democrat | 7 | |||||||||||||
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 | |||||||||||||
16688 | 16688 | John Beckham B000293 | sen | KY | 1915-12-06 | 1921-03-03 | 3 | Democrat | |||||||||||||
12407 | 12407 | William Beckner B000294 | rep | KY | 1893-08-07 | 1895-03-03 | Democrat | 10 | |||||||||||||
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 | |||||||||||||
5358 | 5358 | Joshua Bell B000343 | rep | KY | 1845-12-01 | 1847-03-03 | Whig | 4 | |||||||||||||
15341 | 15341 | Joseph Bennett B000378 | rep | KY | 1905-12-04 | 1907-03-03 | Republican | 9 | |||||||||||||
15342 | 15342 | Joseph Bennett B000378 | rep | KY | 1907-12-02 | 1909-03-03 | Republican | 9 | |||||||||||||
15343 | 15343 | Joseph Bennett B000378 | rep | KY | 1909-03-15 | 1911-03-03 | Republican | 9 | |||||||||||||
13572 | 13572 | Albert Berry B000414 | rep | KY | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
13573 | 13573 | Albert Berry B000414 | rep | KY | 1895-12-02 | 1897-03-03 | Democrat | 6 | |||||||||||||
13574 | 13574 | Albert Berry B000414 | rep | KY | 1897-03-15 | 1899-03-03 | Democrat | 6 | |||||||||||||
13575 | 13575 | Albert Berry B000414 | rep | KY | 1899-12-04 | 1901-03-03 | Democrat | 6 | |||||||||||||
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 | |||||||||||||
13863 | 13863 | Joseph Blackburn B000508 | rep | KY | 1875-12-06 | 1877-03-03 | Democrat | 7 | |||||||||||||
13864 | 13864 | Joseph Blackburn B000508 | rep | KY | 1877-10-15 | 1879-03-03 | Democrat | 7 | |||||||||||||
13865 | 13865 | Joseph Blackburn B000508 | rep | KY | 1879-03-18 | 1881-03-03 | Democrat | 7 | |||||||||||||
13866 | 13866 | Joseph Blackburn B000508 | rep | KY | 1881-12-05 | 1883-03-03 | Democrat | 7 | |||||||||||||
13867 | 13867 | Joseph Blackburn B000508 | rep | KY | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
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 | |||||||||||||
19587 | 19587 | Robert Blackburn B000509 | rep | KY | 1929-04-15 | 1931-03-03 | Republican | 7 | |||||||||||||
1289 | 1289 | Jesse Bledsoe B000554 | sen | KY | 1813-05-24 | 1815-03-03 | 3 | Republican | |||||||||||||
9744 | 9744 | Andrew Boone B000629 | rep | KY | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9745 | 9745 | Andrew Boone B000629 | rep | KY | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
14251 | 14251 | Vincent Boreing B000637 | rep | KY | 1899-12-04 | 1901-03-03 | Republican | 11 | |||||||||||||
14252 | 14252 | Vincent Boreing B000637 | rep | KY | 1901-12-02 | 1903-03-03 | Republican | 11 | |||||||||||||
14253 | 14253 | Vincent Boreing B000637 | rep | KY | 1903-11-09 | 1905-03-03 | Republican | 11 | |||||||||||||
6522 | 6522 | Linn Boyd B000719 | rep | KY | 1835-12-07 | 1837-03-03 | Jackson | 1 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
15355 | 15355 | William Bradley B000749 | sen | KY | 1909-03-15 | 1915-03-03 | 3 | Republican | |||||||||||||
5912 | 5912 | Daniel Breck B000782 | rep | KY | 1849-12-03 | 1851-03-03 | Whig | 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);