legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
44,551 rows sorted by phone descending
This data as json, copyable, CSV (advanced)
Suggested facets: class, state_rank, start (date)
end (date) >30 ✖
- 1919-03-03 506
- 1931-03-03 502
- 1921-03-03 499
- 1933-03-03 499
- 1923-03-03 498
- 1941-01-03 498
- 1915-03-03 494
- 1925-03-03 493
- 1945-01-03 493
- 1939-01-03 492
- 1929-03-03 489
- 1963-01-03 489
- 1943-01-03 488
- 1947-01-03 488
- 1935-01-03 486
- 1949-01-03 486
- 1953-01-03 486
- 1917-03-03 485
- 1937-01-03 485
- 1955-01-03 485
- 1927-03-04 484
- 1961-01-03 483
- 1971-01-03 483
- 1951-01-03 482
- 1965-01-03 482
- 1983-01-03 481
- 1959-01-03 480
- 1977-01-03 480
- 1967-01-03 479
- 1975-01-03 479
- …
how 2 ✖
- appointment 203
- special-election 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41698 | 41698 | Filemon Vela V000132 | rep | TX | 2013-01-03 | 2015-01-03 | Democrat | 34 | http://vela.house.gov | 437 Cannon HOB; Washington DC 20515-4334 | 202-225-9901 | 202-225-9770 | https://forms.house.gov/vela/webforms/email-me.shtml | 437 Cannon House Office Building | http://vela.house.gov/rss.xml | ||||||
41699 | 41699 | Filemon Vela V000132 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 34 | http://vela.house.gov | 437 Cannon HOB; Washington DC 20515-4334 | 202-225-9901 | 202-225-9770 | https://forms.house.gov/vela/webforms/email-me.shtml | 437 Cannon House Office Building | http://vela.house.gov/rss.xml | ||||||
41700 | 41700 | Filemon Vela V000132 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 34 | https://vela.house.gov | 437 Cannon House Office Building; Washington DC 20515-4334 | 202-225-9901 | 202-225-9770 | 437 Cannon House Office Building | http://vela.house.gov/rss.xml | |||||||
41701 | 41701 | Filemon Vela V000132 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 34 | https://vela.house.gov | 307 Cannon House Office Building Washington DC 20515-4334 | 202-225-9901 | 307 Cannon House Office Building | http://vela.house.gov/rss.xml | ||||||||
41702 | 41702 | Filemon Vela V000132 | rep | TX | 2021-01-03 | 2022-03-31 | Democrat | 34 | https://vela.house.gov | 307 Cannon House Office Building Washington DC 20515-4334 | 202-225-9901 | 307 Cannon House Office Building | http://vela.house.gov/rss.xml | ||||||||
44545 | 44545 | Mayra Flores F000473 | rep | TX | 2022-06-21 | 2023-01-03 | Republican | 34 | 307 Cannon House Office Building Washington DC 20515-4334 | 202-225-9901 | 307 Cannon House Office Building | ||||||||||
43886 | 43886 | Marc Veasey V000131 | rep | TX | 2013-01-03 | 2015-01-03 | Democrat | 33 | http://veasey.house.gov | 414 Cannon HOB; Washington DC 20515-4333 | 202-225-9897 | https://veaseyforms.house.gov/forms/writeyourrep/ | 414 Cannon House Office Building | http://veasey.house.gov/rss.xml | |||||||
43887 | 43887 | Marc Veasey V000131 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 33 | http://veasey.house.gov | 414 Cannon HOB; Washington DC 20515-4333 | 202-225-9897 | 202-225-9702 | https://veaseyforms.house.gov/forms/writeyourrep/ | 414 Cannon House Office Building | http://veasey.house.gov/rss.xml | ||||||
43888 | 43888 | Marc Veasey V000131 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 33 | https://veasey.house.gov | 1519 Longworth House Office Building; Washington DC 20515-4333 | 202-225-9897 | 202-225-9702 | 1519 Longworth House Office Building | http://veasey.house.gov/rss.xml | |||||||
43889 | 43889 | Marc Veasey V000131 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 33 | https://veasey.house.gov | 2348 Rayburn House Office Building Washington DC 20515-4333 | 202-225-9897 | 2348 Rayburn House Office Building | http://veasey.house.gov/rss.xml | ||||||||
43890 | 43890 | Marc Veasey V000131 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 33 | https://veasey.house.gov | 2348 Rayburn House Office Building Washington DC 20515-4333 | 202-225-9897 | 2348 Rayburn House Office Building | http://veasey.house.gov/rss.xml | ||||||||
43881 | 43881 | Roger Williams W000816 | rep | TX | 2013-01-03 | 2015-01-03 | Republican | 25 | http://williams.house.gov | 1122 Longworth HOB; Washington DC 20515-4325 | 202-225-9896 | 512-473-8946 | https://williams.house.gov/contact/email-me | 1122 Longworth House Office Building | http://williams.house.gov/rss.xml | ||||||
43882 | 43882 | Roger Williams W000816 | rep | TX | 2015-01-06 | 2017-01-03 | Republican | 25 | http://williams.house.gov | 1323 Longworth HOB; Washington DC 20515-4325 | 202-225-9896 | 512-473-8946 | https://williams.house.gov/contact/email-me | 1323 Longworth House Office Building | http://williams.house.gov/rss.xml | ||||||
43883 | 43883 | Roger Williams W000816 | rep | TX | 2017-01-03 | 2019-01-03 | Republican | 25 | https://williams.house.gov | 1323 Longworth House Office Building; Washington DC 20515-4325 | 202-225-9896 | 512-473-8946 | 1323 Longworth House Office Building | http://williams.house.gov/rss.xml | |||||||
43884 | 43884 | Roger Williams W000816 | rep | TX | 2019-01-03 | 2021-01-03 | Republican | 25 | https://williams.house.gov | 1708 Longworth House Office Building Washington DC 20515-4325 | 202-225-9896 | 1708 Longworth House Office Building | http://williams.house.gov/rss.xml | ||||||||
43885 | 43885 | Roger Williams W000816 | rep | TX | 2021-01-03 | 2023-01-03 | Republican | 25 | https://williams.house.gov | 1708 Longworth House Office Building Washington DC 20515-4325 | 202-225-9896 | 1708 Longworth House Office Building | http://williams.house.gov/rss.xml | ||||||||
43864 | 43864 | Tom Rice R000597 | rep | SC | 2013-01-03 | 2015-01-03 | Republican | 7 | http://rice.house.gov | 325 Cannon HOB; Washington DC 20515-4007 | 202-225-9895 | 202-225-9690 | https://tomriceforms.house.gov/forms/writeyourrep/ | 325 Cannon House Office Building | http://rice.house.gov/rss.xml | ||||||
43865 | 43865 | Tom Rice R000597 | rep | SC | 2015-01-06 | 2017-01-03 | Republican | 7 | http://rice.house.gov | 223 Cannon HOB; Washington DC 20515-4007 | 202-225-9895 | https://tomriceforms.house.gov/forms/writeyourrep/ | 223 Cannon House Office Building | http://rice.house.gov/rss.xml | |||||||
43866 | 43866 | Tom Rice R000597 | rep | SC | 2017-01-03 | 2019-01-03 | Republican | 7 | https://rice.house.gov | 223 Cannon House Office Building; Washington DC 20515-4007 | 202-225-9895 | 223 Cannon House Office Building | http://rice.house.gov/rss.xml | ||||||||
43867 | 43867 | Tom Rice R000597 | rep | SC | 2019-01-03 | 2021-01-03 | Republican | 7 | https://rice.house.gov | 512 Cannon House Office Building Washington DC 20515-4007 | 202-225-9895 | 512 Cannon House Office Building | http://rice.house.gov/rss.xml | ||||||||
43868 | 43868 | Tom Rice R000597 | rep | SC | 2021-01-03 | 2023-01-03 | Republican | 7 | https://rice.house.gov | 460 Cannon House Office Building Washington DC 20515-4007 | 202-225-9895 | 460 Cannon House Office Building | http://rice.house.gov/rss.xml | ||||||||
40507 | 40507 | Cresent Hardy H001070 | rep | NV | 2015-01-06 | 2017-01-03 | Republican | 4 | https://hardy.house.gov | 430 Cannon HOB; Washington DC 20515-2804 | 202-225-9894 | 202-225-9783 | 430 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 | |||||||||
44276 | 44276 | Steven Horsford H001066 | rep | NV | 2013-01-03 | 2015-01-03 | Democrat | 4 | http://horsford.house.gov | 1330 Longworth HOB; Washington DC 20515-2804 | 202-225-9894 | https://horsford.house.gov/contact/email-me | 1330 Longworth House Office Building | http://horsford.house.gov/rss.xml | |||||||
44277 | 44277 | Steven Horsford H001066 | rep | NV | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://horsford.house.gov | 1330 Longworth House Office Building Washington DC 20515-2804 | 202-225-9894 | 1330 Longworth House Office Building | http://horsford.house.gov/rss.xml | ||||||||
44278 | 44278 | Steven Horsford H001066 | rep | NV | 2021-01-03 | 2023-01-03 | Democrat | 4 | https://horsford.house.gov | 562 Cannon House Office Building Washington DC 20515-2804 | 202-225-9894 | 562 Cannon House Office Building | http://horsford.house.gov/rss.xml | ||||||||
41550 | 41550 | Doug Collins C001093 | rep | GA | 2013-01-03 | 2015-01-03 | Republican | 9 | http://dougcollins.house.gov | 513 Cannon HOB; Washington DC 20515-1009 | 202-225-9893 | 202-226-1224 | https://dougcollins.house.gov/email-me | 513 Cannon House Office Building | http://dougcollins.house.gov/latest-rss/latest-rss/ | ||||||
41551 | 41551 | Doug Collins C001093 | rep | GA | 2015-01-06 | 2017-01-03 | Republican | 9 | http://dougcollins.house.gov | 1504 Longworth HOB; Washington DC 20515-1009 | 202-225-9893 | 202-226-1224 | https://dougcollins.house.gov/email-me | 1504 Longworth House Office Building | http://dougcollins.house.gov/latest-rss/latest-rss/ | ||||||
41552 | 41552 | Doug Collins C001093 | rep | GA | 2017-01-03 | 2019-01-03 | Republican | 9 | https://dougcollins.house.gov | 1504 Longworth House Office Building; Washington DC 20515-1009 | 202-225-9893 | 202-226-1224 | 1504 Longworth House Office Building | http://dougcollins.house.gov/latest-rss/latest-rss/ | |||||||
41553 | 41553 | Doug Collins C001093 | rep | GA | 2019-01-03 | 2021-01-03 | Republican | 9 | https://dougcollins.house.gov | 1504 Longworth House Office Building Washington DC 20515-1009 | 202-225-9893 | 1504 Longworth House Office Building | http://dougcollins.house.gov/latest-rss/latest-rss/ | ||||||||
44488 | 44488 | Andrew Clyde C001116 | rep | GA | 2021-01-03 | 2023-01-03 | Republican | 9 | https://clyde.house.gov | 521 Cannon House Office Building Washington DC 20515-1009 | 202-225-9893 | 521 Cannon House Office Building | |||||||||
43763 | 43763 | Lois Frankel F000462 | rep | FL | 2013-01-03 | 2015-01-03 | Democrat | 22 | http://frankel.house.gov | 1037 Longworth HOB; Washington DC 20515-0922 | 202-225-9890 | 561-998-9048 | https://frankel.house.gov/contact/email-me | 1037 Longworth House Office Building | http://frankel.house.gov/rss.xml | ||||||
43764 | 43764 | Lois Frankel F000462 | rep | FL | 2015-01-06 | 2017-01-03 | Democrat | 22 | http://frankel.house.gov | 1037 Longworth HOB; Washington DC 20515-0922 | 202-225-9890 | 561-998-9048 | https://frankel.house.gov/contact/email-me | 1037 Longworth House Office Building | http://frankel.house.gov/rss.xml | ||||||
43765 | 43765 | Lois Frankel F000462 | rep | FL | 2017-01-03 | 2019-01-03 | Democrat | 21 | https://frankel.house.gov | 1037 Longworth House Office Building; Washington DC 20515-0921 | 202-225-9890 | 561-998-9048 | 1037 Longworth House Office Building | http://frankel.house.gov/rss.xml | |||||||
43766 | 43766 | Lois Frankel F000462 | rep | FL | 2019-01-03 | 2021-01-03 | Democrat | 21 | https://frankel.house.gov | 2305 Rayburn House Office Building Washington DC 20515-0921 | 202-225-9890 | 2305 Rayburn House Office Building | http://frankel.house.gov/rss.xml | ||||||||
43767 | 43767 | Lois Frankel F000462 | rep | FL | 2021-01-03 | 2023-01-03 | Democrat | 21 | https://frankel.house.gov | 2305 Rayburn House Office Building Washington DC 20515-0921 | 202-225-9890 | 2305 Rayburn House Office Building | http://frankel.house.gov/rss.xml | ||||||||
40493 | 40493 | Alan Grayson G000556 | rep | FL | 2013-01-03 | 2015-01-03 | Democrat | 9 | http://grayson.house.gov | 430 Cannon HOB; Washington DC 20515-0909 | 202-225-9889 | 202-225-9742 | https://grayson.house.gov/contact/email-me | 430 Cannon House Office Building | http://grayson.house.gov/rss.xml | ||||||
40494 | 40494 | Alan Grayson G000556 | rep | FL | 2015-01-06 | 2017-01-03 | Democrat | 9 | http://grayson.house.gov | 303 Cannon HOB; Washington DC 20515-0909 | 202-225-9889 | 202-225-9742 | https://grayson.house.gov/contact/email-me | 303 Cannon House Office Building | http://grayson.house.gov/rss.xml | ||||||
44148 | 44148 | Darren Soto S001200 | rep | FL | 2017-01-03 | 2019-01-03 | Democrat | 9 | https://soto.house.gov | 1429 Longworth House Office Building; Washington DC 20515-0909 | 202-225-9889 | 1429 Longworth House Office Building | |||||||||
44149 | 44149 | Darren Soto S001200 | rep | FL | 2019-01-03 | 2021-01-03 | Democrat | 9 | https://soto.house.gov | 1507 Longworth House Office Building Washington DC 20515-0909 | 202-225-9889 | 1507 Longworth House Office Building | |||||||||
44150 | 44150 | Darren Soto S001200 | rep | FL | 2021-01-03 | 2023-01-03 | Democrat | 9 | https://soto.house.gov | 2353 Rayburn House Office Building Washington DC 20515-0909 | 202-225-9889 | 2353 Rayburn House Office Building | |||||||||
43704 | 43704 | Kyrsten Sinema S001191 | rep | AZ | 2013-01-03 | 2015-01-03 | Democrat | 9 | http://sinema.house.gov | 1237 Longworth HOB; Washington DC 20515-0309 | 202-225-9888 | 202-225-9731 | https://sinemaforms.house.gov/forms/writeyourrep/ | 1237 Longworth House Office Building | http://sinema.house.gov/index.cfm/rss/feed | ||||||
43705 | 43705 | Kyrsten Sinema S001191 | rep | AZ | 2015-01-06 | 2017-01-03 | Democrat | 9 | https://sinema.house.gov | 1530 Longworth HOB; Washington DC 20515-0309 | 202-225-9888 | 202-225-9731 | https://sinemaforms.house.gov/forms/writeyourrep/ | 1530 Longworth House Office Building | http://sinema.house.gov/index.cfm/rss/feed | ||||||
43706 | 43706 | Kyrsten Sinema S001191 | rep | AZ | 2017-01-03 | 2019-01-03 | Democrat | 9 | https://sinema.house.gov | 1725 Longworth House Office Building; Washington DC 20515-0309 | 202-225-9888 | 202-225-9731 | 1725 Longworth House Office Building | http://sinema.house.gov/index.cfm/rss/feed | |||||||
44284 | 44284 | Greg Stanton S001211 | rep | AZ | 2019-01-03 | 2021-01-03 | Democrat | 9 | https://stanton.house.gov | 128 Cannon House Office Building Washington DC 20515-0309 | 202-225-9888 | 128 Cannon House Office Building | |||||||||
44285 | 44285 | Greg Stanton S001211 | rep | AZ | 2021-01-03 | 2023-01-03 | Democrat | 9 | https://stanton.house.gov | 207 Cannon House Office Building Washington DC 20515-0309 | 202-225-9888 | 207 Cannon House Office Building | |||||||||
41570 | 41570 | Denny Heck H001064 | rep | WA | 2013-01-03 | 2015-01-03 | Democrat | 10 | http://dennyheck.house.gov | 425 Cannon HOB; Washington DC 20515-4710 | 202-225-9740 | 202-225-0129 | https://dennyheck.house.gov/contact/email-me | 425 Cannon House Office Building | http://dennyheck.house.gov/rss.xml | ||||||
41571 | 41571 | Denny Heck H001064 | rep | WA | 2015-01-06 | 2017-01-03 | Democrat | 10 | http://dennyheck.house.gov | 425 Cannon HOB; Washington DC 20515-4710 | 202-225-9740 | 202-225-0129 | https://dennyheck.house.gov/contact/email-me | 425 Cannon House Office Building | http://dennyheck.house.gov/rss.xml | ||||||
41572 | 41572 | Denny Heck H001064 | rep | WA | 2017-01-03 | 2019-01-03 | Democrat | 10 | https://dennyheck.house.gov | 2452 Cannon House Office Building; Washington DC 20515-4710 | 202-225-9740 | 202-225-0129 | 2452 Cannon House Office Building | http://dennyheck.house.gov/rss.xml | |||||||
41573 | 41573 | Denny Heck H001064 | rep | WA | 2019-01-03 | 2021-01-03 | Democrat | 10 | https://dennyheck.house.gov | 2452 Rayburn House Office Building Washington DC 20515-4710 | 202-225-9740 | 2452 Rayburn House Office Building | http://dennyheck.house.gov/rss.xml | ||||||||
44529 | 44529 | Marilyn Strickland S001159 | rep | WA | 2021-01-03 | 2023-01-03 | Democrat | 10 | https://strickland.house.gov | 1004 Longworth House Office Building Washington DC 20515-4710 | 202-225-9740 | 1004 Longworth House Office Building | |||||||||
43891 | 43891 | Chris Stewart S001192 | rep | UT | 2013-01-03 | 2015-01-03 | Republican | 2 | http://stewart.house.gov | 323 Cannon HOB; Washington DC 20515-4402 | 202-225-9730 | 801-364-5551 | https://stewart.house.gov/contact/email-me | 323 Cannon House Office Building | http://stewart.house.gov/rss.xml | ||||||
43892 | 43892 | Chris Stewart S001192 | rep | UT | 2015-01-06 | 2017-01-03 | Republican | 2 | http://stewart.house.gov | 323 Cannon HOB; Washington DC 20515-4402 | 202-225-9730 | 801-364-5551 | https://stewart.house.gov/contact/email-me | 323 Cannon House Office Building | http://stewart.house.gov/rss.xml | ||||||
43893 | 43893 | Chris Stewart S001192 | rep | UT | 2017-01-03 | 2019-01-03 | Republican | 2 | https://stewart.house.gov | 323 Cannon House Office Building; Washington DC 20515-4402 | 202-225-9730 | 801-364-5551 | 323 Cannon House Office Building | http://stewart.house.gov/rss.xml | |||||||
43894 | 43894 | Chris Stewart S001192 | rep | UT | 2019-01-03 | 2021-01-03 | Republican | 2 | https://stewart.house.gov | 2242 Rayburn House Office Building Washington DC 20515-4402 | 202-225-9730 | 2242 Rayburn House Office Building | http://stewart.house.gov/rss.xml | ||||||||
43895 | 43895 | Chris Stewart S001192 | rep | UT | 2021-01-03 | 2023-01-03 | Republican | 2 | https://stewart.house.gov | 166 Cannon House Office Building Washington DC 20515-4402 | 202-225-9730 | 166 Cannon House Office Building | http://stewart.house.gov/rss.xml | ||||||||
43397 | 43397 | Adam Smith S000510 | rep | WA | 2011-01-05 | 2013-01-03 | Democrat | 9 | http://www.house.gov/adamsmith | 2402 Rayburn HOB; Washington DC 20515-4709 | 202-225-8901 | 202-225-5893 | http://adamsmith.house.gov/Contact/ | 2402 Rayburn House Office Building | |||||||
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 | ||||||||
42588 | 42588 | Eddie Johnson J000126 | rep | TX | 2011-01-05 | 2013-01-03 | Democrat | 30 | http://www.house.gov/ebjohnson | 2468 Rayburn HOB; Washington DC 20515-4330 | 202-225-8885 | 202-226-1477 | http://www.house.gov/ebjohnson/IMA/issue_subscribe.shtml | 2468 Rayburn House Office Building | |||||||
42589 | 42589 | Eddie Johnson J000126 | rep | TX | 2013-01-03 | 2015-01-03 | Democrat | 30 | http://ebjohnson.house.gov | 2468 Rayburn HOB; Washington DC 20515-4330 | 202-225-8885 | 202-226-1477 | https://ebjohnson.house.gov/contact/email-me | 2468 Rayburn House Office Building | http://ebjohnson.house.gov/common/rss//index.cfm?rss=21 | ||||||
42590 | 42590 | Eddie Johnson J000126 | rep | TX | 2015-01-06 | 2017-01-03 | Democrat | 30 | http://ebjohnson.house.gov | 2468 Rayburn HOB; Washington DC 20515-4330 | 202-225-8885 | 202-226-1477 | https://ebjohnson.house.gov/contact/email-me | 2468 Rayburn House Office Building | http://ebjohnson.house.gov/common/rss//index.cfm?rss=21 | ||||||
42591 | 42591 | Eddie Johnson J000126 | rep | TX | 2017-01-03 | 2019-01-03 | Democrat | 30 | https://ebjohnson.house.gov | 2468 Rayburn House Office Building; Washington DC 20515-4330 | 202-225-8885 | 202-226-1477 | 2468 Rayburn House Office Building | http://ebjohnson.house.gov/common/rss//index.cfm?rss=21 | |||||||
42592 | 42592 | Eddie Johnson J000126 | rep | TX | 2019-01-03 | 2021-01-03 | Democrat | 30 | https://ebjohnson.house.gov | 2306 Rayburn House Office Building Washington DC 20515-4330 | 202-225-8885 | 2306 Rayburn House Office Building | http://ebjohnson.house.gov/common/rss//index.cfm?rss=21 | ||||||||
42593 | 42593 | Eddie Johnson J000126 | rep | TX | 2021-01-03 | 2023-01-03 | Democrat | 30 | https://ebjohnson.house.gov | 2306 Rayburn House Office Building Washington DC 20515-4330 | 202-225-8885 | 2306 Rayburn House Office Building | http://ebjohnson.house.gov/common/rss//index.cfm?rss=21 | ||||||||
40290 | 40290 | Donna Edwards E000290 | rep | MD | 2011-01-05 | 2013-01-03 | Democrat | 4 | http://donnaedwards.house.gov/ | 318 Cannon HOB; Washington DC 20515-2004 | 202-225-8699 | 202-225-8714 | http://www.house.gov/writerep | 318 Cannon House Office Building | |||||||
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 | ||||||
44178 | 44178 | Anthony Brown B001304 | rep | MD | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://anthonybrown.house.gov | 1505 Longworth House Office Building; Washington DC 20515-2004 | 202-225-8699 | 1505 Longworth House Office Building | |||||||||
44179 | 44179 | Anthony Brown B001304 | rep | MD | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://anthonybrown.house.gov | 1323 Longworth House Office Building Washington DC 20515-2004 | 202-225-8699 | 1323 Longworth House Office Building | |||||||||
44180 | 44180 | Anthony Brown B001304 | rep | MD | 2021-01-03 | 2023-01-03 | Democrat | 4 | https://anthonybrown.house.gov | 1323 Longworth House Office Building Washington DC 20515-2004 | 202-225-8699 | 1323 Longworth House Office Building | |||||||||
39840 | 39840 | Eni Faleomavaega F000010 | rep | AS | 2011-01-05 | 2013-01-03 | Democrat | 0 | http://www.house.gov/faleomavaega | 2422 Rayburn HOB; Washington DC 20515-5201 | 202-225-8577 | 202-225-8757 | http://www.house.gov/writerep | 2422 Rayburn House Office Building | |||||||
39841 | 39841 | Eni Faleomavaega F000010 | rep | AS | 2013-01-03 | 2015-01-03 | Democrat | 0 | http://faleomavaega.house.gov | 2422 Rayburn HOB; Washington DC 20515-5201 | 202-225-8577 | 202-225-8757 | https://faleomavaega.house.gov/contact/email-me | 2422 Rayburn House Office Building | |||||||
44068 | 44068 | Aumua Amata Radewagen R000600 | rep | AS | 2015-01-06 | 2017-01-03 | Republican | 0 | https://radewagen.house.gov | 1339 Longworth HOB; Washington DC 20515-5200 | 202-225-8577 | 202-225-8757 | 1339 Longworth House Office Building | ||||||||
44069 | 44069 | Aumua Amata Radewagen R000600 | rep | AS | 2017-01-03 | 2019-01-03 | Republican | 0 | https://radewagen.house.gov | 1339 Longworth House Office Building; Washington DC 20515-5200 | 202-225-8577 | 202-225-8757 | 1339 Longworth House Office Building | ||||||||
44070 | 44070 | Aumua Amata Radewagen R000600 | rep | AS | 2019-01-03 | 2021-01-03 | Republican | 0 | https://radewagen.house.gov | 1339 Longworth House Office Building Washington DC 20515-5200 | 202-225-8577 | 1339 Longworth House Office Building | |||||||||
44071 | 44071 | Aumua Amata Radewagen R000600 | rep | AS | 2021-01-03 | 2023-01-03 | Republican | 0 | https://radewagen.house.gov | 1339 Longworth House Office Building Washington DC 20515-5200 | 202-225-8577 | 1339 Longworth House Office Building | |||||||||
39620 | 39620 | Rodney Alexander A000361 | rep | LA | 2011-01-05 | 2013-01-03 | Republican | 5 | http://alexander.house.gov/ | 316 Cannon HOB; Washington DC 20515-1805 | 202-225-8490 | 202-225-5639 | http://www.house.gov/alexander/content/webform/zipauth.htm | 316 Cannon House Office Building | |||||||
39621 | 39621 | Rodney Alexander A000361 | rep | LA | 2013-01-03 | 2013-09-27 | Republican | 5 | http://alexander.house.gov | 316 Cannon HOB; Washington DC 20515-1805 | 202-225-8490 | 202-225-5639 | https://alexander.house.gov/email-me | 316 Cannon House Office Building | http://alexander.house.gov/rss/press-releases-statements.xml | ||||||
40127 | 40127 | Vance McAllister M001192 | rep | LA | 2013-11-16 | 2015-01-03 | Republican | 5 | http://mcallister.house.gov | 316 Cannon HOB; Washington DC 20515-1805 | 202-225-8490 | https://mcallister.house.gov/email-me | 316 Cannon House Office Building | ||||||||
41578 | 41578 | Ralph Abraham A000374 | rep | LA | 2015-01-06 | 2017-01-03 | Republican | 5 | https://abraham.house.gov | 417 Cannon HOB; Washington DC 20515-1805 | 202-225-8490 | 202-225-5639 | 417 Cannon House Office Building | ||||||||
41579 | 41579 | Ralph Abraham A000374 | rep | LA | 2017-01-03 | 2019-01-03 | Republican | 5 | https://abraham.house.gov | 417 Cannon House Office Building; Washington DC 20515-1805 | 202-225-8490 | 202-225-5639 | 417 Cannon House Office Building | ||||||||
41580 | 41580 | Ralph Abraham A000374 | rep | LA | 2019-01-03 | 2021-01-03 | Republican | 5 | https://abraham.house.gov | 417 Cannon House Office Building Washington DC 20515-1805 | 202-225-8490 | 417 Cannon House Office Building | |||||||||
44537 | 44537 | Julia Letlow L000595 | rep | LA | 2021-04-14 | 2023-01-03 | Republican | 5 | https://letlow.house.gov | 1408 Longworth House Office Building Washington DC 20515-1805 | 202-225-8490 | 1408 Longworth House Office Building | |||||||||
43330 | 43330 | Robert Scott S000185 | rep | VA | 2011-01-05 | 2013-01-03 | Democrat | 3 | http://www.house.gov/scott | 1201 Longworth HOB; Washington DC 20515-4603 | 202-225-8351 | 202-225-8354 | http://www.house.gov/writerep | 1201 Longworth House Office Building | |||||||
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 | ||||||||
42794 | 42794 | Stephen Lynch L000562 | rep | MA | 2011-01-05 | 2013-01-03 | Democrat | 9 | http://www.house.gov/lynch | 2348 Rayburn HOB; Washington DC 20515-2109 | 202-225-8273 | 202-225-3984 | http://www.house.gov/writerep | 2348 Rayburn House Office Building | |||||||
42795 | 42795 | Stephen Lynch L000562 | rep | MA | 2013-01-03 | 2015-01-03 | Democrat | 8 | http://lynch.house.gov | 2133 Rayburn HOB; Washington DC 20515-2108 | 202-225-8273 | 202-225-3984 | https://lynch.house.gov/contact-me/email-me | 2133 Rayburn House Office Building | http://lynch.house.gov/rss.xml | ||||||
42796 | 42796 | Stephen Lynch L000562 | rep | MA | 2015-01-06 | 2017-01-03 | Democrat | 8 | http://lynch.house.gov | 2369 Rayburn HOB; Washington DC 20515-2108 | 202-225-8273 | 202-225-3984 | https://lynch.house.gov/contact-me/email-me | 2369 Rayburn House Office Building | http://lynch.house.gov/rss.xml | ||||||
42797 | 42797 | Stephen Lynch L000562 | rep | MA | 2017-01-03 | 2019-01-03 | Democrat | 8 | https://lynch.house.gov | 2268 Rayburn House Office Building; Washington DC 20515-2108 | 202-225-8273 | 202-225-3984 | 2268 Rayburn House Office Building | http://lynch.house.gov/rss.xml | |||||||
42798 | 42798 | Stephen Lynch L000562 | rep | MA | 2019-01-03 | 2021-01-03 | Democrat | 8 | https://lynch.house.gov | 2109 Rayburn House Office Building Washington DC 20515-2108 | 202-225-8273 | 2109 Rayburn House Office Building | http://lynch.house.gov/rss.xml | ||||||||
42799 | 42799 | Stephen Lynch L000562 | rep | MA | 2021-01-03 | 2023-01-03 | Democrat | 8 | https://lynch.house.gov | 2109 Rayburn House Office Building Washington DC 20515-2108 | 202-225-8273 | 2109 Rayburn House Office Building | http://lynch.house.gov/rss.xml | ||||||||
40190 | 40190 | Janice Hahn H001063 | rep | CA | 2011-07-19 | 2013-01-03 | Democrat | 36 | http://hahn.house.gov/ | 2400 Rayburn HOB; Washington DC 20515-0536 | 202-225-8220 | 202-226-7290 | https://hahn.house.gov/contact-me/email-me | 2400 Rayburn House Office Building |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [legislator_terms] ( [legislator_id] TEXT REFERENCES [legislators]([id]), [type] TEXT, [state] TEXT, [start] TEXT, [end] TEXT, [class] INTEGER, [party] TEXT , [district] INTEGER, [how] TEXT, [party_affiliations] TEXT, [url] TEXT, [caucus] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);