legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
47 rows where "end" is on date 1921-03-03 and state = "NY"
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17593 | 17593 | Charles Caldwell C000030 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 2 | |||||||||||||
17646 | 17646 | Jerome Donovan D000423 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 21 | |||||||||||||
17650 | 17650 | Peter Dooling D000426 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 15 | |||||||||||||
17734 | 17734 | Henry Goldfogle G000260 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 12 | |||||||||||||
17764 | 17764 | Reuben Haskell H000319 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
17775 | 17775 | William Hill H000610 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 34 | |||||||||||||
17787 | 17787 | John Johnston J000190 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 5 | |||||||||||||
17818 | 17818 | John MacCrate M000002 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 3 | |||||||||||||
17823 | 17823 | James Maher M000063 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 7 | |||||||||||||
17831 | 17831 | Richard McKiniry M000517 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 23 | |||||||||||||
17881 | 17881 | Herbert Pell P000194 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 17 | |||||||||||||
17889 | 17889 | Edmund Platt P000379 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 26 | |||||||||||||
17904 | 17904 | Joseph Rowan R000472 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 19 | |||||||||||||
17907 | 17907 | Frederick Rowe R000476 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 6 | |||||||||||||
17912 | 17912 | Rollin Sanford S000053 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 28 | |||||||||||||
17957 | 17957 | Thomas Smith S000619 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 16 | |||||||||||||
18156 | 18156 | Thomas Dunn D000553 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 38 | |||||||||||||
18205 | 18205 | Norman Gould G000342 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 36 | |||||||||||||
18223 | 18223 | Frederick Hicks H000564 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 1 | |||||||||||||
18227 | 18227 | Alanson Houghton H000813 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 37 | |||||||||||||
18234 | 18234 | James Husted H001005 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 25 | |||||||||||||
18474 | 18474 | Isaac Siegel S000404 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 20 | |||||||||||||
18536 | 18536 | Lester Volk V000111 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 10 | |||||||||||||
18652 | 18652 | James Ganly G000038 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 24 | |||||||||||||
18776 | 18776 | Luther Mott M001041 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 32 | |||||||||||||
18826 | 18826 | Daniel Riordan R000264 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 11 | |||||||||||||
18858 | 18858 | Homer Snyder S000666 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 33 | |||||||||||||
18878 | 18878 | Charles Ward W000129 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 27 | |||||||||||||
18928 | 18928 | William Cleary C000500 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 8 | |||||||||||||
19054 | 19054 | Nathan Perlman P000239 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 14 | |||||||||||||
19401 | 19401 | Clarence MacGregor M000009 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 41 | |||||||||||||
19420 | 19420 | Walter Magee M000049 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 35 | |||||||||||||
19610 | 19610 | John Carew C000142 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 18 | |||||||||||||
19651 | 19651 | Stephen Dempsey D000229 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 40 | |||||||||||||
19904 | 19904 | David O’Connell O000022 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 9 | |||||||||||||
20621 | 20621 | Fiorello La Guardia L000007 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 14 | |||||||||||||
20826 | 20826 | Archie Sanders S000032 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 39 | |||||||||||||
21467 | 21467 | James Parker P000062 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 29 | |||||||||||||
21781 | 21781 | Anthony Griffin G000457 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 22 | |||||||||||||
22418 | 22418 | Bertrand Snell S000652 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 31 | |||||||||||||
22793 | 22793 | Christopher Sullivan S001051 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 13 | |||||||||||||
22945 | 22945 | Frank Crowther C000948 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 30 | |||||||||||||
23128 | 23128 | James Mead M000615 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 42 | |||||||||||||
23394 | 23394 | Thomas Cullen C000970 | rep | NY | 1919-05-19 | 1921-03-03 | Democrat | 4 | |||||||||||||
23453 | 23453 | Hamilton Fish F000142 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 26 | |||||||||||||
25048 | 25048 | James Wadsworth W000012 | sen | NY | 1915-12-06 | 1921-03-03 | 3 | Republican | |||||||||||||
26950 | 26950 | Daniel Reed R000113 | rep | NY | 1919-05-19 | 1921-03-03 | Republican | 43 |
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);