legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
26 rows where party = "Ind. Republican-Democrat" and state = "NY"
This data as json, copyable, CSV (advanced)
Suggested facets: start, start (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6295 | 6295 | Hamilton Fish F000140 | sen | NY | 1851-12-01 | 1857-03-03 | 1 | Ind. Republican-Democrat | |||||||||||||
6786 | 6786 | Thomas Child C000353 | rep | NY | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 7 | |||||||||||||
6787 | 6787 | Bayard Clarke C000457 | rep | NY | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 9 | |||||||||||||
6803 | 6803 | Samuel Dickson D000332 | rep | NY | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 14 | |||||||||||||
6816 | 6816 | Thomas Flagler F000181 | rep | NY | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 31 | |||||||||||||
6825 | 6825 | William Gilbert G000179 | rep | NY | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 23 | |||||||||||||
6836 | 6836 | Solomon Haven H000355 | rep | NY | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 32 | |||||||||||||
6841 | 6841 | Thomas Horton H000799 | rep | NY | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 18 | |||||||||||||
6842 | 6842 | Jonas Hughston H000931 | rep | NY | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 19 | |||||||||||||
6853 | 6853 | Rufus King K000213 | rep | NY | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 11 | |||||||||||||
6871 | 6871 | Andrew McCarty M000319 | rep | NY | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 22 | |||||||||||||
6883 | 6883 | Killian Miller M000744 | rep | NY | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 12 | |||||||||||||
6896 | 6896 | Guy Pelton P000198 | rep | NY | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 3 | |||||||||||||
6902 | 6902 | Benjamin Pringle P000543 | rep | NY | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 30 | |||||||||||||
6912 | 6912 | Russell Sage S000013 | rep | NY | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 13 | |||||||||||||
6919 | 6919 | George Simmons S000416 | rep | NY | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 16 | |||||||||||||
6928 | 6928 | James Stranahan S000990 | rep | NY | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 2 | |||||||||||||
6940 | 6940 | Abram Wakeman W000027 | rep | NY | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 8 | |||||||||||||
6979 | 6979 | Henry Bennett B000376 | rep | NY | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 21 | |||||||||||||
7029 | 7029 | Edward Dodd D000389 | rep | NY | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 15 | |||||||||||||
7063 | 7063 | Amos Granger G000373 | rep | NY | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 24 | |||||||||||||
7154 | 7154 | Orsamus Matteson M000251 | rep | NY | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 20 | |||||||||||||
7160 | 7160 | Edwin Morgan M000948 | rep | NY | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 25 | |||||||||||||
7167 | 7167 | Ambrose Murray M001105 | rep | NY | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 10 | |||||||||||||
7178 | 7178 | John Parker P000064 | rep | NY | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 27 | |||||||||||||
8654 | 8654 | William Kelsey K000080 | rep | NY | 1855-12-03 | 1857-03-03 | Ind. Republican-Democrat | 28 |
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);