+---------+-----------------+--------+---------+------------+------------+---------+----------+------------+-------+----------------------+-------+----------+-----------+---------+-------+----------------+----------+--------------+-----------+------------+
|   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 | Brockman Adams  | rep    | WA      | 1965-01-04 | 1967-01-03 |         | Democrat |          7 |       |                      |       |          |           |         |       |                |          |              |           |            |
|   33471 | Brockman Adams  | rep    | WA      | 1967-01-10 | 1969-01-03 |         | Democrat |          7 |       |                      |       |          |           |         |       |                |          |              |           |            |
|   33472 | Brockman Adams  | rep    | WA      | 1969-01-03 | 1971-01-03 |         | Democrat |          7 |       |                      |       |          |           |         |       |                |          |              |           |            |
|   33473 | Brockman Adams  | rep    | WA      | 1971-01-21 | 1973-01-03 |         | Democrat |          7 |       |                      |       |          |           |         |       |                |          |              |           |            |
|   33474 | Brockman Adams  | rep    | WA      | 1973-01-03 | 1975-01-03 |         | Democrat |          7 |       |                      |       |          |           |         |       |                |          |              |           |            |
|   33475 | Brockman Adams  | rep    | WA      | 1975-01-14 | 1977-01-03 |         | Democrat |          7 |       |                      |       |          |           |         |       |                |          |              |           |            |
|   33476 | Brockman Adams  | rep    | WA      | 1977-01-04 | 1979-01-03 |         | Democrat |          7 |       |                      |       |          |           |         |       |                |          |              |           |            |
|   33477 | Brockman Adams  | sen    | WA      | 1987-01-06 | 1993-01-03 |       3 | Democrat |            |       |                      |       |          |           |         |       |                |          |              |           |            |
+---------+-----------------+--------+---------+------------+------------+---------+----------+------------+-------+----------------------+-------+----------+-----------+---------+-------+----------------+----------+--------------+-----------+------------+