cabinet-turnover/cabinet-turnover

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

312 rows sorted by end

View and edit SQL

Suggested facets: president, position

Link rowid president position appointee start end ▼ length days
127 Clinton Director of Central Intelligence Jim Woolsey 2/5/93 1/10/95 704 721
132 Clinton Secretary of Labor Robert Reich 1/22/93 1/10/97 1449 1452
259 Obama Secretary of Agriculture Tom Vilsack 1/20/09 1/13/17 2915 2916
95 Bush 41 Secretary of Commerce Robert Mosbacher 1/31/89 1/15/92 1079 1091
100 Bush 41 Attorney General William Barr 11/26/91 1/15/93 416 1457
101 Bush 41 Secretary of the Treasury Nicholas Brady Reagan admin 1/17/93 1584 combined 1459
133 Clinton Secretary of State Warren Christopher 1/20/93 1/17/97 1458 1459
14 Carter Secretary of State Ed Muskie 5/8/80 1/18/81 255 1460
151 Clinton EPA Administrator Carol Browner 1/22/93 1/19/01 2919 2922
152 Clinton OMB Director Jack Lew 5/21/98 1/19/01 974 2922
153 Clinton Secretary of Agriculture Dan Glickman 3/30/95 1/19/01 2122 2922
154 Clinton Secretary of Commerce Norman Mineta 7/21/00 1/19/01 182 2922
155 Clinton Secretary of State Madeleine Albright 1/23/97 1/19/01 1457 2922
156 Clinton UN Ambassador Richard Holbrooke 9/7/99 1/19/01 500 2922
206 Bush 43 OMB Director Jim Nussle 9/4/07 1/19/09 503 2922
207 Bush 43 Secretary of Commerce Carlos Gutierrez 2/7/05 1/19/09 1442 2922
208 Bush 43 Secretary of the Interior Dirk Kempthorne 5/29/06 1/19/09 966 2922
260 Obama Secretary of Defense Ash Carter 2/17/15 1/19/17 702 2922
15 Carter Attorney General Ben Civiletti 8/16/79 1/19/81 522 1461
16 Carter Secretary of Commerce Philip Klutznick 1/9/80 1/19/81 376 1461
102 Bush 41 Secretary of Housing & Urban Development Jack Kemp 2/13/89 1/19/93 1436 1461
103 Bush 41 Secretary of State Lawrence Eagleburger 12/8/92 1/19/93 42 1461
134 Clinton Secretary of Housing & Urban Development Henry Cisneros 1/22/93 1/19/97 1458 1461
150 Clinton Secretary of the Interior Bruce Babbitt 1/22/93 1/2/01 2902 2905
294 Trump Secretary of the Interior Ryan Zinke 3/1/17 1/2/19 672 713
157 Clinton Attorney General Janet Reno 3/12/93 1/20/01 2871 2923
158 Clinton Chief of Staff John Podesta 10/20/98 1/20/01 823 2923
159 Clinton SBA Administrator Aida Alvarez 3/7/97 1/20/01 1415 2923
160 Clinton Secretary of Defense William Cohen 1/24/97 1/20/01 1457 2923
161 Clinton Secretary of Education Dick Riley 1/21/93 1/20/01 2921 2923
162 Clinton Secretary of Energy Bill Richardson 8/18/98 1/20/01 886 2923
163 Clinton Secretary of Health & Human Services Donna Shalala 1/22/93 1/20/01 2920 2923
164 Clinton Secretary of Housing & Urban Development Andrew Cuomo 1/29/97 1/20/01 1452 2923
165 Clinton Secretary of Labor Alexis Herman 5/1/97 1/20/01 1360 2923
166 Clinton Secretary of the Treasury Larry Summers 7/2/99 1/20/01 568 2923
167 Clinton Secretary of Transportation Rodney Slater 2/14/97 1/20/01 1436 2923
168 Clinton U.S. Trade Representative Charlene Barshefsky 3/18/97 1/20/01 1404 2923
169 Clinton Vice President Al Gore 1/20/93 1/20/01 2922 2923
177 Bush 43 Secretary of Agriculture Ann Veneman 1/20/01 1/20/05 1461 1462
178 Bush 43 Secretary of Education Rod Paige 1/24/01 1/20/05 1457 1462
179 Bush 43 UN Ambassador John Danforth 7/23/04 1/20/05 181 1462
209 Bush 43 Attorney General Michael Mukasey 11/9/07 1/20/09 438 2923
210 Bush 43 Chief of Staff Josh Bolten 4/14/06 1/20/09 1012 2923
211 Bush 43 EPA Administrator Stephen Johnson 5/2/05 1/20/09 1359 2923
212 Bush 43 Secretary of Agriculture Ed Schafer 1/28/08 1/20/09 358 2923
213 Bush 43 Secretary of Education Margaret Spellings 1/24/05 1/20/09 1457 2923
214 Bush 43 Secretary of Energy Samuel Bodman 2/1/05 1/20/09 1449 2923
215 Bush 43 Secretary of Health & Human Services Mike Leavitt 1/26/05 1/20/09 1455 2923
216 Bush 43 Secretary of Housing & Urban Development Steve Preston 6/5/08 1/20/09 229 2923
217 Bush 43 Secretary of Labor Elaine Chao 1/29/01 1/20/09 2913 2923
218 Bush 43 Secretary of State Condoleezza Rice 1/26/05 1/20/09 1455 2923
219 Bush 43 Secretary of the Treasury Hank Paulson 7/10/06 1/20/09 925 2923
220 Bush 43 Secretary of Transportation Mary Peters 10/17/06 1/20/09 826 2923
221 Bush 43 Secretary of Veterans Affairs James Peake 12/20/07 1/20/09 397 2923
222 Bush 43 U.S. Trade Representative Susan Schwab 6/8/06 1/20/09 957 2923
223 Bush 43 Vice President Dick Cheney 1/20/01 1/20/09 2922 2923
261 Obama Vice President Joe Biden 1/20/09 1/20/17 2922 2923
262 Obama Director of National Intelligence James Clapper 8/9/10 1/20/17 2356 2923
263 Obama Chief of Staff Denis McDonough 1/25/13 1/20/17 1456 2923
264 Obama Secretary of State John Kerry 2/1/13 1/20/17 1449 2923
265 Obama Secretary of the Treasury Jack Lew 2/28/13 1/20/17 1422 2923
266 Obama CIA Director John Brennan 3/8/13 1/20/17 1414 2923
267 Obama Secretary of the Interior Sally Jewell 4/12/13 1/20/17 1379 2923
268 Obama Secretary of Energy Ernest Moniz 5/21/13 1/20/17 1340 2923
269 Obama U.S. Trade Representative Michael Froman 6/21/13 1/20/17 1309 2923
270 Obama Secretary of Commerce Penny Pritzker 6/26/13 1/20/17 1304 2923
271 Obama Secretary of Transportation Anthony Foxx 7/2/13 1/20/17 1298 2923
272 Obama EPA Administrator Gina McCarthy 7/19/13 1/20/17 1281 2923
273 Obama Secretary of Labor Tom Perez 7/23/13 1/20/17 1277 2923
274 Obama Secretary of Homeland Security Jeh Johnson 12/23/13 1/20/17 1124 2923
275 Obama SBA Administrator Maria Contreras-Sweet 4/7/14 1/20/17 1019 2923
276 Obama Secretary of Health & Human Services Sylvia Burwell 6/9/14 1/20/17 956 2923
277 Obama OMB Director Shaun Donovan 7/28/14 1/20/17 907 2923
278 Obama Secretary of Housing & Urban Development Julián Castro 7/28/14 1/20/17 907 2923
279 Obama Secretary of Veterans Affairs Bob McDonald 7/30/14 1/20/17 905 2923
280 Obama Attorney General Loretta Lynch 4/27/15 1/20/17 634 2923
281 Obama Secretary of Education John King Jr. 3/14/16 1/20/17 312 2923
17 Carter Chief of Staff Jack Watson 6/11/80 1/20/81 223 1462
18 Carter Director of Central Intelligence Stansfield Turner 3/9/77 1/20/81 1413 1462
19 Carter EPA Administrator Douglas Costle 3/7/77 1/20/81 1415 1462
20 Carter OMB Director Jim McIntyre 9/24/77 1/20/81 1214 1462
21 Carter SBA Administrator A. Vernon Weaver 4/1/77 1/20/81 1390 1462
22 Carter Secretary of Agriculture Robert Bergland 1/23/77 1/20/81 1458 1462
23 Carter Secretary of Defense Harold Brown 1/21/77 1/20/81 1460 1462
24 Carter Secretary of Education Shirley Hufstedler 12/6/79 1/20/81 411 1462
25 Carter Secretary of Energy Charles Duncan 8/24/79 1/20/81 515 1462
26 Carter Secretary of Health, Education & Welfare/Secretary of Health & Human Services Patricia Harris 8/3/79 1/20/81 536 1462
27 Carter Secretary of Housing & Urban Development Moon Landrieu 9/24/79 1/20/81 484 1462
28 Carter Secretary of Labor Ray Marshall 1/27/77 1/20/81 1454 1462
29 Carter Secretary of the Interior Cecil Andrus 1/23/77 1/20/81 1458 1462
30 Carter Secretary of the Treasury G. William Miller 8/6/79 1/20/81 533 1462
31 Carter Secretary of Transportation Neil Goldschmidt 8/15/79 1/20/81 524 1462
32 Carter UN Ambassador Donald McHenry 9/23/79 1/20/81 485 1462
33 Carter Vice President Walter Mondale 1/20/77 1/20/81 1461 1462
66 Reagan Chief of Staff Kenneth Duberstein 7/1/88 1/20/89 203 2923
67 Reagan EPA Administrator Lee Thomas 2/8/85 1/20/89 1442 2923
68 Reagan OMB Director Joseph Wright Jr. 11/8/88 1/20/89 73 2923
69 Reagan Secretary of Agriculture Richard Edmund Lyng 3/7/86 1/20/89 1050 2923
70 Reagan Secretary of Defense Frank Carlucci 11/23/87 1/20/89 424 2923
71 Reagan Secretary of Energy John Herrington 2/7/85 1/20/89 1443 2923

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "cabinet-turnover/cabinet-turnover" (
"president" TEXT,
  "position" TEXT,
  "appointee" TEXT,
  "start" TEXT,
  "end" TEXT,
  "length" TEXT,
  "days" INTEGER
);
Powered by Datasette · Query took 40.491ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub