legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
474 rows where "start" is on date 2011-01-05 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: state, end, district, contact_form, state_rank, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44462 | 44462 | Pete Sessions S000250 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 32 | http://www.house.gov/sessions | 2233 Rayburn HOB; Washington DC 20515-4332 | 202-225-2231 | 202-225-5878 | http://www.house.gov/sessionsform/emailform.htm | 2233 Rayburn House Office Building | |||||||
44450 | 44450 | Darrell Issa I000056 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 49 | http://www.house.gov/issa | 2347 Rayburn HOB; Washington DC 20515-0549 | 202-225-3906 | 202-225-3303 | http://issa.house.gov/index.cfm?FuseAction=Contact.ContactForm | 2347 Rayburn House Office Building | |||||||
44441 | 44441 | Cynthia Lummis L000571 | rep | WY | 2011-01-05 | 2013-01-03 | Republican | 0 | http://lummis.house.gov | 113 Cannon HOB; Washington DC 20515-5001 | 202-225-2311 | 202-225-3057 | https://forms.house.gov/lummis/contact-form.shtml | 113 Cannon House Office Building | |||||||
43651 | 43651 | Todd Young Y000064 | rep | IN | 2011-01-05 | 2013-01-03 | Republican | 9 | http://toddyoung.house.gov/ | 1721 Longworth HOB; Washington DC 20515-1409 | 202-225-5315 | 202-226-6866 | 1721 Longworth House Office Building | ||||||||
43645 | 43645 | John Yarmuth Y000062 | rep | KY | 2011-01-05 | 2013-01-03 | Democrat | 3 | http://yarmuth.house.gov | 435 Cannon HOB; Washington DC 20515-1703 | 202-225-5401 | 202-225-5776 | http://yarmuth.house.gov/?sectionid=68&sectiontree=6,29,68 | 435 Cannon House Office Building | |||||||
43641 | 43641 | Ron Wyden W000779 | sen | OR | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.wyden.senate.gov | 221 Dirksen Senate Office Building Washington DC 20510 | 202-224-5244 | 202-228-2717 | http://www.wyden.senate.gov/contact | 221 Dirksen Senate Office Building | senior | http://www.wyden.senate.gov/rss/feeds/?type=all& | |||||
43624 | 43624 | Steve Womack W000809 | rep | AR | 2011-01-05 | 2013-01-03 | Republican | 3 | http://womack.house.gov/ | 1508 Longworth HOB; Washington DC 20515-0403 | 202-225-4301 | 202-225-5713 | 1508 Longworth House Office Building | ||||||||
43618 | 43618 | Robert Wittman W000804 | rep | VA | 2011-01-05 | 2013-01-03 | Republican | 1 | http://www.wittman.house.gov/ | 1317 Longworth HOB; Washington DC 20515-4601 | 202-225-4261 | 202-225-4382 | https://forms.house.gov/wittman/IMA/webforms/issue_subscribe.htm | 1317 Longworth House Office Building | |||||||
43610 | 43610 | Frederica Wilson W000808 | rep | FL | 2011-01-05 | 2013-01-03 | Democrat | 17 | http://wilson.house.gov/ | 208 Cannon HOB; Washington DC 20515-0917 | 202-225-4506 | 202-226-0777 | 208 Cannon House Office Building | ||||||||
43604 | 43604 | Joe Wilson W000795 | rep | SC | 2011-01-05 | 2013-01-03 | Republican | 2 | http://joewilson.house.gov | 2229 Rayburn HOB; Washington DC 20515-4002 | 202-225-2452 | 202-225-2455 | http://www.house.gov/formwilson/IMA/issue.htm | 2229 Rayburn House Office Building | |||||||
43593 | 43593 | Peter Welch W000800 | rep | VT | 2011-01-05 | 2013-01-03 | Democrat | 0 | http://welch.house.gov | 1404 Longworth HOB; Washington DC 20515-4501 | 202-225-4115 | 202-225-6790 | http://www.house.gov/formwelch/issue_subscribe.htm | 1404 Longworth House Office Building | |||||||
43585 | 43585 | Daniel Webster W000806 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 8 | http://webster.house.gov/ | 1039 Longworth HOB; Washington DC 20515-0908 | 202-225-2176 | 202-225-0999 | 1039 Longworth House Office Building | ||||||||
43579 | 43579 | Maxine Waters W000187 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 35 | http://www.house.gov/waters | 2344 Rayburn HOB; Washington DC 20515-0535 | 202-225-2201 | 202-225-7854 | http://www.house.gov/waters/IMA/issue.htm | 2344 Rayburn House Office Building | |||||||
43563 | 43563 | Debbie Wasserman Schultz W000797 | rep | FL | 2011-01-05 | 2013-01-03 | Democrat | 20 | http://www.house.gov/schultz | 118 Cannon HOB; Washington DC 20515-0920 | 202-225-7931 | 202-225-2052 | http://wassermanschultz.house.gov/zipauth.htm | 118 Cannon House Office Building | |||||||
43554 | 43554 | Tim Walberg W000798 | rep | MI | 2011-01-05 | 2013-01-03 | Republican | 7 | http://walberg.house.gov/ | 418 Cannon HOB; Washington DC 20515-2207 | 202-225-6276 | 202-225-6281 | 418 Cannon House Office Building | ||||||||
43547 | 43547 | Nydia Velázquez V000081 | rep | NY | 2011-01-05 | 2013-01-03 | Democrat | 12 | http://www.house.gov/velazquez | 2302 Rayburn HOB; Washington DC 20515-3212 | 202-225-2361 | 202-226-0327 | http://www.house.gov/velazquez/IMA/issue_subscribe.htm | 2302 Rayburn House Office Building | |||||||
43534 | 43534 | Chris Van Hollen V000128 | rep | MD | 2011-01-05 | 2013-01-03 | Democrat | 8 | http://vanhollen.house.gov | 1707 Longworth HOB; Washington DC 20515-2008 | 202-225-5341 | 202-225-0375 | http://vanhollen.house.gov/HoR/MD08/Contact+Information/Web+Contact/Contact+Form.htm | 1707 Longworth House Office Building | |||||||
43524 | 43524 | Fred Upton U000031 | rep | MI | 2011-01-05 | 2013-01-03 | Republican | 6 | http://www.house.gov/upton | 2183 Rayburn HOB; Washington DC 20515-2206 | 202-225-3761 | 202-225-4986 | http://www.house.gov/writerep | 2183 Rayburn House Office Building | |||||||
43506 | 43506 | Michael Turner T000463 | rep | OH | 2011-01-05 | 2013-01-03 | Republican | 3 | http://turner.house.gov/ | 2454 Rayburn HOB; Washington DC 20515-3503 | 202-225-6465 | 202-225-6754 | http://turner.house.gov/Contact/ | 2454 Rayburn House Office Building | |||||||
43500 | 43500 | Patrick Toomey T000461 | sen | PA | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.toomey.senate.gov | 248 Russell Senate Office Building Washington DC 20510 | 202-224-4254 | 202-228-0284 | http://www.toomey.senate.gov/?p=contact | 248 Russell Senate Office Building | junior | http://toomey.senate.gov/rss/?p=hot_topic | |||||
43491 | 43491 | Paul Tonko T000469 | rep | NY | 2011-01-05 | 2013-01-03 | Democrat | 21 | http://tonko.house.gov | 422 Cannon HOB; Washington DC 20515-3221 | 202-225-5076 | 202-225-5077 | https://forms.house.gov/tonko/contact-form.shtml | 422 Cannon House Office Building | |||||||
43488 | 43488 | John Thune T000250 | sen | SD | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.thune.senate.gov | 511 Dirksen Senate Office Building Washington DC 20510 | 202-224-2321 | 202-228-5429 | http://www.thune.senate.gov/public/index.cfm/contact | 511 Dirksen Senate Office Building | senior | http://www.thune.senate.gov/public/index.cfm/rss/feed | |||||
43478 | 43478 | Glenn Thompson T000467 | rep | PA | 2011-01-05 | 2013-01-03 | Republican | 5 | http://thompson.house.gov | 124 Cannon HOB; Washington DC 20515-3805 | 202-225-5121 | 202-225-5796 | https://forms.house.gov/thompson/contact-form.shtml | 124 Cannon House Office Building | |||||||
43471 | 43471 | Mike Thompson T000460 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://mikethompson.house.gov | 231 Cannon HOB; Washington DC 20515-0501 | 202-225-3311 | 202-225-4335 | http://mikethompson.house.gov/contact/email.shtml | 231 Cannon House Office Building | |||||||
43459 | 43459 | Bennie Thompson T000193 | rep | MS | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://benniethompson.house.gov | 2466 Rayburn HOB; Washington DC 20515-2402 | 202-225-5876 | 202-225-5898 | https://forms.house.gov/benniethompson/contact-form.shtml | 2466 Rayburn House Office Building | |||||||
43444 | 43444 | Linda Sánchez S001156 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 39 | http://www.house.gov/lindasanchez | 2423 Rayburn HOB; Washington DC 20515-0539 | 202-225-6676 | 202-226-1012 | http://www.house.gov/writerep | 2423 Rayburn House Office Building | |||||||
43434 | 43434 | Jackie Speier S001175 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 12 | http://speier.house.gov/ | 211 Cannon HOB; Washington DC 20515-0512 | 202-225-3531 | 202-347-0956 | http://speier.house.gov/IMA/issue_subscribe.htm | 211 Cannon House Office Building | |||||||
43426 | 43426 | Christopher Smith S000522 | rep | NJ | 2011-01-05 | 2013-01-03 | Republican | 4 | http://www.house.gov/chrissmith | 2373 Rayburn HOB; Washington DC 20515-3004 | 202-225-3765 | 202-225-7768 | http://chrissmith.house.gov/zipauth.html | 2373 Rayburn House Office Building | |||||||
43405 | 43405 | Adrian Smith S001172 | rep | NE | 2011-01-05 | 2013-01-03 | Republican | 3 | http://adriansmith.house.gov | 503 Cannon HOB; Washington DC 20515-2703 | 202-225-6435 | 202-225-0207 | http://www.house.gov/formadriansmith/issues_subscribe.htm | 503 Cannon House Office Building | |||||||
43397 | 43397 | Adam Smith S000510 | rep | WA | 2011-01-05 | 2013-01-03 | Democrat | 9 | http://www.house.gov/adamsmith | 2402 Rayburn HOB; Washington DC 20515-4709 | 202-225-8901 | 202-225-5893 | http://adamsmith.house.gov/Contact/ | 2402 Rayburn House Office Building | |||||||
43384 | 43384 | Albio Sires S001165 | rep | NJ | 2011-01-05 | 2013-01-03 | Democrat | 13 | http://www.house.gov/sires | 2342 Rayburn HOB; Washington DC 20515-3013 | 202-225-7919 | 202-226-0792 | https://forms.house.gov/sires/webforms/issue_subscribe.htm | 2342 Rayburn House Office Building | |||||||
43375 | 43375 | Michael Simpson S001148 | rep | ID | 2011-01-05 | 2013-01-03 | Republican | 2 | http://www.house.gov/simpson | 2312 Rayburn HOB; Washington DC 20515-1202 | 202-225-5531 | 202-225-8216 | http://www.house.gov/simpson/emailme.shtml | 2312 Rayburn House Office Building | |||||||
43363 | 43363 | Brad Sherman S000344 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 27 | http://bradsherman.house.gov | 2242 Rayburn HOB; Washington DC 20515-0527 | 202-225-5911 | 202-225-5879 | http://www.house.gov/sherman/contact/ | 2242 Rayburn House Office Building | |||||||
43354 | 43354 | Richard Shelby S000320 | sen | AL | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.shelby.senate.gov | 304 Russell Senate Office Building Washington DC 20510 | 202-224-5744 | 202-224-3416 | http://www.shelby.senate.gov/public/index.cfm/emailsenatorshelby | 304 Russell Senate Office Building | senior | http://www.shelby.senate.gov/public/index.cfm/rss/feed | |||||
43340 | 43340 | Terri Sewell S001185 | rep | AL | 2011-01-05 | 2013-01-03 | Democrat | 7 | http://sewell.house.gov/ | 1133 Longworth HOB; Washington DC 20515-0107 | 202-225-2665 | 202-226-9567 | 1133 Longworth House Office Building | ||||||||
43336 | 43336 | Tim Scott S001184 | rep | SC | 2011-01-05 | 2013-01-02 | Republican | 1 | http://timscott.house.gov/ | 1117 Longworth HOB; Washington DC 20515-4001 | 202-225-3176 | 202-225-3407 | 1117 Longworth House Office Building | ||||||||
43330 | 43330 | Robert Scott S000185 | rep | VA | 2011-01-05 | 2013-01-03 | Democrat | 3 | http://www.house.gov/scott | 1201 Longworth HOB; Washington DC 20515-4603 | 202-225-8351 | 202-225-8354 | http://www.house.gov/writerep | 1201 Longworth House Office Building | |||||||
43315 | 43315 | David Scott S001157 | rep | GA | 2011-01-05 | 2013-01-03 | Democrat | 13 | http://davidscott.house.gov | 225 Cannon HOB; Washington DC 20515-1013 | 202-225-2939 | 202-225-4628 | http://www.house.gov/writerep | 225 Cannon House Office Building | |||||||
43305 | 43305 | Austin Scott S001189 | rep | GA | 2011-01-05 | 2013-01-03 | Republican | 8 | http://austinscott.house.gov/ | 516 Cannon HOB; Washington DC 20515-1003 | 202-225-6531 | 202-225-3013 | 516 Cannon House Office Building | ||||||||
43299 | 43299 | David Schweikert S001183 | rep | AZ | 2011-01-05 | 2013-01-03 | Republican | 5 | http://schweikert.house.gov/ | 1205 Longworth HOB; Washington DC 20515-0305 | 202-225-2190 | 1205 Longworth House Office Building | |||||||||
43297 | 43297 | Charles Schumer S000148 | sen | NY | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.schumer.senate.gov | 322 Hart Senate Office Building Washington DC 20510 | 202-224-6542 | 202-228-3027 | http://www.schumer.senate.gov/Contact/email-chuck | 322 Hart Senate Office Building | senior | ||||||
43280 | 43280 | Kurt Schrader S001180 | rep | OR | 2011-01-05 | 2013-01-03 | Democrat | 5 | http://schrader.house.gov | 314 Cannon HOB; Washington DC 20515-3705 | 202-225-5711 | 202-225-5699 | https://forms.house.gov/schrader/contact-form.shtml | 314 Cannon House Office Building | |||||||
43273 | 43273 | Adam Schiff S001150 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 29 | http://schiff.house.gov | 2411 Rayburn HOB; Washington DC 20515-0529 | 202-225-4176 | 202-225-5828 | http://schiff.house.gov/HoR/CA29/Contact+Information/Contact+Form.htm | 2411 Rayburn House Office Building | |||||||
43262 | 43262 | Janice Schakowsky S001145 | rep | IL | 2011-01-05 | 2013-01-03 | Democrat | 9 | http://www.house.gov/schakowsky | 2367 Rayburn HOB; Washington DC 20515-1309 | 202-225-2111 | 202-226-6890 | http://www.house.gov/schakowsky/contact.shtml | 2367 Rayburn House Office Building | |||||||
43250 | 43250 | Steve Scalise S001176 | rep | LA | 2011-01-05 | 2013-01-03 | Republican | 1 | http://scalise.house.gov/ | 429 Cannon HOB; Washington DC 20515-1801 | 202-225-3015 | 202-226-0386 | http://www.scalise.house.gov/contactform_zipcheck.shtml | 429 Cannon House Office Building | |||||||
43242 | 43242 | John Sarbanes S001168 | rep | MD | 2011-01-05 | 2013-01-03 | Democrat | 3 | http://sarbanes.house.gov | 2444 Rayburn HOB; Washington DC 20515-2003 | 202-225-4016 | 202-225-9219 | http://sarbanes.house.gov/federal.asp | 2444 Rayburn House Office Building | |||||||
43234 | 43234 | Gregorio Sablan S001177 | rep | MP | 2011-01-05 | 2013-01-03 | Democrat | 0 | http://sablan.house.gov | 423 Cannon HOB; Washington DC 20515-5201 | 202-225-2646 | 202-226-4249 | https://forms.house.gov/sablan/contact-form.shtml | 423 Cannon House Office Building | |||||||
43227 | 43227 | Tim Ryan R000577 | rep | OH | 2011-01-05 | 2013-01-03 | Democrat | 17 | http://timryan.house.gov | 1421 Longworth HOB; Washington DC 20515-3517 | 202-225-5261 | 202-225-3719 | http://timryan.house.gov/index.php?option=com_content&task=view&id=129&Itemid=42 | 1421 Longworth House Office Building | |||||||
43217 | 43217 | Bobby Rush R000515 | rep | IL | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://www.house.gov/rush | 2268 Rayburn HOB; Washington DC 20515-1301 | 202-225-4372 | 202-226-0333 | http://www.house.gov/rush/zipauth.shtml | 2268 Rayburn House Office Building | |||||||
43202 | 43202 | C. Ruppersberger R000576 | rep | MD | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://www.house.gov/ruppersberger | 2453 Rayburn HOB; Washington DC 20515-2002 | 202-225-3061 | 202-225-3094 | http://dutch.house.gov/writedutch_za.shtml | 2453 Rayburn House Office Building | |||||||
43196 | 43196 | Marco Rubio R000595 | sen | FL | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.rubio.senate.gov | 284 Russell Senate Office Building Washington DC 20510 | 202-224-3041 | 202-228-0285 | http://www.rubio.senate.gov/public/index.cfm/contact | 284 Russell Senate Office Building | junior | http://www.rubio.senate.gov/public/?a=rss.feed | |||||
43190 | 43190 | Lucille Roybal-Allard R000486 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 34 | http://www.house.gov/roybal-allard | 2330 Rayburn HOB; Washington DC 20515-0534 | 202-225-1766 | 202-226-0350 | http://www.house.gov/writerep | 2330 Rayburn House Office Building | |||||||
43175 | 43175 | Mike Rogers R000575 | rep | AL | 2011-01-05 | 2013-01-03 | Republican | 3 | http://www.house.gov/mike-rogers | 324 Cannon HOB; Washington DC 20515-0103 | 202-225-3261 | 202-226-8485 | http://www.house.gov/mike-rogers/contact.shtml | 324 Cannon House Office Building | |||||||
43165 | 43165 | Harold Rogers R000395 | rep | KY | 2011-01-05 | 2013-01-03 | Republican | 5 | http://halrogers.house.gov | 2406 Rayburn HOB; Washington DC 20515-1705 | 202-225-4601 | 202-225-0940 | http://halrogers.house.gov/Contact.aspx | 2406 Rayburn House Office Building | |||||||
43144 | 43144 | Mike Quigley Q000023 | rep | IL | 2011-01-05 | 2013-01-03 | Democrat | 5 | http://quigley.house.gov/ | 1124 Longworth HOB; Washington DC 20515-1305 | 202-225-4061 | 202-225-5603 | https://forms.house.gov/quigley/contact-form.shtml | 1124 Longworth House Office Building | |||||||
43137 | 43137 | David Price P000523 | rep | NC | 2011-01-05 | 2013-01-03 | Democrat | 4 | http://price.house.gov | 2162 Rayburn HOB; Washington DC 20515-3304 | 202-225-1784 | 202-225-2014 | http://price.house.gov/contact/contact_form.shtml | 2162 Rayburn House Office Building | |||||||
43120 | 43120 | Bill Posey P000599 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 15 | http://posey.house.gov | 120 Cannon HOB; Washington DC 20515-0915 | 202-225-3671 | 202-225-3516 | http://posey.house.gov/Contact/ | 120 Cannon House Office Building | |||||||
43117 | 43117 | Robert Portman P000449 | sen | OH | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.portman.senate.gov | 448 Russell Senate Office Building Washington DC 20510 | 202-224-3353 | 202-224-9075 | https://www.portman.senate.gov/public/index.cfm/contact-form | 448 Russell Senate Office Building | junior | http://www.portman.senate.gov/public/index.cfm/rss/feed | |||||
43104 | 43104 | Chellie Pingree P000597 | rep | ME | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://pingree.house.gov | 1318 Longworth HOB; Washington DC 20515-1901 | 202-225-6116 | 202-225-5590 | https://forms.house.gov/pingree/contact-form.shtml | 1318 Longworth House Office Building | |||||||
43099 | 43099 | Gary Peters P000595 | rep | MI | 2011-01-05 | 2013-01-03 | Democrat | 9 | http://peters.house.gov | 1609 Longworth HOB; Washington DC 20515-2209 | 202-225-5802 | 202-226-2356 | https://forms.house.gov/peters/contact-form.shtml | 1609 Longworth House Office Building | |||||||
43092 | 43092 | Ed Perlmutter P000593 | rep | CO | 2011-01-05 | 2013-01-03 | Democrat | 7 | http://perlmutter.house.gov | 1221 Longworth HOB; Washington DC 20515-0607 | 202-225-2645 | 202-225-5278 | http://perlmutter.house.gov/IMA/issue_subscribe.htm | 1221 Longworth House Office Building | |||||||
43084 | 43084 | Nancy Pelosi P000197 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 8 | http://www.house.gov/pelosi | 235 Cannon HOB; Washington DC 20515-0508 | 202-225-4965 | 202-225-8259 | http://www.house.gov/pelosi/contact/contact.html | 235 Cannon House Office Building | |||||||
43070 | 43070 | Rand Paul P000603 | sen | KY | 2011-01-05 | 2017-01-03 | 3 | Republican | https://www.paul.senate.gov | 167 Russell Senate Office Building Washington DC 20510 | 202-224-4343 | 202-228-1373 | http://www.paul.senate.gov/?p=contact | 167 Russell Senate Office Building | junior | http://paul.senate.gov/rss/?p=news | |||||
43064 | 43064 | Bill Pascrell P000096 | rep | NJ | 2011-01-05 | 2013-01-03 | Democrat | 8 | http://pascrell.house.gov | 2370 Rayburn HOB; Washington DC 20515-3008 | 202-225-5751 | 202-225-5782 | http://pascrell.house.gov/contact/ | 2370 Rayburn House Office Building | |||||||
43051 | 43051 | Frank Pallone P000034 | rep | NJ | 2011-01-05 | 2013-01-03 | Democrat | 6 | http://www.house.gov/pallone | 237 Cannon HOB; Washington DC 20515-3006 | 202-225-4671 | 202-225-9665 | http://www.house.gov/pallone/contact.shtml | 237 Cannon House Office Building | |||||||
43033 | 43033 | Steven Palazzo P000601 | rep | MS | 2011-01-05 | 2013-01-03 | Republican | 4 | http://palazzo.house.gov/ | 331 Cannon HOB; Washington DC 20515-2404 | 202-225-5772 | 202-225-7074 | 331 Cannon House Office Building | ||||||||
43027 | 43027 | Eleanor Norton N000147 | rep | DC | 2011-01-05 | 2013-01-03 | Democrat | 0 | http://www.house.gov/norton | 2136 Rayburn HOB; Washington DC 20515-5100 | 202-225-8050 | 202-225-3002 | http://www.norton.house.gov/forms/contact.html | 2136 Rayburn House Office Building | |||||||
43011 | 43011 | Richard Neal N000015 | rep | MA | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://www.house.gov/neal | 2208 Rayburn HOB; Washington DC 20515-2102 | 202-225-5601 | 202-225-8112 | http://www.house.gov/neal/write_neal.html | 2208 Rayburn House Office Building | |||||||
42994 | 42994 | Grace Napolitano N000179 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 38 | http://napolitano.house.gov | 1610 Longworth HOB; Washington DC 20515-0538 | 202-225-5256 | 202-225-0027 | http://www.napolitano.house.gov/contact/feedback.htm | 1610 Longworth House Office Building | |||||||
42982 | 42982 | Jerrold Nadler N000002 | rep | NY | 2011-01-05 | 2013-01-03 | Democrat | 8 | http://www.house.gov/nadler | 2334 Rayburn HOB; Washington DC 20515-3208 | 202-225-5635 | 202-225-6923 | http://www.house.gov/nadler/emailform.shtml | 2334 Rayburn House Office Building | |||||||
42970 | 42970 | Patty Murray M001111 | sen | WA | 2011-01-05 | 2017-01-03 | 3 | Democrat | http://www.murray.senate.gov | 154 Russell Senate Office Building Washington DC 20510 | 202-224-2621 | 202-224-0238 | http://www.murray.senate.gov/public/index.cfm/contactme | 154 Russell Senate Office Building | senior | http://www.murray.senate.gov/public/?a=rss.feed | |||||
42964 | 42964 | Christopher Murphy M001169 | rep | CT | 2011-01-05 | 2013-01-03 | Democrat | 5 | http://chrismurphy.house.gov | 412 Cannon HOB; Washington DC 20515-0705 | 202-225-4476 | 202-225-5933 | http://www.house.gov/formchrismurphy/ic_zip_auth.htm | 412 Cannon House Office Building | |||||||
42960 | 42960 | Lisa Murkowski M001153 | sen | AK | 2011-01-05 | 2017-01-03 | 3 | Republican | https://www.murkowski.senate.gov | 709 Hart Senate Office Building Washington DC 20510 | 202-224-6665 | 202-224-5301 | http://www.murkowski.senate.gov/public/index.cfm?p=EMailLisa | 709 Hart Senate Office Building | senior | http://www.murkowski.senate.gov/public/?a=rss.feed | |||||
42956 | 42956 | Jerry Moran M000934 | sen | KS | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.moran.senate.gov | 521 Dirksen Senate Office Building Washington DC 20510 | 202-224-6521 | 202-228-6966 | http://www.moran.senate.gov/public/index.cfm/e-mail-jerry | 521 Dirksen Senate Office Building | junior | http://www.moran.senate.gov/public/index.cfm/rss/feed/ | |||||
42943 | 42943 | Gwen Moore M001160 | rep | WI | 2011-01-05 | 2013-01-03 | Democrat | 4 | http://www.house.gov/gwenmoore | 2245 Rayburn HOB; Washington DC 20515-4904 | 202-225-4572 | 202-225-8135 | http://www.house.gov/gwenmoore/contact.shtml | 2245 Rayburn House Office Building | |||||||
42934 | 42934 | Gregory Meeks M001137 | rep | NY | 2011-01-05 | 2013-01-03 | Democrat | 6 | http://www.house.gov/meeks | 2234 Rayburn HOB; Washington DC 20515-3206 | 202-225-3461 | 202-226-4169 | http://www.house.gov/meeks/contactform_zipcheck.shtml | 2234 Rayburn House Office Building | |||||||
42921 | 42921 | Jerry McNerney M001166 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 11 | http://mcnerney.house.gov | 1210 Longworth HOB; Washington DC 20515-0511 | 202-225-1947 | 202-225-4060 | http://mcnerney.house.gov/contact.shtml | 1210 Longworth House Office Building | |||||||
42913 | 42913 | Cathy McMorris Rodgers M001159 | rep | WA | 2011-01-05 | 2013-01-03 | Republican | 5 | http://mcmorris.house.gov | 2421 Rayburn HOB; Washington DC 20515-4705 | 202-225-2006 | 202-225-3392 | https://mcmorrisforms.house.gov/write-to-cathy1 | 2421 Rayburn House Office Building | |||||||
42904 | 42904 | David McKinley M001180 | rep | WV | 2011-01-05 | 2013-01-03 | Republican | 1 | http://mckinley.house.gov/ | 313 Cannon HOB; Washington DC 20515-4801 | 202-225-4172 | 202-225-7564 | 313 Cannon House Office Building | ||||||||
42898 | 42898 | Patrick McHenry M001156 | rep | NC | 2011-01-05 | 2013-01-03 | Republican | 10 | http://www.house.gov/mchenry | 224 Cannon HOB; Washington DC 20515-3310 | 202-225-2576 | 202-225-0316 | http://mchenry.house.gov/zipauth.htm | 224 Cannon House Office Building | |||||||
42889 | 42889 | James McGovern M000312 | rep | MA | 2011-01-05 | 2013-01-03 | Democrat | 3 | http://www.house.gov/mcgovern | 438 Cannon HOB; Washington DC 20515-2103 | 202-225-6101 | 202-225-5759 | http://www.house.gov/writerep | 438 Cannon House Office Building | |||||||
42876 | 42876 | Betty McCollum M001143 | rep | MN | 2011-01-05 | 2013-01-03 | Democrat | 4 | http://www.house.gov/mccollum | 1714 Longworth HOB; Washington DC 20515-2304 | 202-225-6631 | 202-225-1968 | http://www.mccollum.house.gov/index.asp?Type=NONE&SEC={AC61FD79-AD5F-440D-A7F0-555B12349E5B} | 1714 Longworth House Office Building | |||||||
42865 | 42865 | Tom McClintock M001177 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 4 | http://mcclintock.house.gov | 428 Cannon HOB; Washington DC 20515-0504 | 202-225-2511 | 202-225-5444 | https://forms.house.gov/mcclintock/contact-form.shtml | 428 Cannon House Office Building | |||||||
42858 | 42858 | Michael McCaul M001157 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 10 | http://www.house.gov/mccaul | 131 Cannon HOB; Washington DC 20515-4310 | 202-225-2401 | 202-225-5955 | http://www.house.gov/writerep | 131 Cannon House Office Building | |||||||
42849 | 42849 | Kevin McCarthy M001165 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 22 | http://kevinmccarthy.house.gov | 326 Cannon HOB; Washington DC 20515-0522 | 202-225-2915 | 202-225-2908 | http://kevinmccarthy.house.gov/showpage.asp?ID=69 | 326 Cannon House Office Building | |||||||
42841 | 42841 | Doris Matsui M001163 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 5 | http://www.house.gov/matsui | 222 Cannon HOB; Washington DC 20515-0505 | 202-225-7163 | 202-225-0566 | https://forms.house.gov/matsui/webforms/issue_subscribe.htm | 222 Cannon House Office Building | |||||||
42833 | 42833 | Edward Markey M000133 | rep | MA | 2011-01-05 | 2013-01-03 | Democrat | 7 | http://www.house.gov/markey | 2108 Rayburn HOB; Washington DC 20515-2107 | 202-225-2836 | 202-226-0092 | http://markey.house.gov/index.php?option=com_email_form&Itemid=124 | 2108 Rayburn House Office Building | |||||||
42809 | 42809 | Carolyn Maloney M000087 | rep | NY | 2011-01-05 | 2013-01-03 | Democrat | 14 | http://maloney.house.gov | 2332 Rayburn HOB; Washington DC 20515-3214 | 202-225-7944 | 202-225-4709 | http://maloney.house.gov/index.php?option=com_email_form&Itemid=73 | 2332 Rayburn House Office Building | |||||||
42794 | 42794 | Stephen Lynch L000562 | rep | MA | 2011-01-05 | 2013-01-03 | Democrat | 9 | http://www.house.gov/lynch | 2348 Rayburn HOB; Washington DC 20515-2109 | 202-225-8273 | 202-225-3984 | http://www.house.gov/writerep | 2348 Rayburn House Office Building | |||||||
42783 | 42783 | Ben Luján L000570 | rep | NM | 2011-01-05 | 2013-01-03 | Democrat | 3 | http://lujan.house.gov | 330 Cannon HOB; Washington DC 20515-3103 | 202-225-6190 | 202-226-1528 | https://forms.house.gov/lujan/contact-form.shtml | 330 Cannon House Office Building | |||||||
42776 | 42776 | Blaine Luetkemeyer L000569 | rep | MO | 2011-01-05 | 2013-01-03 | Republican | 9 | http://luetkemeyer.house.gov | 1740 Longworth HOB; Washington DC 20515-2509 | 202-225-2956 | 202-225-5712 | https://forms.house.gov/luetkemeyer/contact-form.shtml | 1740 Longworth House Office Building | |||||||
42769 | 42769 | Frank Lucas L000491 | rep | OK | 2011-01-05 | 2013-01-03 | Republican | 3 | http://www.house.gov/lucas | 2311 Rayburn HOB; Washington DC 20515-3603 | 202-225-5565 | 202-225-8698 | http://www.house.gov/lucas/zipauth.htm | 2311 Rayburn House Office Building | |||||||
42754 | 42754 | Billy Long L000576 | rep | MO | 2011-01-05 | 2013-01-03 | Republican | 7 | http://long.house.gov/ | 1541 Longworth HOB; Washington DC 20515-2507 | 202-225-6536 | 202-225-5604 | 1541 Longworth House Office Building | ||||||||
42748 | 42748 | Zoe Lofgren L000397 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 16 | http://www.house.gov/lofgren | 1401 Longworth HOB; Washington DC 20515-0516 | 202-225-3072 | 202-225-3336 | http://lofgren.house.gov/emailform.shtml | 1401 Longworth House Office Building | |||||||
42738 | 42738 | Mike Lee L000577 | sen | UT | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.lee.senate.gov | 361A Russell Senate Office Building Washington DC 20510 | 202-224-5444 | http://www.lee.senate.gov/public/index.cfm/contact | 361a Russell Senate Office Building | junior | http://www.lee.senate.gov/public/index.cfm/rss/feed | ||||||
42732 | 42732 | Barbara Lee L000551 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 9 | http://lee.house.gov | 2267 Rayburn HOB; Washington DC 20515-0509 | 202-225-2661 | 202-225-9817 | http://lee.house.gov/?sectionid=44&sectiontree=18,44 | 2267 Rayburn House Office Building | |||||||
42723 | 42723 | Patrick Leahy L000174 | sen | VT | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.leahy.senate.gov | 437 Russell Senate Office Building Washington DC 20510 | 202-224-4242 | 202-224-3479 | https://www.leahy.senate.gov/contact/ | 437 Russell Senate Office Building | senior | http://www.leahy.senate.gov/rss/feeds/press/ | |||||
42711 | 42711 | Robert Latta L000566 | rep | OH | 2011-01-05 | 2013-01-03 | Republican | 5 | http://latta.house.gov/ | 1323 Longworth HOB; Washington DC 20515-3505 | 202-225-6405 | 202-225-1985 | http://latta.house.gov/contactform_zipcheck.shtml | 1323 Longworth House Office Building | |||||||
42703 | 42703 | John Larson L000557 | rep | CT | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://www.house.gov/larson | 1501 Longworth HOB; Washington DC 20515-0701 | 202-225-2265 | 202-225-1031 | http://www.house.gov/writerep | 1501 Longworth House Office Building | |||||||
42691 | 42691 | Rick Larsen L000560 | rep | WA | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://www.house.gov/larsen | 108 Cannon HOB; Washington DC 20515-4702 | 202-225-2605 | 202-225-4420 | http://www.house.gov/larsen/contact/ | 108 Cannon House Office Building |
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);