executive_terms

Table actions

69 rows where type = "prez"

✎ 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
1 1 prez 1789-04-30 1793-03-04 no party election George Washington 1
2 2 prez 1793-03-04 1797-03-04 no party election George Washington 1
5 5 prez 1797-03-04 1801-03-04 Federalist election John Adams 2
7 7 prez 1801-03-04 1805-03-04 Democratic-Republican election Thomas Jefferson 3
8 8 prez 1805-03-04 1809-03-04 Democratic-Republican election Thomas Jefferson 3
13 13 prez 1809-03-04 1813-03-04 Democratic-Republican election James Madison 7
14 14 prez 1813-03-04 1817-03-04 Democratic-Republican election James Madison 7
17 17 prez 1817-03-04 1821-03-05 Democratic-Republican election James Monroe 9
18 18 prez 1821-03-05 1825-03-04 Democratic-Republican election James Monroe 9
19 19 prez 1825-03-04 1829-03-04 Democratic-Republican election John Adams 10
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
26 26 prez 1837-03-04 1841-03-04 Democrat election Martin Van Buren 14
27 27 prez 1841-03-04 1841-04-04 Whig election William Harrison 15
29 29 prez 1841-04-04 1845-03-04 Whig succession John Tyler 16
31 31 prez 1845-03-04 1849-03-04 Democrat election James Polk 18
32 32 prez 1849-03-04 1850-07-09 Whig election Zachary Taylor 19
34 34 prez 1850-07-09 1853-03-04 Whig succession Millard Fillmore 20
36 36 prez 1853-03-04 1857-03-04 Democrat election Franklin Pierce 22
38 38 prez 1857-03-04 1861-03-04 Democrat election James Buchanan 24
40 40 prez 1861-03-04 1865-03-04 Republican election Abraham Lincoln 26
41 41 prez 1865-03-04 1865-04-15 Republican election Abraham Lincoln 26
43 43 prez 1865-04-15 1869-03-04 Democrat succession Andrew Johnson 27
46 46 prez 1869-03-04 1873-03-04 Republican election Ulysses Grant 30
47 47 prez 1873-03-04 1877-03-04 Republican election Ulysses Grant 30
49 49 prez 1877-03-04 1881-03-04 Republican election Rutherford Hayes 32
50 50 prez 1881-03-04 1881-09-19 Republican election James Garfield 33
52 52 prez 1881-09-19 1885-03-04 Republican succession Chester Arthur 34
55 55 prez 1889-03-04 1893-03-04 Republican election Benjamin Harrison 37
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
60 60 prez 1897-03-04 1901-03-04 Republican election William McKinley 41
61 61 prez 1901-03-04 1901-09-14 Republican election William McKinley 41
64 64 prez 1901-09-14 1905-03-04 Republican succession Theodore Roosevelt 43
65 65 prez 1905-03-04 1909-03-04 Republican election Theodore Roosevelt 43
67 67 prez 1909-03-04 1913-03-04 Republican election William Taft 45
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
72 72 prez 1921-03-04 1923-08-02 Republican election Warren Harding 48
75 75 prez 1923-08-02 1925-03-04 Republican succession Calvin Coolidge 50
76 76 prez 1925-03-04 1929-03-04 Republican election Calvin Coolidge 50
78 78 prez 1929-03-04 1933-03-04 Republican election Herbert Hoover 52
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
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
90 90 prez 1953-01-20 1957-01-20 Republican election Dwight Eisenhower 58
91 91 prez 1957-01-20 1961-01-20 Republican election Dwight Eisenhower 58
92 92 prez 1961-01-20 1963-11-22 Democrat election John Kennedy 59
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
101 101 prez 1969-01-20 1973-01-20 Republican election Richard Nixon 63
102 102 prez 1973-01-20 1974-08-09 Republican election Richard Nixon 63
104 104 prez 1974-08-09 1977-01-20 Republican succession Gerald Ford 64
107 107 prez 1977-01-20 1981-01-20 Democrat election James Carter 67
108 108 prez 1981-01-20 1985-01-20 Republican election Ronald Reagan 68
109 109 prez 1985-01-20 1989-01-20 Republican election Ronald Reagan 68
113 113 prez 1989-01-20 1993-01-20 Republican election George Bush 70
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
120 120 prez 2001-01-20 2005-01-20 Republican election George Bush 74
121 121 prez 2005-01-20 2009-01-20 Republican election George Bush 74
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
128 128 prez 2017-01-20 2021-01-20 Republican election Donald Trump 78
129 129 prez 2025-01-20 2029-01-20 Republican election Donald Trump 78

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