┏━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━┳━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━┳━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┓ ┃ 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 ┃ ┣━━━━━━━━━╋━━━━━━━━━━━━━━━━━╋━━━━━━━━╋━━━━━━━━━╋━━━━━━━━━━━━╋━━━━━━━━━━━━╋━━━━━━━━━╋━━━━━━━━━━╋━━━━━━━━━━━━╋━━━━━━━╋━━━━━━━━━━━━━━━━━━━━━━╋━━━━━━━━━━━━━━━━━━━━━━━━━━━━╋━━━━━━━━━━╋━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╋━━━━━━━━━━━━━━╋━━━━━━━━━━━━━━╋━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╋━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╋━━━━━━━━━━━━━━╋━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╋━━━━━━━━━━━━┫ ┃ 42223 ┃ Joe Courtney ┃ rep ┃ CT ┃ 2007-01-04 ┃ 2009-01-03 ┃ ┃ Democrat ┃ 2 ┃ ┃ ┃ http://courtney.house.gov ┃ ┃ ┃ ┃ ┃ ┃ ┃ ┃ ┃ ┃ ┃ 42224 ┃ Joe Courtney ┃ rep ┃ CT ┃ 2009-01-06 ┃ 2011-01-03 ┃ ┃ Democrat ┃ 2 ┃ ┃ ┃ http://courtney.house.gov ┃ ┃ ┃ ┃ ┃ ┃ ┃ ┃ ┃ ┃ ┃ 42225 ┃ Joe Courtney ┃ rep ┃ CT ┃ 2011-01-05 ┃ 2013-01-03 ┃ ┃ Democrat ┃ 2 ┃ ┃ ┃ http://courtney.house.gov ┃ ┃ 215 Cannon HOB; Washington DC 20515-0702 ┃ 202-225-2076 ┃ 202-225-4977 ┃ http://courtney.house.gov/email/ ┃ 215 Cannon House Office Building ┃ ┃ ┃ ┃ ┃ 42226 ┃ Joe Courtney ┃ rep ┃ CT ┃ 2013-01-03 ┃ 2015-01-03 ┃ ┃ Democrat ┃ 2 ┃ ┃ ┃ http://courtney.house.gov ┃ ┃ 2348 Rayburn HOB; Washington DC 20515-0702 ┃ 202-225-2076 ┃ 202-225-4977 ┃ https://courtney.house.gov/email-joe1 ┃ 2348 Rayburn House Office Building ┃ ┃ http://courtney.house.gov/index.php?format=feed&type=rss ┃ ┃ ┃ 42227 ┃ Joe Courtney ┃ rep ┃ CT ┃ 2015-01-06 ┃ 2017-01-03 ┃ ┃ Democrat ┃ 2 ┃ ┃ ┃ http://courtney.house.gov ┃ ┃ 2348 Rayburn HOB; Washington DC 20515-0702 ┃ 202-225-2076 ┃ 202-225-4977 ┃ https://courtney.house.gov/email-joe1 ┃ 2348 Rayburn House Office Building ┃ ┃ http://courtney.house.gov/index.php?format=feed&type=rss ┃ ┃ ┃ 42228 ┃ Joe Courtney ┃ rep ┃ CT ┃ 2017-01-03 ┃ 2019-01-03 ┃ ┃ Democrat ┃ 2 ┃ ┃ ┃ https://courtney.house.gov ┃ ┃ 2348 Rayburn House Office Building; Washington DC 20515-0702 ┃ 202-225-2076 ┃ 202-225-4977 ┃ ┃ 2348 Rayburn House Office Building ┃ ┃ http://courtney.house.gov/index.php?format=feed&type=rss ┃ ┃ ┃ 42229 ┃ Joe Courtney ┃ rep ┃ CT ┃ 2019-01-03 ┃ 2021-01-03 ┃ ┃ Democrat ┃ 2 ┃ ┃ ┃ https://courtney.house.gov ┃ ┃ 2332 Rayburn House Office Building Washington DC 20515-0702 ┃ 202-225-2076 ┃ ┃ ┃ 2332 Rayburn House Office Building ┃ ┃ http://courtney.house.gov/index.php?format=feed&type=rss ┃ ┃ ┃ 42230 ┃ Joe Courtney ┃ rep ┃ CT ┃ 2021-01-03 ┃ 2023-01-03 ┃ ┃ Democrat ┃ 2 ┃ ┃ ┃ https://courtney.house.gov ┃ ┃ 2449 Rayburn House Office Building Washington DC 20515-0702 ┃ 202-225-2076 ┃ ┃ ┃ 2449 Rayburn House Office Building ┃ ┃ http://courtney.house.gov/index.php?format=feed&type=rss ┃ ┃ ┗━━━━━━━━━┻━━━━━━━━━━━━━━━━━┻━━━━━━━━┻━━━━━━━━━┻━━━━━━━━━━━━┻━━━━━━━━━━━━┻━━━━━━━━━┻━━━━━━━━━━┻━━━━━━━━━━━━┻━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━┻━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┻━━━━━━━━━━━━┛