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 caucus
This data as json, copyable, CSV (advanced)
Suggested facets: state, party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||
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 | |||||||
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 | |||||||
39054 | 39054 | Kay Hutchison H001016 | sen | TX | 2007-01-04 | 2013-01-03 | 1 | Republican | http://hutchison.senate.gov/ | 284 RUSSELL SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-5922 | 202-224-0776 | http://www.hutchison.senate.gov/?p=email_kay | 284 Russell Senate Office Building | |||||||
39058 | 39058 | Herbert Kohl K000305 | sen | WI | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://kohl.senate.gov/ | 330 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-5653 | 202-224-9787 | http://www.kohl.senate.gov/contact.cfm | 330 Hart Senate Office Building | |||||||
39062 | 39062 | Joseph Lieberman L000304 | sen | CT | 2007-01-04 | 2013-01-03 | 1 | Independent | http://lieberman.senate.gov/ | 706 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-4041 | 202-224-9750 | http://www.lieberman.senate.gov/index.cfm/contact/email-me-about-an-issue | 706 Hart Senate Office Building | |||||||
39068 | 39068 | Richard Lugar L000504 | sen | IN | 2007-01-04 | 2013-01-03 | 1 | Republican | http://lugar.senate.gov/ | 306 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-4814 | 202-228-0360 | http://www.lugar.senate.gov/contact/ | 306 Hart Senate 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 | |||||||
39081 | 39081 | Olympia Snowe S000663 | sen | ME | 2007-01-04 | 2013-01-03 | 1 | Republican | http://snowe.senate.gov/ | 154 RUSSELL SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-5344 | 202-224-1946 | http://www.snowe.senate.gov/public/index.cfm/contact?p=email | 154 Russell Senate Office Building | |||||||
39082 | 39082 | Jim Webb W000803 | sen | VA | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://webb.senate.gov/ | 248 RUSSELL SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-4024 | 202-228-6363 | http://www.webb.senate.gov/contact.cfm | 248 Russell Senate Office Building | |||||||
39083 | 39083 | Scott Brown B001268 | sen | MA | 2010-02-04 | 2013-01-03 | 1 | Republican | http://scottbrown.senate.gov | 359 DIRKSEN SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-4543 | http://www.scottbrown.senate.gov/public/index.cfm/emailscottbrown | 359 Dirksen Senate 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 | ||||||||
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 | |||||||
39581 | 39581 | Kathleen Hochul H001062 | rep | NY | 2011-06-01 | 2013-01-03 | Democrat | 26 | http://hochul.house.gov/ | 1711 Longworth HOB; Washington DC 20515-3226 | 202-225-5265 | 1711 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 | |||||||
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 | |||||||||
39596 | 39596 | Jo Ann Emerson E000172 | rep | MO | 2011-01-05 | 2013-01-03 | Republican | 8 | http://www.house.gov/emerson | 2230 Rayburn HOB; Washington DC 20515-2508 | 202-225-4404 | 202-226-0326 | http://www.house.gov/emerson/contact/ | 2230 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 | |||||||
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 | |||||||
39642 | 39642 | C. Young Y000031 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 10 | http://www.house.gov/young | 2407 Rayburn HOB; Washington DC 20515-0910 | 202-225-5961 | 202-225-9764 | http://www.house.gov/writerep | 2407 Rayburn House Office Building | |||||||
39654 | 39654 | Melvin Watt W000207 | rep | NC | 2011-01-05 | 2013-01-03 | Democrat | 12 | http://www.house.gov/watt | 2304 Rayburn HOB; Washington DC 20515-3312 | 202-225-1510 | 202-225-1512 | http://www.house.gov/formwatt/IMA/issue_subscribe.htm | 2304 Rayburn House Office Building | |||||||
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 | ||||||||
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 | |||||||
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 | |||||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||||
39827 | 39827 | John Dingell D000355 | rep | MI | 2011-01-05 | 2013-01-03 | Democrat | 15 | http://www.house.gov/dingell | 2328 Rayburn HOB; Washington DC 20515-2215 | 202-225-4071 | 202-226-0371 | https://forms.house.gov/wyr/welcome.shtml | 2328 Rayburn House Office Building | |||||||
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 |
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);