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