+-------+------+------------+------------+----------+----------+--------------+ | rowid | type | start | end | party | how | executive_id | +-------+------+------------+------------+----------+----------+--------------+ | 2 | prez | 1793-03-04 | 1797-03-04 | no party | election | 1 | +-------+------+------------+------------+----------+----------+--------------+