legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
470 rows where "end" is on date 2019-01-03 sorted by phone
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, state_rank
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41110 | 41110 | Heidi Heitkamp H001069 | sen | ND | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.heitkamp.senate.gov/public | 516 Hart Senate Office Building Washington DC 20510 | 202-224-2043 | 202-224-7776 | http://www.heitkamp.senate.gov/public/index.cfm/contact | 516 Hart Senate Office Building | junior | http://www.heitkamp.senate.gov/public/index.cfm/rss/feed | |||||
41738 | 41738 | Sherrod Brown B000944 | sen | OH | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.brown.senate.gov | 713 Hart Senate Office Building Washington DC 20510 | 202-224-2315 | 202-228-6321 | http://www.brown.senate.gov/contact/ | 713 Hart Senate Office Building | senior | http://www.brown.senate.gov/rss/feeds/?type=all& | |||||
41765 | 41765 | Thomas Carper C000174 | sen | DE | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.carper.senate.gov/public | 513 Hart Senate Office Building Washington DC 20510 | 202-224-2441 | 202-228-2190 | http://www.carper.senate.gov/public/index.cfm/email-senator-carper | 513 Hart Senate Office Building | senior | http://www.carper.senate.gov/public/index.cfm/rss/feed | |||||
41808 | 41808 | Jon Tester T000464 | sen | MT | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.tester.senate.gov | 311 Hart Senate Office Building Washington DC 20510 | 202-224-2644 | 202-224-8594 | https://www.tester.senate.gov/?p=email_senator | 311 Hart Senate Office Building | senior | http://www.tester.senate.gov/rss/?p=hot_topic | |||||
41811 | 41811 | Sheldon Whitehouse W000802 | sen | RI | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.whitehouse.senate.gov | 530 Hart Senate Office Building Washington DC 20510 | 202-224-2921 | 202-228-6362 | https://www.whitehouse.senate.gov/contact/email-sheldon | 530 Hart Senate Office Building | junior | http://www.whitehouse.senate.gov/rss/feeds/?type=all&cachebuster=1 | |||||
41777 | 41777 | Amy Klobuchar K000367 | sen | MN | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.klobuchar.senate.gov | 302 Hart Senate Office Building Washington DC 20510 | 202-224-3244 | 202-228-2186 | http://www.klobuchar.senate.gov/public/index.cfm/contact | 302 Hart Senate Office Building | senior | ||||||
40671 | 40671 | Bob Corker C001071 | sen | TN | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.corker.senate.gov | 425 Dirksen Senate Office Building Washington DC 20510 | 202-224-3344 | 202-228-0566 | https://www.corker.senate.gov/public/index.cfm/emailme | 425 Dirksen Senate Office Building | junior | http://www.corker.senate.gov/public/index.cfm/rss/feed | |||||
41743 | 41743 | Maria Cantwell C000127 | sen | WA | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.cantwell.senate.gov | 511 Hart Senate Office Building Washington DC 20510 | 202-224-3441 | 202-228-0514 | http://www.cantwell.senate.gov/public/index.cfm/email-maria | 511 Hart Senate Office Building | junior | http://www.cantwell.senate.gov/public/index.cfm/rss/feed | |||||
41774 | 41774 | Dianne Feinstein F000062 | sen | CA | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.feinstein.senate.gov | 331 Hart Senate Office Building Washington DC 20510 | 202-224-3841 | 202-228-3954 | https://www.feinstein.senate.gov/public/index.cfm/e-mail-me | 331 Hart Senate Office Building | senior | http://www.feinstein.senate.gov/public/?a=rss.feed | |||||
41902 | 41902 | Joe Manchin M001183 | sen | WV | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.manchin.senate.gov | 306 Hart Senate Office Building Washington DC 20510 | 202-224-3954 | 202-228-0002 | http://www.manchin.senate.gov/public/index.cfm/contact-form | 306 Hart Senate Office Building | senior | http://www.manchin.senate.gov/public/index.cfm/rss/feed | |||||
43896 | 43896 | Timothy Kaine K000384 | sen | VA | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.kaine.senate.gov | 231 Russell Senate Office Building Washington DC 20510 | 202-224-4024 | 202-228-6363 | https://www.kaine.senate.gov/contact | 231 Russell Senate Office Building | junior | http://www.kaine.senate.gov/rss/feeds/?type=all | |||||
42965 | 42965 | Christopher Murphy M001169 | sen | CT | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.murphy.senate.gov | 136 Hart Senate Office Building Washington DC 20510 | 202-224-4041 | 202-225-5933 | http://www.murphy.senate.gov/contact | 136 Hart Senate Office Building | junior | http://www.theday.com/article/20121216/nws12/312169935/1069/rss | |||||
41896 | 41896 | Kirsten Gillibrand G000555 | sen | NY | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.gillibrand.senate.gov | 478 Russell Senate Office Building Washington DC 20510 | 202-224-4451 | 202-228-0282 | https://www.gillibrand.senate.gov/contact/email-me | 478 Russell Senate Office Building | junior | http://www.gillibrand.senate.gov/rss/ | |||||
40804 | 40804 | Jeff Flake F000444 | sen | AZ | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.flake.senate.gov/public | 413 Russell Senate Office Building Washington DC 20510 | 202-224-4521 | 202-226-4386 | https://www.flake.senate.gov/public/index.cfm/contact-jeff | 413 Russell Senate Office Building | senior | http://www.flake.senate.gov/public/index.cfm/rss/feed | |||||
41756 | 41756 | Benjamin Cardin C000141 | sen | MD | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.cardin.senate.gov | 509 Hart Senate Office Building Washington DC 20510 | 202-224-4524 | 202-224-1651 | http://www.cardin.senate.gov/contact/ | 509 Hart Senate Office Building | senior | http://www.cardin.senate.gov/rss/feeds/?type=all | |||||
43786 | 43786 | Elizabeth Warren W000817 | sen | MA | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.warren.senate.gov | 317 Hart Senate Office Building Washington DC 20510 | 202-224-4543 | 202-228-2072 | https://www.warren.senate.gov/?p=email_senator | 317 Hart Senate Office Building | senior | http://www.warren.senate.gov/rss/?p=hot_topic | |||||
41788 | 41788 | Robert Menendez M000639 | sen | NJ | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.menendez.senate.gov | 528 Hart Senate Office Building Washington DC 20510 | 202-224-4744 | 202-228-2197 | https://www.menendez.senate.gov/contact | 528 Hart Senate Office Building | senior | http://www.menendez.senate.gov/rss/feeds/index.cfm?type=news | |||||
40775 | 40775 | Joe Donnelly D000607 | sen | IN | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.donnelly.senate.gov | 720 Hart Senate Office Building Washington DC 20510 | 202-224-4814 | 202-225-6798 | https://www.donnelly.senate.gov/contact/email-joe | 720 Hart Senate Office Building | senior | http://www.donnelly.senate.gov/rss/feeds/?type=all | |||||
41805 | 41805 | Debbie Stabenow S000770 | sen | MI | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.stabenow.senate.gov | 731 Hart Senate Office Building Washington DC 20510 | 202-224-4822 | 202-228-0325 | https://www.stabenow.senate.gov/contact | 731 Hart Senate Office Building | senior | http://stabenow.senate.gov/rss/?p=news | |||||
41799 | 41799 | Bernard Sanders S000033 | sen | VT | 2013-01-03 | 2019-01-03 | 1 | Independent | https://www.sanders.senate.gov | Democrat | 332 Dirksen Senate Office Building Washington DC 20510 | 202-224-5141 | 202-228-0776 | http://www.sanders.senate.gov/contact/ | 332 Dirksen Senate Office Building | junior | http://www.sanders.senate.gov/rss/ | ||||
40678 | 40678 | Orrin Hatch H000338 | sen | UT | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.hatch.senate.gov | 104 Hart Senate Office Building Washington DC 20510 | 202-224-5251 | 202-224-6331 | http://www.hatch.senate.gov/public/index.cfm/contact?p=Email-Orrin | 104 Hart Senate Office Building | senior | http://www.hatch.senate.gov/public/index.cfm/rss/feed | |||||
40689 | 40689 | Bill Nelson N000032 | sen | FL | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.billnelson.senate.gov | 716 Hart Senate Office Building Washington DC 20510 | 202-224-5274 | 202-228-2183 | https://www.billnelson.senate.gov/contact-bill | 716 Hart Senate Office Building | senior | ||||||
43788 | 43788 | Angus King K000383 | sen | ME | 2013-01-03 | 2019-01-03 | 1 | Independent | https://www.king.senate.gov | Democrat | 133 Hart Senate Office Building Washington DC 20510 | 202-224-5344 | 202-224-1946 | https://www.king.senate.gov/contact | 133 Hart Senate Office Building | junior | http://www.king.senate.gov/rss/feeds/?type=all | ||||
42501 | 42501 | Martin Heinrich H001046 | sen | NM | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.heinrich.senate.gov | 303 Hart Senate Office Building Washington DC 20510 | 202-224-5521 | 202-225-4975 | http://www.heinrich.senate.gov/contact | 303 Hart Senate Office Building | junior | ||||||
41924 | 41924 | Tammy Baldwin B001230 | sen | WI | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.baldwin.senate.gov | 709 Hart Senate Office Building Washington DC 20510 | 202-224-5653 | 202-225-6942 | https://www.baldwin.senate.gov/feedback | 709 Hart Senate Office Building | junior | http://www.baldwin.senate.gov/rss/feeds/?type=all | |||||
43869 | 43869 | Ted Cruz C001098 | sen | TX | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.cruz.senate.gov | 404 Russell Senate Office Building Washington DC 20510 | 202-224-5922 | 202-228-3398 | https://www.cruz.senate.gov/?p=form&id=16 | 404 Russell Senate Office Building | junior | ||||||
40680 | 40680 | Claire McCaskill M001170 | sen | MO | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.mccaskill.senate.gov | 503 Hart Senate Office Building Washington DC 20510 | 202-224-6154 | 202-228-6326 | http://www.mccaskill.senate.gov/contact | 503 Hart Senate Office Building | senior | http://mccaskill.senate.gov/rss/?p=news | |||||
41091 | 41091 | Dean Heller H001041 | sen | NV | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.heller.senate.gov/public | 324 Hart Senate Office Building Washington DC 20510 | 202-224-6244 | 202-228-6753 | http://www.heller.senate.gov/public/index.cfm/contact-form | 324 Hart Senate Office Building | senior | http://www.heller.senate.gov/public/index.cfm/rss/feed | |||||
41824 | 41824 | Roger Wicker W000437 | sen | MS | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.wicker.senate.gov | 555 Dirksen Senate Office Building Washington DC 20510 | 202-224-6253 | 202-228-0378 | https://www.wicker.senate.gov/public/index.cfm/contact | 555 Dirksen Senate Office Building | senior | ||||||
41768 | 41768 | Robert Casey C001070 | sen | PA | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.casey.senate.gov | 393 Russell Senate Office Building Washington DC 20510 | 202-224-6324 | 202-228-0604 | https://www.casey.senate.gov/contact/ | 393 Russell Senate Office Building | senior | http://www.casey.senate.gov/rss/feeds/?all | |||||
42528 | 42528 | Mazie Hirono H001042 | sen | HI | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.hirono.senate.gov | 730 Hart Senate Office Building Washington DC 20510 | 202-224-6361 | 202-225-4987 | https://www.hirono.senate.gov/contact | 730 Hart Senate Office Building | junior | http://www.hirono.senate.gov/rss/feeds/?type=all | |||||
41814 | 41814 | John Barrasso B001261 | sen | WY | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.barrasso.senate.gov | 307 Dirksen Senate Office Building Washington DC 20510 | 202-224-6441 | 202-224-1724 | https://www.barrasso.senate.gov/public/index.cfm/contact-form | 307 Dirksen Senate Office Building | junior | http://www.barrasso.senate.gov/public/index.cfm?FuseAction=Rss.Feed | |||||
43812 | 43812 | Deb Fischer F000463 | sen | NE | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.fischer.senate.gov | 454 Russell Senate Office Building Washington DC 20510 | 202-224-6551 | 202-228-1325 | http://www.fischer.senate.gov/public/index.cfm/contact | 454 Russell Senate Office Building | senior | http://www.fischer.senate.gov/public/index.cfm/rss/feed | |||||
44142 | 44142 | Al Lawson L000586 | rep | FL | 2017-01-03 | 2019-01-03 | Democrat | 5 | https://lawson.house.gov | 1337 Longworth House Office Building; Washington DC 20515-0905 | 202-225-0123 | 1337 Longworth House Office Building | |||||||||
41297 | 41297 | Rob Bishop B001250 | rep | UT | 2017-01-03 | 2019-01-03 | Republican | 1 | https://robbishop.house.gov | 123 Cannon House Office Building; Washington DC 20515-4401 | 202-225-0453 | 202-225-5857 | 123 Cannon House Office Building | http://robbishop.house.gov/news/rss.aspx | |||||||
43760 | 43760 | Scott Peters P000608 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 52 | https://scottpeters.house.gov | 1122 Longworth House Office Building; Washington DC 20515-0552 | 202-225-0508 | 202-225-2558 | 1122 Longworth House Office Building | http://scottpeters.house.gov/rss.xml | |||||||
43910 | 43910 | Robin Kelly K000385 | rep | IL | 2017-01-03 | 2019-01-03 | Democrat | 2 | https://robinkelly.house.gov | 1239 Longworth House Office Building; Washington DC 20515-1302 | 202-225-0773 | 202-225-4583 | 1239 Longworth House Office Building | http://robinkelly.house.gov/rss.xml | |||||||
43664 | 43664 | Suzanne Bonamici B001278 | rep | OR | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://bonamici.house.gov | 439 Cannon House Office Building; Washington DC 20515-3701 | 202-225-0855 | 202-225-9497 | 439 Cannon House Office Building | http://bonamici.house.gov/rss.xml | |||||||
43588 | 43588 | Daniel Webster W000806 | rep | FL | 2017-01-03 | 2019-01-03 | Republican | 11 | https://webster.house.gov | 1210 Longworth House Office Building; Washington DC 20515-0911 | 202-225-1002 | 202-225-0999 | 1210 Longworth House Office Building | http://webster.house.gov/news/rss.aspx | |||||||
40722 | 40722 | Madeleine Bordallo B001245 | rep | GU | 2017-01-03 | 2019-01-03 | Democrat | 0 | https://bordallo.house.gov | 2441 Rayburn House Office Building; Washington DC 20515-5301 | 202-225-1188 | 202-226-0341 | 2441 Rayburn House Office Building | http://bordallo.house.gov/rss.xml | |||||||
41022 | 41022 | Dennis Ross R000593 | rep | FL | 2017-01-03 | 2019-01-03 | Republican | 15 | https://dennisross.house.gov | 436 Cannon House Office Building; Washington DC 20515-0915 | 202-225-1252 | 202-226-0585 | 436 Cannon House Office Building | http://dennisross.house.gov/news/rss.aspx | |||||||
41643 | 41643 | Alcee Hastings H000324 | rep | FL | 2017-01-03 | 2019-01-03 | Democrat | 20 | https://alceehastings.house.gov | 2353 Rayburn House Office Building; Washington DC 20515-0920 | 202-225-1313 | 202-225-1171 | 2353 Rayburn House Office Building | http://www.alceehastings.house.gov/news/rss.aspx | |||||||
42195 | 42195 | Gerald Connolly C001078 | rep | VA | 2017-01-03 | 2019-01-03 | Democrat | 11 | https://connolly.house.gov | 2238 Rayburn House Office Building; Washington DC 20515-4611 | 202-225-1492 | 202-225-3071 | 2238 Rayburn House Office Building | http://connolly.house.gov/common/rss//index.cfm?rss=44 | |||||||
43933 | 43933 | Alma Adams A000370 | rep | NC | 2017-01-03 | 2019-01-03 | Democrat | 12 | https://adams.house.gov | 222 Cannon House Office Building; Washington DC 20515-3312 | 202-225-1510 | 202-225-1512 | 222 Cannon House Office Building | ||||||||
44045 | 44045 | Brian Babin B001291 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 36 | https://babin.house.gov | 316 Cannon House Office Building; Washington DC 20515-4336 | 202-225-1555 | 202-226-0396 | 316 Cannon House Office Building | ||||||||
42599 | 42599 | Henry Johnson J000288 | rep | GA | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://hankjohnson.house.gov | 2240 Rayburn House Office Building; Washington DC 20515-1004 | 202-225-1605 | 202-226-0691 | 2240 Rayburn House Office Building | http://hankjohnson.house.gov/rss.xml | |||||||
43797 | 43797 | Ann Wagner W000812 | rep | MO | 2017-01-03 | 2019-01-03 | Republican | 2 | https://wagner.house.gov | 435 Cannon House Office Building; Washington DC 20515-2502 | 202-225-1621 | 202-225-2563 | 435 Cannon House Office Building | http://wagner.house.gov/rss.xml | |||||||
42250 | 42250 | Henry Cuellar C001063 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 28 | https://cuellar.house.gov | 2209 Rayburn House Office Building; Washington DC 20515-4328 | 202-225-1640 | 202-225-1641 | 2209 Rayburn House Office Building | http://cuellar.house.gov/news/rss.aspx | |||||||
40846 | 40846 | Gene Green G000410 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 29 | https://green.house.gov | 2470 Rayburn House Office Building; Washington DC 20515-4329 | 202-225-1688 | 202-225-9903 | 2470 Rayburn House Office Building | http://green.house.gov/rss.xml | |||||||
43193 | 43193 | Lucille Roybal-Allard R000486 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 40 | https://roybal-allard.house.gov | 2083 Rayburn House Office Building; Washington DC 20515-0540 | 202-225-1766 | 202-226-0350 | 2083 Rayburn House Office Building | http://roybal-allard.house.gov/news/rss.aspx | |||||||
43140 | 43140 | David Price P000523 | rep | NC | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://price.house.gov | 2108 Rayburn House Office Building; Washington DC 20515-3304 | 202-225-1784 | 202-225-2014 | 2108 Rayburn House Office Building | http://price.house.gov/index.php?format=feed&type=rss | |||||||
44053 | 44053 | Stacey Plaskett P000610 | rep | VI | 2017-01-03 | 2019-01-03 | Democrat | 0 | https://plaskett.house.gov | 331 Cannon House Office Building; Washington DC 20515-5500 | 202-225-1790 | 202-225-5517 | 331 Cannon House Office Building | ||||||||
42397 | 42397 | John Garamendi G000559 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 3 | https://garamendi.house.gov | 2438 Rayburn House Office Building; Washington DC 20515-0503 | 202-225-1880 | 202-225-5914 | 2438 Rayburn House Office Building | http://garamendi.house.gov/rss.xml | |||||||
42924 | 42924 | Jerry McNerney M001166 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 9 | https://mcnerney.house.gov | 2265 Rayburn House Office Building; Washington DC 20515-0509 | 202-225-1947 | 202-225-4060 | 2265 Rayburn House Office Building | http://mcnerney.house.gov/rss.xml | |||||||
41127 | 41127 | Steve Knight K000387 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 25 | https://knight.house.gov | 1023 Longworth House Office Building; Washington DC 20515-0525 | 202-225-1956 | 202-226-0683 | 1023 Longworth House Office Building | ||||||||
41109 | 41109 | Robert Pittenger P000606 | rep | NC | 2017-01-03 | 2019-01-03 | Republican | 9 | https://pittenger.house.gov | 224 Cannon House Office Building; Washington DC 20515-3309 | 202-225-1976 | 202-225-3389 | 224 Cannon House Office Building | http://pittenger.house.gov/rss.xml | |||||||
42072 | 42072 | Ken Calvert C000059 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 42 | https://calvert.house.gov | 2205 Rayburn House Office Building; Washington DC 20515-0542 | 202-225-1986 | 202-225-2004 | 2205 Rayburn House Office Building | http://calvert.house.gov/news/rss.aspx | |||||||
40710 | 40710 | Joe Barton B000213 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 6 | https://joebarton.house.gov | 2107 Rayburn House Office Building; Washington DC 20515-4306 | 202-225-2002 | 202-225-3052 | 2107 Rayburn House Office Building | http://joebarton.house.gov/index.php?format=feed&type=rss | |||||||
42916 | 42916 | Cathy McMorris Rodgers M001159 | rep | WA | 2017-01-03 | 2019-01-03 | Republican | 5 | https://mcmorris.house.gov | 1314 Longworth House Office Building; Washington DC 20515-4705 | 202-225-2006 | 202-225-3392 | 1314 Longworth House Office Building | http://mcmorris.house.gov/common/rss/?rss=96 | |||||||
44266 | 44266 | Mary Scanlon S001205 | rep | PA | 2018-11-13 | 2019-01-03 | Democrat | 7 | https://scanlon.house.gov | 2305 Rayburn House Office Building; Washington DC 20515-3807 | 202-225-2011 | 2305 Rayburn House Office Building | |||||||||
41649 | 41649 | Steve Stivers S001187 | rep | OH | 2017-01-03 | 2019-01-03 | Republican | 15 | https://stivers.house.gov | 1022 Longworth House Office Building; Washington DC 20515-3515 | 202-225-2015 | 202-225-3529 | 1022 Longworth House Office Building | http://stivers.house.gov/news/rss.aspx | |||||||
44172 | 44172 | Clay Higgins H001077 | rep | LA | 2017-01-03 | 2019-01-03 | Republican | 3 | https://clayhiggins.house.gov | 1711 Longworth House Office Building; Washington DC 20515-1803 | 202-225-2031 | 1711 Longworth House Office Building | |||||||||
41325 | 41325 | Susan Davis D000598 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 53 | https://susandavis.house.gov | 1214 Longworth House Office Building; Washington DC 20515-0553 | 202-225-2040 | 202-225-2948 | 1214 Longworth House Office Building | ||||||||
41113 | 41113 | Keith Rothfus R000598 | rep | PA | 2017-01-03 | 2019-01-03 | Republican | 12 | https://rothfus.house.gov | 1205 Longworth House Office Building; Washington DC 20515-3812 | 202-225-2065 | 202-225-5709 | 1205 Longworth House Office Building | http://rothfus.house.gov/rss.xml | |||||||
42390 | 42390 | Virginia Foxx F000450 | rep | NC | 2017-01-03 | 2019-01-03 | Republican | 5 | https://foxx.house.gov | 2262 Rayburn House Office Building; Washington DC 20515-3305 | 202-225-2071 | 202-225-2995 | 2262 Rayburn House Office Building | http://foxx.house.gov/common/rss/?rss=55 | |||||||
42228 | 42228 | Joe Courtney C001069 | rep | CT | 2017-01-03 | 2019-01-03 | Democrat | 2 | https://courtney.house.gov | 2348 Rayburn House Office Building; Washington DC 20515-0702 | 202-225-2076 | 202-225-4977 | 2348 Rayburn House Office Building | http://courtney.house.gov/index.php?format=feed&type=rss | |||||||
43953 | 43953 | Mark DeSaulnier D000623 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 11 | https://desaulnier.house.gov | 115 Cannon House Office Building; Washington DC 20515-0511 | 202-225-2095 | 202-225-5609 | 115 Cannon House Office Building | ||||||||
41590 | 41590 | Paul Mitchell M001201 | rep | MI | 2017-01-03 | 2019-01-03 | Republican | 10 | https://mitchell.house.gov | 211 Cannon House Office Building; Washington DC 20515-2210 | 202-225-2106 | 211 Cannon House Office Building | |||||||||
43265 | 43265 | Janice Schakowsky S001145 | rep | IL | 2017-01-03 | 2019-01-03 | Democrat | 9 | https://schakowsky.house.gov | 2367 Rayburn House Office Building; Washington DC 20515-1309 | 202-225-2111 | 202-226-6890 | 2367 Rayburn House Office Building | http://schakowsky.house.gov/index.php?format=feed&type=rss | |||||||
41145 | 41145 | Steve Russell R000604 | rep | OK | 2017-01-03 | 2019-01-03 | Republican | 5 | https://russell.house.gov | 128 Cannon House Office Building; Washington DC 20515-3605 | 202-225-2132 | 202-226-1463 | 128 Cannon House Office Building | ||||||||
42354 | 42354 | Michael Doyle D000482 | rep | PA | 2017-01-03 | 2019-01-03 | Democrat | 14 | https://doyle.house.gov | 239 Cannon House Office Building; Washington DC 20515-3814 | 202-225-2135 | 202-225-3084 | 239 Cannon House Office Building | http://doyle.house.gov/rss.xml | |||||||
40962 | 40962 | Jared Polis P000598 | rep | CO | 2017-01-03 | 2019-01-03 | Democrat | 2 | https://polis.house.gov | 1727 Longworth House Office Building; Washington DC 20515-0602 | 202-225-2161 | 202-226-7840 | 1727 Longworth House Office Building | http://polis.house.gov/news/rss.aspx | |||||||
41432 | 41432 | Collin Peterson P000258 | rep | MN | 2017-01-03 | 2019-01-03 | Democrat | 7 | https://collinpeterson.house.gov | 2204 Rayburn House Office Building; Washington DC 20515-2307 | 202-225-2165 | 202-225-1593 | 2204 Rayburn House Office Building | http://collinpeterson.house.gov/rss.xml | |||||||
44151 | 44151 | Val Demings D000627 | rep | FL | 2017-01-03 | 2019-01-03 | Democrat | 10 | https://demings.house.gov | 238 Cannon House Office Building; Washington DC 20515-0910 | 202-225-2176 | 238 Cannon House Office Building | |||||||||
43302 | 43302 | David Schweikert S001183 | rep | AZ | 2017-01-03 | 2019-01-03 | Republican | 6 | https://schweikert.house.gov | 2059 Rayburn House Office Building; Washington DC 20515-0306 | 202-225-2190 | 202-225-0096 | 2059 Rayburn House Office Building | http://schweikert.house.gov/rss/press-releases.xml | |||||||
43582 | 43582 | Maxine Waters W000187 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 43 | https://waters.house.gov | 2221 Rayburn House Office Building; Washington DC 20515-0543 | 202-225-2201 | 202-225-7854 | 2221 Rayburn House Office Building | http://waters.house.gov/news/rss.aspx | |||||||
44260 | 44260 | Kevin Hern H001082 | rep | OK | 2018-11-13 | 2019-01-03 | Republican | 1 | https://hern.house.gov | 216 Cannon House Office Building; Washington DC 20515-3601 | 202-225-2211 | 216 Cannon House Office Building | |||||||||
42125 | 42125 | Steve Chabot C000266 | rep | OH | 2017-01-03 | 2019-01-03 | Republican | 1 | https://chabot.house.gov | 2371 Rayburn House Office Building; Washington DC 20515-3501 | 202-225-2216 | 202-225-3012 | 2371 Rayburn House Office Building | http://chabot.house.gov/common/rss/index.cfm?rss=49 | |||||||
44465 | 44465 | Pete Sessions S000250 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 32 | https://sessions.house.gov | 2233 Rayburn House Office Building; Washington DC 20515-4332 | 202-225-2231 | 202-225-5878 | 2233 Rayburn House Office Building | http://sessions.house.gov/?a=rss.feed | |||||||
42706 | 42706 | John Larson L000557 | rep | CT | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://larson.house.gov | 1501 Longworth House Office Building; Washington DC 20515-0701 | 202-225-2265 | 202-225-1031 | 1501 Longworth House Office Building | http://www.larson.house.gov/index.php?format=feed&type=rss | |||||||
41162 | 41162 | Jason Lewis L000587 | rep | MN | 2017-01-03 | 2019-01-03 | Republican | 2 | https://jasonlewis.house.gov | 418 Cannon House Office Building; Washington DC 20515-2302 | 202-225-2271 | 418 Cannon House Office Building | |||||||||
41560 | 41560 | Susan Brooks B001284 | rep | IN | 2017-01-03 | 2019-01-03 | Republican | 5 | https://susanwbrooks.house.gov | 1030 Longworth House Office Building; Washington DC 20515-1405 | 202-225-2276 | 202-225-0016 | 1030 Longworth House Office Building | http://susanwbrooks.house.gov/rss.xml | |||||||
44248 | 44248 | Conor Lamb L000588 | rep | PA | 2018-04-12 | 2019-01-03 | Democrat | 18 | https://lamb.house.gov/ | 2332 Rayburn House Office Building; Washington DC 20515-3818 | 202-225-2301 | 2332 Rayburn House Office Building | |||||||||
43745 | 43745 | Mark Takano T000472 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 41 | https://takano.house.gov | 1507 Longworth House Office Building; Washington DC 20515-0541 | 202-225-2305 | 202-225-7018 | 1507 Longworth House Office Building | http://takano.house.gov/rss.xml | |||||||
44227 | 44227 | Liz Cheney C001109 | rep | WY | 2017-01-03 | 2019-01-03 | Republican | 0 | https://cheney.house.gov | 416 Cannon House Office Building; Washington DC 20515-5000 | 202-225-2311 | 416 Cannon House Office Building | |||||||||
42418 | 42418 | Paul Gosar G000565 | rep | AZ | 2017-01-03 | 2019-01-03 | Republican | 4 | https://gosar.house.gov | 2057 Rayburn House Office Building; Washington DC 20515-0304 | 202-225-2315 | 202-226-9739 | 2057 Rayburn House Office Building | http://gosar.house.gov/rss.xml | |||||||
44013 | 44013 | Tom Emmer E000294 | rep | MN | 2017-01-03 | 2019-01-03 | Republican | 6 | https://emmer.house.gov | 315 Cannon House Office Building; Washington DC 20515-2306 | 202-225-2331 | 202-225-6475 | 315 Cannon House Office Building | ||||||||
43550 | 43550 | Nydia Velázquez V000081 | rep | NY | 2017-01-03 | 2019-01-03 | Democrat | 7 | https://velazquez.house.gov | 2302 Rayburn House Office Building; Washington DC 20515-3207 | 202-225-2361 | 202-226-0327 | 2302 Rayburn House Office Building | ||||||||
40950 | 40950 | Stevan Pearce P000588 | rep | NM | 2017-01-03 | 2019-01-03 | Republican | 2 | https://pearce.house.gov | 2432 Rayburn House Office Building; Washington DC 20515-3102 | 202-225-2365 | 2432 Rayburn House Office Building | http://pearce.house.gov/rss.xml | ||||||||
43773 | 43773 | Rodney Davis D000619 | rep | IL | 2017-01-03 | 2019-01-03 | Republican | 13 | https://rodneydavis.house.gov | 1740 Longworth House Office Building; Washington DC 20515-1313 | 202-225-2371 | 217-791-6168 | 1740 Longworth House Office Building | http://rodneydavis.house.gov/rss.xml | |||||||
42861 | 42861 | Michael McCaul M001157 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 10 | https://mccaul.house.gov | 2001 Rayburn House Office Building; Washington DC 20515-4310 | 202-225-2401 | 202-225-5955 | 2001 Rayburn House Office Building | ||||||||
41307 | 41307 | Wm. Clay C001049 | rep | MO | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://lacyclay.house.gov | 2428 Rayburn House Office Building; Washington DC 20515-2501 | 202-225-2406 | 202-226-3717 | 2428 Rayburn House Office Building | ||||||||
44207 | 44207 | Lloyd Smucker S001199 | rep | PA | 2017-01-03 | 2019-01-03 | Republican | 16 | https://smucker.house.gov | 516 Cannon House Office Building; Washington DC 20515-3816 | 202-225-2411 | 516 Cannon House Office Building | |||||||||
40988 | 40988 | Dana Rohrabacher R000409 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 48 | https://rohrabacher.house.gov | 2300 Rayburn House Office Building; Washington DC 20515-0548 | 202-225-2415 | 202-225-0145 | 2300 Rayburn House Office Building | http://rohrabacher.house.gov/rss.xml | |||||||
41054 | 41054 | Bill Shuster S001154 | rep | PA | 2017-01-03 | 2019-01-03 | Republican | 9 | https://shuster.house.gov | 2079 Rayburn House Office Building; Washington DC 20515-3809 | 202-225-2431 | 202-225-2486 | 2079 Rayburn House Office Building | http://shuster.house.gov/common/rss//index.cfm?rss=49 | |||||||
42477 | 42477 | Raúl Grijalva G000551 | rep | AZ | 2017-01-03 | 2019-01-03 | Democrat | 3 | https://grijalva.house.gov | 1511 Longworth House Office Building; Washington DC 20515-0303 | 202-225-2435 | 202-225-1541 | 1511 Longworth House Office Building | http://grijalva.house.gov/common/rss/?rss=13 | |||||||
43607 | 43607 | Joe Wilson W000795 | rep | SC | 2017-01-03 | 2019-01-03 | Republican | 2 | https://joewilson.house.gov | 1436 Longworth House Office Building; Washington DC 20515-4002 | 202-225-2452 | 202-225-2455 | 1436 Longworth House Office Building | http://joewilson.house.gov/news/rss.aspx | |||||||
41528 | 41528 | Peter Visclosky V000108 | rep | IN | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://visclosky.house.gov | 2328 Rayburn House Office Building; Washington DC 20515-1401 | 202-225-2461 | 202-225-2493 | 2328 Rayburn House Office Building | http://visclosky.house.gov/rss.xml | |||||||
41341 | 41341 | Eliot Engel E000179 | rep | NY | 2017-01-03 | 2019-01-03 | Democrat | 16 | https://engel.house.gov | 2462 Rayburn House Office Building; Washington DC 20515-3216 | 202-225-2464 | 202-225-5513 | 2462 Rayburn House Office Building | ||||||||
41082 | 41082 | Timothy Walz W000799 | rep | MN | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://walz.house.gov | 2313 Rayburn House Office Building; Washington DC 20515-2301 | 202-225-2472 | 202-225-3433 | 2313 Rayburn House Office Building | http://walz.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);