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)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20573 | 20573 | Albert Johnson J000114 | rep | WA | 1931-12-07 | 1933-03-03 | Republican | 3 | |||||||||||||
20901 | 20901 | John Summers S001067 | rep | WA | 1919-05-19 | 1921-03-03 | Republican | 4 | |||||||||||||
20902 | 20902 | John Summers S001067 | rep | WA | 1921-04-11 | 1923-03-03 | Republican | 4 | |||||||||||||
20903 | 20903 | John Summers S001067 | rep | WA | 1923-12-03 | 1925-03-03 | Republican | 4 | |||||||||||||
20904 | 20904 | John Summers S001067 | rep | WA | 1925-12-07 | 1927-03-04 | Republican | 4 | |||||||||||||
20905 | 20905 | John Summers S001067 | rep | WA | 1927-12-05 | 1929-03-03 | Republican | 4 | |||||||||||||
20906 | 20906 | John Summers S001067 | rep | WA | 1929-04-15 | 1931-03-03 | Republican | 4 | |||||||||||||
20907 | 20907 | John Summers S001067 | rep | WA | 1931-12-07 | 1933-03-03 | Republican | 4 | |||||||||||||
21062 | 21062 | Elijah Grammer G000366 | sen | WA | 1932-11-22 | 1933-03-03 | 3 | Republican | appointment | ||||||||||||
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 | |||||||||||||
24242 | 24242 | Harry Cain C000021 | sen | WA | 1946-12-31 | 1947-01-03 | 1 | Republican | |||||||||||||
24243 | 24243 | Harry Cain C000021 | sen | WA | 1947-01-03 | 1953-01-03 | 1 | Republican | |||||||||||||
24502 | 24502 | Homer Jones J000225 | rep | WA | 1947-01-03 | 1949-01-03 | Republican | 1 | |||||||||||||
24622 | 24622 | Fred Norman N000135 | rep | WA | 1943-01-06 | 1945-01-03 | Republican | 3 | |||||||||||||
24623 | 24623 | Fred Norman N000135 | rep | WA | 1947-01-03 | 1949-01-03 | Republican | 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 | |||||||||||||
26403 | 26403 | Otis Holmes H000740 | rep | WA | 1943-01-06 | 1945-01-03 | Republican | 4 | |||||||||||||
26404 | 26404 | Otis Holmes H000740 | rep | WA | 1945-01-03 | 1947-01-03 | Republican | 4 | |||||||||||||
26405 | 26405 | Otis Holmes H000740 | rep | WA | 1947-01-03 | 1949-01-03 | Republican | 4 | |||||||||||||
26406 | 26406 | Otis Holmes H000740 | rep | WA | 1949-01-03 | 1951-01-03 | Republican | 4 | |||||||||||||
26407 | 26407 | Otis Holmes H000740 | rep | WA | 1951-01-03 | 1953-01-03 | Republican | 4 | |||||||||||||
26408 | 26408 | Otis Holmes H000740 | rep | WA | 1953-01-03 | 1955-01-03 | Republican | 4 | |||||||||||||
26409 | 26409 | Otis Holmes H000740 | rep | WA | 1955-01-05 | 1957-01-03 | Republican | 4 | |||||||||||||
26410 | 26410 | Otis Holmes H000740 | rep | WA | 1957-01-03 | 1959-01-03 | Republican | 4 | |||||||||||||
26906 | 26906 | Russell Mack M000021 | rep | WA | 1947-01-03 | 1949-01-03 | Republican | 3 | |||||||||||||
26907 | 26907 | Russell Mack M000021 | rep | WA | 1949-01-03 | 1951-01-03 | Republican | 3 | |||||||||||||
26908 | 26908 | Russell Mack M000021 | rep | WA | 1951-01-03 | 1953-01-03 | Republican | 3 | |||||||||||||
26909 | 26909 | Russell Mack M000021 | rep | WA | 1953-01-03 | 1955-01-03 | Republican | 3 | |||||||||||||
26910 | 26910 | Russell Mack M000021 | rep | WA | 1955-01-05 | 1957-01-03 | Republican | 3 | |||||||||||||
26911 | 26911 | Russell Mack M000021 | rep | WA | 1957-01-03 | 1959-01-03 | Republican | 3 | |||||||||||||
26912 | 26912 | Russell Mack M000021 | rep | WA | 1959-01-07 | 1961-01-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
27899 | 27899 | Walter Horan H000786 | rep | WA | 1943-01-06 | 1945-01-03 | Republican | 5 | |||||||||||||
27900 | 27900 | Walter Horan H000786 | rep | WA | 1945-01-03 | 1947-01-03 | Republican | 5 | |||||||||||||
27901 | 27901 | Walter Horan H000786 | rep | WA | 1947-01-03 | 1949-01-03 | Republican | 5 | |||||||||||||
27902 | 27902 | Walter Horan H000786 | rep | WA | 1949-01-03 | 1951-01-03 | Republican | 5 | |||||||||||||
27903 | 27903 | Walter Horan H000786 | rep | WA | 1951-01-03 | 1953-01-03 | Republican | 5 | |||||||||||||
27904 | 27904 | Walter Horan H000786 | rep | WA | 1953-01-03 | 1955-01-03 | Republican | 5 | |||||||||||||
27905 | 27905 | Walter Horan H000786 | rep | WA | 1955-01-05 | 1957-01-03 | Republican | 5 | |||||||||||||
27906 | 27906 | Walter Horan H000786 | rep | WA | 1957-01-03 | 1959-01-03 | Republican | 5 | |||||||||||||
27907 | 27907 | Walter Horan H000786 | rep | WA | 1959-01-07 | 1961-01-03 | Republican | 5 | |||||||||||||
27908 | 27908 | Walter Horan H000786 | rep | WA | 1961-01-03 | 1963-01-03 | Republican | 5 | |||||||||||||
27909 | 27909 | Walter Horan H000786 | rep | WA | 1963-01-09 | 1965-01-03 | Republican | 5 | |||||||||||||
28178 | 28178 | K. Stinson S000928 | rep | WA | 1963-01-09 | 1965-01-03 | Republican | 7 | |||||||||||||
28187 | 28187 | Thor Tollefson T000298 | rep | WA | 1947-01-03 | 1949-01-03 | Republican | 6 | |||||||||||||
28188 | 28188 | Thor Tollefson T000298 | rep | WA | 1949-01-03 | 1951-01-03 | Republican | 6 | |||||||||||||
28189 | 28189 | Thor Tollefson T000298 | rep | WA | 1951-01-03 | 1953-01-03 | Republican | 6 | |||||||||||||
28190 | 28190 | Thor Tollefson T000298 | rep | WA | 1953-01-03 | 1955-01-03 | Republican | 6 | |||||||||||||
28191 | 28191 | Thor Tollefson T000298 | rep | WA | 1955-01-05 | 1957-01-03 | Republican | 6 | |||||||||||||
28192 | 28192 | Thor Tollefson T000298 | rep | WA | 1957-01-03 | 1959-01-03 | Republican | 6 | |||||||||||||
28193 | 28193 | Thor Tollefson T000298 | rep | WA | 1959-01-07 | 1961-01-03 | Republican | 6 | |||||||||||||
28194 | 28194 | Thor Tollefson T000298 | rep | WA | 1961-01-03 | 1963-01-03 | Republican | 6 | |||||||||||||
28195 | 28195 | Thor Tollefson T000298 | rep | WA | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
28250 | 28250 | Alfred Westland W000310 | rep | WA | 1953-01-03 | 1955-01-03 | Republican | 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);