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 ✖
- 1929-04-15 499
- 1931-12-07 495
- 1939-01-03 495
- 1941-01-03 492
- 1943-01-06 487
- 1927-12-05 485
- 1933-03-09 485
- 1947-01-03 485
- 1945-01-03 484
- 1951-01-03 484
- 1959-01-07 484
- 1961-01-03 484
- 1937-01-05 483
- 1969-01-03 482
- 1981-01-05 482
- 1963-01-09 481
- 1989-01-03 481
- 1935-01-03 480
- 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
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18958 | 18958 | Frank Funk F000428 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 17 | |||||||||||||
18959 | 18959 | Frederick Gillett G000201 | rep | MA | 1893-08-07 | 1895-03-03 | Republican | 2 | |||||||||||||
18960 | 18960 | Frederick Gillett G000201 | rep | MA | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
18961 | 18961 | Frederick Gillett G000201 | rep | MA | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
18962 | 18962 | Frederick Gillett G000201 | rep | MA | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
18963 | 18963 | Frederick Gillett G000201 | rep | MA | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
18964 | 18964 | Frederick Gillett G000201 | rep | MA | 1903-11-09 | 1905-03-03 | Republican | 2 | |||||||||||||
18965 | 18965 | Frederick Gillett G000201 | rep | MA | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
18966 | 18966 | Frederick Gillett G000201 | rep | MA | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
18967 | 18967 | Frederick Gillett G000201 | rep | MA | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
18968 | 18968 | Frederick Gillett G000201 | rep | MA | 1911-04-04 | 1913-03-03 | Republican | 2 | |||||||||||||
18969 | 18969 | Frederick Gillett G000201 | rep | MA | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
18970 | 18970 | Frederick Gillett G000201 | rep | MA | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
18971 | 18971 | Frederick Gillett G000201 | rep | MA | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
18972 | 18972 | Frederick Gillett G000201 | rep | MA | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
18973 | 18973 | Frederick Gillett G000201 | rep | MA | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
18974 | 18974 | Frederick Gillett G000201 | rep | MA | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
18975 | 18975 | Frederick Gillett G000201 | sen | MA | 1925-12-07 | 1931-03-03 | 2 | Republican | |||||||||||||
18976 | 18976 | Guy Goff G000254 | sen | WV | 1925-12-07 | 1931-03-03 | 2 | Republican | |||||||||||||
18977 | 18977 | John Gorman G000329 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
18978 | 18978 | John Gorman G000329 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 6 | |||||||||||||
18979 | 18979 | James Heflin H000446 | rep | AL | 1904-05-19 | 1905-03-03 | Democrat | 5 | |||||||||||||
18980 | 18980 | James Heflin H000446 | rep | AL | 1905-12-04 | 1907-03-03 | Democrat | 5 | |||||||||||||
18981 | 18981 | James Heflin H000446 | rep | AL | 1907-12-02 | 1909-03-03 | Democrat | 5 | |||||||||||||
18982 | 18982 | James Heflin H000446 | rep | AL | 1909-03-15 | 1911-03-03 | Democrat | 5 | |||||||||||||
18983 | 18983 | James Heflin H000446 | rep | AL | 1911-04-04 | 1913-03-03 | Democrat | 5 | |||||||||||||
18984 | 18984 | James Heflin H000446 | rep | AL | 1913-04-07 | 1915-03-03 | Democrat | 5 | |||||||||||||
18985 | 18985 | James Heflin H000446 | rep | AL | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
18986 | 18986 | James Heflin H000446 | rep | AL | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
18987 | 18987 | James Heflin H000446 | rep | AL | 1919-05-19 | 1920-11-01 | Democrat | 5 | |||||||||||||
18988 | 18988 | James Heflin H000446 | sen | AL | 1920-11-03 | 1925-03-03 | 2 | Democrat | |||||||||||||
18989 | 18989 | James Heflin H000446 | sen | AL | 1925-12-07 | 1931-03-03 | 2 | Democrat | |||||||||||||
18990 | 18990 | John Hill H000597 | rep | MD | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
18991 | 18991 | John Hill H000597 | rep | MD | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
18992 | 18992 | John Hill H000597 | rep | MD | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
18993 | 18993 | William Jarrett J000061 | rep | HI | 1923-12-03 | 1925-03-03 | Democrat | -1 | |||||||||||||
18994 | 18994 | William Jarrett J000061 | rep | HI | 1925-12-07 | 1927-03-04 | Democrat | -1 | |||||||||||||
18995 | 18995 | Ben Johnson J000118 | rep | KY | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
18996 | 18996 | Ben Johnson J000118 | rep | KY | 1909-03-15 | 1911-03-03 | Democrat | 4 | |||||||||||||
18997 | 18997 | Ben Johnson J000118 | rep | KY | 1911-04-04 | 1913-03-03 | Democrat | 4 | |||||||||||||
18998 | 18998 | Ben Johnson J000118 | rep | KY | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
18999 | 18999 | Ben Johnson J000118 | rep | KY | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
19000 | 19000 | Ben Johnson J000118 | rep | KY | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
19001 | 19001 | Ben Johnson J000118 | rep | KY | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
19002 | 19002 | Ben Johnson J000118 | rep | KY | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
19003 | 19003 | Ben Johnson J000118 | rep | KY | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
19004 | 19004 | Ben Johnson J000118 | rep | KY | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
19005 | 19005 | Oscar Keller K000057 | rep | MN | 1919-05-19 | 1921-03-03 | Ind. Republican | 4 | |||||||||||||
19006 | 19006 | Oscar Keller K000057 | rep | MN | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
19007 | 19007 | Oscar Keller K000057 | rep | MN | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
19008 | 19008 | Oscar Keller K000057 | rep | MN | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
19009 | 19009 | Andrew Kirk K000234 | rep | KY | 1925-12-07 | 1927-03-04 | Republican | 10 | |||||||||||||
19010 | 19010 | John Langley L000072 | rep | KY | 1907-12-02 | 1909-03-03 | Republican | 10 | |||||||||||||
19011 | 19011 | John Langley L000072 | rep | KY | 1909-03-15 | 1911-03-03 | Republican | 10 | |||||||||||||
19012 | 19012 | John Langley L000072 | rep | KY | 1911-04-04 | 1913-03-03 | Republican | 10 | |||||||||||||
19013 | 19013 | John Langley L000072 | rep | KY | 1913-04-07 | 1915-03-03 | Republican | 10 | |||||||||||||
19014 | 19014 | John Langley L000072 | rep | KY | 1915-12-06 | 1917-03-03 | Republican | 10 | |||||||||||||
19015 | 19015 | John Langley L000072 | rep | KY | 1917-04-02 | 1919-03-03 | Republican | 10 | |||||||||||||
19016 | 19016 | John Langley L000072 | rep | KY | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
19017 | 19017 | John Langley L000072 | rep | KY | 1921-04-11 | 1923-03-03 | Republican | 10 | |||||||||||||
19018 | 19018 | John Langley L000072 | rep | KY | 1923-12-03 | 1925-03-03 | Republican | 10 | |||||||||||||
19019 | 19019 | John Langley L000072 | rep | KY | 1925-12-07 | 1927-03-04 | Republican | -1 | |||||||||||||
19020 | 19020 | Gordon Lee L000194 | rep | GA | 1905-12-04 | 1907-03-03 | Democrat | 7 | |||||||||||||
19021 | 19021 | Gordon Lee L000194 | rep | GA | 1907-12-02 | 1909-03-03 | Democrat | 7 | |||||||||||||
19022 | 19022 | Gordon Lee L000194 | rep | GA | 1909-03-15 | 1911-03-03 | Democrat | 7 | |||||||||||||
19023 | 19023 | Gordon Lee L000194 | rep | GA | 1911-04-04 | 1913-03-03 | Democrat | 7 | |||||||||||||
19024 | 19024 | Gordon Lee L000194 | rep | GA | 1913-04-07 | 1915-03-03 | Democrat | 7 | |||||||||||||
19025 | 19025 | Gordon Lee L000194 | rep | GA | 1915-12-06 | 1917-03-03 | Democrat | 7 | |||||||||||||
19026 | 19026 | Gordon Lee L000194 | rep | GA | 1917-04-02 | 1919-03-03 | Democrat | 7 | |||||||||||||
19027 | 19027 | Gordon Lee L000194 | rep | GA | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
19028 | 19028 | Gordon Lee L000194 | rep | GA | 1921-04-11 | 1923-03-03 | Democrat | 7 | |||||||||||||
19029 | 19029 | Gordon Lee L000194 | rep | GA | 1923-12-03 | 1925-03-03 | Democrat | 7 | |||||||||||||
19030 | 19030 | Gordon Lee L000194 | rep | GA | 1925-12-07 | 1927-03-04 | Democrat | 7 | |||||||||||||
19031 | 19031 | Walter Lineberger L000331 | rep | CA | 1921-04-11 | 1923-03-03 | Republican | 9 | |||||||||||||
19032 | 19032 | Walter Lineberger L000331 | rep | CA | 1923-12-03 | 1925-03-03 | Republican | 9 | |||||||||||||
19033 | 19033 | Walter Lineberger L000331 | rep | CA | 1925-12-07 | 1927-03-04 | Republican | 9 | |||||||||||||
19034 | 19034 | Chauncey Little L000348 | rep | KS | 1925-12-07 | 1927-03-04 | Democrat | 2 | |||||||||||||
19035 | 19035 | James Magee M000046 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 35 | |||||||||||||
19036 | 19036 | James Magee M000046 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 35 | |||||||||||||
19037 | 19037 | Melvin McLaughlin M000541 | rep | NE | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
19038 | 19038 | Melvin McLaughlin M000541 | rep | NE | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
19039 | 19039 | Melvin McLaughlin M000541 | rep | NE | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
19040 | 19040 | Melvin McLaughlin M000541 | rep | NE | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
19041 | 19041 | William McMaster M000563 | sen | SD | 1925-12-07 | 1931-03-03 | 2 | Republican | |||||||||||||
19042 | 19042 | Ogden Mills M000776 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 17 | |||||||||||||
19043 | 19043 | Ogden Mills M000776 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 17 | |||||||||||||
19044 | 19044 | Ogden Mills M000776 | rep | NY | 1925-12-07 | 1927-03-04 | Republican | 17 | |||||||||||||
19045 | 19045 | Samuel Montgomery M000870 | rep | OK | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
19046 | 19046 | Cleveland Newton N000075 | rep | MO | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
19047 | 19047 | Cleveland Newton N000075 | rep | MO | 1921-04-11 | 1923-03-03 | Republican | 10 | |||||||||||||
19048 | 19048 | Cleveland Newton N000075 | rep | MO | 1923-12-03 | 1925-03-03 | Republican | 10 | |||||||||||||
19049 | 19049 | Cleveland Newton N000075 | rep | MO | 1925-12-07 | 1927-03-04 | Republican | 10 | |||||||||||||
19050 | 19050 | Francis Patterson P000114 | rep | NJ | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
19051 | 19051 | Francis Patterson P000114 | rep | NJ | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
19052 | 19052 | Francis Patterson P000114 | rep | NJ | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
19053 | 19053 | Francis Patterson P000114 | rep | NJ | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
19054 | 19054 | Nathan Perlman P000239 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 14 | |||||||||||||
19055 | 19055 | Nathan Perlman P000239 | rep | NY | 1921-04-11 | 1923-03-03 | Republican | 14 | |||||||||||||
19056 | 19056 | Nathan Perlman P000239 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 14 | |||||||||||||
19057 | 19057 | Nathan Perlman P000239 | rep | NY | 1925-12-07 | 1927-03-04 | Republican | 14 |
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);