legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
4,189 rows where state = "NY"
This data as json, copyable, CSV (advanced)
party >10 ✖
- Democrat 1,837
- Republican 1,683
- Whig 176
- Jackson 142
- Federalist 72
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
913 | 913 | Philip Van Cortlandt V000022 | rep | NY | 1797-05-15 | 1799-03-03 | Republican | 3 | |||||||||||||
914 | 914 | Philip Van Cortlandt V000022 | rep | NY | 1799-12-02 | 1801-03-03 | Republican | 3 | |||||||||||||
915 | 915 | Philip Van Cortlandt V000022 | rep | NY | 1801-12-07 | 1803-03-03 | Republican | 3 | |||||||||||||
916 | 916 | Philip Van Cortlandt V000022 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 4 | |||||||||||||
917 | 917 | Philip Van Cortlandt V000022 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 4 | |||||||||||||
918 | 918 | Philip Van Cortlandt V000022 | rep | NY | 1807-10-26 | 1809-03-03 | Republican | 4 | |||||||||||||
919 | 919 | Daniel Verplanck V000088 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 6 | |||||||||||||
920 | 920 | Daniel Verplanck V000088 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 6 | |||||||||||||
921 | 921 | Daniel Verplanck V000088 | rep | NY | 1807-10-26 | 1809-03-03 | Republican | 6 | |||||||||||||
929 | 929 | Nathan Wilson W000606 | rep | NY | 1807-10-26 | 1809-03-03 | Republican | 12 | |||||||||||||
969 | 969 | William Denning D000240 | rep | NY | 1809-05-22 | 1811-03-03 | -1 | ||||||||||||||
970 | 970 | Barent Gardenier G000049 | rep | NY | 1807-10-26 | 1809-03-03 | Federalist | 7 | |||||||||||||
971 | 971 | Barent Gardenier G000049 | rep | NY | 1809-05-22 | 1811-03-03 | Federalist | 5 | |||||||||||||
974 | 974 | Obadiah German G000136 | sen | NY | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
1009 | 1009 | Herman Knickerbocker K000282 | rep | NY | 1809-05-22 | 1811-03-03 | Federalist | 6 | |||||||||||||
1034 | 1034 | Vincent Mathews M000239 | rep | NY | 1809-05-22 | 1811-03-03 | Federalist | 14 | |||||||||||||
1037 | 1037 | Gurdon Mumford M001076 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 3 | |||||||||||||
1038 | 1038 | Gurdon Mumford M001076 | rep | NY | 1807-10-26 | 1809-03-03 | Republican | 3 | |||||||||||||
1039 | 1039 | Gurdon Mumford M001076 | rep | NY | 1809-05-22 | 1811-03-03 | Republican | 2 | |||||||||||||
1047 | 1047 | John Nicholson N000098 | rep | NY | 1809-05-22 | 1811-03-03 | Republican | 10 | |||||||||||||
1073 | 1073 | John Thompson T000206 | rep | NY | 1799-12-02 | 1801-03-03 | Republican | 7 | |||||||||||||
1074 | 1074 | John Thompson T000206 | rep | NY | 1807-10-26 | 1809-03-03 | Republican | 11 | |||||||||||||
1075 | 1075 | John Thompson T000206 | rep | NY | 1809-05-22 | 1811-03-03 | Republican | 8 | |||||||||||||
1080 | 1080 | Killian Van Rensselaer V000054 | rep | NY | 1801-12-07 | 1803-03-03 | Federalist | 8 | |||||||||||||
1081 | 1081 | Killian Van Rensselaer V000054 | rep | NY | 1803-10-17 | 1805-03-03 | Federalist | 9 | |||||||||||||
1082 | 1082 | Killian Van Rensselaer V000054 | rep | NY | 1805-12-02 | 1807-03-03 | Federalist | 9 | |||||||||||||
1083 | 1083 | Killian Van Rensselaer V000054 | rep | NY | 1807-10-26 | 1809-03-03 | Federalist | 9 | |||||||||||||
1084 | 1084 | Killian Van Rensselaer V000054 | rep | NY | 1809-05-22 | 1811-03-03 | Federalist | 7 | |||||||||||||
1111 | 1111 | Harmanus Bleecker B000555 | rep | NY | 1811-11-04 | 1813-03-03 | Federalist | 7 | |||||||||||||
1139 | 1139 | Thomas Cooke C000734 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 5 | |||||||||||||
1149 | 1149 | James Emott E000176 | rep | NY | 1809-05-22 | 1811-03-03 | Federalist | 4 | |||||||||||||
1150 | 1150 | James Emott E000176 | rep | NY | 1811-11-04 | 1813-03-03 | Federalist | 4 | |||||||||||||
1151 | 1151 | Asa Fitch F000156 | rep | NY | 1811-11-04 | 1813-03-03 | Federalist | 6 | |||||||||||||
1187 | 1187 | Robert Livingston L000370 | rep | NY | 1809-05-22 | 1811-03-03 | Federalist | 6 | |||||||||||||
1188 | 1188 | Robert Livingston L000370 | rep | NY | 1811-11-04 | 1813-03-03 | Federalist | 6 | |||||||||||||
1192 | 1192 | Arunah Metcalf M000668 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 12 | |||||||||||||
1194 | 1194 | Samuel Mitchill M000831 | rep | NY | 1801-12-07 | 1803-03-03 | Republican | 2 | |||||||||||||
1195 | 1195 | Samuel Mitchill M000831 | rep | NY | 1803-10-17 | 1804-11-22 | Republican | 3 | |||||||||||||
1196 | 1196 | Samuel Mitchill M000831 | sen | NY | 1804-11-23 | 1809-03-03 | 1 | Republican | |||||||||||||
1197 | 1197 | Samuel Mitchill M000831 | rep | NY | 1810-12-04 | 1811-03-03 | Republican | 2 | |||||||||||||
1198 | 1198 | Samuel Mitchill M000831 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 2 | |||||||||||||
1206 | 1206 | William Paulding P000146 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 2 | |||||||||||||
1207 | 1207 | Benjamin Pond P000425 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 8 | |||||||||||||
1213 | 1213 | Thomas Sammons S000023 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 13 | |||||||||||||
1214 | 1214 | Thomas Sammons S000023 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 13 | |||||||||||||
1215 | 1215 | Thomas Sammons S000023 | rep | NY | 1809-05-22 | 1811-03-03 | Republican | 9 | |||||||||||||
1216 | 1216 | Thomas Sammons S000023 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 9 | |||||||||||||
1235 | 1235 | Silas Stow S000984 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 10 | |||||||||||||
1238 | 1238 | Uri Tracy T000347 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 16 | |||||||||||||
1239 | 1239 | Uri Tracy T000347 | rep | NY | 1809-05-22 | 1811-03-03 | Republican | 13 | |||||||||||||
1240 | 1240 | Uri Tracy T000347 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 13 | |||||||||||||
1245 | 1245 | Pierre Van Cortlandt V000023 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 3 | |||||||||||||
1276 | 1276 | Egbert Benson B000388 | rep | NY | 1789-03-04 | 1791-03-03 | Federalist | 3 | |||||||||||||
1277 | 1277 | Egbert Benson B000388 | rep | NY | 1791-10-24 | 1793-03-03 | Federalist | 3 | |||||||||||||
1278 | 1278 | Egbert Benson B000388 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 2 | |||||||||||||
1293 | 1293 | John Bowers B000691 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 15 | |||||||||||||
1294 | 1294 | Alexander Boyd B000715 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 13 | |||||||||||||
1327 | 1327 | Peter Denoyelles D000252 | rep | NY | 1813-05-24 | 1815-03-03 | Republican | 3 | |||||||||||||
1343 | 1343 | James Geddes G000116 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 19 | |||||||||||||
1347 | 1347 | Abraham Hasbrouck H000313 | rep | NY | 1813-05-24 | 1815-03-03 | Republican | 7 | |||||||||||||
1353 | 1353 | Samuel Hopkins H000780 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 21 | |||||||||||||
1354 | 1354 | Nathaniel Howell H000867 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 21 | |||||||||||||
1372 | 1372 | John Lefferts L000213 | rep | NY | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
1373 | 1373 | Jacob Markell M000132 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 14 | |||||||||||||
1378 | 1378 | Morris Miller M000747 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 16 | |||||||||||||
1382 | 1382 | Jotham Post P000455 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 2 | |||||||||||||
1401 | 1401 | Samuel Sherwood S000356 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 8 | |||||||||||||
1402 | 1402 | Zebulon Shipherd S000366 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 12 | |||||||||||||
1422 | 1422 | Joel Thompson T000205 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 15 | |||||||||||||
1432 | 1432 | Elisha Winter W000644 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 12 | |||||||||||||
1447 | 1447 | Asa Adgate A000056 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 12 | |||||||||||||
1451 | 1451 | Daniel Avery A000345 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 14 | |||||||||||||
1452 | 1452 | Daniel Avery A000345 | rep | NY | 1813-05-24 | 1815-03-03 | Republican | 20 | |||||||||||||
1453 | 1453 | Daniel Avery A000345 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 20 | |||||||||||||
1467 | 1467 | Samuel Betts B000427 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 7 | |||||||||||||
1468 | 1468 | James Birdsall B000482 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 15 | |||||||||||||
1478 | 1478 | Micah Brooks B000883 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 21 | |||||||||||||
1481 | 1481 | Daniel Cady C000014 | rep | NY | 1815-12-04 | 1817-03-03 | Federalist | 14 | |||||||||||||
1501 | 1501 | Archibald Clarke C000456 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 21 | |||||||||||||
1530 | 1530 | Henry Crocheron C000914 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 1 | |||||||||||||
1564 | 1564 | Jonathan Fisk F000155 | rep | NY | 1809-05-22 | 1811-03-03 | Republican | 3 | |||||||||||||
1565 | 1565 | Jonathan Fisk F000155 | rep | NY | 1813-05-24 | 1815-03-03 | Republican | 6 | |||||||||||||
1566 | 1566 | Jonathan Fisk F000155 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | -1 | |||||||||||||
1577 | 1577 | Thomas Gold G000257 | rep | NY | 1809-05-22 | 1811-03-03 | Federalist | 11 | |||||||||||||
1578 | 1578 | Thomas Gold G000257 | rep | NY | 1811-11-04 | 1813-03-03 | Federalist | 11 | |||||||||||||
1579 | 1579 | Thomas Gold G000257 | rep | NY | 1815-12-04 | 1817-03-03 | Federalist | 16 | |||||||||||||
1590 | 1590 | Thomas Grosvenor G000498 | rep | NY | 1811-11-04 | 1813-03-03 | Federalist | 6 | |||||||||||||
1591 | 1591 | Thomas Grosvenor G000498 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 5 | |||||||||||||
1592 | 1592 | Thomas Grosvenor G000498 | rep | NY | 1815-12-04 | 1817-03-03 | Federalist | 5 | |||||||||||||
1600 | 1600 | Jabez Hammond H000127 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 15 | |||||||||||||
1627 | 1627 | Moss Kent K000126 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 18 | |||||||||||||
1628 | 1628 | Moss Kent K000126 | rep | NY | 1815-12-04 | 1817-03-03 | Federalist | 18 | |||||||||||||
1651 | 1651 | John Lovett L000466 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 9 | |||||||||||||
1652 | 1652 | John Lovett L000466 | rep | NY | 1815-12-04 | 1817-03-03 | Federalist | 9 | |||||||||||||
1666 | 1666 | Hosea Moffitt M000840 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 10 | |||||||||||||
1667 | 1667 | Hosea Moffitt M000840 | rep | NY | 1815-12-04 | 1817-03-03 | Federalist | 10 | |||||||||||||
1694 | 1694 | Peter Porter P000446 | rep | NY | 1809-05-22 | 1811-03-03 | Republican | 15 | |||||||||||||
1695 | 1695 | Peter Porter P000446 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 15 | |||||||||||||
1696 | 1696 | Peter Porter P000446 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 21 | |||||||||||||
1698 | 1698 | Abraham Schenck S000115 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 4 |
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);