legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
347 rows where "end" is on date 1877-03-03
This data as json, copyable, CSV (advanced)
Suggested facets: state, class, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8793 | 8793 | Morgan Hamilton H000115 | sen | TX | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
8799 | 8799 | James Alcorn A000079 | sen | MS | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
8858 | 8858 | Powell Clayton C000498 | sen | AR | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
8866 | 8866 | Henry Cooper C000751 | sen | TN | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
8870 | 8870 | Aaron Cragin C000852 | sen | NH | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
8901 | 8901 | Frederick Frelinghuysen F000369 | sen | NJ | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
8911 | 8911 | George Goldthwaite G000266 | sen | AL | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
8933 | 8933 | Phineas Hitchcock H000648 | sen | NE | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
8940 | 8940 | James Kelly K000074 | sen | OR | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
8981 | 8981 | Lot Morrill M000970 | sen | ME | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
9003 | 9003 | Thomas Robertson R000327 | sen | SC | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
9029 | 9029 | John Stevenson S000894 | sen | KY | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
9054 | 9054 | Joseph West W000303 | sen | LA | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
9065 | 9065 | George Wright W000759 | sen | IA | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
9097 | 9097 | George Boutwell B000674 | sen | MA | 1873-12-01 | 1877-03-03 | 2 | Republican | |||||||||||||
9432 | 9432 | James Harvey H000307 | sen | KS | 1874-01-01 | 1877-03-03 | 2 | Republican | |||||||||||||
9440 | 9440 | Josiah Abbott A000007 | rep | MA | 1875-12-06 | 1877-03-03 | Democrat | 4 | |||||||||||||
9441 | 9441 | Charles Adams A000033 | rep | NY | 1875-12-06 | 1877-03-03 | Republican | 16 | |||||||||||||
9442 | 9442 | Lucien Ainsworth A000067 | rep | IA | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
9443 | 9443 | William Anderson A000236 | rep | IL | 1875-12-06 | 1877-03-03 | Independent | 19 | |||||||||||||
9445 | 9445 | Thomas Ashe A000309 | rep | NC | 1875-12-06 | 1877-03-03 | Democrat | 6 | |||||||||||||
9446 | 9446 | John Bagby B000031 | rep | IL | 1875-12-06 | 1877-03-03 | Democrat | 10 | |||||||||||||
9448 | 9448 | Lyman Bass B000221 | rep | NY | 1875-12-06 | 1877-03-03 | Republican | 32 | |||||||||||||
9450 | 9450 | Samuel Bell B000346 | rep | NH | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
9451 | 9451 | Thomas Bennett B000383 | rep | ID | 1875-12-06 | 1877-03-03 | Independent | -1 | |||||||||||||
9453 | 9453 | Taul Bradford B000738 | rep | AL | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
9455 | 9455 | Nathan Bradley B000744 | rep | MI | 1875-12-06 | 1877-03-03 | Republican | 8 | |||||||||||||
9459 | 9459 | John Brown B000933 | rep | KY | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
9460 | 9460 | William Brown B000951 | rep | KS | 1875-12-06 | 1877-03-03 | Republican | 3 | |||||||||||||
9469 | 9469 | James Buffinton B001040 | rep | MA | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
9470 | 9470 | Samuel Burchard B001071 | rep | WI | 1875-12-06 | 1877-03-03 | Democrat | 5 | |||||||||||||
9472 | 9472 | John Burleigh B001107 | rep | ME | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
9474 | 9474 | Charles Buttz B001202 | rep | SC | 1875-12-06 | 1877-03-03 | Republican | 2 | |||||||||||||
9476 | 9476 | John Caldwell C000035 | rep | AL | 1875-12-06 | 1877-03-03 | Democrat | 5 | |||||||||||||
9477 | 9477 | Alexander Campbell C000075 | rep | IL | 1875-12-06 | 1877-03-03 | Independent | 7 | |||||||||||||
9478 | 9478 | Allen Caperton C000130 | sen | WV | 1875-12-06 | 1877-03-03 | 1 | Democrat | |||||||||||||
9479 | 9479 | Nathan Carr C000179 | rep | IN | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
9481 | 9481 | Thomas Cason C000232 | rep | IN | 1875-12-06 | 1877-03-03 | Republican | 9 | |||||||||||||
9482 | 9482 | George Cate C000248 | rep | WI | 1875-12-06 | 1877-03-03 | Democrat | 8 | |||||||||||||
9484 | 9484 | Bernard Caulfield C000255 | rep | IL | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9485 | 9485 | Chester Chapin C000305 | rep | MA | 1875-12-06 | 1877-03-03 | Democrat | 11 | |||||||||||||
9487 | 9487 | Alexander Cochran C000561 | rep | PA | 1875-12-06 | 1877-03-03 | Democrat | 23 | |||||||||||||
9488 | 9488 | Jacob Cowan C000820 | rep | OH | 1875-12-06 | 1877-03-03 | Democrat | 14 | |||||||||||||
9490 | 9490 | Lorenzo Crounse C000935 | rep | NE | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
9491 | 9491 | John Davy D000145 | rep | NY | 1875-12-06 | 1877-03-03 | Republican | 30 | |||||||||||||
9492 | 9492 | Rezin De Bolt D000180 | rep | MO | 1875-12-06 | 1877-03-03 | Democrat | 10 | |||||||||||||
9494 | 9494 | Samuel Dobbins D000383 | rep | NJ | 1875-12-06 | 1877-03-03 | Republican | 2 | |||||||||||||
9495 | 9495 | George Durand D000562 | rep | MI | 1875-12-06 | 1877-03-03 | Democrat | 6 | |||||||||||||
9496 | 9496 | Albert Egbert E000087 | rep | PA | 1875-12-06 | 1877-03-03 | Democrat | 27 | |||||||||||||
9498 | 9498 | Smith Ely E000167 | rep | NY | 1875-12-06 | 1877-03-03 | Democrat | 7 | |||||||||||||
9501 | 9501 | James English E000185 | sen | CT | 1875-12-06 | 1877-03-03 | 3 | Democrat | |||||||||||||
9506 | 9506 | Charles Faulkner F000044 | rep | VA | 1875-12-06 | 1877-03-03 | Democrat | -1 | |||||||||||||
9507 | 9507 | David Field F000104 | rep | NY | 1875-12-06 | 1877-03-03 | Democrat | 7 | |||||||||||||
9508 | 9508 | Samuel Fite F000160 | rep | TN | 1875-12-06 | 1877-03-03 | Democrat | 4 | |||||||||||||
9509 | 9509 | Edwin Flye F000225 | rep | ME | 1875-12-06 | 1877-03-03 | Republican | 3 | |||||||||||||
9510 | 9510 | Rufus Frost F000394 | rep | MA | 1875-12-06 | 1877-03-03 | Republican | 4 | |||||||||||||
9511 | 9511 | John Goodin G000287 | rep | KS | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
9513 | 9513 | Robert Hamilton H000117 | rep | NJ | 1875-12-06 | 1877-03-03 | Democrat | 4 | |||||||||||||
9521 | 9521 | Jeremiah Haralson H000179 | rep | AL | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
9523 | 9523 | Henry Hathorn H000347 | rep | NY | 1875-12-06 | 1877-03-03 | Republican | 20 | |||||||||||||
9524 | 9524 | William Haymond H000396 | rep | IN | 1875-12-06 | 1877-03-03 | Democrat | 10 | |||||||||||||
9528 | 9528 | Charles Hays H000402 | rep | AL | 1875-12-06 | 1877-03-03 | Republican | 4 | |||||||||||||
9530 | 9530 | Samuel Hersey H000545 | rep | ME | 1875-12-06 | 1877-03-03 | Republican | -1 | |||||||||||||
9532 | 9532 | Solomon Hoge H000698 | rep | SC | 1875-12-06 | 1877-03-03 | Republican | 3 | |||||||||||||
9534 | 9534 | George Hoskins H000801 | rep | NY | 1875-12-06 | 1877-03-03 | Republican | 31 | |||||||||||||
9535 | 9535 | Andrew Humphreys H000959 | rep | IN | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
9537 | 9537 | Stephen Hurlbut H001003 | rep | IL | 1875-12-06 | 1877-03-03 | Republican | 4 | |||||||||||||
9538 | 9538 | John Hyman H001025 | rep | NC | 1875-12-06 | 1877-03-03 | Republican | 2 | |||||||||||||
9539 | 9539 | George Jenks J000091 | rep | PA | 1875-12-06 | 1877-03-03 | Democrat | 25 | |||||||||||||
9549 | 9549 | Thomas Jones J000253 | rep | KY | 1875-12-06 | 1877-03-03 | Democrat | 6 | |||||||||||||
9550 | 9550 | Edward Kehr K000047 | rep | MO | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9557 | 9557 | Michael Kerr K000143 | rep | IN | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
9558 | 9558 | Winthrop Ketchum K000154 | rep | PA | 1875-12-06 | 1877-03-03 | Republican | 12 | |||||||||||||
9560 | 9560 | Alanson Kimball K000182 | rep | WI | 1875-12-06 | 1877-03-03 | Republican | 6 | |||||||||||||
9561 | 9561 | William King K000218 | rep | MN | 1875-12-06 | 1877-03-03 | Republican | 3 | |||||||||||||
9562 | 9562 | George La Dow L000002 | rep | OR | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9563 | 9563 | Franklin Landers L000046 | rep | IN | 1875-12-06 | 1877-03-03 | Democrat | 7 | |||||||||||||
9564 | 9564 | La Lane L000064 | rep | OR | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9569 | 9569 | William Lawrence L000140 | rep | OH | 1875-12-06 | 1877-03-03 | Republican | 8 | |||||||||||||
9570 | 9570 | John Le Moyne L000162 | rep | IL | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
9571 | 9571 | Elias Leavenworth L000182 | rep | NY | 1875-12-06 | 1877-03-03 | Republican | 25 | |||||||||||||
9572 | 9572 | William Levy L000269 | rep | LA | 1875-12-06 | 1877-03-03 | Democrat | 4 | |||||||||||||
9573 | 9573 | Scott Lord L000442 | rep | NY | 1875-12-06 | 1877-03-03 | Democrat | 23 | |||||||||||||
9575 | 9575 | Clinton MacDougall M000007 | rep | NY | 1875-12-06 | 1877-03-03 | Republican | 26 | |||||||||||||
9576 | 9576 | Henry Magoon M000054 | rep | WI | 1875-12-06 | 1877-03-03 | Republican | 3 | |||||||||||||
9580 | 9580 | George McCrary M000379 | rep | IA | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
9583 | 9583 | William McFarland M000439 | rep | TN | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9584 | 9584 | Edwin Meade M000616 | rep | NY | 1875-12-06 | 1877-03-03 | Democrat | 5 | |||||||||||||
9585 | 9585 | Henry Metcalfe M000673 | rep | NY | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9587 | 9587 | Samuel Miller M000752 | rep | NY | 1875-12-06 | 1877-03-03 | Republican | 21 | |||||||||||||
9589 | 9589 | Charles Milliken M000768 | rep | KY | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
9593 | 9593 | Frank Morey M000942 | rep | LA | 1875-12-06 | 1877-03-03 | Republican | 5 | |||||||||||||
9594 | 9594 | Charles Nash N000008 | rep | LA | 1875-12-06 | 1877-03-03 | Republican | 6 | |||||||||||||
9596 | 9596 | Lawrence Neal N000014 | rep | OH | 1875-12-06 | 1877-03-03 | Democrat | 7 | |||||||||||||
9597 | 9597 | Nelson Norton N000155 | rep | NY | 1875-12-06 | 1877-03-03 | Republican | 33 | |||||||||||||
9599 | 9599 | William O’Brien O000017 | rep | MD | 1875-12-06 | 1877-03-03 | Democrat | 3 | |||||||||||||
9600 | 9600 | Nathaniel Odell O000038 | rep | NY | 1875-12-06 | 1877-03-03 | Democrat | 12 | |||||||||||||
9604 | 9604 | John Packer P000008 | rep | PA | 1875-12-06 | 1877-03-03 | Republican | 14 | |||||||||||||
9605 | 9605 | Edward Parsons P000087 | rep | KY | 1875-12-06 | 1877-03-03 | Democrat | 5 | |||||||||||||
9607 | 9607 | Henry Pierce P000335 | rep | MA | 1875-12-06 | 1877-03-03 | Republican | 3 |
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);