legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
226 rows where party = "Democrat" and state = "MN"
This data as json, copyable, CSV (advanced)
Suggested facets: class, address, phone, fax, office, state_rank, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
8182 | 8182 | Daniel Norton N000145 | sen | MN | 1865-12-04 | 1871-03-03 | 2 | Democrat | |||||||||||||
8543 | 8543 | James Cavanaugh C000260 | rep | MN | 1857-12-07 | 1859-03-03 | Democrat | -1 | |||||||||||||
8784 | 8784 | Eugene Wilson W000578 | rep | MN | 1869-03-04 | 1871-03-03 | Democrat | 2 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
12130 | 12130 | James Castle C000242 | rep | MN | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
14382 | 14382 | John Lind L000319 | rep | MN | 1903-11-09 | 1905-03-03 | Democrat | 5 | |||||||||||||
14919 | 14919 | Charles Towne T000324 | sen | MN | 1900-01-01 | 1901-12-31 | 1 | Democrat | |||||||||||||
16387 | 16387 | Winfield Hammond H000135 | rep | MN | 1907-12-02 | 1909-03-03 | Democrat | 2 | |||||||||||||
16388 | 16388 | Winfield Hammond H000135 | rep | MN | 1909-03-15 | 1911-03-03 | Democrat | 2 | |||||||||||||
16389 | 16389 | Winfield Hammond H000135 | rep | MN | 1911-04-04 | 1913-03-03 | Democrat | 2 | |||||||||||||
16390 | 16390 | Winfield Hammond H000135 | rep | MN | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
17978 | 17978 | Carl Van Dyke V000034 | rep | MN | 1915-12-06 | 1917-03-03 | Democrat | 4 | |||||||||||||
17979 | 17979 | Carl Van Dyke V000034 | rep | MN | 1917-04-02 | 1919-03-03 | Democrat | 4 | |||||||||||||
17980 | 17980 | Carl Van Dyke V000034 | rep | MN | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
21316 | 21316 | Einar Hoidale H000706 | rep | MN | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
22755 | 22755 | Elmer Ryan R000555 | rep | MN | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22756 | 22756 | Elmer Ryan R000555 | rep | MN | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
22757 | 22757 | Elmer Ryan R000555 | rep | MN | 1939-01-03 | 1941-01-03 | Democrat | 2 | |||||||||||||
23844 | 23844 | William Gallagher G000019 | rep | MN | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
24106 | 24106 | Frank Starkey S000812 | rep | MN | 1945-01-03 | 1947-01-03 | Democrat | 4 | |||||||||||||
26464 | 26464 | Coya Knutson K000300 | rep | MN | 1955-01-05 | 1957-01-03 | Democrat | 9 | |||||||||||||
26465 | 26465 | Coya Knutson K000300 | rep | MN | 1957-01-03 | 1959-01-03 | Democrat | 9 | |||||||||||||
27040 | 27040 | Roy Wier W000446 | rep | MN | 1949-01-03 | 1951-01-03 | Democrat | 3 | |||||||||||||
27041 | 27041 | Roy Wier W000446 | rep | MN | 1951-01-03 | 1953-01-03 | Democrat | 3 | |||||||||||||
27042 | 27042 | Roy Wier W000446 | rep | MN | 1953-01-03 | 1955-01-03 | Democrat | 3 | |||||||||||||
27043 | 27043 | Roy Wier W000446 | rep | MN | 1955-01-05 | 1957-01-03 | Democrat | 3 | |||||||||||||
27044 | 27044 | Roy Wier W000446 | rep | MN | 1957-01-03 | 1959-01-03 | Democrat | 3 | |||||||||||||
27045 | 27045 | Roy Wier W000446 | rep | MN | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
27336 | 27336 | Fred Marshall M000152 | rep | MN | 1949-01-03 | 1951-01-03 | Democrat | 6 | |||||||||||||
27337 | 27337 | Fred Marshall M000152 | rep | MN | 1951-01-03 | 1953-01-03 | Democrat | 6 | |||||||||||||
27338 | 27338 | Fred Marshall M000152 | rep | MN | 1953-01-03 | 1955-01-03 | Democrat | 6 | |||||||||||||
27339 | 27339 | Fred Marshall M000152 | rep | MN | 1955-01-05 | 1957-01-03 | Democrat | 6 | |||||||||||||
27340 | 27340 | Fred Marshall M000152 | rep | MN | 1957-01-03 | 1959-01-03 | Democrat | 6 | |||||||||||||
27341 | 27341 | Fred Marshall M000152 | rep | MN | 1959-01-07 | 1961-01-03 | Democrat | 6 | |||||||||||||
27342 | 27342 | Fred Marshall M000152 | rep | MN | 1961-01-03 | 1963-01-03 | Democrat | 6 | |||||||||||||
28557 | 28557 | Eugene McCarthy M000311 | rep | MN | 1949-01-03 | 1951-01-03 | Democrat | 4 | |||||||||||||
28558 | 28558 | Eugene McCarthy M000311 | rep | MN | 1951-01-03 | 1953-01-03 | Democrat | 4 | |||||||||||||
28559 | 28559 | Eugene McCarthy M000311 | rep | MN | 1953-01-03 | 1955-01-03 | Democrat | 4 | |||||||||||||
28560 | 28560 | Eugene McCarthy M000311 | rep | MN | 1955-01-05 | 1957-01-03 | Democrat | 4 | |||||||||||||
28561 | 28561 | Eugene McCarthy M000311 | rep | MN | 1957-01-03 | 1959-01-03 | Democrat | 4 | |||||||||||||
28562 | 28562 | Eugene McCarthy M000311 | sen | MN | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
28563 | 28563 | Eugene McCarthy M000311 | sen | MN | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
28607 | 28607 | Alec Olson O000084 | rep | MN | 1963-01-09 | 1965-01-03 | Democrat | 6 | |||||||||||||
28608 | 28608 | Alec Olson O000084 | rep | MN | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
30165 | 30165 | John Blatnik B000550 | rep | MN | 1947-01-03 | 1949-01-03 | Democrat | 8 | |||||||||||||
30166 | 30166 | John Blatnik B000550 | rep | MN | 1949-01-03 | 1951-01-03 | Democrat | 8 | |||||||||||||
30167 | 30167 | John Blatnik B000550 | rep | MN | 1951-01-03 | 1953-01-03 | Democrat | 8 | |||||||||||||
30168 | 30168 | John Blatnik B000550 | rep | MN | 1953-01-03 | 1955-01-03 | Democrat | 8 | |||||||||||||
30169 | 30169 | John Blatnik B000550 | rep | MN | 1955-01-05 | 1957-01-03 | Democrat | 8 | |||||||||||||
30170 | 30170 | John Blatnik B000550 | rep | MN | 1957-01-03 | 1959-01-03 | Democrat | 8 | |||||||||||||
30171 | 30171 | John Blatnik B000550 | rep | MN | 1959-01-07 | 1961-01-03 | Democrat | 8 | |||||||||||||
30172 | 30172 | John Blatnik B000550 | rep | MN | 1961-01-03 | 1963-01-03 | Democrat | 8 | |||||||||||||
30173 | 30173 | John Blatnik B000550 | rep | MN | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
30174 | 30174 | John Blatnik B000550 | rep | MN | 1965-01-04 | 1967-01-03 | Democrat | 8 | |||||||||||||
30175 | 30175 | John Blatnik B000550 | rep | MN | 1967-01-10 | 1969-01-03 | Democrat | 8 | |||||||||||||
30176 | 30176 | John Blatnik B000550 | rep | MN | 1969-01-03 | 1971-01-03 | Democrat | 8 | |||||||||||||
30177 | 30177 | John Blatnik B000550 | rep | MN | 1971-01-21 | 1973-01-03 | Democrat | 8 | |||||||||||||
30178 | 30178 | John Blatnik B000550 | rep | MN | 1973-01-03 | 1975-01-03 | Democrat | 8 | |||||||||||||
30597 | 30597 | Walter Mondale M000851 | sen | MN | 1964-12-30 | 1967-01-03 | 2 | Democrat | appointment | ||||||||||||
30598 | 30598 | Walter Mondale M000851 | sen | MN | 1967-01-10 | 1973-01-03 | 2 | Democrat | |||||||||||||
30599 | 30599 | Walter Mondale M000851 | sen | MN | 1973-01-03 | 1976-12-30 | 2 | Democrat | |||||||||||||
31096 | 31096 | Joseph Karth K000014 | rep | MN | 1959-01-07 | 1961-01-03 | Democrat | 4 | |||||||||||||
31097 | 31097 | Joseph Karth K000014 | rep | MN | 1961-01-03 | 1963-01-03 | Democrat | 4 | |||||||||||||
31098 | 31098 | Joseph Karth K000014 | rep | MN | 1963-01-09 | 1965-01-03 | Democrat | 4 | |||||||||||||
31099 | 31099 | Joseph Karth K000014 | rep | MN | 1965-01-04 | 1967-01-03 | Democrat | 4 | |||||||||||||
31100 | 31100 | Joseph Karth K000014 | rep | MN | 1967-01-10 | 1969-01-03 | Democrat | 4 | |||||||||||||
31101 | 31101 | Joseph Karth K000014 | rep | MN | 1969-01-03 | 1971-01-03 | Democrat | 4 | |||||||||||||
31102 | 31102 | Joseph Karth K000014 | rep | MN | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
31103 | 31103 | Joseph Karth K000014 | rep | MN | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
31104 | 31104 | Joseph Karth K000014 | rep | MN | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
31411 | 31411 | Wendell Anderson A000202 | sen | MN | 1976-12-30 | 1978-12-29 | 2 | Democrat | appointment | ||||||||||||
31419 | 31419 | Robert Bergland B000408 | rep | MN | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
31420 | 31420 | Robert Bergland B000408 | rep | MN | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
31421 | 31421 | Robert Bergland B000408 | rep | MN | 1975-01-14 | 1977-01-03 | Democrat | 7 | |||||||||||||
31422 | 31422 | Robert Bergland B000408 | rep | MN | 1977-01-04 | 1979-01-03 | Democrat | 7 | |||||||||||||
31569 | 31569 | Donald Fraser F000350 | rep | MN | 1963-01-09 | 1965-01-03 | Democrat | 5 | |||||||||||||
31570 | 31570 | Donald Fraser F000350 | rep | MN | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
31571 | 31571 | Donald Fraser F000350 | rep | MN | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
31572 | 31572 | Donald Fraser F000350 | rep | MN | 1969-01-03 | 1971-01-03 | Democrat | 5 | |||||||||||||
31573 | 31573 | Donald Fraser F000350 | rep | MN | 1971-01-21 | 1973-01-03 | Democrat | 5 | |||||||||||||
31574 | 31574 | Donald Fraser F000350 | rep | MN | 1973-01-03 | 1975-01-03 | Democrat | 5 | |||||||||||||
31575 | 31575 | Donald Fraser F000350 | rep | MN | 1975-01-14 | 1977-01-03 | Democrat | 5 | |||||||||||||
31576 | 31576 | Donald Fraser F000350 | rep | MN | 1977-01-04 | 1979-01-03 | Democrat | 5 | |||||||||||||
31592 | 31592 | Hubert Humphrey H000953 | sen | MN | 1949-01-03 | 1955-01-03 | 2 | Democrat | |||||||||||||
31593 | 31593 | Hubert Humphrey H000953 | sen | MN | 1955-01-05 | 1961-01-03 | 2 | Democrat | |||||||||||||
31594 | 31594 | Hubert Humphrey H000953 | sen | MN | 1961-01-03 | 1964-12-29 | 2 | Democrat | |||||||||||||
31595 | 31595 | Hubert Humphrey H000953 | sen | MN | 1971-01-21 | 1977-01-03 | 1 | Democrat |
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);