legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
271 rows where "end" is on date 1869-03-03 sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: state, party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7898 | 7898 | John Henderson H000483 | sen | MO | 1863-03-04 | 1869-03-03 | 1 | Republican | |||||||||||||
7931 | 7931 | John Conness C000695 | sen | CA | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
7947 | 7947 | James Dixon D000369 | sen | CT | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
7949 | 7949 | James Doolittle D000428 | sen | WI | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
7969 | 7969 | Thomas Hendricks H000493 | sen | IN | 1863-12-07 | 1869-03-03 | 1 | Democrat | |||||||||||||
7974 | 7974 | Reverdy Johnson J000169 | sen | MD | 1863-12-07 | 1869-03-03 | 1 | Democrat | |||||||||||||
8001 | 8001 | Edwin Morgan M000949 | sen | NY | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
8051 | 8051 | Peter Van Winkle V000066 | sen | WV | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
8054 | 8054 | Benjamin Wade W000005 | sen | OH | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
8131 | 8131 | James Guthrie G000534 | sen | KY | 1865-12-04 | 1869-03-03 | 2 | Democrat | |||||||||||||
8246 | 8246 | David Patterson P000110 | sen | TN | 1866-01-01 | 1869-03-03 | 1 | Democrat | |||||||||||||
8265 | 8265 | James Bayard B000248 | sen | DE | 1867-03-04 | 1869-03-03 | 1 | Democrat | |||||||||||||
8502 | 8502 | Adonijah Welch W000261 | sen | FL | 1868-01-01 | 1869-03-03 | 1 | Republican | |||||||||||||
8697 | 8697 | Alexander Ramsey R000026 | sen | MN | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
8724 | 8724 | William Sprague S000747 | sen | RI | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
8743 | 8743 | Charles Sumner S001068 | sen | MA | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
8752 | 8752 | Thomas Tipton T000286 | sen | NE | 1867-03-04 | 1869-03-03 | 1 | Republican | |||||||||||||
8900 | 8900 | Frederick Frelinghuysen F000369 | sen | NJ | 1866-01-01 | 1869-03-03 | 1 | Republican | |||||||||||||
8979 | 8979 | Lot Morrill M000970 | sen | ME | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
10028 | 10028 | Zachariah Chandler C000299 | sen | MI | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
11358 | 11358 | George Edmunds E000056 | sen | VT | 1866-01-01 | 1869-03-03 | 1 | Republican | |||||||||||||
11629 | 11629 | Charles Buckalew B001019 | sen | PA | 1863-12-07 | 1869-03-03 | 1 | Democrat | |||||||||||||
13801 | 13801 | William Stewart S000922 | sen | NV | 1864-01-01 | 1869-03-03 | 1 | Republican | |||||||||||||
14959 | 14959 | William Whyte W000435 | sen | MD | 1868-01-01 | 1869-03-03 | 1 | Democrat | |||||||||||||
8279 | 8279 | Walter Burleigh B001108 | rep | DK | 1867-03-04 | 1869-03-03 | Republican | -1 | |||||||||||||
8287 | 8287 | Charles Clever C000517 | rep | NM | 1867-03-04 | 1869-03-03 | -1 | ||||||||||||||
8333 | 8333 | Alvan Flanders F000188 | rep | WA | 1867-03-04 | 1869-03-03 | Republican | -1 | |||||||||||||
8357 | 8357 | Edward Holbrook H000710 | rep | ID | 1867-03-04 | 1869-03-03 | Democrat | -1 | |||||||||||||
8384 | 8384 | Turner Marquette M000140 | rep | NE | 1867-03-04 | 1869-03-03 | Republican | -1 | |||||||||||||
8544 | 8544 | James Cavanaugh C000260 | rep | MT | 1867-03-04 | 1869-03-03 | Democrat | -1 | |||||||||||||
8547 | 8547 | José Chaves C000337 | rep | NM | 1867-03-04 | 1869-03-03 | Republican | -1 | |||||||||||||
8701 | 8701 | Robert Ridgway R000248 | rep | VA | 1867-03-04 | 1869-03-03 | Whig | -1 | |||||||||||||
8936 | 8936 | William Hooper H000767 | rep | UT | 1867-03-04 | 1869-03-03 | Democrat | -1 | |||||||||||||
9266 | 9266 | George McKee M000494 | rep | MS | 1867-03-04 | 1869-03-03 | Republican | -1 | |||||||||||||
9457 | 9457 | John Brown B000933 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | -1 | |||||||||||||
10621 | 10621 | George Chilcott C000352 | rep | CO | 1867-03-04 | 1869-03-03 | Republican | -1 | |||||||||||||
11112 | 11112 | John Logan L000403 | rep | IL | 1867-03-04 | 1869-03-03 | Republican | -1 | |||||||||||||
8251 | 8251 | Delos Ashley A000312 | rep | NV | 1867-03-04 | 1869-03-03 | Republican | 0 | |||||||||||||
8261 | 8261 | Coles Bashford B000219 | rep | AZ | 1867-03-04 | 1869-03-03 | Independent | 0 | |||||||||||||
8405 | 8405 | John Nicholson N000099 | rep | DE | 1867-03-04 | 1869-03-03 | Democrat | 0 | |||||||||||||
8323 | 8323 | Benjamin Eggleston E000090 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8329 | 8329 | Thomas Eliot E000106 | rep | MA | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8334 | 8334 | John French F000378 | rep | NC | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8363 | 8363 | Chester Hubbard H000879 | rep | WV | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8364 | 8364 | Richard Hubbard H000888 | rep | CT | 1867-03-04 | 1869-03-03 | Democrat | 1 | |||||||||||||
8373 | 8373 | Francis Kellogg K000064 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8381 | 8381 | Rufus Mallory M000083 | rep | OR | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8392 | 8392 | Hiram McCullough M000395 | rep | MD | 1867-03-04 | 1869-03-03 | Democrat | 1 | |||||||||||||
8425 | 8425 | William Pile P000350 | rep | MO | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8458 | 8458 | Stephen Taber T000002 | rep | NY | 1867-03-04 | 1869-03-03 | Democrat | 1 | |||||||||||||
8492 | 8492 | Frederick Woodbridge W000708 | rep | VT | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8509 | 8509 | Samuel Axtell A000349 | rep | CA | 1867-03-04 | 1869-03-03 | Democrat | 1 | |||||||||||||
8517 | 8517 | Fernando Beaman B000275 | rep | MI | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8552 | 8552 | Sidney Clarke C000470 | rep | KS | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8555 | 8555 | Joseph Clift C000519 | rep | GA | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8587 | 8587 | Jacob Ela E000099 | rep | NH | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8614 | 8614 | Charles Hamilton H000105 | rep | FL | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8639 | 8639 | Thomas Jenckes J000076 | rep | RI | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8646 | 8646 | Norman Judd J000277 | rep | IL | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8673 | 8673 | William Moore M000922 | rep | NJ | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8686 | 8686 | Halbert Paine P000028 | rep | WI | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8704 | 8704 | Logan Roots R000434 | rep | AR | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8755 | 8755 | Lawrence Trimble T000375 | rep | KY | 1867-03-04 | 1869-03-03 | Democrat | 1 | |||||||||||||
8780 | 8780 | Benjamin Whittemore W000427 | rep | SC | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8946 | 8946 | John Lynch L000531 | rep | ME | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
9035 | 9035 | John Taffe T000006 | rep | NE | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
9292 | 9292 | William Niblack N000083 | rep | IN | 1867-03-04 | 1869-03-03 | Democrat | 1 | |||||||||||||
9389 | 9389 | Jacob Sypher S001140 | rep | LA | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
10243 | 10243 | William Windom W000629 | rep | MN | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
11312 | 11312 | Roderick Butler B001188 | rep | TN | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
11914 | 11914 | Samuel Randall R000039 | rep | PA | 1867-03-04 | 1869-03-03 | Democrat | 1 | |||||||||||||
12045 | 12045 | James Wilson W000594 | rep | IA | 1867-03-04 | 1869-03-03 | Republican | 1 | |||||||||||||
8260 | 8260 | Demas Barnes B000156 | rep | NY | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
8281 | 8281 | Samuel Cary C000216 | rep | OH | 1867-03-04 | 1869-03-03 | Ind. Republican | 2 | |||||||||||||
8314 | 8314 | Ignatius Donnelly D000417 | rep | MN | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8330 | 8330 | James Elliott E000123 | rep | AR | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8352 | 8352 | William Higby H000576 | rep | CA | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8353 | 8353 | James Hinds H000631 | rep | AR | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8358 | 8358 | Julius Hotchkiss H000809 | rep | CT | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
8374 | 8374 | Bethuel Kitchen K000247 | rep | WV | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8382 | 8382 | James Mann M000103 | rep | LA | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
8403 | 8403 | Carman Newcomb N000065 | rep | MO | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8416 | 8416 | Sidney Perham P000226 | rep | ME | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8478 | 8478 | Charles Upson U000027 | rep | MI | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8528 | 8528 | Christopher Bowen B000681 | rep | SC | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8578 | 8578 | Nathan Dixon D000375 | rep | RI | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8611 | 8611 | Charles Haight H000020 | rep | NJ | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
8623 | 8623 | David Heaton H000432 | rep | NC | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8628 | 8628 | Benjamin Hopkins H000771 | rep | WI | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8726 | 8726 | Aaron Stevens S000875 | rep | NH | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8749 | 8749 | Nelson Tift T000269 | rep | GA | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
8804 | 8804 | Oakes Ames A000175 | rep | MA | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8841 | 8841 | Charles Buckley B001025 | rep | AL | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
8891 | 8891 | John Farnsworth F000024 | rep | IL | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
9073 | 9073 | Stevenson Archer A000274 | rep | MD | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
9256 | 9256 | Horace Maynard M000284 | rep | TN | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
9554 | 9554 | Michael Kerr K000143 | rep | IN | 1867-03-04 | 1869-03-03 | Democrat | 2 | |||||||||||||
9728 | 9728 | Rutherford Hayes H000393 | rep | OH | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
10174 | 10174 | Hiram Price P000525 | rep | IA | 1867-03-04 | 1869-03-03 | Republican | 2 | |||||||||||||
10840 | 10840 | Luke Poland P000406 | rep | VT | 1867-03-04 | 1869-03-03 | Republican | 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);