legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
50 rows where party = "Democrat", state = "KY" and type = "sen"
This data as json, copyable, CSV (advanced)
Suggested facets: class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6475 | 6475 | David Meriwether M000650 | sen | KY | 1852-01-01 | 1853-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | ||||||||||||
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 | |||||||||||||
35264 | 35264 | Wendell Ford F000268 | sen | KY | 1993-01-05 | 1999-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);