+---------+-----------------+--------+---------+------------+------------+---------+------------+------------+-------+----------------------+-------------------------------+----------+-----------------------------------------------------+--------------+--------------+-------------------------------------------------------------+---------------------------------+--------------+-------------------------------------------------+------------+
|   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 |            |
+---------+-----------------+--------+---------+------------+------------+---------+------------+------------+-------+----------------------+-------------------------------+----------+-----------------------------------------------------+--------------+--------------+-------------------------------------------------------------+---------------------------------+--------------+-------------------------------------------------+------------+