legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,736 rows where party = "Republican" and state = "NY"
This data as json, copyable, CSV (advanced)
Suggested facets: class, contact_form, rss_url, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34 | 34 | Aaron Burr B001133 | sen | NY | 1791-10-24 | 1797-03-03 | 1 | Republican | |||||||||||||
171 | 171 | John Hathorn H000348 | rep | NY | 1789-03-04 | 1791-03-03 | Republican | 4 | |||||||||||||
172 | 172 | John Hathorn H000348 | rep | NY | 1795-12-07 | 1797-03-03 | Republican | 4 | |||||||||||||
382 | 382 | Jonathan Havens H000359 | rep | NY | 1795-12-07 | 1797-03-03 | Republican | 2 | |||||||||||||
383 | 383 | Jonathan Havens H000359 | rep | NY | 1797-05-15 | 1799-03-03 | Republican | 2 | |||||||||||||
384 | 384 | Jonathan Havens H000359 | rep | NY | 1799-12-02 | 1801-03-03 | Republican | 2 | |||||||||||||
469 | 469 | Lucas Elmendorf E000153 | rep | NY | 1797-05-15 | 1799-03-03 | Republican | 4 | |||||||||||||
470 | 470 | Lucas Elmendorf E000153 | rep | NY | 1799-12-02 | 1801-03-03 | Republican | 4 | |||||||||||||
471 | 471 | Lucas Elmendorf E000153 | rep | NY | 1801-12-07 | 1803-03-03 | Republican | 4 | |||||||||||||
541 | 541 | John Van Ness V000049 | rep | NY | 1801-12-07 | 1803-03-03 | Republican | 6 | |||||||||||||
551 | 551 | De Clinton C000525 | sen | NY | 1802-01-01 | 1803-12-31 | 3 | Republican | |||||||||||||
554 | 554 | Theodorus Bailey B000049 | rep | NY | 1795-12-07 | 1797-03-03 | Republican | 5 | |||||||||||||
555 | 555 | Theodorus Bailey B000049 | rep | NY | 1799-12-02 | 1801-03-03 | Republican | 5 | |||||||||||||
556 | 556 | Theodorus Bailey B000049 | rep | NY | 1801-12-07 | 1803-03-03 | Republican | 5 | |||||||||||||
557 | 557 | Theodorus Bailey B000049 | sen | NY | 1803-10-17 | 1805-03-03 | 1 | Republican | |||||||||||||
599 | 599 | Andrew McCord M000359 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 5 | |||||||||||||
603 | 603 | Beriah Palmer P000036 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 11 | |||||||||||||
604 | 604 | John Paterson P000101 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 16 | |||||||||||||
605 | 605 | Oliver Phelps P000298 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 17 | |||||||||||||
641 | 641 | John Armstrong A000282 | sen | NY | 1800-11-06 | 1801-03-03 | 3 | Republican | |||||||||||||
642 | 642 | John Armstrong A000282 | sen | NY | 1801-03-04 | 1802-02-05 | 3 | Republican | |||||||||||||
643 | 643 | John Armstrong A000282 | sen | NY | 1804-02-25 | 1804-06-30 | 1 | Republican | |||||||||||||
706 | 706 | Silas Halsey H000090 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 17 | |||||||||||||
742 | 742 | Peter Sailly S000015 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 11 | |||||||||||||
745 | 745 | Martin Schuneman S000149 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 7 | |||||||||||||
784 | 784 | Eliphalet Wickes W000440 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 1 | |||||||||||||
785 | 785 | Nathan Williams W000531 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 15 | |||||||||||||
804 | 804 | John Blake B000533 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 5 | |||||||||||||
805 | 805 | John Blake B000533 | rep | NY | 1807-10-26 | 1809-03-03 | Republican | 5 | |||||||||||||
822 | 822 | George Clinton C000526 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 3 | |||||||||||||
823 | 823 | George Clinton C000526 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 2 | |||||||||||||
824 | 824 | George Clinton C000526 | rep | NY | 1807-10-26 | 1809-03-03 | Republican | 2 | |||||||||||||
854 | 854 | John Harris H000245 | rep | NY | 1807-10-26 | 1809-03-03 | Republican | 17 | |||||||||||||
859 | 859 | Reuben Humphrey H000957 | rep | NY | 1807-10-26 | 1809-03-03 | Republican | 16 | |||||||||||||
864 | 864 | William Kirkpatrick K000239 | rep | NY | 1807-10-26 | 1809-03-03 | Republican | 15 | |||||||||||||
868 | 868 | Josiah Masters M000232 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 10 | |||||||||||||
869 | 869 | Josiah Masters M000232 | rep | NY | 1807-10-26 | 1809-03-03 | Republican | 10 | |||||||||||||
885 | 885 | Samuel Riker R000257 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 1 | |||||||||||||
886 | 886 | Samuel Riker R000257 | rep | NY | 1807-10-26 | 1809-03-03 | Republican | 1 | |||||||||||||
887 | 887 | John Russell R000529 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 14 | |||||||||||||
888 | 888 | John Russell R000529 | rep | NY | 1807-10-26 | 1809-03-03 | Republican | 14 | |||||||||||||
893 | 893 | John Smith S000566 | rep | NY | 1799-12-02 | 1801-03-03 | Republican | 1 | |||||||||||||
894 | 894 | John Smith S000566 | rep | NY | 1801-12-07 | 1803-03-03 | Republican | 1 | |||||||||||||
895 | 895 | John Smith S000566 | sen | NY | 1804-01-01 | 1807-03-03 | 3 | Republican | |||||||||||||
896 | 896 | John Smith S000566 | sen | NY | 1807-10-26 | 1813-03-03 | 3 | Republican | |||||||||||||
898 | 898 | Peter Swart S001096 | rep | NY | 1807-10-26 | 1809-03-03 | Republican | 13 | |||||||||||||
899 | 899 | David Thomas T000163 | rep | NY | 1801-12-07 | 1803-03-03 | Republican | 7 | |||||||||||||
900 | 900 | David Thomas T000163 | rep | NY | 1803-10-17 | 1805-03-03 | Republican | 12 | |||||||||||||
901 | 901 | David Thomas T000163 | rep | NY | 1805-12-02 | 1807-03-03 | Republican | 12 | |||||||||||||
902 | 902 | David Thomas T000163 | rep | NY | 1807-10-26 | 1809-03-03 | Republican | 12 | |||||||||||||
910 | 910 | James Van Alen V000011 | rep | NY | 1807-10-26 | 1809-03-03 | Republican | 8 | |||||||||||||
911 | 911 | Philip Van Cortlandt V000022 | rep | NY | 1793-12-02 | 1795-03-03 | Republican | 3 | |||||||||||||
912 | 912 | Philip Van Cortlandt V000022 | rep | NY | 1795-12-07 | 1797-03-03 | Republican | 3 | |||||||||||||
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 | |||||||||||||
974 | 974 | Obadiah German G000136 | sen | NY | 1809-05-22 | 1815-03-03 | 1 | Republican | |||||||||||||
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 | |||||||||||||
1139 | 1139 | Thomas Cooke C000734 | rep | NY | 1811-11-04 | 1813-03-03 | Republican | 5 | |||||||||||||
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 | |||||||||||||
1327 | 1327 | Peter Denoyelles D000252 | rep | NY | 1813-05-24 | 1815-03-03 | Republican | 3 | |||||||||||||
1347 | 1347 | Abraham Hasbrouck H000313 | rep | NY | 1813-05-24 | 1815-03-03 | Republican | 7 | |||||||||||||
1372 | 1372 | John Lefferts L000213 | rep | NY | 1813-05-24 | 1815-03-03 | Republican | 1 | |||||||||||||
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 | |||||||||||||
1501 | 1501 | Archibald Clarke C000456 | rep | NY | 1815-12-04 | 1817-03-03 | Republican | 21 |
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);