legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
34 rows where "start" is on date 1895-12-02 and type = "sen"
This data as json, copyable, CSV (advanced)
Suggested facets: class
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12908 | 12908 | Lucien Baker B000070 | sen | KS | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
12931 | 12931 | Marion Butler B001183 | sen | NC | 1895-12-02 | 1901-03-03 | 2 | Populist | |||||||||||||
12933 | 12933 | Donelson Caffery C000016 | sen | LA | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
12936 | 12936 | William Chandler C000298 | sen | NH | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
12938 | 12938 | Horace Chilton C000357 | sen | TX | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
13009 | 13009 | John Gear G000110 | sen | IA | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
13026 | 13026 | Isham Harris H000243 | sen | TN | 1895-12-02 | 1897-12-31 | 2 | Democrat | |||||||||||||
13068 | 13068 | William Lindsay L000327 | sen | KY | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
13072 | 13072 | Lee Mantle M000116 | sen | MT | 1895-12-02 | 1899-03-03 | 1 | Silver Republican | |||||||||||||
13073 | 13073 | George McBride M000300 | sen | OR | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
13119 | 13119 | Richard Pettigrew P000271 | sen | SD | 1895-12-02 | 1901-03-03 | 2 | Silver Republican | |||||||||||||
13158 | 13158 | William Sewell S000262 | sen | NJ | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
13161 | 13161 | George Shoup S000382 | sen | ID | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
13179 | 13179 | John Thurston T000256 | sen | NE | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
13203 | 13203 | Edward Walthall W000111 | sen | MS | 1895-12-02 | 1899-03-03 | 2 | Democrat | |||||||||||||
13216 | 13216 | John Wilson W000602 | sen | WA | 1895-12-02 | 1899-03-03 | 1 | Republican | |||||||||||||
13218 | 13218 | Edward Wolcott W000667 | sen | CO | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
13454 | 13454 | Jeter Pritchard P000545 | sen | NC | 1895-12-02 | 1897-03-03 | 3 | Republican | |||||||||||||
13860 | 13860 | James Berry B000418 | sen | AR | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
14008 | 14008 | George Hoar H000654 | sen | MA | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
14063 | 14063 | James McMillan M000567 | sen | MI | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
14095 | 14095 | John Morgan M000954 | sen | AL | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
14611 | 14611 | Julius Burrows B001142 | sen | MI | 1895-12-02 | 1899-03-03 | 1 | Republican | |||||||||||||
14617 | 14617 | Thomas Carter C000200 | sen | MT | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
15061 | 15061 | Shelby Cullom C000973 | sen | IL | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
15095 | 15095 | Stephen Elkins E000110 | sen | WV | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
15110 | 15110 | William Frye F000398 | sen | ME | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
15320 | 15320 | George Wetmore W000312 | sen | RI | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
15895 | 15895 | Clarence Clark C000425 | sen | WY | 1895-12-02 | 1899-03-03 | 1 | Republican | |||||||||||||
16256 | 16256 | Augustus Bacon B000014 | sen | GA | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
16471 | 16471 | Thomas Martin M000200 | sen | VA | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
16615 | 16615 | Benjamin Tillman T000274 | sen | SC | 1895-12-02 | 1901-03-03 | 2 | Democrat | |||||||||||||
17863 | 17863 | Knute Nelson N000040 | sen | MN | 1895-12-02 | 1901-03-03 | 2 | Republican | |||||||||||||
19151 | 19151 | Francis Warren W000164 | sen | WY | 1895-12-02 | 1901-03-03 | 2 | Republican |
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);