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