legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
385 rows where "end" is on date 1895-03-03 and "start" is on date 1893-08-07
This data as json, copyable, CSV (advanced)
Suggested facets: type, class, start (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12394 | 12394 | Silas Adams A000047 | rep | KY | 1893-08-07 | 1895-03-03 | Republican | 11 | |||||||||||||
12397 | 12397 | John Alderson A000080 | rep | WV | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12399 | 12399 | Sydenham Alexander A000102 | rep | NC | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
12401 | 12401 | Marshall Arnold A000292 | rep | MO | 1893-08-07 | 1895-03-03 | Democrat | 14 | |||||||||||||
12402 | 12402 | Melvin Baldwin B000094 | rep | MN | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
12403 | 12403 | Lyman Barnes B000159 | rep | WI | 1893-08-07 | 1895-03-03 | Democrat | 8 | |||||||||||||
12406 | 12406 | Charles Barwig B000218 | rep | WI | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
12407 | 12407 | William Beckner B000294 | rep | KY | 1893-08-07 | 1895-03-03 | Democrat | 10 | |||||||||||||
12411 | 12411 | Frank Beltzhoover B000355 | rep | PA | 1893-08-07 | 1895-03-03 | Democrat | 19 | |||||||||||||
12412 | 12412 | John Black B000504 | rep | IL | 1893-08-07 | 1895-03-03 | Democrat | -1 | |||||||||||||
12417 | 12417 | Henry Blair B000524 | rep | NH | 1893-08-07 | 1895-03-03 | Republican | 1 | |||||||||||||
12418 | 12418 | Haldor Boen B000590 | rep | MN | 1893-08-07 | 1895-03-03 | Populist | 7 | |||||||||||||
12419 | 12419 | William Bower B000688 | rep | NC | 1893-08-07 | 1895-03-03 | Democrat | 8 | |||||||||||||
12421 | 12421 | William Branch B000765 | rep | NC | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12422 | 12422 | Robert Bratton B000773 | rep | MD | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12424 | 12424 | William Brawley B000775 | rep | SC | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12430 | 12430 | Clifton Breckinridge B000784 | rep | AR | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
12435 | 12435 | William Breckinridge B000790 | rep | KY | 1893-08-07 | 1895-03-03 | Democrat | 7 | |||||||||||||
12437 | 12437 | John Bretz B000807 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
12440 | 12440 | George Brickner B000821 | rep | WI | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
12443 | 12443 | Elijah Brookshire B000886 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 8 | |||||||||||||
12446 | 12446 | Jason Brown B000924 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12448 | 12448 | William Bryan B000995 | rep | NE | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12451 | 12451 | Hezekiah Bundy B001059 | rep | OH | 1893-08-07 | 1895-03-03 | Republican | 10 | |||||||||||||
12454 | 12454 | Benjamin Bunn B001062 | rep | NC | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
12455 | 12455 | Daniel Burnes B001115 | rep | MO | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
12460 | 12460 | William Bynum B001205 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 7 | |||||||||||||
12461 | 12461 | Thomas Cabaniss C000001 | rep | GA | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
12463 | 12463 | Cornelius Cadmus C000010 | rep | NJ | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
12466 | 12466 | John Caldwell C000034 | rep | OH | 1893-08-07 | 1895-03-03 | Republican | 2 | |||||||||||||
12468 | 12468 | Johnson Camden C000062 | sen | WV | 1893-08-07 | 1895-03-03 | 2 | Democrat | |||||||||||||
12470 | 12470 | Anthony Caminetti C000069 | rep | CA | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
12474 | 12474 | Timothy Campbell C000103 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 9 | |||||||||||||
12475 | 12475 | Marion Cannon C000122 | rep | CA | 1893-08-07 | 1895-03-03 | Populist | 6 | |||||||||||||
12477 | 12477 | James Capehart C000129 | rep | WV | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
12481 | 12481 | Asher Caruth C000208 | rep | KY | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
12483 | 12483 | John Causey C000257 | rep | DE | 1893-08-07 | 1895-03-03 | Democrat | 0 | |||||||||||||
12484 | 12484 | Robert Childs C000354 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 8 | |||||||||||||
12488 | 12488 | John Chipman C000367 | rep | MI | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12491 | 12491 | John Clancy C000410 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
12492 | 12492 | Henry Coffeen C000585 | rep | WY | 1893-08-07 | 1895-03-03 | Democrat | 0 | |||||||||||||
12497 | 12497 | Barnes Compton C000660 | rep | MD | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
12498 | 12498 | Charles Conn C000683 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 13 | |||||||||||||
12500 | 12500 | William Coombs C000742 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
12503 | 12503 | George Cooper C000750 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
12504 | 12504 | Johnston Cornish C000786 | rep | NJ | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
12509 | 12509 | James Covert C000814 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12511 | 12511 | John Davis D000115 | rep | KS | 1893-08-07 | 1895-03-03 | Populist | 5 | |||||||||||||
12513 | 12513 | Robert De Forest D000190 | rep | CT | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
12514 | 12514 | William Denson D000253 | rep | AL | 1893-08-07 | 1895-03-03 | Democrat | 7 | |||||||||||||
12516 | 12516 | Dennis Donovan D000420 | rep | OH | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
12517 | 12517 | John Dunn D000550 | rep | NJ | 1893-08-07 | 1895-03-03 | Democrat | 8 | |||||||||||||
12520 | 12520 | Edward Dunphy D000556 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 8 | |||||||||||||
12522 | 12522 | Allan Durborow D000564 | rep | IL | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12525 | 12525 | Paul Edmunds E000057 | rep | VA | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
12528 | 12528 | William Ellis E000139 | rep | KY | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
12530 | 12530 | Thomas English E000188 | rep | NJ | 1893-08-07 | 1895-03-03 | Democrat | 6 | |||||||||||||
12531 | 12531 | Warren English E000189 | rep | CA | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12535 | 12535 | Benjamin Enloe E000192 | rep | TN | 1893-08-07 | 1895-03-03 | Democrat | 8 | |||||||||||||
12537 | 12537 | William Enochs E000193 | rep | OH | 1893-08-07 | 1895-03-03 | Republican | 10 | |||||||||||||
12539 | 12539 | James Epes E000195 | rep | VA | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
12540 | 12540 | William Everett E000269 | rep | MA | 1893-08-07 | 1895-03-03 | Democrat | 7 | |||||||||||||
12544 | 12544 | John Fellows F000067 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 14 | |||||||||||||
12545 | 12545 | George Fielder F000109 | rep | NJ | 1893-08-07 | 1895-03-03 | Democrat | 7 | |||||||||||||
12549 | 12549 | Ashbel Fitch F000157 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 15 | |||||||||||||
12552 | 12552 | George Fithian F000162 | rep | IL | 1893-08-07 | 1895-03-03 | Democrat | 16 | |||||||||||||
12555 | 12555 | William Forman F000275 | rep | IL | 1893-08-07 | 1895-03-03 | Democrat | 18 | |||||||||||||
12556 | 12556 | Benjamin Funk F000427 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 14 | |||||||||||||
12562 | 12562 | Edward Funston F000429 | rep | KS | 1893-08-07 | 1895-03-03 | Republican | 2 | |||||||||||||
12565 | 12565 | Robert Fyan F000436 | rep | MO | 1893-08-07 | 1895-03-03 | Democrat | 13 | |||||||||||||
12568 | 12568 | Thomas Geary G000113 | rep | CA | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12571 | 12571 | Jacob Geissenhainer G000119 | rep | NJ | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12575 | 12575 | Julius Goldzier G000269 | rep | IL | 1893-08-07 | 1895-03-03 | Democrat | 4 | |||||||||||||
12578 | 12578 | Isaac Goodnight G000292 | rep | KY | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12580 | 12580 | James Gorman G000328 | rep | MI | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
12582 | 12582 | Benjamin Grady G000350 | rep | NC | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12583 | 12583 | John Graham G000358 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 5 | |||||||||||||
12587 | 12587 | Walter Gresham G000452 | rep | TX | 1893-08-07 | 1895-03-03 | Democrat | 10 | |||||||||||||
12588 | 12588 | Levi Griffin G000463 | rep | MI | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12589 | 12589 | Charles Haines H000025 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 19 | |||||||||||||
12591 | 12591 | Osee Hall H000065 | rep | MN | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12592 | 12592 | Thomas Hammond H000134 | rep | IN | 1893-08-07 | 1895-03-03 | Democrat | 10 | |||||||||||||
12594 | 12594 | Darius Hare H000201 | rep | OH | 1893-08-07 | 1895-03-03 | Democrat | 13 | |||||||||||||
12596 | 12596 | Michael Harter H000296 | rep | OH | 1893-08-07 | 1895-03-03 | Democrat | 14 | |||||||||||||
12604 | 12604 | William Hatch H000339 | rep | MO | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12608 | 12608 | Nils Haugen H000351 | rep | WI | 1893-08-07 | 1895-03-03 | Republican | 10 | |||||||||||||
12612 | 12612 | Walter Hayes H000394 | rep | IA | 1893-08-07 | 1895-03-03 | Democrat | 2 | |||||||||||||
12617 | 12617 | John Heard H000427 | rep | MO | 1893-08-07 | 1895-03-03 | Democrat | 7 | |||||||||||||
12622 | 12622 | John Henderson H000485 | rep | NC | 1893-08-07 | 1895-03-03 | Democrat | 7 | |||||||||||||
12632 | 12632 | Thomas Henderson H000489 | rep | IL | 1893-08-07 | 1895-03-03 | Republican | 7 | |||||||||||||
12633 | 12633 | Joseph Hendrix H000496 | rep | NY | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12634 | 12634 | Winder Henry H000521 | rep | MD | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12635 | 12635 | William Hines H000635 | rep | PA | 1893-08-07 | 1895-03-03 | Democrat | 12 | |||||||||||||
12637 | 12637 | Albert Hopkins H000769 | rep | PA | 1893-08-07 | 1895-03-03 | Republican | 16 | |||||||||||||
12639 | 12639 | George Houk H000816 | rep | OH | 1893-08-07 | 1895-03-03 | Democrat | 3 | |||||||||||||
12641 | 12641 | John Houk H000817 | rep | TN | 1893-08-07 | 1895-03-03 | Republican | 2 | |||||||||||||
12642 | 12642 | Thomas Hudson H000909 | rep | KS | 1893-08-07 | 1895-03-03 | Populist | 3 | |||||||||||||
12643 | 12643 | George Ikirt I000008 | rep | OH | 1893-08-07 | 1895-03-03 | Democrat | 18 | |||||||||||||
12644 | 12644 | James Izlar I000054 | rep | SC | 1893-08-07 | 1895-03-03 | Democrat | 1 | |||||||||||||
12646 | 12646 | Tom Johnson J000178 | rep | OH | 1893-08-07 | 1895-03-03 | Democrat | 21 |
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);