legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
135 rows where state_rank = "senior" sorted by end-type
This data as json, copyable, CSV (advanced)
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
42442 | 42442 | Charles Grassley G000386 | sen | IA | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.grassley.senate.gov | 135 Hart Senate Office Building Washington DC 20510 | 202-224-3744 | 202-224-6020 | http://www.grassley.senate.gov/constituents/questions-and-comments | 135 Hart Senate Office Building | senior | http://grassley.senate.gov/customcf/rss_feed.cfm | |||||
42443 | 42443 | Charles Grassley G000386 | sen | IA | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.grassley.senate.gov | 135 Hart Senate Office Building Washington DC 20510 | 202-224-3744 | 202-224-6020 | https://www.grassley.senate.gov/contact | 135 Hart Senate Office Building | senior | http://grassley.senate.gov/customcf/rss_feed.cfm | |||||
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 | |||||||
42530 | 42530 | John Hoeven H001061 | sen | ND | 2011-01-05 | 2017-01-03 | 3 | Republican | https://www.hoeven.senate.gov | 338 Russell Senate Office Building Washington DC 20510 | 202-224-2551 | 202-224-7999 | http://www.hoeven.senate.gov/public/index.cfm/email-the-senator | 338 Russell Senate Office Building | senior | http://www.hoeven.senate.gov/public/index.cfm/rss/feed | |||||
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 | |||||
42602 | 42602 | Ron Johnson J000293 | sen | WI | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.ronjohnson.senate.gov | 328 Hart Senate Office Building Washington DC 20510 | 202-224-5323 | 920-230-7262 | http://www.ronjohnson.senate.gov/public/index.cfm/contact | 328 Hart Senate Office Building | senior | http://www.ronjohnson.senate.gov/public/index.cfm/rss/feed | |||||
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 | |||||
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/ | |||||
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 | ||||||
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/ | |||||
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 | |||||
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 | |||||
42970 | 42970 | Patty Murray M001111 | sen | WA | 2011-01-05 | 2017-01-03 | 3 | Democrat | http://www.murray.senate.gov | 154 Russell Senate Office Building Washington DC 20510 | 202-224-2621 | 202-224-0238 | http://www.murray.senate.gov/public/index.cfm/contactme | 154 Russell Senate Office Building | senior | http://www.murray.senate.gov/public/?a=rss.feed | |||||
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 | |||||
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 | |||||
43297 | 43297 | Charles Schumer S000148 | sen | NY | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.schumer.senate.gov | 322 Hart Senate Office Building Washington DC 20510 | 202-224-6542 | 202-228-3027 | http://www.schumer.senate.gov/Contact/email-chuck | 322 Hart Senate Office Building | senior | ||||||
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 | ||||||
43354 | 43354 | Richard Shelby S000320 | sen | AL | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.shelby.senate.gov | 304 Russell Senate Office Building Washington DC 20510 | 202-224-5744 | 202-224-3416 | http://www.shelby.senate.gov/public/index.cfm/emailsenatorshelby | 304 Russell Senate Office Building | senior | http://www.shelby.senate.gov/public/index.cfm/rss/feed | |||||
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 | |||||
43488 | 43488 | John Thune T000250 | sen | SD | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.thune.senate.gov | 511 Dirksen Senate Office Building Washington DC 20510 | 202-224-2321 | 202-228-5429 | http://www.thune.senate.gov/public/index.cfm/contact | 511 Dirksen Senate Office Building | senior | http://www.thune.senate.gov/public/index.cfm/rss/feed | |||||
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 | |||||
43641 | 43641 | Ron Wyden W000779 | sen | OR | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.wyden.senate.gov | 221 Dirksen Senate Office Building Washington DC 20510 | 202-224-5244 | 202-228-2717 | http://www.wyden.senate.gov/contact | 221 Dirksen Senate Office Building | senior | http://www.wyden.senate.gov/rss/feeds/?type=all& | |||||
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& | |||||
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 | ||||||
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 | ||||||
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 | ||||||
44104 | 44104 | Catherine Cortez Masto C001113 | sen | NV | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.cortezmasto.senate.gov | 313 Hart Senate Office Building Washington DC 20510 | 202-224-3542 | https://www.cortezmasto.senate.gov/contact | 313 Hart Senate Office Building | senior | |||||||
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 |
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);