legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
103 rows where party = "Federalist" and state = "NY"
This data as json, copyable, CSV (advanced)
Suggested facets: class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
162 | 162 | Ezekiel Gilbert G000173 | rep | NY | 1793-12-02 | 1795-03-03 | Federalist | 6 | |||||||||||||
163 | 163 | Ezekiel Gilbert G000173 | rep | NY | 1795-12-07 | 1797-03-03 | Federalist | 6 | |||||||||||||
237 | 237 | John Laurance L000120 | sen | NY | 1796-01-01 | 1801-03-03 | 3 | Federalist | |||||||||||||
245 | 245 | David Brooks B000875 | rep | NY | 1797-05-15 | 1799-03-03 | Federalist | 5 | |||||||||||||
253 | 253 | James Cochran C000563 | rep | NY | 1797-05-15 | 1799-03-03 | Federalist | 10 | |||||||||||||
269 | 269 | Hezekiah Hosmer H000803 | rep | NY | 1797-05-15 | 1799-03-03 | Federalist | 6 | |||||||||||||
290 | 290 | Philip Schuyler S000154 | sen | NY | 1797-05-15 | 1799-03-03 | 1 | Federalist | |||||||||||||
312 | 312 | John Van Alen V000012 | rep | NY | 1793-12-02 | 1795-03-03 | Federalist | 7 | |||||||||||||
313 | 313 | John Van Alen V000012 | rep | NY | 1795-12-07 | 1797-03-03 | Federalist | 7 | |||||||||||||
314 | 314 | John Van Alen V000012 | rep | NY | 1797-05-15 | 1799-03-03 | Federalist | 7 | |||||||||||||
315 | 315 | John Williams W000513 | rep | NY | 1795-12-07 | 1797-03-03 | Federalist | 9 | |||||||||||||
316 | 316 | John Williams W000513 | rep | NY | 1797-05-15 | 1799-03-03 | Federalist | 9 | |||||||||||||
318 | 318 | John Hobart H000661 | sen | NY | 1798-01-01 | 1799-03-03 | 1 | Federalist | |||||||||||||
319 | 319 | William North N000142 | sen | NY | 1798-01-01 | 1799-03-03 | 1 | Federalist | |||||||||||||
320 | 320 | James Watson W000202 | sen | NY | 1798-01-01 | 1801-03-03 | 1 | Federalist | |||||||||||||
336 | 336 | William Cooper C000764 | rep | NY | 1795-12-07 | 1797-03-03 | Federalist | 10 | |||||||||||||
337 | 337 | William Cooper C000764 | rep | NY | 1799-12-02 | 1801-03-03 | Federalist | 10 | |||||||||||||
366 | 366 | Henry Glen G000235 | rep | NY | 1793-12-02 | 1795-03-03 | Federalist | 8 | |||||||||||||
367 | 367 | Henry Glen G000235 | rep | NY | 1795-12-07 | 1797-03-03 | Federalist | 8 | |||||||||||||
368 | 368 | Henry Glen G000235 | rep | NY | 1797-05-15 | 1799-03-03 | Federalist | 8 | |||||||||||||
369 | 369 | Henry Glen G000235 | rep | NY | 1799-12-02 | 1801-03-03 | Federalist | 8 | |||||||||||||
418 | 418 | Jonas Platt P000381 | rep | NY | 1799-12-02 | 1801-03-03 | Federalist | 9 | |||||||||||||
454 | 454 | Gouverneur Morris M000976 | sen | NY | 1800-01-01 | 1803-03-03 | 1 | Federalist | |||||||||||||
456 | 456 | John Bird B000477 | rep | NY | 1799-12-02 | 1801-03-03 | Federalist | 6 | |||||||||||||
457 | 457 | John Bird B000477 | rep | NY | 1801-12-07 | 1803-03-03 | Federalist | -1 | |||||||||||||
508 | 508 | Thomas Morris M000988 | rep | NY | 1801-12-07 | 1803-03-03 | Federalist | 10 | |||||||||||||
542 | 542 | Benjamin Walker W000046 | rep | NY | 1801-12-07 | 1803-03-03 | Federalist | 9 | |||||||||||||
580 | 580 | Gaylord Griswold G000482 | rep | NY | 1803-10-17 | 1805-03-03 | Federalist | 15 | |||||||||||||
624 | 624 | George Tibbits T000262 | rep | NY | 1803-10-17 | 1805-03-03 | Federalist | 10 | |||||||||||||
723 | 723 | Henry Livingston L000367 | rep | NY | 1803-10-17 | 1805-03-03 | Federalist | 8 | |||||||||||||
724 | 724 | Henry Livingston L000367 | rep | NY | 1805-12-02 | 1807-03-03 | Federalist | 8 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
1343 | 1343 | James Geddes G000116 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 19 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
1481 | 1481 | Daniel Cady C000014 | rep | NY | 1815-12-04 | 1817-03-03 | Federalist | 14 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
1710 | 1710 | William Smith S000638 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 17 | |||||||||||||
1711 | 1711 | William Smith S000638 | rep | NY | 1815-12-04 | 1817-03-03 | Federalist | -1 | |||||||||||||
1820 | 1820 | John Cushman C001019 | rep | NY | 1817-12-01 | 1819-03-03 | Federalist | 10 | |||||||||||||
1885 | 1885 | David Ogden O000043 | rep | NY | 1817-12-01 | 1819-03-03 | Federalist | 18 | |||||||||||||
1918 | 1918 | Philip Schuyler S000153 | rep | NY | 1817-12-01 | 1819-03-03 | Federalist | 5 | |||||||||||||
1943 | 1943 | Rensselaer Westerlo W000309 | rep | NY | 1817-12-01 | 1819-03-03 | Federalist | 9 | |||||||||||||
2051 | 2051 | Rufus King K000212 | sen | NY | 1789-03-04 | 1795-03-03 | 3 | Federalist | |||||||||||||
2052 | 2052 | Rufus King K000212 | sen | NY | 1795-12-07 | 1797-03-03 | 3 | Federalist | |||||||||||||
2053 | 2053 | Rufus King K000212 | sen | NY | 1813-05-24 | 1819-03-03 | 3 | Federalist | |||||||||||||
2054 | 2054 | Rufus King K000212 | sen | NY | 1819-12-06 | 1825-03-03 | 3 | Federalist | |||||||||||||
2149 | 2149 | Randall Street S001002 | rep | NY | 1819-12-06 | 1821-03-03 | Federalist | 4 | |||||||||||||
2220 | 2220 | Cadwallader Colden C000604 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 1 | |||||||||||||
2240 | 2240 | John Gebhard G000114 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 13 | |||||||||||||
2258 | 2258 | Joseph Kirkland K000235 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 16 | |||||||||||||
2298 | 2298 | Walter Patterson P000131 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 5 | |||||||||||||
2324 | 2324 | Charles Ruggles R000501 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 7 | |||||||||||||
2332 | 2332 | Micah Sterling S000871 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 18 | |||||||||||||
2337 | 2337 | Solomon Van Rensselaer V000055 | rep | NY | 1819-12-06 | 1821-03-03 | Federalist | 9 | |||||||||||||
2338 | 2338 | Solomon Van Rensselaer V000055 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 9 | |||||||||||||
2712 | 2712 | Joshua Sands S000046 | rep | NY | 1803-10-17 | 1805-03-03 | Federalist | 2 | |||||||||||||
2921 | 2921 | Thomas Oakley O000003 | rep | NY | 1813-05-24 | 1815-03-03 | Federalist | 4 | |||||||||||||
2983 | 2983 | Stephen Van Rensselaer V000056 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 9 | |||||||||||||
3082 | 3082 | John Dickinson D000322 | rep | NY | 1819-12-06 | 1821-03-03 | Federalist | 10 | |||||||||||||
3083 | 3083 | John Dickinson D000322 | rep | NY | 1821-12-03 | 1823-03-03 | Federalist | 10 | |||||||||||||
3225 | 3225 | Henry Storrs S000976 | rep | NY | 1817-12-01 | 1819-03-03 | Federalist | 16 | |||||||||||||
3226 | 3226 | Henry Storrs S000976 | rep | NY | 1819-12-06 | 1821-03-03 | Federalist | 16 |
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);