legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
36 rows where class = 1 and state_rank = "senior"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, state, end, url, address, phone, office, rss_url, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||
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& | |||||
41739 | 41739 | Sherrod Brown B000944 | sen | OH | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.brown.senate.gov | 503 Hart Senate Office Building Washington DC 20510 | 202-224-2315 | https://www.brown.senate.gov/contact/ | 503 Hart Senate Office Building | senior | http://www.brown.senate.gov/rss/feeds/?type=all& | ||||||
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 | |||||
41757 | 41757 | Benjamin Cardin C000141 | sen | MD | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.cardin.senate.gov | 509 Hart Senate Office Building Washington DC 20510 | 202-224-4524 | https://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 | |||||
41766 | 41766 | Thomas Carper C000174 | sen | DE | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.carper.senate.gov/public | 513 Hart Senate Office Building Washington DC 20510 | 202-224-2441 | https://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 | |||||
41769 | 41769 | Robert Casey C001070 | sen | PA | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.casey.senate.gov | 393 Russell Senate Office Building Washington DC 20510 | 202-224-6324 | 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 | |||||
41775 | 41775 | Dianne Feinstein F000062 | sen | CA | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.feinstein.senate.gov | 331 Hart Senate Office Building Washington DC 20510 | 202-224-3841 | 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 | ||||||
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 | |||||||
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 | ||||||
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 | ||||||
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 | ||||||
41815 | 41815 | John Barrasso B001261 | sen | WY | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.barrasso.senate.gov | 307 Dirksen Senate Office Building Washington DC 20510 | 202-224-6441 | https://www.barrasso.senate.gov/public/index.cfm/contact-form | 307 Dirksen Senate Office Building | senior | 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 | ||||||
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 | |||||||
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 | |||||
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 | ||||||
41966 | 41966 | Marsha Blackburn B001243 | sen | TN | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.blackburn.senate.gov | 357 Dirksen Senate Office Building Washington DC 20510 | 202-224-3344 | https://www.blackburn.senate.gov/email-me | 357 Dirksen Senate Office Building | senior | |||||||
42502 | 42502 | Martin Heinrich H001046 | sen | NM | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.heinrich.senate.gov | 303 Hart Senate Office Building Washington DC 20510 | 202-224-5521 | https://www.heinrich.senate.gov/contact | 303 Hart Senate Office Building | senior | |||||||
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 | |||||||
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 | ||||||
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 | |||||
43813 | 43813 | Deb Fischer F000463 | sen | NE | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.fischer.senate.gov | 454 Russell Senate Office Building Washington DC 20510 | 202-224-6551 | https://www.fischer.senate.gov/public/index.cfm/contact | 454 Russell Senate Office Building | senior | http://www.fischer.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);