legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
41 rows where "start" is on date 1975-01-14 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30802 | 30802 | Bella Abzug A000018 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 20 | |||||||||||||
30973 | 30973 | James Hastings H000327 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 39 | |||||||||||||
31073 | 31073 | Jacob Javits J000064 | sen | NY | 1975-01-14 | 1981-01-03 | 3 | Republican | |||||||||||||
31417 | 31417 | Herman Badillo B000025 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 21 | |||||||||||||
31525 | 31525 | James Delaney D000211 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 9 | |||||||||||||
31608 | 31608 | Edward Koch K000302 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 18 | |||||||||||||
31705 | 31705 | Edward Pattison P000134 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 29 | |||||||||||||
31716 | 31716 | Otis Pike P000348 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 1 | |||||||||||||
31879 | 31879 | William Walsh W000107 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 33 | |||||||||||||
31917 | 31917 | Jerome Ambro A000170 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 3 | |||||||||||||
32094 | 32094 | James Hanley H000158 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 32 | |||||||||||||
32111 | 32111 | Elizabeth Holtzman H000752 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 16 | |||||||||||||
32171 | 32171 | Robert McEwen M000433 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 30 | |||||||||||||
32201 | 32201 | John Murphy M001098 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 17 | |||||||||||||
32417 | 32417 | Lester Wolff W000680 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 6 | |||||||||||||
32427 | 32427 | John Wydler W000780 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 5 | |||||||||||||
32481 | 32481 | Jonathan Bingham B000472 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 22 | |||||||||||||
32552 | 32552 | Shirley Chisholm C000371 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 12 | |||||||||||||
32773 | 32773 | Donald Mitchell M000808 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 31 | |||||||||||||
32798 | 32798 | Peter Peyser P000280 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 23 | |||||||||||||
32838 | 32838 | Frederick Richmond R000232 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 14 | |||||||||||||
32890 | 32890 | Leo Zeferetti Z000002 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 15 | |||||||||||||
32927 | 32927 | Barber Conable C000666 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 35 | |||||||||||||
33075 | 33075 | Richard Ottinger O000134 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 24 | |||||||||||||
33134 | 33134 | Benjamin Rosenthal R000442 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 8 | |||||||||||||
33219 | 33219 | Joseph Addabbo A000052 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 7 | |||||||||||||
33346 | 33346 | Stanley Lundine L000516 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 39 | |||||||||||||
33487 | 33487 | Mario Biaggi B000432 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 10 | |||||||||||||
33629 | 33629 | Jack Kemp K000086 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 38 | |||||||||||||
33770 | 33770 | Samuel Stratton S000997 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 28 | |||||||||||||
34390 | 34390 | Thomas Downey D000471 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 2 | |||||||||||||
34569 | 34569 | Frank Horton H000797 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 34 | |||||||||||||
34675 | 34675 | Norman Lent L000243 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 4 | |||||||||||||
34739 | 34739 | Matthew McHugh M000473 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 27 | |||||||||||||
34788 | 34788 | Henry Nowak N000163 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 37 | |||||||||||||
34932 | 34932 | James Scheuer S000124 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 11 | |||||||||||||
34975 | 34975 | Stephen Solarz S000673 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 13 | |||||||||||||
35235 | 35235 | Hamilton Fish F000141 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 25 | |||||||||||||
36921 | 36921 | Benjamin Gilman G000212 | rep | NY | 1975-01-14 | 1977-01-03 | Republican | 26 | |||||||||||||
36987 | 36987 | John LaFalce L000556 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 36 | |||||||||||||
40440 | 40440 | Charles Rangel R000053 | rep | NY | 1975-01-14 | 1977-01-03 | Democrat | 19 |
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);