legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by fax descending
This data as json, copyable, CSV (advanced)
Suggested facets: class, how, state_rank, start (date)
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
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||
41566 | 41566 | George Holding H001065 | rep | NC | 2013-01-03 | 2015-01-03 | Republican | 13 | http://holding.house.gov | 507 Cannon HOB; Washington DC 20515-3313 | 202-225-3032 | 919-782-4490 | https://holding.house.gov/contact/email-me | 507 Cannon House Office Building | http://holding.house.gov/rss.xml | ||||||
41567 | 41567 | George Holding H001065 | rep | NC | 2015-01-06 | 2017-01-03 | Republican | 13 | http://holding.house.gov | 507 Cannon HOB; Washington DC 20515-3313 | 202-225-3032 | 919-782-4490 | https://holding.house.gov/contact/email-me | 507 Cannon House Office Building | http://holding.house.gov/rss.xml | ||||||
41568 | 41568 | George Holding H001065 | rep | NC | 2017-01-03 | 2019-01-03 | Republican | 2 | https://holding.house.gov | 1110 Longworth House Office Building; Washington DC 20515-3302 | 202-225-3032 | 919-782-4490 | 1110 Longworth House Office Building | http://holding.house.gov/rss.xml | |||||||
40636 | 40636 | Jim Bridenstine B001283 | rep | OK | 2013-01-03 | 2015-01-03 | Republican | 1 | http://bridenstine.house.gov | 216 Cannon HOB; Washington DC 20515-3601 | 202-225-2211 | 918-935-2716 | https://bridenstineforms.house.gov/forms/writeyourrep/ | 216 Cannon House Office Building | http://bridenstine.house.gov/rss.xml | ||||||
40637 | 40637 | Jim Bridenstine B001283 | rep | OK | 2015-01-06 | 2017-01-03 | Republican | 1 | http://bridenstine.house.gov | 216 Cannon HOB; Washington DC 20515-3601 | 202-225-2211 | 918-935-2716 | https://bridenstineforms.house.gov/forms/writeyourrep/ | 216 Cannon House Office Building | http://bridenstine.house.gov/rss.xml | ||||||
40638 | 40638 | Jim Bridenstine B001283 | rep | OK | 2017-01-03 | 2018-04-23 | Republican | 1 | https://bridenstine.house.gov | 216 Cannon House Office Building; Washington DC 20515-3601 | 202-225-2211 | 918-935-2716 | 216 Cannon House Office Building | http://bridenstine.house.gov/rss.xml | |||||||
41120 | 41120 | Marshall Sanford S000051 | rep | SC | 2013-05-15 | 2015-01-03 | Republican | 1 | http://sanford.house.gov | 322 Cannon HOB; Washington DC 20515-4001 | 202-225-3176 | 843-521-2535 | https://sanford.house.gov/contact/email-me | 322 Cannon House Office Building | http://sanford.house.gov/rss.xml | ||||||
41121 | 41121 | Marshall Sanford S000051 | rep | SC | 2015-01-06 | 2017-01-03 | Republican | 1 | http://sanford.house.gov | 2201 Rayburn HOB; Washington DC 20515-4001 | 202-225-3176 | 843-521-2535 | https://sanford.house.gov/contact/email-me | 2201 Rayburn House Office Building | http://sanford.house.gov/rss.xml | ||||||
41122 | 41122 | Marshall Sanford S000051 | rep | SC | 2017-01-03 | 2019-01-03 | Republican | 1 | https://sanford.house.gov | 2211 Rayburn House Office Building; Washington DC 20515-4001 | 202-225-3176 | 843-521-2535 | 2211 Rayburn House Office Building | http://sanford.house.gov/rss.xml | |||||||
43891 | 43891 | Chris Stewart S001192 | rep | UT | 2013-01-03 | 2015-01-03 | Republican | 2 | http://stewart.house.gov | 323 Cannon HOB; Washington DC 20515-4402 | 202-225-9730 | 801-364-5551 | https://stewart.house.gov/contact/email-me | 323 Cannon House Office Building | http://stewart.house.gov/rss.xml | ||||||
43892 | 43892 | Chris Stewart S001192 | rep | UT | 2015-01-06 | 2017-01-03 | Republican | 2 | http://stewart.house.gov | 323 Cannon HOB; Washington DC 20515-4402 | 202-225-9730 | 801-364-5551 | https://stewart.house.gov/contact/email-me | 323 Cannon House Office Building | http://stewart.house.gov/rss.xml | ||||||
43893 | 43893 | Chris Stewart S001192 | rep | UT | 2017-01-03 | 2019-01-03 | Republican | 2 | https://stewart.house.gov | 323 Cannon House Office Building; Washington DC 20515-4402 | 202-225-9730 | 801-364-5551 | 323 Cannon House Office Building | http://stewart.house.gov/rss.xml | |||||||
41095 | 41095 | Luke Messer M001189 | rep | IN | 2013-01-03 | 2015-01-03 | Republican | 6 | http://messer.house.gov | 508 Cannon HOB; Washington DC 20515-1406 | 202-225-3021 | 765-747-5586 | https://messer.house.gov/contact/email-me | 508 Cannon House Office Building | http://messer.house.gov/rss.xml | ||||||
41096 | 41096 | Luke Messer M001189 | rep | IN | 2015-01-06 | 2017-01-03 | Republican | 6 | https://messer.house.gov | 508 Cannon HOB; Washington DC 20515-1406 | 202-225-3021 | 765-747-5586 | https://messer.house.gov/contact/email-me | 508 Cannon House Office Building | http://messer.house.gov/rss.xml | ||||||
41097 | 41097 | Luke Messer M001189 | rep | IN | 2017-01-03 | 2019-01-03 | Republican | 6 | https://messer.house.gov | 1230 Longworth House Office Building; Washington DC 20515-1406 | 202-225-3021 | 765-747-5586 | 1230 Longworth House Office Building | http://messer.house.gov/rss.xml | |||||||
43803 | 43803 | Richard Hudson H001067 | rep | NC | 2013-01-03 | 2015-01-03 | Republican | 8 | http://hudson.house.gov | 429 Cannon HOB; Washington DC 20515-3308 | 202-225-3715 | 704-782-1004 | https://hudson.house.gov/email-me | 429 Cannon House Office Building | http://hudson.house.gov/rss.xml | ||||||
43804 | 43804 | Richard Hudson H001067 | rep | NC | 2015-01-06 | 2017-01-03 | Republican | 8 | http://hudson.house.gov | 429 Cannon HOB; Washington DC 20515-3308 | 202-225-3715 | 704-782-1004 | https://hudson.house.gov/email-me | 429 Cannon House Office Building | http://hudson.house.gov/rss.xml | ||||||
43805 | 43805 | Richard Hudson H001067 | rep | NC | 2017-01-03 | 2019-01-03 | Republican | 8 | https://hudson.house.gov | 429 Cannon House Office Building; Washington DC 20515-3308 | 202-225-3715 | 704-782-1004 | 429 Cannon House Office Building | http://hudson.house.gov/rss.xml | |||||||
43859 | 43859 | Matthew Cartwright C001090 | rep | PA | 2013-01-03 | 2015-01-03 | Democrat | 17 | http://cartwright.house.gov | 1419 Longworth HOB; Washington DC 20515-3817 | 202-225-5546 | 570-341-1055 | https://cartwrightforms.house.gov/forms/writeyourrep/ | 1419 Longworth House Office Building | http://cartwright.house.gov/rss.xml | ||||||
43860 | 43860 | Matthew Cartwright C001090 | rep | PA | 2015-01-06 | 2017-01-03 | Democrat | 17 | http://cartwright.house.gov | 1419 Longworth HOB; Washington DC 20515-3817 | 202-225-5546 | 570-341-1055 | https://cartwrightforms.house.gov/forms/writeyourrep/ | 1419 Longworth House Office Building | http://cartwright.house.gov/rss.xml | ||||||
43861 | 43861 | Matthew Cartwright C001090 | rep | PA | 2017-01-03 | 2019-01-03 | Democrat | 17 | https://cartwright.house.gov | 1034 Longworth House Office Building; Washington DC 20515-3817 | 202-225-5546 | 570-341-1055 | 1034 Longworth House Office Building | http://cartwright.house.gov/rss.xml | |||||||
43763 | 43763 | Lois Frankel F000462 | rep | FL | 2013-01-03 | 2015-01-03 | Democrat | 22 | http://frankel.house.gov | 1037 Longworth HOB; Washington DC 20515-0922 | 202-225-9890 | 561-998-9048 | https://frankel.house.gov/contact/email-me | 1037 Longworth House Office Building | http://frankel.house.gov/rss.xml | ||||||
43764 | 43764 | Lois Frankel F000462 | rep | FL | 2015-01-06 | 2017-01-03 | Democrat | 22 | http://frankel.house.gov | 1037 Longworth HOB; Washington DC 20515-0922 | 202-225-9890 | 561-998-9048 | https://frankel.house.gov/contact/email-me | 1037 Longworth House Office Building | http://frankel.house.gov/rss.xml | ||||||
43765 | 43765 | Lois Frankel F000462 | rep | FL | 2017-01-03 | 2019-01-03 | Democrat | 21 | https://frankel.house.gov | 1037 Longworth House Office Building; Washington DC 20515-0921 | 202-225-9890 | 561-998-9048 | 1037 Longworth House Office Building | http://frankel.house.gov/rss.xml | |||||||
43708 | 43708 | Doug LaMalfa L000578 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 1 | http://lamalfa.house.gov | 506 Cannon HOB; Washington DC 20515-0501 | 202-225-3076 | 530-534-7800 | https://lamalfa.house.gov/contact/email-me | 506 Cannon House Office Building | http://lamalfa.house.gov/rss.xml | ||||||
43709 | 43709 | Doug LaMalfa L000578 | rep | CA | 2015-01-06 | 2017-01-03 | Republican | 1 | http://lamalfa.house.gov | 322 Cannon HOB; Washington DC 20515-0501 | 202-225-3076 | 530-534-7800 | https://lamalfa.house.gov/contact/email-me | 322 Cannon House Office Building | http://lamalfa.house.gov/rss.xml | ||||||
43710 | 43710 | Doug LaMalfa L000578 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 1 | https://lamalfa.house.gov | 322 Cannon House Office Building; Washington DC 20515-0501 | 202-225-3076 | 530-534-7800 | 322 Cannon House Office Building | http://lamalfa.house.gov/rss.xml | |||||||
43881 | 43881 | Roger Williams W000816 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 25 | http://williams.house.gov | 1122 Longworth HOB; Washington DC 20515-4325 | 202-225-9896 | 512-473-8946 | https://williams.house.gov/contact/email-me | 1122 Longworth House Office Building | http://williams.house.gov/rss.xml | ||||||
43882 | 43882 | Roger Williams W000816 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 25 | http://williams.house.gov | 1323 Longworth HOB; Washington DC 20515-4325 | 202-225-9896 | 512-473-8946 | https://williams.house.gov/contact/email-me | 1323 Longworth House Office Building | http://williams.house.gov/rss.xml | ||||||
43883 | 43883 | Roger Williams W000816 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 25 | https://williams.house.gov | 1323 Longworth House Office Building; Washington DC 20515-4325 | 202-225-9896 | 512-473-8946 | 1323 Longworth House Office Building | http://williams.house.gov/rss.xml | |||||||
43776 | 43776 | Cheri Bustos B001286 | rep | IL | 2013-01-03 | 2015-01-03 | Democrat | 17 | http://bustos.house.gov | 1009 Longworth HOB; Washington DC 20515-1317 | 202-225-5905 | 309-786-3720 | http://bustos.house.gov/contact | 1009 Longworth House Office Building | http://bustos.house.gov/rss.xml | ||||||
43777 | 43777 | Cheri Bustos B001286 | rep | IL | 2015-01-06 | 2017-01-03 | Democrat | 17 | http://bustos.house.gov | 1009 Longworth HOB; Washington DC 20515-1317 | 202-225-5905 | 309-786-3720 | http://bustos.house.gov/contact | 1009 Longworth House Office Building | http://bustos.house.gov/rss.xml | ||||||
43778 | 43778 | Cheri Bustos B001286 | rep | IL | 2017-01-03 | 2019-01-03 | Democrat | 17 | https://bustos.house.gov | 1009 Longworth House Office Building; Washington DC 20515-1317 | 202-225-5905 | 309-786-3720 | 1009 Longworth House Office Building | http://bustos.house.gov/rss.xml | |||||||
43772 | 43772 | Rodney Davis D000619 | rep | IL | 2015-01-06 | 2017-01-03 | Republican | 13 | http://rodneydavis.house.gov | 1740 Longworth HOB; Washington DC 20515-1313 | 202-225-2371 | 217-791-6168 | https://rodneydavisforms.house.gov/contact/ | 1740 Longworth House Office Building | http://rodneydavis.house.gov/rss.xml | ||||||
43773 | 43773 | Rodney Davis D000619 | rep | IL | 2017-01-03 | 2019-01-03 | Republican | 13 | https://rodneydavis.house.gov | 1740 Longworth House Office Building; Washington DC 20515-1313 | 202-225-2371 | 217-791-6168 | 1740 Longworth House Office Building | http://rodneydavis.house.gov/rss.xml | |||||||
40126 | 40126 | Pete Gallego G000572 | rep | TX | 2013-01-03 | 2015-01-03 | Democrat | 23 | http://gallego.house.gov | 431 Cannon HOB; Washington DC 20515-4323 | 202-225-4511 | 210-927-4903 | https://gallego.house.gov/contact/email-me | 431 Cannon House Office Building | http://gallego.house.gov/rss.xml | ||||||
43434 | 43434 | Jackie Speier S001175 | rep | CA | 2011-01-05 | 2013-01-03 | Democrat | 12 | http://speier.house.gov/ | 211 Cannon HOB; Washington DC 20515-0512 | 202-225-3531 | 202-347-0956 | http://speier.house.gov/IMA/issue_subscribe.htm | 211 Cannon House Office Building | |||||||
43435 | 43435 | Jackie Speier S001175 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 14 | http://speier.house.gov | 211 Cannon HOB; Washington DC 20515-0514 | 202-225-3531 | 202-347-0956 | https://forms.house.gov/speier/webforms/email_jackie.shtml | 211 Cannon House Office Building | http://speier.house.gov/index.php?format=feed&type=rss | ||||||
43436 | 43436 | Jackie Speier S001175 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 14 | http://speier.house.gov | 2465 Rayburn HOB; Washington DC 20515-0514 | 202-225-3531 | 202-347-0956 | https://forms.house.gov/speier/webforms/email_jackie.shtml | 2465 Rayburn House Office Building | http://speier.house.gov/index.php?format=feed&type=rss | ||||||
43437 | 43437 | Jackie Speier S001175 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 14 | https://speier.house.gov | 2465 Rayburn House Office Building; Washington DC 20515-0514 | 202-225-3531 | 202-347-0956 | 2465 Rayburn House Office Building | http://speier.house.gov/index.php?format=feed&type=rss | |||||||
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/ | |||||
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/ | |||||
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 | |||||
39082 | 39082 | Jim Webb W000803 | sen | VA | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://webb.senate.gov/ | 248 RUSSELL SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-4024 | 202-228-6363 | http://www.webb.senate.gov/contact.cfm | 248 Russell Senate Office Building | |||||||
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 | |||||
41160 | 41160 | Carol Shea-Porter S001170 | rep | NH | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://shea-porter.house.gov | 1530 Longworth HOB; Washington DC 20515-2901 | 202-225-5456 | 202-228-6362 | https://shea-porter.house.gov/contact/email-me | 1530 Longworth House Office Building | http://shea-porter.house.gov/rss.xml | ||||||
41161 | 41161 | Carol Shea-Porter S001170 | rep | NH | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://shea-porter.house.gov | 1530 Longworth House Office Building; Washington DC 20515-2901 | 202-225-5456 | 202-228-6362 | 1530 Longworth House Office Building | http://shea-porter.house.gov/rss.xml | |||||||
41810 | 41810 | Sheldon Whitehouse W000802 | sen | RI | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://whitehouse.senate.gov/ | 717 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-2921 | 202-228-6362 | http://www.whitehouse.senate.gov/contact/ | 717 Hart Senate Office Building | |||||||
41811 | 41811 | Sheldon Whitehouse W000802 | sen | RI | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.whitehouse.senate.gov | 530 Hart Senate Office Building Washington DC 20510 | 202-224-2921 | 202-228-6362 | https://www.whitehouse.senate.gov/contact/email-sheldon | 530 Hart Senate Office Building | junior | http://www.whitehouse.senate.gov/rss/feeds/?type=all&cachebuster=1 | |||||
40679 | 40679 | Claire McCaskill M001170 | sen | MO | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://mccaskill.senate.gov/ | 506 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-6154 | 202-228-6326 | http://www.mccaskill.senate.gov/?p=contact | 506 Hart Senate Office Building | |||||||
40680 | 40680 | Claire McCaskill M001170 | sen | MO | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.mccaskill.senate.gov | 503 Hart Senate Office Building Washington DC 20510 | 202-224-6154 | 202-228-6326 | http://www.mccaskill.senate.gov/contact | 503 Hart Senate Office Building | senior | http://mccaskill.senate.gov/rss/?p=news | |||||
41737 | 41737 | Sherrod Brown B000944 | sen | OH | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://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 | |||||||
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& | |||||
39344 | 39344 | Timothy Johnson J000285 | rep | IL | 2011-01-05 | 2013-01-03 | Republican | 15 | http://www.house.gov/timjohnson | 1207 Longworth HOB; Washington DC 20515-1315 | 202-225-2371 | 202-228-5765 | http://www.house.gov/timjohnson/contact/index.shtml | 1207 Longworth House Office Building | |||||||
39711 | 39711 | Tim Johnson J000177 | sen | SD | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.johnson.senate.gov | 136 Hart Senate Office Building Washington DC 20510 | 202-224-5842 | 202-228-5765 | http://www.johnson.senate.gov/public/index.cfm?p=ContactForm | 136 Hart Senate Office Building | senior | http://www.johnson.senate.gov/public/?a=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 | |||||
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 | |||||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
39608 | 39608 | Frank Lautenberg L000123 | sen | NJ | 2009-01-06 | 2013-06-03 | 2 | Democrat | http://www.lautenberg.senate.gov | 141 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-3224 | 202-228-4054 | http://www.lautenberg.senate.gov/contact/routing.cfm | 141 Hart Senate Office Building | senior | ||||||
41873 | 41873 | Jeff Merkley M001176 | sen | OR | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.merkley.senate.gov | 313 Hart Senate Office Building Washington DC 20510 | 202-224-3753 | 202-228-3997 | http://www.merkley.senate.gov/contact/ | 313 Hart Senate Office Building | junior | http://www.merkley.senate.gov/rss/ | |||||
41874 | 41874 | Jeff Merkley M001176 | sen | OR | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.merkley.senate.gov | 313 Hart Senate Office Building Washington DC 20510 | 202-224-3753 | 202-228-3997 | http://www.merkley.senate.gov/contact/ | 313 Hart Senate Office Building | junior | http://www.merkley.senate.gov/rss/ | |||||
41773 | 41773 | Dianne Feinstein F000062 | sen | CA | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://feinstein.senate.gov | 331 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-3841 | 202-228-3954 | http://www.feinstein.senate.gov/public/index.cfm/e-mail-me | 331 Hart Senate Office Building | |||||||
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 | |||||
41260 | 41260 | Lamar Alexander A000360 | sen | TN | 2009-01-06 | 2015-01-03 | 2 | Republican | http://www.alexander.senate.gov | 455 Dirksen Senate Office Building Washington DC 20510 | 202-224-4944 | 202-228-3398 | http://www.alexander.senate.gov/public/index.cfm?p=Email | 455 Dirksen Senate Office Building | senior | http://www.alexander.senate.gov/public/?a=rss.feed | |||||
41261 | 41261 | Lamar Alexander A000360 | sen | TN | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.alexander.senate.gov/public | 455 Dirksen Senate Office Building Washington DC 20510 | 202-224-4944 | 202-228-3398 | http://www.alexander.senate.gov/public/index.cfm?p=Email | 455 Dirksen Senate Office Building | senior | http://www.alexander.senate.gov/public/?a=rss.feed | |||||
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 | ||||||
41283 | 41283 | Tom Udall U000039 | sen | NM | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.tomudall.senate.gov | 110 Hart Senate Office Building Washington DC 20510 | 202-224-6621 | 202-228-3261 | http://www.tomudall.senate.gov/?p=contact | 110 Hart Senate Office Building | senior | http://tomudall.senate.gov/rss/?p=blog | |||||
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 | |||||
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/ | |||||
41888 | 41888 | Jeanne Shaheen S001181 | sen | NH | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.shaheen.senate.gov | 506 Hart Senate Office Building Washington DC 20510 | 202-224-2841 | 202-228-3194 | https://www.shaheen.senate.gov/contact/contact-jeanne | 506 Hart Senate Office Building | senior | http://www.shaheen.senate.gov/rss/ | |||||
41898 | 41898 | Christopher Coons C001088 | sen | DE | 2010-11-15 | 2015-01-03 | 2 | Democrat | http://www.coons.senate.gov | 127A Russell Senate Office Building Washington DC 20510 | 202-224-5042 | 202-228-3075 | http://www.coons.senate.gov/contact/ | 127a Russell Senate Office Building | junior | http://www.coons.senate.gov/rss/feeds/?type=all | |||||
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 | |||||
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 | ||||||
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 | |||||
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 | |||||
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 | ||||||
40653 | 40653 | John McCain M000303 | sen | AZ | 2017-01-03 | 2018-08-25 | 3 | Republican | https://www.mccain.senate.gov | 218 Russell Senate Office Building Washington DC 20510 | 202-224-2235 | 202-228-2862 | https://www.mccain.senate.gov/public/index.cfm/contact-form | 218 Russell Senate Office Building | senior | ||||||
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 | |||||
41833 | 41833 | John Cornyn C001056 | sen | TX | 2009-01-06 | 2015-01-03 | 2 | Republican | http://www.cornyn.senate.gov | 517 Hart Senate Office Building Washington DC 20510 | 202-224-2934 | 202-228-2856 | http://www.cornyn.senate.gov/public/index.cfm?p=ContactForm | 517 Hart Senate Office Building | senior | http://www.cornyn.senate.gov/public/?a=rss.feed | |||||
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 | |||||
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& | |||||
39693 | 39693 | Kay Hagan H001049 | sen | NC | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.hagan.senate.gov | 521 Dirksen Senate Office Building Washington DC 20510 | 202-224-6342 | 202-228-2563 | http://www.hagan.senate.gov/contact/ | 521 Dirksen Senate Office Building | junior | http://www.hagan.senate.gov/rss | |||||
41787 | 41787 | Robert Menendez M000639 | sen | NJ | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://menendez.senate.gov/ | 528 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-4744 | 202-228-2197 | http://menendez.senate.gov/contact/ | 528 Hart Senate Office Building | |||||||
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 | |||||
41764 | 41764 | Thomas Carper C000174 | sen | DE | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://carper.senate.gov | 513 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-2441 | 202-228-2190 | http://www.carper.senate.gov/contact/ | 513 Hart Senate Office Building | |||||||
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 | |||||
41776 | 41776 | Amy Klobuchar K000367 | sen | MN | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://klobuchar.senate.gov/ | 302 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-3244 | 202-228-2186 | http://www.klobuchar.senate.gov/emailamy.cfm | 302 Hart Senate Office Building | |||||||
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 | ||||||
40688 | 40688 | Bill Nelson N000032 | sen | FL | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://billnelson.senate.gov/ | 716 HART SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-5274 | 202-228-2183 | http://www.billnelson.senate.gov/contact/index.cfm | 716 Hart Senate Office Building | |||||||
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 | ||||||
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 | |||||
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& |
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);