legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
40,641 rows where type = "rep" sorted by contact_form descending
This data as json, copyable, CSV (advanced)
Suggested facets: start (date), end (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41546 | 41546 | Ted Yoho Y000065 | rep | FL | 2013-01-03 | 2015-01-03 | Republican | 3 | http://yoho.house.gov | 511 Cannon HOB; Washington DC 20515-0903 | 202-225-5744 | https://yoho.house.gov/contact/email-me | 511 Cannon House Office Building | http://yoho.house.gov/rss.xml | |||||||
41547 | 41547 | Ted Yoho Y000065 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 3 | http://yoho.house.gov | 511 Cannon HOB; Washington DC 20515-0903 | 202-225-5744 | https://yoho.house.gov/contact/email-me | 511 Cannon House Office Building | http://yoho.house.gov/rss.xml | |||||||
41084 | 41084 | Kevin Yoder Y000063 | rep | KS | 2013-01-03 | 2015-01-03 | Republican | 3 | http://yoder.house.gov | 215 Cannon HOB; Washington DC 20515-1603 | 202-225-2865 | 202-225-2807 | https://yoder.house.gov/contact/email-me | 215 Cannon House Office Building | http://yoder.house.gov/common/rss/index.cfm?rss=49 | ||||||
41085 | 41085 | Kevin Yoder Y000063 | rep | KS | 2015-01-06 | 2017-01-03 | Republican | 3 | http://yoder.house.gov | 215 Cannon HOB; Washington DC 20515-1603 | 202-225-2865 | 202-225-2807 | https://yoder.house.gov/contact/email-me | 215 Cannon House Office Building | http://yoder.house.gov/common/rss/index.cfm?rss=49 | ||||||
39684 | 39684 | Eric Cantor C001046 | rep | VA | 2011-01-05 | 2013-01-03 | Republican | 7 | http://cantor.house.gov | 303 Cannon HOB; Washington DC 20515-4607 | 202-225-2815 | 202-225-0011 | https://writerep.house.gov/writerep/welcome.shtml | 303 Cannon House Office Building | |||||||
41542 | 41542 | Rob Woodall W000810 | rep | GA | 2013-01-03 | 2015-01-03 | Republican | 7 | http://woodall.house.gov | 1725 Longworth HOB; Washington DC 20515-1007 | 202-225-4272 | 202-225-4696 | https://woodall.house.gov/contact-me/email-me | 1725 Longworth House Office Building | http://woodall.house.gov/rss.xml | ||||||
41543 | 41543 | Rob Woodall W000810 | rep | GA | 2015-01-06 | 2017-01-03 | Republican | 7 | http://woodall.house.gov | 1724 Longworth HOB; Washington DC 20515-1007 | 202-225-4272 | 202-225-4696 | https://woodall.house.gov/contact-me/email-me | 1724 Longworth House Office Building | http://woodall.house.gov/rss.xml | ||||||
43625 | 43625 | Steve Womack W000809 | rep | AR | 2013-01-03 | 2015-01-03 | Republican | 3 | http://womack.house.gov | 1119 Longworth HOB; Washington DC 20515-0403 | 202-225-4301 | 202-225-5713 | https://womack.house.gov/contact/contactform.htm | 1119 Longworth House Office Building | http://womack.house.gov/news/rss.aspx | ||||||
43626 | 43626 | Steve Womack W000809 | rep | AR | 2015-01-06 | 2017-01-03 | Republican | 3 | http://womack.house.gov | 1119 Longworth HOB; Washington DC 20515-0403 | 202-225-4301 | 202-225-5713 | https://womack.house.gov/contact/contactform.htm | 1119 Longworth House Office Building | http://womack.house.gov/news/rss.aspx | ||||||
40115 | 40115 | Frank Wolf W000672 | rep | VA | 2013-01-03 | 2015-01-03 | Republican | 10 | http://wolf.house.gov | 233 Cannon HOB; Washington DC 20515-4610 | 202-225-5136 | 202-225-0437 | https://wolf.house.gov/contact/email-me#.U06IH-ZdUrw | 233 Cannon House Office Building | http://wolf.house.gov/common/rss//index.cfm?rss=34 | ||||||
43619 | 43619 | Robert Wittman W000804 | rep | VA | 2013-01-03 | 2015-01-03 | Republican | 1 | http://www.wittman.house.gov | 2454 Rayburn HOB; Washington DC 20515-4601 | 202-225-4261 | 202-225-4382 | https://wittman.house.gov/contact-form/ | 2454 Rayburn House Office Building | http://www.wittman.house.gov/index.php?format=feed&type=rss | ||||||
43620 | 43620 | Robert Wittman W000804 | rep | VA | 2015-01-06 | 2017-01-03 | Republican | 1 | https://wittman.house.gov | 2454 Rayburn HOB; Washington DC 20515-4601 | 202-225-4261 | 202-225-4382 | https://wittman.house.gov/contact-form/ | 2454 Rayburn House Office Building | http://www.wittman.house.gov/index.php?format=feed&type=rss | ||||||
43611 | 43611 | Frederica Wilson W000808 | rep | FL | 2013-01-03 | 2015-01-03 | Democrat | 24 | http://wilson.house.gov | 208 Cannon HOB; Washington DC 20515-0924 | 202-225-4506 | 202-226-0777 | https://wilsonforms.house.gov/contact-form | 208 Cannon House Office Building | http://wilson.house.gov/common/rss//index.cfm?rss=49 | ||||||
43612 | 43612 | Frederica Wilson W000808 | rep | FL | 2015-01-06 | 2017-01-03 | Democrat | 24 | http://wilson.house.gov | 208 Cannon HOB; Washington DC 20515-0924 | 202-225-4506 | 202-226-0777 | https://wilsonforms.house.gov/contact-form | 208 Cannon House Office Building | http://wilson.house.gov/common/rss//index.cfm?rss=49 | ||||||
43881 | 43881 | Roger Williams W000816 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 25 | http://williams.house.gov | 1122 Longworth HOB; Washington DC 20515-4325 | 202-225-9896 | 512-473-8946 | https://williams.house.gov/contact/email-me | 1122 Longworth House Office Building | http://williams.house.gov/rss.xml | ||||||
43882 | 43882 | Roger Williams W000816 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 25 | http://williams.house.gov | 1323 Longworth HOB; Washington DC 20515-4325 | 202-225-9896 | 512-473-8946 | https://williams.house.gov/contact/email-me | 1323 Longworth House Office Building | http://williams.house.gov/rss.xml | ||||||
40187 | 40187 | Ed Whitfield W000413 | rep | KY | 2013-01-03 | 2015-01-03 | Republican | 1 | http://whitfield.house.gov | 2184 Rayburn HOB; Washington DC 20515-1701 | 202-225-3115 | 202-225-3547 | https://whitfield.house.gov/contact/email-me | 2184 Rayburn House Office Building | http://whitfield.house.gov/rss.xml | ||||||
40188 | 40188 | Ed Whitfield W000413 | rep | KY | 2015-01-06 | 2016-09-07 | Republican | 1 | http://whitfield.house.gov | 2184 Rayburn HOB; Washington DC 20515-1701 | 202-225-3115 | 202-225-3547 | https://whitfield.house.gov/contact/email-me | 2184 Rayburn House Office Building | http://whitfield.house.gov/rss.xml | ||||||
40485 | 40485 | Lynn Westmoreland W000796 | rep | GA | 2013-01-03 | 2015-01-03 | Republican | 3 | http://westmoreland.house.gov | 2433 Rayburn HOB; Washington DC 20515-1003 | 202-225-5901 | 202-225-2515 | https://westmoreland.house.gov/email-me | 2433 Rayburn House Office Building | http://westmoreland.house.gov/index.php?format=feed&type=rss | ||||||
40486 | 40486 | Lynn Westmoreland W000796 | rep | GA | 2015-01-06 | 2017-01-03 | Republican | 3 | http://westmoreland.house.gov | 2202 Rayburn HOB; Washington DC 20515-1003 | 202-225-5901 | 202-225-2515 | https://westmoreland.house.gov/email-me | 2202 Rayburn House Office Building | http://westmoreland.house.gov/index.php?format=feed&type=rss | ||||||
43594 | 43594 | Peter Welch W000800 | rep | VT | 2013-01-03 | 2015-01-03 | Democrat | 0 | http://www.welch.house.gov | 2303 Rayburn HOB; Washington DC 20515-4500 | 202-225-4115 | 202-225-6790 | https://welch.house.gov/email-me | 2303 Rayburn House Office Building | http://www.welch.house.gov/index.php?format=feed&type=rss | ||||||
43595 | 43595 | Peter Welch W000800 | rep | VT | 2015-01-06 | 2017-01-03 | Democrat | 0 | http://welch.house.gov | 2303 Rayburn HOB; Washington DC 20515-4500 | 202-225-4115 | 202-225-6790 | https://welch.house.gov/email-me | 2303 Rayburn House Office Building | http://www.welch.house.gov/index.php?format=feed&type=rss | ||||||
43586 | 43586 | Daniel Webster W000806 | rep | FL | 2013-01-03 | 2015-01-03 | Republican | 10 | http://webster.house.gov | 1039 Longworth HOB; Washington DC 20515-0910 | 202-225-2176 | 202-225-0999 | https://webster.house.gov/contact/contactform.htm | 1039 Longworth House Office Building | http://webster.house.gov/news/rss.aspx | ||||||
43587 | 43587 | Daniel Webster W000806 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 10 | http://webster.house.gov | 1039 Longworth HOB; Washington DC 20515-0910 | 202-225-2176 | 202-225-0999 | https://webster.house.gov/contact/contactform.htm | 1039 Longworth House Office Building | http://webster.house.gov/news/rss.aspx | ||||||
43871 | 43871 | Randy Weber W000814 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 14 | http://weber.house.gov | 510 Cannon HOB; Washington DC 20515-4314 | 202-225-2831 | 202-225-0271 | https://weber.house.gov/contact/email-me | 510 Cannon House Office Building | http://weber.house.gov/rss.xml | ||||||
43872 | 43872 | Randy Weber W000814 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 14 | http://weber.house.gov | 510 Cannon HOB; Washington DC 20515-4314 | 202-225-2831 | 202-225-0271 | https://weber.house.gov/contact/email-me | 510 Cannon House Office Building | http://weber.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 | ||||||
43580 | 43580 | Maxine Waters W000187 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 43 | http://waters.house.gov | 2221 Rayburn HOB; Washington DC 20515-0543 | 202-225-2201 | 202-225-7854 | https://waters.house.gov/contact/contactform.htm | 2221 Rayburn House Office Building | http://waters.house.gov/news/rss.aspx | ||||||
43581 | 43581 | Maxine Waters W000187 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 43 | http://waters.house.gov | 2221 Rayburn HOB; Washington DC 20515-0543 | 202-225-2201 | 202-225-7854 | https://waters.house.gov/contact/contactform.htm | 2221 Rayburn House Office Building | http://waters.house.gov/news/rss.aspx | ||||||
39569 | 39569 | Joe Walsh W000811 | rep | IL | 2011-01-05 | 2013-01-03 | Republican | 8 | http://walsh.house.gov/ | 432 Cannon HOB; Washington DC 20515-1308 | 202-225-3711 | 202-225-7830 | https://walsh.house.gov/contact-me | 432 Cannon House Office Building | |||||||
41712 | 41712 | Jackie Walorski W000813 | rep | IN | 2013-01-03 | 2015-01-03 | Republican | 2 | http://walorski.house.gov | 419 Cannon HOB; Washington DC 20515-1402 | 202-225-3915 | 202-225-6798 | https://walorski.house.gov/contact/email-me | 419 Cannon House Office Building | http://walorski.house.gov/rss.xml | ||||||
41713 | 41713 | Jackie Walorski W000813 | rep | IN | 2015-01-06 | 2017-01-03 | Republican | 2 | http://walorski.house.gov | 419 Cannon HOB; Washington DC 20515-1402 | 202-225-3915 | 202-225-6798 | https://walorski.house.gov/contact/email-me | 419 Cannon House Office Building | http://walorski.house.gov/rss.xml | ||||||
41537 | 41537 | Greg Walden W000791 | rep | OR | 2013-01-03 | 2015-01-03 | Republican | 2 | http://walden.house.gov | 2182 Rayburn HOB; Washington DC 20515-3702 | 202-225-6730 | 202-225-5774 | https://walden.house.gov/e-mail-greg | 2182 Rayburn House Office Building | http://walden.house.gov/common/rss/?rss=100 | ||||||
41538 | 41538 | Greg Walden W000791 | rep | OR | 2015-01-06 | 2017-01-03 | Republican | 2 | http://walden.house.gov | 2185 Rayburn HOB; Washington DC 20515-3702 | 202-225-6730 | 202-225-5774 | https://walden.house.gov/e-mail-greg | 2185 Rayburn House Office Building | http://walden.house.gov/common/rss/?rss=100 | ||||||
43555 | 43555 | Tim Walberg W000798 | rep | MI | 2013-01-03 | 2015-01-03 | Republican | 7 | http://walberg.house.gov | 2436 Rayburn HOB; Washington DC 20515-2207 | 202-225-6276 | 202-225-6281 | https://walberg.house.gov/contact/contactform.htm | 2436 Rayburn House Office Building | http://walberg.house.gov/news/rss.aspx | ||||||
43556 | 43556 | Tim Walberg W000798 | rep | MI | 2015-01-06 | 2017-01-03 | Republican | 7 | http://walberg.house.gov | 2436 Rayburn HOB; Washington DC 20515-2207 | 202-225-6276 | 202-225-6281 | https://walberg.house.gov/contact/contactform.htm | 2436 Rayburn House Office Building | http://walberg.house.gov/news/rss.aspx | ||||||
43795 | 43795 | Ann Wagner W000812 | rep | MO | 2013-01-03 | 2015-01-03 | Republican | 2 | http://wagner.house.gov | 435 Cannon HOB; Washington DC 20515-2502 | 202-225-1621 | https://wagner.house.gov/contact/email-me | 435 Cannon House Office Building | http://wagner.house.gov/rss.xml | |||||||
43796 | 43796 | Ann Wagner W000812 | rep | MO | 2015-01-06 | 2017-01-03 | Republican | 2 | http://wagner.house.gov | 435 Cannon HOB; Washington DC 20515-2502 | 202-225-1621 | https://wagner.house.gov/contact/email-me | 435 Cannon House Office Building | http://wagner.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 | ||||||
41527 | 41527 | Peter Visclosky V000108 | rep | IN | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://visclosky.house.gov | 2328 Rayburn HOB; Washington DC 20515-1401 | 202-225-2461 | 202-225-2493 | https://visclosky.house.gov/contact-pete/email-pete | 2328 Rayburn House Office Building | http://visclosky.house.gov/rss.xml | ||||||
43886 | 43886 | Marc Veasey V000131 | rep | TX | 2013-01-03 | 2015-01-03 | Democrat | 33 | http://veasey.house.gov | 414 Cannon HOB; Washington DC 20515-4333 | 202-225-9897 | https://veaseyforms.house.gov/forms/writeyourrep/ | 414 Cannon House Office Building | http://veasey.house.gov/rss.xml | |||||||
43887 | 43887 | Marc Veasey V000131 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 33 | http://veasey.house.gov | 414 Cannon HOB; Washington DC 20515-4333 | 202-225-9897 | 202-225-9702 | https://veaseyforms.house.gov/forms/writeyourrep/ | 414 Cannon House Office Building | http://veasey.house.gov/rss.xml | ||||||
43753 | 43753 | Juan Vargas V000130 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 51 | http://vargas.house.gov | 1605 Longworth HOB; Washington DC 20515-0551 | 202-225-8045 | 202-225-9073 | https://vargas.house.gov/contact | 1605 Longworth House Office Building | http://vargas.house.gov/rss.xml | ||||||
43754 | 43754 | Juan Vargas V000130 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 51 | http://vargas.house.gov | 1605 Longworth HOB; Washington DC 20515-0551 | 202-225-8045 | 202-225-9073 | https://vargas.house.gov/contact | 1605 Longworth House Office Building | http://vargas.house.gov/rss.xml | ||||||
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 | ||||||
41075 | 41075 | Niki Tsongas T000465 | rep | MA | 2015-01-06 | 2017-01-03 | Democrat | 3 | http://tsongas.house.gov | 1714 Longworth HOB; Washington DC 20515-2103 | 202-225-3411 | 202-226-0771 | https://tsongas.house.gov/e-mail-niki/ | 1714 Longworth House Office Building | http://tsongas.house.gov/rss/press-releases.xml | ||||||
44082 | 44082 | Trent Kelly K000388 | rep | MS | 2015-06-09 | 2017-01-03 | Republican | 1 | https://trentkelly.house.gov | 1427 Longworth HOB; Washington DC 20515-2401 | 202-225-4306 | https://trentkelly.house.gov/contact | 1427 Longworth House Office Building | ||||||||
43492 | 43492 | Paul Tonko T000469 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 20 | http://tonko.house.gov | 2463 Rayburn HOB; Washington DC 20515-3220 | 202-225-5076 | 202-225-5077 | https://tonko.house.gov/email-form1 | 2463 Rayburn House Office Building | http://tonko.house.gov/rss/press-releases.xml | ||||||
43493 | 43493 | Paul Tonko T000469 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 20 | http://tonko.house.gov | 2463 Rayburn HOB; Washington DC 20515-3220 | 202-225-5076 | 202-225-5077 | https://tonko.house.gov/email-form1 | 2463 Rayburn House Office Building | http://tonko.house.gov/rss/press-releases.xml | ||||||
43864 | 43864 | Tom Rice R000597 | rep | SC | 2013-01-03 | 2015-01-03 | Republican | 7 | http://rice.house.gov | 325 Cannon HOB; Washington DC 20515-4007 | 202-225-9895 | 202-225-9690 | https://tomriceforms.house.gov/forms/writeyourrep/ | 325 Cannon House Office Building | http://rice.house.gov/rss.xml | ||||||
43865 | 43865 | Tom Rice R000597 | rep | SC | 2015-01-06 | 2017-01-03 | Republican | 7 | http://rice.house.gov | 223 Cannon HOB; Washington DC 20515-4007 | 202-225-9895 | https://tomriceforms.house.gov/forms/writeyourrep/ | 223 Cannon House Office Building | http://rice.house.gov/rss.xml | |||||||
40533 | 40533 | Tom Price P000591 | rep | GA | 2013-01-03 | 2015-01-03 | Republican | 6 | http://tomprice.house.gov | 100 Cannon HOB; Washington DC 20515-1006 | 202-225-4501 | 202-225-4656 | https://tomprice.house.gov/contact-me | 100 Cannon House Office Building | http://tomprice.house.gov/rss.xml | ||||||
40534 | 40534 | Tom Price P000591 | rep | GA | 2015-01-06 | 2017-01-03 | Republican | 6 | https://tomprice.house.gov | 100 Cannon HOB; Washington DC 20515-1006 | 202-225-4501 | 202-225-4656 | https://tomprice.house.gov/contact-me | 100 Cannon House Office Building | http://tomprice.house.gov/rss.xml | ||||||
43652 | 43652 | Todd Young Y000064 | rep | IN | 2013-01-03 | 2015-01-03 | Republican | 9 | http://toddyoung.house.gov | 1007 Longworth HOB; Washington DC 20515-1409 | 202-225-5315 | 202-226-6866 | https://toddyoungforms.house.gov/give-me-your-opinion | 1007 Longworth House Office Building | http://toddyoung.house.gov/common/rss//index.cfm?rss=49 | ||||||
43653 | 43653 | Todd Young Y000064 | rep | IN | 2015-01-06 | 2017-01-03 | Republican | 9 | http://toddyoung.house.gov | 1007 Longworth HOB; Washington DC 20515-1409 | 202-225-5315 | 202-226-6866 | https://toddyoungforms.house.gov/give-me-your-opinion | 1007 Longworth House Office Building | http://toddyoung.house.gov/common/rss//index.cfm?rss=49 | ||||||
43696 | 43696 | Dina Titus T000468 | rep | NV | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://titus.house.gov | 401 Cannon HOB; Washington DC 20515-2801 | 202-225-5965 | 202-225-3119 | https://titus.house.gov/contact/email-me | 401 Cannon House Office Building | http://titus.house.gov/rss.xml | ||||||
43697 | 43697 | Dina Titus T000468 | rep | NV | 2015-01-06 | 2017-01-03 | Democrat | 1 | https://titus.house.gov | 401 Cannon HOB; Washington DC 20515-2801 | 202-225-5965 | https://titus.house.gov/contact/email-me | 401 Cannon House Office Building | http://titus.house.gov/rss.xml | |||||||
41508 | 41508 | Scott Tipton T000470 | rep | CO | 2013-01-03 | 2015-01-03 | Republican | 3 | http://tipton.house.gov | 218 Cannon HOB; Washington DC 20515-0603 | 202-225-4761 | 202-226-9669 | https://tipton.house.gov/contact-me/email-me | 218 Cannon House Office Building | http://tipton.house.gov/rss.xml | ||||||
41509 | 41509 | Scott Tipton T000470 | rep | CO | 2015-01-06 | 2017-01-03 | Republican | 3 | http://tipton.house.gov | 218 Cannon HOB; Washington DC 20515-0603 | 202-225-4761 | 202-226-9669 | https://tipton.house.gov/contact-me/email-me | 218 Cannon House Office Building | http://tipton.house.gov/rss.xml | ||||||
39855 | 39855 | Tim Griffin G000567 | rep | AR | 2013-01-03 | 2015-01-03 | Republican | 2 | http://griffin.house.gov | 1232 Longworth HOB; Washington DC 20515-0402 | 202-225-2506 | 202-225-5903 | https://timgriffinforms.house.gov/forms/writeyourrep/ | 1232 Longworth House Office Building | http://griffin.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 | ||||||
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 | ||||||
40599 | 40599 | Patrick Tiberi T000462 | rep | OH | 2013-01-03 | 2015-01-03 | Republican | 12 | http://tiberi.house.gov | 106 Cannon HOB; Washington DC 20515-3512 | 202-225-5355 | 202-226-4523 | https://tiberi.house.gov/contact/contactform.htm | 106 Cannon House Office Building | http://tiberi.house.gov/news/rss.aspx | ||||||
40600 | 40600 | Patrick Tiberi T000462 | rep | OH | 2015-01-06 | 2017-01-03 | Republican | 12 | http://tiberi.house.gov | 1203 Longworth HOB; Washington DC 20515-3512 | 202-225-5355 | 202-226-4523 | https://tiberi.house.gov/contact/contactform.htm | 1203 Longworth House Office Building | http://tiberi.house.gov/news/rss.aspx | ||||||
41503 | 41503 | Mac Thornberry T000238 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 13 | http://thornberry.house.gov | 2329 Rayburn HOB; Washington DC 20515-4313 | 202-225-3706 | 202-225-3486 | https://thornberry.house.gov/forms/writeyourrep/ | 2329 Rayburn House Office Building | |||||||
41504 | 41504 | Mac Thornberry T000238 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 13 | http://thornberry.house.gov | 2208 Rayburn HOB; Washington DC 20515-4313 | 202-225-3706 | 202-225-3486 | https://thornberry.house.gov/forms/writeyourrep/ | 2208 Rayburn House Office Building | |||||||
43479 | 43479 | Glenn Thompson T000467 | rep | PA | 2013-01-03 | 2015-01-03 | Republican | 5 | http://thompson.house.gov | 124 Cannon HOB; Washington DC 20515-3805 | 202-225-5121 | 202-225-5796 | https://thompson.house.gov/contact-me/email-me | 124 Cannon House Office Building | http://thompson.house.gov/rss.xml | ||||||
43480 | 43480 | Glenn Thompson T000467 | rep | PA | 2015-01-06 | 2017-01-03 | Republican | 5 | http://thompson.house.gov | 124 Cannon HOB; Washington DC 20515-3805 | 202-225-5121 | 202-225-5796 | https://thompson.house.gov/contact-me/email-me | 124 Cannon House Office Building | http://thompson.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 | ||||||
41723 | 41723 | Theodore Deutch D000610 | rep | FL | 2015-01-06 | 2017-01-03 | Democrat | 21 | http://teddeutch.house.gov | 2447 Rayburn HOB; Washington DC 20515-0921 | 202-225-3001 | 202-225-5974 | https://teddeutch.house.gov/forms/writeyourrep/default.aspx | 2447 Rayburn House Office Building | http://teddeutch.house.gov/news/rss.aspx | ||||||
41721 | 41721 | Theodore Deutch D000610 | rep | FL | 2011-01-05 | 2013-01-03 | Democrat | 19 | http://deutch.house.gov/ | 1024 Longworth HOB; Washington DC 20515-0919 | 202-225-3001 | 202-225-5974 | https://teddeutch.house.gov/Forms/WriteYourRep/default.aspx | 1024 Longworth House Office Building | |||||||
43743 | 43743 | Mark Takano T000472 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 41 | http://takano.house.gov | 1507 Longworth HOB; Washington DC 20515-0541 | 202-225-2305 | https://takano.house.gov/contact/email-me | 1507 Longworth House Office Building | http://takano.house.gov/rss.xml | |||||||
43744 | 43744 | Mark Takano T000472 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 41 | https://takano.house.gov | 1507 Longworth HOB; Washington DC 20515-0541 | 202-225-2305 | 202-225-7018 | https://takano.house.gov/contact/email-me | 1507 Longworth House Office Building | http://takano.house.gov/rss.xml | ||||||
41558 | 41558 | Susan Brooks B001284 | rep | IN | 2013-01-03 | 2015-01-03 | Republican | 5 | http://susanwbrooks.house.gov | 1505 Longworth HOB; Washington DC 20515-1405 | 202-225-2276 | https://susanwbrooks.house.gov/contact/email-me | 1505 Longworth House Office Building | http://susanwbrooks.house.gov/rss.xml | |||||||
41559 | 41559 | Susan Brooks B001284 | rep | IN | 2015-01-06 | 2017-01-03 | Republican | 5 | http://susanwbrooks.house.gov | 1505 Longworth HOB; Washington DC 20515-1405 | 202-225-2276 | 202-225-0016 | https://susanwbrooks.house.gov/contact/email-me | 1505 Longworth House Office Building | http://susanwbrooks.house.gov/rss.xml | ||||||
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 | |||||||
41324 | 41324 | Susan Davis D000598 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 53 | http://susandavis.house.gov | 1214 Longworth HOB; Washington DC 20515-0553 | 202-225-2040 | 202-225-2948 | https://susandavisforms.house.gov/forms/writeyourrep/ | 1214 Longworth House Office Building | |||||||
40119 | 40119 | Steve Stockman S000937 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 36 | http://stockman.house.gov | 326 Cannon HOB; Washington DC 20515-4336 | 202-225-1555 | 202-226-0396 | https://stockman.house.gov/contact/email-me | 326 Cannon House Office Building | http://stockman.house.gov/rss.xml | ||||||
41647 | 41647 | Steve Stivers S001187 | rep | OH | 2013-01-03 | 2015-01-03 | Republican | 15 | http://stivers.house.gov | 1022 Longworth HOB; Washington DC 20515-3515 | 202-225-2015 | 202-225-3529 | https://stivers.house.gov/forms/writeyourrep/ | 1022 Longworth House Office Building | http://stivers.house.gov/news/rss.aspx | ||||||
41648 | 41648 | Steve Stivers S001187 | rep | OH | 2015-01-06 | 2017-01-03 | Republican | 15 | http://stivers.house.gov | 1022 Longworth HOB; Washington DC 20515-3515 | 202-225-2015 | 202-225-3529 | https://stivers.house.gov/forms/writeyourrep/ | 1022 Longworth House Office Building | http://stivers.house.gov/news/rss.aspx | ||||||
43891 | 43891 | Chris Stewart S001192 | rep | UT | 2013-01-03 | 2015-01-03 | Republican | 2 | http://stewart.house.gov | 323 Cannon HOB; Washington DC 20515-4402 | 202-225-9730 | 801-364-5551 | https://stewart.house.gov/contact/email-me | 323 Cannon House Office Building | http://stewart.house.gov/rss.xml | ||||||
43892 | 43892 | Chris Stewart S001192 | rep | UT | 2015-01-06 | 2017-01-03 | Republican | 2 | http://stewart.house.gov | 323 Cannon HOB; Washington DC 20515-4402 | 202-225-9730 | 801-364-5551 | https://stewart.house.gov/contact/email-me | 323 Cannon House Office Building | http://stewart.house.gov/rss.xml | ||||||
40061 | 40061 | Steve Southerland S001186 | rep | FL | 2013-01-03 | 2015-01-03 | Republican | 2 | http://southerland.house.gov | 1229 Longworth HOB; Washington DC 20515-0902 | 202-225-5235 | 202-225-5615 | https://southerland.house.gov/index.cfm/email-me | 1229 Longworth House Office Building | http://southerland.house.gov/index.cfm/rss/feed | ||||||
43385 | 43385 | Albio Sires S001165 | rep | NJ | 2013-01-03 | 2015-01-03 | Democrat | 8 | http://sires.house.gov | 2342 Rayburn HOB; Washington DC 20515-3008 | 202-225-7919 | 202-226-0792 | https://sires.house.gov/contact-me/email-me | 2342 Rayburn House Office Building | http://sires.house.gov/rss.xml | ||||||
43386 | 43386 | Albio Sires S001165 | rep | NJ | 2015-01-06 | 2017-01-03 | Democrat | 8 | http://sires.house.gov | 2342 Rayburn HOB; Washington DC 20515-3008 | 202-225-7919 | 202-226-0792 | https://sires.house.gov/contact-me/email-me | 2342 Rayburn House Office Building | http://sires.house.gov/rss.xml | ||||||
43704 | 43704 | Kyrsten Sinema S001191 | rep | AZ | 2013-01-03 | 2015-01-03 | Democrat | 9 | http://sinema.house.gov | 1237 Longworth HOB; Washington DC 20515-0309 | 202-225-9888 | 202-225-9731 | https://sinemaforms.house.gov/forms/writeyourrep/ | 1237 Longworth House Office Building | http://sinema.house.gov/index.cfm/rss/feed | ||||||
43705 | 43705 | Kyrsten Sinema S001191 | rep | AZ | 2015-01-06 | 2017-01-03 | Democrat | 9 | https://sinema.house.gov | 1530 Longworth HOB; Washington DC 20515-0309 | 202-225-9888 | 202-225-9731 | https://sinemaforms.house.gov/forms/writeyourrep/ | 1530 Longworth House Office Building | http://sinema.house.gov/index.cfm/rss/feed | ||||||
41490 | 41490 | John Shimkus S000364 | rep | IL | 2013-01-03 | 2015-01-03 | Republican | 15 | http://shimkus.house.gov | 2452 Rayburn HOB; Washington DC 20515-1315 | 202-225-5271 | 202-225-5880 | https://shimkus.house.gov/contact/email-me | 2452 Rayburn House Office Building | http://shimkus.house.gov/rss.xml | ||||||
41491 | 41491 | John Shimkus S000364 | rep | IL | 2015-01-06 | 2017-01-03 | Republican | 15 | http://shimkus.house.gov | 2217 Rayburn HOB; Washington DC 20515-1315 | 202-225-5271 | 202-225-5880 | https://shimkus.house.gov/contact/email-me | 2217 Rayburn House Office Building | http://shimkus.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 | ||||||
43341 | 43341 | Terri Sewell S001185 | rep | AL | 2013-01-03 | 2015-01-03 | Democrat | 7 | http://sewell.house.gov | 1133 Longworth HOB; Washington DC 20515-0107 | 202-225-2665 | 202-226-9567 | https://sewell.house.gov/email-me | 1133 Longworth House Office Building | http://sewell.house.gov/rss.xml | ||||||
43342 | 43342 | Terri Sewell S001185 | rep | AL | 2015-01-06 | 2017-01-03 | Democrat | 7 | https://sewell.house.gov | 1133 Longworth HOB; Washington DC 20515-0107 | 202-225-2665 | 202-226-9567 | https://sewell.house.gov/email-me | 1133 Longworth House Office Building | http://sewell.house.gov/rss.xml | ||||||
44463 | 44463 | Pete Sessions S000250 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 32 | http://sessions.house.gov | 2233 Rayburn HOB; Washington DC 20515-4332 | 202-225-2231 | 202-225-5878 | https://sessions.house.gov/index.cfm/contact-form | 2233 Rayburn House Office Building | http://sessions.house.gov/?a=rss.feed | ||||||
44464 | 44464 | Pete Sessions S000250 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 32 | https://sessions.house.gov | 2233 Rayburn HOB; Washington DC 20515-4332 | 202-225-2231 | 202-225-5878 | https://sessions.house.gov/index.cfm/contact-form | 2233 Rayburn House Office Building | http://sessions.house.gov/?a=rss.feed | ||||||
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 | ||||||
41479 | 41479 | José Serrano S000248 | rep | NY | 2015-01-06 | 2017-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 | ||||||
43829 | 43829 | Sean Maloney M001185 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 18 | http://seanmaloney.house.gov | 1529 Longworth HOB; Washington DC 20515-3218 | 202-225-5441 | https://seanmaloney.house.gov/contact/email-me | 1529 Longworth House Office Building | http://seanmaloney.house.gov/rss.xml | |||||||
43830 | 43830 | Sean Maloney M001185 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 18 | http://seanmaloney.house.gov | 1529 Longworth HOB; Washington DC 20515-3218 | 202-225-5441 | 202-225-3289 | https://seanmaloney.house.gov/contact/email-me | 1529 Longworth House Office Building | http://seanmaloney.house.gov/rss.xml | ||||||
43758 | 43758 | Scott Peters P000608 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 52 | http://scottpeters.house.gov | 2410 Rayburn HOB; Washington DC 20515-0552 | 202-225-0508 | 202-225-2558 | https://scottpeters.house.gov/contact/email-me | 2410 Rayburn House Office Building | http://scottpeters.house.gov/rss.xml | ||||||
43759 | 43759 | Scott Peters P000608 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 52 | http://scottpeters.house.gov | 1122 Longworth HOB; Washington DC 20515-0552 | 202-225-0508 | 202-225-2558 | https://scottpeters.house.gov/contact/email-me | 1122 Longworth House Office Building | http://scottpeters.house.gov/rss.xml |
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);