legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
134 rows where party = "Democrat" and state = "RI"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, class, address, fax, contact_form, state_rank, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
6561 | 6561 | Thomas Davis D000135 | rep | RI | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6931 | 6931 | Benjamin Thurston T000255 | rep | RI | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
6932 | 6932 | Benjamin Thurston T000255 | rep | RI | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
6933 | 6933 | Benjamin Thurston T000255 | rep | RI | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
12663 | 12663 | Oscar Lapham L000093 | rep | RI | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12664 | 12664 | Oscar Lapham L000093 | rep | RI | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12746 | 12746 | Charles Page P000015 | rep | RI | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
12747 | 12747 | Charles Page P000015 | rep | RI | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12748 | 12748 | Charles Page P000015 | rep | RI | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
15126 | 15126 | Daniel Granger G000375 | rep | RI | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
15127 | 15127 | Daniel Granger G000375 | rep | RI | 1905-12-04 | 1907-03-03 | Democrat | 1 | |||||||||||||
15128 | 15128 | Daniel Granger G000375 | rep | RI | 1907-12-02 | 1909-03-03 | Democrat | 1 | |||||||||||||
17366 | 17366 | George O’Shaunessy O000117 | rep | RI | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
17367 | 17367 | George O’Shaunessy O000117 | rep | RI | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
17368 | 17368 | George O’Shaunessy O000117 | rep | RI | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17369 | 17369 | George O’Shaunessy O000117 | rep | RI | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
19909 | 19909 | Jeremiah O’Connell O000023 | rep | RI | 1923-12-03 | 1925-03-03 | Democrat | 3 | |||||||||||||
19910 | 19910 | Jeremiah O’Connell O000023 | rep | RI | 1925-12-07 | 1927-03-04 | Democrat | 3 | |||||||||||||
19911 | 19911 | Jeremiah O’Connell O000023 | rep | RI | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
21706 | 21706 | Francis Condon C000673 | rep | RI | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
21707 | 21707 | Francis Condon C000673 | rep | RI | 1931-12-07 | 1933-03-03 | Democrat | 3 | |||||||||||||
21708 | 21708 | Francis Condon C000673 | rep | RI | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
21709 | 21709 | Francis Condon C000673 | rep | RI | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22341 | 22341 | John O’Connell O000025 | rep | RI | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
22342 | 22342 | John O’Connell O000025 | rep | RI | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22343 | 22343 | John O’Connell O000025 | rep | RI | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
23010 | 23010 | Peter Gerry G000141 | rep | RI | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
26849 | 26849 | Aime Forand F000255 | rep | RI | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
26850 | 26850 | Aime Forand F000255 | rep | RI | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
26851 | 26851 | Aime Forand F000255 | rep | RI | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
26852 | 26852 | Aime Forand F000255 | rep | RI | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
26853 | 26853 | Aime Forand F000255 | rep | RI | 1947-01-03 | 1949-01-03 | Democrat | 1 | |||||||||||||
26854 | 26854 | Aime Forand F000255 | rep | RI | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
26855 | 26855 | Aime Forand F000255 | rep | RI | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
26856 | 26856 | Aime Forand F000255 | rep | RI | 1953-01-03 | 1955-01-03 | Democrat | 1 | |||||||||||||
26857 | 26857 | Aime Forand F000255 | rep | RI | 1955-01-05 | 1957-01-03 | Democrat | 1 | |||||||||||||
26858 | 26858 | Aime Forand F000255 | rep | RI | 1957-01-03 | 1959-01-03 | Democrat | 1 | |||||||||||||
26859 | 26859 | Aime Forand F000255 | rep | RI | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
28830 | 28830 | John Fogarty F000233 | rep | RI | 1941-01-03 | 1943-01-03 | Democrat | 2 | |||||||||||||
28831 | 28831 | John Fogarty F000233 | rep | RI | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
28832 | 28832 | John Fogarty F000233 | rep | RI | 1945-01-03 | 1947-01-03 | Democrat | 2 | |||||||||||||
28833 | 28833 | John Fogarty F000233 | rep | RI | 1947-01-03 | 1949-01-03 | Democrat | 2 | |||||||||||||
28834 | 28834 | John Fogarty F000233 | rep | RI | 1949-01-03 | 1951-01-03 | Democrat | 2 | |||||||||||||
28835 | 28835 | John Fogarty F000233 | rep | RI | 1951-01-03 | 1953-01-03 | Democrat | 2 | |||||||||||||
28836 | 28836 | John Fogarty F000233 | rep | RI | 1953-01-03 | 1955-01-03 | Democrat | 2 | |||||||||||||
28837 | 28837 | John Fogarty F000233 | rep | RI | 1955-01-05 | 1957-01-03 | Democrat | 2 | |||||||||||||
28838 | 28838 | John Fogarty F000233 | rep | RI | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
28839 | 28839 | John Fogarty F000233 | rep | RI | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
28840 | 28840 | John Fogarty F000233 | rep | RI | 1961-01-03 | 1963-01-03 | Democrat | 2 | |||||||||||||
28841 | 28841 | John Fogarty F000233 | rep | RI | 1963-01-09 | 1965-01-03 | Democrat | 2 | |||||||||||||
28842 | 28842 | John Fogarty F000233 | rep | RI | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
28843 | 28843 | John Fogarty F000233 | rep | RI | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
30733 | 30733 | Robert Tiernan T000265 | rep | RI | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
30734 | 30734 | Robert Tiernan T000265 | rep | RI | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
30735 | 30735 | Robert Tiernan T000265 | rep | RI | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
30736 | 30736 | Robert Tiernan T000265 | rep | RI | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
31953 | 31953 | Edward Beard B000279 | rep | RI | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
31954 | 31954 | Edward Beard B000279 | rep | RI | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
31955 | 31955 | Edward Beard B000279 | rep | RI | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
33748 | 33748 | Fernand St. Germain S000762 | rep | RI | 1961-01-03 | 1963-01-03 | Democrat | 1 | |||||||||||||
33749 | 33749 | Fernand St. Germain S000762 | rep | RI | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
33750 | 33750 | Fernand St. Germain S000762 | rep | RI | 1965-01-04 | 1967-01-03 | Democrat | 1 | |||||||||||||
33751 | 33751 | Fernand St. Germain S000762 | rep | RI | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
33752 | 33752 | Fernand St. Germain S000762 | rep | RI | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
33753 | 33753 | Fernand St. Germain S000762 | rep | RI | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
33754 | 33754 | Fernand St. Germain S000762 | rep | RI | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
33755 | 33755 | Fernand St. Germain S000762 | rep | RI | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
33756 | 33756 | Fernand St. Germain S000762 | rep | RI | 1977-01-04 | 1979-01-03 | Democrat | 1 | |||||||||||||
33757 | 33757 | Fernand St. Germain S000762 | rep | RI | 1979-01-15 | 1981-01-03 | Democrat | 1 | |||||||||||||
33758 | 33758 | Fernand St. Germain S000762 | rep | RI | 1981-01-05 | 1983-01-03 | Democrat | 1 | |||||||||||||
33759 | 33759 | Fernand St. Germain S000762 | rep | RI | 1983-01-03 | 1985-01-03 | Democrat | 1 | |||||||||||||
33760 | 33760 | Fernand St. Germain S000762 | rep | RI | 1985-01-03 | 1987-01-03 | Democrat | 1 | |||||||||||||
33761 | 33761 | Fernand St. Germain S000762 | rep | RI | 1987-01-06 | 1989-01-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
36767 | 36767 | Robert Weygand W000315 | rep | RI | 1997-01-07 | 1999-01-03 | Democrat | 2 | |||||||||||||
36768 | 36768 | Robert Weygand W000315 | rep | RI | 1999-01-06 | 2001-01-03 | Democrat | 2 | |||||||||||||
38615 | 38615 | Patrick Kennedy K000113 | rep | RI | 1995-01-04 | 1997-01-03 | Democrat | 1 | |||||||||||||
38616 | 38616 | Patrick Kennedy K000113 | rep | RI | 1997-01-07 | 1999-01-03 | Democrat | 1 |
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);