legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
856 rows where state = "WI" sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: class, phone, fax, contact_form, state_rank, rss_url, start (date), end (date)
party 9 ✖
- Republican 543
- Democrat 275
- Progressive 24
- Socialist 5
- Free Soil 2
- Ind. Republican-Democrat 2
- Whig 2
- Ind. Democrat 1
- Union 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6414 | 6414 | Henry Sibley S000396 | rep | WI | 1847-12-06 | 1849-03-03 | -1 | ||||||||||||||
5473 | 5473 | Morgan Martin M000196 | rep | WI | 1845-12-01 | 1847-03-03 | Democrat | -1 | |||||||||||||
5662 | 5662 | Mason Darling D000054 | rep | WI | 1847-12-06 | 1849-03-03 | Democrat | -1 | |||||||||||||
5887 | 5887 | Isaac Walker W000055 | sen | WI | 1848-06-08 | 1849-03-03 | 3 | Democrat | |||||||||||||
5888 | 5888 | Isaac Walker W000055 | sen | WI | 1849-03-05 | 1855-03-03 | 3 | Democrat | |||||||||||||
6276 | 6276 | Henry Dodge D000396 | rep | WI | 1841-05-31 | 1843-03-03 | Democrat | -1 | |||||||||||||
6277 | 6277 | Henry Dodge D000396 | rep | WI | 1843-12-04 | 1845-03-03 | Democrat | -1 | |||||||||||||
6278 | 6278 | Henry Dodge D000396 | sen | WI | 1848-01-01 | 1851-03-03 | 1 | Democrat | |||||||||||||
6279 | 6279 | Henry Dodge D000396 | sen | WI | 1851-12-01 | 1857-03-03 | 1 | Democrat | |||||||||||||
6280 | 6280 | James Doty D000443 | rep | WI | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
6281 | 6281 | James Doty D000443 | rep | WI | 1839-12-02 | 1841-03-03 | Democrat | -1 | |||||||||||||
6282 | 6282 | James Doty D000443 | rep | WI | 1849-12-03 | 1851-03-03 | Democrat | 3 | |||||||||||||
6574 | 6574 | Ben Eastman E000019 | rep | WI | 1851-12-01 | 1853-03-03 | Democrat | 2 | |||||||||||||
6575 | 6575 | Ben Eastman E000019 | rep | WI | 1853-12-05 | 1855-03-03 | Democrat | 2 | |||||||||||||
6630 | 6630 | George Jones J000221 | rep | WI | 1837-09-04 | 1839-03-03 | Democrat | -1 | |||||||||||||
6646 | 6646 | John Macy M000036 | rep | WI | 1853-12-05 | 1855-03-03 | Democrat | 3 | |||||||||||||
6945 | 6945 | Daniel Wells W000281 | rep | WI | 1853-12-05 | 1855-03-03 | Democrat | 1 | |||||||||||||
6946 | 6946 | Daniel Wells W000281 | rep | WI | 1855-12-03 | 1857-03-03 | Democrat | 1 | |||||||||||||
7480 | 7480 | Charles Larrabee L000099 | rep | WI | 1859-12-05 | 1861-03-03 | Democrat | 3 | |||||||||||||
7922 | 7922 | James Brown B000922 | rep | WI | 1863-12-07 | 1865-03-03 | Democrat | 1 | |||||||||||||
8058 | 8058 | Ezra Wheeler W000332 | rep | WI | 1863-12-07 | 1865-03-03 | Democrat | 5 | |||||||||||||
9159 | 9159 | Charles Eldredge E000103 | rep | WI | 1863-12-07 | 1865-03-03 | Democrat | 4 | |||||||||||||
9160 | 9160 | Charles Eldredge E000103 | rep | WI | 1865-12-04 | 1867-03-03 | Democrat | 4 | |||||||||||||
9161 | 9161 | Charles Eldredge E000103 | rep | WI | 1867-03-04 | 1869-03-03 | Democrat | 4 | |||||||||||||
9162 | 9162 | Charles Eldredge E000103 | rep | WI | 1869-03-04 | 1871-03-03 | Democrat | 4 | |||||||||||||
9163 | 9163 | Charles Eldredge E000103 | rep | WI | 1871-03-04 | 1873-03-03 | Democrat | 4 | |||||||||||||
9164 | 9164 | Charles Eldredge E000103 | rep | WI | 1873-12-01 | 1875-03-03 | Democrat | 5 | |||||||||||||
9276 | 9276 | Alexander Mitchell M000802 | rep | WI | 1871-03-04 | 1873-03-03 | Democrat | 1 | |||||||||||||
9277 | 9277 | Alexander Mitchell M000802 | rep | WI | 1873-12-01 | 1875-03-03 | Democrat | 4 | |||||||||||||
9470 | 9470 | Samuel Burchard B001071 | rep | WI | 1875-12-06 | 1877-03-03 | Democrat | 5 | |||||||||||||
9482 | 9482 | George Cate C000248 | rep | WI | 1875-12-06 | 1877-03-03 | Democrat | 8 | |||||||||||||
9881 | 9881 | William Lynde L000538 | rep | WI | 1847-12-06 | 1849-03-03 | Democrat | -1 | |||||||||||||
9882 | 9882 | William Lynde L000538 | rep | WI | 1875-12-06 | 1877-03-03 | Democrat | 4 | |||||||||||||
9883 | 9883 | William Lynde L000538 | rep | WI | 1877-10-15 | 1879-03-03 | Democrat | 4 | |||||||||||||
10014 | 10014 | Gabriel Bouck B000658 | rep | WI | 1877-10-15 | 1879-03-03 | Democrat | 6 | |||||||||||||
10015 | 10015 | Gabriel Bouck B000658 | rep | WI | 1879-03-18 | 1881-03-03 | Democrat | 6 | |||||||||||||
10694 | 10694 | Peter Deuster D000274 | rep | WI | 1879-03-18 | 1881-03-03 | Democrat | 4 | |||||||||||||
10695 | 10695 | Peter Deuster D000274 | rep | WI | 1881-12-05 | 1883-03-03 | Democrat | 4 | |||||||||||||
10696 | 10696 | Peter Deuster D000274 | rep | WI | 1883-12-03 | 1885-03-03 | Democrat | 4 | |||||||||||||
10771 | 10771 | Burr Jones J000213 | rep | WI | 1883-12-03 | 1885-03-03 | Democrat | 3 | |||||||||||||
10906 | 10906 | Daniel Sumner S001070 | rep | WI | 1883-12-03 | 1885-03-03 | Democrat | 2 | |||||||||||||
10939 | 10939 | John Winans W000627 | rep | WI | 1883-12-03 | 1885-03-03 | Democrat | 1 | |||||||||||||
10942 | 10942 | Gilbert Woodward W000731 | rep | WI | 1883-12-03 | 1885-03-03 | Democrat | 7 | |||||||||||||
10974 | 10974 | Edward Bragg B000757 | rep | WI | 1877-10-15 | 1879-03-03 | Democrat | 5 | |||||||||||||
10975 | 10975 | Edward Bragg B000757 | rep | WI | 1879-03-18 | 1881-03-03 | Democrat | 5 | |||||||||||||
10976 | 10976 | Edward Bragg B000757 | rep | WI | 1881-12-05 | 1883-03-03 | Democrat | 5 | |||||||||||||
10977 | 10977 | Edward Bragg B000757 | rep | WI | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
11162 | 11162 | Joseph Rankin R000057 | rep | WI | 1883-12-03 | 1885-03-03 | Democrat | 5 | |||||||||||||
11163 | 11163 | Joseph Rankin R000057 | rep | WI | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11411 | 11411 | Thomas Hudd H000902 | rep | WI | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11412 | 11412 | Thomas Hudd H000902 | rep | WI | 1887-12-05 | 1889-03-03 | Democrat | 5 | |||||||||||||
12075 | 12075 | Clinton Babbitt B000001 | rep | WI | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12113 | 12113 | Allen Bushnell B001170 | rep | WI | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12137 | 12137 | Frank Coburn C000557 | rep | WI | 1891-12-07 | 1893-03-03 | Democrat | 7 | |||||||||||||
12244 | 12244 | Lucas Miller M000746 | rep | WI | 1891-12-07 | 1893-03-03 | Democrat | 6 | |||||||||||||
12344 | 12344 | William Vilas V000099 | sen | WI | 1891-12-07 | 1897-03-03 | 3 | Democrat | |||||||||||||
12403 | 12403 | Lyman Barnes B000159 | rep | WI | 1893-08-07 | 1895-03-03 | Democrat | 8 | |||||||||||||
12404 | 12404 | Charles Barwig B000218 | rep | WI | 1889-12-02 | 1891-03-03 | Democrat | 2 | |||||||||||||
12405 | 12405 | Charles Barwig B000218 | rep | WI | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12406 | 12406 | Charles Barwig B000218 | rep | WI | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
12438 | 12438 | George Brickner B000821 | rep | WI | 1889-12-02 | 1891-03-03 | Democrat | 5 | |||||||||||||
12439 | 12439 | George Brickner B000821 | rep | WI | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
12440 | 12440 | George Brickner B000821 | rep | WI | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
12671 | 12671 | Thomas Lynch L000534 | rep | WI | 1891-12-07 | 1893-03-03 | Democrat | 9 | |||||||||||||
12672 | 12672 | Thomas Lynch L000534 | rep | WI | 1893-08-07 | 1895-03-03 | Democrat | 9 | |||||||||||||
12690 | 12690 | John Mitchell M000821 | rep | WI | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
12691 | 12691 | John Mitchell M000821 | sen | WI | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12793 | 12793 | Peter Somers S000677 | rep | WI | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
12848 | 12848 | Owen Wells W000286 | rep | WI | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
15236 | 15236 | James Murphy M001095 | rep | WI | 1907-12-02 | 1909-03-03 | Democrat | 3 | |||||||||||||
15814 | 15814 | Charles Weisse W000259 | rep | WI | 1903-11-09 | 1905-03-03 | Democrat | 6 | |||||||||||||
15815 | 15815 | Charles Weisse W000259 | rep | WI | 1905-12-04 | 1907-03-03 | Democrat | 6 | |||||||||||||
15816 | 15816 | Charles Weisse W000259 | rep | WI | 1907-12-02 | 1909-03-03 | Democrat | 6 | |||||||||||||
15817 | 15817 | Charles Weisse W000259 | rep | WI | 1909-03-15 | 1911-03-03 | Democrat | 6 | |||||||||||||
16720 | 16720 | Michael Burke B001095 | rep | WI | 1911-04-04 | 1913-03-03 | Democrat | 6 | |||||||||||||
16721 | 16721 | Michael Burke B001095 | rep | WI | 1913-04-07 | 1915-03-03 | Democrat | 2 | |||||||||||||
16722 | 16722 | Michael Burke B001095 | rep | WI | 1915-12-06 | 1917-03-03 | Democrat | 2 | |||||||||||||
16823 | 16823 | Paul Husting H001006 | sen | WI | 1915-12-06 | 1917-12-31 | 3 | Democrat | |||||||||||||
16838 | 16838 | Thomas Konop K000310 | rep | WI | 1911-04-04 | 1913-03-03 | Democrat | 9 | |||||||||||||
16839 | 16839 | Thomas Konop K000310 | rep | WI | 1913-04-07 | 1915-03-03 | Democrat | 9 | |||||||||||||
16840 | 16840 | Thomas Konop K000310 | rep | WI | 1915-12-06 | 1917-03-03 | Democrat | 9 | |||||||||||||
21241 | 21241 | Francis Duffy D000518 | sen | WI | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
21315 | 21315 | Charles Henney H000501 | rep | WI | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
21330 | 21330 | James Hughes H000925 | rep | WI | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
22086 | 22086 | Raymond Cannon C000124 | rep | WI | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
22087 | 22087 | Raymond Cannon C000124 | rep | WI | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
22088 | 22088 | Raymond Cannon C000124 | rep | WI | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
22352 | 22352 | Thomas O’Malley O000087 | rep | WI | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
22353 | 22353 | Thomas O’Malley O000087 | rep | WI | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
22354 | 22354 | Thomas O’Malley O000087 | rep | WI | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
22376 | 22376 | Michael Reilly R000155 | rep | WI | 1913-04-07 | 1915-03-03 | Democrat | 6 | |||||||||||||
22377 | 22377 | Michael Reilly R000155 | rep | WI | 1915-12-06 | 1917-03-03 | Democrat | 6 | |||||||||||||
22378 | 22378 | Michael Reilly R000155 | rep | WI | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
22379 | 22379 | Michael Reilly R000155 | rep | WI | 1931-12-07 | 1933-03-03 | Democrat | 6 | |||||||||||||
22380 | 22380 | Michael Reilly R000155 | rep | WI | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
22381 | 22381 | Michael Reilly R000155 | rep | WI | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
22382 | 22382 | Michael Reilly R000155 | rep | WI | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
23411 | 23411 | LaVern Dilweg D000349 | rep | WI | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
23604 | 23604 | Howard McMurray M000579 | rep | WI | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
24183 | 24183 | Thaddeus Wasielewski W000183 | rep | WI | 1941-01-03 | 1943-01-03 | Democrat | 4 |
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);