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 office
This data as json, copyable, CSV (advanced)
Suggested facets: type, state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||
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 | |||||||||
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 | |||||||
40536 | 40536 | Mick Mulvaney M001182 | rep | SC | 2011-01-05 | 2013-01-03 | Republican | 5 | http://mulvaney.house.gov/ | 1004 Longworth HOB; Washington DC 20515-4005 | 202-225-5501 | 202-225-0464 | 1004 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 | |||||||
41646 | 41646 | Steve Stivers S001187 | rep | OH | 2011-01-05 | 2013-01-03 | Republican | 15 | http://stivers.house.gov/ | 1007 Longworth HOB; Washington DC 20515-3515 | 202-225-2015 | 202-225-3529 | 1007 Longworth 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 | |||||||
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 | |||||||
41656 | 41656 | Devin Nunes N000181 | rep | CA | 2011-01-05 | 2013-01-03 | Republican | 21 | http://nunes.house.gov | 1013 Longworth HOB; Washington DC 20515-0521 | 202-225-2523 | 202-225-3404 | http://www.nunes.house.gov/index.cfm?FuseAction=ContactUs.ContactForm | 1013 Longworth House Office Building | |||||||
41623 | 41623 | Marcia Fudge F000455 | rep | OH | 2011-01-05 | 2013-01-03 | Democrat | 11 | http://fudge.house.gov/ | 1019 Longworth HOB; Washington DC 20515-3511 | 202-225-7032 | 202-225-1339 | https://forms.house.gov/fudge/contact-form.shtml | 1019 Longworth House Office Building | |||||||
40730 | 40730 | Robert Brady B001227 | rep | PA | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://www.brady.house.gov | 102 Cannon HOB; Washington DC 20515-3801 | 202-225-4731 | 202-225-0088 | http://www.house.gov/formrobertbrady/issue.htm | 102 Cannon House Office Building | |||||||
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 | |||||||
42493 | 42493 | Vicky Hartzler H001053 | rep | MO | 2011-01-05 | 2013-01-03 | Republican | 4 | http://hartzler.house.gov/ | 1023 Longworth HOB; Washington DC 20515-2504 | 202-225-2876 | 202-225-2695 | 1023 Longworth 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 | |||||||
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 | |||||||
40794 | 40794 | Keith Ellison E000288 | rep | MN | 2011-01-05 | 2013-01-03 | Democrat | 5 | http://ellison.house.gov | 1027 Longworth HOB; Washington DC 20515-2305 | 202-225-4755 | 202-225-4886 | http://ellison.house.gov/index.php?option=com_content&task=view&id=87 | 1027 Longworth 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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
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 | |||||||
40393 | 40393 | Jim McDermott M000404 | rep | WA | 2011-01-05 | 2013-01-03 | Democrat | 7 | http://www.house.gov/mcdermott | 1035 Longworth HOB; Washington DC 20515-4707 | 202-225-3106 | 202-225-6197 | http://www.house.gov/mcdermott/contact.shtml | 1035 Longworth House Office Building | |||||||
41704 | 41704 | Tom Reed R000585 | rep | NY | 2011-01-05 | 2013-01-03 | Republican | 29 | http://reed.house.gov/ | 1037 Longworth HOB; Washington DC 20515-3229 | 202-225-3161 | 202-226-6599 | 1037 Longworth House Office Building | ||||||||
43585 | 43585 | Daniel Webster W000806 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 8 | http://webster.house.gov/ | 1039 Longworth HOB; Washington DC 20515-0908 | 202-225-2176 | 202-225-0999 | 1039 Longworth 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 | |||||||
40677 | 40677 | Orrin Hatch H000338 | sen | UT | 2007-01-04 | 2013-01-03 | 1 | Republican | http://hatch.senate.gov/ | 104 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-5251 | 202-224-6331 | http://www.hatch.senate.gov/public/index.cfm/contact?p=Email-Orrin | 104 Hart Senate Office Building | |||||||
40598 | 40598 | Patrick Tiberi T000462 | rep | OH | 2011-01-05 | 2013-01-03 | Republican | 12 | http://tiberi.house.gov | 106 Cannon HOB; Washington DC 20515-3512 | 202-225-5355 | 202-226-4523 | http://www.house.gov/writerep | 106 Cannon House Office Building | |||||||
40508 | 40508 | Mike Pompeo P000602 | rep | KS | 2011-01-05 | 2013-01-03 | Republican | 4 | http://pompeo.house.gov/ | 107 Cannon HOB; Washington DC 20515-1604 | 202-225-6216 | 202-225-3489 | 107 Cannon House Office Building | ||||||||
42691 | 42691 | Rick Larsen L000560 | rep | WA | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://www.house.gov/larsen | 108 Cannon HOB; Washington DC 20515-4702 | 202-225-2605 | 202-225-4420 | http://www.house.gov/larsen/contact/ | 108 Cannon House Office Building | |||||||
42676 | 42676 | James Langevin L000559 | rep | RI | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://www.house.gov/langevin | 109 Cannon HOB; Washington DC 20515-3902 | 202-225-2735 | 202-225-5976 | http://langevin.house.gov/comments.shtml | 109 Cannon House Office Building | |||||||
42464 | 42464 | H. Griffith G000568 | rep | VA | 2011-01-05 | 2013-01-03 | Republican | 9 | http://morgangriffith.house.gov/ | 1108 Longworth HOB; Washington DC 20515-4609 | 202-225-3861 | 202-225-0076 | 1108 Longworth House Office Building | ||||||||
41408 | 41408 | Kenny Marchant M001158 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 24 | http://www.house.gov/marchant | 1110 Longworth HOB; Washington DC 20515-4324 | 202-225-6605 | 202-225-0074 | http://marchant.house.gov/emailkenny.shtml | 1110 Longworth 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 | |||||||
41247 | 41247 | Tom Graves G000560 | rep | GA | 2011-01-05 | 2013-01-03 | Republican | 9 | http://tomgraves.house.gov/ | 1113 Longworth HOB; Washington DC 20515-1010 | 202-225-5211 | 202-225-8272 | http://tomgraves.house.gov/contact/ | 1113 Longworth House Office Building | |||||||
40474 | 40474 | Loretta Sanchez S000030 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 47 | http://www.lorettasanchez.house.gov | 1114 Longworth HOB; Washington DC 20515-0547 | 202-225-2965 | 202-225-5859 | http://www.lorettasanchez.house.gov/index.php?option=com_content&task=view&id=218&Itemid=17 | 1114 Longworth House Office Building | |||||||
40308 | 40308 | Stephen Fincher F000458 | rep | TN | 2011-01-05 | 2013-01-03 | Republican | 8 | http://fincher.house.gov/ | 1118 Longworth HOB; Washington DC 20515-4208 | 202-225-4714 | 202-225-1765 | 1118 Longworth House Office Building | ||||||||
43673 | 43673 | Thomas Massie M001184 | rep | KY | 2012-11-13 | 2013-01-03 | Republican | 4 | http://massie.house.gov | 1119 Longworth HOB; Washington DC 20515-1704 | 202-225-3465 | 1119 Longworth House Office Building | |||||||||
40878 | 40878 | Lynn Jenkins J000290 | rep | KS | 2011-01-05 | 2013-01-03 | Republican | 2 | http://lynnjenkins.house.gov | 1122 Longworth HOB; Washington DC 20515-1602 | 202-225-6601 | 202-225-7986 | https://forms.house.gov/lynnjenkins/contact-form.shtml | 1122 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 | ||||||||
43144 | 43144 | Mike Quigley Q000023 | rep | IL | 2011-01-05 | 2013-01-03 | Democrat | 5 | http://quigley.house.gov/ | 1124 Longworth HOB; Washington DC 20515-1305 | 202-225-4061 | 202-225-5603 | https://forms.house.gov/quigley/contact-form.shtml | 1124 Longworth House Office Building | |||||||
40305 | 40305 | Sam Farr F000030 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 17 | http://www.house.gov/farr | 1126 Longworth HOB; Washington DC 20515-0517 | 202-225-2861 | 202-225-6791 | http://www.farr.house.gov/index.php?option=com_content&task=view&id=202 | 1126 Longworth 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 | |||||||
44441 | 44441 | Cynthia Lummis L000571 | rep | WY | 2011-01-05 | 2013-01-03 | Republican | 0 | http://lummis.house.gov | 113 Cannon HOB; Washington DC 20515-5001 | 202-225-2311 | 202-225-3057 | https://forms.house.gov/lummis/contact-form.shtml | 113 Cannon House Office Building | |||||||
42503 | 42503 | Jaime Herrera Beutler H001056 | rep | WA | 2011-01-05 | 2013-01-03 | Republican | 3 | http://herrerabeutler.house.gov/ | 1130 Longworth HOB; Washington DC 20515-4703 | 202-225-3536 | 202-225-3478 | 1130 Longworth House Office Building | ||||||||
41369 | 41369 | Steve King K000362 | rep | IA | 2011-01-05 | 2013-01-03 | Republican | 5 | http://www.house.gov/steveking | 1131 Longworth HOB; Washington DC 20515-1505 | 202-225-4426 | 202-225-3193 | http://www.house.gov/steveking/email.shtm | 1131 Longworth House Office Building | |||||||
43340 | 43340 | Terri Sewell S001185 | rep | AL | 2011-01-05 | 2013-01-03 | Democrat | 7 | http://sewell.house.gov/ | 1133 Longworth HOB; Washington DC 20515-0107 | 202-225-2665 | 202-226-9567 | 1133 Longworth 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 | ||||||||
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 | |||||||
42357 | 42357 | Jeff Duncan D000615 | rep | SC | 2011-01-05 | 2013-01-03 | Republican | 3 | http://jeffduncan.house.gov/ | 116 Cannon HOB; Washington DC 20515-4003 | 202-225-5301 | 202-225-3216 | 116 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 | |||||||
43563 | 43563 | Debbie Wasserman Schultz W000797 | rep | FL | 2011-01-05 | 2013-01-03 | Democrat | 20 | http://www.house.gov/schultz | 118 Cannon HOB; Washington DC 20515-0920 | 202-225-7931 | 202-225-2052 | http://wassermanschultz.house.gov/zipauth.htm | 118 Cannon House Office Building | |||||||
42519 | 42519 | James Himes H001047 | rep | CT | 2011-01-05 | 2013-01-03 | Democrat | 4 | http://himes.house.gov | 119 Cannon HOB; Washington DC 20515-0704 | 202-225-5541 | 202-225-9629 | https://forms.house.gov/himes/contact-form.shtml | 119 Cannon House Office Building | |||||||
43120 | 43120 | Bill Posey P000599 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 15 | http://posey.house.gov | 120 Cannon HOB; Washington DC 20515-0915 | 202-225-3671 | 202-225-3516 | http://posey.house.gov/Contact/ | 120 Cannon House Office Building | |||||||
43330 | 43330 | Robert Scott S000185 | rep | VA | 2011-01-05 | 2013-01-03 | Democrat | 3 | http://www.house.gov/scott | 1201 Longworth HOB; Washington DC 20515-4603 | 202-225-8351 | 202-225-8354 | http://www.house.gov/writerep | 1201 Longworth House Office Building | |||||||
39881 | 39881 | Doc Hastings H000329 | rep | WA | 2011-01-05 | 2013-01-03 | Republican | 4 | http://hastings.house.gov | 1203 Longworth HOB; Washington DC 20515-4704 | 202-225-5816 | 202-225-3251 | http://hastings.house.gov/ContactForm.aspx | 1203 Longworth House Office Building | |||||||
43299 | 43299 | David Schweikert S001183 | rep | AZ | 2011-01-05 | 2013-01-03 | Republican | 5 | http://schweikert.house.gov/ | 1205 Longworth HOB; Washington DC 20515-0305 | 202-225-2190 | 1205 Longworth 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 | |||||||
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 | |||||||||
42921 | 42921 | Jerry McNerney M001166 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 11 | http://mcnerney.house.gov | 1210 Longworth HOB; Washington DC 20515-0511 | 202-225-1947 | 202-225-4060 | http://mcnerney.house.gov/contact.shtml | 1210 Longworth House Office Building | |||||||
40892 | 40892 | Sam Johnson J000174 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 3 | http://www.house.gov/samjohnson | 1211 Longworth HOB; Washington DC 20515-4303 | 202-225-4201 | 202-225-1485 | http://www.house.gov/formsamjohnson/IMA/issue.htm | 1211 Longworth House Office Building | |||||||
40426 | 40426 | Pedro Pierluisi P000596 | rep | PR | 2009-01-06 | 2013-01-03 | Democrat | 0 | http://pierluisi.house.gov | 1213 Longworth HOB; Washington DC 20515-5401 | 202-225-2615 | 202-225-2154 | https://forms.house.gov/pierluisi/contact-form.shtml | 1213 Longworth House Office Building | |||||||
39889 | 39889 | Rush Holt H001032 | rep | NJ | 2011-01-05 | 2013-01-03 | Democrat | 12 | http://holt.house.gov | 1214 Longworth HOB; Washington DC 20515-3012 | 202-225-5801 | 202-225-6025 | http://www.holt.house.gov/contact.shtml | 1214 Longworth House Office Building | |||||||
42553 | 42553 | Bill Huizenga H001058 | rep | MI | 2011-01-05 | 2013-01-03 | Republican | 2 | http://huizenga.house.gov/ | 1217 Longworth HOB; Washington DC 20515-2202 | 202-225-4401 | 202-226-0779 | 1217 Longworth House Office Building | ||||||||
42657 | 42657 | Adam Kinzinger K000378 | rep | IL | 2011-01-05 | 2013-01-03 | Republican | 11 | http://kinzinger.house.gov/ | 1218 Longworth HOB; Washington DC 20515-1311 | 202-225-3635 | 202-225-3521 | 1218 Longworth House Office Building | ||||||||
43092 | 43092 | Ed Perlmutter P000593 | rep | CO | 2011-01-05 | 2013-01-03 | Democrat | 7 | http://perlmutter.house.gov | 1221 Longworth HOB; Washington DC 20515-0607 | 202-225-2645 | 202-225-5278 | http://perlmutter.house.gov/IMA/issue_subscribe.htm | 1221 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 | |||||||
40503 | 40503 | Frank Guinta G000570 | rep | NH | 2011-01-05 | 2013-01-03 | Republican | 1 | http://guinta.house.gov/ | 1223 Longworth HOB; Washington DC 20515-2901 | 202-225-5456 | 202-225-5822 | 1223 Longworth House Office Building | ||||||||
40312 | 40312 | Michael Fitzpatrick F000451 | rep | PA | 2011-01-05 | 2013-01-03 | Republican | 8 | http://fitzpatrick.house.gov/ | 1224 Longworth HOB; Washington DC 20515-3808 | 202-225-4276 | 202- 225-9511 | 1224 Longworth 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 | |||||||
40058 | 40058 | Allyson Schwartz S001162 | rep | PA | 2011-01-05 | 2013-01-03 | Democrat | 13 | http://www.house.gov/schwartz | 1227 Longworth HOB; Washington DC 20515-3813 | 202-225-6111 | 202-226-0611 | http://schwartz.house.gov/serving-you/email-me | 1227 Longworth House Office Building | |||||||
40060 | 40060 | Steve Southerland S001186 | rep | FL | 2011-01-05 | 2013-01-03 | Republican | 2 | http://southerland.house.gov/ | 1229 Longworth HOB; Washington DC 20515-0902 | 202-225-5235 | 202-225-5615 | 1229 Longworth House Office Building | ||||||||
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 | |||||||
42387 | 42387 | Virginia Foxx F000450 | rep | NC | 2011-01-05 | 2013-01-03 | Republican | 5 | http://foxx.house.gov | 1230 Longworth HOB; Washington DC 20515-3305 | 202-225-2071 | 202-225-2995 | http://www.house.gov/formfoxx/IMA/issue_subscribe.htm | 1230 Longworth House Office Building | |||||||
39854 | 39854 | Tim Griffin G000567 | rep | AR | 2011-01-05 | 2013-01-03 | Republican | 2 | http://griffin.house.gov/ | 1232 Longworth HOB; Washington DC 20515-0402 | 202-225-2506 | 202-225-5903 | 1232 Longworth House Office Building | ||||||||
41042 | 41042 | Paul Ryan R000570 | rep | WI | 2011-01-05 | 2013-01-03 | Republican | 1 | http://www.house.gov/ryan | 1233 Longworth HOB; Washington DC 20515-4901 | 202-225-3031 | 202-225-3393 | http://www.house.gov/ryan/email.htm | 1233 Longworth House Office Building | |||||||
40919 | 40919 | Sander Levin L000263 | rep | MI | 2011-01-05 | 2013-01-03 | Democrat | 12 | http://www.house.gov/levin | 1236 Longworth HOB; Washington DC 20515-2212 | 202-225-4961 | 202-226-1033 | http://www.house.gov/levin/levin_contact_email.shtml | 1236 Longworth House Office Building | |||||||
40830 | 40830 | Trey Gowdy G000566 | rep | SC | 2011-01-05 | 2013-01-03 | Republican | 4 | http://gowdy.house.gov/ | 1237 Longworth HOB; Washington DC 20515-4004 | 202-225-6030 | 202-226-1177 | 1237 Longworth House Office Building | ||||||||
40053 | 40053 | Jon Runyan R000594 | rep | NJ | 2011-01-05 | 2013-01-03 | Republican | 3 | http://runyan.house.gov/ | 1239 Longworth HOB; Washington DC 20515-3003 | 202-225-4765 | 202-225-0778 | 1239 Longworth House Office Building | ||||||||
43478 | 43478 | Glenn Thompson T000467 | rep | PA | 2011-01-05 | 2013-01-03 | Republican | 5 | http://thompson.house.gov | 124 Cannon HOB; Washington DC 20515-3805 | 202-225-5121 | 202-225-5796 | https://forms.house.gov/thompson/contact-form.shtml | 124 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 | |||||||
40361 | 40361 | Tim Huelskamp H001057 | rep | KS | 2011-01-05 | 2013-01-03 | Republican | 1 | http://huelskamp.house.gov/ | 126 Cannon HOB; Washington DC 20515-1601 | 202-225-2715 | 202- 225-5124 | 126 Cannon House Office Building | ||||||||
40940 | 40940 | Erik Paulsen P000594 | rep | MN | 2011-01-05 | 2013-01-03 | Republican | 3 | http://paulsen.house.gov | 127 Cannon HOB; Washington DC 20515-2303 | 202-225-2871 | 202-225-6351 | https://forms.house.gov/paulsen/contact-form.shtml | 127 Cannon 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 | ||||||||
40869 | 40869 | Jeb Hensarling H001036 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 5 | http://www.house.gov/hensarling | 129 Cannon HOB; Washington DC 20515-4305 | 202-225-3484 | 202-226-4888 | http://www.house.gov/hensarling/contact_web.shtml | 129 Cannon House Office Building | |||||||
40970 | 40970 | James Renacci R000586 | rep | OH | 2011-01-05 | 2013-01-03 | Republican | 16 | http://renacci.house.gov/ | 130 Cannon HOB; Washington DC 20515-3516 | 202-225-3876 | 202-225-3059 | 130 Cannon House Office Building | ||||||||
42858 | 42858 | Michael McCaul M001157 | rep | TX | 2011-01-05 | 2013-01-03 | Republican | 10 | http://www.house.gov/mccaul | 131 Cannon HOB; Washington DC 20515-4310 | 202-225-2401 | 202-225-5955 | http://www.house.gov/writerep | 131 Cannon 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 | |||||||
43618 | 43618 | Robert Wittman W000804 | rep | VA | 2011-01-05 | 2013-01-03 | Republican | 1 | http://www.wittman.house.gov/ | 1317 Longworth HOB; Washington DC 20515-4601 | 202-225-4261 | 202-225-4382 | https://forms.house.gov/wittman/IMA/webforms/issue_subscribe.htm | 1317 Longworth House Office Building | |||||||
43104 | 43104 | Chellie Pingree P000597 | rep | ME | 2011-01-05 | 2013-01-03 | Democrat | 1 | http://pingree.house.gov | 1318 Longworth HOB; Washington DC 20515-1901 | 202-225-6116 | 202-225-5590 | https://forms.house.gov/pingree/contact-form.shtml | 1318 Longworth House Office Building | |||||||
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 | ||||||||
40340 | 40340 | Joseph Heck H001055 | rep | NV | 2011-01-05 | 2013-01-03 | Republican | 3 | http://heck.house.gov/ | 132 Cannon HOB; Washington DC 20515-2803 | 202-225-3252 | 202- 225-2185 | 132 Cannon House Office Building | ||||||||
42711 | 42711 | Robert Latta L000566 | rep | OH | 2011-01-05 | 2013-01-03 | Republican | 5 | http://latta.house.gov/ | 1323 Longworth HOB; Washington DC 20515-3505 | 202-225-6405 | 202-225-1985 | http://latta.house.gov/contactform_zipcheck.shtml | 1323 Longworth House Office Building | |||||||
40051 | 40051 | Mike Rogers R000572 | rep | MI | 2011-01-05 | 2013-01-03 | Republican | 8 | http://www.house.gov/mikerogers | 133 Cannon HOB; Washington DC 20515-2208 | 202-225-4872 | 202-225-5820 | http://www.mikerogers.house.gov/Contact.aspx | 133 Cannon House Office Building | |||||||
41804 | 41804 | Debbie Stabenow S000770 | sen | MI | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://stabenow.senate.gov/ | 133 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-4822 | 202-228-0325 | http://www.stabenow.senate.gov/?p=contact | 133 Hart Senate 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 | |||||||
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 | ||||||||
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 | |||||||
42748 | 42748 | Zoe Lofgren L000397 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 16 | http://www.house.gov/lofgren | 1401 Longworth HOB; Washington DC 20515-0516 | 202-225-3072 | 202-225-3336 | http://lofgren.house.gov/emailform.shtml | 1401 Longworth House Office Building | |||||||
43593 | 43593 | Peter Welch W000800 | rep | VT | 2011-01-05 | 2013-01-03 | Democrat | 0 | http://welch.house.gov | 1404 Longworth HOB; Washington DC 20515-4501 | 202-225-4115 | 202-225-6790 | http://www.house.gov/formwelch/issue_subscribe.htm | 1404 Longworth House Office Building | |||||||
42651 | 42651 | Ron Kind K000188 | rep | WI | 2011-01-05 | 2013-01-03 | Democrat | 3 | http://www.house.gov/kind | 1406 Longworth HOB; Washington DC 20515-4903 | 202-225-5506 | 202-225-5739 | http://www.house.gov/kind/contact.shtml | 1406 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);