legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
1,837 rows where party = "Democrat" and state = "NY"
This data as json, copyable, CSV (advanced)
Suggested facets: class, phone, fax, state_rank, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4130 | 4130 | John Andrews A000246 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 27 | |||||||||||||
4131 | 4131 | Cyrus Beers B000311 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 22 | |||||||||||||
4132 | 4132 | Bennet Bicknell B000437 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 23 | |||||||||||||
4133 | 4133 | Samuel Birdsall B000483 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 25 | |||||||||||||
4144 | 4144 | John Brodhead B000859 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 7 | |||||||||||||
4145 | 4145 | Isaac Bronson B000869 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 18 | |||||||||||||
4146 | 4146 | Andrew Bruyn B000984 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 22 | |||||||||||||
4153 | 4153 | Churchill Cambreleng C000061 | rep | NY | 1823-12-01 | 1825-03-03 | Democrat | 3 | |||||||||||||
4160 | 4160 | Churchill Cambreleng C000061 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 3 | |||||||||||||
4195 | 4195 | John De Graff D000193 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 11 | |||||||||||||
4197 | 4197 | John Edwards E000073 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 15 | |||||||||||||
4204 | 4204 | Albert Gallup G000028 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 10 | |||||||||||||
4210 | 4210 | Abraham Grant G000380 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 17 | |||||||||||||
4213 | 4213 | Hiram Gray G000397 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 22 | |||||||||||||
4262 | 4262 | Arphaxed Loomis L000437 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 16 | |||||||||||||
4291 | 4291 | Ely Moore M000897 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 3 | |||||||||||||
4303 | 4303 | William Noble N000120 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 24 | |||||||||||||
4309 | 4309 | John Palmer P000041 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 13 | |||||||||||||
4310 | 4310 | Amasa Parker P000054 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 20 | |||||||||||||
4355 | 4355 | James Spencer S000725 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 14 | |||||||||||||
4366 | 4366 | William Taylor T000103 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 23 | |||||||||||||
4367 | 4367 | Obadiah Titus T000288 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 5 | |||||||||||||
4368 | 4368 | Henry Vail V000002 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 9 | |||||||||||||
4369 | 4369 | Abraham Vanderveer V000030 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 2 | |||||||||||||
4393 | 4393 | Judson Allen A000137 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 20 | |||||||||||||
4455 | 4455 | James De La Montanya D000205 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 2 | |||||||||||||
4465 | 4465 | Nehemiah Earll E000012 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 23 | |||||||||||||
4466 | 4466 | John Ely E000166 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 8 | |||||||||||||
4467 | 4467 | John Fine F000125 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 14 | |||||||||||||
4499 | 4499 | Augustus Hand H000152 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 13 | |||||||||||||
4519 | 4519 | Thomas Jackson J000027 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 1 | |||||||||||||
4520 | 4520 | Thomas Jackson J000027 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 1 | |||||||||||||
4526 | 4526 | Nathaniel Jones J000243 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 6 | |||||||||||||
4527 | 4527 | Nathaniel Jones J000243 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 6 | |||||||||||||
4528 | 4528 | Gouverneur Kemble K000084 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 4 | |||||||||||||
4529 | 4529 | Gouverneur Kemble K000084 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 4 | |||||||||||||
4538 | 4538 | Stephen Leonard L000249 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 22 | |||||||||||||
4539 | 4539 | Meredith Mallory M000081 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 27 | |||||||||||||
4579 | 4579 | John Prentiss P000509 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 19 | |||||||||||||
4580 | 4580 | John Prentiss P000509 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 19 | |||||||||||||
4602 | 4602 | Edward Rogers R000393 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 23 | |||||||||||||
4619 | 4619 | Theron Strong S001020 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 25 | |||||||||||||
4622 | 4622 | Nathaniel Tallmadge T000032 | sen | NY | 1833-12-02 | 1839-03-03 | 1 | Democrat | |||||||||||||
4631 | 4631 | Aaron Vanderpoel V000028 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 8 | |||||||||||||
4704 | 4704 | Samuel Bowne B000708 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 19 | |||||||||||||
4705 | 4705 | David Brewster B000814 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 17 | |||||||||||||
4706 | 4706 | David Brewster B000814 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 17 | |||||||||||||
4745 | 4745 | John Clark C000443 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 21 | |||||||||||||
4765 | 4765 | Andrew Doig D000400 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 16 | |||||||||||||
4766 | 4766 | Andrew Doig D000400 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 16 | |||||||||||||
4772 | 4772 | Joseph Egbert E000088 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 2 | |||||||||||||
4788 | 4788 | Charles Ferris F000090 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 3 | |||||||||||||
4789 | 4789 | Charles Floyd F000219 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 1 | |||||||||||||
4835 | 4835 | Jacob Houck H000810 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 8 | |||||||||||||
4889 | 4889 | Robert McClellan M000333 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 8 | |||||||||||||
4890 | 4890 | Robert McClellan M000333 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 8 | |||||||||||||
4897 | 4897 | John McKeon M000509 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 3 | |||||||||||||
4927 | 4927 | William Oliver O000078 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 27 | |||||||||||||
4931 | 4931 | Samuel Partridge P000093 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 22 | |||||||||||||
4968 | 4968 | Lewis Riggs R000255 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 22 | |||||||||||||
4979 | 4979 | James Roosevelt R000427 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 3 | |||||||||||||
4988 | 4988 | John Sanford S000048 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 15 | |||||||||||||
5043 | 5043 | John Van Buren V000015 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 7 | |||||||||||||
5053 | 5053 | Aaron Ward W000125 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 4 | |||||||||||||
5130 | 5130 | Samuel Beardsley B000281 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 20 | |||||||||||||
5159 | 5159 | Levi Carpenter C000169 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 20 | |||||||||||||
5160 | 5160 | Jeremiah Cary C000215 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 21 | |||||||||||||
5167 | 5167 | James Clinton C000528 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 6 | |||||||||||||
5168 | 5168 | James Clinton C000528 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 9 | |||||||||||||
5183 | 5183 | Amasa Dana D000020 | rep | NY | 1839-12-02 | 1841-03-03 | Democrat | 22 | |||||||||||||
5184 | 5184 | Amasa Dana D000020 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 26 | |||||||||||||
5185 | 5185 | Richard Davis D000128 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 5 | |||||||||||||
5186 | 5186 | Richard Davis D000128 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 8 | |||||||||||||
5196 | 5196 | Chesselden Ellis E000131 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 16 | |||||||||||||
5206 | 5206 | Byram Green G000406 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 27 | |||||||||||||
5218 | 5218 | William Hubbell H000895 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 30 | |||||||||||||
5244 | 5244 | Moses Leonard L000248 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 5 | |||||||||||||
5264 | 5264 | Zadock Pratt P000507 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 8 | |||||||||||||
5265 | 5265 | Zadock Pratt P000507 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 11 | |||||||||||||
5267 | 5267 | Smith Purdy P000571 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 22 | |||||||||||||
5276 | 5276 | Orville Robinson R000351 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 23 | |||||||||||||
5280 | 5280 | Jeremiah Russell R000528 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 10 | |||||||||||||
5304 | 5304 | Lemuel Stetson S000874 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 15 | |||||||||||||
5308 | 5308 | Selah Strong S001016 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 1 | |||||||||||||
5335 | 5335 | Silas Wright W000770 | sen | NY | 1837-09-04 | 1843-03-03 | 3 | Democrat | |||||||||||||
5336 | 5336 | Silas Wright W000770 | sen | NY | 1843-12-04 | 1845-03-03 | 3 | Democrat | |||||||||||||
5337 | 5337 | Daniel Dickinson D000317 | sen | NY | 1844-11-30 | 1845-03-03 | 1 | Democrat | |||||||||||||
5338 | 5338 | Daniel Dickinson D000317 | sen | NY | 1845-03-04 | 1851-03-03 | 1 | Democrat | |||||||||||||
5339 | 5339 | Henry Foster F000304 | rep | NY | 1837-09-04 | 1839-03-03 | Democrat | 17 | |||||||||||||
5340 | 5340 | Henry Foster F000304 | sen | NY | 1844-01-01 | 1845-12-31 | 3 | Democrat | |||||||||||||
5355 | 5355 | Joseph Anderson A000198 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 7 | |||||||||||||
5356 | 5356 | Joseph Anderson A000198 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 7 | |||||||||||||
5359 | 5359 | Charles Benton B000394 | rep | NY | 1843-12-04 | 1845-03-03 | Democrat | 17 | |||||||||||||
5360 | 5360 | Charles Benton B000394 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 17 | |||||||||||||
5387 | 5387 | John Collin C000632 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 11 | |||||||||||||
5408 | 5408 | John De Mott D000223 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 27 | |||||||||||||
5411 | 5411 | John Dix D000365 | sen | NY | 1845-12-01 | 1849-03-03 | 3 | Democrat | |||||||||||||
5416 | 5416 | Samuel Ellsworth E000149 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 26 | |||||||||||||
5426 | 5426 | Samuel Gordon G000315 | rep | NY | 1841-05-31 | 1843-03-03 | Democrat | 20 | |||||||||||||
5427 | 5427 | Samuel Gordon G000315 | rep | NY | 1845-12-01 | 1847-03-03 | Democrat | 10 |
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);