legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
383 rows where "end" is on date 1893-03-03
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12264 | 12264 | David Patton P000137 | rep | IN | 1891-12-07 | 1893-03-03 | Democrat | 10 | |||||||||||||
12269 | 12269 | Samuel Peel P000184 | rep | AR | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
12276 | 12276 | John Quackenbush Q000001 | rep | NY | 1891-12-07 | 1893-03-03 | Republican | 18 | |||||||||||||
12278 | 12278 | John Raines R000013 | rep | NY | 1891-12-07 | 1893-03-03 | Republican | 29 | |||||||||||||
12280 | 12280 | John Rife R000251 | rep | PA | 1891-12-07 | 1893-03-03 | Republican | 14 | |||||||||||||
12281 | 12281 | Hosea Rockwell R000366 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 28 | |||||||||||||
12282 | 12282 | Leslie Russell R000535 | rep | NY | 1891-12-07 | 1893-03-03 | Republican | 22 | |||||||||||||
12284 | 12284 | John Sanford S000047 | rep | NY | 1891-12-07 | 1893-03-03 | Republican | 20 | |||||||||||||
12285 | 12285 | Owen Scott S000183 | rep | IL | 1891-12-07 | 1893-03-03 | Democrat | 14 | |||||||||||||
12288 | 12288 | Edward Scull S000205 | rep | PA | 1891-12-07 | 1893-03-03 | Republican | 20 | |||||||||||||
12289 | 12289 | John Seerley S000226 | rep | IA | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12290 | 12290 | George Shonk S000376 | rep | PA | 1891-12-07 | 1893-03-03 | Republican | 12 | |||||||||||||
12291 | 12291 | Herman Snow S000660 | rep | IL | 1891-12-07 | 1893-03-03 | Democrat | 9 | |||||||||||||
12294 | 12294 | Francis Spinola S000738 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 10 | |||||||||||||
12297 | 12297 | Eli Stackhouse S000774 | rep | SC | 1891-12-07 | 1893-03-03 | Democrat | 6 | |||||||||||||
12301 | 12301 | William Stahlnecker S000781 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 14 | |||||||||||||
12304 | 12304 | Lewis Steward S000897 | rep | IL | 1891-12-07 | 1893-03-03 | Democrat | 8 | |||||||||||||
12305 | 12305 | Andrew Stewart S000900 | rep | PA | 1891-12-07 | 1893-03-03 | Republican | 24 | |||||||||||||
12310 | 12310 | Charles Stewart S000904 | rep | TX | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12311 | 12311 | Byron Stout S000980 | rep | MI | 1891-12-07 | 1893-03-03 | Democrat | 6 | |||||||||||||
12313 | 12313 | Herman Stump S001043 | rep | MD | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12315 | 12315 | Abner Taylor T000062 | rep | IL | 1891-12-07 | 1893-03-03 | Republican | 1 | |||||||||||||
12322 | 12322 | Ezra Taylor T000073 | rep | OH | 1891-12-07 | 1893-03-03 | Republican | 19 | |||||||||||||
12327 | 12327 | Joseph Taylor T000093 | rep | OH | 1891-12-07 | 1893-03-03 | Republican | 18 | |||||||||||||
12328 | 12328 | Vincent Taylor T000101 | rep | OH | 1891-12-07 | 1893-03-03 | Republican | 20 | |||||||||||||
12335 | 12335 | George Tillman T000275 | rep | SC | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12337 | 12337 | Hosea Townsend T000334 | rep | CO | 1891-12-07 | 1893-03-03 | Republican | 1 | |||||||||||||
12338 | 12338 | George Van Horn V000041 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 24 | |||||||||||||
12354 | 12354 | John Warwick W000169 | rep | OH | 1891-12-07 | 1893-03-03 | Democrat | 16 | |||||||||||||
12355 | 12355 | Harrison Wheeler W000336 | rep | MI | 1891-12-07 | 1893-03-03 | Democrat | 9 | |||||||||||||
12357 | 12357 | Frederick White W000369 | rep | IA | 1891-12-07 | 1893-03-03 | Democrat | 6 | |||||||||||||
12360 | 12360 | Scott Wike W000451 | rep | IL | 1891-12-07 | 1893-03-03 | Democrat | 12 | |||||||||||||
12362 | 12362 | Washington Willcox W000480 | rep | CT | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12363 | 12363 | Archibald Williams W000489 | rep | NC | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
12364 | 12364 | George Williams W000497 | rep | MA | 1891-12-07 | 1893-03-03 | Democrat | 9 | |||||||||||||
12366 | 12366 | John Wilson W000601 | rep | KY | 1891-12-07 | 1893-03-03 | Republican | 11 | |||||||||||||
12368 | 12368 | Robert Wilson W000611 | rep | MO | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
12369 | 12369 | Thomas Winn W000638 | rep | GA | 1891-12-07 | 1893-03-03 | Democrat | 9 | |||||||||||||
12370 | 12370 | Henry Youmans Y000027 | rep | MI | 1891-12-07 | 1893-03-03 | Democrat | 8 | |||||||||||||
12387 | 12387 | Roger Mills M000777 | sen | TX | 1892-03-30 | 1893-03-03 | 1 | Democrat | |||||||||||||
12396 | 12396 | John Alderson A000080 | rep | WV | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12398 | 12398 | Sydenham Alexander A000102 | rep | NC | 1891-12-07 | 1893-03-03 | Democrat | 6 | |||||||||||||
12400 | 12400 | Marshall Arnold A000292 | rep | MO | 1891-12-07 | 1893-03-03 | Democrat | 14 | |||||||||||||
12405 | 12405 | Charles Barwig B000218 | rep | WI | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12410 | 12410 | Frank Beltzhoover B000355 | rep | PA | 1891-12-07 | 1893-03-03 | Democrat | 19 | |||||||||||||
12420 | 12420 | William Branch B000765 | rep | NC | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12423 | 12423 | William Brawley B000775 | rep | SC | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12429 | 12429 | Clifton Breckinridge B000784 | rep | AR | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12434 | 12434 | William Breckinridge B000790 | rep | KY | 1891-12-07 | 1893-03-03 | Democrat | 7 | |||||||||||||
12436 | 12436 | John Bretz B000807 | rep | IN | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12439 | 12439 | George Brickner B000821 | rep | WI | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
12442 | 12442 | Elijah Brookshire B000886 | rep | IN | 1891-12-07 | 1893-03-03 | Democrat | 8 | |||||||||||||
12445 | 12445 | Jason Brown B000924 | rep | IN | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12447 | 12447 | William Bryan B000995 | rep | NE | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12453 | 12453 | Benjamin Bunn B001062 | rep | NC | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
12459 | 12459 | William Bynum B001205 | rep | IN | 1891-12-07 | 1893-03-03 | Democrat | 7 | |||||||||||||
12462 | 12462 | Cornelius Cadmus C000010 | rep | NJ | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
12465 | 12465 | John Caldwell C000034 | rep | OH | 1891-12-07 | 1893-03-03 | Republican | 2 | |||||||||||||
12469 | 12469 | Anthony Caminetti C000069 | rep | CA | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12473 | 12473 | Timothy Campbell C000103 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 8 | |||||||||||||
12476 | 12476 | James Capehart C000129 | rep | WV | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
12480 | 12480 | Asher Caruth C000208 | rep | KY | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
12482 | 12482 | John Causey C000257 | rep | DE | 1891-12-07 | 1893-03-03 | Democrat | 0 | |||||||||||||
12487 | 12487 | John Chipman C000367 | rep | MI | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12490 | 12490 | John Clancy C000410 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
12496 | 12496 | Barnes Compton C000660 | rep | MD | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
12499 | 12499 | William Coombs C000742 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12502 | 12502 | George Cooper C000750 | rep | IN | 1891-12-07 | 1893-03-03 | Democrat | 5 | |||||||||||||
12508 | 12508 | James Covert C000814 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12510 | 12510 | John Davis D000115 | rep | KS | 1891-12-07 | 1893-03-03 | Populist | 5 | |||||||||||||
12512 | 12512 | Robert De Forest D000190 | rep | CT | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
12515 | 12515 | Dennis Donovan D000420 | rep | OH | 1891-12-07 | 1893-03-03 | Democrat | 6 | |||||||||||||
12519 | 12519 | Edward Dunphy D000556 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 7 | |||||||||||||
12521 | 12521 | Allan Durborow D000564 | rep | IL | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12524 | 12524 | Paul Edmunds E000057 | rep | VA | 1891-12-07 | 1893-03-03 | Democrat | 6 | |||||||||||||
12527 | 12527 | William Ellis E000139 | rep | KY | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12529 | 12529 | Thomas English E000188 | rep | NJ | 1891-12-07 | 1893-03-03 | Democrat | 6 | |||||||||||||
12534 | 12534 | Benjamin Enloe E000192 | rep | TN | 1891-12-07 | 1893-03-03 | Democrat | 8 | |||||||||||||
12536 | 12536 | William Enochs E000193 | rep | OH | 1891-12-07 | 1893-03-03 | Republican | 12 | |||||||||||||
12538 | 12538 | James Epes E000195 | rep | VA | 1891-12-07 | 1893-03-03 | Democrat | 4 | |||||||||||||
12541 | 12541 | Charles Faulkner F000045 | sen | WV | 1887-12-05 | 1893-03-03 | 1 | Democrat | |||||||||||||
12543 | 12543 | John Fellows F000067 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 6 | |||||||||||||
12548 | 12548 | Ashbel Fitch F000157 | rep | NY | 1891-12-07 | 1893-03-03 | Democrat | 13 | |||||||||||||
12551 | 12551 | George Fithian F000162 | rep | IL | 1891-12-07 | 1893-03-03 | Democrat | 16 | |||||||||||||
12554 | 12554 | William Forman F000275 | rep | IL | 1891-12-07 | 1893-03-03 | Democrat | 18 | |||||||||||||
12561 | 12561 | Edward Funston F000429 | rep | KS | 1891-12-07 | 1893-03-03 | Republican | 2 | |||||||||||||
12564 | 12564 | Robert Fyan F000436 | rep | MO | 1891-12-07 | 1893-03-03 | Democrat | 13 | |||||||||||||
12567 | 12567 | Thomas Geary G000113 | rep | CA | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12570 | 12570 | Jacob Geissenhainer G000119 | rep | NJ | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12573 | 12573 | James George G000127 | sen | MS | 1887-12-05 | 1893-03-03 | 1 | Democrat | |||||||||||||
12577 | 12577 | Isaac Goodnight G000292 | rep | KY | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12579 | 12579 | James Gorman G000328 | rep | MI | 1891-12-07 | 1893-03-03 | Democrat | 2 | |||||||||||||
12581 | 12581 | Benjamin Grady G000350 | rep | NC | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12585 | 12585 | George Gray G000396 | sen | DE | 1887-12-05 | 1893-03-03 | 1 | Democrat | |||||||||||||
12590 | 12590 | Osee Hall H000065 | rep | MN | 1891-12-07 | 1893-03-03 | Democrat | 3 | |||||||||||||
12593 | 12593 | Darius Hare H000201 | rep | OH | 1891-12-07 | 1893-03-03 | Democrat | 8 | |||||||||||||
12595 | 12595 | Michael Harter H000296 | rep | OH | 1891-12-07 | 1893-03-03 | Democrat | 15 | |||||||||||||
12603 | 12603 | William Hatch H000339 | rep | MO | 1891-12-07 | 1893-03-03 | Democrat | 1 | |||||||||||||
12607 | 12607 | Nils Haugen H000351 | rep | WI | 1891-12-07 | 1893-03-03 | Republican | 8 | |||||||||||||
12611 | 12611 | Walter Hayes H000394 | rep | IA | 1891-12-07 | 1893-03-03 | Democrat | 2 |
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);