rowid	type	start	end	party	how	executive_id
1	prez	1789-04-30	1793-03-04	no party	election	George Washington
2	prez	1793-03-04	1797-03-04	no party	election	George Washington
5	prez	1797-03-04	1801-03-04	Federalist	election	John Adams
7	prez	1801-03-04	1805-03-04	Democratic-Republican	election	Thomas Jefferson
8	prez	1805-03-04	1809-03-04	Democratic-Republican	election	Thomas Jefferson
13	prez	1809-03-04	1813-03-04	Democratic-Republican	election	James Madison
14	prez	1813-03-04	1817-03-04	Democratic-Republican	election	James Madison
17	prez	1817-03-04	1821-03-05	Democratic-Republican	election	James Monroe
18	prez	1821-03-05	1825-03-04	Democratic-Republican	election	James Monroe
19	prez	1825-03-04	1829-03-04	Democratic-Republican	election	John Adams
22	prez	1829-03-04	1833-03-04	Democratic	election	Andrew Jackson
23	prez	1833-03-04	1837-03-04	Democratic	election	Andrew Jackson
26	prez	1837-03-04	1841-03-04	Democratic	election	Martin Van Buren
27	prez	1841-03-04	1841-04-04	Whig	election	William Harrison
29	prez	1841-04-04	1845-03-04	Whig	succession	John Tyler
31	prez	1845-03-04	1849-03-04	Democratic	election	James Polk
32	prez	1849-03-04	1850-07-09	Whig	election	Zachary Taylor
34	prez	1850-07-09	1853-03-04	Whig	succession	Millard Fillmore
36	prez	1853-03-04	1857-03-04	Democratic	election	Franklin Pierce
38	prez	1857-03-04	1861-03-04	Democratic	election	James Buchanan
40	prez	1861-03-04	1865-03-04	Republican	election	Abraham Lincoln
41	prez	1865-03-04	1865-04-15	Republican	election	Abraham Lincoln
43	prez	1865-04-15	1869-03-04	Democratic	succession	Andrew Johnson
46	prez	1869-03-04	1873-03-04	Republican	election	Ulysses Grant
47	prez	1873-03-04	1877-03-04	Republican	election	Ulysses Grant
49	prez	1877-03-04	1881-03-04	Republican	election	Rutherford Hayes
50	prez	1881-03-04	1881-09-19	Republican	election	James Garfield
52	prez	1881-09-19	1885-03-04	Republican	succession	Chester Arthur
55	prez	1889-03-04	1893-03-04	Republican	election	Benjamin Harrison
57	prez	1885-03-04	1889-03-04	Democratic	election	Grover Cleveland
58	prez	1893-03-04	1897-03-04	Democratic	election	Grover Cleveland
60	prez	1897-03-04	1901-03-04	Republican	election	William McKinley
61	prez	1901-03-04	1901-09-14	Republican	election	William McKinley
64	prez	1901-09-14	1905-03-04	Republican	succession	Theodore Roosevelt
65	prez	1905-03-04	1909-03-04	Republican	election	Theodore Roosevelt
67	prez	1909-03-04	1913-03-04	Republican	election	William Taft
70	prez	1913-03-04	1917-03-04	Democratic	election	Woodrow Wilson
71	prez	1917-03-04	1921-03-04	Democratic	election	Woodrow Wilson
72	prez	1921-03-04	1923-08-02	Republican	election	Warren Harding
75	prez	1923-08-02	1925-03-04	Republican	succession	Calvin Coolidge
76	prez	1925-03-04	1929-03-04	Republican	election	Calvin Coolidge
78	prez	1929-03-04	1933-03-04	Republican	election	Herbert Hoover
82	prez	1933-03-04	1937-01-20	Democratic	election	Franklin Roosevelt
83	prez	1937-01-20	1941-01-20	Democratic	election	Franklin Roosevelt
84	prez	1941-01-20	1945-01-20	Democratic	election	Franklin Roosevelt
85	prez	1945-01-20	1945-04-12	Democratic	election	Franklin Roosevelt
88	prez	1945-04-12	1949-01-20	Democratic	succession	Harry Truman
89	prez	1949-01-20	1953-01-20	Democratic	election	Harry Truman
90	prez	1953-01-20	1957-01-20	Republican	election	Dwight Eisenhower
91	prez	1957-01-20	1961-01-20	Republican	election	Dwight Eisenhower
92	prez	1961-01-20	1963-11-22	Democratic	election	John Kennedy
95	prez	1963-11-22	1965-01-20	Democratic	succession	Lyndon Johnson
96	prez	1965-01-20	1969-01-20	Democratic	election	Lyndon Johnson
101	prez	1969-01-20	1973-01-20	Republican	election	Richard Nixon
102	prez	1973-01-20	1974-08-09	Republican	election	Richard Nixon
104	prez	1974-08-09	1977-01-20	Republican	succession	Gerald Ford
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
113	prez	1989-01-20	1993-01-20	Republican	election	George Bush
116	prez	1993-01-20	1997-01-20	Democrat	election	William Clinton
117	prez	1997-01-20	2001-01-20	Democrat	election	William Clinton
120	prez	2001-01-20	2005-01-20	Republican	election	George Bush
121	prez	2005-01-20	2009-01-20	Republican	election	George Bush
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
128	prez	2017-01-20	2021-01-20	Republican	election	Donald Trump
3	viceprez	1789-04-21	1793-03-04	Federalist	election	John Adams
4	viceprez	1793-03-04	1797-03-04	Federalist	election	John Adams
6	viceprez	1797-03-04	1801-03-04	Democratic-Republican	election	Thomas Jefferson
9	viceprez	1801-03-04	1805-03-04	Democratic-Republican	election	Aaron Burr
10	viceprez	1805-03-04	1809-03-04	Democratic-Republican	election	George Clinton
11	viceprez	1809-03-04	1812-04-20	Democratic-Republican	election	George Clinton
12	viceprez	1813-03-04	1814-11-23	Democratic-Republican	election	Elbridge Gerry
15	viceprez	1817-03-04	1821-03-05	Democratic-Republican	election	Daniel Tompkins
16	viceprez	1821-03-05	1825-03-04	Democratic-Republican	election	Daniel Tompkins
20	viceprez	1825-03-04	1829-03-04	Democratic-Republican	election	John Calhoun
21	viceprez	1829-03-04	1832-12-28	Democratic	election	John Calhoun
24	viceprez	1837-03-04	1841-03-04	Democratic	election	Richard Johnson
25	viceprez	1833-03-04	1837-03-04	Democratic	election	Martin Van Buren
28	viceprez	1841-03-04	1841-04-04	Whig	election	John Tyler
30	viceprez	1845-03-04	1849-03-04	Democratic	election	George Dallas
33	viceprez	1849-03-04	1850-07-09	Whig	election	Millard Fillmore
35	viceprez	1853-03-04	1853-04-18	Democratic	election	William King
37	viceprez	1857-03-04	1861-03-04	Democratic	election	John Breckinridge
39	viceprez	1861-03-04	1865-03-04	Republican	election	Hannibal Hamlin
42	viceprez	1865-03-04	1865-04-15	Democratic	election	Andrew Johnson
44	viceprez	1869-03-04	1873-03-04	Republican	election	Schuyler Colfax
45	viceprez	1873-03-04	1875-11-22	Republican	election	Henry Wilson
48	viceprez	1877-03-04	1881-03-04	Republican	election	William Wheeler
51	viceprez	1881-03-04	1881-09-19	Republican	election	Chester Arthur
53	viceprez	1885-03-04	1885-11-25	Democratic	election	Thomas Hendricks
54	viceprez	1889-03-04	1893-03-04	Republican	election	Levi Morton
56	viceprez	1893-03-04	1897-03-04	Democratic	election	Adlai Stevenson
59	viceprez	1897-03-04	1899-11-21	Republican	election	Garret Hobart
62	viceprez	1905-03-04	1909-03-04	Republican	election	Charles Fairbanks
63	viceprez	1901-03-04	1901-09-14	Republican	election	Theodore Roosevelt
66	viceprez	1909-03-04	1912-10-30	Republican	election	James Sherman
68	viceprez	1913-03-04	1917-03-04	Democratic	election	Thomas Marshall