||    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      |