legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
46 rows where "start" is on date 1929-04-15 and state = "NY"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19615 | 19615 | John Carew C000142 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 18 | |||||||||||||
19656 | 19656 | Stephen Dempsey D000229 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 40 | |||||||||||||
19908 | 19908 | David O’Connell O000022 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 9 | |||||||||||||
19938 | 19938 | John Quayle Q000008 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 7 | |||||||||||||
20028 | 20028 | Jonathan Wainwright W000023 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 25 | |||||||||||||
20038 | 20038 | Royal Weller W000277 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | -1 | |||||||||||||
20228 | 20228 | Edmund Cooke C000730 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 41 | |||||||||||||
20283 | 20283 | Frederick Davenport D000070 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 33 | |||||||||||||
20625 | 20625 | Fiorello La Guardia L000007 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 20 | |||||||||||||
20776 | 20776 | Harcourt Pratt P000499 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 27 | |||||||||||||
20778 | 20778 | Ruth Pratt P000505 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 17 | |||||||||||||
20831 | 20831 | Archie Sanders S000032 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 39 | |||||||||||||
21124 | 21124 | Loring Black B000505 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 5 | |||||||||||||
21187 | 21187 | Patrick Carley C000149 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 8 | |||||||||||||
21202 | 21202 | John Clarke C000465 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 34 | |||||||||||||
21376 | 21376 | George Lindsay L000325 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 3 | |||||||||||||
21456 | 21456 | Frank Oliver O000072 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 23 | |||||||||||||
21472 | 21472 | James Parker P000062 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 29 | |||||||||||||
21502 | 21502 | Anning Prall P000495 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 11 | |||||||||||||
21554 | 21554 | Gale Stalker S000783 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 37 | |||||||||||||
21600 | 21600 | James Whitley W000420 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 38 | |||||||||||||
21657 | 21657 | William Brunner B000981 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 2 | |||||||||||||
21722 | 21722 | Royal Copeland C000769 | sen | NY | 1929-04-15 | 1935-01-03 | 1 | Democrat | |||||||||||||
21727 | 21727 | Parker Corning C000785 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 28 | |||||||||||||
21786 | 21786 | Anthony Griffin G000457 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 22 | |||||||||||||
22030 | 22030 | Robert Bacon B000019 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 1 | |||||||||||||
22057 | 22057 | John Boylan B000726 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 15 | |||||||||||||
22347 | 22347 | John O’Connor O000030 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 16 | |||||||||||||
22423 | 22423 | Bertrand Snell S000652 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 31 | |||||||||||||
22776 | 22776 | William Sirovich S000452 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 14 | |||||||||||||
22798 | 22798 | Christopher Sullivan S001051 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 13 | |||||||||||||
22950 | 22950 | Frank Crowther C000948 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 30 | |||||||||||||
23133 | 23133 | James Mead M000615 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 42 | |||||||||||||
23386 | 23386 | Francis Culkin C000968 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 32 | |||||||||||||
23399 | 23399 | Thomas Cullen C000970 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 4 | |||||||||||||
23458 | 23458 | Hamilton Fish F000142 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 26 | |||||||||||||
23467 | 23467 | James Fitzpatrick F000175 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 24 | |||||||||||||
23497 | 23497 | Joseph Gavagan G000101 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 21 | |||||||||||||
23556 | 23556 | Martin Kennedy K000111 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 18 | |||||||||||||
23829 | 23829 | Samuel Dickstein D000335 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 12 | |||||||||||||
23856 | 23856 | Clarence Hancock H000146 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 35 | |||||||||||||
24762 | 24762 | Sol Bloom B000565 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 19 | |||||||||||||
25029 | 25029 | Andrew Somers S000676 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 6 | |||||||||||||
26955 | 26955 | Daniel Reed R000113 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 43 | |||||||||||||
27552 | 27552 | John Taber T000001 | rep | NY | 1929-04-15 | 1931-03-03 | Republican | 36 | |||||||||||||
29674 | 29674 | Emanuel Celler C000264 | rep | NY | 1929-04-15 | 1931-03-03 | Democrat | 10 |
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);