legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
174 rows where party = "Whig", state = "NY" and type = "rep"
This data as json, copyable, CSV (advanced)
Suggested facets: start, end, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2507 | 2507 | Albert Tracy T000343 | rep | NY | 1823-12-01 | 1825-03-03 | Whig | 30 | |||||||||||||
3906 | 3906 | Philo Fuller F000411 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 30 | |||||||||||||
3918 | 3918 | Gideon Hard H000180 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 33 | |||||||||||||
3932 | 3932 | Abner Hazeltine H000416 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 31 | |||||||||||||
3989 | 3989 | George Lay L000150 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 29 | |||||||||||||
3996 | 3996 | Thomas Love L000459 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 32 | |||||||||||||
4311 | 4311 | William Patterson P000133 | rep | NY | 1837-09-04 | 1839-03-03 | Whig | 29 | |||||||||||||
4346 | 4346 | Mark Sibley S000399 | rep | NY | 1837-09-04 | 1839-03-03 | Whig | 26 | |||||||||||||
4409 | 4409 | Anson Brown B000901 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 11 | |||||||||||||
4448 | 4448 | Edward Curtis C001009 | rep | NY | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4449 | 4449 | Edward Curtis C001009 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4462 | 4462 | Nicholas Doe D000398 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 11 | |||||||||||||
4491 | 4491 | Moses Grinnell G000479 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4514 | 4514 | Josiah Hoffman H000687 | rep | NY | 1837-09-04 | 1839-03-03 | Whig | 3 | |||||||||||||
4515 | 4515 | Josiah Hoffman H000687 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4525 | 4525 | Charles Johnston J000184 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 5 | |||||||||||||
4530 | 4530 | Thomas Kempshall K000087 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 28 | |||||||||||||
4540 | 4540 | Richard Marvin M000211 | rep | NY | 1837-09-04 | 1839-03-03 | Whig | 31 | |||||||||||||
4541 | 4541 | Richard Marvin M000211 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 31 | |||||||||||||
4558 | 4558 | Charles Mitchell M000806 | rep | NY | 1837-09-04 | 1839-03-03 | Whig | 33 | |||||||||||||
4559 | 4559 | Charles Mitchell M000806 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 33 | |||||||||||||
4560 | 4560 | James Monroe M000856 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 3 | |||||||||||||
4568 | 4568 | Rufus Palen P000032 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 7 | |||||||||||||
4573 | 4573 | Luther Peck P000179 | rep | NY | 1837-09-04 | 1839-03-03 | Whig | 30 | |||||||||||||
4574 | 4574 | Luther Peck P000179 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 30 | |||||||||||||
4603 | 4603 | David Russell R000524 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 12 | |||||||||||||
4604 | 4604 | David Russell R000524 | rep | NY | 1837-09-04 | 1839-03-03 | Whig | 12 | |||||||||||||
4605 | 4605 | David Russell R000524 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 12 | |||||||||||||
4637 | 4637 | Peter Wagner W000020 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 15 | |||||||||||||
4681 | 4681 | Alfred Babcock B000003 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 33 | |||||||||||||
4696 | 4696 | Victory Birdseye B000484 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 23 | |||||||||||||
4698 | 4698 | Bernard Blair B000522 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 12 | |||||||||||||
4736 | 4736 | Timothy Childs C000355 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 28 | |||||||||||||
4737 | 4737 | Timothy Childs C000355 | rep | NY | 1837-09-04 | 1839-03-03 | Whig | 28 | |||||||||||||
4738 | 4738 | Timothy Childs C000355 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 28 | |||||||||||||
4739 | 4739 | Thomas Chittenden C000374 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 18 | |||||||||||||
4740 | 4740 | Thomas Chittenden C000374 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 18 | |||||||||||||
4746 | 4746 | John Clark C000443 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 21 | |||||||||||||
4747 | 4747 | John Clark C000443 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 21 | |||||||||||||
4748 | 4748 | Staley Clarke C000471 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 31 | |||||||||||||
4792 | 4792 | A. Foster F000296 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 23 | |||||||||||||
4801 | 4801 | Seth Gates G000097 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 29 | |||||||||||||
4802 | 4802 | Seth Gates G000097 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 29 | |||||||||||||
4808 | 4808 | Francis Granger G000376 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 26 | |||||||||||||
4809 | 4809 | Francis Granger G000376 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 26 | |||||||||||||
4810 | 4810 | Francis Granger G000376 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 26 | |||||||||||||
4811 | 4811 | John Greig G000449 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 26 | |||||||||||||
4836 | 4836 | Hiram Hunt H000970 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 9 | |||||||||||||
4837 | 4837 | Hiram Hunt H000970 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 9 | |||||||||||||
4838 | 4838 | Hiram Hunt H000970 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 9 | |||||||||||||
4863 | 4863 | Archibald Linn L000335 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 11 | |||||||||||||
4885 | 4885 | John Maynard M000285 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 25 | |||||||||||||
4907 | 4907 | Christopher Morgan M000945 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 24 | |||||||||||||
4908 | 4908 | Christopher Morgan M000945 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 24 | |||||||||||||
5036 | 5036 | Thomas Tomlinson T000301 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 13 | |||||||||||||
5044 | 5044 | Henry Van Rensselaer V000052 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 14 | |||||||||||||
5093 | 5093 | John Young Y000042 | rep | NY | 1835-12-07 | 1837-03-03 | Whig | 30 | |||||||||||||
5094 | 5094 | John Young Y000042 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 30 | |||||||||||||
5124 | 5124 | Daniel Barnard B000152 | rep | NY | 1839-12-02 | 1841-03-03 | Whig | 10 | |||||||||||||
5125 | 5125 | Daniel Barnard B000152 | rep | NY | 1841-05-31 | 1843-03-03 | Whig | 10 | |||||||||||||
5126 | 5126 | Daniel Barnard B000152 | rep | NY | 1843-12-04 | 1845-03-03 | Whig | 13 | |||||||||||||
5262 | 5262 | Thomas Patterson P000129 | rep | NY | 1843-12-04 | 1845-03-03 | Whig | 28 | |||||||||||||
5279 | 5279 | Charles Rogers R000390 | rep | NY | 1843-12-04 | 1845-03-03 | Whig | 14 | |||||||||||||
5312 | 5312 | Asher Tyler T000447 | rep | NY | 1843-12-04 | 1845-03-03 | Whig | 31 | |||||||||||||
5374 | 5374 | Charles Carroll C000186 | rep | NY | 1843-12-04 | 1845-03-03 | Whig | 29 | |||||||||||||
5375 | 5375 | Charles Carroll C000186 | rep | NY | 1845-12-01 | 1847-03-03 | Whig | 29 | |||||||||||||
5394 | 5394 | Erastus Culver C000978 | rep | NY | 1845-12-01 | 1847-03-03 | Whig | 14 | |||||||||||||
5438 | 5438 | Richard Herrick H000541 | rep | NY | 1845-12-01 | 1847-03-03 | Whig | 12 | |||||||||||||
5469 | 5469 | Abner Lewis L000270 | rep | NY | 1845-12-01 | 1847-03-03 | Whig | 31 | |||||||||||||
5485 | 5485 | William Moseley M001024 | rep | NY | 1843-12-04 | 1845-03-03 | Whig | 32 | |||||||||||||
5486 | 5486 | William Moseley M001024 | rep | NY | 1845-12-01 | 1847-03-03 | Whig | 32 | |||||||||||||
5508 | 5508 | Thomas Ripley R000267 | rep | NY | 1845-12-01 | 1847-03-03 | Whig | 12 | |||||||||||||
5519 | 5519 | Albert Smith S000512 | rep | NY | 1843-12-04 | 1845-03-03 | Whig | 33 | |||||||||||||
5520 | 5520 | Albert Smith S000512 | rep | NY | 1845-12-01 | 1847-03-03 | Whig | 33 | |||||||||||||
5621 | 5621 | Esbon Blackmar B000513 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 27 | |||||||||||||
5707 | 5707 | Horace Greeley G000405 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 6 | |||||||||||||
5711 | 5711 | Nathan Hall H000062 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 32 | |||||||||||||
5720 | 5720 | John Holley H000723 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 27 | |||||||||||||
5721 | 5721 | Elias Holmes H000736 | rep | NY | 1845-12-01 | 1847-03-03 | Whig | 28 | |||||||||||||
5722 | 5722 | Elias Holmes H000736 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 28 | |||||||||||||
5730 | 5730 | Washington Hunt H000978 | rep | NY | 1843-12-04 | 1845-03-03 | Whig | 34 | |||||||||||||
5731 | 5731 | Washington Hunt H000978 | rep | NY | 1845-12-01 | 1847-03-03 | Whig | 34 | |||||||||||||
5732 | 5732 | Washington Hunt H000978 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 34 | |||||||||||||
5754 | 5754 | William Lawrence L000142 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 26 | |||||||||||||
5774 | 5774 | Dudley Marvin M000208 | rep | NY | 1823-12-01 | 1825-03-03 | Whig | 26 | |||||||||||||
5777 | 5777 | Dudley Marvin M000208 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 31 | |||||||||||||
5795 | 5795 | Joseph Mullin M001072 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 19 | |||||||||||||
5815 | 5815 | Eliakim Sherrill S000351 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 10 | |||||||||||||
5821 | 5821 | John Slingerland S000488 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 13 | |||||||||||||
5826 | 5826 | Daniel St. John S000766 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 9 | |||||||||||||
5839 | 5839 | Frederick Tallmadge T000030 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 5 | |||||||||||||
5853 | 5853 | Cornelius Warren W000162 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 8 | |||||||||||||
5890 | 5890 | Henry Alexander A000093 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 17 | |||||||||||||
5893 | 5893 | George Andrews A000245 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 14 | |||||||||||||
5903 | 5903 | David Bokee B000599 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 2 | |||||||||||||
5927 | 5927 | Charles Clarke C000459 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 19 | |||||||||||||
5942 | 5942 | Harmon Conger C000676 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 25 | |||||||||||||
5943 | 5943 | Harmon Conger C000676 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 25 | |||||||||||||
5968 | 5968 | William Duer D000515 | rep | NY | 1847-12-06 | 1849-03-03 | Whig | 23 | |||||||||||||
5969 | 5969 | William Duer D000515 | rep | NY | 1849-12-03 | 1851-03-03 | Whig | 23 |
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);