legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
3,910 rows where type = "sen" sorted by legislator_id descending
This data as json, copyable, CSV (advanced)
Suggested facets: class, party, how, state_rank, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33209 | 33209 | Edward Zorinsky Z000013 | sen | NE | 1976-12-28 | 1977-01-03 | 1 | Democrat | |||||||||||||
33210 | 33210 | Edward Zorinsky Z000013 | sen | NE | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
33211 | 33211 | Edward Zorinsky Z000013 | sen | NE | 1983-01-03 | 1987-12-31 | 1 | Democrat | |||||||||||||
43654 | 43654 | Todd Young Y000064 | sen | IN | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.young.senate.gov | 185 Dirksen Senate Office Building Washington DC 20510 | 202-224-5623 | 202-226-6866 | https://www.young.senate.gov/contact | 185 Dirksen Senate Office Building | senior | ||||||
6959 | 6959 | David Yulee Y000061 | sen | FL | 1845-12-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
6960 | 6960 | David Yulee Y000061 | sen | FL | 1855-12-03 | 1861-03-03 | 3 | Democrat | |||||||||||||
28750 | 28750 | Stephen Young Y000053 | sen | OH | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
28751 | 28751 | Stephen Young Y000053 | sen | OH | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
4386 | 4386 | Richard Young Y000050 | sen | IL | 1837-09-04 | 1843-03-03 | 3 | Democrat | |||||||||||||
31402 | 31402 | Milton Young Y000047 | sen | ND | 1945-03-12 | 1951-01-03 | 3 | Republican | appointment | ||||||||||||
31403 | 31403 | Milton Young Y000047 | sen | ND | 1951-01-03 | 1957-01-03 | 3 | Republican | |||||||||||||
31404 | 31404 | Milton Young Y000047 | sen | ND | 1957-01-03 | 1963-01-03 | 3 | Republican | |||||||||||||
31405 | 31405 | Milton Young Y000047 | sen | ND | 1963-01-09 | 1969-01-03 | 3 | Republican | |||||||||||||
31406 | 31406 | Milton Young Y000047 | sen | ND | 1969-01-03 | 1975-01-03 | 3 | Republican | |||||||||||||
31407 | 31407 | Milton Young Y000047 | sen | ND | 1975-01-14 | 1981-01-03 | 3 | Republican | |||||||||||||
15830 | 15830 | Lafayette Young Y000046 | sen | IA | 1910-01-01 | 1911-12-31 | 2 | Republican | |||||||||||||
8242 | 8242 | Richard Yates Y000012 | sen | IL | 1865-12-04 | 1871-03-03 | 2 | Republican | |||||||||||||
28743 | 28743 | Ralph Yarborough Y000006 | sen | TX | 1957-01-03 | 1959-01-03 | 1 | Democrat | |||||||||||||
28744 | 28744 | Ralph Yarborough Y000006 | sen | TX | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
28745 | 28745 | Ralph Yarborough Y000006 | sen | TX | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
40128 | 40128 | John Walsh W000818 | sen | MT | 2014-02-11 | 2015-01-03 | 2 | Democrat | appointment | http://www.walsh.senate.gov | 511 Hart Senate Office Building Washington DC 20510 | 202-224-2651 | http://www.walsh.senate.gov/contact.cfm | 511 Hart Senate Office Building | junior | ||||||
43786 | 43786 | Elizabeth Warren W000817 | sen | MA | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.warren.senate.gov | 317 Hart Senate Office Building Washington DC 20510 | 202-224-4543 | 202-228-2072 | https://www.warren.senate.gov/?p=email_senator | 317 Hart Senate Office Building | senior | http://www.warren.senate.gov/rss/?p=hot_topic | |||||
43787 | 43787 | Elizabeth Warren W000817 | sen | MA | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.warren.senate.gov | 309 Hart Senate Office Building Washington DC 20510 | 202-224-4543 | https://www.warren.senate.gov/?p=email_senator | 309 Hart Senate Office Building | senior | http://www.warren.senate.gov/rss/?p=hot_topic | ||||||
41890 | 41890 | Mark Warner W000805 | sen | VA | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.warner.senate.gov | 475 Russell Senate Office Building Washington DC 20510 | 202-224-2023 | 202-224-6295 | http://www.warner.senate.gov/public//index.cfm?p=ContactPage#form_f9db6196-2dc7-4cda-8add-f8435a71318a | 475 Russell Senate Office Building | senior | http://www.warner.senate.gov/public/?a=rss.feed | |||||
41891 | 41891 | Mark Warner W000805 | sen | VA | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.warner.senate.gov | 703 Hart Senate Office Building Washington DC 20510 | 202-224-2023 | 202-224-6295 | http://www.warner.senate.gov/public/index.cfm?p=Contact | 703 Hart Senate Office Building | senior | http://www.warner.senate.gov/public/?a=rss.feed | |||||
41892 | 41892 | Mark Warner W000805 | sen | VA | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.warner.senate.gov | 703 Hart Senate Office Building Washington DC 20510 | 202-224-2023 | https://www.warner.senate.gov/public/index.cfm?p=Contact | 703 Hart Senate Office Building | senior | http://www.warner.senate.gov/public/?a=rss.feed | ||||||
39082 | 39082 | Jim Webb W000803 | sen | VA | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://webb.senate.gov/ | 248 RUSSELL SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-4024 | 202-228-6363 | http://www.webb.senate.gov/contact.cfm | 248 Russell Senate Office Building | |||||||
41810 | 41810 | Sheldon Whitehouse W000802 | sen | RI | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://whitehouse.senate.gov/ | 717 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-2921 | 202-228-6362 | http://www.whitehouse.senate.gov/contact/ | 717 Hart Senate Office Building | |||||||
41811 | 41811 | Sheldon Whitehouse W000802 | sen | RI | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.whitehouse.senate.gov | 530 Hart Senate Office Building Washington DC 20510 | 202-224-2921 | 202-228-6362 | https://www.whitehouse.senate.gov/contact/email-sheldon | 530 Hart Senate Office Building | junior | http://www.whitehouse.senate.gov/rss/feeds/?type=all&cachebuster=1 | |||||
41812 | 41812 | Sheldon Whitehouse W000802 | sen | RI | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.whitehouse.senate.gov | 530 Hart Senate Office Building Washington DC 20510 | 202-224-2921 | https://www.whitehouse.senate.gov/contact/email-sheldon | 530 Hart Senate Office Building | junior | http://www.whitehouse.senate.gov/rss/feeds/?type=all&cachebuster=1 | ||||||
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 | ||||||
30786 | 30786 | Louis Wyman W000782 | sen | NH | 1974-12-31 | 1975-01-03 | 3 | Republican | appointment | ||||||||||||
43638 | 43638 | Ron Wyden W000779 | sen | OR | 1996-02-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
43639 | 43639 | Ron Wyden W000779 | sen | OR | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://wyden.senate.gov/ | ||||||||||||
43640 | 43640 | Ron Wyden W000779 | sen | OR | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://wyden.senate.gov/ | ||||||||||||
43641 | 43641 | Ron Wyden W000779 | sen | OR | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.wyden.senate.gov | 221 Dirksen Senate Office Building Washington DC 20510 | 202-224-5244 | 202-228-2717 | http://www.wyden.senate.gov/contact | 221 Dirksen Senate Office Building | senior | http://www.wyden.senate.gov/rss/feeds/?type=all& | |||||
43642 | 43642 | Ron Wyden W000779 | sen | OR | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.wyden.senate.gov | 221 Dirksen Senate Office Building Washington DC 20510 | 202-224-5244 | 202-228-2717 | https://www.wyden.senate.gov/contact/ | 221 Dirksen Senate Office Building | senior | http://www.wyden.senate.gov/rss/feeds/?type=all& | |||||
8066 | 8066 | William Wright W000772 | sen | NJ | 1853-12-05 | 1859-03-03 | 2 | Democrat | |||||||||||||
8067 | 8067 | William Wright W000772 | sen | NJ | 1863-12-07 | 1867-03-03 | 1 | Democrat | |||||||||||||
5334 | 5334 | Silas Wright W000770 | sen | NY | 1833-12-02 | 1837-03-03 | 3 | Jackson | |||||||||||||
5335 | 5335 | Silas Wright W000770 | sen | NY | 1837-09-04 | 1843-03-03 | 3 | Democrat | |||||||||||||
5336 | 5336 | Silas Wright W000770 | sen | NY | 1843-12-04 | 1845-03-03 | 3 | Democrat | |||||||||||||
2353 | 2353 | Robert Wright W000768 | sen | MD | 1801-12-07 | 1807-03-03 | 3 | Republican | |||||||||||||
7902 | 7902 | Joseph Wright W000766 | sen | IN | 1862-01-01 | 1863-03-03 | 1 | Unionist | |||||||||||||
9065 | 9065 | George Wright W000759 | sen | IA | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
1094 | 1094 | Thomas Worthington W000750 | sen | OH | 1803-10-17 | 1807-03-03 | 3 | Republican | |||||||||||||
1095 | 1095 | Thomas Worthington W000750 | sen | OH | 1810-01-01 | 1815-03-03 | 1 | Republican | |||||||||||||
16239 | 16239 | John Works W000743 | sen | CA | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
5088 | 5088 | Levi Woodbury W000711 | sen | NH | 1825-12-05 | 1831-03-03 | 3 | Jackson | |||||||||||||
5089 | 5089 | Levi Woodbury W000711 | sen | NH | 1841-05-31 | 1845-12-31 | 2 | Democrat | |||||||||||||
5087 | 5087 | William Woodbridge W000709 | sen | MI | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
17514 | 17514 | Josiah Wolcott W000669 | sen | DE | 1917-04-02 | 1921-12-31 | 1 | Democrat | |||||||||||||
13217 | 13217 | Edward Wolcott W000667 | sen | CO | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
13218 | 13218 | Edward Wolcott W000667 | sen | CO | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
26155 | 26155 | Thomas Wofford W000666 | sen | SC | 1956-04-05 | 1957-01-03 | 2 | Democrat | appointment | ||||||||||||
35057 | 35057 | Harris Wofford W000665 | sen | PA | 1991-05-08 | 1995-01-03 | 1 | Democrat | appointment | ||||||||||||
9705 | 9705 | Robert Withers W000659 | sen | VA | 1875-12-06 | 1881-03-03 | 1 | Democrat | |||||||||||||
25841 | 25841 | Garrett Withers W000658 | sen | KY | 1949-01-20 | 1950-11-26 | 3 | Democrat | appointment | ||||||||||||
33805 | 33805 | Timothy Wirth W000647 | sen | CO | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
6203 | 6203 | Robert Winthrop W000646 | sen | MA | 1850-01-01 | 1851-03-03 | 1 | Whig | |||||||||||||
137 | 137 | Paine Wingate W000633 | sen | NH | 1789-03-04 | 1793-03-03 | 2 | Anti-Administration | |||||||||||||
10244 | 10244 | William Windom W000629 | sen | MN | 1870-07-15 | 1871-01-22 | 2 | Republican | |||||||||||||
10245 | 10245 | William Windom W000629 | sen | MN | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
10246 | 10246 | William Windom W000629 | sen | MN | 1877-03-05 | 1881-03-07 | 2 | Republican | |||||||||||||
10247 | 10247 | William Windom W000629 | sen | MN | 1881-11-15 | 1883-03-03 | 2 | Republican | |||||||||||||
7900 | 7900 | Robert Wilson W000609 | sen | MO | 1862-01-01 | 1863-12-31 | 3 | Unionist | |||||||||||||
34140 | 34140 | Pete Wilson W000607 | sen | CA | 1983-01-03 | 1989-01-03 | 1 | Republican | |||||||||||||
34141 | 34141 | Pete Wilson W000607 | sen | CA | 1989-01-03 | 1991-12-31 | 1 | Republican | |||||||||||||
13216 | 13216 | John Wilson W000602 | sen | WA | 1895-12-02 | 1899-03-03 | 1 | Republican | |||||||||||||
1770 | 1770 | James Wilson W000595 | sen | NJ | 1815-12-04 | 1821-01-08 | 1 | Republican | |||||||||||||
12046 | 12046 | James Wilson W000594 | sen | IA | 1883-12-03 | 1889-03-03 | 2 | Republican | |||||||||||||
12047 | 12047 | James Wilson W000594 | sen | IA | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
9056 | 9056 | Henry Wilson W000585 | sen | MA | 1855-12-03 | 1859-03-03 | 2 | Republican | |||||||||||||
9057 | 9057 | Henry Wilson W000585 | sen | MA | 1859-12-05 | 1865-03-03 | 2 | Republican | |||||||||||||
9058 | 9058 | Henry Wilson W000585 | sen | MA | 1865-12-04 | 1871-03-03 | 2 | Republican | |||||||||||||
9059 | 9059 | Henry Wilson W000585 | sen | MA | 1871-03-04 | 1873-12-31 | 2 | Republican | |||||||||||||
23758 | 23758 | George Wilson W000581 | sen | IA | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
11274 | 11274 | Ephraim Wilson W000577 | sen | MD | 1885-12-07 | 1891-03-03 | 3 | Democrat | |||||||||||||
7891 | 7891 | David Wilmot W000566 | sen | PA | 1861-07-04 | 1863-03-03 | 1 | Republican | |||||||||||||
23329 | 23329 | Raymond Willis W000563 | sen | IN | 1941-01-03 | 1947-01-03 | 1 | Republican | |||||||||||||
19547 | 19547 | Frank Willis W000561 | sen | OH | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
19548 | 19548 | Frank Willis W000561 | sen | OH | 1927-12-05 | 1929-03-03 | 3 | Republican | |||||||||||||
20072 | 20072 | Ben Williamson W000550 | sen | KY | 1930-01-01 | 1931-03-03 | 2 | Democrat | |||||||||||||
2537 | 2537 | Thomas Williams W000540 | sen | MS | 1817-12-01 | 1823-03-03 | 2 | Republican | |||||||||||||
2538 | 2538 | Thomas Williams W000540 | sen | MS | 1823-12-01 | 1829-03-03 | 2 | Jackson | |||||||||||||
4390 | 4390 | Thomas Williams W000539 | sen | MS | 1838-01-01 | 1839-03-03 | 1 | Democrat | |||||||||||||
4638 | 4638 | Reuel Williams W000532 | sen | ME | 1837-09-04 | 1839-03-03 | 1 | Democrat | |||||||||||||
4639 | 4639 | Reuel Williams W000532 | sen | ME | 1839-12-02 | 1843-12-31 | 1 | Democrat | |||||||||||||
10221 | 10221 | John Williams W000522 | sen | KY | 1879-03-18 | 1885-03-03 | 3 | Democrat | |||||||||||||
17512 | 17512 | John Williams W000521 | sen | MS | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
17513 | 17513 | John Williams W000521 | sen | MS | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
28739 | 28739 | John Williams W000518 | sen | DE | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
28740 | 28740 | John Williams W000518 | sen | DE | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
28741 | 28741 | John Williams W000518 | sen | DE | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
28742 | 28742 | John Williams W000518 | sen | DE | 1965-01-04 | 1971-01-03 | 1 | Republican | |||||||||||||
1948 | 1948 | John Williams W000516 | sen | TN | 1815-12-04 | 1817-03-03 | 2 | Republican | |||||||||||||
1949 | 1949 | John Williams W000516 | sen | TN | 1817-12-01 | 1823-03-03 | 2 | Republican | |||||||||||||
6738 | 6738 | Jared Williams W000511 | sen | NH | 1853-12-05 | 1855-03-03 | 2 | Democrat | |||||||||||||
31895 | 31895 | Harrison Williams W000502 | sen | NJ | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
31896 | 31896 | Harrison Williams W000502 | sen | NJ | 1965-01-04 | 1971-01-03 | 1 | 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);