legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
37 rows where "start" is on date 1885-12-07 and state = "NY"
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10952 | 10952 | John Adams A000040 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 7 | |||||||||||||
10960 | 10960 | John Arnot A000301 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 28 | |||||||||||||
10967 | 10967 | Lewis Beach B000263 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 15 | |||||||||||||
10985 | 10985 | Henry Burleigh B001106 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 18 | |||||||||||||
11018 | 11018 | Abraham Dowdney D000465 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 12 | |||||||||||||
11035 | 11035 | William Evarts E000262 | sen | NY | 1885-12-07 | 1891-03-03 | 3 | Republican | |||||||||||||
11082 | 11082 | Abram Hewitt H000552 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 10 | |||||||||||||
11091 | 11091 | Darwin James J000048 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 3 | |||||||||||||
11093 | 11093 | Frederick Johnson J000131 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 21 | |||||||||||||
11108 | 11108 | James Lindsley L000329 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 17 | |||||||||||||
11129 | 11129 | Stephen Millard M000711 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 26 | |||||||||||||
11161 | 11161 | Joseph Pulitzer P000568 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 9 | |||||||||||||
11184 | 11184 | Walter Sessions S000251 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 34 | |||||||||||||
11202 | 11202 | John Spriggs S000754 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 23 | |||||||||||||
11220 | 11220 | John Swinburne S001120 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 19 | |||||||||||||
11240 | 11240 | Egbert Viele V000097 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 13 | |||||||||||||
11291 | 11291 | Perry Belmont B000353 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 1 | |||||||||||||
11297 | 11297 | Archibald Bliss B000558 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 5 | |||||||||||||
11329 | 11329 | Ira Davenport D000072 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 29 | |||||||||||||
11400 | 11400 | Frank Hiscock H000643 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 25 | |||||||||||||
11440 | 11440 | Peter Mahoney M000068 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 4 | |||||||||||||
11448 | 11448 | Truman Merriman M000658 | rep | NY | 1885-12-07 | 1887-03-03 | Ind. Democrat | 11 | |||||||||||||
11468 | 11468 | Abraham Parker P000053 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 22 | |||||||||||||
11537 | 11537 | John Weber W000236 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 33 | |||||||||||||
11540 | 11540 | George West W000302 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 20 | |||||||||||||
11572 | 11572 | Charles Baker B000057 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 30 | |||||||||||||
11645 | 11645 | Felix Campbell C000082 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 2 | |||||||||||||
11703 | 11703 | Samuel Cox C000839 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 9 | |||||||||||||
11749 | 11749 | John Farquhar F000027 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 32 | |||||||||||||
11904 | 11904 | John Pindar P000359 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 24 | |||||||||||||
11953 | 11953 | John Sawyer S000088 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 31 | |||||||||||||
12076 | 12076 | Henry Bacon B000016 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 15 | |||||||||||||
12298 | 12298 | William Stahlnecker S000781 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 14 | |||||||||||||
12471 | 12471 | Timothy Campbell C000103 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 8 | |||||||||||||
14104 | 14104 | Nicholas Muller M001071 | rep | NY | 1885-12-07 | 1887-03-03 | Democrat | 6 | |||||||||||||
14748 | 14748 | John Ketcham K000152 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 16 | |||||||||||||
16510 | 16510 | Sereno Payne P000153 | rep | NY | 1885-12-07 | 1887-03-03 | Republican | 27 |
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);