┏━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━┳━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┓
┃   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   ┃
┣━━━━━━━━━╋━━━━━━━━━━━━━━━━━╋━━━━━━━━╋━━━━━━━━━╋━━━━━━━━━━━━╋━━━━━━━━━━━━╋━━━━━━━━━╋━━━━━━━━━━━━╋━━━━━━━━━━━━╋━━━━━━━╋━━━━━━━━━━━━━━━━━━━━━━╋━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╋━━━━━━━━━━╋━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╋━━━━━━━━━━━━━━╋━━━━━━━━━━━━━━╋━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╋━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╋━━━━━━━━━━━━━━╋━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╋━━━━━━━━━━━━┫
┃   42102 ┃ Bill Cassidy    ┃ rep    ┃ LA      ┃ 2009-01-06 ┃ 2011-01-03 ┃         ┃ Republican ┃          6 ┃       ┃                      ┃ http://cassidy.house.gov       ┃          ┃                                                     ┃              ┃              ┃                                                    ┃                                      ┃              ┃                                  ┃            ┃
┃   42103 ┃ Bill Cassidy    ┃ rep    ┃ LA      ┃ 2011-01-05 ┃ 2013-01-03 ┃         ┃ Republican ┃          6 ┃       ┃                      ┃ http://cassidy.house.gov       ┃          ┃ 1535 Longworth HOB; Washington DC 20515-1806        ┃ 202-225-3901 ┃ 202-225-7313 ┃ https://forms.house.gov/cassidy/contact-form.shtml ┃ 1535 Longworth House Office Building ┃              ┃                                  ┃            ┃
┃   42104 ┃ Bill Cassidy    ┃ rep    ┃ LA      ┃ 2013-01-03 ┃ 2015-01-03 ┃         ┃ Republican ┃          6 ┃       ┃                      ┃ http://cassidy.house.gov       ┃          ┃ 1131 Longworth HOB; Washington DC 20515-1806        ┃ 202-225-3901 ┃ 202-225-7313 ┃ https://cassidy.house.gov/contact/email-me         ┃ 1131 Longworth House Office Building ┃              ┃ http://cassidy.house.gov/rss.xml ┃            ┃
┃   42105 ┃ Bill Cassidy    ┃ sen    ┃ LA      ┃ 2015-01-06 ┃ 2021-01-03 ┃       2 ┃ Republican ┃            ┃       ┃                      ┃ https://www.cassidy.senate.gov ┃          ┃ 520 Hart Senate Office Building Washington DC 20510 ┃ 202-224-5824 ┃ 202-225-7313 ┃ https://www.cassidy.senate.gov/contact             ┃ 520 Hart Senate Office Building      ┃ senior       ┃                                  ┃            ┃
┃   42106 ┃ Bill Cassidy    ┃ sen    ┃ LA      ┃ 2021-01-03 ┃ 2027-01-03 ┃       2 ┃ Republican ┃            ┃       ┃                      ┃ https://www.cassidy.senate.gov ┃          ┃ 520 Hart Senate Office Building Washington DC 20510 ┃ 202-224-5824 ┃              ┃ https://www.cassidy.senate.gov/contact             ┃ 520 Hart Senate Office Building      ┃ senior       ┃                                  ┃            ┃
┗━━━━━━━━━┻━━━━━━━━━━━━━━━━━┻━━━━━━━━┻━━━━━━━━━┻━━━━━━━━━━━━┻━━━━━━━━━━━━┻━━━━━━━━━┻━━━━━━━━━━━━┻━━━━━━━━━━━━┻━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━━━┛