legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
230 rows where "start" is on date 1865-12-04 sorted by district
This data as json, copyable, CSV (advanced)
Suggested facets: type, class, district, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8097 | 8097 | John Creswell C000904 | sen | MD | 1865-12-04 | 1867-03-03 | 3 | Unconditional Unionist | |||||||||||||
8117 | 8117 | William Fessenden F000099 | sen | ME | 1865-12-04 | 1869-12-31 | 2 | Republican | |||||||||||||
8128 | 8128 | James Grimes G000475 | sen | IA | 1865-12-04 | 1869-12-31 | 2 | Republican | |||||||||||||
8131 | 8131 | James Guthrie G000534 | sen | KY | 1865-12-04 | 1869-03-03 | 2 | Democrat | |||||||||||||
8144 | 8144 | Jacob Howard H000839 | sen | MI | 1865-12-04 | 1871-03-03 | 2 | Republican | |||||||||||||
8164 | 8164 | James Lane L000061 | sen | KS | 1865-12-04 | 1867-03-03 | 2 | Republican | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
8731 | 8731 | John Stockton S000939 | sen | NJ | 1865-12-04 | 1867-03-03 | 2 | Democrat | |||||||||||||
8869 | 8869 | Aaron Cragin C000852 | sen | NH | 1865-12-04 | 1871-03-03 | 2 | Republican | |||||||||||||
9058 | 9058 | Henry Wilson W000585 | sen | MA | 1865-12-04 | 1871-03-03 | 2 | Republican | |||||||||||||
10625 | 10625 | Henry Anthony A000262 | sen | RI | 1865-12-04 | 1871-03-03 | 2 | Republican | |||||||||||||
10839 | 10839 | Luke Poland P000406 | sen | VT | 1865-12-04 | 1867-03-03 | 3 | Republican | |||||||||||||
8109 | 8109 | Arthur Denny D000247 | rep | WA | 1865-12-04 | 1867-03-03 | Republican | -1 | |||||||||||||
8175 | 8175 | Samuel McLean M000551 | rep | MT | 1865-12-04 | 1867-03-03 | Democrat | -1 | |||||||||||||
8278 | 8278 | Walter Burleigh B001108 | rep | DK | 1865-12-04 | 1867-03-03 | Republican | -1 | |||||||||||||
8356 | 8356 | Edward Holbrook H000710 | rep | ID | 1865-12-04 | 1867-03-03 | Democrat | -1 | |||||||||||||
8532 | 8532 | Allen Bradford B000737 | rep | CO | 1865-12-04 | 1867-03-03 | Republican | -1 | |||||||||||||
8546 | 8546 | José Chaves C000337 | rep | NM | 1865-12-04 | 1867-03-03 | Republican | -1 | |||||||||||||
8643 | 8643 | Alexander Jones J000208 | rep | NC | 1865-12-04 | 1867-03-03 | Republican | -1 | |||||||||||||
8932 | 8932 | Phineas Hitchcock H000648 | rep | NE | 1865-12-04 | 1867-03-03 | Republican | -1 | |||||||||||||
8935 | 8935 | William Hooper H000767 | rep | UT | 1865-12-04 | 1867-03-03 | Democrat | -1 | |||||||||||||
10817 | 10817 | Samuel Moulton M001047 | rep | IL | 1865-12-04 | 1867-03-03 | Republican | -1 | |||||||||||||
11204 | 11204 | Louis St. Martin S000768 | rep | LA | 1865-12-04 | 1867-03-03 | Democrat | -1 | |||||||||||||
13336 | 13336 | William Holman H000732 | rep | IN | 1865-12-04 | 1867-03-03 | Democrat | -1 | |||||||||||||
8119 | 8119 | John Goodwin G000301 | rep | AZ | 1865-12-04 | 1867-03-03 | Republican | 0 | |||||||||||||
8250 | 8250 | Delos Ashley A000312 | rep | NV | 1865-12-04 | 1867-03-03 | Republican | 0 | |||||||||||||
8404 | 8404 | John Nicholson N000099 | rep | DE | 1865-12-04 | 1867-03-03 | Democrat | 0 | |||||||||||||
8108 | 8108 | Henry Deming D000227 | rep | CT | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8138 | 8138 | James Henderson H000480 | rep | OR | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8140 | 8140 | John Hogan H000691 | rep | MO | 1865-12-04 | 1867-03-03 | Democrat | 1 | |||||||||||||
8176 | 8176 | Donald McRuer M000600 | rep | CA | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8207 | 8207 | John Starr S000817 | rep | NJ | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8212 | 8212 | Nathaniel Taylor T000095 | rep | TN | 1865-12-04 | 1867-03-03 | Unionist | 1 | |||||||||||||
8229 | 8229 | John Wentworth W000295 | rep | IL | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8322 | 8322 | Benjamin Eggleston E000090 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8328 | 8328 | Thomas Eliot E000106 | rep | MA | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8362 | 8362 | Chester Hubbard H000879 | rep | WV | 1865-12-04 | 1867-03-03 | Unconditional Unionist | 1 | |||||||||||||
8383 | 8383 | Turner Marquette M000140 | rep | NE | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8391 | 8391 | Hiram McCullough M000395 | rep | MD | 1865-12-04 | 1867-03-03 | Democrat | 1 | |||||||||||||
8457 | 8457 | Stephen Taber T000002 | rep | NY | 1865-12-04 | 1867-03-03 | Democrat | 1 | |||||||||||||
8491 | 8491 | Frederick Woodbridge W000708 | rep | VT | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8516 | 8516 | Fernando Beaman B000275 | rep | MI | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8551 | 8551 | Sidney Clarke C000470 | rep | KS | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8638 | 8638 | Thomas Jenckes J000076 | rep | RI | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8685 | 8685 | Halbert Paine P000028 | rep | WI | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8754 | 8754 | Lawrence Trimble T000375 | rep | KY | 1865-12-04 | 1867-03-03 | Democrat | 1 | |||||||||||||
8945 | 8945 | John Lynch L000531 | rep | ME | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
9291 | 9291 | William Niblack N000083 | rep | IN | 1865-12-04 | 1867-03-03 | Democrat | 1 | |||||||||||||
10242 | 10242 | William Windom W000629 | rep | MN | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
11834 | 11834 | Gilman Marston M000165 | rep | NH | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
11913 | 11913 | Samuel Randall R000039 | rep | PA | 1865-12-04 | 1867-03-03 | Democrat | 1 | |||||||||||||
12044 | 12044 | James Wilson W000594 | rep | IA | 1865-12-04 | 1867-03-03 | Republican | 1 | |||||||||||||
8085 | 8085 | Teunis Bergen B000406 | rep | NY | 1865-12-04 | 1867-03-03 | Democrat | 2 | |||||||||||||
8088 | 8088 | Henry Blow B000572 | rep | MO | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8165 | 8165 | George Latham L000107 | rep | WV | 1865-12-04 | 1867-03-03 | Unconditional Unionist | 2 | |||||||||||||
8181 | 8181 | William Newell N000066 | rep | NJ | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8195 | 8195 | Burwell Ritter R000276 | rep | KY | 1865-12-04 | 1867-03-03 | Democrat | 2 | |||||||||||||
8203 | 8203 | Ithamar Sloan S000492 | rep | WI | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8216 | 8216 | John Thomas T000174 | rep | MD | 1865-12-04 | 1867-03-03 | Unconditional Unionist | 2 | |||||||||||||
8219 | 8219 | Samuel Warner W000157 | rep | CT | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8223 | 8223 | Edwin Webster W000239 | rep | MD | 1865-12-04 | 1867-03-03 | Unconditional Unionist | 2 | |||||||||||||
8313 | 8313 | Ignatius Donnelly D000417 | rep | MN | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8351 | 8351 | William Higby H000576 | rep | CA | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8415 | 8415 | Sidney Perham P000226 | rep | ME | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8477 | 8477 | Charles Upson U000027 | rep | MI | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8577 | 8577 | Nathan Dixon D000375 | rep | RI | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8803 | 8803 | Oakes Ames A000175 | rep | MA | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8890 | 8890 | John Farnsworth F000024 | rep | IL | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
9255 | 9255 | Horace Maynard M000284 | rep | TN | 1865-12-04 | 1867-03-03 | Unconditional Unionist | 2 | |||||||||||||
9553 | 9553 | Michael Kerr K000143 | rep | IN | 1865-12-04 | 1867-03-03 | Democrat | 2 | |||||||||||||
9727 | 9727 | Rutherford Hayes H000393 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
9926 | 9926 | Edward Rollins R000411 | rep | NH | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
10173 | 10173 | Hiram Price P000525 | rep | IA | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
12715 | 12715 | Charles O’Neill O000093 | rep | PA | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
13430 | 13430 | Justin Morrill M000969 | rep | VT | 1865-12-04 | 1867-03-03 | Republican | 2 | |||||||||||||
8084 | 8084 | Portus Baxter B000246 | rep | VT | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8086 | 8086 | John Bidwell B000447 | rep | CA | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8090 | 8090 | Augustus Brandegee B000768 | rep | CT | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8126 | 8126 | Henry Grider G000455 | rep | KY | 1865-12-04 | 1867-03-03 | Democrat | 3 | |||||||||||||
8139 | 8139 | Ralph Hill H000604 | rep | IN | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8151 | 8151 | James Humphrey H000954 | rep | NY | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8152 | 8152 | John Hunter H000984 | rep | NY | 1865-12-04 | 1867-03-03 | Democrat | 3 | |||||||||||||
8170 | 8170 | John Longyear L000434 | rep | MI | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8191 | 8191 | Alexander Rice R000193 | rep | MA | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8232 | 8232 | Kellian Whaley W000318 | rep | WV | 1865-12-04 | 1867-03-03 | Unconditional Unionist | 3 | |||||||||||||
8354 | 8354 | Elijah Hise H000644 | rep | KY | 1865-12-04 | 1867-03-03 | Democrat | 3 | |||||||||||||
8406 | 8406 | Thomas Noell N000123 | rep | MO | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8412 | 8412 | James Patterson P000120 | rep | NH | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8418 | 8418 | Charles Phelps P000292 | rep | MD | 1865-12-04 | 1867-03-03 | Unconditional Unionist | 3 | |||||||||||||
8443 | 8443 | Charles Sitgreaves S000458 | rep | NJ | 1865-12-04 | 1867-03-03 | Democrat | 3 | |||||||||||||
8558 | 8558 | Amasa Cobb C000543 | rep | WI | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8712 | 8712 | Robert Schenck S000118 | rep | OH | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
8734 | 8734 | William Stokes S000950 | rep | TN | 1865-12-04 | 1867-03-03 | Unconditional Unionist | 3 | |||||||||||||
8773 | 8773 | Elihu Washburne W000176 | rep | IL | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
9282 | 9282 | Leonard Myers M001131 | rep | PA | 1865-12-04 | 1867-03-03 | Republican | 3 | |||||||||||||
9715 | 9715 | James Blaine B000519 | rep | ME | 1865-12-04 | 1867-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);