legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44551 | 44551 | Rudy Yakym Y000067 | rep | IN | 2022-11-14 | 2023-01-03 | Republican | 2 | special-election | ||||||||||||
44550 | 44550 | Joseph Sempolinski S001219 | rep | NY | 2022-09-13 | 2023-01-03 | Republican | 23 | 1203 Longworth House Office Building Washington DC 20515-3223 | 202-225-3161 | 1203 Longworth House Office Building | ||||||||||
44549 | 44549 | Patrick Ryan R000579 | rep | NY | 2022-09-13 | 2023-01-03 | Democrat | 19 | 1007 Longworth House Office Building Washington DC 20515-3219 | 202-225-5614 | 1007 Longworth House Office Building | ||||||||||
44548 | 44548 | Mary Peltola P000619 | rep | AK | 2022-09-13 | 2023-01-03 | Democrat | 0 | https://peltola.house.gov | 2314 Rayburn House Office Building Washington DC 20515-0200 | 202-225-5765 | 2314 Rayburn House Office Building | |||||||||
44547 | 44547 | Brad Finstad F000475 | rep | MN | 2022-08-12 | 2023-01-03 | Republican | 1 | 1433 Longworth House Office Building Washington DC 20515-2301 | 202-225-2472 | 1433 Longworth House Office Building | ||||||||||
44546 | 44546 | Mike Flood F000474 | rep | NE | 2022-07-12 | 2023-01-03 | Republican | 1 | 1514 Longworth House Office Building Washington DC 20515-2701 | 202-225-4806 | 1514 Longworth House Office Building | ||||||||||
44545 | 44545 | Mayra Flores F000473 | rep | TX | 2022-06-21 | 2023-01-03 | Republican | 34 | 307 Cannon House Office Building Washington DC 20515-4334 | 202-225-9901 | 307 Cannon House Office Building | ||||||||||
44544 | 44544 | Connie Conway C001128 | rep | CA | 2022-06-07 | 2023-01-03 | Republican | 22 | 1013 Longworth House Office Building Washington DC 20515-0522 | 202-225-2523 | 1013 Longworth House Office Building | ||||||||||
44543 | 44543 | Sheila Cherfilus-McCormick C001127 | rep | FL | 2022-01-18 | 2023-01-03 | Democrat | 20 | https://cherfilus-mccormick.house.gov | 2365 Rayburn House Office Building Washington DC 20515-0920 | 202-225-1313 | 2365 Rayburn House Office Building | |||||||||
44542 | 44542 | Mike Carey C001126 | rep | OH | 2021-11-04 | 2023-01-03 | Republican | 15 | https://carey.house.gov | 2234 Rayburn House Office Building Washington DC 20515-3515 | 202-225-2015 | 2234 Rayburn House Office Building | |||||||||
44541 | 44541 | Shontel Brown B001313 | rep | OH | 2021-11-04 | 2023-01-03 | Democrat | 11 | https://shontelbrown.house.gov | 2344 Rayburn House Office Building Washington DC 20515-3511 | 202-225-7032 | 2344 Rayburn House Office Building | |||||||||
44540 | 44540 | Jake Ellzey E000071 | rep | TX | 2021-07-30 | 2023-01-03 | Republican | 6 | https://ellzey.house.gov | 1725 Longworth House Office Building Washington DC 20515-4306 | 202-225-2002 | 1725 Longworth House Office Building | |||||||||
44539 | 44539 | Melanie Stansbury S001218 | rep | NM | 2021-06-14 | 2023-01-03 | Democrat | 1 | https://stansbury.house.gov | 1421 Longworth House Office Building Washington DC 20515-3101 | 202-225-6316 | 1421 Longworth House Office Building | |||||||||
44538 | 44538 | Troy Carter C001125 | rep | LA | 2021-05-11 | 2023-01-03 | Democrat | 2 | https://troycarter.house.gov | 506 Cannon House Office Building Washington DC 20515-1802 | 202-225-6636 | 506 Cannon House Office Building | |||||||||
44537 | 44537 | Julia Letlow L000595 | rep | LA | 2021-04-14 | 2023-01-03 | Republican | 5 | https://letlow.house.gov | 1408 Longworth House Office Building Washington DC 20515-1805 | 202-225-8490 | 1408 Longworth House Office Building | |||||||||
44536 | 44536 | Claudia Tenney T000478 | rep | NY | 2021-02-11 | 2023-01-03 | Republican | 22 | https://tenney.house.gov | 1410 Longworth House Office Building Washington DC 20515-3222 | 202-225-3665 | 1410 Longworth House Office Building | |||||||||
44535 | 44535 | Claudia Tenney T000478 | rep | NY | 2017-01-03 | 2019-01-03 | Republican | 22 | https://tenney.house.gov | 512 Cannon House Office Building; Washington DC 20515-3222 | 202-225-3665 | 512 Cannon House Office Building | |||||||||
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 | ||||||
44533 | 44533 | Jon Ossoff O000174 | sen | GA | 2021-01-20 | 2027-01-03 | 2 | Democrat | https://www.ossoff.senate.gov | 455 Russell Senate Office Building Washington DC 20510 | 202-224-3521 | https://www.ossoff.senate.gov/contact-us/ | 455 Russell Senate Office Building | senior | |||||||
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 | ||||||
44531 | 44531 | Alejandro Padilla P000145 | sen | CA | 2021-01-20 | 2022-11-08 | 3 | Democrat | appointment | 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 | ||||||
44530 | 44530 | Scott Fitzgerald F000471 | rep | WI | 2021-01-03 | 2023-01-03 | Republican | 5 | https://fitzgerald.house.gov | 1507 Longworth House Office Building Washington DC 20515-4905 | 202-225-5101 | 1507 Longworth House Office Building | |||||||||
44529 | 44529 | Marilyn Strickland S001159 | rep | WA | 2021-01-03 | 2023-01-03 | Democrat | 10 | https://strickland.house.gov | 1004 Longworth House Office Building Washington DC 20515-4710 | 202-225-9740 | 1004 Longworth House Office Building | |||||||||
44528 | 44528 | Robert Good G000595 | rep | VA | 2021-01-03 | 2023-01-03 | Republican | 5 | https://good.house.gov | 1213 Longworth House Office Building Washington DC 20515-4605 | 202-225-4711 | 1213 Longworth House Office Building | |||||||||
44527 | 44527 | Clarence Owens O000086 | rep | UT | 2021-01-03 | 2023-01-03 | Republican | 4 | https://owens.house.gov | 1039 Longworth House Office Building Washington DC 20515-4404 | 202-225-3011 | 1039 Longworth House Office Building | |||||||||
44526 | 44526 | Blake Moore M001213 | rep | UT | 2021-01-03 | 2023-01-03 | Republican | 1 | https://blakemoore.house.gov | 1320 Longworth House Office Building Washington DC 20515-4401 | 202-225-0453 | 1320 Longworth House Office Building | |||||||||
44525 | 44525 | Beth Van Duyne V000134 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 24 | https://vanduyne.house.gov | 1337 Longworth House Office Building Washington DC 20515-4324 | 202-225-6605 | 1337 Longworth House Office Building | |||||||||
44524 | 44524 | Ernest Gonzales G000594 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 23 | https://gonzales.house.gov | 1009 Longworth House Office Building Washington DC 20515-4323 | 202-225-4511 | 1009 Longworth House Office Building | |||||||||
44523 | 44523 | Troy Nehls N000026 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 22 | https://nehls.house.gov | 1104 Longworth House Office Building Washington DC 20515-4322 | 202-225-5951 | 1104 Longworth House Office Building | |||||||||
44522 | 44522 | Ronny Jackson J000304 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 13 | https://jackson.house.gov | 118 Cannon House Office Building Washington DC 20515-4313 | 202-225-3706 | 118 Cannon House Office Building | |||||||||
44521 | 44521 | August Pfluger P000048 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 11 | https://pfluger.house.gov | 1531 Longworth House Office Building Washington DC 20515-4311 | 202-225-3605 | 1531 Longworth House Office Building | |||||||||
44520 | 44520 | Patrick Fallon F000246 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 4 | https://fallon.house.gov | 1118 Longworth House Office Building Washington DC 20515-4304 | 202-225-6673 | 1118 Longworth House Office Building | |||||||||
44519 | 44519 | Diana Harshbarger H001086 | rep | TN | 2021-01-03 | 2023-01-03 | Republican | 1 | https://harshbarger.house.gov | 167 Cannon House Office Building Washington DC 20515-4201 | 202-225-6356 | 167 Cannon House Office Building | |||||||||
44518 | 44518 | Nancy Mace M000194 | rep | SC | 2021-01-03 | 2023-01-03 | Republican | 1 | https://mace.house.gov | 212 Cannon House Office Building Washington DC 20515-4001 | 202-225-3176 | 212 Cannon House Office Building | |||||||||
44517 | 44517 | Cliff Bentz B000668 | rep | OR | 2021-01-03 | 2023-01-03 | Republican | 2 | https://bentz.house.gov | 1239 Longworth House Office Building Washington DC 20515-3702 | 202-225-6730 | 1239 Longworth House Office Building | |||||||||
44516 | 44516 | Stephanie Bice B000740 | rep | OK | 2021-01-03 | 2023-01-03 | Republican | 5 | https://bice.house.gov | 1223 Longworth House Office Building Washington DC 20515-3605 | 202-225-2132 | 1223 Longworth House Office Building | |||||||||
44515 | 44515 | Mondaire Jones J000306 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 17 | https://jones.house.gov | 1017 Longworth House Office Building Washington DC 20515-3217 | 202-225-6506 | 1017 Longworth House Office Building | |||||||||
44514 | 44514 | Jamaal Bowman B001223 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 16 | https://bowman.house.gov | 1605 Longworth House Office Building Washington DC 20515-3216 | 202-225-2464 | 1605 Longworth House Office Building | |||||||||
44513 | 44513 | Ritchie Torres T000486 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 15 | https://ritchietorres.house.gov | 317 Cannon House Office Building Washington DC 20515-3215 | 202-225-4361 | 317 Cannon House Office Building | |||||||||
44512 | 44512 | Nicole Malliotakis M000317 | rep | NY | 2021-01-03 | 2023-01-03 | Republican | 11 | https://malliotakis.house.gov | 417 Cannon House Office Building Washington DC 20515-3211 | 202-225-3371 | 417 Cannon House Office Building | |||||||||
44511 | 44511 | Andrew Garbarino G000597 | rep | NY | 2021-01-03 | 2023-01-03 | Republican | 2 | https://garbarino.house.gov | 1516 Longworth House Office Building Washington DC 20515-3202 | 202-225-7896 | 1516 Longworth House Office Building | |||||||||
44510 | 44510 | Teresa Leger Fernandez L000273 | rep | NM | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://fernandez.house.gov | 1432 Longworth House Office Building Washington DC 20515-3103 | 202-225-6190 | 1432 Longworth House Office Building | |||||||||
44509 | 44509 | Yvette Herrell H001084 | rep | NM | 2021-01-03 | 2023-01-03 | Republican | 2 | https://herrell.house.gov | 1305 Longworth House Office Building Washington DC 20515-3102 | 202-225-2365 | 1305 Longworth House Office Building | |||||||||
44508 | 44508 | Madison Cawthorn C001104 | rep | NC | 2021-01-03 | 2023-01-03 | Republican | 11 | https://cawthorn.house.gov | 102 Cannon House Office Building Washington DC 20515-3311 | 202-225-6401 | 102 Cannon House Office Building | |||||||||
44507 | 44507 | Kathy Manning M001135 | rep | NC | 2021-01-03 | 2023-01-03 | Democrat | 6 | https://manning.house.gov | 415 Cannon House Office Building Washington DC 20515-3306 | 202-225-3065 | 415 Cannon House Office Building | |||||||||
44506 | 44506 | Deborah Ross R000305 | rep | NC | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://ross.house.gov | 1208 Longworth House Office Building Washington DC 20515-3302 | 202-225-3032 | 1208 Longworth House Office Building | |||||||||
44505 | 44505 | Matthew Rosendale R000103 | rep | MT | 2021-01-03 | 2023-01-03 | Republican | 0 | https://rosendale.house.gov | 1037 Longworth House Office Building Washington DC 20515-2600 | 202-225-3211 | 1037 Longworth House Office Building | |||||||||
44504 | 44504 | Cori Bush B001224 | rep | MO | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://bush.house.gov | 563 Cannon House Office Building Washington DC 20515-2501 | 202-225-2406 | 563 Cannon House Office Building | |||||||||
44503 | 44503 | Michelle Fischbach F000470 | rep | MN | 2021-01-03 | 2023-01-03 | Republican | 7 | https://fischbach.house.gov | 1237 Longworth House Office Building Washington DC 20515-2307 | 202-225-2165 | 1237 Longworth House Office Building | |||||||||
44502 | 44502 | Lisa McClain M001136 | rep | MI | 2021-01-03 | 2023-01-03 | Republican | 10 | https://mcclain.house.gov | 218 Cannon House Office Building Washington DC 20515-2210 | 202-225-2106 | 218 Cannon House Office Building | |||||||||
44501 | 44501 | Peter Meijer M001186 | rep | MI | 2021-01-03 | 2023-01-03 | Republican | 3 | https://meijer.house.gov | 1508 Longworth House Office Building Washington DC 20515-2203 | 202-225-3831 | 1508 Longworth House Office Building | |||||||||
44500 | 44500 | Jake Auchincloss A000148 | rep | MA | 2021-01-03 | 2023-01-03 | Democrat | 4 | https://auchincloss.house.gov | 1524 Longworth House Office Building Washington DC 20515-2104 | 202-225-5931 | 1524 Longworth House Office Building | |||||||||
44499 | 44499 | Jacob LaTurner L000266 | rep | KS | 2021-01-03 | 2023-01-03 | Republican | 2 | https://laturner.house.gov | 1630 Longworth House Office Building Washington DC 20515-1602 | 202-225-6601 | 1630 Longworth House Office Building | |||||||||
44498 | 44498 | Tracey Mann M000871 | rep | KS | 2021-01-03 | 2023-01-03 | Republican | 1 | https://mann.house.gov | 522 Cannon House Office Building Washington DC 20515-1601 | 202-225-2715 | 522 Cannon House Office Building | |||||||||
44497 | 44497 | Victoria Spartz S000929 | rep | IN | 2021-01-03 | 2023-01-03 | Republican | 5 | https://spartz.house.gov | 1523 Longworth House Office Building Washington DC 20515-1405 | 202-225-2276 | 1523 Longworth House Office Building | |||||||||
44496 | 44496 | Frank Mrvan M001214 | rep | IN | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://mrvan.house.gov | 1607 Longworth House Office Building Washington DC 20515-1401 | 202-225-2461 | 1607 Longworth House Office Building | |||||||||
44495 | 44495 | Mary Miller M001211 | rep | IL | 2021-01-03 | 2023-01-03 | Republican | 15 | https://marymiller.house.gov | 1529 Longworth House Office Building Washington DC 20515-1315 | 202-225-5271 | 1529 Longworth House Office Building | |||||||||
44494 | 44494 | Marie Newman N000192 | rep | IL | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://newman.house.gov | 1022 Longworth House Office Building Washington DC 20515-1303 | 202-225-5701 | 1022 Longworth House Office Building | |||||||||
44493 | 44493 | Randy Feenstra F000446 | rep | IA | 2021-01-03 | 2023-01-03 | Republican | 4 | https://feenstra.house.gov | 1440 Longworth House Office Building Washington DC 20515-1504 | 202-225-4426 | 1440 Longworth House Office Building | |||||||||
44492 | 44492 | Mariannette Miller-Meeks M001215 | rep | IA | 2021-01-03 | 2023-01-03 | Republican | 2 | https://millermeeks.house.gov | 1716 Longworth House Office Building Washington DC 20515-1502 | 202-225-6576 | 1716 Longworth House Office Building | |||||||||
44491 | 44491 | Ashley Hinson H001091 | rep | IA | 2021-01-03 | 2023-01-03 | Republican | 1 | https://hinson.house.gov | 1429 Longworth House Office Building Washington DC 20515-1501 | 202-225-2911 | 1429 Longworth House Office Building | |||||||||
44490 | 44490 | Kaialiʻi Kahele K000396 | rep | HI | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://kahele.house.gov | 1205 Longworth House Office Building Washington DC 20515-1102 | 202-225-4906 | 1205 Longworth House Office Building | |||||||||
44489 | 44489 | Marjorie Greene G000596 | rep | GA | 2021-01-03 | 2023-01-03 | Republican | 14 | https://greene.house.gov | 1023 Longworth House Office Building Washington DC 20515-1014 | 202-225-5211 | 1023 Longworth House Office Building | |||||||||
44488 | 44488 | Andrew Clyde C001116 | rep | GA | 2021-01-03 | 2023-01-03 | Republican | 9 | https://clyde.house.gov | 521 Cannon House Office Building Washington DC 20515-1009 | 202-225-9893 | 521 Cannon House Office Building | |||||||||
44487 | 44487 | Carolyn Bourdeaux B001312 | rep | GA | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://bourdeaux.house.gov | 1319 Longworth House Office Building Washington DC 20515-1007 | 202-225-4272 | 1319 Longworth House Office Building | |||||||||
44486 | 44486 | Nikema Williams W000788 | rep | GA | 2021-01-03 | 2023-01-03 | Democrat | 5 | https://nikemawilliams.house.gov | 1406 Longworth House Office Building Washington DC 20515-1005 | 202-225-3801 | 1406 Longworth House Office Building | |||||||||
44485 | 44485 | Maria Salazar S000168 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 27 | https://salazar.house.gov | 1616 Longworth House Office Building Washington DC 20515-0927 | 202-225-3931 | 1616 Longworth House Office Building | |||||||||
44484 | 44484 | Carlos Gimenez G000593 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 26 | https://gimenez.house.gov | 419 Cannon House Office Building Washington DC 20515-0926 | 202-225-2778 | 419 Cannon House Office Building | |||||||||
44483 | 44483 | Byron Donalds D000032 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 19 | https://donalds.house.gov | 523 Cannon House Office Building Washington DC 20515-0919 | 202-225-2536 | 523 Cannon House Office Building | |||||||||
44482 | 44482 | C. Franklin F000472 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 15 | https://franklin.house.gov | 1517 Longworth House Office Building Washington DC 20515-0915 | 202-225-1252 | 1517 Longworth House Office Building | |||||||||
44481 | 44481 | Katherine Cammack C001039 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 3 | https://cammack.house.gov | 1626 Longworth House Office Building Washington DC 20515-0903 | 202-225-5744 | 1626 Longworth House Office Building | |||||||||
44480 | 44480 | Lauren Boebert B000825 | rep | CO | 2021-01-03 | 2023-01-03 | Republican | 3 | https://boebert.house.gov | 1609 Longworth House Office Building Washington DC 20515-0603 | 202-225-4761 | 1609 Longworth House Office Building | |||||||||
44479 | 44479 | Sara Jacobs J000305 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 53 | https://sarajacobs.house.gov | 1232 Longworth House Office Building Washington DC 20515-0553 | 202-225-2040 | 1232 Longworth House Office Building | |||||||||
44478 | 44478 | Michelle Steel S001135 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 48 | https://steel.house.gov | 1113 Longworth House Office Building Washington DC 20515-0548 | 202-225-2415 | 1113 Longworth House Office Building | |||||||||
44477 | 44477 | Young Kim K000397 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 39 | https://youngkim.house.gov | 1306 Longworth House Office Building Washington DC 20515-0539 | 202-225-4111 | 1306 Longworth House Office Building | |||||||||
44476 | 44476 | Jay Obernolte O000019 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 8 | https://obernolte.house.gov | 1029 Longworth House Office Building Washington DC 20515-0508 | 202-225-5861 | 1029 Longworth House Office Building | |||||||||
44475 | 44475 | Barry Moore M001212 | rep | AL | 2021-01-03 | 2023-01-03 | Republican | 2 | https://barrymoore.house.gov | 1504 Longworth House Office Building Washington DC 20515-0102 | 202-225-2901 | 1504 Longworth House Office Building | |||||||||
44474 | 44474 | Jerry Carl C001054 | rep | AL | 2021-01-03 | 2023-01-03 | Republican | 1 | https://carl.house.gov | 1330 Longworth House Office Building Washington DC 20515-0101 | 202-225-4931 | 1330 Longworth House Office Building | |||||||||
44473 | 44473 | Bill Hagerty H000601 | sen | TN | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.hagerty.senate.gov | 248 Russell Senate Office Building Washington DC 20510 | 202-224-4944 | https://www.hagerty.senate.gov/email-me/ | 248 Russell Senate Office Building | junior | |||||||
44472 | 44472 | John Hickenlooper H000273 | sen | CO | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.hickenlooper.senate.gov | 374 Russell Senate Office Building Washington DC 20510 | 202-224-5941 | https://www.hickenlooper.senate.gov/contact/ | 374 Russell Senate Office Building | junior | |||||||
44471 | 44471 | Tommy Tuberville T000278 | sen | AL | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.tuberville.senate.gov | 142 Russell Senate Office Building Washington DC 20510 | 202-224-4124 | https://www.tuberville.senate.gov/contact/contact-form/ | 142 Russell Senate Office Building | junior | |||||||
44470 | 44470 | David Valadao V000129 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 21 | https://valadao.house.gov | 1728 Longworth House Office Building Washington DC 20515-0521 | 202-225-4695 | 1728 Longworth House Office Building | http://valadao.house.gov/rss.xml | ||||||||
44469 | 44469 | David Valadao V000129 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 21 | https://valadao.house.gov | 1728 Longworth House Office Building; Washington DC 20515-0521 | 202-225-4695 | 202-226-3196 | 1728 Longworth House Office Building | http://valadao.house.gov/rss.xml | |||||||
44468 | 44468 | David Valadao V000129 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 21 | http://valadao.house.gov | 1004 Longworth HOB; Washington DC 20515-0521 | 202-225-4695 | 202-226-3196 | http://valadao.house.gov/contact/ | 1004 Longworth House Office Building | http://valadao.house.gov/rss.xml | ||||||
44467 | 44467 | David Valadao V000129 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 21 | http://valadao.house.gov | 1004 Longworth HOB; Washington DC 20515-0521 | 202-225-4695 | 202-226-3196 | http://valadao.house.gov/contact/ | 1004 Longworth House Office Building | http://valadao.house.gov/rss.xml | ||||||
44466 | 44466 | Pete Sessions S000250 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 17 | https://sessions.house.gov | 2204 Rayburn House Office Building Washington DC 20515-4317 | 202-225-6105 | 2204 Rayburn House Office Building | http://sessions.house.gov/?a=rss.feed | ||||||||
44465 | 44465 | Pete Sessions S000250 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 32 | https://sessions.house.gov | 2233 Rayburn House Office Building; Washington DC 20515-4332 | 202-225-2231 | 202-225-5878 | 2233 Rayburn House Office Building | http://sessions.house.gov/?a=rss.feed | |||||||
44464 | 44464 | Pete Sessions S000250 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 32 | https://sessions.house.gov | 2233 Rayburn HOB; Washington DC 20515-4332 | 202-225-2231 | 202-225-5878 | https://sessions.house.gov/index.cfm/contact-form | 2233 Rayburn House Office Building | http://sessions.house.gov/?a=rss.feed | ||||||
44463 | 44463 | Pete Sessions S000250 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 32 | http://sessions.house.gov | 2233 Rayburn HOB; Washington DC 20515-4332 | 202-225-2231 | 202-225-5878 | https://sessions.house.gov/index.cfm/contact-form | 2233 Rayburn House Office Building | http://sessions.house.gov/?a=rss.feed | ||||||
44462 | 44462 | Pete Sessions S000250 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 32 | http://www.house.gov/sessions | 2233 Rayburn HOB; Washington DC 20515-4332 | 202-225-2231 | 202-225-5878 | http://www.house.gov/sessionsform/emailform.htm | 2233 Rayburn House Office Building | |||||||
44461 | 44461 | Pete Sessions S000250 | rep | TX | 2009-01-06 | 2011-01-03 | Republican | 32 | http://www.house.gov/sessions | ||||||||||||
44460 | 44460 | Pete Sessions S000250 | rep | TX | 2007-01-04 | 2009-01-03 | Republican | 32 | http://www.house.gov/sessions | ||||||||||||
44459 | 44459 | Pete Sessions S000250 | rep | TX | 2005-01-04 | 2007-01-03 | Republican | 32 | http://www.house.gov/sessions | ||||||||||||
44458 | 44458 | Pete Sessions S000250 | rep | TX | 2003-01-07 | 2005-01-03 | Republican | 32 | http://www.house.gov/sessions | ||||||||||||
44457 | 44457 | Pete Sessions S000250 | rep | TX | 2001-01-03 | 2003-01-03 | Republican | 5 | |||||||||||||
44456 | 44456 | Pete Sessions S000250 | rep | TX | 1999-01-06 | 2001-01-03 | Republican | 5 | |||||||||||||
44455 | 44455 | Pete Sessions S000250 | rep | TX | 1997-01-07 | 1999-01-03 | Republican | 5 | |||||||||||||
44454 | 44454 | Darrell Issa I000056 | rep | CA | 2021-01-03 | 2023-01-03 | Republican | 50 | https://issa.house.gov | 2300 Rayburn House Office Building Washington DC 20515-0550 | 202-225-5672 | 2300 Rayburn House Office Building | http://issa.house.gov/feed/ | ||||||||
44453 | 44453 | Darrell Issa I000056 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 49 | https://issa.house.gov | 2269 Rayburn House Office Building; Washington DC 20515-0549 | 202-225-3906 | 202-225-3303 | 2269 Rayburn House Office Building | http://issa.house.gov/feed/ | |||||||
44452 | 44452 | Darrell Issa I000056 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 49 | http://issa.house.gov | 2269 Rayburn HOB; Washington DC 20515-0549 | 202-225-3906 | 202-225-3303 | http://issa.house.gov/contact/contact-me | 2269 Rayburn House Office Building | http://issa.house.gov/feed/ |
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);