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 legislator_id
This data as json, copyable, CSV (advanced)
Suggested facets: type, district, fax, contact_form, office, state_rank, end (date)
Link | rowid | legislator_id ▼ | type | state | start | end | class | party | district | how | party_affiliations | url | caucus | address | phone | fax | contact_form | office | state_rank | rss_url | end-type |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||
41911 | 41911 | Robert Aderholt A000055 | rep | AL | 2011-01-05 | 2013-01-03 | Republican | 4 | http://aderholt.house.gov | 2264 Rayburn HOB; Washington DC 20515-0104 | 202-225-4876 | 202-225-5587 | http://aderholt.house.gov/?sectionid=195&sectiontree=195 | 2264 Rayburn House Office Building | |||||||
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 | ||||||||
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 | |||||||
39620 | 39620 | Rodney Alexander A000361 | rep | LA | 2011-01-05 | 2013-01-03 | Republican | 5 | http://alexander.house.gov/ | 316 Cannon HOB; Washington DC 20515-1805 | 202-225-8490 | 202-225-5639 | http://www.house.gov/alexander/content/webform/zipauth.htm | 316 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 | |||||||
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 | ||||||||
41285 | 41285 | Justin Amash A000367 | rep | MI | 2011-01-05 | 2013-01-03 | Republican | 3 | http://amash.house.gov/ | 114 Cannon HOB; Washington DC 20515-2203 | 202-225-3831 | 202-225-5144 | 114 Cannon House Office Building | ||||||||
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 | |||||
39747 | 39747 | Spencer Bachus B000013 | rep | AL | 2011-01-05 | 2013-01-03 | Republican | 6 | http://bachus.house.gov | 2246 Rayburn HOB; Washington DC 20515-0106 | 202-225-4921 | 202-225-2082 | |||||||||
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 | |||||||
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 | |||||||
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 | ||||||||
40521 | 40521 | Xavier Becerra B000287 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 31 | http://becerra.house.gov | 1226 Longworth HOB; Washington DC 20515-0531 | 202-225-6235 | 202-225-2202 | http://becerra.house.gov/HoR/CA31/Hidden+Content/Email+Signup+Form.htm | 1226 Longworth House Office Building | |||||||
39157 | 39157 | Howard Berman B000410 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 28 | http://www.house.gov/berman | 2221 Rayburn HOB; Washington DC 20515-0528 | 202-225-4695 | 202-225-3196 | http://www.house.gov/berman/contact/ | 2221 Rayburn House Office Building | |||||||
39171 | 39171 | Brian Bilbray B000461 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 50 | http://www.house.gov/bilbray | 2410 Rayburn HOB; Washington DC 20515-0550 | 202-225-0508 | 202-225-2558 | http://www.house.gov/bilbray/contact.shtml | 2410 Rayburn House Office Building | |||||||
41952 | 41952 | Sanford Bishop B000490 | rep | GA | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://bishop.house.gov | 2429 Rayburn HOB; Washington DC 20515-1002 | 202-225-3631 | 202-225-2203 | http://bishop.house.gov/display.cfm?section_id=13 | 2429 Rayburn House Office Building | |||||||
41975 | 41975 | Earl Blumenauer B000574 | rep | OR | 2011-01-05 | 2013-01-03 | Democrat | 3 | http://blumenauer.house.gov | 1502 Longworth HOB; Washington DC 20515-3703 | 202-225-4811 | 202-225-8941 | http://blumenauer.house.gov/index.php?option=com_email_form&Itemid=206 | 1502 Longworth House Office Building | |||||||
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 | |||||
40164 | 40164 | John Boehner B000589 | rep | OH | 2011-01-05 | 2013-01-03 | Republican | 8 | http://johnboehner.house.gov | 1011 Longworth HOB; Washington DC 20515-3508 | 202-225-6205 | 202-225-0704 | http://www.johnboehner.house.gov/Contact/ | 1011 Longworth House Office Building | |||||||
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 | |||||||
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 | ||||||
42006 | 42006 | Kevin Brady B000755 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 8 | http://www.house.gov/brady | 301 Cannon HOB; Washington DC 20515-4308 | 202-225-4901 | 202-225-5524 | http://www.house.gov/brady/contact_page.html | 301 Cannon House Office Building | |||||||
40264 | 40264 | Corrine Brown B000911 | rep | FL | 2011-01-05 | 2013-01-03 | Democrat | 3 | http://www.house.gov/corrinebrown | 2336 Rayburn HOB; Washington DC 20515-0903 | 202-225-0123 | 202-225-2256 | http://www.house.gov/corrinebrown/IMA/issue.shtml | 2336 Rayburn House Office Building | |||||||
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 | |||||
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 | |||||||
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 | |||||||
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 | |||||||
41923 | 41923 | Tammy Baldwin B001230 | rep | WI | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://tammybaldwin.house.gov | 2446 Rayburn HOB; Washington DC 20515-4902 | 202-225-2906 | 202-225-6942 | http://www.house.gov/formbaldwin/IMA/get_address.htm | 2446 Rayburn 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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||
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 | |||||||
41962 | 41962 | Marsha Blackburn B001243 | rep | TN | 2011-01-05 | 2013-01-03 | Republican | 7 | http://www.house.gov/blackburn | 217 Cannon HOB; Washington DC 20515-4207 | 202-225-2811 | 202-225-3004 | http://blackburn.house.gov/contactform/ | 217 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 | |||||||
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 | |||||||
42036 | 42036 | Michael Burgess B001248 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 26 | http://burgess.house.gov | 2241 Rayburn HOB; Washington DC 20515-4326 | 202-225-7772 | 202-225-2919 | https://forms.house.gov/wyr/welcome.shtml | 2241 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 | |||||||
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 | |||||||
39752 | 39752 | John Barrow B001252 | rep | GA | 2011-01-05 | 2013-01-03 | Democrat | 12 | http://barrow.house.gov | 2202 Rayburn HOB; Washington DC 20515-1012 | 202-225-2823 | 202-225-3377 | https://forms.house.gov/barrow/webforms/issue_subscribe.htm | 2202 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 | |||||||
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 | |||||||
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 | |||||||
41937 | 41937 | Gus Bilirakis B001257 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 9 | http://bilirakis.house.gov | 407 Cannon HOB; Washington DC 20515-0909 | 202-225-5755 | 202-225-4085 | http://bilirakis.house.gov/index.php?option=com_content&task=view&id=212&Itemid=44 | 407 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 | |||||||
42020 | 42020 | Vern Buchanan B001260 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 13 | http://buchanan.house.gov | 221 Cannon HOB; Washington DC 20515-0913 | 202-225-5015 | 202-226-0828 | http://buchanan.house.gov/contact.shtml | 221 Cannon House Office Building | |||||||
39766 | 39766 | Paul Broun B001262 | rep | GA | 2011-01-05 | 2013-01-03 | Republican | 10 | http://broun.house.gov/ | 325 Cannon HOB; Washington DC 20515-1009 | 202-225-4101 | 202-226-0776 | http://broun.house.gov/email.shtml | 325 Cannon House Office Building | |||||||
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 | |||||
40690 | 40690 | Lou Barletta B001269 | rep | PA | 2011-01-05 | 2013-01-03 | Republican | 11 | http://barletta.house.gov/ | 510 Cannon HOB; Washington DC 20515-3811 | 202-225-6511 | 202-225-0764 | 510 Cannon House Office Building | ||||||||
41926 | 41926 | Karen Bass B001270 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 33 | http://karenbass.house.gov/ | 408 Cannon HOB; Washington DC 20515-0533 | 202-225-7084 | 202-225-2422 | 408 Cannon House Office Building | ||||||||
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 | ||||||||
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 | ||||||||
40711 | 40711 | Diane Black B001273 | rep | TN | 2011-01-05 | 2013-01-03 | Republican | 6 | http://black.house.gov/ | 1531 Longworth HOB; Washington DC 20515-4206 | 202-225-4231 | 202-225-6887 | 1531 Longworth House Office Building | ||||||||
42012 | 42012 | Mo Brooks B001274 | rep | AL | 2011-01-05 | 2013-01-03 | Republican | 5 | http://brooks.house.gov/ | 1641 Longworth HOB; Washington DC 20515-0105 | 202-225-4801 | 202-225-4392 | 1641 Longworth House Office Building | ||||||||
42026 | 42026 | Larry Bucshon B001275 | rep | IN | 2011-01-05 | 2013-01-03 | Republican | 8 | http://bucshon.house.gov/ | 1123 Longworth HOB; Washington DC 20515-1408 | 202-225-4636 | 202-225-3284 | 1123 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 | ||||||||
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 | |||||
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 | |||||||
39778 | 39778 | Dave Camp C000071 | rep | MI | 2011-01-05 | 2013-01-03 | Republican | 4 | http://camp.house.gov | 341 Cannon HOB; Washington DC 20515-2204 | 202-225-3561 | 202-225-9679 | http://camp.house.gov/WriteRep.aspx | 341 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 | ||||||||
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 | |||||||||
42167 | 42167 | James Clyburn C000537 | rep | SC | 2011-01-05 | 2013-01-03 | Democrat | 6 | http://clyburn.house.gov | 2135 Rayburn HOB; Washington DC 20515-4006 | 202-225-3315 | 202-225-2313 | http://clyburn.house.gov/contact.cfm | 2135 Rayburn House Office Building | |||||||
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& | |||||
40144 | 40144 | Howard Coble C000556 | rep | NC | 2011-01-05 | 2013-01-03 | Republican | 6 | http://www.house.gov/coble | 2188 Rayburn HOB; Washington DC 20515-3306 | 202-225-3065 | 202-225-8611 | http://www.house.gov/writerep | 2188 Rayburn House 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 | ||||||
40578 | 40578 | John Conyers C000714 | rep | MI | 2011-01-05 | 2013-01-03 | Democrat | 14 | http://www.house.gov/conyers | 2426 Rayburn HOB; Washington DC 20515-2214 | 202-225-5126 | 202-225-0072 | http://conyers.house.gov/index.cfm?FuseAction=Contact.OnlineContactForm | 2426 Rayburn House Office Building | |||||||
42208 | 42208 | Jim Cooper C000754 | rep | TN | 2011-01-05 | 2013-01-03 | Democrat | 5 | http://cooper.house.gov | 1536 Longworth HOB; Washington DC 20515-4205 | 202-225-4311 | 202-226-1035 | http://cooper.house.gov/index.php?option=com_content&task=view&id=117&Itemid=61 | 1536 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 | |||||||
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 | ||||||
41204 | 41204 | Elijah Cummings C000984 | rep | MD | 2011-01-05 | 2013-01-03 | Democrat | 7 | http://www.house.gov/cummings | 2235 Rayburn HOB; Washington DC 20515-2007 | 202-225-4741 | 202-225-3178 | https://forms.house.gov/wyr/welcome.shtml | 2235 Rayburn House Office Building | |||||||
40274 | 40274 | Lois Capps C001036 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 23 | http://www.house.gov/capps | 2231 Rayburn HOB; Washington DC 20515-0523 | 202-225-3601 | 202-225-5632 | http://www.house.gov/capps/contact/send_an_email.shtml | 2231 Rayburn House Office Building | |||||||
40740 | 40740 | Michael Capuano C001037 | rep | MA | 2011-01-05 | 2013-01-03 | Democrat | 8 | http://www.house.gov/capuano | 1414 Longworth HOB; Washington DC 20515-2108 | 202-225-5111 | 202-225-9322 | http://www.house.gov/capuano/contact/email.shtml | 1414 Longworth House Office Building | |||||||
40755 | 40755 | Joseph Crowley C001038 | rep | NY | 2011-01-05 | 2013-01-03 | Democrat | 7 | http://www.house.gov/crowley | 2404 Rayburn HOB; Washington DC 20515-3207 | 202-225-3965 | 202-225-1909 | https://forms.house.gov/crowley/contact.shtml | 2404 Rayburn House Office Building | |||||||
40285 | 40285 | Ander Crenshaw C001045 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 4 | http://crenshaw.house.gov | 440 Cannon HOB; Washington DC 20515-0904 | 202-225-2501 | 202-225-2504 | https://forms.house.gov/wyr/welcome.shtml | 440 Cannon House Office Building | |||||||
39684 | 39684 | Eric Cantor C001046 | rep | VA | 2011-01-05 | 2013-01-03 | Republican | 7 | http://cantor.house.gov | 303 Cannon HOB; Washington DC 20515-4607 | 202-225-2815 | 202-225-0011 | https://writerep.house.gov/writerep/welcome.shtml | 303 Cannon House Office Building | |||||||
42080 | 42080 | Shelley Capito C001047 | rep | WV | 2011-01-05 | 2013-01-03 | Republican | 2 | http://capito.house.gov | 2443 Rayburn HOB; Washington DC 20515-4802 | 202-225-2711 | 202-225-7856 | https://forms.house.gov/wyr/welcome.shtml | 2443 Rayburn House Office Building | |||||||
40764 | 40764 | John Culberson C001048 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 7 | http://culberson.house.gov | 2352 Rayburn HOB; Washington DC 20515-4307 | 202-225-2571 | 202-225-4381 | http://www.culberson.house.gov/contactinfo.aspx | 2352 Rayburn 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 | |||||||
38941 | 38941 | Dennis Cardoza C001050 | rep | CA | 2011-01-05 | 2012-08-15 | Democrat | 18 | http://www.house.gov/cardoza | 2437 Rayburn House Office Building; 20515-0518 | 202-225-6131 | 202-225-0819 | https://forms.house.gov/wyr/welcome.shtml | 2437 Rayburn House Office Building | |||||||
42096 | 42096 | John Carter C001051 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 31 | http://carter.house.gov | 409 Cannon HOB; Washington DC 20515-4331 | 202-225-3864 | 202-225-5886 | https://forms.house.gov/wyr/welcome.shtml | 409 Cannon House Office Building | |||||||
42185 | 42185 | Tom Cole C001053 | rep | OK | 2011-01-05 | 2013-01-03 | Republican | 4 | http://www.house.gov/cole | 2458 Rayburn HOB; Washington DC 20515-3604 | 202-225-6165 | 202-225-3512 | http://www.cole.house.gov/contact-tom.html | 2458 Rayburn 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 | |||||||
42217 | 42217 | Jim Costa C001059 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 20 | http://www.house.gov/costa | 1314 Longworth HOB; Washington DC 20515-0520 | 202-225-3341 | 202-225-9308 | http://www.house.gov/formcosta/issue.htm | 1314 Longworth House Office Building | |||||||
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 | |||||||
42152 | 42152 | Emanuel Cleaver C001061 | rep | MO | 2011-01-05 | 2013-01-03 | Democrat | 5 | http://www.house.gov/cleaver | 1433 Longworth HOB; Washington DC 20515-2505 | 202-225-4535 | 202-225-4403 | http://www.house.gov/cleaver/IMA/issue.htm | 1433 Longworth House Office Building | |||||||
41312 | 41312 | K. Conaway C001062 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 11 | http://www.house.gov/conaway | 2430 Rayburn HOB; Washington DC 20515-4311 | 202-225-3605 | 202-225-1783 | http://conaway.house.gov/Contact/default.aspx#email | 2430 Rayburn House Office Building | |||||||
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 | |||||||
39783 | 39783 | John Campbell C001064 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 48 | http://www.house.gov/campbell | 1507 Longworth HOB; Washington DC 20515-0548 | 202-225-5611 | 202-225-9177 | http://campbell.house.gov/Contact/ContactForm.htm | 1507 Longworth House Office Building | |||||||
42109 | 42109 | Kathy Castor C001066 | rep | FL | 2011-01-05 | 2013-01-03 | Democrat | 11 | http://castor.house.gov | 137 Cannon HOB; Washington DC 20515-0911 | 202-225-3376 | 202-225-5652 | https://forms.house.gov/wyr/welcome.shtml | 137 Cannon House Office Building | |||||||
42143 | 42143 | Yvette Clarke C001067 | rep | NY | 2011-01-05 | 2013-01-03 | Democrat | 11 | http://clarke.house.gov | 1029 Longworth HOB; Washington DC 20515-3211 | 202-225-6231 | 202-226-0112 | http://clarke.house.gov/contactform_zipcheck.shtml | 1029 Longworth House Office Building | |||||||
42175 | 42175 | Steve Cohen C001068 | rep | TN | 2011-01-05 | 2013-01-03 | Democrat | 9 | http://cohen.house.gov | 1005 Longworth HOB; Washington DC 20515-4209 | 202-225-3265 | 202-225-5663 | http://cohen.house.gov/index.php?option=com_email_form&Itemid=113 | 1005 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 | |||||||
42086 | 42086 | André Carson C001072 | rep | IN | 2011-01-05 | 2013-01-03 | Democrat | 7 | http://carson.house.gov/ | 425 Cannon HOB; Washington DC 20515-1407 | 202-225-4011 | 202-225-5633 | http://carson.house.gov/contact.me.shtml | 425 Cannon House Office Building | |||||||
42103 | 42103 | Bill Cassidy C001075 | rep | LA | 2011-01-05 | 2013-01-03 | Republican | 6 | http://cassidy.house.gov | 1535 Longworth HOB; Washington DC 20515-1806 | 202-225-3901 | 202-225-7313 | https://forms.house.gov/cassidy/contact-form.shtml | 1535 Longworth House Office Building | |||||||
40543 | 40543 | Jason Chaffetz C001076 | rep | UT | 2011-01-05 | 2013-01-03 | Republican | 3 | http://chaffetz.house.gov | 1032 Longworth HOB; Washington DC 20515-4403 | 202-225-7751 | 202-225-5629 | https://forms.house.gov/chaffetz/contact-form.shtml | 1032 Longworth House Office Building | |||||||
40745 | 40745 | Mike Coffman C001077 | rep | CO | 2011-01-05 | 2013-01-03 | Republican | 6 | http://coffman.house.gov | 1222 Longworth HOB; Washington DC 20515-0606 | 202-225-7882 | 202-226-4623 | https://forms.house.gov/coffman/contact-form.shtml | 1222 Longworth House Office Building | |||||||
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 | |||||||
42129 | 42129 | Judy Chu C001080 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 32 | http://chu.house.gov/ | 1520 Longworth HOB; Washington DC 20515-0532 | 202-225-5464 | 202-225-5467 | https://forms.house.gov/chu/contact-form.shtml | 1520 Longworth House Office Building |
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);