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 ✖
- 1947-01-03 485
- 1951-01-03 484
- 1959-01-07 484
- 1961-01-03 484
- 1969-01-03 482
- 1981-01-05 482
- 1963-01-09 481
- 1989-01-03 481
- 1949-01-03 480
- 1957-01-03 480
- 1975-01-14 480
- 1971-01-21 478
- 1977-01-04 478
- 1983-01-03 478
- 1991-01-03 478
- 1953-01-03 477
- 1965-01-04 477
- 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
- 1967-01-10 473
- 1999-01-06 473
- 2005-01-04 473
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23909 | 23909 | Jed Johnson J000150 | rep | OK | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
23910 | 23910 | Jed Johnson J000150 | rep | OK | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
23911 | 23911 | Luther Johnson J000159 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 6 | |||||||||||||
23912 | 23912 | Luther Johnson J000159 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 6 | |||||||||||||
23913 | 23913 | Luther Johnson J000159 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 6 | |||||||||||||
23914 | 23914 | Luther Johnson J000159 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
23915 | 23915 | Luther Johnson J000159 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
23916 | 23916 | Luther Johnson J000159 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
23917 | 23917 | Luther Johnson J000159 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
23918 | 23918 | Luther Johnson J000159 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
23919 | 23919 | Luther Johnson J000159 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
23920 | 23920 | Luther Johnson J000159 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
23921 | 23921 | Luther Johnson J000159 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
23922 | 23922 | Luther Johnson J000159 | rep | TX | 1945-01-03 | 1946-07-17 | Democrat | 6 | |||||||||||||
23923 | 23923 | Edward Kelly K000071 | rep | IL | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
23924 | 23924 | Edward Kelly K000071 | rep | IL | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
23925 | 23925 | Edward Kelly K000071 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
23926 | 23926 | Edward Kelly K000071 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23927 | 23927 | Edward Kelly K000071 | rep | IL | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
23928 | 23928 | Edward Kelly K000071 | rep | IL | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
23929 | 23929 | Edward Kelly K000071 | rep | IL | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
23930 | 23930 | John Kinzer K000231 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 10 | |||||||||||||
23931 | 23931 | John Kinzer K000231 | rep | PA | 1931-12-07 | 1933-03-03 | Republican | 10 | |||||||||||||
23932 | 23932 | John Kinzer K000231 | rep | PA | 1933-03-09 | 1935-01-03 | Republican | 10 | |||||||||||||
23933 | 23933 | John Kinzer K000231 | rep | PA | 1935-01-03 | 1937-01-03 | Republican | 10 | |||||||||||||
23934 | 23934 | John Kinzer K000231 | rep | PA | 1937-01-05 | 1939-01-03 | Republican | 10 | |||||||||||||
23935 | 23935 | John Kinzer K000231 | rep | PA | 1939-01-03 | 1941-01-03 | Republican | 10 | |||||||||||||
23936 | 23936 | John Kinzer K000231 | rep | PA | 1941-01-03 | 1943-01-03 | Republican | 10 | |||||||||||||
23937 | 23937 | John Kinzer K000231 | rep | PA | 1943-01-06 | 1945-01-03 | Republican | 10 | |||||||||||||
23938 | 23938 | John Kinzer K000231 | rep | PA | 1945-01-03 | 1947-01-03 | Republican | 9 | |||||||||||||
23939 | 23939 | Herman Kopplemann K000315 | rep | CT | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
23940 | 23940 | Herman Kopplemann K000315 | rep | CT | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
23941 | 23941 | Herman Kopplemann K000315 | rep | CT | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
23942 | 23942 | Herman Kopplemann K000315 | rep | CT | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
23943 | 23943 | Herman Kopplemann K000315 | rep | CT | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
23944 | 23944 | Charles La Follette L000003 | rep | IN | 1943-01-06 | 1945-01-03 | Republican | 8 | |||||||||||||
23945 | 23945 | Charles La Follette L000003 | rep | IN | 1945-01-03 | 1947-01-03 | Republican | 8 | |||||||||||||
23946 | 23946 | Fritz Lanham L000076 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
23947 | 23947 | Fritz Lanham L000076 | rep | TX | 1921-04-11 | 1923-03-03 | Democrat | 12 | |||||||||||||
23948 | 23948 | Fritz Lanham L000076 | rep | TX | 1923-12-03 | 1925-03-03 | Democrat | 12 | |||||||||||||
23949 | 23949 | Fritz Lanham L000076 | rep | TX | 1925-12-07 | 1927-03-04 | Democrat | 12 | |||||||||||||
23950 | 23950 | Fritz Lanham L000076 | rep | TX | 1927-12-05 | 1929-03-03 | Democrat | 12 | |||||||||||||
23951 | 23951 | Fritz Lanham L000076 | rep | TX | 1929-04-15 | 1931-03-03 | Democrat | 12 | |||||||||||||
23952 | 23952 | Fritz Lanham L000076 | rep | TX | 1931-12-07 | 1933-03-03 | Democrat | 12 | |||||||||||||
23953 | 23953 | Fritz Lanham L000076 | rep | TX | 1933-03-09 | 1935-01-03 | Democrat | 12 | |||||||||||||
23954 | 23954 | Fritz Lanham L000076 | rep | TX | 1935-01-03 | 1937-01-03 | Democrat | 12 | |||||||||||||
23955 | 23955 | Fritz Lanham L000076 | rep | TX | 1937-01-05 | 1939-01-03 | Democrat | 12 | |||||||||||||
23956 | 23956 | Fritz Lanham L000076 | rep | TX | 1939-01-03 | 1941-01-03 | Democrat | 12 | |||||||||||||
23957 | 23957 | Fritz Lanham L000076 | rep | TX | 1941-01-03 | 1943-01-03 | Democrat | 12 | |||||||||||||
23958 | 23958 | Fritz Lanham L000076 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 12 | |||||||||||||
23959 | 23959 | Fritz Lanham L000076 | rep | TX | 1945-01-03 | 1947-01-03 | Democrat | 12 | |||||||||||||
23960 | 23960 | William Link L000334 | rep | IL | 1945-01-03 | 1947-01-03 | Democrat | 7 | |||||||||||||
23961 | 23961 | Scott Lucas L000493 | rep | IL | 1935-01-03 | 1937-01-03 | Democrat | 20 | |||||||||||||
23962 | 23962 | Scott Lucas L000493 | rep | IL | 1937-01-05 | 1939-01-03 | Democrat | 20 | |||||||||||||
23963 | 23963 | Scott Lucas L000493 | sen | IL | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
23964 | 23964 | Scott Lucas L000493 | sen | IL | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
23965 | 23965 | Clare Luce L000497 | rep | CT | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
23966 | 23966 | Clare Luce L000497 | rep | CT | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
23967 | 23967 | Paul Maloney M000091 | rep | LA | 1931-12-07 | 1933-03-03 | Democrat | 2 | |||||||||||||
23968 | 23968 | Paul Maloney M000091 | rep | LA | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
23969 | 23969 | Paul Maloney M000091 | rep | LA | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
23970 | 23970 | Paul Maloney M000091 | rep | LA | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23971 | 23971 | Paul Maloney M000091 | rep | LA | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
23972 | 23972 | Paul Maloney M000091 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23973 | 23973 | Paul Maloney M000091 | rep | LA | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
23974 | 23974 | Helen Mankin M000097 | rep | GA | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
23975 | 23975 | Andrew May M000272 | rep | KY | 1931-12-07 | 1933-03-03 | Democrat | 10 | |||||||||||||
23976 | 23976 | Andrew May M000272 | rep | KY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
23977 | 23977 | Andrew May M000272 | rep | KY | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
23978 | 23978 | Andrew May M000272 | rep | KY | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
23979 | 23979 | Andrew May M000272 | rep | KY | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
23980 | 23980 | Andrew May M000272 | rep | KY | 1941-01-03 | 1943-01-03 | Democrat | 7 | |||||||||||||
23981 | 23981 | Andrew May M000272 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
23982 | 23982 | Andrew May M000272 | rep | KY | 1945-01-03 | 1947-01-03 | Democrat | 7 | |||||||||||||
23983 | 23983 | Daniel McGehee M000446 | rep | MS | 1935-01-03 | 1937-01-03 | Democrat | 7 | |||||||||||||
23984 | 23984 | Daniel McGehee M000446 | rep | MS | 1937-01-05 | 1939-01-03 | Democrat | 7 | |||||||||||||
23985 | 23985 | Daniel McGehee M000446 | rep | MS | 1939-01-03 | 1941-01-03 | Democrat | 7 | |||||||||||||
23986 | 23986 | Daniel McGehee M000446 | rep | MS | 1941-01-03 | 1943-01-03 | Democrat | 7 | |||||||||||||
23987 | 23987 | Daniel McGehee M000446 | rep | MS | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
23988 | 23988 | Daniel McGehee M000446 | rep | MS | 1945-01-03 | 1947-01-03 | Democrat | 7 | |||||||||||||
23989 | 23989 | Herbert McGlinchey M000451 | rep | PA | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
23990 | 23990 | Charles McKenzie M000504 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
23991 | 23991 | Charles McKenzie M000504 | rep | LA | 1945-01-03 | 1947-01-03 | Democrat | 5 | |||||||||||||
23992 | 23992 | John Moses M001029 | sen | ND | 1945-01-03 | 1945-12-31 | 3 | Democrat | |||||||||||||
23993 | 23993 | James Mott M001040 | rep | OR | 1933-03-09 | 1935-01-03 | Republican | 1 | |||||||||||||
23994 | 23994 | James Mott M001040 | rep | OR | 1935-01-03 | 1937-01-03 | Republican | 1 | |||||||||||||
23995 | 23995 | James Mott M001040 | rep | OR | 1937-01-05 | 1939-01-03 | Republican | 1 | |||||||||||||
23996 | 23996 | James Mott M001040 | rep | OR | 1939-01-03 | 1941-01-03 | Republican | 1 | |||||||||||||
23997 | 23997 | James Mott M001040 | rep | OR | 1941-01-03 | 1943-01-03 | Republican | 1 | |||||||||||||
23998 | 23998 | James Mott M001040 | rep | OR | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
23999 | 23999 | James Mott M001040 | rep | OR | 1945-01-03 | 1947-01-03 | Republican | 1 | |||||||||||||
24000 | 24000 | John Murphy M001099 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 11 | |||||||||||||
24001 | 24001 | John Murphy M001099 | rep | PA | 1945-01-03 | 1946-07-17 | Democrat | 10 | |||||||||||||
24002 | 24002 | Francis Myers M001127 | rep | PA | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
24003 | 24003 | Francis Myers M001127 | rep | PA | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
24004 | 24004 | Francis Myers M001127 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
24005 | 24005 | Francis Myers M001127 | sen | PA | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
24006 | 24006 | James O’Connor O000029 | rep | MT | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
24007 | 24007 | James O’Connor O000029 | rep | MT | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
24008 | 24008 | James O’Connor O000029 | rep | MT | 1941-01-03 | 1943-01-03 | Democrat | 2 |
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);