legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by office descending
This data as json, copyable, CSV (advanced)
Link | rowid | legislator_id | type | state | start | end | class | party | district | how | party_affiliations | url | caucus | address | phone | fax | contact_form | office ▲ | state_rank | rss_url | end-type |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41134 | 41134 | David Young Y000066 | rep | IA | 2015-01-06 | 2017-01-03 | Republican | 3 | https://davidyoung.house.gov | 515 Cannon HOB; Washington DC 20515-1503 | 202-225-5476 | 515 Cannon House Office Building | |||||||||
42638 | 42638 | Mike Kelly K000376 | rep | PA | 2011-01-05 | 2013-01-03 | Republican | 3 | http://kelly.house.gov/ | 515 Cannon HOB; Washington DC 20515-3803 | 202-225-5406 | 202-225-3103 | 515 Cannon House Office Building | ||||||||
43748 | 43748 | Alan Lowenthal L000579 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 47 | http://lowenthal.house.gov | 515 Cannon HOB; Washington DC 20515-0547 | 202-225-7924 | 202-225-7926 | http://lowenthal.house.gov/contact/howtocontactme.htm | 515 Cannon House Office Building | http://lowenthal.house.gov/news/rss.aspx | ||||||
44160 | 44160 | Raja Krishnamoorthi K000391 | rep | IL | 2017-01-03 | 2019-01-03 | Democrat | 8 | https://krishnamoorthi.house.gov | 515 Cannon House Office Building; Washington DC 20515-1308 | 202-225-3711 | 515 Cannon House Office Building | |||||||||
40246 | 40246 | Dan Benishek B001271 | rep | MI | 2011-01-05 | 2013-01-03 | Republican | 1 | http://benishek.house.gov/ | 514 Cannon HOB; Washington DC 20515-2201 | 202-225-4735 | 202- 225-4744 | 514 Cannon House Office Building | ||||||||
40247 | 40247 | Dan Benishek B001271 | rep | MI | 2013-01-03 | 2015-01-03 | Republican | 1 | http://benishek.house.gov | 514 Cannon HOB; Washington DC 20515-2201 | 202-225-4735 | 202- 225-4744 | https://benishek.house.gov/contact-me/email-me | 514 Cannon House Office Building | http://benishek.house.gov/rss.xml | ||||||
40248 | 40248 | Dan Benishek B001271 | rep | MI | 2015-01-06 | 2017-01-03 | Republican | 1 | http://benishek.house.gov | 514 Cannon HOB; Washington DC 20515-2201 | 202-225-4735 | 202- 225-4744 | https://benishek.house.gov/contact-me/email-me | 514 Cannon House Office Building | http://benishek.house.gov/rss.xml | ||||||
44204 | 44204 | Brian Fitzpatrick F000466 | rep | PA | 2017-01-03 | 2019-01-03 | Republican | 8 | https://fitzpatrick.house.gov | 514 Cannon House Office Building; Washington DC 20515-3808 | 202-225-4276 | 514 Cannon House Office Building | |||||||||
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 | |||||
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 | ||||||
40632 | 40632 | Patrick Meehan M001181 | rep | PA | 2011-01-05 | 2013-01-03 | Republican | 7 | http://meehan.house.gov/ | 513 Cannon HOB; Washington DC 20515-3807 | 202-225-2011 | 202-226-0280 | 513 Cannon House Office Building | ||||||||
41550 | 41550 | Doug Collins C001093 | rep | GA | 2013-01-03 | 2015-01-03 | Republican | 9 | http://dougcollins.house.gov | 513 Cannon HOB; Washington DC 20515-1009 | 202-225-9893 | 202-226-1224 | https://dougcollins.house.gov/email-me | 513 Cannon House Office Building | http://dougcollins.house.gov/latest-rss/latest-rss/ | ||||||
43984 | 43984 | Rick Allen A000372 | rep | GA | 2015-01-06 | 2017-01-03 | Republican | 12 | http://allen.house.gov | 513 Cannon HOB; Washington DC 20515-1012 | 202-225-2823 | 202-225-3377 | 513 Cannon House Office Building | ||||||||
44115 | 44115 | Ro Khanna K000389 | rep | CA | 2017-01-03 | 2019-01-03 | Democrat | 17 | https://khanna.house.gov | 513 Cannon House Office Building; Washington DC 20515-0517 | 202-225-2631 | 513 Cannon House Office Building | |||||||||
40129 | 40129 | Michael Grimm G000569 | rep | NY | 2011-01-05 | 2013-01-03 | Republican | 13 | http://grimm.house.gov/ | 512 Cannon HOB; Washington DC 20515-3213 | 202-225-3371 | 202-226-1272 | 512 Cannon House Office Building | ||||||||
40130 | 40130 | Michael Grimm G000569 | rep | NY | 2013-01-03 | 2015-01-03 | Republican | 11 | http://grimm.house.gov | 512 Cannon HOB; Washington DC 20515-3211 | 202-225-3371 | 202- 226-1272 | https://grimm.house.gov/contact-me/email-me | 512 Cannon House Office Building | http://grimm.house.gov/rss.xml | ||||||
43867 | 43867 | Tom Rice R000597 | rep | SC | 2019-01-03 | 2021-01-03 | Republican | 7 | https://rice.house.gov | 512 Cannon House Office Building Washington DC 20515-4007 | 202-225-9895 | 512 Cannon House Office Building | http://rice.house.gov/rss.xml | ||||||||
44032 | 44032 | Elise Stefanik S001196 | rep | NY | 2015-01-06 | 2017-01-03 | Republican | 21 | https://stefanik.house.gov | 512 Cannon HOB; Washington DC 20515-3221 | 202-225-4611 | 202-226-0621 | 512 Cannon House Office Building | ||||||||
44256 | 44256 | Michael Cloud C001115 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 27 | https://cloud.house.gov | 512 Cannon House Office Building Washington DC 20515-4327 | 202-225-7742 | 512 Cannon House Office Building | |||||||||
44535 | 44535 | Claudia Tenney T000478 | rep | NY | 2017-01-03 | 2019-01-03 | Republican | 22 | https://tenney.house.gov | 512 Cannon House Office Building; Washington DC 20515-3222 | 202-225-3665 | 512 Cannon House Office Building | |||||||||
39665 | 39665 | Max Baucus B000243 | sen | MT | 2009-01-06 | 2014-02-06 | 2 | Democrat | http://www.baucus.senate.gov | 511 Hart Senate Office Building Washington DC 20510 | 202-224-2651 | 202-224-0515 | http://www.baucus.senate.gov/contact/emailForm.cfm?subj=issue | 511 Hart Senate Office Building | senior | http://baucus.senate.gov/rss/?p=news | |||||
40128 | 40128 | John Walsh W000818 | sen | MT | 2014-02-11 | 2015-01-03 | 2 | Democrat | appointment | http://www.walsh.senate.gov | 511 Hart Senate Office Building Washington DC 20510 | 202-224-2651 | http://www.walsh.senate.gov/contact.cfm | 511 Hart 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 | ||||||
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 | |||||
41546 | 41546 | Ted Yoho Y000065 | rep | FL | 2013-01-03 | 2015-01-03 | Republican | 3 | http://yoho.house.gov | 511 Cannon HOB; Washington DC 20515-0903 | 202-225-5744 | https://yoho.house.gov/contact/email-me | 511 Cannon House Office Building | http://yoho.house.gov/rss.xml | |||||||
41547 | 41547 | Ted Yoho Y000065 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 3 | http://yoho.house.gov | 511 Cannon HOB; Washington DC 20515-0903 | 202-225-5744 | https://yoho.house.gov/contact/email-me | 511 Cannon House Office Building | http://yoho.house.gov/rss.xml | |||||||
41548 | 41548 | Ted Yoho Y000065 | rep | FL | 2017-01-03 | 2019-01-03 | Republican | 3 | https://yoho.house.gov | 511 Cannon House Office Building; Washington DC 20515-0903 | 202-225-5744 | 511 Cannon House Office Building | http://yoho.house.gov/rss.xml | ||||||||
42378 | 42378 | Charles Fleischmann F000459 | rep | TN | 2011-01-05 | 2013-01-03 | Republican | 3 | http://fleischmann.house.gov/ | 511 Cannon HOB; Washington DC 20515-4203 | 202-225-3271 | 202-225-3494 | 511 Cannon House Office Building | ||||||||
40690 | 40690 | Lou Barletta B001269 | rep | PA | 2011-01-05 | 2013-01-03 | Republican | 11 | http://barletta.house.gov/ | 510 Cannon HOB; Washington DC 20515-3811 | 202-225-6511 | 202-225-0764 | 510 Cannon House Office Building | ||||||||
41253 | 41253 | Martha McSally M001197 | rep | AZ | 2017-01-03 | 2019-01-03 | Republican | 2 | https://mcsally.house.gov | 510 Cannon House Office Building; Washington DC 20515-0302 | 202-225-2542 | 202-225-0378 | 510 Cannon House Office Building | ||||||||
43871 | 43871 | Randy Weber W000814 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 14 | http://weber.house.gov | 510 Cannon HOB; Washington DC 20515-4314 | 202-225-2831 | 202-225-0271 | https://weber.house.gov/contact/email-me | 510 Cannon House Office Building | http://weber.house.gov/rss.xml | ||||||
43872 | 43872 | Randy Weber W000814 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 14 | http://weber.house.gov | 510 Cannon HOB; Washington DC 20515-4314 | 202-225-2831 | 202-225-0271 | https://weber.house.gov/contact/email-me | 510 Cannon House Office Building | http://weber.house.gov/rss.xml | ||||||
41755 | 41755 | Benjamin Cardin C000141 | sen | MD | 2007-01-04 | 2013-01-03 | 1 | Democrat | http://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 | |||||||
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 | ||||||
41092 | 41092 | Elizabeth Esty E000293 | rep | CT | 2013-01-03 | 2015-01-03 | Democrat | 5 | http://esty.house.gov | 509 Cannon HOB; Washington DC 20515-0705 | 202-225-4476 | 202-225-5933 | http://esty.house.gov/contact | 509 Cannon House Office Building | http://esty.house.gov/rss.xml | ||||||
42682 | 42682 | James Lankford L000575 | rep | OK | 2011-01-05 | 2013-01-03 | Republican | 5 | http://lankford.house.gov/ | 509 Cannon HOB; Washington DC 20515-3605 | 202-225-2132 | 202-226-1463 | 509 Cannon House Office Building | ||||||||
44052 | 44052 | Stacey Plaskett P000610 | rep | VI | 2015-01-06 | 2017-01-03 | Democrat | 0 | https://plaskett.house.gov | 509 Cannon HOB; Washington DC 20515-5500 | 202-225-1790 | 202-225-5517 | 509 Cannon House Office Building | ||||||||
44163 | 44163 | Jim Banks B001299 | rep | IN | 2017-01-03 | 2019-01-03 | Republican | 3 | https://banks.house.gov | 509 Cannon House Office Building; Washington DC 20515-1403 | 202-225-4436 | 509 Cannon House Office Building | |||||||||
39232 | 39232 | Chip Cravaack C001086 | rep | MN | 2011-01-05 | 2013-01-03 | Republican | 8 | http://cravaack.house.gov/ | 508 Cannon HOB; Washington DC 20515-2308 | 202-225-6211 | 202- 225-6211 | 508 Cannon House Office Building | ||||||||
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 | ||||||
44212 | 44212 | David Kustoff K000392 | rep | TN | 2017-01-03 | 2019-01-03 | Republican | 8 | https://kustoff.house.gov | 508 Cannon House Office Building; Washington DC 20515-4208 | 202-225-4714 | 508 Cannon House Office Building | |||||||||
39505 | 39505 | Robert Schilling S001182 | rep | IL | 2011-01-05 | 2013-01-03 | Republican | 17 | http://schilling.house.gov/ | 507 Cannon HOB; Washington DC 20515-1317 | 202-225-5905 | 202- 225-5396 | 507 Cannon House Office Building | ||||||||
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 | ||||||
44133 | 44133 | Matt Gaetz G000578 | rep | FL | 2017-01-03 | 2019-01-03 | Republican | 1 | https://gaetz.house.gov | 507 Cannon House Office Building; Washington DC 20515-0901 | 202-225-4136 | 507 Cannon House Office Building | |||||||||
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 | |||||||
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/ | |||||
41889 | 41889 | Jeanne Shaheen S001181 | sen | NH | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.shaheen.senate.gov | 506 Hart Senate Office Building Washington DC 20510 | 202-224-2841 | https://www.shaheen.senate.gov/contact/contact-jeanne | 506 Hart Senate Office Building | senior | http://www.shaheen.senate.gov/rss/ | ||||||
41142 | 41142 | Tom MacArthur M001193 | rep | NJ | 2015-01-06 | 2017-01-03 | Republican | 3 | https://macarthur.house.gov | 506 Cannon HOB; Washington DC 20515-3003 | 202-225-4765 | 202-225-0778 | 506 Cannon House Office Building | ||||||||
41143 | 41143 | Tom MacArthur M001193 | rep | NJ | 2017-01-03 | 2019-01-03 | Republican | 3 | https://macarthur.house.gov | 506 Cannon House Office Building; Washington DC 20515-3003 | 202-225-4765 | 202-225-0778 | 506 Cannon House Office Building | ||||||||
41615 | 41615 | Cedric Richmond R000588 | rep | LA | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://richmond.house.gov | 506 Cannon House Office Building Washington DC 20515-1802 | 202-225-6636 | 506 Cannon House Office Building | http://richmond.house.gov/rss.xml | ||||||||
41616 | 41616 | Cedric Richmond R000588 | rep | LA | 2021-01-03 | 2021-01-15 | Democrat | 2 | https://richmond.house.gov | 506 Cannon House Office Building Washington DC 20515-1802 | 202-225-6636 | 506 Cannon House Office Building | http://richmond.house.gov/rss.xml | ||||||||
42487 | 42487 | Andy Harris H001052 | rep | MD | 2011-01-05 | 2013-01-03 | Republican | 1 | http://harris.house.gov/ | 506 Cannon HOB; Washington DC 20515-2001 | 202-225-5311 | 202-225-0254 | 506 Cannon House Office Building | ||||||||
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 | ||||||
44538 | 44538 | Troy Carter C001125 | rep | LA | 2021-05-11 | 2023-01-03 | Democrat | 2 | https://troycarter.house.gov | 506 Cannon House Office Building Washington DC 20515-1802 | 202-225-6636 | 506 Cannon House Office Building | |||||||||
41438 | 41438 | Martha Roby R000591 | rep | AL | 2019-01-03 | 2021-01-03 | Republican | 2 | https://roby.house.gov | 504 Cannon House Office Building Washington DC 20515-0102 | 202-225-2901 | 504 Cannon House Office Building | http://roby.house.gov/rss.xml | ||||||||
42415 | 42415 | Paul Gosar G000565 | rep | AZ | 2011-01-05 | 2013-01-03 | Republican | 1 | http://gosar.house.gov/ | 504 Cannon HOB; Washington DC 20515-0301 | 202-225-2315 | 200-226-9739 | 504 Cannon House Office Building | ||||||||
42416 | 42416 | Paul Gosar G000565 | rep | AZ | 2013-01-03 | 2015-01-03 | Republican | 4 | http://gosar.house.gov | 504 Cannon HOB; Washington DC 20515-0304 | 202-225-2315 | 202-226-9739 | https://gosar.house.gov/contact-me/email-me | 504 Cannon House Office Building | http://gosar.house.gov/rss.xml | ||||||
42417 | 42417 | Paul Gosar G000565 | rep | AZ | 2015-01-06 | 2017-01-03 | Republican | 4 | http://gosar.house.gov | 504 Cannon HOB; Washington DC 20515-0304 | 202-225-2315 | 202-226-9739 | https://gosar.house.gov/contact-me/email-me | 504 Cannon House Office Building | http://gosar.house.gov/rss.xml | ||||||
44059 | 44059 | Dan Newhouse N000189 | rep | WA | 2021-01-03 | 2023-01-03 | Republican | 4 | https://newhouse.house.gov | 504 Cannon House Office Building Washington DC 20515-4704 | 202-225-5816 | 504 Cannon House Office Building | |||||||||
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 | |||||
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 | |||||
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& | ||||||
41111 | 41111 | Keith Rothfus R000598 | rep | PA | 2013-01-03 | 2015-01-03 | Republican | 12 | http://rothfus.house.gov | 503 Cannon HOB; Washington DC 20515-3812 | 202-225-2065 | https://rothfus.house.gov/email-keith | 503 Cannon House Office Building | http://rothfus.house.gov/rss.xml | |||||||
43405 | 43405 | Adrian Smith S001172 | rep | NE | 2011-01-05 | 2013-01-03 | Republican | 3 | http://adriansmith.house.gov | 503 Cannon HOB; Washington DC 20515-2703 | 202-225-6435 | 202-225-0207 | http://www.house.gov/formadriansmith/issues_subscribe.htm | 503 Cannon House Office Building | |||||||
43954 | 43954 | Mark DeSaulnier D000623 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 11 | https://desaulnier.house.gov | 503 Cannon House Office Building Washington DC 20515-0511 | 202-225-2095 | 503 Cannon House Office Building | |||||||||
43955 | 43955 | Mark DeSaulnier D000623 | rep | CA | 2021-01-03 | 2023-01-03 | Democrat | 11 | https://desaulnier.house.gov | 503 Cannon House Office Building Washington DC 20515-0511 | 202-225-2095 | 503 Cannon House Office Building | |||||||||
44012 | 44012 | Tom Emmer E000294 | rep | MN | 2015-01-06 | 2017-01-03 | Republican | 6 | https://emmer.house.gov | 503 Cannon HOB; Washington DC 20515-2306 | 202-225-2331 | 202-225-6475 | 503 Cannon House Office Building | ||||||||
44078 | 44078 | Mike Rounds R000605 | sen | SD | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.rounds.senate.gov | 502 Hart Senate Office Building Washington DC 20510 | 202-224-5842 | https://www.rounds.senate.gov/contact/email-mike | 502 Hart Senate Office Building | junior | |||||||
44414 | 44414 | Rick Scott S001217 | sen | FL | 2019-01-08 | 2025-01-03 | 1 | Republican | https://www.rickscott.senate.gov | 502 Hart Senate Office Building Washington DC 20510 | 202-224-5274 | https://www.rickscott.senate.gov/contact/contact | 502 Hart Senate Office Building | junior | |||||||
40334 | 40334 | Christopher Gibson G000564 | rep | NY | 2011-01-05 | 2013-01-03 | Republican | 20 | http://gibson.house.gov/ | 502 Cannon HOB; Washington DC 20515-3220 | 202-225-5614 | 202-225-1168 | 502 Cannon House Office Building | ||||||||
40657 | 40657 | Evan Jenkins J000297 | rep | WV | 2015-01-06 | 2017-01-03 | Republican | 3 | https://evanjenkins.house.gov | 502 Cannon HOB; Washington DC 20515-4803 | 202-225-3452 | 202-225-9061 | 502 Cannon House Office Building | ||||||||
41554 | 41554 | Tulsi Gabbard G000571 | rep | HI | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://gabbard.house.gov | 502 Cannon HOB; Washington DC 20515-1102 | 202-225-4906 | 202-225-4987 | https://forms.house.gov/formsgabbard/webforms/email-me.shtml | 502 Cannon House Office Building | http://gabbard.house.gov/rss.xml | ||||||
43409 | 43409 | Adrian Smith S001172 | rep | NE | 2019-01-03 | 2021-01-03 | Republican | 3 | https://adriansmith.house.gov | 502 Cannon House Office Building Washington DC 20515-2703 | 202-225-6435 | 502 Cannon House Office Building | http://adriansmith.house.gov/rss.xml | ||||||||
43410 | 43410 | Adrian Smith S001172 | rep | NE | 2021-01-03 | 2023-01-03 | Republican | 3 | https://adriansmith.house.gov | 502 Cannon House Office Building Washington DC 20515-2703 | 202-225-6435 | 502 Cannon House Office Building | http://adriansmith.house.gov/rss.xml | ||||||||
40959 | 40959 | Jared Polis P000598 | rep | CO | 2011-01-05 | 2013-01-03 | Democrat | 2 | http://polis.house.gov | 501 Cannon HOB; Washington DC 20515-0602 | 202-225-2161 | 202-226-7840 | http://polis.house.gov/Contact/ | 501 Cannon House Office Building | |||||||
43723 | 43723 | Eric Swalwell S001193 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 15 | http://swalwell.house.gov | 501 Cannon HOB; Washington DC 20515-0515 | 202-225-5065 | http://swalwell.house.gov/contact-me/email-eric/ | 501 Cannon House Office Building | ||||||||
44060 | 44060 | Glenn Grothman G000576 | rep | WI | 2015-01-06 | 2017-01-03 | Republican | 6 | http://grothman.house.gov | 501 Cannon HOB; Washington DC 20515-4906 | 202-225-2476 | 202-225-2356 | 501 Cannon House Office Building | ||||||||
42788 | 42788 | Ben Luján L000570 | sen | NM | 2021-01-03 | 2027-01-03 | 2 | Democrat | https://www.lujan.senate.gov | 498 Russell Senate Office Building Washington DC 20510 | 202-224-6621 | https://www.lujan.senate.gov/contact/ | 498 Russell 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& | |||||
41884 | 41884 | James Risch R000584 | sen | ID | 2009-01-06 | 2015-01-03 | 2 | Republican | http://www.risch.senate.gov | 483 Russell Senate Office Building Washington DC 20510 | 202-224-2752 | 202-224-2573 | http://www.risch.senate.gov/public/index.cfm?p=Email | 483 Russell Senate Office Building | junior | ||||||
41885 | 41885 | James Risch R000584 | sen | ID | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.risch.senate.gov | 483 Russell Senate Office Building Washington DC 20510 | 202-224-2752 | 202-224-2573 | http://www.risch.senate.gov/public/index.cfm?p=Email | 483 Russell Senate Office Building | junior | ||||||
41886 | 41886 | James Risch R000584 | sen | ID | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.risch.senate.gov | 483 Russell Senate Office Building Washington DC 20510 | 202-224-2752 | https://www.risch.senate.gov/public/index.cfm?p=Email | 483 Russell Senate Office Building | junior | |||||||
44171 | 44171 | Roger Marshall M001198 | sen | KS | 2021-01-03 | 2027-01-03 | 2 | Republican | https://www.marshall.senate.gov | 479A Russell Senate Office Building Washington DC 20510 | 202-224-4774 | https://www.marshall.senate.gov/contact/ | 479a Russell Senate Office Building | junior | |||||||
41895 | 41895 | Kirsten Gillibrand G000555 | sen | NY | 2009-01-27 | 2013-01-03 | 1 | Democrat | appointment | http://gillibrand.senate.gov | 478 RUSSELL SENATE OFFICE BUILDING WASHINGTON DC 20510 | 202-224-4451 | 202-228-0282 | http://www.gillibrand.senate.gov/contact/ | 478 Russell Senate Office Building | ||||||
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/ | ||||||
41890 | 41890 | Mark Warner W000805 | sen | VA | 2009-01-06 | 2015-01-03 | 2 | Democrat | http://www.warner.senate.gov | 475 Russell Senate Office Building Washington DC 20510 | 202-224-2023 | 202-224-6295 | http://www.warner.senate.gov/public//index.cfm?p=ContactPage#form_f9db6196-2dc7-4cda-8add-f8435a71318a | 475 Russell Senate Office Building | senior | http://www.warner.senate.gov/public/?a=rss.feed | |||||
43320 | 43320 | David Scott S001157 | rep | GA | 2021-01-03 | 2023-01-03 | Democrat | 13 | https://davidscott.house.gov | 468 Cannon House Office Building Washington DC 20515-1013 | 202-225-2939 | 468 Cannon House Office Building | http://davidscott.house.gov/news/rss.aspx | ||||||||
41716 | 41716 | Jackie Walorski W000813 | rep | IN | 2021-01-03 | 2022-08-03 | Republican | 2 | https://walorski.house.gov | 466 Cannon House Office Building Washington DC 20515-1402 | 202-225-3915 | 466 Cannon House Office Building | http://walorski.house.gov/rss.xml | ||||||||
44413 | 44413 | Carol Miller M001205 | rep | WV | 2021-01-03 | 2023-01-03 | Republican | 3 | https://miller.house.gov | 465 Cannon House Office Building Washington DC 20515-4803 | 202-225-3452 | 465 Cannon House Office Building | |||||||||
43833 | 43833 | Sean Maloney M001185 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 18 | https://seanmaloney.house.gov | 464 Cannon House Office Building Washington DC 20515-3218 | 202-225-5441 | 464 Cannon House Office Building | http://seanmaloney.house.gov/rss.xml | ||||||||
42383 | 42383 | Charles Fleischmann F000459 | rep | TN | 2021-01-03 | 2023-01-03 | Republican | 3 | https://fleischmann.house.gov | 462 Cannon House Office Building Washington DC 20515-4203 | 202-225-3271 | 462 Cannon House Office Building | http://fleischmann.house.gov/rss.xml | ||||||||
44343 | 44343 | Pete Stauber S001212 | rep | MN | 2021-01-03 | 2023-01-03 | Republican | 8 | https://stauber.house.gov | 461 Cannon House Office Building Washington DC 20515-2308 | 202-225-6211 | 461 Cannon House Office Building | |||||||||
43868 | 43868 | Tom Rice R000597 | rep | SC | 2021-01-03 | 2023-01-03 | Republican | 7 | https://rice.house.gov | 460 Cannon House Office Building Washington DC 20515-4007 | 202-225-9895 | 460 Cannon House Office Building | http://rice.house.gov/rss.xml |
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);