legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,299 rows where state = "MI" sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: class, state_rank, start (date), end (date)
party 8 ✖
- Republican 809
- Democrat 468
- Whig 7
- Ind. Republican-Democrat 3
- Progressive 2
- Independent 1
- Jackson 1
- Libertarian 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4304 | 4304 | John Norvell N000158 | sen | MI | 1837-09-04 | 1841-03-03 | 2 | Democrat | |||||||||||||
4648 | 4648 | Augustus Porter P000437 | sen | MI | 1840-01-01 | 1845-03-03 | 1 | Whig | |||||||||||||
5087 | 5087 | William Woodbridge W000709 | sen | MI | 1841-05-31 | 1847-03-03 | 2 | Whig | |||||||||||||
5248 | 5248 | Lucius Lyon L000544 | sen | MI | 1837-09-04 | 1839-03-03 | 1 | Democrat | |||||||||||||
5691 | 5691 | Alpheus Felch F000063 | sen | MI | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
5868 | 5868 | Thomas Fitzgerald F000167 | sen | MI | 1848-01-01 | 1849-12-31 | 1 | Democrat | |||||||||||||
6253 | 6253 | Lewis Cass C000233 | sen | MI | 1845-12-01 | 1849-03-03 | 1 | Democrat | |||||||||||||
6254 | 6254 | Lewis Cass C000233 | sen | MI | 1849-12-03 | 1851-03-03 | 1 | Democrat | |||||||||||||
6255 | 6255 | Lewis Cass C000233 | sen | MI | 1851-12-01 | 1857-03-03 | 1 | Democrat | |||||||||||||
6712 | 6712 | Charles Stuart S001033 | sen | MI | 1853-12-05 | 1859-03-03 | 2 | Democrat | |||||||||||||
7294 | 7294 | Kinsley Bingham B000473 | sen | MI | 1859-12-05 | 1861-12-31 | 2 | Republican | |||||||||||||
8143 | 8143 | Jacob Howard H000839 | sen | MI | 1862-01-01 | 1865-03-03 | 2 | Republican | |||||||||||||
8144 | 8144 | Jacob Howard H000839 | sen | MI | 1865-12-04 | 1871-03-03 | 2 | Republican | |||||||||||||
9486 | 9486 | Isaac Christiancy C000379 | sen | MI | 1875-12-06 | 1879-12-31 | 1 | Republican | |||||||||||||
9805 | 9805 | Thomas Ferry F000095 | sen | MI | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
9806 | 9806 | Thomas Ferry F000095 | sen | MI | 1877-10-15 | 1883-03-03 | 2 | Republican | |||||||||||||
10000 | 10000 | Henry Baldwin B000089 | sen | MI | 1879-03-18 | 1881-03-03 | 1 | Republican | |||||||||||||
10027 | 10027 | Zachariah Chandler C000299 | sen | MI | 1857-12-07 | 1863-03-03 | 1 | Republican | |||||||||||||
10028 | 10028 | Zachariah Chandler C000299 | sen | MI | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
10029 | 10029 | Zachariah Chandler C000299 | sen | MI | 1869-03-04 | 1875-03-03 | 1 | Republican | |||||||||||||
10030 | 10030 | Zachariah Chandler C000299 | sen | MI | 1879-03-18 | 1879-12-31 | 1 | Republican | |||||||||||||
10305 | 10305 | Omar Conger C000678 | sen | MI | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
10831 | 10831 | Thomas Palmer P000044 | sen | MI | 1883-12-03 | 1889-03-03 | 2 | Republican | |||||||||||||
12808 | 12808 | Francis Stockbridge S000932 | sen | MI | 1887-12-05 | 1893-03-03 | 1 | Republican | |||||||||||||
12809 | 12809 | Francis Stockbridge S000932 | sen | MI | 1893-08-07 | 1895-03-03 | 1 | Republican | |||||||||||||
12884 | 12884 | John Patton P000141 | sen | MI | 1894-01-01 | 1895-12-31 | 1 | Republican | |||||||||||||
14062 | 14062 | James McMillan M000567 | sen | MI | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
14063 | 14063 | James McMillan M000567 | sen | MI | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
14064 | 14064 | James McMillan M000567 | sen | MI | 1901-12-02 | 1903-03-03 | 2 | Republican | |||||||||||||
14224 | 14224 | Russell Alger A000107 | sen | MI | 1902-01-01 | 1907-03-03 | 2 | Republican | |||||||||||||
14611 | 14611 | Julius Burrows B001142 | sen | MI | 1895-12-02 | 1899-03-03 | 1 | Republican | |||||||||||||
14612 | 14612 | Julius Burrows B001142 | sen | MI | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14613 | 14613 | Julius Burrows B001142 | sen | MI | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
16584 | 16584 | William Smith S000629 | sen | MI | 1907-12-02 | 1913-03-03 | 2 | Republican | |||||||||||||
16585 | 16585 | William Smith S000629 | sen | MI | 1913-04-07 | 1919-03-03 | 2 | Republican | |||||||||||||
17494 | 17494 | Charles Townsend T000330 | sen | MI | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
17495 | 17495 | Charles Townsend T000330 | sen | MI | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
17868 | 17868 | Truman Newberry N000062 | sen | MI | 1919-05-19 | 1922-11-18 | 2 | Republican | |||||||||||||
18640 | 18640 | Woodbridge Ferris F000092 | sen | MI | 1923-12-03 | 1928-03-23 | 1 | Democrat | |||||||||||||
20251 | 20251 | James Couzens C000812 | sen | MI | 1922-11-29 | 1925-03-03 | 2 | Republican | appointment | ||||||||||||
20252 | 20252 | James Couzens C000812 | sen | MI | 1925-12-07 | 1931-03-03 | 2 | Republican | |||||||||||||
20253 | 20253 | James Couzens C000812 | sen | MI | 1931-12-07 | 1936-10-22 | 2 | Republican | |||||||||||||
22013 | 22013 | Prentiss Brown B000941 | sen | MI | 1936-11-19 | 1937-01-03 | 2 | Democrat | |||||||||||||
22014 | 22014 | Prentiss Brown B000941 | sen | MI | 1937-01-05 | 1943-01-03 | 2 | Democrat | |||||||||||||
24707 | 24707 | Arthur Vandenberg V000025 | sen | MI | 1928-03-31 | 1929-01-03 | 1 | Republican | appointment | ||||||||||||
24708 | 24708 | Arthur Vandenberg V000025 | sen | MI | 1929-04-15 | 1935-01-03 | 1 | Republican | |||||||||||||
24709 | 24709 | Arthur Vandenberg V000025 | sen | MI | 1935-01-03 | 1941-01-03 | 1 | Republican | |||||||||||||
24710 | 24710 | Arthur Vandenberg V000025 | sen | MI | 1941-01-03 | 1947-01-03 | 1 | Republican | |||||||||||||
24711 | 24711 | Arthur Vandenberg V000025 | sen | MI | 1947-01-03 | 1951-04-18 | 1 | Republican | |||||||||||||
24830 | 24830 | Homer Ferguson F000081 | sen | MI | 1943-01-06 | 1949-01-03 | 2 | Republican | |||||||||||||
24831 | 24831 | Homer Ferguson F000081 | sen | MI | 1949-01-03 | 1955-01-03 | 2 | Republican | |||||||||||||
25393 | 25393 | Arthur Moody M000878 | sen | MI | 1951-04-23 | 1953-01-03 | 1 | Democrat | appointment | ||||||||||||
25575 | 25575 | Charles Potter P000460 | sen | MI | 1952-11-05 | 1953-01-03 | 1 | Republican | |||||||||||||
25576 | 25576 | Charles Potter P000460 | sen | MI | 1953-01-03 | 1959-01-03 | 1 | Republican | |||||||||||||
27365 | 27365 | Patrick McNamara M000582 | sen | MI | 1955-01-05 | 1961-01-03 | 2 | Democrat | |||||||||||||
27366 | 27366 | Patrick McNamara M000582 | sen | MI | 1961-01-03 | 1966-04-30 | 2 | Democrat | |||||||||||||
29836 | 29836 | Philip Hart H000291 | sen | MI | 1959-01-07 | 1965-01-03 | 1 | Democrat | |||||||||||||
29837 | 29837 | Philip Hart H000291 | sen | MI | 1965-01-04 | 1971-01-03 | 1 | Democrat | |||||||||||||
29838 | 29838 | Philip Hart H000291 | sen | MI | 1971-01-21 | 1977-01-03 | 1 | Democrat | |||||||||||||
30401 | 30401 | Robert Griffin G000465 | sen | MI | 1966-05-11 | 1967-01-03 | 2 | Republican | appointment | ||||||||||||
30402 | 30402 | Robert Griffin G000465 | sen | MI | 1967-01-10 | 1973-01-03 | 2 | Republican | |||||||||||||
30403 | 30403 | Robert Griffin G000465 | sen | MI | 1973-01-03 | 1979-01-03 | 2 | Republican | |||||||||||||
34068 | 34068 | Donald Riegle R000249 | sen | MI | 1977-01-04 | 1983-01-03 | 1 | Democrat | |||||||||||||
34069 | 34069 | Donald Riegle R000249 | sen | MI | 1983-01-03 | 1989-01-03 | 1 | Democrat | |||||||||||||
34070 | 34070 | Donald Riegle R000249 | sen | MI | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
35679 | 35679 | Spencer Abraham A000355 | sen | MI | 1995-01-04 | 2001-01-03 | 1 | Republican | |||||||||||||
39715 | 39715 | Carl Levin L000261 | sen | MI | 1979-01-15 | 1985-01-03 | 2 | Democrat | |||||||||||||
39716 | 39716 | Carl Levin L000261 | sen | MI | 1985-01-03 | 1991-01-03 | 2 | Democrat | |||||||||||||
39717 | 39717 | Carl Levin L000261 | sen | MI | 1991-01-03 | 1997-01-03 | 2 | Democrat | |||||||||||||
39718 | 39718 | Carl Levin L000261 | sen | MI | 1997-01-07 | 2003-01-03 | 2 | Democrat | |||||||||||||
39719 | 39719 | Carl Levin L000261 | sen | MI | 2003-01-07 | 2009-01-03 | 2 | Democrat | http://levin.senate.gov/ | ||||||||||||
39720 | 39720 | Carl Levin L000261 | sen | MI | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.levin.senate.gov | 269 Russell Senate Office Building Washington DC 20510 | 202-224-6221 | 202-224-1388 | https://www.levin.senate.gov/contact/email/ | 269 Russell Senate Office Building | senior | http://www.levin.senate.gov/rss/feeds/?type=all | |||||
41803 | 41803 | Debbie Stabenow S000770 | sen | MI | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://stabenow.senate.gov/ | ||||||||||||
41804 | 41804 | Debbie Stabenow S000770 | sen | MI | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://stabenow.senate.gov/ | 133 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-4822 | 202-228-0325 | http://www.stabenow.senate.gov/?p=contact | 133 Hart Senate Office Building | |||||||
41805 | 41805 | Debbie Stabenow S000770 | sen | MI | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.stabenow.senate.gov | 731 Hart Senate Office Building Washington DC 20510 | 202-224-4822 | 202-228-0325 | https://www.stabenow.senate.gov/contact | 731 Hart Senate Office Building | senior | http://stabenow.senate.gov/rss/?p=news | |||||
41806 | 41806 | Debbie Stabenow S000770 | sen | MI | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.stabenow.senate.gov | 731 Hart Senate Office Building Washington DC 20510 | 202-224-4822 | https://www.stabenow.senate.gov/contact | 731 Hart Senate Office Building | senior | http://stabenow.senate.gov/rss/?p=news | ||||||
43101 | 43101 | Gary Peters P000595 | sen | MI | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.peters.senate.gov | 724 Hart Senate Office Building Washington DC 20510 | 202-224-6221 | 202-226-2356 | https://www.peters.senate.gov/contact/email-gary | 724 Hart Senate Office Building | junior | ||||||
43102 | 43102 | Gary Peters P000595 | sen | MI | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.peters.senate.gov | 724 Hart Senate Office Building Washington DC 20510 | 202-224-6221 | https://www.peters.senate.gov/contact/email-gary | 724 Hart Senate Office Building | junior | |||||||
2328 | 2328 | Solomon Sibley S000400 | rep | MI | 1819-12-06 | 1821-03-03 | -1 | ||||||||||||||
2329 | 2329 | Solomon Sibley S000400 | rep | MI | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2472 | 2472 | Gabriel Richard R000210 | rep | MI | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
3057 | 3057 | John Biddle B000441 | rep | MI | 1829-12-07 | 1831-03-03 | -1 | ||||||||||||||
3585 | 3585 | Austin Wing W000631 | rep | MI | 1825-12-05 | 1827-03-03 | -1 | ||||||||||||||
3586 | 3586 | Austin Wing W000631 | rep | MI | 1827-12-03 | 1829-03-03 | -1 | ||||||||||||||
3587 | 3587 | Austin Wing W000631 | rep | MI | 1831-12-05 | 1833-03-03 | -1 | ||||||||||||||
5086 | 5086 | William Woodbridge W000709 | rep | MI | 1819-12-06 | 1821-03-03 | Whig | -1 | |||||||||||||
5247 | 5247 | Lucius Lyon L000544 | rep | MI | 1833-12-02 | 1835-03-03 | Democrat | -1 | |||||||||||||
6629 | 6629 | George Jones J000221 | rep | MI | 1835-12-07 | 1837-03-03 | Democrat | -1 | |||||||||||||
18267 | 18267 | Patrick Kelley K000061 | rep | MI | 1913-04-07 | 1915-03-03 | Republican | -1 | |||||||||||||
20980 | 20980 | Bird Vincent V000101 | rep | MI | 1931-12-07 | 1933-03-03 | Republican | -1 | |||||||||||||
28177 | 28177 | Neil Staebler S000775 | rep | MI | 1963-01-09 | 1965-01-03 | Democrat | 0 | |||||||||||||
4443 | 4443 | Isaac Crary C000882 | rep | MI | 1835-12-07 | 1837-03-03 | Jackson | 1 | |||||||||||||
4444 | 4444 | Isaac Crary C000882 | rep | MI | 1837-09-04 | 1839-03-03 | Democrat | 1 | |||||||||||||
4445 | 4445 | Isaac Crary C000882 | rep | MI | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
5778 | 5778 | Robert McClelland M000334 | rep | MI | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
5779 | 5779 | Robert McClelland M000334 | rep | MI | 1845-12-01 | 1847-03-03 | Democrat | 1 | |||||||||||||
5780 | 5780 | Robert McClelland M000334 | rep | MI | 1847-12-06 | 1849-03-03 | Democrat | 1 | |||||||||||||
5916 | 5916 | Alexander Buel B001037 | rep | MI | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
6386 | 6386 | Ebenezer Penniman P000212 | rep | MI | 1851-12-01 | 1853-03-03 | Whig | 1 | |||||||||||||
6713 | 6713 | David Stuart S001034 | rep | MI | 1853-12-05 | 1855-03-03 | Democrat | 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);