legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
474 rows where "start" is on date 2017-01-03
This data as json, copyable, CSV (advanced)
Suggested facets: party, office, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40511 | 40511 | Mike Pompeo P000602 | rep | KS | 2017-01-03 | 2017-01-23 | Republican | 4 | http://pompeo.house.gov | 2452 Rayburn HOB; Washington DC 20515-1604 | 202-225-6216 | 2452 Rayburn House Office Building | http://pompeo.house.gov/news/rss.aspx | ||||||||
40524 | 40524 | Xavier Becerra B000287 | rep | CA | 2017-01-03 | 2017-01-24 | Democrat | 34 | https://becerra.house.gov | 1226 Longworth HOB; Washington DC 20515-0534 | 202-225-6235 | 1226 Longworth House Office Building | http://becerra.house.gov/index.php?format=feed&type=rss | ||||||||
40535 | 40535 | Tom Price P000591 | rep | GA | 2017-01-03 | 2017-02-10 | Republican | 6 | https://tomprice.house.gov | 1211 Longworth HOB; Washington DC 20515-1006 | 202-225-4501 | 202-225-4656 | 1211 Longworth House Office Building | http://tomprice.house.gov/rss.xml | |||||||
40539 | 40539 | Mick Mulvaney M001182 | rep | SC | 2017-01-03 | 2017-02-16 | Republican | 5 | https://mulvaney.house.gov | 2350 Rayburn HOB; Washington DC 20515-4005 | 202-225-5501 | 202-225-0464 | 2350 Rayburn House Office Building | http://mulvaney.house.gov/index.php?format=feed&type=rss | |||||||
40541 | 40541 | Ryan Zinke Z000018 | rep | MT | 2017-01-03 | 2017-03-01 | Republican | 0 | https://zinke.house.gov | 1419 Longworth HOB; Washington DC 20515-2600 | 202-225-3211 | 202-225-5687 | 1419 Longworth House Office Building | ||||||||
40546 | 40546 | Jason Chaffetz C001076 | rep | UT | 2017-01-03 | 2017-06-30 | Republican | 3 | https://chaffetz.house.gov | 2236 Rayburn HOB; Washington DC 20515-4403 | 202-225-7751 | 202-225-5629 | 2236 Rayburn House Office Building | http://chaffetz.house.gov/rss.xml | |||||||
40554 | 40554 | Tim Murphy M001151 | rep | PA | 2017-01-03 | 2017-10-21 | Republican | 18 | https://murphy.house.gov | 2332 Rayburn HOB; Washington DC 20515-3818 | 202-225-2301 | 202-225-1844 | 2332 Rayburn House Office Building | http://murphy.house.gov/common/rss/?rss=44 | |||||||
40581 | 40581 | John Conyers C000714 | rep | MI | 2017-01-03 | 2017-12-05 | Democrat | 13 | https://conyers.house.gov | 2426 Rayburn HOB; Washington DC 20515-2213 | 202-225-5126 | 202-225-0072 | 2426 Rayburn House Office Building | http://conyers.house.gov/index.cfm/rss/feed | |||||||
40589 | 40589 | Trent Franks F000448 | rep | AZ | 2017-01-03 | 2017-12-08 | Republican | 8 | https://franks.house.gov | 2435 Rayburn HOB; Washington DC 20515-0308 | 202-225-4576 | 202-225-6328 | 2435 Rayburn House Office Building | http://franks.house.gov/rss.xml | |||||||
40601 | 40601 | Patrick Tiberi T000462 | rep | OH | 2017-01-03 | 2018-01-15 | Republican | 12 | https://tiberi.house.gov | 1203 Longworth HOB; Washington DC 20515-3512 | 202-225-5355 | 202-226-4523 | 1203 Longworth House Office Building | http://tiberi.house.gov/news/rss.aspx | |||||||
40617 | 40617 | Louise Slaughter S000480 | rep | NY | 2017-01-03 | 2018-03-16 | Democrat | 25 | https://louise.house.gov | 2469 Rayburn House Office Building; Washington DC 20515-3225 | 202-225-3615 | 202-225-7822 | 2469 Rayburn House Office Building | http://louise.house.gov/index.php?format=feed&type=rss | |||||||
40631 | 40631 | Blake Farenthold F000460 | rep | TX | 2017-01-03 | 2018-04-06 | Republican | 27 | https://farenthold.house.gov | 2331 Rayburn House Office Building; Washington DC 20515-4327 | 202-225-7742 | 202-226-1134 | 2331 Rayburn House Office Building | http://farenthold.house.gov/index.php?format=feed&type=rss | |||||||
40635 | 40635 | Patrick Meehan M001181 | rep | PA | 2017-01-03 | 2018-04-27 | Republican | 7 | https://meehan.house.gov | 2305 Rayburn House Office Building; Washington DC 20515-3807 | 202-225-2011 | 202-226-0280 | 2305 Rayburn House Office Building | http://meehan.house.gov/rss/latest-news.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 | |||||||
40645 | 40645 | Charles Dent D000604 | rep | PA | 2017-01-03 | 2018-05-12 | Republican | 15 | https://dent.house.gov | 2082 Rayburn House Office Building; Washington DC 20515-3815 | 202-225-6411 | 202-226-0778 | 2082 Rayburn House Office Building | http://dent.house.gov/?a=rss.feed | |||||||
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 | ||||||
40656 | 40656 | Ron DeSantis D000621 | rep | FL | 2017-01-03 | 2018-09-10 | Republican | 6 | https://desantis.house.gov | 1524 Longworth House Office Building; Washington DC 20515-0906 | 202-225-2706 | 202-226-6299 | 1524 Longworth House Office Building | http://desantis.house.gov/rss.xml | |||||||
40658 | 40658 | Evan Jenkins J000297 | rep | WV | 2017-01-03 | 2018-09-30 | Republican | 3 | https://evanjenkins.house.gov | 1609 Longworth House Office Building; Washington DC 20515-4803 | 202-225-3452 | 202-225-9061 | 1609 Longworth House Office Building | ||||||||
40669 | 40669 | Michelle Lujan Grisham L000580 | rep | NM | 2017-01-03 | 2018-12-31 | Democrat | 1 | https://lujangrisham.house.gov | 214 Cannon House Office Building; Washington DC 20515-3101 | 202-225-6316 | 202-225-4975 | 214 Cannon House Office Building | http://lujangrisham.house.gov/rss.xml | |||||||
40693 | 40693 | Lou Barletta B001269 | rep | PA | 2017-01-03 | 2019-01-03 | Republican | 11 | https://barletta.house.gov | 2049 Rayburn House Office Building; Washington DC 20515-3811 | 202-225-6511 | 202-225-0764 | 2049 Rayburn House Office Building | http://barletta.house.gov/common/rss//index.cfm?rss=25 | |||||||
40710 | 40710 | Joe Barton B000213 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 6 | https://joebarton.house.gov | 2107 Rayburn House Office Building; Washington DC 20515-4306 | 202-225-2002 | 202-225-3052 | 2107 Rayburn House Office Building | http://joebarton.house.gov/index.php?format=feed&type=rss | |||||||
40714 | 40714 | Diane Black B001273 | rep | TN | 2017-01-03 | 2019-01-03 | Republican | 6 | https://black.house.gov | 1131 Longworth House Office Building; Washington DC 20515-4206 | 202-225-4231 | 202-225-6887 | 1131 Longworth House Office Building | http://black.house.gov/rss.xml | |||||||
40722 | 40722 | Madeleine Bordallo B001245 | rep | GU | 2017-01-03 | 2019-01-03 | Democrat | 0 | https://bordallo.house.gov | 2441 Rayburn House Office Building; Washington DC 20515-5301 | 202-225-1188 | 202-226-0341 | 2441 Rayburn House Office Building | http://bordallo.house.gov/rss.xml | |||||||
40733 | 40733 | Robert Brady B001227 | rep | PA | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://brady.house.gov | 2004 Rayburn House Office Building; Washington DC 20515-3801 | 202-225-4731 | 202-225-0088 | 2004 Rayburn House Office Building | http://brady.house.gov/rss.xml | |||||||
40743 | 40743 | Michael Capuano C001037 | rep | MA | 2017-01-03 | 2019-01-03 | Democrat | 7 | http://capuano.house.gov | 1414 Longworth House Office Building; Washington DC 20515-2107 | 202-225-5111 | 202-225-9322 | 1414 Longworth House Office Building | ||||||||
40748 | 40748 | Mike Coffman C001077 | rep | CO | 2017-01-03 | 2019-01-03 | Republican | 6 | https://coffman.house.gov | 2443 Rayburn House Office Building; Washington DC 20515-0606 | 202-225-7882 | 202-226-4623 | 2443 Rayburn House Office Building | http://coffman.house.gov/index.php?format=feed&type=rss | |||||||
40758 | 40758 | Joseph Crowley C001038 | rep | NY | 2017-01-03 | 2019-01-03 | Democrat | 14 | https://crowley.house.gov | 1035 Longworth House Office Building; Washington DC 20515-3214 | 202-225-3965 | 202-225-1909 | 1035 Longworth House Office Building | http://crowley.house.gov/rss.xml | |||||||
40767 | 40767 | John Culberson C001048 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 7 | https://culberson.house.gov | 2161 Rayburn House Office Building; Washington DC 20515-4307 | 202-225-2571 | 202-225-4381 | 2161 Rayburn House Office Building | http://culberson.house.gov/rss/ | |||||||
40771 | 40771 | Jeff Denham D000612 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 10 | https://denham.house.gov | 1730 Longworth House Office Building; Washington DC 20515-0510 | 202-225-4540 | 202-225-3402 | 1730 Longworth House Office Building | http://denham.house.gov/rss.xml | |||||||
40791 | 40791 | John Duncan D000533 | rep | TN | 2017-01-03 | 2019-01-03 | Republican | 2 | https://duncan.house.gov | 2207 Rayburn House Office Building; Washington DC 20515-4202 | 202-225-5435 | 202-225-6440 | 2207 Rayburn House Office Building | http://duncan.house.gov/rss.xml | |||||||
40797 | 40797 | Keith Ellison E000288 | rep | MN | 2017-01-03 | 2019-01-03 | Democrat | 5 | https://ellison.house.gov | 2263 Rayburn House Office Building; Washington DC 20515-2305 | 202-225-4755 | 202-225-4886 | 2263 Rayburn House Office Building | http://ellison.house.gov/index.php?format=feed&type=rss | |||||||
40816 | 40816 | Rodney Frelinghuysen F000372 | rep | NJ | 2017-01-03 | 2019-01-03 | Republican | 11 | https://frelinghuysen.house.gov | 2306 Rayburn House Office Building; Washington DC 20515-3011 | 202-225-5034 | 202-225-3186 | 2306 Rayburn House Office Building | http://frelinghuysen.house.gov/common/rss/?rss=3 | |||||||
40829 | 40829 | Bob Goodlatte G000289 | rep | VA | 2017-01-03 | 2019-01-03 | Republican | 6 | https://goodlatte.house.gov | 2309 Rayburn House Office Building; Washington DC 20515-4606 | 202-225-5431 | 202-225-9681 | 2309 Rayburn House Office Building | http://goodlatte.house.gov/press_releases.rss | |||||||
40833 | 40833 | Trey Gowdy G000566 | rep | SC | 2017-01-03 | 2019-01-03 | Republican | 4 | https://gowdy.house.gov | 2418 Rayburn House Office Building; Washington DC 20515-4004 | 202-225-6030 | 202-226-1177 | 2418 Rayburn House Office Building | http://gowdy.house.gov/news/rss.aspx | |||||||
40846 | 40846 | Gene Green G000410 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 29 | https://green.house.gov | 2470 Rayburn House Office Building; Washington DC 20515-4329 | 202-225-1688 | 202-225-9903 | 2470 Rayburn House Office Building | http://green.house.gov/rss.xml | |||||||
40859 | 40859 | Luis Gutiérrez G000535 | rep | IL | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://gutierrez.house.gov | 2408 Rayburn House Office Building; Washington DC 20515-1304 | 202-225-8203 | 202-225-7810 | 2408 Rayburn House Office Building | http://gutierrez.house.gov/rss.xml | |||||||
40864 | 40864 | Gregg Harper H001045 | rep | MS | 2017-01-03 | 2019-01-03 | Republican | 3 | https://harper.house.gov | 2227 Rayburn House Office Building; Washington DC 20515-2403 | 202-225-5031 | 202-225-5797 | 2227 Rayburn House Office Building | http://harper.house.gov/rss.xml | |||||||
40872 | 40872 | Jeb Hensarling H001036 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 5 | https://hensarling.house.gov | 2228 Rayburn House Office Building; Washington DC 20515-4305 | 202-225-3484 | 202-226-4888 | 2228 Rayburn House Office Building | http://hensarling.house.gov/atom.xml | |||||||
40876 | 40876 | Randy Hultgren H001059 | rep | IL | 2017-01-03 | 2019-01-03 | Republican | 14 | https://hultgren.house.gov | 2455 Rayburn House Office Building; Washington DC 20515-1314 | 202-225-2976 | 202-225-0697 | 2455 Rayburn House Office Building | http://hultgren.house.gov/common/rss//index.cfm?rss=49 | |||||||
40881 | 40881 | Lynn Jenkins J000290 | rep | KS | 2017-01-03 | 2019-01-03 | Republican | 2 | https://lynnjenkins.house.gov | 1526 Longworth House Office Building; Washington DC 20515-1602 | 202-225-6601 | 202-225-7986 | 1526 Longworth House Office Building | http://lynnjenkins.house.gov/common/rss/?rss=220 | |||||||
40895 | 40895 | Sam Johnson J000174 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 3 | https://samjohnson.house.gov | 2304 Rayburn House Office Building; Washington DC 20515-4303 | 202-225-4201 | 202-225-1485 | 2304 Rayburn House Office Building | http://samjohnson.house.gov/news/rss.aspx | |||||||
40899 | 40899 | Raúl Labrador L000573 | rep | ID | 2017-01-03 | 2019-01-03 | Republican | 1 | https://labrador.house.gov | 1523 Longworth House Office Building; Washington DC 20515-1201 | 202-225-6611 | 202-225-3029 | 1523 Longworth House Office Building | http://labrador.house.gov/common/rss//index.cfm?rss=49 | |||||||
40904 | 40904 | Leonard Lance L000567 | rep | NJ | 2017-01-03 | 2019-01-03 | Republican | 7 | https://lance.house.gov | 2352 Rayburn House Office Building; Washington DC 20515-3007 | 202-225-5361 | 202-225-9460 | 2352 Rayburn House Office Building | http://lance.house.gov/rss-button/rss-button/ | |||||||
40922 | 40922 | Sander Levin L000263 | rep | MI | 2017-01-03 | 2019-01-03 | Democrat | 9 | https://levin.house.gov | 1236 Longworth House Office Building; Washington DC 20515-2209 | 202-225-4961 | 202-226-1033 | 1236 Longworth House Office Building | http://levin.house.gov/rss.xml | |||||||
40934 | 40934 | Frank LoBiondo L000554 | rep | NJ | 2017-01-03 | 2019-01-03 | Republican | 2 | https://lobiondo.house.gov | 2427 Rayburn House Office Building; Washington DC 20515-3002 | 202-225-6572 | 202-225-3318 | 2427 Rayburn House Office Building | http://lobiondo.house.gov/rss.xml | |||||||
40938 | 40938 | Kristi Noem N000184 | rep | SD | 2017-01-03 | 2019-01-03 | Republican | 0 | https://noem.house.gov | 2457 Rayburn House Office Building; Washington DC 20515-4100 | 202-225-2801 | 202-225-5823 | 2457 Rayburn House Office Building | http://noem.house.gov/index.cfm/rss/feed | |||||||
40943 | 40943 | Erik Paulsen P000594 | rep | MN | 2017-01-03 | 2019-01-03 | Republican | 3 | https://paulsen.house.gov | 127 Cannon House Office Building; Washington DC 20515-2303 | 202-225-2871 | 202-225-6351 | 127 Cannon House Office Building | http://paulsen.house.gov/common/rss//?rss=105 | |||||||
40950 | 40950 | Stevan Pearce P000588 | rep | NM | 2017-01-03 | 2019-01-03 | Republican | 2 | https://pearce.house.gov | 2432 Rayburn House Office Building; Washington DC 20515-3102 | 202-225-2365 | 2432 Rayburn House Office Building | http://pearce.house.gov/rss.xml | ||||||||
40957 | 40957 | Ted Poe P000592 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 2 | https://poe.house.gov | 2132 Rayburn House Office Building; Washington DC 20515-4302 | 202-225-6565 | 202-225-5547 | 2132 Rayburn House Office Building | http://poe.house.gov/index.php?format=feed&type=rss | |||||||
40962 | 40962 | Jared Polis P000598 | rep | CO | 2017-01-03 | 2019-01-03 | Democrat | 2 | https://polis.house.gov | 1727 Longworth House Office Building; Washington DC 20515-0602 | 202-225-2161 | 202-226-7840 | 1727 Longworth House Office Building | http://polis.house.gov/news/rss.aspx | |||||||
40969 | 40969 | David Reichert R000578 | rep | WA | 2017-01-03 | 2019-01-03 | Republican | 8 | https://reichert.house.gov | 1127 Longworth House Office Building; Washington DC 20515-4708 | 202-225-7761 | 202-225-4282 | 1127 Longworth House Office Building | http://reichert.house.gov/rss.xml | |||||||
40973 | 40973 | James Renacci R000586 | rep | OH | 2017-01-03 | 2019-01-03 | Republican | 16 | https://renacci.house.gov | 328 Cannon House Office Building; Washington DC 20515-3516 | 202-225-3876 | 202-225-3059 | 328 Cannon House Office Building | http://renacci.house.gov/common/rss//index.cfm?rss=25 | |||||||
40988 | 40988 | Dana Rohrabacher R000409 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 48 | https://rohrabacher.house.gov | 2300 Rayburn House Office Building; Washington DC 20515-0548 | 202-225-2415 | 202-225-0145 | 2300 Rayburn House Office Building | http://rohrabacher.house.gov/rss.xml | |||||||
40992 | 40992 | Todd Rokita R000592 | rep | IN | 2017-01-03 | 2019-01-03 | Republican | 4 | http://rokita.house.gov | 2439 Rayburn House Office Building; Washington DC 20515-1404 | 202-225-5037 | 202-226-0544 | 2439 Rayburn House Office Building | http://rokita.house.gov/rss.xml | |||||||
40997 | 40997 | Thomas Rooney R000583 | rep | FL | 2017-01-03 | 2019-01-03 | Republican | 17 | https://rooney.house.gov | 2160 Rayburn House Office Building; Washington DC 20515-0917 | 202-225-5792 | 202-225-3132 | 2160 Rayburn House Office Building | http://rooney.house.gov/index.php?format=feed&type=rss | |||||||
41012 | 41012 | Ileana Ros-Lehtinen R000435 | rep | FL | 2017-01-03 | 2019-01-03 | Republican | 27 | https://ros-lehtinen.house.gov | 2206 Rayburn House Office Building; Washington DC 20515-0927 | 202-225-3931 | 202-225-5620 | 2206 Rayburn House Office Building | http://ros-lehtinen.house.gov/rss.xml | |||||||
41018 | 41018 | Peter Roskam R000580 | rep | IL | 2017-01-03 | 2019-01-03 | Republican | 6 | https://roskam.house.gov | 2246 Rayburn House Office Building; Washington DC 20515-1306 | 202-225-4561 | 202-225-1166 | 2246 Rayburn House Office Building | http://roskam.house.gov/index.php?format=feed&type=rss | |||||||
41022 | 41022 | Dennis Ross R000593 | rep | FL | 2017-01-03 | 2019-01-03 | Republican | 15 | https://dennisross.house.gov | 436 Cannon House Office Building; Washington DC 20515-0915 | 202-225-1252 | 202-226-0585 | 436 Cannon House Office Building | http://dennisross.house.gov/news/rss.aspx | |||||||
41035 | 41035 | Edward Royce R000487 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 39 | https://royce.house.gov | 2310 Rayburn House Office Building; Washington DC 20515-0539 | 202-225-4111 | 202-226-0335 | 2310 Rayburn House Office Building | http://royce.house.gov/news/rss.aspx | |||||||
41045 | 41045 | Paul Ryan R000570 | rep | WI | 2017-01-03 | 2019-01-03 | Republican | 1 | https://paulryan.house.gov | 1233 Longworth House Office Building; Washington DC 20515-4901 | 202-225-3031 | 202-225-3393 | 1233 Longworth House Office Building | http://paulryan.house.gov/news/rss.aspx | |||||||
41054 | 41054 | Bill Shuster S001154 | rep | PA | 2017-01-03 | 2019-01-03 | Republican | 9 | https://shuster.house.gov | 2079 Rayburn House Office Building; Washington DC 20515-3809 | 202-225-2431 | 202-225-2486 | 2079 Rayburn House Office Building | http://shuster.house.gov/common/rss//index.cfm?rss=49 | |||||||
41070 | 41070 | Lamar Smith S000583 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 21 | https://lamarsmith.house.gov | 2409 Rayburn House Office Building; Washington DC 20515-4321 | 202-225-4236 | 202-225-8628 | 2409 Rayburn House Office Building | http://lamarsmith.house.gov/news/rss.aspx | |||||||
41076 | 41076 | Niki Tsongas T000465 | rep | MA | 2017-01-03 | 2019-01-03 | Democrat | 3 | https://tsongas.house.gov | 1714 Longworth House Office Building; Washington DC 20515-2103 | 202-225-3411 | 202-226-0771 | 1714 Longworth House Office Building | http://tsongas.house.gov/rss/press-releases.xml | |||||||
41082 | 41082 | Timothy Walz W000799 | rep | MN | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://walz.house.gov | 2313 Rayburn House Office Building; Washington DC 20515-2301 | 202-225-2472 | 202-225-3433 | 2313 Rayburn House Office Building | http://walz.house.gov/index.php?format=feed&type=rss | |||||||
41086 | 41086 | Kevin Yoder Y000063 | rep | KS | 2017-01-03 | 2019-01-03 | Republican | 3 | https://yoder.house.gov | 2433 Rayburn House Office Building; Washington DC 20515-1603 | 202-225-2865 | 202-225-2807 | 2433 Rayburn House Office Building | http://yoder.house.gov/common/rss/index.cfm?rss=49 | |||||||
41094 | 41094 | Elizabeth Esty E000293 | rep | CT | 2017-01-03 | 2019-01-03 | Democrat | 5 | https://esty.house.gov | 221 Cannon House Office Building; Washington DC 20515-0705 | 202-225-4476 | 202-225-5933 | 221 Cannon House Office Building | http://esty.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 | |||||||
41100 | 41100 | John Delaney D000620 | rep | MD | 2017-01-03 | 2019-01-03 | Democrat | 6 | https://delaney.house.gov | 1632 Longworth House Office Building; Washington DC 20515-2006 | 202-225-2721 | 202-225-2193 | 1632 Longworth House Office Building | http://delaney.house.gov/rss.xml | |||||||
41106 | 41106 | Richard Nolan N000127 | rep | MN | 2017-01-03 | 2019-01-03 | Democrat | 8 | https://nolan.house.gov | 2366 Rayburn House Office Building; Washington DC 20515-2308 | 202-225-6211 | 202-225-0699 | 2366 Rayburn House Office Building | http://nolan.house.gov/rss.xml | |||||||
41109 | 41109 | Robert Pittenger P000606 | rep | NC | 2017-01-03 | 2019-01-03 | Republican | 9 | https://pittenger.house.gov | 224 Cannon House Office Building; Washington DC 20515-3309 | 202-225-1976 | 202-225-3389 | 224 Cannon House Office Building | http://pittenger.house.gov/rss.xml | |||||||
41113 | 41113 | Keith Rothfus R000598 | rep | PA | 2017-01-03 | 2019-01-03 | Republican | 12 | https://rothfus.house.gov | 1205 Longworth House Office Building; Washington DC 20515-3812 | 202-225-2065 | 202-225-5709 | 1205 Longworth House Office Building | http://rothfus.house.gov/rss.xml | |||||||
41116 | 41116 | Beto O’Rourke O000170 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 16 | https://orourke.house.gov | 1330 Longworth House Office Building; Washington DC 20515-4316 | 202-225-4831 | 1330 Longworth House Office Building | http://orourke.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 | |||||||
41125 | 41125 | David Brat B001290 | rep | VA | 2017-01-03 | 2019-01-03 | Republican | 7 | https://brat.house.gov | 1628 Longworth House Office Building; Washington DC 20515-4607 | 202-225-2815 | 1628 Longworth House Office Building | |||||||||
41127 | 41127 | Steve Knight K000387 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 25 | https://knight.house.gov | 1023 Longworth House Office Building; Washington DC 20515-0525 | 202-225-1956 | 202-226-0683 | 1023 Longworth House Office Building | ||||||||
41129 | 41129 | Mimi Walters W000820 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 45 | https://walters.house.gov | 215 Cannon House Office Building; Washington DC 20515-0545 | 202-225-5611 | 202-225-9177 | 215 Cannon House Office Building | ||||||||
41131 | 41131 | Carlos Curbelo C001107 | rep | FL | 2017-01-03 | 2019-01-03 | Republican | 26 | https://curbelo.house.gov | 1404 Longworth House Office Building; Washington DC 20515-0926 | 202-225-2778 | 1404 Longworth House Office Building | |||||||||
41133 | 41133 | Rod Blum B001294 | rep | IA | 2017-01-03 | 2019-01-03 | Republican | 1 | https://blum.house.gov | 1108 Longworth House Office Building; Washington DC 20515-1501 | 202-225-2911 | 1108 Longworth House Office Building | |||||||||
41135 | 41135 | David Young Y000066 | rep | IA | 2017-01-03 | 2019-01-03 | Republican | 3 | https://davidyoung.house.gov | 240 Cannon House Office Building; Washington DC 20515-1503 | 202-225-5476 | 240 Cannon House Office Building | |||||||||
41137 | 41137 | Bruce Poliquin P000611 | rep | ME | 2017-01-03 | 2019-01-03 | Republican | 2 | https://poliquin.house.gov | 1208 Longworth House Office Building; Washington DC 20515-1902 | 202-225-6306 | 202-225-2943 | 1208 Longworth House Office Building | ||||||||
41139 | 41139 | Mike Bishop B001293 | rep | MI | 2017-01-03 | 2019-01-03 | Republican | 8 | https://mikebishop.house.gov | 428 Cannon House Office Building; Washington DC 20515-2208 | 202-225-4872 | 202-225-5820 | 428 Cannon House Office Building | ||||||||
41141 | 41141 | Dave Trott T000475 | rep | MI | 2017-01-03 | 2019-01-03 | Republican | 11 | https://trott.house.gov | 1722 Longworth House Office Building; Washington DC 20515-2211 | 202-225-8171 | 1722 Longworth 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 | ||||||||
41145 | 41145 | Steve Russell R000604 | rep | OK | 2017-01-03 | 2019-01-03 | Republican | 5 | https://russell.house.gov | 128 Cannon House Office Building; Washington DC 20515-3605 | 202-225-2132 | 202-226-1463 | 128 Cannon House Office Building | ||||||||
41147 | 41147 | Ryan Costello C001106 | rep | PA | 2017-01-03 | 2019-01-03 | Republican | 6 | https://costello.house.gov | 326 Cannon House Office Building; Washington DC 20515-3806 | 202-225-4315 | 202-225-8440 | 326 Cannon House Office Building | ||||||||
41149 | 41149 | Mia Love L000584 | rep | UT | 2017-01-03 | 2019-01-03 | Republican | 4 | https://love.house.gov | 217 Cannon House Office Building; Washington DC 20515-4404 | 202-225-3011 | 202-225-5638 | 217 Cannon House Office Building | ||||||||
41151 | 41151 | Barbara Comstock C001105 | rep | VA | 2017-01-03 | 2019-01-03 | Republican | 10 | https://comstock.house.gov | 229 Cannon House Office Building; Washington DC 20515-4610 | 202-225-5136 | 202-225-0437 | 229 Cannon House Office Building | ||||||||
41153 | 41153 | Daniel Donovan D000625 | rep | NY | 2017-01-03 | 2019-01-03 | Republican | 11 | https://donovan.house.gov | 1541 Longworth House Office Building; Washington DC 20515-3211 | 202-225-3371 | 1541 Longworth House Office Building | |||||||||
41157 | 41157 | Colleen Hanabusa H001050 | rep | HI | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://hanabusa.house.gov | 422 Cannon House Office Building; Washington DC 20515-1101 | 202-225-2726 | 202-225-0688 | 422 Cannon House Office Building | https://hanabusa.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 | |||||||
41162 | 41162 | Jason Lewis L000587 | rep | MN | 2017-01-03 | 2019-01-03 | Republican | 2 | https://jasonlewis.house.gov | 418 Cannon House Office Building; Washington DC 20515-2302 | 202-225-2271 | 418 Cannon House Office Building | |||||||||
41163 | 41163 | Ruben Kihuen K000390 | rep | NV | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://kihuen.house.gov | 313 Cannon House Office Building; Washington DC 20515-2804 | 202-225-9894 | 313 Cannon House Office Building | |||||||||
41164 | 41164 | John Faso F000464 | rep | NY | 2017-01-03 | 2019-01-03 | Republican | 19 | https://faso.house.gov | 1616 Longworth House Office Building; Washington DC 20515-3219 | 202-225-5614 | 202-225-1168 | 1616 Longworth House Office Building | ||||||||
41165 | 41165 | Scott Taylor T000477 | rep | VA | 2017-01-03 | 2019-01-03 | Republican | 2 | https://taylor.house.gov | 412 Cannon House Office Building; Washington DC 20515-4602 | 202-225-4215 | 412 Cannon House Office Building | |||||||||
41166 | 41166 | Thomas Garrett G000580 | rep | VA | 2017-01-03 | 2019-01-03 | Republican | 5 | https://tomgarrett.house.gov | 415 Cannon House Office Building; Washington DC 20515-4605 | 202-225-4711 | 415 Cannon House Office Building | |||||||||
41172 | 41172 | Tom Marino M001179 | rep | PA | 2017-01-03 | 2019-01-03 | Republican | 10 | https://marino.house.gov | 2242 Rayburn House Office Building; Washington DC 20515-3810 | 202-225-3731 | 202-225-9594 | 2242 Rayburn House Office Building | http://marino.house.gov/rss.xml | |||||||
41185 | 41185 | Walter Jones J000255 | rep | NC | 2017-01-03 | 2019-01-03 | Republican | 3 | https://jones.house.gov | 2333 Rayburn House Office Building; Washington DC 20515-3303 | 202-225-3415 | 202-225-3286 | 2333 Rayburn House Office Building | http://jones.house.gov/rss.xml | |||||||
41190 | 41190 | Sean Duffy D000614 | rep | WI | 2017-01-03 | 2019-01-03 | Republican | 7 | https://duffy.house.gov | 2330 Rayburn House Office Building; Washington DC 20515-4907 | 202-225-3365 | 202-225-3240 | 2330 Rayburn House Office Building | http://duffy.house.gov/rss.xml | |||||||
41194 | 41194 | Chris Collins C001092 | rep | NY | 2017-01-03 | 2019-01-03 | Republican | 27 | https://chriscollins.house.gov | 1117 Longworth House Office Building; Washington DC 20515-3227 | 202-225-5265 | 202-225-5910 | 1117 Longworth House Office Building | http://chriscollins.house.gov/rss.xml | |||||||
41207 | 41207 | Elijah Cummings C000984 | rep | MD | 2017-01-03 | 2019-01-03 | Democrat | 7 | https://cummings.house.gov | 2163 Rayburn House Office Building; Washington DC 20515-2007 | 202-225-4741 | 202-225-3178 | 2163 Rayburn House Office Building | http://cummings.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);