+---------+--------+------------+------------+-----------------------+----------+----------------+
|   rowid | type   | start      | end        | party                 | how      |   executive_id |
+=========+========+============+============+=======================+==========+================+
|       8 | prez   | 1805-03-04 | 1809-03-04 | Democratic-Republican | election |              3 |
+---------+--------+------------+------------+-----------------------+----------+----------------+