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 address
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||
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 | |||||||
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/ | |||||
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 | |||||
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 | ||||||
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 | |||||
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 | |||||||
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 | ||||||
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 | |||||
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 | |||||
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 | ||||||
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& | |||||
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 | |||||
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 | ||||||
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 | ||||||
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 | |||||
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 |
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);