┏━━━━━━━━━┳━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┓
┃   rowid ┃ type   ┃ start      ┃ end        ┃ party      ┃ how      ┃ executive_id    ┃
┣━━━━━━━━━╋━━━━━━━━╋━━━━━━━━━━━━╋━━━━━━━━━━━━╋━━━━━━━━━━━━╋━━━━━━━━━━╋━━━━━━━━━━━━━━━━━┫
┃      40 ┃ prez   ┃ 1861-03-04 ┃ 1865-03-04 ┃ Republican ┃ election ┃ Abraham Lincoln ┃
┃      41 ┃ prez   ┃ 1865-03-04 ┃ 1865-04-15 ┃ Republican ┃ election ┃ Abraham Lincoln ┃
┗━━━━━━━━━┻━━━━━━━━┻━━━━━━━━━━━━┻━━━━━━━━━━━━┻━━━━━━━━━━━━┻━━━━━━━━━━┻━━━━━━━━━━━━━━━━━┛