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)
party 5 ✖
- Republican 486
- Democrat 240
- Progressive 24
- Socialist 5
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10592 | 10592 | Charles Williams W000492 | rep | WI | 1879-03-18 | 1881-03-03 | Republican | 1 | |||||||||||||
10593 | 10593 | Charles Williams W000492 | rep | WI | 1881-12-05 | 1883-03-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
11158 | 11158 | Hugh Price P000526 | rep | WI | 1885-12-07 | 1887-03-03 | Republican | 8 | |||||||||||||
11159 | 11159 | William Price P000534 | rep | WI | 1883-12-03 | 1885-03-03 | Republican | 8 | |||||||||||||
11160 | 11160 | William Price P000534 | rep | WI | 1885-12-07 | 1887-03-03 | Republican | 8 | |||||||||||||
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 | |||||||||||||
11383 | 11383 | Richard Guenther G000516 | rep | WI | 1881-12-05 | 1883-03-03 | Republican | 6 | |||||||||||||
11384 | 11384 | Richard Guenther G000516 | rep | WI | 1883-12-03 | 1885-03-03 | Republican | 6 | |||||||||||||
11385 | 11385 | Richard Guenther G000516 | rep | WI | 1885-12-07 | 1887-03-03 | Republican | 6 | |||||||||||||
11386 | 11386 | Richard Guenther G000516 | rep | WI | 1887-12-05 | 1889-03-03 | Republican | 2 | |||||||||||||
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 | |||||||||||||
11498 | 11498 | Philetus Sawyer S000091 | rep | WI | 1865-12-04 | 1867-03-03 | Republican | 5 | |||||||||||||
11499 | 11499 | Philetus Sawyer S000091 | rep | WI | 1867-03-04 | 1869-03-03 | Republican | 5 | |||||||||||||
11500 | 11500 | Philetus Sawyer S000091 | rep | WI | 1869-03-04 | 1871-03-03 | Republican | 5 | |||||||||||||
11501 | 11501 | Philetus Sawyer S000091 | rep | WI | 1871-03-04 | 1873-03-03 | Republican | 5 | |||||||||||||
11502 | 11502 | Philetus Sawyer S000091 | rep | WI | 1873-12-01 | 1875-03-03 | Republican | 6 | |||||||||||||
11503 | 11503 | Philetus Sawyer S000091 | sen | WI | 1881-12-05 | 1887-03-03 | 1 | Republican | |||||||||||||
11504 | 11504 | Philetus Sawyer S000091 | sen | WI | 1887-12-05 | 1893-03-03 | 1 | Republican | |||||||||||||
11510 | 11510 | Henry Smith S000546 | rep | WI | 1887-12-05 | 1889-03-03 | Union | 4 | |||||||||||||
11657 | 11657 | Lucien Caswell C000245 | rep | WI | 1875-12-06 | 1877-03-03 | Republican | 2 | |||||||||||||
11658 | 11658 | Lucien Caswell C000245 | rep | WI | 1877-10-15 | 1879-03-03 | Republican | 2 | |||||||||||||
11659 | 11659 | Lucien Caswell C000245 | rep | WI | 1879-03-18 | 1881-03-03 | Republican | 2 | |||||||||||||
11660 | 11660 | Lucien Caswell C000245 | rep | WI | 1881-12-05 | 1883-03-03 | Republican | 2 | |||||||||||||
11661 | 11661 | Lucien Caswell C000245 | rep | WI | 1885-12-07 | 1887-03-03 | Republican | 1 | |||||||||||||
11662 | 11662 | Lucien Caswell C000245 | rep | WI | 1887-12-05 | 1889-03-03 | Republican | 1 | |||||||||||||
11663 | 11663 | Lucien Caswell C000245 | rep | WI | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
11666 | 11666 | Charles Clark C000422 | rep | WI | 1887-12-05 | 1889-03-03 | Republican | 6 | |||||||||||||
11667 | 11667 | Charles Clark C000422 | rep | WI | 1889-12-02 | 1891-03-03 | Republican | 6 | |||||||||||||
11846 | 11846 | Myron McCord M000361 | rep | WI | 1889-12-02 | 1891-03-03 | Republican | 9 | |||||||||||||
11980 | 11980 | Ormsby Thomas T000180 | rep | WI | 1885-12-07 | 1887-03-03 | Republican | 7 | |||||||||||||
11981 | 11981 | Ormsby Thomas T000180 | rep | WI | 1887-12-05 | 1889-03-03 | Republican | 7 | |||||||||||||
11982 | 11982 | Ormsby Thomas T000180 | rep | WI | 1889-12-02 | 1891-03-03 | Republican | 7 | |||||||||||||
11997 | 11997 | Isaac Van Schaick V000058 | rep | WI | 1885-12-07 | 1887-03-03 | Republican | 4 | |||||||||||||
11998 | 11998 | Isaac Van Schaick V000058 | rep | WI | 1889-12-02 | 1891-03-03 | Republican | 4 | |||||||||||||
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 | |||||||||||||
12605 | 12605 | Nils Haugen H000351 | rep | WI | 1887-12-05 | 1889-03-03 | Republican | 8 | |||||||||||||
12606 | 12606 | Nils Haugen H000351 | rep | WI | 1889-12-02 | 1891-03-03 | Republican | 8 | |||||||||||||
12607 | 12607 | Nils Haugen H000351 | rep | WI | 1891-12-07 | 1893-03-03 | Republican | 8 | |||||||||||||
12608 | 12608 | Nils Haugen H000351 | rep | WI | 1893-08-07 | 1895-03-03 | Republican | 10 | |||||||||||||
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 | |||||||||||||
12773 | 12773 | George Shaw S000305 | rep | WI | 1893-08-07 | 1895-03-03 | Republican | 7 | |||||||||||||
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 | |||||||||||||
12961 | 12961 | Samuel Cook C000726 | rep | WI | 1895-12-02 | 1897-03-03 | Republican | 6 | |||||||||||||
13309 | 13309 | Michael Griffin G000464 | rep | WI | 1893-08-07 | 1895-03-03 | Republican | 7 | |||||||||||||
13310 | 13310 | Michael Griffin G000464 | rep | WI | 1895-12-02 | 1897-03-03 | Republican | 7 | |||||||||||||
13311 | 13311 | Michael Griffin G000464 | rep | WI | 1897-03-15 | 1899-03-03 | Republican | 7 | |||||||||||||
13463 | 13463 | Edward Sauerhering S000071 | rep | WI | 1895-12-02 | 1897-03-03 | Republican | 2 | |||||||||||||
13464 | 13464 | Edward Sauerhering S000071 | rep | WI | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
13769 | 13769 | Joseph Quarles Q000003 | sen | WI | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
13798 | 13798 | Alexander Stewart S000898 | rep | WI | 1895-12-02 | 1897-03-03 | Republican | 9 | |||||||||||||
13799 | 13799 | Alexander Stewart S000898 | rep | WI | 1897-03-15 | 1899-03-03 | Republican | 9 | |||||||||||||
13800 | 13800 | Alexander Stewart S000898 | rep | WI | 1899-12-04 | 1901-03-03 | Republican | 9 | |||||||||||||
13846 | 13846 | Samuel Barney B000163 | rep | WI | 1895-12-02 | 1897-03-03 | Republican | 5 | |||||||||||||
13847 | 13847 | Samuel Barney B000163 | rep | WI | 1897-03-15 | 1899-03-03 | Republican | 5 | |||||||||||||
13848 | 13848 | Samuel Barney B000163 | rep | WI | 1899-12-04 | 1901-03-03 | Republican | 5 | |||||||||||||
13849 | 13849 | Samuel Barney B000163 | rep | WI | 1901-12-02 | 1903-03-03 | Republican | 5 | |||||||||||||
13930 | 13930 | Herman Dahle D000005 | rep | WI | 1899-12-04 | 1901-03-03 | Republican | 2 | |||||||||||||
13931 | 13931 | Herman Dahle D000005 | rep | WI | 1901-12-02 | 1903-03-03 | Republican | 2 | |||||||||||||
14483 | 14483 | John Spooner S000741 | sen | WI | 1885-12-07 | 1891-03-03 | 3 | Republican | |||||||||||||
14484 | 14484 | John Spooner S000741 | sen | WI | 1897-03-15 | 1903-03-03 | 3 | Republican | |||||||||||||
14485 | 14485 | John Spooner S000741 | sen | WI | 1903-11-09 | 1907-12-31 | 3 | Republican | |||||||||||||
14546 | 14546 | Henry Adams A000037 | rep | WI | 1903-11-09 | 1905-03-03 | Republican | 2 | |||||||||||||
14547 | 14547 | Henry Adams A000037 | rep | WI | 1905-12-04 | 1907-03-03 | Republican | 2 | |||||||||||||
14563 | 14563 | Joseph Babcock B000004 | rep | WI | 1893-08-07 | 1895-03-03 | Republican | 3 | |||||||||||||
14564 | 14564 | Joseph Babcock B000004 | rep | WI | 1895-12-02 | 1897-03-03 | Republican | 3 | |||||||||||||
14565 | 14565 | Joseph Babcock B000004 | rep | WI | 1897-03-15 | 1899-03-03 | Republican | 3 | |||||||||||||
14566 | 14566 | Joseph Babcock B000004 | rep | WI | 1899-12-04 | 1901-03-03 | Republican | 3 | |||||||||||||
14567 | 14567 | Joseph Babcock B000004 | rep | WI | 1901-12-02 | 1903-03-03 | Republican | 3 | |||||||||||||
14568 | 14568 | Joseph Babcock B000004 | rep | WI | 1903-11-09 | 1905-03-03 | Republican | 3 | |||||||||||||
14569 | 14569 | Joseph Babcock B000004 | rep | WI | 1905-12-04 | 1907-03-03 | Republican | 3 | |||||||||||||
14593 | 14593 | Webster Brown B000946 | rep | WI | 1901-12-02 | 1903-03-03 | Republican | 9 | |||||||||||||
14594 | 14594 | Webster Brown B000946 | rep | WI | 1903-11-09 | 1905-03-03 | Republican | 10 |
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);