┏━━━━━━━━━┳━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━┳━━━━━━━━━━━━━━━━┓
┃   rowid ┃ type     ┃ start      ┃ end        ┃ party      ┃ how      ┃ executive_id   ┃
┣━━━━━━━━━╋━━━━━━━━━━╋━━━━━━━━━━━━╋━━━━━━━━━━━━╋━━━━━━━━━━━━╋━━━━━━━━━━╋━━━━━━━━━━━━━━━━┫
┃       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     ┃
┗━━━━━━━━━┻━━━━━━━━━━┻━━━━━━━━━━━━┻━━━━━━━━━━━━┻━━━━━━━━━━━━┻━━━━━━━━━━┻━━━━━━━━━━━━━━━━┛