┍━━━━━━━━━┯━━━━━━━━━━┯━━━━━━━━━━━━┯━━━━━━━━━━━━┯━━━━━━━━━━━━┯━━━━━━━━━━━━━┯━━━━━━━━━━━━━━━━━━━━┑
│   rowid │ type     │ start      │ end        │ party      │ how         │ executive_id       │
┝━━━━━━━━━┿━━━━━━━━━━┿━━━━━━━━━━━━┿━━━━━━━━━━━━┿━━━━━━━━━━━━┿━━━━━━━━━━━━━┿━━━━━━━━━━━━━━━━━━━━┥
│     101 │ prez     │ 1969-01-20 │ 1973-01-20 │ Republican │ election    │ Richard Nixon      │
│     102 │ prez     │ 1973-01-20 │ 1974-08-09 │ Republican │ election    │ Richard Nixon      │
│     103 │ viceprez │ 1973-12-06 │ 1974-08-09 │ Republican │ appointment │ Gerald Ford        │
│     104 │ prez     │ 1974-08-09 │ 1977-01-20 │ Republican │ succession  │ Gerald Ford        │
│     105 │ viceprez │ 1974-12-19 │ 1977-01-20 │ Republican │ appointment │ Nelson Rockefeller │
│     106 │ viceprez │ 1977-01-20 │ 1981-01-20 │ Democratic │ election    │ Walter Mondale     │
│     107 │ prez     │ 1977-01-20 │ 1981-01-20 │ Democratic │ election    │ James Carter       │
│     108 │ prez     │ 1981-01-20 │ 1985-01-20 │ Republican │ election    │ Ronald Reagan      │
│     109 │ prez     │ 1985-01-20 │ 1989-01-20 │ Republican │ election    │ Ronald Reagan      │
│     110 │ viceprez │ 1989-01-20 │ 1993-01-20 │ Republican │ election    │ James Quayle       │
│     111 │ viceprez │ 1981-01-20 │ 1985-01-20 │ Republican │ election    │ George Bush        │
│     112 │ viceprez │ 1985-01-20 │ 1989-01-20 │ Republican │ election    │ George Bush        │
│     113 │ prez     │ 1989-01-20 │ 1993-01-20 │ Republican │ election    │ George Bush        │
│     114 │ viceprez │ 1993-01-20 │ 1997-01-20 │ Democrat   │ election    │ Albert Gore        │
│     115 │ viceprez │ 1997-01-20 │ 2001-01-20 │ Democrat   │ election    │ Albert Gore        │
│     116 │ prez     │ 1993-01-20 │ 1997-01-20 │ Democrat   │ election    │ William Clinton    │
│     117 │ prez     │ 1997-01-20 │ 2001-01-20 │ Democrat   │ election    │ William Clinton    │
│     118 │ viceprez │ 2001-01-20 │ 2005-01-20 │ Republican │ election    │ Richard Cheney     │
│     119 │ viceprez │ 2005-01-20 │ 2009-01-20 │ Republican │ election    │ Richard Cheney     │
│     120 │ prez     │ 2001-01-20 │ 2005-01-20 │ Republican │ election    │ George Bush        │
│     121 │ prez     │ 2005-01-20 │ 2009-01-20 │ Republican │ election    │ George Bush        │
│     122 │ viceprez │ 2009-01-20 │ 2013-01-20 │ Democrat   │ election    │ Joseph Biden       │
│     123 │ viceprez │ 2013-01-20 │ 2017-01-20 │ Democrat   │ election    │ Joseph Biden       │
│     124 │ prez     │ 2021-01-20 │ 2025-01-20 │ Democrat   │ election    │ Joseph Biden       │
│     125 │ prez     │ 2009-01-20 │ 2013-01-20 │ Democrat   │ election    │ Barack Obama       │
│     126 │ prez     │ 2013-01-20 │ 2017-01-20 │ Democrat   │ election    │ Barack Obama       │
│     127 │ viceprez │ 2017-01-20 │ 2021-01-20 │ Republican │ election    │ Mike Pence         │
│     128 │ prez     │ 2017-01-20 │ 2021-01-20 │ Republican │ election    │ Donald Trump       │
│     129 │ viceprez │ 2021-01-20 │ 2025-01-20 │ Democrat   │ election    │ Kamala Harris      │
┕━━━━━━━━━┷━━━━━━━━━━┷━━━━━━━━━━━━┷━━━━━━━━━━━━┷━━━━━━━━━━━━┷━━━━━━━━━━━━━┷━━━━━━━━━━━━━━━━━━━━┙