legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
220 rows where "end" is on date 1865-03-03 sorted by legislator_id
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7905 | 7905 | James Allen A000128 | rep | IL | 1863-12-07 | 1865-03-03 | Democrat | -1 | |||||||||||||
7907 | 7907 | William Allen A000152 | rep | IL | 1863-12-07 | 1865-03-03 | Democrat | 13 | |||||||||||||
8076 | 8076 | John Alley A000155 | rep | MA | 1863-12-07 | 1865-03-03 | Republican | 5 | |||||||||||||
14227 | 14227 | William Allison A000160 | rep | IA | 1863-12-07 | 1865-03-03 | Republican | 3 | |||||||||||||
8802 | 8802 | Oakes Ames A000175 | rep | MA | 1863-12-07 | 1865-03-03 | Republican | 2 | |||||||||||||
8079 | 8079 | Sydenham Ancona A000178 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 8 | |||||||||||||
7908 | 7908 | Lucien Anderson A000201 | rep | KY | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 1 | |||||||||||||
10624 | 10624 | Henry Anthony A000262 | sen | RI | 1859-12-05 | 1865-03-03 | 2 | Republican | |||||||||||||
7910 | 7910 | Isaac Arnold A000288 | rep | IL | 1863-12-07 | 1865-03-03 | Republican | 1 | |||||||||||||
8254 | 8254 | James Ashley A000314 | rep | OH | 1863-12-07 | 1865-03-03 | Republican | 10 | |||||||||||||
7912 | 7912 | Joseph Bailey B000043 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 15 | |||||||||||||
7913 | 7913 | Augustus Baldwin B000085 | rep | MI | 1863-12-07 | 1865-03-03 | Democrat | 5 | |||||||||||||
8257 | 8257 | John Baldwin B000091 | rep | MA | 1863-12-07 | 1865-03-03 | Republican | 8 | |||||||||||||
8083 | 8083 | Portus Baxter B000246 | rep | VT | 1863-12-07 | 1865-03-03 | Republican | 3 | |||||||||||||
8264 | 8264 | James Bayard B000248 | sen | DE | 1863-12-07 | 1865-03-03 | 1 | Democrat | |||||||||||||
8515 | 8515 | Fernando Beaman B000275 | rep | MI | 1863-12-07 | 1865-03-03 | Republican | 1 | |||||||||||||
7915 | 7915 | Hiram Bennet B000369 | rep | CO | 1863-12-07 | 1865-03-03 | Conservative Republican | -1 | |||||||||||||
9714 | 9714 | James Blaine B000519 | rep | ME | 1863-12-07 | 1865-03-03 | Republican | 3 | |||||||||||||
8831 | 8831 | Francis Blair B000523 | rep | MO | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 1 | |||||||||||||
7917 | 7917 | Jacob Blair B000525 | rep | WV | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 1 | |||||||||||||
7919 | 7919 | George Bliss B000559 | rep | OH | 1863-12-07 | 1865-03-03 | Democrat | 14 | |||||||||||||
8087 | 8087 | Henry Blow B000572 | rep | MO | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 2 | |||||||||||||
9093 | 9093 | George Boutwell B000674 | rep | MA | 1863-12-07 | 1865-03-03 | Republican | 7 | |||||||||||||
7920 | 7920 | Lemuel Bowden B000678 | sen | VA | 1863-12-07 | 1865-03-03 | 1 | Unionist | |||||||||||||
8530 | 8530 | Sempronius Boyd B000720 | rep | MO | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 4 | |||||||||||||
8089 | 8089 | Augustus Brandegee B000768 | rep | CT | 1863-12-07 | 1865-03-03 | Republican | 3 | |||||||||||||
9102 | 9102 | James Brooks B000881 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 8 | |||||||||||||
8273 | 8273 | John Broomall B000889 | rep | PA | 1863-12-07 | 1865-03-03 | Republican | 7 | |||||||||||||
7922 | 7922 | James Brown B000922 | rep | WI | 1863-12-07 | 1865-03-03 | Democrat | 1 | |||||||||||||
7926 | 7926 | William Brown B000948 | rep | VA | 1863-12-07 | 1865-03-03 | Unconditional Unionist | -1 | |||||||||||||
7689 | 7689 | John Carlile C000150 | sen | VA | 1861-07-09 | 1865-03-03 | 2 | Unionist | |||||||||||||
8282 | 8282 | John Chanler C000302 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 7 | |||||||||||||
7928 | 7928 | Ambrose Clark C000420 | rep | NY | 1863-12-07 | 1865-03-03 | Republican | 20 | |||||||||||||
9118 | 9118 | Freeman Clarke C000461 | rep | NY | 1863-12-07 | 1865-03-03 | Republican | 28 | |||||||||||||
7929 | 7929 | Brutus Clay C000479 | rep | KY | 1863-12-07 | 1865-03-03 | Unionist | 7 | |||||||||||||
8557 | 8557 | Amasa Cobb C000543 | rep | WI | 1863-12-07 | 1865-03-03 | Republican | 3 | |||||||||||||
10046 | 10046 | Alexander Coffroth C000593 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 16 | |||||||||||||
8288 | 8288 | Cornelius Cole C000607 | rep | CA | 1863-12-07 | 1865-03-03 | Republican | -1 | |||||||||||||
7930 | 7930 | George Cole C000609 | rep | WA | 1863-12-07 | 1865-03-03 | Democrat | -1 | |||||||||||||
8294 | 8294 | Schuyler Colfax C000626 | rep | IN | 1863-12-07 | 1865-03-03 | Republican | 9 | |||||||||||||
7934 | 7934 | Erastus Corning C000784 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 14 | |||||||||||||
11694 | 11694 | Samuel Cox C000839 | rep | OH | 1863-12-07 | 1865-03-03 | Democrat | 7 | |||||||||||||
7936 | 7936 | James Cravens C000883 | rep | IN | 1863-12-07 | 1865-03-03 | Democrat | 2 | |||||||||||||
8096 | 8096 | John Creswell C000904 | rep | MD | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 1 | |||||||||||||
7939 | 7939 | Samuel Daily D000006 | rep | NE | 1863-12-07 | 1865-03-03 | Republican | -1 | |||||||||||||
7943 | 7943 | Henry Davis D000104 | rep | MD | 1863-12-07 | 1865-03-03 | Unconditional Unionist | 3 | |||||||||||||
8100 | 8100 | Thomas Davis D000139 | rep | NY | 1863-12-07 | 1865-03-03 | Republican | 23 | |||||||||||||
11339 | 11339 | Henry Dawes D000148 | rep | MA | 1863-12-07 | 1865-03-03 | Republican | 10 | |||||||||||||
8104 | 8104 | John Dawson D000153 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 21 | |||||||||||||
8107 | 8107 | Henry Deming D000227 | rep | CT | 1863-12-07 | 1865-03-03 | Republican | 1 | |||||||||||||
8308 | 8308 | Charles Denison D000235 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 12 | |||||||||||||
8576 | 8576 | Nathan Dixon D000375 | rep | RI | 1863-12-07 | 1865-03-03 | Republican | 2 | |||||||||||||
8312 | 8312 | Ignatius Donnelly D000417 | rep | MN | 1863-12-07 | 1865-03-03 | Republican | 2 | |||||||||||||
8316 | 8316 | John Driggs D000498 | rep | MI | 1863-12-07 | 1865-03-03 | Republican | 6 | |||||||||||||
8111 | 8111 | Ebenezer Dumont D000524 | rep | IN | 1863-12-07 | 1865-03-03 | Republican | 6 | |||||||||||||
8319 | 8319 | Ephraim Eckley E000036 | rep | OH | 1863-12-07 | 1865-03-03 | Republican | 17 | |||||||||||||
11019 | 11019 | John Eden E000042 | rep | IL | 1863-12-07 | 1865-03-03 | Democrat | 7 | |||||||||||||
7950 | 7950 | Joseph Edgerton E000047 | rep | IN | 1863-12-07 | 1865-03-03 | Democrat | 10 | |||||||||||||
9159 | 9159 | Charles Eldredge E000103 | rep | WI | 1863-12-07 | 1865-03-03 | Democrat | 4 | |||||||||||||
8327 | 8327 | Thomas Eliot E000106 | rep | MA | 1863-12-07 | 1865-03-03 | Republican | 1 | |||||||||||||
9500 | 9500 | James English E000185 | rep | CT | 1863-12-07 | 1865-03-03 | Democrat | 2 | |||||||||||||
8889 | 8889 | John Farnsworth F000024 | rep | IL | 1863-12-07 | 1865-03-03 | Republican | 2 | |||||||||||||
8070 | 8070 | Nathan Farwell F000038 | sen | ME | 1864-01-01 | 1865-03-03 | 2 | Republican | |||||||||||||
8593 | 8593 | Reuben Fenton F000077 | rep | NY | 1863-12-07 | 1865-03-03 | Republican | 31 | |||||||||||||
8116 | 8116 | William Fessenden F000099 | sen | ME | 1859-12-05 | 1865-03-03 | 2 | Republican | |||||||||||||
9171 | 9171 | William Finck F000118 | rep | OH | 1863-12-07 | 1865-03-03 | Democrat | 12 | |||||||||||||
7958 | 7958 | Augustus Frank F000338 | rep | NY | 1863-12-07 | 1865-03-03 | Republican | 29 | |||||||||||||
7959 | 7959 | John Ganson G000042 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 30 | |||||||||||||
10230 | 10230 | James Garfield G000063 | rep | OH | 1863-12-07 | 1865-03-03 | Republican | 19 | |||||||||||||
9180 | 9180 | Daniel Gooch G000274 | rep | MA | 1863-12-07 | 1865-03-03 | Republican | 6 | |||||||||||||
8125 | 8125 | Henry Grider G000455 | rep | KY | 1863-12-07 | 1865-03-03 | Unionist | 3 | |||||||||||||
8127 | 8127 | James Grimes G000475 | sen | IA | 1859-12-05 | 1865-03-03 | 2 | Republican | |||||||||||||
8129 | 8129 | Josiah Grinnell G000478 | rep | IA | 1863-12-07 | 1865-03-03 | Republican | 4 | |||||||||||||
8339 | 8339 | John Griswold G000486 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 15 | |||||||||||||
7962 | 7962 | James Hale H000032 | rep | PA | 1863-12-07 | 1865-03-03 | Ind. Republican | 18 | |||||||||||||
7429 | 7429 | John Hale H000034 | sen | NH | 1859-12-05 | 1865-03-03 | 2 | Republican | |||||||||||||
7964 | 7964 | William Hall H000079 | rep | MO | 1863-12-07 | 1865-03-03 | Unionist | 8 | |||||||||||||
8133 | 8133 | Aaron Harding H000187 | rep | KY | 1863-12-07 | 1865-03-03 | Unionist | 4 | |||||||||||||
7896 | 7896 | Benjamin Harding H000189 | sen | OR | 1862-01-01 | 1865-03-03 | 2 | Democrat | |||||||||||||
7965 | 7965 | Henry Harrington H000229 | rep | IN | 1863-12-07 | 1865-03-03 | Democrat | 3 | |||||||||||||
8135 | 8135 | Benjamin Harris H000232 | rep | MD | 1863-12-07 | 1865-03-03 | Democrat | 5 | |||||||||||||
7966 | 7966 | Charles Harris H000234 | rep | IL | 1863-12-07 | 1865-03-03 | Democrat | 4 | |||||||||||||
7970 | 7970 | Anson Herrick H000537 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 9 | |||||||||||||
8350 | 8350 | William Higby H000576 | rep | CA | 1863-12-07 | 1865-03-03 | Republican | -1 | |||||||||||||
13335 | 13335 | William Holman H000732 | rep | IN | 1863-12-07 | 1865-03-03 | Democrat | 4 | |||||||||||||
9203 | 9203 | Samuel Hooper H000765 | rep | MA | 1863-12-07 | 1865-03-03 | Republican | 4 | |||||||||||||
8630 | 8630 | Giles Hotchkiss H000808 | rep | NY | 1863-12-07 | 1865-03-03 | Republican | 26 | |||||||||||||
8143 | 8143 | Jacob Howard H000839 | sen | MI | 1862-01-01 | 1865-03-03 | 2 | Republican | |||||||||||||
8359 | 8359 | Asahel Hubbard H000877 | rep | IA | 1863-12-07 | 1865-03-03 | Republican | 6 | |||||||||||||
8146 | 8146 | John Hubbard H000885 | rep | CT | 1863-12-07 | 1865-03-03 | Republican | 4 | |||||||||||||
8365 | 8365 | Calvin Hulburd H000936 | rep | NY | 1863-12-07 | 1865-03-03 | Republican | 17 | |||||||||||||
7971 | 7971 | Wells Hutchins H001010 | rep | OH | 1863-12-07 | 1865-03-03 | Democrat | 11 | |||||||||||||
8633 | 8633 | Ebon Ingersoll I000017 | rep | IL | 1863-12-07 | 1865-03-03 | Republican | 5 | |||||||||||||
7972 | 7972 | William Jayne J000066 | rep | DK | 1863-12-07 | 1865-03-03 | -1 | ||||||||||||||
8637 | 8637 | Thomas Jenckes J000076 | rep | RI | 1863-12-07 | 1865-03-03 | Republican | 1 | |||||||||||||
8154 | 8154 | Philip Johnson J000168 | rep | PA | 1863-12-07 | 1865-03-03 | Democrat | 11 | |||||||||||||
7975 | 7975 | William Johnston J000201 | rep | OH | 1863-12-07 | 1865-03-03 | Democrat | 8 | |||||||||||||
8650 | 8650 | George Julian J000280 | rep | IN | 1863-12-07 | 1865-03-03 | Republican | 5 | |||||||||||||
7976 | 7976 | Martin Kalbfleisch K000005 | rep | NY | 1863-12-07 | 1865-03-03 | Democrat | 2 | |||||||||||||
10773 | 10773 | John Kasson K000018 | rep | IA | 1863-12-07 | 1865-03-03 | Republican | 5 |
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);