legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
469 rows where "end" is on date 2021-01-03 sorted by phone
This data as json, copyable, CSV (advanced)
Suggested facets: start, district, rss_url
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41891 | 41891 | Mark Warner W000805 | sen | VA | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.warner.senate.gov | 703 Hart Senate Office Building Washington DC 20510 | 202-224-2023 | 202-224-6295 | http://www.warner.senate.gov/public/index.cfm?p=Contact | 703 Hart Senate Office Building | senior | http://www.warner.senate.gov/public/?a=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 | |||||
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 | |||||||
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 | |||||
41871 | 41871 | Mitch McConnell M000355 | sen | KY | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.mcconnell.senate.gov | 317 Russell Senate Office Building Washington DC 20510 | 202-224-2541 | 202-224-2499 | http://www.mcconnell.senate.gov/public/index.cfm?p=contact | 317 Russell Senate Office Building | senior | http://www.mcconnell.senate.gov/public/?a=rss.feed | |||||
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 | ||||||
42836 | 42836 | Edward Markey M000133 | sen | MA | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.markey.senate.gov | 255 Dirksen Senate Office Building Washington DC 20510 | 202-224-2742 | https://www.markey.senate.gov/contact | 255 Dirksen 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 | ||||||
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/ | |||||
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 | |||||
44072 | 44072 | Dan Sullivan S001198 | sen | AK | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.sullivan.senate.gov | 302 Hart Senate Office Building Washington DC 20510 | 202-224-3004 | https://www.sullivan.senate.gov/contact/email | 302 Hart Senate Office Building | junior | |||||||
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 | ||||||
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 | |||||||
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 | |||||
41584 | 41584 | David Perdue P000612 | sen | GA | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.perdue.senate.gov | 455 Russell Senate Office Building Washington DC 20510 | 202-224-3521 | https://www.perdue.senate.gov/connect/email | 455 Russell Senate Office Building | senior | |||||||
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/ | |||||
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 | |||||||
44080 | 44080 | Benjamin Sasse S001197 | sen | NE | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.sasse.senate.gov/public | 107 Russell Senate Office Building Washington DC 20510 | 202-224-4224 | http://www.sasse.senate.gov/public/index.cfm/email-ben | 107 Russell Senate Office Building | junior | |||||||
41882 | 41882 | John Reed R000122 | sen | RI | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.reed.senate.gov | 728 Hart Senate Office Building Washington DC 20510 | 202-224-4642 | 202-224-4680 | https://www.reed.senate.gov/contact/ | 728 Hart Senate Office Building | senior | https://www.reed.senate.gov//rss/feeds/?type=all | |||||
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 | |||||
41277 | 41277 | Pat Roberts R000307 | sen | KS | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.roberts.senate.gov | 109 Hart Senate Office Building Washington DC 20510 | 202-224-4774 | 202-224-3514 | https://www.roberts.senate.gov/public/?p=EmailPat | 109 Hart Senate Office Building | senior | http://www.roberts.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 | |||||
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 | |||||
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 | |||||||
44243 | 44243 | Tina Smith S001203 | sen | MN | 2018-11-07 | 2021-01-03 | 2 | Democrat | https://www.smith.senate.gov | 720 Hart Senate Office Building Washington DC 20510 | 202-224-5641 | https://www.smith.senate.gov/contact-tina | 720 Hart Senate Office Building | junior | |||||||
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 | ||||||
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 | |||||||
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 | ||||||
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 | |||||
43101 | 43101 | Gary Peters P000595 | sen | MI | 2015-01-06 | 2021-01-03 | 2 | Democrat | https://www.peters.senate.gov | 724 Hart Senate Office Building Washington DC 20510 | 202-224-6221 | 202-226-2356 | https://www.peters.senate.gov/contact/email-gary | 724 Hart Senate Office Building | junior | ||||||
44076 | 44076 | Thom Tillis T000476 | sen | NC | 2015-01-06 | 2021-01-03 | 2 | Republican | https://www.tillis.senate.gov | 113 Dirksen Senate Office Building Washington DC 20510 | 202-224-6342 | https://www.tillis.senate.gov/public/index.cfm/email-me | 113 Dirksen Senate Office Building | junior | |||||||
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 | ||||||
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 | |||||
44143 | 44143 | Al Lawson L000586 | rep | FL | 2019-01-03 | 2021-01-03 | Democrat | 5 | https://lawson.house.gov | 1406 Longworth House Office Building Washington DC 20515-0905 | 202-225-0123 | 1406 Longworth House Office Building | |||||||||
41298 | 41298 | Rob Bishop B001250 | rep | UT | 2019-01-03 | 2021-01-03 | Republican | 1 | https://robbishop.house.gov | 123 Cannon House Office Building Washington DC 20515-4401 | 202-225-0453 | 123 Cannon House Office Building | http://robbishop.house.gov/news/rss.aspx | ||||||||
43761 | 43761 | Scott Peters P000608 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 52 | https://scottpeters.house.gov | 2338 Rayburn House Office Building Washington DC 20515-0552 | 202-225-0508 | 2338 Rayburn House Office Building | http://scottpeters.house.gov/rss.xml | ||||||||
43911 | 43911 | Robin Kelly K000385 | rep | IL | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://robinkelly.house.gov | 2416 Rayburn House Office Building Washington DC 20515-1302 | 202-225-0773 | 2416 Rayburn House Office Building | http://robinkelly.house.gov/rss.xml | ||||||||
43665 | 43665 | Suzanne Bonamici B001278 | rep | OR | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://bonamici.house.gov | 2231 Rayburn House Office Building Washington DC 20515-3701 | 202-225-0855 | 2231 Rayburn House Office Building | http://bonamici.house.gov/rss.xml | ||||||||
43589 | 43589 | Daniel Webster W000806 | rep | FL | 2019-01-03 | 2021-01-03 | Republican | 11 | https://webster.house.gov | 1210 Longworth House Office Building Washington DC 20515-0911 | 202-225-1002 | 1210 Longworth House Office Building | http://webster.house.gov/news/rss.aspx | ||||||||
44304 | 44304 | Michael San Nicolas S001204 | rep | GU | 2019-01-03 | 2021-01-03 | Democrat | 0 | https://sannicolas.house.gov | 1632 Longworth House Office Building Washington DC 20515-5301 | 202-225-1188 | 1632 Longworth House Office Building | |||||||||
41598 | 41598 | Ross Spano S001210 | rep | FL | 2019-01-03 | 2021-01-03 | Republican | 15 | https://spano.house.gov | 224 Cannon House Office Building Washington DC 20515-0915 | 202-225-1252 | 224 Cannon House Office Building | |||||||||
41644 | 41644 | Alcee Hastings H000324 | rep | FL | 2019-01-03 | 2021-01-03 | Democrat | 20 | https://alceehastings.house.gov | 2353 Rayburn House Office Building Washington DC 20515-0920 | 202-225-1313 | 2353 Rayburn House Office Building | http://www.alceehastings.house.gov/news/rss.aspx | ||||||||
42196 | 42196 | Gerald Connolly C001078 | rep | VA | 2019-01-03 | 2021-01-03 | Democrat | 11 | https://connolly.house.gov | 2238 Rayburn House Office Building Washington DC 20515-4611 | 202-225-1492 | 2238 Rayburn House Office Building | http://connolly.house.gov/common/rss//index.cfm?rss=44 | ||||||||
43934 | 43934 | Alma Adams A000370 | rep | NC | 2019-01-03 | 2021-01-03 | Democrat | 12 | https://adams.house.gov | 2436 Rayburn House Office Building Washington DC 20515-3312 | 202-225-1510 | 2436 Rayburn House Office Building | |||||||||
44046 | 44046 | Brian Babin B001291 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 36 | https://babin.house.gov | 2236 Rayburn House Office Building Washington DC 20515-4336 | 202-225-1555 | 2236 Rayburn House Office Building | |||||||||
42600 | 42600 | Henry Johnson J000288 | rep | GA | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://hankjohnson.house.gov | 2240 Rayburn House Office Building Washington DC 20515-1004 | 202-225-1605 | 2240 Rayburn House Office Building | http://hankjohnson.house.gov/rss.xml | ||||||||
43798 | 43798 | Ann Wagner W000812 | rep | MO | 2019-01-03 | 2021-01-03 | Republican | 2 | https://wagner.house.gov | 2350 Rayburn House Office Building Washington DC 20515-2502 | 202-225-1621 | 2350 Rayburn House Office Building | http://wagner.house.gov/rss.xml | ||||||||
42251 | 42251 | Henry Cuellar C001063 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 28 | https://cuellar.house.gov | 2372 Rayburn House Office Building Washington DC 20515-4328 | 202-225-1640 | 2372 Rayburn House Office Building | http://cuellar.house.gov/news/rss.aspx | ||||||||
44396 | 44396 | Sylvia Garcia G000587 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 29 | https://sylviagarcia.house.gov | 1620 Longworth House Office Building Washington DC 20515-4329 | 202-225-1688 | 1620 Longworth House Office Building | |||||||||
43194 | 43194 | Lucille Roybal-Allard R000486 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 40 | https://roybal-allard.house.gov | 2083 Rayburn House Office Building Washington DC 20515-0540 | 202-225-1766 | 2083 Rayburn House Office Building | http://roybal-allard.house.gov/news/rss.aspx | ||||||||
43141 | 43141 | David Price P000523 | rep | NC | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://price.house.gov | 2108 Rayburn House Office Building Washington DC 20515-3304 | 202-225-1784 | 2108 Rayburn House Office Building | http://price.house.gov/index.php?format=feed&type=rss | ||||||||
44054 | 44054 | Stacey Plaskett P000610 | rep | VI | 2019-01-03 | 2021-01-03 | Democrat | 0 | https://plaskett.house.gov | 2404 Rayburn House Office Building Washington DC 20515-5500 | 202-225-1790 | 2404 Rayburn House Office Building | |||||||||
42398 | 42398 | John Garamendi G000559 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://garamendi.house.gov | 2368 Rayburn House Office Building Washington DC 20515-0503 | 202-225-1880 | 2368 Rayburn House Office Building | http://garamendi.house.gov/rss.xml | ||||||||
42925 | 42925 | Jerry McNerney M001166 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 9 | https://mcnerney.house.gov | 2265 Rayburn House Office Building Washington DC 20515-0509 | 202-225-1947 | 2265 Rayburn House Office Building | http://mcnerney.house.gov/rss.xml | ||||||||
44435 | 44435 | Mike Garcia G000061 | rep | CA | 2020-05-19 | 2021-01-03 | Republican | 25 | 1130 Longworth House Office Building Washington DC 20515-0525 | 202-225-1956 | 1130 Longworth House Office Building | ||||||||||
44422 | 44422 | Dan Bishop B001311 | rep | NC | 2019-09-17 | 2021-01-03 | Republican | 9 | https://danbishop.house.gov/ | 132 Cannon House Office Building Washington DC 20515-3309 | 202-225-1976 | https://danbishop.house.gov/contact/email | 132 Cannon House Office Building | ||||||||
42073 | 42073 | Ken Calvert C000059 | rep | CA | 2019-01-03 | 2021-01-03 | Republican | 42 | https://calvert.house.gov | 2205 Rayburn House Office Building Washington DC 20515-0542 | 202-225-1986 | 2205 Rayburn House Office Building | http://calvert.house.gov/news/rss.aspx | ||||||||
41619 | 41619 | Ron Wright W000827 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 6 | https://wright.house.gov | 428 Cannon House Office Building Washington DC 20515-4306 | 202-225-2002 | 428 Cannon House Office Building | |||||||||
42917 | 42917 | Cathy McMorris Rodgers M001159 | rep | WA | 2019-01-03 | 2021-01-03 | Republican | 5 | https://mcmorris.house.gov | 1035 Longworth House Office Building Washington DC 20515-4705 | 202-225-2006 | 1035 Longworth House Office Building | http://mcmorris.house.gov/common/rss/?rss=96 | ||||||||
44267 | 44267 | Mary Scanlon S001205 | rep | PA | 2019-01-03 | 2021-01-03 | Democrat | 5 | https://scanlon.house.gov | 1535 Longworth House Office Building Washington DC 20515-3805 | 202-225-2011 | 1535 Longworth House Office Building | |||||||||
41650 | 41650 | Steve Stivers S001187 | rep | OH | 2019-01-03 | 2021-01-03 | Republican | 15 | https://stivers.house.gov | 2234 Rayburn House Office Building Washington DC 20515-3515 | 202-225-2015 | 2234 Rayburn House Office Building | http://stivers.house.gov/news/rss.aspx | ||||||||
44173 | 44173 | Clay Higgins H001077 | rep | LA | 2019-01-03 | 2021-01-03 | Republican | 3 | https://clayhiggins.house.gov | 424 Cannon House Office Building Washington DC 20515-1803 | 202-225-2031 | 424 Cannon House Office Building | |||||||||
41326 | 41326 | Susan Davis D000598 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 53 | https://susandavis.house.gov | 1214 Longworth House Office Building Washington DC 20515-0553 | 202-225-2040 | 1214 Longworth House Office Building | |||||||||
44372 | 44372 | Guy Reschenthaler R000610 | rep | PA | 2019-01-03 | 2021-01-03 | Republican | 14 | https://reschenthaler.house.gov | 531 Cannon House Office Building Washington DC 20515-3814 | 202-225-2065 | 531 Cannon House Office Building | |||||||||
42391 | 42391 | Virginia Foxx F000450 | rep | NC | 2019-01-03 | 2021-01-03 | Republican | 5 | https://foxx.house.gov | 2462 Rayburn House Office Building Washington DC 20515-3305 | 202-225-2071 | 2462 Rayburn House Office Building | http://foxx.house.gov/common/rss/?rss=55 | ||||||||
42229 | 42229 | Joe Courtney C001069 | rep | CT | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://courtney.house.gov | 2332 Rayburn House Office Building Washington DC 20515-0702 | 202-225-2076 | 2332 Rayburn House Office Building | http://courtney.house.gov/index.php?format=feed&type=rss | ||||||||
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 | |||||||||
41591 | 41591 | Paul Mitchell M001201 | rep | MI | 2019-01-03 | 2021-01-03 | Independent | 10 | [ { "start": "2019-01-03", "end": "2020-12-13", "party": "Republican" }, { "start": "2020-12-14", "end": "2021-01-03", "party": "Independent" } ] |
https://mitchell.house.gov | 211 Cannon House Office Building Washington DC 20515-2210 | 202-225-2106 | 211 Cannon House Office Building | ||||||||
43266 | 43266 | Janice Schakowsky S001145 | rep | IL | 2019-01-03 | 2021-01-03 | Democrat | 9 | https://schakowsky.house.gov | 2367 Rayburn House Office Building Washington DC 20515-1309 | 202-225-2111 | 2367 Rayburn House Office Building | http://schakowsky.house.gov/index.php?format=feed&type=rss | ||||||||
41606 | 41606 | Kendra Horn H001083 | rep | OK | 2019-01-03 | 2021-01-03 | Democrat | 5 | https://horn.house.gov | 415 Cannon House Office Building Washington DC 20515-3605 | 202-225-2132 | 415 Cannon House Office Building | |||||||||
42355 | 42355 | Michael Doyle D000482 | rep | PA | 2019-01-03 | 2021-01-03 | Democrat | 18 | https://doyle.house.gov | 306 Cannon House Office Building Washington DC 20515-3818 | 202-225-2135 | 306 Cannon House Office Building | http://doyle.house.gov/rss.xml | ||||||||
44292 | 44292 | Joe Neguse N000191 | rep | CO | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://neguse.house.gov | 1419 Longworth House Office Building Washington DC 20515-0602 | 202-225-2161 | 1419 Longworth House Office Building | |||||||||
41433 | 41433 | Collin Peterson P000258 | rep | MN | 2019-01-03 | 2021-01-03 | Democrat | 7 | https://collinpeterson.house.gov | 2204 Rayburn House Office Building Washington DC 20515-2307 | 202-225-2165 | 2204 Rayburn House Office Building | http://collinpeterson.house.gov/rss.xml | ||||||||
44152 | 44152 | Val Demings D000627 | rep | FL | 2019-01-03 | 2021-01-03 | Democrat | 10 | https://demings.house.gov | 217 Cannon House Office Building Washington DC 20515-0910 | 202-225-2176 | 217 Cannon House Office Building | |||||||||
43303 | 43303 | David Schweikert S001183 | rep | AZ | 2019-01-03 | 2021-01-03 | Republican | 6 | https://schweikert.house.gov | 1526 Longworth House Office Building Washington DC 20515-0306 | 202-225-2190 | 1526 Longworth House Office Building | http://schweikert.house.gov/rss/press-releases.xml | ||||||||
43583 | 43583 | Maxine Waters W000187 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 43 | https://waters.house.gov | 2221 Rayburn House Office Building Washington DC 20515-0543 | 202-225-2201 | 2221 Rayburn House Office Building | http://waters.house.gov/news/rss.aspx | ||||||||
44261 | 44261 | Kevin Hern H001082 | rep | OK | 2019-01-03 | 2021-01-03 | Republican | 1 | https://hern.house.gov | 1019 Longworth House Office Building Washington DC 20515-3601 | 202-225-2211 | 1019 Longworth House Office Building | |||||||||
42126 | 42126 | Steve Chabot C000266 | rep | OH | 2019-01-03 | 2021-01-03 | Republican | 1 | https://chabot.house.gov | 2408 Rayburn House Office Building Washington DC 20515-3501 | 202-225-2216 | 2408 Rayburn House Office Building | http://chabot.house.gov/common/rss/index.cfm?rss=49 | ||||||||
44398 | 44398 | Colin Allred A000376 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 32 | https://allred.house.gov | 328 Cannon House Office Building Washington DC 20515-4332 | 202-225-2231 | 328 Cannon House Office Building | |||||||||
42707 | 42707 | John Larson L000557 | rep | CT | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://larson.house.gov | 1501 Longworth House Office Building Washington DC 20515-0701 | 202-225-2265 | 1501 Longworth House Office Building | http://www.larson.house.gov/index.php?format=feed&type=rss | ||||||||
44336 | 44336 | Angie Craig C001119 | rep | MN | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://craig.house.gov | 1523 Longworth House Office Building Washington DC 20515-2302 | 202-225-2271 | 1523 Longworth House Office Building | |||||||||
41561 | 41561 | Susan Brooks B001284 | rep | IN | 2019-01-03 | 2021-01-03 | Republican | 5 | https://susanwbrooks.house.gov | 2211 Rayburn House Office Building Washington DC 20515-1405 | 202-225-2276 | 2211 Rayburn House Office Building | http://susanwbrooks.house.gov/rss.xml | ||||||||
44249 | 44249 | Conor Lamb L000588 | rep | PA | 2019-01-03 | 2021-01-03 | Democrat | 17 | https://lamb.house.gov | 1224 Longworth House Office Building Washington DC 20515-3817 | 202-225-2301 | 1224 Longworth House Office Building | |||||||||
43746 | 43746 | Mark Takano T000472 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 41 | https://takano.house.gov | 420 Cannon House Office Building Washington DC 20515-0541 | 202-225-2305 | 420 Cannon House Office Building | http://takano.house.gov/rss.xml | ||||||||
44228 | 44228 | Liz Cheney C001109 | rep | WY | 2019-01-03 | 2021-01-03 | Republican | 0 | https://cheney.house.gov | 416 Cannon House Office Building Washington DC 20515-5000 | 202-225-2311 | 416 Cannon House Office Building | |||||||||
42419 | 42419 | Paul Gosar G000565 | rep | AZ | 2019-01-03 | 2021-01-03 | Republican | 4 | https://gosar.house.gov | 2057 Rayburn House Office Building Washington DC 20515-0304 | 202-225-2315 | 2057 Rayburn House Office Building | http://gosar.house.gov/rss.xml | ||||||||
44014 | 44014 | Tom Emmer E000294 | rep | MN | 2019-01-03 | 2021-01-03 | Republican | 6 | https://emmer.house.gov | 315 Cannon House Office Building Washington DC 20515-2306 | 202-225-2331 | 315 Cannon House Office Building | |||||||||
43551 | 43551 | Nydia Velázquez V000081 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 7 | https://velazquez.house.gov | 2302 Rayburn House Office Building Washington DC 20515-3207 | 202-225-2361 | 2302 Rayburn House Office Building | |||||||||
41603 | 41603 | Xochitl Torres Small T000484 | rep | NM | 2019-01-03 | 2021-01-03 | Democrat | 2 | https://torressmall.house.gov | 430 Cannon House Office Building Washington DC 20515-3102 | 202-225-2365 | 430 Cannon House Office Building | |||||||||
43774 | 43774 | Rodney Davis D000619 | rep | IL | 2019-01-03 | 2021-01-03 | Republican | 13 | https://rodneydavis.house.gov | 1740 Longworth House Office Building Washington DC 20515-1313 | 202-225-2371 | 1740 Longworth House Office Building | http://rodneydavis.house.gov/rss.xml | ||||||||
42862 | 42862 | Michael McCaul M001157 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 10 | https://mccaul.house.gov | 2001 Rayburn House Office Building Washington DC 20515-4310 | 202-225-2401 | 2001 Rayburn House Office Building | |||||||||
41308 | 41308 | Wm. Clay C001049 | rep | MO | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://lacyclay.house.gov | 2428 Rayburn House Office Building Washington DC 20515-2501 | 202-225-2406 | 2428 Rayburn House Office Building | |||||||||
44208 | 44208 | Lloyd Smucker S001199 | rep | PA | 2019-01-03 | 2021-01-03 | Republican | 11 | https://smucker.house.gov | 127 Cannon House Office Building Washington DC 20515-3811 | 202-225-2411 | 127 Cannon House Office Building | |||||||||
41597 | 41597 | Harley Rouda R000616 | rep | CA | 2019-01-03 | 2021-01-03 | Democrat | 48 | https://rouda.house.gov | 2300 Rayburn House Office Building Washington DC 20515-0548 | 202-225-2415 | 2300 Rayburn House Office Building | |||||||||
44370 | 44370 | John Joyce J000302 | rep | PA | 2019-01-03 | 2021-01-03 | Republican | 13 | https://johnjoyce.house.gov | 1337 Longworth House Office Building Washington DC 20515-3813 | 202-225-2431 | 1337 Longworth House Office Building | |||||||||
42478 | 42478 | Raúl Grijalva G000551 | rep | AZ | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://grijalva.house.gov | 1511 Longworth House Office Building Washington DC 20515-0303 | 202-225-2435 | 1511 Longworth House Office Building | http://grijalva.house.gov/common/rss/?rss=13 | ||||||||
43608 | 43608 | Joe Wilson W000795 | rep | SC | 2019-01-03 | 2021-01-03 | Republican | 2 | https://joewilson.house.gov | 1436 Longworth House Office Building Washington DC 20515-4002 | 202-225-2452 | 1436 Longworth House Office Building | http://joewilson.house.gov/news/rss.aspx | ||||||||
41529 | 41529 | Peter Visclosky V000108 | rep | IN | 2019-01-03 | 2021-01-03 | Democrat | 1 | https://visclosky.house.gov | 2328 Rayburn House Office Building Washington DC 20515-1401 | 202-225-2461 | 2328 Rayburn House Office Building | http://visclosky.house.gov/rss.xml | ||||||||
41342 | 41342 | Eliot Engel E000179 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 16 | https://engel.house.gov | 2426 Rayburn House Office Building Washington DC 20515-3216 | 202-225-2464 | 2426 Rayburn House Office Building | |||||||||
41662 | 41662 | Jim Hagedorn H001088 | rep | MN | 2019-01-03 | 2021-01-03 | Republican | 1 | https://hagedorn.house.gov | 325 Cannon House Office Building Washington DC 20515-2301 | 202-225-2472 | 325 Cannon House Office Building |
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);