rowid	type	start	end	party	how	executive_id
1	prez	1789-04-30	1793-03-04	no party	election	1
2	prez	1793-03-04	1797-03-04	no party	election	1
3	viceprez	1789-04-21	1793-03-04	Federalist	election	2
4	viceprez	1793-03-04	1797-03-04	Federalist	election	2
5	prez	1797-03-04	1801-03-04	Federalist	election	2
6	viceprez	1797-03-04	1801-03-04	Democratic-Republican	election	3
7	prez	1801-03-04	1805-03-04	Democratic-Republican	election	3
8	prez	1805-03-04	1809-03-04	Democratic-Republican	election	3
9	viceprez	1801-03-04	1805-03-04	Democratic-Republican	election	4
10	viceprez	1805-03-04	1809-03-04	Democratic-Republican	election	5
11	viceprez	1809-03-04	1812-04-20	Democratic-Republican	election	5
12	viceprez	1813-03-04	1814-11-23	Democratic-Republican	election	6
13	prez	1809-03-04	1813-03-04	Democratic-Republican	election	7
14	prez	1813-03-04	1817-03-04	Democratic-Republican	election	7
15	viceprez	1817-03-04	1821-03-05	Democratic-Republican	election	8
16	viceprez	1821-03-05	1825-03-04	Democratic-Republican	election	8
17	prez	1817-03-04	1821-03-05	Democratic-Republican	election	9
18	prez	1821-03-05	1825-03-04	Democratic-Republican	election	9
19	prez	1825-03-04	1829-03-04	Democratic-Republican	election	10
20	viceprez	1825-03-04	1829-03-04	Democratic-Republican	election	11
21	viceprez	1829-03-04	1832-12-28	Democratic	election	11
22	prez	1829-03-04	1833-03-04	Democratic	election	12
23	prez	1833-03-04	1837-03-04	Democratic	election	12
24	viceprez	1837-03-04	1841-03-04	Democratic	election	13
25	viceprez	1833-03-04	1837-03-04	Democratic	election	14
26	prez	1837-03-04	1841-03-04	Democratic	election	14
27	prez	1841-03-04	1841-04-04	Whig	election	15
28	viceprez	1841-03-04	1841-04-04	Whig	election	16
29	prez	1841-04-04	1845-03-04	Whig	succession	16
30	viceprez	1845-03-04	1849-03-04	Democratic	election	17
31	prez	1845-03-04	1849-03-04	Democratic	election	18
32	prez	1849-03-04	1850-07-09	Whig	election	19
33	viceprez	1849-03-04	1850-07-09	Whig	election	20
34	prez	1850-07-09	1853-03-04	Whig	succession	20
35	viceprez	1853-03-04	1853-04-18	Democratic	election	21
36	prez	1853-03-04	1857-03-04	Democratic	election	22
37	viceprez	1857-03-04	1861-03-04	Democratic	election	23
38	prez	1857-03-04	1861-03-04	Democratic	election	24
39	viceprez	1861-03-04	1865-03-04	Republican	election	25
40	prez	1861-03-04	1865-03-04	Republican	election	26
41	prez	1865-03-04	1865-04-15	Republican	election	26
42	viceprez	1865-03-04	1865-04-15	Democratic	election	27
43	prez	1865-04-15	1869-03-04	Democratic	succession	27
44	viceprez	1869-03-04	1873-03-04	Republican	election	28
45	viceprez	1873-03-04	1875-11-22	Republican	election	29
46	prez	1869-03-04	1873-03-04	Republican	election	30
47	prez	1873-03-04	1877-03-04	Republican	election	30
48	viceprez	1877-03-04	1881-03-04	Republican	election	31
49	prez	1877-03-04	1881-03-04	Republican	election	32
50	prez	1881-03-04	1881-09-19	Republican	election	33
51	viceprez	1881-03-04	1881-09-19	Republican	election	34
52	prez	1881-09-19	1885-03-04	Republican	succession	34
53	viceprez	1885-03-04	1885-11-25	Democratic	election	35
54	viceprez	1889-03-04	1893-03-04	Republican	election	36
55	prez	1889-03-04	1893-03-04	Republican	election	37
56	viceprez	1893-03-04	1897-03-04	Democratic	election	38
57	prez	1885-03-04	1889-03-04	Democratic	election	39
58	prez	1893-03-04	1897-03-04	Democratic	election	39
59	viceprez	1897-03-04	1899-11-21	Republican	election	40
60	prez	1897-03-04	1901-03-04	Republican	election	41
61	prez	1901-03-04	1901-09-14	Republican	election	41
62	viceprez	1905-03-04	1909-03-04	Republican	election	42
63	viceprez	1901-03-04	1901-09-14	Republican	election	43
64	prez	1901-09-14	1905-03-04	Republican	succession	43
65	prez	1905-03-04	1909-03-04	Republican	election	43
66	viceprez	1909-03-04	1912-10-30	Republican	election	44
67	prez	1909-03-04	1913-03-04	Republican	election	45
68	viceprez	1913-03-04	1917-03-04	Democratic	election	46
69	viceprez	1917-03-04	1921-03-04	Democratic	election	46
70	prez	1913-03-04	1917-03-04	Democratic	election	47
71	prez	1917-03-04	1921-03-04	Democratic	election	47
72	prez	1921-03-04	1923-08-02	Republican	election	48
73	viceprez	1925-03-04	1929-03-04	Republican	election	49
74	viceprez	1921-03-04	1923-08-02	Republican	election	50
75	prez	1923-08-02	1925-03-04	Republican	succession	50
76	prez	1925-03-04	1929-03-04	Republican	election	50
77	viceprez	1929-03-04	1933-03-04	Republican	election	51
78	prez	1929-03-04	1933-03-04	Republican	election	52
79	viceprez	1933-03-04	1937-01-20	Democratic	election	53
80	viceprez	1937-01-20	1941-01-20	Democratic	election	53
81	viceprez	1941-01-20	1945-01-20	Democratic	election	54
82	prez	1933-03-04	1937-01-20	Democratic	election	55
83	prez	1937-01-20	1941-01-20	Democratic	election	55
84	prez	1941-01-20	1945-01-20	Democratic	election	55
85	prez	1945-01-20	1945-04-12	Democratic	election	55
86	viceprez	1949-01-20	1953-01-20	Democratic	election	56
87	viceprez	1945-01-20	1945-04-12	Democratic	election	57
88	prez	1945-04-12	1949-01-20	Democratic	succession	57
89	prez	1949-01-20	1953-01-20	Democratic	election	57
90	prez	1953-01-20	1957-01-20	Republican	election	58
91	prez	1957-01-20	1961-01-20	Republican	election	58
92	prez	1961-01-20	1963-11-22	Democratic	election	59
93	viceprez	1965-01-20	1969-01-20	Democratic	election	60
94	viceprez	1961-01-20	1963-11-22	Democratic	election	61
95	prez	1963-11-22	1965-01-20	Democratic	succession	61
96	prez	1965-01-20	1969-01-20	Democratic	election	61
97	viceprez	1969-01-20	1973-01-20	Republican	election	62
98	viceprez	1973-01-20	1973-10-10	Republican	election	62
99	viceprez	1953-01-20	1957-01-20	Republican	election	63
100	viceprez	1957-01-20	1961-01-20	Republican	election	63
101	prez	1969-01-20	1973-01-20	Republican	election	63