cabinet-turnover/cabinet-turnover

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

312 rows sorted by days descending

View and edit SQL

Suggested facets: president, position

Link rowid president position appointee start end length days ▲
82 Reagan SBA Administrator James Abdnor 3/23/87 4/20/89 759 3013
81 Reagan UN Ambassador Vernon Walters 5/22/85 3/15/89 1393 2977
227 Bush 43 CIA Director Michael Hayden 5/30/06 2/12/09 989 2946
80 Reagan Secretary of Commerce William Verity Jr. 10/19/87 1/30/89 469 2933
226 Bush 43 Director of National Intelligence Mike McConnell 2/13/07 1/27/09 714 2930
225 Bush 43 UN Ambassador Zalmay Khalilzad 4/30/07 1/22/09 633 2925
224 Bush 43 Secretary of Homeland Security Michael Chertoff 2/15/05 1/21/09 1436 2924
282 Obama UN Ambassador Samantha Power 8/5/13 1/21/17 1265 2924
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
72 Reagan Secretary of Health & Human Services Otis Bowen 12/13/85 1/20/89 1134 2923
73 Reagan Secretary of Housing & Urban Development Samuel Pierce Jr. 1/23/81 1/20/89 2919 2923
74 Reagan Secretary of Labor Ann McLaughlin 12/14/87 1/20/89 403 2923
75 Reagan Secretary of State George Shultz 7/16/82 1/20/89 2380 2923
76 Reagan Secretary of the Interior Donald Hodel 2/8/85 1/20/89 1442 2923
77 Reagan Secretary of Transportation James Burnley IV 12/3/87 1/20/89 414 2923
78 Reagan U.S. Trade Representative Clayton Yeutter 7/1/85 1/20/89 1299 2923
79 Reagan Vice President George H.W. Bush 1/20/81 1/20/89 2922 2923
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
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
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
259 Obama Secretary of Agriculture Tom Vilsack 1/20/09 1/13/17 2915 2916
150 Clinton Secretary of the Interior Bruce Babbitt 1/22/93 1/2/01 2902 2905
65 Reagan OMB Director Jim Miller 10/8/85 10/15/88 1103 2826
64 Reagan Secretary of Education Bill Bennett 2/6/85 9/20/88 1322 2801
63 Reagan Secretary of the Treasury James Baker 2/3/85 8/17/88 1291 2767
62 Reagan Attorney General Ed Meese 2/25/85 8/12/88 1264 2762
149 Clinton Secretary of Veterans Affairs Togo West Jr. 5/5/98 7/25/00 812 2744
148 Clinton Secretary of Commerce Bill Daley 1/30/97 7/19/00 1266 2738
61 Reagan Chief of Staff Howard Baker 3/2/87 7/1/88 487 2720
205 Bush 43 SBA Administrator Steve Preston 7/10/06 6/5/08 696 2694
204 Bush 43 Secretary of Housing & Urban Development Alphonso Jackson 3/31/04 4/18/08 1479 2646
258 Obama Secretary of Education Arne Duncan 1/20/09 12/31/15 2536 2537
60 Reagan Secretary of Defense Caspar Weinberger 1/21/81 11/23/87 2497 2499
59 Reagan Secretary of Labor Bill Brock 4/29/85 10/31/87 915 2476
203 Bush 43 Secretary of Veterans Affairs Jim Nicholson 2/1/05 10/1/07 972 2446
58 Reagan Secretary of Transportation Elizabeth Dole 2/7/83 9/30/87 1696 2445
202 Bush 43 Secretary of Agriculture Mike Johanns 1/21/05 9/20/07 972 2435
201 Bush 43 Attorney General Alberto Gonzales 2/3/05 9/17/07 956 2432
200 Bush 43 OMB Director Rob Portman 5/26/06 8/3/07 434 2387

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