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 phone
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, party, state_rank, rss_url, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||
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& | |||||
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 | |||||
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 | |||||
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 | ||||||
40671 | 40671 | Bob Corker C001071 | sen | TN | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.corker.senate.gov | 425 Dirksen Senate Office Building Washington DC 20510 | 202-224-3344 | 202-228-0566 | https://www.corker.senate.gov/public/index.cfm/emailme | 425 Dirksen Senate Office Building | junior | http://www.corker.senate.gov/public/index.cfm/rss/feed | |||||
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 | |||||
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 | |||||
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 | |||||
43896 | 43896 | Timothy Kaine K000384 | sen | VA | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.kaine.senate.gov | 231 Russell Senate Office Building Washington DC 20510 | 202-224-4024 | 202-228-6363 | https://www.kaine.senate.gov/contact | 231 Russell Senate Office Building | junior | http://www.kaine.senate.gov/rss/feeds/?type=all | |||||
42965 | 42965 | Christopher Murphy M001169 | sen | CT | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.murphy.senate.gov | 136 Hart Senate Office Building Washington DC 20510 | 202-224-4041 | 202-225-5933 | http://www.murphy.senate.gov/contact | 136 Hart Senate Office Building | junior | http://www.theday.com/article/20121216/nws12/312169935/1069/rss | |||||
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/ | |||||
40804 | 40804 | Jeff Flake F000444 | sen | AZ | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.flake.senate.gov/public | 413 Russell Senate Office Building Washington DC 20510 | 202-224-4521 | 202-226-4386 | https://www.flake.senate.gov/public/index.cfm/contact-jeff | 413 Russell Senate Office Building | senior | http://www.flake.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 | |||||
43786 | 43786 | Elizabeth Warren W000817 | sen | MA | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.warren.senate.gov | 317 Hart Senate Office Building Washington DC 20510 | 202-224-4543 | 202-228-2072 | https://www.warren.senate.gov/?p=email_senator | 317 Hart Senate Office Building | senior | http://www.warren.senate.gov/rss/?p=hot_topic | |||||
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 | |||||
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 | |||||
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 | |||||
41799 | 41799 | Bernard Sanders S000033 | sen | VT | 2013-01-03 | 2019-01-03 | 1 | Independent | https://www.sanders.senate.gov | Democrat | 332 Dirksen Senate Office Building Washington DC 20510 | 202-224-5141 | 202-228-0776 | http://www.sanders.senate.gov/contact/ | 332 Dirksen Senate Office Building | junior | http://www.sanders.senate.gov/rss/ | ||||
40678 | 40678 | Orrin Hatch H000338 | sen | UT | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.hatch.senate.gov | 104 Hart Senate Office Building Washington DC 20510 | 202-224-5251 | 202-224-6331 | http://www.hatch.senate.gov/public/index.cfm/contact?p=Email-Orrin | 104 Hart Senate Office Building | senior | http://www.hatch.senate.gov/public/index.cfm/rss/feed | |||||
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 | ||||||
43788 | 43788 | Angus King K000383 | sen | ME | 2013-01-03 | 2019-01-03 | 1 | Independent | https://www.king.senate.gov | Democrat | 133 Hart Senate Office Building Washington DC 20510 | 202-224-5344 | 202-224-1946 | https://www.king.senate.gov/contact | 133 Hart Senate Office Building | junior | http://www.king.senate.gov/rss/feeds/?type=all | ||||
42501 | 42501 | Martin Heinrich H001046 | sen | NM | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.heinrich.senate.gov | 303 Hart Senate Office Building Washington DC 20510 | 202-224-5521 | 202-225-4975 | http://www.heinrich.senate.gov/contact | 303 Hart Senate Office Building | junior | ||||||
41924 | 41924 | Tammy Baldwin B001230 | sen | WI | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.baldwin.senate.gov | 709 Hart Senate Office Building Washington DC 20510 | 202-224-5653 | 202-225-6942 | https://www.baldwin.senate.gov/feedback | 709 Hart Senate Office Building | junior | http://www.baldwin.senate.gov/rss/feeds/?type=all | |||||
43869 | 43869 | Ted Cruz C001098 | sen | TX | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.cruz.senate.gov | 404 Russell Senate Office Building Washington DC 20510 | 202-224-5922 | 202-228-3398 | https://www.cruz.senate.gov/?p=form&id=16 | 404 Russell Senate Office Building | junior | ||||||
43337 | 43337 | Tim Scott S001184 | sen | SC | 2013-01-03 | 2015-01-03 | 3 | Republican | appointment | http://www.scott.senate.gov | 167 Russell Senate Office Building Washington DC 20510 | 202-224-6121 | 202-225-3407 | http://www.scott.senate.gov/contact/email-me | 167 Russell Senate Office Building | junior | http://www.scott.senate.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 | |||||
41091 | 41091 | Dean Heller H001041 | sen | NV | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.heller.senate.gov/public | 324 Hart Senate Office Building Washington DC 20510 | 202-224-6244 | 202-228-6753 | http://www.heller.senate.gov/public/index.cfm/contact-form | 324 Hart Senate Office Building | senior | http://www.heller.senate.gov/public/index.cfm/rss/feed | |||||
41824 | 41824 | Roger Wicker W000437 | sen | MS | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.wicker.senate.gov | 555 Dirksen Senate Office Building Washington DC 20510 | 202-224-6253 | 202-228-0378 | https://www.wicker.senate.gov/public/index.cfm/contact | 555 Dirksen Senate Office Building | senior | ||||||
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 | |||||
42528 | 42528 | Mazie Hirono H001042 | sen | HI | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.hirono.senate.gov | 730 Hart Senate Office Building Washington DC 20510 | 202-224-6361 | 202-225-4987 | https://www.hirono.senate.gov/contact | 730 Hart Senate Office Building | junior | http://www.hirono.senate.gov/rss/feeds/?type=all | |||||
41814 | 41814 | John Barrasso B001261 | sen | WY | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.barrasso.senate.gov | 307 Dirksen Senate Office Building Washington DC 20510 | 202-224-6441 | 202-224-1724 | https://www.barrasso.senate.gov/public/index.cfm/contact-form | 307 Dirksen Senate Office Building | junior | http://www.barrasso.senate.gov/public/index.cfm?FuseAction=Rss.Feed | |||||
43812 | 43812 | Deb Fischer F000463 | sen | NE | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.fischer.senate.gov | 454 Russell Senate Office Building Washington DC 20510 | 202-224-6551 | 202-228-1325 | http://www.fischer.senate.gov/public/index.cfm/contact | 454 Russell Senate Office Building | senior | http://www.fischer.senate.gov/public/index.cfm/rss/feed | |||||
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 | ||||||
41295 | 41295 | Rob Bishop B001250 | rep | UT | 2013-01-03 | 2015-01-03 | Republican | 1 | http://robbishop.house.gov | 123 Cannon HOB; Washington DC 20515-4401 | 202-225-0453 | 202-225-5857 | https://robbishop.house.gov/contact/contactform.htm | 123 Cannon House Office Building | http://robbishop.house.gov/news/rss.aspx | ||||||
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 | ||||||
43662 | 43662 | Suzanne Bonamici B001278 | rep | OR | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://bonamici.house.gov | 439 Cannon HOB; Washington DC 20515-3701 | 202-225-0855 | 202-225-9497 | https://bonamici.house.gov/contact-me/email-me | 439 Cannon House Office Building | http://bonamici.house.gov/rss.xml | ||||||
40424 | 40424 | Richard Nugent N000185 | rep | FL | 2013-01-03 | 2015-01-03 | Republican | 11 | http://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 | ||||||
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 | ||||||
41020 | 41020 | Dennis Ross R000593 | rep | FL | 2013-01-03 | 2015-01-03 | Republican | 15 | http://dennisross.house.gov | 229 Cannon HOB; Washington DC 20515-0915 | 202-225-1252 | 202-226-0585 | https://dennisross.house.gov/forms/writeyourrep/ | 229 Cannon House Office Building | http://dennisross.house.gov/news/rss.aspx | ||||||
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 | ||||||
42193 | 42193 | Gerald Connolly C001078 | rep | VA | 2013-01-03 | 2015-01-03 | Democrat | 11 | http://connolly.house.gov | 424 Cannon HOB; Washington DC 20515-4611 | 202-225-1492 | 202-225-3071 | https://forms.house.gov/connolly/contact-form.shtml | 424 Cannon House Office Building | http://connolly.house.gov/common/rss//index.cfm?rss=44 | ||||||
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 | ||||||
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 | ||||||
42597 | 42597 | Henry Johnson J000288 | rep | GA | 2013-01-03 | 2015-01-03 | Democrat | 4 | http://hankjohnson.house.gov | 2240 Rayburn HOB; Washington DC 20515-1004 | 202-225-1605 | 202-226-0691 | https://hankjohnson.house.gov/contact-me/email-me | 2240 Rayburn House Office Building | http://hankjohnson.house.gov/rss.xml | ||||||
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 | |||||||
42248 | 42248 | Henry Cuellar C001063 | rep | TX | 2013-01-03 | 2015-01-03 | Democrat | 28 | http://cuellar.house.gov | 2431 Rayburn HOB; Washington DC 20515-4328 | 202-225-1640 | 202-225-1641 | https://cuellar.house.gov/forms/writeyourrep/default.aspx | 2431 Rayburn House Office Building | http://cuellar.house.gov/news/rss.aspx | ||||||
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 | ||||||
43191 | 43191 | Lucille Roybal-Allard R000486 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 40 | http://roybal-allard.house.gov | 2330 Rayburn HOB; Washington DC 20515-0540 | 202-225-1766 | 202-226-0350 | http://roybal-allard.house.gov/contact/ | 2330 Rayburn House Office Building | http://roybal-allard.house.gov/news/rss.aspx | ||||||
43138 | 43138 | David Price P000523 | rep | NC | 2013-01-03 | 2015-01-03 | Democrat | 4 | http://price.house.gov | 2162 Rayburn HOB; Washington DC 20515-3304 | 202-225-1784 | 202-225-2014 | https://price.house.gov/contact | 2162 Rayburn House Office Building | http://price.house.gov/index.php?format=feed&type=rss | ||||||
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 | ||||||
42395 | 42395 | John Garamendi G000559 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 3 | http://garamendi.house.gov | 2438 Rayburn HOB; Washington DC 20515-0503 | 202-225-1880 | 202-225-5914 | https://garamendi.house.gov/contact-me/email-me | 2438 Rayburn House Office Building | http://garamendi.house.gov/rss.xml | ||||||
42922 | 42922 | Jerry McNerney M001166 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 9 | http://mcnerney.house.gov | 1210 Longworth HOB; Washington DC 20515-0509 | 202-225-1947 | 202-225-4060 | https://mcnerney.house.gov/contact/email-me | 1210 Longworth House Office Building | http://mcnerney.house.gov/rss.xml | ||||||
39947 | 39947 | Howard McKeon M000508 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 25 | http://mckeon.house.gov | 2310 Rayburn HOB; Washington DC 20515-0525 | 202-225-1956 | 202-226-0683 | https://mckeon.house.gov/forms/writeyourrep/default.aspx | 2310 Rayburn House Office Building | http://mckeon.house.gov/news/rss.aspx | ||||||
41107 | 41107 | Robert Pittenger P000606 | rep | NC | 2013-01-03 | 2015-01-03 | Republican | 9 | http://pittenger.house.gov | 224 Cannon HOB; Washington DC 20515-3309 | 202-225-1976 | 202-225-3389 | https://pittenger.house.gov/contact/email-me | 224 Cannon House Office Building | http://pittenger.house.gov/rss.xml | ||||||
42070 | 42070 | Ken Calvert C000059 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 42 | http://calvert.house.gov | 2269 Rayburn HOB; Washington DC 20515-0542 | 202-225-1986 | 202-225-2004 | https://calvert.house.gov/contactform/ | 2269 Rayburn House Office Building | http://calvert.house.gov/news/rss.aspx | ||||||
40708 | 40708 | Joe Barton B000213 | rep | TX | 2013-01-03 | 2015-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 | ||||||
42914 | 42914 | Cathy McMorris Rodgers M001159 | rep | WA | 2013-01-03 | 2015-01-03 | Republican | 5 | http://mcmorris.house.gov | 203 Cannon HOB; Washington DC 20515-4705 | 202-225-2006 | 202-225-3392 | https://mcmorrisforms.house.gov/write-to-cathy1 | 203 Cannon House Office Building | http://mcmorris.house.gov/common/rss/?rss=96 | ||||||
40633 | 40633 | Patrick Meehan M001181 | rep | PA | 2013-01-03 | 2015-01-03 | Republican | 7 | http://meehan.house.gov | 204 Cannon HOB; Washington DC 20515-3807 | 202-225-2011 | 202-226-0280 | https://meehan.house.gov/email-me | 204 Cannon House Office Building | http://meehan.house.gov/rss/latest-news.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 | ||||||
40253 | 40253 | Charles Boustany B001255 | rep | LA | 2013-01-03 | 2015-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 | ||||||
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 | |||||||
41111 | 41111 | Keith Rothfus R000598 | rep | PA | 2013-01-03 | 2015-01-03 | Republican | 12 | http://rothfus.house.gov | 503 Cannon HOB; Washington DC 20515-3812 | 202-225-2065 | https://rothfus.house.gov/email-keith | 503 Cannon House Office Building | http://rothfus.house.gov/rss.xml | |||||||
42388 | 42388 | Virginia Foxx F000450 | rep | NC | 2013-01-03 | 2015-01-03 | Republican | 5 | http://foxx.house.gov | 2350 Rayburn HOB; Washington DC 20515-3305 | 202-225-2071 | 202-225-2995 | https://foxx.house.gov/forms/writeyourrep/?zip5=&zip4= | 2350 Rayburn House Office Building | http://foxx.house.gov/common/rss/?rss=55 | ||||||
42226 | 42226 | Joe Courtney C001069 | rep | CT | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://courtney.house.gov | 2348 Rayburn HOB; Washington DC 20515-0702 | 202-225-2076 | 202-225-4977 | https://courtney.house.gov/email-joe1 | 2348 Rayburn House Office Building | http://courtney.house.gov/index.php?format=feed&type=rss | ||||||
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 | ||||||
40198 | 40198 | Candice Miller M001150 | rep | MI | 2013-01-03 | 2015-01-03 | Republican | 10 | http://candicemiller.house.gov | 320 Cannon HOB; Washington DC 20515-2210 | 202-225-2106 | 202-226-1169 | http://candicemiller.house.gov/contact | 320 Cannon House Office Building | http://candicemiller.house.gov/rss.xml | ||||||
43263 | 43263 | Janice Schakowsky S001145 | rep | IL | 2013-01-03 | 2015-01-03 | Democrat | 9 | http://schakowsky.house.gov | 2367 Rayburn HOB; Washington DC 20515-1309 | 202-225-2111 | 202-226-6890 | https://schakowsky.house.gov/write-to-congresswoman-jan-schakowsky | 2367 Rayburn House Office Building | http://schakowsky.house.gov/index.php?format=feed&type=rss | ||||||
42683 | 42683 | James Lankford L000575 | rep | OK | 2013-01-03 | 2015-01-03 | Republican | 5 | http://lankford.house.gov | 228 Cannon HOB; Washington DC 20515-3605 | 202-225-2132 | 202-226-1463 | https://lankford.house.gov/contact-me/ | 228 Cannon House Office Building | http://lankford.house.gov/rss.xml | ||||||
42352 | 42352 | Michael Doyle D000482 | rep | PA | 2013-01-03 | 2015-01-03 | Democrat | 14 | http://doyle.house.gov | 239 Cannon HOB; Washington DC 20515-3814 | 202-225-2135 | 202-225-3084 | https://doyle.house.gov/contact-me/email-me | 239 Cannon House Office Building | http://doyle.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 | ||||||
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 | ||||||
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 | ||||||
43300 | 43300 | David Schweikert S001183 | rep | AZ | 2013-01-03 | 2015-01-03 | Republican | 6 | http://schweikert.house.gov | 1205 Longworth HOB; Washington DC 20515-0306 | 202-225-2190 | 202-225-0096 | https://schweikert.house.gov/contact-form | 1205 Longworth House Office Building | http://schweikert.house.gov/rss/press-releases.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 | ||||||
40636 | 40636 | Jim Bridenstine B001283 | rep | OK | 2013-01-03 | 2015-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 | ||||||
42123 | 42123 | Steve Chabot C000266 | rep | OH | 2013-01-03 | 2015-01-03 | Republican | 1 | http://chabot.house.gov | 2371 Rayburn HOB; Washington DC 20515-3501 | 202-225-2216 | 202-225-3012 | https://chabot.house.gov/forms/writeyourrep/?zip5=45202&zip4=3003 | 2371 Rayburn House Office Building | http://chabot.house.gov/common/rss/index.cfm?rss=49 | ||||||
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 | ||||||
42704 | 42704 | John Larson L000557 | rep | CT | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://www.larson.house.gov | 1501 Longworth HOB; Washington DC 20515-0701 | 202-225-2265 | 202-225-1031 | https://forms.house.gov/larson/contact_new.html | 1501 Longworth House Office Building | http://www.larson.house.gov/index.php?format=feed&type=rss | ||||||
40380 | 40380 | John Kline K000363 | rep | MN | 2013-01-03 | 2015-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 | ||||||
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 | |||||||
40552 | 40552 | Tim Murphy M001151 | rep | PA | 2013-01-03 | 2015-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 | ||||||
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 | |||||||
44442 | 44442 | Cynthia Lummis L000571 | rep | WY | 2013-01-03 | 2015-01-03 | Republican | 0 | http://lummis.house.gov | 113 Cannon HOB; Washington DC 20515-5000 | 202-225-2311 | 202-225-3057 | http://lummis.house.gov/contact/ | 113 Cannon House Office Building | http://lummis.house.gov/news/rss.aspx | ||||||
42416 | 42416 | Paul Gosar G000565 | rep | AZ | 2013-01-03 | 2015-01-03 | Republican | 4 | http://gosar.house.gov | 504 Cannon HOB; Washington DC 20515-0304 | 202-225-2315 | 202-226-9739 | https://gosar.house.gov/contact-me/email-me | 504 Cannon House Office Building | http://gosar.house.gov/rss.xml | ||||||
39737 | 39737 | Michele Bachmann B001256 | rep | MN | 2013-01-03 | 2015-01-03 | Republican | 6 | http://bachmann.house.gov | 2417 Rayburn HOB; Washington DC 20515-2306 | 202-225-2331 | 202-225-6475 | https://bachmann.house.gov/contact/email-michele | 2417 Rayburn House Office Building | http://bachmann.house.gov/rss.xml | ||||||
43548 | 43548 | Nydia Velázquez V000081 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 7 | http://www.house.gov/velazquez | 2302 Rayburn HOB; Washington DC 20515-3207 | 202-225-2361 | 202-226-0327 | http://velazquez.house.gov/IMA/issue_subscribe.shtml | 2302 Rayburn House Office Building | |||||||
40948 | 40948 | Stevan Pearce P000588 | rep | NM | 2013-01-03 | 2015-01-03 | Republican | 2 | http://pearce.house.gov | 2432 Rayburn HOB; Washington DC 20515-3102 | 202-225-2365 | https://pearce.house.gov/contact-me/email-me | 2432 Rayburn House Office Building | http://pearce.house.gov/rss.xml | |||||||
43771 | 43771 | Rodney Davis D000619 | rep | IL | 2013-01-03 | 2015-01-03 | Republican | 13 | http://rodneydavis.house.gov | 1740 Longworth HOB; Washington DC 20515-1313 | 202-225-2371 | https://rodneydavisforms.house.gov/contact/ | 1740 Longworth House Office Building | http://rodneydavis.house.gov/rss.xml | |||||||
42859 | 42859 | Michael McCaul M001157 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 10 | http://mccaul.house.gov | 131 Cannon HOB; Washington DC 20515-4310 | 202-225-2401 | 202-225-5955 | https://mccaul.house.gov/contact/email-me | 131 Cannon House Office Building | |||||||
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 | |||||||
40436 | 40436 | Joseph Pitts P000373 | rep | PA | 2013-01-03 | 2015-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 | ||||||
40986 | 40986 | Dana Rohrabacher R000409 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 48 | http://rohrabacher.house.gov | 2300 Rayburn HOB; Washington DC 20515-0548 | 202-225-2415 | 202-225-0145 | https://rohrabacher.house.gov/contact/email-me | 2300 Rayburn House Office Building | http://rohrabacher.house.gov/rss.xml | ||||||
41052 | 41052 | Bill Shuster S001154 | rep | PA | 2013-01-03 | 2015-01-03 | Republican | 9 | http://shuster.house.gov | 2209 Rayburn HOB; Washington DC 20515-3809 | 202-225-2431 | 202-225-2486 | http://shuster.house.gov/contact-form/ | 2209 Rayburn House Office Building | http://shuster.house.gov/common/rss//index.cfm?rss=49 | ||||||
42475 | 42475 | Raúl Grijalva G000551 | rep | AZ | 2013-01-03 | 2015-01-03 | Democrat | 3 | http://grijalva.house.gov | 1511 Longworth HOB; Washington DC 20515-0303 | 202-225-2435 | 202-225-1541 | https://grijalvaforms.house.gov/email-raul | 1511 Longworth House Office Building | http://grijalva.house.gov/common/rss/?rss=13 | ||||||
43605 | 43605 | Joe Wilson W000795 | rep | SC | 2013-01-03 | 2015-01-03 | Republican | 2 | http://joewilson.house.gov | 2229 Rayburn HOB; Washington DC 20515-4002 | 202-225-2452 | 202-225-2455 | https://joewilson.house.gov/forms/writeyourrep/default.aspx | 2229 Rayburn House Office Building | http://joewilson.house.gov/news/rss.aspx | ||||||
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 | ||||||
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 | |||||||
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 |
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);