legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by contact_form descending
This data as json, copyable, CSV (advanced)
Suggested facets: class, start (date), end (date)
how 2 ✖
- appointment 203
- special-election 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41546 | 41546 | Ted Yoho Y000065 | rep | FL | 2013-01-03 | 2015-01-03 | Republican | 3 | http://yoho.house.gov | 511 Cannon HOB; Washington DC 20515-0903 | 202-225-5744 | https://yoho.house.gov/contact/email-me | 511 Cannon House Office Building | http://yoho.house.gov/rss.xml | |||||||
41547 | 41547 | Ted Yoho Y000065 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 3 | http://yoho.house.gov | 511 Cannon HOB; Washington DC 20515-0903 | 202-225-5744 | https://yoho.house.gov/contact/email-me | 511 Cannon House Office Building | http://yoho.house.gov/rss.xml | |||||||
41084 | 41084 | Kevin Yoder Y000063 | rep | KS | 2013-01-03 | 2015-01-03 | Republican | 3 | http://yoder.house.gov | 215 Cannon HOB; Washington DC 20515-1603 | 202-225-2865 | 202-225-2807 | https://yoder.house.gov/contact/email-me | 215 Cannon House Office Building | http://yoder.house.gov/common/rss/index.cfm?rss=49 | ||||||
41085 | 41085 | Kevin Yoder Y000063 | rep | KS | 2015-01-06 | 2017-01-03 | Republican | 3 | http://yoder.house.gov | 215 Cannon HOB; Washington DC 20515-1603 | 202-225-2865 | 202-225-2807 | https://yoder.house.gov/contact/email-me | 215 Cannon House Office Building | http://yoder.house.gov/common/rss/index.cfm?rss=49 | ||||||
43654 | 43654 | Todd Young Y000064 | sen | IN | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.young.senate.gov | 185 Dirksen Senate Office Building Washington DC 20510 | 202-224-5623 | 202-226-6866 | https://www.young.senate.gov/contact | 185 Dirksen Senate Office Building | senior | ||||||
43642 | 43642 | Ron Wyden W000779 | sen | OR | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.wyden.senate.gov | 221 Dirksen Senate Office Building Washington DC 20510 | 202-224-5244 | 202-228-2717 | https://www.wyden.senate.gov/contact/ | 221 Dirksen Senate Office Building | senior | http://www.wyden.senate.gov/rss/feeds/?type=all& | |||||
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 | ||||||
41825 | 41825 | Roger Wicker W000437 | sen | MS | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.wicker.senate.gov | 555 Dirksen Senate Office Building Washington DC 20510 | 202-224-6253 | https://www.wicker.senate.gov/public/index.cfm/contact | 555 Dirksen Senate Office Building | senior | |||||||
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 | |||||
41812 | 41812 | Sheldon Whitehouse W000802 | sen | RI | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.whitehouse.senate.gov | 530 Hart Senate Office Building Washington DC 20510 | 202-224-2921 | 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 | ||||||
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 | |||||
43787 | 43787 | Elizabeth Warren W000817 | sen | MA | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.warren.senate.gov | 309 Hart Senate Office Building Washington DC 20510 | 202-224-4543 | https://www.warren.senate.gov/?p=email_senator | 309 Hart Senate Office Building | senior | http://www.warren.senate.gov/rss/?p=hot_topic | ||||||
44534 | 44534 | Raphael Warnock W000790 | sen | GA | 2021-01-20 | 2023-01-03 | 3 | Democrat | special-election | https://www.warnock.senate.gov | 388 Russell Senate Office Building Washington DC 20510 | 202-224-3643 | https://www.warnock.senate.gov/contact/ | 388 Russell Senate Office Building | junior | ||||||
41892 | 41892 | Mark Warner W000805 | sen | VA | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.warner.senate.gov | 703 Hart Senate Office Building Washington DC 20510 | 202-224-2023 | https://www.warner.senate.gov/public/index.cfm?p=Contact | 703 Hart Senate Office Building | senior | http://www.warner.senate.gov/public/?a=rss.feed | ||||||
43537 | 43537 | Chris Van Hollen V000128 | sen | MD | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.vanhollen.senate.gov | 110 Hart Senate Office Building Washington DC 20510 | 202-224-4654 | 202-225-0375 | https://www.vanhollen.senate.gov/contact/email | 110 Hart Senate Office Building | junior | ||||||
44471 | 44471 | Tommy Tuberville T000278 | sen | AL | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.tuberville.senate.gov | 142 Russell Senate Office Building Washington DC 20510 | 202-224-4124 | https://www.tuberville.senate.gov/contact/contact-form/ | 142 Russell Senate Office Building | junior | |||||||
43501 | 43501 | Patrick Toomey T000461 | sen | PA | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.toomey.senate.gov | 455 Dirksen Senate Office Building Washington DC 20510 | 202-224-4254 | 202-228-0284 | https://www.toomey.senate.gov/?p=contact | 455 Dirksen Senate Office Building | junior | http://toomey.senate.gov/rss/?p=hot_topic | |||||
41284 | 41284 | Tom Udall U000039 | sen | NM | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.tomudall.senate.gov | 531 Hart Senate Office Building Washington DC 20510 | 202-224-6621 | 202-228-3261 | https://www.tomudall.senate.gov/?p=contact | 531 Hart Senate Office Building | senior | http://tomudall.senate.gov/rss/?p=blog | |||||
44076 | 44076 | Thom Tillis T000476 | sen | NC | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.tillis.senate.gov | 113 Dirksen Senate Office Building Washington DC 20510 | 202-224-6342 | https://www.tillis.senate.gov/public/index.cfm/email-me | 113 Dirksen Senate Office Building | junior | |||||||
44077 | 44077 | Thom Tillis T000476 | sen | NC | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.tillis.senate.gov | 113 Dirksen Senate Office Building Washington DC 20510 | 202-224-6342 | https://www.tillis.senate.gov/public/index.cfm/email-me | 113 Dirksen Senate Office Building | junior | |||||||
43489 | 43489 | John Thune T000250 | sen | SD | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.thune.senate.gov | 511 Dirksen Senate Office Building Washington DC 20510 | 202-224-2321 | 202-228-5429 | https://www.thune.senate.gov/public/index.cfm/contact | 511 Dirksen Senate Office Building | senior | http://www.thune.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 | |||||
41809 | 41809 | Jon Tester T000464 | sen | MT | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.tester.senate.gov | 311 Hart Senate Office Building Washington DC 20510 | 202-224-2644 | https://www.tester.senate.gov/?p=email_senator | 311 Hart Senate Office Building | senior | http://www.tester.senate.gov/rss/?p=hot_topic | ||||||
44072 | 44072 | Dan Sullivan S001198 | sen | AK | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.sullivan.senate.gov | 302 Hart Senate Office Building Washington DC 20510 | 202-224-3004 | https://www.sullivan.senate.gov/contact/email | 302 Hart Senate Office Building | junior | |||||||
44073 | 44073 | Dan Sullivan S001198 | sen | AK | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.sullivan.senate.gov | 302 Hart Senate Office Building Washington DC 20510 | 202-224-3004 | https://www.sullivan.senate.gov/contact/email | 302 Hart Senate Office Building | junior | |||||||
40592 | 40592 | Luther Strange S001202 | sen | AL | 2017-02-09 | 2018-01-03 | 2 | Republican | appointment | https://www.strange.senate.gov | 326 Russell Senate Office Building Washington DC 20510 | 202-224-4124 | https://www.strange.senate.gov/content/contact-senator | 326 Russell Senate Office Building | junior | ||||||
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 | |||||
41806 | 41806 | Debbie Stabenow S000770 | sen | MI | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.stabenow.senate.gov | 731 Hart Senate Office Building Washington DC 20510 | 202-224-4822 | https://www.stabenow.senate.gov/contact | 731 Hart Senate Office Building | senior | http://stabenow.senate.gov/rss/?p=news | ||||||
44244 | 44244 | Tina Smith S001203 | sen | MN | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.smith.senate.gov | 720 Hart Senate Office Building Washington DC 20510 | 202-224-5641 | https://www.smith.senate.gov/share-your-opinion/ | 720 Hart Senate Office Building | junior | |||||||
44242 | 44242 | Tina Smith S001203 | sen | MN | 2018-01-03 | 2018-11-06 | 2 | Democrat | appointment | https://www.smith.senate.gov | 309 Hart Senate Office Building Washington DC 20510 | 202-224-5641 | https://www.smith.senate.gov/content/contact-senator | 309 Hart Senate Office Building | junior | special-election | |||||
44243 | 44243 | Tina Smith S001203 | sen | MN | 2018-11-07 | 2021-01-03 | 2 | Democrat | https://www.smith.senate.gov | 720 Hart Senate Office Building Washington DC 20510 | 202-224-5641 | https://www.smith.senate.gov/contact-tina | 720 Hart Senate Office Building | junior | |||||||
43707 | 43707 | Kyrsten Sinema S001191 | sen | AZ | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.sinema.senate.gov | 317 Hart Senate Office Building Washington DC 20510 | 202-224-4521 | https://www.sinema.senate.gov/contact-kyrsten | 317 Hart Senate Office Building | senior | |||||||
43355 | 43355 | Richard Shelby S000320 | sen | AL | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.shelby.senate.gov | 304 Russell Senate Office Building Washington DC 20510 | 202-224-5744 | 202-224-3416 | https://www.shelby.senate.gov/public/index.cfm/emailsenatorshelby | 304 Russell Senate Office Building | senior | http://www.shelby.senate.gov/public/index.cfm/rss/feed | |||||
41888 | 41888 | Jeanne Shaheen S001181 | sen | NH | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.shaheen.senate.gov | 506 Hart Senate Office Building Washington DC 20510 | 202-224-2841 | 202-228-3194 | https://www.shaheen.senate.gov/contact/contact-jeanne | 506 Hart Senate Office Building | senior | http://www.shaheen.senate.gov/rss/ | |||||
41889 | 41889 | Jeanne Shaheen S001181 | sen | NH | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.shaheen.senate.gov | 506 Hart Senate Office Building Washington DC 20510 | 202-224-2841 | https://www.shaheen.senate.gov/contact/contact-jeanne | 506 Hart Senate Office Building | senior | http://www.shaheen.senate.gov/rss/ | ||||||
43339 | 43339 | Tim Scott S001184 | sen | SC | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.scott.senate.gov | 104 Hart Senate Office Building Washington DC 20510 | 202-224-6121 | 202-225-3407 | https://www.scott.senate.gov/contact/email-me | 104 Hart Senate Office Building | junior | http://www.scott.senate.gov/rss.xml | |||||
43298 | 43298 | Charles Schumer S000148 | sen | NY | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.schumer.senate.gov | 322 Hart Senate Office Building Washington DC 20510 | 202-224-6542 | 202-228-3027 | https://www.schumer.senate.gov/contact/email-chuck | 322 Hart Senate Office Building | senior | ||||||
43687 | 43687 | Brian Schatz S001194 | sen | HI | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.schatz.senate.gov | 722 Hart Senate Office Building Washington DC 20510 | 202-224-3934 | 202-228-1153 | https://www.schatz.senate.gov/contact | 722 Hart Senate Office Building | senior | ||||||
44081 | 44081 | Benjamin Sasse S001197 | sen | NE | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.sasse.senate.gov/public | 139 Russell Senate Office Building Washington DC 20510 | 202-224-4224 | https://www.sasse.senate.gov/public/index.cfm/email-ben | 139 Russell Senate Office Building | junior | |||||||
41800 | 41800 | Bernard Sanders S000033 | sen | VT | 2019-01-03 | 2025-01-03 | 1 | Independent | https://www.sanders.senate.gov | Democrat | 332 Dirksen Senate Office Building Washington DC 20510 | 202-224-5141 | https://www.sanders.senate.gov/contact/ | 332 Dirksen Senate Office Building | junior | http://www.sanders.senate.gov/rss/ | |||||
43197 | 43197 | Marco Rubio R000595 | sen | FL | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.rubio.senate.gov | 284 Russell Senate Office Building Washington DC 20510 | 202-224-3041 | 202-228-0285 | https://www.rubio.senate.gov/public/index.cfm/contact | 284 Russell Senate Office Building | senior | http://www.rubio.senate.gov/public/?a=rss.feed | |||||
44078 | 44078 | Mike Rounds R000605 | sen | SD | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.rounds.senate.gov | 502 Hart Senate Office Building Washington DC 20510 | 202-224-5842 | https://www.rounds.senate.gov/contact/email-mike | 502 Hart Senate Office Building | junior | |||||||
44079 | 44079 | Mike Rounds R000605 | sen | SD | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.rounds.senate.gov | 716 Hart Senate Office Building Washington DC 20510 | 202-224-5842 | https://www.rounds.senate.gov/contact/email-mike | 716 Hart Senate Office Building | junior | |||||||
44197 | 44197 | Jacky Rosen R000608 | sen | NV | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.rosen.senate.gov | 713 Hart Senate Office Building Washington DC 20510 | 202-224-6244 | https://www.rosen.senate.gov/contact_jacky | 713 Hart Senate Office Building | junior | |||||||
42603 | 42603 | Ron Johnson J000293 | sen | WI | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.ronjohnson.senate.gov | 328 Hart Senate Office Building Washington DC 20510 | 202-224-5323 | 920-230-7262 | https://www.ronjohnson.senate.gov/public/index.cfm/email-the-senator | 328 Hart Senate Office Building | senior | http://www.ronjohnson.senate.gov/public/index.cfm/rss/feed | |||||
44417 | 44417 | Mitt Romney R000615 | sen | UT | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.romney.senate.gov | 354 Russell Senate Office Building Washington DC 20510 | 202-224-5251 | https://www.romney.senate.gov/contact-senator-romney | 354 Russell Senate Office Building | junior | |||||||
41277 | 41277 | Pat Roberts R000307 | sen | KS | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.roberts.senate.gov | 109 Hart Senate Office Building Washington DC 20510 | 202-224-4774 | 202-224-3514 | https://www.roberts.senate.gov/public/?p=EmailPat | 109 Hart Senate Office Building | senior | http://www.roberts.senate.gov/public/?a=rss.feed | |||||
41886 | 41886 | James Risch R000584 | sen | ID | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.risch.senate.gov | 483 Russell Senate Office Building Washington DC 20510 | 202-224-2752 | https://www.risch.senate.gov/public/index.cfm?p=Email | 483 Russell Senate Office Building | junior | |||||||
44414 | 44414 | Rick Scott S001217 | sen | FL | 2019-01-08 | 2025-01-03 | 1 | Republican | https://www.rickscott.senate.gov | 502 Hart Senate Office Building Washington DC 20510 | 202-224-5274 | https://www.rickscott.senate.gov/contact/contact | 502 Hart Senate Office Building | junior | |||||||
41882 | 41882 | John Reed R000122 | sen | RI | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.reed.senate.gov | 728 Hart Senate Office Building Washington DC 20510 | 202-224-4642 | 202-224-4680 | https://www.reed.senate.gov/contact/ | 728 Hart Senate Office Building | senior | https://www.reed.senate.gov//rss/feeds/?type=all | |||||
41883 | 41883 | John Reed R000122 | sen | RI | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.reed.senate.gov | 728 Hart Senate Office Building Washington DC 20510 | 202-224-4642 | https://www.reed.senate.gov/contact/ | 728 Hart Senate Office Building | senior | https://www.reed.senate.gov//rss/feeds/?type=all | ||||||
43118 | 43118 | Robert Portman P000449 | sen | OH | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.portman.senate.gov | 448 Russell Senate Office Building Washington DC 20510 | 202-224-3353 | https://www.portman.senate.gov/public/index.cfm/contact?p=contact-form | 448 Russell Senate Office Building | junior | http://www.portman.senate.gov/public/index.cfm/rss/feed | ||||||
43117 | 43117 | Robert Portman P000449 | sen | OH | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.portman.senate.gov | 448 Russell Senate Office Building Washington DC 20510 | 202-224-3353 | 202-224-9075 | https://www.portman.senate.gov/public/index.cfm/contact-form | 448 Russell Senate Office Building | junior | http://www.portman.senate.gov/public/index.cfm/rss/feed | |||||
43101 | 43101 | Gary Peters P000595 | sen | MI | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.peters.senate.gov | 724 Hart Senate Office Building Washington DC 20510 | 202-224-6221 | 202-226-2356 | https://www.peters.senate.gov/contact/email-gary | 724 Hart Senate Office Building | junior | ||||||
43102 | 43102 | Gary Peters P000595 | sen | MI | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.peters.senate.gov | 724 Hart Senate Office Building Washington DC 20510 | 202-224-6221 | https://www.peters.senate.gov/contact/email-gary | 724 Hart Senate Office Building | junior | |||||||
41584 | 41584 | David Perdue P000612 | sen | GA | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.perdue.senate.gov | 455 Russell Senate Office Building Washington DC 20510 | 202-224-3521 | https://www.perdue.senate.gov/connect/email | 455 Russell Senate Office Building | senior | |||||||
43071 | 43071 | Rand Paul P000603 | sen | KY | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.paul.senate.gov | 167 Russell Senate Office Building Washington DC 20510 | 202-224-4343 | 202-228-1373 | https://www.paul.senate.gov/connect/email-rand | 167 Russell Senate Office Building | junior | http://paul.senate.gov/rss/?p=news | |||||
44531 | 44531 | Alejandro Padilla P000145 | sen | CA | 2021-01-20 | 2022-11-08 | 3 | Democrat | appointment | https://www.padilla.senate.gov | 112 Hart Senate Office Building Washington DC 20510 | 202-224-3553 | https://www.padilla.senate.gov/contact/ | 112 Hart Senate Office Building | junior | ||||||
44532 | 44532 | Alejandro Padilla P000145 | sen | CA | 2022-11-09 | 2023-01-03 | 3 | Democrat | special-election | https://www.padilla.senate.gov | 112 Hart Senate Office Building Washington DC 20510 | 202-224-3553 | https://www.padilla.senate.gov/contact/ | 112 Hart Senate Office Building | junior | ||||||
44533 | 44533 | Jon Ossoff O000174 | sen | GA | 2021-01-20 | 2027-01-03 | 2 | Democrat | https://www.ossoff.senate.gov | 455 Russell Senate Office Building Washington DC 20510 | 202-224-3521 | https://www.ossoff.senate.gov/contact-us/ | 455 Russell Senate Office Building | senior | |||||||
42971 | 42971 | Patty Murray M001111 | sen | WA | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.murray.senate.gov | 154 Russell Senate Office Building Washington DC 20510 | 202-224-2621 | 202-224-0238 | https://www.murray.senate.gov/write-to-patty/ | 154 Russell Senate Office Building | senior | http://www.murray.senate.gov/public/?a=rss.feed | |||||
42966 | 42966 | Christopher Murphy M001169 | sen | CT | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.murphy.senate.gov | 136 Hart Senate Office Building Washington DC 20510 | 202-224-4041 | https://www.murphy.senate.gov/contact | 136 Hart Senate Office Building | junior | http://www.theday.com/article/20121216/nws12/312169935/1069/rss | ||||||
42961 | 42961 | Lisa Murkowski M001153 | sen | AK | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.murkowski.senate.gov | 522 Hart Senate Office Building Washington DC 20510 | 202-224-6665 | 202-224-5301 | https://www.murkowski.senate.gov/public/index.cfm/contact | 522 Hart Senate Office Building | senior | http://www.murkowski.senate.gov/public/?a=rss.feed | |||||
42957 | 42957 | Jerry Moran M000934 | sen | KS | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.moran.senate.gov | 521 Dirksen Senate Office Building Washington DC 20510 | 202-224-6521 | 202-228-6966 | https://www.moran.senate.gov/public/index.cfm/e-mail-jerry | 521 Dirksen Senate Office Building | senior | http://www.moran.senate.gov/public/index.cfm/rss/feed/ | |||||
41875 | 41875 | Jeff Merkley M001176 | sen | OR | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.merkley.senate.gov | 531 Hart Senate Office Building Washington DC 20510 | 202-224-3753 | https://www.merkley.senate.gov/contact/ | 531 Hart Senate Office Building | junior | http://www.merkley.senate.gov/rss/ | ||||||
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 | |||||
41789 | 41789 | Robert Menendez M000639 | sen | NJ | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.menendez.senate.gov | 528 Hart Senate Office Building Washington DC 20510 | 202-224-4744 | https://www.menendez.senate.gov/contact | 528 Hart Senate Office Building | senior | http://www.menendez.senate.gov/rss/feeds/index.cfm?type=news | ||||||
41254 | 41254 | Martha McSally M001197 | sen | AZ | 2019-01-03 | 2020-12-02 | 3 | Republican | appointment | https://www.mcsally.senate.gov | 404 Russell Senate Office Building Washington DC 20510 | 202-224-2235 | https://www.mcsally.senate.gov/contact_martha | 404 Russell Senate Office Building | junior | special-election | |||||
41872 | 41872 | Mitch McConnell M000355 | sen | KY | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.mcconnell.senate.gov | 317 Russell Senate Office Building Washington DC 20510 | 202-224-2541 | https://www.mcconnell.senate.gov/public/index.cfm?p=contact | 317 Russell Senate Office Building | senior | http://www.mcconnell.senate.gov/public/?a=rss.feed | ||||||
40653 | 40653 | John McCain M000303 | sen | AZ | 2017-01-03 | 2018-08-25 | 3 | Republican | https://www.mccain.senate.gov | 218 Russell Senate Office Building Washington DC 20510 | 202-224-2235 | 202-228-2862 | https://www.mccain.senate.gov/public/index.cfm/contact-form | 218 Russell Senate Office Building | senior | ||||||
44171 | 44171 | Roger Marshall M001198 | sen | KS | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.marshall.senate.gov | 479A Russell Senate Office Building Washington DC 20510 | 202-224-4774 | https://www.marshall.senate.gov/contact/ | 479a Russell Senate Office Building | junior | |||||||
42836 | 42836 | Edward Markey M000133 | sen | MA | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.markey.senate.gov | 255 Dirksen Senate Office Building Washington DC 20510 | 202-224-2742 | https://www.markey.senate.gov/contact | 255 Dirksen Senate Office Building | junior | |||||||
42837 | 42837 | Edward Markey M000133 | sen | MA | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.markey.senate.gov | 255 Dirksen Senate Office Building Washington DC 20510 | 202-224-2742 | https://www.markey.senate.gov/contact | 255 Dirksen Senate Office Building | junior | |||||||
41903 | 41903 | Joe Manchin M001183 | sen | WV | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.manchin.senate.gov | 306 Hart Senate Office Building Washington DC 20510 | 202-224-3954 | https://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 | ||||||
44444 | 44444 | Cynthia Lummis L000571 | sen | WY | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.lummis.senate.gov | 124 Russell Senate Office Building Washington DC 20510 | 202-224-3424 | https://www.lummis.senate.gov/contact/contact-form/ | 124 Russell Senate Office Building | junior | |||||||
42788 | 42788 | Ben Luján L000570 | sen | NM | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.lujan.senate.gov | 498 Russell Senate Office Building Washington DC 20510 | 202-224-6621 | https://www.lujan.senate.gov/contact/ | 498 Russell Senate Office Building | junior | |||||||
41618 | 41618 | Kelly Loeffler L000594 | sen | GA | 2020-01-06 | 2021-01-20 | 3 | Republican | appointment | https://www.loeffler.senate.gov | 131 Russell Senate Office Building Washington DC 20510 | 202-224-3643 | https://www.loeffler.senate.gov/connect/email-kelly | 131 Russell Senate Office Building | junior | special-election | |||||
41854 | 41854 | Lindsey Graham G000359 | sen | SC | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.lgraham.senate.gov/public | 290 Russell Senate Office Building Washington DC 20510 | 202-224-5972 | 202-224-3808 | https://www.lgraham.senate.gov/public/index.cfm/e-mail-senator-graham | 290 Russell Senate Office Building | senior | http://www.lgraham.senate.gov/public/index.cfm?FuseAction=Rss.Feed | |||||
41855 | 41855 | Lindsey Graham G000359 | sen | SC | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.lgraham.senate.gov/public | 290 Russell Senate Office Building Washington DC 20510 | 202-224-5972 | https://www.lgraham.senate.gov/public/index.cfm/e-mail-senator-graham | 290 Russell Senate Office Building | senior | http://www.lgraham.senate.gov/public/index.cfm?FuseAction=Rss.Feed | ||||||
39720 | 39720 | Carl Levin L000261 | sen | MI | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.levin.senate.gov | 269 Russell Senate Office Building Washington DC 20510 | 202-224-6221 | 202-224-1388 | https://www.levin.senate.gov/contact/email/ | 269 Russell Senate Office Building | senior | http://www.levin.senate.gov/rss/feeds/?type=all | |||||
42739 | 42739 | Mike Lee L000577 | sen | UT | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.lee.senate.gov | 363 Russell Senate Office Building Washington DC 20510 | 202-224-5444 | https://www.lee.senate.gov/public/index.cfm/contact | 363 Russell Senate Office Building | senior | http://www.lee.senate.gov/public/index.cfm/rss/feed | ||||||
42723 | 42723 | Patrick Leahy L000174 | sen | VT | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.leahy.senate.gov | 437 Russell Senate Office Building Washington DC 20510 | 202-224-4242 | 202-224-3479 | https://www.leahy.senate.gov/contact/ | 437 Russell Senate Office Building | senior | http://www.leahy.senate.gov/rss/feeds/press/ | |||||
42724 | 42724 | Patrick Leahy L000174 | sen | VT | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.leahy.senate.gov | 437 Russell Senate Office Building Washington DC 20510 | 202-224-4242 | 202-224-3479 | https://www.leahy.senate.gov/contact/ | 437 Russell Senate Office Building | senior | http://www.leahy.senate.gov/rss/feeds/press/ | |||||
42685 | 42685 | James Lankford L000575 | sen | OK | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.lankford.senate.gov | 316 Hart Senate Office Building Washington DC 20510 | 202-224-5754 | https://www.lankford.senate.gov/contact/email | 316 Hart Senate Office Building | junior | |||||||
40666 | 40666 | Jon Kyl K000352 | sen | AZ | 2018-09-05 | 2018-12-31 | 3 | Republican | appointment | https://www.kyl.senate.gov | G12 Dirksen Senate Office Building Washington DC 20510 | 202-224-2235 | 202-228-2862 | https://www.kyl.senate.gov/content/contact-senator-kyl | G12 Dirksen Senate Office Building | junior | |||||
41778 | 41778 | Amy Klobuchar K000367 | sen | MN | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.klobuchar.senate.gov | 425 Dirksen Senate Office Building Washington DC 20510 | 202-224-3244 | https://www.klobuchar.senate.gov/public/index.cfm/contact | 425 Dirksen 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 | ||||
43789 | 43789 | Angus King K000383 | sen | ME | 2019-01-03 | 2025-01-03 | 1 | Independent | https://www.king.senate.gov | Democrat | 133 Hart Senate Office Building Washington DC 20510 | 202-224-5344 | https://www.king.senate.gov/contact | 133 Hart Senate Office Building | junior | http://www.king.senate.gov/rss/feeds/?type=all | |||||
44102 | 44102 | John Kennedy K000393 | sen | LA | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.kennedy.senate.gov/public | 416 Russell Senate Office Building Washington DC 20510 | 202-224-4623 | https://www.kennedy.senate.gov/public/email-me | 416 Russell Senate Office Building | junior | |||||||
44439 | 44439 | Mark Kelly K000377 | sen | AZ | 2020-12-02 | 2023-01-03 | 3 | Democrat | special-election | https://www.kelly.senate.gov | 516 Hart Senate Office Building Washington DC 20510 | 202-224-2235 | https://www.kelly.senate.gov | 516 Hart 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 | |||||
43897 | 43897 | Timothy Kaine K000384 | sen | VA | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.kaine.senate.gov | 231 Russell Senate Office Building Washington DC 20510 | 202-224-4024 | https://www.kaine.senate.gov/contact | 231 Russell Senate Office Building | junior | http://www.kaine.senate.gov/rss/feeds/?type=all | ||||||
41594 | 41594 | Doug Jones J000300 | sen | AL | 2018-01-03 | 2021-01-03 | 2 | Democrat | https://www.jones.senate.gov | 330 Hart Senate Office Building Washington DC 20510 | 202-224-4124 | https://www.jones.senate.gov/content/contact-senator | 330 Hart Senate Office Building | junior | |||||||
41215 | 41215 | John Isakson I000055 | sen | GA | 2017-01-03 | 2019-12-31 | 3 | Republican | https://www.isakson.senate.gov | 131 Russell Senate Office Building Washington DC 20510 | 202-224-3643 | 202-228-0724 | https://www.isakson.senate.gov/public/index.cfm/email-me | 131 Russell Senate Office Building | senior | http://www.isakson.senate.gov/public/?a=RSS.Feed | |||||
41864 | 41864 | James Inhofe I000024 | sen | OK | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.inhofe.senate.gov | 205 Russell Senate Office Building Washington DC 20510 | 202-224-4721 | 202-228-0380 | https://www.inhofe.senate.gov/contact | 205 Russell Senate Office Building | senior | http://www.inhofe.senate.gov/rss/feeds/?type=all&cachebuster=eea6c4d7%2d939c%2d5c1e%2db6c7aa3b8b291208 | |||||
41865 | 41865 | James Inhofe I000024 | sen | OK | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.inhofe.senate.gov | 205 Russell Senate Office Building Washington DC 20510 | 202-224-4721 | https://www.inhofe.senate.gov/contact | 205 Russell Senate Office Building | senior | http://www.inhofe.senate.gov/rss/feeds/?type=all&cachebuster=eea6c4d7%2d939c%2d5c1e%2db6c7aa3b8b291208 | ||||||
44245 | 44245 | Cindy Hyde-Smith H001079 | sen | MS | 2018-04-09 | 2018-11-27 | 2 | Republican | appointment | https://www.hydesmith.senate.gov | G12 Dirksen Senate Office Building Washington DC 20510 | 202-224-5054 | https://www.hydesmith.senate.gov/content/contact-senator | G12 Dirksen Senate Office Building | junior | special-election | |||||
44246 | 44246 | Cindy Hyde-Smith H001079 | sen | MS | 2018-11-28 | 2021-01-03 | 2 | Republican | https://www.hydesmith.senate.gov | 702 Hart Senate Office Building Washington DC 20510 | 202-224-5054 | https://www.hydesmith.senate.gov/content/contact-senator | 702 Hart Senate Office Building | junior | |||||||
44247 | 44247 | Cindy Hyde-Smith H001079 | sen | MS | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.hydesmith.senate.gov | 702 Hart Senate Office Building Washington DC 20510 | 202-224-5054 | https://www.hydesmith.senate.gov/content/contact-senator | 702 Hart Senate Office Building | junior | |||||||
42531 | 42531 | John Hoeven H001061 | sen | ND | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.hoeven.senate.gov | 338 Russell Senate Office Building Washington DC 20510 | 202-224-2551 | 202-224-7999 | https://www.hoeven.senate.gov/contact/email-the-senator/form | 338 Russell Senate Office Building | senior | http://www.hoeven.senate.gov/public/index.cfm/rss/feed |
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);