legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
76 rows where district = 3 and state = "ME"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2247 | 2247 | Mark Hill H000602 | rep | ME | 1821-12-03 | 1823-03-03 | Republican | 3 | |||||||||||||
2631 | 2631 | Ebenezer Herrick H000538 | rep | ME | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
2632 | 2632 | Ebenezer Herrick H000538 | rep | ME | 1825-12-05 | 1827-03-03 | Adams | 3 | |||||||||||||
3269 | 3269 | Joseph Wingate W000632 | rep | ME | 1827-12-03 | 1829-03-03 | Adams | 3 | |||||||||||||
3270 | 3270 | Joseph Wingate W000632 | rep | ME | 1829-12-07 | 1831-03-03 | 3 | ||||||||||||||
3708 | 3708 | Edward Kavanagh K000022 | rep | ME | 1831-12-05 | 1833-03-03 | Jackson | 3 | |||||||||||||
3709 | 3709 | Edward Kavanagh K000022 | rep | ME | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
3840 | 3840 | Jeremiah Bailey B000040 | rep | ME | 1835-12-07 | 1837-03-03 | Whig | 3 | |||||||||||||
4169 | 4169 | Jonathan Cilley C000395 | rep | ME | 1837-09-04 | 1839-03-03 | Democrat | 3 | |||||||||||||
4339 | 4339 | Edward Robinson R000334 | rep | ME | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4950 | 4950 | Benjamin Randall R000035 | rep | ME | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4951 | 4951 | Benjamin Randall R000035 | rep | ME | 1841-05-31 | 1843-03-03 | Whig | 3 | |||||||||||||
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 | |||||||||||||
6086 | 6086 | John Otis O000128 | rep | ME | 1849-12-03 | 1851-03-03 | Whig | 3 | |||||||||||||
6312 | 6312 | Robert Goodenow G000284 | rep | ME | 1851-12-01 | 1853-03-03 | Whig | 3 | |||||||||||||
6591 | 6591 | Ephraim Farley F000018 | rep | ME | 1853-12-05 | 1855-03-03 | Whig | 3 | |||||||||||||
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 | |||||||||||||
7412 | 7412 | Ezra French F000377 | rep | ME | 1859-12-05 | 1861-03-03 | Republican | 3 | |||||||||||||
7748 | 7748 | Samuel Fessenden F000097 | rep | ME | 1861-07-04 | 1863-03-03 | Republican | 3 | |||||||||||||
9509 | 9509 | Edwin Flye F000225 | rep | ME | 1875-12-06 | 1877-03-03 | Republican | 3 | |||||||||||||
9714 | 9714 | James Blaine B000519 | rep | ME | 1863-12-07 | 1865-03-03 | Republican | 3 | |||||||||||||
9715 | 9715 | James Blaine B000519 | rep | ME | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
9716 | 9716 | James Blaine B000519 | rep | ME | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
9717 | 9717 | James Blaine B000519 | rep | ME | 1869-03-04 | 1871-03-03 | Republican | 3 | |||||||||||||
9718 | 9718 | James Blaine B000519 | rep | ME | 1871-03-04 | 1873-03-03 | Republican | 3 | |||||||||||||
9719 | 9719 | James Blaine B000519 | rep | ME | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
9720 | 9720 | James Blaine B000519 | rep | ME | 1875-12-06 | 1876-07-10 | Republican | 3 | |||||||||||||
10432 | 10432 | Stephen Lindsey L000328 | rep | ME | 1877-10-15 | 1879-03-03 | Republican | 3 | |||||||||||||
10433 | 10433 | Stephen Lindsey L000328 | rep | ME | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10434 | 10434 | Stephen Lindsey L000328 | rep | ME | 1881-12-05 | 1883-03-03 | Republican | 3 | |||||||||||||
13415 | 13415 | Seth Milliken M000769 | rep | ME | 1885-12-07 | 1887-03-03 | Republican | 3 | |||||||||||||
13416 | 13416 | Seth Milliken M000769 | rep | ME | 1887-12-05 | 1889-03-03 | Republican | 3 | |||||||||||||
13417 | 13417 | Seth Milliken M000769 | rep | ME | 1889-12-02 | 1891-03-03 | Republican | 3 | |||||||||||||
13418 | 13418 | Seth Milliken M000769 | rep | ME | 1891-12-07 | 1893-03-03 | Republican | 3 | |||||||||||||
13419 | 13419 | Seth Milliken M000769 | rep | ME | 1893-08-07 | 1895-03-03 | Republican | 3 | |||||||||||||
13420 | 13420 | Seth Milliken M000769 | rep | ME | 1895-12-02 | 1897-03-03 | Republican | 3 | |||||||||||||
13421 | 13421 | Seth Milliken M000769 | rep | ME | 1897-03-15 | 1899-03-03 | Republican | 3 | |||||||||||||
15988 | 15988 | Samuel Gould G000343 | rep | ME | 1911-04-04 | 1913-03-03 | Democrat | 3 | |||||||||||||
16309 | 16309 | Edwin Burleigh B001105 | rep | ME | 1897-03-15 | 1899-03-03 | Republican | 3 | |||||||||||||
16310 | 16310 | Edwin Burleigh B001105 | rep | ME | 1899-12-04 | 1901-03-03 | Republican | 3 | |||||||||||||
16311 | 16311 | Edwin Burleigh B001105 | rep | ME | 1901-12-02 | 1903-03-03 | Republican | 3 | |||||||||||||
16312 | 16312 | Edwin Burleigh B001105 | rep | ME | 1903-11-09 | 1905-03-03 | Republican | 3 | |||||||||||||
16313 | 16313 | Edwin Burleigh B001105 | rep | ME | 1905-12-04 | 1907-03-03 | Republican | 3 | |||||||||||||
16314 | 16314 | Edwin Burleigh B001105 | rep | ME | 1907-12-02 | 1909-03-03 | Republican | 3 | |||||||||||||
16315 | 16315 | Edwin Burleigh B001105 | rep | ME | 1909-03-15 | 1911-03-03 | Republican | 3 | |||||||||||||
16378 | 16378 | Forrest Goodwin G000298 | rep | ME | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
18416 | 18416 | John Peters P000253 | rep | ME | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
18417 | 18417 | John Peters P000253 | rep | ME | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
18418 | 18418 | John Peters P000253 | rep | ME | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
18419 | 18419 | John Peters P000253 | rep | ME | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
18420 | 18420 | John Peters P000253 | rep | ME | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
20740 | 20740 | John Nelson N000038 | rep | ME | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
20741 | 20741 | John Nelson N000038 | rep | ME | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
20742 | 20742 | John Nelson N000038 | rep | ME | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
20743 | 20743 | John Nelson N000038 | rep | ME | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
20744 | 20744 | John Nelson N000038 | rep | ME | 1929-04-15 | 1931-03-03 | Republican | 3 | |||||||||||||
20745 | 20745 | John Nelson N000038 | rep | ME | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
21585 | 21585 | John Utterback U000037 | rep | ME | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
24281 | 24281 | Ralph Brewster B000816 | rep | ME | 1935-01-03 | 1937-01-03 | Republican | 3 | |||||||||||||
24282 | 24282 | Ralph Brewster B000816 | rep | ME | 1937-01-05 | 1939-01-03 | Republican | 3 | |||||||||||||
24283 | 24283 | Ralph Brewster B000816 | rep | ME | 1939-01-03 | 1941-01-03 | Republican | 3 | |||||||||||||
25256 | 25256 | Frank Fellows F000066 | rep | ME | 1941-01-03 | 1943-01-03 | Republican | 3 | |||||||||||||
25257 | 25257 | Frank Fellows F000066 | rep | ME | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
25258 | 25258 | Frank Fellows F000066 | rep | ME | 1945-01-03 | 1947-01-03 | Republican | 3 | |||||||||||||
25259 | 25259 | Frank Fellows F000066 | rep | ME | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
25260 | 25260 | Frank Fellows F000066 | rep | ME | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
25261 | 25261 | Frank Fellows F000066 | rep | ME | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
27998 | 27998 | Clifford McIntire M000478 | rep | ME | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
27999 | 27999 | Clifford McIntire M000478 | rep | ME | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
28000 | 28000 | Clifford McIntire M000478 | rep | ME | 1955-01-05 | 1957-01-03 | Republican | 3 | |||||||||||||
28001 | 28001 | Clifford McIntire M000478 | rep | ME | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
28002 | 28002 | Clifford McIntire M000478 | rep | ME | 1959-01-07 | 1961-01-03 | Republican | 3 | |||||||||||||
28003 | 28003 | Clifford McIntire M000478 | rep | ME | 1961-01-03 | 1963-01-03 | Republican | 3 |
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);