executive_terms

Table actions

131 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ type start end party how executive_id
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
103 103 viceprez 1973-12-06 1974-08-09 Republican appointment Gerald Ford 64
104 104 prez 1974-08-09 1977-01-20 Republican succession 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
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
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
113 113 prez 1989-01-20 1993-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
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
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
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
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
127 127 viceprez 2017-01-20 2021-01-20 Republican election Mike Pence 77
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
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])
);