\begin{tabular}{rllllll} \hline rowid & type & start & end & party & how & executive_id \\ \hline 1 & prez & 1789-04-30 & 1793-03-04 & no party & election & George Washington \\ 2 & prez & 1793-03-04 & 1797-03-04 & no party & election & George Washington \\ 3 & viceprez & 1789-04-21 & 1793-03-04 & Federalist & election & John Adams \\ 4 & viceprez & 1793-03-04 & 1797-03-04 & Federalist & election & John Adams \\ 5 & prez & 1797-03-04 & 1801-03-04 & Federalist & election & John Adams \\ 6 & viceprez & 1797-03-04 & 1801-03-04 & Democratic-Republican & election & Thomas Jefferson \\ 7 & prez & 1801-03-04 & 1805-03-04 & Democratic-Republican & election & Thomas Jefferson \\ 8 & prez & 1805-03-04 & 1809-03-04 & Democratic-Republican & election & Thomas Jefferson \\ 9 & viceprez & 1801-03-04 & 1805-03-04 & Democratic-Republican & election & Aaron Burr \\ 10 & viceprez & 1805-03-04 & 1809-03-04 & Democratic-Republican & election & George Clinton \\ 11 & viceprez & 1809-03-04 & 1812-04-20 & Democratic-Republican & election & George Clinton \\ 12 & viceprez & 1813-03-04 & 1814-11-23 & Democratic-Republican & election & Elbridge Gerry \\ 13 & prez & 1809-03-04 & 1813-03-04 & Democratic-Republican & election & James Madison \\ 14 & prez & 1813-03-04 & 1817-03-04 & Democratic-Republican & election & James Madison \\ 15 & viceprez & 1817-03-04 & 1821-03-05 & Democratic-Republican & election & Daniel Tompkins \\ 16 & viceprez & 1821-03-05 & 1825-03-04 & Democratic-Republican & election & Daniel Tompkins \\ 17 & prez & 1817-03-04 & 1821-03-05 & Democratic-Republican & election & James Monroe \\ 18 & prez & 1821-03-05 & 1825-03-04 & Democratic-Republican & election & James Monroe \\ 19 & prez & 1825-03-04 & 1829-03-04 & Democratic-Republican & election & John Adams \\ 20 & viceprez & 1825-03-04 & 1829-03-04 & Democratic-Republican & election & John Calhoun \\ 21 & viceprez & 1829-03-04 & 1832-12-28 & Democratic & election & John Calhoun \\ 22 & prez & 1829-03-04 & 1833-03-04 & Democratic & election & Andrew Jackson \\ 23 & prez & 1833-03-04 & 1837-03-04 & Democratic & election & Andrew Jackson \\ 24 & viceprez & 1837-03-04 & 1841-03-04 & Democratic & election & Richard Johnson \\ 25 & viceprez & 1833-03-04 & 1837-03-04 & Democratic & election & Martin Van Buren \\ 26 & prez & 1837-03-04 & 1841-03-04 & Democratic & election & Martin Van Buren \\ 27 & prez & 1841-03-04 & 1841-04-04 & Whig & election & William Harrison \\ 28 & viceprez & 1841-03-04 & 1841-04-04 & Whig & election & John Tyler \\ 29 & prez & 1841-04-04 & 1845-03-04 & Whig & succession & John Tyler \\ 30 & viceprez & 1845-03-04 & 1849-03-04 & Democratic & election & George Dallas \\ 31 & prez & 1845-03-04 & 1849-03-04 & Democratic & election & James Polk \\ 32 & prez & 1849-03-04 & 1850-07-09 & Whig & election & Zachary Taylor \\ 33 & viceprez & 1849-03-04 & 1850-07-09 & Whig & election & Millard Fillmore \\ 34 & prez & 1850-07-09 & 1853-03-04 & Whig & succession & Millard Fillmore \\ 35 & viceprez & 1853-03-04 & 1853-04-18 & Democratic & election & William King \\ 36 & prez & 1853-03-04 & 1857-03-04 & Democratic & election & Franklin Pierce \\ 37 & viceprez & 1857-03-04 & 1861-03-04 & Democratic & election & John Breckinridge \\ 38 & prez & 1857-03-04 & 1861-03-04 & Democratic & election & James Buchanan \\ 39 & viceprez & 1861-03-04 & 1865-03-04 & Republican & election & Hannibal Hamlin \\ 40 & prez & 1861-03-04 & 1865-03-04 & Republican & election & Abraham Lincoln \\ 41 & prez & 1865-03-04 & 1865-04-15 & Republican & election & Abraham Lincoln \\ 42 & viceprez & 1865-03-04 & 1865-04-15 & Democratic & election & Andrew Johnson \\ 43 & prez & 1865-04-15 & 1869-03-04 & Democratic & succession & Andrew Johnson \\ 44 & viceprez & 1869-03-04 & 1873-03-04 & Republican & election & Schuyler Colfax \\ 45 & viceprez & 1873-03-04 & 1875-11-22 & Republican & election & Henry Wilson \\ 46 & prez & 1869-03-04 & 1873-03-04 & Republican & election & Ulysses Grant \\ 47 & prez & 1873-03-04 & 1877-03-04 & Republican & election & Ulysses Grant \\ 48 & viceprez & 1877-03-04 & 1881-03-04 & Republican & election & William Wheeler \\ 49 & prez & 1877-03-04 & 1881-03-04 & Republican & election & Rutherford Hayes \\ 50 & prez & 1881-03-04 & 1881-09-19 & Republican & election & James Garfield \\ 51 & viceprez & 1881-03-04 & 1881-09-19 & Republican & election & Chester Arthur \\ 52 & prez & 1881-09-19 & 1885-03-04 & Republican & succession & Chester Arthur \\ 53 & viceprez & 1885-03-04 & 1885-11-25 & Democratic & election & Thomas Hendricks \\ 54 & viceprez & 1889-03-04 & 1893-03-04 & Republican & election & Levi Morton \\ 55 & prez & 1889-03-04 & 1893-03-04 & Republican & election & Benjamin Harrison \\ 56 & viceprez & 1893-03-04 & 1897-03-04 & Democratic & election & Adlai Stevenson \\ 57 & prez & 1885-03-04 & 1889-03-04 & Democratic & election & Grover Cleveland \\ 58 & prez & 1893-03-04 & 1897-03-04 & Democratic & election & Grover Cleveland \\ 59 & viceprez & 1897-03-04 & 1899-11-21 & Republican & election & Garret Hobart \\ 60 & prez & 1897-03-04 & 1901-03-04 & Republican & election & William McKinley \\ 61 & prez & 1901-03-04 & 1901-09-14 & Republican & election & William McKinley \\ 62 & viceprez & 1905-03-04 & 1909-03-04 & Republican & election & Charles Fairbanks \\ 63 & viceprez & 1901-03-04 & 1901-09-14 & Republican & election & Theodore Roosevelt \\ 64 & prez & 1901-09-14 & 1905-03-04 & Republican & succession & Theodore Roosevelt \\ 65 & prez & 1905-03-04 & 1909-03-04 & Republican & election & Theodore Roosevelt \\ 66 & viceprez & 1909-03-04 & 1912-10-30 & Republican & election & James Sherman \\ 67 & prez & 1909-03-04 & 1913-03-04 & Republican & election & William Taft \\ 68 & viceprez & 1913-03-04 & 1917-03-04 & Democratic & election & Thomas Marshall \\ 69 & viceprez & 1917-03-04 & 1921-03-04 & Democratic & election & Thomas Marshall \\ 70 & prez & 1913-03-04 & 1917-03-04 & Democratic & election & Woodrow Wilson \\ 71 & prez & 1917-03-04 & 1921-03-04 & Democratic & election & Woodrow Wilson \\ 72 & prez & 1921-03-04 & 1923-08-02 & Republican & election & Warren Harding \\ 73 & viceprez & 1925-03-04 & 1929-03-04 & Republican & election & Charles Dawes \\ 74 & viceprez & 1921-03-04 & 1923-08-02 & Republican & election & Calvin Coolidge \\ 75 & prez & 1923-08-02 & 1925-03-04 & Republican & succession & Calvin Coolidge \\ 76 & prez & 1925-03-04 & 1929-03-04 & Republican & election & Calvin Coolidge \\ 77 & viceprez & 1929-03-04 & 1933-03-04 & Republican & election & Charles Curtis \\ 78 & prez & 1929-03-04 & 1933-03-04 & Republican & election & Herbert Hoover \\ 79 & viceprez & 1933-03-04 & 1937-01-20 & Democratic & election & John Garner \\ 80 & viceprez & 1937-01-20 & 1941-01-20 & Democratic & election & John Garner \\ 81 & viceprez & 1941-01-20 & 1945-01-20 & Democratic & election & Henry Wallace \\ 82 & prez & 1933-03-04 & 1937-01-20 & Democratic & election & Franklin Roosevelt \\ 83 & prez & 1937-01-20 & 1941-01-20 & Democratic & election & Franklin Roosevelt \\ 84 & prez & 1941-01-20 & 1945-01-20 & Democratic & election & Franklin Roosevelt \\ 85 & prez & 1945-01-20 & 1945-04-12 & Democratic & election & Franklin Roosevelt \\ 86 & viceprez & 1949-01-20 & 1953-01-20 & Democratic & election & Alben Barkley \\ 87 & viceprez & 1945-01-20 & 1945-04-12 & Democratic & election & Harry Truman \\ 88 & prez & 1945-04-12 & 1949-01-20 & Democratic & succession & Harry Truman \\ 89 & prez & 1949-01-20 & 1953-01-20 & Democratic & election & Harry Truman \\ 90 & prez & 1953-01-20 & 1957-01-20 & Republican & election & Dwight Eisenhower \\ 91 & prez & 1957-01-20 & 1961-01-20 & Republican & election & Dwight Eisenhower \\ 92 & prez & 1961-01-20 & 1963-11-22 & Democratic & election & John Kennedy \\ 93 & viceprez & 1965-01-20 & 1969-01-20 & Democratic & election & Hubert Humphrey \\ 94 & viceprez & 1961-01-20 & 1963-11-22 & Democratic & election & Lyndon Johnson \\ 95 & prez & 1963-11-22 & 1965-01-20 & Democratic & succession & Lyndon Johnson \\ 96 & prez & 1965-01-20 & 1969-01-20 & Democratic & election & Lyndon Johnson \\ 97 & viceprez & 1969-01-20 & 1973-01-20 & Republican & election & Spiro Agnew \\ 98 & viceprez & 1973-01-20 & 1973-10-10 & Republican & election & Spiro Agnew \\ 99 & viceprez & 1953-01-20 & 1957-01-20 & Republican & election & Richard Nixon \\ 100 & viceprez & 1957-01-20 & 1961-01-20 & Republican & election & Richard Nixon \\ \hline \end{tabular}