+---------+----------+------------+------------+-----------------------+----------+----------------+
|   rowid | type     | start      | end        | party                 | how      |   executive_id |
+=========+==========+============+============+=======================+==========+================+
|       9 | viceprez | 1801-03-04 | 1805-03-04 | Democratic-Republican | election |              4 |
+---------+----------+------------+------------+-----------------------+----------+----------------+