legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by how descending
This data as json, copyable, CSV (advanced)
Suggested facets: class, party, how, phone, fax, contact_form, office, state_rank, rss_url, start (date)
end (date) 655 ✖
- 1919-03-03 506
- 1931-03-03 502
- 1921-03-03 499
- 1933-03-03 499
- 1923-03-03 498
- 1941-01-03 498
- 1915-03-03 494
- 1925-03-03 493
- 1945-01-03 493
- 1939-01-03 492
- 1929-03-03 489
- 1963-01-03 489
- 1943-01-03 488
- 1947-01-03 488
- 1935-01-03 486
- 1949-01-03 486
- 1953-01-03 486
- 1917-03-03 485
- 1937-01-03 485
- 1955-01-03 485
- 1927-03-04 484
- 1961-01-03 483
- 1971-01-03 483
- 1951-01-03 482
- 1965-01-03 482
- 1983-01-03 481
- 1959-01-03 480
- 1977-01-03 480
- 1967-01-03 479
- 1975-01-03 479
- 1981-01-03 479
- 1987-01-03 478
- 1957-01-03 477
- 1973-01-03 477
- 1979-01-03 477
- 1985-01-03 477
- 2015-01-03 476
- 1989-01-03 475
- 1993-01-03 475
- 1969-01-03 474
- 1995-01-03 474
- 1991-01-03 473
- 1999-01-03 473
- 2001-01-03 473
- 2011-01-03 473
- 2017-01-03 473
- 1997-01-03 472
- 2005-01-03 472
- 2009-01-03 472
- 2023-01-03 472
- 2003-01-03 471
- 2007-01-03 471
- 2013-01-03 470
- 2019-01-03 470
- 2021-01-03 469
- 1913-03-03 452
- 1909-03-03 446
- 1911-03-03 444
- 1905-03-03 438
- 1907-03-03 438
- 1895-03-03 415
- 1901-03-03 415
- 1903-03-03 409
- 1897-03-03 406
- 1899-03-03 404
- 1891-03-03 391
- 1893-03-03 383
- 1885-03-03 380
- 1887-03-03 371
- 1889-03-03 364
- 1877-03-03 347
- 1875-03-03 345
- 1883-03-03 344
- 1881-03-03 338
- 1879-03-03 337
- 1871-03-03 297
- 1873-03-03 289
- 1837-03-03 286
- 1843-03-03 286
- 1841-03-03 285
- 1835-03-03 281
- 1839-03-03 281
- 1859-03-03 280
- 1855-03-03 275
- 1861-03-03 275
- 1851-03-03 273
- 1869-03-03 271
- 1853-03-03 269
- 1857-03-03 268
- 1849-03-03 265
- 1847-03-03 262
- 1845-03-03 260
- 1827-03-03 252
- 1829-03-03 249
- 1831-03-03 247
- 1833-03-03 244
- 1825-03-03 243
- 1863-03-03 236
- 1867-03-03 236
- 1823-03-03 230
- 1817-03-03 225
- 1821-03-03 223
- 1815-03-03 222
- 1865-03-03 220
- 1819-03-03 216
- 1807-03-03 170
- 1809-03-03 169
- 1811-03-03 168
- 1813-03-03 166
- 1805-03-03 165
- 1799-03-03 135
- 1801-03-03 130
- 1803-03-03 130
- 1797-03-03 129
- 1795-03-03 121
- 1793-03-03 82
- 1791-03-03 78
- 2025-01-03 33
- 2027-01-03 33
- 1861-12-31 20
- 1941-12-31 11
- 1945-12-31 8
- 1911-12-31 7
- 1913-12-31 7
- 1809-12-31 6
- 1845-12-31 6
- 1877-12-31 6
- 1801-12-31 5
- 1837-12-31 5
- 1847-12-31 5
- 1853-12-31 5
- 1881-12-31 5
- 1929-12-31 5
- 1933-12-31 5
- 1849-12-31 4
- 1857-12-31 4
- 1863-12-31 4
- 1879-12-31 4
- 1885-12-31 4
- 1891-12-31 4
- 1893-12-31 4
- 1897-12-31 4
- 1925-12-31 4
- 1953-12-31 4
- 1797-12-31 3
- 1807-12-31 3
- 1813-12-31 3
- 1817-12-31 3
- 1825-12-31 3
- 1829-12-31 3
- 1831-12-31 3
- 1833-12-31 3
- 1843-12-31 3
- 1859-12-31 3
- 1865-12-31 3
- 1871-12-31 3
- 1873-12-31 3
- 1901-12-31 3
- 1905-12-31 3
- 1907-12-31 3
- 1917-12-31 3
- 1923-12-31 3
- 1946-11-05 3
- 1949-12-31 3
- 1957-12-31 3
- 1992-12-14 3
- 1793-12-31 2
- 1803-12-31 2
- 1815-12-31 2
- 1821-12-31 2
- 1823-12-31 2
- 1835-12-31 2
- 1855-12-31 2
- 1869-12-31 2
- 1875-12-31 2
- 1895-12-31 2
- 1909-12-31 2
- 1921-12-31 2
- 1931-12-31 2
- 1935-12-31 2
- 1939-12-31 2
- 1946-07-17 2
- 1952-11-04 2
- 1963-12-31 2
- 1964-11-03 2
- 1974-12-31 2
- 1976-12-27 2
- 1976-12-28 2
- 1978-11-07 2
- 1978-12-14 2
- 1989-12-31 2
- 1991-12-31 2
- 1993-12-31 2
- 2009-01-21 2
- 2010-11-29 2
- 2018-12-31 2
- 2022-03-31 2
- 1791-12-31 1
- 1792-06-01 1
- 1793-03-02 1
- 1794-05-11 1
- 1794-05-27 1
- 1795-12-31 1
- 1796-02-20 1
- 1796-05-18 1
- 1796-06-11 1
- 1796-10-13 1
- 1796-10-14 1
- 1796-10-15 1
- 1797-03-04 1
- 1798-10-02 1
- 1799-12-31 1
- 1800-11-08 1
- 1801-12-15 1
- 1802-02-05 1
- 1803-12-07 1
- 1804-06-30 1
- 1804-11-22 1
- 1804-12-04 1
- 1805-12-31 1
- 1807-03-04 1
- 1809-11-14 1
- 1810-05-10 1
- 1810-06-10 1
- 1810-12-08 1
- 1810-12-16 1
- 1810-12-30 1
- 1811-12-31 1
- 1813-05-01 1
- 1813-11-06 1
- 1814-02-24 1
- 1814-05-20 1
- 1815-12-13 1
- 1816-11-04 1
- 1816-11-09 1
- 1816-11-15 1
- 1816-12-20 1
- 1818-09-23 1
- 1818-11-23 1
- 1819-02-17 1
- 1819-04-23 1
- 1819-12-31 1
- 1820-03-15 1
- 1821-01-08 1
- 1822-01-24 1
- 1823-01-29 1
- 1824-03-04 1
- 1824-08-21 1
- 1825-09-25 1
- 1825-12-26 1
- 1826-03-18 1
- 1826-05-23 1
- 1826-08-19 1
- 1827-12-31 1
- 1828-11-14 1
- 1829-01-12 1
- 1829-03-09 1
- 1833-03-02 1
- 1833-05-19 1
- 1833-11-08 1
- 1834-05-09 1
- 1834-06-27 1
- 1836-06-15 1
- 1836-07-04 1
- 1836-11-26 1
- 1838-01-22 1
- 1840-10-24 1
- 1840-11-16 1
- 1841-02-22 1
- 1841-12-31 1
- 1842-06-26 1
- 1844-04-15 1
- 1844-04-22 1
- 1846-08-17 1
- 1846-12-28 1
- 1848-03-15 1
- 1848-06-12 1
- 1848-10-25 1
- 1850-07-22 1
- 1852-08-07 1
- 1852-12-20 1
- 1853-04-11 1
- 1855-02-22 1
- 1860-11-10 1
- 1861-01-21 1
- 1861-07-09 1
- 1867-12-31 1
- 1871-01-22 1
- 1876-07-10 1
- 1881-03-05 1
- 1881-03-07 1
- 1881-10-04 1
- 1882-04-17 1
- 1883-12-31 1
- 1887-12-31 1
- 1889-11-11 1
- 1889-12-31 1
- 1890-07-10 1
- 1892-03-29 1
- 1894-03-12 1
- 1896-01-04 1
- 1898-05-31 1
- 1899-12-31 1
- 1900-01-12 1
- 1900-08-22 1
- 1902-05-04 1
- 1904-03-23 1
- 1904-05-28 1
- 1905-05-10 1
- 1906-01-30 1
- 1907-12-23 1
- 1909-04-04 1
- 1910-10-15 1
- 1912-03-21 1
- 1918-11-05 1
- 1918-12-16 1
- 1919-01-25 1
- 1919-11-12 1
- 1920-11-01 1
- 1921-03-04 1
- 1922-11-18 1
- 1924-08-18 1
- 1924-10-14 1
- 1924-11-09 1
- 1926-07-30 1
- 1926-10-15 1
- 1927-12-20 1
- 1928-03-23 1
- 1928-12-06 1
- 1929-01-03 1
- 1929-11-24 1
- 1930-01-10 1
- 1930-11-20 1
- 1930-11-30 1
- 1930-12-12 1
- 1930-12-17 1
- 1933-02-03 1
- 1933-11-03 1
- 1935-05-06 1
- 1935-08-09 1
- 1936-05-08 1
- 1936-10-22 1
- 1936-11-18 1
- 1937-08-19 1
- 1938-01-10 1
- 1938-01-11 1
- 1940-12-16 1
- 1940-12-19 1
- 1940-12-31 1
- 1941-02-27 1
- 1941-05-27 1
- 1942-12-06 1
- 1943-12-31 1
- 1944-02-25 1
- 1944-11-13 1
- 1944-12-13 1
- 1945-01-09 1
- 1945-06-30 1
- 1946-05-28 1
- 1946-05-31 1
- 1946-08-02 1
- 1946-09-18 1
- 1946-12-25 1
- 1947-05-24 1
- 1948-01-06 1
- 1948-02-17 1
- 1948-09-27 1
- 1948-12-26 1
- 1948-12-30 1
- 1949-01-19 1
- 1949-03-06 1
- 1949-08-23 1
- 1949-11-08 1
- 1949-12-16 1
- 1950-11-26 1
- 1950-11-30 1
- 1950-12-18 1
- 1951-03-08 1
- 1951-03-17 1
- 1951-04-18 1
- 1951-12-15 1
- 1951-12-31 1
- 1953-04-30 1
- 1954-06-19 1
- 1954-07-01 1
- 1954-08-28 1
- 1954-11-08 1
- 1956-04-04 1
- 1956-04-30 1
- 1956-11-07 1
- 1958-01-18 1
- 1959-11-08 1
- 1960-03-09 1
- 1960-08-08 1
- 1960-09-13 1
- 1960-12-22 1
- 1961-11-26 1
- 1961-12-31 1
- 1962-01-21 1
- 1962-11-18 1
- 1964-12-29 1
- 1965-11-10 1
- 1965-12-31 1
- 1966-04-30 1
- 1966-05-10 1
- 1968-12-11 1
- 1968-12-16 1
- 1968-12-27 1
- 1969-01-02 1
- 1969-08-13 1
- 1971-01-21 1
- 1971-09-16 1
- 1972-07-27 1
- 1972-10-16 1
- 1972-11-13 1
- 1972-12-08 1
- 1974-01-03 1
- 1974-12-17 1
- 1974-12-20 1
- 1974-12-23 1
- 1974-12-27 1
- 1975-02-14 1
- 1975-09-18 1
- 1976-12-30 1
- 1977-12-31 1
- 1978-01-12 1
- 1978-01-13 1
- 1978-06-01 1
- 1978-12-23 1
- 1978-12-29 1
- 1980-12-29 1
- 1982-03-11 1
- 1982-12-27 1
- 1983-04-10 1
- 1983-09-01 1
- 1983-12-03 1
- 1984-03-29 1
- 1986-06-29 1
- 1986-07-14 1
- 1986-11-04 1
- 1987-02-01 1
- 1987-05-07 1
- 1987-10-05 1
- 1987-12-31 1
- 1988-01-23 1
- 1988-04-23 1
- 1988-06-21 1
- 1989-05-30 1
- 1989-06-15 1
- 1989-06-30 1
- 1989-08-07 1
- 1989-08-13 1
- 1990-01-07 1
- 1990-01-16 1
- 1990-03-17 1
- 1990-05-15 1
- 1990-12-04 1
- 1990-12-07 1
- 1991-02-08 1
- 1991-03-08 1
- 1991-03-11 1
- 1991-05-04 1
- 1991-09-11 1
- 1991-11-04 1
- 1992-09-08 1
- 1992-09-14 1
- 1992-09-15 1
- 1993-01-02 1
- 1993-01-20 1
- 1993-01-21 1
- 1993-01-22 1
- 1993-01-31 1
- 1993-07-31 1
- 1994-01-07 1
- 1994-03-29 1
- 1994-11-15 1
- 1995-10-01 1
- 1995-10-10 1
- 1995-12-15 1
- 1995-12-31 1
- 1996-02-05 1
- 1996-02-18 1
- 1996-06-11 1
- 1996-06-22 1
- 1996-11-05 1
- 1996-11-07 1
- 1997-01-30 1
- 1997-02-13 1
- 1997-08-02 1
- 1997-10-28 1
- 1997-11-11 1
- 1997-11-17 1
- 1998-01-05 1
- 1998-02-07 1
- 1998-03-25 1
- 1999-03-01 1
- 1999-07-15 1
- 1999-10-24 1
- 2000-09-11 1
- 2001-02-05 1
- 2001-03-29 1
- 2001-05-28 1
- 2001-08-06 1
- 2001-08-16 1
- 2001-09-05 1
- 2002-02-15 1
- 2002-07-24 1
- 2002-09-09 1
- 2002-09-28 1
- 2002-10-25 1
- 2002-11-29 1
- 2002-12-19 1
- 2003-05-31 1
- 2003-12-08 1
- 2004-01-20 1
- 2004-06-11 1
- 2004-08-31 1
- 2004-09-23 1
- 2005-04-29 1
- 2005-08-02 1
- 2005-12-01 1
- 2006-01-16 1
- 2006-01-17 1
- 2006-06-09 1
- 2006-09-29 1
- 2006-11-03 1
- 2007-02-13 1
- 2007-04-22 1
- 2007-06-04 1
- 2007-07-01 1
- 2007-09-05 1
- 2007-10-06 1
- 2007-11-26 1
- 2007-12-15 1
- 2007-12-18 1
- 2007-12-31 1
- 2008-01-14 1
- 2008-02-02 1
- 2008-02-11 1
- 2008-05-31 1
- 2008-08-20 1
- 2008-11-16 1
- 2008-11-24 1
- 2009-01-15 1
- 2009-01-26 1
- 2009-02-24 1
- 2009-06-26 1
- 2009-08-25 1
- 2009-09-09 1
- 2009-09-21 1
- 2010-01-04 1
- 2010-02-04 1
- 2010-02-08 1
- 2010-03-01 1
- 2010-03-08 1
- 2010-03-22 1
- 2010-05-21 1
- 2010-06-28 1
- 2010-11-14 1
- 2010-11-15 1
- 2011-02-09 1
- 2011-02-28 1
- 2011-05-03 1
- 2011-05-09 1
- 2011-06-21 1
- 2011-08-03 1
- 2012-01-25 1
- 2012-03-06 1
- 2012-03-20 1
- 2012-07-06 1
- 2012-07-31 1
- 2012-08-15 1
- 2012-11-21 1
- 2012-12-03 1
- 2012-12-17 1
- 2013-01-01 1
- 2013-01-02 1
- 2013-01-22 1
- 2013-02-01 1
- 2013-06-03 1
- 2013-07-15 1
- 2013-07-16 1
- 2013-08-02 1
- 2013-09-27 1
- 2013-10-18 1
- 2013-10-31 1
- 2014-01-06 1
- 2014-01-27 1
- 2014-02-06 1
- 2014-02-18 1
- 2014-08-18 1
- 2015-02-06 1
- 2015-03-31 1
- 2015-10-31 1
- 2016-06-23 1
- 2016-07-20 1
- 2016-09-07 1
- 2016-12-04 1
- 2016-12-31 1
- 2017-01-23 1
- 2017-01-24 1
- 2017-02-08 1
- 2017-02-10 1
- 2017-02-16 1
- 2017-03-01 1
- 2017-06-30 1
- 2017-10-21 1
- 2017-12-05 1
- 2017-12-08 1
- 2018-01-02 1
- 2018-01-03 1
- 2018-01-15 1
- 2018-03-16 1
- 2018-04-01 1
- 2018-04-06 1
- 2018-04-23 1
- 2018-04-27 1
- 2018-05-12 1
- 2018-08-25 1
- 2018-09-10 1
- 2018-09-30 1
- 2018-11-06 1
- 2018-11-27 1
- 2019-01-23 1
- 2019-02-10 1
- 2019-09-23 1
- 2019-10-01 1
- 2019-10-17 1
- 2019-11-03 1
- 2019-12-31 1
- 2020-01-13 1
- 2020-03-30 1
- 2020-05-22 1
- 2020-07-17 1
- 2020-10-04 1
- 2020-12-02 1
- 2020-12-07 1
- 2021-01-15 1
- 2021-01-18 1
- 2021-01-20 1
- 2021-02-07 1
- 2021-03-10 1
- 2021-03-16 1
- 2021-04-06 1
- 2021-05-16 1
- 2022-01-03 1
- 2022-02-17 1
- 2022-03-18 1
- 2022-05-10 1
- 2022-05-25 1
- 2022-08-03 1
- 2022-08-31 1
- 2022-09-30 1
- 2022-11-08 1
- 2022-11-28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44439 | 44439 | Mark Kelly K000377 | sen | AZ | 2020-12-02 | 2023-01-03 | 3 | Democrat | special-election | https://www.kelly.senate.gov | 516 Hart Senate Office Building Washington DC 20510 | 202-224-2235 | https://www.kelly.senate.gov | 516 Hart Senate Office Building | junior | ||||||
44532 | 44532 | Alejandro Padilla P000145 | sen | CA | 2022-11-09 | 2023-01-03 | 3 | Democrat | special-election | https://www.padilla.senate.gov | 112 Hart Senate Office Building Washington DC 20510 | 202-224-3553 | https://www.padilla.senate.gov/contact/ | 112 Hart Senate Office Building | junior | ||||||
44534 | 44534 | Raphael Warnock W000790 | sen | GA | 2021-01-20 | 2023-01-03 | 3 | Democrat | special-election | https://www.warnock.senate.gov | 388 Russell Senate Office Building Washington DC 20510 | 202-224-3643 | https://www.warnock.senate.gov/contact/ | 388 Russell Senate Office Building | junior | ||||||
44551 | 44551 | Rudy Yakym Y000067 | rep | IN | 2022-11-14 | 2023-01-03 | Republican | 2 | special-election | ||||||||||||
16397 | 16397 | John Heiskell H000457 | sen | AR | 1913-04-07 | 1913-12-31 | 2 | Democrat | appointment | ||||||||||||
16417 | 16417 | Rienzi Johnston J000196 | sen | TX | 1913-04-07 | 1913-12-31 | 2 | Democrat | appointment | ||||||||||||
16652 | 16652 | Johnson Camden C000063 | sen | KY | 1914-06-16 | 1915-03-03 | 3 | Democrat | appointment | ||||||||||||
16660 | 16660 | William West W000305 | sen | GA | 1914-03-02 | 1915-03-03 | 2 | Democrat | appointment | ||||||||||||
17043 | 17043 | Thomas Taggart T000013 | sen | IN | 1916-03-20 | 1917-03-03 | 3 | Democrat | appointment | ||||||||||||
17520 | 17520 | David Baird B000052 | sen | NJ | 1918-02-23 | 1919-03-03 | 2 | Republican | appointment | ||||||||||||
17521 | 17521 | Christie Benet B000360 | sen | SC | 1918-07-06 | 1919-03-03 | 2 | Democrat | appointment | ||||||||||||
17522 | 17522 | Irving Drew D000495 | sen | NH | 1918-09-02 | 1919-03-03 | 3 | Republican | appointment | ||||||||||||
17524 | 17524 | Walter Guion G000522 | sen | LA | 1918-04-22 | 1919-03-03 | 3 | Democrat | appointment | ||||||||||||
17525 | 17525 | Charles Henderson H000477 | sen | NV | 1918-01-12 | 1921-03-03 | 3 | Democrat | appointment | ||||||||||||
17526 | 17526 | George Martin M000181 | sen | KY | 1918-09-07 | 1919-03-03 | 2 | Democrat | appointment | ||||||||||||
17529 | 17529 | John Nugent N000169 | sen | ID | 1918-01-22 | 1921-03-03 | 3 | Democrat | appointment | ||||||||||||
17531 | 17531 | Xenophon Wilfley W000471 | sen | MO | 1918-04-30 | 1919-03-03 | 3 | Democrat | appointment | ||||||||||||
18031 | 18031 | Braxton Comer C000657 | sen | AL | 1920-03-05 | 1921-03-03 | 2 | Democrat | appointment | ||||||||||||
18079 | 18079 | Holm Bursum B001144 | sen | NM | 1921-04-11 | 1925-03-03 | 2 | Republican | appointment | ||||||||||||
18140 | 18140 | William Crow C000938 | sen | PA | 1921-10-17 | 1923-03-03 | 1 | Republican | appointment | ||||||||||||
18560 | 18560 | Rebecca Felton F000069 | sen | GA | 1922-10-03 | 1923-03-03 | 3 | Democrat | appointment | ||||||||||||
18561 | 18561 | George Pepper P000219 | sen | PA | 1922-01-09 | 1927-03-04 | 3 | Republican | appointment | ||||||||||||
18562 | 18562 | Charles Rawson R000075 | sen | IA | 1922-02-24 | 1923-03-03 | 2 | Republican | appointment | ||||||||||||
18907 | 18907 | William Butler B001196 | sen | MA | 1924-11-13 | 1927-03-04 | 1 | Republican | appointment | ||||||||||||
19166 | 19166 | George Williams W000499 | sen | MO | 1925-12-07 | 1927-03-04 | 3 | Republican | appointment | ||||||||||||
19176 | 19176 | Thomas du Pont D000560 | sen | DE | 1921-07-07 | 1923-03-03 | 1 | Republican | appointment | ||||||||||||
19186 | 19186 | David Stewart S000906 | sen | IA | 1926-08-07 | 1927-03-04 | 3 | Republican | appointment | ||||||||||||
19570 | 19570 | Cyrus Locher L000386 | sen | OH | 1928-04-04 | 1929-03-03 | 3 | Democrat | appointment | ||||||||||||
19571 | 19571 | Henry Allen A000126 | sen | KS | 1929-04-15 | 1931-03-03 | 3 | Republican | appointment | ||||||||||||
19572 | 19572 | David Baird B000053 | sen | NJ | 1929-11-30 | 1931-03-03 | 2 | Republican | appointment | ||||||||||||
19597 | 19597 | William Brock B000850 | sen | TN | 1929-09-02 | 1931-03-03 | 2 | Democrat | appointment | ||||||||||||
19646 | 19646 | Bronson Cutting C001028 | sen | NM | 1927-12-29 | 1928-12-06 | 1 | Republican | appointment | ||||||||||||
19752 | 19752 | Joseph Grundy G000510 | sen | PA | 1929-12-11 | 1931-03-03 | 3 | Republican | appointment | ||||||||||||
19870 | 19870 | Roscoe McCulloch M000392 | sen | OH | 1929-11-05 | 1931-03-03 | 3 | Republican | appointment | ||||||||||||
19940 | 19940 | David Reed R000114 | sen | PA | 1922-08-08 | 1923-03-03 | 1 | Republican | appointment | ||||||||||||
19944 | 19944 | Arthur Robinson R000332 | sen | IN | 1925-12-07 | 1929-03-03 | 1 | Republican | appointment | ||||||||||||
20001 | 20001 | Patrick Sullivan S001060 | sen | WY | 1929-12-05 | 1930-11-20 | 2 | Republican | appointment | ||||||||||||
20071 | 20071 | Frank Partridge P000091 | sen | VT | 1930-12-23 | 1931-12-31 | 1 | Republican | appointment | ||||||||||||
20251 | 20251 | James Couzens C000812 | sen | MI | 1922-11-29 | 1925-03-03 | 2 | Republican | appointment | ||||||||||||
20478 | 20478 | Daniel Hastings H000325 | sen | DE | 1928-12-10 | 1931-03-03 | 2 | Republican | appointment | ||||||||||||
21061 | 21061 | John Cohen C000597 | sen | GA | 1932-04-25 | 1933-12-31 | 2 | Democrat | appointment | ||||||||||||
21062 | 21062 | Elijah Grammer G000366 | sen | WA | 1932-11-22 | 1933-03-03 | 3 | Republican | appointment | ||||||||||||
21065 | 21065 | Walter Walker W000069 | sen | CO | 1932-09-26 | 1933-03-03 | 3 | Democrat | appointment | ||||||||||||
21105 | 21105 | Nathan Bachman B000010 | sen | TN | 1933-03-09 | 1937-01-03 | 2 | Democrat | appointment | ||||||||||||
21253 | 21253 | John Erickson E000202 | sen | MT | 1933-03-13 | 1935-01-03 | 2 | Democrat | appointment | ||||||||||||
21583 | 21583 | William Thompson T000225 | sen | NE | 1933-05-24 | 1935-01-03 | 1 | Democrat | appointment | ||||||||||||
21640 | 21640 | Elmer Benson B000389 | sen | MN | 1935-12-27 | 1937-01-03 | 2 | Farmer-Labor | appointment | ||||||||||||
22015 | 22015 | William Hill H000612 | sen | FL | 1936-07-01 | 1937-01-03 | 3 | Democrat | appointment | ||||||||||||
22016 | 22016 | Herbert Hitchcock H000646 | sen | SD | 1936-12-29 | 1939-01-03 | 3 | Democrat | appointment | ||||||||||||
22018 | 22018 | Scott Loftin L000400 | sen | FL | 1936-05-26 | 1937-01-03 | 1 | Democrat | appointment | ||||||||||||
22019 | 22019 | Rose Long L000427 | sen | LA | 1936-01-31 | 1937-01-03 | 2 | Democrat | appointment | ||||||||||||
22036 | 22036 | George Berry B000417 | sen | TN | 1937-05-06 | 1939-01-03 | 2 | Democrat | appointment | ||||||||||||
22185 | 22185 | Dixie Graves G000391 | sen | AL | 1937-08-20 | 1938-01-10 | 3 | Democrat | appointment | ||||||||||||
22464 | 22464 | John Milton M000787 | sen | NJ | 1938-01-18 | 1939-01-03 | 1 | Democrat | appointment | ||||||||||||
22466 | 22466 | Alfred Reames R000099 | sen | OR | 1938-02-01 | 1939-01-03 | 3 | Democrat | appointment | ||||||||||||
22467 | 22467 | Thomas Storke S000973 | sen | CA | 1938-11-09 | 1939-01-03 | 3 | Democrat | appointment | ||||||||||||
22468 | 22468 | Alva Adams A000028 | sen | CO | 1923-12-03 | 1925-03-03 | 3 | Democrat | appointment | ||||||||||||
22515 | 22515 | Hattie Caraway C000138 | sen | AR | 1931-12-07 | 1933-03-03 | 3 | Democrat | appointment | ||||||||||||
22611 | 22611 | Ernest Gibson G000158 | sen | VT | 1933-11-21 | 1939-01-03 | 3 | Republican | appointment | ||||||||||||
22734 | 22734 | Gerald Nye N000176 | sen | ND | 1925-12-07 | 1927-03-04 | 3 | Republican | appointment | ||||||||||||
22782 | 22782 | James Slattery S000478 | sen | IL | 1939-04-14 | 1941-01-03 | 2 | Democrat | appointment | ||||||||||||
22840 | 22840 | Ernest Gibson G000159 | sen | VT | 1940-06-24 | 1941-12-31 | 3 | Republican | appointment | ||||||||||||
22856 | 22856 | William Barbour B000132 | sen | NJ | 1931-12-07 | 1937-01-03 | 2 | Republican | appointment | ||||||||||||
23043 | 23043 | Andrew Houston H000821 | sen | TX | 1941-04-21 | 1941-12-31 | 2 | Democrat | appointment | ||||||||||||
23106 | 23106 | Alva Lumpkin L000510 | sen | SC | 1941-07-17 | 1941-12-31 | 2 | Democrat | appointment | ||||||||||||
23170 | 23170 | Roger Peace P000159 | sen | SC | 1941-08-05 | 1941-12-31 | 2 | Democrat | appointment | ||||||||||||
23206 | 23206 | Joseph Rosier R000443 | sen | WV | 1941-01-13 | 1943-01-03 | 2 | Democrat | appointment | ||||||||||||
23257 | 23257 | George Spencer S000724 | sen | AR | 1941-04-01 | 1943-01-03 | 2 | Democrat | appointment | ||||||||||||
23344 | 23344 | Joseph Ball B000099 | sen | MN | 1940-10-14 | 1943-01-03 | 2 | Republican | appointment | ||||||||||||
23372 | 23372 | Albert Chandler C000290 | sen | KY | 1939-10-10 | 1943-01-03 | 2 | Democrat | appointment | ||||||||||||
23521 | 23521 | Carter Glass G000232 | sen | VA | 1920-02-20 | 1925-03-03 | 2 | Democrat | appointment | ||||||||||||
23548 | 23548 | Carl Hatch H000334 | sen | NM | 1933-10-10 | 1937-01-03 | 2 | Democrat | appointment | ||||||||||||
23605 | 23605 | Charles McNary M000583 | sen | OR | 1917-05-29 | 1918-11-05 | 2 | Republican | appointment | ||||||||||||
23606 | 23606 | Charles McNary M000583 | sen | OR | 1918-12-18 | 1919-03-03 | 2 | Republican | appointment | ||||||||||||
23624 | 23624 | Cameron Morrison M000993 | sen | NC | 1930-12-13 | 1933-03-03 | 3 | Democrat | appointment | ||||||||||||
23708 | 23708 | John Thomas T000172 | sen | ID | 1928-06-30 | 1933-03-03 | 3 | Republican | appointment | ||||||||||||
23709 | 23709 | John Thomas T000172 | sen | ID | 1940-01-27 | 1943-01-03 | 2 | Republican | appointment | ||||||||||||
23732 | 23732 | Arthur Walsh W000096 | sen | NJ | 1943-11-26 | 1945-01-03 | 1 | Democrat | appointment | ||||||||||||
23761 | 23761 | Wilton Hall H000080 | sen | SC | 1944-11-20 | 1945-01-03 | 3 | Democrat | appointment | ||||||||||||
23762 | 23762 | Samuel Jackson J000026 | sen | IN | 1944-01-28 | 1945-01-03 | 3 | Democrat | appointment | ||||||||||||
23763 | 23763 | Sinclair Weeks W000248 | sen | MA | 1944-02-08 | 1945-01-03 | 2 | Republican | appointment | ||||||||||||
23787 | 23787 | Frank Briggs B000828 | sen | MO | 1945-01-18 | 1947-01-03 | 1 | Democrat | appointment | ||||||||||||
23790 | 23790 | Berkeley Bunker B001061 | sen | NV | 1940-11-27 | 1941-01-03 | 1 | Democrat | appointment | ||||||||||||
23802 | 23802 | Edward Carville C000211 | sen | NV | 1945-07-25 | 1947-01-03 | 1 | Democrat | appointment | ||||||||||||
23852 | 23852 | Charles Gossett G000337 | sen | ID | 1945-11-17 | 1947-01-03 | 2 | Democrat | appointment | ||||||||||||
23873 | 23873 | Thomas Hart H000293 | sen | CT | 1945-02-15 | 1947-01-03 | 1 | Republican | appointment | ||||||||||||
23895 | 23895 | James Huffman H000913 | sen | OH | 1945-10-08 | 1947-01-03 | 1 | Democrat | appointment | ||||||||||||
24105 | 24105 | William Stanfill S000792 | sen | KY | 1945-11-19 | 1947-01-03 | 2 | Republican | appointment | ||||||||||||
24241 | 24241 | Thomas Burch B001069 | sen | VA | 1946-05-31 | 1946-11-05 | 2 | Democrat | appointment | ||||||||||||
24244 | 24244 | George Swift S001117 | sen | AL | 1946-06-15 | 1947-01-03 | 2 | Democrat | appointment | ||||||||||||
24249 | 24249 | William Umstead U000005 | sen | NC | 1946-12-18 | 1949-01-03 | 2 | Democrat | appointment | ||||||||||||
24656 | 24656 | John Robsion R000358 | sen | KY | 1930-01-11 | 1930-11-30 | 2 | Republican | appointment | ||||||||||||
24707 | 24707 | Arthur Vandenberg V000025 | sen | MI | 1928-03-31 | 1929-01-03 | 1 | Republican | appointment | ||||||||||||
24730 | 24730 | Vera Bushfield B001169 | sen | SD | 1948-10-06 | 1948-12-26 | 2 | Republican | appointment | ||||||||||||
24731 | 24731 | William Feazel F000057 | sen | LA | 1948-05-18 | 1949-01-03 | 3 | Democrat | appointment | ||||||||||||
24739 | 24739 | William Benton B000399 | sen | CT | 1949-12-17 | 1953-01-03 | 1 | Democrat | appointment | ||||||||||||
24812 | 24812 | Guy Cordon C000774 | sen | OR | 1944-03-04 | 1949-01-03 | 2 | Republican | appointment | ||||||||||||
24815 | 24815 | Harry Darby D000048 | sen | KS | 1949-12-02 | 1951-01-03 | 3 | Republican | appointment | ||||||||||||
24821 | 24821 | John Dulles D000522 | sen | NY | 1949-07-07 | 1949-12-31 | 3 | Republican | appointment | ||||||||||||
24842 | 24842 | Frank Graham G000353 | sen | NC | 1949-03-29 | 1951-01-03 | 2 | Democrat | appointment |
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);