legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
31 rows where class = 3 and state_rank = "junior"
This data as json, copyable, CSV (advanced)
Suggested facets: legislator_id, state, start, end, party, how, url, address, phone, contact_form, office, rss_url, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||
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 | |||||
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 | |||||
41254 | 41254 | Martha McSally M001197 | sen | AZ | 2019-01-03 | 2020-12-02 | 3 | Republican | appointment | https://www.mcsally.senate.gov | 404 Russell Senate Office Building Washington DC 20510 | 202-224-2235 | https://www.mcsally.senate.gov/contact_martha | 404 Russell Senate Office Building | junior | special-election | |||||
41617 | 41617 | Kamala Harris H001075 | sen | CA | 2017-01-03 | 2021-01-18 | 3 | Democrat | https://www.harris.senate.gov | 112 Hart Senate Office Building Washington DC 20510 | 202-224-3553 | https://www.harris.senate.gov/contact | 112 Hart Senate Office Building | junior | |||||||
41618 | 41618 | Kelly Loeffler L000594 | sen | GA | 2020-01-06 | 2021-01-20 | 3 | Republican | appointment | https://www.loeffler.senate.gov | 131 Russell Senate Office Building Washington DC 20510 | 202-224-3643 | https://www.loeffler.senate.gov/connect/email-kelly | 131 Russell Senate Office Building | junior | special-election | |||||
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 | |||||
42684 | 42684 | James Lankford L000575 | sen | OK | 2015-01-06 | 2017-01-03 | 3 | Republican | https://www.lankford.senate.gov | 316 Hart Senate Office Building Washington DC 20510 | 202-224-5754 | 316 Hart Senate Office Building | junior | ||||||||
42685 | 42685 | James Lankford L000575 | sen | OK | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.lankford.senate.gov | 316 Hart Senate Office Building Washington DC 20510 | 202-224-5754 | https://www.lankford.senate.gov/contact/email | 316 Hart Senate Office Building | junior | |||||||
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/ | |||||
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 | |||||
43071 | 43071 | Rand Paul P000603 | sen | KY | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.paul.senate.gov | 167 Russell Senate Office Building Washington DC 20510 | 202-224-4343 | 202-228-1373 | https://www.paul.senate.gov/connect/email-rand | 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 | |||||
43118 | 43118 | Robert Portman P000449 | sen | OH | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.portman.senate.gov | 448 Russell Senate Office Building Washington DC 20510 | 202-224-3353 | https://www.portman.senate.gov/public/index.cfm/contact?p=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 | |||||
43337 | 43337 | Tim Scott S001184 | sen | SC | 2013-01-03 | 2015-01-03 | 3 | Republican | appointment | http://www.scott.senate.gov | 167 Russell Senate Office Building Washington DC 20510 | 202-224-6121 | 202-225-3407 | http://www.scott.senate.gov/contact/email-me | 167 Russell Senate Office Building | junior | http://www.scott.senate.gov/rss.xml | ||||
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 | |||||
43339 | 43339 | Tim Scott S001184 | sen | SC | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.scott.senate.gov | 104 Hart Senate Office Building Washington DC 20510 | 202-224-6121 | 202-225-3407 | https://www.scott.senate.gov/contact/email-me | 104 Hart Senate Office Building | junior | http://www.scott.senate.gov/rss.xml | |||||
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 | |||||
43501 | 43501 | Patrick Toomey T000461 | sen | PA | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.toomey.senate.gov | 455 Dirksen Senate Office Building Washington DC 20510 | 202-224-4254 | 202-228-0284 | https://www.toomey.senate.gov/?p=contact | 455 Dirksen Senate Office Building | junior | http://toomey.senate.gov/rss/?p=hot_topic | |||||
43537 | 43537 | Chris Van Hollen V000128 | sen | MD | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.vanhollen.senate.gov | 110 Hart Senate Office Building Washington DC 20510 | 202-224-4654 | 202-225-0375 | https://www.vanhollen.senate.gov/contact/email | 110 Hart Senate Office Building | junior | ||||||
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 | |||||||
44102 | 44102 | John Kennedy K000393 | sen | LA | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.kennedy.senate.gov/public | 416 Russell Senate Office Building Washington DC 20510 | 202-224-4623 | https://www.kennedy.senate.gov/public/email-me | 416 Russell Senate Office Building | junior | |||||||
44103 | 44103 | Margaret Hassan H001076 | sen | NH | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.hassan.senate.gov | 324 Hart Senate Office Building Washington DC 20510 | 202-224-3324 | https://www.hassan.senate.gov/content/contact-senator | 324 Hart Senate Office Building | junior | |||||||
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 | ||||||
44531 | 44531 | Alejandro Padilla P000145 | sen | CA | 2021-01-20 | 2022-11-08 | 3 | Democrat | appointment | https://www.padilla.senate.gov | 112 Hart Senate Office Building Washington DC 20510 | 202-224-3553 | https://www.padilla.senate.gov/contact/ | 112 Hart Senate Office Building | junior | ||||||
44532 | 44532 | Alejandro Padilla P000145 | sen | CA | 2022-11-09 | 2023-01-03 | 3 | Democrat | special-election | https://www.padilla.senate.gov | 112 Hart Senate Office Building Washington DC 20510 | 202-224-3553 | https://www.padilla.senate.gov/contact/ | 112 Hart Senate Office Building | junior | ||||||
44534 | 44534 | Raphael Warnock W000790 | sen | GA | 2021-01-20 | 2023-01-03 | 3 | Democrat | special-election | https://www.warnock.senate.gov | 388 Russell Senate Office Building Washington DC 20510 | 202-224-3643 | https://www.warnock.senate.gov/contact/ | 388 Russell Senate Office Building | junior |
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);