\begin{tabular}{rlllllr} \hline rowid & type & start & end & party & how & executive\_id \\ \hline 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 \\ \hline \end{tabular}