legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
104 rows where district = 2 and state = "ME"
This data as json, copyable, CSV (advanced)
Suggested facets: party, address, office, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2243 | 2243 | Mark Harris H000248 | rep | ME | 1821-12-03 | 1823-03-03 | Republican | 2 | |||||||||||||
2349 | 2349 | Ezekiel Whitman W000421 | rep | ME | 1821-12-03 | 1823-03-03 | Federalist | 2 | |||||||||||||
2443 | 2443 | Stephen Longfellow L000430 | rep | ME | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
3297 | 3297 | John Anderson A000193 | rep | ME | 1825-12-05 | 1827-03-03 | Jackson | 2 | |||||||||||||
3298 | 3298 | John Anderson A000193 | rep | ME | 1827-12-03 | 1829-03-03 | Jackson | 2 | |||||||||||||
3299 | 3299 | John Anderson A000193 | rep | ME | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3300 | 3300 | John Anderson A000193 | rep | ME | 1831-12-05 | 1833-03-03 | Jackson | 2 | |||||||||||||
4347 | 4347 | Francis Smith S000531 | rep | ME | 1833-12-02 | 1835-03-03 | Jackson | 2 | |||||||||||||
4348 | 4348 | Francis Smith S000531 | rep | ME | 1835-12-07 | 1837-03-03 | Jackson | 2 | |||||||||||||
4349 | 4349 | Francis Smith S000531 | rep | ME | 1837-09-04 | 1839-03-03 | Democrat | 2 | |||||||||||||
4610 | 4610 | Albert Smith S000513 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
5413 | 5413 | Robert Dunlap D000543 | rep | ME | 1843-12-04 | 1845-03-03 | Democrat | 2 | |||||||||||||
5414 | 5414 | Robert Dunlap D000543 | rep | ME | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5647 | 5647 | Asa Clapp C000413 | rep | ME | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
6047 | 6047 | Nathaniel Littlefield L000356 | rep | ME | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
6211 | 6211 | John Appleton A000268 | rep | ME | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
6648 | 6648 | Samuel Mayall M000278 | rep | ME | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
7060 | 7060 | Charles Gilman G000213 | rep | ME | 1857-12-07 | 1859-03-03 | Republican | 2 | |||||||||||||
7536 | 7536 | John Perry P000243 | rep | ME | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 2 | |||||||||||||
7537 | 7537 | John Perry P000243 | rep | ME | 1859-12-05 | 1861-03-03 | Republican | 2 | |||||||||||||
7749 | 7749 | Thomas Fessenden F000098 | rep | ME | 1861-07-04 | 1863-03-03 | Republican | 2 | |||||||||||||
7874 | 7874 | Charles Walton W000112 | rep | ME | 1861-07-04 | 1863-03-03 | Republican | 2 | |||||||||||||
8114 | 8114 | William Fessenden F000099 | rep | ME | 1841-05-31 | 1843-03-03 | Whig | 2 | |||||||||||||
8414 | 8414 | Sidney Perham P000226 | rep | ME | 1863-12-07 | 1865-03-03 | Republican | 2 | |||||||||||||
8415 | 8415 | Sidney Perham P000226 | rep | ME | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8416 | 8416 | Sidney Perham P000226 | rep | ME | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8677 | 8677 | Samuel Morrill M000971 | rep | ME | 1869-03-04 | 1871-03-03 | Republican | 2 | |||||||||||||
13642 | 13642 | Nelson Dingley D000356 | rep | ME | 1881-12-05 | 1883-03-03 | Republican | 2 | |||||||||||||
13644 | 13644 | Nelson Dingley D000356 | rep | ME | 1885-12-07 | 1887-03-03 | Republican | 2 | |||||||||||||
13645 | 13645 | Nelson Dingley D000356 | rep | ME | 1887-12-05 | 1889-03-03 | Republican | 2 | |||||||||||||
13646 | 13646 | Nelson Dingley D000356 | rep | ME | 1889-12-02 | 1891-03-03 | Republican | 2 | |||||||||||||
13647 | 13647 | Nelson Dingley D000356 | rep | ME | 1891-12-07 | 1893-03-03 | Republican | 2 | |||||||||||||
13648 | 13648 | Nelson Dingley D000356 | rep | ME | 1893-08-07 | 1895-03-03 | Republican | 2 | |||||||||||||
13649 | 13649 | Nelson Dingley D000356 | rep | ME | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
13650 | 13650 | Nelson Dingley D000356 | rep | ME | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
15102 | 15102 | William Frye F000398 | rep | ME | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
15103 | 15103 | William Frye F000398 | rep | ME | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
15104 | 15104 | William Frye F000398 | rep | ME | 1875-12-06 | 1877-03-03 | Republican | 2 | |||||||||||||
15105 | 15105 | William Frye F000398 | rep | ME | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
15106 | 15106 | William Frye F000398 | rep | ME | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
15204 | 15204 | Charles Littlefield L000355 | rep | ME | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
15205 | 15205 | Charles Littlefield L000355 | rep | ME | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
15206 | 15206 | Charles Littlefield L000355 | rep | ME | 1903-11-09 | 1905-03-03 | Republican | 2 | |||||||||||||
15207 | 15207 | Charles Littlefield L000355 | rep | ME | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
15208 | 15208 | Charles Littlefield L000355 | rep | ME | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
15768 | 15768 | John Swasey S001098 | rep | ME | 1907-12-02 | 1909-03-03 | Republican | 2 | |||||||||||||
15769 | 15769 | John Swasey S001098 | rep | ME | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
16881 | 16881 | Daniel McGillicuddy M000448 | rep | ME | 1911-04-04 | 1913-03-03 | Democrat | 2 | |||||||||||||
16882 | 16882 | Daniel McGillicuddy M000448 | rep | ME | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16883 | 16883 | Daniel McGillicuddy M000448 | rep | ME | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
20768 | 20768 | Donald Partridge P000090 | rep | ME | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
21897 | 21897 | Edward Moran M000932 | rep | ME | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
21898 | 21898 | Edward Moran M000932 | rep | ME | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22783 | 22783 | Clyde Smith S000523 | rep | ME | 1937-01-05 | 1939-01-03 | Republican | 2 | |||||||||||||
22784 | 22784 | Clyde Smith S000523 | rep | ME | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
23747 | 23747 | Wallace White W000396 | rep | ME | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
23748 | 23748 | Wallace White W000396 | rep | ME | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
23749 | 23749 | Wallace White W000396 | rep | ME | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
23750 | 23750 | Wallace White W000396 | rep | ME | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
23751 | 23751 | Wallace White W000396 | rep | ME | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
23752 | 23752 | Wallace White W000396 | rep | ME | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
23753 | 23753 | Wallace White W000396 | rep | ME | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
26073 | 26073 | Charles Nelson N000031 | rep | ME | 1949-01-03 | 1951-01-03 | Republican | 2 | |||||||||||||
26074 | 26074 | Charles Nelson N000031 | rep | ME | 1951-01-03 | 1953-01-03 | Republican | 2 | |||||||||||||
26075 | 26075 | Charles Nelson N000031 | rep | ME | 1953-01-03 | 1955-01-03 | Republican | 2 | |||||||||||||
26076 | 26076 | Charles Nelson N000031 | rep | ME | 1955-01-05 | 1957-01-03 | Republican | 2 | |||||||||||||
26811 | 26811 | Frank Coffin C000589 | rep | ME | 1957-01-03 | 1959-01-03 | Democrat | 2 | |||||||||||||
26812 | 26812 | Frank Coffin C000589 | rep | ME | 1959-01-07 | 1961-01-03 | Democrat | 2 | |||||||||||||
28004 | 28004 | Clifford McIntire M000478 | rep | ME | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
28727 | 28727 | Stanley Tupper T000411 | rep | ME | 1961-01-03 | 1963-01-03 | Republican | 2 | |||||||||||||
29040 | 29040 | Margaret Smith S000590 | rep | ME | 1939-01-03 | 1941-01-03 | Republican | 2 | |||||||||||||
29041 | 29041 | Margaret Smith S000590 | rep | ME | 1941-01-03 | 1943-01-03 | Republican | 2 | |||||||||||||
29042 | 29042 | Margaret Smith S000590 | rep | ME | 1943-01-06 | 1945-01-03 | Republican | 2 | |||||||||||||
29043 | 29043 | Margaret Smith S000590 | rep | ME | 1945-01-03 | 1947-01-03 | Republican | 2 | |||||||||||||
29044 | 29044 | Margaret Smith S000590 | rep | ME | 1947-01-03 | 1949-01-03 | Republican | 2 | |||||||||||||
30473 | 30473 | William Hathaway H000346 | rep | ME | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
30474 | 30474 | William Hathaway H000346 | rep | ME | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
30475 | 30475 | William Hathaway H000346 | rep | ME | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
30476 | 30476 | William Hathaway H000346 | rep | ME | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
34309 | 34309 | William Cohen C000598 | rep | ME | 1973-01-03 | 1975-01-03 | Republican | 2 | |||||||||||||
34310 | 34310 | William Cohen C000598 | rep | ME | 1975-01-14 | 1977-01-03 | Republican | 2 | |||||||||||||
34311 | 34311 | William Cohen C000598 | rep | ME | 1977-01-04 | 1979-01-03 | Republican | 2 | |||||||||||||
36790 | 36790 | John Baldacci B000081 | rep | ME | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
36791 | 36791 | John Baldacci B000081 | rep | ME | 1997-01-07 | 1999-01-03 | Democrat | 2 | |||||||||||||
36792 | 36792 | John Baldacci B000081 | rep | ME | 1999-01-06 | 2001-01-03 | Democrat | 2 | |||||||||||||
36793 | 36793 | John Baldacci B000081 | rep | ME | 2001-01-03 | 2003-01-03 | Democrat | 2 | |||||||||||||
39071 | 39071 | Olympia Snowe S000663 | rep | ME | 1979-01-15 | 1981-01-03 | Republican | 2 | |||||||||||||
39072 | 39072 | Olympia Snowe S000663 | rep | ME | 1981-01-05 | 1983-01-03 | Republican | 2 | |||||||||||||
39073 | 39073 | Olympia Snowe S000663 | rep | ME | 1983-01-03 | 1985-01-03 | Republican | 2 | |||||||||||||
39074 | 39074 | Olympia Snowe S000663 | rep | ME | 1985-01-03 | 1987-01-03 | Republican | 2 | |||||||||||||
39075 | 39075 | Olympia Snowe S000663 | rep | ME | 1987-01-06 | 1989-01-03 | Republican | 2 | |||||||||||||
39076 | 39076 | Olympia Snowe S000663 | rep | ME | 1989-01-03 | 1991-01-03 | Republican | 2 | |||||||||||||
39077 | 39077 | Olympia Snowe S000663 | rep | ME | 1991-01-03 | 1993-01-03 | Republican | 2 | |||||||||||||
39078 | 39078 | Olympia Snowe S000663 | rep | ME | 1993-01-05 | 1995-01-03 | Republican | 2 | |||||||||||||
39948 | 39948 | Michael Michaud M001149 | rep | ME | 2003-01-07 | 2005-01-03 | Democrat | 2 | http://www.house.gov/michaud | ||||||||||||
39949 | 39949 | Michael Michaud M001149 | rep | ME | 2005-01-04 | 2007-01-03 | Democrat | 2 | http://www.house.gov/michaud | ||||||||||||
39950 | 39950 | Michael Michaud M001149 | rep | ME | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://michaud.house.gov | ||||||||||||
39951 | 39951 | Michael Michaud M001149 | rep | ME | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://michaud.house.gov | ||||||||||||
39952 | 39952 | Michael Michaud M001149 | rep | ME | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://michaud.house.gov | 1724 Longworth HOB; Washington DC 20515-1902 | 202-225-6306 | 202-225-2943 | https://forms.house.gov/michaud/webforms/issue_subscribe.htm | 1724 Longworth House Office Building | |||||||
39953 | 39953 | Michael Michaud M001149 | rep | ME | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://michaud.house.gov | 1724 Longworth HOB; Washington DC 20515-1902 | 202-225-6306 | 202-225-2943 | http://michaud.house.gov/email | 1724 Longworth House Office Building | http://michaud.house.gov/rss.xml |
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);