legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows
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 432
- 1969-01-03 382
- 1967-01-10 338
- 1965-01-04 273
- 1963-01-09 232
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29856 | 29856 | William Hull H000947 | rep | MO | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
29857 | 29857 | Charles Jonas J000206 | rep | NC | 1953-01-03 | 1955-01-03 | Republican | 10 | |||||||||||||
29858 | 29858 | Charles Jonas J000206 | rep | NC | 1955-01-05 | 1957-01-03 | Republican | 10 | |||||||||||||
29859 | 29859 | Charles Jonas J000206 | rep | NC | 1957-01-03 | 1959-01-03 | Republican | 10 | |||||||||||||
29860 | 29860 | Charles Jonas J000206 | rep | NC | 1959-01-07 | 1961-01-03 | Republican | 10 | |||||||||||||
29861 | 29861 | Charles Jonas J000206 | rep | NC | 1961-01-03 | 1963-01-03 | Republican | 10 | |||||||||||||
29862 | 29862 | Charles Jonas J000206 | rep | NC | 1963-01-09 | 1965-01-03 | Republican | 8 | |||||||||||||
29863 | 29863 | Charles Jonas J000206 | rep | NC | 1965-01-04 | 1967-01-03 | Republican | 8 | |||||||||||||
29864 | 29864 | Charles Jonas J000206 | rep | NC | 1967-01-10 | 1969-01-03 | Republican | 8 | |||||||||||||
29865 | 29865 | Charles Jonas J000206 | rep | NC | 1969-01-03 | 1971-01-03 | Republican | 9 | |||||||||||||
29866 | 29866 | Charles Jonas J000206 | rep | NC | 1971-01-21 | 1973-01-03 | Republican | 9 | |||||||||||||
29867 | 29867 | James Kee K000038 | rep | WV | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
29868 | 29868 | James Kee K000038 | rep | WV | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
29869 | 29869 | James Kee K000038 | rep | WV | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
29870 | 29870 | James Kee K000038 | rep | WV | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
29871 | 29871 | Hastings Keith K000053 | rep | MA | 1959-01-07 | 1961-01-03 | Republican | 9 | |||||||||||||
29872 | 29872 | Hastings Keith K000053 | rep | MA | 1961-01-03 | 1963-01-03 | Republican | 9 | |||||||||||||
29873 | 29873 | Hastings Keith K000053 | rep | MA | 1963-01-09 | 1965-01-03 | Republican | 12 | |||||||||||||
29874 | 29874 | Hastings Keith K000053 | rep | MA | 1965-01-04 | 1967-01-03 | Republican | 12 | |||||||||||||
29875 | 29875 | Hastings Keith K000053 | rep | MA | 1967-01-10 | 1969-01-03 | Republican | 12 | |||||||||||||
29876 | 29876 | Hastings Keith K000053 | rep | MA | 1969-01-03 | 1971-01-03 | Republican | 12 | |||||||||||||
29877 | 29877 | Hastings Keith K000053 | rep | MA | 1971-01-21 | 1973-01-03 | Republican | 12 | |||||||||||||
29878 | 29878 | John Kyl K000351 | rep | IA | 1959-01-07 | 1961-01-03 | Republican | 4 | |||||||||||||
29879 | 29879 | John Kyl K000351 | rep | IA | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
29880 | 29880 | John Kyl K000351 | rep | IA | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
29881 | 29881 | John Kyl K000351 | rep | IA | 1967-01-10 | 1969-01-03 | Republican | 4 | |||||||||||||
29882 | 29882 | John Kyl K000351 | rep | IA | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
29883 | 29883 | John Kyl K000351 | rep | IA | 1971-01-21 | 1973-01-03 | Republican | 4 | |||||||||||||
29884 | 29884 | Alton Lennon L000240 | sen | NC | 1953-07-10 | 1955-01-03 | 2 | Democrat | appointment | ||||||||||||
29885 | 29885 | Alton Lennon L000240 | rep | NC | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
29886 | 29886 | Alton Lennon L000240 | rep | NC | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
29887 | 29887 | Alton Lennon L000240 | rep | NC | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
29888 | 29888 | Alton Lennon L000240 | rep | NC | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
29889 | 29889 | Alton Lennon L000240 | rep | NC | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
29890 | 29890 | Alton Lennon L000240 | rep | NC | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
29891 | 29891 | Alton Lennon L000240 | rep | NC | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
29892 | 29892 | Alton Lennon L000240 | rep | NC | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
29893 | 29893 | Arthur Link L000333 | rep | ND | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
29894 | 29894 | Sherman Lloyd L000382 | rep | UT | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
29895 | 29895 | Sherman Lloyd L000382 | rep | UT | 1967-01-10 | 1969-01-03 | Republican | 2 | |||||||||||||
29896 | 29896 | Sherman Lloyd L000382 | rep | UT | 1969-01-03 | 1971-01-03 | Republican | 2 | |||||||||||||
29897 | 29897 | Sherman Lloyd L000382 | rep | UT | 1971-01-21 | 1973-01-03 | Republican | 2 | |||||||||||||
29898 | 29898 | Speedy Long L000429 | rep | LA | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
29899 | 29899 | Speedy Long L000429 | rep | LA | 1967-01-10 | 1969-01-03 | Democrat | 8 | |||||||||||||
29900 | 29900 | Speedy Long L000429 | rep | LA | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
29901 | 29901 | Speedy Long L000429 | rep | LA | 1971-01-21 | 1973-01-03 | Democrat | 8 | |||||||||||||
29902 | 29902 | Michael Mansfield M000113 | rep | MT | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
29903 | 29903 | Michael Mansfield M000113 | rep | MT | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
29904 | 29904 | Michael Mansfield M000113 | rep | MT | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
29905 | 29905 | Michael Mansfield M000113 | rep | MT | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
29906 | 29906 | Michael Mansfield M000113 | rep | MT | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
29907 | 29907 | Michael Mansfield M000113 | sen | MT | 1953-01-03 | 1959-01-03 | 1 | Democrat | |||||||||||||
29908 | 29908 | Michael Mansfield M000113 | sen | MT | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
29909 | 29909 | Michael Mansfield M000113 | sen | MT | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
29910 | 29910 | Michael Mansfield M000113 | sen | MT | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
29911 | 29911 | William McCulloch M000393 | rep | OH | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
29912 | 29912 | William McCulloch M000393 | rep | OH | 1949-01-03 | 1951-01-03 | Republican | 4 | |||||||||||||
29913 | 29913 | William McCulloch M000393 | rep | OH | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
29914 | 29914 | William McCulloch M000393 | rep | OH | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
29915 | 29915 | William McCulloch M000393 | rep | OH | 1955-01-05 | 1957-01-03 | Republican | 4 | |||||||||||||
29916 | 29916 | William McCulloch M000393 | rep | OH | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
29917 | 29917 | William McCulloch M000393 | rep | OH | 1959-01-07 | 1961-01-03 | Republican | 4 | |||||||||||||
29918 | 29918 | William McCulloch M000393 | rep | OH | 1961-01-03 | 1963-01-03 | Republican | 4 | |||||||||||||
29919 | 29919 | William McCulloch M000393 | rep | OH | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
29920 | 29920 | William McCulloch M000393 | rep | OH | 1965-01-04 | 1967-01-03 | Republican | 4 | |||||||||||||
29921 | 29921 | William McCulloch M000393 | rep | OH | 1967-01-10 | 1969-01-03 | Republican | 4 | |||||||||||||
29922 | 29922 | William McCulloch M000393 | rep | OH | 1969-01-03 | 1971-01-03 | Republican | 4 | |||||||||||||
29923 | 29923 | William McCulloch M000393 | rep | OH | 1971-01-21 | 1973-01-03 | Republican | 4 | |||||||||||||
29924 | 29924 | Jack McDonald M000410 | rep | MI | 1967-01-10 | 1969-01-03 | Republican | 19 | |||||||||||||
29925 | 29925 | Jack McDonald M000410 | rep | MI | 1969-01-03 | 1971-01-03 | Republican | 19 | |||||||||||||
29926 | 29926 | Jack McDonald M000410 | rep | MI | 1971-01-21 | 1973-01-03 | Republican | 19 | |||||||||||||
29927 | 29927 | Gale McGee M000445 | sen | WY | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
29928 | 29928 | Gale McGee M000445 | sen | WY | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
29929 | 29929 | Gale McGee M000445 | sen | WY | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
29930 | 29930 | James McKevitt M000513 | rep | CO | 1971-01-21 | 1973-01-03 | Republican | 1 | |||||||||||||
29931 | 29931 | John McMillan M000568 | rep | SC | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
29932 | 29932 | John McMillan M000568 | rep | SC | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
29933 | 29933 | John McMillan M000568 | rep | SC | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
29934 | 29934 | John McMillan M000568 | rep | SC | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
29935 | 29935 | John McMillan M000568 | rep | SC | 1947-01-03 | 1949-01-03 | Democrat | 6 | |||||||||||||
29936 | 29936 | John McMillan M000568 | rep | SC | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
29937 | 29937 | John McMillan M000568 | rep | SC | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
29938 | 29938 | John McMillan M000568 | rep | SC | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
29939 | 29939 | John McMillan M000568 | rep | SC | 1955-01-05 | 1957-01-03 | Democrat | 6 | |||||||||||||
29940 | 29940 | John McMillan M000568 | rep | SC | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
29941 | 29941 | John McMillan M000568 | rep | SC | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
29942 | 29942 | John McMillan M000568 | rep | SC | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
29943 | 29943 | John McMillan M000568 | rep | SC | 1963-01-09 | 1965-01-03 | Democrat | 6 | |||||||||||||
29944 | 29944 | John McMillan M000568 | rep | SC | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
29945 | 29945 | John McMillan M000568 | rep | SC | 1967-01-10 | 1969-01-03 | Democrat | 6 | |||||||||||||
29946 | 29946 | John McMillan M000568 | rep | SC | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
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 |
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);