┏━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━┳━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┓
┃   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   ┃
┣━━━━━━━━━╋━━━━━━━━━━━━━━━━━╋━━━━━━━━╋━━━━━━━━━╋━━━━━━━━━━━━╋━━━━━━━━━━━━╋━━━━━━━━━╋━━━━━━━━━━━━╋━━━━━━━━━━━━╋━━━━━━━╋━━━━━━━━━━━━━━━━━━━━━━╋━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╋━━━━━━━━━━╋━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╋━━━━━━━━━━━━━━╋━━━━━━━━━━━━━━╋━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╋━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╋━━━━━━━━━━━━━━╋━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╋━━━━━━━━━━━━┫
┃   41831 ┃ John Cornyn     ┃ sen    ┃ TX      ┃ 2002-11-30 ┃ 2003-01-03 ┃       2 ┃ Republican ┃            ┃       ┃                      ┃                               ┃          ┃                                                     ┃              ┃              ┃                                                             ┃                                 ┃              ┃                                                 ┃            ┃
┃   41832 ┃ John Cornyn     ┃ sen    ┃ TX      ┃ 2003-01-07 ┃ 2009-01-03 ┃       2 ┃ Republican ┃            ┃       ┃                      ┃ http://cornyn.senate.gov/     ┃          ┃                                                     ┃              ┃              ┃                                                             ┃                                 ┃              ┃                                                 ┃            ┃
┃   41833 ┃ John Cornyn     ┃ sen    ┃ TX      ┃ 2009-01-06 ┃ 2015-01-03 ┃       2 ┃ Republican ┃            ┃       ┃                      ┃ http://www.cornyn.senate.gov  ┃          ┃ 517 Hart Senate Office Building Washington DC 20510 ┃ 202-224-2934 ┃ 202-228-2856 ┃ http://www.cornyn.senate.gov/public/index.cfm?p=ContactForm ┃ 517 Hart Senate Office Building ┃ senior       ┃ http://www.cornyn.senate.gov/public/?a=rss.feed ┃            ┃
┃   41834 ┃ John Cornyn     ┃ sen    ┃ TX      ┃ 2015-01-06 ┃ 2021-01-03 ┃       2 ┃ Republican ┃            ┃       ┃                      ┃ https://www.cornyn.senate.gov ┃          ┃ 517 Hart Senate Office Building Washington DC 20510 ┃ 202-224-2934 ┃ 202-228-2856 ┃ https://www.cornyn.senate.gov/contact                       ┃ 517 Hart Senate Office Building ┃ senior       ┃ http://www.cornyn.senate.gov/public/?a=rss.feed ┃            ┃
┃   41835 ┃ John Cornyn     ┃ sen    ┃ TX      ┃ 2021-01-03 ┃ 2027-01-03 ┃       2 ┃ Republican ┃            ┃       ┃                      ┃ https://www.cornyn.senate.gov ┃          ┃ 517 Hart Senate Office Building Washington DC 20510 ┃ 202-224-2934 ┃              ┃ https://www.cornyn.senate.gov/contact                       ┃ 517 Hart Senate Office Building ┃ senior       ┃ http://www.cornyn.senate.gov/public/?a=rss.feed ┃            ┃
┗━━━━━━━━━┻━━━━━━━━━━━━━━━━━┻━━━━━━━━┻━━━━━━━━━┻━━━━━━━━━━━━┻━━━━━━━━━━━━┻━━━━━━━━━┻━━━━━━━━━━━━┻━━━━━━━━━━━━┻━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━━━┛