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