legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
259 rows where party = "Democrat" and state = "WA"
This data as json, copyable, CSV (advanced)
Suggested facets: class, url, phone, fax, office, state_rank, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
9263 | 9263 | Obadiah McFadden M000435 | rep | WA | 1873-12-01 | 1875-03-03 | Democrat | -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 | |||||||||||||
13508 | 13508 | George Turner T000420 | sen | WA | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
21805 | 21805 | Samuel Hill H000607 | rep | WA | 1923-12-03 | 1925-03-03 | Democrat | 5 | |||||||||||||
21806 | 21806 | Samuel Hill H000607 | rep | WA | 1925-12-07 | 1927-03-04 | Democrat | 5 | |||||||||||||
21807 | 21807 | Samuel Hill H000607 | rep | WA | 1927-12-05 | 1929-03-03 | Democrat | 5 | |||||||||||||
21808 | 21808 | Samuel Hill H000607 | rep | WA | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
21809 | 21809 | Samuel Hill H000607 | rep | WA | 1931-12-07 | 1933-03-03 | Democrat | 5 | |||||||||||||
21810 | 21810 | Samuel Hill H000607 | rep | WA | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
21811 | 21811 | Samuel Hill H000607 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 5 | |||||||||||||
21857 | 21857 | Wesley Lloyd L000383 | rep | WA | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
21858 | 21858 | Wesley Lloyd L000383 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 6 | |||||||||||||
21959 | 21959 | Lewis Schwellenbach S000160 | sen | WA | 1935-01-03 | 1940-12-16 | 1 | Democrat | |||||||||||||
22009 | 22009 | Marion Zioncheck Z000011 | rep | WA | 1933-03-09 | 1935-01-03 | Democrat | 1 | |||||||||||||
22010 | 22010 | Marion Zioncheck Z000011 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 1 | |||||||||||||
22275 | 22275 | James Lewis L000284 | rep | WA | 1897-03-15 | 1899-03-03 | Democrat | -1 | |||||||||||||
22507 | 22507 | Homer Bone B000614 | sen | WA | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
22508 | 22508 | Homer Bone B000614 | sen | WA | 1939-01-03 | 1944-11-13 | 3 | Democrat | |||||||||||||
22841 | 22841 | Monrad Wallgren W000088 | rep | WA | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
22842 | 22842 | Monrad Wallgren W000088 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 2 | |||||||||||||
22843 | 22843 | Monrad Wallgren W000088 | rep | WA | 1937-01-05 | 1939-01-03 | Democrat | 2 | |||||||||||||
22844 | 22844 | Monrad Wallgren W000088 | rep | WA | 1939-01-05 | 1940-12-19 | Democrat | 2 | |||||||||||||
22845 | 22845 | Monrad Wallgren W000088 | sen | WA | 1940-12-19 | 1941-01-03 | 1 | Democrat | |||||||||||||
22846 | 22846 | Monrad Wallgren W000088 | sen | WA | 1941-01-03 | 1945-01-09 | 1 | Democrat | |||||||||||||
23037 | 23037 | Knute Hill H000600 | rep | WA | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
23038 | 23038 | Knute Hill H000600 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 4 | |||||||||||||
23039 | 23039 | Knute Hill H000600 | rep | WA | 1937-01-05 | 1939-01-03 | Democrat | 4 | |||||||||||||
23040 | 23040 | Knute Hill H000600 | rep | WA | 1939-01-03 | 1941-01-03 | Democrat | 4 | |||||||||||||
23041 | 23041 | Knute Hill H000600 | rep | WA | 1941-01-03 | 1943-01-03 | Democrat | 4 | |||||||||||||
23103 | 23103 | Charles Leavy L000185 | rep | WA | 1937-01-05 | 1939-01-03 | Democrat | 5 | |||||||||||||
23104 | 23104 | Charles Leavy L000185 | rep | WA | 1939-01-03 | 1941-01-03 | Democrat | 5 | |||||||||||||
23105 | 23105 | Charles Leavy L000185 | rep | WA | 1941-01-03 | 1943-01-03 | Democrat | 5 | |||||||||||||
23248 | 23248 | Martin Smith S000591 | rep | WA | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
23249 | 23249 | Martin Smith S000591 | rep | WA | 1935-01-03 | 1937-01-03 | Democrat | 3 | |||||||||||||
23250 | 23250 | Martin Smith S000591 | rep | WA | 1937-01-05 | 1939-01-03 | Democrat | 3 | |||||||||||||
23251 | 23251 | Martin Smith S000591 | rep | WA | 1939-01-03 | 1941-01-03 | Democrat | 3 | |||||||||||||
23252 | 23252 | Martin Smith S000591 | rep | WA | 1941-01-03 | 1943-01-03 | Democrat | 3 | |||||||||||||
23814 | 23814 | John Coffee C000584 | rep | WA | 1937-01-05 | 1939-01-03 | Democrat | 6 | |||||||||||||
23815 | 23815 | John Coffee C000584 | rep | WA | 1939-01-03 | 1941-01-03 | Democrat | 6 | |||||||||||||
23816 | 23816 | John Coffee C000584 | rep | WA | 1941-01-03 | 1943-01-03 | Democrat | 6 | |||||||||||||
23817 | 23817 | John Coffee C000584 | rep | WA | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
23818 | 23818 | John Coffee C000584 | rep | WA | 1945-01-03 | 1947-01-03 | Democrat | 6 | |||||||||||||
23825 | 23825 | Emerson De Lacy D000206 | rep | WA | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
24090 | 24090 | Charles Savage S000080 | rep | WA | 1945-01-03 | 1947-01-03 | Democrat | 3 | |||||||||||||
25390 | 25390 | Hugh Mitchell M000814 | sen | WA | 1945-01-10 | 1946-12-25 | 1 | Democrat | appointment | ||||||||||||
25391 | 25391 | Hugh Mitchell M000814 | rep | WA | 1949-01-03 | 1951-01-03 | Democrat | 1 | |||||||||||||
25392 | 25392 | Hugh Mitchell M000814 | rep | WA | 1951-01-03 | 1953-01-03 | Democrat | 1 | |||||||||||||
27331 | 27331 | Donald Magnuson M000052 | rep | WA | 1953-01-03 | 1955-01-03 | Democrat | 7 | |||||||||||||
27332 | 27332 | Donald Magnuson M000052 | rep | WA | 1955-01-05 | 1957-01-03 | Democrat | 7 | |||||||||||||
27333 | 27333 | Donald Magnuson M000052 | rep | WA | 1957-01-03 | 1959-01-03 | Democrat | 7 | |||||||||||||
27334 | 27334 | Donald Magnuson M000052 | rep | WA | 1959-01-07 | 1961-01-03 | Democrat | 7 | |||||||||||||
27335 | 27335 | Donald Magnuson M000052 | rep | WA | 1961-01-03 | 1963-01-03 | Democrat | 7 | |||||||||||||
30454 | 30454 | Julia Hansen H000174 | rep | WA | 1959-01-07 | 1961-01-03 | Democrat | 3 | |||||||||||||
30455 | 30455 | Julia Hansen H000174 | rep | WA | 1961-01-03 | 1963-01-03 | Democrat | 3 | |||||||||||||
30456 | 30456 | Julia Hansen H000174 | rep | WA | 1963-01-09 | 1965-01-03 | Democrat | 3 | |||||||||||||
30457 | 30457 | Julia Hansen H000174 | rep | WA | 1965-01-04 | 1967-01-03 | Democrat | 3 | |||||||||||||
30458 | 30458 | Julia Hansen H000174 | rep | WA | 1967-01-10 | 1969-01-03 | Democrat | 3 | |||||||||||||
30459 | 30459 | Julia Hansen H000174 | rep | WA | 1969-01-03 | 1971-01-03 | Democrat | 3 | |||||||||||||
30460 | 30460 | Julia Hansen H000174 | rep | WA | 1971-01-21 | 1973-01-03 | Democrat | 3 | |||||||||||||
30461 | 30461 | Julia Hansen H000174 | rep | WA | 1973-01-03 | 1975-01-03 | Democrat | 3 | |||||||||||||
31012 | 31012 | Floyd Hicks H000563 | rep | WA | 1965-01-04 | 1967-01-03 | Democrat | 6 | |||||||||||||
31013 | 31013 | Floyd Hicks H000563 | rep | WA | 1967-01-10 | 1969-01-03 | Democrat | 6 | |||||||||||||
31014 | 31014 | Floyd Hicks H000563 | rep | WA | 1969-01-03 | 1971-01-03 | Democrat | 6 | |||||||||||||
31015 | 31015 | Floyd Hicks H000563 | rep | WA | 1971-01-21 | 1973-01-03 | Democrat | 6 | |||||||||||||
31016 | 31016 | Floyd Hicks H000563 | rep | WA | 1973-01-03 | 1975-01-03 | Democrat | 6 | |||||||||||||
31017 | 31017 | Floyd Hicks H000563 | rep | WA | 1975-01-14 | 1977-01-03 | Democrat | 6 | |||||||||||||
31160 | 31160 | Warren Magnuson M000053 | rep | WA | 1937-01-05 | 1939-01-03 | Democrat | 1 | |||||||||||||
31161 | 31161 | Warren Magnuson M000053 | rep | WA | 1939-01-03 | 1941-01-03 | Democrat | 1 | |||||||||||||
31162 | 31162 | Warren Magnuson M000053 | rep | WA | 1941-01-03 | 1943-01-03 | Democrat | 1 | |||||||||||||
31163 | 31163 | Warren Magnuson M000053 | rep | WA | 1943-01-03 | 1944-12-13 | Democrat | 1 | |||||||||||||
31164 | 31164 | Warren Magnuson M000053 | sen | WA | 1944-12-14 | 1945-01-03 | 3 | Democrat | |||||||||||||
31165 | 31165 | Warren Magnuson M000053 | sen | WA | 1945-01-03 | 1951-01-03 | 3 | Democrat | |||||||||||||
31166 | 31166 | Warren Magnuson M000053 | sen | WA | 1951-01-03 | 1957-01-03 | 3 | Democrat | |||||||||||||
31167 | 31167 | Warren Magnuson M000053 | sen | WA | 1957-01-03 | 1963-01-03 | 3 | Democrat | |||||||||||||
31168 | 31168 | Warren Magnuson M000053 | sen | WA | 1963-01-09 | 1969-01-03 | 3 | Democrat | |||||||||||||
31169 | 31169 | Warren Magnuson M000053 | sen | WA | 1969-01-03 | 1975-01-03 | 3 | Democrat | |||||||||||||
31170 | 31170 | Warren Magnuson M000053 | sen | WA | 1975-01-14 | 1981-01-03 | 3 | Democrat | |||||||||||||
31659 | 31659 | Lloyd Meeds M000626 | rep | WA | 1965-01-04 | 1967-01-03 | Democrat | 2 | |||||||||||||
31660 | 31660 | Lloyd Meeds M000626 | rep | WA | 1967-01-10 | 1969-01-03 | Democrat | 2 | |||||||||||||
31661 | 31661 | Lloyd Meeds M000626 | rep | WA | 1969-01-03 | 1971-01-03 | Democrat | 2 | |||||||||||||
31662 | 31662 | Lloyd Meeds M000626 | rep | WA | 1971-01-21 | 1973-01-03 | Democrat | 2 | |||||||||||||
31663 | 31663 | Lloyd Meeds M000626 | rep | WA | 1973-01-03 | 1975-01-03 | Democrat | 2 | |||||||||||||
31664 | 31664 | Lloyd Meeds M000626 | rep | WA | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
31665 | 31665 | Lloyd Meeds M000626 | rep | WA | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
32161 | 32161 | Mike McCormack M000365 | rep | WA | 1971-01-21 | 1973-01-03 | Democrat | 4 | |||||||||||||
32162 | 32162 | Mike McCormack M000365 | rep | WA | 1973-01-03 | 1975-01-03 | Democrat | 4 | |||||||||||||
32163 | 32163 | Mike McCormack M000365 | rep | WA | 1975-01-14 | 1977-01-03 | Democrat | 4 | |||||||||||||
32164 | 32164 | Mike McCormack M000365 | rep | WA | 1977-01-04 | 1979-01-03 | Democrat | 4 | |||||||||||||
32165 | 32165 | Mike McCormack M000365 | rep | WA | 1979-01-15 | 1981-01-03 | Democrat | 4 | |||||||||||||
32999 | 32999 | Henry Jackson J000013 | rep | WA | 1941-01-03 | 1943-01-03 | Democrat | 2 |
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);