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 party
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10 | 10 | William Floyd F000224 | rep | NY | 1789-03-04 | 1791-03-03 | 1 | ||||||||||||||
27 | 27 | Jeremiah Van Rensselaer V000053 | rep | NY | 1789-03-04 | 1791-03-03 | 6 | ||||||||||||||
49 | 49 | Cornelius Schoonmaker S000140 | rep | NY | 1791-10-24 | 1793-03-03 | 4 | ||||||||||||||
55 | 55 | Peter Silvester S000412 | rep | NY | 1789-03-04 | 1791-03-03 | 5 | ||||||||||||||
56 | 56 | Peter Silvester S000412 | rep | NY | 1791-10-24 | 1793-03-03 | 5 | ||||||||||||||
95 | 95 | James Gordon G000311 | rep | NY | 1791-10-24 | 1793-03-03 | 6 | ||||||||||||||
96 | 96 | James Gordon G000311 | rep | NY | 1793-12-02 | 1795-03-03 | 9 | ||||||||||||||
122 | 122 | Silas Talbot T000019 | rep | NY | 1793-12-02 | 1795-03-03 | 10 | ||||||||||||||
123 | 123 | Thomas Tredwell T000361 | rep | NY | 1791-10-24 | 1793-03-03 | 1 | ||||||||||||||
124 | 124 | Thomas Tredwell T000361 | rep | NY | 1793-12-02 | 1795-03-03 | 2 | ||||||||||||||
125 | 125 | Peter Van Gaasbeck V000039 | rep | NY | 1793-12-02 | 1795-03-03 | 4 | ||||||||||||||
135 | 135 | John Watts W000211 | rep | NY | 1793-12-02 | 1795-03-03 | 1 | ||||||||||||||
235 | 235 | John Laurance L000120 | rep | NY | 1789-03-04 | 1791-03-03 | 2 | ||||||||||||||
236 | 236 | John Laurance L000120 | rep | NY | 1791-10-24 | 1793-03-03 | 2 | ||||||||||||||
553 | 553 | Theodorus Bailey B000049 | rep | NY | 1793-12-02 | 1795-03-03 | 5 | ||||||||||||||
969 | 969 | William Denning D000240 | rep | NY | 1809-05-22 | 1811-03-03 | -1 | ||||||||||||||
2333 | 2333 | Selah Tuthill T000438 | rep | NY | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2387 | 2387 | John Cady C000015 | rep | NY | 1823-12-01 | 1825-03-03 | 16 | ||||||||||||||
2394 | 2394 | Lot Clark C000447 | rep | NY | 1823-12-01 | 1825-03-03 | 21 | ||||||||||||||
2395 | 2395 | Ela Collins C000635 | rep | NY | 1823-12-01 | 1825-03-03 | 20 | ||||||||||||||
2401 | 2401 | Justin Dwinell D000584 | rep | NY | 1823-12-01 | 1825-03-03 | 22 | ||||||||||||||
2411 | 2411 | Charles Foote F000249 | rep | NY | 1823-12-01 | 1825-03-03 | 11 | ||||||||||||||
2426 | 2426 | James Hogeboom H000700 | rep | NY | 1823-12-01 | 1825-03-03 | 9 | ||||||||||||||
2431 | 2431 | Lemuel Jenkins J000085 | rep | NY | 1823-12-01 | 1825-03-03 | 7 | ||||||||||||||
2434 | 2434 | Samuel Lawrence L000138 | rep | NY | 1823-12-01 | 1825-03-03 | 25 | ||||||||||||||
2439 | 2439 | Elisha Litchfield L000346 | rep | NY | 1823-12-01 | 1825-03-03 | 23 | ||||||||||||||
2473 | 2473 | John Richards R000216 | rep | NY | 1823-12-01 | 1825-03-03 | 19 | ||||||||||||||
2475 | 2475 | William Rochester R000360 | rep | NY | 1823-12-01 | 1825-03-03 | -1 | ||||||||||||||
2484 | 2484 | Peter Sharpe S000297 | rep | NY | 1821-12-03 | 1823-03-03 | -1 | ||||||||||||||
2485 | 2485 | Peter Sharpe S000297 | rep | NY | 1823-12-01 | 1825-03-03 | 3 | ||||||||||||||
2511 | 2511 | Jacob Tyson T000453 | rep | NY | 1823-12-01 | 1825-03-03 | 2 | ||||||||||||||
2521 | 2521 | William Van Wyck V000068 | rep | NY | 1823-12-01 | 1825-03-03 | 5 | ||||||||||||||
2540 | 2540 | William Woods W000727 | rep | NY | 1823-12-01 | 1825-03-03 | 28 | ||||||||||||||
2545 | 2545 | Parmenio Adams A000042 | rep | NY | 1823-12-01 | 1825-03-03 | 29 | ||||||||||||||
2625 | 2625 | Moses Hayden H000387 | rep | NY | 1823-12-01 | 1825-03-03 | 27 | ||||||||||||||
2725 | 2725 | Egbert Ten Eyck T000125 | rep | NY | 1823-12-01 | 1825-03-03 | 20 | ||||||||||||||
2835 | 2835 | David Evans E000237 | rep | NY | 1827-12-03 | 1829-03-03 | -1 | ||||||||||||||
2984 | 2984 | Stephen Van Rensselaer V000056 | rep | NY | 1823-12-01 | 1825-03-03 | 10 | ||||||||||||||
3004 | 3004 | Silas Wood W000703 | rep | NY | 1823-12-01 | 1825-03-03 | 1 | ||||||||||||||
3034 | 3034 | Benedict Arnold A000287 | rep | NY | 1829-12-07 | 1831-03-03 | 16 | ||||||||||||||
3068 | 3068 | Henry Cowles C000828 | rep | NY | 1829-12-07 | 1831-03-03 | 4 | ||||||||||||||
3085 | 3085 | John Dickinson D000322 | rep | NY | 1829-12-07 | 1831-03-03 | 9 | ||||||||||||||
3096 | 3096 | Samuel Eager E000002 | rep | NY | 1829-12-07 | 1831-03-03 | 6 | ||||||||||||||
3099 | 3099 | Isaac Finch F000117 | rep | NY | 1829-12-07 | 1831-03-03 | 19 | ||||||||||||||
3100 | 3100 | George Fisher F000146 | rep | NY | 1829-12-07 | 1831-03-03 | 20 | ||||||||||||||
3216 | 3216 | Ambrose Spencer S000721 | rep | NY | 1829-12-07 | 1831-03-03 | 10 | ||||||||||||||
3232 | 3232 | James Strong S001010 | rep | NY | 1823-12-01 | 1825-03-03 | 8 | ||||||||||||||
3235 | 3235 | James Strong S001010 | rep | NY | 1829-12-07 | 1831-03-03 | 8 | ||||||||||||||
2546 | 2546 | Parmenio Adams A000042 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 29 | |||||||||||||
2556 | 2556 | Luther Badger B000023 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 23 | |||||||||||||
2603 | 2603 | Nicoll Fosdick F000292 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 20 | |||||||||||||
2624 | 2624 | Abraham Hasbrouck H000312 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 7 | |||||||||||||
2626 | 2626 | Moses Hayden H000387 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 27 | |||||||||||||
2638 | 2638 | Daniel Hugunin H000932 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 20 | |||||||||||||
2639 | 2639 | Charles Humphrey H000950 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 25 | |||||||||||||
2684 | 2684 | William McManus M000562 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 9 | |||||||||||||
2690 | 2690 | John Miller M000737 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 22 | |||||||||||||
2703 | 2703 | Timothy Porter P000448 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 28 | |||||||||||||
2709 | 2709 | Henry Ross R000447 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 19 | |||||||||||||
2713 | 2713 | Joshua Sands S000046 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 2 | |||||||||||||
2734 | 2734 | Bartow White W000356 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 5 | |||||||||||||
2735 | 2735 | Elias Whitmore W000423 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 21 | |||||||||||||
2758 | 2758 | Nathan Sanford S000052 | sen | NY | 1826-01-01 | 1831-03-03 | 3 | Adams | |||||||||||||
2819 | 2819 | Samuel Chase C000333 | rep | NY | 1827-12-03 | 1829-03-03 | Adams | 13 | |||||||||||||
2845 | 2845 | Daniel Garnsey G000078 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 30 | |||||||||||||
2846 | 2846 | Daniel Garnsey G000078 | rep | NY | 1827-12-03 | 1829-03-03 | Adams | 30 | |||||||||||||
2887 | 2887 | Henry Markell M000131 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 16 | |||||||||||||
2888 | 2888 | Henry Markell M000131 | rep | NY | 1827-12-03 | 1829-03-03 | Adams | 16 | |||||||||||||
2985 | 2985 | Stephen Van Rensselaer V000056 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 10 | |||||||||||||
2986 | 2986 | Stephen Van Rensselaer V000056 | rep | NY | 1827-12-03 | 1829-03-03 | Adams | 10 | |||||||||||||
3005 | 3005 | Silas Wood W000703 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 1 | |||||||||||||
3006 | 3006 | Silas Wood W000703 | rep | NY | 1827-12-03 | 1829-03-03 | Adams | 1 | |||||||||||||
3008 | 3008 | David Woodcock W000712 | rep | NY | 1827-12-03 | 1829-03-03 | Adams | 25 | |||||||||||||
3084 | 3084 | John Dickinson D000322 | rep | NY | 1827-12-03 | 1829-03-03 | Adams | 9 | |||||||||||||
3199 | 3199 | Robert Rose R000439 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 26 | |||||||||||||
3228 | 3228 | Henry Storrs S000976 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 14 | |||||||||||||
3229 | 3229 | Henry Storrs S000976 | rep | NY | 1827-12-03 | 1829-03-03 | Adams | 14 | |||||||||||||
3233 | 3233 | James Strong S001010 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 8 | |||||||||||||
3234 | 3234 | James Strong S001010 | rep | NY | 1827-12-03 | 1829-03-03 | Adams | 8 | |||||||||||||
3301 | 3301 | William Angel A000256 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 13 | |||||||||||||
3558 | 3558 | John Taylor T000091 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 17 | |||||||||||||
3559 | 3559 | John Taylor T000091 | rep | NY | 1827-12-03 | 1829-03-03 | Adams | 17 | |||||||||||||
3573 | 3573 | Phineas Tracy T000346 | rep | NY | 1827-12-03 | 1829-03-03 | Adams | 29 | |||||||||||||
3742 | 3742 | Henry Martindale M000204 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 18 | |||||||||||||
3743 | 3743 | Henry Martindale M000204 | rep | NY | 1827-12-03 | 1829-03-03 | Adams | 18 | |||||||||||||
4884 | 4884 | John Maynard M000285 | rep | NY | 1827-12-03 | 1829-03-03 | Adams | 26 | |||||||||||||
5048 | 5048 | Aaron Ward W000125 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 4 | |||||||||||||
5049 | 5049 | Aaron Ward W000125 | rep | NY | 1827-12-03 | 1829-03-03 | Adams | 4 | |||||||||||||
5123 | 5123 | Daniel Barnard B000152 | rep | NY | 1827-12-03 | 1829-03-03 | Adams | 27 | |||||||||||||
5775 | 5775 | Dudley Marvin M000208 | rep | NY | 1825-12-05 | 1827-03-03 | Adams | 26 | |||||||||||||
5776 | 5776 | Dudley Marvin M000208 | rep | NY | 1827-12-03 | 1829-03-03 | Adams | 26 | |||||||||||||
3118 | 3118 | Joseph Hawkins H000371 | rep | NY | 1829-12-07 | 1831-03-03 | Adams Democrat | 20 | |||||||||||||
5373 | 5373 | William Campbell C000105 | rep | NY | 1845-12-01 | 1847-03-03 | American | 6 | |||||||||||||
5482 | 5482 | William Miller M000765 | rep | NY | 1845-12-01 | 1847-03-03 | American | 3 | |||||||||||||
5515 | 5515 | Henry Seaman S000208 | rep | NY | 1845-12-01 | 1847-03-03 | American | 2 | |||||||||||||
5576 | 5576 | Thomas Woodruff W000719 | rep | NY | 1845-12-01 | 1847-03-03 | American | 5 | |||||||||||||
6809 | 6809 | Francis Edwards E000069 | rep | NY | 1855-12-03 | 1857-03-03 | American | 33 | |||||||||||||
6939 | 6939 | William Valk V000007 | rep | NY | 1855-12-03 | 1857-03-03 | American | 1 | |||||||||||||
6952 | 6952 | Thomas Whitney W000425 | rep | NY | 1855-12-03 | 1857-03-03 | American | 5 | |||||||||||||
20623 | 20623 | Fiorello La Guardia L000007 | rep | NY | 1925-12-07 | 1927-03-04 | American Labor | 20 |
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);