legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
34 rows where "start" is on date 2011-01-05 and type = "sen"
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||
39588 | 39588 | Jim DeMint D000595 | sen | SC | 2011-01-05 | 2013-01-01 | 3 | Republican | http://demint.senate.gov | 167 RUSSELL SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-6121 | 202-228-5143 | http://www.demint.senate.gov/public/index.cfm?p=ContactInformation | 167 Russell Senate Office Building | |||||||
39798 | 39798 | Thomas Coburn C000560 | sen | OK | 2011-01-05 | 2015-01-03 | 3 | Republican | http://www.coburn.senate.gov | 172 Russell Senate Office Building Washington DC 20510 | 202-224-5754 | 202-224-6008 | http://www.coburn.senate.gov/public/?p=ContactForm#form_904650a1-34fd-4705-aec9-87815cbf9cb4 | 172 Russell Senate Office Building | junior | ||||||
40200 | 40200 | Kelly Ayotte A000368 | sen | NH | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.ayotte.senate.gov | 144 Russell Senate Office Building Washington DC 20510 | 202-224-3324 | 202-224-4952 | http://www.ayotte.senate.gov/?p=contact | 144 Russell Senate Office Building | junior | http://ayotte.senate.gov/rss/?p=news | |||||
40209 | 40209 | Barbara Boxer B000711 | sen | CA | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.boxer.senate.gov | 112 Hart Senate Office Building Washington DC 20510 | 202-224-3553 | 202-224-0454 | https://www.boxer.senate.gov/contact/shareyourviews.html | 112 Hart Senate Office Building | junior | ||||||
40216 | 40216 | Daniel Coats C000542 | sen | IN | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.coats.senate.gov | 493 Russell Senate Office Building Washington DC 20510 | 202-224-5623 | 202-228-1820 | http://www.coats.senate.gov/contact/ | 493 Russell Senate Office Building | senior | http://www.coats.senate.gov/rss/feeds/?type=all& | |||||
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 | |||||
40233 | 40233 | Barbara Mikulski M000702 | sen | MD | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.mikulski.senate.gov | 503 Hart Senate Office Building Washington DC 20510 | 202-224-4654 | 202-224-8858 | http://www.mikulski.senate.gov/contact/shareyouropinion.cfm | 503 Hart Senate Office Building | senior | http://www.mikulski.senate.gov/rssfeed.cfm | |||||
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 | ||||||
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 | |||||
40652 | 40652 | John McCain M000303 | sen | AZ | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.mccain.senate.gov | 218 Russell Senate Office Building Washington DC 20510 | 202-224-2235 | 202-228-2862 | http://www.mccain.senate.gov/public/index.cfm/contact-form | 218 Russell Senate Office Building | senior | ||||||
41214 | 41214 | John Isakson I000055 | sen | GA | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.isakson.senate.gov | 131 Russell Senate Office Building Washington DC 20510 | 202-224-3643 | 202-228-0724 | http://www.isakson.senate.gov/public/index.cfm/email-me | 131 Russell Senate Office Building | senior | http://www.isakson.senate.gov/public/?a=RSS.Feed | |||||
41933 | 41933 | Michael Bennet B001267 | sen | CO | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.bennet.senate.gov | 261 Russell Senate Office Building Washington DC 20510 | 202-224-5852 | 202-228-5097 | http://www.bennet.senate.gov/contact/email | 261 Russell Senate Office Building | senior | http://www.bennet.senate.gov/rss/feeds/?type=news | |||||
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 | |||||
41990 | 41990 | Roy Blunt B000575 | sen | MO | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.blunt.senate.gov | 260 Russell Senate Office Building Washington DC 20510 | 202-224-5721 | 202-224-8149 | http://www.blunt.senate.gov/public/index.cfm/contact-form?p=contact-roy | 260 Russell Senate Office Building | junior | http://www.blunt.senate.gov/public/?a=rss.feed | |||||
41997 | 41997 | John Boozman B001236 | sen | AR | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.boozman.senate.gov | 141 Hart Senate Office Building Washington DC 20510 | 202-224-4843 | 202-228-1371 | http://www.boozman.senate.gov/public/index.cfm/e-mail-me | 141 Hart Senate Office Building | senior | http://www.boozman.senate.gov/public/index.cfm/rss/feed | |||||
42048 | 42048 | Richard Burr B001135 | sen | NC | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.burr.senate.gov | 217 Russell Senate Office Building Washington DC 20510 | 202-224-3154 | 202-228-2981 | http://www.burr.senate.gov/public/index.cfm?FuseAction=Contact.ContactForm | 217 Russell Senate Office Building | senior | http://www.burr.senate.gov/public/index.cfm?fuseaction=rss.feed | |||||
42236 | 42236 | Michael Crapo C000880 | sen | ID | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.crapo.senate.gov | 239 Dirksen Senate Office Building Washington DC 20510 | 202-224-6142 | 202-228-1375 | http://www.crapo.senate.gov/contact/email.cfm | 239 Dirksen Senate Office Building | senior | ||||||
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 | |||||
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 | |||||
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 | |||||
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/ | |||||
42738 | 42738 | Mike Lee L000577 | sen | UT | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.lee.senate.gov | 361A Russell Senate Office Building Washington DC 20510 | 202-224-5444 | http://www.lee.senate.gov/public/index.cfm/contact | 361a Russell Senate Office Building | junior | http://www.lee.senate.gov/public/index.cfm/rss/feed | ||||||
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/ | |||||
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 | |||||
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 | |||||
43070 | 43070 | Rand Paul P000603 | sen | KY | 2011-01-05 | 2017-01-03 | 3 | Republican | https://www.paul.senate.gov | 167 Russell Senate Office Building Washington DC 20510 | 202-224-4343 | 202-228-1373 | http://www.paul.senate.gov/?p=contact | 167 Russell Senate Office Building | junior | http://paul.senate.gov/rss/?p=news | |||||
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 | |||||
43196 | 43196 | Marco Rubio R000595 | sen | FL | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.rubio.senate.gov | 284 Russell Senate Office Building Washington DC 20510 | 202-224-3041 | 202-228-0285 | http://www.rubio.senate.gov/public/index.cfm/contact | 284 Russell Senate Office Building | junior | 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 | ||||||
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 | |||||
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 | |||||
43500 | 43500 | Patrick Toomey T000461 | sen | PA | 2011-01-05 | 2017-01-03 | 3 | Republican | http://www.toomey.senate.gov | 248 Russell Senate Office Building Washington DC 20510 | 202-224-4254 | 202-228-0284 | http://www.toomey.senate.gov/?p=contact | 248 Russell Senate Office Building | junior | http://toomey.senate.gov/rss/?p=hot_topic | |||||
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& |
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);