legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
470 rows where "end" is on date 2013-01-03 sorted by url
This data as json, copyable, CSV (advanced)
Suggested facets: type, party, contact_form
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
43679 | 43679 | Donald Payne P000604 | rep | NJ | 2012-11-15 | 2013-01-03 | Democrat | 10 | 2310 Rayburn HOB; Washington DC 20515-3010 | 202-225-3436 | 2310 Rayburn House Office Building | ||||||||||
39098 | 39098 | Gary Ackerman A000022 | rep | NY | 2011-01-05 | 2013-01-03 | Democrat | 5 | http://ackerman.house.gov/ | 2111 Rayburn HOB; Washington DC 20515-3205 | 202-225-2601 | 202-225-1589 | http://www.house.gov/writerep | 2111 Rayburn House Office Building | |||||||
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 | ||||||||
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 | |||||||
43405 | 43405 | Adrian Smith S001172 | rep | NE | 2011-01-05 | 2013-01-03 | Republican | 3 | http://adriansmith.house.gov | 503 Cannon HOB; Washington DC 20515-2703 | 202-225-6435 | 202-225-0207 | http://www.house.gov/formadriansmith/issues_subscribe.htm | 503 Cannon House Office Building | |||||||
39040 | 39040 | Daniel Akaka A000069 | sen | HI | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://akaka.senate.gov | 141 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-6361 | 202-224-2126 | http://www.akaka.senate.gov/email-senator-akaka.cfm | 141 Hart Senate 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 | |||||||
41640 | 41640 | Alcee Hastings H000324 | rep | FL | 2011-01-05 | 2013-01-03 | Democrat | 23 | http://alceehastings.house.gov | 2353 Rayburn HOB; Washington DC 20515-0923 | 202-225-1313 | 202-225-1171 | http://www.alceehastings.house.gov/index.php?option=com_content&task=view&id=104&Itemid= | 2353 Rayburn House Office Building | |||||||
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 | |||||||
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 | ||||||||
43655 | 43655 | Mark Amodei A000369 | rep | NV | 2011-09-13 | 2013-01-03 | Republican | 2 | http://amodei.house.gov/ | 125 Cannon HOB; Washington DC 20515-2802 | 202-225-6155 | 202-225-5679 | https://amodei.house.gov/contact-me | 125 Cannon House Office Building | |||||||
43305 | 43305 | Austin Scott S001189 | rep | GA | 2011-01-05 | 2013-01-03 | Republican | 8 | http://austinscott.house.gov/ | 516 Cannon HOB; Washington DC 20515-1003 | 202-225-6531 | 202-225-3013 | 516 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 | |||||||
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 | |||||||
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 | |||||||||
40116 | 40116 | Ron Barber B001279 | rep | AZ | 2012-06-12 | 2013-01-03 | Democrat | 8 | http://barber.house.gov/ | 1030 Longworth HOB; Washington DC 20515-0308 | 202-225-2542 | 202-225-0378 | https://barber.house.gov/contact-me/email-me | 1030 Longworth House Office Building | |||||||
40690 | 40690 | Lou Barletta B001269 | rep | PA | 2011-01-05 | 2013-01-03 | Republican | 11 | http://barletta.house.gov/ | 510 Cannon HOB; Washington DC 20515-3811 | 202-225-6511 | 202-225-0764 | 510 Cannon House Office Building | ||||||||
41813 | 41813 | John Barrasso B001261 | sen | WY | 2007-06-25 | 2013-01-03 | 1 | Republican | appointment | http://barrasso.senate.gov | 307 DIRKSEN SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-6441 | 202-224-1724 | http://www.barrasso.senate.gov/public/index.cfm?FuseAction=ContactUs.ContactForm | 307 Dirksen Senate 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 | |||||||
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 | ||||||||
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 | |||||||
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 | ||||||||
39070 | 39070 | Ben Nelson N000180 | sen | NE | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://bennelson.senate.gov/ | 720 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-6551 | 202-228-0012 | http://www.bennelson.senate.gov/contact-me.cfm | 720 Hart Senate Office Building | |||||||
43459 | 43459 | Bennie Thompson T000193 | rep | MS | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://benniethompson.house.gov | 2466 Rayburn HOB; Washington DC 20515-2402 | 202-225-5876 | 202-225-5898 | https://forms.house.gov/benniethompson/contact-form.shtml | 2466 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 | |||||||
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 | |||||||
42573 | 42573 | Bill Johnson J000292 | rep | OH | 2011-01-05 | 2013-01-03 | Republican | 6 | http://billjohnson.house.gov/ | 317 Cannon HOB; Washington DC 20515-3506 | 202-225-5705 | 202-225-5907 | 317 Cannon House Office Building | ||||||||
40688 | 40688 | Bill Nelson N000032 | sen | FL | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://billnelson.senate.gov/ | 716 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-5274 | 202-228-2183 | http://www.billnelson.senate.gov/contact/index.cfm | 716 Hart Senate Office Building | |||||||
39045 | 39045 | Jeff Bingaman B000468 | sen | NM | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://bingaman.senate.gov | 703 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-5521 | 202-224-2852 | http://www.bingaman.senate.gov/contact/ | 703 Hart Senate 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 | |||||||
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 | ||||||||
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 | |||||||
39582 | 39582 | Robert Turner T000471 | rep | NY | 2011-09-13 | 2013-01-03 | Republican | 9 | http://bobturner.house.gov/ | 2104 Rayburn HOB; Washington DC 20515-3209 | 202-225-6616 | 202-226-0218 | https://bobturner.house.gov/contact-me | 2104 Rayburn House Office Building | |||||||
43661 | 43661 | Suzanne Bonamici B001278 | rep | OR | 2012-02-07 | 2013-01-03 | Democrat | 1 | http://bonamici.house.gov/ | 2338 Rayburn HOB; Washington DC 20515-3701 | 202-225-0855 | https://bonamici.house.gov/contact-me | 2338 Rayburn House Office Building | ||||||||
39614 | 39614 | Jo Bonner B001244 | rep | AL | 2011-01-05 | 2013-01-03 | Republican | 1 | http://bonner.house.gov | 2236 Rayburn HOB; Washington DC 20515-0101 | 202-225-4931 | 202-225-0562 | https://forms.house.gov/bonner/webforms/issue_subscribe.html | 2236 Rayburn House Office Building | |||||||
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 | |||||||
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 | |||||||
43363 | 43363 | Brad Sherman S000344 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 27 | http://bradsherman.house.gov | 2242 Rayburn HOB; Washington DC 20515-0527 | 202-225-5911 | 202-225-5879 | http://www.house.gov/sherman/contact/ | 2242 Rayburn 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 | |||||||
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 | ||||||||
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 | |||||||
41737 | 41737 | Sherrod Brown B000944 | sen | OH | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://brown.senate.gov/ | 713 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-2315 | 202-228-6321 | http://www.brown.senate.gov/contact/ | 713 Hart Senate 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 | |||||||
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 | ||||||||
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 | |||||||
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 | |||||||
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 | |||||||
40197 | 40197 | Candice Miller M001150 | rep | MI | 2011-01-05 | 2013-01-03 | Republican | 10 | http://candicemiller.house.gov | 1034 Longworth HOB; Washington DC 20515-2210 | 202-225-2106 | 202-226-1169 | http://candicemiller.house.gov/Contact.aspx | 1034 Longworth House Office Building | |||||||
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 | ||||||||
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 | |||||||
41742 | 41742 | Maria Cantwell C000127 | sen | WA | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://cantwell.senate.gov | 311 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-3441 | 202-228-0514 | http://www.cantwell.senate.gov/contact/ | 311 Hart Senate 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 | |||||||
41755 | 41755 | Benjamin Cardin C000141 | sen | MD | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://cardin.senate.gov/ | 509 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-4524 | 202-224-1651 | http://www.cardin.senate.gov/contact/ | 509 Hart Senate Office Building | |||||||
41764 | 41764 | Thomas Carper C000174 | sen | DE | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://carper.senate.gov | 513 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-2441 | 202-228-2190 | http://www.carper.senate.gov/contact/ | 513 Hart Senate 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 | |||||||
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 | |||||||
41767 | 41767 | Robert Casey C001070 | sen | PA | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://casey.senate.gov/ | 393 RUSSELL SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-6324 | 202-228-0604 | http://www.casey.senate.gov/contact/ | 393 Russell Senate 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 | |||||||
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 | |||||||
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 | ||||||||
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 | |||||||
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 | |||||||
42964 | 42964 | Christopher Murphy M001169 | rep | CT | 2011-01-05 | 2013-01-03 | Democrat | 5 | http://chrismurphy.house.gov | 412 Cannon HOB; Washington DC 20515-0705 | 202-225-4476 | 202-225-5933 | http://www.house.gov/formchrismurphy/ic_zip_auth.htm | 412 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 | |||||||
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 | ||||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
41429 | 41429 | Collin Peterson P000258 | rep | MN | 2011-01-05 | 2013-01-03 | Democrat | 7 | http://collinpeterson.house.gov | 2211 Rayburn HOB; Washington DC 20515-2307 | 202-225-2165 | 202-225-1593 | http://collinpeterson.house.gov//email.html | 2211 Rayburn House Office Building | |||||||
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 | |||||||
39050 | 39050 | Kent Conrad C000705 | sen | ND | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://conrad.senate.gov | 530 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-2043 | 202-224-7776 | http://www.conrad.senate.gov/contact/webform.cfm | 530 Hart Senate 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 | |||||||
40670 | 40670 | Bob Corker C001071 | sen | TN | 2007-01-04 | 2013-01-03 | 1 | Republican | http://corker.senate.gov/ | 185 DIRKSEN SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-3344 | 202-228-0566 | http://www.corker.senate.gov/public/index.cfm?p=ContactMe | 185 Dirksen Senate 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 | |||||||
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 | ||||||||
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 | ||||||||
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 | |||||||
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 | |||||||
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 | |||||||
39583 | 39583 | David Curson C001089 | rep | MI | 2012-11-13 | 2013-01-03 | Democrat | 11 | http://curson.house.gov | 2243 Rayburn HOB; Washington DC 20515-2211 | 202-225-8171 | 2243 Rayburn House Office Building | |||||||||
43315 | 43315 | David Scott S001157 | rep | GA | 2011-01-05 | 2013-01-03 | Democrat | 13 | http://davidscott.house.gov | 225 Cannon HOB; Washington DC 20515-1013 | 202-225-2939 | 202-225-4628 | http://www.house.gov/writerep | 225 Cannon House Office Building | |||||||
42278 | 42278 | Peter DeFazio D000191 | rep | OR | 2011-01-05 | 2013-01-03 | Democrat | 4 | http://defazio.house.gov | 2134 Rayburn HOB; Washington DC 20515-3704 | 202-225-6416 | 202-225-0032 | http://www.house.gov/formdefazio/contact.html | 2134 Rayburn House Office Building | |||||||
43667 | 43667 | Suzan DelBene D000617 | rep | WA | 2012-11-13 | 2013-01-03 | Democrat | 1 | http://delbene.house.gov | 2329 Rayburn HOB; Washington DC 20515-4701 | 202-225-6311 | 2329 Rayburn House Office Building | |||||||||
40768 | 40768 | Jeff Denham D000612 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 19 | http://denham.house.gov/ | 1605 Longworth HOB; Washington DC 20515-0519 | 202-225-4540 | 202-225-3402 | 1605 Longworth House Office Building | ||||||||
41019 | 41019 | Dennis Ross R000593 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 12 | http://dennisross.house.gov/ | 404 Cannon HOB; Washington DC 20515-0912 | 202-225-1252 | 202-226-0585 | 404 Cannon House Office Building | ||||||||
40642 | 40642 | Charles Dent D000604 | rep | PA | 2011-01-05 | 2013-01-03 | Republican | 15 | http://dent.house.gov | 1009 Longworth HOB; Washington DC 20515-3815 | 202-225-6411 | 202-226-0778 | http://dent.house.gov/verifyemail.shtml | 1009 Longworth House Office Building | |||||||
42313 | 42313 | Scott DesJarlais D000616 | rep | TN | 2011-01-05 | 2013-01-03 | Republican | 4 | http://desjarlais.house.gov/ | 413 Cannon HOB; Washington DC 20515-4204 | 202-225-6831 | 202-226-5172 | 413 Cannon House Office Building | ||||||||
41721 | 41721 | Theodore Deutch D000610 | rep | FL | 2011-01-05 | 2013-01-03 | Democrat | 19 | http://deutch.house.gov/ | 1024 Longworth HOB; Washington DC 20515-0919 | 202-225-3001 | 202-225-5974 | https://teddeutch.house.gov/Forms/WriteYourRep/default.aspx | 1024 Longworth House Office Building | |||||||
40501 | 40501 | Bob Dold D000613 | rep | IL | 2011-01-05 | 2013-01-03 | Republican | 10 | http://dold.house.gov/ | 212 Cannon HOB; Washington DC 20515-1310 | 202-225-4835 | 202-225-0837 | 212 Cannon House Office Building | ||||||||
40290 | 40290 | Donna Edwards E000290 | rep | MD | 2011-01-05 | 2013-01-03 | Democrat | 4 | http://donnaedwards.house.gov/ | 318 Cannon HOB; Washington DC 20515-2004 | 202-225-8699 | 202-225-8714 | http://www.house.gov/writerep | 318 Cannon House Office Building | |||||||
40774 | 40774 | Joe Donnelly D000607 | rep | IN | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://donnelly.house.gov | 1530 Longworth HOB; Washington DC 20515-1402 | 202-225-3915 | 202-225-6798 | http://donnelly.house.gov/issue_subscribe.shtml | 1530 Longworth House Office Building | |||||||
41683 | 41683 | Don Young Y000033 | rep | AK | 2011-01-05 | 2013-01-03 | Republican | 0 | http://donyoung.house.gov | 2314 Rayburn HOB; Washington DC 20515-0201 | 202-225-5765 | 202-225-0425 | http://donyoung.house.gov/Contact/ | 2314 Rayburn House Office Building | |||||||
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 | |||||||
41187 | 41187 | Sean Duffy D000614 | rep | WI | 2011-01-05 | 2013-01-03 | Republican | 7 | http://duffy.house.gov/ | 1208 Longworth HOB; Washington DC 20515-4907 | 202-225-3365 | 1208 Longworth House Office Building |
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);