legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
473 rows where "end" is on date 2017-01-03
This data as json, copyable, CSV (advanced)
Suggested facets: party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40200 | 40200 | Kelly Ayotte A000368 | sen | NH | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.ayotte.senate.gov | 144 Russell Senate Office Building Washington DC 20510 | 202-224-3324 | 202-224-4952 | http://www.ayotte.senate.gov/?p=contact | 144 Russell Senate Office Building | junior | http://ayotte.senate.gov/rss/?p=news | |||||
40209 | 40209 | Barbara Boxer B000711 | sen | CA | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.boxer.senate.gov | 112 Hart Senate Office Building Washington DC 20510 | 202-224-3553 | 202-224-0454 | https://www.boxer.senate.gov/contact/shareyourviews.html | 112 Hart Senate Office Building | junior | ||||||
40216 | 40216 | Daniel Coats C000542 | sen | IN | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.coats.senate.gov | 493 Russell Senate Office Building Washington DC 20510 | 202-224-5623 | 202-228-1820 | http://www.coats.senate.gov/contact/ | 493 Russell Senate Office Building | senior | http://www.coats.senate.gov/rss/feeds/?type=all& | |||||
40223 | 40223 | Mark Kirk K000360 | sen | IL | 2011-01-05 | 2017-01-03 | 3 | Republican | https://www.kirk.senate.gov | 524 Hart Senate Office Building Washington DC 20510 | 202-224-2854 | 202-228-4611 | http://www.kirk.senate.gov/?p=comment_on_legislation | 524 Hart Senate Office Building | junior | http://kirk.senate.gov/rss/?p=hot_topic | |||||
40233 | 40233 | Barbara Mikulski M000702 | sen | MD | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.mikulski.senate.gov | 503 Hart Senate Office Building Washington DC 20510 | 202-224-4654 | 202-224-8858 | http://www.mikulski.senate.gov/contact/shareyouropinion.cfm | 503 Hart Senate Office Building | senior | http://www.mikulski.senate.gov/rssfeed.cfm | |||||
40240 | 40240 | Harry Reid R000146 | sen | NV | 2011-01-05 | 2017-01-03 | 3 | Democrat | http://www.reid.senate.gov | 522 Hart Senate Office Building Washington DC 20510 | 202-224-3542 | 202-224-7327 | http://www.reid.senate.gov/contact | 522 Hart Senate Office Building | senior | ||||||
40245 | 40245 | David Vitter V000127 | sen | LA | 2011-01-05 | 2017-01-03 | 3 | Republican | https://www.vitter.senate.gov | 516 Hart Senate Office Building Washington DC 20510 | 202-224-4623 | 202-228-5061 | http://www.vitter.senate.gov/contact/email-senator-vitter | 516 Hart Senate Office Building | senior | http://www.vitter.senate.gov/rss/feeds/?type=all | |||||
40248 | 40248 | Dan Benishek B001271 | rep | MI | 2015-01-06 | 2017-01-03 | Republican | 1 | http://benishek.house.gov | 514 Cannon HOB; Washington DC 20515-2201 | 202-225-4735 | 202- 225-4744 | https://benishek.house.gov/contact-me/email-me | 514 Cannon House Office Building | http://benishek.house.gov/rss.xml | ||||||
40254 | 40254 | Charles Boustany B001255 | rep | LA | 2015-01-06 | 2017-01-03 | Republican | 3 | http://boustany.house.gov | 1431 Longworth HOB; Washington DC 20515-1803 | 202-225-2031 | 202-225-5724 | https://boustanyforms.house.gov/contact-me/ | 1431 Longworth House Office Building | http://www.house.gov/common/rss/index.cfm?rss=82 | ||||||
40266 | 40266 | Corrine Brown B000911 | rep | FL | 2015-01-06 | 2017-01-03 | Democrat | 5 | https://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 | ||||||
40276 | 40276 | Lois Capps C001036 | rep | CA | 2015-01-06 | 2017-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 | ||||||
40279 | 40279 | John Carney C001083 | rep | DE | 2015-01-06 | 2017-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 | ||||||
40287 | 40287 | Ander Crenshaw C001045 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 4 | https://crenshaw.house.gov | 2161 Rayburn HOB; Washington DC 20515-0904 | 202-225-2501 | 202-225-2504 | https://forms.house.gov/write/crenshaw/email-me.shtml | 2161 Rayburn House Office Building | |||||||
40292 | 40292 | Donna Edwards E000290 | rep | MD | 2015-01-06 | 2017-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 | ||||||
40295 | 40295 | Renee Ellmers E000291 | rep | NC | 2015-01-06 | 2017-01-03 | Republican | 2 | http://ellmers.house.gov | 1210 Longworth HOB; Washington DC 20515-3302 | 202-225-4531 | 202- 225-5662 | https://ellmersforms.house.gov/contact-us1 | 1210 Longworth House Office Building | http://ellmers.house.gov/common/rss//index.cfm?rss=49 | ||||||
40307 | 40307 | Sam Farr F000030 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 20 | http://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 | ||||||
40310 | 40310 | Stephen Fincher F000458 | rep | TN | 2015-01-06 | 2017-01-03 | Republican | 8 | http://fincher.house.gov | 2452 Rayburn HOB; Washington DC 20515-4208 | 202-225-4714 | 202-225-1765 | https://fincher.house.gov/contact/email-me#.U06uR_ldWVo | 2452 Rayburn House Office Building | http://fincher.house.gov/rss.xml | ||||||
40314 | 40314 | Michael Fitzpatrick F000451 | rep | PA | 2015-01-06 | 2017-01-03 | Republican | 8 | http://fitzpatrick.house.gov | 2400 Rayburn HOB; Washington DC 20515-3808 | 202-225-4276 | 202- 225-9511 | https://fitzpatrick.house.gov/contact-me/email-me | 2400 Rayburn House Office Building | http://fitzpatrick.house.gov/rss.xml | ||||||
40318 | 40318 | John Fleming F000456 | rep | LA | 2015-01-06 | 2017-01-03 | Republican | 4 | http://fleming.house.gov | 2182 Rayburn HOB; Washington DC 20515-1804 | 202-225-2777 | 202-225-8039 | https://fleming.house.gov/contact/contactform.htm | 2182 Rayburn House Office Building | http://fleming.house.gov/news/rss.aspx | ||||||
40326 | 40326 | J. Forbes F000445 | rep | VA | 2015-01-06 | 2017-01-03 | Republican | 4 | http://forbes.house.gov | 2135 Rayburn HOB; Washington DC 20515-4604 | 202-225-6365 | 202-226-1170 | https://forbes.house.gov/contact/contactform.htm | 2135 Rayburn House Office Building | http://forbes.house.gov/news/rss.aspx | ||||||
40333 | 40333 | Scott Garrett G000548 | rep | NJ | 2015-01-06 | 2017-01-03 | Republican | 5 | http://garrett.house.gov | 2232 Rayburn HOB; Washington DC 20515-3005 | 202-225-4465 | 202-225-9048 | https://garrettforms.house.gov/forms/writeyourrep/?zip5=07452&zip4=3321 | 2232 Rayburn House Office Building | http://garrett.house.gov/rss.xml | ||||||
40336 | 40336 | Christopher Gibson G000564 | rep | NY | 2015-01-06 | 2017-01-03 | Republican | 19 | http://gibson.house.gov | 1708 Longworth HOB; Washington DC 20515-3219 | 202-225-5614 | 202-225-1168 | http://gibson.house.gov/contact/ | 1708 Longworth House Office Building | http://gibson.house.gov/news/rss.aspx | ||||||
40339 | 40339 | Richard Hanna H001051 | rep | NY | 2015-01-06 | 2017-01-03 | Republican | 22 | http://hanna.house.gov | 319 Cannon HOB; Washington DC 20515-3222 | 202-225-3665 | 202-225-1891 | https://hanna.house.gov/email-me | 319 Cannon House Office Building | http://hanna.house.gov/index.php?format=feed&type=rss | ||||||
40342 | 40342 | Joseph Heck H001055 | rep | NV | 2015-01-06 | 2017-01-03 | Republican | 3 | https://heck.house.gov | 132 Cannon HOB; Washington DC 20515-2803 | 202-225-3252 | 202- 225-2185 | https://heck.house.gov/contact-me | 132 Cannon House Office Building | http://heck.house.gov/rss.xml | ||||||
40352 | 40352 | Rubén Hinojosa H000636 | rep | TX | 2015-01-06 | 2017-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 | ||||||
40360 | 40360 | Michael Honda H001034 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 17 | https://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 | ||||||
40363 | 40363 | Tim Huelskamp H001057 | rep | KS | 2015-01-06 | 2017-01-03 | Republican | 1 | http://huelskamp.house.gov | 1110 Longworth HOB; Washington DC 20515-1601 | 202-225-2715 | 202- 225-5124 | https://huelskamp.house.gov/contact/email-me | 1110 Longworth House Office Building | http://huelskamp.house.gov/index.php?format=feed&type=rss | ||||||
40366 | 40366 | Robert Hurt H001060 | rep | VA | 2015-01-06 | 2017-01-03 | Republican | 5 | https://hurt.house.gov | 125 Cannon HOB; Washington DC 20515-4605 | 202-225-4711 | 202-225-5681 | https://hurt.house.gov/index.cfm/email-me | 125 Cannon House Office Building | http://hurt.house.gov/index.cfm/rss/feed | ||||||
40374 | 40374 | Steve Israel I000057 | rep | NY | 2015-01-06 | 2017-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 | ||||||
40381 | 40381 | John Kline K000363 | rep | MN | 2015-01-06 | 2017-01-03 | Republican | 2 | http://kline.house.gov | 2439 Rayburn HOB; Washington DC 20515-2302 | 202-225-2271 | 202-225-2595 | http://kline.house.gov/contact/ | 2439 Rayburn House Office Building | http://kline.house.gov/common/rss/?rss=47 | ||||||
40395 | 40395 | Jim McDermott M000404 | rep | WA | 2015-01-06 | 2017-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 | ||||||
40407 | 40407 | John Mica M000689 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 7 | http://mica.house.gov | 2187 Rayburn HOB; Washington DC 20515-0907 | 202-225-4035 | 202-226-0821 | https://mica.house.gov/contact-form | 2187 Rayburn House Office Building | http://mica.house.gov/common/rss/index.cfm?rss=25 | ||||||
40415 | 40415 | Jeff Miller M001144 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 1 | http://jeffmiller.house.gov | 336 Cannon HOB; Washington DC 20515-0901 | 202-225-4136 | 202-225-3414 | https://jeffmiller.house.gov/contact/contactform.htm | 336 Cannon House Office Building | http://jeffmiller.house.gov/news/rss.aspx | ||||||
40422 | 40422 | Randy Neugebauer N000182 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 19 | http://randy.house.gov | 1424 Longworth HOB; Washington DC 20515-4319 | 202-225-4005 | 202-225-9615 | https://randy.house.gov/contact-me/email-me | 1424 Longworth House Office Building | http://randy.house.gov/rss.xml | ||||||
40425 | 40425 | Richard Nugent N000185 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 11 | https://nugent.house.gov | 1727 Longworth HOB; Washington DC 20515-0911 | 202-225-1002 | 202- 226-6559 | https://nugent.house.gov/contact/email-me | 1727 Longworth House Office Building | http://nugent.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 | ||||||
40437 | 40437 | Joseph Pitts P000373 | rep | PA | 2015-01-06 | 2017-01-03 | Republican | 16 | http://pitts.house.gov | 420 Cannon HOB; Washington DC 20515-3816 | 202-225-2411 | 202-225-2013 | https://pitts.house.gov/contact-me/legislative-contact-form | 420 Cannon House Office Building | http://pitts.house.gov/rss.xml | ||||||
40460 | 40460 | Charles Rangel R000053 | rep | NY | 2015-01-06 | 2017-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 | ||||||
40463 | 40463 | Reid Ribble R000587 | rep | WI | 2015-01-06 | 2017-01-03 | Republican | 8 | http://ribble.house.gov | 1513 Longworth HOB; Washington DC 20515-4908 | 202-225-5665 | 202- 225-5729 | https://ribble.house.gov/contact-me/email-me | 1513 Longworth House Office Building | http://ribble.house.gov/rss.xml | ||||||
40466 | 40466 | Edward Rigell R000589 | rep | VA | 2015-01-06 | 2017-01-03 | Republican | 2 | http://rigell.house.gov | 418 Cannon HOB; Washington DC 20515-4602 | 202-225-4215 | 202-225-4218 | https://rigell.house.gov/contact/contactform.htm | 418 Cannon House Office Building | http://rigell.house.gov/news/rss.aspx | ||||||
40476 | 40476 | Loretta Sanchez S000030 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 46 | http://lorettasanchez.house.gov | 1211 Longworth HOB; Washington DC 20515-0546 | 202-225-2965 | 202-225-5859 | https://lorettasanchez.house.gov/contact-me/email-me | 1211 Longworth House Office Building | http://lorettasanchez.house.gov/rss.xml | ||||||
40480 | 40480 | Marlin Stutzman S001188 | rep | IN | 2015-01-06 | 2017-01-03 | Republican | 3 | http://stutzman.house.gov | 2418 Rayburn HOB; Washington DC 20515-1403 | 202-225-4436 | 202-226-9870 | http://stutzman.house.gov/contacts/new | 2418 Rayburn House Office Building | http://stutzman.house.gov/press_releases.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 | ||||||
40491 | 40491 | Matt Salmon S000018 | rep | AZ | 2015-01-06 | 2017-01-03 | Republican | 5 | http://salmon.house.gov | 2349 Rayburn HOB; Washington DC 20515-0305 | 202-225-2635 | 202-226-4386 | https://salmon.house.gov/contact/email-me | 2349 Rayburn House Office Building | http://salmon.house.gov/rss.xml | ||||||
40494 | 40494 | Alan Grayson G000556 | rep | FL | 2015-01-06 | 2017-01-03 | Democrat | 9 | http://grayson.house.gov | 303 Cannon HOB; Washington DC 20515-0909 | 202-225-9889 | 202-225-9742 | https://grayson.house.gov/contact/email-me | 303 Cannon House Office Building | http://grayson.house.gov/rss.xml | ||||||
40496 | 40496 | Patrick Murphy M001191 | rep | FL | 2015-01-06 | 2017-01-03 | Democrat | 18 | http://patrickmurphy.house.gov | 211 Cannon HOB; Washington DC 20515-0918 | 202-225-3026 | 202-225-8398 | http://patrickmurphy.house.gov/contact/ | 211 Cannon House Office Building | http://patrickmurphy.house.gov/news/rss.aspx | ||||||
40498 | 40498 | David Jolly J000296 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 13 | http://jolly.house.gov | 1728 Longworth HOB; Washington DC 20515-0913 | 202-225-5961 | 202-225-9764 | https://jolly.house.gov/contact/email-me | 1728 Longworth House Office Building | |||||||
40500 | 40500 | Curtis Clawson C001102 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 19 | http://clawson.house.gov | 228 Cannon HOB; Washington DC 20515-0919 | 202-225-2536 | 228 Cannon House Office Building | |||||||||
40502 | 40502 | Bob Dold D000613 | rep | IL | 2015-01-06 | 2017-01-03 | Republican | 10 | https://dold.house.gov | 221 Cannon HOB; Washington DC 20515-1310 | 202-225-4835 | 221 Cannon House Office Building | |||||||||
40504 | 40504 | Frank Guinta G000570 | rep | NH | 2015-01-06 | 2017-01-03 | Republican | 1 | https://guinta.house.gov | 326 Cannon HOB; Washington DC 20515-2901 | 202-225-5456 | 202-225-5822 | 326 Cannon House Office Building | ||||||||
40505 | 40505 | Gwen Graham G000575 | rep | FL | 2015-01-06 | 2017-01-03 | Democrat | 2 | https://graham.house.gov | 1213 Longworth HOB; Washington DC 20515-0902 | 202-225-5235 | 202-225-5615 | 1213 Longworth House Office Building | ||||||||
40506 | 40506 | Brad Ashford A000373 | rep | NE | 2015-01-06 | 2017-01-03 | Democrat | 2 | https://ashford.house.gov | 107 Cannon HOB; Washington DC 20515-2702 | 202-225-4155 | 202-226-5452 | 107 Cannon House Office Building | ||||||||
40507 | 40507 | Cresent Hardy H001070 | rep | NV | 2015-01-06 | 2017-01-03 | Republican | 4 | https://hardy.house.gov | 430 Cannon HOB; Washington DC 20515-2804 | 202-225-9894 | 202-225-9783 | 430 Cannon House Office Building | ||||||||
40510 | 40510 | Mike Pompeo P000602 | rep | KS | 2015-01-06 | 2017-01-03 | Republican | 4 | http://pompeo.house.gov | 436 Cannon HOB; Washington DC 20515-1604 | 202-225-6216 | 202-225-3489 | https://pompeo.house.gov/contact/contactform.htm?zip5=$ADDRESS_ZIP5 | 436 Cannon House Office Building | http://pompeo.house.gov/news/rss.aspx | ||||||
40523 | 40523 | Xavier Becerra B000287 | rep | CA | 2015-01-06 | 2017-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 | ||||||
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 | ||||||
40538 | 40538 | Mick Mulvaney M001182 | rep | SC | 2015-01-06 | 2017-01-03 | Republican | 5 | https://mulvaney.house.gov | 2419 Rayburn HOB; Washington DC 20515-4005 | 202-225-5501 | 202-225-0464 | https://mulvaney.house.gov/email-mick/ | 2419 Rayburn House Office Building | http://mulvaney.house.gov/index.php?format=feed&type=rss | ||||||
40540 | 40540 | Ryan Zinke Z000018 | rep | MT | 2015-01-06 | 2017-01-03 | Republican | 0 | https://zinke.house.gov | 113 Cannon HOB; Washington DC 20515-2600 | 202-225-3211 | 202-225-5687 | 113 Cannon House Office Building | ||||||||
40545 | 40545 | Jason Chaffetz C001076 | rep | UT | 2015-01-06 | 2017-01-03 | Republican | 3 | http://chaffetz.house.gov | 2236 Rayburn HOB; Washington DC 20515-4403 | 202-225-7751 | 202-225-5629 | https://chaffetz.house.gov/contact-me/email-me | 2236 Rayburn House Office Building | http://chaffetz.house.gov/rss.xml | ||||||
40553 | 40553 | Tim Murphy M001151 | rep | PA | 2015-01-06 | 2017-01-03 | Republican | 18 | http://murphy.house.gov | 2332 Rayburn HOB; Washington DC 20515-3818 | 202-225-2301 | 202-225-1844 | https://murphy.house.gov/contact-me | 2332 Rayburn House Office Building | http://murphy.house.gov/common/rss/?rss=44 | ||||||
40580 | 40580 | John Conyers C000714 | rep | MI | 2015-01-06 | 2017-01-03 | Democrat | 13 | https://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 | ||||||
40588 | 40588 | Trent Franks F000448 | rep | AZ | 2015-01-06 | 2017-01-03 | Republican | 8 | http://franks.house.gov | 2435 Rayburn HOB; Washington DC 20515-0308 | 202-225-4576 | 202-225-6328 | https://franks.house.gov/contact-me/email-me | 2435 Rayburn House Office Building | http://franks.house.gov/rss.xml | ||||||
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 | ||||||
40616 | 40616 | Louise Slaughter S000480 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 25 | https://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 | ||||||
40630 | 40630 | Blake Farenthold F000460 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 27 | http://farenthold.house.gov | 1027 Longworth HOB; Washington DC 20515-4327 | 202-225-7742 | 202-226-1134 | http://farentholdforms.house.gov/contact/email.htm | 1027 Longworth House Office Building | http://farenthold.house.gov/index.php?format=feed&type=rss | ||||||
40634 | 40634 | Patrick Meehan M001181 | rep | PA | 2015-01-06 | 2017-01-03 | Republican | 7 | https://meehan.house.gov | 434 Cannon HOB; Washington DC 20515-3807 | 202-225-2011 | 202-226-0280 | https://meehan.house.gov/email-me | 434 Cannon House Office Building | http://meehan.house.gov/rss/latest-news.xml | ||||||
40637 | 40637 | Jim Bridenstine B001283 | rep | OK | 2015-01-06 | 2017-01-03 | Republican | 1 | http://bridenstine.house.gov | 216 Cannon HOB; Washington DC 20515-3601 | 202-225-2211 | 918-935-2716 | https://bridenstineforms.house.gov/forms/writeyourrep/ | 216 Cannon House Office Building | http://bridenstine.house.gov/rss.xml | ||||||
40644 | 40644 | Charles Dent D000604 | rep | PA | 2015-01-06 | 2017-01-03 | Republican | 15 | https://dent.house.gov | 2211 Rayburn HOB; Washington DC 20515-3815 | 202-225-6411 | 202-226-0778 | https://dent.house.gov/?p=ContactForm | 2211 Rayburn House Office Building | http://dent.house.gov/?a=rss.feed | ||||||
40652 | 40652 | John McCain M000303 | sen | AZ | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.mccain.senate.gov | 218 Russell Senate Office Building Washington DC 20510 | 202-224-2235 | 202-228-2862 | http://www.mccain.senate.gov/public/index.cfm/contact-form | 218 Russell Senate Office Building | senior | ||||||
40655 | 40655 | Ron DeSantis D000621 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 6 | http://desantis.house.gov | 308 Cannon HOB; Washington DC 20515-0906 | 202-225-2706 | 202-226-6299 | https://desantis.house.gov/contact/email-me | 308 Cannon House Office Building | http://desantis.house.gov/rss.xml | ||||||
40657 | 40657 | Evan Jenkins J000297 | rep | WV | 2015-01-06 | 2017-01-03 | Republican | 3 | https://evanjenkins.house.gov | 502 Cannon HOB; Washington DC 20515-4803 | 202-225-3452 | 202-225-9061 | 502 Cannon House Office Building | ||||||||
40668 | 40668 | Michelle Lujan Grisham L000580 | rep | NM | 2015-01-06 | 2017-01-03 | Democrat | 1 | https://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 | ||||||
40692 | 40692 | Lou Barletta B001269 | rep | PA | 2015-01-06 | 2017-01-03 | Republican | 11 | http://barletta.house.gov | 115 Cannon HOB; Washington DC 20515-3811 | 202-225-6511 | 202-225-0764 | https://barletta.house.gov/contact/email-me | 115 Cannon House Office Building | http://barletta.house.gov/common/rss//index.cfm?rss=25 | ||||||
40709 | 40709 | Joe Barton B000213 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 6 | http://joebarton.house.gov | 2107 Rayburn HOB; Washington DC 20515-4306 | 202-225-2002 | 202-225-3052 | https://joebarton.house.gov/contact1/ | 2107 Rayburn House Office Building | http://joebarton.house.gov/index.php?format=feed&type=rss | ||||||
40713 | 40713 | Diane Black B001273 | rep | TN | 2015-01-06 | 2017-01-03 | Republican | 6 | http://black.house.gov | 1131 Longworth HOB; Washington DC 20515-4206 | 202-225-4231 | 202-225-6887 | https://black.house.gov/contact-me/email-me | 1131 Longworth House Office Building | http://black.house.gov/rss.xml | ||||||
40721 | 40721 | Madeleine Bordallo B001245 | rep | GU | 2015-01-06 | 2017-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 | ||||||
40732 | 40732 | Robert Brady B001227 | rep | PA | 2015-01-06 | 2017-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 | ||||||
40742 | 40742 | Michael Capuano C001037 | rep | MA | 2015-01-06 | 2017-01-03 | Democrat | 7 | http://capuano.house.gov | 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 | |||||||
40747 | 40747 | Mike Coffman C001077 | rep | CO | 2015-01-06 | 2017-01-03 | Republican | 6 | http://coffman.house.gov | 2443 Rayburn HOB; Washington DC 20515-0606 | 202-225-7882 | 202-226-4623 | https://coffman.house.gov/contact/email-me | 2443 Rayburn House Office Building | http://coffman.house.gov/index.php?format=feed&type=rss | ||||||
40757 | 40757 | Joseph Crowley C001038 | rep | NY | 2015-01-06 | 2017-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 | ||||||
40766 | 40766 | John Culberson C001048 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 7 | http://culberson.house.gov | 2372 Rayburn HOB; Washington DC 20515-4307 | 202-225-2571 | 202-225-4381 | https://culbersonforms.house.gov/forms/writeyourrep/default.aspx | 2372 Rayburn House Office Building | http://culberson.house.gov/rss/ | ||||||
40770 | 40770 | Jeff Denham D000612 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 10 | http://denham.house.gov | 1730 Longworth HOB; Washington DC 20515-0510 | 202-225-4540 | 202-225-3402 | https://denham.house.gov/contact-me/email-me | 1730 Longworth House Office Building | http://denham.house.gov/rss.xml | ||||||
40790 | 40790 | John Duncan D000533 | rep | TN | 2015-01-06 | 2017-01-03 | Republican | 2 | http://duncan.house.gov | 2207 Rayburn HOB; Washington DC 20515-4202 | 202-225-5435 | 202-225-6440 | https://duncan.house.gov/contact-me/email-me | 2207 Rayburn House Office Building | http://duncan.house.gov/rss.xml | ||||||
40796 | 40796 | Keith Ellison E000288 | rep | MN | 2015-01-06 | 2017-01-03 | Democrat | 5 | http://ellison.house.gov | 2263 Rayburn HOB; Washington DC 20515-2305 | 202-225-4755 | 202-225-4886 | http://ellison.house.gov/contact | 2263 Rayburn House Office Building | http://ellison.house.gov/index.php?format=feed&type=rss | ||||||
40815 | 40815 | Rodney Frelinghuysen F000372 | rep | NJ | 2015-01-06 | 2017-01-03 | Republican | 11 | http://frelinghuysen.house.gov | 2306 Rayburn HOB; Washington DC 20515-3011 | 202-225-5034 | 202-225-3186 | https://frelinghuysenforms.house.gov/contact-form | 2306 Rayburn House Office Building | http://frelinghuysen.house.gov/common/rss/?rss=3 | ||||||
40828 | 40828 | Bob Goodlatte G000289 | rep | VA | 2015-01-06 | 2017-01-03 | Republican | 6 | http://goodlatte.house.gov | 2309 Rayburn HOB; Washington DC 20515-4606 | 202-225-5431 | 202-225-9681 | http://goodlatte.house.gov/contacts/new | 2309 Rayburn House Office Building | http://goodlatte.house.gov/press_releases.rss | ||||||
40832 | 40832 | Trey Gowdy G000566 | rep | SC | 2015-01-06 | 2017-01-03 | Republican | 4 | https://gowdy.house.gov | 1404 Longworth HOB; Washington DC 20515-4004 | 202-225-6030 | 202-226-1177 | https://gowdy.house.gov/forms/writeyourrep/default.aspx | 1404 Longworth House Office Building | http://gowdy.house.gov/news/rss.aspx | ||||||
40845 | 40845 | Gene Green G000410 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 29 | https://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 | ||||||
40858 | 40858 | Luis Gutiérrez G000535 | rep | IL | 2015-01-06 | 2017-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 | ||||||
40863 | 40863 | Gregg Harper H001045 | rep | MS | 2015-01-06 | 2017-01-03 | Republican | 3 | http://harper.house.gov | 307 Cannon HOB; Washington DC 20515-2403 | 202-225-5031 | 202-225-5797 | https://harperforms.house.gov/forms/writeyourrep/ | 307 Cannon House Office Building | http://harper.house.gov/rss.xml | ||||||
40871 | 40871 | Jeb Hensarling H001036 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 5 | http://hensarling.house.gov | 2228 Rayburn HOB; Washington DC 20515-4305 | 202-225-3484 | 202-226-4888 | https://hensarling.house.gov/contact/email-me | 2228 Rayburn House Office Building | http://hensarling.house.gov/atom.xml | ||||||
40875 | 40875 | Randy Hultgren H001059 | rep | IL | 2015-01-06 | 2017-01-03 | Republican | 14 | http://hultgren.house.gov | 2455 Rayburn HOB; Washington DC 20515-1314 | 202-225-2976 | 202-225-0697 | https://hultgren.house.gov/contact/email-randy | 2455 Rayburn House Office Building | http://hultgren.house.gov/common/rss//index.cfm?rss=49 | ||||||
40880 | 40880 | Lynn Jenkins J000290 | rep | KS | 2015-01-06 | 2017-01-03 | Republican | 2 | http://lynnjenkins.house.gov | 1526 Longworth HOB; Washington DC 20515-1602 | 202-225-6601 | 202-225-7986 | https://lynnjenkins.house.gov/contact-me | 1526 Longworth House Office Building | http://lynnjenkins.house.gov/common/rss/?rss=220 | ||||||
40894 | 40894 | Sam Johnson J000174 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 3 | http://samjohnson.house.gov | 2304 Rayburn HOB; Washington DC 20515-4303 | 202-225-4201 | 202-225-1485 | http://samjohnson.house.gov/contact/ | 2304 Rayburn House Office Building | http://samjohnson.house.gov/news/rss.aspx | ||||||
40898 | 40898 | Raúl Labrador L000573 | rep | ID | 2015-01-06 | 2017-01-03 | Republican | 1 | http://labrador.house.gov | 1523 Longworth HOB; Washington DC 20515-1201 | 202-225-6611 | 202-225-3029 | https://labradorforms.house.gov/email-me | 1523 Longworth House Office Building | http://labrador.house.gov/common/rss//index.cfm?rss=49 | ||||||
40903 | 40903 | Leonard Lance L000567 | rep | NJ | 2015-01-06 | 2017-01-03 | Republican | 7 | http://lance.house.gov | 2352 Rayburn HOB; Washington DC 20515-3007 | 202-225-5361 | 202-225-9460 | https://lance.house.gov/contact-me1 | 2352 Rayburn House Office Building | http://lance.house.gov/rss-button/rss-button/ | ||||||
40921 | 40921 | Sander Levin L000263 | rep | MI | 2015-01-06 | 2017-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 | ||||||
40933 | 40933 | Frank LoBiondo L000554 | rep | NJ | 2015-01-06 | 2017-01-03 | Republican | 2 | http://lobiondo.house.gov | 2427 Rayburn HOB; Washington DC 20515-3002 | 202-225-6572 | 202-225-3318 | https://lobiondo.house.gov/contact-me/email-me | 2427 Rayburn House Office Building | http://lobiondo.house.gov/rss.xml | ||||||
40937 | 40937 | Kristi Noem N000184 | rep | SD | 2015-01-06 | 2017-01-03 | Republican | 0 | https://noem.house.gov | 2422 Rayburn HOB; Washington DC 20515-4100 | 202-225-2801 | 202-225-5823 | http://noem.house.gov/index.cfm/email-kristi | 2422 Rayburn House Office Building | http://noem.house.gov/index.cfm/rss/feed | ||||||
40942 | 40942 | Erik Paulsen P000594 | rep | MN | 2015-01-06 | 2017-01-03 | Republican | 3 | http://paulsen.house.gov | 127 Cannon HOB; Washington DC 20515-2303 | 202-225-2871 | 202-225-6351 | https://paulsenforms.house.gov/contact-me | 127 Cannon House Office Building | http://paulsen.house.gov/common/rss//?rss=105 |
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);