legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
470 rows where "end" is on date 2019-01-03 sorted by party_affiliations
This data as json, copyable, CSV (advanced)
Suggested facets: start, district, fax, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40671 | 40671 | Bob Corker C001071 | sen | TN | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.corker.senate.gov | 425 Dirksen Senate Office Building Washington DC 20510 | 202-224-3344 | 202-228-0566 | https://www.corker.senate.gov/public/index.cfm/emailme | 425 Dirksen Senate Office Building | junior | http://www.corker.senate.gov/public/index.cfm/rss/feed | |||||
40678 | 40678 | Orrin Hatch H000338 | sen | UT | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.hatch.senate.gov | 104 Hart Senate Office Building Washington DC 20510 | 202-224-5251 | 202-224-6331 | http://www.hatch.senate.gov/public/index.cfm/contact?p=Email-Orrin | 104 Hart Senate Office Building | senior | http://www.hatch.senate.gov/public/index.cfm/rss/feed | |||||
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 | |||||
40689 | 40689 | Bill Nelson N000032 | sen | FL | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.billnelson.senate.gov | 716 Hart Senate Office Building Washington DC 20510 | 202-224-5274 | 202-228-2183 | https://www.billnelson.senate.gov/contact-bill | 716 Hart Senate Office Building | senior | ||||||
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 | |||||||
40775 | 40775 | Joe Donnelly D000607 | sen | IN | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.donnelly.senate.gov | 720 Hart Senate Office Building Washington DC 20510 | 202-224-4814 | 202-225-6798 | https://www.donnelly.senate.gov/contact/email-joe | 720 Hart Senate Office Building | senior | http://www.donnelly.senate.gov/rss/feeds/?type=all | |||||
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 | |||||||
40804 | 40804 | Jeff Flake F000444 | sen | AZ | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.flake.senate.gov/public | 413 Russell Senate Office Building Washington DC 20510 | 202-224-4521 | 202-226-4386 | https://www.flake.senate.gov/public/index.cfm/contact-jeff | 413 Russell Senate Office Building | senior | http://www.flake.senate.gov/public/index.cfm/rss/feed | |||||
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 | |||||||
41091 | 41091 | Dean Heller H001041 | sen | NV | 2013-01-03 | 2019-01-03 | 1 | Republican | https://www.heller.senate.gov/public | 324 Hart Senate Office Building Washington DC 20510 | 202-224-6244 | 202-228-6753 | http://www.heller.senate.gov/public/index.cfm/contact-form | 324 Hart Senate Office Building | senior | http://www.heller.senate.gov/public/index.cfm/rss/feed | |||||
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 | |||||||
41110 | 41110 | Heidi Heitkamp H001069 | sen | ND | 2013-01-03 | 2019-01-03 | 1 | Democrat | https://www.heitkamp.senate.gov/public | 516 Hart Senate Office Building Washington DC 20510 | 202-224-2043 | 202-224-7776 | http://www.heitkamp.senate.gov/public/index.cfm/contact | 516 Hart Senate Office Building | junior | http://www.heitkamp.senate.gov/public/index.cfm/rss/feed | |||||
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 | |||||||||
41167 | 41167 | Karen Handel H001078 | rep | GA | 2017-06-26 | 2019-01-03 | Republican | 6 | https://handel.house.gov | 1211 Longworth House Office Building; Washington DC 20515-1006 | 202-225-4501 | 1211 Longworth House Office Building | |||||||||
41168 | 41168 | Brenda Jones J000303 | rep | MI | 2018-11-29 | 2019-01-03 | Democrat | 13 | 2426 Rayburn House Office Building; Washington DC 20515-2213 | 202-225-5126 | 2426 Rayburn 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 | |||||||
41220 | 41220 | Duncan Hunter H001048 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 50 | https://hunter.house.gov | 2429 Rayburn House Office Building; Washington DC 20515-0550 | 202-225-5672 | 202-225-0235 | 2429 Rayburn House Office Building | http://hunter.house.gov/rss.xml | |||||||
41224 | 41224 | Mark Meadows M001187 | rep | NC | 2017-01-03 | 2019-01-03 | Republican | 11 | https://meadows.house.gov | 1024 Longworth House Office Building; Washington DC 20515-3311 | 202-225-6401 | 202-226-6422 | 1024 Longworth House Office Building | http://meadows.house.gov/rss/press-releases.xml | |||||||
41227 | 41227 | John Ratcliffe R000601 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 4 | https://ratcliffe.house.gov | 325 Cannon House Office Building; Washington DC 20515-4304 | 202-225-6673 | 202-225-3332 | 325 Cannon House Office Building | ||||||||
41244 | 41244 | John Lewis L000287 | rep | GA | 2017-01-03 | 2019-01-03 | Democrat | 5 | https://johnlewis.house.gov | 343 Cannon House Office Building; Washington DC 20515-1005 | 202-225-3801 | 202-225-0351 | 343 Cannon House Office Building | http://johnlewis.house.gov/rss.xml | |||||||
41250 | 41250 | Tom Graves G000560 | rep | GA | 2017-01-03 | 2019-01-03 | Republican | 14 | https://tomgraves.house.gov | 2078 Rayburn House Office Building; Washington DC 20515-1014 | 202-225-5211 | 202-225-8272 | 2078 Rayburn House Office Building | http://tomgraves.house.gov/news/rss.aspx | |||||||
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 | ||||||||
41257 | 41257 | Paul Cook C001094 | rep | CA | 2017-01-03 | 2019-01-03 | Republican | 8 | https://cook.house.gov | 1222 Longworth House Office Building; Washington DC 20515-0508 | 202-225-5861 | 202-225-6498 | 1222 Longworth House Office Building | http://cook.house.gov/rss.xml | |||||||
41288 | 41288 | Justin Amash A000367 | rep | MI | 2017-01-03 | 2019-01-03 | Republican | 3 | https://amash.house.gov | 114 Cannon House Office Building; Washington DC 20515-2203 | 202-225-3831 | 202-225-5144 | 114 Cannon House Office Building | http://amash.house.gov/rss.xml | |||||||
41297 | 41297 | Rob Bishop B001250 | rep | UT | 2017-01-03 | 2019-01-03 | Republican | 1 | https://robbishop.house.gov | 123 Cannon House Office Building; Washington DC 20515-4401 | 202-225-0453 | 202-225-5857 | 123 Cannon House Office Building | http://robbishop.house.gov/news/rss.aspx |
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);