legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
856 rows where state = "WI"
This data as json, copyable, CSV (advanced)
Suggested facets: class, district, fax, contact_form, state_rank, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
5847 | 5847 | John Tweedy T000441 | rep | WI | 1847-12-06 | 1849-03-03 | Whig | -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 | |||||||||||||
5941 | 5941 | Orsamus Cole C000611 | rep | WI | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
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 | |||||||||||||
6283 | 6283 | James Doty D000443 | rep | WI | 1851-12-01 | 1853-03-03 | Ind. Democrat | 3 | |||||||||||||
6414 | 6414 | Henry Sibley S000396 | rep | WI | 1847-12-06 | 1849-03-03 | -1 | ||||||||||||||
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 | |||||||||||||
6806 | 6806 | Charles Durkee D000573 | rep | WI | 1849-12-03 | 1851-03-03 | Free Soil | 1 | |||||||||||||
6807 | 6807 | Charles Durkee D000573 | rep | WI | 1851-12-01 | 1853-03-03 | Free Soil | 1 | |||||||||||||
6808 | 6808 | Charles Durkee D000573 | sen | WI | 1855-12-03 | 1861-03-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
6981 | 6981 | Charles Billinghurst B000464 | rep | WI | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 3 | |||||||||||||
6982 | 6982 | Charles Billinghurst B000464 | rep | WI | 1857-12-07 | 1859-03-03 | Republican | 3 | |||||||||||||
7480 | 7480 | Charles Larrabee L000099 | rep | WI | 1859-12-05 | 1861-03-03 | Democrat | 3 | |||||||||||||
7761 | 7761 | Luther Hanchett H000145 | rep | WI | 1861-07-04 | 1863-03-03 | Republican | 2 | |||||||||||||
7839 | 7839 | John Potter P000465 | rep | WI | 1857-12-07 | 1859-03-03 | Republican | 1 | |||||||||||||
7840 | 7840 | John Potter P000465 | rep | WI | 1859-12-05 | 1861-03-03 | Republican | 1 | |||||||||||||
7841 | 7841 | John Potter P000465 | rep | WI | 1861-07-04 | 1863-03-03 | Republican | 1 | |||||||||||||
7851 | 7851 | Andrew Sloan S000490 | rep | WI | 1861-07-04 | 1863-03-03 | Republican | 3 | |||||||||||||
7922 | 7922 | James Brown B000922 | rep | WI | 1863-12-07 | 1865-03-03 | Democrat | 1 | |||||||||||||
7948 | 7948 | James Doolittle D000428 | sen | WI | 1857-12-07 | 1863-03-03 | 1 | Republican | |||||||||||||
7949 | 7949 | James Doolittle D000428 | sen | WI | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
8058 | 8058 | Ezra Wheeler W000332 | rep | WI | 1863-12-07 | 1865-03-03 | Democrat | 5 | |||||||||||||
8171 | 8171 | Walter McIndoe M000476 | rep | WI | 1861-07-04 | 1863-03-03 | Republican | 2 | |||||||||||||
8172 | 8172 | Walter McIndoe M000476 | rep | WI | 1863-12-07 | 1865-03-03 | Republican | 6 | |||||||||||||
8173 | 8173 | Walter McIndoe M000476 | rep | WI | 1865-12-04 | 1867-03-03 | Republican | 6 | |||||||||||||
8202 | 8202 | Ithamar Sloan S000492 | rep | WI | 1863-12-07 | 1865-03-03 | Republican | 2 | |||||||||||||
8203 | 8203 | Ithamar Sloan S000492 | rep | WI | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8508 | 8508 | David Atwood A000335 | rep | WI | 1869-03-04 | 1871-03-03 | Republican | 2 | |||||||||||||
8557 | 8557 | Amasa Cobb C000543 | rep | WI | 1863-12-07 | 1865-03-03 | Republican | 3 | |||||||||||||
8558 | 8558 | Amasa Cobb C000543 | rep | WI | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8559 | 8559 | Amasa Cobb C000543 | rep | WI | 1867-03-04 | 1869-03-03 | Republican | 3 | |||||||||||||
8560 | 8560 | Amasa Cobb C000543 | rep | WI | 1869-03-04 | 1871-03-03 | Republican | 3 | |||||||||||||
8628 | 8628 | Benjamin Hopkins H000771 | rep | WI | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8629 | 8629 | Benjamin Hopkins H000771 | rep | WI | 1869-03-04 | 1871-03-03 | Republican | 2 | |||||||||||||
8685 | 8685 | Halbert Paine P000028 | rep | WI | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8686 | 8686 | Halbert Paine P000028 | rep | WI | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8687 | 8687 | Halbert Paine P000028 | rep | WI | 1869-03-04 | 1871-03-03 | Republican | 1 | |||||||||||||
8762 | 8762 | Cadwallader Washburn W000170 | rep | WI | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 2 | |||||||||||||
8763 | 8763 | Cadwallader Washburn W000170 | rep | WI | 1857-12-07 | 1859-03-03 | Republican | 2 | |||||||||||||
8764 | 8764 | Cadwallader Washburn W000170 | rep | WI | 1859-12-05 | 1861-03-03 | Republican | 2 | |||||||||||||
8765 | 8765 | Cadwallader Washburn W000170 | rep | WI | 1867-03-04 | 1869-03-03 | Republican | 6 | |||||||||||||
8766 | 8766 | Cadwallader Washburn W000170 | rep | WI | 1869-03-04 | 1871-03-03 | Republican | 6 | |||||||||||||
9083 | 9083 | Joel Barber B000122 | rep | WI | 1871-03-04 | 1873-03-03 | Republican | 3 | |||||||||||||
9084 | 9084 | Joel Barber B000122 | rep | WI | 1873-12-01 | 1875-03-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
9194 | 9194 | Gerry Hazelton H000419 | rep | WI | 1871-03-04 | 1873-03-03 | Republican | 2 | |||||||||||||
9195 | 9195 | Gerry Hazelton H000419 | rep | WI | 1873-12-01 | 1875-03-03 | Republican | 2 | |||||||||||||
9212 | 9212 | Timothy Howe H000856 | sen | WI | 1861-07-04 | 1867-03-03 | 3 | Republican | |||||||||||||
9213 | 9213 | Timothy Howe H000856 | sen | WI | 1867-03-04 | 1873-03-03 | 3 | Republican | |||||||||||||
9214 | 9214 | Timothy Howe H000856 | sen | WI | 1873-12-01 | 1879-03-03 | 3 | Republican | |||||||||||||
9262 | 9262 | Alexander McDill M000406 | rep | WI | 1873-12-01 | 1875-03-03 | Republican | 8 | |||||||||||||
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 | |||||||||||||
9560 | 9560 | Alanson Kimball K000182 | rep | WI | 1875-12-06 | 1877-03-03 | Republican | 6 | |||||||||||||
9576 | 9576 | Henry Magoon M000054 | rep | WI | 1875-12-06 | 1877-03-03 | Republican | 3 | |||||||||||||
9625 | 9625 | Jeremiah Rusk R000517 | rep | WI | 1871-03-04 | 1873-03-03 | Republican | 6 | |||||||||||||
9626 | 9626 | Jeremiah Rusk R000517 | rep | WI | 1873-12-01 | 1875-03-03 | Republican | 7 | |||||||||||||
9627 | 9627 | Jeremiah Rusk R000517 | rep | WI | 1875-12-06 | 1877-03-03 | Republican | 7 | |||||||||||||
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 | |||||||||||||
10025 | 10025 | Matthew Carpenter C000171 | sen | WI | 1869-03-04 | 1875-03-03 | 1 | Republican | |||||||||||||
10026 | 10026 | Matthew Carpenter C000171 | sen | WI | 1879-03-18 | 1881-12-31 | 3 | Republican | |||||||||||||
10279 | 10279 | Angus Cameron C000064 | sen | WI | 1875-12-06 | 1881-03-03 | 1 | Republican | |||||||||||||
10280 | 10280 | Angus Cameron C000064 | sen | WI | 1881-12-05 | 1885-03-03 | 3 | Republican | |||||||||||||
10378 | 10378 | George Hazelton H000418 | rep | WI | 1877-10-15 | 1879-03-03 | Republican | 3 | |||||||||||||
10379 | 10379 | George Hazelton H000418 | rep | WI | 1879-03-18 | 1881-03-03 | Republican | 3 | |||||||||||||
10380 | 10380 | George Hazelton H000418 | rep | WI | 1881-12-05 | 1883-03-03 | Republican | 3 | |||||||||||||
10398 | 10398 | Herman Humphrey H000952 | rep | WI | 1877-10-15 | 1879-03-03 | Republican | 7 | |||||||||||||
10399 | 10399 | Herman Humphrey H000952 | rep | WI | 1879-03-18 | 1881-03-03 | Republican | 7 | |||||||||||||
10400 | 10400 | Herman Humphrey H000952 | rep | WI | 1881-12-05 | 1883-03-03 | Republican | 7 | |||||||||||||
10507 | 10507 | Thaddeus Pound P000476 | rep | WI | 1877-10-15 | 1879-03-03 | Republican | 8 | |||||||||||||
10508 | 10508 | Thaddeus Pound P000476 | rep | WI | 1879-03-18 | 1881-03-03 | Republican | 8 | |||||||||||||
10509 | 10509 | Thaddeus Pound P000476 | rep | WI | 1881-12-05 | 1883-03-03 | Republican | 8 | |||||||||||||
10589 | 10589 | Charles Williams W000492 | rep | WI | 1873-12-01 | 1875-03-03 | Republican | 1 | |||||||||||||
10590 | 10590 | Charles Williams W000492 | rep | WI | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
10591 | 10591 | Charles Williams W000492 | rep | WI | 1877-10-15 | 1879-03-03 | Republican | 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);