┏━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━┳━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━┳━━━━━━━━━━━━┓
┃   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       ┃           ┃            ┃
┗━━━━━━━━━┻━━━━━━━━━━━━━━━━━┻━━━━━━━━┻━━━━━━━━━┻━━━━━━━━━━━━┻━━━━━━━━━━━━┻━━━━━━━━━┻━━━━━━━━━━━━┻━━━━━━━━━━━━┻━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━┻━━━━━━━━━━━┻━━━━━━━━━━━━┛