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 end descending
This data as json, copyable, CSV (advanced)
Suggested facets: type, district, fax
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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& | |||||
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 | ||||||
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 | |||||||
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 | ||||||||
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 | |||||||
39108 | 39108 | Jason Altmire A000362 | rep | PA | 2011-01-05 | 2013-01-03 | Democrat | 4 | http://altmire.house.gov | 332 Cannon HOB; Washington DC 20515-3804 | 202-225-2565 | 202-226-2274 | https://forms.house.gov/altmire/webforms/issue_subscribe.htm | 332 Cannon House Office Building | |||||||
39110 | 39110 | Steve Austria A000365 | rep | OH | 2011-01-05 | 2013-01-03 | Republican | 7 | http://austria.house.gov | 439 Cannon HOB; Washington DC 20515-3507 | 202-225-4324 | 202-225-1984 | https://forms.house.gov/austria/contact-form.shtml | 439 Cannon House Office Building | |||||||
39117 | 39117 | Joe Baca B001234 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 43 | http://www.house.gov/baca | 2366 Rayburn HOB; Washington DC 20515-0543 | 202-225-6161 | 202-225-8671 | http://www.house.gov/baca/zipauth.shtml | 2366 Rayburn House Office Building | |||||||
39127 | 39127 | Roscoe Bartlett B000208 | rep | MD | 2011-01-05 | 2013-01-03 | Republican | 6 | http://bartlett.house.gov | 2412 Rayburn HOB; Washington DC 20515-2006 | 202-225-2721 | 202-225-2193 | http://www.bartlett.house.gov/Email_Roscoe/ | 2412 Rayburn 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 | ||||||||
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 | ||||||||
39142 | 39142 | Shelley Berkley B001231 | rep | NV | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://berkley.house.gov | 405 Cannon HOB; Washington DC 20515-2801 | 202-225-5965 | 202-225-3119 | http://berkley.house.gov/contact/email.html | 405 Cannon House Office Building | |||||||
39157 | 39157 | Howard Berman B000410 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 28 | http://www.house.gov/berman | 2221 Rayburn HOB; Washington DC 20515-0528 | 202-225-4695 | 202-225-3196 | http://www.house.gov/berman/contact/ | 2221 Rayburn House Office Building | |||||||
39164 | 39164 | Judy Biggert B001232 | rep | IL | 2011-01-05 | 2013-01-03 | Republican | 13 | http://judybiggert.house.gov | 2113 Rayburn HOB; Washington DC 20515-1313 | 202-225-3515 | 202-225-9420 | http://judybiggert.house.gov/ContactJudy.aspx | 2113 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 | |||||||
39183 | 39183 | Dan Boren B001254 | rep | OK | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://www.house.gov/boren | 2447 Rayburn HOB; Washington DC 20515-3602 | 202-225-2701 | 202-225-3038 | http://www.house.gov/boren/emailsignup.shtml | 2447 Rayburn House Office Building | |||||||
39191 | 39191 | Leonard Boswell B000652 | rep | IA | 2011-01-05 | 2013-01-03 | Democrat | 3 | http://boswell.house.gov | 1026 Longworth HOB; Washington DC 20515-1503 | 202-225-3806 | 202-225-5608 | http://boswell.house.gov/messageform.htm | 1026 Longworth House Office Building | |||||||
39192 | 39192 | Ann Marie Buerkle B001276 | rep | NY | 2011-01-05 | 2013-01-03 | Republican | 25 | http://buerkle.house.gov/ | 1630 Longworth HOB; Washington DC 20515-3225 | 202-225-3701 | 202-225-4042 | 1630 Longworth 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 | |||||||
39208 | 39208 | Francisco Canseco C001082 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 23 | http://canseco.house.gov/ | 1339 Longworth HOB; Washington DC 20515-4323 | 202-225-4511 | 202-225-2237 | 1339 Longworth House Office Building | ||||||||
39212 | 39212 | Russ Carnahan C001060 | rep | MO | 2011-01-05 | 2013-01-03 | Democrat | 3 | http://www.house.gov/carnahan | 1710 Longworth HOB; Washington DC 20515-2503 | 202-225-2671 | 202-225-7452 | http://carnahan.house.gov/contact.shtml | 1710 Longworth House Office Building | |||||||
39217 | 39217 | Ben Chandler C001058 | rep | KY | 2011-01-05 | 2013-01-03 | Democrat | 6 | http://chandler.house.gov | 1504 Longworth HOB; Washington DC 20515-1706 | 202-225-4706 | 202-225-2122 | https://forms.house.gov/wyr/welcome.shtml | 1504 Longworth House Office Building | |||||||
39218 | 39218 | Hansen Clarke C001085 | rep | MI | 2011-01-05 | 2013-01-03 | Democrat | 13 | http://hansenclarke.house.gov/ | 1319 Longworth HOB; Washington DC 20515-2213 | 202-225-2261 | 202-225-5730 | 1319 Longworth House Office Building | ||||||||
39231 | 39231 | Jerry Costello C000794 | rep | IL | 2011-01-05 | 2013-01-03 | Democrat | 12 | http://www.house.gov/costello | 2408 Rayburn HOB; Washington DC 20515-1312 | 202-225-5661 | 202-225-0285 | http://costello.house.gov/IMA/issue_subscribe.shtml | 2408 Rayburn House Office Building | |||||||
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 | ||||||||
39234 | 39234 | Mark Critz C001081 | rep | PA | 2011-01-05 | 2013-01-03 | Democrat | 12 | http://critz.house.gov/ | 1022 Longworth HOB; Washington DC 20515-3812 | 202-225-2065 | 202-225-5974 | https://critz.house.gov/contact/email-me.shtml | 1022 Longworth House Office Building | |||||||
39252 | 39252 | Norman Dicks D000327 | rep | WA | 2011-01-05 | 2013-01-03 | Democrat | 6 | http://www.house.gov/dicks | 2467 Rayburn HOB; Washington DC 20515-4706 | 202-225-5916 | 202-226-1176 | http://www.house.gov/dicks/email.shtml | 2467 Rayburn House Office Building | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
39304 | 39304 | Charles Gonzalez G000544 | rep | TX | 2011-01-05 | 2013-01-03 | Democrat | 20 | http://gonzalez.house.gov | 1436 Longworth HOB; Washington DC 20515-4320 | 202-225-3236 | 202-225-1915 | http://www.gonzalez.house.gov/index.php?option=com_content&task=view&id=170 | 1436 Longworth House Office Building | |||||||
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 | ||||||||
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 | |||||||
39328 | 39328 | Maurice Hinchey H000627 | rep | NY | 2011-01-05 | 2013-01-03 | Democrat | 22 | http://www.house.gov/hinchey | 2431 Rayburn HOB; Washington DC 20515-3222 | 202-225-6335 | 202-226-0774 | http://www.house.gov/hinchey/contact/zipauth.shtml | 2431 Rayburn House Office Building | |||||||
39338 | 39338 | Tim Holden H000712 | rep | PA | 2011-01-05 | 2013-01-03 | Democrat | 17 | http://www.holden.house.gov | 2417 Rayburn HOB; Washington DC 20515-3817 | 202-225-5546 | 202-226-0996 | http://www.holden.house.gov/contactform_zipcheck.shtml | 2417 Rayburn House Office Building | |||||||
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 | |||||||
39362 | 39362 | Dale Kildee K000172 | rep | MI | 2011-01-05 | 2013-01-03 | Democrat | 5 | http://www.house.gov/kildee | 2107 Rayburn HOB; Washington DC 20515-2205 | 202-225-3611 | 202-225-6393 | http://www.house.gov/writerep | 2107 Rayburn House Office Building | |||||||
39364 | 39364 | Larry Kissell K000369 | rep | NC | 2011-01-05 | 2013-01-03 | Democrat | 8 | http://kissell.house.gov | 1632 Longworth HOB; Washington DC 20515-3308 | 202-225-3715 | 202-225-4036 | https://forms.house.gov/kissell/contact-form.shtml | 1632 Longworth House Office Building | |||||||
39372 | 39372 | Dennis Kucinich K000336 | rep | OH | 2011-01-05 | 2013-01-03 | Democrat | 10 | http://kucinich.house.gov | 2445 Rayburn HOB; Washington DC 20515-3510 | 202-225-5871 | 202-225-5745 | http://kucinich.house.gov/Contact/Starter.htm | 2445 Rayburn House Office Building | |||||||
39381 | 39381 | Steven LaTourette L000553 | rep | OH | 2011-01-05 | 2013-01-03 | Republican | 14 | http://www.house.gov/latourette | 2371 Rayburn HOB; Washington DC 20515-3514 | 202-225-5731 | 202-225-3307 | http://latourette.house.gov/ContactSteve.aspx | 2371 Rayburn 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 | ||||||||
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 | |||||||
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 | |||||||
39422 | 39422 | Donald Manzullo M001138 | rep | IL | 2011-01-05 | 2013-01-03 | Republican | 16 | http://manzullo.house.gov | 2228 Rayburn HOB; Washington DC 20515-1316 | 202-225-5676 | 202-225-5284 | http://manzullo.house.gov/zipauth.aspx | 2228 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 | |||||||
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 | |||||||
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 | |||||||
39459 | 39459 | Ronald Paul P000583 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 14 | http://www.house.gov/paul | 203 Cannon HOB; Washington DC 20515-4314 | 202-225-2831 | 202-226-6553 | http://www.house.gov/paul/contact.shtml | 203 Cannon House Office Building | |||||||
39465 | 39465 | Mike Pence P000587 | rep | IN | 2011-01-05 | 2013-01-03 | Republican | 6 | http://mikepence.house.gov | 100 Cannon HOB; Washington DC 20515-1406 | 202-225-3021 | 202-225-3382 | https://forms.house.gov/pence/IMA/contact_form.htm | 100 Cannon House Office Building | |||||||
39471 | 39471 | Todd Platts P000585 | rep | PA | 2011-01-05 | 2013-01-03 | Republican | 19 | http://www.house.gov/platts | 2455 Rayburn HOB; Washington DC 20515-3819 | 202-225-5836 | 202-226-1000 | http://www.house.gov/platts/email.shtml | 2455 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 | ||||||||
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 | |||||||
39486 | 39486 | Silvestre Reyes R000170 | rep | TX | 2011-01-05 | 2013-01-03 | Democrat | 16 | http://wwwc.house.gov/reyes | 2210 Rayburn HOB; Washington DC 20515-4316 | 202-225-4831 | 202-225-2016 | http://wwwc.house.gov/reyes/voice_your_opinion.asp | 2210 Rayburn House Office Building | |||||||
39489 | 39489 | Laura Richardson R000581 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 37 | http://richardson.house.gov/ | 1330 Longworth HOB; Washington DC 20515-0537 | 202-225-7924 | 202-225-7926 | http://richardson.house.gov/IMA/issue_subscribe.htm | 1330 Longworth House Office Building | |||||||
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 | ||||||||
39496 | 39496 | Mike Ross R000573 | rep | AR | 2011-01-05 | 2013-01-03 | Democrat | 4 | http://www.house.gov/ross | 2436 Rayburn HOB; Washington DC 20515-0404 | 202-225-3772 | 202-225-1314 | http://ross.house.gov/?sectionid=77§iontree=76,77 | 2436 Rayburn House Office Building | |||||||
39504 | 39504 | Steven Rothman R000462 | rep | NJ | 2011-01-05 | 2013-01-03 | Democrat | 9 | http://rothman.house.gov | 2303 Rayburn HOB; Washington DC 20515-3009 | 202-225-5061 | 202-225-5851 | https://forms.house.gov/rothman/webforms/issue_subscribe.htm | 2303 Rayburn House Office Building | |||||||
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 | ||||||||
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 | |||||||
39512 | 39512 | Heath Shuler S001171 | rep | NC | 2011-01-05 | 2013-01-03 | Democrat | 11 | http://shuler.house.gov | 229 Cannon HOB; Washington DC 20515-3311 | 202-225-6401 | 202-226-6422 | http://shuler.house.gov/zipauth.htm | 229 Cannon House Office Building | |||||||
39532 | 39532 | Fortney Stark S000810 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 13 | http://www.house.gov/stark | 239 Cannon HOB; Washington DC 20515-0513 | 202-225-5065 | 202-226-3805 | http://www.house.gov/stark/contact/index.htm | 239 Cannon House Office Building | |||||||
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 | |||||||
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 | |||||||
39553 | 39553 | Betty Sutton S001174 | rep | OH | 2011-01-05 | 2013-01-03 | Democrat | 13 | http://sutton.house.gov | 1519 Longworth HOB; Washington DC 20515-3513 | 202-225-3401 | 202-225-2266 | http://sutton.house.gov/about/emailform.cfm | 1519 Longworth House Office Building | |||||||
39568 | 39568 | Edolphus Towns T000326 | rep | NY | 2011-01-05 | 2013-01-03 | Democrat | 10 | http://www.house.gov/towns | 2232 Rayburn HOB; Washington DC 20515-3210 | 202-225-5936 | 202-225-1018 | http://www.house.gov/towns/contact_form_zipcheck.shtml | 2232 Rayburn House Office Building | |||||||
39569 | 39569 | Joe Walsh W000811 | rep | IL | 2011-01-05 | 2013-01-03 | Republican | 8 | http://walsh.house.gov/ | 432 Cannon HOB; Washington DC 20515-1308 | 202-225-3711 | 202-225-7830 | https://walsh.house.gov/contact-me | 432 Cannon 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 | ||||||||
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 |
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);