legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
473 rows where "end" is on date 2017-01-03
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40949 | 40949 | Stevan Pearce P000588 | rep | NM | 2015-01-06 | 2017-01-03 | Republican | 2 | http://pearce.house.gov | 2432 Rayburn HOB; Washington DC 20515-3102 | 202-225-2365 | https://pearce.house.gov/contact-me/email-me | 2432 Rayburn House Office Building | http://pearce.house.gov/rss.xml | |||||||
40956 | 40956 | Ted Poe P000592 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 2 | https://poe.house.gov | 2412 Rayburn HOB; Washington DC 20515-4302 | 202-225-6565 | 202-225-5547 | https://poe.house.gov/index.cfm/contact-form#form_D05B44B5-B782-4DC7-BED6-FF0C90951FFF | 2412 Rayburn House Office Building | http://poe.house.gov/index.php?format=feed&type=rss | ||||||
40961 | 40961 | Jared Polis P000598 | rep | CO | 2015-01-06 | 2017-01-03 | Democrat | 2 | http://polis.house.gov | 1433 Longworth HOB; Washington DC 20515-0602 | 202-225-2161 | 202-226-7840 | https://polis.house.gov/forms/writeyourrep/default.aspx | 1433 Longworth House Office Building | http://polis.house.gov/news/rss.aspx | ||||||
40968 | 40968 | David Reichert R000578 | rep | WA | 2015-01-06 | 2017-01-03 | Republican | 8 | http://reichert.house.gov | 1127 Longworth HOB; Washington DC 20515-4708 | 202-225-7761 | 202-225-4282 | https://reichert.house.gov/contact-me | 1127 Longworth House Office Building | http://reichert.house.gov/rss.xml | ||||||
40972 | 40972 | James Renacci R000586 | rep | OH | 2015-01-06 | 2017-01-03 | Republican | 16 | https://renacci.house.gov | 328 Cannon HOB; Washington DC 20515-3516 | 202-225-3876 | 202-225-3059 | https://renacci.house.gov/index.cfm/contact-form | 328 Cannon House Office Building | http://renacci.house.gov/common/rss//index.cfm?rss=25 | ||||||
40987 | 40987 | Dana Rohrabacher R000409 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 48 | http://rohrabacher.house.gov | 2300 Rayburn HOB; Washington DC 20515-0548 | 202-225-2415 | 202-225-0145 | https://rohrabacher.house.gov/contact/email-me | 2300 Rayburn House Office Building | http://rohrabacher.house.gov/rss.xml | ||||||
40991 | 40991 | Todd Rokita R000592 | rep | IN | 2015-01-06 | 2017-01-03 | Republican | 4 | http://rokita.house.gov | 1717 Longworth HOB; Washington DC 20515-1404 | 202-225-5037 | 202-226-0544 | https://rokita.house.gov/contact-me | 1717 Longworth House Office Building | http://rokita.house.gov/rss.xml | ||||||
40996 | 40996 | Thomas Rooney R000583 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 17 | https://rooney.house.gov | 2160 Rayburn HOB; Washington DC 20515-0917 | 202-225-5792 | 202-225-3132 | https://rooney.house.gov/email-me | 2160 Rayburn House Office Building | http://rooney.house.gov/index.php?format=feed&type=rss | ||||||
41011 | 41011 | Ileana Ros-Lehtinen R000435 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 27 | http://ros-lehtinen.house.gov | 2206 Rayburn HOB; Washington DC 20515-0927 | 202-225-3931 | 202-225-5620 | https://ros-lehtinen.house.gov/contact-me/email-me | 2206 Rayburn House Office Building | http://ros-lehtinen.house.gov/rss.xml | ||||||
41017 | 41017 | Peter Roskam R000580 | rep | IL | 2015-01-06 | 2017-01-03 | Republican | 6 | http://roskam.house.gov | 2246 Rayburn HOB; Washington DC 20515-1306 | 202-225-4561 | 202-225-1166 | https://roskam.house.gov/contact/email-me | 2246 Rayburn House Office Building | http://roskam.house.gov/index.php?format=feed&type=rss | ||||||
41021 | 41021 | Dennis Ross R000593 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 15 | http://dennisross.house.gov | 229 Cannon HOB; Washington DC 20515-0915 | 202-225-1252 | 202-226-0585 | https://dennisross.house.gov/forms/writeyourrep/ | 229 Cannon House Office Building | http://dennisross.house.gov/news/rss.aspx | ||||||
41034 | 41034 | Edward Royce R000487 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 39 | http://royce.house.gov | 2310 Rayburn HOB; Washington DC 20515-0539 | 202-225-4111 | 202-226-0335 | https://royce.house.gov/contact/contactform.htm | 2310 Rayburn House Office Building | http://royce.house.gov/news/rss.aspx | ||||||
41044 | 41044 | Paul Ryan R000570 | rep | WI | 2015-01-06 | 2017-01-03 | Republican | 1 | http://paulryan.house.gov | 1233 Longworth HOB; Washington DC 20515-4901 | 202-225-3031 | 202-225-3393 | https://paulryan.house.gov/contact/email.htm#.U032ra1dU_d | 1233 Longworth House Office Building | http://paulryan.house.gov/news/rss.aspx | ||||||
41053 | 41053 | Bill Shuster S001154 | rep | PA | 2015-01-06 | 2017-01-03 | Republican | 9 | http://shuster.house.gov | 2268 Rayburn HOB; Washington DC 20515-3809 | 202-225-2431 | 202-225-2486 | http://shuster.house.gov/contact-form/ | 2268 Rayburn House Office Building | http://shuster.house.gov/common/rss//index.cfm?rss=49 | ||||||
41069 | 41069 | Lamar Smith S000583 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 21 | http://lamarsmith.house.gov | 2409 Rayburn HOB; Washington DC 20515-4321 | 202-225-4236 | 202-225-8628 | http://lamarsmith.house.gov/contact/email-lamar | 2409 Rayburn House Office Building | http://lamarsmith.house.gov/news/rss.aspx | ||||||
41075 | 41075 | Niki Tsongas T000465 | rep | MA | 2015-01-06 | 2017-01-03 | Democrat | 3 | http://tsongas.house.gov | 1714 Longworth HOB; Washington DC 20515-2103 | 202-225-3411 | 202-226-0771 | https://tsongas.house.gov/e-mail-niki/ | 1714 Longworth House Office Building | http://tsongas.house.gov/rss/press-releases.xml | ||||||
41081 | 41081 | Timothy Walz W000799 | rep | MN | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://walz.house.gov | 1034 Longworth HOB; Washington DC 20515-2301 | 202-225-2472 | 202-225-3433 | http://walz.house.gov/contact | 1034 Longworth House Office Building | http://walz.house.gov/index.php?format=feed&type=rss | ||||||
41085 | 41085 | Kevin Yoder Y000063 | rep | KS | 2015-01-06 | 2017-01-03 | Republican | 3 | http://yoder.house.gov | 215 Cannon HOB; Washington DC 20515-1603 | 202-225-2865 | 202-225-2807 | https://yoder.house.gov/contact/email-me | 215 Cannon House Office Building | http://yoder.house.gov/common/rss/index.cfm?rss=49 | ||||||
41093 | 41093 | Elizabeth Esty E000293 | rep | CT | 2015-01-06 | 2017-01-03 | Democrat | 5 | http://esty.house.gov | 405 Cannon HOB; Washington DC 20515-0705 | 202-225-4476 | 202-225-5933 | http://esty.house.gov/contact | 405 Cannon House Office Building | http://esty.house.gov/rss.xml | ||||||
41096 | 41096 | Luke Messer M001189 | rep | IN | 2015-01-06 | 2017-01-03 | Republican | 6 | https://messer.house.gov | 508 Cannon HOB; Washington DC 20515-1406 | 202-225-3021 | 765-747-5586 | https://messer.house.gov/contact/email-me | 508 Cannon House Office Building | http://messer.house.gov/rss.xml | ||||||
41099 | 41099 | John Delaney D000620 | rep | MD | 2015-01-06 | 2017-01-03 | Democrat | 6 | http://delaney.house.gov | 1632 Longworth HOB; Washington DC 20515-2006 | 202-225-2721 | 202-225-2193 | https://delaney.house.gov/contact/email-me | 1632 Longworth House Office Building | http://delaney.house.gov/rss.xml | ||||||
41105 | 41105 | Richard Nolan N000127 | rep | MN | 2015-01-06 | 2017-01-03 | Democrat | 8 | http://nolan.house.gov | 2366 Rayburn HOB; Washington DC 20515-2308 | 202-225-6211 | 202-225-0699 | https://nolan.house.gov/contact/email-me | 2366 Rayburn House Office Building | http://nolan.house.gov/rss.xml | ||||||
41108 | 41108 | Robert Pittenger P000606 | rep | NC | 2015-01-06 | 2017-01-03 | Republican | 9 | http://pittenger.house.gov | 224 Cannon HOB; Washington DC 20515-3309 | 202-225-1976 | 202-225-3389 | https://pittenger.house.gov/contact/email-me | 224 Cannon House Office Building | http://pittenger.house.gov/rss.xml | ||||||
41112 | 41112 | Keith Rothfus R000598 | rep | PA | 2015-01-06 | 2017-01-03 | Republican | 12 | https://rothfus.house.gov | 1205 Longworth HOB; Washington DC 20515-3812 | 202-225-2065 | 202-225-5709 | https://rothfus.house.gov/email-keith | 1205 Longworth House Office Building | http://rothfus.house.gov/rss.xml | ||||||
41115 | 41115 | Beto O’Rourke O000170 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 16 | http://orourke.house.gov | 1330 Longworth HOB; Washington DC 20515-4316 | 202-225-4831 | https://orourkeforms.house.gov/forms/writeyourrep/ | 1330 Longworth House Office Building | http://orourke.house.gov/rss.xml | |||||||
41121 | 41121 | Marshall Sanford S000051 | rep | SC | 2015-01-06 | 2017-01-03 | Republican | 1 | http://sanford.house.gov | 2201 Rayburn HOB; Washington DC 20515-4001 | 202-225-3176 | 843-521-2535 | https://sanford.house.gov/contact/email-me | 2201 Rayburn House Office Building | http://sanford.house.gov/rss.xml | ||||||
41124 | 41124 | David Brat B001290 | rep | VA | 2015-01-06 | 2017-01-03 | Republican | 7 | http://brat.house.gov | 330 Cannon HOB; Washington DC 20515-4607 | 202-225-2815 | http://brat.house.gov/contact | 330 Cannon House Office Building | ||||||||
41126 | 41126 | Steve Knight K000387 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 25 | https://knight.house.gov | 1023 Longworth HOB; Washington DC 20515-0525 | 202-225-1956 | 202-226-0683 | 1023 Longworth House Office Building | ||||||||
41128 | 41128 | Mimi Walters W000820 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 45 | https://walters.house.gov | 236 Cannon HOB; Washington DC 20515-0545 | 202-225-5611 | 202-225-9177 | 236 Cannon House Office Building | ||||||||
41130 | 41130 | Carlos Curbelo C001107 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 26 | http://curbelo.house.gov | 1429 Longworth HOB; Washington DC 20515-0926 | 202-225-2778 | 1429 Longworth House Office Building | |||||||||
41132 | 41132 | Rod Blum B001294 | rep | IA | 2015-01-06 | 2017-01-03 | Republican | 1 | https://blum.house.gov | 213 Cannon HOB; Washington DC 20515-1501 | 202-225-2911 | 213 Cannon House Office Building | |||||||||
41134 | 41134 | David Young Y000066 | rep | IA | 2015-01-06 | 2017-01-03 | Republican | 3 | https://davidyoung.house.gov | 515 Cannon HOB; Washington DC 20515-1503 | 202-225-5476 | 515 Cannon House Office Building | |||||||||
41136 | 41136 | Bruce Poliquin P000611 | rep | ME | 2015-01-06 | 2017-01-03 | Republican | 2 | https://poliquin.house.gov | 426 Cannon HOB; Washington DC 20515-1902 | 202-225-6306 | 202-225-2943 | 426 Cannon House Office Building | ||||||||
41138 | 41138 | Mike Bishop B001293 | rep | MI | 2015-01-06 | 2017-01-03 | Republican | 8 | https://mikebishop.house.gov | 428 Cannon HOB; Washington DC 20515-2208 | 202-225-4872 | 202-225-5820 | 428 Cannon House Office Building | ||||||||
41140 | 41140 | Dave Trott T000475 | rep | MI | 2015-01-06 | 2017-01-03 | Republican | 11 | https://trott.house.gov | 1722 Longworth HOB; Washington DC 20515-2211 | 202-225-8171 | 1722 Longworth House Office Building | |||||||||
41142 | 41142 | Tom MacArthur M001193 | rep | NJ | 2015-01-06 | 2017-01-03 | Republican | 3 | https://macarthur.house.gov | 506 Cannon HOB; Washington DC 20515-3003 | 202-225-4765 | 202-225-0778 | 506 Cannon House Office Building | ||||||||
41144 | 41144 | Steve Russell R000604 | rep | OK | 2015-01-06 | 2017-01-03 | Republican | 5 | https://russell.house.gov | 128 Cannon HOB; Washington DC 20515-3605 | 202-225-2132 | 202-226-1463 | 128 Cannon House Office Building | ||||||||
41146 | 41146 | Ryan Costello C001106 | rep | PA | 2015-01-06 | 2017-01-03 | Republican | 6 | https://costello.house.gov | 427 Cannon HOB; Washington DC 20515-3806 | 202-225-4315 | 202-225-8440 | 427 Cannon House Office Building | ||||||||
41148 | 41148 | Mia Love L000584 | rep | UT | 2015-01-06 | 2017-01-03 | Republican | 4 | https://love.house.gov | 217 Cannon HOB; Washington DC 20515-4404 | 202-225-3011 | 202-225-5638 | 217 Cannon House Office Building | ||||||||
41150 | 41150 | Barbara Comstock C001105 | rep | VA | 2015-01-06 | 2017-01-03 | Republican | 10 | https://comstock.house.gov | 226 Cannon HOB; Washington DC 20515-4610 | 202-225-5136 | 202-225-0437 | 226 Cannon House Office Building | ||||||||
41152 | 41152 | Daniel Donovan D000625 | rep | NY | 2015-05-12 | 2017-01-03 | Republican | 11 | https://donovan.house.gov | 1725 Longworth HOB; Washington DC 20515-3211 | 202-225-3371 | 1725 Longworth House Office Building | |||||||||
41156 | 41156 | Colleen Hanabusa H001050 | rep | HI | 2016-11-14 | 2017-01-03 | Democrat | 1 | https://hanabusa.house.gov/ | 422 Cannon HOB; Washington DC 20515-1101 | 202-225-2726 | 202-225-0688 | https://hanabusa.house.gov/contact/email | 422 Cannon House Office Building | https://hanabusa.house.gov/rss.xml | ||||||
41171 | 41171 | Tom Marino M001179 | rep | PA | 2015-01-06 | 2017-01-03 | Republican | 10 | http://marino.house.gov | 410 Cannon HOB; Washington DC 20515-3810 | 202-225-3731 | 202-225-9594 | https://marino.house.gov/contact-me/email-me | 410 Cannon House Office Building | http://marino.house.gov/rss.xml | ||||||
41184 | 41184 | Walter Jones J000255 | rep | NC | 2015-01-06 | 2017-01-03 | Republican | 3 | http://jones.house.gov | 2333 Rayburn HOB; Washington DC 20515-3303 | 202-225-3415 | 202-225-3286 | https://jones.house.gov/contact-me/email-me | 2333 Rayburn House Office Building | http://jones.house.gov/rss.xml | ||||||
41189 | 41189 | Sean Duffy D000614 | rep | WI | 2015-01-06 | 2017-01-03 | Republican | 7 | https://duffy.house.gov | 1208 Longworth HOB; Washington DC 20515-4907 | 202-225-3365 | 202-225-3240 | http://duffy.house.gov/contact | 1208 Longworth House Office Building | http://duffy.house.gov/rss.xml | ||||||
41193 | 41193 | Chris Collins C001092 | rep | NY | 2015-01-06 | 2017-01-03 | Republican | 27 | http://chriscollins.house.gov | 1117 Longworth HOB; Washington DC 20515-3227 | 202-225-5265 | 202-225-5910 | https://chriscollins.house.gov/contact/email-me | 1117 Longworth House Office Building | http://chriscollins.house.gov/rss.xml | ||||||
41206 | 41206 | Elijah Cummings C000984 | rep | MD | 2015-01-06 | 2017-01-03 | Democrat | 7 | http://cummings.house.gov | 2230 Rayburn HOB; Washington DC 20515-2007 | 202-225-4741 | 202-225-3178 | https://cummings.house.gov/contact-me/email-me | 2230 Rayburn House Office Building | http://cummings.house.gov/rss.xml | ||||||
41214 | 41214 | John Isakson I000055 | sen | GA | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.isakson.senate.gov | 131 Russell Senate Office Building Washington DC 20510 | 202-224-3643 | 202-228-0724 | http://www.isakson.senate.gov/public/index.cfm/email-me | 131 Russell Senate Office Building | senior | http://www.isakson.senate.gov/public/?a=RSS.Feed | |||||
41219 | 41219 | Duncan Hunter H001048 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 50 | http://hunter.house.gov | 2429 Rayburn HOB; Washington DC 20515-0550 | 202-225-5672 | 202-225-0235 | https://hunter.house.gov/contact-me/email-me | 2429 Rayburn House Office Building | http://hunter.house.gov/rss.xml | ||||||
41223 | 41223 | Mark Meadows M001187 | rep | NC | 2015-01-06 | 2017-01-03 | Republican | 11 | https://meadows.house.gov | 1024 Longworth HOB; Washington DC 20515-3311 | 202-225-6401 | 202-226-6422 | https://meadows.house.gov/email-me | 1024 Longworth House Office Building | http://meadows.house.gov/rss/press-releases.xml | ||||||
41226 | 41226 | John Ratcliffe R000601 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 4 | https://ratcliffe.house.gov | 325 Cannon HOB; Washington DC 20515-4304 | 202-225-6673 | 202-225-3332 | 325 Cannon House Office Building | ||||||||
41243 | 41243 | John Lewis L000287 | rep | GA | 2015-01-06 | 2017-01-03 | Democrat | 5 | http://johnlewis.house.gov | 343 Cannon HOB; Washington DC 20515-1005 | 202-225-3801 | 202-225-0351 | https://johnlewis.house.gov/contact-me/email-me-zip | 343 Cannon House Office Building | http://johnlewis.house.gov/rss.xml | ||||||
41249 | 41249 | Tom Graves G000560 | rep | GA | 2015-01-06 | 2017-01-03 | Republican | 14 | http://tomgraves.house.gov | 2442 Rayburn HOB; Washington DC 20515-1014 | 202-225-5211 | 202-225-8272 | http://tomgraves.house.gov/contact/ | 2442 Rayburn House Office Building | http://tomgraves.house.gov/news/rss.aspx | ||||||
41252 | 41252 | Martha McSally M001197 | rep | AZ | 2015-01-06 | 2017-01-03 | Republican | 2 | https://mcsally.house.gov | 1029 Longworth HOB; Washington DC 20515-0302 | 202-225-2542 | 202-225-0378 | 1029 Longworth House Office Building | ||||||||
41256 | 41256 | Paul Cook C001094 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 8 | http://cook.house.gov | 1222 Longworth HOB; Washington DC 20515-0508 | 202-225-5861 | https://cook.house.gov/contact/email-me | 1222 Longworth House Office Building | http://cook.house.gov/rss.xml | |||||||
41287 | 41287 | Justin Amash A000367 | rep | MI | 2015-01-06 | 2017-01-03 | Republican | 3 | http://amash.house.gov | 114 Cannon HOB; Washington DC 20515-2203 | 202-225-3831 | 202-225-5144 | https://amash.house.gov/contact-me/email-me | 114 Cannon House Office Building | http://amash.house.gov/rss.xml | ||||||
41296 | 41296 | Rob Bishop B001250 | rep | UT | 2015-01-06 | 2017-01-03 | Republican | 1 | http://robbishop.house.gov | 123 Cannon HOB; Washington DC 20515-4401 | 202-225-0453 | 202-225-5857 | https://robbishop.house.gov/contact/contactform.htm | 123 Cannon House Office Building | http://robbishop.house.gov/news/rss.aspx | ||||||
41306 | 41306 | Wm. Clay C001049 | rep | MO | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://lacyclay.house.gov | 2428 Rayburn HOB; Washington DC 20515-2501 | 202-225-2406 | 202-226-3717 | http://lacyclay.house.gov/contact-form/ | 2428 Rayburn House Office Building | |||||||
41314 | 41314 | K. Conaway C001062 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 11 | http://conaway.house.gov | 2430 Rayburn HOB; Washington DC 20515-4311 | 202-225-3605 | 202-225-1783 | https://conaway.house.gov/forms/writeyourrep/default.aspx | 2430 Rayburn House Office Building | |||||||
41324 | 41324 | Susan Davis D000598 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 53 | http://susandavis.house.gov | 1214 Longworth HOB; Washington DC 20515-0553 | 202-225-2040 | 202-225-2948 | https://susandavisforms.house.gov/forms/writeyourrep/ | 1214 Longworth House Office Building | |||||||
41340 | 41340 | Eliot Engel E000179 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 16 | http://engel.house.gov | 2462 Rayburn HOB; Washington DC 20515-3216 | 202-225-2464 | 202-225-5513 | https://engel.house.gov/write-your-rep1 | 2462 Rayburn House Office Building | |||||||
41345 | 41345 | Bill Flores F000461 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 17 | http://flores.house.gov | 1030 Longworth HOB; Washington DC 20515-4317 | 202-225-6105 | 202-225-0350 | https://billflores.house.gov/contact/ | 1030 Longworth House Office Building | http://flores.house.gov/common/rss//index.cfm?rss=25 | ||||||
41362 | 41362 | Peter King K000210 | rep | NY | 2015-01-06 | 2017-01-03 | Republican | 2 | http://peteking.house.gov | 339 Cannon HOB; Washington DC 20515-3202 | 202-225-7896 | 202-226-2279 | https://peteking.house.gov/contact/email-me | 339 Cannon House Office Building | http://peteking.house.gov/rss.xml | ||||||
41371 | 41371 | Steve King K000362 | rep | IA | 2015-01-06 | 2017-01-03 | Republican | 4 | https://steveking.house.gov | 2210 Rayburn HOB; Washington DC 20515-1504 | 202-225-4426 | 202-225-3193 | https://forms.house.gov/king/webforms/issue_subscribe.html | 2210 Rayburn House Office Building | http://steveking.house.gov/index.php?format=feed&type=rss | ||||||
41379 | 41379 | Daniel Lipinski L000563 | rep | IL | 2015-01-06 | 2017-01-03 | Democrat | 3 | http://lipinski.house.gov | 2346 Rayburn HOB; Washington DC 20515-1303 | 202-225-5701 | 202-225-1012 | https://lipinskiforms.house.gov/contact-form | 2346 Rayburn House Office Building | http://www.lipinski.house.gov/common/rss//index.cfm?rss=25 | ||||||
41386 | 41386 | David Loebsack L000565 | rep | IA | 2015-01-06 | 2017-01-03 | Democrat | 2 | http://loebsack.house.gov | 1527 Longworth HOB; Washington DC 20515-1502 | 202-225-6576 | 202-226-0757 | https://loebsack.house.gov/forms/writeyourrep/ | 1527 Longworth House Office Building | http://loebsack.house.gov/news/rss.aspx | ||||||
41402 | 41402 | Nita Lowey L000480 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 17 | http://lowey.house.gov | 2365 Rayburn HOB; Washington DC 20515-3217 | 202-225-6506 | 202-225-0546 | https://lowey.house.gov/contact-form/ | 2365 Rayburn House Office Building | http://www.house.gov/common/rss/?rss=18 | ||||||
41410 | 41410 | Kenny Marchant M001158 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 24 | http://marchant.house.gov | 2313 Rayburn HOB; Washington DC 20515-4324 | 202-225-6605 | 202-225-0074 | https://marchant.house.gov/contact/contactform.htm | 2313 Rayburn House Office Building | http://marchant.house.gov/news/rss.aspx | ||||||
41416 | 41416 | Pete Olson O000168 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 22 | http://olson.house.gov | 2133 Rayburn HOB; Washington DC 20515-4322 | 202-225-5951 | 202-225-5241 | https://forms.house.gov/olson/contact-form.shtml | 2133 Rayburn House Office Building | feed://olson.house.gov/common/rss/?rss=82 | ||||||
41431 | 41431 | Collin Peterson P000258 | rep | MN | 2015-01-06 | 2017-01-03 | Democrat | 7 | http://collinpeterson.house.gov | 2204 Rayburn HOB; Washington DC 20515-2307 | 202-225-2165 | 202-225-1593 | https://collinpeterson.house.gov/contact-me/email-me | 2204 Rayburn House Office Building | http://collinpeterson.house.gov/rss.xml | ||||||
41436 | 41436 | Martha Roby R000591 | rep | AL | 2015-01-06 | 2017-01-03 | Republican | 2 | http://roby.house.gov | 442 Cannon HOB; Washington DC 20515-0102 | 202-225-2901 | 202-225-8913 | https://roby.house.gov/contact-me | 442 Cannon House Office Building | http://roby.house.gov/rss.xml | ||||||
41442 | 41442 | David Roe R000582 | rep | TN | 2015-01-06 | 2017-01-03 | Republican | 1 | http://roe.house.gov | 407 Cannon HOB; Washington DC 20515-4201 | 202-225-6356 | 202-225-6356 | https://roe.house.gov/contact/contactform.htm?zip5=37813&zip4=1659 | 407 Cannon House Office Building | |||||||
41463 | 41463 | F. Sensenbrenner S000244 | rep | WI | 2015-01-06 | 2017-01-03 | Republican | 5 | http://sensenbrenner.house.gov | 2449 Rayburn HOB; Washington DC 20515-4905 | 202-225-5101 | 202-225-3190 | http://sensenbrenner.house.gov/contact/email.htm | 2449 Rayburn House Office Building | http://sensenbrenner.house.gov/news/rss.aspx | ||||||
41479 | 41479 | José Serrano S000248 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 15 | http://serrano.house.gov | 2227 Rayburn HOB; Washington DC 20515-3215 | 202-225-4361 | 202-225-6001 | https://serrano.house.gov/contact-me/email-me | 2227 Rayburn House Office Building | http://serrano.house.gov/rss.xml | ||||||
41491 | 41491 | John Shimkus S000364 | rep | IL | 2015-01-06 | 2017-01-03 | Republican | 15 | http://shimkus.house.gov | 2217 Rayburn HOB; Washington DC 20515-1315 | 202-225-5271 | 202-225-5880 | https://shimkus.house.gov/contact/email-me | 2217 Rayburn House Office Building | http://shimkus.house.gov/rss.xml | ||||||
41504 | 41504 | Mac Thornberry T000238 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 13 | http://thornberry.house.gov | 2208 Rayburn HOB; Washington DC 20515-4313 | 202-225-3706 | 202-225-3486 | https://thornberry.house.gov/forms/writeyourrep/ | 2208 Rayburn House Office Building | |||||||
41509 | 41509 | Scott Tipton T000470 | rep | CO | 2015-01-06 | 2017-01-03 | Republican | 3 | http://tipton.house.gov | 218 Cannon HOB; Washington DC 20515-0603 | 202-225-4761 | 202-226-9669 | https://tipton.house.gov/contact-me/email-me | 218 Cannon House Office Building | http://tipton.house.gov/rss.xml | ||||||
41527 | 41527 | Peter Visclosky V000108 | rep | IN | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://visclosky.house.gov | 2328 Rayburn HOB; Washington DC 20515-1401 | 202-225-2461 | 202-225-2493 | https://visclosky.house.gov/contact-pete/email-pete | 2328 Rayburn House Office Building | http://visclosky.house.gov/rss.xml | ||||||
41538 | 41538 | Greg Walden W000791 | rep | OR | 2015-01-06 | 2017-01-03 | Republican | 2 | http://walden.house.gov | 2185 Rayburn HOB; Washington DC 20515-3702 | 202-225-6730 | 202-225-5774 | https://walden.house.gov/e-mail-greg | 2185 Rayburn House Office Building | http://walden.house.gov/common/rss/?rss=100 | ||||||
41543 | 41543 | Rob Woodall W000810 | rep | GA | 2015-01-06 | 2017-01-03 | Republican | 7 | http://woodall.house.gov | 1724 Longworth HOB; Washington DC 20515-1007 | 202-225-4272 | 202-225-4696 | https://woodall.house.gov/contact-me/email-me | 1724 Longworth House Office Building | http://woodall.house.gov/rss.xml | ||||||
41547 | 41547 | Ted Yoho Y000065 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 3 | http://yoho.house.gov | 511 Cannon HOB; Washington DC 20515-0903 | 202-225-5744 | https://yoho.house.gov/contact/email-me | 511 Cannon House Office Building | http://yoho.house.gov/rss.xml | |||||||
41551 | 41551 | Doug Collins C001093 | rep | GA | 2015-01-06 | 2017-01-03 | Republican | 9 | http://dougcollins.house.gov | 1504 Longworth HOB; Washington DC 20515-1009 | 202-225-9893 | 202-226-1224 | https://dougcollins.house.gov/email-me | 1504 Longworth House Office Building | http://dougcollins.house.gov/latest-rss/latest-rss/ | ||||||
41555 | 41555 | Tulsi Gabbard G000571 | rep | HI | 2015-01-06 | 2017-01-03 | Democrat | 2 | http://gabbard.house.gov | 1609 Longworth HOB; Washington DC 20515-1102 | 202-225-4906 | 202-225-4987 | https://forms.house.gov/formsgabbard/webforms/email-me.shtml | 1609 Longworth House Office Building | http://gabbard.house.gov/rss.xml | ||||||
41559 | 41559 | Susan Brooks B001284 | rep | IN | 2015-01-06 | 2017-01-03 | Republican | 5 | http://susanwbrooks.house.gov | 1505 Longworth HOB; Washington DC 20515-1405 | 202-225-2276 | 202-225-0016 | https://susanwbrooks.house.gov/contact/email-me | 1505 Longworth House Office Building | http://susanwbrooks.house.gov/rss.xml | ||||||
41563 | 41563 | Joseph Kennedy K000379 | rep | MA | 2015-01-06 | 2017-01-03 | Democrat | 4 | http://kennedy.house.gov | 306 Cannon HOB; Washington DC 20515-2104 | 202-225-5931 | 202-225-0182 | https://kennedy.house.gov/contact/email-me | 306 Cannon House Office Building | http://kennedy.house.gov/rss.xml | ||||||
41567 | 41567 | George Holding H001065 | rep | NC | 2015-01-06 | 2017-01-03 | Republican | 13 | http://holding.house.gov | 507 Cannon HOB; Washington DC 20515-3313 | 202-225-3032 | 919-782-4490 | https://holding.house.gov/contact/email-me | 507 Cannon House Office Building | http://holding.house.gov/rss.xml | ||||||
41571 | 41571 | Denny Heck H001064 | rep | WA | 2015-01-06 | 2017-01-03 | Democrat | 10 | http://dennyheck.house.gov | 425 Cannon HOB; Washington DC 20515-4710 | 202-225-9740 | 202-225-0129 | https://dennyheck.house.gov/contact/email-me | 425 Cannon House Office Building | http://dennyheck.house.gov/rss.xml | ||||||
41575 | 41575 | Bradley Byrne B001289 | rep | AL | 2015-01-06 | 2017-01-03 | Republican | 1 | https://byrne.house.gov | 119 Cannon HOB; Washington DC 20515-0101 | 202-225-4931 | 202-225-0562 | https://byrne.house.gov/contact/email-me | 119 Cannon House Office Building | |||||||
41578 | 41578 | Ralph Abraham A000374 | rep | LA | 2015-01-06 | 2017-01-03 | Republican | 5 | https://abraham.house.gov | 417 Cannon HOB; Washington DC 20515-1805 | 202-225-8490 | 202-225-5639 | 417 Cannon House Office Building | ||||||||
41581 | 41581 | Will Hurd H001073 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 23 | https://hurd.house.gov | 317 Cannon HOB; Washington DC 20515-4323 | 202-225-4511 | 317 Cannon House Office Building | |||||||||
41585 | 41585 | Mark Walker W000819 | rep | NC | 2015-01-06 | 2017-01-03 | Republican | 6 | https://walker.house.gov | 312 Cannon HOB; Washington DC 20515-3306 | 202-225-3065 | 202-225-8611 | 312 Cannon House Office Building | ||||||||
41613 | 41613 | Cedric Richmond R000588 | rep | LA | 2015-01-06 | 2017-01-03 | Democrat | 2 | http://richmond.house.gov | 240 Cannon HOB; Washington DC 20515-1802 | 202-225-6636 | 202-225-1988 | https://richmond.house.gov/contact-me/email-me | 240 Cannon House Office Building | http://richmond.house.gov/rss.xml | ||||||
41625 | 41625 | Marcia Fudge F000455 | rep | OH | 2015-01-06 | 2017-01-03 | Democrat | 11 | http://fudge.house.gov | 2344 Rayburn HOB; Washington DC 20515-3511 | 202-225-7032 | 202-225-1339 | https://fudgeforms.house.gov/contact-form | 2344 Rayburn House Office Building | http://fudge.house.gov/common/rss//index.cfm?rss=25 | ||||||
41642 | 41642 | Alcee Hastings H000324 | rep | FL | 2015-01-06 | 2017-01-03 | Democrat | 20 | http://alceehastings.house.gov | 2353 Rayburn HOB; Washington DC 20515-0920 | 202-225-1313 | 202-225-1171 | https://alceehastings.house.gov/forms/writeyourrep/?zip5=33407&zip4=3224 | 2353 Rayburn House Office Building | http://www.alceehastings.house.gov/news/rss.aspx | ||||||
41648 | 41648 | Steve Stivers S001187 | rep | OH | 2015-01-06 | 2017-01-03 | Republican | 15 | http://stivers.house.gov | 1022 Longworth HOB; Washington DC 20515-3515 | 202-225-2015 | 202-225-3529 | https://stivers.house.gov/forms/writeyourrep/ | 1022 Longworth House Office Building | http://stivers.house.gov/news/rss.aspx | ||||||
41658 | 41658 | Devin Nunes N000181 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 22 | http://nunes.house.gov | 1013 Longworth HOB; Washington DC 20515-0522 | 202-225-2523 | 202-225-3404 | https://nunes.house.gov/contactform/default.aspx | 1013 Longworth House Office Building | http://nunes.house.gov/news/rss.aspx | ||||||
41685 | 41685 | Don Young Y000033 | rep | AK | 2015-01-06 | 2017-01-03 | Republican | 0 | http://donyoung.house.gov | 2314 Rayburn HOB; Washington DC 20515-0200 | 202-225-5765 | 202-225-0425 | https://donyoung.house.gov/forms/writeyourrep/ | 2314 Rayburn House Office Building | http://donyoung.house.gov/news/rss.aspx | ||||||
41694 | 41694 | Jeff Fortenberry F000449 | rep | NE | 2015-01-06 | 2017-01-03 | Republican | 1 | https://fortenberry.house.gov | 1514 Longworth HOB; Washington DC 20515-2701 | 202-225-4806 | 202-225-5686 | https://fortenberry.house.gov/contact-me1 | 1514 Longworth House Office Building | http://fortenberry.house.gov/index.php?format=feed&type=rss | ||||||
41699 | 41699 | Filemon Vela V000132 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 34 | http://vela.house.gov | 437 Cannon HOB; Washington DC 20515-4334 | 202-225-9901 | 202-225-9770 | https://forms.house.gov/vela/webforms/email-me.shtml | 437 Cannon House Office Building | http://vela.house.gov/rss.xml | ||||||
41706 | 41706 | Tom Reed R000585 | rep | NY | 2015-01-06 | 2017-01-03 | Republican | 23 | http://reed.house.gov | 2437 Rayburn HOB; Washington DC 20515-3223 | 202-225-3161 | 202-226-6599 | https://reed.house.gov/contact-me/email-me | 2437 Rayburn House Office Building | http://reed.house.gov/rss.xml |
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);