+---------+-----------------+--------+---------+------------+------------+---------+------------+------------+-------+----------------------+------------------------------+----------+--------------------------------------------------------+--------------+--------------+-----------------------------------------------+------------------------------------+--------------+-----------+------------+
|   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   |
|---------+-----------------+--------+---------+------------+------------+---------+------------+------------+-------+----------------------+------------------------------+----------+--------------------------------------------------------+--------------+--------------+-----------------------------------------------+------------------------------------+--------------+-----------+------------|
|   42231 | Michael Crapo   | rep    | ID      | 1993-01-05 | 1995-01-03 |         | Republican |          2 |       |                      |                              |          |                                                        |              |              |                                               |                                    |              |           |            |
|   42232 | Michael Crapo   | rep    | ID      | 1995-01-04 | 1997-01-03 |         | Republican |          2 |       |                      |                              |          |                                                        |              |              |                                               |                                    |              |           |            |
|   42233 | Michael Crapo   | rep    | ID      | 1997-01-07 | 1999-01-03 |         | Republican |          2 |       |                      |                              |          |                                                        |              |              |                                               |                                    |              |           |            |
|   42234 | Michael Crapo   | sen    | ID      | 1999-01-06 | 2005-01-03 |       3 | Republican |            |       |                      | http://crapo.senate.gov/     |          |                                                        |              |              |                                               |                                    |              |           |            |
|   42235 | Michael Crapo   | sen    | ID      | 2005-01-04 | 2011-01-03 |       3 | Republican |            |       |                      | http://crapo.senate.gov      |          |                                                        |              |              |                                               |                                    |              |           |            |
|   42236 | Michael Crapo   | sen    | ID      | 2011-01-05 | 2017-01-03 |       3 | Republican |            |       |                      | http://www.crapo.senate.gov  |          | 239 Dirksen Senate Office Building Washington DC 20510 | 202-224-6142 | 202-228-1375 | http://www.crapo.senate.gov/contact/email.cfm | 239 Dirksen Senate Office Building | senior       |           |            |
|   42237 | Michael Crapo   | sen    | ID      | 2017-01-03 | 2023-01-03 |       3 | Republican |            |       |                      | https://www.crapo.senate.gov |          | 239 Dirksen Senate Office Building Washington DC 20510 | 202-224-6142 | 202-228-1375 | https://www.crapo.senate.gov/contact          | 239 Dirksen Senate Office Building | senior       |           |            |
+---------+-----------------+--------+---------+------------+------------+---------+------------+------------+-------+----------------------+------------------------------+----------+--------------------------------------------------------+--------------+--------------+-----------------------------------------------+------------------------------------+--------------+-----------+------------+