+---------+----------+------------+------------+------------+------------+--------------------+
|   rowid | type     | start      | end        | party      | how        | executive_id       |
|---------+----------+------------+------------+------------+------------+--------------------|
|      63 | viceprez | 1901-03-04 | 1901-09-14 | Republican | election   | Theodore Roosevelt |
|      64 | prez     | 1901-09-14 | 1905-03-04 | Republican | succession | Theodore Roosevelt |
|      65 | prez     | 1905-03-04 | 1909-03-04 | Republican | election   | Theodore Roosevelt |
+---------+----------+------------+------------+------------+------------+--------------------+