legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
97 rows where party = "Democrat", state = "ME" and type = "rep"
This data as json, copyable, CSV (advanced)
Suggested facets: district, url, address, phone, fax, office, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4161 | 4161 | Timothy Carter C000202 | rep | ME | 1837-09-04 | 1839-03-03 | Democrat | 5 | |||||||||||||
4169 | 4169 | Jonathan Cilley C000395 | rep | ME | 1837-09-04 | 1839-03-03 | Democrat | 3 | |||||||||||||
4349 | 4349 | Francis Smith S000531 | rep | ME | 1837-09-04 | 1839-03-03 | Democrat | 2 | |||||||||||||
4395 | 4395 | Hugh Anderson A000190 | rep | ME | 1837-09-04 | 1839-03-03 | Democrat | 6 | |||||||||||||
4396 | 4396 | Hugh Anderson A000190 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
4450 | 4450 | Thomas Davee D000068 | rep | ME | 1837-09-04 | 1839-03-03 | Democrat | 8 | |||||||||||||
4451 | 4451 | Thomas Davee D000068 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 8 | |||||||||||||
4569 | 4569 | Virgil Parris P000081 | rep | ME | 1837-09-04 | 1839-03-03 | Democrat | 5 | |||||||||||||
4570 | 4570 | Virgil Parris P000081 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 5 | |||||||||||||
4610 | 4610 | Albert Smith S000513 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
4753 | 4753 | Nathan Clifford C000518 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4754 | 4754 | Nathan Clifford C000518 | rep | ME | 1841-05-31 | 1843-03-03 | Democrat | 1 | |||||||||||||
4864 | 4864 | Joshua Lowell L000476 | rep | ME | 1839-12-02 | 1841-03-03 | Democrat | 7 | |||||||||||||
4865 | 4865 | Joshua Lowell L000476 | rep | ME | 1841-05-31 | 1843-03-03 | Democrat | 7 | |||||||||||||
4871 | 4871 | Alfred Marshall M000150 | rep | ME | 1841-05-31 | 1843-03-03 | Democrat | 6 | |||||||||||||
5161 | 5161 | Shepard Cary C000217 | rep | ME | 1843-12-04 | 1845-03-03 | Democrat | 7 | |||||||||||||
5217 | 5217 | Joshua Herrick H000539 | rep | ME | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
5315 | 5315 | Benjamin White W000357 | rep | ME | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
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 | |||||||||||||
5421 | 5421 | John Fairfield F000006 | rep | ME | 1837-09-04 | 1839-03-03 | Democrat | 1 | |||||||||||||
5477 | 5477 | John McCrate M000380 | rep | ME | 1845-12-01 | 1847-03-03 | Democrat | 4 | |||||||||||||
5514 | 5514 | John Scamman S000104 | rep | ME | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5647 | 5647 | Asa Clapp C000413 | rep | ME | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
5648 | 5648 | Franklin Clark C000432 | rep | ME | 1847-12-06 | 1849-03-03 | Democrat | 4 | |||||||||||||
5712 | 5712 | David Hammons H000136 | rep | ME | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
5857 | 5857 | James Wiley W000467 | rep | ME | 1847-12-06 | 1849-03-03 | Democrat | 6 | |||||||||||||
5858 | 5858 | Hezekiah Williams W000504 | rep | ME | 1845-12-01 | 1847-03-03 | Democrat | 7 | |||||||||||||
5859 | 5859 | Hezekiah Williams W000504 | rep | ME | 1847-12-06 | 1849-03-03 | Democrat | 7 | |||||||||||||
5978 | 5978 | Elbridge Gerry G000138 | rep | ME | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6046 | 6046 | Nathaniel Littlefield L000356 | rep | ME | 1841-05-31 | 1843-03-03 | Democrat | 5 | |||||||||||||
6047 | 6047 | Nathaniel Littlefield L000356 | rep | ME | 1849-12-03 | 1851-03-03 | Democrat | 2 | |||||||||||||
6110 | 6110 | Cullen Sawtelle S000085 | rep | ME | 1845-12-01 | 1847-03-03 | Democrat | 5 | |||||||||||||
6111 | 6111 | Cullen Sawtelle S000085 | rep | ME | 1849-12-03 | 1851-03-03 | Democrat | 5 | |||||||||||||
6133 | 6133 | Charles Stetson S000873 | rep | ME | 1849-12-03 | 1851-03-03 | Democrat | 6 | |||||||||||||
6210 | 6210 | Charles Andrews A000243 | rep | ME | 1851-12-01 | 1853-03-03 | Democrat | 4 | |||||||||||||
6211 | 6211 | John Appleton A000268 | rep | ME | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
6417 | 6417 | Ephraim Smart S000503 | rep | ME | 1847-12-06 | 1849-03-03 | Democrat | 5 | |||||||||||||
6418 | 6418 | Ephraim Smart S000503 | rep | ME | 1851-12-01 | 1853-03-03 | Democrat | 5 | |||||||||||||
6644 | 6644 | Moses Macdonald M000004 | rep | ME | 1851-12-01 | 1853-03-03 | Democrat | 1 | |||||||||||||
6645 | 6645 | Moses Macdonald M000004 | rep | ME | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6648 | 6648 | Samuel Mayall M000278 | rep | ME | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6820 | 6820 | Thomas Fuller F000412 | rep | ME | 1849-12-03 | 1851-03-03 | Democrat | 7 | |||||||||||||
6821 | 6821 | Thomas Fuller F000412 | rep | ME | 1851-12-01 | 1853-03-03 | Democrat | 7 | |||||||||||||
6822 | 6822 | Thomas Fuller F000412 | rep | ME | 1853-12-05 | 1855-03-03 | Democrat | 6 | |||||||||||||
6823 | 6823 | Thomas Fuller F000412 | rep | ME | 1855-12-03 | 1857-03-03 | Democrat | 6 | |||||||||||||
8044 | 8044 | Lorenzo Sweat S001100 | rep | ME | 1863-12-07 | 1865-03-03 | Democrat | 1 | |||||||||||||
9514 | 9514 | Hannibal Hamlin H000121 | rep | ME | 1843-12-04 | 1845-03-03 | Democrat | 6 | |||||||||||||
9515 | 9515 | Hannibal Hamlin H000121 | rep | ME | 1845-12-01 | 1847-03-03 | Democrat | 6 | |||||||||||||
15988 | 15988 | Samuel Gould G000343 | rep | ME | 1911-04-04 | 1913-03-03 | Democrat | 3 | |||||||||||||
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 | |||||||||||||
21585 | 21585 | John Utterback U000037 | rep | ME | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
21801 | 21801 | Simon Hamlin H000122 | rep | ME | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
26926 | 26926 | James Oliver O000074 | rep | ME | 1959-01-07 | 1961-01-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
30527 | 30527 | Peter Kyros K000356 | rep | ME | 1967-01-10 | 1969-01-03 | Democrat | 1 | |||||||||||||
30528 | 30528 | Peter Kyros K000356 | rep | ME | 1969-01-03 | 1971-01-03 | Democrat | 1 | |||||||||||||
30529 | 30529 | Peter Kyros K000356 | rep | ME | 1971-01-21 | 1973-01-03 | Democrat | 1 | |||||||||||||
30530 | 30530 | Peter Kyros K000356 | rep | ME | 1973-01-03 | 1975-01-03 | Democrat | 1 | |||||||||||||
33835 | 33835 | Joseph Brennan B000798 | rep | ME | 1987-01-06 | 1989-01-03 | Democrat | 1 | |||||||||||||
33836 | 33836 | Joseph Brennan B000798 | rep | ME | 1989-01-03 | 1991-01-03 | Democrat | 1 | |||||||||||||
35097 | 35097 | Thomas Andrews A000211 | rep | ME | 1991-01-03 | 1993-01-03 | Democrat | 1 | |||||||||||||
35098 | 35098 | Thomas Andrews A000211 | rep | ME | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
37933 | 37933 | Thomas Allen A000357 | rep | ME | 1997-01-07 | 1999-01-03 | Democrat | 1 | |||||||||||||
37934 | 37934 | Thomas Allen A000357 | rep | ME | 1999-01-06 | 2001-01-03 | Democrat | 1 | |||||||||||||
37935 | 37935 | Thomas Allen A000357 | rep | ME | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
37936 | 37936 | Thomas Allen A000357 | rep | ME | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://tomallen.house.gov | ||||||||||||
37937 | 37937 | Thomas Allen A000357 | rep | ME | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://tomallen.house.gov | ||||||||||||
37938 | 37938 | Thomas Allen A000357 | rep | ME | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://tomallen.house.gov | ||||||||||||
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 | ||||||
43103 | 43103 | Chellie Pingree P000597 | rep | ME | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://pingree.house.gov | ||||||||||||
43104 | 43104 | Chellie Pingree P000597 | rep | ME | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://pingree.house.gov | 1318 Longworth HOB; Washington DC 20515-1901 | 202-225-6116 | 202-225-5590 | https://forms.house.gov/pingree/contact-form.shtml | 1318 Longworth House Office Building | |||||||
43105 | 43105 | Chellie Pingree P000597 | rep | ME | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://pingree.house.gov | 1318 Longworth HOB; Washington DC 20515-1901 | 202-225-6116 | 202-225-5590 | https://pingree.house.gov/email-me | 1318 Longworth House Office Building | http://pingree.house.gov/index.php?format=feed&type=rss | ||||||
43106 | 43106 | Chellie Pingree P000597 | rep | ME | 2015-01-06 | 2017-01-03 | Democrat | 1 | https://pingree.house.gov | 2162 Rayburn HOB; Washington DC 20515-1901 | 202-225-6116 | 202-225-5590 | https://pingree.house.gov/email-me | 2162 Rayburn House Office Building | http://pingree.house.gov/index.php?format=feed&type=rss | ||||||
43107 | 43107 | Chellie Pingree P000597 | rep | ME | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://pingree.house.gov | 2162 Rayburn House Office Building; Washington DC 20515-1901 | 202-225-6116 | 202-225-5590 | 2162 Rayburn House Office Building | http://pingree.house.gov/index.php?format=feed&type=rss | |||||||
43108 | 43108 | Chellie Pingree P000597 | rep | ME | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://pingree.house.gov | 2162 Rayburn House Office Building Washington DC 20515-1901 | 202-225-6116 | 2162 Rayburn House Office Building | http://pingree.house.gov/index.php?format=feed&type=rss | ||||||||
43109 | 43109 | Chellie Pingree P000597 | rep | ME | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://pingree.house.gov | 2162 Rayburn House Office Building Washington DC 20515-1901 | 202-225-6116 | 2162 Rayburn House Office Building | http://pingree.house.gov/index.php?format=feed&type=rss | ||||||||
44418 | 44418 | Jared Golden G000592 | rep | ME | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://golden.house.gov | 1223 Longworth House Office Building Washington DC 20515-1902 | 202-225-6306 | 1223 Longworth House Office Building | |||||||||
44419 | 44419 | Jared Golden G000592 | rep | ME | 2021-01-03 | 2023-01-03 | Democrat | 2 | https://golden.house.gov | 1222 Longworth House Office Building Washington DC 20515-1902 | 202-225-6306 | 1222 Longworth House Office Building |
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);