home / fivethirtyeight

cabinet-turnover/cabinet-turnover

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

312 rows sorted by start

View and edit SQL

Suggested facets: president, position

Link rowid president position appointee start ▼ end length days
147 Clinton Secretary of the Treasury Bob Rubin 1/10/95 7/2/99 1634 2355
236 Obama Chief of Staff Bill Daley 1/13/11 1/27/12 379 1103
177 Bush 43 Secretary of Agriculture Ann Veneman 1/20/01 1/20/05 1461 1462
181 Bush 43 Secretary of State Colin Powell 1/20/01 1/25/05 1466 1467
184 Bush 43 Secretary of Energy Spencer Abraham 1/20/01 1/31/05 1472 1473
187 Bush 43 Secretary of Commerce Donald Evans 1/20/01 2/3/05 1475 1476
190 Bush 43 Chief of Staff Andy Card 1/20/01 4/14/06 1910 1911
197 Bush 43 Secretary of Defense Donald Rumsfeld 1/20/01 12/18/06 2158 2159
223 Bush 43 Vice President Dick Cheney 1/20/01 1/20/09 2922 2923
230 Obama OMB Director Peter Orszag 1/20/09 7/30/10 556 557
231 Obama Chief of Staff Rahm Emanuel 1/20/09 10/1/10 619 620
246 Obama Secretary of the Interior Ken Salazar 1/20/09 4/12/13 1543 1544
258 Obama Secretary of Education Arne Duncan 1/20/09 12/31/15 2536 2537
259 Obama Secretary of Agriculture Tom Vilsack 1/20/09 1/13/17 2915 2916
261 Obama Vice President Joe Biden 1/20/09 1/20/17 2922 2923
283 Trump Chief of Staff Reince Priebus 1/20/17 7/28/17 189 190
284 Trump Secretary of Homeland Security John Kelly 1/20/17 7/28/17 189 190
291 Trump Secretary of Defense Jim Mattis 1/20/17 12/31/18 710 711
295 Trump Vice President Mike Pence 1/20/17 Still in office #VALUE! #VALUE!
33 Carter Vice President Walter Mondale 1/20/77 1/20/81 1461 1462
44 Reagan Chief of Staff James Baker 1/20/81 2/3/85 1475 1476
57 Reagan Secretary of Commerce Mac Baldrige 1/20/81 7/25/87 2377 2378
79 Reagan Vice President George H.W. Bush 1/20/81 1/20/89 2922 2923
94 Bush 41 Chief of Staff John Sununu 1/20/89 12/15/91 1059 1060
119 Bush 41 Vice President Dan Quayle 1/20/89 1/20/93 1461 1462
122 Clinton Chief of Staff Mack McLarty 1/20/93 7/17/94 543 544
133 Clinton Secretary of State Warren Christopher 1/20/93 1/17/97 1458 1459
169 Clinton Vice President Al Gore 1/20/93 1/20/01 2922 2923
146 Clinton Chief of Staff Erskine Bowles 1/20/97 10/20/98 638 2100
202 Bush 43 Secretary of Agriculture Mike Johanns 1/21/05 9/20/07 972 2435
242 Obama Secretary of State Hillary Clinton 1/21/09 2/1/13 1472 1474
247 Obama Secretary of Energy Steven Chu 1/21/09 4/22/13 1552 1554
251 Obama Secretary of Homeland Security Janet Napolitano 1/21/09 9/6/13 1689 1691
252 Obama Secretary of Veterans Affairs Eric Shinseki 1/21/09 5/30/14 1955 1957
1 Carter OMB Director Bert Lance 1/21/77 9/23/77 245 247
23 Carter Secretary of Defense Harold Brown 1/21/77 1/20/81 1460 1462
51 Reagan OMB Director David Stockman 1/21/81 8/1/85 1653 1655
60 Reagan Secretary of Defense Caspar Weinberger 1/21/81 11/23/87 2497 2499
121 Clinton Secretary of Defense Les Aspin 1/21/93 2/3/94 378 380
123 Clinton OMB Director Leon Panetta 1/21/93 7/17/94 542 544
141 Clinton Secretary of Transportation Federico Peña 1/21/93 2/14/97 1485 1487
161 Clinton Secretary of Education Dick Riley 1/21/93 1/20/01 2921 2923
35 Reagan Secretary of State Alexander Haig 1/22/81 7/5/82 529 532
38 Reagan Secretary of Health & Human Services Richard Schweiker 1/22/81 2/3/83 742 745
43 Reagan Secretary of the Treasury Don Regan 1/22/81 2/2/85 1472 1475
125 Clinton Secretary of the Treasury Lloyd Bentsen 1/22/93 12/22/94 699 702
126 Clinton Secretary of Agriculture Mike Espy 1/22/93 12/31/94 708 711
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
132 Clinton Secretary of Labor Robert Reich 1/22/93 1/10/97 1449 1452
134 Clinton Secretary of Housing & Urban Development Henry Cisneros 1/22/93 1/19/97 1458 1461
136 Clinton Secretary of Energy Hazel O'Leary 1/22/93 1/20/97 1459 1462
150 Clinton Secretary of the Interior Bruce Babbitt 1/22/93 1/2/01 2902 2905
151 Clinton EPA Administrator Carol Browner 1/22/93 1/19/01 2919 2922
163 Clinton Secretary of Health & Human Services Donna Shalala 1/22/93 1/20/01 2920 2923
172 Bush 43 OMB Director Mitch Daniels 1/23/01 6/6/03 864 868
183 Bush 43 Secretary of Veterans Affairs Anthony Principi 1/23/01 1/26/05 1464 1468
249 Obama Secretary of Transportation Ray LaHood 1/23/09 7/2/13 1621 1625
288 Trump CIA Director Mike Pompeo 1/23/17 4/26/18 458 462
2 Carter Secretary of Transportation Brock Adams 1/23/77 7/20/79 908 912
4 Carter Secretary of Housing & Urban Development Patricia Harris 1/23/77 8/3/79 922 926
5 Carter Secretary of the Treasury W. Michael Blumenthal 1/23/77 8/4/79 923 927
10 Carter Secretary of Commerce Juanita Kreps 1/23/77 10/31/79 1011 1015
11 Carter Secretary of State Cyrus Vance 1/23/77 4/28/80 1191 1195
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
36 Reagan Secretary of Energy James Edwards 1/23/81 11/5/82 651 655
37 Reagan Secretary of Transportation Drew Lewis 1/23/81 2/1/83 739 743
40 Reagan Secretary of the Interior James Watt 1/23/81 11/8/83 1019 1023
41 Reagan Secretary of Education T.H. Bell 1/23/81 12/31/84 1438 1442
47 Reagan Attorney General William French Smith 1/23/81 2/25/85 1494 1498
50 Reagan U.S. Trade Representative Bill Brock 1/23/81 4/29/85 1557 1561
53 Reagan Secretary of Agriculture John Block 1/23/81 2/14/86 1848 1852
73 Reagan Secretary of Housing & Urban Development Samuel Pierce Jr. 1/23/81 1/20/89 2919 2923
142 Clinton Secretary of Veterans Affairs Jesse Brown 1/23/93 7/3/97 1622 1626
155 Clinton Secretary of State Madeleine Albright 1/23/97 1/19/01 1457 2922
174 Bush 43 Secretary of Housing & Urban Development Mel Martinez 1/24/01 12/12/03 1052 1057
178 Bush 43 Secretary of Education Rod Paige 1/24/01 1/20/05 1457 1462
185 Bush 43 Secretary of Homeland Security Tom Ridge 1/24/03 2/1/05 739 1474
213 Bush 43 Secretary of Education Margaret Spellings 1/24/05 1/20/09 1457 2923
160 Clinton Secretary of Defense William Cohen 1/24/97 1/20/01 1457 2923
196 Bush 43 Secretary of Transportation Norman Mineta 1/25/01 7/7/06 1989 1995
263 Obama Chief of Staff Denis McDonough 1/25/13 1/20/17 1456 2923
3 Carter Secretary of Health, Education & Welfare Joseph Califano Jr. 1/25/77 8/3/79 920 926
87 Bush 41 Secretary of Labor Elizabeth Dole 1/25/89 11/23/90 667 673
98 Bush 41 Secretary of State James Baker 1/25/89 8/23/92 1306 1312
107 Bush 41 OMB Director Dick Darman 1/25/89 1/20/93 1456 1462
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
240 Obama Secretary of the Treasury Tim Geithner 1/26/09 1/25/13 1460 1467
243 Obama EPA Administrator Lisa Jackson 1/26/09 2/14/13 1480 1487
248 Obama UN Ambassador Susan Rice 1/26/09 6/30/13 1616 1623
255 Obama Secretary of Housing & Urban Development Shaun Donovan 1/26/09 7/28/14 2009 2016
6 Carter Attorney General Griffin Bell 1/26/77 8/16/79 932 939
292 Trump UN Ambassador Nikki Haley 1/27/17 12/31/18 703 711
28 Carter Secretary of Labor Ray Marshall 1/27/77 1/20/81 1454 1462
138 Clinton UN Ambassador Madeleine Albright 1/27/93 1/21/97 1455 1463
212 Bush 43 Secretary of Agriculture Ed Schafer 1/28/08 1/20/09 358 2923
55 Reagan Director of Central Intelligence William Casey 1/28/81 1/29/87 2192 2201
217 Bush 43 Secretary of Labor Elaine Chao 1/29/01 1/20/09 2913 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" TEXT
)
Powered by Datasette · Query took 38.898ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub