legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
40,641 rows where type = "rep" sorted by rss_url descending
This data as json, copyable, CSV (advanced)
Suggested facets: start (date), end (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41156 | 41156 | Colleen Hanabusa H001050 | rep | HI | 2016-11-14 | 2017-01-03 | Democrat | 1 | https://hanabusa.house.gov/ | 422 Cannon HOB; Washington DC 20515-1101 | 202-225-2726 | 202-225-0688 | https://hanabusa.house.gov/contact/email | 422 Cannon House Office Building | https://hanabusa.house.gov/rss.xml | ||||||
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 | |||||||
44098 | 44098 | Dwight Evans E000296 | rep | PA | 2016-11-14 | 2017-01-03 | Democrat | 2 | https://evans.house.gov/ | 2301 Rayburn HOB; Washington DC 20515-3802 | 202-225-4001 | https://evans.house.gov/contact/email | 2301 Rayburn House Office Building | https://evans.house.gov/rss.xml | |||||||
44099 | 44099 | Dwight Evans E000296 | rep | PA | 2017-01-03 | 2019-01-03 | Democrat | 2 | https://evans.house.gov | 1105 Longworth House Office Building; Washington DC 20515-3802 | 202-225-4001 | 1105 Longworth House Office Building | https://evans.house.gov/rss.xml | ||||||||
44100 | 44100 | Dwight Evans E000296 | rep | PA | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://evans.house.gov | 1105 Longworth House Office Building Washington DC 20515-3803 | 202-225-4001 | 1105 Longworth House Office Building | https://evans.house.gov/rss.xml | ||||||||
44101 | 44101 | Dwight Evans E000296 | rep | PA | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://evans.house.gov | 1105 Longworth House Office Building Washington DC 20515-3803 | 202-225-4001 | 1105 Longworth House Office Building | https://evans.house.gov/rss.xml | ||||||||
44094 | 44094 | James Comer C001108 | rep | KY | 2016-11-14 | 2017-01-03 | Republican | 1 | https://comer.house.gov/ | 2184 Rayburn HOB; Washington DC 20515-1701 | 202-225-3115 | https://comer.house.gov/contact/email | 2184 Rayburn House Office Building | https://comer.house.gov/rss.xml | |||||||
44095 | 44095 | James Comer C001108 | rep | KY | 2017-01-03 | 2019-01-03 | Republican | 1 | https://comer.house.gov | 1513 Longworth House Office Building; Washington DC 20515-1701 | 202-225-3115 | 1513 Longworth House Office Building | https://comer.house.gov/rss.xml | ||||||||
44096 | 44096 | James Comer C001108 | rep | KY | 2019-01-03 | 2021-01-03 | Republican | 1 | https://comer.house.gov | 1037 Longworth House Office Building Washington DC 20515-1701 | 202-225-3115 | 1037 Longworth House Office Building | https://comer.house.gov/rss.xml | ||||||||
44097 | 44097 | James Comer C001108 | rep | KY | 2021-01-03 | 2023-01-03 | Republican | 1 | https://comer.house.gov | 2410 Rayburn House Office Building Washington DC 20515-1701 | 202-225-3115 | 2410 Rayburn House Office Building | https://comer.house.gov/rss.xml | ||||||||
39643 | 39643 | C. Young Y000031 | rep | FL | 2013-01-03 | 2013-10-18 | Republican | 13 | http://www.house.gov/young | 2407 Rayburn HOB; Washington DC 20515-0910 | 202-225-5961 | 202-225-9764 | http://www.house.gov/writerep | 2407 Rayburn House Office Building | http://young.house.gov/rss.xml | ||||||
41546 | 41546 | Ted Yoho Y000065 | rep | FL | 2013-01-03 | 2015-01-03 | Republican | 3 | http://yoho.house.gov | 511 Cannon HOB; Washington DC 20515-0903 | 202-225-5744 | https://yoho.house.gov/contact/email-me | 511 Cannon House Office Building | http://yoho.house.gov/rss.xml | |||||||
41547 | 41547 | Ted Yoho Y000065 | rep | FL | 2015-01-06 | 2017-01-03 | Republican | 3 | http://yoho.house.gov | 511 Cannon HOB; Washington DC 20515-0903 | 202-225-5744 | https://yoho.house.gov/contact/email-me | 511 Cannon House Office Building | http://yoho.house.gov/rss.xml | |||||||
41548 | 41548 | Ted Yoho Y000065 | rep | FL | 2017-01-03 | 2019-01-03 | Republican | 3 | https://yoho.house.gov | 511 Cannon House Office Building; Washington DC 20515-0903 | 202-225-5744 | 511 Cannon House Office Building | http://yoho.house.gov/rss.xml | ||||||||
41549 | 41549 | Ted Yoho Y000065 | rep | FL | 2019-01-03 | 2021-01-03 | Republican | 3 | https://yoho.house.gov | 1730 Longworth House Office Building Washington DC 20515-0903 | 202-225-5744 | 1730 Longworth House Office Building | http://yoho.house.gov/rss.xml | ||||||||
41084 | 41084 | Kevin Yoder Y000063 | rep | KS | 2013-01-03 | 2015-01-03 | Republican | 3 | http://yoder.house.gov | 215 Cannon HOB; Washington DC 20515-1603 | 202-225-2865 | 202-225-2807 | https://yoder.house.gov/contact/email-me | 215 Cannon House Office Building | http://yoder.house.gov/common/rss/index.cfm?rss=49 | ||||||
41085 | 41085 | Kevin Yoder Y000063 | rep | KS | 2015-01-06 | 2017-01-03 | Republican | 3 | http://yoder.house.gov | 215 Cannon HOB; Washington DC 20515-1603 | 202-225-2865 | 202-225-2807 | https://yoder.house.gov/contact/email-me | 215 Cannon House Office Building | http://yoder.house.gov/common/rss/index.cfm?rss=49 | ||||||
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 | |||||||
43619 | 43619 | Robert Wittman W000804 | rep | VA | 2013-01-03 | 2015-01-03 | Republican | 1 | http://www.wittman.house.gov | 2454 Rayburn HOB; Washington DC 20515-4601 | 202-225-4261 | 202-225-4382 | https://wittman.house.gov/contact-form/ | 2454 Rayburn House Office Building | http://www.wittman.house.gov/index.php?format=feed&type=rss | ||||||
43620 | 43620 | Robert Wittman W000804 | rep | VA | 2015-01-06 | 2017-01-03 | Republican | 1 | https://wittman.house.gov | 2454 Rayburn HOB; Washington DC 20515-4601 | 202-225-4261 | 202-225-4382 | https://wittman.house.gov/contact-form/ | 2454 Rayburn House Office Building | http://www.wittman.house.gov/index.php?format=feed&type=rss | ||||||
43621 | 43621 | Robert Wittman W000804 | rep | VA | 2017-01-03 | 2019-01-03 | Republican | 1 | https://wittman.house.gov | 2055 Rayburn House Office Building; Washington DC 20515-4601 | 202-225-4261 | 202-225-4382 | 2055 Rayburn House Office Building | http://www.wittman.house.gov/index.php?format=feed&type=rss | |||||||
43622 | 43622 | Robert Wittman W000804 | rep | VA | 2019-01-03 | 2021-01-03 | Republican | 1 | https://wittman.house.gov | 2055 Rayburn House Office Building Washington DC 20515-4601 | 202-225-4261 | 2055 Rayburn House Office Building | http://www.wittman.house.gov/index.php?format=feed&type=rss | ||||||||
43623 | 43623 | Robert Wittman W000804 | rep | VA | 2021-01-03 | 2023-01-03 | Republican | 1 | https://wittman.house.gov | 2055 Rayburn House Office Building Washington DC 20515-4601 | 202-225-4261 | 2055 Rayburn House Office Building | http://www.wittman.house.gov/index.php?format=feed&type=rss | ||||||||
43594 | 43594 | Peter Welch W000800 | rep | VT | 2013-01-03 | 2015-01-03 | Democrat | 0 | http://www.welch.house.gov | 2303 Rayburn HOB; Washington DC 20515-4500 | 202-225-4115 | 202-225-6790 | https://welch.house.gov/email-me | 2303 Rayburn House Office Building | http://www.welch.house.gov/index.php?format=feed&type=rss | ||||||
43595 | 43595 | Peter Welch W000800 | rep | VT | 2015-01-06 | 2017-01-03 | Democrat | 0 | http://welch.house.gov | 2303 Rayburn HOB; Washington DC 20515-4500 | 202-225-4115 | 202-225-6790 | https://welch.house.gov/email-me | 2303 Rayburn House Office Building | http://www.welch.house.gov/index.php?format=feed&type=rss | ||||||
43596 | 43596 | Peter Welch W000800 | rep | VT | 2017-01-03 | 2019-01-03 | Democrat | 0 | https://welch.house.gov | 2303 Rayburn House Office Building; Washington DC 20515-4500 | 202-225-4115 | 202-225-6790 | 2303 Rayburn House Office Building | http://www.welch.house.gov/index.php?format=feed&type=rss | |||||||
43597 | 43597 | Peter Welch W000800 | rep | VT | 2019-01-03 | 2021-01-03 | Democrat | 0 | https://welch.house.gov | 2187 Rayburn House Office Building Washington DC 20515-4500 | 202-225-4115 | 2187 Rayburn House Office Building | http://www.welch.house.gov/index.php?format=feed&type=rss | ||||||||
43598 | 43598 | Peter Welch W000800 | rep | VT | 2021-01-03 | 2023-01-03 | Democrat | 0 | https://welch.house.gov | 2187 Rayburn House Office Building Washington DC 20515-4500 | 202-225-4115 | 2187 Rayburn House Office Building | http://www.welch.house.gov/index.php?format=feed&type=rss | ||||||||
41378 | 41378 | Daniel Lipinski L000563 | rep | IL | 2013-01-03 | 2015-01-03 | Democrat | 3 | http://www.lipinski.house.gov | 1717 Longworth HOB; Washington DC 20515-1303 | 202-225-5701 | 202-225-1012 | https://lipinskiforms.house.gov/contact-form | 1717 Longworth House Office Building | http://www.lipinski.house.gov/common/rss//index.cfm?rss=25 | ||||||
41379 | 41379 | Daniel Lipinski L000563 | rep | IL | 2015-01-06 | 2017-01-03 | Democrat | 3 | http://lipinski.house.gov | 2346 Rayburn HOB; Washington DC 20515-1303 | 202-225-5701 | 202-225-1012 | https://lipinskiforms.house.gov/contact-form | 2346 Rayburn House Office Building | http://www.lipinski.house.gov/common/rss//index.cfm?rss=25 | ||||||
41380 | 41380 | Daniel Lipinski L000563 | rep | IL | 2017-01-03 | 2019-01-03 | Democrat | 3 | https://lipinski.house.gov | 2346 Rayburn House Office Building; Washington DC 20515-1303 | 202-225-5701 | 202-225-1012 | 2346 Rayburn House Office Building | http://www.lipinski.house.gov/common/rss//index.cfm?rss=25 | |||||||
41381 | 41381 | Daniel Lipinski L000563 | rep | IL | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://lipinski.house.gov | 2346 Rayburn House Office Building Washington DC 20515-1303 | 202-225-5701 | 2346 Rayburn House Office Building | http://www.lipinski.house.gov/common/rss//index.cfm?rss=25 | ||||||||
42704 | 42704 | John Larson L000557 | rep | CT | 2013-01-03 | 2015-01-03 | Democrat | 1 | http://www.larson.house.gov | 1501 Longworth HOB; Washington DC 20515-0701 | 202-225-2265 | 202-225-1031 | https://forms.house.gov/larson/contact_new.html | 1501 Longworth House Office Building | http://www.larson.house.gov/index.php?format=feed&type=rss | ||||||
42705 | 42705 | John Larson L000557 | rep | CT | 2015-01-06 | 2017-01-03 | Democrat | 1 | http://larson.house.gov | 1501 Longworth HOB; Washington DC 20515-0701 | 202-225-2265 | 202-225-1031 | https://forms.house.gov/larson/contact_new.html | 1501 Longworth House Office Building | http://www.larson.house.gov/index.php?format=feed&type=rss | ||||||
42706 | 42706 | John Larson L000557 | rep | CT | 2017-01-03 | 2019-01-03 | Democrat | 1 | https://larson.house.gov | 1501 Longworth House Office Building; Washington DC 20515-0701 | 202-225-2265 | 202-225-1031 | 1501 Longworth House Office Building | http://www.larson.house.gov/index.php?format=feed&type=rss | |||||||
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 | ||||||||
42708 | 42708 | John Larson L000557 | rep | CT | 2021-01-03 | 2023-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 | ||||||||
39911 | 39911 | Tom Latham L000111 | rep | IA | 2013-01-03 | 2015-01-03 | Republican | 3 | http://latham.house.gov | 2217 Rayburn HOB; Washington DC 20515-1503 | 202-225-5476 | 202-225-3301 | https://latham.house.gov/contact/contactform.htm | 2217 Rayburn House Office Building | http://www.house.gov/news/rss.aspx | ||||||
43398 | 43398 | Adam Smith S000510 | rep | WA | 2013-01-03 | 2015-01-03 | Democrat | 9 | http://adamsmith.house.gov | 2264 Rayburn HOB; Washington DC 20515-4709 | 202-225-8901 | 202-225-5893 | https://adamsmith.house.gov/contact/contactform.htm | 2264 Rayburn House Office Building | http://www.house.gov/news/rss.aspx | ||||||
43399 | 43399 | Adam Smith S000510 | rep | WA | 2015-01-06 | 2017-01-03 | Democrat | 9 | https://adamsmith.house.gov | 2264 Rayburn HOB; Washington DC 20515-4709 | 202-225-8901 | 202-225-5893 | https://adamsmith.house.gov/contact/contactform.htm | 2264 Rayburn House Office Building | http://www.house.gov/news/rss.aspx | ||||||
43400 | 43400 | Adam Smith S000510 | rep | WA | 2017-01-03 | 2019-01-03 | Democrat | 9 | https://adamsmith.house.gov | 2264 Rayburn House Office Building; Washington DC 20515-4709 | 202-225-8901 | 202-225-5893 | 2264 Rayburn House Office Building | http://www.house.gov/news/rss.aspx | |||||||
43401 | 43401 | Adam Smith S000510 | rep | WA | 2019-01-03 | 2021-01-03 | Democrat | 9 | https://adamsmith.house.gov | 2264 Rayburn House Office Building Washington DC 20515-4709 | 202-225-8901 | 2264 Rayburn House Office Building | http://www.house.gov/news/rss.aspx | ||||||||
43402 | 43402 | Adam Smith S000510 | rep | WA | 2021-01-03 | 2023-01-03 | Democrat | 9 | https://adamsmith.house.gov | 2264 Rayburn House Office Building Washington DC 20515-4709 | 202-225-8901 | 2264 Rayburn House Office Building | http://www.house.gov/news/rss.aspx | ||||||||
43525 | 43525 | Fred Upton U000031 | rep | MI | 2013-01-03 | 2015-01-03 | Republican | 6 | http://upton.house.gov | 2183 Rayburn HOB; Washington DC 20515-2206 | 202-225-3761 | 202-225-4986 | http://upton.house.gov/contact/zipauth.htm | 2183 Rayburn House Office Building | http://www.house.gov/news/rss.aspx | ||||||
43526 | 43526 | Fred Upton U000031 | rep | MI | 2015-01-06 | 2017-01-03 | Republican | 6 | http://upton.house.gov | 2183 Rayburn HOB; Washington DC 20515-2206 | 202-225-3761 | 202-225-4986 | http://upton.house.gov/contact/zipauth.htm | 2183 Rayburn House Office Building | http://www.house.gov/news/rss.aspx | ||||||
43527 | 43527 | Fred Upton U000031 | rep | MI | 2017-01-03 | 2019-01-03 | Republican | 6 | https://upton.house.gov | 2183 Rayburn House Office Building; Washington DC 20515-2206 | 202-225-3761 | 202-225-4986 | 2183 Rayburn House Office Building | http://www.house.gov/news/rss.aspx | |||||||
43528 | 43528 | Fred Upton U000031 | rep | MI | 2019-01-03 | 2021-01-03 | Republican | 6 | https://upton.house.gov | 2183 Rayburn House Office Building Washington DC 20515-2206 | 202-225-3761 | 2183 Rayburn House Office Building | http://www.house.gov/news/rss.aspx | ||||||||
43529 | 43529 | Fred Upton U000031 | rep | MI | 2021-01-03 | 2023-01-03 | Republican | 6 | https://upton.house.gov | 2183 Rayburn House Office Building Washington DC 20515-2206 | 202-225-3761 | 2183 Rayburn House Office Building | http://www.house.gov/news/rss.aspx | ||||||||
40008 | 40008 | Ed Pastor P000099 | rep | AZ | 2013-01-03 | 2015-01-03 | Democrat | 7 | http://www.pastor.house.gov | 2465 Rayburn HOB; Washington DC 20515-0307 | 202-225-4065 | 202-225-1655 | https://pastor.house.gov/email-me | 2465 Rayburn House Office Building | http://www.house.gov/index.php?format=feed&type=rss | ||||||
40359 | 40359 | Michael Honda H001034 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 17 | http://honda.house.gov | 1713 Longworth HOB; Washington DC 20515-0517 | 202-225-2631 | 202-225-2699 | http://honda.house.gov/contact | 1713 Longworth House Office Building | http://www.house.gov/index.php?format=feed&type=rss | ||||||
40360 | 40360 | Michael Honda H001034 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 17 | https://honda.house.gov | 1713 Longworth HOB; Washington DC 20515-0517 | 202-225-2631 | 202-225-2699 | http://honda.house.gov/contact | 1713 Longworth House Office Building | http://www.house.gov/index.php?format=feed&type=rss | ||||||
43331 | 43331 | Robert Scott S000185 | rep | VA | 2013-01-03 | 2015-01-03 | Democrat | 3 | http://www.bobbyscott.house.gov | 1201 Longworth HOB; Washington DC 20515-4603 | 202-225-8351 | 202-225-8354 | https://bobbyscott.house.gov/email-bobby-scott | 1201 Longworth House Office Building | http://www.house.gov/index.php?format=feed&type=rss | ||||||
43332 | 43332 | Robert Scott S000185 | rep | VA | 2015-01-06 | 2017-01-03 | Democrat | 3 | http://bobbyscott.house.gov | 1201 Longworth HOB; Washington DC 20515-4603 | 202-225-8351 | 202-225-8354 | https://bobbyscott.house.gov/contact/email-me | 1201 Longworth House Office Building | http://www.house.gov/index.php?format=feed&type=rss | ||||||
43333 | 43333 | Robert Scott S000185 | rep | VA | 2017-01-03 | 2019-01-03 | Democrat | 3 | https://bobbyscott.house.gov | 1201 Longworth House Office Building; Washington DC 20515-4603 | 202-225-8351 | 202-225-8354 | 1201 Longworth House Office Building | http://www.house.gov/index.php?format=feed&type=rss | |||||||
43334 | 43334 | Robert Scott S000185 | rep | VA | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://bobbyscott.house.gov | 1201 Longworth House Office Building Washington DC 20515-4603 | 202-225-8351 | 1201 Longworth House Office Building | http://www.house.gov/index.php?format=feed&type=rss | ||||||||
43335 | 43335 | Robert Scott S000185 | rep | VA | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://bobbyscott.house.gov | 2328 Rayburn House Office Building Washington DC 20515-4603 | 202-225-8351 | 2328 Rayburn House Office Building | http://www.house.gov/index.php?format=feed&type=rss | ||||||||
40253 | 40253 | Charles Boustany B001255 | rep | LA | 2013-01-03 | 2015-01-03 | Republican | 3 | http://boustany.house.gov | 1431 Longworth HOB; Washington DC 20515-1803 | 202-225-2031 | 202-225-5724 | https://boustanyforms.house.gov/contact-me/ | 1431 Longworth House Office Building | http://www.house.gov/common/rss/index.cfm?rss=82 | ||||||
40254 | 40254 | Charles Boustany B001255 | rep | LA | 2015-01-06 | 2017-01-03 | Republican | 3 | http://boustany.house.gov | 1431 Longworth HOB; Washington DC 20515-1803 | 202-225-2031 | 202-225-5724 | https://boustanyforms.house.gov/contact-me/ | 1431 Longworth House Office Building | http://www.house.gov/common/rss/index.cfm?rss=82 | ||||||
40291 | 40291 | Donna Edwards E000290 | rep | MD | 2013-01-03 | 2015-01-03 | Democrat | 4 | http://donnaedwards.house.gov | 2445 Rayburn HOB; Washington DC 20515-2004 | 202-225-8699 | 202-225-8714 | https://forms.house.gov/formdonnaedwards/issue_subscribe.shtml | 2445 Rayburn House Office Building | http://www.house.gov/common/rss/?rss=24 | ||||||
40292 | 40292 | Donna Edwards E000290 | rep | MD | 2015-01-06 | 2017-01-03 | Democrat | 4 | http://donnaedwards.house.gov | 2445 Rayburn HOB; Washington DC 20515-2004 | 202-225-8699 | 202-225-8714 | https://forms.house.gov/formdonnaedwards/issue_subscribe.shtml | 2445 Rayburn House Office Building | http://www.house.gov/common/rss/?rss=24 | ||||||
41401 | 41401 | Nita Lowey L000480 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 17 | http://lowey.house.gov | 2365 Rayburn HOB; Washington DC 20515-3217 | 202-225-6506 | 202-225-0546 | https://lowey.house.gov/contact-form/ | 2365 Rayburn House Office Building | http://www.house.gov/common/rss/?rss=18 | ||||||
41402 | 41402 | Nita Lowey L000480 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 17 | http://lowey.house.gov | 2365 Rayburn HOB; Washington DC 20515-3217 | 202-225-6506 | 202-225-0546 | https://lowey.house.gov/contact-form/ | 2365 Rayburn House Office Building | http://www.house.gov/common/rss/?rss=18 | ||||||
41403 | 41403 | Nita Lowey L000480 | rep | NY | 2017-01-03 | 2019-01-03 | Democrat | 17 | https://lowey.house.gov | 2365 Rayburn House Office Building; Washington DC 20515-3217 | 202-225-6506 | 202-225-0546 | 2365 Rayburn House Office Building | http://www.house.gov/common/rss/?rss=18 | |||||||
41404 | 41404 | Nita Lowey L000480 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 17 | https://lowey.house.gov | 2365 Rayburn House Office Building Washington DC 20515-3217 | 202-225-6506 | 2365 Rayburn House Office Building | http://www.house.gov/common/rss/?rss=18 | ||||||||
39927 | 39927 | Carolyn McCarthy M000309 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 4 | http://carolynmccarthy.house.gov | 2346 Rayburn HOB; Washington DC 20515-3204 | 202-225-5516 | 202-225-5758 | https://carolynmccarthy.house.gov/contact | 2346 Rayburn House Office Building | http://www.house.gov/common/rss/?rss=155 | ||||||
40176 | 40176 | Chaka Fattah F000043 | rep | PA | 2013-01-03 | 2015-01-03 | Democrat | 2 | http://fattah.house.gov | 2301 Rayburn HOB; Washington DC 20515-3802 | 202-225-4001 | 202-225-5392 | https://fattahforms.house.gov/contact-rep-fattah | 2301 Rayburn House Office Building | http://www.house.gov/common/rss//index.cfm?rss=34 | ||||||
40177 | 40177 | Chaka Fattah F000043 | rep | PA | 2015-01-06 | 2016-06-23 | Democrat | 2 | http://fattah.house.gov | 2301 Rayburn HOB; Washington DC 20515-3802 | 202-225-4001 | 202-225-5392 | https://fattahforms.house.gov/contact-rep-fattah | 2301 Rayburn House Office Building | http://www.house.gov/common/rss//index.cfm?rss=34 | ||||||
43065 | 43065 | Bill Pascrell P000096 | rep | NJ | 2013-01-03 | 2015-01-03 | Democrat | 9 | http://pascrell.house.gov | 2370 Rayburn HOB; Washington DC 20515-3009 | 202-225-5751 | 202-225-5782 | https://pascrell.house.gov/contact/email-me | 2370 Rayburn House Office Building | http://www.house.gov/apps/list/press/nj08_pascrell/rss.xml | ||||||
43066 | 43066 | Bill Pascrell P000096 | rep | NJ | 2015-01-06 | 2017-01-03 | Democrat | 9 | http://pascrell.house.gov | 2370 Rayburn HOB; Washington DC 20515-3009 | 202-225-5751 | 202-225-5782 | https://pascrell.house.gov/contact/email-me | 2370 Rayburn House Office Building | http://www.house.gov/apps/list/press/nj08_pascrell/rss.xml | ||||||
43067 | 43067 | Bill Pascrell P000096 | rep | NJ | 2017-01-03 | 2019-01-03 | Democrat | 9 | https://pascrell.house.gov | 2370 Rayburn House Office Building; Washington DC 20515-3009 | 202-225-5751 | 202-225-5782 | 2370 Rayburn House Office Building | http://www.house.gov/apps/list/press/nj08_pascrell/rss.xml | |||||||
43068 | 43068 | Bill Pascrell P000096 | rep | NJ | 2019-01-03 | 2021-01-03 | Democrat | 9 | https://pascrell.house.gov | 2409 Rayburn House Office Building Washington DC 20515-3009 | 202-225-5751 | 2409 Rayburn House Office Building | http://www.house.gov/apps/list/press/nj08_pascrell/rss.xml | ||||||||
43069 | 43069 | Bill Pascrell P000096 | rep | NJ | 2021-01-03 | 2023-01-03 | Democrat | 9 | https://pascrell.house.gov | 2409 Rayburn House Office Building Washington DC 20515-3009 | 202-225-5751 | 2409 Rayburn House Office Building | http://www.house.gov/apps/list/press/nj08_pascrell/rss.xml | ||||||||
40306 | 40306 | Sam Farr F000030 | rep | CA | 2013-01-03 | 2015-01-03 | Democrat | 20 | http://www.farr.house.gov | 1126 Longworth HOB; Washington DC 20515-0520 | 202-225-2861 | 202-225-6791 | https://forms.house.gov/farr/webforms/issue_subscribe.html | 1126 Longworth House Office Building | http://www.farr.house.gov/index.php?format=feed&type=rss | ||||||
40307 | 40307 | Sam Farr F000030 | rep | CA | 2015-01-06 | 2017-01-03 | Democrat | 20 | http://farr.house.gov | 1126 Longworth HOB; Washington DC 20515-0520 | 202-225-2861 | 202-225-6791 | https://forms.house.gov/farr/webforms/issue_subscribe.html | 1126 Longworth House Office Building | http://www.farr.house.gov/index.php?format=feed&type=rss | ||||||
42279 | 42279 | Peter DeFazio D000191 | rep | OR | 2013-01-03 | 2015-01-03 | Democrat | 4 | http://defazio.house.gov | 2134 Rayburn HOB; Washington DC 20515-3704 | 202-225-6416 | https://defazio.house.gov/contact/email-me | 2134 Rayburn House Office Building | http://www.defazio.house.gov/index.php?format=feed&type=rss | |||||||
42280 | 42280 | Peter DeFazio D000191 | rep | OR | 2015-01-06 | 2017-01-03 | Democrat | 4 | http://defazio.house.gov | 2134 Rayburn HOB; Washington DC 20515-3704 | 202-225-6416 | https://defazio.house.gov/contact/email-me | 2134 Rayburn House Office Building | http://www.defazio.house.gov/index.php?format=feed&type=rss | |||||||
42281 | 42281 | Peter DeFazio D000191 | rep | OR | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://defazio.house.gov | 2134 Rayburn House Office Building; Washington DC 20515-3704 | 202-225-6416 | 2134 Rayburn House Office Building | http://www.defazio.house.gov/index.php?format=feed&type=rss | ||||||||
42282 | 42282 | Peter DeFazio D000191 | rep | OR | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://defazio.house.gov | 2134 Rayburn House Office Building Washington DC 20515-3704 | 202-225-6416 | 2134 Rayburn House Office Building | http://www.defazio.house.gov/index.php?format=feed&type=rss | ||||||||
42283 | 42283 | Peter DeFazio D000191 | rep | OR | 2021-01-03 | 2023-01-03 | Democrat | 4 | https://defazio.house.gov | 2134 Rayburn House Office Building Washington DC 20515-3704 | 202-225-6416 | 2134 Rayburn House Office Building | http://www.defazio.house.gov/index.php?format=feed&type=rss | ||||||||
39784 | 39784 | John Campbell C001064 | rep | CA | 2013-01-03 | 2015-01-03 | Republican | 45 | http://www.campbell.house.gov | 2331 Rayburn HOB; Washington DC 20515-0545 | 202-225-5611 | 202-225-9177 | https://campbell.house.gov/email-me | 2331 Rayburn House Office Building | http://www.campbell.house.gov/rss/press1.xml | ||||||
41641 | 41641 | Alcee Hastings H000324 | rep | FL | 2013-01-03 | 2015-01-03 | Democrat | 20 | http://alceehastings.house.gov | 2353 Rayburn HOB; Washington DC 20515-0920 | 202-225-1313 | 202-225-1171 | https://alceehastings.house.gov/forms/writeyourrep/?zip5=33407&zip4=3224 | 2353 Rayburn House Office Building | http://www.alceehastings.house.gov/news/rss.aspx | ||||||
41642 | 41642 | Alcee Hastings H000324 | rep | FL | 2015-01-06 | 2017-01-03 | Democrat | 20 | http://alceehastings.house.gov | 2353 Rayburn HOB; Washington DC 20515-0920 | 202-225-1313 | 202-225-1171 | https://alceehastings.house.gov/forms/writeyourrep/?zip5=33407&zip4=3224 | 2353 Rayburn House Office Building | http://www.alceehastings.house.gov/news/rss.aspx | ||||||
41643 | 41643 | Alcee Hastings H000324 | rep | FL | 2017-01-03 | 2019-01-03 | Democrat | 20 | https://alceehastings.house.gov | 2353 Rayburn House Office Building; Washington DC 20515-0920 | 202-225-1313 | 202-225-1171 | 2353 Rayburn House Office Building | http://www.alceehastings.house.gov/news/rss.aspx | |||||||
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 | ||||||||
41645 | 41645 | Alcee Hastings H000324 | rep | FL | 2021-01-03 | 2021-04-06 | Democrat | 20 | https://alceehastings.house.gov | 2365 Rayburn House Office Building Washington DC 20515-0920 | 202-225-1313 | 2365 Rayburn House Office Building | http://www.alceehastings.house.gov/news/rss.aspx | ||||||||
41542 | 41542 | Rob Woodall W000810 | rep | GA | 2013-01-03 | 2015-01-03 | Republican | 7 | http://woodall.house.gov | 1725 Longworth HOB; Washington DC 20515-1007 | 202-225-4272 | 202-225-4696 | https://woodall.house.gov/contact-me/email-me | 1725 Longworth House Office Building | http://woodall.house.gov/rss.xml | ||||||
41543 | 41543 | Rob Woodall W000810 | rep | GA | 2015-01-06 | 2017-01-03 | Republican | 7 | http://woodall.house.gov | 1724 Longworth HOB; Washington DC 20515-1007 | 202-225-4272 | 202-225-4696 | https://woodall.house.gov/contact-me/email-me | 1724 Longworth House Office Building | http://woodall.house.gov/rss.xml | ||||||
41544 | 41544 | Rob Woodall W000810 | rep | GA | 2017-01-03 | 2019-01-03 | Republican | 7 | https://woodall.house.gov | 1724 Longworth House Office Building; Washington DC 20515-1007 | 202-225-4272 | 202-225-4696 | 1724 Longworth House Office Building | http://woodall.house.gov/rss.xml | |||||||
41545 | 41545 | Rob Woodall W000810 | rep | GA | 2019-01-03 | 2021-01-03 | Republican | 7 | https://woodall.house.gov | 1724 Longworth House Office Building Washington DC 20515-1007 | 202-225-4272 | 1724 Longworth House Office Building | http://woodall.house.gov/rss.xml | ||||||||
43625 | 43625 | Steve Womack W000809 | rep | AR | 2013-01-03 | 2015-01-03 | Republican | 3 | http://womack.house.gov | 1119 Longworth HOB; Washington DC 20515-0403 | 202-225-4301 | 202-225-5713 | https://womack.house.gov/contact/contactform.htm | 1119 Longworth House Office Building | http://womack.house.gov/news/rss.aspx | ||||||
43626 | 43626 | Steve Womack W000809 | rep | AR | 2015-01-06 | 2017-01-03 | Republican | 3 | http://womack.house.gov | 1119 Longworth HOB; Washington DC 20515-0403 | 202-225-4301 | 202-225-5713 | https://womack.house.gov/contact/contactform.htm | 1119 Longworth House Office Building | http://womack.house.gov/news/rss.aspx | ||||||
43627 | 43627 | Steve Womack W000809 | rep | AR | 2017-01-03 | 2019-01-03 | Republican | 3 | https://womack.house.gov | 2412 Rayburn House Office Building; Washington DC 20515-0403 | 202-225-4301 | 202-225-5713 | 2412 Rayburn House Office Building | http://womack.house.gov/news/rss.aspx | |||||||
43628 | 43628 | Steve Womack W000809 | rep | AR | 2019-01-03 | 2021-01-03 | Republican | 3 | https://womack.house.gov | 2412 Rayburn House Office Building Washington DC 20515-0403 | 202-225-4301 | 2412 Rayburn House Office Building | http://womack.house.gov/news/rss.aspx | ||||||||
43629 | 43629 | Steve Womack W000809 | rep | AR | 2021-01-03 | 2023-01-03 | Republican | 3 | https://womack.house.gov | 2412 Rayburn House Office Building Washington DC 20515-0403 | 202-225-4301 | 2412 Rayburn House Office Building | http://womack.house.gov/news/rss.aspx | ||||||||
40115 | 40115 | Frank Wolf W000672 | rep | VA | 2013-01-03 | 2015-01-03 | Republican | 10 | http://wolf.house.gov | 233 Cannon HOB; Washington DC 20515-4610 | 202-225-5136 | 202-225-0437 | https://wolf.house.gov/contact/email-me#.U06IH-ZdUrw | 233 Cannon House Office Building | http://wolf.house.gov/common/rss//index.cfm?rss=34 | ||||||
43611 | 43611 | Frederica Wilson W000808 | rep | FL | 2013-01-03 | 2015-01-03 | Democrat | 24 | http://wilson.house.gov | 208 Cannon HOB; Washington DC 20515-0924 | 202-225-4506 | 202-226-0777 | https://wilsonforms.house.gov/contact-form | 208 Cannon House Office Building | http://wilson.house.gov/common/rss//index.cfm?rss=49 | ||||||
43612 | 43612 | Frederica Wilson W000808 | rep | FL | 2015-01-06 | 2017-01-03 | Democrat | 24 | http://wilson.house.gov | 208 Cannon HOB; Washington DC 20515-0924 | 202-225-4506 | 202-226-0777 | https://wilsonforms.house.gov/contact-form | 208 Cannon House Office Building | http://wilson.house.gov/common/rss//index.cfm?rss=49 | ||||||
43613 | 43613 | Frederica Wilson W000808 | rep | FL | 2017-01-03 | 2019-01-03 | Democrat | 24 | https://wilson.house.gov | 2445 Rayburn House Office Building; Washington DC 20515-0924 | 202-225-4506 | 202-226-0777 | 2445 Rayburn House Office Building | http://wilson.house.gov/common/rss//index.cfm?rss=49 | |||||||
43614 | 43614 | Frederica Wilson W000808 | rep | FL | 2019-01-03 | 2021-01-03 | Democrat | 24 | https://wilson.house.gov | 2445 Rayburn House Office Building Washington DC 20515-0924 | 202-225-4506 | 2445 Rayburn House Office Building | http://wilson.house.gov/common/rss//index.cfm?rss=49 | ||||||||
43615 | 43615 | Frederica Wilson W000808 | rep | FL | 2021-01-03 | 2023-01-03 | Democrat | 24 | https://wilson.house.gov | 2445 Rayburn House Office Building Washington DC 20515-0924 | 202-225-4506 | 2445 Rayburn House Office Building | http://wilson.house.gov/common/rss//index.cfm?rss=49 |
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);