legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
116 rows where party = "Democrat" and state = "ME"
This data as json, copyable, CSV (advanced)
Suggested facets: type, class, district, url, address, fax, contact_form, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4051 | 4051 | John Ruggles R000502 | sen | ME | 1835-12-07 | 1841-03-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
4638 | 4638 | Reuel Williams W000532 | sen | ME | 1837-09-04 | 1839-03-03 | 1 | Democrat | |||||||||||||
4639 | 4639 | Reuel Williams W000532 | sen | ME | 1839-12-02 | 1843-12-31 | 1 | Democrat | |||||||||||||
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 | |||||||||||||
5422 | 5422 | John Fairfield F000006 | sen | ME | 1843-12-04 | 1845-03-03 | 1 | Democrat | |||||||||||||
5423 | 5423 | John Fairfield F000006 | sen | ME | 1845-12-01 | 1847-12-31 | 1 | Democrat | |||||||||||||
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 | |||||||||||||
5627 | 5627 | James Bradbury B000734 | sen | ME | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
5886 | 5886 | Wyman Moor M000889 | sen | ME | 1848-01-01 | 1849-03-03 | 1 | Democrat | |||||||||||||
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 | |||||||||||||
9516 | 9516 | Hannibal Hamlin H000121 | sen | ME | 1848-01-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
9517 | 9517 | Hannibal Hamlin H000121 | sen | ME | 1851-12-01 | 1857-03-03 | 1 | Democrat | |||||||||||||
15982 | 15982 | Obadiah Gardner G000060 | sen | ME | 1911-04-04 | 1913-03-03 | 2 | Democrat | |||||||||||||
15988 | 15988 | Samuel Gould G000343 | rep | ME | 1911-04-04 | 1913-03-03 | Democrat | 3 | |||||||||||||
16018 | 16018 | Charles Johnson J000124 | sen | ME | 1911-04-04 | 1917-03-03 | 1 | Democrat | |||||||||||||
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 | |||||||||||||
30477 | 30477 | William Hathaway H000346 | sen | ME | 1973-01-03 | 1979-01-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
31688 | 31688 | Edmund Muskie M001121 | sen | ME | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
31689 | 31689 | Edmund Muskie M001121 | sen | ME | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
31690 | 31690 | Edmund Muskie M001121 | sen | ME | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
31691 | 31691 | Edmund Muskie M001121 | sen | ME | 1977-01-04 | 1981-01-03 | 1 | Democrat | |||||||||||||
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 | |||||||||||||
34018 | 34018 | George Mitchell M000811 | sen | ME | 1980-05-17 | 1983-01-03 | 1 | Democrat | appointment | ||||||||||||
34019 | 34019 | George Mitchell M000811 | sen | ME | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
34020 | 34020 | George Mitchell M000811 | sen | ME | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
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 |
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);