legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
476 rows where "end" is on date 2015-01-03 sorted by state
This data as json, copyable, CSV (advanced)
Suggested facets: state, party, fax, state_rank, start (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39686 | 39686 | Mark Begich B001265 | sen | AK | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.begich.senate.gov | 111 Russell Senate Office Building Washington DC 20510 | 202-224-3004 | 202-224-2354 | http://www.begich.senate.gov/public/index.cfm?p=EmailSenator | 111 Russell Senate Office Building | junior | http://www.begich.senate.gov/public/?a=rss.feed | |||||
41684 | 41684 | Don Young Y000033 | rep | AK | 2013-01-03 | 2015-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 | ||||||
39748 | 39748 | Spencer Bachus B000013 | rep | AL | 2013-01-03 | 2015-01-03 | Republican | 6 | http://bachus.house.gov | 2246 Rayburn HOB; Washington DC 20515-0106 | 202-225-4921 | 202-225-2082 | https://bachus.house.gov/email-me | 2246 Rayburn House Office Building | http://bachus.house.gov/index.php?option=com_bca-rss-syndicator&feed_id=1 | ||||||
40527 | 40527 | Jefferson Sessions S001141 | sen | AL | 2009-01-06 | 2015-01-03 | 2 | Republican | http://www.sessions.senate.gov | 326 Russell Senate Office Building Washington DC 20510 | 202-224-4124 | 202-224-3149 | http://www.sessions.senate.gov/public/index.cfm/contact-jeff | 326 Russell Senate Office Building | junior | http://www.sessions.senate.gov/public/index.cfm?fuseaction=rss.feed | |||||
41435 | 41435 | Martha Roby R000591 | rep | AL | 2013-01-03 | 2015-01-03 | Republican | 2 | http://roby.house.gov | 428 Cannon HOB; Washington DC 20515-0102 | 202-225-2901 | 202-225-8913 | https://roby.house.gov/contact-me | 428 Cannon House Office Building | http://roby.house.gov/rss.xml | ||||||
41574 | 41574 | Bradley Byrne B001289 | rep | AL | 2014-01-08 | 2015-01-03 | Republican | 1 | http://byrne.house.gov | 2236 Rayburn HOB; Washington DC 20515-0101 | 202-225-4931 | https://byrne.house.gov/contact/email-me | 2236 Rayburn House Office Building | ||||||||
41912 | 41912 | Robert Aderholt A000055 | rep | AL | 2013-01-03 | 2015-01-03 | Republican | 4 | http://aderholt.house.gov | 2369 Rayburn HOB; Washington DC 20515-0104 | 202-225-4876 | 202-225-5587 | http://aderholt.house.gov/email-me2/ | 2369 Rayburn House Office Building | http://aderholt.house.gov/common/rss//index.cfm?rss=20 | ||||||
42013 | 42013 | Mo Brooks B001274 | rep | AL | 2013-01-03 | 2015-01-03 | Republican | 5 | http://brooks.house.gov | 1230 Longworth HOB; Washington DC 20515-0105 | 202-225-4801 | 202-225-4392 | https://brooks.house.gov/email-me | 1230 Longworth House Office Building | http://brooks.house.gov/rss/press-releases.xml | ||||||
43176 | 43176 | Mike Rogers R000575 | rep | AL | 2013-01-03 | 2015-01-03 | Republican | 3 | http://mike-rogers.house.gov | 324 Cannon HOB; Washington DC 20515-0103 | 202-225-3261 | 202-226-8485 | http://mike-rogers.house.gov/contact-mike/email-me | 324 Cannon House Office Building | http://mike-rogers.house.gov/rss.xml | ||||||
43341 | 43341 | Terri Sewell S001185 | rep | AL | 2013-01-03 | 2015-01-03 | Democrat | 7 | http://sewell.house.gov | 1133 Longworth HOB; Washington DC 20515-0107 | 202-225-2665 | 202-226-9567 | https://sewell.house.gov/email-me | 1133 Longworth House Office Building | http://sewell.house.gov/rss.xml | ||||||
39722 | 39722 | Mark Pryor P000590 | sen | AR | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.pryor.senate.gov | 255 Dirksen Senate Office Building Washington DC 20510 | 202-224-2353 | 202-228-0908 | http://www.pryor.senate.gov/contact/form | 255 Dirksen Senate Office Building | senior | http://www.pryor.senate.gov/public/index.cfm/rss/feed | |||||
39855 | 39855 | Tim Griffin G000567 | rep | AR | 2013-01-03 | 2015-01-03 | Republican | 2 | http://griffin.house.gov | 1232 Longworth HOB; Washington DC 20515-0402 | 202-225-2506 | 202-225-5903 | https://timgriffinforms.house.gov/forms/writeyourrep/ | 1232 Longworth House Office Building | http://griffin.house.gov/rss.xml | ||||||
42239 | 42239 | Eric Crawford C001087 | rep | AR | 2013-01-03 | 2015-01-03 | Republican | 1 | http://crawford.house.gov | 1711 Longworth HOB; Washington DC 20515-0401 | 202-225-4076 | 202-225-5602 | http://crawford.house.gov/contact/ | 1711 Longworth House Office Building | http://crawford.house.gov/news/rss.aspx | ||||||
43625 | 43625 | Steve Womack W000809 | rep | AR | 2013-01-03 | 2015-01-03 | Republican | 3 | http://womack.house.gov | 1119 Longworth HOB; Washington DC 20515-0403 | 202-225-4301 | 202-225-5713 | https://womack.house.gov/contact/contactform.htm | 1119 Longworth House Office Building | http://womack.house.gov/news/rss.aspx | ||||||
43701 | 43701 | Tom Cotton C001095 | rep | AR | 2013-01-03 | 2015-01-03 | Republican | 4 | http://cotton.house.gov | 415 Cannon HOB; Washington DC 20515-0404 | 202-225-3772 | https://cotton.house.gov/contact/email-me | 415 Cannon House Office Building | http://cotton.house.gov/rss.xml | |||||||
39841 | 39841 | Eni Faleomavaega F000010 | rep | AS | 2013-01-03 | 2015-01-03 | Democrat | 0 | http://faleomavaega.house.gov | 2422 Rayburn HOB; Washington DC 20515-5201 | 202-225-8577 | 202-225-8757 | https://faleomavaega.house.gov/contact/email-me | 2422 Rayburn House Office Building | |||||||
40008 | 40008 | Ed Pastor P000099 | rep | AZ | 2013-01-03 | 2015-01-03 | Democrat | 7 | http://www.pastor.house.gov | 2465 Rayburn HOB; Washington DC 20515-0307 | 202-225-4065 | 202-225-1655 | https://pastor.house.gov/email-me | 2465 Rayburn House Office Building | http://www.house.gov/index.php?format=feed&type=rss | ||||||
40117 | 40117 | Ron Barber B001279 | rep | AZ | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://barber.house.gov | 1029 Longworth HOB; Washington DC 20515-0302 | 202-225-2542 | 202-225-0378 | https://barber.house.gov/contact/email-me | 1029 Longworth House Office Building | http://barber.house.gov/rss.xml | ||||||
40490 | 40490 | Matt Salmon S000018 | rep | AZ | 2013-01-03 | 2015-01-03 | Republican | 5 | http://salmon.house.gov | 2349 Rayburn HOB; Washington DC 20515-0305 | 202-225-2635 | 202-226-4386 | https://salmon.house.gov/contact/email-me | 2349 Rayburn House Office Building | http://salmon.house.gov/rss.xml | ||||||
40587 | 40587 | Trent Franks F000448 | rep | AZ | 2013-01-03 | 2015-01-03 | Republican | 8 | http://franks.house.gov | 2435 Rayburn HOB; Washington DC 20515-0308 | 202-225-4576 | 202-225-6328 | https://franks.house.gov/contact-me/email-me | 2435 Rayburn House Office Building | http://franks.house.gov/rss.xml | ||||||
42416 | 42416 | Paul Gosar G000565 | rep | AZ | 2013-01-03 | 2015-01-03 | Republican | 4 | http://gosar.house.gov | 504 Cannon HOB; Washington DC 20515-0304 | 202-225-2315 | 202-226-9739 | https://gosar.house.gov/contact-me/email-me | 504 Cannon House Office Building | http://gosar.house.gov/rss.xml | ||||||
42475 | 42475 | Raúl Grijalva G000551 | rep | AZ | 2013-01-03 | 2015-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 | ||||||
43300 | 43300 | David Schweikert S001183 | rep | AZ | 2013-01-03 | 2015-01-03 | Republican | 6 | http://schweikert.house.gov | 1205 Longworth HOB; Washington DC 20515-0306 | 202-225-2190 | 202-225-0096 | https://schweikert.house.gov/contact-form | 1205 Longworth House Office Building | http://schweikert.house.gov/rss/press-releases.xml | ||||||
43704 | 43704 | Kyrsten Sinema S001191 | rep | AZ | 2013-01-03 | 2015-01-03 | Democrat | 9 | http://sinema.house.gov | 1237 Longworth HOB; Washington DC 20515-0309 | 202-225-9888 | 202-225-9731 | https://sinemaforms.house.gov/forms/writeyourrep/ | 1237 Longworth House Office Building | http://sinema.house.gov/index.cfm/rss/feed | ||||||
44280 | 44280 | Ann Kirkpatrick K000368 | rep | AZ | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://kirkpatrick.house.gov | 330 Cannon HOB; Washington DC 20515-0301 | 202-225-3361 | 202-225-3462 | https://kirkpatrick.house.gov/contact/email-me | 330 Cannon House Office Building | http://kirkpatrick.house.gov/rss.xml | ||||||
39784 | 39784 | John Campbell C001064 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 45 | http://www.campbell.house.gov | 2331 Rayburn HOB; Washington DC 20515-0545 | 202-225-5611 | 202-225-9177 | https://campbell.house.gov/email-me | 2331 Rayburn House Office Building | http://www.campbell.house.gov/rss/press1.xml | ||||||
39947 | 39947 | Howard McKeon M000508 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 25 | http://mckeon.house.gov | 2310 Rayburn HOB; Washington DC 20515-0525 | 202-225-1956 | 202-226-0683 | https://mckeon.house.gov/forms/writeyourrep/default.aspx | 2310 Rayburn House Office Building | http://mckeon.house.gov/news/rss.aspx | ||||||
39961 | 39961 | Gary Miller M001139 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 31 | http://garymiller.house.gov | 2467 Rayburn HOB; Washington DC 20515-0531 | 202-225-3201 | 202-226-6962 | http://garymiller.house.gov/contact/ | 2467 Rayburn House Office Building | http://garymiller.house.gov/news/rss.aspx | ||||||
39981 | 39981 | George Miller M000725 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 11 | http://georgemiller.house.gov | 2205 Rayburn HOB; Washington DC 20515-0511 | 202-225-2095 | 202-225-5609 | https://georgemiller.house.gov/contact-me/email-me | 2205 Rayburn House Office Building | http://georgemiller.house.gov/rss.xml | ||||||
40098 | 40098 | Henry Waxman W000215 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 33 | http://waxman.house.gov | 2204 Rayburn HOB; Washington DC 20515-0533 | 202-225-3976 | 202-225-4099 | https://waxman.house.gov/contact-me/email-me | 2204 Rayburn House Office Building | http://waxman.house.gov/rss.xml | ||||||
40122 | 40122 | Gloria Negrete McLeod N000187 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 35 | http://negretemcleod.house.gov | 1641 Longworth HOB; Washington DC 20515-0535 | 202-225-6161 | 202-225-8671 | http://negretemcleod.house.gov/EmailGloria | 1641 Longworth House Office Building | http://negretemcleod.house.gov/rss.xml | ||||||
40191 | 40191 | Janice Hahn H001063 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 44 | http://hahn.house.gov | 404 Cannon HOB; Washington DC 20515-0544 | 202-225-8220 | 202-226-7290 | https://hahn.house.gov/contact-me/email-me | 404 Cannon House Office Building | http://hahn.house.gov/rss.xml | ||||||
40275 | 40275 | Lois Capps C001036 | rep | CA | 2013-01-03 | 2015-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 | ||||||
40306 | 40306 | Sam Farr F000030 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 20 | http://www.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 | ||||||
40359 | 40359 | Michael Honda H001034 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 17 | http://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 | ||||||
40475 | 40475 | Loretta Sanchez S000030 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 46 | http://lorettasanchez.house.gov | 1114 Longworth HOB; Washington DC 20515-0546 | 202-225-2965 | 202-225-5859 | https://lorettasanchez.house.gov/contact-me/email-me | 1114 Longworth House Office Building | http://lorettasanchez.house.gov/rss.xml | ||||||
40522 | 40522 | Xavier Becerra B000287 | rep | CA | 2013-01-03 | 2015-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 | ||||||
40769 | 40769 | Jeff Denham D000612 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 10 | http://denham.house.gov | 1730 Longworth HOB; Washington DC 20515-0510 | 202-225-4540 | 202-225-3402 | https://denham.house.gov/contact-me/email-me | 1730 Longworth House Office Building | http://denham.house.gov/rss.xml | ||||||
40986 | 40986 | Dana Rohrabacher R000409 | rep | CA | 2013-01-03 | 2015-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 | ||||||
41033 | 41033 | Edward Royce R000487 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 39 | http://royce.house.gov | 2185 Rayburn HOB; Washington DC 20515-0539 | 202-225-4111 | 202-226-0335 | https://royce.house.gov/contact/contactform.htm | 2185 Rayburn House Office Building | http://royce.house.gov/news/rss.aspx | ||||||
41218 | 41218 | Duncan Hunter H001048 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 50 | http://hunter.house.gov | 223 Cannon HOB; Washington DC 20515-0550 | 202-225-5672 | 202-225-0235 | https://hunter.house.gov/contact-me/email-me | 223 Cannon House Office Building | http://hunter.house.gov/rss.xml | ||||||
41255 | 41255 | Paul Cook C001094 | rep | CA | 2013-01-03 | 2015-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 | |||||||
41323 | 41323 | Susan Davis D000598 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 53 | http://www.house.gov/susandavis | 1526 Longworth HOB; Washington DC 20515-0553 | 202-225-2040 | 202-225-2948 | https://susandavisforms.house.gov/forms/writeyourrep/ | 1526 Longworth House Office Building | |||||||
41657 | 41657 | Devin Nunes N000181 | rep | CA | 2013-01-03 | 2015-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 | ||||||
41927 | 41927 | Karen Bass B001270 | rep | CA | 2013-01-03 | 2015-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 | ||||||
42070 | 42070 | Ken Calvert C000059 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 42 | http://calvert.house.gov | 2269 Rayburn HOB; Washington DC 20515-0542 | 202-225-1986 | 202-225-2004 | https://calvert.house.gov/contactform/ | 2269 Rayburn House Office Building | http://calvert.house.gov/news/rss.aspx | ||||||
42130 | 42130 | Judy Chu C001080 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 27 | http://chu.house.gov | 1520 Longworth HOB; Washington DC 20515-0527 | 202-225-5464 | 202-225-5467 | http://chu.house.gov/connect-with-me/email-judy | 1520 Longworth House Office Building | http://chu.house.gov/rss.xml | ||||||
42218 | 42218 | Jim Costa C001059 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 16 | http://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 | ||||||
42373 | 42373 | Anna Eshoo E000215 | rep | CA | 2013-01-03 | 2015-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 | ||||||
42395 | 42395 | John Garamendi G000559 | rep | CA | 2013-01-03 | 2015-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 | ||||||
42733 | 42733 | Barbara Lee L000551 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 13 | http://lee.house.gov | 2267 Rayburn HOB; Washington DC 20515-0513 | 202-225-2661 | 202-225-9817 | http://lee.house.gov/contact-the-office/email-me | 2267 Rayburn House Office Building | http://lee.house.gov/rss.xml | ||||||
42749 | 42749 | Zoe Lofgren L000397 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 19 | http://lofgren.house.gov | 1401 Longworth HOB; Washington DC 20515-0519 | 202-225-3072 | 202-225-3336 | http://lofgren.house.gov/contact/ | 1401 Longworth House Office Building | http://lofgren.house.gov/index.php?format=feed&type=rss | ||||||
42842 | 42842 | Doris Matsui M001163 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 6 | http://matsui.house.gov | 2434 Rayburn HOB; Washington DC 20515-0506 | 202-225-7163 | 202-225-0566 | https://matsui.house.gov/email-representative-matsui | 2434 Rayburn House Office Building | http://matsui.house.gov/index.php?format=feed&type=rss | ||||||
42850 | 42850 | Kevin McCarthy M001165 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 23 | http://kevinmccarthy.house.gov | 2421 Rayburn HOB; Washington DC 20515-0523 | 202-225-2915 | 202-225-2908 | https://kevinmccarthy.house.gov/contact/email-me | 2421 Rayburn House Office Building | http://kevinmccarthy.house.gov/index.php?format=feed&type=rss | ||||||
42866 | 42866 | Tom McClintock M001177 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 4 | http://mcclintock.house.gov | 434 Cannon HOB; Washington DC 20515-0504 | 202-225-2511 | 202-225-5444 | https://mcclintockforms.house.gov/forms/contact-form.shtml | 434 Cannon House Office Building | http://mcclintock.house.gov/atom.xml | ||||||
42922 | 42922 | Jerry McNerney M001166 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 9 | http://mcnerney.house.gov | 1210 Longworth HOB; Washington DC 20515-0509 | 202-225-1947 | 202-225-4060 | https://mcnerney.house.gov/contact/email-me | 1210 Longworth House Office Building | http://mcnerney.house.gov/rss.xml | ||||||
42995 | 42995 | Grace Napolitano N000179 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 32 | http://napolitano.house.gov | 1610 Longworth HOB; Washington DC 20515-0532 | 202-225-5256 | 202-225-0027 | https://napolitano.house.gov/contact-me/email-me | 1610 Longworth House Office Building | http://napolitano.house.gov/rss.xml | ||||||
43085 | 43085 | Nancy Pelosi P000197 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 12 | http://pelosi.house.gov | 235 Cannon HOB; Washington DC 20515-0512 | 202-225-4965 | 202-225-8259 | http://pelosi.house.gov/contact-me/email-me | 235 Cannon House Office Building | http://pelosi.house.gov/atom.xml | ||||||
43191 | 43191 | Lucille Roybal-Allard R000486 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 40 | http://roybal-allard.house.gov | 2330 Rayburn HOB; Washington DC 20515-0540 | 202-225-1766 | 202-226-0350 | http://roybal-allard.house.gov/contact/ | 2330 Rayburn House Office Building | http://roybal-allard.house.gov/news/rss.aspx | ||||||
43274 | 43274 | Adam Schiff S001150 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 28 | http://schiff.house.gov | 2411 Rayburn HOB; Washington DC 20515-0528 | 202-225-4176 | 202-225-5828 | https://schiff.house.gov/email-congressman-schiff1 | 2411 Rayburn House Office Building | http://schiff.house.gov/common/rss/?rss=49 | ||||||
43364 | 43364 | Brad Sherman S000344 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 30 | http://bradsherman.house.gov | 2242 Rayburn HOB; Washington DC 20515-0530 | 202-225-5911 | 202-225-5879 | http://sherman.house.gov/contact/contact-congressman-sherman-form | 2242 Rayburn House Office Building | http://bradsherman.house.gov/press-releases-and-columns/rss.shtml | ||||||
43435 | 43435 | Jackie Speier S001175 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 14 | http://speier.house.gov | 211 Cannon HOB; Washington DC 20515-0514 | 202-225-3531 | 202-347-0956 | https://forms.house.gov/speier/webforms/email_jackie.shtml | 211 Cannon House Office Building | http://speier.house.gov/index.php?format=feed&type=rss | ||||||
43445 | 43445 | Linda Sánchez S001156 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 38 | http://lindasanchez.house.gov | 2423 Rayburn HOB; Washington DC 20515-0538 | 202-225-6676 | 202-226-1012 | https://forms.house.gov/lindasanchez/webforms/issue_subscribe.htm | 2423 Rayburn House Office Building | http://lindasanchez.house.gov/index.php?format=feed&type=rss | ||||||
43472 | 43472 | Mike Thompson T000460 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 5 | http://mikethompson.house.gov | 231 Cannon HOB; Washington DC 20515-0505 | 202-225-3311 | 202-225-4335 | https://mikethompson.house.gov/contact/email-me | 231 Cannon House Office Building | http://mikethompson.house.gov/news/rss.aspx | ||||||
43580 | 43580 | Maxine Waters W000187 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 43 | http://waters.house.gov | 2221 Rayburn HOB; Washington DC 20515-0543 | 202-225-2201 | 202-225-7854 | https://waters.house.gov/contact/contactform.htm | 2221 Rayburn House Office Building | http://waters.house.gov/news/rss.aspx | ||||||
43708 | 43708 | Doug LaMalfa L000578 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 1 | http://lamalfa.house.gov | 506 Cannon HOB; Washington DC 20515-0501 | 202-225-3076 | 530-534-7800 | https://lamalfa.house.gov/contact/email-me | 506 Cannon House Office Building | http://lamalfa.house.gov/rss.xml | ||||||
43713 | 43713 | Jared Huffman H001068 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://huffman.house.gov | 1630 Longworth HOB; Washington DC 20515-0502 | 202-225-5161 | 202-225-5163 | https://huffman.house.gov/contact/email-me | 1630 Longworth House Office Building | http://huffman.house.gov/rss.xml | ||||||
43718 | 43718 | Ami Bera B001287 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 7 | http://bera.house.gov | 1408 Longworth HOB; Washington DC 20515-0507 | 202-225-5716 | 202-226-1298 | https://beraforms.house.gov/forms/writeyourrep/ | 1408 Longworth House Office Building | http://bera.house.gov/rss.xml | ||||||
43723 | 43723 | Eric Swalwell S001193 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 15 | http://swalwell.house.gov | 501 Cannon HOB; Washington DC 20515-0515 | 202-225-5065 | http://swalwell.house.gov/contact-me/email-eric/ | 501 Cannon House Office Building | ||||||||
43728 | 43728 | Julia Brownley B001285 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 26 | http://juliabrownley.house.gov | 1019 Longworth HOB; Washington DC 20515-0526 | 202-225-5811 | 202-225-1100 | https://juliabrownley.house.gov/contact/email-me | 1019 Longworth House Office Building | http://juliabrownley.house.gov/rss.xml | ||||||
43733 | 43733 | Tony Cárdenas C001097 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 29 | http://cardenas.house.gov | 1508 Longworth HOB; Washington DC 20515-0529 | 202-225-6131 | 202-225-0819 | https://cardenas.house.gov/contact/email-me | 1508 Longworth House Office Building | http://cardenas.house.gov/rss.xml | ||||||
43738 | 43738 | Raul Ruiz R000599 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 36 | http://ruiz.house.gov | 1319 Longworth HOB; Washington DC 20515-0536 | 202-225-5330 | https://ruiz.house.gov/email-me | 1319 Longworth House Office Building | http://ruiz.house.gov/rss.xml | |||||||
43743 | 43743 | Mark Takano T000472 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 41 | http://takano.house.gov | 1507 Longworth HOB; Washington DC 20515-0541 | 202-225-2305 | https://takano.house.gov/contact/email-me | 1507 Longworth House Office Building | http://takano.house.gov/rss.xml | |||||||
43748 | 43748 | Alan Lowenthal L000579 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 47 | http://lowenthal.house.gov | 515 Cannon HOB; Washington DC 20515-0547 | 202-225-7924 | 202-225-7926 | http://lowenthal.house.gov/contact/howtocontactme.htm | 515 Cannon House Office Building | http://lowenthal.house.gov/news/rss.aspx | ||||||
43753 | 43753 | Juan Vargas V000130 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 51 | http://vargas.house.gov | 1605 Longworth HOB; Washington DC 20515-0551 | 202-225-8045 | 202-225-9073 | https://vargas.house.gov/contact | 1605 Longworth House Office Building | http://vargas.house.gov/rss.xml | ||||||
43758 | 43758 | Scott Peters P000608 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 52 | http://scottpeters.house.gov | 2410 Rayburn HOB; Washington DC 20515-0552 | 202-225-0508 | 202-225-2558 | https://scottpeters.house.gov/contact/email-me | 2410 Rayburn House Office Building | http://scottpeters.house.gov/rss.xml | ||||||
44451 | 44451 | Darrell Issa I000056 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 49 | http://issa.house.gov | 2347 Rayburn HOB; Washington DC 20515-0549 | 202-225-3906 | 202-225-3303 | http://issa.house.gov/contact/contact-me | 2347 Rayburn House Office Building | http://issa.house.gov/feed/ | ||||||
44467 | 44467 | David Valadao V000129 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 21 | http://valadao.house.gov | 1004 Longworth HOB; Washington DC 20515-0521 | 202-225-4695 | 202-226-3196 | http://valadao.house.gov/contact/ | 1004 Longworth House Office Building | http://valadao.house.gov/rss.xml | ||||||
39733 | 39733 | Mark Udall U000038 | sen | CO | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.markudall.senate.gov | 730 Hart Senate Office Building Washington DC 20510 | 202-224-5941 | 202-226-7840 | http://www.markudall.senate.gov/?p=contact_us | 730 Hart Senate Office Building | senior | http://markudall.senate.gov/rss/?p=blog | |||||
40746 | 40746 | Mike Coffman C001077 | rep | CO | 2013-01-03 | 2015-01-03 | Republican | 6 | http://coffman.house.gov | 2443 Rayburn HOB; Washington DC 20515-0606 | 202-225-7882 | 202-226-4623 | https://coffman.house.gov/contact/email-me | 2443 Rayburn House Office Building | http://coffman.house.gov/index.php?format=feed&type=rss | ||||||
40960 | 40960 | Jared Polis P000598 | rep | CO | 2013-01-03 | 2015-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 | ||||||
41349 | 41349 | Cory Gardner G000562 | rep | CO | 2013-01-03 | 2015-01-03 | Republican | 4 | http://gardner.house.gov | 213 Cannon HOB; Washington DC 20515-0604 | 202-225-4676 | 202-225-5870 | https://gardner.house.gov/contact-me | 213 Cannon House Office Building | http://gardner.house.gov/rss.xml | ||||||
41508 | 41508 | Scott Tipton T000470 | rep | CO | 2013-01-03 | 2015-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 | ||||||
42292 | 42292 | Diana DeGette D000197 | rep | CO | 2013-01-03 | 2015-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 | ||||||
42666 | 42666 | Doug Lamborn L000564 | rep | CO | 2013-01-03 | 2015-01-03 | Republican | 5 | http://lamborn.house.gov | 2402 Rayburn HOB; Washington DC 20515-0605 | 202-225-4422 | 202-226-2638 | https://lambornforms.house.gov/contact-form | 2402 Rayburn House Office Building | http://lamborn.house.gov/news-rss-graphic/news-rss-graphic/ | ||||||
43093 | 43093 | Ed Perlmutter P000593 | rep | CO | 2013-01-03 | 2015-01-03 | Democrat | 7 | http://perlmutter.house.gov | 1410 Longworth HOB; Washington DC 20515-0607 | 202-225-2645 | 202-225-5278 | https://forms.house.gov/perlmutter/webforms/contact.shtml | 1410 Longworth House Office Building | http://perlmutter.house.gov/index.php?format=feed&type=rss | ||||||
41092 | 41092 | Elizabeth Esty E000293 | rep | CT | 2013-01-03 | 2015-01-03 | Democrat | 5 | http://esty.house.gov | 509 Cannon HOB; Washington DC 20515-0705 | 202-225-4476 | 202-225-5933 | http://esty.house.gov/contact | 509 Cannon House Office Building | http://esty.house.gov/rss.xml | ||||||
42226 | 42226 | Joe Courtney C001069 | rep | CT | 2013-01-03 | 2015-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 | ||||||
42308 | 42308 | Rosa DeLauro D000216 | rep | CT | 2013-01-03 | 2015-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 | ||||||
42520 | 42520 | James Himes H001047 | rep | CT | 2013-01-03 | 2015-01-03 | Democrat | 4 | http://himes.house.gov | 119 Cannon HOB; Washington DC 20515-0704 | 202-225-5541 | 202-225-9629 | https://himes.house.gov/contact-me/email-me | 119 Cannon House Office Building | http://himes.house.gov/rss.xml | ||||||
42704 | 42704 | John Larson L000557 | rep | CT | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://www.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 | ||||||
43028 | 43028 | Eleanor Norton N000147 | rep | DC | 2013-01-03 | 2015-01-03 | Democrat | 0 | http://norton.house.gov | 2136 Rayburn HOB; Washington DC 20515-5101 | 202-225-8050 | 202-225-3002 | https://norton.house.gov/contact/email-me | 2136 Rayburn House Office Building | http://norton.house.gov/index.php?format=feed&type=rss | ||||||
40278 | 40278 | John Carney C001083 | rep | DE | 2013-01-03 | 2015-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 | ||||||
41898 | 41898 | Christopher Coons C001088 | sen | DE | 2010-11-15 | 2015-01-03 | 2 | Democrat | http://www.coons.senate.gov | 127A Russell Senate Office Building Washington DC 20510 | 202-224-5042 | 202-228-3075 | http://www.coons.senate.gov/contact/ | 127a Russell Senate Office Building | junior | http://www.coons.senate.gov/rss/feeds/?type=all | |||||
40061 | 40061 | Steve Southerland S001186 | rep | FL | 2013-01-03 | 2015-01-03 | Republican | 2 | http://southerland.house.gov | 1229 Longworth HOB; Washington DC 20515-0902 | 202-225-5235 | 202-225-5615 | https://southerland.house.gov/index.cfm/email-me | 1229 Longworth House Office Building | http://southerland.house.gov/index.cfm/rss/feed | ||||||
40123 | 40123 | Joe Garcia G000573 | rep | FL | 2013-01-03 | 2015-01-03 | Democrat | 26 | http://garcia.house.gov | 1440 Longworth HOB; Washington DC 20515-0926 | 202-225-2778 | http://garciaforms.house.gov/email-me/ | 1440 Longworth House Office Building | http://garcia.house.gov/rss.xml | |||||||
40265 | 40265 | Corrine Brown B000911 | rep | FL | 2013-01-03 | 2015-01-03 | Democrat | 5 | http://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 | ||||||
40286 | 40286 | Ander Crenshaw C001045 | rep | FL | 2013-01-03 | 2015-01-03 | Republican | 4 | http://crenshaw.house.gov | 440 Cannon HOB; Washington DC 20515-0904 | 202-225-2501 | 202-225-2504 | https://forms.house.gov/write/crenshaw/email-me.shtml | 440 Cannon House Office Building | |||||||
40406 | 40406 | John Mica M000689 | rep | FL | 2013-01-03 | 2015-01-03 | Republican | 7 | http://mica.house.gov | 2187 Rayburn HOB; Washington DC 20515-0907 | 202-225-4035 | 202-226-0821 | https://mica.house.gov/contact-form | 2187 Rayburn House Office Building | http://mica.house.gov/common/rss/index.cfm?rss=25 | ||||||
40414 | 40414 | Jeff Miller M001144 | rep | FL | 2013-01-03 | 2015-01-03 | Republican | 1 | http://jeffmiller.house.gov | 336 Cannon HOB; Washington DC 20515-0901 | 202-225-4136 | 202-225-3414 | https://jeffmiller.house.gov/contact/contactform.htm | 336 Cannon House Office Building | http://jeffmiller.house.gov/news/rss.aspx |
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);