legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
297 rows where "end" is on date 1871-03-03 sorted by party
This data as json, copyable, CSV (advanced)
Suggested facets: type, start, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8526 | 8526 | George Booker B000627 | rep | VA | 1869-03-04 | 1871-03-03 | Conservative | 4 | |||||||||||||
8601 | 8601 | James Gibson G000162 | rep | VA | 1869-03-04 | 1871-03-03 | Conservative | 8 | |||||||||||||
8669 | 8669 | Lewis McKenzie M000507 | rep | VA | 1869-03-04 | 1871-03-03 | Conservative | 7 | |||||||||||||
8670 | 8670 | William Milnes M000784 | rep | VA | 1869-03-04 | 1871-03-03 | Conservative | 6 | |||||||||||||
8702 | 8702 | Robert Ridgway R000248 | rep | VA | 1869-03-04 | 1871-03-03 | Conservative | 5 | |||||||||||||
8883 | 8883 | Richard Duke D000521 | rep | VA | 1869-03-04 | 1871-03-03 | Conservative | 5 | |||||||||||||
8182 | 8182 | Daniel Norton N000145 | sen | MN | 1865-12-04 | 1871-03-03 | 2 | Democrat | |||||||||||||
8200 | 8200 | Willard Saulsbury S000074 | sen | DE | 1865-12-04 | 1871-03-03 | 2 | Democrat | |||||||||||||
8510 | 8510 | Samuel Axtell A000349 | rep | CA | 1869-03-04 | 1871-03-03 | Democrat | 1 | |||||||||||||
8538 | 8538 | Albert Burr B001134 | rep | IL | 1869-03-04 | 1871-03-03 | Democrat | 10 | |||||||||||||
8541 | 8541 | Hervey Calkin C000047 | rep | NY | 1869-03-04 | 1871-03-03 | Democrat | 7 | |||||||||||||
8545 | 8545 | James Cavanaugh C000260 | rep | MT | 1869-03-04 | 1871-03-03 | Democrat | -1 | |||||||||||||
8554 | 8554 | Orestes Cleveland C000514 | rep | NJ | 1869-03-04 | 1871-03-03 | Democrat | 5 | |||||||||||||
8561 | 8561 | Stephen Corker C000776 | rep | GA | 1869-03-04 | 1871-03-03 | Democrat | 5 | |||||||||||||
8573 | 8573 | Edward Dickinson D000320 | rep | OH | 1869-03-04 | 1871-03-03 | Democrat | 9 | |||||||||||||
8600 | 8600 | John Fox F000331 | rep | NY | 1869-03-04 | 1871-03-03 | Democrat | 4 | |||||||||||||
8606 | 8606 | Jacob Golladay G000271 | rep | KY | 1869-03-04 | 1871-03-03 | Democrat | 3 | |||||||||||||
8609 | 8609 | George Greene G000426 | rep | NY | 1869-03-04 | 1871-03-03 | Democrat | 11 | |||||||||||||
8610 | 8610 | John Griswold G000485 | rep | NY | 1869-03-04 | 1871-03-03 | Democrat | 13 | |||||||||||||
8612 | 8612 | Charles Haight H000020 | rep | NJ | 1869-03-04 | 1871-03-03 | Democrat | 2 | |||||||||||||
8613 | 8613 | Patrick Hamill H000100 | rep | MD | 1869-03-04 | 1871-03-03 | Democrat | 4 | |||||||||||||
8626 | 8626 | Truman Hoag H000650 | rep | OH | 1869-03-04 | 1871-03-03 | Democrat | 10 | |||||||||||||
8642 | 8642 | James Johnson J000145 | rep | CA | 1869-03-04 | 1871-03-03 | Democrat | 3 | |||||||||||||
8665 | 8665 | John Manning M000109 | rep | NC | 1869-03-04 | 1871-03-03 | Democrat | 4 | |||||||||||||
8671 | 8671 | John Moffet M000838 | rep | PA | 1869-03-04 | 1871-03-03 | Democrat | 3 | |||||||||||||
8679 | 8679 | John Morrissey M001001 | rep | NY | 1869-03-04 | 1871-03-03 | Democrat | 5 | |||||||||||||
8681 | 8681 | William Mungen M001079 | rep | OH | 1869-03-04 | 1871-03-03 | Democrat | 5 | |||||||||||||
8684 | 8684 | Stephen Nuckolls N000166 | rep | WY | 1869-03-04 | 1871-03-03 | Democrat | 0 | |||||||||||||
8688 | 8688 | William Paine P000031 | rep | GA | 1869-03-04 | 1871-03-03 | Democrat | 1 | |||||||||||||
8699 | 8699 | John Reading R000096 | rep | PA | 1869-03-04 | 1871-03-03 | Democrat | 5 | |||||||||||||
8700 | 8700 | Henry Reeves R000138 | rep | NY | 1869-03-04 | 1871-03-03 | Democrat | 1 | |||||||||||||
8703 | 8703 | Anthony Rogers R000388 | rep | AR | 1869-03-04 | 1871-03-03 | Democrat | 2 | |||||||||||||
8717 | 8717 | Jacob Shafer S000276 | rep | ID | 1869-03-04 | 1871-03-03 | Democrat | -1 | |||||||||||||
8719 | 8719 | William Sherrod S000352 | rep | AL | 1869-03-04 | 1871-03-03 | Democrat | 6 | |||||||||||||
8720 | 8720 | Joseph Smith S000581 | rep | OR | 1869-03-04 | 1871-03-03 | Democrat | 1 | |||||||||||||
8730 | 8730 | John Stiles S000924 | rep | PA | 1869-03-04 | 1871-03-03 | Democrat | 6 | |||||||||||||
8738 | 8738 | Frederick Stone S000957 | rep | MD | 1869-03-04 | 1871-03-03 | Democrat | 5 | |||||||||||||
8739 | 8739 | Peter Strader S000987 | rep | OH | 1869-03-04 | 1871-03-03 | Democrat | 1 | |||||||||||||
8745 | 8745 | William Sweeney S001104 | rep | KY | 1869-03-04 | 1871-03-03 | Democrat | 2 | |||||||||||||
8750 | 8750 | Nelson Tift T000269 | rep | GA | 1869-03-04 | 1871-03-03 | Democrat | -1 | |||||||||||||
8756 | 8756 | Lawrence Trimble T000375 | rep | KY | 1869-03-04 | 1871-03-03 | Democrat | 1 | |||||||||||||
8758 | 8758 | Daniel Van Auken V000014 | rep | PA | 1869-03-04 | 1871-03-03 | Democrat | 11 | |||||||||||||
8784 | 8784 | Eugene Wilson W000578 | rep | MN | 1869-03-04 | 1871-03-03 | Democrat | 2 | |||||||||||||
8789 | 8789 | George Woodward W000730 | rep | PA | 1869-03-04 | 1871-03-03 | Democrat | 12 | |||||||||||||
8813 | 8813 | Benjamin Biggs B000457 | rep | DE | 1869-03-04 | 1871-03-03 | Democrat | 0 | |||||||||||||
8823 | 8823 | John Bird B000478 | rep | NJ | 1869-03-04 | 1871-03-03 | Democrat | 3 | |||||||||||||
8860 | 8860 | John Conner C000691 | rep | TX | 1869-03-04 | 1871-03-03 | Democrat | 2 | |||||||||||||
8871 | 8871 | John Crebs C000900 | rep | IL | 1869-03-04 | 1871-03-03 | Democrat | 13 | |||||||||||||
8880 | 8880 | Peter Dox D000478 | rep | AL | 1869-03-04 | 1871-03-03 | Democrat | 5 | |||||||||||||
8909 | 8909 | James Getz G000145 | rep | PA | 1869-03-04 | 1871-03-03 | Democrat | 8 | |||||||||||||
8915 | 8915 | Richard Haldeman H000027 | rep | PA | 1869-03-04 | 1871-03-03 | Democrat | 15 | |||||||||||||
8919 | 8919 | Samuel Hambleton H000095 | rep | MD | 1869-03-04 | 1871-03-03 | Democrat | 1 | |||||||||||||
8937 | 8937 | William Hooper H000767 | rep | UT | 1869-03-04 | 1871-03-03 | Democrat | -1 | |||||||||||||
8943 | 8943 | Joseph Lewis L000289 | rep | KY | 1869-03-04 | 1871-03-03 | Democrat | 3 | |||||||||||||
8954 | 8954 | James McCormick M000367 | rep | MO | 1869-03-04 | 1871-03-03 | Democrat | 3 | |||||||||||||
8961 | 8961 | Thompson McNeely M000585 | rep | IL | 1869-03-04 | 1871-03-03 | Democrat | 9 | |||||||||||||
8974 | 8974 | George Morgan M000950 | rep | OH | 1869-03-04 | 1871-03-03 | Democrat | 13 | |||||||||||||
8995 | 8995 | William Price P000533 | rep | GA | 1869-03-04 | 1871-03-03 | Democrat | 6 | |||||||||||||
8999 | 8999 | John Rice R000202 | rep | KY | 1869-03-04 | 1871-03-03 | Democrat | 9 | |||||||||||||
9014 | 9014 | Francis Shober S000372 | rep | NC | 1869-03-04 | 1871-03-03 | Democrat | 6 | |||||||||||||
9048 | 9048 | Philadelph Van Trump V000060 | rep | OH | 1869-03-04 | 1871-03-03 | Democrat | 12 | |||||||||||||
9063 | 9063 | Boyd Winchester W000628 | rep | KY | 1869-03-04 | 1871-03-03 | Democrat | 5 | |||||||||||||
9068 | 9068 | George Adams A000035 | rep | KY | 1869-03-04 | 1871-03-03 | Democrat | 8 | |||||||||||||
9074 | 9074 | Stevenson Archer A000274 | rep | MD | 1869-03-04 | 1871-03-03 | Democrat | 2 | |||||||||||||
9105 | 9105 | James Brooks B000881 | rep | NY | 1869-03-04 | 1871-03-03 | Democrat | 8 | |||||||||||||
9162 | 9162 | Charles Eldredge E000103 | rep | WI | 1869-03-04 | 1871-03-03 | Democrat | 4 | |||||||||||||
9248 | 9248 | Samuel Marshall M000160 | rep | IL | 1869-03-04 | 1871-03-03 | Democrat | 11 | |||||||||||||
9260 | 9260 | Thomas McCreery M000385 | sen | KY | 1868-01-01 | 1871-03-03 | 2 | Democrat | |||||||||||||
9293 | 9293 | William Niblack N000083 | rep | IN | 1869-03-04 | 1871-03-03 | Democrat | 1 | |||||||||||||
9429 | 9429 | Pierce Young Y000048 | rep | GA | 1869-03-04 | 1871-03-03 | Democrat | 7 | |||||||||||||
9548 | 9548 | Thomas Jones J000253 | rep | KY | 1869-03-04 | 1871-03-03 | Democrat | 6 | |||||||||||||
9555 | 9555 | Michael Kerr K000143 | rep | IN | 1869-03-04 | 1871-03-03 | Democrat | 2 | |||||||||||||
9629 | 9629 | John Schumaker S000147 | rep | NY | 1869-03-04 | 1871-03-03 | Democrat | 2 | |||||||||||||
9710 | 9710 | William Barnum B000166 | rep | CT | 1869-03-04 | 1871-03-03 | Democrat | 4 | |||||||||||||
9860 | 9860 | John Johnston J000191 | sen | VA | 1870-01-26 | 1871-03-03 | 2 | Democrat | |||||||||||||
9887 | 9887 | Stephen Mayham M000282 | rep | NY | 1869-03-04 | 1871-03-03 | Democrat | 14 | |||||||||||||
9898 | 9898 | Clarkson Potter P000461 | rep | NY | 1869-03-04 | 1871-03-03 | Democrat | 10 | |||||||||||||
9947 | 9947 | Thomas Swann S001092 | rep | MD | 1869-03-04 | 1871-03-03 | Democrat | 3 | |||||||||||||
10213 | 10213 | Erastus Wells W000282 | rep | MO | 1869-03-04 | 1871-03-03 | Democrat | 1 | |||||||||||||
10419 | 10419 | James Knott K000290 | rep | KY | 1869-03-04 | 1871-03-03 | Democrat | 4 | |||||||||||||
10609 | 10609 | Fernando Wood W000694 | rep | NY | 1869-03-04 | 1871-03-03 | Democrat | 9 | |||||||||||||
10892 | 10892 | Henry Slocum S000496 | rep | NY | 1869-03-04 | 1871-03-03 | Democrat | 3 | |||||||||||||
11205 | 11205 | Louis St. Martin S000768 | rep | LA | 1869-03-04 | 1871-03-03 | Democrat | -1 | |||||||||||||
11600 | 11600 | James Beck B000289 | rep | KY | 1869-03-04 | 1871-03-03 | Democrat | 7 | |||||||||||||
11695 | 11695 | Samuel Cox C000839 | rep | NY | 1869-03-04 | 1871-03-03 | Democrat | 6 | |||||||||||||
11915 | 11915 | Samuel Randall R000039 | rep | PA | 1869-03-04 | 1871-03-03 | Democrat | 1 | |||||||||||||
12348 | 12348 | Daniel Voorhees V000116 | rep | IN | 1869-03-04 | 1871-03-03 | Democrat | 6 | |||||||||||||
13338 | 13338 | William Holman H000732 | rep | IN | 1869-03-04 | 1871-03-03 | Democrat | 3 | |||||||||||||
8144 | 8144 | Jacob Howard H000839 | sen | MI | 1865-12-04 | 1871-03-03 | 2 | Republican | |||||||||||||
8235 | 8235 | Waitman Willey W000484 | sen | WV | 1865-12-04 | 1871-03-03 | 2 | Republican | |||||||||||||
8236 | 8236 | George Williams W000498 | sen | OR | 1865-12-04 | 1871-03-03 | 2 | Republican | |||||||||||||
8242 | 8242 | Richard Yates Y000012 | sen | IL | 1865-12-04 | 1871-03-03 | 2 | Republican | |||||||||||||
8243 | 8243 | Alexander Cattell C000254 | sen | NJ | 1866-01-01 | 1871-03-03 | 2 | Republican | |||||||||||||
8245 | 8245 | Joseph Fowler F000324 | sen | TN | 1866-01-01 | 1871-03-03 | 2 | Republican | |||||||||||||
8247 | 8247 | Edmund Ross R000445 | sen | KS | 1866-01-01 | 1871-03-03 | 2 | Republican | |||||||||||||
8315 | 8315 | Charles Drake D000484 | sen | MO | 1867-03-04 | 1871-03-03 | 3 | Republican | |||||||||||||
8459 | 8459 | John Thayer T000148 | sen | NE | 1867-03-04 | 1871-03-03 | 2 | Republican | |||||||||||||
8493 | 8493 | Joseph Abbott A000006 | sen | NC | 1868-01-01 | 1871-03-03 | 2 | Republican | |||||||||||||
8494 | 8494 | John Harris H000246 | sen | LA | 1868-01-01 | 1871-03-03 | 2 | Republican | |||||||||||||
8495 | 8495 | Alexander McDonald M000408 | sen | AR | 1868-01-01 | 1871-03-03 | 2 | Republican |
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);