legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
98 rows where state = "RI" and type = "sen"
This data as json, copyable, CSV (advanced)
Suggested facets: class, url, address, fax, contact_form, office, state_rank, rss_url, start (date), end (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
79 | 79 | William Bradford B000739 | sen | RI | 1793-12-02 | 1797-12-31 | 2 | Federalist | |||||||||||||
261 | 261 | Theodore Foster F000313 | sen | RI | 1790-06-12 | 1791-03-03 | 1 | Federalist | |||||||||||||
262 | 262 | Theodore Foster F000313 | sen | RI | 1791-03-04 | 1797-03-03 | 1 | Federalist | |||||||||||||
263 | 263 | Theodore Foster F000313 | sen | RI | 1797-05-15 | 1803-03-03 | 1 | Republican | |||||||||||||
374 | 374 | Ray Greene G000427 | sen | RI | 1797-05-15 | 1799-03-03 | 2 | Federalist | |||||||||||||
375 | 375 | Ray Greene G000427 | sen | RI | 1799-12-02 | 1801-12-31 | 2 | Federalist | |||||||||||||
468 | 468 | Christopher Ellery E000114 | sen | RI | 1801-12-07 | 1805-03-03 | 2 | Republican | |||||||||||||
608 | 608 | Samuel Potter P000468 | sen | RI | 1803-10-17 | 1805-03-03 | 1 | Republican | |||||||||||||
644 | 644 | Benjamin Howland H000870 | sen | RI | 1804-01-01 | 1809-03-03 | 1 | Republican | |||||||||||||
691 | 691 | James Fenner F000074 | sen | RI | 1805-12-02 | 1807-12-31 | 2 | Republican | |||||||||||||
754 | 754 | Joseph Stanton S000805 | sen | RI | 1790-01-01 | 1793-03-03 | 2 | Anti-Administration | |||||||||||||
870 | 870 | Elisha Mathewson M000240 | sen | RI | 1807-10-26 | 1811-03-03 | 2 | Republican | |||||||||||||
963 | 963 | Christopher Champlin C000289 | sen | RI | 1809-05-22 | 1811-12-31 | 1 | Federalist | |||||||||||||
1030 | 1030 | Francis Malbone M000076 | sen | RI | 1809-05-22 | 1809-12-31 | 1 | Federalist | |||||||||||||
1182 | 1182 | Jeremiah Howell H000865 | sen | RI | 1811-11-04 | 1817-03-03 | 2 | Republican | |||||||||||||
1616 | 1616 | William Hunter H000991 | sen | RI | 1811-11-04 | 1815-03-03 | 1 | Federalist | |||||||||||||
1617 | 1617 | William Hunter H000991 | sen | RI | 1815-12-04 | 1821-03-03 | 1 | Federalist | |||||||||||||
1808 | 1808 | James Burrill B001137 | sen | RI | 1817-12-01 | 1821-03-03 | 2 | Federalist | |||||||||||||
2229 | 2229 | James De Wolf D000295 | sen | RI | 1821-12-03 | 1825-12-31 | 1 | Republican | |||||||||||||
3788 | 3788 | Asher Robbins R000297 | sen | RI | 1825-12-05 | 1827-03-03 | 1 | Adams | |||||||||||||
3789 | 3789 | Asher Robbins R000297 | sen | RI | 1827-12-03 | 1833-03-03 | 1 | Adams | |||||||||||||
3790 | 3790 | Asher Robbins R000297 | sen | RI | 1833-12-02 | 1839-03-03 | 1 | Whig | |||||||||||||
3977 | 3977 | Nehemiah Knight K000287 | sen | RI | 1821-12-03 | 1823-03-03 | 2 | Republican | |||||||||||||
3978 | 3978 | Nehemiah Knight K000287 | sen | RI | 1823-12-01 | 1829-03-03 | 2 | Adams | |||||||||||||
3979 | 3979 | Nehemiah Knight K000287 | sen | RI | 1829-12-07 | 1835-03-03 | 2 | Whig | |||||||||||||
3980 | 3980 | Nehemiah Knight K000287 | sen | RI | 1835-12-07 | 1841-03-03 | 2 | Whig | |||||||||||||
4461 | 4461 | Nathan Dixon D000376 | sen | RI | 1839-12-02 | 1843-03-03 | 1 | Whig | |||||||||||||
5110 | 5110 | William Sprague S000746 | sen | RI | 1842-01-01 | 1845-03-03 | 1 | Whig | |||||||||||||
5341 | 5341 | John Francis F000336 | sen | RI | 1844-01-01 | 1845-03-03 | 1 | Law and Order | |||||||||||||
5434 | 5434 | Albert Greene G000424 | sen | RI | 1845-12-01 | 1851-03-03 | 1 | Whig | |||||||||||||
5650 | 5650 | John Clarke C000466 | sen | RI | 1847-12-06 | 1853-03-03 | 2 | Whig | |||||||||||||
6342 | 6342 | Charles James J000046 | sen | RI | 1851-12-01 | 1857-03-03 | 1 | Democrat | |||||||||||||
6488 | 6488 | Philip Allen A000141 | sen | RI | 1853-12-05 | 1859-03-03 | 2 | Democrat | |||||||||||||
7223 | 7223 | James Simmons S000417 | sen | RI | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
7224 | 7224 | James Simmons S000417 | sen | RI | 1857-12-07 | 1863-03-03 | 1 | Republican | |||||||||||||
7894 | 7894 | Samuel Arnold A000295 | sen | RI | 1862-01-01 | 1863-03-03 | 1 | Republican | |||||||||||||
8724 | 8724 | William Sprague S000747 | sen | RI | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
8725 | 8725 | William Sprague S000747 | sen | RI | 1869-03-04 | 1875-03-03 | 1 | Liberal Republican | |||||||||||||
9473 | 9473 | Ambrose Burnside B001130 | sen | RI | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
10624 | 10624 | Henry Anthony A000262 | sen | RI | 1859-12-05 | 1865-03-03 | 2 | Republican | |||||||||||||
10625 | 10625 | Henry Anthony A000262 | sen | RI | 1865-12-04 | 1871-03-03 | 2 | Republican | |||||||||||||
10626 | 10626 | Henry Anthony A000262 | sen | RI | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
10627 | 10627 | Henry Anthony A000262 | sen | RI | 1877-10-15 | 1883-03-03 | 2 | Republican | |||||||||||||
10628 | 10628 | Henry Anthony A000262 | sen | RI | 1883-12-03 | 1885-03-03 | 2 | Republican | |||||||||||||
10950 | 10950 | William Sheffield S000319 | sen | RI | 1884-01-01 | 1885-12-31 | 2 | Republican | |||||||||||||
11002 | 11002 | Jonathan Chace C000267 | sen | RI | 1885-12-07 | 1889-03-03 | 2 | Republican | |||||||||||||
11734 | 11734 | Nathan Dixon D000377 | sen | RI | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
14557 | 14557 | Nelson Aldrich A000083 | sen | RI | 1881-10-05 | 1887-03-03 | 1 | Republican | |||||||||||||
14558 | 14558 | Nelson Aldrich A000083 | sen | RI | 1887-12-05 | 1893-03-03 | 1 | Republican | |||||||||||||
14559 | 14559 | Nelson Aldrich A000083 | sen | RI | 1893-08-07 | 1899-03-03 | 1 | Republican | |||||||||||||
14560 | 14560 | Nelson Aldrich A000083 | sen | RI | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14561 | 14561 | Nelson Aldrich A000083 | sen | RI | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
15320 | 15320 | George Wetmore W000312 | sen | RI | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
15321 | 15321 | George Wetmore W000312 | sen | RI | 1901-12-02 | 1907-03-03 | 2 | Republican | |||||||||||||
15322 | 15322 | George Wetmore W000312 | sen | RI | 1908-01-01 | 1913-03-03 | 2 | Republican | |||||||||||||
16054 | 16054 | Henry Lippitt L000343 | sen | RI | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
17628 | 17628 | LeBaron Colt C000651 | sen | RI | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
17629 | 17629 | LeBaron Colt C000651 | sen | RI | 1919-05-19 | 1924-08-18 | 2 | Republican | |||||||||||||
19763 | 19763 | Felix Hebert H000436 | sen | RI | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
20710 | 20710 | Jesse Metcalf M000670 | sen | RI | 1924-11-05 | 1925-03-03 | 2 | Republican | |||||||||||||
20711 | 20711 | Jesse Metcalf M000670 | sen | RI | 1925-12-07 | 1931-03-03 | 2 | Republican | |||||||||||||
20712 | 20712 | Jesse Metcalf M000670 | sen | RI | 1931-12-07 | 1937-01-03 | 2 | Republican | |||||||||||||
23011 | 23011 | Peter Gerry G000141 | sen | RI | 1917-04-02 | 1923-03-03 | 1 | Democrat | |||||||||||||
23012 | 23012 | Peter Gerry G000141 | sen | RI | 1923-12-03 | 1929-03-03 | 1 | Democrat | |||||||||||||
23013 | 23013 | Peter Gerry G000141 | sen | RI | 1935-01-03 | 1941-01-03 | 1 | Democrat | |||||||||||||
23014 | 23014 | Peter Gerry G000141 | sen | RI | 1941-01-03 | 1947-01-03 | 1 | Democrat | |||||||||||||
24603 | 24603 | James McGrath M000456 | sen | RI | 1947-01-03 | 1949-08-23 | 1 | Democrat | |||||||||||||
24880 | 24880 | Edward Leahy L000173 | sen | RI | 1949-08-24 | 1950-12-18 | 1 | Democrat | appointment | ||||||||||||
25983 | 25983 | Theodore Green G000418 | sen | RI | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
25984 | 25984 | Theodore Green G000418 | sen | RI | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
25985 | 25985 | Theodore Green G000418 | sen | RI | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
25986 | 25986 | Theodore Green G000418 | sen | RI | 1955-01-05 | 1961-01-03 | 2 | Democrat | |||||||||||||
30005 | 30005 | John Pastore P000100 | sen | RI | 1950-12-19 | 1953-01-03 | 1 | Democrat | |||||||||||||
30006 | 30006 | John Pastore P000100 | sen | RI | 1953-01-03 | 1959-01-03 | 1 | Democrat | |||||||||||||
30007 | 30007 | John Pastore P000100 | sen | RI | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
30008 | 30008 | John Pastore P000100 | sen | RI | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
30009 | 30009 | John Pastore P000100 | sen | RI | 1971-01-21 | 1976-12-28 | 1 | Democrat | |||||||||||||
34830 | 34830 | Claiborne Pell P000193 | sen | RI | 1961-01-03 | 1967-01-03 | 2 | Democrat | |||||||||||||
34831 | 34831 | Claiborne Pell P000193 | sen | RI | 1967-01-10 | 1973-01-03 | 2 | Democrat | |||||||||||||
34832 | 34832 | Claiborne Pell P000193 | sen | RI | 1973-01-03 | 1979-01-03 | 2 | Democrat | |||||||||||||
34833 | 34833 | Claiborne Pell P000193 | sen | RI | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
34834 | 34834 | Claiborne Pell P000193 | sen | RI | 1985-01-03 | 1991-01-03 | 2 | Democrat | |||||||||||||
34835 | 34835 | Claiborne Pell P000193 | sen | RI | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
35727 | 35727 | John Chafee C000269 | sen | RI | 1976-12-29 | 1977-01-03 | 1 | Republican | |||||||||||||
35728 | 35728 | John Chafee C000269 | sen | RI | 1977-01-04 | 1983-01-03 | 1 | Republican | |||||||||||||
35729 | 35729 | John Chafee C000269 | sen | RI | 1983-01-03 | 1989-01-03 | 1 | Republican | |||||||||||||
35730 | 35730 | John Chafee C000269 | sen | RI | 1989-01-03 | 1995-01-03 | 1 | Republican | |||||||||||||
35731 | 35731 | John Chafee C000269 | sen | RI | 1995-01-04 | 1999-10-24 | 1 | Republican | |||||||||||||
36855 | 36855 | Lincoln Chafee C001040 | sen | RI | 1999-11-02 | 2001-01-03 | 1 | Republican | appointment | ||||||||||||
36856 | 36856 | Lincoln Chafee C001040 | sen | RI | 2001-01-03 | 2007-01-03 | 1 | Republican | http://chafee.senate.gov | ||||||||||||
41810 | 41810 | Sheldon Whitehouse W000802 | sen | RI | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://whitehouse.senate.gov/ | 717 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-2921 | 202-228-6362 | http://www.whitehouse.senate.gov/contact/ | 717 Hart Senate Office Building | |||||||
41811 | 41811 | Sheldon Whitehouse W000802 | sen | RI | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.whitehouse.senate.gov | 530 Hart Senate Office Building Washington DC 20510 | 202-224-2921 | 202-228-6362 | https://www.whitehouse.senate.gov/contact/email-sheldon | 530 Hart Senate Office Building | junior | http://www.whitehouse.senate.gov/rss/feeds/?type=all&cachebuster=1 | |||||
41812 | 41812 | Sheldon Whitehouse W000802 | sen | RI | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.whitehouse.senate.gov | 530 Hart Senate Office Building Washington DC 20510 | 202-224-2921 | https://www.whitehouse.senate.gov/contact/email-sheldon | 530 Hart Senate Office Building | junior | http://www.whitehouse.senate.gov/rss/feeds/?type=all&cachebuster=1 | ||||||
41879 | 41879 | John Reed R000122 | sen | RI | 1997-01-07 | 2003-01-03 | 2 | Democrat | |||||||||||||
41880 | 41880 | John Reed R000122 | sen | RI | 2003-01-07 | 2009-01-03 | 2 | Democrat | http://reed.senate.gov/ | ||||||||||||
41881 | 41881 | John Reed R000122 | sen | RI | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.reed.senate.gov | 728 Hart Senate Office Building Washington DC 20510 | 202-224-4642 | 202-224-4680 | http://www.reed.senate.gov/contact/ | 728 Hart Senate Office Building | senior | https://www.reed.senate.gov//rss/feeds/?type=all | |||||
41882 | 41882 | John Reed R000122 | sen | RI | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.reed.senate.gov | 728 Hart Senate Office Building Washington DC 20510 | 202-224-4642 | 202-224-4680 | https://www.reed.senate.gov/contact/ | 728 Hart Senate Office Building | senior | https://www.reed.senate.gov//rss/feeds/?type=all | |||||
41883 | 41883 | John Reed R000122 | sen | RI | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.reed.senate.gov | 728 Hart Senate Office Building Washington DC 20510 | 202-224-4642 | https://www.reed.senate.gov/contact/ | 728 Hart Senate Office Building | senior | https://www.reed.senate.gov//rss/feeds/?type=all |
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);