legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
510 rows where state = "ME"
This data as json, copyable, CSV (advanced)
party 7 ✖
- Republican 289
- Democrat 96
- Whig 13
- Ind. Republican-Democrat 5
- National Greenbacker 4
- Independent 2
- Jackson 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
5420 | 5420 | John Fairfield F000006 | rep | ME | 1835-12-07 | 1837-03-03 | Jackson | 1 | |||||||||||||
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 | |||||||||||||
5516 | 5516 | Luther Severance S000255 | rep | ME | 1843-12-04 | 1845-03-03 | Whig | 3 | |||||||||||||
5517 | 5517 | Luther Severance S000255 | rep | ME | 1845-12-01 | 1847-03-03 | Whig | 3 | |||||||||||||
5613 | 5613 | Hiram Belcher B000321 | rep | ME | 1847-12-06 | 1849-03-03 | Whig | 3 | |||||||||||||
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 | |||||||||||||
5980 | 5980 | Rufus Goodenow G000285 | rep | ME | 1849-12-03 | 1851-03-03 | Whig | 4 | |||||||||||||
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 | |||||||||||||
6086 | 6086 | John Otis O000128 | rep | ME | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
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 | |||||||||||||
6312 | 6312 | Robert Goodenow G000284 | rep | ME | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6392 | 6392 | Isaac Reed R000117 | rep | ME | 1851-12-01 | 1853-03-03 | Whig | 4 | |||||||||||||
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 | |||||||||||||
6591 | 6591 | Ephraim Farley F000018 | rep | ME | 1853-12-05 | 1855-03-03 | Whig | 3 | |||||||||||||
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 | |||||||||||||
6773 | 6773 | Samuel Benson B000390 | rep | ME | 1853-12-05 | 1855-03-03 | Whig | 4 | |||||||||||||
6774 | 6774 | Samuel Benson B000390 | rep | ME | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 4 | |||||||||||||
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 | |||||||||||||
6855 | 6855 | Ebenezer Knowlton K000294 | rep | ME | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 3 | |||||||||||||
6971 | 6971 | Nehemiah Abbott A000008 | rep | ME | 1857-12-07 | 1859-03-03 | Republican | 3 | |||||||||||||
7060 | 7060 | Charles Gilman G000213 | rep | ME | 1857-12-07 | 1859-03-03 | Republican | 2 | |||||||||||||
7172 | 7172 | Amos Nourse N000162 | sen | ME | 1857-12-07 | 1857-12-31 | 1 | Republican | |||||||||||||
7251 | 7251 | John Wood W000698 | rep | ME | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 1 | |||||||||||||
7252 | 7252 | John Wood W000698 | rep | ME | 1857-12-07 | 1859-03-03 | Republican | 1 | |||||||||||||
7354 | 7354 | Stephen Coburn C000559 | rep | ME | 1859-12-05 | 1861-03-03 | Republican | 5 | |||||||||||||
7410 | 7410 | Stephen Foster F000312 | rep | ME | 1857-12-07 | 1859-03-03 | Republican | 6 | |||||||||||||
7411 | 7411 | Stephen Foster F000312 | rep | ME | 1859-12-05 | 1861-03-03 | Republican | 6 | |||||||||||||
7412 | 7412 | Ezra French F000377 | rep | ME | 1859-12-05 | 1861-03-03 | Republican | 3 | |||||||||||||
7523 | 7523 | Freeman Morse M001010 | rep | ME | 1843-12-04 | 1845-03-03 | Whig | 4 | |||||||||||||
7524 | 7524 | Freeman Morse M001010 | rep | ME | 1857-12-07 | 1859-03-03 | Republican | 4 | |||||||||||||
7525 | 7525 | Freeman Morse M001010 | rep | ME | 1859-12-05 | 1861-03-03 | Republican | 4 | |||||||||||||
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 | |||||||||||||
7575 | 7575 | Daniel Somes S000678 | rep | ME | 1859-12-05 | 1861-03-03 | Republican | 1 | |||||||||||||
7620 | 7620 | Israel Washburn W000173 | rep | ME | 1851-12-01 | 1853-03-03 | Whig | 6 | |||||||||||||
7621 | 7621 | Israel Washburn W000173 | rep | ME | 1853-12-05 | 1855-03-03 | Whig | 5 | |||||||||||||
7622 | 7622 | Israel Washburn W000173 | rep | ME | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 5 | |||||||||||||
7623 | 7623 | Israel Washburn W000173 | rep | ME | 1857-12-07 | 1859-03-03 | Republican | 5 | |||||||||||||
7624 | 7624 | Israel Washburn W000173 | rep | ME | 1859-12-05 | 1861-03-03 | Republican | 5 | |||||||||||||
7748 | 7748 | Samuel Fessenden F000097 | rep | ME | 1861-07-04 | 1863-03-03 | Republican | 3 | |||||||||||||
7749 | 7749 | Thomas Fessenden F000098 | rep | ME | 1861-07-04 | 1863-03-03 | Republican | 2 | |||||||||||||
7806 | 7806 | Anson Morrill M000967 | rep | ME | 1861-07-04 | 1863-03-03 | Republican | 4 | |||||||||||||
7874 | 7874 | Charles Walton W000112 | rep | ME | 1861-07-04 | 1863-03-03 | Republican | 2 | |||||||||||||
8044 | 8044 | Lorenzo Sweat S001100 | rep | ME | 1863-12-07 | 1865-03-03 | Democrat | 1 | |||||||||||||
8070 | 8070 | Nathan Farwell F000038 | sen | ME | 1864-01-01 | 1865-03-03 | 2 | Republican | |||||||||||||
8114 | 8114 | William Fessenden F000099 | rep | ME | 1841-05-31 | 1843-03-03 | Whig | 2 | |||||||||||||
8115 | 8115 | William Fessenden F000099 | sen | ME | 1854-01-01 | 1859-03-03 | 2 | Republican | |||||||||||||
8116 | 8116 | William Fessenden F000099 | sen | ME | 1859-12-05 | 1865-03-03 | 2 | Republican | |||||||||||||
8117 | 8117 | William Fessenden F000099 | sen | ME | 1865-12-04 | 1869-12-31 | 2 | Republican | |||||||||||||
8118 | 8118 | John Goodwin G000301 | rep | ME | 1861-07-04 | 1863-03-03 | Republican | 1 | |||||||||||||
8192 | 8192 | John Rice R000201 | rep | ME | 1861-07-04 | 1863-03-03 | Republican | 5 | |||||||||||||
8193 | 8193 | John Rice R000201 | rep | ME | 1863-12-07 | 1865-03-03 | Republican | 4 | |||||||||||||
8194 | 8194 | John Rice R000201 | rep | ME | 1865-12-04 | 1867-03-03 | Republican | 4 | |||||||||||||
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 | |||||||||||||
8421 | 8421 | Frederick Pike P000346 | rep | ME | 1861-07-04 | 1863-03-03 | Republican | 6 | |||||||||||||
8422 | 8422 | Frederick Pike P000346 | rep | ME | 1863-12-07 | 1865-03-03 | Republican | 5 | |||||||||||||
8423 | 8423 | Frederick Pike P000346 | rep | ME | 1865-12-04 | 1867-03-03 | Republican | 5 | |||||||||||||
8424 | 8424 | Frederick Pike P000346 | rep | ME | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
8677 | 8677 | Samuel Morrill M000971 | rep | ME | 1869-03-04 | 1871-03-03 | Republican | 2 | |||||||||||||
8945 | 8945 | John Lynch L000531 | rep | ME | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8946 | 8946 | John Lynch L000531 | rep | ME | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8947 | 8947 | John Lynch L000531 | rep | ME | 1869-03-04 | 1871-03-03 | Republican | 1 | |||||||||||||
8948 | 8948 | John Lynch L000531 | rep | ME | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
8978 | 8978 | Lot Morrill M000970 | sen | ME | 1861-07-04 | 1863-03-03 | 1 | Republican | |||||||||||||
8979 | 8979 | Lot Morrill M000970 | sen | ME | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
8980 | 8980 | Lot Morrill M000970 | sen | ME | 1869-03-04 | 1871-03-03 | 2 | Republican | |||||||||||||
8981 | 8981 | Lot Morrill M000970 | sen | ME | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
8990 | 8990 | John Peters P000252 | rep | ME | 1867-03-04 | 1869-03-03 | Republican | 4 | |||||||||||||
8991 | 8991 | John Peters P000252 | rep | ME | 1869-03-04 | 1871-03-03 | Republican | 4 | |||||||||||||
8992 | 8992 | John Peters P000252 | rep | ME | 1871-03-04 | 1873-03-03 | Republican | 4 | |||||||||||||
9471 | 9471 | John Burleigh B001107 | rep | ME | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
9472 | 9472 | John Burleigh B001107 | rep | ME | 1875-12-06 | 1877-03-03 | Republican | 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);