executive_terms

Table actions

62 rows where type = "viceprez"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: party, how, start (date), end (date)

Link rowid ▼ type start end party how executive_id
3 3 viceprez 1789-04-21 1793-03-04 Federalist election John Adams 2
4 4 viceprez 1793-03-04 1797-03-04 Federalist election John Adams 2
6 6 viceprez 1797-03-04 1801-03-04 Democratic-Republican election Thomas Jefferson 3
9 9 viceprez 1801-03-04 1805-03-04 Democratic-Republican election Aaron Burr 4
10 10 viceprez 1805-03-04 1809-03-04 Democratic-Republican election George Clinton 5
11 11 viceprez 1809-03-04 1812-04-20 Democratic-Republican election George Clinton 5
12 12 viceprez 1813-03-04 1814-11-23 Democratic-Republican election Elbridge Gerry 6
15 15 viceprez 1817-03-04 1821-03-05 Democratic-Republican election Daniel Tompkins 8
16 16 viceprez 1821-03-05 1825-03-04 Democratic-Republican election Daniel Tompkins 8
20 20 viceprez 1825-03-04 1829-03-04 Democratic-Republican election John Calhoun 11
21 21 viceprez 1829-03-04 1832-12-28 Democrat election John Calhoun 11
24 24 viceprez 1837-03-04 1841-03-04 Democrat election Richard Johnson 13
25 25 viceprez 1833-03-04 1837-03-04 Democrat election Martin Van Buren 14
28 28 viceprez 1841-03-04 1841-04-04 Whig election John Tyler 16
30 30 viceprez 1845-03-04 1849-03-04 Democrat election George Dallas 17
33 33 viceprez 1849-03-04 1850-07-09 Whig election Millard Fillmore 20
35 35 viceprez 1853-03-04 1853-04-18 Democrat election William King 21
37 37 viceprez 1857-03-04 1861-03-04 Democrat election John Breckinridge 23
39 39 viceprez 1861-03-04 1865-03-04 Republican election Hannibal Hamlin 25
42 42 viceprez 1865-03-04 1865-04-15 Democrat election Andrew Johnson 27
44 44 viceprez 1869-03-04 1873-03-04 Republican election Schuyler Colfax 28
45 45 viceprez 1873-03-04 1875-11-22 Republican election Henry Wilson 29
48 48 viceprez 1877-03-04 1881-03-04 Republican election William Wheeler 31
51 51 viceprez 1881-03-04 1881-09-19 Republican election Chester Arthur 34
53 53 viceprez 1885-03-04 1885-11-25 Democrat election Thomas Hendricks 35
54 54 viceprez 1889-03-04 1893-03-04 Republican election Levi Morton 36
56 56 viceprez 1893-03-04 1897-03-04 Democrat election Adlai Stevenson 38
59 59 viceprez 1897-03-04 1899-11-21 Republican election Garret Hobart 40
62 62 viceprez 1905-03-04 1909-03-04 Republican election Charles Fairbanks 42
63 63 viceprez 1901-03-04 1901-09-14 Republican election Theodore Roosevelt 43
66 66 viceprez 1909-03-04 1912-10-30 Republican election James Sherman 44
68 68 viceprez 1913-03-04 1917-03-04 Democrat election Thomas Marshall 46
69 69 viceprez 1917-03-04 1921-03-04 Democrat election Thomas Marshall 46
73 73 viceprez 1925-03-04 1929-03-04 Republican election Charles Dawes 49
74 74 viceprez 1921-03-04 1923-08-02 Republican election Calvin Coolidge 50
77 77 viceprez 1929-03-04 1933-03-04 Republican election Charles Curtis 51
79 79 viceprez 1933-03-04 1937-01-20 Democrat election John Garner 53
80 80 viceprez 1937-01-20 1941-01-20 Democrat election John Garner 53
81 81 viceprez 1941-01-20 1945-01-20 Democrat election Henry Wallace 54
86 86 viceprez 1949-01-20 1953-01-20 Democrat election Alben Barkley 56
87 87 viceprez 1945-01-20 1945-04-12 Democrat election Harry Truman 57
93 93 viceprez 1965-01-20 1969-01-20 Democrat election Hubert Humphrey 60
94 94 viceprez 1961-01-20 1963-11-22 Democrat election Lyndon Johnson 61
97 97 viceprez 1969-01-20 1973-01-20 Republican election Spiro Agnew 62
98 98 viceprez 1973-01-20 1973-10-10 Republican election Spiro Agnew 62
99 99 viceprez 1953-01-20 1957-01-20 Republican election Richard Nixon 63
100 100 viceprez 1957-01-20 1961-01-20 Republican election Richard Nixon 63
103 103 viceprez 1973-12-06 1974-08-09 Republican appointment Gerald Ford 64
105 105 viceprez 1974-12-19 1977-01-20 Republican appointment Nelson Rockefeller 65
106 106 viceprez 1977-01-20 1981-01-20 Democrat election Walter Mondale 66
110 110 viceprez 1989-01-20 1993-01-20 Republican election James Quayle 69
111 111 viceprez 1981-01-20 1985-01-20 Republican election George Bush 70
112 112 viceprez 1985-01-20 1989-01-20 Republican election George Bush 70
114 114 viceprez 1993-01-20 1997-01-20 Democrat election Albert Gore 71
115 115 viceprez 1997-01-20 2001-01-20 Democrat election Albert Gore 71
118 118 viceprez 2001-01-20 2005-01-20 Republican election Richard Cheney 73
119 119 viceprez 2005-01-20 2009-01-20 Republican election Richard Cheney 73
122 122 viceprez 2009-01-20 2013-01-20 Democrat election Joseph Biden 75
123 123 viceprez 2013-01-20 2017-01-20 Democrat election Joseph Biden 75
127 127 viceprez 2017-01-20 2021-01-20 Republican election Mike Pence 77
130 130 viceprez 2021-01-20 2025-01-20 Democrat election Kamala Harris 79
131 131 viceprez 2025-01-20 2029-01-20 Republican election James David Vance 80

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [executive_terms] (
   [type] TEXT,
   [start] TEXT,
   [end] TEXT,
   [party] TEXT,
   [how] TEXT,
   [executive_id] INTEGER REFERENCES [executives]([id])
);