cabinet-turnover/cabinet-turnover

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

312 rows sorted by length

View and edit SQL

Suggested facets: president, position

Link rowid president position appointee start end length ▼ days
295 Trump Vice President Mike Pence 1/20/17 Still in office    
296 Trump Secretary of Transportation Elaine Chao 1/31/17 Still in office    
297 Trump Secretary of Education Betsy DeVos 2/7/17 Still in office    
298 Trump Secretary of the Treasury Steve Mnuchin 2/13/17 Still in office    
299 Trump SBA Administrator Linda McMahon 2/14/17 Still in office    
300 Trump OMB Director Mick Mulvaney 2/16/17 Still in office    
301 Trump Secretary of Commerce Wilbur Ross 2/28/17 Still in office    
302 Trump Secretary of Energy Rick Perry 3/2/17 Still in office    
303 Trump Secretary of Housing & Urban Development Ben Carson 3/2/17 Still in office    
304 Trump Director of National Intelligence Dan Coats 3/16/17 Still in office    
305 Trump Secretary of Agriculture Sonny Perdue 4/25/17 Still in office    
306 Trump Secretary of Labor Alexander Acosta 4/28/17 Still in office    
307 Trump U.S. Trade Representative Robert Lighthizer 5/15/17 Still in office    
308 Trump Secretary of Homeland Security Kirstjen Nielsen 12/6/17 Still in office    
309 Trump Secretary of Health & Human Services Alex Azar 1/29/18 Still in office    
310 Trump Secretary of State Mike Pompeo 4/26/18 Still in office    
311 Trump CIA Director Gina Haspel 5/21/18 Still in office    
312 Trump Secretary of Veterans Affairs Robert Wilkie 7/30/18 Still in office    
175 Bush 43 UN Ambassador John Negroponte 9/19/01 6/23/04 1008 1251
52 Reagan Secretary of Health & Human Services Margaret Heckler 3/9/83 12/13/85 1010 1789
10 Carter Secretary of Commerce Juanita Kreps 1/23/77 10/31/79 1011 1015
210 Bush 43 Chief of Staff Josh Bolten 4/14/06 1/20/09 1012 2923
40 Reagan Secretary of the Interior James Watt 1/23/81 11/8/83 1019 1023
275 Obama SBA Administrator Maria Contreras-Sweet 4/7/14 1/20/17 1019 2923
191 Bush 43 OMB Director Josh Bolten 6/26/03 4/14/06 1023 1911
93 Bush 41 Secretary of Transportation Sam Skinner 2/6/89 12/13/91 1040 1058
69 Reagan Secretary of Agriculture Richard Edmund Lyng 3/7/86 1/20/89 1050 2923
174 Bush 43 Secretary of Housing & Urban Development Mel Martinez 1/24/01 12/12/03 1052 1057
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
139 Clinton Secretary of Defense William Perry 2/3/94 1/23/97 1085 1465
83 Reagan Attorney General Dick Thornburgh 8/12/88 Bush admin 1098 combined  
91 Bush 41 Attorney General Dick Thornburgh Reagan admin 8/15/91 1098 combined 938
65 Reagan OMB Director Jim Miller 10/8/85 10/15/88 1103 2826
274 Obama Secretary of Homeland Security Jeh Johnson 12/23/13 1/20/17 1124 2923
72 Reagan Secretary of Health & Human Services Otis Bowen 12/13/85 1/20/89 1134 2923
96 Bush 41 UN Ambassador Tom Pickering 3/20/89 5/7/92 1144 1204
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
11 Carter Secretary of State Cyrus Vance 1/23/77 4/28/80 1191 1195
20 Carter OMB Director Jim McIntyre 9/24/77 1/20/81 1214 1462
194 Bush 43 Secretary of the Treasury John Snow 2/3/03 6/29/06 1242 1987
62 Reagan Attorney General Ed Meese 2/25/85 8/12/88 1264 2762
282 Obama UN Ambassador Samantha Power 8/5/13 1/21/17 1265 2924
148 Clinton Secretary of Commerce Bill Daley 1/30/97 7/19/00 1266 2738
273 Obama Secretary of Labor Tom Perez 7/23/13 1/20/17 1277 2923
272 Obama EPA Administrator Gina McCarthy 7/19/13 1/20/17 1281 2923
63 Reagan Secretary of the Treasury James Baker 2/3/85 8/17/88 1291 2767
99 Bush 41 Secretary of Veterans Affairs Ed Derwinski 3/15/89 9/26/92 1291 1346
271 Obama Secretary of Transportation Anthony Foxx 7/2/13 1/20/17 1298 2923
78 Reagan U.S. Trade Representative Clayton Yeutter 7/1/85 1/20/89 1299 2923
270 Obama Secretary of Commerce Penny Pritzker 6/26/13 1/20/17 1304 2923
98 Bush 41 Secretary of State James Baker 1/25/89 8/23/92 1306 1312
269 Obama U.S. Trade Representative Michael Froman 6/21/13 1/20/17 1309 2923
64 Reagan Secretary of Education Bill Bennett 2/6/85 9/20/88 1322 2801
268 Obama Secretary of Energy Ernest Moniz 5/21/13 1/20/17 1340 2923
211 Bush 43 EPA Administrator Stephen Johnson 5/2/05 1/20/09 1359 2923
165 Clinton Secretary of Labor Alexis Herman 5/1/97 1/20/01 1360 2923
267 Obama Secretary of the Interior Sally Jewell 4/12/13 1/20/17 1379 2923
21 Carter SBA Administrator A. Vernon Weaver 4/1/77 1/20/81 1390 1462
81 Reagan UN Ambassador Vernon Walters 5/22/85 3/15/89 1393 2977
111 Bush 41 Secretary of Defense Dick Cheney 3/21/89 1/20/93 1401 1462
168 Clinton U.S. Trade Representative Charlene Barshefsky 3/18/97 1/20/01 1404 2923
18 Carter Director of Central Intelligence Stansfield Turner 3/9/77 1/20/81 1413 1462
266 Obama CIA Director John Brennan 3/8/13 1/20/17 1414 2923
19 Carter EPA Administrator Douglas Costle 3/7/77 1/20/81 1415 1462
159 Clinton SBA Administrator Aida Alvarez 3/7/97 1/20/01 1415 2923
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
265 Obama Secretary of the Treasury Jack Lew 2/28/13 1/20/17 1422 2923
239 Obama Secretary of Labor Hilda Solis 2/24/09 1/22/13 1428 1464
102 Bush 41 Secretary of Housing & Urban Development Jack Kemp 2/13/89 1/19/93 1436 1461
167 Clinton Secretary of Transportation Rodney Slater 2/14/97 1/20/01 1436 2923
224 Bush 43 Secretary of Homeland Security Michael Chertoff 2/15/05 1/21/09 1436 2924
41 Reagan Secretary of Education T.H. Bell 1/23/81 12/31/84 1438 1442
67 Reagan EPA Administrator Lee Thomas 2/8/85 1/20/89 1442 2923
76 Reagan Secretary of the Interior Donald Hodel 2/8/85 1/20/89 1442 2923
207 Bush 43 Secretary of Commerce Carlos Gutierrez 2/7/05 1/19/09 1442 2922
71 Reagan Secretary of Energy John Herrington 2/7/85 1/20/89 1443 2923
106 Bush 41 EPA Administrator William Reilly 2/6/89 1/20/93 1444 1462
118 Bush 41 U.S. Trade Representative Carla Hills 2/6/89 1/20/93 1444 1462
116 Bush 41 Secretary of the Interior Manuel Luján Jr. 2/3/89 1/20/93 1447 1462
132 Clinton Secretary of Labor Robert Reich 1/22/93 1/10/97 1449 1452
214 Bush 43 Secretary of Energy Samuel Bodman 2/1/05 1/20/09 1449 2923
264 Obama Secretary of State John Kerry 2/1/13 1/20/17 1449 2923
164 Clinton Secretary of Housing & Urban Development Andrew Cuomo 1/29/97 1/20/01 1452 2923
28 Carter Secretary of Labor Ray Marshall 1/27/77 1/20/81 1454 1462
182 Bush 43 Secretary of Health & Human Services Tommy Thompson 2/2/01 1/26/05 1454 1468
138 Clinton UN Ambassador Madeleine Albright 1/27/93 1/21/97 1455 1463
215 Bush 43 Secretary of Health & Human Services Mike Leavitt 1/26/05 1/20/09 1455 2923
218 Bush 43 Secretary of State Condoleezza Rice 1/26/05 1/20/09 1455 2923
107 Bush 41 OMB Director Dick Darman 1/25/89 1/20/93 1456 1462
245 Obama U.S. Trade Representative Ron Kirk 3/20/09 3/15/13 1456 1516
263 Obama Chief of Staff Denis McDonough 1/25/13 1/20/17 1456 2923
155 Clinton Secretary of State Madeleine Albright 1/23/97 1/19/01 1457 2922
160 Clinton Secretary of Defense William Cohen 1/24/97 1/20/01 1457 2923
178 Bush 43 Secretary of Education Rod Paige 1/24/01 1/20/05 1457 1462
213 Bush 43 Secretary of Education Margaret Spellings 1/24/05 1/20/09 1457 2923
22 Carter Secretary of Agriculture Robert Bergland 1/23/77 1/20/81 1458 1462
29 Carter Secretary of the Interior Cecil Andrus 1/23/77 1/20/81 1458 1462

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 22.839ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub