legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
471 rows where "start" is on date 2019-01-03 sorted by phone
This data as json, copyable, CSV (advanced)
Suggested facets: type, end, party, state_rank
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
43811 | 43811 | Kevin Cramer C001096 | sen | ND | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.cramer.senate.gov | 330 Hart Senate Office Building Washington DC 20510 | 202-224-2043 | https://www.cramer.senate.gov/contact/contact-kevin | 330 Hart Senate Office Building | junior | |||||||
41254 | 41254 | Martha McSally M001197 | sen | AZ | 2019-01-03 | 2020-12-02 | 3 | Republican | appointment | https://www.mcsally.senate.gov | 404 Russell Senate Office Building Washington DC 20510 | 202-224-2235 | https://www.mcsally.senate.gov/contact_martha | 404 Russell Senate Office Building | junior | special-election | |||||
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& | ||||||
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 | ||||||
41809 | 41809 | Jon Tester T000464 | sen | MT | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.tester.senate.gov | 311 Hart Senate Office Building Washington DC 20510 | 202-224-2644 | https://www.tester.senate.gov/?p=email_senator | 311 Hart Senate Office Building | senior | http://www.tester.senate.gov/rss/?p=hot_topic | ||||||
41812 | 41812 | Sheldon Whitehouse W000802 | sen | RI | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.whitehouse.senate.gov | 530 Hart Senate Office Building Washington DC 20510 | 202-224-2921 | 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 | ||||||
41778 | 41778 | Amy Klobuchar K000367 | sen | MN | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.klobuchar.senate.gov | 425 Dirksen Senate Office Building Washington DC 20510 | 202-224-3244 | https://www.klobuchar.senate.gov/public/index.cfm/contact | 425 Dirksen Senate Office Building | senior | |||||||
41966 | 41966 | Marsha Blackburn B001243 | sen | TN | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.blackburn.senate.gov | 357 Dirksen Senate Office Building Washington DC 20510 | 202-224-3344 | https://www.blackburn.senate.gov/email-me | 357 Dirksen Senate Office Building | senior | |||||||
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 | ||||||
41775 | 41775 | Dianne Feinstein F000062 | sen | CA | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.feinstein.senate.gov | 331 Hart Senate Office Building Washington DC 20510 | 202-224-3841 | https://www.feinstein.senate.gov/public/index.cfm/e-mail-me | 331 Hart Senate Office Building | senior | http://www.feinstein.senate.gov/public/?a=rss.feed | ||||||
41903 | 41903 | Joe Manchin M001183 | sen | WV | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.manchin.senate.gov | 306 Hart Senate Office Building Washington DC 20510 | 202-224-3954 | https://www.manchin.senate.gov/public/index.cfm/contact-form | 306 Hart Senate Office Building | senior | http://www.manchin.senate.gov/public/index.cfm/rss/feed | ||||||
43897 | 43897 | Timothy Kaine K000384 | sen | VA | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.kaine.senate.gov | 231 Russell Senate Office Building Washington DC 20510 | 202-224-4024 | https://www.kaine.senate.gov/contact | 231 Russell Senate Office Building | junior | http://www.kaine.senate.gov/rss/feeds/?type=all | ||||||
42966 | 42966 | Christopher Murphy M001169 | sen | CT | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.murphy.senate.gov | 136 Hart Senate Office Building Washington DC 20510 | 202-224-4041 | https://www.murphy.senate.gov/contact | 136 Hart Senate Office Building | junior | http://www.theday.com/article/20121216/nws12/312169935/1069/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/ | ||||||
43707 | 43707 | Kyrsten Sinema S001191 | sen | AZ | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.sinema.senate.gov | 317 Hart Senate Office Building Washington DC 20510 | 202-224-4521 | https://www.sinema.senate.gov/contact-kyrsten | 317 Hart Senate Office Building | senior | |||||||
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 | ||||||
43787 | 43787 | Elizabeth Warren W000817 | sen | MA | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.warren.senate.gov | 309 Hart Senate Office Building Washington DC 20510 | 202-224-4543 | https://www.warren.senate.gov/?p=email_senator | 309 Hart Senate Office Building | senior | http://www.warren.senate.gov/rss/?p=hot_topic | ||||||
41789 | 41789 | Robert Menendez M000639 | sen | NJ | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.menendez.senate.gov | 528 Hart Senate Office Building Washington DC 20510 | 202-224-4744 | https://www.menendez.senate.gov/contact | 528 Hart Senate Office Building | senior | http://www.menendez.senate.gov/rss/feeds/index.cfm?type=news | ||||||
44415 | 44415 | Mike Braun B001310 | sen | IN | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.braun.senate.gov | 404 Russell Senate Office Building Washington DC 20510 | 202-224-4814 | https://www.braun.senate.gov/contact-mike | 404 Russell Senate Office Building | junior | |||||||
41806 | 41806 | Debbie Stabenow S000770 | sen | MI | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.stabenow.senate.gov | 731 Hart Senate Office Building Washington DC 20510 | 202-224-4822 | https://www.stabenow.senate.gov/contact | 731 Hart Senate Office Building | senior | http://stabenow.senate.gov/rss/?p=news | ||||||
41800 | 41800 | Bernard Sanders S000033 | sen | VT | 2019-01-03 | 2025-01-03 | 1 | Independent | https://www.sanders.senate.gov | Democrat | 332 Dirksen Senate Office Building Washington DC 20510 | 202-224-5141 | https://www.sanders.senate.gov/contact/ | 332 Dirksen Senate Office Building | junior | http://www.sanders.senate.gov/rss/ | |||||
44417 | 44417 | Mitt Romney R000615 | sen | UT | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.romney.senate.gov | 354 Russell Senate Office Building Washington DC 20510 | 202-224-5251 | https://www.romney.senate.gov/contact-senator-romney | 354 Russell Senate Office Building | junior | |||||||
43789 | 43789 | Angus King K000383 | sen | ME | 2019-01-03 | 2025-01-03 | 1 | Independent | https://www.king.senate.gov | Democrat | 133 Hart Senate Office Building Washington DC 20510 | 202-224-5344 | https://www.king.senate.gov/contact | 133 Hart Senate Office Building | junior | http://www.king.senate.gov/rss/feeds/?type=all | |||||
42502 | 42502 | Martin Heinrich H001046 | sen | NM | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.heinrich.senate.gov | 303 Hart Senate Office Building Washington DC 20510 | 202-224-5521 | https://www.heinrich.senate.gov/contact | 303 Hart Senate Office Building | senior | |||||||
41925 | 41925 | Tammy Baldwin B001230 | sen | WI | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.baldwin.senate.gov | 709 Hart Senate Office Building Washington DC 20510 | 202-224-5653 | https://www.baldwin.senate.gov/feedback | 709 Hart Senate Office Building | junior | http://www.baldwin.senate.gov/rss/feeds/?type=all | ||||||
43870 | 43870 | Ted Cruz C001098 | sen | TX | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.cruz.senate.gov | 127A Russell Senate Office Building Washington DC 20510 | 202-224-5922 | https://www.cruz.senate.gov/?p=form&id=16 | 127a Russell Senate Office Building | junior | |||||||
44416 | 44416 | Joshua Hawley H001089 | sen | MO | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.hawley.senate.gov | 115 Russell Senate Office Building Washington DC 20510 | 202-224-6154 | https://www.hawley.senate.gov/contact-senator-hawley | 115 Russell Senate Office Building | junior | |||||||
44197 | 44197 | Jacky Rosen R000608 | sen | NV | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.rosen.senate.gov | 713 Hart Senate Office Building Washington DC 20510 | 202-224-6244 | https://www.rosen.senate.gov/contact_jacky | 713 Hart Senate Office Building | junior | |||||||
41825 | 41825 | Roger Wicker W000437 | sen | MS | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.wicker.senate.gov | 555 Dirksen Senate Office Building Washington DC 20510 | 202-224-6253 | https://www.wicker.senate.gov/public/index.cfm/contact | 555 Dirksen Senate Office Building | senior | |||||||
41769 | 41769 | Robert Casey C001070 | sen | PA | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.casey.senate.gov | 393 Russell Senate Office Building Washington DC 20510 | 202-224-6324 | https://www.casey.senate.gov/contact | 393 Russell Senate Office Building | senior | http://www.casey.senate.gov/rss/feeds/?all | ||||||
42529 | 42529 | Mazie Hirono H001042 | sen | HI | 2019-01-03 | 2025-01-03 | 1 | Democrat | https://www.hirono.senate.gov | 109 Hart Senate Office Building Washington DC 20510 | 202-224-6361 | https://www.hirono.senate.gov/contact | 109 Hart Senate Office Building | junior | http://www.hirono.senate.gov/rss/feeds/?type=all | ||||||
41815 | 41815 | John Barrasso B001261 | sen | WY | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.barrasso.senate.gov | 307 Dirksen Senate Office Building Washington DC 20510 | 202-224-6441 | https://www.barrasso.senate.gov/public/index.cfm/contact-form | 307 Dirksen Senate Office Building | senior | http://www.barrasso.senate.gov/public/index.cfm?FuseAction=Rss.Feed | ||||||
43813 | 43813 | Deb Fischer F000463 | sen | NE | 2019-01-03 | 2025-01-03 | 1 | Republican | https://www.fischer.senate.gov | 454 Russell Senate Office Building Washington DC 20510 | 202-224-6551 | https://www.fischer.senate.gov/public/index.cfm/contact | 454 Russell Senate Office Building | senior | http://www.fischer.senate.gov/public/index.cfm/rss/feed | ||||||
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 | ||||||||
41209 | 41209 | Katie Hill H001087 | rep | CA | 2019-01-03 | 2019-11-03 | Democrat | 25 | https://katiehill.house.gov | 1130 Longworth House Office Building; Washington DC 20515-0525 | 202-225-1956 | 1130 Longworth 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 | |||||||||
44062 | 44062 | Glenn Grothman G000576 | rep | WI | 2019-01-03 | 2021-01-03 | Republican | 6 | https://grothman.house.gov | 1427 Longworth House Office Building Washington DC 20515-4906 | 202-225-2476 | 1427 Longworth 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);