cabinet-turnover/cabinet-turnover

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

312 rows sorted by days

View and edit SQL

Suggested facets: president, position

Link rowid president position appointee start end length days ▼
83 Reagan Attorney General Dick Thornburgh 8/12/88 Bush admin 1098 combined #VALUE!
84 Reagan Director of Central Intelligence Bill Webster 5/26/87 Bush admin 1558 combined #VALUE!
85 Reagan Secretary of Education Lauro Cavazos 9/20/88 Bush admin 816 combined #VALUE!
86 Reagan Secretary of the Treasury Nicholas Brady 9/16/88 Bush admin 1584 combined #VALUE!
170 Clinton Director of Central Intelligence George Tenet 7/11/97 Bush admin 2557 combined #VALUE!
228 Bush 43 Secretary of Defense Bob Gates 12/18/06 Obama admin 1655 combined #VALUE!
295 Trump Vice President Mike Pence 1/20/17 Still in office #VALUE! #VALUE!
296 Trump Secretary of Transportation Elaine Chao 1/31/17 Still in office #VALUE! #VALUE!
297 Trump Secretary of Education Betsy DeVos 2/7/17 Still in office #VALUE! #VALUE!
298 Trump Secretary of the Treasury Steve Mnuchin 2/13/17 Still in office #VALUE! #VALUE!
299 Trump SBA Administrator Linda McMahon 2/14/17 Still in office #VALUE! #VALUE!
300 Trump OMB Director Mick Mulvaney 2/16/17 Still in office #VALUE! #VALUE!
301 Trump Secretary of Commerce Wilbur Ross 2/28/17 Still in office #VALUE! #VALUE!
302 Trump Secretary of Energy Rick Perry 3/2/17 Still in office #VALUE! #VALUE!
303 Trump Secretary of Housing & Urban Development Ben Carson 3/2/17 Still in office #VALUE! #VALUE!
304 Trump Director of National Intelligence Dan Coats 3/16/17 Still in office #VALUE! #VALUE!
305 Trump Secretary of Agriculture Sonny Perdue 4/25/17 Still in office #VALUE! #VALUE!
306 Trump Secretary of Labor Alexander Acosta 4/28/17 Still in office #VALUE! #VALUE!
307 Trump U.S. Trade Representative Robert Lighthizer 5/15/17 Still in office #VALUE! #VALUE!
308 Trump Secretary of Homeland Security Kirstjen Nielsen 12/6/17 Still in office #VALUE! #VALUE!
309 Trump Secretary of Health & Human Services Alex Azar 1/29/18 Still in office #VALUE! #VALUE!
310 Trump Secretary of State Mike Pompeo 4/26/18 Still in office #VALUE! #VALUE!
311 Trump CIA Director Gina Haspel 5/21/18 Still in office #VALUE! #VALUE!
312 Trump Secretary of Veterans Affairs Robert Wilkie 7/30/18 Still in office #VALUE! #VALUE!
10 Carter Secretary of Commerce Juanita Kreps 1/23/77 10/31/79 1011 1015
40 Reagan Secretary of the Interior James Watt 1/23/81 11/8/83 1019 1023
174 Bush 43 Secretary of Housing & Urban Development Mel Martinez 1/24/01 12/12/03 1052 1057
93 Bush 41 Secretary of Transportation Sam Skinner 2/6/89 12/13/91 1040 1058
94 Bush 41 Chief of Staff John Sununu 1/20/89 12/15/91 1059 1060
95 Bush 41 Secretary of Commerce Robert Mosbacher 1/31/89 1/15/92 1079 1091
235 Obama OMB Director Jack Lew 11/18/10 1/26/12 434 1102
236 Obama Chief of Staff Bill Daley 1/13/11 1/27/12 379 1103
128 Clinton Secretary of Commerce Ron Brown 1/22/93 4/3/96 1167 1170
129 Clinton U.S. Trade Representative Mickey Kantor 1/22/93 4/12/96 1176 1179
130 Clinton OMB Director Alice Rivlin 10/17/94 4/26/96 557 1193
11 Carter Secretary of State Cyrus Vance 1/23/77 4/28/80 1191 1195
96 Bush 41 UN Ambassador Tom Pickering 3/20/89 5/7/92 1144 1204
12 Carter Chief of Staff Hamilton Jordan 7/18/79 6/11/80 329 1239
237 Obama Secretary of Commerce John Bryson 10/21/11 6/21/12 244 1249
175 Bush 43 UN Ambassador John Negroponte 9/19/01 6/23/04 1008 1251
176 Bush 43 Director of Central Intelligence George Tenet Clinton admin 7/11/04 2557 combined 1269
97 Bush 41 Chief of Staff Sam Skinner 12/16/91 8/23/92 251 1312
98 Bush 41 Secretary of State James Baker 1/25/89 8/23/92 1306 1312
99 Bush 41 Secretary of Veterans Affairs Ed Derwinski 3/15/89 9/26/92 1291 1346
238 Obama CIA Director David Petraeus 9/6/11 11/9/12 430 1390
131 Clinton Director of Central Intelligence John Deutch 5/10/95 12/15/96 585 1426
13 Carter U.S. Trade Representative Reubin Askew 10/1/79 12/31/80 457 1442
41 Reagan Secretary of Education T.H. Bell 1/23/81 12/31/84 1438 1442
42 Reagan EPA Administrator William Ruckelshaus 5/18/83 1/4/85 597 1446
132 Clinton Secretary of Labor Robert Reich 1/22/93 1/10/97 1449 1452
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
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
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
104 Bush 41 Chief of Staff James Baker 8/23/92 1/20/93 150 1462
105 Bush 41 Director of Central Intelligence Bob Gates 11/6/91 1/20/93 441 1462
106 Bush 41 EPA Administrator William Reilly 2/6/89 1/20/93 1444 1462
107 Bush 41 OMB Director Dick Darman 1/25/89 1/20/93 1456 1462
108 Bush 41 SBA Administrator Pat Saiki 3/27/91 1/20/93 665 1462
109 Bush 41 Secretary of Agriculture Ed Madigan 3/12/91 1/20/93 680 1462
110 Bush 41 Secretary of Commerce Barbara Franklin 2/27/92 1/20/93 328 1462
111 Bush 41 Secretary of Defense Dick Cheney 3/21/89 1/20/93 1401 1462
112 Bush 41 Secretary of Education Lamar Alexander 3/18/91 1/20/93 674 1462
113 Bush 41 Secretary of Energy James Watkins 3/1/89 1/20/93 1421 1462
114 Bush 41 Secretary of Health & Human Services Louis Sullivan 3/1/89 1/20/93 1421 1462
115 Bush 41 Secretary of Labor Lynn Morley Martin 2/7/91 1/20/93 713 1462
116 Bush 41 Secretary of the Interior Manuel Luján Jr. 2/3/89 1/20/93 1447 1462
117 Bush 41 Secretary of Transportation Andy Card 3/11/92 1/20/93 315 1462
118 Bush 41 U.S. Trade Representative Carla Hills 2/6/89 1/20/93 1444 1462
119 Bush 41 Vice President Dan Quayle 1/20/89 1/20/93 1461 1462
135 Clinton Chief of Staff Leon Panetta 7/17/94 1/20/97 918 1462
136 Clinton Secretary of Energy Hazel O'Leary 1/22/93 1/20/97 1459 1462
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
137 Clinton Secretary of Commerce Mickey Kantor 4/12/96 1/21/97 284 1463
138 Clinton UN Ambassador Madeleine Albright 1/27/93 1/21/97 1455 1463
239 Obama Secretary of Labor Hilda Solis 2/24/09 1/22/13 1428 1464

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" TEXT
)
Powered by Datasette · Query took 54.115ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub