legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
406 rows where "start" is on date 1897-03-15 sorted by url
This data as json, copyable, CSV (advanced)
Suggested facets: state, class, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
13289 | 13289 | William Deboe D000182 | sen | KY | 1897-03-15 | 1903-03-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
13299 | 13299 | Joseph Earle E000009 | sen | SC | 1897-03-15 | 1897-12-31 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
13318 | 13318 | William Harris H000258 | sen | KS | 1897-03-15 | 1903-03-03 | 3 | Populist | |||||||||||||
13321 | 13321 | Charles Hartman H000300 | rep | MT | 1897-03-15 | 1899-03-03 | Silver Republican | 1 | |||||||||||||
13322 | 13322 | Henry Heitfeld H000458 | sen | ID | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
13366 | 13366 | James Jones J000231 | sen | AR | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
13371 | 13371 | John Jones J000237 | sen | NV | 1897-03-15 | 1903-03-03 | 3 | Republican | |||||||||||||
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 | |||||||||||||
13374 | 13374 | Richard Kenney K000121 | sen | DE | 1897-03-15 | 1901-03-03 | 2 | Democrat | |||||||||||||
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 | |||||||||||||
13380 | 13380 | James Kyle K000353 | sen | SD | 1897-03-15 | 1901-12-31 | 3 | Republican | |||||||||||||
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 | |||||||||||||
13401 | 13401 | John McLaurin M000543 | sen | SC | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
13455 | 13455 | Jeter Pritchard P000545 | sen | NC | 1897-03-15 | 1903-03-03 | 3 | Republican | |||||||||||||
13458 | 13458 | Lemuel Quigg Q000011 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 14 | |||||||||||||
13460 | 13460 | Joseph Rawlins R000073 | sen | UT | 1897-03-15 | 1903-03-03 | 3 | Democrat | |||||||||||||
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 | |||||||||||||
13473 | 13473 | Richard Shannon S000288 | rep | NY | 1897-03-15 | 1899-03-03 | Republican | 13 | |||||||||||||
13475 | 13475 | Alonzo Shuford S000389 | rep | NC | 1897-03-15 | 1899-03-03 | Populist | 7 | |||||||||||||
13477 | 13477 | John Simpkins S000428 | rep | MA | 1897-03-15 | 1899-03-03 | Republican | 13 |
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);