┏━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━┳━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━┳━━━━━━━━━━━━┓
┃   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   ┃
┣━━━━━━━━━╋━━━━━━━━━━━━━━━━━╋━━━━━━━━╋━━━━━━━━━╋━━━━━━━━━━━━╋━━━━━━━━━━━━╋━━━━━━━━━╋━━━━━━━━━━━━╋━━━━━━━━━━━━╋━━━━━━━╋━━━━━━━━━━━━━━━━━━━━━━╋━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╋━━━━━━━━━━╋━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╋━━━━━━━━━━━━━━╋━━━━━━━╋━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╋━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╋━━━━━━━━━━━━━━╋━━━━━━━━━━━╋━━━━━━━━━━━━┫
┃   44422 ┃ Dan Bishop      ┃ rep    ┃ NC      ┃ 2019-09-17 ┃ 2021-01-03 ┃         ┃ Republican ┃          9 ┃       ┃                      ┃ https://danbishop.house.gov/ ┃          ┃ 132 Cannon House Office Building Washington DC 20515-3309     ┃ 202-225-1976 ┃       ┃ https://danbishop.house.gov/contact/email ┃ 132 Cannon House Office Building     ┃              ┃           ┃            ┃
┃   44423 ┃ Dan Bishop      ┃ rep    ┃ NC      ┃ 2021-01-03 ┃ 2023-01-03 ┃         ┃ Republican ┃          9 ┃       ┃                      ┃ https://danbishop.house.gov  ┃          ┃ 1207 Longworth House Office Building Washington DC 20515-3309 ┃ 202-225-1976 ┃       ┃                                           ┃ 1207 Longworth House Office Building ┃              ┃           ┃            ┃
┗━━━━━━━━━┻━━━━━━━━━━━━━━━━━┻━━━━━━━━┻━━━━━━━━━┻━━━━━━━━━━━━┻━━━━━━━━━━━━┻━━━━━━━━━┻━━━━━━━━━━━━┻━━━━━━━━━━━━┻━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━┻━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━┻━━━━━━━━━━━┻━━━━━━━━━━━━┛