legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
470 rows where "end" is on date 2013-01-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, fax, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39040 | 39040 | Daniel Akaka A000069 | sen | HI | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://akaka.senate.gov | 141 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-6361 | 202-224-2126 | http://www.akaka.senate.gov/email-senator-akaka.cfm | 141 Hart Senate Office Building | |||||||
39045 | 39045 | Jeff Bingaman B000468 | sen | NM | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://bingaman.senate.gov | 703 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-5521 | 202-224-2852 | http://www.bingaman.senate.gov/contact/ | 703 Hart Senate Office Building | |||||||
39050 | 39050 | Kent Conrad C000705 | sen | ND | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://conrad.senate.gov | 530 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-2043 | 202-224-7776 | http://www.conrad.senate.gov/contact/webform.cfm | 530 Hart Senate Office Building | |||||||
39058 | 39058 | Herbert Kohl K000305 | sen | WI | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://kohl.senate.gov/ | 330 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-5653 | 202-224-9787 | http://www.kohl.senate.gov/contact.cfm | 330 Hart Senate Office Building | |||||||
39070 | 39070 | Ben Nelson N000180 | sen | NE | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://bennelson.senate.gov/ | 720 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-6551 | 202-228-0012 | http://www.bennelson.senate.gov/contact-me.cfm | 720 Hart Senate Office Building | |||||||
39082 | 39082 | Jim Webb W000803 | sen | VA | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://webb.senate.gov/ | 248 RUSSELL SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-4024 | 202-228-6363 | http://www.webb.senate.gov/contact.cfm | 248 Russell 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 | |||||||
39581 | 39581 | Kathleen Hochul H001062 | rep | NY | 2011-06-01 | 2013-01-03 | Democrat | 26 | http://hochul.house.gov/ | 1711 Longworth HOB; Washington DC 20515-3226 | 202-225-5265 | 1711 Longworth House Office Building | |||||||||
39583 | 39583 | David Curson C001089 | rep | MI | 2012-11-13 | 2013-01-03 | Democrat | 11 | http://curson.house.gov | 2243 Rayburn HOB; Washington DC 20515-2211 | 202-225-8171 | 2243 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 | |||||||
40116 | 40116 | Ron Barber B001279 | rep | AZ | 2012-06-12 | 2013-01-03 | Democrat | 8 | http://barber.house.gov/ | 1030 Longworth HOB; Washington DC 20515-0308 | 202-225-2542 | 202-225-0378 | https://barber.house.gov/contact-me/email-me | 1030 Longworth 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 | |||||||
40190 | 40190 | Janice Hahn H001063 | rep | CA | 2011-07-19 | 2013-01-03 | Democrat | 36 | http://hahn.house.gov/ | 2400 Rayburn HOB; Washington DC 20515-0536 | 202-225-8220 | 202-226-7290 | https://hahn.house.gov/contact-me/email-me | 2400 Rayburn House Office Building | |||||||
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 | |||||||
40426 | 40426 | Pedro Pierluisi P000596 | rep | PR | 2009-01-06 | 2013-01-03 | Democrat | 0 | http://pierluisi.house.gov | 1213 Longworth HOB; Washington DC 20515-5401 | 202-225-2615 | 202-225-2154 | https://forms.house.gov/pierluisi/contact-form.shtml | 1213 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 | |||||||
40679 | 40679 | Claire McCaskill M001170 | sen | MO | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://mccaskill.senate.gov/ | 506 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-6154 | 202-228-6326 | http://www.mccaskill.senate.gov/?p=contact | 506 Hart Senate Office Building | |||||||
40688 | 40688 | Bill Nelson N000032 | sen | FL | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://billnelson.senate.gov/ | 716 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-5274 | 202-228-2183 | http://www.billnelson.senate.gov/contact/index.cfm | 716 Hart Senate 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);