executive_terms

Table actions Table actions

50 rows where party = "Democrat"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid ▼ type start end party how executive_id
21 21 viceprez 1829-03-04 1832-12-28 Democrat election John Calhoun 11
22 22 prez 1829-03-04 1833-03-04 Democrat election Andrew Jackson 12
23 23 prez 1833-03-04 1837-03-04 Democrat election Andrew Jackson 12
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
26 26 prez 1837-03-04 1841-03-04 Democrat election Martin Van Buren 14
30 30 viceprez 1845-03-04 1849-03-04 Democrat election George Dallas 17
31 31 prez 1845-03-04 1849-03-04 Democrat election James Polk 18
35 35 viceprez 1853-03-04 1853-04-18 Democrat election William King 21
36 36 prez 1853-03-04 1857-03-04 Democrat election Franklin Pierce 22
37 37 viceprez 1857-03-04 1861-03-04 Democrat election John Breckinridge 23
38 38 prez 1857-03-04 1861-03-04 Democrat election James Buchanan 24
42 42 viceprez 1865-03-04 1865-04-15 Democrat election Andrew Johnson 27
43 43 prez 1865-04-15 1869-03-04 Democrat succession Andrew Johnson 27
53 53 viceprez 1885-03-04 1885-11-25 Democrat election Thomas Hendricks 35
56 56 viceprez 1893-03-04 1897-03-04 Democrat election Adlai Stevenson 38
57 57 prez 1885-03-04 1889-03-04 Democrat election Grover Cleveland 39
58 58 prez 1893-03-04 1897-03-04 Democrat election Grover Cleveland 39
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
70 70 prez 1913-03-04 1917-03-04 Democrat election Woodrow Wilson 47
71 71 prez 1917-03-04 1921-03-04 Democrat election Woodrow Wilson 47
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
82 82 prez 1933-03-04 1937-01-20 Democrat election Franklin Roosevelt 55
83 83 prez 1937-01-20 1941-01-20 Democrat election Franklin Roosevelt 55
84 84 prez 1941-01-20 1945-01-20 Democrat election Franklin Roosevelt 55
85 85 prez 1945-01-20 1945-04-12 Democrat election Franklin Roosevelt 55
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
88 88 prez 1945-04-12 1949-01-20 Democrat succession Harry Truman 57
89 89 prez 1949-01-20 1953-01-20 Democrat election Harry Truman 57
92 92 prez 1961-01-20 1963-11-22 Democrat election John Kennedy 59
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
95 95 prez 1963-11-22 1965-01-20 Democrat succession Lyndon Johnson 61
96 96 prez 1965-01-20 1969-01-20 Democrat election Lyndon Johnson 61
106 106 viceprez 1977-01-20 1981-01-20 Democrat election Walter Mondale 66
107 107 prez 1977-01-20 1981-01-20 Democrat election James Carter 67
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
116 116 prez 1993-01-20 1997-01-20 Democrat election William Clinton 72
117 117 prez 1997-01-20 2001-01-20 Democrat election William Clinton 72
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
124 124 prez 2021-01-20 2025-01-20 Democrat election Joseph Biden 75
125 125 prez 2009-01-20 2013-01-20 Democrat election Barack Obama 76
126 126 prez 2013-01-20 2017-01-20 Democrat election Barack Obama 76
130 130 viceprez 2021-01-20 2025-01-20 Democrat election Kamala Harris 79

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])
);