legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
3,910 rows where type = "sen" sorted by state descending
This data as json, copyable, CSV (advanced)
Suggested facets: party, how, state_rank, end (date)
start (date) >30 ✖
- 1913-04-07 39
- 1911-04-04 36
- 1925-12-07 36
- 1941-01-03 36
- 1993-01-05 36
- 2015-01-06 36
- 1907-12-02 35
- 1923-12-03 35
- 1959-01-07 35
- 1963-01-09 35
- 1895-12-02 34
- 1897-03-15 34
- 1957-01-03 34
- 1961-01-03 34
- 1981-01-05 34
- 1987-01-06 34
- 1989-01-03 34
- 1999-01-06 34
- 2003-01-07 34
- 2005-01-04 34
- 2011-01-05 34
- 2013-01-03 34
- 2017-01-03 34
- 1929-04-15 33
- 1931-12-07 33
- 1933-03-09 33
- 1939-01-03 33
- 1945-01-03 33
- 1949-01-03 33
- 1953-01-03 33
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12055 | 12055 | Joseph Carey C000145 | sen | WY | 1890-11-15 | 1895-03-03 | 2 | Republican | |||||||||||||
15895 | 15895 | Clarence Clark C000425 | sen | WY | 1895-12-02 | 1899-03-03 | 1 | Republican | |||||||||||||
15896 | 15896 | Clarence Clark C000425 | sen | WY | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
15897 | 15897 | Clarence Clark C000425 | sen | WY | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
15898 | 15898 | Clarence Clark C000425 | sen | WY | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
19150 | 19150 | Francis Warren W000164 | sen | WY | 1890-12-01 | 1893-03-03 | 1 | Republican | |||||||||||||
19151 | 19151 | Francis Warren W000164 | sen | WY | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
19152 | 19152 | Francis Warren W000164 | sen | WY | 1901-12-02 | 1907-03-03 | 2 | Republican | |||||||||||||
19153 | 19153 | Francis Warren W000164 | sen | WY | 1907-12-02 | 1913-03-03 | 2 | Republican | |||||||||||||
19154 | 19154 | Francis Warren W000164 | sen | WY | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
19155 | 19155 | Francis Warren W000164 | sen | WY | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
19156 | 19156 | Francis Warren W000164 | sen | WY | 1925-12-07 | 1929-11-24 | 2 | Republican | |||||||||||||
19811 | 19811 | John Kendrick K000098 | sen | WY | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
19812 | 19812 | John Kendrick K000098 | sen | WY | 1923-12-03 | 1929-03-03 | 1 | Democrat | |||||||||||||
19813 | 19813 | John Kendrick K000098 | sen | WY | 1929-04-15 | 1933-11-03 | 1 | Democrat | |||||||||||||
20001 | 20001 | Patrick Sullivan S001060 | sen | WY | 1929-12-05 | 1930-11-20 | 2 | Republican | appointment | ||||||||||||
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 | |||||||||||||
22401 | 22401 | Henry Schwartz S000157 | sen | WY | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
23653 | 23653 | Edward Robertson R000320 | sen | WY | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
24857 | 24857 | Lester Hunt H000975 | sen | WY | 1949-01-03 | 1954-06-19 | 2 | Democrat | |||||||||||||
25589 | 25589 | Frank Barrett B000176 | sen | WY | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
25856 | 25856 | Edward Crippa C000906 | sen | WY | 1954-06-24 | 1955-01-03 | 2 | Republican | appointment | ||||||||||||
25858 | 25858 | Joseph O’Mahoney O000088 | sen | WY | 1933-12-18 | 1935-01-03 | 1 | Democrat | appointment | ||||||||||||
25859 | 25859 | Joseph O’Mahoney O000088 | sen | WY | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
25860 | 25860 | Joseph O’Mahoney O000088 | sen | WY | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
25861 | 25861 | Joseph O’Mahoney O000088 | sen | WY | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
25862 | 25862 | Joseph O’Mahoney O000088 | sen | WY | 1954-11-29 | 1955-01-03 | 2 | Democrat | |||||||||||||
25863 | 25863 | Joseph O’Mahoney O000088 | sen | WY | 1955-01-03 | 1961-01-03 | 2 | Democrat | |||||||||||||
27225 | 27225 | John Hickey H000561 | sen | WY | 1961-01-03 | 1963-01-03 | 2 | Democrat | appointment | ||||||||||||
27601 | 27601 | Milward Simpson S000434 | sen | WY | 1962-01-01 | 1967-01-03 | 2 | Republican | |||||||||||||
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 | |||||||||||||
30452 | 30452 | Clifford Hansen H000170 | sen | WY | 1967-01-10 | 1973-01-03 | 2 | Republican | |||||||||||||
30453 | 30453 | Clifford Hansen H000170 | sen | WY | 1973-01-03 | 1979-01-03 | 2 | Republican | |||||||||||||
34131 | 34131 | Malcolm Wallop W000092 | sen | WY | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
34132 | 34132 | Malcolm Wallop W000092 | sen | WY | 1983-01-03 | 1989-01-03 | 1 | Republican | |||||||||||||
34133 | 34133 | Malcolm Wallop W000092 | sen | WY | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
34963 | 34963 | Alan Simpson S000429 | sen | WY | 1979-01-15 | 1985-01-03 | 2 | Republican | |||||||||||||
34964 | 34964 | Alan Simpson S000429 | sen | WY | 1985-01-03 | 1991-01-03 | 2 | Republican | |||||||||||||
34965 | 34965 | Alan Simpson S000429 | sen | WY | 1991-01-03 | 1997-01-03 | 2 | Republican | |||||||||||||
38352 | 38352 | Craig Thomas T000162 | sen | WY | 1995-01-04 | 2001-01-03 | 1 | Republican | |||||||||||||
38353 | 38353 | Craig Thomas T000162 | sen | WY | 2001-01-03 | 2007-01-03 | 1 | Republican | http://thomas.senate.gov/ | ||||||||||||
38354 | 38354 | Craig Thomas T000162 | sen | WY | 2007-01-04 | 2007-06-04 | 1 | Republican | http://thomas.senate.gov/ | ||||||||||||
41262 | 41262 | Michael Enzi E000285 | sen | WY | 1997-01-07 | 2003-01-03 | 2 | Republican | |||||||||||||
41263 | 41263 | Michael Enzi E000285 | sen | WY | 2003-01-07 | 2009-01-03 | 2 | Republican | http://enzi.senate.gov | ||||||||||||
41264 | 41264 | Michael Enzi E000285 | sen | WY | 2009-01-06 | 2015-01-03 | 2 | Republican | http://www.enzi.senate.gov | 379A Russell Senate Office Building Washington DC 20510 | 202-224-3424 | 202-228-0359 | http://www.enzi.senate.gov/public/index.cfm/contact?p=e-mail-senator-enzi | 379a Russell Senate Office Building | senior | http://www.enzi.senate.gov/public/index.cfm/rss/feed | |||||
41265 | 41265 | Michael Enzi E000285 | sen | WY | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.enzi.senate.gov | 379A Russell Senate Office Building Washington DC 20510 | 202-224-3424 | 202-228-0359 | http://www.enzi.senate.gov/public/index.cfm/contact?p=e-mail-senator-enzi | 379a Russell Senate Office Building | senior | http://www.enzi.senate.gov/public/index.cfm/rss/feed | |||||
41813 | 41813 | John Barrasso B001261 | sen | WY | 2007-06-25 | 2013-01-03 | 1 | Republican | appointment | http://barrasso.senate.gov | 307 DIRKSEN SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-6441 | 202-224-1724 | http://www.barrasso.senate.gov/public/index.cfm?FuseAction=ContactUs.ContactForm | 307 Dirksen Senate Office Building | ||||||
41814 | 41814 | John Barrasso B001261 | sen | WY | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.barrasso.senate.gov | 307 Dirksen Senate Office Building Washington DC 20510 | 202-224-6441 | 202-224-1724 | https://www.barrasso.senate.gov/public/index.cfm/contact-form | 307 Dirksen Senate Office Building | junior | http://www.barrasso.senate.gov/public/index.cfm?FuseAction=Rss.Feed | |||||
41815 | 41815 | John Barrasso B001261 | sen | WY | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.barrasso.senate.gov | 307 Dirksen Senate Office Building Washington DC 20510 | 202-224-6441 | https://www.barrasso.senate.gov/public/index.cfm/contact-form | 307 Dirksen Senate Office Building | senior | http://www.barrasso.senate.gov/public/index.cfm?FuseAction=Rss.Feed | ||||||
44444 | 44444 | Cynthia Lummis L000571 | sen | WY | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.lummis.senate.gov | 124 Russell Senate Office Building Washington DC 20510 | 202-224-3424 | https://www.lummis.senate.gov/contact/contact-form/ | 124 Russell Senate Office Building | junior | |||||||
8051 | 8051 | Peter Van Winkle V000066 | sen | WV | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
8234 | 8234 | Waitman Willey W000484 | sen | WV | 1863-12-07 | 1865-03-03 | 2 | Unconditional Unionist | |||||||||||||
8235 | 8235 | Waitman Willey W000484 | sen | WV | 1865-12-04 | 1871-03-03 | 2 | Republican | |||||||||||||
8527 | 8527 | Arthur Boreman B000638 | sen | WV | 1869-03-04 | 1875-03-03 | 1 | Republican | |||||||||||||
9478 | 9478 | Allen Caperton C000130 | sen | WV | 1875-12-06 | 1877-03-03 | 1 | Democrat | |||||||||||||
9726 | 9726 | Samuel Price P000530 | sen | WV | 1876-01-01 | 1877-12-31 | 1 | Democrat | |||||||||||||
9782 | 9782 | Henry Davis D000103 | sen | WV | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
9783 | 9783 | Henry Davis D000103 | sen | WV | 1877-10-15 | 1883-03-03 | 2 | Democrat | |||||||||||||
9849 | 9849 | Frank Hereford H000527 | sen | WV | 1877-10-15 | 1881-03-03 | 1 | Democrat | |||||||||||||
11802 | 11802 | John Kenna K000099 | sen | WV | 1883-12-03 | 1889-03-03 | 2 | Democrat | |||||||||||||
11803 | 11803 | John Kenna K000099 | sen | WV | 1889-12-02 | 1893-12-31 | 2 | Democrat | |||||||||||||
12467 | 12467 | Johnson Camden C000062 | sen | WV | 1881-12-05 | 1887-03-03 | 1 | Democrat | |||||||||||||
12468 | 12468 | Johnson Camden C000062 | sen | WV | 1893-08-07 | 1895-03-03 | 2 | Democrat | |||||||||||||
12541 | 12541 | Charles Faulkner F000045 | sen | WV | 1887-12-05 | 1893-03-03 | 1 | Democrat | |||||||||||||
12542 | 12542 | Charles Faulkner F000045 | sen | WV | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
14887 | 14887 | Nathan Scott S000182 | sen | WV | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14888 | 14888 | Nathan Scott S000182 | sen | WV | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
15095 | 15095 | Stephen Elkins E000110 | sen | WV | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
15096 | 15096 | Stephen Elkins E000110 | sen | WV | 1901-12-02 | 1907-03-03 | 2 | Republican | |||||||||||||
15097 | 15097 | Stephen Elkins E000110 | sen | WV | 1907-12-02 | 1911-12-31 | 2 | Republican | |||||||||||||
15889 | 15889 | William Chilton C000360 | sen | WV | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
16227 | 16227 | Clarence Watson W000198 | sen | WV | 1911-04-04 | 1913-03-03 | 2 | Democrat | |||||||||||||
16377 | 16377 | Nathan Goff G000255 | sen | WV | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
17470 | 17470 | Howard Sutherland S001081 | sen | WV | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
17656 | 17656 | Davis Elkins E000109 | sen | WV | 1911-04-04 | 1911-12-31 | 2 | Republican | |||||||||||||
17657 | 17657 | Davis Elkins E000109 | sen | WV | 1919-05-19 | 1925-03-03 | 2 | Republican | |||||||||||||
18976 | 18976 | Guy Goff G000254 | sen | WV | 1925-12-07 | 1931-03-03 | 2 | Republican | |||||||||||||
19762 | 19762 | Henry Hatfield H000342 | sen | WV | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
21817 | 21817 | Rush Holt H000749 | sen | WV | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
23206 | 23206 | Joseph Rosier R000443 | sen | WV | 1941-01-13 | 1943-01-03 | 2 | Democrat | appointment | ||||||||||||
23340 | 23340 | Hugh Shott S000381 | sen | WV | 1942-01-01 | 1943-01-03 | 2 | Republican | |||||||||||||
25737 | 25737 | Harley Kilgore K000176 | sen | WV | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
25738 | 25738 | Harley Kilgore K000176 | sen | WV | 1947-01-03 | 1953-01-03 | 1 | Democrat | |||||||||||||
25739 | 25739 | Harley Kilgore K000176 | sen | WV | 1953-01-03 | 1957-01-03 | 1 | Democrat | |||||||||||||
26067 | 26067 | Matthew Neely N000023 | sen | WV | 1923-12-03 | 1929-03-03 | 1 | Democrat | |||||||||||||
26068 | 26068 | Matthew Neely N000023 | sen | WV | 1931-12-07 | 1937-01-03 | 2 | Democrat | |||||||||||||
26069 | 26069 | Matthew Neely N000023 | sen | WV | 1937-01-05 | 1941-12-31 | 2 | Democrat | |||||||||||||
26071 | 26071 | Matthew Neely N000023 | sen | WV | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
26072 | 26072 | Matthew Neely N000023 | sen | WV | 1955-01-05 | 1958-01-18 | 2 | Democrat | |||||||||||||
26152 | 26152 | William Laird L000025 | sen | WV | 1956-03-13 | 1957-01-03 | 1 | Democrat | appointment | ||||||||||||
26153 | 26153 | William Revercomb R000167 | sen | WV | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
26154 | 26154 | William Revercomb R000167 | sen | WV | 1956-01-01 | 1959-01-03 | 1 | Republican | |||||||||||||
26691 | 26691 | John Hoblitzell H000665 | sen | WV | 1958-01-25 | 1959-01-03 | 2 | Republican | appointment | ||||||||||||
32248 | 32248 | Jennings Randolph R000046 | sen | WV | 1958-11-05 | 1961-01-03 | 2 | Democrat | |||||||||||||
32249 | 32249 | Jennings Randolph R000046 | sen | WV | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
32250 | 32250 | Jennings Randolph R000046 | sen | WV | 1967-01-10 | 1973-01-03 | 2 | Democrat | |||||||||||||
32251 | 32251 | Jennings Randolph R000046 | sen | WV | 1973-01-03 | 1979-01-03 | 2 | Democrat |
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);