+---------+----------+------------+------------+------------+----------+----------------+
|   rowid | type     | start      | end        | party      | how      |   executive_id |
+=========+==========+============+============+============+==========+================+
|       4 | viceprez | 1793-03-04 | 1797-03-04 | Federalist | election |              2 |
+---------+----------+------------+------------+------------+----------+----------------+