legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
42 rows where "end" is on date 1965-01-03 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26901 | 26901 | Kenneth Keating K000036 | sen | NY | 1959-01-07 | 1965-01-03 | 1 | Republican | |||||||||||||
27634 | 27634 | Robert Barry B000190 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 25 | |||||||||||||
27640 | 27640 | Frank Becker B000292 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 5 | |||||||||||||
27677 | 27677 | Charles Buckley B001024 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 23 | |||||||||||||
27741 | 27741 | Steven Derounian D000266 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 3 | |||||||||||||
27862 | 27862 | James Healey H000424 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 21 | |||||||||||||
27962 | 27962 | Clarence Kilburn K000170 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 31 | |||||||||||||
28019 | 28019 | William Miller M000762 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 40 | |||||||||||||
28082 | 28082 | Harold Ostertag O000121 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 37 | |||||||||||||
28094 | 28094 | John Pillion P000352 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 39 | |||||||||||||
28114 | 28114 | Roy Riehlman R000250 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 34 | |||||||||||||
28176 | 28176 | Katharine St. George S000764 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 27 | |||||||||||||
28262 | 28262 | James Wharton W000323 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 28 | |||||||||||||
28506 | 28506 | Eugene Keogh K000130 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 11 | |||||||||||||
28523 | 28523 | John Lindsay L000326 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 17 | |||||||||||||
28605 | 28605 | Leo O’Brien O000015 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 29 | |||||||||||||
28827 | 28827 | Paul Fino F000137 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 24 | |||||||||||||
28939 | 28939 | Edna Kelly K000070 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 12 | |||||||||||||
28985 | 28985 | Abraham Multer M001074 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 13 | |||||||||||||
29100 | 29100 | Charles Goodell G000282 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 38 | |||||||||||||
29251 | 29251 | Leonard Farbstein F000015 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 19 | |||||||||||||
29288 | 29288 | Jacob Gilbert G000175 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 22 | |||||||||||||
29431 | 29431 | Adam Powell P000477 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 18 | |||||||||||||
29691 | 29691 | Emanuel Celler C000264 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 10 | |||||||||||||
29831 | 29831 | Seymour Halpern H000085 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 6 | |||||||||||||
30022 | 30022 | Alexander Pirnie P000366 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 32 | |||||||||||||
30056 | 30056 | William Ryan R000562 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 20 | |||||||||||||
30217 | 30217 | Hugh Carey C000143 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 15 | |||||||||||||
30331 | 30331 | Thaddeus Dulski D000523 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 41 | |||||||||||||
30427 | 30427 | James Grover G000504 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 2 | |||||||||||||
30517 | 30517 | Carleton King K000195 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 30 | |||||||||||||
30625 | 30625 | Ogden Reid R000150 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 26 | |||||||||||||
30634 | 30634 | Howard Robison R000357 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 33 | |||||||||||||
30651 | 30651 | John Rooney R000424 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 14 | |||||||||||||
31519 | 31519 | James Delaney D000211 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 9 | |||||||||||||
31710 | 31710 | Otis Pike P000348 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 1 | |||||||||||||
32195 | 32195 | John Murphy M001098 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 16 | |||||||||||||
32421 | 32421 | John Wydler W000780 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 4 | |||||||||||||
33128 | 33128 | Benjamin Rosenthal R000442 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 8 | |||||||||||||
33213 | 33213 | Joseph Addabbo A000052 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 7 | |||||||||||||
33764 | 33764 | Samuel Stratton S000997 | rep | NY | 1963-01-09 | 1965-01-03 | Democrat | 35 | |||||||||||||
34563 | 34563 | Frank Horton H000797 | rep | NY | 1963-01-09 | 1965-01-03 | Republican | 36 |
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);