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 state
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, party, state_rank, rss_url, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||
42960 | 42960 | Lisa Murkowski M001153 | sen | AK | 2011-01-05 | 2017-01-03 | 3 | Republican | https://www.murkowski.senate.gov | 709 Hart Senate Office Building Washington DC 20510 | 202-224-6665 | 202-224-5301 | http://www.murkowski.senate.gov/public/index.cfm?p=EMailLisa | 709 Hart Senate Office Building | senior | http://www.murkowski.senate.gov/public/?a=rss.feed | |||||
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 | ||||||
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 | |||||||
41913 | 41913 | Robert Aderholt A000055 | rep | AL | 2015-01-06 | 2017-01-03 | Republican | 4 | https://aderholt.house.gov | 235 Cannon HOB; Washington DC 20515-0104 | 202-225-4876 | 202-225-5587 | http://aderholt.house.gov/email-me2/ | 235 Cannon House Office Building | http://aderholt.house.gov/common/rss//index.cfm?rss=20 | ||||||
42014 | 42014 | Mo Brooks B001274 | rep | AL | 2015-01-06 | 2017-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 | ||||||
43177 | 43177 | Mike Rogers R000575 | rep | AL | 2015-01-06 | 2017-01-03 | Republican | 3 | http://mikerogers.house.gov | 324 Cannon HOB; Washington DC 20515-0103 | 202-225-3261 | 202-226-8485 | http://mikerogers.house.gov/contact-mike/email-me | 324 Cannon House Office Building | http://mikerogers.house.gov/rss.xml | ||||||
43342 | 43342 | Terri Sewell S001185 | rep | AL | 2015-01-06 | 2017-01-03 | Democrat | 7 | https://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 | ||||||
43354 | 43354 | Richard Shelby S000320 | sen | AL | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.shelby.senate.gov | 304 Russell Senate Office Building Washington DC 20510 | 202-224-5744 | 202-224-3416 | http://www.shelby.senate.gov/public/index.cfm/emailsenatorshelby | 304 Russell Senate Office Building | senior | http://www.shelby.senate.gov/public/index.cfm/rss/feed | |||||
43936 | 43936 | Gary Palmer P000609 | rep | AL | 2015-01-06 | 2017-01-03 | Republican | 6 | https://palmer.house.gov | 206 Cannon HOB; Washington DC 20515-0106 | 202-225-4921 | 202-225-2082 | 206 Cannon House Office Building | ||||||||
41997 | 41997 | John Boozman B001236 | sen | AR | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.boozman.senate.gov | 141 Hart Senate Office Building Washington DC 20510 | 202-224-4843 | 202-228-1371 | http://www.boozman.senate.gov/public/index.cfm/e-mail-me | 141 Hart Senate Office Building | senior | http://www.boozman.senate.gov/public/index.cfm/rss/feed | |||||
42240 | 42240 | Eric Crawford C001087 | rep | AR | 2015-01-06 | 2017-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 | ||||||
43626 | 43626 | Steve Womack W000809 | rep | AR | 2015-01-06 | 2017-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 | ||||||
43940 | 43940 | J. Hill H001072 | rep | AR | 2015-01-06 | 2017-01-03 | Republican | 2 | https://hill.house.gov | 1229 Longworth HOB; Washington DC 20515-0402 | 202-225-2506 | 202-225-5903 | 1229 Longworth House Office Building | ||||||||
43944 | 43944 | Bruce Westerman W000821 | rep | AR | 2015-01-06 | 2017-01-03 | Republican | 4 | https://westerman.house.gov | 130 Cannon HOB; Washington DC 20515-0404 | 202-225-3772 | 130 Cannon House Office Building | |||||||||
44068 | 44068 | Aumua Amata Radewagen R000600 | rep | AS | 2015-01-06 | 2017-01-03 | Republican | 0 | https://radewagen.house.gov | 1339 Longworth HOB; Washington DC 20515-5200 | 202-225-8577 | 202-225-8757 | 1339 Longworth House Office Building | ||||||||
40491 | 40491 | Matt Salmon S000018 | rep | AZ | 2015-01-06 | 2017-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 | ||||||
40588 | 40588 | Trent Franks F000448 | rep | AZ | 2015-01-06 | 2017-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 | ||||||
40652 | 40652 | John McCain M000303 | sen | AZ | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.mccain.senate.gov | 218 Russell Senate Office Building Washington DC 20510 | 202-224-2235 | 202-228-2862 | http://www.mccain.senate.gov/public/index.cfm/contact-form | 218 Russell Senate Office Building | senior | ||||||
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 | ||||||||
42417 | 42417 | Paul Gosar G000565 | rep | AZ | 2015-01-06 | 2017-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 | ||||||
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 | ||||||
43301 | 43301 | David Schweikert S001183 | rep | AZ | 2015-01-06 | 2017-01-03 | Republican | 6 | http://schweikert.house.gov | 409 Cannon HOB; Washington DC 20515-0306 | 202-225-2190 | 202-225-0096 | https://schweikert.house.gov/contact-form | 409 Cannon House Office Building | http://schweikert.house.gov/rss/press-releases.xml | ||||||
43705 | 43705 | Kyrsten Sinema S001191 | rep | AZ | 2015-01-06 | 2017-01-03 | Democrat | 9 | https://sinema.house.gov | 1530 Longworth HOB; Washington DC 20515-0309 | 202-225-9888 | 202-225-9731 | https://sinemaforms.house.gov/forms/writeyourrep/ | 1530 Longworth House Office Building | http://sinema.house.gov/index.cfm/rss/feed | ||||||
43948 | 43948 | Ruben Gallego G000574 | rep | AZ | 2015-01-06 | 2017-01-03 | Democrat | 7 | https://rubengallego.house.gov | 1218 Longworth HOB; Washington DC 20515-0307 | 202-225-4065 | 1218 Longworth House Office Building | |||||||||
44281 | 44281 | Ann Kirkpatrick K000368 | rep | AZ | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://kirkpatrick.house.gov | 201 Cannon HOB; Washington DC 20515-0301 | 202-225-3361 | 202-225-3462 | https://kirkpatrick.house.gov/contact/email-me | 201 Cannon House Office Building | http://kirkpatrick.house.gov/rss.xml | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
40770 | 40770 | Jeff Denham D000612 | rep | CA | 2015-01-06 | 2017-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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||||
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 | ||||||
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 | |||||||
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 | |||||||
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 | ||||||
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 | ||||||
42071 | 42071 | Ken Calvert C000059 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 42 | http://calvert.house.gov | 2205 Rayburn HOB; Washington DC 20515-0542 | 202-225-1986 | 202-225-2004 | https://calvert.house.gov/contactform/ | 2205 Rayburn House Office Building | http://calvert.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 | ||||||
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 | ||||||
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 | ||||||
42734 | 42734 | Barbara Lee L000551 | rep | CA | 2015-01-06 | 2017-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 | ||||||
42750 | 42750 | Zoe Lofgren L000397 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 19 | https://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 | ||||||
42843 | 42843 | Doris Matsui M001163 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 6 | http://matsui.house.gov | 2311 Rayburn HOB; Washington DC 20515-0506 | 202-225-7163 | 202-225-0566 | https://matsui.house.gov/email-representative-matsui | 2311 Rayburn House Office Building | http://matsui.house.gov/index.php?format=feed&type=rss | ||||||
42851 | 42851 | Kevin McCarthy M001165 | rep | CA | 2015-01-06 | 2017-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 | ||||||
42867 | 42867 | Tom McClintock M001177 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 4 | http://mcclintock.house.gov | 2331 Rayburn HOB; Washington DC 20515-0504 | 202-225-2511 | 202-225-5444 | https://mcclintockforms.house.gov/forms/contact-form.shtml | 2331 Rayburn House Office Building | http://mcclintock.house.gov/atom.xml | ||||||
42923 | 42923 | Jerry McNerney M001166 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 9 | http://mcnerney.house.gov | 2265 Rayburn HOB; Washington DC 20515-0509 | 202-225-1947 | 202-225-4060 | https://mcnerney.house.gov/contact/email-me | 2265 Rayburn House Office Building | http://mcnerney.house.gov/rss.xml | ||||||
42996 | 42996 | Grace Napolitano N000179 | rep | CA | 2015-01-06 | 2017-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 | ||||||
43086 | 43086 | Nancy Pelosi P000197 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 12 | http://pelosi.house.gov | 233 Cannon HOB; Washington DC 20515-0512 | 202-225-4965 | 202-225-8259 | http://pelosi.house.gov/contact-me/email-me | 233 Cannon House Office Building | http://pelosi.house.gov/atom.xml | ||||||
43192 | 43192 | Lucille Roybal-Allard R000486 | rep | CA | 2015-01-06 | 2017-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 | ||||||
43275 | 43275 | Adam Schiff S001150 | rep | CA | 2015-01-06 | 2017-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/contact | 2411 Rayburn House Office Building | http://schiff.house.gov/common/rss/?rss=49 | ||||||
43365 | 43365 | Brad Sherman S000344 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 30 | http://sherman.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 | ||||||
43436 | 43436 | Jackie Speier S001175 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 14 | http://speier.house.gov | 2465 Rayburn HOB; Washington DC 20515-0514 | 202-225-3531 | 202-347-0956 | https://forms.house.gov/speier/webforms/email_jackie.shtml | 2465 Rayburn House Office Building | http://speier.house.gov/index.php?format=feed&type=rss | ||||||
43446 | 43446 | Linda Sánchez S001156 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 38 | https://lindasanchez.house.gov | 2329 Rayburn HOB; Washington DC 20515-0538 | 202-225-6676 | 202-226-1012 | https://forms.house.gov/lindasanchez/webforms/issue_subscribe.htm | 2329 Rayburn House Office Building | http://lindasanchez.house.gov/index.php?format=feed&type=rss | ||||||
43473 | 43473 | Mike Thompson T000460 | rep | CA | 2015-01-06 | 2017-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 | ||||||
43581 | 43581 | Maxine Waters W000187 | rep | CA | 2015-01-06 | 2017-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 | ||||||
43709 | 43709 | Doug LaMalfa L000578 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 1 | http://lamalfa.house.gov | 322 Cannon HOB; Washington DC 20515-0501 | 202-225-3076 | 530-534-7800 | https://lamalfa.house.gov/contact/email-me | 322 Cannon House Office Building | http://lamalfa.house.gov/rss.xml | ||||||
43714 | 43714 | Jared Huffman H001068 | rep | CA | 2015-01-06 | 2017-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 | ||||||
43719 | 43719 | Ami Bera B001287 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 7 | http://bera.house.gov | 1535 Longworth HOB; Washington DC 20515-0507 | 202-225-5716 | 202-226-1298 | https://beraforms.house.gov/forms/writeyourrep/ | 1535 Longworth House Office Building | http://bera.house.gov/rss.xml | ||||||
43724 | 43724 | Eric Swalwell S001193 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 15 | http://swalwell.house.gov | 129 Cannon HOB; Washington DC 20515-0515 | 202-225-5065 | http://swalwell.house.gov/contact-me/email-eric/ | 129 Cannon House Office Building | ||||||||
43729 | 43729 | Julia Brownley B001285 | rep | CA | 2015-01-06 | 2017-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 | ||||||
43734 | 43734 | Tony Cárdenas C001097 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 29 | http://cardenas.house.gov | 1510 Longworth HOB; Washington DC 20515-0529 | 202-225-6131 | 202-225-0819 | https://cardenas.house.gov/contact/email-me | 1510 Longworth House Office Building | http://cardenas.house.gov/rss.xml | ||||||
43739 | 43739 | Raul Ruiz R000599 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 36 | https://ruiz.house.gov | 1319 Longworth HOB; Washington DC 20515-0536 | 202-225-5330 | 202-225-1238 | https://ruiz.house.gov/email-me | 1319 Longworth House Office Building | http://ruiz.house.gov/rss.xml | ||||||
43744 | 43744 | Mark Takano T000472 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 41 | https://takano.house.gov | 1507 Longworth HOB; Washington DC 20515-0541 | 202-225-2305 | 202-225-7018 | https://takano.house.gov/contact/email-me | 1507 Longworth House Office Building | http://takano.house.gov/rss.xml | ||||||
43749 | 43749 | Alan Lowenthal L000579 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 47 | http://lowenthal.house.gov | 108 Cannon HOB; Washington DC 20515-0547 | 202-225-7924 | 202-225-7926 | http://lowenthal.house.gov/contact/howtocontactme.htm | 108 Cannon House Office Building | http://lowenthal.house.gov/news/rss.aspx | ||||||
43754 | 43754 | Juan Vargas V000130 | rep | CA | 2015-01-06 | 2017-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 | ||||||
43759 | 43759 | Scott Peters P000608 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 52 | http://scottpeters.house.gov | 1122 Longworth HOB; Washington DC 20515-0552 | 202-225-0508 | 202-225-2558 | https://scottpeters.house.gov/contact/email-me | 1122 Longworth House Office Building | http://scottpeters.house.gov/rss.xml | ||||||
43952 | 43952 | Mark DeSaulnier D000623 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 11 | https://desaulnier.house.gov | 327 Cannon HOB; Washington DC 20515-0511 | 202-225-2095 | 202-225-5609 | 327 Cannon House Office Building | ||||||||
43956 | 43956 | Pete Aguilar A000371 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 31 | https://aguilar.house.gov | 1223 Longworth HOB; Washington DC 20515-0531 | 202-225-3201 | 202-226-6962 | 1223 Longworth House Office Building | ||||||||
43960 | 43960 | Ted Lieu L000582 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 33 | https://lieu.house.gov | 415 Cannon HOB; Washington DC 20515-0533 | 202-225-3976 | 202-225-4099 | 415 Cannon House Office Building | ||||||||
43964 | 43964 | Norma Torres T000474 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 35 | https://torres.house.gov | 516 Cannon HOB; Washington DC 20515-0535 | 202-225-6161 | 202-225-8671 | 516 Cannon House Office Building | ||||||||
44452 | 44452 | Darrell Issa I000056 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 49 | http://issa.house.gov | 2269 Rayburn HOB; Washington DC 20515-0549 | 202-225-3906 | 202-225-3303 | http://issa.house.gov/contact/contact-me | 2269 Rayburn House Office Building | http://issa.house.gov/feed/ | ||||||
44468 | 44468 | David Valadao V000129 | rep | CA | 2015-01-06 | 2017-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 | ||||||
40747 | 40747 | Mike Coffman C001077 | rep | CO | 2015-01-06 | 2017-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 | ||||||
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 | ||||||
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 | ||||||
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 | |||||
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 | ||||||
42667 | 42667 | Doug Lamborn L000564 | rep | CO | 2015-01-06 | 2017-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/ | ||||||
43094 | 43094 | Ed Perlmutter P000593 | rep | CO | 2015-01-06 | 2017-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 | ||||||
43968 | 43968 | Ken Buck B001297 | rep | CO | 2015-01-06 | 2017-01-03 | Republican | 4 | https://buck.house.gov | 416 Cannon HOB; Washington DC 20515-0604 | 202-225-4676 | 202-225-5870 | 416 Cannon House Office Building | ||||||||
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 | ||||||
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 | |||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
43029 | 43029 | Eleanor Norton N000147 | rep | DC | 2015-01-06 | 2017-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 | ||||||
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 | ||||||
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 | ||||||
40287 | 40287 | Ander Crenshaw C001045 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 4 | https://crenshaw.house.gov | 2161 Rayburn HOB; Washington DC 20515-0904 | 202-225-2501 | 202-225-2504 | https://forms.house.gov/write/crenshaw/email-me.shtml | 2161 Rayburn House Office Building | |||||||
40407 | 40407 | John Mica M000689 | rep | FL | 2015-01-06 | 2017-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 | ||||||
40415 | 40415 | Jeff Miller M001144 | rep | FL | 2015-01-06 | 2017-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 | ||||||
40425 | 40425 | Richard Nugent N000185 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 11 | https://nugent.house.gov | 1727 Longworth HOB; Washington DC 20515-0911 | 202-225-1002 | 202- 226-6559 | https://nugent.house.gov/contact/email-me | 1727 Longworth House Office Building | http://nugent.house.gov/index.php?format=feed&type=rss |
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);