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 party
This data as json, copyable, CSV (advanced)
Suggested facets: type, party, office, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38941 | 38941 | Dennis Cardoza C001050 | rep | CA | 2011-01-05 | 2012-08-15 | Democrat | 18 | http://www.house.gov/cardoza | 2437 Rayburn House Office Building; 20515-0518 | 202-225-6131 | 202-225-0819 | https://forms.house.gov/wyr/welcome.shtml | 2437 Rayburn House Office Building | |||||||
38948 | 38948 | Gabrielle Giffords G000554 | rep | AZ | 2011-01-05 | 2012-01-25 | Democrat | 8 | http://giffords.house.gov | 1030 Longworth House Office Building; 20515-0308 | |||||||||||
38957 | 38957 | Jane Harman H000213 | rep | CA | 2011-01-05 | 2011-02-28 | Democrat | 36 | http://www.house.gov/harman | ||||||||||||
38965 | 38965 | Jay Inslee I000026 | rep | WA | 2011-01-05 | 2012-03-20 | Democrat | 1 | http://www.house.gov/inslee | 2329 Rayburn House Office Building; 20515-4701 | 202-225-6311 | 202-226-1606 | http://www.house.gov/inslee/contact/email.html | 2329 Rayburn House Office Building | |||||||
38984 | 38984 | Donald Payne P000149 | rep | NJ | 2011-01-05 | 2012-03-06 | Democrat | 10 | http://www.house.gov/payne | 2310 Rayburn House Office Building; 20515-3010 | 202-225-3436 | 202-225-4160 | http://www.house.gov/payne/IMA/email.shtml | 2310 Rayburn House Office Building | |||||||
38991 | 38991 | Anthony Weiner W000792 | rep | NY | 2011-01-05 | 2011-06-21 | Democrat | 9 | http://www.house.gov/weiner | 2104 Rayburn House Office Building; 20515-3209 | |||||||||||
38998 | 38998 | David Wu W000793 | rep | OR | 2011-01-05 | 2011-08-03 | Democrat | 1 | http://www.house.gov/wu | 2338 Rayburn House Office Building; 20515-3701 | |||||||||||
39007 | 39007 | Jesse Jackson J000283 | rep | IL | 2011-01-05 | 2012-11-21 | Democrat | 2 | http://www.house.gov/jackson/ | 2419 Rayburn HOB; Washington DC 20515-1302 | 202-225-0773 | 202-225-0899 | http://www.house.gov/jackson/ContactByEMail.shtml | 2419 Rayburn House Office Building | |||||||
39017 | 39017 | Bob Filner F000116 | rep | CA | 2011-01-05 | 2012-12-03 | Democrat | 51 | http://www.house.gov/filner | 2428 Rayburn HOB; Washington DC 20515-0551 | 202-225-8045 | 202-225-9073 | http://www.house.gov/writerep | 2428 Rayburn House Office Building | |||||||
39029 | 39029 | Daniel Inouye I000025 | sen | HI | 2011-01-05 | 2012-12-17 | 3 | Democrat | http://inouye.senate.gov/ | 722 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-3934 | 202-224-6747 | http://www.inouye.senate.gov/Contact/ContactDKI.cfm | 722 Hart Senate Office Building | |||||||
39098 | 39098 | Gary Ackerman A000022 | rep | NY | 2011-01-05 | 2013-01-03 | Democrat | 5 | http://ackerman.house.gov/ | 2111 Rayburn HOB; Washington DC 20515-3205 | 202-225-2601 | 202-225-1589 | http://www.house.gov/writerep | 2111 Rayburn House Office Building | |||||||
39108 | 39108 | Jason Altmire A000362 | rep | PA | 2011-01-05 | 2013-01-03 | Democrat | 4 | http://altmire.house.gov | 332 Cannon HOB; Washington DC 20515-3804 | 202-225-2565 | 202-226-2274 | https://forms.house.gov/altmire/webforms/issue_subscribe.htm | 332 Cannon House Office Building | |||||||
39117 | 39117 | Joe Baca B001234 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 43 | http://www.house.gov/baca | 2366 Rayburn HOB; Washington DC 20515-0543 | 202-225-6161 | 202-225-8671 | http://www.house.gov/baca/zipauth.shtml | 2366 Rayburn House Office Building | |||||||
39142 | 39142 | Shelley Berkley B001231 | rep | NV | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://berkley.house.gov | 405 Cannon HOB; Washington DC 20515-2801 | 202-225-5965 | 202-225-3119 | http://berkley.house.gov/contact/email.html | 405 Cannon House Office Building | |||||||
39157 | 39157 | Howard Berman B000410 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 28 | http://www.house.gov/berman | 2221 Rayburn HOB; Washington DC 20515-0528 | 202-225-4695 | 202-225-3196 | http://www.house.gov/berman/contact/ | 2221 Rayburn House Office Building | |||||||
39183 | 39183 | Dan Boren B001254 | rep | OK | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://www.house.gov/boren | 2447 Rayburn HOB; Washington DC 20515-3602 | 202-225-2701 | 202-225-3038 | http://www.house.gov/boren/emailsignup.shtml | 2447 Rayburn House Office Building | |||||||
39191 | 39191 | Leonard Boswell B000652 | rep | IA | 2011-01-05 | 2013-01-03 | Democrat | 3 | http://boswell.house.gov | 1026 Longworth HOB; Washington DC 20515-1503 | 202-225-3806 | 202-225-5608 | http://boswell.house.gov/messageform.htm | 1026 Longworth House Office Building | |||||||
39212 | 39212 | Russ Carnahan C001060 | rep | MO | 2011-01-05 | 2013-01-03 | Democrat | 3 | http://www.house.gov/carnahan | 1710 Longworth HOB; Washington DC 20515-2503 | 202-225-2671 | 202-225-7452 | http://carnahan.house.gov/contact.shtml | 1710 Longworth House Office Building | |||||||
39217 | 39217 | Ben Chandler C001058 | rep | KY | 2011-01-05 | 2013-01-03 | Democrat | 6 | http://chandler.house.gov | 1504 Longworth HOB; Washington DC 20515-1706 | 202-225-4706 | 202-225-2122 | https://forms.house.gov/wyr/welcome.shtml | 1504 Longworth House Office Building | |||||||
39218 | 39218 | Hansen Clarke C001085 | rep | MI | 2011-01-05 | 2013-01-03 | Democrat | 13 | http://hansenclarke.house.gov/ | 1319 Longworth HOB; Washington DC 20515-2213 | 202-225-2261 | 202-225-5730 | 1319 Longworth House Office Building | ||||||||
39231 | 39231 | Jerry Costello C000794 | rep | IL | 2011-01-05 | 2013-01-03 | Democrat | 12 | http://www.house.gov/costello | 2408 Rayburn HOB; Washington DC 20515-1312 | 202-225-5661 | 202-225-0285 | http://costello.house.gov/IMA/issue_subscribe.shtml | 2408 Rayburn House Office Building | |||||||
39234 | 39234 | Mark Critz C001081 | rep | PA | 2011-01-05 | 2013-01-03 | Democrat | 12 | http://critz.house.gov/ | 1022 Longworth HOB; Washington DC 20515-3812 | 202-225-2065 | 202-225-5974 | https://critz.house.gov/contact/email-me.shtml | 1022 Longworth House Office Building | |||||||
39252 | 39252 | Norman Dicks D000327 | rep | WA | 2011-01-05 | 2013-01-03 | Democrat | 6 | http://www.house.gov/dicks | 2467 Rayburn HOB; Washington DC 20515-4706 | 202-225-5916 | 202-226-1176 | http://www.house.gov/dicks/email.shtml | 2467 Rayburn House Office Building | |||||||
39284 | 39284 | Barney Frank F000339 | rep | MA | 2011-01-05 | 2013-01-03 | Democrat | 4 | http://www.house.gov/frank | 2252 Rayburn HOB; Washington DC 20515-2104 | 202-225-5931 | 202-225-0182 | http://www.house.gov/writerep | 2252 Rayburn House Office Building | |||||||
39304 | 39304 | Charles Gonzalez G000544 | rep | TX | 2011-01-05 | 2013-01-03 | Democrat | 20 | http://gonzalez.house.gov | 1436 Longworth HOB; Washington DC 20515-4320 | 202-225-3236 | 202-225-1915 | http://www.gonzalez.house.gov/index.php?option=com_content&task=view&id=170 | 1436 Longworth House Office Building | |||||||
39328 | 39328 | Maurice Hinchey H000627 | rep | NY | 2011-01-05 | 2013-01-03 | Democrat | 22 | http://www.house.gov/hinchey | 2431 Rayburn HOB; Washington DC 20515-3222 | 202-225-6335 | 202-226-0774 | http://www.house.gov/hinchey/contact/zipauth.shtml | 2431 Rayburn House Office Building | |||||||
39338 | 39338 | Tim Holden H000712 | rep | PA | 2011-01-05 | 2013-01-03 | Democrat | 17 | http://www.holden.house.gov | 2417 Rayburn HOB; Washington DC 20515-3817 | 202-225-5546 | 202-226-0996 | http://www.holden.house.gov/contactform_zipcheck.shtml | 2417 Rayburn House Office Building | |||||||
39362 | 39362 | Dale Kildee K000172 | rep | MI | 2011-01-05 | 2013-01-03 | Democrat | 5 | http://www.house.gov/kildee | 2107 Rayburn HOB; Washington DC 20515-2205 | 202-225-3611 | 202-225-6393 | http://www.house.gov/writerep | 2107 Rayburn House Office Building | |||||||
39364 | 39364 | Larry Kissell K000369 | rep | NC | 2011-01-05 | 2013-01-03 | Democrat | 8 | http://kissell.house.gov | 1632 Longworth HOB; Washington DC 20515-3308 | 202-225-3715 | 202-225-4036 | https://forms.house.gov/kissell/contact-form.shtml | 1632 Longworth House Office Building | |||||||
39372 | 39372 | Dennis Kucinich K000336 | rep | OH | 2011-01-05 | 2013-01-03 | Democrat | 10 | http://kucinich.house.gov | 2445 Rayburn HOB; Washington DC 20515-3510 | 202-225-5871 | 202-225-5745 | http://kucinich.house.gov/Contact/Starter.htm | 2445 Rayburn House Office Building | |||||||
39427 | 39427 | R. Miller M001154 | rep | NC | 2011-01-05 | 2013-01-03 | Democrat | 13 | http://www.house.gov/bradmiller | 1127 Longworth HOB; Washington DC 20515-3313 | 202-225-3032 | 202-225-0181 | http://bradmiller.house.gov/?sectionid=17§iontree=9,17 | 1127 Longworth House Office Building | |||||||
39447 | 39447 | John Olver O000085 | rep | MA | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://www.house.gov/olver | 1111 Longworth HOB; Washington DC 20515-2101 | 202-225-5335 | 202-226-1224 | http://www.house.gov/olver/contactme.html | 1111 Longworth House Office Building | |||||||
39486 | 39486 | Silvestre Reyes R000170 | rep | TX | 2011-01-05 | 2013-01-03 | Democrat | 16 | http://wwwc.house.gov/reyes | 2210 Rayburn HOB; Washington DC 20515-4316 | 202-225-4831 | 202-225-2016 | http://wwwc.house.gov/reyes/voice_your_opinion.asp | 2210 Rayburn House Office Building | |||||||
39489 | 39489 | Laura Richardson R000581 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 37 | http://richardson.house.gov/ | 1330 Longworth HOB; Washington DC 20515-0537 | 202-225-7924 | 202-225-7926 | http://richardson.house.gov/IMA/issue_subscribe.htm | 1330 Longworth House Office Building | |||||||
39496 | 39496 | Mike Ross R000573 | rep | AR | 2011-01-05 | 2013-01-03 | Democrat | 4 | http://www.house.gov/ross | 2436 Rayburn HOB; Washington DC 20515-0404 | 202-225-3772 | 202-225-1314 | http://ross.house.gov/?sectionid=77§iontree=76,77 | 2436 Rayburn House Office Building | |||||||
39504 | 39504 | Steven Rothman R000462 | rep | NJ | 2011-01-05 | 2013-01-03 | Democrat | 9 | http://rothman.house.gov | 2303 Rayburn HOB; Washington DC 20515-3009 | 202-225-5061 | 202-225-5851 | https://forms.house.gov/rothman/webforms/issue_subscribe.htm | 2303 Rayburn House Office Building | |||||||
39512 | 39512 | Heath Shuler S001171 | rep | NC | 2011-01-05 | 2013-01-03 | Democrat | 11 | http://shuler.house.gov | 229 Cannon HOB; Washington DC 20515-3311 | 202-225-6401 | 202-226-6422 | http://shuler.house.gov/zipauth.htm | 229 Cannon House Office Building | |||||||
39532 | 39532 | Fortney Stark S000810 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 13 | http://www.house.gov/stark | 239 Cannon HOB; Washington DC 20515-0513 | 202-225-5065 | 202-226-3805 | http://www.house.gov/stark/contact/index.htm | 239 Cannon House Office Building | |||||||
39553 | 39553 | Betty Sutton S001174 | rep | OH | 2011-01-05 | 2013-01-03 | Democrat | 13 | http://sutton.house.gov | 1519 Longworth HOB; Washington DC 20515-3513 | 202-225-3401 | 202-225-2266 | http://sutton.house.gov/about/emailform.cfm | 1519 Longworth House Office Building | |||||||
39568 | 39568 | Edolphus Towns T000326 | rep | NY | 2011-01-05 | 2013-01-03 | Democrat | 10 | http://www.house.gov/towns | 2232 Rayburn HOB; Washington DC 20515-3210 | 202-225-5936 | 202-225-1018 | http://www.house.gov/towns/contact_form_zipcheck.shtml | 2232 Rayburn House Office Building | |||||||
39580 | 39580 | Lynn Woolsey W000738 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 6 | http://woolsey.house.gov | 2263 Rayburn HOB; Washington DC 20515-0506 | 202-225-5161 | 202-225-5163 | http://woolsey.house.gov/contactemailform.asp | 2263 Rayburn House Office Building | |||||||
39654 | 39654 | Melvin Watt W000207 | rep | NC | 2011-01-05 | 2013-01-03 | Democrat | 12 | http://www.house.gov/watt | 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 | |||||||
39677 | 39677 | Robert Andrews A000210 | rep | NJ | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://www.house.gov/andrews | 2265 Rayburn HOB; Washington DC 20515-3001 | 202-225-6501 | http://www.house.gov/andrews/contact_form_za.shtml | 2265 Rayburn House Office Building | ||||||||
39752 | 39752 | John Barrow B001252 | rep | GA | 2011-01-05 | 2013-01-03 | Democrat | 12 | http://barrow.house.gov | 2202 Rayburn HOB; Washington DC 20515-1012 | 202-225-2823 | 202-225-3377 | https://forms.house.gov/barrow/webforms/issue_subscribe.htm | 2202 Rayburn House Office Building | |||||||
39758 | 39758 | Timothy Bishop B001242 | rep | NY | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://timbishop.house.gov/ | 306 Cannon HOB; Washington DC 20515-3201 | 202-225-3826 | 202-225-3143 | http://timbishop.house.gov/?sectionid=96&sectiontree=7,96 | 306 Cannon House Office Building | |||||||
39762 | 39762 | Bruce Braley B001259 | rep | IA | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://braley.house.gov | 1727 Longworth HOB; Washington DC 20515-1501 | 202-225-2911 | 202-225-6666 | https://forms.house.gov/braley/webforms/issue_subscribe.html | 1727 Longworth House Office Building | |||||||
39792 | 39792 | Donna Christensen C000380 | rep | VI | 2011-01-05 | 2013-01-03 | Democrat | 0 | http://www.donnachristensen.house.gov/ | 1510 Longworth HOB; Washington DC 20515-5501 | 202-225-1790 | 202-225-5517 | |||||||||
39827 | 39827 | John Dingell D000355 | rep | MI | 2011-01-05 | 2013-01-03 | Democrat | 15 | http://www.house.gov/dingell | 2328 Rayburn HOB; Washington DC 20515-2215 | 202-225-4071 | 202-226-0371 | https://forms.house.gov/wyr/welcome.shtml | 2328 Rayburn House Office Building | |||||||
39840 | 39840 | Eni Faleomavaega F000010 | rep | AS | 2011-01-05 | 2013-01-03 | Democrat | 0 | http://www.house.gov/faleomavaega | 2422 Rayburn HOB; Washington DC 20515-5201 | 202-225-8577 | 202-225-8757 | http://www.house.gov/writerep | 2422 Rayburn House Office Building | |||||||
39889 | 39889 | Rush Holt H001032 | rep | NJ | 2011-01-05 | 2013-01-03 | Democrat | 12 | http://holt.house.gov | 1214 Longworth HOB; Washington DC 20515-3012 | 202-225-5801 | 202-225-6025 | http://www.holt.house.gov/contact.shtml | 1214 Longworth House Office Building | |||||||
39917 | 39917 | Jim Matheson M001142 | rep | UT | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://www.house.gov/matheson | 2434 Rayburn HOB; Washington DC 20515-4402 | 202-225-3011 | 202-225-5638 | https://forms.house.gov/matheson/contact.shtml | 2434 Rayburn House Office Building | |||||||
39926 | 39926 | Carolyn McCarthy M000309 | rep | NY | 2011-01-05 | 2013-01-03 | Democrat | 4 | http://www.house.gov/carolynmccarthy | 2346 Rayburn HOB; Washington DC 20515-3204 | 202-225-5516 | 202-225-5758 | http://www.house.gov/writerep | 2346 Rayburn House Office Building | |||||||
39935 | 39935 | Mike McIntyre M000485 | rep | NC | 2011-01-05 | 2013-01-03 | Democrat | 7 | http://www.house.gov/mcintyre | 2133 Rayburn HOB; Washington DC 20515-3307 | 202-225-2731 | 202-225-5773 | http://www.house.gov/mcintyre/IMA/issue.htm | 2133 Rayburn House Office Building | |||||||
39952 | 39952 | Michael Michaud M001149 | rep | ME | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://michaud.house.gov | 1724 Longworth HOB; Washington DC 20515-1902 | 202-225-6306 | 202-225-2943 | https://forms.house.gov/michaud/webforms/issue_subscribe.htm | 1724 Longworth House Office Building | |||||||
39980 | 39980 | George Miller M000725 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 7 | http://www.house.gov/georgemiller | 2205 Rayburn HOB; Washington DC 20515-0507 | 202-225-2095 | 202-225-5609 | http://georgemiller.house.gov/contactus/2007/08/post_1.html | 2205 Rayburn House Office Building | |||||||
39992 | 39992 | James Moran M000933 | rep | VA | 2011-01-05 | 2013-01-03 | Democrat | 8 | http://www.house.gov/moran | 2239 Rayburn HOB; Washington DC 20515-4608 | 202-225-4376 | 202-225-0017 | http://moran.house.gov/zipauth.shtml | 2239 Rayburn House Office Building | |||||||
39995 | 39995 | William Owens O000169 | rep | NY | 2011-01-05 | 2013-01-03 | Democrat | 23 | http://owens.house.gov/ | 431 Cannon HOB; Washington DC 20515-3223 | 202-225-4611 | 202-226-0621 | http://owens.house.gov/contact/email-me.shtml | 431 Cannon House Office Building | |||||||
40007 | 40007 | Ed Pastor P000099 | rep | AZ | 2011-01-05 | 2013-01-03 | Democrat | 4 | http://www.house.gov/pastor | 2465 Rayburn HOB; Washington DC 20515-0304 | 202-225-4065 | 202-225-1655 | http://www.house.gov/writerep | 2465 Rayburn House Office Building | |||||||
40044 | 40044 | Nick Rahall R000011 | rep | WV | 2011-01-05 | 2013-01-03 | Democrat | 3 | http://www.rahall.house.gov | 2307 Rayburn HOB; Washington DC 20515-4803 | 202-225-3452 | 202-225-9061 | http://www.rahall.house.gov/?sectionid=9&sectiontree=9 | 2307 Rayburn House Office Building | |||||||
40058 | 40058 | Allyson Schwartz S001162 | rep | PA | 2011-01-05 | 2013-01-03 | Democrat | 13 | http://www.house.gov/schwartz | 1227 Longworth HOB; Washington DC 20515-3813 | 202-225-6111 | 202-226-0611 | http://schwartz.house.gov/serving-you/email-me | 1227 Longworth House Office Building | |||||||
40077 | 40077 | John Tierney T000266 | rep | MA | 2011-01-05 | 2013-01-03 | Democrat | 6 | http://www.house.gov/tierney | 2238 Rayburn HOB; Washington DC 20515-2106 | 202-225-8020 | 202-225-5915 | http://www.house.gov/tierney/IMA/email.shtml | 2238 Rayburn House Office Building | |||||||
40097 | 40097 | Henry Waxman W000215 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 30 | http://www.henrywaxman.house.gov | 2204 Rayburn HOB; Washington DC 20515-0530 | 202-225-3976 | 202-225-4099 | http://waxman.house.gov/Contact/ | 2204 Rayburn House Office Building | |||||||
40175 | 40175 | Chaka Fattah F000043 | rep | PA | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://www.house.gov/fattah | 2301 Rayburn HOB; Washington DC 20515-3802 | 202-225-4001 | 202-225-5392 | http://fattah.house.gov/?sectionid=8&sectiontree=8 | 2301 Rayburn House Office Building | |||||||
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 | ||||||
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 | ||||||
40264 | 40264 | Corrine Brown B000911 | rep | FL | 2011-01-05 | 2013-01-03 | Democrat | 3 | http://www.house.gov/corrinebrown | 2336 Rayburn HOB; Washington DC 20515-0903 | 202-225-0123 | 202-225-2256 | http://www.house.gov/corrinebrown/IMA/issue.shtml | 2336 Rayburn House Office Building | |||||||
40274 | 40274 | Lois Capps C001036 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 23 | http://www.house.gov/capps | 2231 Rayburn HOB; Washington DC 20515-0523 | 202-225-3601 | 202-225-5632 | http://www.house.gov/capps/contact/send_an_email.shtml | 2231 Rayburn House Office Building | |||||||
40277 | 40277 | John Carney C001083 | rep | DE | 2011-01-05 | 2013-01-03 | Democrat | 0 | http://johncarney.house.gov/ | 1429 Longworth HOB; Washington DC 20515-0801 | 202-225-4165 | 202-225-2291 | https://forms.house.gov/carney/webforms/email-me.shtml | 1429 Longworth House Office Building | |||||||
40290 | 40290 | Donna Edwards E000290 | rep | MD | 2011-01-05 | 2013-01-03 | Democrat | 4 | http://donnaedwards.house.gov/ | 318 Cannon HOB; Washington DC 20515-2004 | 202-225-8699 | 202-225-8714 | http://www.house.gov/writerep | 318 Cannon House Office Building | |||||||
40305 | 40305 | Sam Farr F000030 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 17 | http://www.house.gov/farr | 1126 Longworth HOB; Washington DC 20515-0517 | 202-225-2861 | 202-225-6791 | http://www.farr.house.gov/index.php?option=com_content&task=view&id=202 | 1126 Longworth House Office Building | |||||||
40350 | 40350 | Rubén Hinojosa H000636 | rep | TX | 2011-01-05 | 2013-01-03 | Democrat | 15 | http://hinojosa.house.gov | 2262 Rayburn HOB; Washington DC 20515-4315 | 202-225-2531 | 202-225-5688 | http://www.house.gov/writerep | 2262 Rayburn House Office Building | |||||||
40358 | 40358 | Michael Honda H001034 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 15 | http://www.house.gov/honda | 1713 Longworth HOB; Washington DC 20515-0515 | 202-225-2631 | 202-225-2699 | http://honda.house.gov/contactmike.shtml | 1713 Longworth House Office Building | |||||||
40372 | 40372 | Steve Israel I000057 | rep | NY | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://www.house.gov/israel | 2457 Rayburn HOB; Washington DC 20515-3202 | 202-225-3335 | 202-225-4669 | http://www.house.gov/formisrael/contact.html | 2457 Rayburn House Office Building | |||||||
40393 | 40393 | Jim McDermott M000404 | rep | WA | 2011-01-05 | 2013-01-03 | Democrat | 7 | http://www.house.gov/mcdermott | 1035 Longworth HOB; Washington DC 20515-4707 | 202-225-3106 | 202-225-6197 | http://www.house.gov/mcdermott/contact.shtml | 1035 Longworth House Office Building | |||||||
40458 | 40458 | Charles Rangel R000053 | rep | NY | 2011-01-05 | 2013-01-03 | Democrat | 15 | http://rangel.house.gov | 2354 Rayburn HOB; Washington DC 20515-3215 | 202-225-4365 | 202-225-0816 | https://forms.house.gov/rangel/forms/contact.shtml | 2354 Rayburn House Office Building | |||||||
40474 | 40474 | Loretta Sanchez S000030 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 47 | http://www.lorettasanchez.house.gov | 1114 Longworth HOB; Washington DC 20515-0547 | 202-225-2965 | 202-225-5859 | http://www.lorettasanchez.house.gov/index.php?option=com_content&task=view&id=218&Itemid=17 | 1114 Longworth House Office Building | |||||||
40521 | 40521 | Xavier Becerra B000287 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 31 | http://becerra.house.gov | 1226 Longworth HOB; Washington DC 20515-0531 | 202-225-6235 | 202-225-2202 | http://becerra.house.gov/HoR/CA31/Hidden+Content/Email+Signup+Form.htm | 1226 Longworth House Office Building | |||||||
40578 | 40578 | John Conyers C000714 | rep | MI | 2011-01-05 | 2013-01-03 | Democrat | 14 | http://www.house.gov/conyers | 2426 Rayburn HOB; Washington DC 20515-2214 | 202-225-5126 | 202-225-0072 | http://conyers.house.gov/index.cfm?FuseAction=Contact.OnlineContactForm | 2426 Rayburn House Office Building | |||||||
40614 | 40614 | Louise Slaughter S000480 | rep | NY | 2011-01-05 | 2013-01-03 | Democrat | 28 | http://www.louise.house.gov | 2469 Rayburn HOB; Washington DC 20515-3228 | 202-225-3615 | 202-225-7822 | http://www.louise.house.gov/index.php?option=com_content&task=view&id=506&Itemid=150 | 2469 Rayburn House Office Building | |||||||
40719 | 40719 | Madeleine Bordallo B001245 | rep | GU | 2011-01-05 | 2013-01-03 | Democrat | 0 | http://www.house.gov/bordallo | 2441 Rayburn HOB; Washington DC 20515-5301 | 202-225-1188 | 202-226-0341 | http://www.house.gov/bordallo/IMA/issue.htm | 2441 Rayburn House Office Building | |||||||
40730 | 40730 | Robert Brady B001227 | rep | PA | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://www.brady.house.gov | 102 Cannon HOB; Washington DC 20515-3801 | 202-225-4731 | 202-225-0088 | http://www.house.gov/formrobertbrady/issue.htm | 102 Cannon House Office Building | |||||||
40740 | 40740 | Michael Capuano C001037 | rep | MA | 2011-01-05 | 2013-01-03 | Democrat | 8 | http://www.house.gov/capuano | 1414 Longworth HOB; Washington DC 20515-2108 | 202-225-5111 | 202-225-9322 | http://www.house.gov/capuano/contact/email.shtml | 1414 Longworth House Office Building | |||||||
40755 | 40755 | Joseph Crowley C001038 | rep | NY | 2011-01-05 | 2013-01-03 | Democrat | 7 | http://www.house.gov/crowley | 2404 Rayburn HOB; Washington DC 20515-3207 | 202-225-3965 | 202-225-1909 | https://forms.house.gov/crowley/contact.shtml | 2404 Rayburn House Office Building | |||||||
40774 | 40774 | Joe Donnelly D000607 | rep | IN | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://donnelly.house.gov | 1530 Longworth HOB; Washington DC 20515-1402 | 202-225-3915 | 202-225-6798 | http://donnelly.house.gov/issue_subscribe.shtml | 1530 Longworth House Office Building | |||||||
40794 | 40794 | Keith Ellison E000288 | rep | MN | 2011-01-05 | 2013-01-03 | Democrat | 5 | http://ellison.house.gov | 1027 Longworth HOB; Washington DC 20515-2305 | 202-225-4755 | 202-225-4886 | http://ellison.house.gov/index.php?option=com_content&task=view&id=87 | 1027 Longworth House Office Building | |||||||
40843 | 40843 | Gene Green G000410 | rep | TX | 2011-01-05 | 2013-01-03 | Democrat | 29 | http://www.house.gov/green | 2470 Rayburn HOB; Washington DC 20515-4329 | 202-225-1688 | 202-225-9903 | http://www.house.gov/green/contact | 2470 Rayburn House Office Building | |||||||
40856 | 40856 | Luis Gutiérrez G000535 | rep | IL | 2011-01-05 | 2013-01-03 | Democrat | 4 | http://www.house.gov/gutierrez | 2266 Rayburn HOB; Washington DC 20515-1304 | 202-225-8203 | 202-225-7810 | http://www.house.gov/writerep | 2266 Rayburn House Office Building | |||||||
40919 | 40919 | Sander Levin L000263 | rep | MI | 2011-01-05 | 2013-01-03 | Democrat | 12 | http://www.house.gov/levin | 1236 Longworth HOB; Washington DC 20515-2212 | 202-225-4961 | 202-226-1033 | http://www.house.gov/levin/levin_contact_email.shtml | 1236 Longworth House Office Building | |||||||
40959 | 40959 | Jared Polis P000598 | rep | CO | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://polis.house.gov | 501 Cannon HOB; Washington DC 20515-0602 | 202-225-2161 | 202-226-7840 | http://polis.house.gov/Contact/ | 501 Cannon House Office Building | |||||||
41073 | 41073 | Niki Tsongas T000465 | rep | MA | 2011-01-05 | 2013-01-03 | Democrat | 5 | http://tsongas.house.gov/ | 1607 Longworth HOB; Washington DC 20515-2105 | 202-225-3411 | 202-226-0771 | http://tsongas.house.gov/?sectionid=11&sectiontree=3,11 | 1607 Longworth House Office Building | |||||||
41079 | 41079 | Timothy Walz W000799 | rep | MN | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://walz.house.gov | 1722 Longworth HOB; Washington DC 20515-2301 | 202-225-2472 | 202-225-3433 | http://walz.house.gov/zip_auth.shtm | 1722 Longworth House Office Building | |||||||
41154 | 41154 | Colleen Hanabusa H001050 | rep | HI | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://hanabusa.house.gov/ | 238 Cannon HOB; Washington DC 20515-1101 | 202-225-2726 | 202-225-4580 | 238 Cannon House Office Building | ||||||||
41204 | 41204 | Elijah Cummings C000984 | rep | MD | 2011-01-05 | 2013-01-03 | Democrat | 7 | http://www.house.gov/cummings | 2235 Rayburn HOB; Washington DC 20515-2007 | 202-225-4741 | 202-225-3178 | https://forms.house.gov/wyr/welcome.shtml | 2235 Rayburn House Office Building | |||||||
41241 | 41241 | John Lewis L000287 | rep | GA | 2011-01-05 | 2013-01-03 | Democrat | 5 | http://www.house.gov/johnlewis | 343 Cannon HOB; Washington DC 20515-1005 | 202-225-3801 | 202-225-0351 | http://www.house.gov/formjohnlewis/contact.html | 343 Cannon House Office Building | |||||||
41304 | 41304 | Wm. Clay C001049 | rep | MO | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://www.house.gov/clay | 2418 Rayburn HOB; Washington DC 20515-2501 | 202-225-2406 | 202-226-3717 | http://lacyclay.house.gov/contact.htm | 2418 Rayburn House Office Building | |||||||
41322 | 41322 | Susan Davis D000598 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 53 | http://www.house.gov/susandavis | 1526 Longworth HOB; Washington DC 20515-0553 | 202-225-2040 | 202-225-2948 | http://www.house.gov/susandavis/contact.shtml | 1526 Longworth House Office Building | |||||||
41338 | 41338 | Eliot Engel E000179 | rep | NY | 2011-01-05 | 2013-01-03 | Democrat | 17 | http://www.house.gov/engel | 2161 Rayburn HOB; Washington DC 20515-3217 | 202-225-2464 | 202-225-5513 | http://www.house.gov/writerep | 2161 Rayburn House Office Building | |||||||
41377 | 41377 | Daniel Lipinski L000563 | rep | IL | 2011-01-05 | 2013-01-03 | Democrat | 3 | http://www.lipinski.house.gov | 1717 Longworth HOB; Washington DC 20515-1303 | 202-225-5701 | 202-225-1012 | http://www.house.gov/formlipinski/zipauth.html | 1717 Longworth House Office Building | |||||||
41384 | 41384 | David Loebsack L000565 | rep | IA | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://loebsack.house.gov | 1527 Longworth HOB; Washington DC 20515-1502 | 202-225-6576 | 202-226-0757 | http://loebsack.house.gov/contactform/ | 1527 Longworth 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);