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)
end (date) >30 ✖
- 1931-03-03 502
- 1933-03-03 499
- 1941-01-03 498
- 1945-01-03 493
- 1939-01-03 492
- 1929-03-03 489
- 1963-01-03 489
- 1925-03-03 488
- 1943-01-03 488
- 1947-01-03 488
- 1935-01-03 486
- 1949-01-03 486
- 1953-01-03 486
- 1937-01-03 485
- 1955-01-03 485
- 1927-03-04 484
- 1961-01-03 483
- 1971-01-03 483
- 1923-03-03 482
- 1951-01-03 482
- 1965-01-03 482
- 1983-01-03 481
- 1959-01-03 480
- 1977-01-03 480
- 1967-01-03 479
- 1975-01-03 479
- 1981-01-03 479
- 1987-01-03 478
- 1957-01-03 477
- 1973-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17921 | 17921 | Thomas Scully S000206 | rep | NJ | 1911-04-04 | 1913-03-03 | Democrat | 3 | |||||||||||||
17922 | 17922 | Thomas Scully S000206 | rep | NJ | 1913-04-07 | 1915-03-03 | Democrat | 3 | |||||||||||||
17923 | 17923 | Thomas Scully S000206 | rep | NJ | 1915-12-06 | 1917-03-03 | Democrat | 3 | |||||||||||||
17924 | 17924 | Thomas Scully S000206 | rep | NJ | 1917-04-02 | 1919-03-03 | Democrat | 3 | |||||||||||||
17925 | 17925 | Thomas Scully S000206 | rep | NJ | 1919-05-19 | 1921-03-03 | Democrat | 3 | |||||||||||||
17926 | 17926 | Sam Sells S000235 | rep | TN | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
17927 | 17927 | Sam Sells S000235 | rep | TN | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
17928 | 17928 | Sam Sells S000235 | rep | TN | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
17929 | 17929 | Sam Sells S000235 | rep | TN | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
17930 | 17930 | Sam Sells S000235 | rep | TN | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
17931 | 17931 | John Shields S000363 | sen | TN | 1913-04-07 | 1919-03-03 | 2 | Democrat | |||||||||||||
17932 | 17932 | John Shields S000363 | sen | TN | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
17933 | 17933 | Thetus Sims S000441 | rep | TN | 1897-03-15 | 1899-03-03 | Democrat | 8 | |||||||||||||
17934 | 17934 | Thetus Sims S000441 | rep | TN | 1899-12-04 | 1901-03-03 | Democrat | 8 | |||||||||||||
17935 | 17935 | Thetus Sims S000441 | rep | TN | 1901-12-02 | 1903-03-03 | Democrat | 8 | |||||||||||||
17936 | 17936 | Thetus Sims S000441 | rep | TN | 1903-11-09 | 1905-03-03 | Democrat | 8 | |||||||||||||
17937 | 17937 | Thetus Sims S000441 | rep | TN | 1905-12-04 | 1907-03-03 | Democrat | 8 | |||||||||||||
17938 | 17938 | Thetus Sims S000441 | rep | TN | 1907-12-02 | 1909-03-03 | Democrat | 8 | |||||||||||||
17939 | 17939 | Thetus Sims S000441 | rep | TN | 1909-03-15 | 1911-03-03 | Democrat | 8 | |||||||||||||
17940 | 17940 | Thetus Sims S000441 | rep | TN | 1911-04-04 | 1913-03-03 | Democrat | 8 | |||||||||||||
17941 | 17941 | Thetus Sims S000441 | rep | TN | 1913-04-07 | 1915-03-03 | Democrat | 8 | |||||||||||||
17942 | 17942 | Thetus Sims S000441 | rep | TN | 1915-12-06 | 1917-03-03 | Democrat | 8 | |||||||||||||
17943 | 17943 | Thetus Sims S000441 | rep | TN | 1917-04-02 | 1919-03-03 | Democrat | 8 | |||||||||||||
17944 | 17944 | Thetus Sims S000441 | rep | TN | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
17945 | 17945 | John Small S000500 | rep | NC | 1899-12-04 | 1901-03-03 | Democrat | 1 | |||||||||||||
17946 | 17946 | John Small S000500 | rep | NC | 1901-12-02 | 1903-03-03 | Democrat | 1 | |||||||||||||
17947 | 17947 | John Small S000500 | rep | NC | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
17948 | 17948 | John Small S000500 | rep | NC | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
17949 | 17949 | John Small S000500 | rep | NC | 1907-12-02 | 1909-03-03 | Democrat | 1 | |||||||||||||
17950 | 17950 | John Small S000500 | rep | NC | 1909-03-15 | 1911-03-03 | Democrat | 1 | |||||||||||||
17951 | 17951 | John Small S000500 | rep | NC | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
17952 | 17952 | John Small S000500 | rep | NC | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
17953 | 17953 | John Small S000500 | rep | NC | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17954 | 17954 | John Small S000500 | rep | NC | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17955 | 17955 | John Small S000500 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
17956 | 17956 | Thomas Smith S000619 | rep | NY | 1917-04-02 | 1919-03-03 | Democrat | 15 | |||||||||||||
17957 | 17957 | Thomas Smith S000619 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 16 | |||||||||||||
17958 | 17958 | Augustus Stanley S000796 | rep | KY | 1903-11-09 | 1905-03-03 | Democrat | 2 | |||||||||||||
17959 | 17959 | Augustus Stanley S000796 | rep | KY | 1905-12-04 | 1907-03-03 | Democrat | 2 | |||||||||||||
17960 | 17960 | Augustus Stanley S000796 | rep | KY | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
17961 | 17961 | Augustus Stanley S000796 | rep | KY | 1909-03-15 | 1911-03-03 | Democrat | 2 | |||||||||||||
17962 | 17962 | Augustus Stanley S000796 | rep | KY | 1911-04-04 | 1913-03-03 | Democrat | 2 | |||||||||||||
17963 | 17963 | Augustus Stanley S000796 | rep | KY | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
17964 | 17964 | Augustus Stanley S000796 | sen | KY | 1919-05-19 | 1925-03-03 | 2 | Democrat | |||||||||||||
17965 | 17965 | Henry Steele S000831 | rep | PA | 1915-12-06 | 1917-03-03 | Democrat | 26 | |||||||||||||
17966 | 17966 | Henry Steele S000831 | rep | PA | 1917-04-02 | 1919-03-03 | Democrat | 26 | |||||||||||||
17967 | 17967 | Henry Steele S000831 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 26 | |||||||||||||
17968 | 17968 | Thomas Sterling S000872 | sen | SD | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
17969 | 17969 | Thomas Sterling S000872 | sen | SD | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
17970 | 17970 | Charles Sulzer S001064 | rep | AK | 1917-04-02 | 1919-03-03 | 0 | ||||||||||||||
17971 | 17971 | Charles Sulzer S001064 | rep | AK | 1919-05-19 | 1921-03-03 | 0 | ||||||||||||||
17972 | 17972 | Charles Swindall S001121 | rep | OK | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
17973 | 17973 | King Swope S001129 | rep | KY | 1919-05-19 | 1921-03-03 | Republican | 8 | |||||||||||||
17974 | 17974 | Joseph Thompson T000210 | rep | OK | 1913-04-07 | 1915-03-03 | Democrat | -1 | |||||||||||||
17975 | 17975 | Joseph Thompson T000210 | rep | OK | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17976 | 17976 | Joseph Thompson T000210 | rep | OK | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
17977 | 17977 | Joseph Thompson T000210 | rep | OK | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
17978 | 17978 | Carl Van Dyke V000034 | rep | MN | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17979 | 17979 | Carl Van Dyke V000034 | rep | MN | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
17980 | 17980 | Carl Van Dyke V000034 | rep | MN | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
17981 | 17981 | William Venable V000086 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
17982 | 17982 | William Venable V000086 | rep | MS | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
17983 | 17983 | William Venable V000086 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
17984 | 17984 | John Watkins W000193 | rep | LA | 1905-12-04 | 1907-03-03 | Democrat | 4 | |||||||||||||
17985 | 17985 | John Watkins W000193 | rep | LA | 1907-12-02 | 1909-03-03 | Democrat | 4 | |||||||||||||
17986 | 17986 | John Watkins W000193 | rep | LA | 1909-03-15 | 1911-03-03 | Democrat | 4 | |||||||||||||
17987 | 17987 | John Watkins W000193 | rep | LA | 1911-04-04 | 1913-03-03 | Democrat | 4 | |||||||||||||
17988 | 17988 | John Watkins W000193 | rep | LA | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
17989 | 17989 | John Watkins W000193 | rep | LA | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17990 | 17990 | John Watkins W000193 | rep | LA | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
17991 | 17991 | John Watkins W000193 | rep | LA | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
17992 | 17992 | Walter Watson W000206 | rep | VA | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
17993 | 17993 | Walter Watson W000206 | rep | VA | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17994 | 17994 | Walter Watson W000206 | rep | VA | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
17995 | 17995 | Walter Watson W000206 | rep | VA | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
17996 | 17996 | Edwin Webb W000231 | rep | NC | 1903-11-09 | 1905-03-03 | Democrat | 9 | |||||||||||||
17997 | 17997 | Edwin Webb W000231 | rep | NC | 1905-12-04 | 1907-03-03 | Democrat | 9 | |||||||||||||
17998 | 17998 | Edwin Webb W000231 | rep | NC | 1907-12-02 | 1909-03-03 | Democrat | 9 | |||||||||||||
17999 | 17999 | Edwin Webb W000231 | rep | NC | 1909-03-15 | 1911-03-03 | Democrat | 9 | |||||||||||||
18000 | 18000 | Edwin Webb W000231 | rep | NC | 1911-04-04 | 1913-03-03 | Democrat | 9 | |||||||||||||
18001 | 18001 | Edwin Webb W000231 | rep | NC | 1913-04-07 | 1915-03-03 | Democrat | 9 | |||||||||||||
18002 | 18002 | Edwin Webb W000231 | rep | NC | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
18003 | 18003 | Edwin Webb W000231 | rep | NC | 1917-04-02 | 1919-03-03 | Democrat | 9 | |||||||||||||
18004 | 18004 | Edwin Webb W000231 | rep | NC | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
18005 | 18005 | Milton Welling W000278 | rep | UT | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
18006 | 18006 | Milton Welling W000278 | rep | UT | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
18007 | 18007 | Benjamin Welty W000291 | rep | OH | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
18008 | 18008 | Benjamin Welty W000291 | rep | OH | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
18009 | 18009 | Richard Whaley W000319 | rep | SC | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
18010 | 18010 | Richard Whaley W000319 | rep | SC | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
18011 | 18011 | Richard Whaley W000319 | rep | SC | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
18012 | 18012 | Richard Whaley W000319 | rep | SC | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
18013 | 18013 | James Wilson W000593 | rep | TX | 1917-04-02 | 1919-03-03 | Democrat | 12 | |||||||||||||
18014 | 18014 | James Wilson W000593 | rep | TX | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
18015 | 18015 | John Wilson W000600 | rep | PA | 1919-05-19 | 1921-03-03 | Democrat | 22 | |||||||||||||
18016 | 18016 | William Wilson W000624 | rep | IL | 1903-11-09 | 1905-03-03 | Republican | 3 | |||||||||||||
18017 | 18017 | William Wilson W000624 | rep | IL | 1905-12-04 | 1907-03-03 | Republican | 3 | |||||||||||||
18018 | 18018 | William Wilson W000624 | rep | IL | 1907-12-02 | 1909-03-03 | Republican | 3 | |||||||||||||
18019 | 18019 | William Wilson W000624 | rep | IL | 1909-03-15 | 1911-03-03 | Republican | 3 | |||||||||||||
18020 | 18020 | William Wilson W000624 | rep | IL | 1911-04-04 | 1913-03-03 | Republican | 3 |
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);