legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
40 rows where "start" is on date 1981-01-05 and state = "NY"
This data as json, copyable, CSV (advanced)
Suggested facets: type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32484 | 32484 | Jonathan Bingham B000472 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 22 | |||||||||||||
32548 | 32548 | Gregory Carman C000158 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 3 | |||||||||||||
32555 | 32555 | Shirley Chisholm C000371 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 12 | |||||||||||||
32727 | 32727 | John LeBoutillier L000547 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 6 | |||||||||||||
32732 | 32732 | Gary Lee L000192 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 33 | |||||||||||||
32776 | 32776 | Donald Mitchell M000808 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 31 | |||||||||||||
32800 | 32800 | Peter Peyser P000280 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 23 | |||||||||||||
32841 | 32841 | Frederick Richmond R000232 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 14 | |||||||||||||
32893 | 32893 | Leo Zeferetti Z000002 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 15 | |||||||||||||
32930 | 32930 | Barber Conable C000666 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 35 | |||||||||||||
32970 | 32970 | Geraldine Ferraro F000088 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 9 | |||||||||||||
33078 | 33078 | Richard Ottinger O000134 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 24 | |||||||||||||
33137 | 33137 | Benjamin Rosenthal R000442 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 8 | |||||||||||||
33222 | 33222 | Joseph Addabbo A000052 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 7 | |||||||||||||
33248 | 33248 | William Carney C000165 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 1 | |||||||||||||
33349 | 33349 | Stanley Lundine L000516 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 39 | |||||||||||||
33490 | 33490 | Mario Biaggi B000432 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 10 | |||||||||||||
33632 | 33632 | Jack Kemp K000086 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 38 | |||||||||||||
33773 | 33773 | Samuel Stratton S000997 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 28 | |||||||||||||
33806 | 33806 | George Wortley W000752 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 32 | |||||||||||||
33926 | 33926 | Robert Garcia G000047 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 21 | |||||||||||||
34021 | 34021 | Guy Molinari M000842 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 17 | |||||||||||||
34393 | 34393 | Thomas Downey D000471 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 2 | |||||||||||||
34498 | 34498 | Sedgwick Green G000417 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 18 | |||||||||||||
34572 | 34572 | Frank Horton H000797 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 34 | |||||||||||||
34678 | 34678 | Norman Lent L000243 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 4 | |||||||||||||
34714 | 34714 | David Martin M000174 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 30 | |||||||||||||
34733 | 34733 | Raymond McGrath M000458 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 5 | |||||||||||||
34742 | 34742 | Matthew McHugh M000473 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 27 | |||||||||||||
34791 | 34791 | Henry Nowak N000163 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 37 | |||||||||||||
34935 | 34935 | James Scheuer S000124 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 11 | |||||||||||||
34978 | 34978 | Stephen Solarz S000673 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 13 | |||||||||||||
35051 | 35051 | Theodore Weiss W000258 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 20 | |||||||||||||
35171 | 35171 | Alfonse D’Amato D000018 | sen | NY | 1981-01-05 | 1987-01-03 | 3 | Republican | |||||||||||||
35238 | 35238 | Hamilton Fish F000141 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 25 | |||||||||||||
36389 | 36389 | Gerald Solomon S000675 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 29 | |||||||||||||
36924 | 36924 | Benjamin Gilman G000212 | rep | NY | 1981-01-05 | 1983-01-03 | Republican | 26 | |||||||||||||
36990 | 36990 | John LaFalce L000556 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 36 | |||||||||||||
40443 | 40443 | Charles Rangel R000053 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 19 | |||||||||||||
43286 | 43286 | Charles Schumer S000148 | rep | NY | 1981-01-05 | 1983-01-03 | Democrat | 16 |
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);