home / fivethirtyeight

cabinet-turnover/cabinet-turnover

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

312 rows sorted by position

View and edit SQL

Suggested facets: president, position

Link rowid president position ▼ appointee start end length days
6 Carter Attorney General Griffin Bell 1/26/77 8/16/79 932 939
15 Carter Attorney General Ben Civiletti 8/16/79 1/19/81 522 1461
47 Reagan Attorney General William French Smith 1/23/81 2/25/85 1494 1498
62 Reagan Attorney General Ed Meese 2/25/85 8/12/88 1264 2762
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
100 Bush 41 Attorney General William Barr 11/26/91 1/15/93 416 1457
157 Clinton Attorney General Janet Reno 3/12/93 1/20/01 2871 2923
186 Bush 43 Attorney General John Ashcroft 2/2/01 2/3/05 1462 1476
201 Bush 43 Attorney General Alberto Gonzales 2/3/05 9/17/07 956 2432
209 Bush 43 Attorney General Michael Mukasey 11/9/07 1/20/09 438 2923
257 Obama Attorney General Eric Holder 2/3/09 4/24/15 2271 2286
280 Obama Attorney General Loretta Lynch 4/27/15 1/20/17 634 2923
290 Trump Attorney General Jeff Sessions 2/9/17 11/7/18 636 657
227 Bush 43 CIA Director Michael Hayden 5/30/06 2/12/09 989 2946
232 Obama CIA Director Leon Panetta 2/13/09 6/30/11 867 892
238 Obama CIA Director David Petraeus 9/6/11 11/9/12 430 1390
266 Obama CIA Director John Brennan 3/8/13 1/20/17 1414 2923
288 Trump CIA Director Mike Pompeo 1/23/17 4/26/18 458 462
311 Trump CIA Director Gina Haspel 5/21/18 Still in office #VALUE! #VALUE!
12 Carter Chief of Staff Hamilton Jordan 7/18/79 6/11/80 329 1239
17 Carter Chief of Staff Jack Watson 6/11/80 1/20/81 223 1462
44 Reagan Chief of Staff James Baker 1/20/81 2/3/85 1475 1476
56 Reagan Chief of Staff Don Regan 2/4/85 2/27/87 753 2230
61 Reagan Chief of Staff Howard Baker 3/2/87 7/1/88 487 2720
66 Reagan Chief of Staff Kenneth Duberstein 7/1/88 1/20/89 203 2923
94 Bush 41 Chief of Staff John Sununu 1/20/89 12/15/91 1059 1060
97 Bush 41 Chief of Staff Sam Skinner 12/16/91 8/23/92 251 1312
104 Bush 41 Chief of Staff James Baker 8/23/92 1/20/93 150 1462
122 Clinton Chief of Staff Mack McLarty 1/20/93 7/17/94 543 544
135 Clinton Chief of Staff Leon Panetta 7/17/94 1/20/97 918 1462
146 Clinton Chief of Staff Erskine Bowles 1/20/97 10/20/98 638 2100
158 Clinton Chief of Staff John Podesta 10/20/98 1/20/01 823 2923
190 Bush 43 Chief of Staff Andy Card 1/20/01 4/14/06 1910 1911
210 Bush 43 Chief of Staff Josh Bolten 4/14/06 1/20/09 1012 2923
231 Obama Chief of Staff Rahm Emanuel 1/20/09 10/1/10 619 620
236 Obama Chief of Staff Bill Daley 1/13/11 1/27/12 379 1103
241 Obama Chief of Staff Jack Lew 1/30/12 1/25/13 361 1467
263 Obama Chief of Staff Denis McDonough 1/25/13 1/20/17 1456 2923
283 Trump Chief of Staff Reince Priebus 1/20/17 7/28/17 189 190
293 Trump Chief of Staff John Kelly 7/31/17 12/31/18 518 711
18 Carter Director of Central Intelligence Stansfield Turner 3/9/77 1/20/81 1413 1462
55 Reagan Director of Central Intelligence William Casey 1/28/81 1/29/87 2192 2201
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
127 Clinton Director of Central Intelligence Jim Woolsey 2/5/93 1/10/95 704 721
131 Clinton Director of Central Intelligence John Deutch 5/10/95 12/15/96 585 1426
170 Clinton Director of Central Intelligence George Tenet 7/11/97 Bush admin 2557 combined #VALUE!
176 Bush 43 Director of Central Intelligence George Tenet Clinton admin 7/11/04 2557 combined 1269
192 Bush 43 Director of Central Intelligence/CIA Director Porter Goss 9/24/04 5/5/06 588 1932
199 Bush 43 Director of National Intelligence John Negroponte 4/21/05 2/13/07 663 2216
226 Bush 43 Director of National Intelligence Mike McConnell 2/13/07 1/27/09 714 2930
229 Obama Director of National Intelligence Dennis Blair 1/29/09 5/28/10 484 494
262 Obama Director of National Intelligence James Clapper 8/9/10 1/20/17 2356 2923
304 Trump Director of National Intelligence Dan Coats 3/16/17 Still in office #VALUE! #VALUE!
19 Carter EPA Administrator Douglas Costle 3/7/77 1/20/81 1415 1462
39 Reagan EPA Administrator Anne Gorsuch 5/20/81 3/9/83 658 779
42 Reagan EPA Administrator William Ruckelshaus 5/18/83 1/4/85 597 1446
67 Reagan EPA Administrator Lee Thomas 2/8/85 1/20/89 1442 2923
106 Bush 41 EPA Administrator William Reilly 2/6/89 1/20/93 1444 1462
151 Clinton EPA Administrator Carol Browner 1/22/93 1/19/01 2919 2922
173 Bush 43 EPA Administrator Christine Todd Whitman 1/31/01 6/27/03 877 889
180 Bush 43 EPA Administrator Mike Leavitt 11/6/03 1/25/05 446 1467
211 Bush 43 EPA Administrator Stephen Johnson 5/2/05 1/20/09 1359 2923
243 Obama EPA Administrator Lisa Jackson 1/26/09 2/14/13 1480 1487
272 Obama EPA Administrator Gina McCarthy 7/19/13 1/20/17 1281 2923
289 Trump EPA Administrator Scott Pruitt 2/17/17 7/6/18 504 533
1 Carter OMB Director Bert Lance 1/21/77 9/23/77 245 247
20 Carter OMB Director Jim McIntyre 9/24/77 1/20/81 1214 1462
51 Reagan OMB Director David Stockman 1/21/81 8/1/85 1653 1655
65 Reagan OMB Director Jim Miller 10/8/85 10/15/88 1103 2826
68 Reagan OMB Director Joseph Wright Jr. 11/8/88 1/20/89 73 2923
107 Bush 41 OMB Director Dick Darman 1/25/89 1/20/93 1456 1462
123 Clinton OMB Director Leon Panetta 1/21/93 7/17/94 542 544
130 Clinton OMB Director Alice Rivlin 10/17/94 4/26/96 557 1193
143 Clinton OMB Director Frank Raines 9/13/96 5/21/98 615 1948
152 Clinton OMB Director Jack Lew 5/21/98 1/19/01 974 2922
172 Bush 43 OMB Director Mitch Daniels 1/23/01 6/6/03 864 868
191 Bush 43 OMB Director Josh Bolten 6/26/03 4/14/06 1023 1911
200 Bush 43 OMB Director Rob Portman 5/26/06 8/3/07 434 2387
206 Bush 43 OMB Director Jim Nussle 9/4/07 1/19/09 503 2922
230 Obama OMB Director Peter Orszag 1/20/09 7/30/10 556 557
235 Obama OMB Director Jack Lew 11/18/10 1/26/12 434 1102
254 Obama OMB Director Sylvia Burwell 4/26/13 6/8/14 408 1966
277 Obama OMB Director Shaun Donovan 7/28/14 1/20/17 907 2923
300 Trump OMB Director Mick Mulvaney 2/16/17 Still in office #VALUE! #VALUE!
21 Carter SBA Administrator A. Vernon Weaver 4/1/77 1/20/81 1390 1462
34 Reagan SBA Administrator Michael Cardenas 3/30/81 2/3/82 310 380
54 Reagan SBA Administrator James Sanders 3/29/82 3/31/86 1463 1897
82 Reagan SBA Administrator James Abdnor 3/23/87 4/20/89 759 3013
90 Bush 41 SBA Administrator Susan Engeleiter 4/20/89 3/27/91 706 797
108 Bush 41 SBA Administrator Pat Saiki 3/27/91 1/20/93 665 1462
124 Clinton SBA Administrator Erskine Bowles 5/12/93 10/6/94 512 625
140 Clinton SBA Administrator Philip Lader 10/8/94 2/11/97 857 1484
159 Clinton SBA Administrator Aida Alvarez 3/7/97 1/20/01 1415 2923
195 Bush 43 SBA Administrator Hector Barreto 7/25/01 7/2/06 1803 1990
205 Bush 43 SBA Administrator Steve Preston 7/10/06 6/5/08 696 2694
250 Obama SBA Administrator Karen Mills 4/6/09 9/1/13 1609 1686
275 Obama SBA Administrator Maria Contreras-Sweet 4/7/14 1/20/17 1019 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 34.518ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub