legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
4,189 rows where state = "NY" sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: class, state_rank, start (date), end (date)
party >10 ✖
- Democrat 1,837
- Republican 1,736
- Whig 176
- Jackson 142
- Federalist 103
- Adams 43
- Ind. Republican-Democrat 26
- Anti Masonic 18
- American Labor 8
- American 7
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44550 | 44550 | Joseph Sempolinski S001219 | rep | NY | 2022-09-13 | 2023-01-03 | Republican | 23 | 1203 Longworth House Office Building Washington DC 20515-3223 | 202-225-3161 | 1203 Longworth House Office Building | ||||||||||
44549 | 44549 | Patrick Ryan R000579 | rep | NY | 2022-09-13 | 2023-01-03 | Democrat | 19 | 1007 Longworth House Office Building Washington DC 20515-3219 | 202-225-5614 | 1007 Longworth House Office Building | ||||||||||
44536 | 44536 | Claudia Tenney T000478 | rep | NY | 2021-02-11 | 2023-01-03 | Republican | 22 | https://tenney.house.gov | 1410 Longworth House Office Building Washington DC 20515-3222 | 202-225-3665 | 1410 Longworth House Office Building | |||||||||
44535 | 44535 | Claudia Tenney T000478 | rep | NY | 2017-01-03 | 2019-01-03 | Republican | 22 | https://tenney.house.gov | 512 Cannon House Office Building; Washington DC 20515-3222 | 202-225-3665 | 512 Cannon House Office Building | |||||||||
44515 | 44515 | Mondaire Jones J000306 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 17 | https://jones.house.gov | 1017 Longworth House Office Building Washington DC 20515-3217 | 202-225-6506 | 1017 Longworth House Office Building | |||||||||
44514 | 44514 | Jamaal Bowman B001223 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 16 | https://bowman.house.gov | 1605 Longworth House Office Building Washington DC 20515-3216 | 202-225-2464 | 1605 Longworth House Office Building | |||||||||
44513 | 44513 | Ritchie Torres T000486 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 15 | https://ritchietorres.house.gov | 317 Cannon House Office Building Washington DC 20515-3215 | 202-225-4361 | 317 Cannon House Office Building | |||||||||
44512 | 44512 | Nicole Malliotakis M000317 | rep | NY | 2021-01-03 | 2023-01-03 | Republican | 11 | https://malliotakis.house.gov | 417 Cannon House Office Building Washington DC 20515-3211 | 202-225-3371 | 417 Cannon House Office Building | |||||||||
44511 | 44511 | Andrew Garbarino G000597 | rep | NY | 2021-01-03 | 2023-01-03 | Republican | 2 | https://garbarino.house.gov | 1516 Longworth House Office Building Washington DC 20515-3202 | 202-225-7896 | 1516 Longworth House Office Building | |||||||||
44438 | 44438 | Chris Jacobs J000020 | rep | NY | 2021-01-03 | 2023-01-03 | Republican | 27 | https://jacobs.house.gov | 214 Cannon House Office Building Washington DC 20515-3227 | 202-225-5265 | 214 Cannon House Office Building | |||||||||
44437 | 44437 | Chris Jacobs J000020 | rep | NY | 2020-07-21 | 2021-01-03 | Republican | 27 | 2243 Rayburn House Office Building Washington DC 20515-3227 | 202-225-5265 | 2243 Rayburn House Office Building | ||||||||||
44361 | 44361 | Alexandria Ocasio-Cortez O000172 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 14 | https://ocasio-cortez.house.gov | 216 Cannon House Office Building Washington DC 20515-3214 | 202-225-3965 | 216 Cannon House Office Building | |||||||||
44360 | 44360 | Alexandria Ocasio-Cortez O000172 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 14 | https://ocasio-cortez.house.gov | 229 Cannon House Office Building Washington DC 20515-3214 | 202-225-3965 | 229 Cannon House Office Building | |||||||||
44265 | 44265 | Joseph Morelle M001206 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 25 | https://morelle.house.gov | 1317 Longworth House Office Building Washington DC 20515-3225 | 202-225-3615 | 1317 Longworth House Office Building | |||||||||
44264 | 44264 | Joseph Morelle M001206 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 25 | https://morelle.house.gov | 1317 Longworth House Office Building Washington DC 20515-3225 | 202-225-3615 | 1317 Longworth House Office Building | |||||||||
44263 | 44263 | Joseph Morelle M001206 | rep | NY | 2018-11-13 | 2019-01-03 | Democrat | 25 | https://morelle.house.gov | 2469 Rayburn House Office Building; Washington DC 20515-3225 | 202-225-3615 | 2469 Rayburn House Office Building | |||||||||
44203 | 44203 | Adriano Espaillat E000297 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 13 | https://espaillat.house.gov | 2332 Rayburn House Office Building Washington DC 20515-3213 | 202-225-4365 | 2332 Rayburn House Office Building | |||||||||
44202 | 44202 | Adriano Espaillat E000297 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 13 | https://espaillat.house.gov | 1630 Longworth House Office Building Washington DC 20515-3213 | 202-225-4365 | 1630 Longworth House Office Building | |||||||||
44201 | 44201 | Adriano Espaillat E000297 | rep | NY | 2017-01-03 | 2019-01-03 | Democrat | 13 | https://espaillat.house.gov | 1630 Longworth House Office Building; Washington DC 20515-3213 | 202-225-4365 | 202-225-0816 | 1630 Longworth House Office Building | ||||||||
44200 | 44200 | Thomas Suozzi S001201 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 3 | https://suozzi.house.gov | 407 Cannon House Office Building Washington DC 20515-3203 | 202-225-3335 | 407 Cannon House Office Building | |||||||||
44199 | 44199 | Thomas Suozzi S001201 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 3 | https://suozzi.house.gov | 214 Cannon House Office Building Washington DC 20515-3203 | 202-225-3335 | 214 Cannon House Office Building | |||||||||
44198 | 44198 | Thomas Suozzi S001201 | rep | NY | 2017-01-03 | 2019-01-03 | Democrat | 3 | https://suozzi.house.gov | 226 Cannon House Office Building; Washington DC 20515-3203 | 202-225-3335 | 202-225-4669 | 226 Cannon House Office Building | ||||||||
44039 | 44039 | John Katko K000386 | rep | NY | 2021-01-03 | 2023-01-03 | Republican | 24 | https://katko.house.gov | 2428 Rayburn House Office Building Washington DC 20515-3224 | 202-225-3701 | 2428 Rayburn House Office Building | |||||||||
44038 | 44038 | John Katko K000386 | rep | NY | 2019-01-03 | 2021-01-03 | Republican | 24 | https://katko.house.gov | 2457 Rayburn House Office Building Washington DC 20515-3224 | 202-225-3701 | 2457 Rayburn House Office Building | |||||||||
44037 | 44037 | John Katko K000386 | rep | NY | 2017-01-03 | 2019-01-03 | Republican | 24 | https://katko.house.gov | 1620 Longworth House Office Building; Washington DC 20515-3224 | 202-225-3701 | 202-225-4042 | 1620 Longworth House Office Building | ||||||||
44036 | 44036 | John Katko K000386 | rep | NY | 2015-01-06 | 2017-01-03 | Republican | 24 | https://katko.house.gov | 1123 Longworth HOB; Washington DC 20515-3224 | 202-225-3701 | 202-225-4042 | 1123 Longworth House Office Building | ||||||||
44035 | 44035 | Elise Stefanik S001196 | rep | NY | 2021-01-03 | 2023-01-03 | Republican | 21 | https://stefanik.house.gov | 2211 Rayburn House Office Building Washington DC 20515-3221 | 202-225-4611 | 2211 Rayburn House Office Building | |||||||||
44034 | 44034 | Elise Stefanik S001196 | rep | NY | 2019-01-03 | 2021-01-03 | Republican | 21 | https://stefanik.house.gov | 318 Cannon House Office Building Washington DC 20515-3221 | 202-225-4611 | 318 Cannon House Office Building | |||||||||
44033 | 44033 | Elise Stefanik S001196 | rep | NY | 2017-01-03 | 2019-01-03 | Republican | 21 | https://stefanik.house.gov | 318 Cannon House Office Building; Washington DC 20515-3221 | 202-225-4611 | 202-226-0621 | 318 Cannon House Office Building | ||||||||
44032 | 44032 | Elise Stefanik S001196 | rep | NY | 2015-01-06 | 2017-01-03 | Republican | 21 | https://stefanik.house.gov | 512 Cannon HOB; Washington DC 20515-3221 | 202-225-4611 | 202-226-0621 | 512 Cannon House Office Building | ||||||||
44031 | 44031 | Kathleen Rice R000602 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 4 | https://kathleenrice.house.gov | 2435 Rayburn House Office Building Washington DC 20515-3204 | 202-225-5516 | 2435 Rayburn House Office Building | |||||||||
44030 | 44030 | Kathleen Rice R000602 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 4 | https://kathleenrice.house.gov | 2435 Rayburn House Office Building Washington DC 20515-3204 | 202-225-5516 | 2435 Rayburn House Office Building | |||||||||
44029 | 44029 | Kathleen Rice R000602 | rep | NY | 2017-01-03 | 2019-01-03 | Democrat | 4 | https://kathleenrice.house.gov | 1508 Longworth House Office Building; Washington DC 20515-3204 | 202-225-5516 | 202-225-5758 | 1508 Longworth House Office Building | ||||||||
44028 | 44028 | Kathleen Rice R000602 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 4 | http://kathleenrice.house.gov | 1508 Longworth HOB; Washington DC 20515-3204 | 202-225-5516 | 202-225-5758 | 1508 Longworth House Office Building | ||||||||
44027 | 44027 | Lee Zeldin Z000017 | rep | NY | 2021-01-03 | 2023-01-03 | Republican | 1 | https://zeldin.house.gov | 2441 Rayburn House Office Building Washington DC 20515-3201 | 202-225-3826 | 2441 Rayburn House Office Building | |||||||||
44026 | 44026 | Lee Zeldin Z000017 | rep | NY | 2019-01-03 | 2021-01-03 | Republican | 1 | https://zeldin.house.gov | 2441 Rayburn House Office Building Washington DC 20515-3201 | 202-225-3826 | 2441 Rayburn House Office Building | |||||||||
44025 | 44025 | Lee Zeldin Z000017 | rep | NY | 2017-01-03 | 2019-01-03 | Republican | 1 | https://zeldin.house.gov | 1517 Longworth House Office Building; Washington DC 20515-3201 | 202-225-3826 | 202-225-3143 | 1517 Longworth House Office Building | ||||||||
44024 | 44024 | Lee Zeldin Z000017 | rep | NY | 2015-01-06 | 2017-01-03 | Republican | 1 | https://zeldin.house.gov | 1517 Longworth HOB; Washington DC 20515-3201 | 202-225-3826 | 202-225-3143 | 1517 Longworth House Office Building | ||||||||
43833 | 43833 | Sean Maloney M001185 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 18 | https://seanmaloney.house.gov | 464 Cannon House Office Building Washington DC 20515-3218 | 202-225-5441 | 464 Cannon House Office Building | http://seanmaloney.house.gov/rss.xml | ||||||||
43832 | 43832 | Sean Maloney M001185 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 18 | https://seanmaloney.house.gov | 2331 Rayburn House Office Building Washington DC 20515-3218 | 202-225-5441 | 2331 Rayburn House Office Building | http://seanmaloney.house.gov/rss.xml | ||||||||
43831 | 43831 | Sean Maloney M001185 | rep | NY | 2017-01-03 | 2019-01-03 | Democrat | 18 | https://seanmaloney.house.gov | 1027 Longworth House Office Building; Washington DC 20515-3218 | 202-225-5441 | 202-225-3289 | 1027 Longworth House Office Building | http://seanmaloney.house.gov/rss.xml | |||||||
43830 | 43830 | Sean Maloney M001185 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 18 | http://seanmaloney.house.gov | 1529 Longworth HOB; Washington DC 20515-3218 | 202-225-5441 | 202-225-3289 | https://seanmaloney.house.gov/contact/email-me | 1529 Longworth House Office Building | http://seanmaloney.house.gov/rss.xml | ||||||
43829 | 43829 | Sean Maloney M001185 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 18 | http://seanmaloney.house.gov | 1529 Longworth HOB; Washington DC 20515-3218 | 202-225-5441 | https://seanmaloney.house.gov/contact/email-me | 1529 Longworth House Office Building | http://seanmaloney.house.gov/rss.xml | |||||||
43828 | 43828 | Hakeem Jeffries J000294 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 8 | https://jeffries.house.gov | 2433 Rayburn House Office Building Washington DC 20515-3208 | 202-225-5936 | 2433 Rayburn House Office Building | http://jeffries.house.gov/rss.xml | ||||||||
43827 | 43827 | Hakeem Jeffries J000294 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 8 | https://jeffries.house.gov | 2433 Rayburn House Office Building Washington DC 20515-3208 | 202-225-5936 | 2433 Rayburn House Office Building | http://jeffries.house.gov/rss.xml | ||||||||
43826 | 43826 | Hakeem Jeffries J000294 | rep | NY | 2017-01-03 | 2019-01-03 | Democrat | 8 | https://jeffries.house.gov | 1607 Longworth House Office Building; Washington DC 20515-3208 | 202-225-5936 | 1607 Longworth House Office Building | http://jeffries.house.gov/rss.xml | ||||||||
43825 | 43825 | Hakeem Jeffries J000294 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 8 | http://jeffries.house.gov | 1607 Longworth HOB; Washington DC 20515-3208 | 202-225-5936 | https://jeffriesforms.house.gov/contact/ | 1607 Longworth House Office Building | http://jeffries.house.gov/rss.xml | |||||||
43824 | 43824 | Hakeem Jeffries J000294 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 8 | http://jeffries.house.gov | 1339 Longworth HOB; Washington DC 20515-3208 | 202-225-5936 | https://jeffriesforms.house.gov/contact/ | 1339 Longworth House Office Building | http://jeffries.house.gov/rss.xml | |||||||
43823 | 43823 | Grace Meng M001188 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 6 | https://meng.house.gov | 2209 Rayburn House Office Building Washington DC 20515-3206 | 202-225-2601 | 2209 Rayburn House Office Building | http://meng.house.gov/rss.xml | ||||||||
43822 | 43822 | Grace Meng M001188 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 6 | https://meng.house.gov | 2209 Rayburn House Office Building Washington DC 20515-3206 | 202-225-2601 | 2209 Rayburn House Office Building | http://meng.house.gov/rss.xml | ||||||||
43821 | 43821 | Grace Meng M001188 | rep | NY | 2017-01-03 | 2019-01-03 | Democrat | 6 | https://meng.house.gov | 1317 Longworth House Office Building; Washington DC 20515-3206 | 202-225-2601 | 202-225-1589 | 1317 Longworth House Office Building | http://meng.house.gov/rss.xml | |||||||
43820 | 43820 | Grace Meng M001188 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 6 | http://meng.house.gov | 1317 Longworth HOB; Washington DC 20515-3206 | 202-225-2601 | 202-225-1589 | https://meng.house.gov/contact/email-me | 1317 Longworth House Office Building | http://meng.house.gov/rss.xml | ||||||
43819 | 43819 | Grace Meng M001188 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 6 | http://meng.house.gov | 1317 Longworth HOB; Washington DC 20515-3206 | 202-225-2601 | https://meng.house.gov/contact/email-me | 1317 Longworth House Office Building | http://meng.house.gov/rss.xml | |||||||
43552 | 43552 | Nydia Velázquez V000081 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 7 | https://velazquez.house.gov | 2302 Rayburn House Office Building Washington DC 20515-3207 | 202-225-2361 | 2302 Rayburn House Office Building | |||||||||
43551 | 43551 | Nydia Velázquez V000081 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 7 | https://velazquez.house.gov | 2302 Rayburn House Office Building Washington DC 20515-3207 | 202-225-2361 | 2302 Rayburn House Office Building | |||||||||
43550 | 43550 | Nydia Velázquez V000081 | rep | NY | 2017-01-03 | 2019-01-03 | Democrat | 7 | https://velazquez.house.gov | 2302 Rayburn House Office Building; Washington DC 20515-3207 | 202-225-2361 | 202-226-0327 | 2302 Rayburn House Office Building | ||||||||
43549 | 43549 | Nydia Velázquez V000081 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 7 | http://velazquez.house.gov | 2302 Rayburn HOB; Washington DC 20515-3207 | 202-225-2361 | 202-226-0327 | http://velazquez.house.gov/IMA/issue_subscribe.shtml | 2302 Rayburn House Office Building | |||||||
43548 | 43548 | Nydia Velázquez V000081 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 7 | http://www.house.gov/velazquez | 2302 Rayburn HOB; Washington DC 20515-3207 | 202-225-2361 | 202-226-0327 | http://velazquez.house.gov/IMA/issue_subscribe.shtml | 2302 Rayburn House Office Building | |||||||
43547 | 43547 | Nydia Velázquez V000081 | rep | NY | 2011-01-05 | 2013-01-03 | Democrat | 12 | http://www.house.gov/velazquez | 2302 Rayburn HOB; Washington DC 20515-3212 | 202-225-2361 | 202-226-0327 | http://www.house.gov/velazquez/IMA/issue_subscribe.htm | 2302 Rayburn House Office Building | |||||||
43546 | 43546 | Nydia Velázquez V000081 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 12 | http://www.house.gov/velazquez | ||||||||||||
43545 | 43545 | Nydia Velázquez V000081 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 12 | http://www.house.gov/velazquez | ||||||||||||
43544 | 43544 | Nydia Velázquez V000081 | rep | NY | 2005-01-04 | 2007-01-03 | Democrat | 12 | http://www.house.gov/velazquez | ||||||||||||
43543 | 43543 | Nydia Velázquez V000081 | rep | NY | 2003-01-07 | 2005-01-03 | Democrat | 12 | http://www.house.gov/velazquez | ||||||||||||
43542 | 43542 | Nydia Velázquez V000081 | rep | NY | 2001-01-03 | 2003-01-03 | Democrat | 12 | |||||||||||||
43541 | 43541 | Nydia Velázquez V000081 | rep | NY | 1999-01-06 | 2001-01-03 | Democrat | 12 | |||||||||||||
43540 | 43540 | Nydia Velázquez V000081 | rep | NY | 1997-01-07 | 1999-01-03 | Democrat | 12 | |||||||||||||
43539 | 43539 | Nydia Velázquez V000081 | rep | NY | 1995-01-04 | 1997-01-03 | Democrat | 12 | |||||||||||||
43538 | 43538 | Nydia Velázquez V000081 | rep | NY | 1993-01-05 | 1995-01-03 | Democrat | 12 | |||||||||||||
43496 | 43496 | Paul Tonko T000469 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 20 | https://tonko.house.gov | 2369 Rayburn House Office Building Washington DC 20515-3220 | 202-225-5076 | 2369 Rayburn House Office Building | http://tonko.house.gov/rss/press-releases.xml | ||||||||
43495 | 43495 | Paul Tonko T000469 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 20 | https://tonko.house.gov | 2369 Rayburn House Office Building Washington DC 20515-3220 | 202-225-5076 | 2369 Rayburn House Office Building | http://tonko.house.gov/rss/press-releases.xml | ||||||||
43494 | 43494 | Paul Tonko T000469 | rep | NY | 2017-01-03 | 2019-01-03 | Democrat | 20 | https://tonko.house.gov | 2463 Rayburn House Office Building; Washington DC 20515-3220 | 202-225-5076 | 202-225-5077 | 2463 Rayburn House Office Building | http://tonko.house.gov/rss/press-releases.xml | |||||||
43493 | 43493 | Paul Tonko T000469 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 20 | http://tonko.house.gov | 2463 Rayburn HOB; Washington DC 20515-3220 | 202-225-5076 | 202-225-5077 | https://tonko.house.gov/email-form1 | 2463 Rayburn House Office Building | http://tonko.house.gov/rss/press-releases.xml | ||||||
43492 | 43492 | Paul Tonko T000469 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 20 | http://tonko.house.gov | 2463 Rayburn HOB; Washington DC 20515-3220 | 202-225-5076 | 202-225-5077 | https://tonko.house.gov/email-form1 | 2463 Rayburn House Office Building | http://tonko.house.gov/rss/press-releases.xml | ||||||
43491 | 43491 | Paul Tonko T000469 | rep | NY | 2011-01-05 | 2013-01-03 | Democrat | 21 | http://tonko.house.gov | 422 Cannon HOB; Washington DC 20515-3221 | 202-225-5076 | 202-225-5077 | https://forms.house.gov/tonko/contact-form.shtml | 422 Cannon House Office Building | |||||||
43490 | 43490 | Paul Tonko T000469 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 21 | http://tonko.house.gov | ||||||||||||
43298 | 43298 | Charles Schumer S000148 | sen | NY | 2017-01-03 | 2023-01-03 | 3 | Democrat | https://www.schumer.senate.gov | 322 Hart Senate Office Building Washington DC 20510 | 202-224-6542 | 202-228-3027 | https://www.schumer.senate.gov/contact/email-chuck | 322 Hart Senate Office Building | senior | ||||||
43297 | 43297 | Charles Schumer S000148 | sen | NY | 2011-01-05 | 2017-01-03 | 3 | Democrat | https://www.schumer.senate.gov | 322 Hart Senate Office Building Washington DC 20510 | 202-224-6542 | 202-228-3027 | http://www.schumer.senate.gov/Contact/email-chuck | 322 Hart Senate Office Building | senior | ||||||
43296 | 43296 | Charles Schumer S000148 | sen | NY | 2005-01-04 | 2011-01-03 | 3 | Democrat | http://schumer.senate.gov/ | ||||||||||||
43295 | 43295 | Charles Schumer S000148 | sen | NY | 1999-01-06 | 2005-01-03 | 3 | Democrat | http://schumer.senate.gov/ | ||||||||||||
43294 | 43294 | Charles Schumer S000148 | rep | NY | 1997-01-07 | 1999-01-03 | Democrat | 9 | |||||||||||||
43293 | 43293 | Charles Schumer S000148 | rep | NY | 1995-01-04 | 1997-01-03 | Democrat | 9 | |||||||||||||
43292 | 43292 | Charles Schumer S000148 | rep | NY | 1993-01-05 | 1995-01-03 | Democrat | 9 | |||||||||||||
43291 | 43291 | Charles Schumer S000148 | rep | NY | 1991-01-03 | 1993-01-03 | Democrat | 10 | |||||||||||||
43290 | 43290 | Charles Schumer S000148 | rep | NY | 1989-01-03 | 1991-01-03 | Democrat | 10 | |||||||||||||
43289 | 43289 | Charles Schumer S000148 | rep | NY | 1987-01-06 | 1989-01-03 | Democrat | 10 | |||||||||||||
43288 | 43288 | Charles Schumer S000148 | rep | NY | 1985-01-03 | 1987-01-03 | Democrat | 10 | |||||||||||||
43287 | 43287 | Charles Schumer S000148 | rep | NY | 1983-01-03 | 1985-01-03 | Democrat | 10 | |||||||||||||
43286 | 43286 | Charles Schumer S000148 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 16 | |||||||||||||
42987 | 42987 | Jerrold Nadler N000002 | rep | NY | 2021-01-03 | 2023-01-03 | Democrat | 10 | https://nadler.house.gov | 2132 Rayburn House Office Building Washington DC 20515-3210 | 202-225-5635 | 2132 Rayburn House Office Building | http://nadler.house.gov/rss.xml | ||||||||
42986 | 42986 | Jerrold Nadler N000002 | rep | NY | 2019-01-03 | 2021-01-03 | Democrat | 10 | https://nadler.house.gov | 2132 Rayburn House Office Building Washington DC 20515-3210 | 202-225-5635 | 2132 Rayburn House Office Building | http://nadler.house.gov/rss.xml | ||||||||
42985 | 42985 | Jerrold Nadler N000002 | rep | NY | 2017-01-03 | 2019-01-03 | Democrat | 10 | https://nadler.house.gov | 2109 Rayburn House Office Building; Washington DC 20515-3210 | 202-225-5635 | 202-225-6923 | 2109 Rayburn House Office Building | http://nadler.house.gov/rss.xml | |||||||
42984 | 42984 | Jerrold Nadler N000002 | rep | NY | 2015-01-06 | 2017-01-03 | Democrat | 10 | http://nadler.house.gov | 2109 Rayburn HOB; Washington DC 20515-3210 | 202-225-5635 | 202-225-6923 | https://jerroldnadler.house.gov/forms/writeyourrep/default.aspx | 2109 Rayburn House Office Building | http://nadler.house.gov/rss.xml | ||||||
42983 | 42983 | Jerrold Nadler N000002 | rep | NY | 2013-01-03 | 2015-01-03 | Democrat | 10 | http://nadler.house.gov | 2110 Rayburn HOB; Washington DC 20515-3210 | 202-225-5635 | 202-225-6923 | https://jerroldnadler.house.gov/forms/writeyourrep/default.aspx | 2110 Rayburn House Office Building | http://nadler.house.gov/rss.xml | ||||||
42982 | 42982 | Jerrold Nadler N000002 | rep | NY | 2011-01-05 | 2013-01-03 | Democrat | 8 | http://www.house.gov/nadler | 2334 Rayburn HOB; Washington DC 20515-3208 | 202-225-5635 | 202-225-6923 | http://www.house.gov/nadler/emailform.shtml | 2334 Rayburn House Office Building | |||||||
42981 | 42981 | Jerrold Nadler N000002 | rep | NY | 2009-01-06 | 2011-01-03 | Democrat | 8 | http://www.house.gov/nadler | ||||||||||||
42980 | 42980 | Jerrold Nadler N000002 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://www.house.gov/nadler | ||||||||||||
42979 | 42979 | Jerrold Nadler N000002 | rep | NY | 2005-01-04 | 2007-01-03 | Democrat | 8 | http://www.house.gov/nadler | ||||||||||||
42978 | 42978 | Jerrold Nadler N000002 | rep | NY | 2003-01-07 | 2005-01-03 | Democrat | 8 | http://www.house.gov/nadler | ||||||||||||
42977 | 42977 | Jerrold Nadler N000002 | rep | NY | 2001-01-03 | 2003-01-03 | Democrat | 8 | |||||||||||||
42976 | 42976 | Jerrold Nadler N000002 | rep | NY | 1999-01-06 | 2001-01-03 | Democrat | 8 |
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);