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 fax
This data as json, copyable, CSV (advanced)
Suggested facets: district, fax, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||
38967 | 38967 | Christopher Lee L000568 | rep | NY | 2011-01-05 | 2011-02-09 | Republican | 26 | http://chrislee.house.gov | ||||||||||||
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 | |||||||||||
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 | ||||||||
40947 | 40947 | Stevan Pearce P000588 | rep | NM | 2011-01-05 | 2013-01-03 | Republican | 2 | http://pearce.house.gov/ | 2432 Rayburn HOB; Washington DC 20515-3102 | 202-225-2365 | 2432 Rayburn House Office Building | |||||||||
40989 | 40989 | Todd Rokita R000592 | rep | IN | 2011-01-05 | 2013-01-03 | Republican | 4 | http://rokita.house.gov/ | 236 Cannon HOB; Washington DC 20515-1404 | 202-225-5037 | 236 Cannon House Office Building | |||||||||
41089 | 41089 | Dean Heller H001041 | rep | NV | 2011-01-05 | 2011-05-09 | Republican | 2 | http://heller.house.gov | 125 Cannon House Office Building; 20515-2802 | |||||||||||
41187 | 41187 | Sean Duffy D000614 | rep | WI | 2011-01-05 | 2013-01-03 | Republican | 7 | http://duffy.house.gov/ | 1208 Longworth HOB; Washington DC 20515-4907 | 202-225-3365 | 1208 Longworth 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 | |||||||||
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 | ||||||
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 | |||||||||
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 | ||||||||
40340 | 40340 | Joseph Heck H001055 | rep | NV | 2011-01-05 | 2013-01-03 | Republican | 3 | http://heck.house.gov/ | 132 Cannon HOB; Washington DC 20515-2803 | 202-225-3252 | 202- 225-2185 | 132 Cannon House Office Building | ||||||||
39305 | 39305 | Nan Hayworth H001054 | rep | NY | 2011-01-05 | 2013-01-03 | Republican | 19 | http://hayworth.house.gov/ | 1440 Longworth HOB; Washington DC 20515-3219 | 202-225-5441 | 202- 225-3289 | 1440 Longworth House Office Building | ||||||||
40147 | 40147 | Alan Nunnelee N000186 | rep | MS | 2011-01-05 | 2013-01-03 | Republican | 1 | http://nunnelee.house.gov/ | 1432 Longworth HOB; Washington DC 20515-2401 | 202-225-4306 | 202- 225-3549 | 1432 Longworth House Office Building | ||||||||
40246 | 40246 | Dan Benishek B001271 | rep | MI | 2011-01-05 | 2013-01-03 | Republican | 1 | http://benishek.house.gov/ | 514 Cannon HOB; Washington DC 20515-2201 | 202-225-4735 | 202- 225-4744 | 514 Cannon House Office Building | ||||||||
40361 | 40361 | Tim Huelskamp H001057 | rep | KS | 2011-01-05 | 2013-01-03 | Republican | 1 | http://huelskamp.house.gov/ | 126 Cannon HOB; Washington DC 20515-1601 | 202-225-2715 | 202- 225-5124 | 126 Cannon House Office Building | ||||||||
39505 | 39505 | Robert Schilling S001182 | rep | IL | 2011-01-05 | 2013-01-03 | Republican | 17 | http://schilling.house.gov/ | 507 Cannon HOB; Washington DC 20515-1317 | 202-225-5905 | 202- 225-5396 | 507 Cannon House Office Building | ||||||||
40293 | 40293 | Renee Ellmers E000291 | rep | NC | 2011-01-05 | 2013-01-03 | Republican | 2 | http://ellmers.house.gov/ | 1533 Longworth HOB; Washington DC 20515-3302 | 202-225-4531 | 202- 225-5662 | 1533 Longworth House Office Building | ||||||||
40461 | 40461 | Reid Ribble R000587 | rep | WI | 2011-01-05 | 2013-01-03 | Republican | 8 | http://ribble.house.gov/ | 1513 Longworth HOB; Washington DC 20515-4908 | 202-225-5665 | 202- 225-5729 | 1513 Longworth House Office Building | ||||||||
39232 | 39232 | Chip Cravaack C001086 | rep | MN | 2011-01-05 | 2013-01-03 | Republican | 8 | http://cravaack.house.gov/ | 508 Cannon HOB; Washington DC 20515-2308 | 202-225-6211 | 202- 225-6211 | 508 Cannon House Office Building | ||||||||
40312 | 40312 | Michael Fitzpatrick F000451 | rep | PA | 2011-01-05 | 2013-01-03 | Republican | 8 | http://fitzpatrick.house.gov/ | 1224 Longworth HOB; Washington DC 20515-3808 | 202-225-4276 | 202- 225-9511 | 1224 Longworth House Office Building | ||||||||
39382 | 39382 | Jeff Landry L000574 | rep | LA | 2011-01-05 | 2013-01-03 | Republican | 3 | http://landry.house.gov/ | 206 Cannon HOB; Washington DC 20515-1803 | 202-225-4031 | 202- 226-3944 | 206 Cannon House Office Building | ||||||||
40423 | 40423 | Richard Nugent N000185 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 5 | http://nugent.house.gov/ | 1517 Longworth HOB; Washington DC 20515-0905 | 202-225-1002 | 202- 226-6559 | 1517 Longworth 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 | |||||
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 | ||||||
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 | |||||
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/ | |||||
40200 | 40200 | Kelly Ayotte A000368 | sen | NH | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.ayotte.senate.gov | 144 Russell Senate Office Building Washington DC 20510 | 202-224-3324 | 202-224-4952 | http://www.ayotte.senate.gov/?p=contact | 144 Russell Senate Office Building | junior | http://ayotte.senate.gov/rss/?p=news | |||||
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 | |||||
39798 | 39798 | Thomas Coburn C000560 | sen | OK | 2011-01-05 | 2015-01-03 | 3 | Republican | http://www.coburn.senate.gov | 172 Russell Senate Office Building Washington DC 20510 | 202-224-5754 | 202-224-6008 | http://www.coburn.senate.gov/public/?p=ContactForm#form_904650a1-34fd-4705-aec9-87815cbf9cb4 | 172 Russell Senate Office Building | junior | ||||||
42442 | 42442 | Charles Grassley G000386 | sen | IA | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.grassley.senate.gov | 135 Hart Senate Office Building Washington DC 20510 | 202-224-3744 | 202-224-6020 | http://www.grassley.senate.gov/constituents/questions-and-comments | 135 Hart Senate Office Building | senior | http://grassley.senate.gov/customcf/rss_feed.cfm | |||||
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 | |||||||
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 | ||||||
42530 | 42530 | John Hoeven H001061 | sen | ND | 2011-01-05 | 2017-01-03 | 3 | Republican | https://www.hoeven.senate.gov | 338 Russell Senate Office Building Washington DC 20510 | 202-224-2551 | 202-224-7999 | http://www.hoeven.senate.gov/public/index.cfm/email-the-senator | 338 Russell Senate Office Building | senior | http://www.hoeven.senate.gov/public/index.cfm/rss/feed | |||||
41990 | 41990 | Roy Blunt B000575 | sen | MO | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.blunt.senate.gov | 260 Russell Senate Office Building Washington DC 20510 | 202-224-5721 | 202-224-8149 | http://www.blunt.senate.gov/public/index.cfm/contact-form?p=contact-roy | 260 Russell Senate Office Building | junior | http://www.blunt.senate.gov/public/?a=rss.feed | |||||
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 | |||||
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 | |||||
41981 | 41981 | Richard Blumenthal B001277 | sen | CT | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.blumenthal.senate.gov | 706 Hart Senate Office Building Washington DC 20510 | 202-224-2823 | 202-224-9673 | https://www.blumenthal.senate.gov/contact/ | 706 Hart Senate Office Building | senior | http://www.blumenthal.senate.gov/rss/feeds/?type=all | |||||
38945 | 38945 | Geoff Davis D000603 | rep | KY | 2011-01-05 | 2012-07-31 | Republican | 4 | http://geoffdavis.house.gov | 1119 Longworth House Office Building; 20515-1704 | 202-225-3465 | 202-225-0003 | http://geoffdavis.house.gov/Contact.aspx | 1119 Longworth House Office Building | |||||||
39684 | 39684 | Eric Cantor C001046 | rep | VA | 2011-01-05 | 2013-01-03 | Republican | 7 | http://cantor.house.gov | 303 Cannon HOB; Washington DC 20515-4607 | 202-225-2815 | 202-225-0011 | https://writerep.house.gov/writerep/welcome.shtml | 303 Cannon House Office Building | |||||||
39207 | 39207 | Dan Burton B001149 | rep | IN | 2011-01-05 | 2013-01-03 | Republican | 5 | http://burton.house.gov | 2308 Rayburn HOB; Washington DC 20515-1405 | 202-225-2276 | 202-225-0016 | http://burton.house.gov/contacts/new | 2308 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 | |||||||
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 | |||||||
42278 | 42278 | Peter DeFazio D000191 | rep | OR | 2011-01-05 | 2013-01-03 | Democrat | 4 | http://defazio.house.gov | 2134 Rayburn HOB; Washington DC 20515-3704 | 202-225-6416 | 202-225-0032 | http://www.house.gov/formdefazio/contact.html | 2134 Rayburn 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 | |||||||
41408 | 41408 | Kenny Marchant M001158 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 24 | http://www.house.gov/marchant | 1110 Longworth HOB; Washington DC 20515-4324 | 202-225-6605 | 202-225-0074 | http://marchant.house.gov/emailkenny.shtml | 1110 Longworth House Office Building | |||||||
42464 | 42464 | H. Griffith G000568 | rep | VA | 2011-01-05 | 2013-01-03 | Republican | 9 | http://morgangriffith.house.gov/ | 1108 Longworth HOB; Washington DC 20515-4609 | 202-225-3861 | 202-225-0076 | 1108 Longworth 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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
42487 | 42487 | Andy Harris H001052 | rep | MD | 2011-01-05 | 2013-01-03 | Republican | 1 | http://harris.house.gov/ | 506 Cannon HOB; Washington DC 20515-2001 | 202-225-5311 | 202-225-0254 | 506 Cannon 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 | |||||||
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 | |||||||
41343 | 41343 | Bill Flores F000461 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 17 | http://flores.house.gov/ | 1505 Longworth HOB; Washington DC 20515-4317 | 202-225-6105 | 202-225-0350 | 1505 Longworth 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 | |||||||
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 | |||||||
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 | |||||||
40114 | 40114 | Frank Wolf W000672 | rep | VA | 2011-01-05 | 2013-01-03 | Republican | 10 | http://www.house.gov/wolf | 241 Cannon HOB; Washington DC 20515-4610 | 202-225-5136 | 202-225-0437 | http://www.house.gov/formwolf/contact_email/emailzip.shtml | 241 Cannon House Office Building | |||||||
40536 | 40536 | Mick Mulvaney M001182 | rep | SC | 2011-01-05 | 2013-01-03 | Republican | 5 | http://mulvaney.house.gov/ | 1004 Longworth HOB; Washington DC 20515-4005 | 202-225-5501 | 202-225-0464 | 1004 Longworth House Office Building | ||||||||
41400 | 41400 | Nita Lowey L000480 | rep | NY | 2011-01-05 | 2013-01-03 | Democrat | 18 | http://www.house.gov/lowey | 2365 Rayburn HOB; Washington DC 20515-3218 | 202-225-6506 | 202-225-0546 | http://lowey.house.gov/?sectionid=56&sectiontree=56 | 2365 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 | |||||||
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 | |||||||
40873 | 40873 | Randy Hultgren H001059 | rep | IL | 2011-01-05 | 2013-01-03 | Republican | 14 | http://hultgren.house.gov/ | 427 Cannon HOB; Washington DC 20515-1314 | 202-225-2976 | 202-225-0697 | 427 Cannon House Office Building | ||||||||
40164 | 40164 | John Boehner B000589 | rep | OH | 2011-01-05 | 2013-01-03 | Republican | 8 | http://johnboehner.house.gov | 1011 Longworth HOB; Washington DC 20515-3508 | 202-225-6205 | 202-225-0704 | http://www.johnboehner.house.gov/Contact/ | 1011 Longworth House Office Building | |||||||
40690 | 40690 | Lou Barletta B001269 | rep | PA | 2011-01-05 | 2013-01-03 | Republican | 11 | http://barletta.house.gov/ | 510 Cannon HOB; Washington DC 20515-3811 | 202-225-6511 | 202-225-0764 | 510 Cannon House Office Building | ||||||||
40053 | 40053 | Jon Runyan R000594 | rep | NJ | 2011-01-05 | 2013-01-03 | Republican | 3 | http://runyan.house.gov/ | 1239 Longworth HOB; Washington DC 20515-3003 | 202-225-4765 | 202-225-0778 | 1239 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 | |||||||
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 | |||||||
40501 | 40501 | Bob Dold D000613 | rep | IL | 2011-01-05 | 2013-01-03 | Republican | 10 | http://dold.house.gov/ | 212 Cannon HOB; Washington DC 20515-1310 | 202-225-4835 | 202-225-0837 | 212 Cannon House Office Building | ||||||||
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 | |||||||
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 | |||||||
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 | ||||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
41015 | 41015 | Peter Roskam R000580 | rep | IL | 2011-01-05 | 2013-01-03 | Republican | 6 | http://roskam.house.gov | 227 Cannon HOB; Washington DC 20515-1306 | 202-225-4561 | 202-225-1166 | http://www.house.gov/writerep | 227 Cannon House Office Building | |||||||
40334 | 40334 | Christopher Gibson G000564 | rep | NY | 2011-01-05 | 2013-01-03 | Republican | 20 | http://gibson.house.gov/ | 502 Cannon HOB; Washington DC 20515-3220 | 202-225-5614 | 202-225-1168 | 502 Cannon House Office Building | ||||||||
41640 | 41640 | Alcee Hastings H000324 | rep | FL | 2011-01-05 | 2013-01-03 | Democrat | 23 | http://alceehastings.house.gov | 2353 Rayburn HOB; Washington DC 20515-0923 | 202-225-1313 | 202-225-1171 | http://www.alceehastings.house.gov/index.php?option=com_content&task=view&id=104&Itemid= | 2353 Rayburn 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 | |||||||
41623 | 41623 | Marcia Fudge F000455 | rep | OH | 2011-01-05 | 2013-01-03 | Democrat | 11 | http://fudge.house.gov/ | 1019 Longworth HOB; Washington DC 20515-3511 | 202-225-7032 | 202-225-1339 | https://forms.house.gov/fudge/contact-form.shtml | 1019 Longworth House Office Building | |||||||
40892 | 40892 | Sam Johnson J000174 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 3 | http://www.house.gov/samjohnson | 1211 Longworth HOB; Washington DC 20515-4303 | 202-225-4201 | 202-225-1485 | http://www.house.gov/formsamjohnson/IMA/issue.htm | 1211 Longworth 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 | |||||||
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 | |||||||
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 | |||||||
41429 | 41429 | Collin Peterson P000258 | rep | MN | 2011-01-05 | 2013-01-03 | Democrat | 7 | http://collinpeterson.house.gov | 2211 Rayburn HOB; Washington DC 20515-2307 | 202-225-2165 | 202-225-1593 | http://collinpeterson.house.gov//email.html | 2211 Rayburn House Office Building | |||||||
42247 | 42247 | Henry Cuellar C001063 | rep | TX | 2011-01-05 | 2013-01-03 | Democrat | 28 | http://www.house.gov/cuellar | 2463 Rayburn HOB; Washington DC 20515-4328 | 202-225-1640 | 202-225-1641 | http://cuellar.house.gov/Contact/SendMeAnEmail.htm | 2463 Rayburn 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 | |||||||
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 | |||||||
40308 | 40308 | Stephen Fincher F000458 | rep | TN | 2011-01-05 | 2013-01-03 | Republican | 8 | http://fincher.house.gov/ | 1118 Longworth HOB; Washington DC 20515-4208 | 202-225-4714 | 202-225-1765 | 1118 Longworth House Office Building | ||||||||
41312 | 41312 | K. Conaway C001062 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 11 | http://www.house.gov/conaway | 2430 Rayburn HOB; Washington DC 20515-4311 | 202-225-3605 | 202-225-1783 | http://conaway.house.gov/Contact/default.aspx#email | 2430 Rayburn House Office Building | |||||||
40551 | 40551 | Tim Murphy M001151 | rep | PA | 2011-01-05 | 2013-01-03 | Republican | 18 | http://murphy.house.gov | 322 Cannon HOB; Washington DC 20515-3818 | 202-225-2301 | 202-225-1844 | http://murphy.house.gov/Contact/zipauth.htm | 322 Cannon House Office Building | |||||||
40337 | 40337 | Richard Hanna H001051 | rep | NY | 2011-01-05 | 2013-01-03 | Republican | 24 | http://hanna.house.gov/ | 319 Cannon HOB; Washington DC 20515-3224 | 202-225-3665 | 202-225-1891 | 319 Cannon 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 |
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);