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 state
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, district, contact_form, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41683 | 41683 | Don Young Y000033 | rep | AK | 2011-01-05 | 2013-01-03 | Republican | 0 | http://donyoung.house.gov | 2314 Rayburn HOB; Washington DC 20515-0201 | 202-225-5765 | 202-225-0425 | http://donyoung.house.gov/Contact/ | 2314 Rayburn House Office Building | |||||||
39614 | 39614 | Jo Bonner B001244 | rep | AL | 2011-01-05 | 2013-01-03 | Republican | 1 | http://bonner.house.gov | 2236 Rayburn HOB; Washington DC 20515-0101 | 202-225-4931 | 202-225-0562 | https://forms.house.gov/bonner/webforms/issue_subscribe.html | 2236 Rayburn House Office Building | |||||||
39747 | 39747 | Spencer Bachus B000013 | rep | AL | 2011-01-05 | 2013-01-03 | Republican | 6 | http://bachus.house.gov | 2246 Rayburn HOB; Washington DC 20515-0106 | 202-225-4921 | 202-225-2082 | |||||||||
41434 | 41434 | Martha Roby R000591 | rep | AL | 2011-01-05 | 2013-01-03 | Republican | 2 | http://roby.house.gov/ | 414 Cannon HOB; Washington DC 20515-0102 | 202-225-2901 | 202-225-8913 | 414 Cannon House Office Building | ||||||||
41911 | 41911 | Robert Aderholt A000055 | rep | AL | 2011-01-05 | 2013-01-03 | Republican | 4 | http://aderholt.house.gov | 2264 Rayburn HOB; Washington DC 20515-0104 | 202-225-4876 | 202-225-5587 | http://aderholt.house.gov/?sectionid=195&sectiontree=195 | 2264 Rayburn House Office Building | |||||||
42012 | 42012 | Mo Brooks B001274 | rep | AL | 2011-01-05 | 2013-01-03 | Republican | 5 | http://brooks.house.gov/ | 1641 Longworth HOB; Washington DC 20515-0105 | 202-225-4801 | 202-225-4392 | 1641 Longworth 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 | |||||||
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 | ||||||||
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 | |||||||
39854 | 39854 | Tim Griffin G000567 | rep | AR | 2011-01-05 | 2013-01-03 | Republican | 2 | http://griffin.house.gov/ | 1232 Longworth HOB; Washington DC 20515-0402 | 202-225-2506 | 202-225-5903 | 1232 Longworth House Office Building | ||||||||
42238 | 42238 | Eric Crawford C001087 | rep | AR | 2011-01-05 | 2013-01-03 | Republican | 1 | http://crawford.house.gov/ | 1408 Longworth HOB; Washington DC 20515-0401 | 202-225-4076 | 202-225-5602 | 1408 Longworth House Office Building | ||||||||
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 | ||||||||
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 | |||||||
39472 | 39472 | Ben Quayle Q000024 | rep | AZ | 2011-01-05 | 2013-01-03 | Republican | 3 | http://quayle.house.gov/ | 1419 Longworth HOB; Washington DC 20515-0303 | 202-225-3361 | 202-225-3462 | 1419 Longworth 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 | |||||||
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 | |||||||
40586 | 40586 | Trent Franks F000448 | rep | AZ | 2011-01-05 | 2013-01-03 | Republican | 2 | http://www.house.gov/franks | 2435 Rayburn HOB; Washington DC 20515-0302 | 202-225-4576 | 202-225-6328 | https://forms.house.gov/franks/email_zipcheck.shtml | 2435 Rayburn House Office Building | |||||||
40665 | 40665 | Jon Kyl K000352 | sen | AZ | 2007-01-04 | 2013-01-03 | 1 | Republican | http://kyl.senate.gov/ | 730 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-4521 | 202-224-2207 | http://www.kyl.senate.gov/contact.cfm | 730 Hart Senate Office Building | |||||||
40803 | 40803 | Jeff Flake F000444 | rep | AZ | 2011-01-05 | 2013-01-03 | Republican | 6 | http://flake.house.gov | 240 Cannon HOB; Washington DC 20515-0306 | 202-225-2635 | 202-226-4386 | http://www.house.gov/writerep | 240 Cannon House Office Building | |||||||
42415 | 42415 | Paul Gosar G000565 | rep | AZ | 2011-01-05 | 2013-01-03 | Republican | 1 | http://gosar.house.gov/ | 504 Cannon HOB; Washington DC 20515-0301 | 202-225-2315 | 200-226-9739 | 504 Cannon House Office Building | ||||||||
42474 | 42474 | Raúl Grijalva G000551 | rep | AZ | 2011-01-05 | 2013-01-03 | Democrat | 7 | http://www.house.gov/grijalva | 1511 Longworth HOB; Washington DC 20515-0307 | 202-225-2435 | 202-225-1541 | http://grijalva.house.gov/?sectionid=49&sectiontree=2,49 | 1511 Longworth 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 | |||||||||
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 | |||||||
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 | |||||||
39171 | 39171 | Brian Bilbray B000461 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 50 | http://www.house.gov/bilbray | 2410 Rayburn HOB; Washington DC 20515-0550 | 202-225-0508 | 202-225-2558 | http://www.house.gov/bilbray/contact.shtml | 2410 Rayburn House Office Building | |||||||
39179 | 39179 | Mary Bono Mack B001228 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 45 | http://bono.house.gov | 104 Cannon HOB; Washington DC 20515-0545 | 202-225-5330 | 202-225-2961 | http://www.house.gov/formbono/issue.htm | 104 Cannon House Office Building | |||||||
39268 | 39268 | David Dreier D000492 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 26 | http://dreier.house.gov | 233 Cannon HOB; Washington DC 20515-0526 | 202-225-2305 | 202-225-7018 | http://doyle.house.gov/email_mike.shtml | 233 Cannon House Office Building | |||||||
39297 | 39297 | Elton Gallegly G000021 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 24 | http://www.house.gov/gallegly | 2309 Rayburn HOB; Washington DC 20515-0524 | 202-225-5811 | 202-225-1100 | http://www.house.gov/writerep | 2309 Rayburn House Office Building | |||||||
39318 | 39318 | Walter Herger H000528 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 2 | http://www.house.gov/herger | 242 Cannon HOB; Washington DC 20515-0502 | 202-225-3076 | 202-225-1740 | http://www.house.gov/herger/contact.shtml | 242 Cannon House Office Building | |||||||
39399 | 39399 | Jerry Lewis L000274 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 41 | http://www.house.gov/jerrylewis | 2112 Rayburn HOB; Washington DC 20515-0541 | 202-225-5861 | 202-225-6498 | http://www.house.gov/jerrylewis/IMA/WritetoRepresentativeLewis.htm | 2112 Rayburn House Office Building | |||||||
39408 | 39408 | Daniel Lungren L000517 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 3 | http://www.lungren.house.gov | 2313 Rayburn HOB; Washington DC 20515-0503 | 202-225-5716 | 202-226-1298 | https://forms.house.gov/lungren/forms/email.shtml | 2313 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 | |||||||
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 | |||||||
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 | |||||||
39783 | 39783 | John Campbell C001064 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 48 | http://www.house.gov/campbell | 1507 Longworth HOB; Washington DC 20515-0548 | 202-225-5611 | 202-225-9177 | http://campbell.house.gov/Contact/ContactForm.htm | 1507 Longworth House Office Building | |||||||
39946 | 39946 | Howard McKeon M000508 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 25 | http://mckeon.house.gov | 2184 Rayburn HOB; Washington DC 20515-0525 | 202-225-1956 | 202-226-0683 | http://mckeon.house.gov/contact.shtml | 2184 Rayburn House Office Building | |||||||
39960 | 39960 | Gary Miller M001139 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 42 | http://www.house.gov/garymiller | 2349 Rayburn HOB; Washington DC 20515-0542 | 202-225-3201 | 202-226-6962 | http://garymiller.house.gov/Contact/ | 2349 Rayburn 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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
40768 | 40768 | Jeff Denham D000612 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 19 | http://denham.house.gov/ | 1605 Longworth HOB; Washington DC 20515-0519 | 202-225-4540 | 202-225-3402 | 1605 Longworth House Office Building | ||||||||
40985 | 40985 | Dana Rohrabacher R000409 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 46 | http://www.house.gov/rohrabacher | 2300 Rayburn HOB; Washington DC 20515-0546 | 202-225-2415 | 202-225-0145 | http://rohrabacher.house.gov/Contact/Zip.htm | 2300 Rayburn House Office Building | |||||||
41032 | 41032 | Edward Royce R000487 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 40 | http://www.royce.house.gov | 2185 Rayburn HOB; Washington DC 20515-0540 | 202-225-4111 | 202-226-0335 | http://www.house.gov/writerep | 2185 Rayburn House Office Building | |||||||
41217 | 41217 | Duncan Hunter H001048 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 52 | http://hunter.house.gov | 223 Cannon HOB; Washington DC 20515-0552 | 202-225-5672 | 202-225-0235 | https://forms.house.gov/hunter/zipauthen_contact.shtml | 223 Cannon 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 | |||||||
41656 | 41656 | Devin Nunes N000181 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 21 | http://nunes.house.gov | 1013 Longworth HOB; Washington DC 20515-0521 | 202-225-2523 | 202-225-3404 | http://www.nunes.house.gov/index.cfm?FuseAction=ContactUs.ContactForm | 1013 Longworth House Office Building | |||||||
41773 | 41773 | Dianne Feinstein F000062 | sen | CA | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://feinstein.senate.gov | 331 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-3841 | 202-228-3954 | http://www.feinstein.senate.gov/public/index.cfm/e-mail-me | 331 Hart Senate Office Building | |||||||
41926 | 41926 | Karen Bass B001270 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 33 | http://karenbass.house.gov/ | 408 Cannon HOB; Washington DC 20515-0533 | 202-225-7084 | 202-225-2422 | 408 Cannon House Office Building | ||||||||
42069 | 42069 | Ken Calvert C000059 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 44 | http://calvert.house.gov | 2269 Rayburn HOB; Washington DC 20515-0544 | 202-225-1986 | 202-225-2004 | http://calvert.house.gov/awenhnjafe.asp | 2269 Rayburn House Office Building | |||||||
42129 | 42129 | Judy Chu C001080 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 32 | http://chu.house.gov/ | 1520 Longworth HOB; Washington DC 20515-0532 | 202-225-5464 | 202-225-5467 | https://forms.house.gov/chu/contact-form.shtml | 1520 Longworth House Office Building | |||||||
42217 | 42217 | Jim Costa C001059 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 20 | http://www.house.gov/costa | 1314 Longworth HOB; Washington DC 20515-0520 | 202-225-3341 | 202-225-9308 | http://www.house.gov/formcosta/issue.htm | 1314 Longworth House Office Building | |||||||
42372 | 42372 | Anna Eshoo E000215 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 14 | http://eshoo.house.gov | 205 Cannon HOB; Washington DC 20515-0514 | 202-225-8104 | 202-225-8890 | https://forms.house.gov/eshoo/webforms/issue_subscribe.htm | 205 Cannon House Office Building | |||||||
42394 | 42394 | John Garamendi G000559 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 10 | http://garamendi.house.gov/ | 228 Cannon HOB; Washington DC 20515-0510 | 202-225-1880 | 202-225-5914 | http://garamendi.house.gov/contact/email-me.shtml | 228 Cannon House Office Building | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
40745 | 40745 | Mike Coffman C001077 | rep | CO | 2011-01-05 | 2013-01-03 | Republican | 6 | http://coffman.house.gov | 1222 Longworth HOB; Washington DC 20515-0606 | 202-225-7882 | 202-226-4623 | https://forms.house.gov/coffman/contact-form.shtml | 1222 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 | |||||||
41348 | 41348 | Cory Gardner G000562 | rep | CO | 2011-01-05 | 2013-01-03 | Republican | 4 | http://gardner.house.gov/ | 213 Cannon HOB; Washington DC 20515-0604 | 202-225-4676 | 213 Cannon House Office Building | |||||||||
41507 | 41507 | Scott Tipton T000470 | rep | CO | 2011-01-05 | 2013-01-03 | Republican | 3 | http://tipton.house.gov/ | 218 Cannon HOB; Washington DC 20515-0603 | 202-225-4761 | 202-226-9669 | 218 Cannon House Office Building | ||||||||
42291 | 42291 | Diana DeGette D000197 | rep | CO | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://www.house.gov/degette | 2335 Rayburn HOB; Washington DC 20515-0601 | 202-225-4431 | 202-225-5657 | http://www.house.gov/formdegette/zip_auth.htm | 2335 Rayburn House Office Building | |||||||
42665 | 42665 | Doug Lamborn L000564 | rep | CO | 2011-01-05 | 2013-01-03 | Republican | 5 | http://lamborn.house.gov | 437 Cannon HOB; Washington DC 20515-0605 | 202-225-4422 | 202-226-2638 | http://lamborn.house.gov/ZipAuth.aspx | 437 Cannon 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 | |||||||
39062 | 39062 | Joseph Lieberman L000304 | sen | CT | 2007-01-04 | 2013-01-03 | 1 | Independent | http://lieberman.senate.gov/ | 706 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-4041 | 202-224-9750 | http://www.lieberman.senate.gov/index.cfm/contact/email-me-about-an-issue | 706 Hart Senate Office Building | |||||||
42225 | 42225 | Joe Courtney C001069 | rep | CT | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://courtney.house.gov | 215 Cannon HOB; Washington DC 20515-0702 | 202-225-2076 | 202-225-4977 | http://courtney.house.gov/email/ | 215 Cannon House Office Building | |||||||
42307 | 42307 | Rosa DeLauro D000216 | rep | CT | 2011-01-05 | 2013-01-03 | Democrat | 3 | http://www.house.gov/delauro | 2413 Rayburn HOB; Washington DC 20515-0703 | 202-225-3661 | 202-225-4890 | http://delauro.house.gov/contact_form_email.cfm | 2413 Rayburn House Office Building | |||||||
42519 | 42519 | James Himes H001047 | rep | CT | 2011-01-05 | 2013-01-03 | Democrat | 4 | http://himes.house.gov | 119 Cannon HOB; Washington DC 20515-0704 | 202-225-5541 | 202-225-9629 | https://forms.house.gov/himes/contact-form.shtml | 119 Cannon 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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
41764 | 41764 | Thomas Carper C000174 | sen | DE | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://carper.senate.gov | 513 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-2441 | 202-228-2190 | http://www.carper.senate.gov/contact/ | 513 Hart Senate Office Building | |||||||
39099 | 39099 | Sandy Adams A000366 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 24 | http://adams.house.gov/ | 216 Cannon HOB; Washington DC 20515-0924 | 202-225-2706 | 202-226-6299 | 216 Cannon House Office Building | ||||||||
39412 | 39412 | Connie Mack M001155 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 14 | http://www.house.gov/mack | 115 Cannon HOB; Washington DC 20515-0914 | 202-225-2536 | 202-226-0439 | http://mack.house.gov/index.cfm?FuseAction=ContactConnie.ContactForm | 115 Cannon House Office Building | |||||||
39490 | 39490 | David Rivera R000590 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 25 | http://rivera.house.gov/ | 417 Cannon HOB; Washington DC 20515-0925 | 202-225-2778 | 202-226-0346 | 417 Cannon House Office Building | ||||||||
39544 | 39544 | Clifford Stearns S000822 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 6 | http://www.house.gov/stearns | 2306 Rayburn HOB; Washington DC 20515-0906 | 202-225-5744 | 202-225-3973 | http://www.house.gov/writerep | 2306 Rayburn House Office Building | |||||||
39570 | 39570 | Allen West W000807 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 22 | http://west.house.gov/ | 1708 Longworth HOB; Washington DC 20515-0922 | 202-225-3026 | 202-225-8398 | 1708 Longworth House Office Building | ||||||||
39642 | 39642 | C. Young Y000031 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 10 | http://www.house.gov/young | 2407 Rayburn HOB; Washington DC 20515-0910 | 202-225-5961 | 202-225-9764 | http://www.house.gov/writerep | 2407 Rayburn House Office Building | |||||||
40060 | 40060 | Steve Southerland S001186 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 2 | http://southerland.house.gov/ | 1229 Longworth HOB; Washington DC 20515-0902 | 202-225-5235 | 202-225-5615 | 1229 Longworth 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 | |||||||
40285 | 40285 | Ander Crenshaw C001045 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 4 | http://crenshaw.house.gov | 440 Cannon HOB; Washington DC 20515-0904 | 202-225-2501 | 202-225-2504 | https://forms.house.gov/wyr/welcome.shtml | 440 Cannon House Office Building | |||||||
40405 | 40405 | John Mica M000689 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 7 | http://www.house.gov/mica | 2187 Rayburn HOB; Washington DC 20515-0907 | 202-225-4035 | 202-226-0821 | http://www.house.gov/mica/messageform.shtml | 2187 Rayburn 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);