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 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, state_rank, rss_url
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40209 | 40209 | Barbara Boxer B000711 | sen | CA | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.boxer.senate.gov | 112 Hart Senate Office Building Washington DC 20510 | 202-224-3553 | 202-224-0454 | https://www.boxer.senate.gov/contact/shareyourviews.html | 112 Hart Senate Office Building | junior | ||||||
40233 | 40233 | Barbara Mikulski M000702 | sen | MD | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.mikulski.senate.gov | 503 Hart Senate Office Building Washington DC 20510 | 202-224-4654 | 202-224-8858 | http://www.mikulski.senate.gov/contact/shareyouropinion.cfm | 503 Hart Senate Office Building | senior | http://www.mikulski.senate.gov/rssfeed.cfm | |||||
40240 | 40240 | Harry Reid R000146 | sen | NV | 2011-01-05 | 2017-01-03 | 3 | Democrat | http://www.reid.senate.gov | 522 Hart Senate Office Building Washington DC 20510 | 202-224-3542 | 202-224-7327 | http://www.reid.senate.gov/contact | 522 Hart Senate Office Building | senior | ||||||
40266 | 40266 | Corrine Brown B000911 | rep | FL | 2015-01-06 | 2017-01-03 | Democrat | 5 | https://corrinebrown.house.gov | 2111 Rayburn HOB; Washington DC 20515-0905 | 202-225-0123 | 202-225-2256 | https://forms.house.gov/corrinebrown/webforms/contact-me.shtml | 2111 Rayburn House Office Building | http://corrinebrown.house.gov/index.php?option=com_ninjarsssyndicator&feed_id=1&format=raw | ||||||
40276 | 40276 | Lois Capps C001036 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 24 | http://capps.house.gov | 2231 Rayburn HOB; Washington DC 20515-0524 | 202-225-3601 | 202-225-5632 | https://capps.house.gov/contact-me/email-me | 2231 Rayburn House Office Building | http://capps.house.gov/rss.xml | ||||||
40279 | 40279 | John Carney C001083 | rep | DE | 2015-01-06 | 2017-01-03 | Democrat | 0 | http://johncarney.house.gov | 1406 Longworth HOB; Washington DC 20515-0800 | 202-225-4165 | 202-225-2291 | https://forms.house.gov/carney/webforms/email-me.shtml | 1406 Longworth House Office Building | http://johncarney.house.gov/index.php?format=feed&type=rss | ||||||
40292 | 40292 | Donna Edwards E000290 | rep | MD | 2015-01-06 | 2017-01-03 | Democrat | 4 | http://donnaedwards.house.gov | 2445 Rayburn HOB; Washington DC 20515-2004 | 202-225-8699 | 202-225-8714 | https://forms.house.gov/formdonnaedwards/issue_subscribe.shtml | 2445 Rayburn House Office Building | http://www.house.gov/common/rss/?rss=24 | ||||||
40307 | 40307 | Sam Farr F000030 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 20 | http://farr.house.gov | 1126 Longworth HOB; Washington DC 20515-0520 | 202-225-2861 | 202-225-6791 | https://forms.house.gov/farr/webforms/issue_subscribe.html | 1126 Longworth House Office Building | http://www.farr.house.gov/index.php?format=feed&type=rss | ||||||
40352 | 40352 | Rubén Hinojosa H000636 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 15 | http://hinojosa.house.gov | 2262 Rayburn HOB; Washington DC 20515-4315 | 202-225-2531 | 202-225-5688 | https://hinojosa.house.gov/contact-me/email-me | 2262 Rayburn House Office Building | http://hinojosa.house.gov/rss.xml | ||||||
40360 | 40360 | Michael Honda H001034 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 17 | https://honda.house.gov | 1713 Longworth HOB; Washington DC 20515-0517 | 202-225-2631 | 202-225-2699 | http://honda.house.gov/contact | 1713 Longworth House Office Building | http://www.house.gov/index.php?format=feed&type=rss | ||||||
40374 | 40374 | Steve Israel I000057 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 3 | http://israel.house.gov | 2457 Rayburn HOB; Washington DC 20515-3203 | 202-225-3335 | 202-225-4669 | https://israel.house.gov/contact/email-me | 2457 Rayburn House Office Building | http://israel.house.gov/index.php?format=feed&type=rss | ||||||
40395 | 40395 | Jim McDermott M000404 | rep | WA | 2015-01-06 | 2017-01-03 | Democrat | 7 | http://mcdermott.house.gov | 1035 Longworth HOB; Washington DC 20515-4707 | 202-225-3106 | 202-225-6197 | https://forms.house.gov/mcdermott/webforms/new/contact.shtml | 1035 Longworth House Office Building | http://mcdermott.house.gov/index.php?format=feed&type=rss | ||||||
40427 | 40427 | Pedro Pierluisi P000596 | rep | PR | 2013-01-03 | 2017-01-03 | Democrat | 0 | http://pierluisi.house.gov | 2410 Rayburn HOB; Washington DC 20515-5401 | 202-225-2615 | 202-225-2154 | https://pierluisi.house.gov/contact/email-me | 2410 Rayburn House Office Building | http://pierluisi.house.gov/rss.xml | ||||||
40460 | 40460 | Charles Rangel R000053 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 13 | http://rangel.house.gov | 2354 Rayburn HOB; Washington DC 20515-3213 | 202-225-4365 | 202-225-0816 | https://rangel.house.gov/contact-me/email-me | 2354 Rayburn House Office Building | http://rangel.house.gov/rss.xml | ||||||
40476 | 40476 | Loretta Sanchez S000030 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 46 | http://lorettasanchez.house.gov | 1211 Longworth HOB; Washington DC 20515-0546 | 202-225-2965 | 202-225-5859 | https://lorettasanchez.house.gov/contact-me/email-me | 1211 Longworth House Office Building | http://lorettasanchez.house.gov/rss.xml | ||||||
40494 | 40494 | Alan Grayson G000556 | rep | FL | 2015-01-06 | 2017-01-03 | Democrat | 9 | http://grayson.house.gov | 303 Cannon HOB; Washington DC 20515-0909 | 202-225-9889 | 202-225-9742 | https://grayson.house.gov/contact/email-me | 303 Cannon House Office Building | http://grayson.house.gov/rss.xml | ||||||
40496 | 40496 | Patrick Murphy M001191 | rep | FL | 2015-01-06 | 2017-01-03 | Democrat | 18 | http://patrickmurphy.house.gov | 211 Cannon HOB; Washington DC 20515-0918 | 202-225-3026 | 202-225-8398 | http://patrickmurphy.house.gov/contact/ | 211 Cannon House Office Building | http://patrickmurphy.house.gov/news/rss.aspx | ||||||
40505 | 40505 | Gwen Graham G000575 | rep | FL | 2015-01-06 | 2017-01-03 | Democrat | 2 | https://graham.house.gov | 1213 Longworth HOB; Washington DC 20515-0902 | 202-225-5235 | 202-225-5615 | 1213 Longworth House Office Building | ||||||||
40506 | 40506 | Brad Ashford A000373 | rep | NE | 2015-01-06 | 2017-01-03 | Democrat | 2 | https://ashford.house.gov | 107 Cannon HOB; Washington DC 20515-2702 | 202-225-4155 | 202-226-5452 | 107 Cannon House Office Building | ||||||||
40523 | 40523 | Xavier Becerra B000287 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 34 | http://becerra.house.gov | 1226 Longworth HOB; Washington DC 20515-0534 | 202-225-6235 | 202-225-2202 | http://becerraforms.house.gov/forms/writeyourrep/ | 1226 Longworth House Office Building | http://becerra.house.gov/index.php?format=feed&type=rss | ||||||
40580 | 40580 | John Conyers C000714 | rep | MI | 2015-01-06 | 2017-01-03 | Democrat | 13 | https://conyers.house.gov | 2426 Rayburn HOB; Washington DC 20515-2213 | 202-225-5126 | 202-225-0072 | https://conyers.house.gov/index.cfm/online-contact-form | 2426 Rayburn House Office Building | http://conyers.house.gov/index.cfm/rss/feed | ||||||
40616 | 40616 | Louise Slaughter S000480 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 25 | https://louise.house.gov | 2469 Rayburn HOB; Washington DC 20515-3225 | 202-225-3615 | 202-225-7822 | https://louise.house.gov/contact-louise | 2469 Rayburn House Office Building | http://louise.house.gov/index.php?format=feed&type=rss | ||||||
40668 | 40668 | Michelle Lujan Grisham L000580 | rep | NM | 2015-01-06 | 2017-01-03 | Democrat | 1 | https://lujangrisham.house.gov | 214 Cannon HOB; Washington DC 20515-3101 | 202-225-6316 | 202-225-4975 | http://lujangrisham.house.gov/contact/email-me/ | 214 Cannon House Office Building | http://lujangrisham.house.gov/rss.xml | ||||||
40721 | 40721 | Madeleine Bordallo B001245 | rep | GU | 2015-01-06 | 2017-01-03 | Democrat | 0 | http://bordallo.house.gov | 2441 Rayburn HOB; Washington DC 20515-5301 | 202-225-1188 | 202-226-0341 | https://bordallo.house.gov/contact-me | 2441 Rayburn House Office Building | http://bordallo.house.gov/rss.xml | ||||||
40732 | 40732 | Robert Brady B001227 | rep | PA | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://brady.house.gov | 102 Cannon HOB; Washington DC 20515-3801 | 202-225-4731 | 202-225-0088 | https://brady.house.gov/contact-me/email-me | 102 Cannon House Office Building | http://brady.house.gov/rss.xml | ||||||
40742 | 40742 | Michael Capuano C001037 | rep | MA | 2015-01-06 | 2017-01-03 | Democrat | 7 | http://capuano.house.gov | 1414 Longworth HOB; Washington DC 20515-2107 | 202-225-5111 | 202-225-9322 | http://www.house.gov/capuano/contact/email.shtml | 1414 Longworth House Office Building | |||||||
40757 | 40757 | Joseph Crowley C001038 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 14 | http://crowley.house.gov | 1436 Longworth HOB; Washington DC 20515-3214 | 202-225-3965 | 202-225-1909 | https://crowley.house.gov/contact-me/email-me | 1436 Longworth House Office Building | http://crowley.house.gov/rss.xml | ||||||
40796 | 40796 | Keith Ellison E000288 | rep | MN | 2015-01-06 | 2017-01-03 | Democrat | 5 | http://ellison.house.gov | 2263 Rayburn HOB; Washington DC 20515-2305 | 202-225-4755 | 202-225-4886 | http://ellison.house.gov/contact | 2263 Rayburn House Office Building | http://ellison.house.gov/index.php?format=feed&type=rss | ||||||
40845 | 40845 | Gene Green G000410 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 29 | https://green.house.gov | 2470 Rayburn HOB; Washington DC 20515-4329 | 202-225-1688 | 202-225-9903 | https://green.house.gov/contact-me/email-me | 2470 Rayburn House Office Building | http://green.house.gov/rss.xml | ||||||
40858 | 40858 | Luis Gutiérrez G000535 | rep | IL | 2015-01-06 | 2017-01-03 | Democrat | 4 | http://gutierrez.house.gov | 2408 Rayburn HOB; Washington DC 20515-1304 | 202-225-8203 | 202-225-7810 | http://gutierrezforms.house.gov/contact/ | 2408 Rayburn House Office Building | http://gutierrez.house.gov/rss.xml | ||||||
40921 | 40921 | Sander Levin L000263 | rep | MI | 2015-01-06 | 2017-01-03 | Democrat | 9 | http://levin.house.gov | 1236 Longworth HOB; Washington DC 20515-2209 | 202-225-4961 | 202-226-1033 | https://levin.house.gov/contact-me/email-me | 1236 Longworth House Office Building | http://levin.house.gov/rss.xml | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | |||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | |||||||
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 | |||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
41723 | 41723 | Theodore Deutch D000610 | rep | FL | 2015-01-06 | 2017-01-03 | Democrat | 21 | http://teddeutch.house.gov | 2447 Rayburn HOB; Washington DC 20515-0921 | 202-225-3001 | 202-225-5974 | https://teddeutch.house.gov/forms/writeyourrep/default.aspx | 2447 Rayburn House Office Building | http://teddeutch.house.gov/news/rss.aspx | ||||||
41928 | 41928 | Karen Bass B001270 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 37 | http://bass.house.gov | 408 Cannon HOB; Washington DC 20515-0537 | 202-225-7084 | 202-225-2422 | https://bass.house.gov/contact-me/email-me | 408 Cannon House Office Building | http://bass.house.gov/rss.xml | ||||||
41933 | 41933 | Michael Bennet B001267 | sen | CO | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.bennet.senate.gov | 261 Russell Senate Office Building Washington DC 20510 | 202-224-5852 | 202-228-5097 | http://www.bennet.senate.gov/contact/email | 261 Russell Senate Office Building | senior | http://www.bennet.senate.gov/rss/feeds/?type=news | |||||
41954 | 41954 | Sanford Bishop B000490 | rep | GA | 2015-01-06 | 2017-01-03 | Democrat | 2 | http://bishop.house.gov | 2407 Rayburn HOB; Washington DC 20515-1002 | 202-225-3631 | 202-225-2203 | http://bishop.house.gov/contact | 2407 Rayburn House Office Building | http://bishop.house.gov/rss.xml | ||||||
41977 | 41977 | Earl Blumenauer B000574 | rep | OR | 2015-01-06 | 2017-01-03 | Democrat | 3 | http://blumenauer.house.gov | 1111 Longworth HOB; Washington DC 20515-3703 | 202-225-4811 | 202-225-8941 | https://forms.house.gov/blumenauer/webforms/issue_subscribe.html | 1111 Longworth House Office Building | http://blumenauer.house.gov/index.php?format=feed&type=rss | ||||||
41981 | 41981 | Richard Blumenthal B001277 | sen | CT | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.blumenthal.senate.gov | 706 Hart Senate Office Building Washington DC 20510 | 202-224-2823 | 202-224-9673 | https://www.blumenthal.senate.gov/contact/ | 706 Hart Senate Office Building | senior | http://www.blumenthal.senate.gov/rss/feeds/?type=all | |||||
42056 | 42056 | George Butterfield B001251 | rep | NC | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://butterfield.house.gov | 2305 Rayburn HOB; Washington DC 20515-3301 | 202-225-3101 | 202-225-3354 | https://butterfield.house.gov/email-congressman-butterfield | 2305 Rayburn House Office Building | http://butterfield.house.gov/rss/press-releases.xml/ | ||||||
42088 | 42088 | André Carson C001072 | rep | IN | 2015-01-06 | 2017-01-03 | Democrat | 7 | http://carson.house.gov | 2453 Rayburn HOB; Washington DC 20515-1407 | 202-225-4011 | 202-225-5633 | https://carson.house.gov/contact/email-me | 2453 Rayburn House Office Building | http://carson.house.gov/index.php?option=com_bca-rss-syndicator&feed_id=1 | ||||||
42111 | 42111 | Kathy Castor C001066 | rep | FL | 2015-01-06 | 2017-01-03 | Democrat | 14 | http://castor.house.gov | 205 Cannon HOB; Washington DC 20515-0914 | 202-225-3376 | 202-225-5652 | https://castor.house.gov/contact/contactform.htm | 205 Cannon House Office Building | http://castor.house.gov/news/rss.aspx | ||||||
42131 | 42131 | Judy Chu C001080 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 27 | http://chu.house.gov | 2423 Rayburn HOB; Washington DC 20515-0527 | 202-225-5464 | 202-225-5467 | http://chu.house.gov/connect-with-me/email-judy | 2423 Rayburn House Office Building | http://chu.house.gov/rss.xml | ||||||
42137 | 42137 | David Cicilline C001084 | rep | RI | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://cicilline.house.gov | 2244 Rayburn HOB; Washington DC 20515-3901 | 202-225-4911 | 202-225-3290 | https://cicilline.house.gov/contact-me/email-me | 2244 Rayburn House Office Building | http://cicilline.house.gov/rss.xml | ||||||
42145 | 42145 | Yvette Clarke C001067 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 9 | http://clarke.house.gov | 2351 Rayburn HOB; Washington DC 20515-3209 | 202-225-6231 | 202-226-0112 | https://clarke.house.gov/contact/email-me | 2351 Rayburn House Office Building | http://clarke.house.gov/news/rss.aspx | ||||||
42154 | 42154 | Emanuel Cleaver C001061 | rep | MO | 2015-01-06 | 2017-01-03 | Democrat | 5 | http://cleaver.house.gov | 2335 Rayburn HOB; Washington DC 20515-2505 | 202-225-4535 | 202-225-4403 | https://cleaver.house.gov/contact/email-me | 2335 Rayburn House Office Building | http://cleaver.house.gov/rss.xml | ||||||
42169 | 42169 | James Clyburn C000537 | rep | SC | 2015-01-06 | 2017-01-03 | Democrat | 6 | http://clyburn.house.gov | 242 Cannon HOB; Washington DC 20515-4006 | 202-225-3315 | 202-225-2313 | https://clyburn.house.gov/contact-me/email-me | 242 Cannon House Office Building | http://clyburn.house.gov/rss.xml | ||||||
42177 | 42177 | Steve Cohen C001068 | rep | TN | 2015-01-06 | 2017-01-03 | Democrat | 9 | http://cohen.house.gov | 2404 Rayburn HOB; Washington DC 20515-4209 | 202-225-3265 | 202-225-5663 | https://cohen.house.gov/contact-me/email-me | 2404 Rayburn House Office Building | http://cohen.house.gov/rss.xml | ||||||
42194 | 42194 | Gerald Connolly C001078 | rep | VA | 2015-01-06 | 2017-01-03 | Democrat | 11 | http://connolly.house.gov | 2238 Rayburn HOB; Washington DC 20515-4611 | 202-225-1492 | 202-225-3071 | https://forms.house.gov/connolly/contact-form.shtml | 2238 Rayburn House Office Building | http://connolly.house.gov/common/rss//index.cfm?rss=44 | ||||||
42210 | 42210 | Jim Cooper C000754 | rep | TN | 2015-01-06 | 2017-01-03 | Democrat | 5 | http://cooper.house.gov | 1536 Longworth HOB; Washington DC 20515-4205 | 202-225-4311 | 202-226-1035 | https://cooper.house.gov/contact/email-me | 1536 Longworth House Office Building | http://cooper.house.gov/index.php?format=feed&type=rss | ||||||
42219 | 42219 | Jim Costa C001059 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 16 | https://costa.house.gov | 1314 Longworth HOB; Washington DC 20515-0516 | 202-225-3341 | 202-225-9308 | http://www.house.gov/formcosta/issue.htm | 1314 Longworth House Office Building | http://costa.house.gov/index.php?format=feed&type=rss | ||||||
42227 | 42227 | Joe Courtney C001069 | rep | CT | 2015-01-06 | 2017-01-03 | Democrat | 2 | http://courtney.house.gov | 2348 Rayburn HOB; Washington DC 20515-0702 | 202-225-2076 | 202-225-4977 | https://courtney.house.gov/email-joe1 | 2348 Rayburn House Office Building | http://courtney.house.gov/index.php?format=feed&type=rss | ||||||
42249 | 42249 | Henry Cuellar C001063 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 28 | http://cuellar.house.gov | 2209 Rayburn HOB; Washington DC 20515-4328 | 202-225-1640 | 202-225-1641 | https://cuellar.house.gov/forms/writeyourrep/default.aspx | 2209 Rayburn House Office Building | http://cuellar.house.gov/news/rss.aspx | ||||||
42262 | 42262 | Danny Davis D000096 | rep | IL | 2015-01-06 | 2017-01-03 | Democrat | 7 | http://davis.house.gov | 2159 Rayburn HOB; Washington DC 20515-1307 | 202-225-5006 | 202-225-5641 | https://davis.house.gov/email-me | 2159 Rayburn House Office Building | http://davis.house.gov/index.php?format=feed&type=rss | ||||||
42280 | 42280 | Peter DeFazio D000191 | rep | OR | 2015-01-06 | 2017-01-03 | Democrat | 4 | http://defazio.house.gov | 2134 Rayburn HOB; Washington DC 20515-3704 | 202-225-6416 | https://defazio.house.gov/contact/email-me | 2134 Rayburn House Office Building | http://www.defazio.house.gov/index.php?format=feed&type=rss | |||||||
42293 | 42293 | Diana DeGette D000197 | rep | CO | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://degette.house.gov | 2368 Rayburn HOB; Washington DC 20515-0601 | 202-225-4431 | 202-225-5657 | https://degette.house.gov/contact/send-me-an-email/email-me | 2368 Rayburn House Office Building | http://degette.house.gov/index.php?option=com_ninjarsssyndicator&feed_id=1&format=raw | ||||||
42309 | 42309 | Rosa DeLauro D000216 | rep | CT | 2015-01-06 | 2017-01-03 | Democrat | 3 | http://delauro.house.gov | 2413 Rayburn HOB; Washington DC 20515-0703 | 202-225-3661 | 202-225-4890 | https://forms.house.gov/delauro/webforms/contact_form_email.shtml | 2413 Rayburn House Office Building | http://delauro.house.gov/index.php?format=feed&type=rss | ||||||
42339 | 42339 | Lloyd Doggett D000399 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 35 | http://doggett.house.gov | 2307 Rayburn HOB; Washington DC 20515-4335 | 202-225-4865 | 202-225-3073 | https://forms.house.gov/doggett/webforms/issue_subscribe.htm | 2307 Rayburn House Office Building | http://doggett.house.gov/index.php/component/ninjarsssyndicator/?feed_id=1&format=raw | ||||||
42353 | 42353 | Michael Doyle D000482 | rep | PA | 2015-01-06 | 2017-01-03 | Democrat | 14 | http://doyle.house.gov | 239 Cannon HOB; Washington DC 20515-3814 | 202-225-2135 | 202-225-3084 | https://doyle.house.gov/contact-me/email-me | 239 Cannon House Office Building | http://doyle.house.gov/rss.xml | ||||||
42374 | 42374 | Anna Eshoo E000215 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 18 | http://eshoo.house.gov | 241 Cannon HOB; Washington DC 20515-0518 | 202-225-8104 | 202-225-8890 | https://eshoo.house.gov/email-me/ | 241 Cannon House Office Building | http://eshoo.house.gov/index.php?format=feed&type=rss | ||||||
42396 | 42396 | John Garamendi G000559 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 3 | http://garamendi.house.gov | 2438 Rayburn HOB; Washington DC 20515-0503 | 202-225-1880 | 202-225-5914 | https://garamendi.house.gov/contact-me/email-me | 2438 Rayburn House Office Building | http://garamendi.house.gov/rss.xml | ||||||
42460 | 42460 | Al Green G000553 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 9 | http://algreen.house.gov | 2347 Rayburn HOB; Washington DC 20515-4309 | 202-225-7508 | 202-225-2947 | https://algreen.house.gov/contact-me/email-me | 2347 Rayburn House Office Building | http://algreen.house.gov/rss.xml | ||||||
42476 | 42476 | Raúl Grijalva G000551 | rep | AZ | 2015-01-06 | 2017-01-03 | Democrat | 3 | http://grijalva.house.gov | 1511 Longworth HOB; Washington DC 20515-0303 | 202-225-2435 | 202-225-1541 | https://grijalvaforms.house.gov/email-raul | 1511 Longworth House Office Building | http://grijalva.house.gov/common/rss/?rss=13 | ||||||
42514 | 42514 | Brian Higgins H001038 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 26 | http://higgins.house.gov | 2459 Rayburn HOB; Washington DC 20515-3226 | 202-225-3306 | 202-226-0347 | http://higgins.house.gov/contact/email-brian | 2459 Rayburn House Office Building | http://higgins.house.gov/rss.xml | ||||||
42521 | 42521 | James Himes H001047 | rep | CT | 2015-01-06 | 2017-01-03 | Democrat | 4 | http://himes.house.gov | 1227 Longworth HOB; Washington DC 20515-0704 | 202-225-5541 | 202-225-9629 | https://himes.house.gov/contact-me/email-me | 1227 Longworth House Office Building | http://himes.house.gov/rss.xml | ||||||
42549 | 42549 | Steny Hoyer H000874 | rep | MD | 2015-01-06 | 2017-01-03 | Democrat | 5 | http://hoyer.house.gov | 1705 Longworth HOB; Washington DC 20515-2005 | 202-225-4131 | 202-225-4300 | https://hoyer.house.gov/email-steny | 1705 Longworth House Office Building | http://hoyer.house.gov/index.php?format=feed&type=rss | ||||||
42569 | 42569 | Sheila Jackson Lee J000032 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 18 | http://jacksonlee.house.gov | 2252 Rayburn HOB; Washington DC 20515-4318 | 202-225-3816 | 202-225-3317 | http://jacksonlee.house.gov/contact/ | 2252 Rayburn House Office Building | http://jacksonlee.house.gov/news/rss.aspx | ||||||
42590 | 42590 | Eddie Johnson J000126 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 30 | http://ebjohnson.house.gov | 2468 Rayburn HOB; Washington DC 20515-4330 | 202-225-8885 | 202-226-1477 | https://ebjohnson.house.gov/contact/email-me | 2468 Rayburn House Office Building | http://ebjohnson.house.gov/common/rss//index.cfm?rss=21 | ||||||
42598 | 42598 | Henry Johnson J000288 | rep | GA | 2015-01-06 | 2017-01-03 | Democrat | 4 | http://hankjohnson.house.gov | 2240 Rayburn HOB; Washington DC 20515-1004 | 202-225-1605 | 202-226-0691 | https://hankjohnson.house.gov/contact-me/email-me | 2240 Rayburn House Office Building | http://hankjohnson.house.gov/rss.xml | ||||||
42628 | 42628 | Marcy Kaptur K000009 | rep | OH | 2015-01-06 | 2017-01-03 | Democrat | 9 | http://kaptur.house.gov | 2186 Rayburn HOB; Washington DC 20515-3509 | 202-225-4146 | 202-225-7711 | https://forms.house.gov/kaptur/webforms/issue_subscribe.shtml | 2186 Rayburn House Office Building | http://kaptur.house.gov/index.php?format=feed&type=rss | ||||||
42634 | 42634 | William Keating K000375 | rep | MA | 2015-01-06 | 2017-01-03 | Democrat | 9 | http://keating.house.gov | 315 Cannon HOB; Washington DC 20515-2109 | 202-225-3111 | 202-225-5658 | https://forms.house.gov/keating/webforms/contact.shtml | 315 Cannon House Office Building | http://keating.house.gov/index.php?format=feed&type=rss | ||||||
42653 | 42653 | Ron Kind K000188 | rep | WI | 2015-01-06 | 2017-01-03 | Democrat | 3 | http://kind.house.gov | 1502 Longworth HOB; Washington DC 20515-4903 | 202-225-5506 | 202-225-5739 | https://kindforms.house.gov/email-ron | 1502 Longworth House Office Building | http://kind.house.gov/common/rss/?rss=52 | ||||||
42678 | 42678 | James Langevin L000559 | rep | RI | 2015-01-06 | 2017-01-03 | Democrat | 2 | http://langevin.house.gov | 2077 Rayburn HOB; Washington DC 20515-3902 | 202-225-2735 | 202-225-5976 | https://langevin.house.gov/contact-me/email-me | 2077 Rayburn House Office Building | http://langevin.house.gov/rss.xml | ||||||
42693 | 42693 | Rick Larsen L000560 | rep | WA | 2015-01-06 | 2017-01-03 | Democrat | 2 | http://larsen.house.gov | 2113 Rayburn HOB; Washington DC 20515-4702 | 202-225-2605 | 202-225-4420 | http://larsen.house.gov/contact-rick/email-rick | 2113 Rayburn House Office Building | http://larsen.house.gov/rss.xml | ||||||
42705 | 42705 | John Larson L000557 | rep | CT | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://larson.house.gov | 1501 Longworth HOB; Washington DC 20515-0701 | 202-225-2265 | 202-225-1031 | https://forms.house.gov/larson/contact_new.html | 1501 Longworth House Office Building | http://www.larson.house.gov/index.php?format=feed&type=rss | ||||||
42723 | 42723 | Patrick Leahy L000174 | sen | VT | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.leahy.senate.gov | 437 Russell Senate Office Building Washington DC 20510 | 202-224-4242 | 202-224-3479 | https://www.leahy.senate.gov/contact/ | 437 Russell Senate Office Building | senior | http://www.leahy.senate.gov/rss/feeds/press/ |
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);