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 sorted by district
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
9478 | 9478 | Allen Caperton C000130 | sen | WV | 1875-12-06 | 1877-03-03 | 1 | Democrat | |||||||||||||
9501 | 9501 | James English E000185 | sen | CT | 1875-12-06 | 1877-03-03 | 3 | Democrat | |||||||||||||
9721 | 9721 | James Blaine B000519 | sen | ME | 1876-07-10 | 1877-03-03 | 2 | Republican | |||||||||||||
9782 | 9782 | Henry Davis D000103 | sen | WV | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
9805 | 9805 | Thomas Ferry F000095 | sen | MI | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
9861 | 9861 | John Johnston J000191 | sen | VA | 1871-03-15 | 1877-03-03 | 2 | Democrat | |||||||||||||
10245 | 10245 | William Windom W000629 | sen | MN | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
10626 | 10626 | Henry Anthony A000262 | sen | RI | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
10874 | 10874 | Eli Saulsbury S000072 | sen | DE | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
11114 | 11114 | John Logan L000403 | sen | IL | 1871-03-04 | 1877-03-03 | 2 | Republican | |||||||||||||
11461 | 11461 | Thomas Norwood N000160 | sen | GA | 1871-03-04 | 1877-03-03 | 2 | Democrat | |||||||||||||
11926 | 11926 | Matt Ransom R000062 | sen | NC | 1872-01-01 | 1877-03-03 | 2 | Democrat | |||||||||||||
14492 | 14492 | Henry Teller T000116 | sen | CO | 1876-11-15 | 1877-03-03 | 2 | Republican | |||||||||||||
9451 | 9451 | Thomas Bennett B000383 | rep | ID | 1875-12-06 | 1877-03-03 | Independent | -1 | |||||||||||||
9506 | 9506 | Charles Faulkner F000044 | rep | VA | 1875-12-06 | 1877-03-03 | Democrat | -1 | |||||||||||||
9530 | 9530 | Samuel Hersey H000545 | rep | ME | 1875-12-06 | 1877-03-03 | Republican | -1 | |||||||||||||
9800 | 9800 | Stephen Fenn F000073 | rep | ID | 1875-12-06 | 1877-03-03 | Democrat | -1 | |||||||||||||
9858 | 9858 | Orange Jacobs J000037 | rep | WA | 1875-12-06 | 1877-03-03 | Republican | -1 | |||||||||||||
9867 | 9867 | Jefferson Kidder K000164 | rep | DK | 1875-12-06 | 1877-03-03 | Republican | -1 | |||||||||||||
10132 | 10132 | Burwell Lewis L000272 | rep | AL | 1875-12-06 | 1877-03-03 | Democrat | -1 | |||||||||||||
10285 | 10285 | George Cannon C000119 | rep | UT | 1875-12-06 | 1877-03-03 | Republican | -1 | |||||||||||||
10802 | 10802 | Martin Maginnis M000050 | rep | MT | 1875-12-06 | 1877-03-03 | Democrat | -1 | |||||||||||||
12164 | 12164 | William Forney F000280 | rep | AL | 1875-12-06 | 1877-03-03 | Democrat | -1 | |||||||||||||
14120 | 14120 | Thomas Patterson P000130 | rep | CO | 1875-12-06 | 1877-03-03 | Democrat | -1 | |||||||||||||
15094 | 15094 | Stephen Elkins E000110 | rep | NM | 1875-12-06 | 1877-03-03 | Republican | -1 | |||||||||||||
9643 | 9643 | William Steele S000840 | rep | WY | 1875-12-06 | 1877-03-03 | Democrat | 0 | |||||||||||||
9943 | 9943 | Hiram Stevens S000880 | rep | AZ | 1875-12-06 | 1877-03-03 | Democrat | 0 | |||||||||||||
9983 | 9983 | James Williams W000506 | rep | DE | 1875-12-06 | 1877-03-03 | Democrat | 0 | |||||||||||||
11551 | 11551 | William Woodburn W000710 | rep | NV | 1875-12-06 | 1877-03-03 | Republican | 0 | |||||||||||||
9469 | 9469 | James Buffinton B001040 | rep | MA | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
9472 | 9472 | John Burleigh B001107 | rep | ME | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
9484 | 9484 | Bernard Caulfield C000255 | rep | IL | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9490 | 9490 | Lorenzo Crounse C000935 | rep | NE | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
9521 | 9521 | Jeremiah Haralson H000179 | rep | AL | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
9550 | 9550 | Edward Kehr K000047 | rep | MO | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9562 | 9562 | George La Dow L000002 | rep | OR | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9564 | 9564 | La Lane L000064 | rep | OR | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
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 | |||||||||||||
9585 | 9585 | Henry Metcalfe M000673 | rep | NY | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9608 | 9608 | William Piper P000364 | rep | CA | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9616 | 9616 | William Purman P000572 | rep | FL | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
9654 | 9654 | Phillip Thomas T000182 | rep | MD | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9744 | 9744 | Andrew Boone B000629 | rep | KY | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9787 | 9787 | Beverly Douglas D000450 | rep | VA | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9794 | 9794 | Benjamin Eames E000005 | rep | RI | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
9814 | 9814 | Chapman Freeman F000361 | rep | PA | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
9816 | 9816 | Benoni Fuller F000406 | rep | IN | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9820 | 9820 | Lucien Gause G000100 | rep | AR | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9836 | 9836 | Julian Hartridge H000303 | rep | GA | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9863 | 9863 | Frank Jones J000219 | rep | NH | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9873 | 9873 | George Landers L000047 | rep | CT | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9895 | 9895 | William Phillips P000315 | rep | KS | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
9908 | 9908 | Joseph Rainey R000016 | rep | SC | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
9933 | 9933 | Milton Sayler S000101 | rep | OH | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9936 | 9936 | Clement Sinnickson S000447 | rep | NJ | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
9979 | 9979 | Alpheus Williams W000487 | rep | MI | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
10226 | 10226 | Jesse Yeates Y000016 | rep | NC | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
10313 | 10313 | William Crapo C000881 | rep | MA | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
10412 | 10412 | Charles Joyce J000275 | rep | VT | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
10590 | 10590 | Charles Williams W000492 | rep | WI | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
10597 | 10597 | Benjamin Wilson W000569 | rep | WV | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
10633 | 10633 | James Belford B000326 | rep | CO | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
10787 | 10787 | Lucius Lamar L000030 | rep | MS | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
11483 | 11483 | John Reagan R000098 | rep | TX | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
11742 | 11742 | Mark Dunnell D000555 | rep | MN | 1875-12-06 | 1877-03-03 | Republican | 1 | |||||||||||||
11764 | 11764 | Randall Gibson G000165 | rep | LA | 1875-12-06 | 1877-03-03 | Democrat | 1 | |||||||||||||
9450 | 9450 | Samuel Bell B000346 | rep | NH | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
9459 | 9459 | John Brown B000933 | rep | KY | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
9474 | 9474 | Charles Buttz B001202 | rep | SC | 1875-12-06 | 1877-03-03 | Republican | 2 | |||||||||||||
9494 | 9494 | Samuel Dobbins D000383 | rep | NJ | 1875-12-06 | 1877-03-03 | Republican | 2 | |||||||||||||
9511 | 9511 | John Goodin G000287 | rep | KS | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
9535 | 9535 | Andrew Humphreys H000959 | rep | IN | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
9538 | 9538 | John Hyman H001025 | rep | NC | 1875-12-06 | 1877-03-03 | Republican | 2 | |||||||||||||
9631 | 9631 | John Schumaker S000147 | rep | NY | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
9663 | 9663 | John Tufts T000406 | rep | IA | 1875-12-06 | 1877-03-03 | Republican | 2 | |||||||||||||
9670 | 9670 | Henry Waldron W000041 | rep | MI | 1875-12-06 | 1877-03-03 | Republican | 2 | |||||||||||||
9682 | 9682 | Josiah Walls W000093 | rep | FL | 1875-12-06 | 1877-03-03 | Republican | 2 | |||||||||||||
9689 | 9689 | Guilford Wells W000283 | rep | MS | 1875-12-06 | 1877-03-03 | Ind. Republican | 2 | |||||||||||||
9700 | 9700 | James Williams W000507 | rep | IN | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
9737 | 9737 | Henry Banning B000117 | rep | OH | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
9785 | 9785 | Dudley Denison D000236 | rep | VT | 1875-12-06 | 1877-03-03 | Ind. Republican | 2 | |||||||||||||
9833 | 9833 | Carter Harrison H000267 | rep | IL | 1875-12-06 | 1877-03-03 | Democrat | 2 | |||||||||||||
9920 | 9920 | Charles Roberts R000306 | rep | MD | 1875-12-06 | 1877-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);