legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
225 rows where "start" is on date 1863-12-07 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14227 | 14227 | William Allison A000160 | rep | IA | 1863-12-07 | 1865-03-03 | Republican | 3 | |||||||||||||
13429 | 13429 | Justin Morrill M000969 | rep | VT | 1863-12-07 | 1865-03-03 | Republican | 2 | |||||||||||||
13335 | 13335 | William Holman H000732 | rep | IN | 1863-12-07 | 1865-03-03 | Democrat | 4 | |||||||||||||
12833 | 12833 | David Turpie T000432 | sen | IN | 1863-12-07 | 1863-12-31 | 1 | Democrat | |||||||||||||
12714 | 12714 | Charles O’Neill O000093 | rep | PA | 1863-12-07 | 1865-03-03 | Republican | 2 | |||||||||||||
12346 | 12346 | Daniel Voorhees V000116 | rep | IN | 1863-12-07 | 1865-03-03 | Democrat | 7 | |||||||||||||
12043 | 12043 | James Wilson W000594 | rep | IA | 1863-12-07 | 1865-03-03 | Republican | 1 | |||||||||||||
11912 | 11912 | Samuel Randall R000039 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 1 | |||||||||||||
11785 | 11785 | William Kelley K000062 | rep | PA | 1863-12-07 | 1865-03-03 | Republican | 4 | |||||||||||||
11694 | 11694 | Samuel Cox C000839 | rep | OH | 1863-12-07 | 1865-03-03 | Democrat | 7 | |||||||||||||
11629 | 11629 | Charles Buckalew B001019 | sen | PA | 1863-12-07 | 1869-03-03 | 1 | Democrat | |||||||||||||
11339 | 11339 | Henry Dawes D000148 | rep | MA | 1863-12-07 | 1865-03-03 | Republican | 10 | |||||||||||||
11242 | 11242 | William Wadsworth W000015 | rep | KY | 1863-12-07 | 1865-03-03 | Unionist | 9 | |||||||||||||
11134 | 11134 | William Morrison M001000 | rep | IL | 1863-12-07 | 1865-03-03 | Democrat | 12 | |||||||||||||
11019 | 11019 | John Eden E000042 | rep | IL | 1863-12-07 | 1865-03-03 | Democrat | 7 | |||||||||||||
10773 | 10773 | John Kasson K000018 | rep | IA | 1863-12-07 | 1865-03-03 | Republican | 5 | |||||||||||||
10607 | 10607 | Fernando Wood W000694 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 5 | |||||||||||||
10604 | 10604 | Benjamin Wood W000690 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 4 | |||||||||||||
10485 | 10485 | Godlove Orth O000106 | rep | IN | 1863-12-07 | 1865-03-03 | Republican | 8 | |||||||||||||
10241 | 10241 | William Windom W000629 | rep | MN | 1863-12-07 | 1865-03-03 | Republican | 1 | |||||||||||||
10230 | 10230 | James Garfield G000063 | rep | OH | 1863-12-07 | 1865-03-03 | Republican | 19 | |||||||||||||
10172 | 10172 | Hiram Price P000525 | rep | IA | 1863-12-07 | 1865-03-03 | Republican | 2 | |||||||||||||
10165 | 10165 | George Pendleton P000203 | rep | OH | 1863-12-07 | 1865-03-03 | Democrat | 1 | |||||||||||||
10046 | 10046 | Alexander Coffroth C000593 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 16 | |||||||||||||
10028 | 10028 | Zachariah Chandler C000299 | sen | MI | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
9925 | 9925 | Edward Rollins R000411 | rep | NH | 1863-12-07 | 1865-03-03 | Republican | 2 | |||||||||||||
9714 | 9714 | James Blaine B000519 | rep | ME | 1863-12-07 | 1865-03-03 | Republican | 3 | |||||||||||||
9685 | 9685 | Elijah Ward W000131 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 6 | |||||||||||||
9586 | 9586 | Samuel Miller M000752 | rep | NY | 1863-12-07 | 1865-03-03 | Republican | 19 | |||||||||||||
9551 | 9551 | Francis Kernan K000133 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 21 | |||||||||||||
9500 | 9500 | James English E000185 | rep | CT | 1863-12-07 | 1865-03-03 | Democrat | 2 | |||||||||||||
9434 | 9434 | William Washburn W000174 | rep | MA | 1863-12-07 | 1865-03-03 | Republican | 9 | |||||||||||||
9343 | 9343 | Glenni Scofield S000164 | rep | PA | 1863-12-07 | 1865-03-03 | Republican | 19 | |||||||||||||
9333 | 9333 | James Robinson R000336 | rep | IL | 1863-12-07 | 1865-03-03 | Democrat | 11 | |||||||||||||
9281 | 9281 | Leonard Myers M001131 | rep | PA | 1863-12-07 | 1865-03-03 | Republican | 3 | |||||||||||||
9203 | 9203 | Samuel Hooper H000765 | rep | MA | 1863-12-07 | 1865-03-03 | Republican | 4 | |||||||||||||
9180 | 9180 | Daniel Gooch G000274 | rep | MA | 1863-12-07 | 1865-03-03 | Republican | 6 | |||||||||||||
9171 | 9171 | William Finck F000118 | rep | OH | 1863-12-07 | 1865-03-03 | Democrat | 12 | |||||||||||||
9159 | 9159 | Charles Eldredge E000103 | rep | WI | 1863-12-07 | 1865-03-03 | Democrat | 4 | |||||||||||||
9118 | 9118 | Freeman Clarke C000461 | rep | NY | 1863-12-07 | 1865-03-03 | Republican | 28 | |||||||||||||
9102 | 9102 | James Brooks B000881 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 8 | |||||||||||||
9093 | 9093 | George Boutwell B000674 | rep | MA | 1863-12-07 | 1865-03-03 | Republican | 7 | |||||||||||||
9038 | 9038 | Dwight Townsend T000331 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 1 | |||||||||||||
8979 | 8979 | Lot Morrill M000970 | sen | ME | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
8959 | 8959 | John McKinney M000525 | rep | OH | 1863-12-07 | 1865-03-03 | Democrat | 4 | |||||||||||||
8889 | 8889 | John Farnsworth F000024 | rep | IL | 1863-12-07 | 1865-03-03 | Republican | 2 | |||||||||||||
8831 | 8831 | Francis Blair B000523 | rep | MO | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 1 | |||||||||||||
8802 | 8802 | Oakes Ames A000175 | rep | MA | 1863-12-07 | 1865-03-03 | Republican | 2 | |||||||||||||
8772 | 8772 | Elihu Washburne W000176 | rep | IL | 1863-12-07 | 1865-03-03 | Republican | 3 | |||||||||||||
8743 | 8743 | Charles Sumner S001068 | sen | MA | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
8729 | 8729 | John Stiles S000924 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 6 | |||||||||||||
8724 | 8724 | William Sprague S000747 | sen | RI | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
8711 | 8711 | Robert Schenck S000118 | rep | OH | 1863-12-07 | 1865-03-03 | Republican | 3 | |||||||||||||
8697 | 8697 | Alexander Ramsey R000026 | sen | MN | 1863-12-07 | 1869-03-03 | 1 | Republican | |||||||||||||
8650 | 8650 | George Julian J000280 | rep | IN | 1863-12-07 | 1865-03-03 | Republican | 5 | |||||||||||||
8637 | 8637 | Thomas Jenckes J000076 | rep | RI | 1863-12-07 | 1865-03-03 | Republican | 1 | |||||||||||||
8633 | 8633 | Ebon Ingersoll I000017 | rep | IL | 1863-12-07 | 1865-03-03 | Republican | 5 | |||||||||||||
8630 | 8630 | Giles Hotchkiss H000808 | rep | NY | 1863-12-07 | 1865-03-03 | Republican | 26 | |||||||||||||
8593 | 8593 | Reuben Fenton F000077 | rep | NY | 1863-12-07 | 1865-03-03 | Republican | 31 | |||||||||||||
8576 | 8576 | Nathan Dixon D000375 | rep | RI | 1863-12-07 | 1865-03-03 | Republican | 2 | |||||||||||||
8557 | 8557 | Amasa Cobb C000543 | rep | WI | 1863-12-07 | 1865-03-03 | Republican | 3 | |||||||||||||
8530 | 8530 | Sempronius Boyd B000720 | rep | MO | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 4 | |||||||||||||
8515 | 8515 | Fernando Beaman B000275 | rep | MI | 1863-12-07 | 1865-03-03 | Republican | 1 | |||||||||||||
8490 | 8490 | Frederick Woodbridge W000708 | rep | VT | 1863-12-07 | 1865-03-03 | Republican | 1 | |||||||||||||
8485 | 8485 | Thomas Williams W000538 | rep | PA | 1863-12-07 | 1865-03-03 | Republican | 23 | |||||||||||||
8476 | 8476 | Charles Upson U000027 | rep | MI | 1863-12-07 | 1865-03-03 | Republican | 2 | |||||||||||||
8466 | 8466 | Francis Thomas T000166 | rep | MD | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 4 | |||||||||||||
8452 | 8452 | Thaddeus Stevens S000887 | rep | PA | 1863-12-07 | 1865-03-03 | Republican | 9 | |||||||||||||
8445 | 8445 | Rufus Spalding S000697 | rep | OH | 1863-12-07 | 1865-03-03 | Republican | 18 | |||||||||||||
8439 | 8439 | Lewis Ross R000451 | rep | IL | 1863-12-07 | 1865-03-03 | Democrat | 9 | |||||||||||||
8435 | 8435 | John Pruyn P000554 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 14 | |||||||||||||
8432 | 8432 | Theodore Pomeroy P000424 | rep | NY | 1863-12-07 | 1865-03-03 | Republican | 24 | |||||||||||||
8422 | 8422 | Frederick Pike P000346 | rep | ME | 1863-12-07 | 1865-03-03 | Republican | 5 | |||||||||||||
8414 | 8414 | Sidney Perham P000226 | rep | ME | 1863-12-07 | 1865-03-03 | Republican | 2 | |||||||||||||
8411 | 8411 | James Patterson P000120 | rep | NH | 1863-12-07 | 1865-03-03 | Republican | 3 | |||||||||||||
8399 | 8399 | James Moorhead M000929 | rep | PA | 1863-12-07 | 1865-03-03 | Republican | 22 | |||||||||||||
8388 | 8388 | Joseph McClurg M000347 | rep | MO | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 5 | |||||||||||||
8385 | 8385 | James Marvin M000210 | rep | NY | 1863-12-07 | 1865-03-03 | Republican | 18 | |||||||||||||
8378 | 8378 | Benjamin Loan L000384 | rep | MO | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 7 | |||||||||||||
8372 | 8372 | Francis Kellogg K000064 | rep | MI | 1863-12-07 | 1865-03-03 | Republican | 4 | |||||||||||||
8365 | 8365 | Calvin Hulburd H000936 | rep | NY | 1863-12-07 | 1865-03-03 | Republican | 17 | |||||||||||||
8359 | 8359 | Asahel Hubbard H000877 | rep | IA | 1863-12-07 | 1865-03-03 | Republican | 6 | |||||||||||||
8350 | 8350 | William Higby H000576 | rep | CA | 1863-12-07 | 1865-03-03 | Republican | -1 | |||||||||||||
8339 | 8339 | John Griswold G000486 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 15 | |||||||||||||
8327 | 8327 | Thomas Eliot E000106 | rep | MA | 1863-12-07 | 1865-03-03 | Republican | 1 | |||||||||||||
8319 | 8319 | Ephraim Eckley E000036 | rep | OH | 1863-12-07 | 1865-03-03 | Republican | 17 | |||||||||||||
8316 | 8316 | John Driggs D000498 | rep | MI | 1863-12-07 | 1865-03-03 | Republican | 6 | |||||||||||||
8312 | 8312 | Ignatius Donnelly D000417 | rep | MN | 1863-12-07 | 1865-03-03 | Republican | 2 | |||||||||||||
8308 | 8308 | Charles Denison D000235 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 12 | |||||||||||||
8294 | 8294 | Schuyler Colfax C000626 | rep | IN | 1863-12-07 | 1865-03-03 | Republican | 9 | |||||||||||||
8288 | 8288 | Cornelius Cole C000607 | rep | CA | 1863-12-07 | 1865-03-03 | Republican | -1 | |||||||||||||
8282 | 8282 | John Chanler C000302 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 7 | |||||||||||||
8273 | 8273 | John Broomall B000889 | rep | PA | 1863-12-07 | 1865-03-03 | Republican | 7 | |||||||||||||
8264 | 8264 | James Bayard B000248 | sen | DE | 1863-12-07 | 1865-03-03 | 1 | Democrat | |||||||||||||
8257 | 8257 | John Baldwin B000091 | rep | MA | 1863-12-07 | 1865-03-03 | Republican | 8 | |||||||||||||
8254 | 8254 | James Ashley A000314 | rep | OH | 1863-12-07 | 1865-03-03 | Republican | 10 | |||||||||||||
8237 | 8237 | Charles Winfield W000630 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 11 | |||||||||||||
8234 | 8234 | Waitman Willey W000484 | sen | WV | 1863-12-07 | 1865-03-03 | 2 | Unconditional Unionist | |||||||||||||
8231 | 8231 | Kellian Whaley W000318 | rep | WV | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 3 | |||||||||||||
8222 | 8222 | Edwin Webster W000239 | rep | MD | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 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);