legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
404 rows where "end" is on date 1899-03-03 sorted by party_affiliations
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, class, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12388 | 12388 | Roger Mills M000777 | sen | TX | 1893-03-04 | 1899-03-03 | 1 | Democrat | |||||||||||||
12542 | 12542 | Charles Faulkner F000045 | sen | WV | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12586 | 12586 | George Gray G000396 | sen | DE | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12691 | 12691 | John Mitchell M000821 | sen | WI | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12698 | 12698 | Edward Murphy M001090 | sen | NY | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12751 | 12751 | Samuel Pasco P000095 | sen | FL | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12770 | 12770 | William Roach R000290 | sen | ND | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12790 | 12790 | James Smith S000561 | sen | NJ | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12835 | 12835 | David Turpie T000432 | sen | IN | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
12852 | 12852 | Stephen White W000394 | sen | CA | 1893-08-07 | 1899-03-03 | 1 | Democrat | |||||||||||||
13072 | 13072 | Lee Mantle M000116 | sen | MT | 1895-12-02 | 1899-03-03 | 1 | Silver 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 | |||||||||||||
13228 | 13228 | Frank Cannon C000118 | sen | UT | 1896-01-22 | 1899-03-03 | 1 | Silver Republican | |||||||||||||
13237 | 13237 | William Arnold A000299 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 28 | |||||||||||||
13241 | 13241 | Jehu Baker B000066 | rep | IL | 1897-03-15 | 1899-03-03 | Democrat | 21 | |||||||||||||
13242 | 13242 | Isaac Barber B000121 | rep | MD | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13243 | 13243 | Charles Barlow B000149 | rep | CA | 1897-03-15 | 1899-03-03 | Populist | 6 | |||||||||||||
13245 | 13245 | William Barrett B000180 | rep | MA | 1897-03-15 | 1899-03-03 | Republican | 7 | |||||||||||||
13246 | 13246 | Samuel Barrows B000186 | rep | MA | 1897-03-15 | 1899-03-03 | Republican | 10 | |||||||||||||
13248 | 13248 | Clifton Beach B000262 | rep | OH | 1897-03-15 | 1899-03-03 | Republican | 20 | |||||||||||||
13253 | 13253 | James Belden B000325 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 27 | |||||||||||||
13254 | 13254 | Joseph Belford B000327 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13256 | 13256 | Hugh Belknap B000329 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 3 | |||||||||||||
13257 | 13257 | George Benner B000366 | rep | PA | 1897-03-15 | 1899-03-03 | Democrat | 19 | |||||||||||||
13259 | 13259 | Charles Bennett B000372 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 5 | |||||||||||||
13260 | 13260 | Robert Bodine B000584 | rep | MO | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
13261 | 13261 | William Booze B000633 | rep | MD | 1897-03-15 | 1899-03-03 | Republican | 3 | |||||||||||||
13262 | 13262 | Jeremiah Botkin B000654 | rep | KS | 1897-03-15 | 1899-03-03 | Populist | -1 | |||||||||||||
13264 | 13264 | Henry Brewster B000815 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 31 | |||||||||||||
13268 | 13268 | Case Broderick B000856 | rep | KS | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13269 | 13269 | Ferdinand Brucker B000973 | rep | MI | 1897-03-15 | 1899-03-03 | Democrat | 8 | |||||||||||||
13270 | 13270 | James Callahan C000053 | rep | OK | 1897-03-15 | 1899-03-03 | Free Silver | -1 | |||||||||||||
13271 | 13271 | James Campbell C000089 | rep | IL | 1897-03-15 | 1899-03-03 | Democrat | 20 | |||||||||||||
13272 | 13272 | Curtis Castle C000241 | rep | CA | 1897-03-15 | 1899-03-03 | Populist | 7 | |||||||||||||
13274 | 13274 | John Clardy C000415 | rep | KY | 1897-03-15 | 1899-03-03 | Democrat | 2 | |||||||||||||
13276 | 13276 | Samuel Clark C000452 | rep | IA | 1897-03-15 | 1899-03-03 | Republican | 1 | |||||||||||||
13278 | 13278 | James Codding C000580 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 15 | |||||||||||||
13280 | 13280 | David Colson C000649 | rep | KY | 1897-03-15 | 1899-03-03 | Republican | 11 | |||||||||||||
13282 | 13282 | James Connolly C000697 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 17 | |||||||||||||
13284 | 13284 | Edward Cooke C000731 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 6 | |||||||||||||
13285 | 13285 | John Cranford C000876 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
13287 | 13287 | George Curtis C001010 | rep | IA | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
13288 | 13288 | George Davison D000144 | rep | KY | 1897-03-15 | 1899-03-03 | Republican | 8 | |||||||||||||
13297 | 13297 | Alexander Dockery D000384 | rep | MO | 1897-03-15 | 1899-03-03 | Democrat | 3 | |||||||||||||
13298 | 13298 | Charles Dorr D000436 | rep | WV | 1897-03-15 | 1899-03-03 | Republican | 3 | |||||||||||||
13301 | 13301 | Walter Evans E000260 | rep | KY | 1897-03-15 | 1899-03-03 | Republican | 5 | |||||||||||||
13303 | 13303 | Lucien Fenton F000076 | rep | OH | 1897-03-15 | 1899-03-03 | Republican | 10 | |||||||||||||
13305 | 13305 | Israel Fischer F000138 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 4 | |||||||||||||
13307 | 13307 | Wallace Foote F000252 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 23 | |||||||||||||
13308 | 13308 | John Fowler F000323 | rep | NC | 1897-03-15 | 1899-03-03 | Populist | 3 | |||||||||||||
13311 | 13311 | Michael Griffin G000464 | rep | WI | 1897-03-15 | 1899-03-03 | Republican | 7 | |||||||||||||
13312 | 13312 | James Gunn G000525 | rep | ID | 1897-03-15 | 1899-03-03 | Populist | 1 | |||||||||||||
13315 | 13315 | Alva Hager H000015 | rep | IA | 1897-03-15 | 1899-03-03 | Republican | 9 | |||||||||||||
13316 | 13316 | Levin Handy H000156 | rep | DE | 1897-03-15 | 1899-03-03 | Democrat | 0 | |||||||||||||
13321 | 13321 | Charles Hartman H000300 | rep | MT | 1897-03-15 | 1899-03-03 | Silver Republican | 1 | |||||||||||||
13324 | 13324 | Charles Henry H000503 | rep | IN | 1897-03-15 | 1899-03-03 | Republican | 8 | |||||||||||||
13327 | 13327 | Josiah Hicks H000565 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 20 | |||||||||||||
13331 | 13331 | Samuel Hilborn H000583 | rep | CA | 1897-03-15 | 1899-03-03 | Republican | 3 | |||||||||||||
13332 | 13332 | William Hinrichsen H000637 | rep | IL | 1897-03-15 | 1899-03-03 | Democrat | 16 | |||||||||||||
13349 | 13349 | William Holman H000732 | rep | IN | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
13351 | 13351 | Milford Howard H000843 | rep | AL | 1897-03-15 | 1899-03-03 | Populist | 7 | |||||||||||||
13353 | 13353 | James Howe H000852 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 6 | |||||||||||||
13355 | 13355 | Andrew Hunter H000980 | rep | IL | 1897-03-15 | 1899-03-03 | Democrat | 19 | |||||||||||||
13357 | 13357 | Denis Hurley H001004 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
13361 | 13361 | Henry Johnson J000138 | rep | IN | 1897-03-15 | 1899-03-03 | Republican | 6 | |||||||||||||
13372 | 13372 | William Jones J000260 | rep | WA | 1897-03-15 | 1899-03-03 | Silver Republican | -1 | |||||||||||||
13373 | 13373 | John Kelley K000060 | rep | SD | 1897-03-15 | 1899-03-03 | Populist | -1 | |||||||||||||
13375 | 13375 | William Kirkpatrick K000241 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 8 | |||||||||||||
13376 | 13376 | Freeman Knowles K000293 | rep | SD | 1897-03-15 | 1899-03-03 | Populist | -1 | |||||||||||||
13378 | 13378 | Monroe Kulp K000338 | rep | PA | 1897-03-15 | 1899-03-03 | Republican | 17 | |||||||||||||
13381 | 13381 | William Love L000461 | rep | MS | 1897-03-15 | 1899-03-03 | Democrat | 6 | |||||||||||||
13383 | 13383 | Philip Low L000471 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 15 | |||||||||||||
13386 | 13386 | James Maguire M000059 | rep | CA | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
13388 | 13388 | Rowland Mahany M000062 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 32 | |||||||||||||
13389 | 13389 | George Marshall M000153 | rep | OH | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
13391 | 13391 | Charles Martin M000172 | rep | NC | 1897-03-15 | 1899-03-03 | Populist | 6 | |||||||||||||
13392 | 13392 | Samuel Maxwell M000270 | rep | NE | 1897-03-15 | 1899-03-03 | Populist | 3 | |||||||||||||
13393 | 13393 | Nelson McCormick M000370 | rep | KS | 1897-03-15 | 1899-03-03 | Populist | 6 | |||||||||||||
13394 | 13394 | John McDonald M000411 | rep | MD | 1897-03-15 | 1899-03-03 | Republican | 6 | |||||||||||||
13396 | 13396 | Thomas McEwan M000431 | rep | NJ | 1897-03-15 | 1899-03-03 | Republican | 7 | |||||||||||||
13397 | 13397 | William McIntire M000480 | rep | MD | 1897-03-15 | 1899-03-03 | Republican | 4 | |||||||||||||
13411 | 13411 | Benton McMillin M000575 | rep | TN | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
13413 | 13413 | Warren Miller M000761 | rep | WV | 1897-03-15 | 1899-03-03 | Republican | 4 | |||||||||||||
13421 | 13421 | Seth Milliken M000769 | rep | ME | 1897-03-15 | 1899-03-03 | Republican | 3 | |||||||||||||
13422 | 13422 | Daniel Mills M000773 | rep | IL | 1897-03-15 | 1899-03-03 | Republican | 4 | |||||||||||||
13424 | 13424 | John Mitchell M000822 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 8 | |||||||||||||
13436 | 13436 | Justin Morrill M000969 | sen | VT | 1897-03-15 | 1899-03-03 | 3 | Republican | |||||||||||||
13439 | 13439 | Stephen Northway N000144 | rep | OH | 1897-03-15 | 1899-03-03 | Republican | 19 | |||||||||||||
13441 | 13441 | Benjamin Odell O000036 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 17 | |||||||||||||
13444 | 13444 | Henry Ogden O000044 | rep | LA | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
13445 | 13445 | John Osborne O000113 | rep | WY | 1897-03-15 | 1899-03-03 | Democrat | 0 | |||||||||||||
13449 | 13449 | George Perkins P000233 | rep | IA | 1897-03-15 | 1899-03-03 | Republican | 11 | |||||||||||||
13450 | 13450 | Mason Peters P000254 | rep | KS | 1897-03-15 | 1899-03-03 | Populist | 2 | |||||||||||||
13452 | 13452 | Mahlon Pitney P000370 | rep | NJ | 1897-03-15 | 1899-03-03 | Republican | 4 | |||||||||||||
13453 | 13453 | Thomas Plowman P000388 | rep | AL | 1897-03-15 | 1899-03-03 | Democrat | 4 | |||||||||||||
13458 | 13458 | Lemuel Quigg Q000011 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 14 | |||||||||||||
13462 | 13462 | Lemuel Royse R000490 | rep | IN | 1897-03-15 | 1899-03-03 | Republican | 13 | |||||||||||||
13464 | 13464 | Edward Sauerhering S000071 | rep | WI | 1897-03-15 | 1899-03-03 | Republican | 2 | |||||||||||||
13471 | 13471 | Joseph Sayers S000099 | rep | TX | 1897-03-15 | 1899-03-03 | Democrat | 9 |
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);