legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
697 rows where state = "MN" sorted by type
This data as json, copyable, CSV (advanced)
Suggested facets: class, district, fax, state_rank, rss_url, start (date), end (date)
party 8 ✖
- Republican 431
- Democrat 226
- Farmer-Labor 31
- Populist 2
- Progressive 2
- Ind. Republican 1
- Independent 1
- Union Labor 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6415 | 6415 | Henry Sibley S000396 | rep | MN | 1849-12-03 | 1851-03-03 | -1 | ||||||||||||||
6416 | 6416 | Henry Sibley S000396 | rep | MN | 1851-12-01 | 1853-03-03 | -1 | ||||||||||||||
7123 | 7123 | William Kingsbury K000219 | rep | MN | 1857-12-07 | 1859-03-03 | Democrat | -1 | |||||||||||||
7180 | 7180 | William Phelps P000301 | rep | MN | 1857-12-07 | 1859-03-03 | Democrat | -1 | |||||||||||||
7268 | 7268 | Henry Rice R000198 | rep | MN | 1853-12-05 | 1855-03-03 | Democrat | -1 | |||||||||||||
7269 | 7269 | Henry Rice R000198 | rep | MN | 1855-12-03 | 1857-03-03 | Democrat | -1 | |||||||||||||
7650 | 7650 | Cyrus Aldrich A000081 | rep | MN | 1859-12-05 | 1861-03-03 | Republican | -1 | |||||||||||||
7651 | 7651 | Cyrus Aldrich A000081 | rep | MN | 1861-07-04 | 1863-03-03 | Republican | -1 | |||||||||||||
8312 | 8312 | Ignatius Donnelly D000417 | rep | MN | 1863-12-07 | 1865-03-03 | Republican | 2 | |||||||||||||
8313 | 8313 | Ignatius Donnelly D000417 | rep | MN | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8314 | 8314 | Ignatius Donnelly D000417 | rep | MN | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8543 | 8543 | James Cavanaugh C000260 | rep | MN | 1857-12-07 | 1859-03-03 | Democrat | -1 | |||||||||||||
8783 | 8783 | Morton Wilkinson W000476 | rep | MN | 1869-03-04 | 1871-03-03 | Republican | 1 | |||||||||||||
8784 | 8784 | Eugene Wilson W000578 | rep | MN | 1869-03-04 | 1871-03-03 | Democrat | 2 | |||||||||||||
9081 | 9081 | John Averill A000344 | rep | MN | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
9082 | 9082 | John Averill A000344 | rep | MN | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
9561 | 9561 | William King K000218 | rep | MN | 1875-12-06 | 1877-03-03 | Republican | 3 | |||||||||||||
9945 | 9945 | Jacob Stewart S000908 | rep | MN | 1877-10-15 | 1879-03-03 | Republican | 3 | |||||||||||||
10171 | 10171 | Henry Poehler P000400 | rep | MN | 1879-03-18 | 1881-03-03 | Democrat | 2 | |||||||||||||
10239 | 10239 | William Windom W000629 | rep | MN | 1859-12-05 | 1861-03-03 | Republican | -1 | |||||||||||||
10240 | 10240 | William Windom W000629 | rep | MN | 1861-07-04 | 1863-03-03 | Republican | -1 | |||||||||||||
10241 | 10241 | William Windom W000629 | rep | MN | 1863-12-07 | 1865-03-03 | Republican | 1 | |||||||||||||
10242 | 10242 | William Windom W000629 | rep | MN | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
10243 | 10243 | William Windom W000629 | rep | MN | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
11050 | 11050 | John Gilfillan G000186 | rep | MN | 1885-12-07 | 1887-03-03 | Republican | 4 | |||||||||||||
11214 | 11214 | Horace Strait S000988 | rep | MN | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
11215 | 11215 | Horace Strait S000988 | rep | MN | 1875-12-06 | 1877-03-03 | Republican | 2 | |||||||||||||
11216 | 11216 | Horace Strait S000988 | rep | MN | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
11217 | 11217 | Horace Strait S000988 | rep | MN | 1881-12-05 | 1883-03-03 | Republican | 2 | |||||||||||||
11218 | 11218 | Horace Strait S000988 | rep | MN | 1883-12-03 | 1885-03-03 | Republican | 3 | |||||||||||||
11219 | 11219 | Horace Strait S000988 | rep | MN | 1885-12-07 | 1887-03-03 | Republican | 3 | |||||||||||||
11250 | 11250 | James Wakefield W000026 | rep | MN | 1883-12-03 | 1885-03-03 | Republican | 2 | |||||||||||||
11251 | 11251 | James Wakefield W000026 | rep | MN | 1885-12-07 | 1887-03-03 | Republican | 2 | |||||||||||||
11266 | 11266 | Milo White W000387 | rep | MN | 1883-12-03 | 1885-03-03 | Republican | 1 | |||||||||||||
11267 | 11267 | Milo White W000387 | rep | MN | 1885-12-07 | 1887-03-03 | Republican | 1 | |||||||||||||
11438 | 11438 | John MacDonald M000003 | rep | MN | 1887-12-05 | 1889-03-03 | Democrat | 3 | |||||||||||||
11490 | 11490 | Edmund Rice R000196 | rep | MN | 1887-12-05 | 1889-03-03 | Democrat | 4 | |||||||||||||
11550 | 11550 | Thomas Wilson W000614 | rep | MN | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
11681 | 11681 | Solomon Comstock C000665 | rep | MN | 1889-12-02 | 1891-03-03 | Republican | 5 | |||||||||||||
11740 | 11740 | Mark Dunnell D000555 | rep | MN | 1871-03-04 | 1873-03-03 | Republican | 1 | |||||||||||||
11741 | 11741 | Mark Dunnell D000555 | rep | MN | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
11742 | 11742 | Mark Dunnell D000555 | rep | MN | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
11743 | 11743 | Mark Dunnell D000555 | rep | MN | 1877-10-15 | 1879-03-03 | Republican | 1 | |||||||||||||
11744 | 11744 | Mark Dunnell D000555 | rep | MN | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
11745 | 11745 | Mark Dunnell D000555 | rep | MN | 1881-12-05 | 1883-03-03 | Republican | 1 | |||||||||||||
11746 | 11746 | Mark Dunnell D000555 | rep | MN | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
11776 | 11776 | Darwin Hall H000047 | rep | MN | 1889-12-02 | 1891-03-03 | Republican | 3 | |||||||||||||
11965 | 11965 | Samuel Snider S000653 | rep | MN | 1889-12-02 | 1891-03-03 | Republican | 4 | |||||||||||||
12013 | 12013 | William Washburn W000175 | rep | MN | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
12014 | 12014 | William Washburn W000175 | rep | MN | 1881-12-05 | 1883-03-03 | Republican | 3 | |||||||||||||
12015 | 12015 | William Washburn W000175 | rep | MN | 1883-12-03 | 1885-03-03 | Republican | 4 | |||||||||||||
12130 | 12130 | James Castle C000242 | rep | MN | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
12188 | 12188 | Kittel Halvorson H000094 | rep | MN | 1891-12-07 | 1893-03-03 | Populist | 5 | |||||||||||||
12190 | 12190 | William Harries H000228 | rep | MN | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12402 | 12402 | Melvin Baldwin B000094 | rep | MN | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
12418 | 12418 | Haldor Boen B000590 | rep | MN | 1893-08-07 | 1895-03-03 | Populist | 7 | |||||||||||||
12590 | 12590 | Osee Hall H000065 | rep | MN | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12591 | 12591 | Osee Hall H000065 | rep | MN | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
13049 | 13049 | Andrew Kiefer K000166 | rep | MN | 1893-08-07 | 1895-03-03 | Republican | 4 | |||||||||||||
13050 | 13050 | Andrew Kiefer K000166 | rep | MN | 1895-12-02 | 1897-03-03 | Republican | 4 | |||||||||||||
13940 | 13940 | Frank Eddy E000038 | rep | MN | 1895-12-02 | 1897-03-03 | Republican | 7 | |||||||||||||
13941 | 13941 | Frank Eddy E000038 | rep | MN | 1897-03-15 | 1899-03-03 | Republican | 7 | |||||||||||||
13942 | 13942 | Frank Eddy E000038 | rep | MN | 1899-12-04 | 1901-03-03 | Republican | 7 | |||||||||||||
13943 | 13943 | Frank Eddy E000038 | rep | MN | 1901-12-02 | 1903-03-03 | Republican | 7 | |||||||||||||
13986 | 13986 | Joel Heatwole H000434 | rep | MN | 1895-12-02 | 1897-03-03 | Republican | 3 | |||||||||||||
13987 | 13987 | Joel Heatwole H000434 | rep | MN | 1897-03-15 | 1899-03-03 | Republican | 3 | |||||||||||||
13988 | 13988 | Joel Heatwole H000434 | rep | MN | 1899-12-04 | 1901-03-03 | Republican | 3 | |||||||||||||
13989 | 13989 | Joel Heatwole H000434 | rep | MN | 1901-12-02 | 1903-03-03 | Republican | 3 | |||||||||||||
14097 | 14097 | Robert Morris M000986 | rep | MN | 1897-03-15 | 1899-03-03 | Republican | 6 | |||||||||||||
14098 | 14098 | Robert Morris M000986 | rep | MN | 1899-12-04 | 1901-03-03 | Republican | 6 | |||||||||||||
14099 | 14099 | Robert Morris M000986 | rep | MN | 1901-12-02 | 1903-03-03 | Republican | 6 | |||||||||||||
14379 | 14379 | John Lind L000319 | rep | MN | 1887-12-05 | 1889-03-03 | Republican | 2 | |||||||||||||
14380 | 14380 | John Lind L000319 | rep | MN | 1889-12-02 | 1891-03-03 | Republican | 2 | |||||||||||||
14381 | 14381 | John Lind L000319 | rep | MN | 1891-12-07 | 1893-03-03 | Republican | 2 | |||||||||||||
14382 | 14382 | John Lind L000319 | rep | MN | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
14596 | 14596 | Clarence Buckman B001029 | rep | MN | 1903-11-09 | 1905-03-03 | Republican | 6 | |||||||||||||
14597 | 14597 | Clarence Buckman B001029 | rep | MN | 1905-12-04 | 1907-03-03 | Republican | 6 | |||||||||||||
14656 | 14656 | Loren Fletcher F000202 | rep | MN | 1893-08-07 | 1895-03-03 | Republican | 5 | |||||||||||||
14657 | 14657 | Loren Fletcher F000202 | rep | MN | 1895-12-02 | 1897-03-03 | Republican | 5 | |||||||||||||
14658 | 14658 | Loren Fletcher F000202 | rep | MN | 1897-03-15 | 1899-03-03 | Republican | 5 | |||||||||||||
14659 | 14659 | Loren Fletcher F000202 | rep | MN | 1899-12-04 | 1901-03-03 | Republican | 5 | |||||||||||||
14660 | 14660 | Loren Fletcher F000202 | rep | MN | 1901-12-02 | 1903-03-03 | Republican | 5 | |||||||||||||
14661 | 14661 | Loren Fletcher F000202 | rep | MN | 1905-12-04 | 1907-03-03 | Republican | 5 | |||||||||||||
14811 | 14811 | James McCleary M000326 | rep | MN | 1893-08-07 | 1895-03-03 | Republican | 2 | |||||||||||||
14812 | 14812 | James McCleary M000326 | rep | MN | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
14813 | 14813 | James McCleary M000326 | rep | MN | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
14814 | 14814 | James McCleary M000326 | rep | MN | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
14815 | 14815 | James McCleary M000326 | rep | MN | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
14816 | 14816 | James McCleary M000326 | rep | MN | 1903-11-09 | 1905-03-03 | Republican | 2 | |||||||||||||
14817 | 14817 | James McCleary M000326 | rep | MN | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
14979 | 14979 | James Bede B000297 | rep | MN | 1903-11-09 | 1905-03-03 | Republican | 8 | |||||||||||||
14980 | 14980 | James Bede B000297 | rep | MN | 1905-12-04 | 1907-03-03 | Republican | 8 | |||||||||||||
14981 | 14981 | James Bede B000297 | rep | MN | 1907-12-02 | 1909-03-03 | Republican | 8 | |||||||||||||
15770 | 15770 | James Tawney T000060 | rep | MN | 1893-08-07 | 1895-03-03 | Republican | 1 | |||||||||||||
15771 | 15771 | James Tawney T000060 | rep | MN | 1895-12-02 | 1897-03-03 | Republican | 1 | |||||||||||||
15772 | 15772 | James Tawney T000060 | rep | MN | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
15773 | 15773 | James Tawney T000060 | rep | MN | 1899-12-04 | 1901-03-03 | Republican | 1 | |||||||||||||
15774 | 15774 | James Tawney T000060 | rep | MN | 1901-12-02 | 1903-03-03 | Republican | 1 | |||||||||||||
15775 | 15775 | James Tawney T000060 | rep | MN | 1903-11-09 | 1905-03-03 | Republican | 1 | |||||||||||||
15776 | 15776 | James Tawney T000060 | rep | MN | 1905-12-04 | 1907-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);