legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
142 rows where party = "Jackson" and state = "NY"
This data as json, copyable, CSV (advanced)
Suggested facets: start, end, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2555 | 2555 | Henry Ashley A000313 | rep | NY | 1825-12-05 | 1827-03-03 | Jackson | 11 | |||||||||||||
2584 | 2584 | William Dietz D000342 | rep | NY | 1825-12-05 | 1827-03-03 | Jackson | 12 | |||||||||||||
2646 | 2646 | Charles Kellogg K000063 | rep | NY | 1825-12-05 | 1827-03-03 | Jackson | 24 | |||||||||||||
2726 | 2726 | Egbert Ten Eyck T000125 | rep | NY | 1825-12-05 | 1827-03-03 | Jackson | 20 | |||||||||||||
2797 | 2797 | George Belden B000324 | rep | NY | 1827-12-03 | 1829-03-03 | Jackson | 7 | |||||||||||||
2811 | 2811 | Rudolph Bunner B001065 | rep | NY | 1827-12-03 | 1829-03-03 | Jackson | 20 | |||||||||||||
2847 | 2847 | Nathaniel Garrow G000085 | rep | NY | 1827-12-03 | 1829-03-03 | Jackson | 24 | |||||||||||||
2850 | 2850 | John Hallock H000082 | rep | NY | 1825-12-05 | 1827-03-03 | Jackson | 6 | |||||||||||||
2851 | 2851 | John Hallock H000082 | rep | NY | 1827-12-03 | 1829-03-03 | Jackson | 6 | |||||||||||||
2858 | 2858 | Selah Hobbie H000662 | rep | NY | 1827-12-03 | 1829-03-03 | Jackson | 11 | |||||||||||||
2863 | 2863 | Jeromus Johnson J000152 | rep | NY | 1825-12-05 | 1827-03-03 | Jackson | 3 | |||||||||||||
2864 | 2864 | Jeromus Johnson J000152 | rep | NY | 1827-12-03 | 1829-03-03 | Jackson | 3 | |||||||||||||
2865 | 2865 | Richard Keese K000043 | rep | NY | 1827-12-03 | 1829-03-03 | Jackson | 19 | |||||||||||||
2922 | 2922 | Thomas Oakley O000003 | rep | NY | 1827-12-03 | 1829-03-03 | Jackson | 5 | |||||||||||||
2971 | 2971 | John Stower S000986 | rep | NY | 1827-12-03 | 1829-03-03 | Jackson | 22 | |||||||||||||
2972 | 2972 | Thomas Taber T000003 | rep | NY | 1827-12-03 | 1829-03-03 | Jackson | 5 | |||||||||||||
3001 | 3001 | John Wood W000697 | rep | NY | 1827-12-03 | 1829-03-03 | Jackson | 2 | |||||||||||||
3058 | 3058 | Peter Borst B000645 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 12 | |||||||||||||
3070 | 3070 | Hector Craig C000856 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 6 | |||||||||||||
3071 | 3071 | Jacob Crocheron C000915 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 2 | |||||||||||||
3076 | 3076 | Charles De Witt D000284 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 7 | |||||||||||||
3089 | 3089 | Charles Dudley D000511 | sen | NY | 1829-12-07 | 1833-03-03 | 1 | Jackson | |||||||||||||
3097 | 3097 | Jonas Earll E000011 | rep | NY | 1827-12-03 | 1829-03-03 | Jackson | 23 | |||||||||||||
3098 | 3098 | Jonas Earll E000011 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 23 | |||||||||||||
3114 | 3114 | Jehiel Halsey H000088 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 26 | |||||||||||||
3158 | 3158 | Perkins King K000209 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 11 | |||||||||||||
3169 | 3169 | John Magee M000047 | rep | NY | 1827-12-03 | 1829-03-03 | Jackson | 28 | |||||||||||||
3170 | 3170 | John Magee M000047 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 28 | |||||||||||||
3174 | 3174 | Thomas Maxwell M000271 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 25 | |||||||||||||
3184 | 3184 | Robert Monell M000853 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 21 | |||||||||||||
3185 | 3185 | Ebenezer Norton N000146 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 30 | |||||||||||||
3190 | 3190 | Gershom Powers P000489 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 24 | |||||||||||||
3201 | 3201 | Jonah Sanford S000050 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 20 | |||||||||||||
3302 | 3302 | William Angel A000256 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 13 | |||||||||||||
3303 | 3303 | William Angel A000256 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 13 | |||||||||||||
3316 | 3316 | John Bergen B000405 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 2 | |||||||||||||
3318 | 3318 | Joseph Bouck B000659 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 12 | |||||||||||||
3363 | 3363 | Charles Dayan D000162 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 20 | |||||||||||||
3409 | 3409 | Michael Hoffman H000688 | rep | NY | 1825-12-05 | 1827-03-03 | Jackson | 15 | |||||||||||||
3410 | 3410 | Michael Hoffman H000688 | rep | NY | 1827-12-03 | 1829-03-03 | Jackson | 15 | |||||||||||||
3411 | 3411 | Michael Hoffman H000688 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 15 | |||||||||||||
3412 | 3412 | Michael Hoffman H000688 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 15 | |||||||||||||
3413 | 3413 | William Hogan H000694 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 19 | |||||||||||||
3435 | 3435 | Freeborn Jewett J000104 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 23 | |||||||||||||
3448 | 3448 | John King K000204 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 8 | |||||||||||||
3455 | 3455 | James Lent L000242 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 1 | |||||||||||||
3456 | 3456 | James Lent L000242 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 1 | |||||||||||||
3464 | 3464 | William Marcy M000127 | sen | NY | 1831-12-05 | 1833-12-31 | 3 | Jackson | |||||||||||||
3526 | 3526 | Nathaniel Pitcher P000367 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 18 | |||||||||||||
3535 | 3535 | Edward Reed R000115 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 22 | |||||||||||||
3540 | 3540 | Erastus Root R000431 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 11 | |||||||||||||
3545 | 3545 | Nathan Soule S000681 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 16 | |||||||||||||
3576 | 3576 | Gulian Verplanck V000089 | rep | NY | 1825-12-05 | 1827-03-03 | Jackson | 3 | |||||||||||||
3577 | 3577 | Gulian Verplanck V000089 | rep | NY | 1827-12-03 | 1829-03-03 | Jackson | 3 | |||||||||||||
3578 | 3578 | Gulian Verplanck V000089 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 3 | |||||||||||||
3579 | 3579 | Gulian Verplanck V000089 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 3 | |||||||||||||
3593 | 3593 | John Adams A000038 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 8 | |||||||||||||
3625 | 3625 | Charles Bodle B000585 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 7 | |||||||||||||
3660 | 3660 | Rowland Day D000159 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 24 | |||||||||||||
3699 | 3699 | Nicoll Halsey H000089 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 22 | |||||||||||||
3702 | 3702 | Samuel Hathaway H000345 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 22 | |||||||||||||
3704 | 3704 | Edward Howell H000860 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 27 | |||||||||||||
3707 | 3707 | Noadiah Johnson J000164 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 20 | |||||||||||||
3719 | 3719 | Cornelius Lawrence L000131 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
3754 | 3754 | Charles McVean M000607 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 15 | |||||||||||||
3756 | 3756 | Henry Mitchell M000813 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 21 | |||||||||||||
3761 | 3761 | John Morgan M000953 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
3767 | 3767 | Job Pierson P000343 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 9 | |||||||||||||
3768 | 3768 | Job Pierson P000343 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 9 | |||||||||||||
3791 | 3791 | Dudley Selden S000233 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 3 | |||||||||||||
3813 | 3813 | Isaac Van Houten V000046 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 2 | |||||||||||||
3816 | 3816 | Reuben Whallon W000321 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 13 | |||||||||||||
3844 | 3844 | Samuel Barton B000215 | rep | NY | 1835-12-07 | 1837-03-03 | Jackson | 2 | |||||||||||||
3849 | 3849 | Abraham Bockee B000581 | rep | NY | 1829-12-07 | 1831-03-03 | Jackson | 5 | |||||||||||||
3850 | 3850 | Abraham Bockee B000581 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 5 | |||||||||||||
3851 | 3851 | Abraham Bockee B000581 | rep | NY | 1835-12-07 | 1837-03-03 | Jackson | 5 | |||||||||||||
3852 | 3852 | Matthias Bovee B000675 | rep | NY | 1835-12-07 | 1837-03-03 | Jackson | 15 | |||||||||||||
3855 | 3855 | John Brown B000932 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 6 | |||||||||||||
3856 | 3856 | John Brown B000932 | rep | NY | 1835-12-07 | 1837-03-03 | Jackson | 6 | |||||||||||||
3866 | 3866 | Graham Chapin C000306 | rep | NY | 1835-12-07 | 1837-03-03 | Jackson | 25 | |||||||||||||
3878 | 3878 | John Cramer C000867 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 11 | |||||||||||||
3879 | 3879 | John Cramer C000867 | rep | NY | 1835-12-07 | 1837-03-03 | Jackson | 11 | |||||||||||||
3894 | 3894 | Ulysses Doubleday D000444 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 24 | |||||||||||||
3895 | 3895 | Ulysses Doubleday D000444 | rep | NY | 1835-12-07 | 1837-03-03 | Jackson | 24 | |||||||||||||
3898 | 3898 | Valentine Efner E000086 | rep | NY | 1835-12-07 | 1837-03-03 | Jackson | 8 | |||||||||||||
3900 | 3900 | Dudley Farlin F000022 | rep | NY | 1835-12-07 | 1837-03-03 | Jackson | 13 | |||||||||||||
3907 | 3907 | William Fuller F000415 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 23 | |||||||||||||
3908 | 3908 | William Fuller F000415 | rep | NY | 1835-12-07 | 1837-03-03 | Jackson | 23 | |||||||||||||
3909 | 3909 | Ransom Gillet G000200 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 14 | |||||||||||||
3910 | 3910 | Ransom Gillet G000200 | rep | NY | 1835-12-07 | 1837-03-03 | Jackson | 14 | |||||||||||||
3944 | 3944 | Abel Huntington H000994 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 1 | |||||||||||||
3945 | 3945 | Abel Huntington H000994 | rep | NY | 1835-12-07 | 1837-03-03 | Jackson | 1 | |||||||||||||
3983 | 3983 | Gerrit Lansing L000086 | rep | NY | 1831-12-05 | 1833-03-03 | Jackson | 10 | |||||||||||||
3984 | 3984 | Gerrit Lansing L000086 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 10 | |||||||||||||
3985 | 3985 | Gerrit Lansing L000086 | rep | NY | 1835-12-07 | 1837-03-03 | Jackson | 10 | |||||||||||||
3992 | 3992 | Gideon Lee L000193 | rep | NY | 1835-12-07 | 1837-03-03 | Jackson | 3 | |||||||||||||
3993 | 3993 | Joshua Lee L000197 | rep | NY | 1835-12-07 | 1837-03-03 | Jackson | 27 | |||||||||||||
4002 | 4002 | Abijah Mann M000099 | rep | NY | 1833-12-02 | 1835-03-03 | Jackson | 16 | |||||||||||||
4003 | 4003 | Abijah Mann M000099 | rep | NY | 1835-12-07 | 1837-03-03 | Jackson | 16 | |||||||||||||
4011 | 4011 | William Mason M000227 | rep | NY | 1835-12-07 | 1837-03-03 | Jackson | 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);