legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
543 rows where party = "Republican" and state = "WI"
This data as json, copyable, CSV (advanced)
Suggested facets: class, district, url, phone, fax, office, rss_url, start (date), end (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6808 | 6808 | Charles Durkee D000573 | sen | WI | 1855-12-03 | 1861-03-03 | 3 | Republican | |||||||||||||
6982 | 6982 | Charles Billinghurst B000464 | rep | WI | 1857-12-07 | 1859-03-03 | Republican | 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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
12773 | 12773 | George Shaw S000305 | rep | WI | 1893-08-07 | 1895-03-03 | Republican | 7 | |||||||||||||
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 |
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);