legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by office descending
This data as json, copyable, CSV (advanced)
Suggested facets: class, how, start (date), end (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||
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 | |||||
39703 | 39703 | Thomas Harkin H000206 | sen | IA | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.harkin.senate.gov | 731 Hart Senate Office Building Washington DC 20510 | 202-224-3254 | 202-224-9369 | http://www.harkin.senate.gov/contact.cfm | 731 Hart Senate Office Building | junior | http://www.harkin.senate.gov/rss/rss.cfm | |||||
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 | ||||||
39733 | 39733 | Mark Udall U000038 | sen | CO | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.markudall.senate.gov | 730 Hart Senate Office Building Washington DC 20510 | 202-224-5941 | 202-226-7840 | http://www.markudall.senate.gov/?p=contact_us | 730 Hart Senate Office Building | senior | http://markudall.senate.gov/rss/?p=blog | |||||
40665 | 40665 | Jon Kyl K000352 | sen | AZ | 2007-01-04 | 2013-01-03 | 1 | Republican | http://kyl.senate.gov/ | 730 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-4521 | 202-224-2207 | http://www.kyl.senate.gov/contact.cfm | 730 Hart Senate Office Building | |||||||
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 | |||||
44074 | 44074 | Joni Ernst E000295 | sen | IA | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.ernst.senate.gov/public | 730 Hart Senate Office Building Washington DC 20510 | 202-224-3254 | https://www.ernst.senate.gov/public/index.cfm/contact | 730 Hart Senate Office Building | junior | |||||||
44075 | 44075 | Joni Ernst E000295 | sen | IA | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.ernst.senate.gov | 730 Hart Senate Office Building Washington DC 20510 | 202-224-3254 | https://www.ernst.senate.gov/public/index.cfm/contact | 730 Hart Senate Office Building | junior | |||||||
41881 | 41881 | John Reed R000122 | sen | RI | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.reed.senate.gov | 728 Hart Senate Office Building Washington DC 20510 | 202-224-4642 | 202-224-4680 | http://www.reed.senate.gov/contact/ | 728 Hart Senate Office Building | senior | https://www.reed.senate.gov//rss/feeds/?type=all | |||||
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 | ||||||
41807 | 41807 | Jon Tester T000464 | sen | MT | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://tester.senate.gov/ | 724 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-2644 | 202-224-8594 | http://www.tester.senate.gov/Contact/index.cfm | 724 Hart Senate Office Building | |||||||
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 | |||||||
39029 | 39029 | Daniel Inouye I000025 | sen | HI | 2011-01-05 | 2012-12-17 | 3 | Democrat | http://inouye.senate.gov/ | 722 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-3934 | 202-224-6747 | http://www.inouye.senate.gov/Contact/ContactDKI.cfm | 722 Hart Senate Office Building | |||||||
43685 | 43685 | Brian Schatz S001194 | sen | HI | 2012-12-27 | 2015-01-03 | 3 | Democrat | appointment | http://www.schatz.senate.gov | 722 Hart Senate Office Building Washington DC 20510 | 202-224-3934 | 202-228-1153 | http://www.schatz.senate.gov/contact | 722 Hart Senate Office Building | senior | |||||
43686 | 43686 | Brian Schatz S001194 | sen | HI | 2015-01-06 | 2017-01-03 | 3 | Democrat | http://www.schatz.senate.gov | 722 Hart Senate Office Building Washington DC 20510 | 202-224-3934 | 202-228-1153 | http://www.schatz.senate.gov/contact | 722 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 | ||||||
39070 | 39070 | Ben Nelson N000180 | sen | NE | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://bennelson.senate.gov/ | 720 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-6551 | 202-228-0012 | http://www.bennelson.senate.gov/contact-me.cfm | 720 Hart Senate Office Building | |||||||
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 | |||||
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 | |||||||
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 | |||||||
41810 | 41810 | Sheldon Whitehouse W000802 | sen | RI | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://whitehouse.senate.gov/ | 717 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-2921 | 202-228-6362 | http://www.whitehouse.senate.gov/contact/ | 717 Hart Senate Office Building | |||||||
43919 | 43919 | Cory Booker B001288 | sen | NJ | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.booker.senate.gov | 717 Hart Senate Office Building Washington DC 20510 | 202-224-3224 | 202-224-8378 | https://www.booker.senate.gov/?p=contact | 717 Hart Senate Office Building | junior | ||||||
43920 | 43920 | Cory Booker B001288 | sen | NJ | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.booker.senate.gov | 717 Hart Senate Office Building Washington DC 20510 | 202-224-3224 | https://www.booker.senate.gov/?p=contact | 717 Hart Senate Office Building | junior | |||||||
40688 | 40688 | Bill Nelson N000032 | sen | FL | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://billnelson.senate.gov/ | 716 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-5274 | 202-228-2183 | http://www.billnelson.senate.gov/contact/index.cfm | 716 Hart Senate Office Building | |||||||
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 | ||||||
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 | |||||||
41737 | 41737 | Sherrod Brown B000944 | sen | OH | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://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 | |||||||
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& | |||||
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 | |||||||
41845 | 41845 | Richard Durbin D000563 | sen | IL | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.durbin.senate.gov | 711 Hart Senate Office Building Washington DC 20510 | 202-224-2152 | 202-228-0400 | http://www.durbin.senate.gov/public/index.cfm/contact | 711 Hart Senate Office Building | senior | http://durbin.senate.gov/public/index.cfm/rss/feed | |||||
41846 | 41846 | Richard Durbin D000563 | sen | IL | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.durbin.senate.gov | 711 Hart Senate Office Building Washington DC 20510 | 202-224-2152 | 202-228-0400 | https://www.durbin.senate.gov/contact/ | 711 Hart Senate Office Building | senior | http://durbin.senate.gov/public/index.cfm/rss/feed | |||||
41847 | 41847 | Richard Durbin D000563 | sen | IL | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.durbin.senate.gov | 711 Hart Senate Office Building Washington DC 20510 | 202-224-2152 | https://www.durbin.senate.gov/contact/ | 711 Hart Senate Office Building | senior | http://durbin.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 | |||||
41925 | 41925 | Tammy Baldwin B001230 | sen | WI | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.baldwin.senate.gov | 709 Hart Senate Office Building Washington DC 20510 | 202-224-5653 | https://www.baldwin.senate.gov/feedback | 709 Hart Senate Office Building | junior | http://www.baldwin.senate.gov/rss/feeds/?type=all | ||||||
42960 | 42960 | Lisa Murkowski M001153 | sen | AK | 2011-01-05 | 2017-01-03 | 3 | Republican | https://www.murkowski.senate.gov | 709 Hart Senate Office Building Washington DC 20510 | 202-224-6665 | 202-224-5301 | http://www.murkowski.senate.gov/public/index.cfm?p=EMailLisa | 709 Hart Senate Office Building | senior | http://www.murkowski.senate.gov/public/?a=rss.feed | |||||
39062 | 39062 | Joseph Lieberman L000304 | sen | CT | 2007-01-04 | 2013-01-03 | 1 | Independent | http://lieberman.senate.gov/ | 706 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-4041 | 202-224-9750 | http://www.lieberman.senate.gov/index.cfm/contact/email-me-about-an-issue | 706 Hart Senate Office Building | |||||||
41981 | 41981 | Richard Blumenthal B001277 | sen | CT | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.blumenthal.senate.gov | 706 Hart Senate Office Building Washington DC 20510 | 202-224-2823 | 202-224-9673 | https://www.blumenthal.senate.gov/contact/ | 706 Hart Senate Office Building | senior | http://www.blumenthal.senate.gov/rss/feeds/?type=all | |||||
41982 | 41982 | Richard Blumenthal B001277 | sen | CT | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.blumenthal.senate.gov | 706 Hart Senate Office Building Washington DC 20510 | 202-224-2823 | 202-224-9673 | https://www.blumenthal.senate.gov/contact/ | 706 Hart Senate Office Building | senior | http://www.blumenthal.senate.gov/rss/feeds/?type=all | |||||
39045 | 39045 | Jeff Bingaman B000468 | sen | NM | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://bingaman.senate.gov | 703 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-5521 | 202-224-2852 | http://www.bingaman.senate.gov/contact/ | 703 Hart Senate Office Building | |||||||
39714 | 39714 | Mary Landrieu L000550 | sen | LA | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.landrieu.senate.gov | 703 Hart Senate Office Building Washington DC 20510 | 202-224-5824 | 202-224-9735 | http://www.landrieu.senate.gov/?p=contact | 703 Hart Senate Office Building | senior | http://www.landrieu.senate.gov/rss/ | |||||
41891 | 41891 | Mark Warner W000805 | sen | VA | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.warner.senate.gov | 703 Hart Senate Office Building Washington DC 20510 | 202-224-2023 | 202-224-6295 | http://www.warner.senate.gov/public/index.cfm?p=Contact | 703 Hart Senate Office Building | senior | http://www.warner.senate.gov/public/?a=rss.feed | |||||
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 | ||||||
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 | |||||||
44174 | 44174 | Clay Higgins H001077 | rep | LA | 2021-01-03 | 2023-01-03 | Republican | 3 | https://clayhiggins.house.gov | 572 Cannon House Office Building Washington DC 20515-1803 | 202-225-2031 | 572 Cannon House Office Building | |||||||||
43987 | 43987 | Rick Allen A000372 | rep | GA | 2021-01-03 | 2023-01-03 | Republican | 12 | https://allen.house.gov | 570 Cannon House Office Building Washington DC 20515-1012 | 202-225-2823 | 570 Cannon House Office Building | |||||||||
44235 | 44235 | Ralph Norman N000190 | rep | SC | 2021-01-03 | 2023-01-03 | Republican | 5 | https://norman.house.gov | 569 Cannon House Office Building Washington DC 20515-4005 | 202-225-5501 | 569 Cannon House Office Building | |||||||||
44177 | 44177 | Mike Johnson J000299 | rep | LA | 2021-01-03 | 2023-01-03 | Republican | 4 | https://mikejohnson.house.gov | 568 Cannon House Office Building Washington DC 20515-1804 | 202-225-2777 | 568 Cannon House Office Building | |||||||||
44186 | 44186 | Jack Bergman B001301 | rep | MI | 2021-01-03 | 2023-01-03 | Republican | 1 | https://bergman.house.gov | 566 Cannon House Office Building Washington DC 20515-2201 | 202-225-4735 | 566 Cannon House Office Building | |||||||||
44504 | 44504 | Cori Bush B001224 | rep | MO | 2021-01-03 | 2023-01-03 | Democrat | 1 | https://bush.house.gov | 563 Cannon House Office Building Washington DC 20515-2501 | 202-225-2406 | 563 Cannon House Office Building | |||||||||
44278 | 44278 | Steven Horsford H001066 | rep | NV | 2021-01-03 | 2023-01-03 | Democrat | 4 | https://horsford.house.gov | 562 Cannon House Office Building Washington DC 20515-2804 | 202-225-9894 | 562 Cannon House Office Building | http://horsford.house.gov/rss.xml | ||||||||
44214 | 44214 | David Kustoff K000392 | rep | TN | 2021-01-03 | 2023-01-03 | Republican | 8 | https://kustoff.house.gov | 560 Cannon House Office Building Washington DC 20515-4208 | 202-225-4714 | 560 Cannon House Office Building | |||||||||
41823 | 41823 | Roger Wicker W000437 | sen | MS | 2007-12-31 | 2013-01-03 | 1 | Republican | appointment | http://wicker.senate.gov | 555 DIRKSEN SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-6253 | 202-228-0378 | http://www.wicker.senate.gov/public/index.cfm?FuseAction=Contact.EMailSenatorWicker | 555 Dirksen Senate Office Building | ||||||
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 | |||||||
44400 | 44400 | Elaine Luria L000591 | rep | VA | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://luria.house.gov | 534 Cannon House Office Building Washington DC 20515-4602 | 202-225-4215 | 534 Cannon House Office Building | |||||||||
44382 | 44382 | Mark Green G000590 | rep | TN | 2019-01-03 | 2021-01-03 | Republican | 7 | https://markgreen.house.gov | 533 Cannon House Office Building Washington DC 20515-4207 | 202-225-2811 | 533 Cannon House Office Building | |||||||||
44316 | 44316 | James Baird B001307 | rep | IN | 2019-01-03 | 2021-01-03 | Republican | 4 | https://baird.house.gov | 532 Cannon House Office Building Washington DC 20515-1404 | 202-225-5037 | 532 Cannon House Office Building | |||||||||
39727 | 39727 | John Rockefeller R000361 | sen | WV | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.rockefeller.senate.gov | 531 Hart Senate Office Building Washington DC 20510 | 202-224-6472 | 202-224-7665 | http://www.rockefeller.senate.gov/public/index.cfm/email-jay | 531 Hart Senate Office Building | senior | http://www.rockefeller.senate.gov/public/index.cfm/rss/feed | |||||
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 | |||||
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/ | ||||||
44372 | 44372 | Guy Reschenthaler R000610 | rep | PA | 2019-01-03 | 2021-01-03 | Republican | 14 | https://reschenthaler.house.gov | 531 Cannon House Office Building Washington DC 20515-3814 | 202-225-2065 | 531 Cannon House Office Building | |||||||||
39050 | 39050 | Kent Conrad C000705 | sen | ND | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://conrad.senate.gov | 530 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-2043 | 202-224-7776 | http://www.conrad.senate.gov/contact/webform.cfm | 530 Hart Senate Office Building | |||||||
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 | ||||||
44310 | 44310 | Jesús García G000586 | rep | IL | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://chuygarcia.house.gov | 530 Cannon House Office Building Washington DC 20515-1304 | 202-225-8203 | 530 Cannon House Office Building | |||||||||
41787 | 41787 | Robert Menendez M000639 | sen | NJ | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://menendez.senate.gov/ | 528 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-4744 | 202-228-2197 | http://menendez.senate.gov/contact/ | 528 Hart Senate Office Building | |||||||
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 | ||||||
40223 | 40223 | Mark Kirk K000360 | sen | IL | 2011-01-05 | 2017-01-03 | 3 | Republican | https://www.kirk.senate.gov | 524 Hart Senate Office Building Washington DC 20510 | 202-224-2854 | 202-228-4611 | http://www.kirk.senate.gov/?p=comment_on_legislation | 524 Hart Senate Office Building | junior | http://kirk.senate.gov/rss/?p=hot_topic | |||||
43770 | 43770 | Tammy Duckworth D000622 | sen | IL | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.duckworth.senate.gov | 524 Hart Senate Office Building Washington DC 20510 | 202-224-2854 | https://www.duckworth.senate.gov/content/contact-senator | 524 Hart Senate Office Building | junior | |||||||
44213 | 44213 | David Kustoff K000392 | rep | TN | 2019-01-03 | 2021-01-03 | Republican | 8 | https://kustoff.house.gov | 523 Cannon House Office Building Washington DC 20515-4208 | 202-225-4714 | 523 Cannon House Office Building | |||||||||
44483 | 44483 | Byron Donalds D000032 | rep | FL | 2021-01-03 | 2023-01-03 | Republican | 19 | https://donalds.house.gov | 523 Cannon House Office Building Washington DC 20515-0919 | 202-225-2536 | 523 Cannon House Office Building | |||||||||
40240 | 40240 | Harry Reid R000146 | sen | NV | 2011-01-05 | 2017-01-03 | 3 | Democrat | http://www.reid.senate.gov | 522 Hart Senate Office Building Washington DC 20510 | 202-224-3542 | 202-224-7327 | http://www.reid.senate.gov/contact | 522 Hart Senate Office Building | senior | ||||||
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 | |||||
44358 | 44358 | Susie Lee L000590 | rep | NV | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://susielee.house.gov | 522 Cannon House Office Building Washington DC 20515-2803 | 202-225-3252 | 522 Cannon House Office Building | |||||||||
44498 | 44498 | Tracey Mann M000871 | rep | KS | 2021-01-03 | 2023-01-03 | Republican | 1 | https://mann.house.gov | 522 Cannon House Office Building Washington DC 20515-1601 | 202-225-2715 | 522 Cannon House Office Building | |||||||||
39693 | 39693 | Kay Hagan H001049 | sen | NC | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.hagan.senate.gov | 521 Dirksen Senate Office Building Washington DC 20510 | 202-224-6342 | 202-228-2563 | http://www.hagan.senate.gov/contact/ | 521 Dirksen Senate Office Building | junior | http://www.hagan.senate.gov/rss | |||||
42956 | 42956 | Jerry Moran M000934 | sen | KS | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.moran.senate.gov | 521 Dirksen Senate Office Building Washington DC 20510 | 202-224-6521 | 202-228-6966 | http://www.moran.senate.gov/public/index.cfm/e-mail-jerry | 521 Dirksen Senate Office Building | junior | http://www.moran.senate.gov/public/index.cfm/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/ | |||||
44300 | 44300 | W. Steube S001214 | rep | FL | 2019-01-03 | 2021-01-03 | Republican | 17 | https://steube.house.gov | 521 Cannon House Office Building Washington DC 20515-0917 | 202-225-5792 | 521 Cannon House Office Building | |||||||||
44488 | 44488 | Andrew Clyde C001116 | rep | GA | 2021-01-03 | 2023-01-03 | Republican | 9 | https://clyde.house.gov | 521 Cannon House Office Building Washington DC 20515-1009 | 202-225-9893 | 521 Cannon House Office Building | |||||||||
41887 | 41887 | Jeanne Shaheen S001181 | sen | NH | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.shaheen.senate.gov | 520 Hart Senate Office Building Washington DC 20510 | 202-224-2841 | 202-228-3194 | http://www.shaheen.senate.gov/contact/ | 520 Hart Senate Office Building | senior | http://www.shaheen.senate.gov/rss/ | |||||
42105 | 42105 | Bill Cassidy C001075 | sen | LA | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.cassidy.senate.gov | 520 Hart Senate Office Building Washington DC 20510 | 202-224-5824 | 202-225-7313 | https://www.cassidy.senate.gov/contact | 520 Hart Senate Office Building | senior | ||||||
42106 | 42106 | Bill Cassidy C001075 | sen | LA | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.cassidy.senate.gov | 520 Hart Senate Office Building Washington DC 20510 | 202-224-5824 | https://www.cassidy.senate.gov/contact | 520 Hart Senate Office Building | senior | |||||||
43338 | 43338 | Tim Scott S001184 | sen | SC | 2015-01-06 | 2017-01-03 | 3 | Republican | https://www.scott.senate.gov | 520 Hart Senate Office Building Washington DC 20510 | 202-224-6121 | 202-225-3407 | http://www.scott.senate.gov/contact/email-me | 520 Hart Senate Office Building | junior | http://www.scott.senate.gov/rss.xml | |||||
41833 | 41833 | John Cornyn C001056 | sen | TX | 2009-01-06 | 2015-01-03 | 2 | Republican | http://www.cornyn.senate.gov | 517 Hart Senate Office Building Washington DC 20510 | 202-224-2934 | 202-228-2856 | http://www.cornyn.senate.gov/public/index.cfm?p=ContactForm | 517 Hart Senate Office Building | senior | http://www.cornyn.senate.gov/public/?a=rss.feed | |||||
41834 | 41834 | John Cornyn C001056 | sen | TX | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.cornyn.senate.gov | 517 Hart Senate Office Building Washington DC 20510 | 202-224-2934 | 202-228-2856 | https://www.cornyn.senate.gov/contact | 517 Hart Senate Office Building | senior | http://www.cornyn.senate.gov/public/?a=rss.feed | |||||
41835 | 41835 | John Cornyn C001056 | sen | TX | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.cornyn.senate.gov | 517 Hart Senate Office Building Washington DC 20510 | 202-224-2934 | https://www.cornyn.senate.gov/contact | 517 Hart Senate Office Building | senior | http://www.cornyn.senate.gov/public/?a=rss.feed | ||||||
40245 | 40245 | David Vitter V000127 | sen | LA | 2011-01-05 | 2017-01-03 | 3 | Republican | https://www.vitter.senate.gov | 516 Hart Senate Office Building Washington DC 20510 | 202-224-4623 | 202-228-5061 | http://www.vitter.senate.gov/contact/email-senator-vitter | 516 Hart Senate Office Building | senior | http://www.vitter.senate.gov/rss/feeds/?type=all | |||||
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 | |||||
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 | ||||||
43305 | 43305 | Austin Scott S001189 | rep | GA | 2011-01-05 | 2013-01-03 | Republican | 8 | http://austinscott.house.gov/ | 516 Cannon HOB; Washington DC 20515-1003 | 202-225-6531 | 202-225-3013 | 516 Cannon House Office Building | ||||||||
43306 | 43306 | Austin Scott S001189 | rep | GA | 2013-01-03 | 2015-01-03 | Republican | 8 | http://austinscott.house.gov | 516 Cannon HOB; Washington DC 20515-1008 | 202-225-6531 | 202-225-3013 | https://austinscott.house.gov/email-me/ | 516 Cannon House Office Building | http://austinscott.house.gov/index.php?format=feed&type=rss | ||||||
43964 | 43964 | Norma Torres T000474 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 35 | https://torres.house.gov | 516 Cannon HOB; Washington DC 20515-0535 | 202-225-6161 | 202-225-8671 | 516 Cannon House Office Building | ||||||||
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 |
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);