legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
499 rows where state = "WA" sorted by legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: class, district, fax, contact_form, state_rank, rss_url, start (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33470 | 33470 | Brockman Adams A000031 | rep | WA | 1965-01-04 | 1967-01-03 | Democrat | 7 | |||||||||||||
33471 | 33471 | Brockman Adams A000031 | rep | WA | 1967-01-10 | 1969-01-03 | Democrat | 7 | |||||||||||||
33472 | 33472 | Brockman Adams A000031 | rep | WA | 1969-01-03 | 1971-01-03 | Democrat | 7 | |||||||||||||
33473 | 33473 | Brockman Adams A000031 | rep | WA | 1971-01-21 | 1973-01-03 | Democrat | 7 | |||||||||||||
33474 | 33474 | Brockman Adams A000031 | rep | WA | 1973-01-03 | 1975-01-03 | Democrat | 7 | |||||||||||||
33475 | 33475 | Brockman Adams A000031 | rep | WA | 1975-01-14 | 1977-01-03 | Democrat | 7 | |||||||||||||
33476 | 33476 | Brockman Adams A000031 | rep | WA | 1977-01-04 | 1979-01-03 | Democrat | 7 | |||||||||||||
33477 | 33477 | Brockman Adams A000031 | sen | WA | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
6757 | 6757 | James Anderson A000192 | rep | WA | 1855-12-03 | 1857-03-03 | Democrat | -1 | |||||||||||||
14237 | 14237 | Levi Ankeny A000258 | sen | WA | 1903-11-09 | 1909-03-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
33517 | 33517 | Don Bonker B000620 | rep | WA | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
33518 | 33518 | Don Bonker B000620 | rep | WA | 1977-01-04 | 1979-01-03 | Democrat | 3 | |||||||||||||
33519 | 33519 | Don Bonker B000620 | rep | WA | 1979-01-15 | 1981-01-03 | Democrat | 3 | |||||||||||||
33520 | 33520 | Don Bonker B000620 | rep | WA | 1981-01-05 | 1983-01-03 | Democrat | 3 | |||||||||||||
33521 | 33521 | Don Bonker B000620 | rep | WA | 1983-01-03 | 1985-01-03 | Democrat | 3 | |||||||||||||
33522 | 33522 | Don Bonker B000620 | rep | WA | 1985-01-03 | 1987-01-03 | Democrat | 3 | |||||||||||||
33523 | 33523 | Don Bonker B000620 | rep | WA | 1987-01-06 | 1989-01-03 | Democrat | 3 | |||||||||||||
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 | |||||||||||||
16296 | 16296 | James Bryan B000987 | rep | WA | 1913-04-07 | 1915-03-03 | Progressive | -1 | |||||||||||||
38408 | 38408 | Brian Baird B001229 | rep | WA | 1999-01-06 | 2001-01-03 | Democrat | 3 | |||||||||||||
38409 | 38409 | Brian Baird B001229 | rep | WA | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
38410 | 38410 | Brian Baird B001229 | rep | WA | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/baird | ||||||||||||
38411 | 38411 | Brian Baird B001229 | rep | WA | 2005-01-04 | 2007-01-03 | Democrat | 3 | http://www.house.gov/baird | ||||||||||||
38412 | 38412 | Brian Baird B001229 | rep | WA | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://www.house.gov/baird | ||||||||||||
38413 | 38413 | Brian Baird B001229 | rep | WA | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://www.baird.house.gov | ||||||||||||
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 | |||||||||||||
41740 | 41740 | Maria Cantwell C000127 | rep | WA | 1993-01-05 | 1995-01-03 | Democrat | 1 | |||||||||||||
41741 | 41741 | Maria Cantwell C000127 | sen | WA | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://cantwell.senate.gov | ||||||||||||
41742 | 41742 | Maria Cantwell C000127 | sen | WA | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://cantwell.senate.gov | 311 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-3441 | 202-228-0514 | http://www.cantwell.senate.gov/contact/ | 311 Hart Senate Office Building | |||||||
41743 | 41743 | Maria Cantwell C000127 | sen | WA | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.cantwell.senate.gov | 511 Hart Senate Office Building Washington DC 20510 | 202-224-3441 | 202-228-0514 | http://www.cantwell.senate.gov/public/index.cfm/email-maria | 511 Hart Senate Office Building | junior | http://www.cantwell.senate.gov/public/index.cfm/rss/feed | |||||
41744 | 41744 | Maria Cantwell C000127 | sen | WA | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.cantwell.senate.gov | 511 Hart Senate Office Building Washington DC 20510 | 202-224-3441 | https://www.cantwell.senate.gov/public/index.cfm/email-maria | 511 Hart Senate Office Building | junior | http://www.cantwell.senate.gov/public/index.cfm/rss/feed | ||||||
34304 | 34304 | Rodney Chandler C000293 | rep | WA | 1983-01-03 | 1985-01-03 | Republican | 8 | |||||||||||||
34305 | 34305 | Rodney Chandler C000293 | rep | WA | 1985-01-03 | 1987-01-03 | Republican | 8 | |||||||||||||
34306 | 34306 | Rodney Chandler C000293 | rep | WA | 1987-01-06 | 1989-01-03 | Republican | 8 | |||||||||||||
34307 | 34307 | Rodney Chandler C000293 | rep | WA | 1989-01-03 | 1991-01-03 | Republican | 8 | |||||||||||||
34308 | 34308 | Rodney Chandler C000293 | rep | WA | 1991-01-03 | 1993-01-03 | Republican | 8 | |||||||||||||
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 | |||||||||||||
7930 | 7930 | George Cole C000609 | rep | WA | 1863-12-07 | 1865-03-03 | Democrat | -1 | |||||||||||||
31510 | 31510 | John Cunningham C000992 | rep | WA | 1977-01-04 | 1979-01-03 | Republican | 7 | |||||||||||||
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 | |||||||||||||
23825 | 23825 | Emerson De Lacy D000206 | rep | WA | 1945-01-03 | 1947-01-03 | Democrat | 1 | |||||||||||||
8109 | 8109 | Arthur Denny D000247 | rep | WA | 1865-12-04 | 1867-03-03 | Republican | -1 | |||||||||||||
39235 | 39235 | Norman Dicks D000327 | rep | WA | 1977-01-04 | 1979-01-03 | Democrat | 6 | |||||||||||||
39236 | 39236 | Norman Dicks D000327 | rep | WA | 1979-01-15 | 1981-01-03 | Democrat | 6 | |||||||||||||
39237 | 39237 | Norman Dicks D000327 | rep | WA | 1981-01-05 | 1983-01-03 | Democrat | 6 | |||||||||||||
39238 | 39238 | Norman Dicks D000327 | rep | WA | 1983-01-03 | 1985-01-03 | Democrat | 6 | |||||||||||||
39239 | 39239 | Norman Dicks D000327 | rep | WA | 1985-01-03 | 1987-01-03 | Democrat | 6 | |||||||||||||
39240 | 39240 | Norman Dicks D000327 | rep | WA | 1987-01-06 | 1989-01-03 | Democrat | 6 | |||||||||||||
39241 | 39241 | Norman Dicks D000327 | rep | WA | 1989-01-03 | 1991-01-03 | Democrat | 6 | |||||||||||||
39242 | 39242 | Norman Dicks D000327 | rep | WA | 1991-01-03 | 1993-01-03 | Democrat | 6 | |||||||||||||
39243 | 39243 | Norman Dicks D000327 | rep | WA | 1993-01-05 | 1995-01-03 | Democrat | 6 | |||||||||||||
39244 | 39244 | Norman Dicks D000327 | rep | WA | 1995-01-04 | 1997-01-03 | Democrat | 6 | |||||||||||||
39245 | 39245 | Norman Dicks D000327 | rep | WA | 1997-01-07 | 1999-01-03 | Democrat | 6 | |||||||||||||
39246 | 39246 | Norman Dicks D000327 | rep | WA | 1999-01-06 | 2001-01-03 | Democrat | 6 | |||||||||||||
39247 | 39247 | Norman Dicks D000327 | rep | WA | 2001-01-03 | 2003-01-03 | Democrat | 6 | |||||||||||||
39248 | 39248 | Norman Dicks D000327 | rep | WA | 2003-01-07 | 2005-01-03 | Democrat | 6 | http://www.house.gov/dicks | ||||||||||||
39249 | 39249 | Norman Dicks D000327 | rep | WA | 2005-01-04 | 2007-01-03 | Democrat | 6 | http://www.house.gov/dicks | ||||||||||||
39250 | 39250 | Norman Dicks D000327 | rep | WA | 2007-01-04 | 2009-01-03 | Democrat | 6 | http://www.house.gov/dicks | ||||||||||||
39251 | 39251 | Norman Dicks D000327 | rep | WA | 2009-01-06 | 2011-01-03 | Democrat | 6 | http://www.house.gov/dicks | ||||||||||||
39252 | 39252 | Norman Dicks D000327 | rep | WA | 2011-01-05 | 2013-01-03 | Democrat | 6 | http://www.house.gov/dicks | 2467 Rayburn HOB; Washington DC 20515-4706 | 202-225-5916 | 202-226-1176 | http://www.house.gov/dicks/email.shtml | 2467 Rayburn House Office Building | |||||||
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 | |||||||||||||
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 | |||||||||||||
37320 | 37320 | Jennifer Dunn D000549 | rep | WA | 1993-01-05 | 1995-01-03 | Republican | 8 | |||||||||||||
37321 | 37321 | Jennifer Dunn D000549 | rep | WA | 1995-01-04 | 1997-01-03 | Republican | 8 | |||||||||||||
37322 | 37322 | Jennifer Dunn D000549 | rep | WA | 1997-01-07 | 1999-01-03 | Republican | 8 | |||||||||||||
37323 | 37323 | Jennifer Dunn D000549 | rep | WA | 1999-01-06 | 2001-01-03 | Republican | 8 | |||||||||||||
37324 | 37324 | Jennifer Dunn D000549 | rep | WA | 2001-01-03 | 2003-01-03 | Republican | 8 | |||||||||||||
37325 | 37325 | Jennifer Dunn D000549 | rep | WA | 2003-01-07 | 2005-01-03 | Republican | 8 | http://www.house.gov/dunn | ||||||||||||
43667 | 43667 | Suzan DelBene D000617 | rep | WA | 2012-11-13 | 2013-01-03 | Democrat | 1 | http://delbene.house.gov | 2329 Rayburn HOB; Washington DC 20515-4701 | 202-225-6311 | 2329 Rayburn House Office Building | |||||||||
43668 | 43668 | Suzan DelBene D000617 | rep | WA | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://delbene.house.gov | 318 Cannon HOB; Washington DC 20515-4701 | 202-225-6311 | 202-226-1606 | http://delbene.house.gov/contact-me/email-me | 318 Cannon House Office Building | http://delbene.house.gov/rss.xml | ||||||
43669 | 43669 | Suzan DelBene D000617 | rep | WA | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://delbene.house.gov | 318 Cannon HOB; Washington DC 20515-4701 | 202-225-6311 | 202-226-1606 | http://delbene.house.gov/contact-me/email-me | 318 Cannon House Office Building | http://delbene.house.gov/rss.xml | ||||||
43670 | 43670 | Suzan DelBene D000617 | rep | WA | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://delbene.house.gov | 2442 Rayburn House Office Building; Washington DC 20515-4701 | 202-225-6311 | 202-226-1606 | 2442 Rayburn House Office Building | http://delbene.house.gov/rss.xml | |||||||
43671 | 43671 | Suzan DelBene D000617 | rep | WA | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://delbene.house.gov | 2330 Rayburn House Office Building Washington DC 20515-4701 | 202-225-6311 | 2330 Rayburn House Office Building | http://delbene.house.gov/rss.xml | ||||||||
43672 | 43672 | Suzan DelBene D000617 | rep | WA | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://delbene.house.gov | 2330 Rayburn House Office Building Washington DC 20515-4701 | 202-225-6311 | 2330 Rayburn House Office Building | http://delbene.house.gov/rss.xml | ||||||||
32968 | 32968 | Daniel Evans E000236 | sen | WA | 1983-09-08 | 1989-01-03 | 1 | Republican | appointment | ||||||||||||
16353 | 16353 | Jacob Falconer F000009 | rep | WA | 1913-04-07 | 1915-03-03 | Progressive | -1 | |||||||||||||
8333 | 8333 | Alvan Flanders F000188 | rep | WA | 1867-03-04 | 1869-03-03 | Republican | -1 | |||||||||||||
35245 | 35245 | Thomas Foley F000239 | rep | WA | 1965-01-04 | 1967-01-03 | Democrat | 5 | |||||||||||||
35246 | 35246 | Thomas Foley F000239 | rep | WA | 1967-01-10 | 1969-01-03 | Democrat | 5 | |||||||||||||
35247 | 35247 | Thomas Foley F000239 | rep | WA | 1969-01-03 | 1971-01-03 | Democrat | 5 |
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);