legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
499 rows where state = "WA"
This data as json, copyable, CSV (advanced)
Suggested facets: district, fax, contact_form, state_rank, rss_url, end (date)
party 4 ✖
- Democrat 259
- Republican 237
- Progressive 2
- Silver Republican 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6639 | 6639 | Columbia Lancaster L000044 | rep | WA | 1853-12-05 | 1855-03-03 | Democrat | -1 | |||||||||||||
6757 | 6757 | James Anderson A000192 | rep | WA | 1855-12-03 | 1857-03-03 | Democrat | -1 | |||||||||||||
7586 | 7586 | Isaac Stevens S000881 | rep | WA | 1857-12-07 | 1859-03-03 | Democrat | -1 | |||||||||||||
7587 | 7587 | Isaac Stevens S000881 | rep | WA | 1859-12-05 | 1861-03-03 | Democrat | -1 | |||||||||||||
7930 | 7930 | George Cole C000609 | rep | WA | 1863-12-07 | 1865-03-03 | Democrat | -1 | |||||||||||||
8056 | 8056 | William Wallace W000086 | rep | WA | 1861-07-04 | 1863-03-03 | Republican | -1 | |||||||||||||
8109 | 8109 | Arthur Denny D000247 | rep | WA | 1865-12-04 | 1867-03-03 | Republican | -1 | |||||||||||||
8333 | 8333 | Alvan Flanders F000188 | rep | WA | 1867-03-04 | 1869-03-03 | Republican | -1 | |||||||||||||
8905 | 8905 | Selucius Garfielde G000064 | rep | WA | 1869-03-04 | 1871-03-03 | Republican | -1 | |||||||||||||
8906 | 8906 | Selucius Garfielde G000064 | rep | WA | 1871-03-04 | 1873-03-03 | Republican | -1 | |||||||||||||
9263 | 9263 | Obadiah McFadden M000435 | rep | WA | 1873-12-01 | 1875-03-03 | Democrat | -1 | |||||||||||||
9858 | 9858 | Orange Jacobs J000037 | rep | WA | 1875-12-06 | 1877-03-03 | Republican | -1 | |||||||||||||
9859 | 9859 | Orange Jacobs J000037 | rep | WA | 1877-10-15 | 1879-03-03 | Republican | -1 | |||||||||||||
10646 | 10646 | Thomas Brents B000806 | rep | WA | 1879-03-18 | 1881-03-03 | Republican | -1 | |||||||||||||
10647 | 10647 | Thomas Brents B000806 | rep | WA | 1881-12-05 | 1883-03-03 | Republican | -1 | |||||||||||||
10648 | 10648 | Thomas Brents B000806 | rep | WA | 1883-12-03 | 1885-03-03 | Republican | -1 | |||||||||||||
11532 | 11532 | Charles Voorhees V000115 | rep | WA | 1885-12-07 | 1887-03-03 | Democrat | -1 | |||||||||||||
11533 | 11533 | Charles Voorhees V000115 | rep | WA | 1887-12-05 | 1889-03-03 | Democrat | -1 | |||||||||||||
11561 | 11561 | John Allen A000130 | rep | WA | 1889-03-04 | 1889-11-11 | Republican | -1 | |||||||||||||
11562 | 11562 | John Allen A000130 | sen | WA | 1889-11-19 | 1893-03-03 | 1 | Republican | |||||||||||||
12295 | 12295 | Watson Squire S000761 | sen | WA | 1889-12-02 | 1891-03-03 | 3 | Republican | |||||||||||||
12296 | 12296 | Watson Squire S000761 | sen | WA | 1891-12-07 | 1897-03-03 | 3 | Republican | |||||||||||||
12998 | 12998 | William Doolittle D000430 | rep | WA | 1893-08-07 | 1895-03-03 | Republican | -1 | |||||||||||||
12999 | 12999 | William Doolittle D000430 | rep | WA | 1895-12-02 | 1897-03-03 | Republican | -1 | |||||||||||||
13042 | 13042 | Samuel Hyde H001024 | rep | WA | 1895-12-02 | 1897-03-03 | Republican | -1 | |||||||||||||
13213 | 13213 | John Wilson W000602 | rep | WA | 1889-12-02 | 1891-03-03 | Republican | 1 | |||||||||||||
13214 | 13214 | John Wilson W000602 | rep | WA | 1891-12-07 | 1893-03-03 | Republican | 1 | |||||||||||||
13215 | 13215 | John Wilson W000602 | rep | WA | 1893-08-07 | 1895-03-03 | Republican | -1 | |||||||||||||
13216 | 13216 | John Wilson W000602 | sen | WA | 1895-12-02 | 1899-03-03 | 1 | Republican | |||||||||||||
13372 | 13372 | William Jones J000260 | rep | WA | 1897-03-15 | 1899-03-03 | Silver Republican | -1 | |||||||||||||
13508 | 13508 | George Turner T000420 | sen | WA | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
13667 | 13667 | Addison Foster F000298 | sen | WA | 1899-12-04 | 1905-03-03 | 1 | Republican | |||||||||||||
14237 | 14237 | Levi Ankeny A000258 | sen | WA | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
14862 | 14862 | Samuel Piles P000351 | sen | WA | 1905-12-04 | 1911-03-03 | 1 | Republican | |||||||||||||
15410 | 15410 | Francis Cushman C001018 | rep | WA | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
15411 | 15411 | Francis Cushman C001018 | rep | WA | 1901-12-02 | 1903-03-03 | Republican | -1 | |||||||||||||
15412 | 15412 | Francis Cushman C001018 | rep | WA | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
15413 | 15413 | Francis Cushman C001018 | rep | WA | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
15414 | 15414 | Francis Cushman C001018 | rep | WA | 1907-12-02 | 1909-03-03 | Republican | -1 | |||||||||||||
15415 | 15415 | Francis Cushman C001018 | rep | WA | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
15634 | 15634 | William McCredie M000384 | rep | WA | 1909-03-15 | 1911-03-03 | Republican | 2 | |||||||||||||
16226 | 16226 | Stanton Warburton W000124 | rep | WA | 1911-04-04 | 1913-03-03 | Republican | 2 | |||||||||||||
16296 | 16296 | James Bryan B000987 | rep | WA | 1913-04-07 | 1915-03-03 | Progressive | -1 | |||||||||||||
16353 | 16353 | Jacob Falconer F000009 | rep | WA | 1913-04-07 | 1915-03-03 | Progressive | -1 | |||||||||||||
16816 | 16816 | William Humphrey H000958 | rep | WA | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
16817 | 16817 | William Humphrey H000958 | rep | WA | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
16818 | 16818 | William Humphrey H000958 | rep | WA | 1907-12-02 | 1909-03-03 | Republican | -1 | |||||||||||||
16819 | 16819 | William Humphrey H000958 | rep | WA | 1909-03-15 | 1911-03-03 | Republican | 1 | |||||||||||||
16820 | 16820 | William Humphrey H000958 | rep | WA | 1911-04-04 | 1913-03-03 | Republican | 1 | |||||||||||||
16821 | 16821 | William Humphrey H000958 | rep | WA | 1913-04-07 | 1915-03-03 | Republican | 1 | |||||||||||||
16822 | 16822 | William Humphrey H000958 | rep | WA | 1915-12-06 | 1917-03-03 | Republican | 1 | |||||||||||||
17334 | 17334 | William La Follette L000006 | rep | WA | 1911-04-04 | 1913-03-03 | Republican | 3 | |||||||||||||
17335 | 17335 | William La Follette L000006 | rep | WA | 1913-04-07 | 1915-03-03 | Republican | 3 | |||||||||||||
17336 | 17336 | William La Follette L000006 | rep | WA | 1915-12-06 | 1917-03-03 | Republican | 4 | |||||||||||||
17337 | 17337 | William La Follette L000006 | rep | WA | 1917-04-02 | 1919-03-03 | Republican | 4 | |||||||||||||
17376 | 17376 | Miles Poindexter P000403 | rep | WA | 1909-03-15 | 1911-03-03 | Republican | 3 | |||||||||||||
17377 | 17377 | Miles Poindexter P000403 | sen | WA | 1911-04-04 | 1917-03-03 | 1 | Republican | |||||||||||||
17378 | 17378 | Miles Poindexter P000403 | sen | WA | 1917-04-02 | 1923-03-03 | 1 | Republican | |||||||||||||
18884 | 18884 | John Webster W000240 | rep | WA | 1919-05-19 | 1921-03-03 | Republican | 5 | |||||||||||||
18885 | 18885 | John Webster W000240 | rep | WA | 1921-04-11 | 1923-03-03 | Republican | 5 | |||||||||||||
18886 | 18886 | John Webster W000240 | rep | WA | 1923-12-03 | 1925-03-03 | Republican | 5 | |||||||||||||
19362 | 19362 | Wesley Jones J000257 | rep | WA | 1899-12-04 | 1901-03-03 | Republican | -1 | |||||||||||||
19363 | 19363 | Wesley Jones J000257 | rep | WA | 1901-12-02 | 1903-03-03 | Republican | -1 | |||||||||||||
19364 | 19364 | Wesley Jones J000257 | rep | WA | 1903-11-09 | 1905-03-03 | Republican | -1 | |||||||||||||
19365 | 19365 | Wesley Jones J000257 | rep | WA | 1905-12-04 | 1907-03-03 | Republican | -1 | |||||||||||||
19366 | 19366 | Wesley Jones J000257 | rep | WA | 1907-12-02 | 1909-03-03 | Republican | -1 | |||||||||||||
19367 | 19367 | Wesley Jones J000257 | sen | WA | 1909-03-15 | 1915-03-03 | 3 | Republican | |||||||||||||
19368 | 19368 | Wesley Jones J000257 | sen | WA | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
19369 | 19369 | Wesley Jones J000257 | sen | WA | 1921-04-11 | 1927-03-04 | 3 | Republican | |||||||||||||
19370 | 19370 | Wesley Jones J000257 | sen | WA | 1927-12-05 | 1933-03-03 | 3 | Republican | |||||||||||||
19665 | 19665 | Clarence Dill D000345 | rep | WA | 1915-12-06 | 1917-03-03 | Democrat | 5 | |||||||||||||
19666 | 19666 | Clarence Dill D000345 | rep | WA | 1917-04-02 | 1919-03-03 | Democrat | 5 | |||||||||||||
19667 | 19667 | Clarence Dill D000345 | sen | WA | 1923-12-03 | 1929-03-03 | 1 | Democrat | |||||||||||||
19668 | 19668 | Clarence Dill D000345 | sen | WA | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
19879 | 19879 | John Miller M000739 | rep | WA | 1917-04-02 | 1919-03-03 | Republican | 1 | |||||||||||||
19880 | 19880 | John Miller M000739 | rep | WA | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
19881 | 19881 | John Miller M000739 | rep | WA | 1921-04-11 | 1923-03-03 | Republican | 1 | |||||||||||||
19882 | 19882 | John Miller M000739 | rep | WA | 1923-12-03 | 1925-03-03 | Republican | 1 | |||||||||||||
19883 | 19883 | John Miller M000739 | rep | WA | 1925-12-07 | 1927-03-04 | Republican | 1 | |||||||||||||
19884 | 19884 | John Miller M000739 | rep | WA | 1927-12-05 | 1929-03-03 | Republican | 1 | |||||||||||||
19885 | 19885 | John Miller M000739 | rep | WA | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
20445 | 20445 | Lindley Hadley H000008 | rep | WA | 1915-12-06 | 1917-03-03 | Republican | 2 | |||||||||||||
20446 | 20446 | Lindley Hadley H000008 | rep | WA | 1917-04-02 | 1919-03-03 | Republican | 2 | |||||||||||||
20447 | 20447 | Lindley Hadley H000008 | rep | WA | 1919-05-19 | 1921-03-03 | Republican | 2 | |||||||||||||
20448 | 20448 | Lindley Hadley H000008 | rep | WA | 1921-04-11 | 1923-03-03 | Republican | 2 | |||||||||||||
20449 | 20449 | Lindley Hadley H000008 | rep | WA | 1923-12-03 | 1925-03-03 | Republican | 2 | |||||||||||||
20450 | 20450 | Lindley Hadley H000008 | rep | WA | 1925-12-07 | 1927-03-04 | Republican | 2 | |||||||||||||
20451 | 20451 | Lindley Hadley H000008 | rep | WA | 1927-12-05 | 1929-03-03 | Republican | 2 | |||||||||||||
20452 | 20452 | Lindley Hadley H000008 | rep | WA | 1929-04-15 | 1931-03-03 | Republican | 2 | |||||||||||||
20453 | 20453 | Lindley Hadley H000008 | rep | WA | 1931-12-07 | 1933-03-03 | Republican | 2 | |||||||||||||
20531 | 20531 | Ralph Horr H000793 | rep | WA | 1931-12-07 | 1933-03-03 | Republican | 1 | |||||||||||||
20564 | 20564 | Albert Johnson J000114 | rep | WA | 1913-04-07 | 1915-03-03 | Republican | 2 | |||||||||||||
20565 | 20565 | Albert Johnson J000114 | rep | WA | 1915-12-06 | 1917-03-03 | Republican | 3 | |||||||||||||
20566 | 20566 | Albert Johnson J000114 | rep | WA | 1917-04-02 | 1919-03-03 | Republican | 3 | |||||||||||||
20567 | 20567 | Albert Johnson J000114 | rep | WA | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
20568 | 20568 | Albert Johnson J000114 | rep | WA | 1921-04-11 | 1923-03-03 | Republican | 3 | |||||||||||||
20569 | 20569 | Albert Johnson J000114 | rep | WA | 1923-12-03 | 1925-03-03 | Republican | 3 | |||||||||||||
20570 | 20570 | Albert Johnson J000114 | rep | WA | 1925-12-07 | 1927-03-04 | Republican | 3 | |||||||||||||
20571 | 20571 | Albert Johnson J000114 | rep | WA | 1927-12-05 | 1929-03-03 | Republican | 3 | |||||||||||||
20572 | 20572 | Albert Johnson J000114 | rep | WA | 1929-04-15 | 1931-03-03 | Republican | 3 |
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);