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 rss_url
This data as json, copyable, CSV (advanced)
Suggested facets: class, district, fax, contact_form, 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 | |||||||||||||
7270 | 7270 | Henry Rice R000198 | sen | MN | 1858-01-01 | 1863-03-03 | 1 | Democrat | |||||||||||||
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 | |||||||||||||
8182 | 8182 | Daniel Norton N000145 | sen | MN | 1865-12-04 | 1871-03-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
8697 | 8697 | Alexander Ramsey R000026 | sen | MN | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
8698 | 8698 | Alexander Ramsey R000026 | sen | MN | 1869-03-04 | 1875-03-03 | 1 | Republican | |||||||||||||
8782 | 8782 | Morton Wilkinson W000476 | sen | MN | 1859-12-05 | 1865-03-03 | 2 | Republican | |||||||||||||
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 | |||||||||||||
9023 | 9023 | Ozora Stearns S000824 | sen | MN | 1871-03-04 | 1871-12-31 | 2 | Republican | |||||||||||||
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 | |||||||||||||
10189 | 10189 | James Shields S000362 | sen | MN | 1858-01-01 | 1859-03-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
10244 | 10244 | William Windom W000629 | sen | MN | 1870-07-15 | 1871-01-22 | 2 | Republican | |||||||||||||
10245 | 10245 | William Windom W000629 | sen | MN | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
10246 | 10246 | William Windom W000629 | sen | MN | 1877-03-05 | 1881-03-07 | 2 | Republican | |||||||||||||
10247 | 10247 | William Windom W000629 | sen | MN | 1881-11-15 | 1883-03-03 | 2 | Republican | |||||||||||||
10339 | 10339 | Alonzo Edgerton E000046 | sen | MN | 1881-12-05 | 1881-12-31 | 2 | Republican | |||||||||||||
10462 | 10462 | Samuel McMillan M000570 | sen | MN | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
10463 | 10463 | Samuel McMillan M000570 | sen | MN | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
10873 | 10873 | Dwight Sabin S000003 | sen | MN | 1883-12-03 | 1889-03-03 | 2 | Republican | |||||||||||||
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 | |||||||||||||
12016 | 12016 | William Washburn W000175 | sen | MN | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
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 | |||||||||||||
13637 | 13637 | Cushman Davis D000095 | sen | MN | 1887-12-05 | 1893-03-03 | 1 | Republican | |||||||||||||
13638 | 13638 | Cushman Davis D000095 | sen | MN | 1893-08-07 | 1899-03-03 | 1 | Republican | |||||||||||||
13639 | 13639 | Cushman Davis D000095 | sen | MN | 1899-12-04 | 1901-03-03 | 1 | Republican | |||||||||||||
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 |
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);