legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by url descending
This data as json, copyable, CSV (advanced)
end (date) >30 ✖
- 1919-03-03 506
- 1931-03-03 502
- 1921-03-03 499
- 1933-03-03 499
- 1923-03-03 498
- 1941-01-03 498
- 1915-03-03 494
- 1925-03-03 493
- 1945-01-03 493
- 1939-01-03 492
- 1929-03-03 489
- 1963-01-03 489
- 1943-01-03 488
- 1947-01-03 488
- 1935-01-03 486
- 1949-01-03 486
- 1953-01-03 486
- 1917-03-03 485
- 1937-01-03 485
- 1955-01-03 485
- 1927-03-04 484
- 1961-01-03 483
- 1971-01-03 483
- 1951-01-03 482
- 1965-01-03 482
- 1983-01-03 481
- 1959-01-03 480
- 1977-01-03 480
- 1967-01-03 479
- 1975-01-03 479
- …
how 2 ✖
- appointment 199
- special-election 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||
41854 | 41854 | Lindsey Graham G000359 | sen | SC | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.lgraham.senate.gov/public | 290 Russell Senate Office Building Washington DC 20510 | 202-224-5972 | 202-224-3808 | https://www.lgraham.senate.gov/public/index.cfm/e-mail-senator-graham | 290 Russell Senate Office Building | senior | http://www.lgraham.senate.gov/public/index.cfm?FuseAction=Rss.Feed | |||||
41855 | 41855 | Lindsey Graham G000359 | sen | SC | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.lgraham.senate.gov/public | 290 Russell Senate Office Building Washington DC 20510 | 202-224-5972 | https://www.lgraham.senate.gov/public/index.cfm/e-mail-senator-graham | 290 Russell Senate Office Building | senior | http://www.lgraham.senate.gov/public/index.cfm?FuseAction=Rss.Feed | ||||||
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 | ||||||
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/ | |||||
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 | |||||||
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 | |||||
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 | |||||||
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 | |||||
43788 | 43788 | Angus King K000383 | sen | ME | 2013-01-03 | 2019-01-03 | 1 | Independent | https://www.king.senate.gov | Democrat | 133 Hart Senate Office Building Washington DC 20510 | 202-224-5344 | 202-224-1946 | https://www.king.senate.gov/contact | 133 Hart Senate Office Building | junior | http://www.king.senate.gov/rss/feeds/?type=all | ||||
43789 | 43789 | Angus King K000383 | sen | ME | 2019-01-03 | 2025-01-03 | 1 | Independent | https://www.king.senate.gov | Democrat | 133 Hart Senate Office Building Washington DC 20510 | 202-224-5344 | https://www.king.senate.gov/contact | 133 Hart Senate Office Building | junior | http://www.king.senate.gov/rss/feeds/?type=all | |||||
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 | |||||||
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 | ||||||
43896 | 43896 | Timothy Kaine K000384 | sen | VA | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.kaine.senate.gov | 231 Russell Senate Office Building Washington DC 20510 | 202-224-4024 | 202-228-6363 | https://www.kaine.senate.gov/contact | 231 Russell Senate Office Building | junior | http://www.kaine.senate.gov/rss/feeds/?type=all | |||||
43897 | 43897 | Timothy Kaine K000384 | sen | VA | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.kaine.senate.gov | 231 Russell Senate Office Building Washington DC 20510 | 202-224-4024 | https://www.kaine.senate.gov/contact | 231 Russell Senate Office Building | junior | http://www.kaine.senate.gov/rss/feeds/?type=all | ||||||
41594 | 41594 | Doug Jones J000300 | sen | AL | 2018-01-03 | 2021-01-03 | 2 | Democrat | https://www.jones.senate.gov | 330 Hart Senate Office Building Washington DC 20510 | 202-224-4124 | https://www.jones.senate.gov/content/contact-senator | 330 Hart Senate Office Building | junior | |||||||
41215 | 41215 | John Isakson I000055 | sen | GA | 2017-01-03 | 2019-12-31 | 3 | Republican | https://www.isakson.senate.gov | 131 Russell Senate Office Building Washington DC 20510 | 202-224-3643 | 202-228-0724 | https://www.isakson.senate.gov/public/index.cfm/email-me | 131 Russell Senate Office Building | senior | http://www.isakson.senate.gov/public/?a=RSS.Feed | |||||
41864 | 41864 | James Inhofe I000024 | sen | OK | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.inhofe.senate.gov | 205 Russell Senate Office Building Washington DC 20510 | 202-224-4721 | 202-228-0380 | https://www.inhofe.senate.gov/contact | 205 Russell Senate Office Building | senior | http://www.inhofe.senate.gov/rss/feeds/?type=all&cachebuster=eea6c4d7%2d939c%2d5c1e%2db6c7aa3b8b291208 | |||||
41865 | 41865 | James Inhofe I000024 | sen | OK | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.inhofe.senate.gov | 205 Russell Senate Office Building Washington DC 20510 | 202-224-4721 | https://www.inhofe.senate.gov/contact | 205 Russell Senate Office Building | senior | http://www.inhofe.senate.gov/rss/feeds/?type=all&cachebuster=eea6c4d7%2d939c%2d5c1e%2db6c7aa3b8b291208 | ||||||
44245 | 44245 | Cindy Hyde-Smith H001079 | sen | MS | 2018-04-09 | 2018-11-27 | 2 | Republican | appointment | https://www.hydesmith.senate.gov | G12 Dirksen Senate Office Building Washington DC 20510 | 202-224-5054 | https://www.hydesmith.senate.gov/content/contact-senator | G12 Dirksen Senate Office Building | junior | special-election | |||||
44246 | 44246 | Cindy Hyde-Smith H001079 | sen | MS | 2018-11-28 | 2021-01-03 | 2 | Republican | https://www.hydesmith.senate.gov | 702 Hart Senate Office Building Washington DC 20510 | 202-224-5054 | https://www.hydesmith.senate.gov/content/contact-senator | 702 Hart Senate Office Building | junior | |||||||
44247 | 44247 | Cindy Hyde-Smith H001079 | sen | MS | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.hydesmith.senate.gov | 702 Hart Senate Office Building Washington DC 20510 | 202-224-5054 | https://www.hydesmith.senate.gov/content/contact-senator | 702 Hart Senate Office Building | junior | |||||||
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 | |||||
42528 | 42528 | Mazie Hirono H001042 | sen | HI | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.hirono.senate.gov | 730 Hart Senate Office Building Washington DC 20510 | 202-224-6361 | 202-225-4987 | https://www.hirono.senate.gov/contact | 730 Hart Senate Office Building | junior | http://www.hirono.senate.gov/rss/feeds/?type=all | |||||
42529 | 42529 | Mazie Hirono H001042 | sen | HI | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.hirono.senate.gov | 109 Hart Senate Office Building Washington DC 20510 | 202-224-6361 | https://www.hirono.senate.gov/contact | 109 Hart Senate Office Building | junior | http://www.hirono.senate.gov/rss/feeds/?type=all | ||||||
44472 | 44472 | John Hickenlooper H000273 | sen | CO | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.hickenlooper.senate.gov | 374 Russell Senate Office Building Washington DC 20510 | 202-224-5941 | https://www.hickenlooper.senate.gov/contact/ | 374 Russell Senate Office Building | junior | |||||||
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 | |||||
41110 | 41110 | Heidi Heitkamp H001069 | sen | ND | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.heitkamp.senate.gov/public | 516 Hart Senate Office Building Washington DC 20510 | 202-224-2043 | 202-224-7776 | http://www.heitkamp.senate.gov/public/index.cfm/contact | 516 Hart Senate Office Building | junior | http://www.heitkamp.senate.gov/public/index.cfm/rss/feed | |||||
42501 | 42501 | Martin Heinrich H001046 | sen | NM | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.heinrich.senate.gov | 303 Hart Senate Office Building Washington DC 20510 | 202-224-5521 | 202-225-4975 | http://www.heinrich.senate.gov/contact | 303 Hart Senate Office Building | junior | ||||||
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 | |||||||
44416 | 44416 | Joshua Hawley H001089 | sen | MO | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.hawley.senate.gov | 115 Russell Senate Office Building Washington DC 20510 | 202-224-6154 | https://www.hawley.senate.gov/contact-senator-hawley | 115 Russell Senate Office Building | junior | |||||||
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 | |||||
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 | |||||||
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 | |||||||
44473 | 44473 | Bill Hagerty H000601 | sen | TN | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.hagerty.senate.gov | 248 Russell Senate Office Building Washington DC 20510 | 202-224-4944 | https://www.hagerty.senate.gov/email-me/ | 248 Russell Senate Office Building | junior | |||||||
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 | |||||
41896 | 41896 | Kirsten Gillibrand G000555 | sen | NY | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.gillibrand.senate.gov | 478 Russell Senate Office Building Washington DC 20510 | 202-224-4451 | 202-228-0282 | https://www.gillibrand.senate.gov/contact/email-me | 478 Russell Senate Office Building | junior | http://www.gillibrand.senate.gov/rss/ | |||||
41897 | 41897 | Kirsten Gillibrand G000555 | sen | NY | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.gillibrand.senate.gov | 478 Russell Senate Office Building Washington DC 20510 | 202-224-4451 | https://www.gillibrand.senate.gov/contact/email-me | 478 Russell Senate Office Building | junior | http://www.gillibrand.senate.gov/rss/ | ||||||
41350 | 41350 | Cory Gardner G000562 | sen | CO | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.gardner.senate.gov | 354 Russell Senate Office Building Washington DC 20510 | 202-224-5941 | 202-225-5870 | https://www.gardner.senate.gov/contact-cory/email-cory | 354 Russell Senate Office Building | junior | ||||||
40591 | 40591 | Alan Franken F000457 | sen | MN | 2015-01-06 | 2018-01-02 | 2 | Democrat | https://www.franken.senate.gov | 309 Hart Senate Office Building Washington DC 20510 | 202-224-5641 | 202-224-0044 | https://www.franken.senate.gov/?p=contact | 309 Hart Senate Office Building | junior | http://franken.senate.gov/rss/?p=hot_topic | |||||
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 | |||||
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 | ||||||
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 | ||||||
44074 | 44074 | Joni Ernst E000295 | sen | IA | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.ernst.senate.gov/public | 730 Hart Senate Office Building Washington DC 20510 | 202-224-3254 | https://www.ernst.senate.gov/public/index.cfm/contact | 730 Hart Senate Office Building | junior | |||||||
44075 | 44075 | Joni Ernst E000295 | sen | IA | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.ernst.senate.gov | 730 Hart Senate Office Building Washington DC 20510 | 202-224-3254 | https://www.ernst.senate.gov/public/index.cfm/contact | 730 Hart Senate Office Building | junior | |||||||
41265 | 41265 | Michael Enzi E000285 | sen | WY | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.enzi.senate.gov | 379A Russell Senate Office Building Washington DC 20510 | 202-224-3424 | 202-228-0359 | http://www.enzi.senate.gov/public/index.cfm/contact?p=e-mail-senator-enzi | 379a Russell Senate Office Building | senior | http://www.enzi.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 | ||||||
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 | |||||||
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 | |||||
43801 | 43801 | Steve Daines D000618 | sen | MT | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.daines.senate.gov | 320 Hart Senate Office Building Washington DC 20510 | 202-224-2651 | 202-228-1236 | https://www.daines.senate.gov/connect/email-steve | 320 Hart Senate Office Building | junior | ||||||
43802 | 43802 | Steve Daines D000618 | sen | MT | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.daines.senate.gov | 320 Hart Senate Office Building Washington DC 20510 | 202-224-2651 | https://www.daines.senate.gov/connect/email-steve | 320 Hart Senate Office Building | junior | |||||||
43869 | 43869 | Ted Cruz C001098 | sen | TX | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.cruz.senate.gov | 404 Russell Senate Office Building Washington DC 20510 | 202-224-5922 | 202-228-3398 | https://www.cruz.senate.gov/?p=form&id=16 | 404 Russell Senate Office Building | junior | ||||||
43870 | 43870 | Ted Cruz C001098 | sen | TX | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.cruz.senate.gov | 127A Russell Senate Office Building Washington DC 20510 | 202-224-5922 | https://www.cruz.senate.gov/?p=form&id=16 | 127a Russell Senate Office Building | junior | |||||||
42237 | 42237 | Michael Crapo C000880 | sen | ID | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.crapo.senate.gov | 239 Dirksen Senate Office Building Washington DC 20510 | 202-224-6142 | 202-228-1375 | https://www.crapo.senate.gov/contact | 239 Dirksen Senate Office Building | senior | ||||||
43811 | 43811 | Kevin Cramer C001096 | sen | ND | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.cramer.senate.gov | 330 Hart Senate Office Building Washington DC 20510 | 202-224-2043 | https://www.cramer.senate.gov/contact/contact-kevin | 330 Hart Senate Office Building | junior | |||||||
43702 | 43702 | Tom Cotton C001095 | sen | AR | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.cotton.senate.gov | 326 Russell Senate Office Building Washington DC 20510 | 202-224-2353 | https://www.cotton.senate.gov/contact/contact-tom | 326 Russell Senate Office Building | junior | |||||||
43703 | 43703 | Tom Cotton C001095 | sen | AR | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.cotton.senate.gov | 326 Russell Senate Office Building Washington DC 20510 | 202-224-2353 | https://www.cotton.senate.gov/contact/contact-tom | 326 Russell Senate Office Building | junior | |||||||
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 | |||||||
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 | ||||||
40671 | 40671 | Bob Corker C001071 | sen | TN | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.corker.senate.gov | 425 Dirksen Senate Office Building Washington DC 20510 | 202-224-3344 | 202-228-0566 | https://www.corker.senate.gov/public/index.cfm/emailme | 425 Dirksen Senate Office Building | junior | http://www.corker.senate.gov/public/index.cfm/rss/feed | |||||
41899 | 41899 | Christopher Coons C001088 | sen | DE | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.coons.senate.gov | 218 Russell Senate Office Building Washington DC 20510 | 202-224-5042 | 202-228-3075 | https://www.coons.senate.gov/contact | 218 Russell Senate Office Building | junior | http://www.coons.senate.gov/rss/feeds/?type=all | |||||
41900 | 41900 | Christopher Coons C001088 | sen | DE | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.coons.senate.gov | 218 Russell Senate Office Building Washington DC 20510 | 202-224-5042 | https://www.coons.senate.gov/contact | 218 Russell Senate Office Building | junior | http://www.coons.senate.gov/rss/feeds/?type=all | ||||||
41829 | 41829 | Susan Collins C001035 | sen | ME | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.collins.senate.gov | 413 Dirksen Senate Office Building Washington DC 20510 | 202-224-2523 | 202-224-2693 | http://www.collins.senate.gov/contact | 413 Dirksen Senate Office Building | senior | http://www.collins.senate.gov/public/?a=rss.feed | |||||
41830 | 41830 | Susan Collins C001035 | sen | ME | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.collins.senate.gov | 413 Dirksen Senate Office Building Washington DC 20510 | 202-224-2523 | https://www.collins.senate.gov/contact | 413 Dirksen Senate Office Building | senior | http://www.collins.senate.gov/public/?a=rss.feed | ||||||
40627 | 40627 | Thad Cochran C000567 | sen | MS | 2015-01-06 | 2018-04-01 | 2 | Republican | https://www.cochran.senate.gov | 113 Dirksen Senate Office Building Washington DC 20510 | 202-224-5054 | 202-224-9450 | https://www.cochran.senate.gov/public/index.cfm/email-me | 113 Dirksen Senate Office Building | senior | http://www.cochran.senate.gov/public/index.cfm/rss/feed | |||||
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 | |||||||
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 | ||||||
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 | ||||||
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 | ||||||
42082 | 42082 | Shelley Capito C001047 | sen | WV | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.capito.senate.gov | 172 Russell Senate Office Building Washington DC 20510 | 202-224-6472 | 202-225-7856 | https://www.capito.senate.gov/contact/contact-shelley | 172 Russell Senate Office Building | junior | ||||||
42083 | 42083 | Shelley Capito C001047 | sen | WV | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.capito.senate.gov | 172 Russell Senate Office Building Washington DC 20510 | 202-224-6472 | https://www.capito.senate.gov/contact/contact-shelley | 172 Russell Senate Office Building | junior | |||||||
41743 | 41743 | Maria Cantwell C000127 | sen | WA | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.cantwell.senate.gov | 511 Hart Senate Office Building Washington DC 20510 | 202-224-3441 | 202-228-0514 | http://www.cantwell.senate.gov/public/index.cfm/email-maria | 511 Hart Senate Office Building | junior | http://www.cantwell.senate.gov/public/index.cfm/rss/feed | |||||
41744 | 41744 | Maria Cantwell C000127 | sen | WA | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.cantwell.senate.gov | 511 Hart Senate Office Building Washington DC 20510 | 202-224-3441 | https://www.cantwell.senate.gov/public/index.cfm/email-maria | 511 Hart Senate Office Building | junior | http://www.cantwell.senate.gov/public/index.cfm/rss/feed | ||||||
42049 | 42049 | Richard Burr B001135 | sen | NC | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.burr.senate.gov | 217 Russell Senate Office Building Washington DC 20510 | 202-224-3154 | 202-228-2981 | https://www.burr.senate.gov/contact | 217 Russell Senate Office Building | senior | http://www.burr.senate.gov/public/index.cfm?fuseaction=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& | ||||||
44415 | 44415 | Mike Braun B001310 | sen | IN | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.braun.senate.gov | 404 Russell Senate Office Building Washington DC 20510 | 202-224-4814 | https://www.braun.senate.gov/contact-mike | 404 Russell Senate Office Building | junior | |||||||
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 | ||||||
41998 | 41998 | John Boozman B001236 | sen | AR | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.boozman.senate.gov/public | 141 Hart Senate Office Building Washington DC 20510 | 202-224-4843 | 202-228-1371 | https://www.boozman.senate.gov/public/index.cfm/contact | 141 Hart Senate Office Building | senior | http://www.boozman.senate.gov/public/index.cfm/rss/feed | |||||
43919 | 43919 | Cory Booker B001288 | sen | NJ | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.booker.senate.gov | 717 Hart Senate Office Building Washington DC 20510 | 202-224-3224 | 202-224-8378 | https://www.booker.senate.gov/?p=contact | 717 Hart Senate Office Building | junior | ||||||
43920 | 43920 | Cory Booker B001288 | sen | NJ | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.booker.senate.gov | 717 Hart Senate Office Building Washington DC 20510 | 202-224-3224 | https://www.booker.senate.gov/?p=contact | 717 Hart Senate Office Building | junior | |||||||
41991 | 41991 | Roy Blunt B000575 | sen | MO | 2017-01-03 | 2023-01-03 | 3 | Republican | https://www.blunt.senate.gov | 260 Russell Senate Office Building Washington DC 20510 | 202-224-5721 | 202-224-8149 | https://www.blunt.senate.gov/public/index.cfm/contact-roy | 260 Russell Senate Office Building | senior | http://www.blunt.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 | |||||
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 | |||||||
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 | ||||||
41934 | 41934 | Michael Bennet B001267 | sen | CO | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.bennet.senate.gov/public | 261 Russell Senate Office Building Washington DC 20510 | 202-224-5852 | 202-228-5097 | https://www.bennet.senate.gov/public/index.cfm/contact | 261 Russell Senate Office Building | senior | http://www.bennet.senate.gov/rss/feeds/?type=news | |||||
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 |
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);