legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by legislator_id descending
This data as json, copyable, CSV (advanced)
Suggested facets: class, how, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40540 | 40540 | Ryan Zinke Z000018 | rep | MT | 2015-01-06 | 2017-01-03 | Republican | 0 | https://zinke.house.gov | 113 Cannon HOB; Washington DC 20515-2600 | 202-225-3211 | 202-225-5687 | 113 Cannon House Office Building | ||||||||
40541 | 40541 | Ryan Zinke Z000018 | rep | MT | 2017-01-03 | 2017-03-01 | Republican | 0 | https://zinke.house.gov | 1419 Longworth HOB; Washington DC 20515-2600 | 202-225-3211 | 202-225-5687 | 1419 Longworth House Office Building | ||||||||
44024 | 44024 | Lee Zeldin Z000017 | rep | NY | 2015-01-06 | 2017-01-03 | Republican | 1 | https://zeldin.house.gov | 1517 Longworth HOB; Washington DC 20515-3201 | 202-225-3826 | 202-225-3143 | 1517 Longworth House Office Building | ||||||||
44025 | 44025 | Lee Zeldin Z000017 | rep | NY | 2017-01-03 | 2019-01-03 | Republican | 1 | https://zeldin.house.gov | 1517 Longworth House Office Building; Washington DC 20515-3201 | 202-225-3826 | 202-225-3143 | 1517 Longworth House Office Building | ||||||||
44026 | 44026 | Lee Zeldin Z000017 | rep | NY | 2019-01-03 | 2021-01-03 | Republican | 1 | https://zeldin.house.gov | 2441 Rayburn House Office Building Washington DC 20515-3201 | 202-225-3826 | 2441 Rayburn House Office Building | |||||||||
44027 | 44027 | Lee Zeldin Z000017 | rep | NY | 2021-01-03 | 2023-01-03 | Republican | 1 | https://zeldin.house.gov | 2441 Rayburn House Office Building Washington DC 20515-3201 | 202-225-3826 | 2441 Rayburn House Office Building | |||||||||
30777 | 30777 | John Zwach Z000016 | rep | MN | 1967-01-10 | 1969-01-03 | Republican | 6 | |||||||||||||
30778 | 30778 | John Zwach Z000016 | rep | MN | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
30779 | 30779 | John Zwach Z000016 | rep | MN | 1971-01-21 | 1973-01-03 | Republican | 6 | |||||||||||||
30780 | 30780 | John Zwach Z000016 | rep | MN | 1973-01-03 | 1975-01-03 | Republican | 6 | |||||||||||||
33453 | 33453 | Edwin Zschau Z000014 | rep | CA | 1983-01-03 | 1985-01-03 | Republican | 12 | |||||||||||||
33454 | 33454 | Edwin Zschau Z000014 | rep | CA | 1985-01-03 | 1987-01-03 | Republican | 12 | |||||||||||||
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 | |||||||||||||
7255 | 7255 | Felix Zollicoffer Z000012 | rep | TN | 1853-12-05 | 1855-03-03 | Whig | 8 | |||||||||||||
7256 | 7256 | Felix Zollicoffer Z000012 | rep | TN | 1855-12-03 | 1857-03-03 | American | 8 | |||||||||||||
7257 | 7257 | Felix Zollicoffer Z000012 | rep | TN | 1857-12-07 | 1859-03-03 | American | 8 | |||||||||||||
22009 | 22009 | Marion Zioncheck Z000011 | rep | WA | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
22010 | 22010 | Marion Zioncheck Z000011 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
30773 | 30773 | Roger Zion Z000010 | rep | IN | 1967-01-10 | 1969-01-03 | Republican | 8 | |||||||||||||
30774 | 30774 | Roger Zion Z000010 | rep | IN | 1969-01-03 | 1971-01-03 | Republican | 8 | |||||||||||||
30775 | 30775 | Roger Zion Z000010 | rep | IN | 1971-01-21 | 1973-01-03 | Republican | 8 | |||||||||||||
30776 | 30776 | Roger Zion Z000010 | rep | IN | 1973-01-03 | 1975-01-03 | Republican | 8 | |||||||||||||
24721 | 24721 | Orville Zimmerman Z000009 | rep | MO | 1935-01-03 | 1937-01-03 | Democrat | 10 | |||||||||||||
24722 | 24722 | Orville Zimmerman Z000009 | rep | MO | 1937-01-05 | 1939-01-03 | Democrat | 10 | |||||||||||||
24723 | 24723 | Orville Zimmerman Z000009 | rep | MO | 1939-01-03 | 1941-01-03 | Democrat | 10 | |||||||||||||
24724 | 24724 | Orville Zimmerman Z000009 | rep | MO | 1941-01-03 | 1943-01-03 | Democrat | 10 | |||||||||||||
24725 | 24725 | Orville Zimmerman Z000009 | rep | MO | 1943-01-06 | 1945-01-03 | Democrat | 10 | |||||||||||||
24726 | 24726 | Orville Zimmerman Z000009 | rep | MO | 1945-01-03 | 1947-01-03 | Democrat | 10 | |||||||||||||
24727 | 24727 | Orville Zimmerman Z000009 | rep | MO | 1947-01-03 | 1949-01-03 | Democrat | 10 | |||||||||||||
36113 | 36113 | Richard Zimmer Z000008 | rep | NJ | 1991-01-03 | 1993-01-03 | Republican | 12 | |||||||||||||
36114 | 36114 | Richard Zimmer Z000008 | rep | NJ | 1993-01-05 | 1995-01-03 | Republican | 12 | |||||||||||||
36115 | 36115 | Richard Zimmer Z000008 | rep | NJ | 1995-01-04 | 1997-01-03 | Republican | 12 | |||||||||||||
20061 | 20061 | Frederick Zihlman Z000007 | rep | MD | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
20062 | 20062 | Frederick Zihlman Z000007 | rep | MD | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
20063 | 20063 | Frederick Zihlman Z000007 | rep | MD | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
20064 | 20064 | Frederick Zihlman Z000007 | rep | MD | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
20065 | 20065 | Frederick Zihlman Z000007 | rep | MD | 1925-12-07 | 1927-03-04 | Republican | 6 | |||||||||||||
20066 | 20066 | Frederick Zihlman Z000007 | rep | MD | 1927-12-05 | 1929-03-03 | Republican | 6 | |||||||||||||
20067 | 20067 | Frederick Zihlman Z000007 | rep | MD | 1929-04-15 | 1931-03-03 | Republican | 6 | |||||||||||||
13841 | 13841 | Edward Ziegler Z000006 | rep | PA | 1899-12-04 | 1901-03-03 | Democrat | 19 | |||||||||||||
14953 | 14953 | William Zenor Z000005 | rep | IN | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
14954 | 14954 | William Zenor Z000005 | rep | IN | 1899-12-04 | 1901-03-03 | Democrat | 3 | |||||||||||||
14955 | 14955 | William Zenor Z000005 | rep | IN | 1901-12-02 | 1903-03-03 | Democrat | 3 | |||||||||||||
14956 | 14956 | William Zenor Z000005 | rep | IN | 1903-11-09 | 1905-03-03 | Democrat | 3 | |||||||||||||
14957 | 14957 | William Zenor Z000005 | rep | IN | 1905-12-04 | 1907-03-03 | Democrat | 3 | |||||||||||||
36110 | 36110 | William Zeliff Z000004 | rep | NH | 1991-01-03 | 1993-01-03 | Republican | 1 | |||||||||||||
36111 | 36111 | William Zeliff Z000004 | rep | NH | 1993-01-05 | 1995-01-03 | Republican | 1 | |||||||||||||
36112 | 36112 | William Zeliff Z000004 | rep | NH | 1995-01-04 | 1997-01-03 | Republican | 1 | |||||||||||||
27590 | 27590 | Herbert Zelenko Z000003 | rep | NY | 1955-01-05 | 1957-01-03 | Democrat | 21 | |||||||||||||
27591 | 27591 | Herbert Zelenko Z000003 | rep | NY | 1957-01-03 | 1959-01-03 | Democrat | 21 | |||||||||||||
27592 | 27592 | Herbert Zelenko Z000003 | rep | NY | 1959-01-07 | 1961-01-03 | Democrat | 21 | |||||||||||||
27593 | 27593 | Herbert Zelenko Z000003 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 21 | |||||||||||||
32890 | 32890 | Leo Zeferetti Z000002 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 15 | |||||||||||||
32891 | 32891 | Leo Zeferetti Z000002 | rep | NY | 1977-01-04 | 1979-01-03 | Democrat | 15 | |||||||||||||
32892 | 32892 | Leo Zeferetti Z000002 | rep | NY | 1979-01-15 | 1981-01-03 | Democrat | 15 | |||||||||||||
32893 | 32893 | Leo Zeferetti Z000002 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 15 | |||||||||||||
33191 | 33191 | Clement Zablocki Z000001 | rep | WI | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
33192 | 33192 | Clement Zablocki Z000001 | rep | WI | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
33193 | 33193 | Clement Zablocki Z000001 | rep | WI | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
33194 | 33194 | Clement Zablocki Z000001 | rep | WI | 1955-01-05 | 1957-01-03 | Democrat | 4 | |||||||||||||
33195 | 33195 | Clement Zablocki Z000001 | rep | WI | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
33196 | 33196 | Clement Zablocki Z000001 | rep | WI | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
33197 | 33197 | Clement Zablocki Z000001 | rep | WI | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
33198 | 33198 | Clement Zablocki Z000001 | rep | WI | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
33199 | 33199 | Clement Zablocki Z000001 | rep | WI | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
33200 | 33200 | Clement Zablocki Z000001 | rep | WI | 1967-01-10 | 1969-01-03 | Democrat | 4 | |||||||||||||
33201 | 33201 | Clement Zablocki Z000001 | rep | WI | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
33202 | 33202 | Clement Zablocki Z000001 | rep | WI | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
33203 | 33203 | Clement Zablocki Z000001 | rep | WI | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
33204 | 33204 | Clement Zablocki Z000001 | rep | WI | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
33205 | 33205 | Clement Zablocki Z000001 | rep | WI | 1977-01-04 | 1979-01-03 | Democrat | 4 | |||||||||||||
33206 | 33206 | Clement Zablocki Z000001 | rep | WI | 1979-01-15 | 1981-01-03 | Democrat | 4 | |||||||||||||
33207 | 33207 | Clement Zablocki Z000001 | rep | WI | 1981-01-05 | 1983-01-03 | Democrat | 4 | |||||||||||||
33208 | 33208 | Clement Zablocki Z000001 | rep | WI | 1983-01-03 | 1983-12-03 | Democrat | 4 | |||||||||||||
44551 | 44551 | Rudy Yakym Y000067 | rep | IN | 2022-11-14 | 2023-01-03 | Republican | 2 | special-election | ||||||||||||
41134 | 41134 | David Young Y000066 | rep | IA | 2015-01-06 | 2017-01-03 | Republican | 3 | https://davidyoung.house.gov | 515 Cannon HOB; Washington DC 20515-1503 | 202-225-5476 | 515 Cannon House Office Building | |||||||||
41135 | 41135 | David Young Y000066 | rep | IA | 2017-01-03 | 2019-01-03 | Republican | 3 | https://davidyoung.house.gov | 240 Cannon House Office Building; Washington DC 20515-1503 | 202-225-5476 | 240 Cannon House Office Building | |||||||||
41546 | 41546 | Ted Yoho Y000065 | rep | FL | 2013-01-03 | 2015-01-03 | Republican | 3 | http://yoho.house.gov | 511 Cannon HOB; Washington DC 20515-0903 | 202-225-5744 | https://yoho.house.gov/contact/email-me | 511 Cannon House Office Building | http://yoho.house.gov/rss.xml | |||||||
41547 | 41547 | Ted Yoho Y000065 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 3 | http://yoho.house.gov | 511 Cannon HOB; Washington DC 20515-0903 | 202-225-5744 | https://yoho.house.gov/contact/email-me | 511 Cannon House Office Building | http://yoho.house.gov/rss.xml | |||||||
41548 | 41548 | Ted Yoho Y000065 | rep | FL | 2017-01-03 | 2019-01-03 | Republican | 3 | https://yoho.house.gov | 511 Cannon House Office Building; Washington DC 20515-0903 | 202-225-5744 | 511 Cannon House Office Building | http://yoho.house.gov/rss.xml | ||||||||
41549 | 41549 | Ted Yoho Y000065 | rep | FL | 2019-01-03 | 2021-01-03 | Republican | 3 | https://yoho.house.gov | 1730 Longworth House Office Building Washington DC 20515-0903 | 202-225-5744 | 1730 Longworth House Office Building | http://yoho.house.gov/rss.xml | ||||||||
43651 | 43651 | Todd Young Y000064 | rep | IN | 2011-01-05 | 2013-01-03 | Republican | 9 | http://toddyoung.house.gov/ | 1721 Longworth HOB; Washington DC 20515-1409 | 202-225-5315 | 202-226-6866 | 1721 Longworth House Office Building | ||||||||
43652 | 43652 | Todd Young Y000064 | rep | IN | 2013-01-03 | 2015-01-03 | Republican | 9 | http://toddyoung.house.gov | 1007 Longworth HOB; Washington DC 20515-1409 | 202-225-5315 | 202-226-6866 | https://toddyoungforms.house.gov/give-me-your-opinion | 1007 Longworth House Office Building | http://toddyoung.house.gov/common/rss//index.cfm?rss=49 | ||||||
43653 | 43653 | Todd Young Y000064 | rep | IN | 2015-01-06 | 2017-01-03 | Republican | 9 | http://toddyoung.house.gov | 1007 Longworth HOB; Washington DC 20515-1409 | 202-225-5315 | 202-226-6866 | https://toddyoungforms.house.gov/give-me-your-opinion | 1007 Longworth House Office Building | http://toddyoung.house.gov/common/rss//index.cfm?rss=49 | ||||||
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 | ||||||
41083 | 41083 | Kevin Yoder Y000063 | rep | KS | 2011-01-05 | 2013-01-03 | Republican | 3 | http://yoder.house.gov/ | 214 Cannon HOB; Washington DC 20515-1603 | 202-225-2865 | 202-225-2807 | 214 Cannon House Office Building | ||||||||
41084 | 41084 | Kevin Yoder Y000063 | rep | KS | 2013-01-03 | 2015-01-03 | Republican | 3 | http://yoder.house.gov | 215 Cannon HOB; Washington DC 20515-1603 | 202-225-2865 | 202-225-2807 | https://yoder.house.gov/contact/email-me | 215 Cannon House Office Building | http://yoder.house.gov/common/rss/index.cfm?rss=49 | ||||||
41085 | 41085 | Kevin Yoder Y000063 | rep | KS | 2015-01-06 | 2017-01-03 | Republican | 3 | http://yoder.house.gov | 215 Cannon HOB; Washington DC 20515-1603 | 202-225-2865 | 202-225-2807 | https://yoder.house.gov/contact/email-me | 215 Cannon House Office Building | http://yoder.house.gov/common/rss/index.cfm?rss=49 | ||||||
41086 | 41086 | Kevin Yoder Y000063 | rep | KS | 2017-01-03 | 2019-01-03 | Republican | 3 | https://yoder.house.gov | 2433 Rayburn House Office Building; Washington DC 20515-1603 | 202-225-2865 | 202-225-2807 | 2433 Rayburn House Office Building | http://yoder.house.gov/common/rss/index.cfm?rss=49 | |||||||
43643 | 43643 | John Yarmuth Y000062 | rep | KY | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://yarmuth.house.gov | ||||||||||||
43644 | 43644 | John Yarmuth Y000062 | rep | KY | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://yarmuth.house.gov | ||||||||||||
43645 | 43645 | John Yarmuth Y000062 | rep | KY | 2011-01-05 | 2013-01-03 | Democrat | 3 | http://yarmuth.house.gov | 435 Cannon HOB; Washington DC 20515-1703 | 202-225-5401 | 202-225-5776 | http://yarmuth.house.gov/?sectionid=68&sectiontree=6,29,68 | 435 Cannon House Office Building | |||||||
43646 | 43646 | John Yarmuth Y000062 | rep | KY | 2013-01-03 | 2015-01-03 | Democrat | 3 | http://yarmuth.house.gov | 403 Cannon HOB; Washington DC 20515-1703 | 202-225-5401 | 202-225-5776 | http://yarmuth.house.gov/contact-john2/ | 403 Cannon House Office Building | |||||||
43647 | 43647 | John Yarmuth Y000062 | rep | KY | 2015-01-06 | 2017-01-03 | Democrat | 3 | http://yarmuth.house.gov | 403 Cannon HOB; Washington DC 20515-1703 | 202-225-5401 | 202-225-5776 | http://yarmuth.house.gov/contact-john2/ | 403 Cannon House Office Building | |||||||
43648 | 43648 | John Yarmuth Y000062 | rep | KY | 2017-01-03 | 2019-01-03 | Democrat | 3 | https://yarmuth.house.gov | 131 Cannon House Office Building; Washington DC 20515-1703 | 202-225-5401 | 202-225-5776 | 131 Cannon House Office Building | ||||||||
43649 | 43649 | John Yarmuth Y000062 | rep | KY | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://yarmuth.house.gov | 402 Cannon House Office Building Washington DC 20515-1703 | 202-225-5401 | 402 Cannon House Office Building | |||||||||
43650 | 43650 | John Yarmuth Y000062 | rep | KY | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://yarmuth.house.gov | 402 Cannon House Office Building Washington DC 20515-1703 | 202-225-5401 | 402 Cannon House Office Building | |||||||||
6957 | 6957 | David Yulee Y000061 | rep | FL | 1841-05-31 | 1843-03-03 | Democrat | -1 |
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);