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 phone
This data as json, copyable, CSV (advanced)
Suggested facets: type, state, end, party, contact_form, state_rank
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 | |||||||||||
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 | |||||||||||
40652 | 40652 | John McCain M000303 | sen | AZ | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.mccain.senate.gov | 218 Russell Senate Office Building Washington DC 20510 | 202-224-2235 | 202-228-2862 | http://www.mccain.senate.gov/public/index.cfm/contact-form | 218 Russell Senate Office Building | senior | ||||||
43488 | 43488 | John Thune T000250 | sen | SD | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.thune.senate.gov | 511 Dirksen Senate Office Building Washington DC 20510 | 202-224-2321 | 202-228-5429 | http://www.thune.senate.gov/public/index.cfm/contact | 511 Dirksen Senate Office Building | senior | http://www.thune.senate.gov/public/index.cfm/rss/feed | |||||
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 | |||||
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 | |||||
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 | |||||
40223 | 40223 | Mark Kirk K000360 | sen | IL | 2011-01-05 | 2017-01-03 | 3 | Republican | https://www.kirk.senate.gov | 524 Hart Senate Office Building Washington DC 20510 | 202-224-2854 | 202-228-4611 | http://www.kirk.senate.gov/?p=comment_on_legislation | 524 Hart Senate Office Building | junior | http://kirk.senate.gov/rss/?p=hot_topic | |||||
43196 | 43196 | Marco Rubio R000595 | sen | FL | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.rubio.senate.gov | 284 Russell Senate Office Building Washington DC 20510 | 202-224-3041 | 202-228-0285 | http://www.rubio.senate.gov/public/index.cfm/contact | 284 Russell Senate Office Building | junior | http://www.rubio.senate.gov/public/?a=rss.feed | |||||
42048 | 42048 | Richard Burr B001135 | sen | NC | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.burr.senate.gov | 217 Russell Senate Office Building Washington DC 20510 | 202-224-3154 | 202-228-2981 | http://www.burr.senate.gov/public/index.cfm?FuseAction=Contact.ContactForm | 217 Russell Senate Office Building | senior | http://www.burr.senate.gov/public/index.cfm?fuseaction=rss.feed | |||||
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 | |||||
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 | |||||
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 | ||||||
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 | ||||||
41214 | 41214 | John Isakson I000055 | sen | GA | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.isakson.senate.gov | 131 Russell Senate Office Building Washington DC 20510 | 202-224-3643 | 202-228-0724 | http://www.isakson.senate.gov/public/index.cfm/email-me | 131 Russell Senate Office Building | senior | http://www.isakson.senate.gov/public/?a=RSS.Feed | |||||
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 | |||||||
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/ | |||||
43500 | 43500 | Patrick Toomey T000461 | sen | PA | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.toomey.senate.gov | 248 Russell Senate Office Building Washington DC 20510 | 202-224-4254 | 202-228-0284 | http://www.toomey.senate.gov/?p=contact | 248 Russell Senate Office Building | junior | http://toomey.senate.gov/rss/?p=hot_topic | |||||
43070 | 43070 | Rand Paul P000603 | sen | KY | 2011-01-05 | 2017-01-03 | 3 | Republican | https://www.paul.senate.gov | 167 Russell Senate Office Building Washington DC 20510 | 202-224-4343 | 202-228-1373 | http://www.paul.senate.gov/?p=contact | 167 Russell Senate Office Building | junior | http://paul.senate.gov/rss/?p=news | |||||
40245 | 40245 | David Vitter V000127 | sen | LA | 2011-01-05 | 2017-01-03 | 3 | Republican | https://www.vitter.senate.gov | 516 Hart Senate Office Building Washington DC 20510 | 202-224-4623 | 202-228-5061 | http://www.vitter.senate.gov/contact/email-senator-vitter | 516 Hart Senate Office Building | senior | http://www.vitter.senate.gov/rss/feeds/?type=all | |||||
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 | |||||
41997 | 41997 | John Boozman B001236 | sen | AR | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.boozman.senate.gov | 141 Hart Senate Office Building Washington DC 20510 | 202-224-4843 | 202-228-1371 | http://www.boozman.senate.gov/public/index.cfm/e-mail-me | 141 Hart Senate Office Building | senior | http://www.boozman.senate.gov/public/index.cfm/rss/feed | |||||
43641 | 43641 | Ron Wyden W000779 | sen | OR | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.wyden.senate.gov | 221 Dirksen Senate Office Building Washington DC 20510 | 202-224-5244 | 202-228-2717 | http://www.wyden.senate.gov/contact | 221 Dirksen Senate Office Building | senior | http://www.wyden.senate.gov/rss/feeds/?type=all& | |||||
42602 | 42602 | Ron Johnson J000293 | sen | WI | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.ronjohnson.senate.gov | 328 Hart Senate Office Building Washington DC 20510 | 202-224-5323 | 920-230-7262 | http://www.ronjohnson.senate.gov/public/index.cfm/contact | 328 Hart Senate Office Building | senior | http://www.ronjohnson.senate.gov/public/index.cfm/rss/feed | |||||
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 | ||||||
40216 | 40216 | Daniel Coats C000542 | sen | IN | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.coats.senate.gov | 493 Russell Senate Office Building Washington DC 20510 | 202-224-5623 | 202-228-1820 | http://www.coats.senate.gov/contact/ | 493 Russell Senate Office Building | senior | http://www.coats.senate.gov/rss/feeds/?type=all& | |||||
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 | |||||
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 | |||||
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 | ||||||
41933 | 41933 | Michael Bennet B001267 | sen | CO | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.bennet.senate.gov | 261 Russell Senate Office Building Washington DC 20510 | 202-224-5852 | 202-228-5097 | http://www.bennet.senate.gov/contact/email | 261 Russell Senate Office Building | senior | http://www.bennet.senate.gov/rss/feeds/?type=news | |||||
39588 | 39588 | Jim DeMint D000595 | sen | SC | 2011-01-05 | 2013-01-01 | 3 | Republican | http://demint.senate.gov | 167 RUSSELL SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-6121 | 202-228-5143 | http://www.demint.senate.gov/public/index.cfm?p=ContactInformation | 167 Russell Senate Office Building | |||||||
42236 | 42236 | Michael Crapo C000880 | sen | ID | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.crapo.senate.gov | 239 Dirksen Senate Office Building Washington DC 20510 | 202-224-6142 | 202-228-1375 | http://www.crapo.senate.gov/contact/email.cfm | 239 Dirksen Senate Office Building | senior | ||||||
42956 | 42956 | Jerry Moran M000934 | sen | KS | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.moran.senate.gov | 521 Dirksen Senate Office Building Washington DC 20510 | 202-224-6521 | 202-228-6966 | http://www.moran.senate.gov/public/index.cfm/e-mail-jerry | 521 Dirksen Senate Office Building | junior | http://www.moran.senate.gov/public/index.cfm/rss/feed/ | |||||
43297 | 43297 | Charles Schumer S000148 | sen | NY | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.schumer.senate.gov | 322 Hart Senate Office Building Washington DC 20510 | 202-224-6542 | 202-228-3027 | http://www.schumer.senate.gov/Contact/email-chuck | 322 Hart Senate Office Building | senior | ||||||
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 | |||||
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 | |||||||
41294 | 41294 | Rob Bishop B001250 | rep | UT | 2011-01-05 | 2013-01-03 | Republican | 1 | http://www.house.gov/robbishop | 123 Cannon HOB; Washington DC 20515-4401 | 202-225-0453 | 202-225-5857 | http://robbishop.house.gov/ZipAuth.aspx | 123 Cannon 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 | |||||||
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 | |||||||
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 | ||||||||
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 | |||||||
41019 | 41019 | Dennis Ross R000593 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 12 | http://dennisross.house.gov/ | 404 Cannon HOB; Washington DC 20515-0912 | 202-225-1252 | 202-226-0585 | 404 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 | |||||||
42192 | 42192 | Gerald Connolly C001078 | rep | VA | 2011-01-05 | 2013-01-03 | Democrat | 11 | http://connolly.house.gov | 424 Cannon HOB; Washington DC 20515-4611 | 202-225-1492 | 202-225-3071 | https://forms.house.gov/connolly/contact-form.shtml | 424 Cannon 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 | |||||||
42596 | 42596 | Henry Johnson J000288 | rep | GA | 2011-01-05 | 2013-01-03 | Democrat | 4 | http://hankjohnson.house.gov | 1427 Longworth HOB; Washington DC 20515-1004 | 202-225-1605 | 202-226-0691 | http://hankjohnson.house.gov/contact_hank_write.shtml | 1427 Longworth 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 | |||||||
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 | |||||||
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 | |||||||
43137 | 43137 | David Price P000523 | rep | NC | 2011-01-05 | 2013-01-03 | Democrat | 4 | http://price.house.gov | 2162 Rayburn HOB; Washington DC 20515-3304 | 202-225-1784 | 202-225-2014 | http://price.house.gov/contact/contact_form.shtml | 2162 Rayburn House Office Building | |||||||
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 | |||||||||
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 | |||||||
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 | |||||||
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 | |||||||
39436 | 39436 | Sue Myrick M001134 | rep | NC | 2011-01-05 | 2013-01-03 | Republican | 9 | http://www.house.gov/myrick | 230 Cannon HOB; Washington DC 20515-3309 | 202-225-1976 | 202-225-3389 | http://myrick.house.gov/zipauth.shtml | 230 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 | |||||||
40707 | 40707 | Joe Barton B000213 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 6 | http://joebarton.house.gov | 2109 Rayburn HOB; Washington DC 20515-4306 | 202-225-2002 | 202-225-3052 | http://joebarton.house.gov/ContactJoe.aspx?Type=Email | 2109 Rayburn House Office Building | |||||||
42913 | 42913 | Cathy McMorris Rodgers M001159 | rep | WA | 2011-01-05 | 2013-01-03 | Republican | 5 | http://mcmorris.house.gov | 2421 Rayburn HOB; Washington DC 20515-4705 | 202-225-2006 | 202-225-3392 | https://mcmorrisforms.house.gov/write-to-cathy1 | 2421 Rayburn House Office Building | |||||||
40632 | 40632 | Patrick Meehan M001181 | rep | PA | 2011-01-05 | 2013-01-03 | Republican | 7 | http://meehan.house.gov/ | 513 Cannon HOB; Washington DC 20515-3807 | 202-225-2011 | 202-226-0280 | 513 Cannon House Office Building | ||||||||
41646 | 41646 | Steve Stivers S001187 | rep | OH | 2011-01-05 | 2013-01-03 | Republican | 15 | http://stivers.house.gov/ | 1007 Longworth HOB; Washington DC 20515-3515 | 202-225-2015 | 202-225-3529 | 1007 Longworth House Office Building | ||||||||
40252 | 40252 | Charles Boustany B001255 | rep | LA | 2011-01-05 | 2013-01-03 | Republican | 7 | http://www.house.gov/boustany | 1431 Longworth HOB; Washington DC 20515-1807 | 202-225-2031 | 202-225-5724 | http://boustany.house.gov/ContactCharles.asp | 1431 Longworth 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 | |||||||
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 | |||||||
42387 | 42387 | Virginia Foxx F000450 | rep | NC | 2011-01-05 | 2013-01-03 | Republican | 5 | http://foxx.house.gov | 1230 Longworth HOB; Washington DC 20515-3305 | 202-225-2071 | 202-225-2995 | http://www.house.gov/formfoxx/IMA/issue_subscribe.htm | 1230 Longworth House 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 | |||||||
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 | |||||||
40197 | 40197 | Candice Miller M001150 | rep | MI | 2011-01-05 | 2013-01-03 | Republican | 10 | http://candicemiller.house.gov | 1034 Longworth HOB; Washington DC 20515-2210 | 202-225-2106 | 202-226-1169 | http://candicemiller.house.gov/Contact.aspx | 1034 Longworth House Office Building | |||||||
43262 | 43262 | Janice Schakowsky S001145 | rep | IL | 2011-01-05 | 2013-01-03 | Democrat | 9 | http://www.house.gov/schakowsky | 2367 Rayburn HOB; Washington DC 20515-1309 | 202-225-2111 | 202-226-6890 | http://www.house.gov/schakowsky/contact.shtml | 2367 Rayburn House Office Building | |||||||
42682 | 42682 | James Lankford L000575 | rep | OK | 2011-01-05 | 2013-01-03 | Republican | 5 | http://lankford.house.gov/ | 509 Cannon HOB; Washington DC 20515-3605 | 202-225-2132 | 202-226-1463 | 509 Cannon House Office Building | ||||||||
42351 | 42351 | Michael Doyle D000482 | rep | PA | 2011-01-05 | 2013-01-03 | Democrat | 14 | http://www.house.gov/doyle | 401 Cannon HOB; Washington DC 20515-3814 | 202-225-2135 | 202-225-3084 | http://www.house.gov/doyle/email_mike.shtml | 401 Cannon 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 | |||||||
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 | |||||||
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 | ||||||||
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 | |||||||||
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 | |||||||
39550 | 39550 | John Sullivan S001155 | rep | OK | 2011-01-05 | 2013-01-03 | Republican | 1 | http://www.house.gov/sullivan | 434 Cannon HOB; Washington DC 20515-3601 | 202-225-2211 | 202-225-9187 | http://sullivan.house.gov/zipauth.html | 434 Cannon House Office Building | |||||||
42122 | 42122 | Steve Chabot C000266 | rep | OH | 2011-01-05 | 2013-01-03 | Republican | 1 | http://chabot.house.gov/ | 2351 Rayburn HOB; Washington DC 20515-3501 | 202-225-2216 | 202-225-3012 | 2351 Rayburn House Office Building | ||||||||
44462 | 44462 | Pete Sessions S000250 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 32 | http://www.house.gov/sessions | 2233 Rayburn HOB; Washington DC 20515-4332 | 202-225-2231 | 202-225-5878 | http://www.house.gov/sessionsform/emailform.htm | 2233 Rayburn House Office Building | |||||||
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 | ||||||||
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 | |||||||
40379 | 40379 | John Kline K000363 | rep | MN | 2011-01-05 | 2013-01-03 | Republican | 2 | http://kline.house.gov | 2439 Rayburn HOB; Washington DC 20515-2302 | 202-225-2271 | 202-225-2595 | http://kline.house.gov/index.cfm?FuseAction=ContactInformation.ContactForm&To=mn02hwyr@housemail.house.gov&CFID=22307054&CFTOKEN=28173710 | 2439 Rayburn 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 | |||||||
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 | |||||||
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 | |||||||
44441 | 44441 | Cynthia Lummis L000571 | rep | WY | 2011-01-05 | 2013-01-03 | Republican | 0 | http://lummis.house.gov | 113 Cannon HOB; Washington DC 20515-5001 | 202-225-2311 | 202-225-3057 | https://forms.house.gov/lummis/contact-form.shtml | 113 Cannon House Office Building | |||||||
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 | ||||||||
39736 | 39736 | Michele Bachmann B001256 | rep | MN | 2011-01-05 | 2013-01-03 | Republican | 6 | http://bachmann.house.gov | 103 Cannon HOB; Washington DC 20515-2306 | 202-225-2331 | 202-225-6475 | http://bachmann.house.gov/Email_zip.htm | 103 Cannon House Office Building | |||||||
43547 | 43547 | Nydia Velázquez V000081 | rep | NY | 2011-01-05 | 2013-01-03 | Democrat | 12 | http://www.house.gov/velazquez | 2302 Rayburn HOB; Washington DC 20515-3212 | 202-225-2361 | 202-226-0327 | http://www.house.gov/velazquez/IMA/issue_subscribe.htm | 2302 Rayburn House Office Building | |||||||
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 | |||||||||
39344 | 39344 | Timothy Johnson J000285 | rep | IL | 2011-01-05 | 2013-01-03 | Republican | 15 | http://www.house.gov/timjohnson | 1207 Longworth HOB; Washington DC 20515-1315 | 202-225-2371 | 202-228-5765 | http://www.house.gov/timjohnson/contact/index.shtml | 1207 Longworth House Office Building | |||||||
42858 | 42858 | Michael McCaul M001157 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 10 | http://www.house.gov/mccaul | 131 Cannon HOB; Washington DC 20515-4310 | 202-225-2401 | 202-225-5955 | http://www.house.gov/writerep | 131 Cannon House Office Building | |||||||
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 | |||||||
40435 | 40435 | Joseph Pitts P000373 | rep | PA | 2011-01-05 | 2013-01-03 | Republican | 16 | http://www.house.gov/pitts | 420 Cannon HOB; Washington DC 20515-3816 | 202-225-2411 | 202-225-2013 | http://www.house.gov/pitts/contact.shtml | 420 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 | |||||||
41051 | 41051 | Bill Shuster S001154 | rep | PA | 2011-01-05 | 2013-01-03 | Republican | 9 | http://www.house.gov/shuster | 204 Cannon HOB; Washington DC 20515-3809 | 202-225-2431 | 202-225-2486 | http://www.house.gov/shuster/zipauth.htm | 204 Cannon House Office Building |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [legislator_terms] ( [legislator_id] TEXT REFERENCES [legislators]([id]), [type] TEXT, [state] TEXT, [start] TEXT, [end] TEXT, [class] INTEGER, [party] TEXT , [district] INTEGER, [how] TEXT, [party_affiliations] TEXT, [url] TEXT, [caucus] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);