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 district
This data as json, copyable, CSV (advanced)
Suggested facets: district, fax, office, end (date)
Link | rowid | legislator_id | type | state | start | end | class | party | district ▼ | how | party_affiliations | url | caucus | address | phone | fax | contact_form | office | state_rank | rss_url | end-type |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||
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 | |||||||
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 | ||||||
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 | |||||
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 | ||||||
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& | |||||
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 | |||||
40233 | 40233 | Barbara Mikulski M000702 | sen | MD | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.mikulski.senate.gov | 503 Hart Senate Office Building Washington DC 20510 | 202-224-4654 | 202-224-8858 | http://www.mikulski.senate.gov/contact/shareyouropinion.cfm | 503 Hart Senate Office Building | senior | http://www.mikulski.senate.gov/rssfeed.cfm | |||||
40240 | 40240 | Harry Reid R000146 | sen | NV | 2011-01-05 | 2017-01-03 | 3 | Democrat | http://www.reid.senate.gov | 522 Hart Senate Office Building Washington DC 20510 | 202-224-3542 | 202-224-7327 | http://www.reid.senate.gov/contact | 522 Hart Senate Office Building | senior | ||||||
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 | |||||
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 | ||||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | ||||||
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 | |||||
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 | |||||
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 | |||||
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/ | |||||
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 | ||||||
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/ | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | ||||||
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 | |||||
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 | |||||
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 | |||||
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& | |||||
39135 | 39135 | Rick Berg B001272 | rep | ND | 2011-01-05 | 2013-01-03 | Republican | 0 | http://berg.house.gov/ | 323 Cannon HOB; Washington DC 20515-3401 | 202-225-2611 | 202-226-0893 | 323 Cannon House Office Building | ||||||||
39478 | 39478 | Dennis Rehberg R000571 | rep | MT | 2011-01-05 | 2013-01-03 | Republican | 0 | http://www.house.gov/rehberg | 2448 Rayburn HOB; Washington DC 20515-2601 | 202-225-3211 | 202-225-5687 | http://www.house.gov/rehberg/issue.shtml | 2448 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 | |||||||||
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 | |||||||
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 | |||||||
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 | |||||||
40935 | 40935 | Kristi Noem N000184 | rep | SD | 2011-01-05 | 2013-01-03 | Republican | 0 | http://noem.house.gov/ | 226 Cannon HOB; Washington DC 20515-4101 | 202-225-2801 | 202-225-5823 | 226 Cannon 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 | |||||||
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 | |||||||
43234 | 43234 | Gregorio Sablan S001177 | rep | MP | 2011-01-05 | 2013-01-03 | Democrat | 0 | http://sablan.house.gov | 423 Cannon HOB; Washington DC 20515-5201 | 202-225-2646 | 202-226-4249 | https://forms.house.gov/sablan/contact-form.shtml | 423 Cannon House Office Building | |||||||
43593 | 43593 | Peter Welch W000800 | rep | VT | 2011-01-05 | 2013-01-03 | Democrat | 0 | http://welch.house.gov | 1404 Longworth HOB; Washington DC 20515-4501 | 202-225-4115 | 202-225-6790 | http://www.house.gov/formwelch/issue_subscribe.htm | 1404 Longworth 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 | |||||||
38965 | 38965 | Jay Inslee I000026 | rep | WA | 2011-01-05 | 2012-03-20 | Democrat | 1 | http://www.house.gov/inslee | 2329 Rayburn House Office Building; 20515-4701 | 202-225-6311 | 202-226-1606 | http://www.house.gov/inslee/contact/email.html | 2329 Rayburn House Office Building | |||||||
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 | |||||||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | ||||||||
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 | |||||||
39900 | 39900 | Jack Kingston K000220 | rep | GA | 2011-01-05 | 2013-01-03 | Republican | 1 | http://kingston.house.gov | 2372 Rayburn HOB; Washington DC 20515-1001 | 202-225-5831 | 202-226-2269 | http://kingston.house.gov/ContactForm/ | 2372 Rayburn 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 | ||||||||
40186 | 40186 | Ed Whitfield W000413 | rep | KY | 2011-01-05 | 2013-01-03 | Republican | 1 | http://www.house.gov/whitfield | 2368 Rayburn HOB; Washington DC 20515-1701 | 202-225-3115 | 202-225-3547 | http://whitfield.house.gov/contact/index.shtml | 2368 Rayburn 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 | ||||||||
40413 | 40413 | Jeff Miller M001144 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 1 | http://www.house.gov/jeffmiller | 2416 Rayburn HOB; Washington DC 20515-0901 | 202-225-4136 | 202-225-3414 | http://jeffmiller.house.gov/index.cfm?FuseAction=Contact.Home | 2416 Rayburn House Office Building | |||||||
40503 | 40503 | Frank Guinta G000570 | rep | NH | 2011-01-05 | 2013-01-03 | Republican | 1 | http://guinta.house.gov/ | 1223 Longworth HOB; Washington DC 20515-2901 | 202-225-5456 | 202-225-5822 | 1223 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 | |||||||
40896 | 40896 | Raúl Labrador L000573 | rep | ID | 2011-01-05 | 2013-01-03 | Republican | 1 | http://labrador.house.gov/ | 1523 Longworth HOB; Washington DC 20515-1201 | 202-225-6611 | 202-225-3029 | 1523 Longworth House Office Building | ||||||||
41042 | 41042 | Paul Ryan R000570 | rep | WI | 2011-01-05 | 2013-01-03 | Republican | 1 | http://www.house.gov/ryan | 1233 Longworth HOB; Washington DC 20515-4901 | 202-225-3031 | 202-225-3393 | http://www.house.gov/ryan/email.htm | 1233 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 | ||||||||
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 | |||||||
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 | |||||||
41440 | 41440 | David Roe R000582 | rep | TN | 2011-01-05 | 2013-01-03 | Republican | 1 | http://www.roe.house.gov | 419 Cannon HOB; Washington DC 20515-4201 | 202-225-6356 | 202-225-6356 | https://forms.house.gov/roe/contact-form.shtml | 419 Cannon House Office Building | |||||||
41525 | 41525 | Peter Visclosky V000108 | rep | IN | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://www.house.gov/visclosky | 2256 Rayburn HOB; Washington DC 20515-1401 | 202-225-2461 | 202-225-2493 | http://www.house.gov/writerep | 2256 Rayburn House Office Building | |||||||
41692 | 41692 | Jeff Fortenberry F000449 | rep | NE | 2011-01-05 | 2013-01-03 | Republican | 1 | http://fortenberry.house.gov | 1514 Longworth HOB; Washington DC 20515-2701 | 202-225-4806 | 202-225-5686 | http://fortenberry.house.gov/contactform_zipcheck.shtml | 1514 Longworth House Office Building | |||||||
42054 | 42054 | George Butterfield B001251 | rep | NC | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://www.house.gov/butterfield | 2305 Rayburn HOB; Washington DC 20515-3301 | 202-225-3101 | 202-225-3354 | http://butterfield.house.gov/contactinfo.asp | 2305 Rayburn 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 | ||||||||
42135 | 42135 | David Cicilline C001084 | rep | RI | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://cicilline.house.gov/ | 128 Cannon HOB; Washington DC 20515-3901 | 202-225-4911 | 202-225-3290 | 128 Cannon 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 | ||||||||
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 | |||||||
42409 | 42409 | Louie Gohmert G000552 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 1 | http://gohmert.house.gov | 2440 Rayburn HOB; Washington DC 20515-4301 | 202-225-3035 | 202-226-1230 | http://gohmert.house.gov/contact_louie.htm | 2440 Rayburn 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 | ||||||||
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 | ||||||||
42500 | 42500 | Martin Heinrich H001046 | rep | NM | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://heinrich.house.gov | 336 Cannon HOB; Washington DC 20515-3101 | 202-225-6316 | 202-225-4975 | https://forms.house.gov/heinrich/contact-form.shtml | 336 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 | |||||||
42904 | 42904 | David McKinley M001180 | rep | WV | 2011-01-05 | 2013-01-03 | Republican | 1 | http://mckinley.house.gov/ | 313 Cannon HOB; Washington DC 20515-4801 | 202-225-4172 | 202-225-7564 | 313 Cannon House Office Building | ||||||||
43104 | 43104 | Chellie Pingree P000597 | rep | ME | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://pingree.house.gov | 1318 Longworth HOB; Washington DC 20515-1901 | 202-225-6116 | 202-225-5590 | https://forms.house.gov/pingree/contact-form.shtml | 1318 Longworth House Office Building | |||||||
43217 | 43217 | Bobby Rush R000515 | rep | IL | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://www.house.gov/rush | 2268 Rayburn HOB; Washington DC 20515-1301 | 202-225-4372 | 202-226-0333 | http://www.house.gov/rush/zipauth.shtml | 2268 Rayburn House Office Building | |||||||
43250 | 43250 | Steve Scalise S001176 | rep | LA | 2011-01-05 | 2013-01-03 | Republican | 1 | http://scalise.house.gov/ | 429 Cannon HOB; Washington DC 20515-1801 | 202-225-3015 | 202-226-0386 | http://www.scalise.house.gov/contactform_zipcheck.shtml | 429 Cannon House Office Building | |||||||
43336 | 43336 | Tim Scott S001184 | rep | SC | 2011-01-05 | 2013-01-02 | Republican | 1 | http://timscott.house.gov/ | 1117 Longworth HOB; Washington DC 20515-4001 | 202-225-3176 | 202-225-3407 | 1117 Longworth 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 | |||||||
43618 | 43618 | Robert Wittman W000804 | rep | VA | 2011-01-05 | 2013-01-03 | Republican | 1 | http://www.wittman.house.gov/ | 1317 Longworth HOB; Washington DC 20515-4601 | 202-225-4261 | 202-225-4382 | https://forms.house.gov/wittman/IMA/webforms/issue_subscribe.htm | 1317 Longworth 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 | |||||||
39105 | 39105 | W. Akin A000358 | rep | MO | 2011-01-05 | 2013-01-03 | Republican | 2 | http://akin.house.gov | 117 Cannon HOB; Washington DC 20515-2502 | 202-225-2561 | 202-225-2563 | http://akin.house.gov/email.shtml | 117 Cannon House Office Building | |||||||
39134 | 39134 | Charles Bass B000220 | rep | NH | 2011-01-05 | 2013-01-03 | Republican | 2 | http://bass.house.gov/ | 2350 Rayburn HOB; Washington DC 20515-2902 | 202-225-5206 | 202-225-2946 | 2350 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 | |||||||
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 | |||||||
39509 | 39509 | Jean Schmidt S001164 | rep | OH | 2011-01-05 | 2013-01-03 | Republican | 2 | http://www.house.gov/schmidt | 2464 Rayburn HOB; Washington DC 20515-3502 | 202-225-3164 | 202-225-1992 | http://www.house.gov/schmidt/contact.shtml | 2464 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 | ||||||||
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 | |||||||
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 | |||||||
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 | ||||||||
40068 | 40068 | Lee Terry T000459 | rep | NE | 2011-01-05 | 2013-01-03 | Republican | 2 | http://leeterry.house.gov | 2331 Rayburn HOB; Washington DC 20515-2702 | 202-225-4155 | 202-226-5452 | http://www.house.gov/formleeterry/IMA/issue.htm | 2331 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);