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 start
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||
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 | |||||
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 | |||||
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 | ||||||
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 | |||||
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 | |||||
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 | |||||
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& | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | ||||||
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 | |||||
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/ | ||||
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 | |||||
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 | |||||
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 | |||||
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 | ||||||
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/ | |||||
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 | |||||
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 | |||||
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 | ||||||
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 | |||||
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 | |||||
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 | |||||
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 | ||||
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 | |||||
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 | ||||||
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 | |||||
40693 | 40693 | Lou Barletta B001269 | rep | PA | 2017-01-03 | 2019-01-03 | Republican | 11 | https://barletta.house.gov | 2049 Rayburn House Office Building; Washington DC 20515-3811 | 202-225-6511 | 202-225-0764 | 2049 Rayburn House Office Building | http://barletta.house.gov/common/rss//index.cfm?rss=25 | |||||||
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 | |||||||
40714 | 40714 | Diane Black B001273 | rep | TN | 2017-01-03 | 2019-01-03 | Republican | 6 | https://black.house.gov | 1131 Longworth House Office Building; Washington DC 20515-4206 | 202-225-4231 | 202-225-6887 | 1131 Longworth House Office Building | http://black.house.gov/rss.xml | |||||||
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 | |||||||
40733 | 40733 | Robert Brady B001227 | rep | PA | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://brady.house.gov | 2004 Rayburn House Office Building; Washington DC 20515-3801 | 202-225-4731 | 202-225-0088 | 2004 Rayburn House Office Building | http://brady.house.gov/rss.xml | |||||||
40743 | 40743 | Michael Capuano C001037 | rep | MA | 2017-01-03 | 2019-01-03 | Democrat | 7 | http://capuano.house.gov | 1414 Longworth House Office Building; Washington DC 20515-2107 | 202-225-5111 | 202-225-9322 | 1414 Longworth House Office Building | ||||||||
40748 | 40748 | Mike Coffman C001077 | rep | CO | 2017-01-03 | 2019-01-03 | Republican | 6 | https://coffman.house.gov | 2443 Rayburn House Office Building; Washington DC 20515-0606 | 202-225-7882 | 202-226-4623 | 2443 Rayburn House Office Building | http://coffman.house.gov/index.php?format=feed&type=rss | |||||||
40758 | 40758 | Joseph Crowley C001038 | rep | NY | 2017-01-03 | 2019-01-03 | Democrat | 14 | https://crowley.house.gov | 1035 Longworth House Office Building; Washington DC 20515-3214 | 202-225-3965 | 202-225-1909 | 1035 Longworth House Office Building | http://crowley.house.gov/rss.xml | |||||||
40767 | 40767 | John Culberson C001048 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 7 | https://culberson.house.gov | 2161 Rayburn House Office Building; Washington DC 20515-4307 | 202-225-2571 | 202-225-4381 | 2161 Rayburn House Office Building | http://culberson.house.gov/rss/ | |||||||
40771 | 40771 | Jeff Denham D000612 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 10 | https://denham.house.gov | 1730 Longworth House Office Building; Washington DC 20515-0510 | 202-225-4540 | 202-225-3402 | 1730 Longworth House Office Building | http://denham.house.gov/rss.xml | |||||||
40791 | 40791 | John Duncan D000533 | rep | TN | 2017-01-03 | 2019-01-03 | Republican | 2 | https://duncan.house.gov | 2207 Rayburn House Office Building; Washington DC 20515-4202 | 202-225-5435 | 202-225-6440 | 2207 Rayburn House Office Building | http://duncan.house.gov/rss.xml | |||||||
40797 | 40797 | Keith Ellison E000288 | rep | MN | 2017-01-03 | 2019-01-03 | Democrat | 5 | https://ellison.house.gov | 2263 Rayburn House Office Building; Washington DC 20515-2305 | 202-225-4755 | 202-225-4886 | 2263 Rayburn House Office Building | http://ellison.house.gov/index.php?format=feed&type=rss | |||||||
40816 | 40816 | Rodney Frelinghuysen F000372 | rep | NJ | 2017-01-03 | 2019-01-03 | Republican | 11 | https://frelinghuysen.house.gov | 2306 Rayburn House Office Building; Washington DC 20515-3011 | 202-225-5034 | 202-225-3186 | 2306 Rayburn House Office Building | http://frelinghuysen.house.gov/common/rss/?rss=3 | |||||||
40829 | 40829 | Bob Goodlatte G000289 | rep | VA | 2017-01-03 | 2019-01-03 | Republican | 6 | https://goodlatte.house.gov | 2309 Rayburn House Office Building; Washington DC 20515-4606 | 202-225-5431 | 202-225-9681 | 2309 Rayburn House Office Building | http://goodlatte.house.gov/press_releases.rss | |||||||
40833 | 40833 | Trey Gowdy G000566 | rep | SC | 2017-01-03 | 2019-01-03 | Republican | 4 | https://gowdy.house.gov | 2418 Rayburn House Office Building; Washington DC 20515-4004 | 202-225-6030 | 202-226-1177 | 2418 Rayburn House Office Building | http://gowdy.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 | |||||||
40859 | 40859 | Luis Gutiérrez G000535 | rep | IL | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://gutierrez.house.gov | 2408 Rayburn House Office Building; Washington DC 20515-1304 | 202-225-8203 | 202-225-7810 | 2408 Rayburn House Office Building | http://gutierrez.house.gov/rss.xml | |||||||
40864 | 40864 | Gregg Harper H001045 | rep | MS | 2017-01-03 | 2019-01-03 | Republican | 3 | https://harper.house.gov | 2227 Rayburn House Office Building; Washington DC 20515-2403 | 202-225-5031 | 202-225-5797 | 2227 Rayburn House Office Building | http://harper.house.gov/rss.xml | |||||||
40872 | 40872 | Jeb Hensarling H001036 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 5 | https://hensarling.house.gov | 2228 Rayburn House Office Building; Washington DC 20515-4305 | 202-225-3484 | 202-226-4888 | 2228 Rayburn House Office Building | http://hensarling.house.gov/atom.xml | |||||||
40876 | 40876 | Randy Hultgren H001059 | rep | IL | 2017-01-03 | 2019-01-03 | Republican | 14 | https://hultgren.house.gov | 2455 Rayburn House Office Building; Washington DC 20515-1314 | 202-225-2976 | 202-225-0697 | 2455 Rayburn House Office Building | http://hultgren.house.gov/common/rss//index.cfm?rss=49 | |||||||
40881 | 40881 | Lynn Jenkins J000290 | rep | KS | 2017-01-03 | 2019-01-03 | Republican | 2 | https://lynnjenkins.house.gov | 1526 Longworth House Office Building; Washington DC 20515-1602 | 202-225-6601 | 202-225-7986 | 1526 Longworth House Office Building | http://lynnjenkins.house.gov/common/rss/?rss=220 | |||||||
40895 | 40895 | Sam Johnson J000174 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 3 | https://samjohnson.house.gov | 2304 Rayburn House Office Building; Washington DC 20515-4303 | 202-225-4201 | 202-225-1485 | 2304 Rayburn House Office Building | http://samjohnson.house.gov/news/rss.aspx | |||||||
40899 | 40899 | Raúl Labrador L000573 | rep | ID | 2017-01-03 | 2019-01-03 | Republican | 1 | https://labrador.house.gov | 1523 Longworth House Office Building; Washington DC 20515-1201 | 202-225-6611 | 202-225-3029 | 1523 Longworth House Office Building | http://labrador.house.gov/common/rss//index.cfm?rss=49 | |||||||
40904 | 40904 | Leonard Lance L000567 | rep | NJ | 2017-01-03 | 2019-01-03 | Republican | 7 | https://lance.house.gov | 2352 Rayburn House Office Building; Washington DC 20515-3007 | 202-225-5361 | 202-225-9460 | 2352 Rayburn House Office Building | http://lance.house.gov/rss-button/rss-button/ | |||||||
40922 | 40922 | Sander Levin L000263 | rep | MI | 2017-01-03 | 2019-01-03 | Democrat | 9 | https://levin.house.gov | 1236 Longworth House Office Building; Washington DC 20515-2209 | 202-225-4961 | 202-226-1033 | 1236 Longworth House Office Building | http://levin.house.gov/rss.xml | |||||||
40934 | 40934 | Frank LoBiondo L000554 | rep | NJ | 2017-01-03 | 2019-01-03 | Republican | 2 | https://lobiondo.house.gov | 2427 Rayburn House Office Building; Washington DC 20515-3002 | 202-225-6572 | 202-225-3318 | 2427 Rayburn House Office Building | http://lobiondo.house.gov/rss.xml | |||||||
40938 | 40938 | Kristi Noem N000184 | rep | SD | 2017-01-03 | 2019-01-03 | Republican | 0 | https://noem.house.gov | 2457 Rayburn House Office Building; Washington DC 20515-4100 | 202-225-2801 | 202-225-5823 | 2457 Rayburn House Office Building | http://noem.house.gov/index.cfm/rss/feed | |||||||
40943 | 40943 | Erik Paulsen P000594 | rep | MN | 2017-01-03 | 2019-01-03 | Republican | 3 | https://paulsen.house.gov | 127 Cannon House Office Building; Washington DC 20515-2303 | 202-225-2871 | 202-225-6351 | 127 Cannon House Office Building | http://paulsen.house.gov/common/rss//?rss=105 | |||||||
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 | ||||||||
40957 | 40957 | Ted Poe P000592 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 2 | https://poe.house.gov | 2132 Rayburn House Office Building; Washington DC 20515-4302 | 202-225-6565 | 202-225-5547 | 2132 Rayburn House Office Building | http://poe.house.gov/index.php?format=feed&type=rss | |||||||
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 | |||||||
40969 | 40969 | David Reichert R000578 | rep | WA | 2017-01-03 | 2019-01-03 | Republican | 8 | https://reichert.house.gov | 1127 Longworth House Office Building; Washington DC 20515-4708 | 202-225-7761 | 202-225-4282 | 1127 Longworth House Office Building | http://reichert.house.gov/rss.xml | |||||||
40973 | 40973 | James Renacci R000586 | rep | OH | 2017-01-03 | 2019-01-03 | Republican | 16 | https://renacci.house.gov | 328 Cannon House Office Building; Washington DC 20515-3516 | 202-225-3876 | 202-225-3059 | 328 Cannon House Office Building | http://renacci.house.gov/common/rss//index.cfm?rss=25 | |||||||
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 | |||||||
40992 | 40992 | Todd Rokita R000592 | rep | IN | 2017-01-03 | 2019-01-03 | Republican | 4 | http://rokita.house.gov | 2439 Rayburn House Office Building; Washington DC 20515-1404 | 202-225-5037 | 202-226-0544 | 2439 Rayburn House Office Building | http://rokita.house.gov/rss.xml | |||||||
40997 | 40997 | Thomas Rooney R000583 | rep | FL | 2017-01-03 | 2019-01-03 | Republican | 17 | https://rooney.house.gov | 2160 Rayburn House Office Building; Washington DC 20515-0917 | 202-225-5792 | 202-225-3132 | 2160 Rayburn House Office Building | http://rooney.house.gov/index.php?format=feed&type=rss | |||||||
41012 | 41012 | Ileana Ros-Lehtinen R000435 | rep | FL | 2017-01-03 | 2019-01-03 | Republican | 27 | https://ros-lehtinen.house.gov | 2206 Rayburn House Office Building; Washington DC 20515-0927 | 202-225-3931 | 202-225-5620 | 2206 Rayburn House Office Building | http://ros-lehtinen.house.gov/rss.xml | |||||||
41018 | 41018 | Peter Roskam R000580 | rep | IL | 2017-01-03 | 2019-01-03 | Republican | 6 | https://roskam.house.gov | 2246 Rayburn House Office Building; Washington DC 20515-1306 | 202-225-4561 | 202-225-1166 | 2246 Rayburn House Office Building | http://roskam.house.gov/index.php?format=feed&type=rss | |||||||
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 | |||||||
41035 | 41035 | Edward Royce R000487 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 39 | https://royce.house.gov | 2310 Rayburn House Office Building; Washington DC 20515-0539 | 202-225-4111 | 202-226-0335 | 2310 Rayburn House Office Building | http://royce.house.gov/news/rss.aspx | |||||||
41045 | 41045 | Paul Ryan R000570 | rep | WI | 2017-01-03 | 2019-01-03 | Republican | 1 | https://paulryan.house.gov | 1233 Longworth House Office Building; Washington DC 20515-4901 | 202-225-3031 | 202-225-3393 | 1233 Longworth House Office Building | http://paulryan.house.gov/news/rss.aspx | |||||||
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 | |||||||
41070 | 41070 | Lamar Smith S000583 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 21 | https://lamarsmith.house.gov | 2409 Rayburn House Office Building; Washington DC 20515-4321 | 202-225-4236 | 202-225-8628 | 2409 Rayburn House Office Building | http://lamarsmith.house.gov/news/rss.aspx | |||||||
41076 | 41076 | Niki Tsongas T000465 | rep | MA | 2017-01-03 | 2019-01-03 | Democrat | 3 | https://tsongas.house.gov | 1714 Longworth House Office Building; Washington DC 20515-2103 | 202-225-3411 | 202-226-0771 | 1714 Longworth House Office Building | http://tsongas.house.gov/rss/press-releases.xml | |||||||
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 | |||||||
41086 | 41086 | Kevin Yoder Y000063 | rep | KS | 2017-01-03 | 2019-01-03 | Republican | 3 | https://yoder.house.gov | 2433 Rayburn House Office Building; Washington DC 20515-1603 | 202-225-2865 | 202-225-2807 | 2433 Rayburn House Office Building | http://yoder.house.gov/common/rss/index.cfm?rss=49 | |||||||
41094 | 41094 | Elizabeth Esty E000293 | rep | CT | 2017-01-03 | 2019-01-03 | Democrat | 5 | https://esty.house.gov | 221 Cannon House Office Building; Washington DC 20515-0705 | 202-225-4476 | 202-225-5933 | 221 Cannon House Office Building | http://esty.house.gov/rss.xml | |||||||
41097 | 41097 | Luke Messer M001189 | rep | IN | 2017-01-03 | 2019-01-03 | Republican | 6 | https://messer.house.gov | 1230 Longworth House Office Building; Washington DC 20515-1406 | 202-225-3021 | 765-747-5586 | 1230 Longworth House Office Building | http://messer.house.gov/rss.xml | |||||||
41100 | 41100 | John Delaney D000620 | rep | MD | 2017-01-03 | 2019-01-03 | Democrat | 6 | https://delaney.house.gov | 1632 Longworth House Office Building; Washington DC 20515-2006 | 202-225-2721 | 202-225-2193 | 1632 Longworth House Office Building | http://delaney.house.gov/rss.xml | |||||||
41106 | 41106 | Richard Nolan N000127 | rep | MN | 2017-01-03 | 2019-01-03 | Democrat | 8 | https://nolan.house.gov | 2366 Rayburn House Office Building; Washington DC 20515-2308 | 202-225-6211 | 202-225-0699 | 2366 Rayburn House Office Building | http://nolan.house.gov/rss.xml | |||||||
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 | |||||||
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 | |||||||
41116 | 41116 | Beto O’Rourke O000170 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 16 | https://orourke.house.gov | 1330 Longworth House Office Building; Washington DC 20515-4316 | 202-225-4831 | 1330 Longworth House Office Building | http://orourke.house.gov/rss.xml | ||||||||
41122 | 41122 | Marshall Sanford S000051 | rep | SC | 2017-01-03 | 2019-01-03 | Republican | 1 | https://sanford.house.gov | 2211 Rayburn House Office Building; Washington DC 20515-4001 | 202-225-3176 | 843-521-2535 | 2211 Rayburn House Office Building | http://sanford.house.gov/rss.xml | |||||||
41125 | 41125 | David Brat B001290 | rep | VA | 2017-01-03 | 2019-01-03 | Republican | 7 | https://brat.house.gov | 1628 Longworth House Office Building; Washington DC 20515-4607 | 202-225-2815 | 1628 Longworth House Office Building | |||||||||
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 | ||||||||
41129 | 41129 | Mimi Walters W000820 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 45 | https://walters.house.gov | 215 Cannon House Office Building; Washington DC 20515-0545 | 202-225-5611 | 202-225-9177 | 215 Cannon House Office Building | ||||||||
41131 | 41131 | Carlos Curbelo C001107 | rep | FL | 2017-01-03 | 2019-01-03 | Republican | 26 | https://curbelo.house.gov | 1404 Longworth House Office Building; Washington DC 20515-0926 | 202-225-2778 | 1404 Longworth House Office Building | |||||||||
41133 | 41133 | Rod Blum B001294 | rep | IA | 2017-01-03 | 2019-01-03 | Republican | 1 | https://blum.house.gov | 1108 Longworth House Office Building; Washington DC 20515-1501 | 202-225-2911 | 1108 Longworth House Office Building | |||||||||
41135 | 41135 | David Young Y000066 | rep | IA | 2017-01-03 | 2019-01-03 | Republican | 3 | https://davidyoung.house.gov | 240 Cannon House Office Building; Washington DC 20515-1503 | 202-225-5476 | 240 Cannon House Office Building | |||||||||
41137 | 41137 | Bruce Poliquin P000611 | rep | ME | 2017-01-03 | 2019-01-03 | Republican | 2 | https://poliquin.house.gov | 1208 Longworth House Office Building; Washington DC 20515-1902 | 202-225-6306 | 202-225-2943 | 1208 Longworth House Office Building | ||||||||
41139 | 41139 | Mike Bishop B001293 | rep | MI | 2017-01-03 | 2019-01-03 | Republican | 8 | https://mikebishop.house.gov | 428 Cannon House Office Building; Washington DC 20515-2208 | 202-225-4872 | 202-225-5820 | 428 Cannon House Office Building | ||||||||
41141 | 41141 | Dave Trott T000475 | rep | MI | 2017-01-03 | 2019-01-03 | Republican | 11 | https://trott.house.gov | 1722 Longworth House Office Building; Washington DC 20515-2211 | 202-225-8171 | 1722 Longworth House Office Building | |||||||||
41143 | 41143 | Tom MacArthur M001193 | rep | NJ | 2017-01-03 | 2019-01-03 | Republican | 3 | https://macarthur.house.gov | 506 Cannon House Office Building; Washington DC 20515-3003 | 202-225-4765 | 202-225-0778 | 506 Cannon House Office Building | ||||||||
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 | ||||||||
41147 | 41147 | Ryan Costello C001106 | rep | PA | 2017-01-03 | 2019-01-03 | Republican | 6 | https://costello.house.gov | 326 Cannon House Office Building; Washington DC 20515-3806 | 202-225-4315 | 202-225-8440 | 326 Cannon House Office Building | ||||||||
41149 | 41149 | Mia Love L000584 | rep | UT | 2017-01-03 | 2019-01-03 | Republican | 4 | https://love.house.gov | 217 Cannon House Office Building; Washington DC 20515-4404 | 202-225-3011 | 202-225-5638 | 217 Cannon House Office Building |
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);