╔═════════╦══════════╦════════════╦════════════╦═══════════════════════╦════════════╦════════════════╗ ║ rowid ║ type ║ start ║ end ║ party ║ how ║ executive_id ║ ╠═════════╬══════════╬════════════╬════════════╬═══════════════════════╬════════════╬════════════════╣ ║ 1 ║ prez ║ 1789-04-30 ║ 1793-03-04 ║ no party ║ election ║ 1 ║ ║ 2 ║ prez ║ 1793-03-04 ║ 1797-03-04 ║ no party ║ election ║ 1 ║ ║ 3 ║ viceprez ║ 1789-04-21 ║ 1793-03-04 ║ Federalist ║ election ║ 2 ║ ║ 4 ║ viceprez ║ 1793-03-04 ║ 1797-03-04 ║ Federalist ║ election ║ 2 ║ ║ 5 ║ prez ║ 1797-03-04 ║ 1801-03-04 ║ Federalist ║ election ║ 2 ║ ║ 6 ║ viceprez ║ 1797-03-04 ║ 1801-03-04 ║ Democratic-Republican ║ election ║ 3 ║ ║ 7 ║ prez ║ 1801-03-04 ║ 1805-03-04 ║ Democratic-Republican ║ election ║ 3 ║ ║ 8 ║ prez ║ 1805-03-04 ║ 1809-03-04 ║ Democratic-Republican ║ election ║ 3 ║ ║ 9 ║ viceprez ║ 1801-03-04 ║ 1805-03-04 ║ Democratic-Republican ║ election ║ 4 ║ ║ 10 ║ viceprez ║ 1805-03-04 ║ 1809-03-04 ║ Democratic-Republican ║ election ║ 5 ║ ║ 11 ║ viceprez ║ 1809-03-04 ║ 1812-04-20 ║ Democratic-Republican ║ election ║ 5 ║ ║ 12 ║ viceprez ║ 1813-03-04 ║ 1814-11-23 ║ Democratic-Republican ║ election ║ 6 ║ ║ 13 ║ prez ║ 1809-03-04 ║ 1813-03-04 ║ Democratic-Republican ║ election ║ 7 ║ ║ 14 ║ prez ║ 1813-03-04 ║ 1817-03-04 ║ Democratic-Republican ║ election ║ 7 ║ ║ 15 ║ viceprez ║ 1817-03-04 ║ 1821-03-05 ║ Democratic-Republican ║ election ║ 8 ║ ║ 16 ║ viceprez ║ 1821-03-05 ║ 1825-03-04 ║ Democratic-Republican ║ election ║ 8 ║ ║ 17 ║ prez ║ 1817-03-04 ║ 1821-03-05 ║ Democratic-Republican ║ election ║ 9 ║ ║ 18 ║ prez ║ 1821-03-05 ║ 1825-03-04 ║ Democratic-Republican ║ election ║ 9 ║ ║ 19 ║ prez ║ 1825-03-04 ║ 1829-03-04 ║ Democratic-Republican ║ election ║ 10 ║ ║ 20 ║ viceprez ║ 1825-03-04 ║ 1829-03-04 ║ Democratic-Republican ║ election ║ 11 ║ ║ 21 ║ viceprez ║ 1829-03-04 ║ 1832-12-28 ║ Democratic ║ election ║ 11 ║ ║ 22 ║ prez ║ 1829-03-04 ║ 1833-03-04 ║ Democratic ║ election ║ 12 ║ ║ 23 ║ prez ║ 1833-03-04 ║ 1837-03-04 ║ Democratic ║ election ║ 12 ║ ║ 24 ║ viceprez ║ 1837-03-04 ║ 1841-03-04 ║ Democratic ║ election ║ 13 ║ ║ 25 ║ viceprez ║ 1833-03-04 ║ 1837-03-04 ║ Democratic ║ election ║ 14 ║ ║ 26 ║ prez ║ 1837-03-04 ║ 1841-03-04 ║ Democratic ║ election ║ 14 ║ ║ 27 ║ prez ║ 1841-03-04 ║ 1841-04-04 ║ Whig ║ election ║ 15 ║ ║ 28 ║ viceprez ║ 1841-03-04 ║ 1841-04-04 ║ Whig ║ election ║ 16 ║ ║ 29 ║ prez ║ 1841-04-04 ║ 1845-03-04 ║ Whig ║ succession ║ 16 ║ ║ 30 ║ viceprez ║ 1845-03-04 ║ 1849-03-04 ║ Democratic ║ election ║ 17 ║ ║ 31 ║ prez ║ 1845-03-04 ║ 1849-03-04 ║ Democratic ║ election ║ 18 ║ ║ 32 ║ prez ║ 1849-03-04 ║ 1850-07-09 ║ Whig ║ election ║ 19 ║ ║ 33 ║ viceprez ║ 1849-03-04 ║ 1850-07-09 ║ Whig ║ election ║ 20 ║ ║ 34 ║ prez ║ 1850-07-09 ║ 1853-03-04 ║ Whig ║ succession ║ 20 ║ ║ 35 ║ viceprez ║ 1853-03-04 ║ 1853-04-18 ║ Democratic ║ election ║ 21 ║ ║ 36 ║ prez ║ 1853-03-04 ║ 1857-03-04 ║ Democratic ║ election ║ 22 ║ ║ 37 ║ viceprez ║ 1857-03-04 ║ 1861-03-04 ║ Democratic ║ election ║ 23 ║ ║ 38 ║ prez ║ 1857-03-04 ║ 1861-03-04 ║ Democratic ║ election ║ 24 ║ ║ 39 ║ viceprez ║ 1861-03-04 ║ 1865-03-04 ║ Republican ║ election ║ 25 ║ ║ 40 ║ prez ║ 1861-03-04 ║ 1865-03-04 ║ Republican ║ election ║ 26 ║ ║ 41 ║ prez ║ 1865-03-04 ║ 1865-04-15 ║ Republican ║ election ║ 26 ║ ║ 42 ║ viceprez ║ 1865-03-04 ║ 1865-04-15 ║ Democratic ║ election ║ 27 ║ ║ 43 ║ prez ║ 1865-04-15 ║ 1869-03-04 ║ Democratic ║ succession ║ 27 ║ ║ 44 ║ viceprez ║ 1869-03-04 ║ 1873-03-04 ║ Republican ║ election ║ 28 ║ ║ 45 ║ viceprez ║ 1873-03-04 ║ 1875-11-22 ║ Republican ║ election ║ 29 ║ ║ 46 ║ prez ║ 1869-03-04 ║ 1873-03-04 ║ Republican ║ election ║ 30 ║ ║ 47 ║ prez ║ 1873-03-04 ║ 1877-03-04 ║ Republican ║ election ║ 30 ║ ║ 48 ║ viceprez ║ 1877-03-04 ║ 1881-03-04 ║ Republican ║ election ║ 31 ║ ║ 49 ║ prez ║ 1877-03-04 ║ 1881-03-04 ║ Republican ║ election ║ 32 ║ ║ 50 ║ prez ║ 1881-03-04 ║ 1881-09-19 ║ Republican ║ election ║ 33 ║ ║ 51 ║ viceprez ║ 1881-03-04 ║ 1881-09-19 ║ Republican ║ election ║ 34 ║ ║ 52 ║ prez ║ 1881-09-19 ║ 1885-03-04 ║ Republican ║ succession ║ 34 ║ ║ 53 ║ viceprez ║ 1885-03-04 ║ 1885-11-25 ║ Democratic ║ election ║ 35 ║ ║ 54 ║ viceprez ║ 1889-03-04 ║ 1893-03-04 ║ Republican ║ election ║ 36 ║ ║ 55 ║ prez ║ 1889-03-04 ║ 1893-03-04 ║ Republican ║ election ║ 37 ║ ║ 56 ║ viceprez ║ 1893-03-04 ║ 1897-03-04 ║ Democratic ║ election ║ 38 ║ ║ 57 ║ prez ║ 1885-03-04 ║ 1889-03-04 ║ Democratic ║ election ║ 39 ║ ║ 58 ║ prez ║ 1893-03-04 ║ 1897-03-04 ║ Democratic ║ election ║ 39 ║ ║ 59 ║ viceprez ║ 1897-03-04 ║ 1899-11-21 ║ Republican ║ election ║ 40 ║ ║ 60 ║ prez ║ 1897-03-04 ║ 1901-03-04 ║ Republican ║ election ║ 41 ║ ║ 61 ║ prez ║ 1901-03-04 ║ 1901-09-14 ║ Republican ║ election ║ 41 ║ ║ 62 ║ viceprez ║ 1905-03-04 ║ 1909-03-04 ║ Republican ║ election ║ 42 ║ ║ 63 ║ viceprez ║ 1901-03-04 ║ 1901-09-14 ║ Republican ║ election ║ 43 ║ ║ 64 ║ prez ║ 1901-09-14 ║ 1905-03-04 ║ Republican ║ succession ║ 43 ║ ║ 65 ║ prez ║ 1905-03-04 ║ 1909-03-04 ║ Republican ║ election ║ 43 ║ ║ 66 ║ viceprez ║ 1909-03-04 ║ 1912-10-30 ║ Republican ║ election ║ 44 ║ ║ 67 ║ prez ║ 1909-03-04 ║ 1913-03-04 ║ Republican ║ election ║ 45 ║ ║ 68 ║ viceprez ║ 1913-03-04 ║ 1917-03-04 ║ Democratic ║ election ║ 46 ║ ║ 69 ║ viceprez ║ 1917-03-04 ║ 1921-03-04 ║ Democratic ║ election ║ 46 ║ ║ 70 ║ prez ║ 1913-03-04 ║ 1917-03-04 ║ Democratic ║ election ║ 47 ║ ║ 71 ║ prez ║ 1917-03-04 ║ 1921-03-04 ║ Democratic ║ election ║ 47 ║ ║ 72 ║ prez ║ 1921-03-04 ║ 1923-08-02 ║ Republican ║ election ║ 48 ║ ║ 73 ║ viceprez ║ 1925-03-04 ║ 1929-03-04 ║ Republican ║ election ║ 49 ║ ║ 74 ║ viceprez ║ 1921-03-04 ║ 1923-08-02 ║ Republican ║ election ║ 50 ║ ║ 75 ║ prez ║ 1923-08-02 ║ 1925-03-04 ║ Republican ║ succession ║ 50 ║ ║ 76 ║ prez ║ 1925-03-04 ║ 1929-03-04 ║ Republican ║ election ║ 50 ║ ║ 77 ║ viceprez ║ 1929-03-04 ║ 1933-03-04 ║ Republican ║ election ║ 51 ║ ║ 78 ║ prez ║ 1929-03-04 ║ 1933-03-04 ║ Republican ║ election ║ 52 ║ ║ 79 ║ viceprez ║ 1933-03-04 ║ 1937-01-20 ║ Democratic ║ election ║ 53 ║ ║ 80 ║ viceprez ║ 1937-01-20 ║ 1941-01-20 ║ Democratic ║ election ║ 53 ║ ║ 81 ║ viceprez ║ 1941-01-20 ║ 1945-01-20 ║ Democratic ║ election ║ 54 ║ ║ 82 ║ prez ║ 1933-03-04 ║ 1937-01-20 ║ Democratic ║ election ║ 55 ║ ║ 83 ║ prez ║ 1937-01-20 ║ 1941-01-20 ║ Democratic ║ election ║ 55 ║ ║ 84 ║ prez ║ 1941-01-20 ║ 1945-01-20 ║ Democratic ║ election ║ 55 ║ ║ 85 ║ prez ║ 1945-01-20 ║ 1945-04-12 ║ Democratic ║ election ║ 55 ║ ║ 86 ║ viceprez ║ 1949-01-20 ║ 1953-01-20 ║ Democratic ║ election ║ 56 ║ ║ 87 ║ viceprez ║ 1945-01-20 ║ 1945-04-12 ║ Democratic ║ election ║ 57 ║ ║ 88 ║ prez ║ 1945-04-12 ║ 1949-01-20 ║ Democratic ║ succession ║ 57 ║ ║ 89 ║ prez ║ 1949-01-20 ║ 1953-01-20 ║ Democratic ║ election ║ 57 ║ ║ 90 ║ prez ║ 1953-01-20 ║ 1957-01-20 ║ Republican ║ election ║ 58 ║ ║ 91 ║ prez ║ 1957-01-20 ║ 1961-01-20 ║ Republican ║ election ║ 58 ║ ║ 92 ║ prez ║ 1961-01-20 ║ 1963-11-22 ║ Democratic ║ election ║ 59 ║ ║ 93 ║ viceprez ║ 1965-01-20 ║ 1969-01-20 ║ Democratic ║ election ║ 60 ║ ║ 94 ║ viceprez ║ 1961-01-20 ║ 1963-11-22 ║ Democratic ║ election ║ 61 ║ ║ 95 ║ prez ║ 1963-11-22 ║ 1965-01-20 ║ Democratic ║ succession ║ 61 ║ ║ 96 ║ prez ║ 1965-01-20 ║ 1969-01-20 ║ Democratic ║ election ║ 61 ║ ║ 97 ║ viceprez ║ 1969-01-20 ║ 1973-01-20 ║ Republican ║ election ║ 62 ║ ║ 98 ║ viceprez ║ 1973-01-20 ║ 1973-10-10 ║ Republican ║ election ║ 62 ║ ║ 99 ║ viceprez ║ 1953-01-20 ║ 1957-01-20 ║ Republican ║ election ║ 63 ║ ║ 100 ║ viceprez ║ 1957-01-20 ║ 1961-01-20 ║ Republican ║ election ║ 63 ║ ║ 101 ║ prez ║ 1969-01-20 ║ 1973-01-20 ║ Republican ║ election ║ 63 ║ ╚═════════╩══════════╩════════════╩════════════╩═══════════════════════╩════════════╩════════════════╝