legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
473 rows where "start" is on date 2013-01-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: type, class, party, office, rss_url
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39655 | 39655 | Melvin Watt W000207 | rep | NC | 2013-01-03 | 2014-01-06 | Democrat | 12 | http://watt.house.gov | 2304 Rayburn HOB; Washington DC 20515-3312 | 202-225-1510 | 202-225-1512 | http://www.house.gov/formwatt/IMA/issue_subscribe.htm | 2304 Rayburn House Office Building | http://watt.house.gov/index.php?format=feed&type=rss | ||||||
39678 | 39678 | Robert Andrews A000210 | rep | NJ | 2013-01-03 | 2014-02-18 | Democrat | 1 | http://andrews.house.gov | 2265 Rayburn HOB; Washington DC 20515-3001 | 202-225-6501 | http://andrews.house.gov/contact-me/email-me | 2265 Rayburn House Office Building | http://andrews.house.gov/rss.xml | |||||||
39753 | 39753 | John Barrow B001252 | rep | GA | 2013-01-03 | 2015-01-03 | Democrat | 12 | http://barrow.house.gov | 2202 Rayburn HOB; Washington DC 20515-1012 | 202-225-2823 | 202-225-3377 | http://barrowforms.house.gov/contact/ | 2202 Rayburn House Office Building | http://barrow.house.gov/rss.xml | ||||||
39759 | 39759 | Timothy Bishop B001242 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://timbishop.house.gov | 306 Cannon HOB; Washington DC 20515-3201 | 202-225-3826 | 202-225-3143 | https://timbishop.house.gov/email-me | 306 Cannon House Office Building | http://timbishop.house.gov/rss/latest-news.xml | ||||||
39763 | 39763 | Bruce Braley B001259 | rep | IA | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://braley.house.gov | 2263 Rayburn HOB; Washington DC 20515-1501 | 202-225-2911 | 202-225-6666 | http://braley.house.gov/contact | 2263 Rayburn House Office Building | http://braley.house.gov/rss.xml | ||||||
39793 | 39793 | Donna Christensen C000380 | rep | VI | 2013-01-03 | 2015-01-03 | Democrat | 0 | http://donnachristensen.house.gov | 1510 Longworth HOB; Washington DC 20515-5501 | 202-225-1790 | 202-225-5517 | https://donnachristensen.house.gov/contact-me/email-me | 1510 Longworth House Office Building | http://donnachristensen.house.gov/rss.xml | ||||||
39828 | 39828 | John Dingell D000355 | rep | MI | 2013-01-03 | 2015-01-03 | Democrat | 12 | http://dingell.house.gov | 2328 Rayburn HOB; Washington DC 20515-2212 | 202-225-4071 | 202-226-0371 | https://dingell.house.gov/contact-me/email-me | 2328 Rayburn House Office Building | http://dingell.house.gov/rss.xml | ||||||
39841 | 39841 | Eni Faleomavaega F000010 | rep | AS | 2013-01-03 | 2015-01-03 | Democrat | 0 | http://faleomavaega.house.gov | 2422 Rayburn HOB; Washington DC 20515-5201 | 202-225-8577 | 202-225-8757 | https://faleomavaega.house.gov/contact/email-me | 2422 Rayburn House Office Building | |||||||
39890 | 39890 | Rush Holt H001032 | rep | NJ | 2013-01-03 | 2015-01-03 | Democrat | 12 | http://holt.house.gov | 1214 Longworth HOB; Washington DC 20515-3012 | 202-225-5801 | 202-225-6025 | https://holt.house.gov/email-me | 1214 Longworth House Office Building | http://holt.house.gov/index.php?format=feed&type=rss | ||||||
39918 | 39918 | Jim Matheson M001142 | rep | UT | 2013-01-03 | 2015-01-03 | Democrat | 4 | http://matheson.house.gov | 2211 Rayburn HOB; Washington DC 20515-4404 | 202-225-3011 | 202-225-5638 | https://mathesonforms.house.gov/contact-form | 2211 Rayburn House Office Building | |||||||
39927 | 39927 | Carolyn McCarthy M000309 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 4 | http://carolynmccarthy.house.gov | 2346 Rayburn HOB; Washington DC 20515-3204 | 202-225-5516 | 202-225-5758 | https://carolynmccarthy.house.gov/contact | 2346 Rayburn House Office Building | http://www.house.gov/common/rss/?rss=155 | ||||||
39936 | 39936 | Mike McIntyre M000485 | rep | NC | 2013-01-03 | 2015-01-03 | Democrat | 7 | http://mcintyre.house.gov | 2428 Rayburn HOB; Washington DC 20515-3307 | 202-225-2731 | 202-225-5773 | https://mcintyreforms.house.gov/forms/writeyourrep/ | 2428 Rayburn House Office Building | http://mcintyre.house.gov/index.php?format=feed&type=rss | ||||||
39953 | 39953 | Michael Michaud M001149 | rep | ME | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://michaud.house.gov | 1724 Longworth HOB; Washington DC 20515-1902 | 202-225-6306 | 202-225-2943 | http://michaud.house.gov/email | 1724 Longworth House Office Building | http://michaud.house.gov/rss.xml | ||||||
39981 | 39981 | George Miller M000725 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 11 | http://georgemiller.house.gov | 2205 Rayburn HOB; Washington DC 20515-0511 | 202-225-2095 | 202-225-5609 | https://georgemiller.house.gov/contact-me/email-me | 2205 Rayburn House Office Building | http://georgemiller.house.gov/rss.xml | ||||||
39993 | 39993 | James Moran M000933 | rep | VA | 2013-01-03 | 2015-01-03 | Democrat | 8 | http://moran.house.gov | 2252 Rayburn HOB; Washington DC 20515-4608 | 202-225-4376 | 202-225-0017 | https://moran.house.gov/contact-me | 2252 Rayburn House Office Building | http://moran.house.gov/rss.xml | ||||||
39996 | 39996 | William Owens O000169 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 21 | http://owens.house.gov | 405 Cannon HOB; Washington DC 20515-3221 | 202-225-4611 | 202-226-0621 | http://owens.house.gov/contact/ | 405 Cannon House Office Building | http://owens.house.gov/news/rss.aspx | ||||||
40008 | 40008 | Ed Pastor P000099 | rep | AZ | 2013-01-03 | 2015-01-03 | Democrat | 7 | http://www.pastor.house.gov | 2465 Rayburn HOB; Washington DC 20515-0307 | 202-225-4065 | 202-225-1655 | https://pastor.house.gov/email-me | 2465 Rayburn House Office Building | http://www.house.gov/index.php?format=feed&type=rss | ||||||
40045 | 40045 | Nick Rahall R000011 | rep | WV | 2013-01-03 | 2015-01-03 | Democrat | 3 | http://rahall.house.gov | 2307 Rayburn HOB; Washington DC 20515-4803 | 202-225-3452 | 202-225-9061 | https://rahall.house.gov/contact-me/email-me | 2307 Rayburn House Office Building | http://rahall.house.gov/rss.xml | ||||||
40059 | 40059 | Allyson Schwartz S001162 | rep | PA | 2013-01-03 | 2015-01-03 | Democrat | 13 | http://schwartz.house.gov | 1227 Longworth HOB; Washington DC 20515-3813 | 202-225-6111 | 202-226-0611 | http://schwartz.house.gov/serving-you/email-me | 1227 Longworth House Office Building | http://schwartz.house.gov/rss.xml | ||||||
40078 | 40078 | John Tierney T000266 | rep | MA | 2013-01-03 | 2015-01-03 | Democrat | 6 | http://tierney.house.gov | 2238 Rayburn HOB; Washington DC 20515-2106 | 202-225-8020 | 202-225-5915 | https://tierney.house.gov/contact/email-me | 2238 Rayburn House Office Building | http://tierney.house.gov/rss.xml | ||||||
40098 | 40098 | Henry Waxman W000215 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 33 | http://waxman.house.gov | 2204 Rayburn HOB; Washington DC 20515-0533 | 202-225-3976 | 202-225-4099 | https://waxman.house.gov/contact-me/email-me | 2204 Rayburn House Office Building | http://waxman.house.gov/rss.xml | ||||||
40117 | 40117 | Ron Barber B001279 | rep | AZ | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://barber.house.gov | 1029 Longworth HOB; Washington DC 20515-0302 | 202-225-2542 | 202-225-0378 | https://barber.house.gov/contact/email-me | 1029 Longworth House Office Building | http://barber.house.gov/rss.xml | ||||||
40121 | 40121 | Daniel Maffei M001171 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 24 | http://maffei.house.gov | 422 Cannon HOB; Washington DC 20515-3224 | 202-225-3701 | 202-225-4042 | https://maffei.house.gov/email-me | 422 Cannon House Office Building | http://maffei.house.gov/rss.xml | ||||||
40122 | 40122 | Gloria Negrete McLeod N000187 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 35 | http://negretemcleod.house.gov | 1641 Longworth HOB; Washington DC 20515-0535 | 202-225-6161 | 202-225-8671 | http://negretemcleod.house.gov/EmailGloria | 1641 Longworth House Office Building | http://negretemcleod.house.gov/rss.xml | ||||||
40123 | 40123 | Joe Garcia G000573 | rep | FL | 2013-01-03 | 2015-01-03 | Democrat | 26 | http://garcia.house.gov | 1440 Longworth HOB; Washington DC 20515-0926 | 202-225-2778 | http://garciaforms.house.gov/email-me/ | 1440 Longworth House Office Building | http://garcia.house.gov/rss.xml | |||||||
40124 | 40124 | William Enyart E000292 | rep | IL | 2013-01-03 | 2015-01-03 | Democrat | 12 | http://enyart.house.gov | 1722 Longworth HOB; Washington DC 20515-1312 | 202-225-5661 | http://enyart.house.gov/contact | 1722 Longworth House Office Building | http://enyart.house.gov/rss.xml | |||||||
40126 | 40126 | Pete Gallego G000572 | rep | TX | 2013-01-03 | 2015-01-03 | Democrat | 23 | http://gallego.house.gov | 431 Cannon HOB; Washington DC 20515-4323 | 202-225-4511 | 210-927-4903 | https://gallego.house.gov/contact/email-me | 431 Cannon House Office Building | http://gallego.house.gov/rss.xml | ||||||
40176 | 40176 | Chaka Fattah F000043 | rep | PA | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://fattah.house.gov | 2301 Rayburn HOB; Washington DC 20515-3802 | 202-225-4001 | 202-225-5392 | https://fattahforms.house.gov/contact-rep-fattah | 2301 Rayburn House Office Building | http://www.house.gov/common/rss//index.cfm?rss=34 | ||||||
40191 | 40191 | Janice Hahn H001063 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 44 | http://hahn.house.gov | 404 Cannon HOB; Washington DC 20515-0544 | 202-225-8220 | 202-226-7290 | https://hahn.house.gov/contact-me/email-me | 404 Cannon House Office Building | http://hahn.house.gov/rss.xml | ||||||
40265 | 40265 | Corrine Brown B000911 | rep | FL | 2013-01-03 | 2015-01-03 | Democrat | 5 | http://corrinebrown.house.gov | 2111 Rayburn HOB; Washington DC 20515-0905 | 202-225-0123 | 202-225-2256 | https://forms.house.gov/corrinebrown/webforms/contact-me.shtml | 2111 Rayburn House Office Building | http://corrinebrown.house.gov/index.php?option=com_ninjarsssyndicator&feed_id=1&format=raw | ||||||
40275 | 40275 | Lois Capps C001036 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 24 | http://capps.house.gov | 2231 Rayburn HOB; Washington DC 20515-0524 | 202-225-3601 | 202-225-5632 | https://capps.house.gov/contact-me/email-me | 2231 Rayburn House Office Building | http://capps.house.gov/rss.xml | ||||||
40278 | 40278 | John Carney C001083 | rep | DE | 2013-01-03 | 2015-01-03 | Democrat | 0 | http://johncarney.house.gov | 1406 Longworth HOB; Washington DC 20515-0800 | 202-225-4165 | 202-225-2291 | https://forms.house.gov/carney/webforms/email-me.shtml | 1406 Longworth House Office Building | http://johncarney.house.gov/index.php?format=feed&type=rss | ||||||
40291 | 40291 | Donna Edwards E000290 | rep | MD | 2013-01-03 | 2015-01-03 | Democrat | 4 | http://donnaedwards.house.gov | 2445 Rayburn HOB; Washington DC 20515-2004 | 202-225-8699 | 202-225-8714 | https://forms.house.gov/formdonnaedwards/issue_subscribe.shtml | 2445 Rayburn House Office Building | http://www.house.gov/common/rss/?rss=24 | ||||||
40306 | 40306 | Sam Farr F000030 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 20 | http://www.farr.house.gov | 1126 Longworth HOB; Washington DC 20515-0520 | 202-225-2861 | 202-225-6791 | https://forms.house.gov/farr/webforms/issue_subscribe.html | 1126 Longworth House Office Building | http://www.farr.house.gov/index.php?format=feed&type=rss | ||||||
40351 | 40351 | Rubén Hinojosa H000636 | rep | TX | 2013-01-03 | 2015-01-03 | Democrat | 15 | http://hinojosa.house.gov | 2262 Rayburn HOB; Washington DC 20515-4315 | 202-225-2531 | 202-225-5688 | https://hinojosa.house.gov/contact-me/email-me | 2262 Rayburn House Office Building | http://hinojosa.house.gov/rss.xml | ||||||
40359 | 40359 | Michael Honda H001034 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 17 | http://honda.house.gov | 1713 Longworth HOB; Washington DC 20515-0517 | 202-225-2631 | 202-225-2699 | http://honda.house.gov/contact | 1713 Longworth House Office Building | http://www.house.gov/index.php?format=feed&type=rss | ||||||
40373 | 40373 | Steve Israel I000057 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 3 | http://israel.house.gov | 2457 Rayburn HOB; Washington DC 20515-3203 | 202-225-3335 | 202-225-4669 | https://israel.house.gov/contact/email-me | 2457 Rayburn House Office Building | http://israel.house.gov/index.php?format=feed&type=rss | ||||||
40394 | 40394 | Jim McDermott M000404 | rep | WA | 2013-01-03 | 2015-01-03 | Democrat | 7 | http://mcdermott.house.gov | 1035 Longworth HOB; Washington DC 20515-4707 | 202-225-3106 | 202-225-6197 | https://forms.house.gov/mcdermott/webforms/new/contact.shtml | 1035 Longworth House Office Building | http://mcdermott.house.gov/index.php?format=feed&type=rss | ||||||
40427 | 40427 | Pedro Pierluisi P000596 | rep | PR | 2013-01-03 | 2017-01-03 | Democrat | 0 | http://pierluisi.house.gov | 2410 Rayburn HOB; Washington DC 20515-5401 | 202-225-2615 | 202-225-2154 | https://pierluisi.house.gov/contact/email-me | 2410 Rayburn House Office Building | http://pierluisi.house.gov/rss.xml | ||||||
40459 | 40459 | Charles Rangel R000053 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 13 | http://rangel.house.gov | 2354 Rayburn HOB; Washington DC 20515-3213 | 202-225-4365 | 202-225-0816 | https://rangel.house.gov/contact-me/email-me | 2354 Rayburn House Office Building | http://rangel.house.gov/rss.xml | ||||||
40475 | 40475 | Loretta Sanchez S000030 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 46 | http://lorettasanchez.house.gov | 1114 Longworth HOB; Washington DC 20515-0546 | 202-225-2965 | 202-225-5859 | https://lorettasanchez.house.gov/contact-me/email-me | 1114 Longworth House Office Building | http://lorettasanchez.house.gov/rss.xml | ||||||
40493 | 40493 | Alan Grayson G000556 | rep | FL | 2013-01-03 | 2015-01-03 | Democrat | 9 | http://grayson.house.gov | 430 Cannon HOB; Washington DC 20515-0909 | 202-225-9889 | 202-225-9742 | https://grayson.house.gov/contact/email-me | 430 Cannon House Office Building | http://grayson.house.gov/rss.xml | ||||||
40495 | 40495 | Patrick Murphy M001191 | rep | FL | 2013-01-03 | 2015-01-03 | Democrat | 18 | http://patrickmurphy.house.gov | 1517 Longworth HOB; Washington DC 20515-0918 | 202-225-3026 | 202-225-8398 | http://patrickmurphy.house.gov/contact/ | 1517 Longworth House Office Building | http://patrickmurphy.house.gov/news/rss.aspx | ||||||
40522 | 40522 | Xavier Becerra B000287 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 34 | http://becerra.house.gov | 1226 Longworth HOB; Washington DC 20515-0534 | 202-225-6235 | 202-225-2202 | http://becerraforms.house.gov/forms/writeyourrep/ | 1226 Longworth House Office Building | http://becerra.house.gov/index.php?format=feed&type=rss | ||||||
40579 | 40579 | John Conyers C000714 | rep | MI | 2013-01-03 | 2015-01-03 | Democrat | 13 | http://conyers.house.gov | 2426 Rayburn HOB; Washington DC 20515-2213 | 202-225-5126 | 202-225-0072 | https://conyers.house.gov/index.cfm/online-contact-form | 2426 Rayburn House Office Building | http://conyers.house.gov/index.cfm/rss/feed | ||||||
40615 | 40615 | Louise Slaughter S000480 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 25 | http://www.louise.house.gov | 2469 Rayburn HOB; Washington DC 20515-3225 | 202-225-3615 | 202-225-7822 | https://louise.house.gov/contact-louise | 2469 Rayburn House Office Building | http://louise.house.gov/index.php?format=feed&type=rss | ||||||
40667 | 40667 | Michelle Lujan Grisham L000580 | rep | NM | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://lujangrisham.house.gov | 214 Cannon HOB; Washington DC 20515-3101 | 202-225-6316 | 202-225-4975 | http://lujangrisham.house.gov/contact/email-me/ | 214 Cannon House Office Building | http://lujangrisham.house.gov/rss.xml | ||||||
40680 | 40680 | Claire McCaskill M001170 | sen | MO | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.mccaskill.senate.gov | 503 Hart Senate Office Building Washington DC 20510 | 202-224-6154 | 202-228-6326 | http://www.mccaskill.senate.gov/contact | 503 Hart Senate Office Building | senior | http://mccaskill.senate.gov/rss/?p=news | |||||
40689 | 40689 | Bill Nelson N000032 | sen | FL | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.billnelson.senate.gov | 716 Hart Senate Office Building Washington DC 20510 | 202-224-5274 | 202-228-2183 | https://www.billnelson.senate.gov/contact-bill | 716 Hart Senate Office Building | senior | ||||||
40720 | 40720 | Madeleine Bordallo B001245 | rep | GU | 2013-01-03 | 2015-01-03 | Democrat | 0 | http://bordallo.house.gov | 2441 Rayburn HOB; Washington DC 20515-5301 | 202-225-1188 | 202-226-0341 | https://bordallo.house.gov/contact-me | 2441 Rayburn House Office Building | http://bordallo.house.gov/rss.xml | ||||||
40731 | 40731 | Robert Brady B001227 | rep | PA | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://brady.house.gov | 102 Cannon HOB; Washington DC 20515-3801 | 202-225-4731 | 202-225-0088 | https://brady.house.gov/contact-me/email-me | 102 Cannon House Office Building | http://brady.house.gov/rss.xml | ||||||
40741 | 40741 | Michael Capuano C001037 | rep | MA | 2013-01-03 | 2015-01-03 | Democrat | 7 | http://www.house.gov/capuano | 1414 Longworth HOB; Washington DC 20515-2107 | 202-225-5111 | 202-225-9322 | http://www.house.gov/capuano/contact/email.shtml | 1414 Longworth House Office Building | |||||||
40756 | 40756 | Joseph Crowley C001038 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 14 | http://crowley.house.gov | 1436 Longworth HOB; Washington DC 20515-3214 | 202-225-3965 | 202-225-1909 | https://crowley.house.gov/contact-me/email-me | 1436 Longworth House Office Building | http://crowley.house.gov/rss.xml | ||||||
40775 | 40775 | Joe Donnelly D000607 | sen | IN | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.donnelly.senate.gov | 720 Hart Senate Office Building Washington DC 20510 | 202-224-4814 | 202-225-6798 | https://www.donnelly.senate.gov/contact/email-joe | 720 Hart Senate Office Building | senior | http://www.donnelly.senate.gov/rss/feeds/?type=all | |||||
40795 | 40795 | Keith Ellison E000288 | rep | MN | 2013-01-03 | 2015-01-03 | Democrat | 5 | http://ellison.house.gov | 2244 Rayburn HOB; Washington DC 20515-2305 | 202-225-4755 | 202-225-4886 | http://ellison.house.gov/contact | 2244 Rayburn House Office Building | http://ellison.house.gov/index.php?format=feed&type=rss | ||||||
40844 | 40844 | Gene Green G000410 | rep | TX | 2013-01-03 | 2015-01-03 | Democrat | 29 | http://green.house.gov | 2470 Rayburn HOB; Washington DC 20515-4329 | 202-225-1688 | 202-225-9903 | https://green.house.gov/contact-me/email-me | 2470 Rayburn House Office Building | http://green.house.gov/rss.xml | ||||||
40857 | 40857 | Luis Gutiérrez G000535 | rep | IL | 2013-01-03 | 2015-01-03 | Democrat | 4 | http://gutierrez.house.gov | 2408 Rayburn HOB; Washington DC 20515-1304 | 202-225-8203 | 202-225-7810 | http://gutierrezforms.house.gov/contact/ | 2408 Rayburn House Office Building | http://gutierrez.house.gov/rss.xml | ||||||
40920 | 40920 | Sander Levin L000263 | rep | MI | 2013-01-03 | 2015-01-03 | Democrat | 9 | http://levin.house.gov | 1236 Longworth HOB; Washington DC 20515-2209 | 202-225-4961 | 202-226-1033 | https://levin.house.gov/contact-me/email-me | 1236 Longworth House Office Building | http://levin.house.gov/rss.xml | ||||||
40960 | 40960 | Jared Polis P000598 | rep | CO | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://polis.house.gov | 1433 Longworth HOB; Washington DC 20515-0602 | 202-225-2161 | 202-226-7840 | https://polis.house.gov/forms/writeyourrep/default.aspx | 1433 Longworth House Office Building | http://polis.house.gov/news/rss.aspx | ||||||
41074 | 41074 | Niki Tsongas T000465 | rep | MA | 2013-01-03 | 2015-01-03 | Democrat | 3 | http://tsongas.house.gov | 1607 Longworth HOB; Washington DC 20515-2103 | 202-225-3411 | 202-226-0771 | https://tsongas.house.gov/e-mail-niki/ | 1607 Longworth House Office Building | http://tsongas.house.gov/rss/press-releases.xml | ||||||
41080 | 41080 | Timothy Walz W000799 | rep | MN | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://walz.house.gov | 1034 Longworth HOB; Washington DC 20515-2301 | 202-225-2472 | 202-225-3433 | http://walz.house.gov/contact | 1034 Longworth House Office Building | http://walz.house.gov/index.php?format=feed&type=rss | ||||||
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 | ||||||
41098 | 41098 | John Delaney D000620 | rep | MD | 2013-01-03 | 2015-01-03 | Democrat | 6 | http://delaney.house.gov | 1632 Longworth HOB; Washington DC 20515-2006 | 202-225-2721 | https://delaney.house.gov/contact/email-me | 1632 Longworth House Office Building | http://delaney.house.gov/rss.xml | |||||||
41104 | 41104 | Richard Nolan N000127 | rep | MN | 2013-01-03 | 2015-01-03 | Democrat | 8 | http://nolan.house.gov | 2447 Rayburn HOB; Washington DC 20515-2308 | 202-225-6211 | https://nolan.house.gov/contact/email-me | 2447 Rayburn House Office Building | http://nolan.house.gov/rss.xml | |||||||
41110 | 41110 | Heidi Heitkamp H001069 | sen | ND | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.heitkamp.senate.gov/public | 516 Hart Senate Office Building Washington DC 20510 | 202-224-2043 | 202-224-7776 | http://www.heitkamp.senate.gov/public/index.cfm/contact | 516 Hart Senate Office Building | junior | http://www.heitkamp.senate.gov/public/index.cfm/rss/feed | |||||
41114 | 41114 | Beto O’Rourke O000170 | rep | TX | 2013-01-03 | 2015-01-03 | Democrat | 16 | http://orourke.house.gov | 1721 Longworth HOB; Washington DC 20515-4316 | 202-225-4831 | https://orourkeforms.house.gov/forms/writeyourrep/ | 1721 Longworth House Office Building | http://orourke.house.gov/rss.xml | |||||||
41155 | 41155 | Colleen Hanabusa H001050 | rep | HI | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://hanabusa.house.gov | 238 Cannon HOB; Washington DC 20515-1101 | 202-225-2726 | 202-225-4580 | https://hanabusa.house.gov/contact-me/email-me | 238 Cannon House Office Building | http://hanabusa.house.gov/rss.xml | ||||||
41160 | 41160 | Carol Shea-Porter S001170 | rep | NH | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://shea-porter.house.gov | 1530 Longworth HOB; Washington DC 20515-2901 | 202-225-5456 | 202-228-6362 | https://shea-porter.house.gov/contact/email-me | 1530 Longworth House Office Building | http://shea-porter.house.gov/rss.xml | ||||||
41205 | 41205 | Elijah Cummings C000984 | rep | MD | 2013-01-03 | 2015-01-03 | Democrat | 7 | http://cummings.house.gov | 2235 Rayburn HOB; Washington DC 20515-2007 | 202-225-4741 | 202-225-3178 | https://cummings.house.gov/contact-me/email-me | 2235 Rayburn House Office Building | http://cummings.house.gov/rss.xml | ||||||
41242 | 41242 | John Lewis L000287 | rep | GA | 2013-01-03 | 2015-01-03 | Democrat | 5 | http://johnlewis.house.gov | 343 Cannon HOB; Washington DC 20515-1005 | 202-225-3801 | 202-225-0351 | https://johnlewis.house.gov/contact-me/email-me-zip | 343 Cannon House Office Building | http://johnlewis.house.gov/rss.xml | ||||||
41305 | 41305 | Wm. Clay C001049 | rep | MO | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://lacyclay.house.gov | 2418 Rayburn HOB; Washington DC 20515-2501 | 202-225-2406 | 202-226-3717 | http://lacyclay.house.gov/contact-form/ | 2418 Rayburn House Office Building | |||||||
41323 | 41323 | Susan Davis D000598 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 53 | http://www.house.gov/susandavis | 1526 Longworth HOB; Washington DC 20515-0553 | 202-225-2040 | 202-225-2948 | https://susandavisforms.house.gov/forms/writeyourrep/ | 1526 Longworth House Office Building | |||||||
41339 | 41339 | Eliot Engel E000179 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 16 | http://engel.house.gov | 2161 Rayburn HOB; Washington DC 20515-3216 | 202-225-2464 | 202-225-5513 | https://engel.house.gov/write-your-rep1 | 2161 Rayburn House Office Building | |||||||
41378 | 41378 | Daniel Lipinski L000563 | rep | IL | 2013-01-03 | 2015-01-03 | Democrat | 3 | http://www.lipinski.house.gov | 1717 Longworth HOB; Washington DC 20515-1303 | 202-225-5701 | 202-225-1012 | https://lipinskiforms.house.gov/contact-form | 1717 Longworth House Office Building | http://www.lipinski.house.gov/common/rss//index.cfm?rss=25 | ||||||
41385 | 41385 | David Loebsack L000565 | rep | IA | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://loebsack.house.gov | 1527 Longworth HOB; Washington DC 20515-1502 | 202-225-6576 | 202-226-0757 | https://loebsack.house.gov/forms/writeyourrep/ | 1527 Longworth House Office Building | http://loebsack.house.gov/news/rss.aspx | ||||||
41401 | 41401 | Nita Lowey L000480 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 17 | http://lowey.house.gov | 2365 Rayburn HOB; Washington DC 20515-3217 | 202-225-6506 | 202-225-0546 | https://lowey.house.gov/contact-form/ | 2365 Rayburn House Office Building | http://www.house.gov/common/rss/?rss=18 | ||||||
41430 | 41430 | Collin Peterson P000258 | rep | MN | 2013-01-03 | 2015-01-03 | Democrat | 7 | http://collinpeterson.house.gov | 2109 Rayburn HOB; Washington DC 20515-2307 | 202-225-2165 | 202-225-1593 | https://collinpeterson.house.gov/contact-me/email-me | 2109 Rayburn House Office Building | http://collinpeterson.house.gov/rss.xml | ||||||
41478 | 41478 | José Serrano S000248 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 15 | http://serrano.house.gov | 2227 Rayburn HOB; Washington DC 20515-3215 | 202-225-4361 | 202-225-6001 | https://serrano.house.gov/contact-me/email-me | 2227 Rayburn House Office Building | http://serrano.house.gov/rss.xml | ||||||
41526 | 41526 | Peter Visclosky V000108 | rep | IN | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://visclosky.house.gov | 2256 Rayburn HOB; Washington DC 20515-1401 | 202-225-2461 | 202-225-2493 | https://visclosky.house.gov/contact-pete/email-pete | 2256 Rayburn House Office Building | http://visclosky.house.gov/rss.xml | ||||||
41554 | 41554 | Tulsi Gabbard G000571 | rep | HI | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://gabbard.house.gov | 502 Cannon HOB; Washington DC 20515-1102 | 202-225-4906 | 202-225-4987 | https://forms.house.gov/formsgabbard/webforms/email-me.shtml | 502 Cannon House Office Building | http://gabbard.house.gov/rss.xml | ||||||
41562 | 41562 | Joseph Kennedy K000379 | rep | MA | 2013-01-03 | 2015-01-03 | Democrat | 4 | http://kennedy.house.gov | 1218 Longworth HOB; Washington DC 20515-2104 | 202-225-5931 | 202-225-0182 | https://kennedy.house.gov/contact/email-me | 1218 Longworth House Office Building | http://kennedy.house.gov/rss.xml | ||||||
41570 | 41570 | Denny Heck H001064 | rep | WA | 2013-01-03 | 2015-01-03 | Democrat | 10 | http://dennyheck.house.gov | 425 Cannon HOB; Washington DC 20515-4710 | 202-225-9740 | 202-225-0129 | https://dennyheck.house.gov/contact/email-me | 425 Cannon House Office Building | http://dennyheck.house.gov/rss.xml | ||||||
41612 | 41612 | Cedric Richmond R000588 | rep | LA | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://richmond.house.gov | 240 Cannon HOB; Washington DC 20515-1802 | 202-225-6636 | 202-225-1988 | https://richmond.house.gov/contact-me/email-me | 240 Cannon House Office Building | http://richmond.house.gov/rss.xml | ||||||
41624 | 41624 | Marcia Fudge F000455 | rep | OH | 2013-01-03 | 2015-01-03 | Democrat | 11 | http://fudge.house.gov | 2344 Rayburn HOB; Washington DC 20515-3511 | 202-225-7032 | 202-225-1339 | https://fudgeforms.house.gov/contact-form | 2344 Rayburn House Office Building | http://fudge.house.gov/common/rss//index.cfm?rss=25 | ||||||
41641 | 41641 | Alcee Hastings H000324 | rep | FL | 2013-01-03 | 2015-01-03 | Democrat | 20 | http://alceehastings.house.gov | 2353 Rayburn HOB; Washington DC 20515-0920 | 202-225-1313 | 202-225-1171 | https://alceehastings.house.gov/forms/writeyourrep/?zip5=33407&zip4=3224 | 2353 Rayburn House Office Building | http://www.alceehastings.house.gov/news/rss.aspx | ||||||
41698 | 41698 | Filemon Vela V000132 | rep | TX | 2013-01-03 | 2015-01-03 | Democrat | 34 | http://vela.house.gov | 437 Cannon HOB; Washington DC 20515-4334 | 202-225-9901 | 202-225-9770 | https://forms.house.gov/vela/webforms/email-me.shtml | 437 Cannon House Office Building | http://vela.house.gov/rss.xml | ||||||
41722 | 41722 | Theodore Deutch D000610 | rep | FL | 2013-01-03 | 2015-01-03 | Democrat | 21 | http://teddeutch.house.gov | 1024 Longworth HOB; Washington DC 20515-0921 | 202-225-3001 | 202-225-5974 | https://teddeutch.house.gov/forms/writeyourrep/default.aspx | 1024 Longworth House Office Building | http://teddeutch.house.gov/news/rss.aspx | ||||||
41738 | 41738 | Sherrod Brown B000944 | sen | OH | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.brown.senate.gov | 713 Hart Senate Office Building Washington DC 20510 | 202-224-2315 | 202-228-6321 | http://www.brown.senate.gov/contact/ | 713 Hart Senate Office Building | senior | http://www.brown.senate.gov/rss/feeds/?type=all& | |||||
41743 | 41743 | Maria Cantwell C000127 | sen | WA | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.cantwell.senate.gov | 511 Hart Senate Office Building Washington DC 20510 | 202-224-3441 | 202-228-0514 | http://www.cantwell.senate.gov/public/index.cfm/email-maria | 511 Hart Senate Office Building | junior | http://www.cantwell.senate.gov/public/index.cfm/rss/feed | |||||
41756 | 41756 | Benjamin Cardin C000141 | sen | MD | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.cardin.senate.gov | 509 Hart Senate Office Building Washington DC 20510 | 202-224-4524 | 202-224-1651 | http://www.cardin.senate.gov/contact/ | 509 Hart Senate Office Building | senior | http://www.cardin.senate.gov/rss/feeds/?type=all | |||||
41765 | 41765 | Thomas Carper C000174 | sen | DE | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.carper.senate.gov/public | 513 Hart Senate Office Building Washington DC 20510 | 202-224-2441 | 202-228-2190 | http://www.carper.senate.gov/public/index.cfm/email-senator-carper | 513 Hart Senate Office Building | senior | http://www.carper.senate.gov/public/index.cfm/rss/feed | |||||
41768 | 41768 | Robert Casey C001070 | sen | PA | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.casey.senate.gov | 393 Russell Senate Office Building Washington DC 20510 | 202-224-6324 | 202-228-0604 | https://www.casey.senate.gov/contact/ | 393 Russell Senate Office Building | senior | http://www.casey.senate.gov/rss/feeds/?all | |||||
41774 | 41774 | Dianne Feinstein F000062 | sen | CA | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.feinstein.senate.gov | 331 Hart Senate Office Building Washington DC 20510 | 202-224-3841 | 202-228-3954 | https://www.feinstein.senate.gov/public/index.cfm/e-mail-me | 331 Hart Senate Office Building | senior | http://www.feinstein.senate.gov/public/?a=rss.feed | |||||
41777 | 41777 | Amy Klobuchar K000367 | sen | MN | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.klobuchar.senate.gov | 302 Hart Senate Office Building Washington DC 20510 | 202-224-3244 | 202-228-2186 | http://www.klobuchar.senate.gov/public/index.cfm/contact | 302 Hart Senate Office Building | senior | ||||||
41788 | 41788 | Robert Menendez M000639 | sen | NJ | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.menendez.senate.gov | 528 Hart Senate Office Building Washington DC 20510 | 202-224-4744 | 202-228-2197 | https://www.menendez.senate.gov/contact | 528 Hart Senate Office Building | senior | http://www.menendez.senate.gov/rss/feeds/index.cfm?type=news | |||||
41805 | 41805 | Debbie Stabenow S000770 | sen | MI | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.stabenow.senate.gov | 731 Hart Senate Office Building Washington DC 20510 | 202-224-4822 | 202-228-0325 | https://www.stabenow.senate.gov/contact | 731 Hart Senate Office Building | senior | http://stabenow.senate.gov/rss/?p=news | |||||
41808 | 41808 | Jon Tester T000464 | sen | MT | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.tester.senate.gov | 311 Hart Senate Office Building Washington DC 20510 | 202-224-2644 | 202-224-8594 | https://www.tester.senate.gov/?p=email_senator | 311 Hart Senate Office Building | senior | http://www.tester.senate.gov/rss/?p=hot_topic | |||||
41811 | 41811 | Sheldon Whitehouse W000802 | sen | RI | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.whitehouse.senate.gov | 530 Hart Senate Office Building Washington DC 20510 | 202-224-2921 | 202-228-6362 | https://www.whitehouse.senate.gov/contact/email-sheldon | 530 Hart Senate Office Building | junior | http://www.whitehouse.senate.gov/rss/feeds/?type=all&cachebuster=1 | |||||
41896 | 41896 | Kirsten Gillibrand G000555 | sen | NY | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.gillibrand.senate.gov | 478 Russell Senate Office Building Washington DC 20510 | 202-224-4451 | 202-228-0282 | https://www.gillibrand.senate.gov/contact/email-me | 478 Russell Senate Office Building | junior | http://www.gillibrand.senate.gov/rss/ | |||||
41902 | 41902 | Joe Manchin M001183 | sen | WV | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.manchin.senate.gov | 306 Hart Senate Office Building Washington DC 20510 | 202-224-3954 | 202-228-0002 | http://www.manchin.senate.gov/public/index.cfm/contact-form | 306 Hart Senate Office Building | senior | http://www.manchin.senate.gov/public/index.cfm/rss/feed |
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);