legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by class
This data as json, copyable, CSV (advanced)
start (date) >30 ✖
- 1981-01-05 482
- 1989-01-03 481
- 1975-01-14 480
- 1977-01-04 478
- 1983-01-03 478
- 1991-01-03 478
- 1973-01-03 477
- 1979-01-15 477
- 1985-01-03 477
- 1987-01-06 477
- 1993-01-05 476
- 1997-01-07 475
- 2015-01-06 475
- 2003-01-07 474
- 2011-01-05 474
- 2017-01-03 474
- 1999-01-06 473
- 2005-01-04 473
- 2007-01-04 473
- 2013-01-03 473
- 1995-01-04 472
- 2001-01-03 472
- 2009-01-06 472
- 2019-01-03 471
- 2021-01-03 471
- 1971-01-21 428
- 1969-01-03 382
- 1967-01-10 342
- 1965-01-04 283
- 1963-01-09 248
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29947 | 29947 | John McMillan M000568 | rep | SC | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
29948 | 29948 | George Miller M000727 | rep | CA | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
29949 | 29949 | George Miller M000727 | rep | CA | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
29950 | 29950 | George Miller M000727 | rep | CA | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
29951 | 29951 | George Miller M000727 | rep | CA | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
29952 | 29952 | George Miller M000727 | rep | CA | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
29953 | 29953 | George Miller M000727 | rep | CA | 1955-01-05 | 1957-01-03 | Democrat | 8 | |||||||||||||
29954 | 29954 | George Miller M000727 | rep | CA | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
29955 | 29955 | George Miller M000727 | rep | CA | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
29956 | 29956 | George Miller M000727 | rep | CA | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
29957 | 29957 | George Miller M000727 | rep | CA | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
29958 | 29958 | George Miller M000727 | rep | CA | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
29959 | 29959 | George Miller M000727 | rep | CA | 1967-01-10 | 1969-01-03 | Democrat | 8 | |||||||||||||
29960 | 29960 | George Miller M000727 | rep | CA | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
29961 | 29961 | George Miller M000727 | rep | CA | 1971-01-21 | 1973-01-03 | Democrat | 8 | |||||||||||||
29962 | 29962 | John Monagan M000847 | rep | CT | 1959-01-07 | 1961-01-03 | Democrat | 5 | |||||||||||||
29963 | 29963 | John Monagan M000847 | rep | CT | 1961-01-03 | 1963-01-03 | Democrat | 5 | |||||||||||||
29964 | 29964 | John Monagan M000847 | rep | CT | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
29965 | 29965 | John Monagan M000847 | rep | CT | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
29966 | 29966 | John Monagan M000847 | rep | CT | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
29967 | 29967 | John Monagan M000847 | rep | CT | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
29968 | 29968 | John Monagan M000847 | rep | CT | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
29969 | 29969 | Joseph Montoya M000876 | rep | NM | 1957-01-03 | 1959-01-03 | Democrat | 0 | |||||||||||||
29970 | 29970 | Joseph Montoya M000876 | rep | NM | 1959-01-07 | 1961-01-03 | Democrat | 0 | |||||||||||||
29971 | 29971 | Joseph Montoya M000876 | rep | NM | 1961-01-03 | 1963-01-03 | Democrat | 0 | |||||||||||||
29972 | 29972 | Joseph Montoya M000876 | rep | NM | 1963-01-09 | 1964-11-03 | Democrat | 0 | |||||||||||||
29976 | 29976 | Frank Morse M001009 | rep | MA | 1961-01-03 | 1963-01-03 | Republican | 5 | |||||||||||||
29977 | 29977 | Frank Morse M001009 | rep | MA | 1963-01-09 | 1965-01-03 | Republican | 5 | |||||||||||||
29978 | 29978 | Frank Morse M001009 | rep | MA | 1965-01-04 | 1967-01-03 | Republican | 5 | |||||||||||||
29979 | 29979 | Frank Morse M001009 | rep | MA | 1967-01-10 | 1969-01-03 | Republican | 5 | |||||||||||||
29980 | 29980 | Frank Morse M001009 | rep | MA | 1969-01-03 | 1971-01-03 | Republican | 5 | |||||||||||||
29981 | 29981 | Frank Morse M001009 | rep | MA | 1971-01-21 | 1973-01-03 | Republican | 5 | |||||||||||||
29982 | 29982 | Rogers Morton M001021 | rep | MD | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
29983 | 29983 | Rogers Morton M001021 | rep | MD | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
29984 | 29984 | Rogers Morton M001021 | rep | MD | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
29985 | 29985 | Rogers Morton M001021 | rep | MD | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
29986 | 29986 | Rogers Morton M001021 | rep | MD | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
29990 | 29990 | Alvin O’Konski O000058 | rep | WI | 1943-01-06 | 1945-01-03 | Republican | 10 | |||||||||||||
29991 | 29991 | Alvin O’Konski O000058 | rep | WI | 1945-01-03 | 1947-01-03 | Republican | 10 | |||||||||||||
29992 | 29992 | Alvin O’Konski O000058 | rep | WI | 1947-01-03 | 1949-01-03 | Republican | 10 | |||||||||||||
29993 | 29993 | Alvin O’Konski O000058 | rep | WI | 1949-01-03 | 1951-01-03 | Republican | 10 | |||||||||||||
29994 | 29994 | Alvin O’Konski O000058 | rep | WI | 1951-01-03 | 1953-01-03 | Republican | 10 | |||||||||||||
29995 | 29995 | Alvin O’Konski O000058 | rep | WI | 1953-01-03 | 1955-01-03 | Republican | 10 | |||||||||||||
29996 | 29996 | Alvin O’Konski O000058 | rep | WI | 1955-01-05 | 1957-01-03 | Republican | 10 | |||||||||||||
29997 | 29997 | Alvin O’Konski O000058 | rep | WI | 1957-01-03 | 1959-01-03 | Republican | 10 | |||||||||||||
29998 | 29998 | Alvin O’Konski O000058 | rep | WI | 1959-01-07 | 1961-01-03 | Republican | 10 | |||||||||||||
29999 | 29999 | Alvin O’Konski O000058 | rep | WI | 1961-01-03 | 1963-01-03 | Republican | 10 | |||||||||||||
30000 | 30000 | Alvin O’Konski O000058 | rep | WI | 1963-01-09 | 1965-01-03 | Republican | 10 | |||||||||||||
30001 | 30001 | Alvin O’Konski O000058 | rep | WI | 1965-01-04 | 1967-01-03 | Republican | 10 | |||||||||||||
30002 | 30002 | Alvin O’Konski O000058 | rep | WI | 1967-01-10 | 1969-01-03 | Republican | 10 | |||||||||||||
30003 | 30003 | Alvin O’Konski O000058 | rep | WI | 1969-01-03 | 1971-01-03 | Republican | 10 | |||||||||||||
30004 | 30004 | Alvin O’Konski O000058 | rep | WI | 1971-01-21 | 1973-01-03 | Republican | 10 | |||||||||||||
30010 | 30010 | Thomas Pelly P000196 | rep | WA | 1953-01-03 | 1955-01-03 | Republican | 1 | |||||||||||||
30011 | 30011 | Thomas Pelly P000196 | rep | WA | 1955-01-05 | 1957-01-03 | Republican | 1 | |||||||||||||
30012 | 30012 | Thomas Pelly P000196 | rep | WA | 1957-01-03 | 1959-01-03 | Republican | 1 | |||||||||||||
30013 | 30013 | Thomas Pelly P000196 | rep | WA | 1959-01-07 | 1961-01-03 | Republican | 1 | |||||||||||||
30014 | 30014 | Thomas Pelly P000196 | rep | WA | 1961-01-03 | 1963-01-03 | Republican | 1 | |||||||||||||
30015 | 30015 | Thomas Pelly P000196 | rep | WA | 1963-01-09 | 1965-01-03 | Republican | 1 | |||||||||||||
30016 | 30016 | Thomas Pelly P000196 | rep | WA | 1965-01-04 | 1967-01-03 | Republican | 1 | |||||||||||||
30017 | 30017 | Thomas Pelly P000196 | rep | WA | 1967-01-10 | 1969-01-03 | Republican | 1 | |||||||||||||
30018 | 30018 | Thomas Pelly P000196 | rep | WA | 1969-01-03 | 1971-01-03 | Republican | 1 | |||||||||||||
30019 | 30019 | Thomas Pelly P000196 | rep | WA | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
30020 | 30020 | Alexander Pirnie P000366 | rep | NY | 1959-01-07 | 1961-01-03 | Republican | 34 | |||||||||||||
30021 | 30021 | Alexander Pirnie P000366 | rep | NY | 1961-01-03 | 1963-01-03 | Republican | 34 | |||||||||||||
30022 | 30022 | Alexander Pirnie P000366 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 32 | |||||||||||||
30023 | 30023 | Alexander Pirnie P000366 | rep | NY | 1965-01-04 | 1967-01-03 | Republican | 32 | |||||||||||||
30024 | 30024 | Alexander Pirnie P000366 | rep | NY | 1967-01-10 | 1969-01-03 | Republican | 32 | |||||||||||||
30025 | 30025 | Alexander Pirnie P000366 | rep | NY | 1969-01-03 | 1971-01-03 | Republican | 32 | |||||||||||||
30026 | 30026 | Alexander Pirnie P000366 | rep | NY | 1971-01-21 | 1973-01-03 | Republican | 32 | |||||||||||||
30027 | 30027 | Richard Poff P000401 | rep | VA | 1953-01-03 | 1955-01-03 | Republican | 6 | |||||||||||||
30028 | 30028 | Richard Poff P000401 | rep | VA | 1955-01-05 | 1957-01-03 | Republican | 6 | |||||||||||||
30029 | 30029 | Richard Poff P000401 | rep | VA | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
30030 | 30030 | Richard Poff P000401 | rep | VA | 1959-01-07 | 1961-01-03 | Republican | 6 | |||||||||||||
30031 | 30031 | Richard Poff P000401 | rep | VA | 1961-01-03 | 1963-01-03 | Republican | 6 | |||||||||||||
30032 | 30032 | Richard Poff P000401 | rep | VA | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
30033 | 30033 | Richard Poff P000401 | rep | VA | 1965-01-04 | 1967-01-03 | Republican | 6 | |||||||||||||
30034 | 30034 | Richard Poff P000401 | rep | VA | 1967-01-10 | 1969-01-03 | Republican | 6 | |||||||||||||
30035 | 30035 | Richard Poff P000401 | rep | VA | 1969-01-03 | 1971-01-03 | Republican | 6 | |||||||||||||
30036 | 30036 | Richard Poff P000401 | rep | VA | 1971-01-21 | 1973-01-03 | Republican | 6 | |||||||||||||
30037 | 30037 | Roman Pucinski P000559 | rep | IL | 1959-01-07 | 1961-01-03 | Democrat | 11 | |||||||||||||
30038 | 30038 | Roman Pucinski P000559 | rep | IL | 1961-01-03 | 1963-01-03 | Democrat | 11 | |||||||||||||
30039 | 30039 | Roman Pucinski P000559 | rep | IL | 1963-01-09 | 1965-01-03 | Democrat | 11 | |||||||||||||
30040 | 30040 | Roman Pucinski P000559 | rep | IL | 1965-01-04 | 1967-01-03 | Democrat | 11 | |||||||||||||
30041 | 30041 | Roman Pucinski P000559 | rep | IL | 1967-01-10 | 1969-01-03 | Democrat | 11 | |||||||||||||
30042 | 30042 | Roman Pucinski P000559 | rep | IL | 1969-01-03 | 1971-01-03 | Democrat | 11 | |||||||||||||
30043 | 30043 | Roman Pucinski P000559 | rep | IL | 1971-01-21 | 1973-01-03 | Democrat | 11 | |||||||||||||
30044 | 30044 | Graham Purcell P000569 | rep | TX | 1961-01-03 | 1963-01-03 | Democrat | 13 | |||||||||||||
30045 | 30045 | Graham Purcell P000569 | rep | TX | 1963-01-09 | 1965-01-03 | Democrat | 13 | |||||||||||||
30046 | 30046 | Graham Purcell P000569 | rep | TX | 1965-01-04 | 1967-01-03 | Democrat | 13 | |||||||||||||
30047 | 30047 | Graham Purcell P000569 | rep | TX | 1967-01-10 | 1969-01-03 | Democrat | 13 | |||||||||||||
30048 | 30048 | Graham Purcell P000569 | rep | TX | 1969-01-03 | 1971-01-03 | Democrat | 13 | |||||||||||||
30049 | 30049 | Graham Purcell P000569 | rep | TX | 1971-01-21 | 1973-01-03 | Democrat | 13 | |||||||||||||
30050 | 30050 | Charlotte Reid R000143 | rep | IL | 1963-01-09 | 1965-01-03 | Republican | 15 | |||||||||||||
30051 | 30051 | Charlotte Reid R000143 | rep | IL | 1965-01-04 | 1967-01-03 | Republican | 15 | |||||||||||||
30052 | 30052 | Charlotte Reid R000143 | rep | IL | 1967-01-10 | 1969-01-03 | Republican | 15 | |||||||||||||
30053 | 30053 | Charlotte Reid R000143 | rep | IL | 1969-01-03 | 1971-01-03 | Republican | 15 | |||||||||||||
30054 | 30054 | Charlotte Reid R000143 | rep | IL | 1971-01-21 | 1973-01-03 | Republican | 15 | |||||||||||||
30055 | 30055 | William Ryan R000562 | rep | NY | 1961-01-03 | 1963-01-03 | Democrat | 20 | |||||||||||||
30056 | 30056 | William Ryan R000562 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 20 | |||||||||||||
30057 | 30057 | William Ryan R000562 | rep | NY | 1965-01-04 | 1967-01-03 | Democrat | 20 |
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);