legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
50 rows where "end" is on date 1945-01-03 and state = "NY"
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23352 | 23352 | Thomas Burchill B001072 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 15 | |||||||||||||
23355 | 23355 | Louis Capozzoli C000132 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 13 | |||||||||||||
23393 | 23393 | Francis Culkin C000968 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 32 | |||||||||||||
23406 | 23406 | Thomas Cullen C000970 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
23434 | 23434 | Fred Douglas D000453 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 33 | |||||||||||||
23452 | 23452 | James Fay F000051 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 16 | |||||||||||||
23465 | 23465 | Hamilton Fish F000142 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 26 | |||||||||||||
23474 | 23474 | James Fitzpatrick F000175 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 24 | |||||||||||||
23504 | 23504 | Joseph Gavagan G000101 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 21 | |||||||||||||
23563 | 23563 | Martin Kennedy K000111 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 18 | |||||||||||||
23617 | 23617 | Matthew Merritt M000661 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
23626 | 23626 | Joseph Mruk M001058 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 41 | |||||||||||||
23635 | 23635 | Joseph O’Brien O000014 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 38 | |||||||||||||
23642 | 23642 | James O’Leary O000065 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 11 | |||||||||||||
23681 | 23681 | Winifred Stanley S000798 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 0 | |||||||||||||
23768 | 23768 | Joseph Baldwin B000093 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 17 | |||||||||||||
23774 | 23774 | William Barry B000191 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
23836 | 23836 | Samuel Dickstein D000335 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 12 | |||||||||||||
23863 | 23863 | Clarence Hancock H000146 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 35 | |||||||||||||
24164 | 24164 | James Torrens T000315 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 21 | |||||||||||||
24181 | 24181 | Robert Wagner W000021 | sen | NY | 1939-01-03 | 1945-01-03 | 3 | Democrat | |||||||||||||
24258 | 24258 | Walter Andrews A000250 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 40 | |||||||||||||
24287 | 24287 | Ellsworth Buck B001016 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 11 | |||||||||||||
24346 | 24346 | John Delaney D000212 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
24396 | 24396 | Hadwen Fuller F000404 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 32 | |||||||||||||
24769 | 24769 | Sol Bloom B000565 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 19 | |||||||||||||
24876 | 24876 | Jay Le Fevre L000161 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 27 | |||||||||||||
24905 | 24905 | Walter Lynch L000537 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 22 | |||||||||||||
24914 | 24914 | Vito Marcantonio M000122 | rep | NY | 1943-01-06 | 1945-01-03 | American Labor | 20 | |||||||||||||
24985 | 24985 | Joseph Pfeifer P000285 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
25036 | 25036 | Andrew Somers S000676 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
25055 | 25055 | James Wadsworth W000012 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 39 | |||||||||||||
25167 | 25167 | John Butler B001179 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 42 | |||||||||||||
25174 | 25174 | William Byrne B001214 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 28 | |||||||||||||
25294 | 25294 | Edwin Hall H000050 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 34 | |||||||||||||
25301 | 25301 | Leonard Hall H000060 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 1 | |||||||||||||
25317 | 25317 | James Heffernan H000443 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
25416 | 25416 | Donald O’Toole O000133 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
25969 | 25969 | Ralph Gamble G000031 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 25 | |||||||||||||
26037 | 26037 | Arthur Klein K000261 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 14 | |||||||||||||
26242 | 26242 | William Cole C000617 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 37 | |||||||||||||
26446 | 26446 | Bernard Kearney K000030 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 30 | |||||||||||||
26962 | 26962 | Daniel Reed R000113 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 43 | |||||||||||||
27021 | 27021 | Dean Taylor T000070 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 29 | |||||||||||||
27559 | 27559 | John Taber T000001 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 36 | |||||||||||||
27667 | 27667 | Charles Buckley B001024 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 23 | |||||||||||||
27952 | 27952 | Clarence Kilburn K000170 | rep | NY | 1943-01-06 | 1945-01-03 | Republican | 31 | |||||||||||||
28496 | 28496 | Eugene Keogh K000130 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 9 | |||||||||||||
29681 | 29681 | Emanuel Celler C000264 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 10 | |||||||||||||
30641 | 30641 | John Rooney R000424 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 4 |
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);