home / fivethirtyeight

cabinet-turnover/cabinet-turnover

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

312 rows sorted by appointee

View and edit SQL

Suggested facets: president, position

Link rowid president position appointee ▼ start end length days
21 Carter SBA Administrator A. Vernon Weaver 4/1/77 1/20/81 1390 1462
159 Clinton SBA Administrator Aida Alvarez 3/7/97 1/20/01 1415 2923
169 Clinton Vice President Al Gore 1/20/93 1/20/01 2922 2923
201 Bush 43 Attorney General Alberto Gonzales 2/3/05 9/17/07 956 2432
309 Trump Secretary of Health & Human Services Alex Azar 1/29/18 Still in office #VALUE! #VALUE!
306 Trump Secretary of Labor Alexander Acosta 4/28/17 Still in office #VALUE! #VALUE!
35 Reagan Secretary of State Alexander Haig 1/22/81 7/5/82 529 532
165 Clinton Secretary of Labor Alexis Herman 5/1/97 1/20/01 1360 2923
130 Clinton OMB Director Alice Rivlin 10/17/94 4/26/96 557 1193
204 Bush 43 Secretary of Housing & Urban Development Alphonso Jackson 3/31/04 4/18/08 1479 2646
164 Clinton Secretary of Housing & Urban Development Andrew Cuomo 1/29/97 1/20/01 1452 2923
9 Carter UN Ambassador Andrew Young 1/30/77 9/23/79 966 977
117 Bush 41 Secretary of Transportation Andy Card 3/11/92 1/20/93 315 1462
190 Bush 43 Chief of Staff Andy Card 1/20/01 4/14/06 1910 1911
74 Reagan Secretary of Labor Ann McLaughlin 12/14/87 1/20/89 403 2923
177 Bush 43 Secretary of Agriculture Ann Veneman 1/20/01 1/20/05 1461 1462
39 Reagan EPA Administrator Anne Gorsuch 5/20/81 3/9/83 658 779
271 Obama Secretary of Transportation Anthony Foxx 7/2/13 1/20/17 1298 2923
183 Bush 43 Secretary of Veterans Affairs Anthony Principi 1/23/01 1/26/05 1464 1468
258 Obama Secretary of Education Arne Duncan 1/20/09 12/31/15 2536 2537
260 Obama Secretary of Defense Ash Carter 2/17/15 1/19/17 702 2922
110 Bush 41 Secretary of Commerce Barbara Franklin 2/27/92 1/20/93 328 1462
303 Trump Secretary of Housing & Urban Development Ben Carson 3/2/17 Still in office #VALUE! #VALUE!
15 Carter Attorney General Ben Civiletti 8/16/79 1/19/81 522 1461
1 Carter OMB Director Bert Lance 1/21/77 9/23/77 245 247
297 Trump Secretary of Education Betsy DeVos 2/7/17 Still in office #VALUE! #VALUE!
64 Reagan Secretary of Education Bill Bennett 2/6/85 9/20/88 1322 2801
50 Reagan U.S. Trade Representative Bill Brock 1/23/81 4/29/85 1557 1561
59 Reagan Secretary of Labor Bill Brock 4/29/85 10/31/87 915 2476
148 Clinton Secretary of Commerce Bill Daley 1/30/97 7/19/00 1266 2738
236 Obama Chief of Staff Bill Daley 1/13/11 1/27/12 379 1103
145 Clinton UN Ambassador Bill Richardson 2/18/97 8/18/98 546 2037
162 Clinton Secretary of Energy Bill Richardson 8/18/98 1/20/01 886 2923
84 Reagan Director of Central Intelligence Bill Webster 5/26/87 Bush admin 1558 combined #VALUE!
92 Bush 41 Director of Central Intelligence Bill Webster Reagan admin 8/31/91 1558 combined 954
105 Bush 41 Director of Central Intelligence Bob Gates 11/6/91 1/20/93 441 1462
228 Bush 43 Secretary of Defense Bob Gates 12/18/06 Obama admin 1655 combined #VALUE!
233 Obama Secretary of Defense Bob Gates Bush admin 6/30/11 1655 combined 892
279 Obama Secretary of Veterans Affairs Bob McDonald 7/30/14 1/20/17 905 2923
147 Clinton Secretary of the Treasury Bob Rubin 1/10/95 7/2/99 1634 2355
2 Carter Secretary of Transportation Brock Adams 1/23/77 7/20/79 908 912
150 Clinton Secretary of the Interior Bruce Babbitt 1/22/93 1/2/01 2902 2905
118 Bush 41 U.S. Trade Representative Carla Hills 2/6/89 1/20/93 1444 1462
207 Bush 43 Secretary of Commerce Carlos Gutierrez 2/7/05 1/19/09 1442 2922
151 Clinton EPA Administrator Carol Browner 1/22/93 1/19/01 2919 2922
60 Reagan Secretary of Defense Caspar Weinberger 1/21/81 11/23/87 2497 2499
29 Carter Secretary of the Interior Cecil Andrus 1/23/77 1/20/81 1458 1462
168 Clinton U.S. Trade Representative Charlene Barshefsky 3/18/97 1/20/01 1404 2923
25 Carter Secretary of Energy Charles Duncan 8/24/79 1/20/81 515 1462
173 Bush 43 EPA Administrator Christine Todd Whitman 1/31/01 6/27/03 877 889
256 Obama Secretary of Defense Chuck Hagel 2/27/13 2/17/15 720 2220
78 Reagan U.S. Trade Representative Clayton Yeutter 7/1/85 1/20/89 1299 2923
89 Bush 41 Secretary of Agriculture Clayton Yeutter 2/16/89 3/1/91 743 771
181 Bush 43 Secretary of State Colin Powell 1/20/01 1/25/05 1466 1467
218 Bush 43 Secretary of State Condoleezza Rice 1/26/05 1/20/09 1455 2923
11 Carter Secretary of State Cyrus Vance 1/23/77 4/28/80 1191 1195
304 Trump Director of National Intelligence Dan Coats 3/16/17 Still in office #VALUE! #VALUE!
153 Clinton Secretary of Agriculture Dan Glickman 3/30/95 1/19/01 2122 2922
119 Bush 41 Vice President Dan Quayle 1/20/89 1/20/93 1461 1462
238 Obama CIA Director David Petraeus 9/6/11 11/9/12 430 1390
286 Trump Secretary of Veterans Affairs David Shulkin 2/14/17 3/28/18 407 433
51 Reagan OMB Director David Stockman 1/21/81 8/1/85 1653 1655
263 Obama Chief of Staff Denis McDonough 1/25/13 1/20/17 1456 2923
229 Obama Director of National Intelligence Dennis Blair 1/29/09 5/28/10 484 494
111 Bush 41 Secretary of Defense Dick Cheney 3/21/89 1/20/93 1401 1462
223 Bush 43 Vice President Dick Cheney 1/20/01 1/20/09 2922 2923
107 Bush 41 OMB Director Dick Darman 1/25/89 1/20/93 1456 1462
161 Clinton Secretary of Education Dick Riley 1/21/93 1/20/01 2921 2923
83 Reagan Attorney General Dick Thornburgh 8/12/88 Bush admin 1098 combined #VALUE!
91 Bush 41 Attorney General Dick Thornburgh Reagan admin 8/15/91 1098 combined 938
208 Bush 43 Secretary of the Interior Dirk Kempthorne 5/29/06 1/19/09 966 2922
43 Reagan Secretary of the Treasury Don Regan 1/22/81 2/2/85 1472 1475
56 Reagan Chief of Staff Don Regan 2/4/85 2/27/87 753 2230
187 Bush 43 Secretary of Commerce Donald Evans 1/20/01 2/3/05 1475 1476
45 Reagan Secretary of Energy Donald Hodel 11/5/82 2/7/85 825 1480
76 Reagan Secretary of the Interior Donald Hodel 2/8/85 1/20/89 1442 2923
32 Carter UN Ambassador Donald McHenry 9/23/79 1/20/81 485 1462
197 Bush 43 Secretary of Defense Donald Rumsfeld 1/20/01 12/18/06 2158 2159
163 Clinton Secretary of Health & Human Services Donna Shalala 1/22/93 1/20/01 2920 2923
19 Carter EPA Administrator Douglas Costle 3/7/77 1/20/81 1415 1462
37 Reagan Secretary of Transportation Drew Lewis 1/23/81 2/1/83 739 743
99 Bush 41 Secretary of Veterans Affairs Ed Derwinski 3/15/89 9/26/92 1291 1346
109 Bush 41 Secretary of Agriculture Ed Madigan 3/12/91 1/20/93 680 1462
62 Reagan Attorney General Ed Meese 2/25/85 8/12/88 1264 2762
14 Carter Secretary of State Ed Muskie 5/8/80 1/18/81 255 1460
212 Bush 43 Secretary of Agriculture Ed Schafer 1/28/08 1/20/09 358 2923
120 Bush 41 UN Ambassador Edward Perkins 5/12/92 1/27/93 260 1469
217 Bush 43 Secretary of Labor Elaine Chao 1/29/01 1/20/09 2913 2923
296 Trump Secretary of Transportation Elaine Chao 1/31/17 Still in office #VALUE! #VALUE!
58 Reagan Secretary of Transportation Elizabeth Dole 2/7/83 9/30/87 1696 2445
87 Bush 41 Secretary of Labor Elizabeth Dole 1/25/89 11/23/90 667 673
257 Obama Attorney General Eric Holder 2/3/09 4/24/15 2271 2286
252 Obama Secretary of Veterans Affairs Eric Shinseki 1/21/09 5/30/14 1955 1957
268 Obama Secretary of Energy Ernest Moniz 5/21/13 1/20/17 1340 2923
124 Clinton SBA Administrator Erskine Bowles 5/12/93 10/6/94 512 625
146 Clinton Chief of Staff Erskine Bowles 1/20/97 10/20/98 638 2100
141 Clinton Secretary of Transportation Federico Peña 1/21/93 2/14/97 1485 1487
144 Clinton Secretary of Energy Federico Peña 3/12/97 6/30/98 475 1988
70 Reagan Secretary of Defense Frank Carlucci 11/23/87 1/20/89 424 2923
143 Clinton OMB Director Frank Raines 9/13/96 5/21/98 615 1948

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