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