legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
754 rows where state = "CT" sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: district, url, address, fax, contact_form, office, state_rank, start (date), end (date)
party 12 ✖
- Republican 284
- Democrat 256
- Federalist 111
- Whig 34
- Adams 16
- Jackson 9
- Pro-Administration 5
- American 4
- Anti-Jacksonian 3
- Free Soil 2
- Anti Jacksonian 1
- Independent 1
Link | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44297 | 44297 | Jahana Hayes H001081 | rep | CT | 2021-01-03 | 2023-01-03 | Democrat | 5 | https://hayes.house.gov | 1415 Longworth House Office Building Washington DC 20515-0705 | 202-225-4476 | 1415 Longworth House Office Building | |||||||||
44296 | 44296 | Jahana Hayes H001081 | rep | CT | 2019-01-03 | 2021-01-03 | Democrat | 5 | https://hayes.house.gov | 1415 Longworth House Office Building Washington DC 20515-0705 | 202-225-4476 | 1415 Longworth House Office Building | |||||||||
42966 | 42966 | Christopher Murphy M001169 | sen | CT | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.murphy.senate.gov | 136 Hart Senate Office Building Washington DC 20510 | 202-224-4041 | https://www.murphy.senate.gov/contact | 136 Hart Senate Office Building | junior | http://www.theday.com/article/20121216/nws12/312169935/1069/rss | ||||||
42965 | 42965 | Christopher Murphy M001169 | sen | CT | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.murphy.senate.gov | 136 Hart Senate Office Building Washington DC 20510 | 202-224-4041 | 202-225-5933 | http://www.murphy.senate.gov/contact | 136 Hart Senate Office Building | junior | http://www.theday.com/article/20121216/nws12/312169935/1069/rss | |||||
42964 | 42964 | Christopher Murphy M001169 | rep | CT | 2011-01-05 | 2013-01-03 | Democrat | 5 | http://chrismurphy.house.gov | 412 Cannon HOB; Washington DC 20515-0705 | 202-225-4476 | 202-225-5933 | http://www.house.gov/formchrismurphy/ic_zip_auth.htm | 412 Cannon House Office Building | |||||||
42963 | 42963 | Christopher Murphy M001169 | rep | CT | 2009-01-06 | 2011-01-03 | Democrat | 5 | http://chrismurphy.house.gov | ||||||||||||
42962 | 42962 | Christopher Murphy M001169 | rep | CT | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://chrismurphy.house.gov | ||||||||||||
42708 | 42708 | John Larson L000557 | rep | CT | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://larson.house.gov | 1501 Longworth House Office Building Washington DC 20515-0701 | 202-225-2265 | 1501 Longworth House Office Building | http://www.larson.house.gov/index.php?format=feed&type=rss | ||||||||
42707 | 42707 | John Larson L000557 | rep | CT | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://larson.house.gov | 1501 Longworth House Office Building Washington DC 20515-0701 | 202-225-2265 | 1501 Longworth House Office Building | http://www.larson.house.gov/index.php?format=feed&type=rss | ||||||||
42706 | 42706 | John Larson L000557 | rep | CT | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://larson.house.gov | 1501 Longworth House Office Building; Washington DC 20515-0701 | 202-225-2265 | 202-225-1031 | 1501 Longworth House Office Building | http://www.larson.house.gov/index.php?format=feed&type=rss | |||||||
42705 | 42705 | John Larson L000557 | rep | CT | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://larson.house.gov | 1501 Longworth HOB; Washington DC 20515-0701 | 202-225-2265 | 202-225-1031 | https://forms.house.gov/larson/contact_new.html | 1501 Longworth House Office Building | http://www.larson.house.gov/index.php?format=feed&type=rss | ||||||
42704 | 42704 | John Larson L000557 | rep | CT | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://www.larson.house.gov | 1501 Longworth HOB; Washington DC 20515-0701 | 202-225-2265 | 202-225-1031 | https://forms.house.gov/larson/contact_new.html | 1501 Longworth House Office Building | http://www.larson.house.gov/index.php?format=feed&type=rss | ||||||
42703 | 42703 | John Larson L000557 | rep | CT | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://www.house.gov/larson | 1501 Longworth HOB; Washington DC 20515-0701 | 202-225-2265 | 202-225-1031 | http://www.house.gov/writerep | 1501 Longworth House Office Building | |||||||
42702 | 42702 | John Larson L000557 | rep | CT | 2009-01-06 | 2011-01-03 | Democrat | 1 | http://www.house.gov/larson | ||||||||||||
42701 | 42701 | John Larson L000557 | rep | CT | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/larson | ||||||||||||
42700 | 42700 | John Larson L000557 | rep | CT | 2005-01-04 | 2007-01-03 | Democrat | 1 | http://www.house.gov/larson | ||||||||||||
42699 | 42699 | John Larson L000557 | rep | CT | 2003-01-07 | 2005-01-03 | Democrat | 1 | http://www.house.gov/larson | ||||||||||||
42698 | 42698 | John Larson L000557 | rep | CT | 2001-01-03 | 2003-01-03 | Democrat | 1 | |||||||||||||
42697 | 42697 | John Larson L000557 | rep | CT | 1999-01-06 | 2001-01-03 | Democrat | 1 | |||||||||||||
42524 | 42524 | James Himes H001047 | rep | CT | 2021-01-03 | 2023-01-03 | Democrat | 4 | https://himes.house.gov | 2137 Rayburn House Office Building Washington DC 20515-0704 | 202-225-5541 | 2137 Rayburn House Office Building | http://himes.house.gov/rss.xml | ||||||||
42523 | 42523 | James Himes H001047 | rep | CT | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://himes.house.gov | 1227 Longworth House Office Building Washington DC 20515-0704 | 202-225-5541 | 1227 Longworth House Office Building | http://himes.house.gov/rss.xml | ||||||||
42522 | 42522 | James Himes H001047 | rep | CT | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://himes.house.gov | 1227 Longworth House Office Building; Washington DC 20515-0704 | 202-225-5541 | 202-225-9629 | 1227 Longworth House Office Building | http://himes.house.gov/rss.xml | |||||||
42521 | 42521 | James Himes H001047 | rep | CT | 2015-01-06 | 2017-01-03 | Democrat | 4 | http://himes.house.gov | 1227 Longworth HOB; Washington DC 20515-0704 | 202-225-5541 | 202-225-9629 | https://himes.house.gov/contact-me/email-me | 1227 Longworth House Office Building | http://himes.house.gov/rss.xml | ||||||
42520 | 42520 | James Himes H001047 | rep | CT | 2013-01-03 | 2015-01-03 | Democrat | 4 | http://himes.house.gov | 119 Cannon HOB; Washington DC 20515-0704 | 202-225-5541 | 202-225-9629 | https://himes.house.gov/contact-me/email-me | 119 Cannon House Office Building | http://himes.house.gov/rss.xml | ||||||
42519 | 42519 | James Himes H001047 | rep | CT | 2011-01-05 | 2013-01-03 | Democrat | 4 | http://himes.house.gov | 119 Cannon HOB; Washington DC 20515-0704 | 202-225-5541 | 202-225-9629 | https://forms.house.gov/himes/contact-form.shtml | 119 Cannon House Office Building | |||||||
42518 | 42518 | James Himes H001047 | rep | CT | 2009-01-06 | 2011-01-03 | Democrat | 4 | http://himes.house.gov | ||||||||||||
42312 | 42312 | Rosa DeLauro D000216 | rep | CT | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://delauro.house.gov | 2413 Rayburn House Office Building Washington DC 20515-0703 | 202-225-3661 | 2413 Rayburn House Office Building | http://delauro.house.gov/index.php?format=feed&type=rss | ||||||||
42311 | 42311 | Rosa DeLauro D000216 | rep | CT | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://delauro.house.gov | 2413 Rayburn House Office Building Washington DC 20515-0703 | 202-225-3661 | 2413 Rayburn House Office Building | http://delauro.house.gov/index.php?format=feed&type=rss | ||||||||
42310 | 42310 | Rosa DeLauro D000216 | rep | CT | 2017-01-03 | 2019-01-03 | Democrat | 3 | https://delauro.house.gov | 2413 Rayburn House Office Building; Washington DC 20515-0703 | 202-225-3661 | 202-225-4890 | 2413 Rayburn House Office Building | http://delauro.house.gov/index.php?format=feed&type=rss | |||||||
42309 | 42309 | Rosa DeLauro D000216 | rep | CT | 2015-01-06 | 2017-01-03 | Democrat | 3 | http://delauro.house.gov | 2413 Rayburn HOB; Washington DC 20515-0703 | 202-225-3661 | 202-225-4890 | https://forms.house.gov/delauro/webforms/contact_form_email.shtml | 2413 Rayburn House Office Building | http://delauro.house.gov/index.php?format=feed&type=rss | ||||||
42308 | 42308 | Rosa DeLauro D000216 | rep | CT | 2013-01-03 | 2015-01-03 | Democrat | 3 | http://delauro.house.gov | 2413 Rayburn HOB; Washington DC 20515-0703 | 202-225-3661 | 202-225-4890 | https://forms.house.gov/delauro/webforms/contact_form_email.shtml | 2413 Rayburn House Office Building | http://delauro.house.gov/index.php?format=feed&type=rss | ||||||
42307 | 42307 | Rosa DeLauro D000216 | rep | CT | 2011-01-05 | 2013-01-03 | Democrat | 3 | http://www.house.gov/delauro | 2413 Rayburn HOB; Washington DC 20515-0703 | 202-225-3661 | 202-225-4890 | http://delauro.house.gov/contact_form_email.cfm | 2413 Rayburn House Office Building | |||||||
42306 | 42306 | Rosa DeLauro D000216 | rep | CT | 2009-01-06 | 2011-01-03 | Democrat | 3 | http://www.house.gov/delauro | ||||||||||||
42305 | 42305 | Rosa DeLauro D000216 | rep | CT | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://www.house.gov/delauro | ||||||||||||
42304 | 42304 | Rosa DeLauro D000216 | rep | CT | 2005-01-04 | 2007-01-03 | Democrat | 3 | http://www.house.gov/delauro | ||||||||||||
42303 | 42303 | Rosa DeLauro D000216 | rep | CT | 2003-01-07 | 2005-01-03 | Democrat | 3 | http://www.house.gov/delauro | ||||||||||||
42302 | 42302 | Rosa DeLauro D000216 | rep | CT | 2001-01-03 | 2003-01-03 | Democrat | 3 | |||||||||||||
42301 | 42301 | Rosa DeLauro D000216 | rep | CT | 1999-01-06 | 2001-01-03 | Democrat | 3 | |||||||||||||
42300 | 42300 | Rosa DeLauro D000216 | rep | CT | 1997-01-07 | 1999-01-03 | Democrat | 3 | |||||||||||||
42299 | 42299 | Rosa DeLauro D000216 | rep | CT | 1995-01-04 | 1997-01-03 | Democrat | 3 | |||||||||||||
42298 | 42298 | Rosa DeLauro D000216 | rep | CT | 1993-01-05 | 1995-01-03 | Democrat | 3 | |||||||||||||
42297 | 42297 | Rosa DeLauro D000216 | rep | CT | 1991-01-03 | 1993-01-03 | Democrat | 3 | |||||||||||||
42230 | 42230 | Joe Courtney C001069 | 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 | ||||||||
42229 | 42229 | Joe Courtney C001069 | 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 | ||||||||
42228 | 42228 | Joe Courtney C001069 | 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 | |||||||
42227 | 42227 | Joe Courtney C001069 | 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 | ||||||
42226 | 42226 | Joe Courtney C001069 | 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 | ||||||
42225 | 42225 | Joe Courtney C001069 | 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 | |||||||
42224 | 42224 | Joe Courtney C001069 | rep | CT | 2009-01-06 | 2011-01-03 | Democrat | 2 | http://courtney.house.gov | ||||||||||||
42223 | 42223 | Joe Courtney C001069 | rep | CT | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://courtney.house.gov | ||||||||||||
41982 | 41982 | Richard Blumenthal B001277 | sen | CT | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.blumenthal.senate.gov | 706 Hart Senate Office Building Washington DC 20510 | 202-224-2823 | 202-224-9673 | https://www.blumenthal.senate.gov/contact/ | 706 Hart Senate Office Building | senior | http://www.blumenthal.senate.gov/rss/feeds/?type=all | |||||
41981 | 41981 | Richard Blumenthal B001277 | sen | CT | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.blumenthal.senate.gov | 706 Hart Senate Office Building Washington DC 20510 | 202-224-2823 | 202-224-9673 | https://www.blumenthal.senate.gov/contact/ | 706 Hart Senate Office Building | senior | http://www.blumenthal.senate.gov/rss/feeds/?type=all | |||||
41094 | 41094 | Elizabeth Esty E000293 | rep | CT | 2017-01-03 | 2019-01-03 | Democrat | 5 | https://esty.house.gov | 221 Cannon House Office Building; Washington DC 20515-0705 | 202-225-4476 | 202-225-5933 | 221 Cannon House Office Building | http://esty.house.gov/rss.xml | |||||||
41093 | 41093 | Elizabeth Esty E000293 | rep | CT | 2015-01-06 | 2017-01-03 | Democrat | 5 | http://esty.house.gov | 405 Cannon HOB; Washington DC 20515-0705 | 202-225-4476 | 202-225-5933 | http://esty.house.gov/contact | 405 Cannon House Office Building | http://esty.house.gov/rss.xml | ||||||
41092 | 41092 | Elizabeth Esty E000293 | rep | CT | 2013-01-03 | 2015-01-03 | Democrat | 5 | http://esty.house.gov | 509 Cannon HOB; Washington DC 20515-0705 | 202-225-4476 | 202-225-5933 | http://esty.house.gov/contact | 509 Cannon House Office Building | http://esty.house.gov/rss.xml | ||||||
39062 | 39062 | Joseph Lieberman L000304 | sen | CT | 2007-01-04 | 2013-01-03 | 1 | Independent | http://lieberman.senate.gov/ | 706 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-4041 | 202-224-9750 | http://www.lieberman.senate.gov/index.cfm/contact/email-me-about-an-issue | 706 Hart Senate Office Building | |||||||
39061 | 39061 | Joseph Lieberman L000304 | sen | CT | 2001-01-03 | 2007-01-03 | 1 | Democrat | http://lieberman.senate.gov/ | ||||||||||||
39060 | 39060 | Joseph Lieberman L000304 | sen | CT | 1995-01-04 | 2001-01-03 | 1 | Democrat | |||||||||||||
39059 | 39059 | Joseph Lieberman L000304 | sen | CT | 1989-01-03 | 1995-01-03 | 1 | Democrat | |||||||||||||
38343 | 38343 | Christopher Shays S001144 | rep | CT | 2007-01-04 | 2009-01-03 | Republican | 4 | http://www.house.gov/shays | ||||||||||||
38342 | 38342 | Christopher Shays S001144 | rep | CT | 2005-01-04 | 2007-01-03 | Republican | 4 | http://www.house.gov/shays | ||||||||||||
38341 | 38341 | Christopher Shays S001144 | rep | CT | 2003-01-07 | 2005-01-03 | Republican | 4 | http://www.house.gov/shays | ||||||||||||
38340 | 38340 | Christopher Shays S001144 | rep | CT | 2001-01-03 | 2003-01-03 | Republican | 4 | |||||||||||||
38339 | 38339 | Christopher Shays S001144 | rep | CT | 1999-01-06 | 2001-01-03 | Republican | 4 | |||||||||||||
38338 | 38338 | Christopher Shays S001144 | rep | CT | 1997-01-07 | 1999-01-03 | Republican | 4 | |||||||||||||
38337 | 38337 | Christopher Shays S001144 | rep | CT | 1995-01-04 | 1997-01-03 | Republican | 4 | |||||||||||||
38336 | 38336 | Christopher Shays S001144 | rep | CT | 1993-01-05 | 1995-01-03 | Republican | 4 | |||||||||||||
38335 | 38335 | Christopher Shays S001144 | rep | CT | 1991-01-03 | 1993-01-03 | Republican | 4 | |||||||||||||
38334 | 38334 | Christopher Shays S001144 | rep | CT | 1989-01-03 | 1991-01-03 | Republican | 4 | |||||||||||||
38333 | 38333 | Christopher Shays S001144 | rep | CT | 1987-08-18 | 1989-01-03 | Republican | 4 | |||||||||||||
37881 | 37881 | Robert Simmons S001152 | rep | CT | 2005-01-04 | 2007-01-03 | Republican | 2 | http://www.house.gov/simmons | ||||||||||||
37880 | 37880 | Robert Simmons S001152 | rep | CT | 2003-01-07 | 2005-01-03 | Republican | 2 | http://www.house.gov/simmons | ||||||||||||
37879 | 37879 | Robert Simmons S001152 | rep | CT | 2001-01-03 | 2003-01-03 | Republican | 2 | |||||||||||||
37736 | 37736 | Nancy Johnson J000163 | rep | CT | 2005-01-04 | 2007-01-03 | Republican | 5 | http://www.house.gov/nancyjohnson | ||||||||||||
37735 | 37735 | Nancy Johnson J000163 | rep | CT | 2003-01-07 | 2005-01-03 | Republican | 5 | http://www.house.gov/nancyjohnson | ||||||||||||
37734 | 37734 | Nancy Johnson J000163 | rep | CT | 2001-01-03 | 2003-01-03 | Republican | 6 | |||||||||||||
37733 | 37733 | Nancy Johnson J000163 | rep | CT | 1999-01-06 | 2001-01-03 | Republican | 6 | |||||||||||||
37732 | 37732 | Nancy Johnson J000163 | rep | CT | 1997-01-07 | 1999-01-03 | Republican | 6 | |||||||||||||
37731 | 37731 | Nancy Johnson J000163 | rep | CT | 1995-01-04 | 1997-01-03 | Republican | 6 | |||||||||||||
37730 | 37730 | Nancy Johnson J000163 | rep | CT | 1993-01-05 | 1995-01-03 | Republican | 6 | |||||||||||||
37729 | 37729 | Nancy Johnson J000163 | rep | CT | 1991-01-03 | 1993-01-03 | Republican | 6 | |||||||||||||
37728 | 37728 | Nancy Johnson J000163 | rep | CT | 1989-01-03 | 1991-01-03 | Republican | 6 | |||||||||||||
37727 | 37727 | Nancy Johnson J000163 | rep | CT | 1987-01-06 | 1989-01-03 | Republican | 6 | |||||||||||||
37726 | 37726 | Nancy Johnson J000163 | rep | CT | 1985-01-03 | 1987-01-03 | Republican | 6 | |||||||||||||
37725 | 37725 | Nancy Johnson J000163 | rep | CT | 1983-01-03 | 1985-01-03 | Republican | 6 | |||||||||||||
37611 | 37611 | Christopher Dodd D000388 | sen | CT | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://dodd.senate.gov | ||||||||||||
37610 | 37610 | Christopher Dodd D000388 | sen | CT | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://dodd.senate.gov/ | ||||||||||||
37609 | 37609 | Christopher Dodd D000388 | sen | CT | 1993-01-05 | 1999-01-03 | 3 | Democrat | |||||||||||||
37608 | 37608 | Christopher Dodd D000388 | sen | CT | 1987-01-06 | 1993-01-03 | 3 | Democrat | |||||||||||||
37607 | 37607 | Christopher Dodd D000388 | sen | CT | 1981-01-05 | 1987-01-03 | 3 | Democrat | |||||||||||||
37606 | 37606 | Christopher Dodd D000388 | rep | CT | 1979-01-15 | 1981-01-03 | Democrat | 2 | |||||||||||||
37605 | 37605 | Christopher Dodd D000388 | rep | CT | 1977-01-04 | 1979-01-03 | Democrat | 2 | |||||||||||||
37604 | 37604 | Christopher Dodd D000388 | rep | CT | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
37012 | 37012 | James Maloney M000090 | rep | CT | 2001-01-03 | 2003-01-03 | Democrat | 5 | |||||||||||||
37011 | 37011 | James Maloney M000090 | rep | CT | 1999-01-06 | 2001-01-03 | Democrat | 5 | |||||||||||||
37010 | 37010 | James Maloney M000090 | rep | CT | 1997-01-07 | 1999-01-03 | Democrat | 5 | |||||||||||||
36630 | 36630 | Sam Gejdenson G000120 | rep | CT | 1999-01-06 | 2001-01-03 | Democrat | 2 | |||||||||||||
36629 | 36629 | Sam Gejdenson G000120 | rep | CT | 1997-01-07 | 1999-01-03 | Democrat | 2 | |||||||||||||
36628 | 36628 | Sam Gejdenson G000120 | rep | CT | 1995-01-04 | 1997-01-03 | Democrat | 2 | |||||||||||||
36627 | 36627 | Sam Gejdenson G000120 | rep | CT | 1993-01-05 | 1995-01-03 | Democrat | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [legislator_terms] ( [legislator_id] TEXT REFERENCES [legislators]([id]), [type] TEXT, [state] TEXT, [start] TEXT, [end] TEXT, [class] INTEGER, [party] TEXT , [district] INTEGER, [how] TEXT, [party_affiliations] TEXT, [url] TEXT, [caucus] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);