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 ✖
- 1931-12-07 495
- 1939-01-03 495
- 1941-01-03 492
- 1943-01-06 487
- 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
- 1949-01-03 480
- 1957-01-03 480
- 1975-01-14 480
- 1935-01-03 479
- 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
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19988 | 19988 | Leslie Steele S000835 | rep | GA | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
19989 | 19989 | Leslie Steele S000835 | rep | GA | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
19990 | 19990 | Hubert Stephens S000857 | rep | MS | 1911-04-04 | 1913-03-03 | Democrat | 2 | |||||||||||||
19991 | 19991 | Hubert Stephens S000857 | rep | MS | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
19992 | 19992 | Hubert Stephens S000857 | rep | MS | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
19993 | 19993 | Hubert Stephens S000857 | rep | MS | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
19994 | 19994 | Hubert Stephens S000857 | rep | MS | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
19995 | 19995 | Hubert Stephens S000857 | sen | MS | 1923-12-03 | 1929-03-03 | 1 | Democrat | |||||||||||||
19996 | 19996 | Hubert Stephens S000857 | sen | MS | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
19997 | 19997 | George Stobbs S000931 | rep | MA | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
19998 | 19998 | George Stobbs S000931 | rep | MA | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
19999 | 19999 | George Stobbs S000931 | rep | MA | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20000 | 20000 | Ulysses Stone S000964 | rep | OK | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
20001 | 20001 | Patrick Sullivan S001060 | sen | WY | 1929-12-05 | 1930-11-20 | 2 | Republican | appointment | ||||||||||||
20002 | 20002 | Daniel Sutherland S001079 | rep | AK | 1921-04-11 | 1923-03-03 | Republican | 0 | |||||||||||||
20003 | 20003 | Daniel Sutherland S001079 | rep | AK | 1923-12-03 | 1925-03-03 | Republican | 0 | |||||||||||||
20004 | 20004 | Daniel Sutherland S001079 | rep | AK | 1925-12-07 | 1927-03-04 | Republican | 0 | |||||||||||||
20005 | 20005 | Daniel Sutherland S001079 | rep | AK | 1927-12-05 | 1929-03-03 | Republican | 0 | |||||||||||||
20006 | 20006 | Daniel Sutherland S001079 | rep | AK | 1929-04-15 | 1931-03-03 | Republican | 0 | |||||||||||||
20007 | 20007 | Claude Swanson S001094 | rep | VA | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
20008 | 20008 | Claude Swanson S001094 | rep | VA | 1895-12-02 | 1897-03-03 | Democrat | 5 | |||||||||||||
20009 | 20009 | Claude Swanson S001094 | rep | VA | 1897-03-15 | 1899-03-03 | Democrat | 5 | |||||||||||||
20010 | 20010 | Claude Swanson S001094 | rep | VA | 1899-12-04 | 1901-03-03 | Democrat | 5 | |||||||||||||
20011 | 20011 | Claude Swanson S001094 | rep | VA | 1901-12-02 | 1903-03-03 | Democrat | 5 | |||||||||||||
20012 | 20012 | Claude Swanson S001094 | rep | VA | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
20013 | 20013 | Claude Swanson S001094 | rep | VA | 1905-12-04 | 1906-01-30 | Democrat | 5 | |||||||||||||
20014 | 20014 | Claude Swanson S001094 | sen | VA | 1910-08-01 | 1911-03-03 | 1 | Democrat | |||||||||||||
20015 | 20015 | Claude Swanson S001094 | sen | VA | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
20016 | 20016 | Claude Swanson S001094 | sen | VA | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
20017 | 20017 | Claude Swanson S001094 | sen | VA | 1923-12-03 | 1929-03-03 | 1 | Democrat | |||||||||||||
20018 | 20018 | Claude Swanson S001094 | sen | VA | 1929-04-15 | 1933-03-03 | 1 | Democrat | |||||||||||||
20019 | 20019 | Charles Thompson T000194 | rep | OH | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
20020 | 20020 | Charles Thompson T000194 | rep | OH | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
20021 | 20021 | Charles Thompson T000194 | rep | OH | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
20022 | 20022 | Charles Thompson T000194 | rep | OH | 1925-12-07 | 1927-03-04 | Republican | 5 | |||||||||||||
20023 | 20023 | Charles Thompson T000194 | rep | OH | 1927-12-05 | 1929-03-03 | Republican | 5 | |||||||||||||
20024 | 20024 | Charles Thompson T000194 | rep | OH | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
20025 | 20025 | Jonathan Wainwright W000023 | rep | NY | 1923-12-03 | 1925-03-03 | Republican | 25 | |||||||||||||
20026 | 20026 | Jonathan Wainwright W000023 | rep | NY | 1925-12-07 | 1927-03-04 | Republican | 25 | |||||||||||||
20027 | 20027 | Jonathan Wainwright W000023 | rep | NY | 1927-12-05 | 1929-03-03 | Republican | 25 | |||||||||||||
20028 | 20028 | Jonathan Wainwright W000023 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 25 | |||||||||||||
20029 | 20029 | Frederic Walcott W000032 | sen | CT | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
20030 | 20030 | Lewis Walker W000063 | rep | KY | 1929-04-15 | 1931-03-03 | Republican | 8 | |||||||||||||
20031 | 20031 | Laurence Watres W000196 | rep | PA | 1923-12-03 | 1925-03-03 | Republican | 11 | |||||||||||||
20032 | 20032 | Laurence Watres W000196 | rep | PA | 1925-12-07 | 1927-03-04 | Republican | 11 | |||||||||||||
20033 | 20033 | Laurence Watres W000196 | rep | PA | 1927-12-05 | 1929-03-03 | Republican | 11 | |||||||||||||
20034 | 20034 | Laurence Watres W000196 | rep | PA | 1929-04-15 | 1931-03-03 | Republican | 11 | |||||||||||||
20035 | 20035 | Royal Weller W000277 | rep | NY | 1923-12-03 | 1925-03-03 | Democrat | 21 | |||||||||||||
20036 | 20036 | Royal Weller W000277 | rep | NY | 1925-12-07 | 1927-03-04 | Democrat | 21 | |||||||||||||
20037 | 20037 | Royal Weller W000277 | rep | NY | 1927-12-05 | 1929-03-03 | Democrat | 21 | |||||||||||||
20038 | 20038 | Royal Weller W000277 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | -1 | |||||||||||||
20039 | 20039 | Joseph Whitehead W000400 | rep | VA | 1925-12-07 | 1927-03-04 | Democrat | 5 | |||||||||||||
20040 | 20040 | Joseph Whitehead W000400 | rep | VA | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
20041 | 20041 | Joseph Whitehead W000400 | rep | VA | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
20042 | 20042 | Thomas Williams W000542 | rep | IL | 1915-12-06 | 1917-03-03 | Republican | 24 | |||||||||||||
20043 | 20043 | Thomas Williams W000542 | rep | IL | 1917-04-02 | 1919-03-03 | Republican | 24 | |||||||||||||
20044 | 20044 | Thomas Williams W000542 | rep | IL | 1919-05-19 | 1921-03-03 | Republican | 24 | |||||||||||||
20045 | 20045 | Thomas Williams W000542 | rep | IL | 1921-04-11 | 1923-03-03 | Republican | 24 | |||||||||||||
20046 | 20046 | Thomas Williams W000542 | rep | IL | 1923-12-03 | 1925-03-03 | Republican | 24 | |||||||||||||
20047 | 20047 | Thomas Williams W000542 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 24 | |||||||||||||
20048 | 20048 | Thomas Williams W000542 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 24 | |||||||||||||
20049 | 20049 | Thomas Williams W000542 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 24 | |||||||||||||
20050 | 20050 | Otis Wingo W000635 | rep | AR | 1913-04-07 | 1915-03-03 | Democrat | 4 | |||||||||||||
20051 | 20051 | Otis Wingo W000635 | rep | AR | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
20052 | 20052 | Otis Wingo W000635 | rep | AR | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
20053 | 20053 | Otis Wingo W000635 | rep | AR | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
20054 | 20054 | Otis Wingo W000635 | rep | AR | 1921-04-11 | 1923-03-03 | Democrat | 4 | |||||||||||||
20055 | 20055 | Otis Wingo W000635 | rep | AR | 1923-12-03 | 1925-03-03 | Democrat | 4 | |||||||||||||
20056 | 20056 | Otis Wingo W000635 | rep | AR | 1925-12-07 | 1927-03-04 | Democrat | 4 | |||||||||||||
20057 | 20057 | Otis Wingo W000635 | rep | AR | 1927-12-05 | 1929-03-03 | Democrat | 4 | |||||||||||||
20058 | 20058 | Otis Wingo W000635 | rep | AR | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
20059 | 20059 | John Wolverton W000684 | rep | WV | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
20060 | 20060 | John Wolverton W000684 | rep | WV | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
20061 | 20061 | Frederick Zihlman Z000007 | rep | MD | 1917-04-02 | 1919-03-03 | Republican | 6 | |||||||||||||
20062 | 20062 | Frederick Zihlman Z000007 | rep | MD | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
20063 | 20063 | Frederick Zihlman Z000007 | rep | MD | 1921-04-11 | 1923-03-03 | Republican | 6 | |||||||||||||
20064 | 20064 | Frederick Zihlman Z000007 | rep | MD | 1923-12-03 | 1925-03-03 | Republican | 6 | |||||||||||||
20065 | 20065 | Frederick Zihlman Z000007 | rep | MD | 1925-12-07 | 1927-03-04 | Republican | 6 | |||||||||||||
20066 | 20066 | Frederick Zihlman Z000007 | rep | MD | 1927-12-05 | 1929-03-03 | Republican | 6 | |||||||||||||
20067 | 20067 | Frederick Zihlman Z000007 | rep | MD | 1929-04-15 | 1931-03-03 | Republican | 6 | |||||||||||||
20068 | 20068 | Robert Carey C000146 | sen | WY | 1930-12-01 | 1931-03-03 | 2 | Republican | |||||||||||||
20069 | 20069 | Robert Carey C000146 | sen | WY | 1931-12-07 | 1937-01-03 | 2 | Republican | |||||||||||||
20070 | 20070 | Dwight Morrow M001002 | sen | NJ | 1930-01-01 | 1931-03-03 | 2 | Republican | |||||||||||||
20071 | 20071 | Frank Partridge P000091 | sen | VT | 1930-12-23 | 1931-12-31 | 1 | Republican | appointment | ||||||||||||
20072 | 20072 | Ben Williamson W000550 | sen | KY | 1930-01-01 | 1931-03-03 | 2 | Democrat | |||||||||||||
20073 | 20073 | Ernest Ackerman A000021 | rep | NJ | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
20074 | 20074 | Ernest Ackerman A000021 | rep | NJ | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
20075 | 20075 | Ernest Ackerman A000021 | rep | NJ | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
20076 | 20076 | Ernest Ackerman A000021 | rep | NJ | 1925-12-07 | 1927-03-04 | Republican | 5 | |||||||||||||
20077 | 20077 | Ernest Ackerman A000021 | rep | NJ | 1927-12-05 | 1929-03-03 | Republican | 5 | |||||||||||||
20078 | 20078 | Ernest Ackerman A000021 | rep | NJ | 1929-04-15 | 1931-03-03 | Republican | 5 | |||||||||||||
20079 | 20079 | Ernest Ackerman A000021 | rep | NJ | 1931-12-07 | 1933-03-03 | Republican | 5 | |||||||||||||
20080 | 20080 | Charles Adkins A000057 | rep | IL | 1925-12-07 | 1927-03-04 | Republican | 19 | |||||||||||||
20081 | 20081 | Charles Adkins A000057 | rep | IL | 1927-12-05 | 1929-03-03 | Republican | 19 | |||||||||||||
20082 | 20082 | Charles Adkins A000057 | rep | IL | 1929-04-15 | 1931-03-03 | Republican | 19 | |||||||||||||
20083 | 20083 | Charles Adkins A000057 | rep | IL | 1931-12-07 | 1933-03-03 | Republican | 19 | |||||||||||||
20084 | 20084 | Richard Aldrich A000084 | rep | RI | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
20085 | 20085 | Richard Aldrich A000084 | rep | RI | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20086 | 20086 | Richard Aldrich A000084 | rep | RI | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20087 | 20087 | Richard Aldrich A000084 | rep | RI | 1929-04-15 | 1931-03-03 | Republican | 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);