legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
48 rows where "start" is on date 1933-03-09 and state = "NY"
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21126 | 21126 | Loring Black B000505 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 5 | |||||||||||||
21189 | 21189 | Patrick Carley C000149 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 8 | |||||||||||||
21204 | 21204 | John Clarke C000465 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 34 | |||||||||||||
21205 | 21205 | Marian Clarke C000467 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 34 | |||||||||||||
21258 | 21258 | John Fitzgibbons F000171 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21378 | 21378 | George Lindsay L000325 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 3 | |||||||||||||
21458 | 21458 | Frank Oliver O000072 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 23 | |||||||||||||
21474 | 21474 | James Parker P000062 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 29 | |||||||||||||
21504 | 21504 | Anning Prall P000495 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 11 | |||||||||||||
21556 | 21556 | Gale Stalker S000783 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 37 | |||||||||||||
21571 | 21571 | Elmer Studley S001041 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 0 | |||||||||||||
21602 | 21602 | James Whitley W000420 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 38 | |||||||||||||
21659 | 21659 | William Brunner B000981 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 2 | |||||||||||||
21729 | 21729 | Parker Corning C000785 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 28 | |||||||||||||
21788 | 21788 | Anthony Griffin G000457 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 22 | |||||||||||||
21948 | 21948 | Stephen Rudd R000496 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 9 | |||||||||||||
21969 | 21969 | Frederick Sisson S000455 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 33 | |||||||||||||
21972 | 21972 | William Thomas T000187 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 29 | |||||||||||||
22032 | 22032 | Robert Bacon B000019 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 1 | |||||||||||||
22059 | 22059 | John Boylan B000726 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 15 | |||||||||||||
22182 | 22182 | Philip Goodwin G000302 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 27 | |||||||||||||
22264 | 22264 | James Lanzetta L000091 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 20 | |||||||||||||
22305 | 22305 | Charles Millard M000709 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 25 | |||||||||||||
22349 | 22349 | John O’Connor O000030 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 16 | |||||||||||||
22370 | 22370 | Theodore Peyser P000281 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 17 | |||||||||||||
22425 | 22425 | Bertrand Snell S000652 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 31 | |||||||||||||
22778 | 22778 | William Sirovich S000452 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 14 | |||||||||||||
22800 | 22800 | Christopher Sullivan S001051 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 13 | |||||||||||||
22867 | 22867 | Alfred Beiter B000320 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 41 | |||||||||||||
22952 | 22952 | Frank Crowther C000948 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 30 | |||||||||||||
23135 | 23135 | James Mead M000615 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 42 | |||||||||||||
23388 | 23388 | Francis Culkin C000968 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 32 | |||||||||||||
23401 | 23401 | Thomas Cullen C000970 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 4 | |||||||||||||
23460 | 23460 | Hamilton Fish F000142 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 26 | |||||||||||||
23469 | 23469 | James Fitzpatrick F000175 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 24 | |||||||||||||
23499 | 23499 | Joseph Gavagan G000101 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 21 | |||||||||||||
23558 | 23558 | Martin Kennedy K000111 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 18 | |||||||||||||
23831 | 23831 | Samuel Dickstein D000335 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 12 | |||||||||||||
23858 | 23858 | Clarence Hancock H000146 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 35 | |||||||||||||
24180 | 24180 | Robert Wagner W000021 | sen | NY | 1933-03-09 | 1939-01-03 | 3 | Democrat | |||||||||||||
24253 | 24253 | Walter Andrews A000250 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 40 | |||||||||||||
24341 | 24341 | John Delaney D000212 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 7 | |||||||||||||
24764 | 24764 | Sol Bloom B000565 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 19 | |||||||||||||
25031 | 25031 | Andrew Somers S000676 | rep | NY | 1933-03-09 | 1935-01-03 | Democrat | 6 | |||||||||||||
25050 | 25050 | James Wadsworth W000012 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 39 | |||||||||||||
26957 | 26957 | Daniel Reed R000113 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 43 | |||||||||||||
27554 | 27554 | John Taber T000001 | rep | NY | 1933-03-09 | 1935-01-03 | Republican | 36 | |||||||||||||
29676 | 29676 | Emanuel Celler C000264 | rep | NY | 1933-03-09 | 1935-01-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);