legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
36 rows where "start" is on date 1897-03-15 and state = "NY"
This data as json, copyable, CSV (advanced)
Suggested facets: type, start (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13253 | 13253 | James Belden B000325 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 27 | |||||||||||||
13254 | 13254 | Joseph Belford B000327 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13259 | 13259 | Charles Bennett B000372 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 5 | |||||||||||||
13264 | 13264 | Henry Brewster B000815 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 31 | |||||||||||||
13305 | 13305 | Israel Fischer F000138 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 4 | |||||||||||||
13307 | 13307 | Wallace Foote F000252 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 23 | |||||||||||||
13353 | 13353 | James Howe H000852 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 6 | |||||||||||||
13357 | 13357 | Denis Hurley H001004 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
13383 | 13383 | Philip Low L000471 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 15 | |||||||||||||
13388 | 13388 | Rowland Mahany M000062 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 32 | |||||||||||||
13424 | 13424 | John Mitchell M000822 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 8 | |||||||||||||
13441 | 13441 | Benjamin Odell O000036 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 17 | |||||||||||||
13458 | 13458 | Lemuel Quigg Q000011 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 14 | |||||||||||||
13473 | 13473 | Richard Shannon S000288 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 13 | |||||||||||||
13514 | 13514 | John Vehslage V000080 | rep | NY | 1897-03-15 | 1899-03-03 | Democrat | 7 | |||||||||||||
13527 | 13527 | William Ward W000144 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 16 | |||||||||||||
13533 | 13533 | David Wilber W000453 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 21 | |||||||||||||
13536 | 13536 | Francis Wilson W000579 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 3 | |||||||||||||
13589 | 13589 | Thomas Bradley B000746 | rep | NY | 1897-03-15 | 1899-03-03 | Democrat | 9 | |||||||||||||
13609 | 13609 | Charles Chickering C000351 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 24 | |||||||||||||
13614 | 13614 | Aaron Cochrane C000568 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 19 | |||||||||||||
13652 | 13652 | Edmund Driggs D000497 | rep | NY | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
13716 | 13716 | Warren Hooker H000760 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 34 | |||||||||||||
13927 | 13927 | Amos Cummings C000983 | rep | NY | 1897-03-15 | 1899-03-03 | Democrat | 10 | |||||||||||||
14133 | 14133 | George Ray R000076 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 26 | |||||||||||||
14327 | 14327 | Charles Gillet G000199 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 29 | |||||||||||||
14402 | 14402 | George McClellan M000331 | rep | NY | 1897-03-15 | 1899-03-03 | Democrat | 12 | |||||||||||||
14441 | 14441 | Thomas Platt P000383 | sen | NY | 1897-03-15 | 1903-03-03 | 3 | Republican | |||||||||||||
14752 | 14752 | John Ketcham K000152 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 18 | |||||||||||||
14781 | 14781 | Lucius Littauer L000347 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 22 | |||||||||||||
14937 | 14937 | James Wadsworth W000011 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 30 | |||||||||||||
15280 | 15280 | James Sherman S000345 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 25 | |||||||||||||
15323 | 15323 | De Alexander A000091 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 33 | |||||||||||||
15740 | 15740 | George Southwick S000691 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 20 | |||||||||||||
16196 | 16196 | William Sulzer S001065 | rep | NY | 1897-03-15 | 1899-03-03 | Democrat | 11 | |||||||||||||
16515 | 16515 | Sereno Payne P000153 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 28 |
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);