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 party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||
4304 | 4304 | John Norvell N000158 | sen | MI | 1837-09-04 | 1841-03-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
5247 | 5247 | Lucius Lyon L000544 | rep | MI | 1833-12-02 | 1835-03-03 | Democrat | -1 | |||||||||||||
5248 | 5248 | Lucius Lyon L000544 | sen | MI | 1837-09-04 | 1839-03-03 | 1 | Democrat | |||||||||||||
5249 | 5249 | Lucius Lyon L000544 | rep | MI | 1843-12-04 | 1845-03-03 | Democrat | 2 | |||||||||||||
5385 | 5385 | John Chipman C000368 | rep | MI | 1845-12-01 | 1847-03-03 | Democrat | 2 | |||||||||||||
5447 | 5447 | James Hunt H000971 | rep | MI | 1843-12-04 | 1845-03-03 | Democrat | 3 | |||||||||||||
5448 | 5448 | James Hunt H000971 | rep | MI | 1845-12-01 | 1847-03-03 | Democrat | 3 | |||||||||||||
5628 | 5628 | Edward Bradley B000741 | rep | MI | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
5691 | 5691 | Alpheus Felch F000063 | sen | MI | 1847-12-06 | 1853-03-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
5868 | 5868 | Thomas Fitzgerald F000167 | sen | MI | 1848-01-01 | 1849-12-31 | 1 | Democrat | |||||||||||||
5916 | 5916 | Alexander Buel B001037 | rep | MI | 1849-12-03 | 1851-03-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
6548 | 6548 | Samuel Clark C000451 | rep | MI | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
6629 | 6629 | George Jones J000221 | rep | MI | 1835-12-07 | 1837-03-03 | Democrat | -1 | |||||||||||||
6658 | 6658 | David Noble N000117 | rep | MI | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6705 | 6705 | Hestor Stevens S000879 | rep | MI | 1853-12-05 | 1855-03-03 | Democrat | 4 | |||||||||||||
6710 | 6710 | Charles Stuart S001033 | rep | MI | 1847-12-06 | 1849-03-03 | Democrat | 2 | |||||||||||||
6711 | 6711 | Charles Stuart S001033 | rep | MI | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
6712 | 6712 | Charles Stuart S001033 | sen | MI | 1853-12-05 | 1859-03-03 | 2 | Democrat | |||||||||||||
6713 | 6713 | David Stuart S001034 | rep | MI | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6895 | 6895 | George Peck P000176 | rep | MI | 1855-12-03 | 1857-03-03 | Democrat | 4 | |||||||||||||
7292 | 7292 | Kinsley Bingham B000473 | rep | MI | 1847-12-06 | 1849-03-03 | Democrat | 3 | |||||||||||||
7293 | 7293 | Kinsley Bingham B000473 | rep | MI | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
7359 | 7359 | George Cooper C000749 | rep | MI | 1859-12-05 | 1861-03-03 | Democrat | 1 | |||||||||||||
7913 | 7913 | Augustus Baldwin B000085 | rep | MI | 1863-12-07 | 1865-03-03 | Democrat | 5 | |||||||||||||
9034 | 9034 | Jabez Sutherland S001082 | rep | MI | 1871-03-04 | 1873-03-03 | Democrat | 6 | |||||||||||||
9495 | 9495 | George Durand D000562 | rep | MI | 1875-12-06 | 1877-03-03 | Democrat | 6 | |||||||||||||
9611 | 9611 | Allen Potter P000459 | rep | MI | 1875-12-06 | 1877-03-03 | Democrat | 4 | |||||||||||||
9979 | 9979 | Alpheus Williams W000487 | rep | MI | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9980 | 9980 | Alpheus Williams W000487 | rep | MI | 1877-10-15 | 1879-03-03 | Democrat | 1 | |||||||||||||
10761 | 10761 | Julius Houseman H000820 | rep | MI | 1883-12-03 | 1885-03-03 | Democrat | 5 | |||||||||||||
10943 | 10943 | George Yaple Y000005 | rep | MI | 1883-12-03 | 1885-03-03 | Democrat | 4 | |||||||||||||
10998 | 10998 | Ezra Carleton C000147 | rep | MI | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
10999 | 10999 | Ezra Carleton C000147 | rep | MI | 1885-12-07 | 1887-03-03 | Democrat | 7 | |||||||||||||
11009 | 11009 | Charles Comstock C000662 | rep | MI | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11024 | 11024 | Nathaniel Eldredge E000104 | rep | MI | 1883-12-03 | 1885-03-03 | Democrat | 2 | |||||||||||||
11025 | 11025 | Nathaniel Eldredge E000104 | rep | MI | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
11126 | 11126 | William Maybury M000280 | rep | MI | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
11127 | 11127 | William Maybury M000280 | rep | MI | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
11275 | 11275 | Edwin Winans W000625 | rep | MI | 1883-12-03 | 1885-03-03 | Democrat | 6 | |||||||||||||
11276 | 11276 | Edwin Winans W000625 | rep | MI | 1885-12-07 | 1887-03-03 | Democrat | 6 | |||||||||||||
11368 | 11368 | Spencer Fisher F000153 | rep | MI | 1885-12-07 | 1887-03-03 | Democrat | 10 | |||||||||||||
11369 | 11369 | Spencer Fisher F000153 | rep | MI | 1887-12-05 | 1889-03-03 | Democrat | 10 | |||||||||||||
11518 | 11518 | Timothy Tarsney T000044 | rep | MI | 1885-12-07 | 1887-03-03 | Democrat | 8 | |||||||||||||
11519 | 11519 | Timothy Tarsney T000044 | rep | MI | 1887-12-05 | 1889-03-03 | Democrat | 8 | |||||||||||||
12162 | 12162 | Melbourne Ford F000265 | rep | MI | 1887-12-05 | 1889-03-03 | Democrat | 5 | |||||||||||||
12163 | 12163 | Melbourne Ford F000265 | rep | MI | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
12311 | 12311 | Byron Stout S000980 | rep | MI | 1891-12-07 | 1893-03-03 | Democrat | 6 | |||||||||||||
12355 | 12355 | Harrison Wheeler W000336 | rep | MI | 1891-12-07 | 1893-03-03 | Democrat | 9 | |||||||||||||
12370 | 12370 | Henry Youmans Y000027 | rep | MI | 1891-12-07 | 1893-03-03 | Democrat | 8 | |||||||||||||
12485 | 12485 | John Chipman C000367 | rep | MI | 1887-12-05 | 1889-03-03 | Democrat | 1 | |||||||||||||
12486 | 12486 | John Chipman C000367 | rep | MI | 1889-12-02 | 1891-03-03 | Democrat | 1 | |||||||||||||
12487 | 12487 | John Chipman C000367 | rep | MI | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12488 | 12488 | John Chipman C000367 | rep | MI | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12579 | 12579 | James Gorman G000328 | rep | MI | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12580 | 12580 | James Gorman G000328 | rep | MI | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
12588 | 12588 | Levi Griffin G000463 | rep | MI | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12768 | 12768 | George Richardson R000220 | rep | MI | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
12846 | 12846 | Thomas Weadock W000219 | rep | MI | 1891-12-07 | 1893-03-03 | Democrat | 10 | |||||||||||||
12847 | 12847 | Thomas Weadock W000219 | rep | MI | 1893-08-07 | 1895-03-03 | Democrat | 10 | |||||||||||||
12854 | 12854 | Justin Whiting W000415 | rep | MI | 1887-12-05 | 1889-03-03 | Democrat | 7 | |||||||||||||
12855 | 12855 | Justin Whiting W000415 | rep | MI | 1889-12-02 | 1891-03-03 | Democrat | 7 | |||||||||||||
12856 | 12856 | Justin Whiting W000415 | rep | MI | 1891-12-07 | 1893-03-03 | Democrat | 7 | |||||||||||||
12857 | 12857 | Justin Whiting W000415 | rep | MI | 1893-08-07 | 1895-03-03 | Democrat | 7 | |||||||||||||
13269 | 13269 | Ferdinand Brucker B000973 | rep | MI | 1897-03-15 | 1899-03-03 | Democrat | 8 | |||||||||||||
13506 | 13506 | Albert Todd T000291 | rep | MI | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
14388 | 14388 | Alfred Lucking L000500 | rep | MI | 1903-11-09 | 1905-03-03 | Democrat | 1 | |||||||||||||
16207 | 16207 | Edwin Sweet S001107 | rep | MI | 1911-04-04 | 1913-03-03 | Democrat | 5 | |||||||||||||
17070 | 17070 | Samuel Beakes B000264 | rep | MI | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
17071 | 17071 | Samuel Beakes B000264 | rep | MI | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
17072 | 17072 | Samuel Beakes B000264 | rep | MI | 1917-04-02 | 1919-03-03 | Democrat | 2 | |||||||||||||
17651 | 17651 | Frank Doremus D000431 | rep | MI | 1911-04-04 | 1913-03-03 | Democrat | 1 | |||||||||||||
17652 | 17652 | Frank Doremus D000431 | rep | MI | 1913-04-07 | 1915-03-03 | Democrat | 1 | |||||||||||||
17653 | 17653 | Frank Doremus D000431 | rep | MI | 1915-12-06 | 1917-03-03 | Democrat | 1 | |||||||||||||
17654 | 17654 | Frank Doremus D000431 | rep | MI | 1917-04-02 | 1919-03-03 | Democrat | 1 | |||||||||||||
17655 | 17655 | Frank Doremus D000431 | rep | MI | 1919-05-19 | 1921-03-03 | Democrat | 1 | |||||||||||||
18640 | 18640 | Woodbridge Ferris F000092 | sen | MI | 1923-12-03 | 1928-03-23 | 1 | Democrat | |||||||||||||
20200 | 20200 | Robert Clancy C000412 | rep | MI | 1923-12-03 | 1925-03-03 | Democrat | 1 | |||||||||||||
21185 | 21185 | Claude Cady C000013 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
21269 | 21269 | George Foulkes F000317 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
21305 | 21305 | Michael Hart H000290 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
21372 | 21372 | John Lehr L000228 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
21447 | 21447 | Harry Musselwhite M001122 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
21597 | 21597 | Carl Weideman W000254 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 14 | |||||||||||||
22011 | 22011 | Prentiss Brown B000941 | rep | MI | 1933-03-09 | 1935-01-03 | Democrat | 11 | |||||||||||||
22012 | 22012 | Prentiss Brown B000941 | rep | MI | 1935-01-03 | 1936-11-18 | Democrat | 11 |
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);