legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
32 rows where class = 2 and "end" is on date 1895-03-03
This data as json, copyable, CSV (advanced)
Suggested facets: state, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11638 | 11638 | Matthew Butler B001184 | sen | SC | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
11676 | 11676 | Richard Coke C000601 | sen | TX | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
11680 | 11680 | Alfred Colquitt C000647 | sen | GA | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
11734 | 11734 | Nathan Dixon D000377 | sen | RI | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
11736 | 11736 | Joseph Dolph D000405 | sen | OR | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
11780 | 11780 | Anthony Higgins H000577 | sen | DE | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
11831 | 11831 | Charles Manderson M000095 | sen | NE | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
11852 | 11852 | John McPherson M000593 | sen | NJ | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
11929 | 11929 | Matt Ransom R000062 | sen | NC | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
12016 | 12016 | William Washburn W000175 | sen | MN | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
12047 | 12047 | James Wilson W000594 | sen | IA | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
12055 | 12055 | Joseph Carey C000145 | sen | WY | 1890-11-15 | 1895-03-03 | 2 | Republican | |||||||||||||
12064 | 12064 | Thomas Power P000486 | sen | MT | 1890-01-01 | 1895-03-03 | 2 | Republican | |||||||||||||
12376 | 12376 | Eppa Hunton H000999 | sen | VA | 1892-01-01 | 1895-03-03 | 2 | Democrat | |||||||||||||
12468 | 12468 | Johnson Camden C000062 | sen | WV | 1893-08-07 | 1895-03-03 | 2 | Democrat | |||||||||||||
12680 | 12680 | John Martin M000185 | sen | KS | 1893-08-07 | 1895-03-03 | 2 | Democrat | |||||||||||||
12885 | 12885 | Patrick Walsh W000103 | sen | GA | 1894-01-01 | 1895-03-03 | 2 | Democrat | |||||||||||||
12932 | 12932 | Donelson Caffery C000016 | sen | LA | 1892-01-01 | 1895-03-03 | 2 | Democrat | |||||||||||||
12935 | 12935 | William Chandler C000298 | sen | NH | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
13025 | 13025 | Isham Harris H000243 | sen | TN | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
13067 | 13067 | William Lindsay L000327 | sen | KY | 1893-08-07 | 1895-03-03 | 2 | Democrat | |||||||||||||
13118 | 13118 | Richard Pettigrew P000271 | sen | SD | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
13160 | 13160 | George Shoup S000382 | sen | ID | 1890-01-01 | 1895-03-03 | 2 | Republican | |||||||||||||
13202 | 13202 | Edward Walthall W000111 | sen | MS | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
13217 | 13217 | Edward Wolcott W000667 | sen | CO | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
13859 | 13859 | James Berry B000418 | sen | AR | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
14007 | 14007 | George Hoar H000654 | sen | MA | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
14062 | 14062 | James McMillan M000567 | sen | MI | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
14094 | 14094 | John Morgan M000954 | sen | AL | 1889-12-02 | 1895-03-03 | 2 | Democrat | |||||||||||||
15060 | 15060 | Shelby Cullom C000973 | sen | IL | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
15109 | 15109 | William Frye F000398 | sen | ME | 1889-12-02 | 1895-03-03 | 2 | Republican | |||||||||||||
15221 | 15221 | Anselm McLaurin M000542 | sen | MS | 1894-01-01 | 1895-03-03 | 2 | Democrat |
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);