cabinet-turnover/cabinet-turnover
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
379 rows sorted by president descending
This data as json, copyable, CSV (advanced)
Suggested facets: president, position, gender
Link | rowid | president ▲ | position | appointee | start_date | end_date | length | departure_day | gender | Unnamed: 8 | Unnamed: 9 |
---|---|---|---|---|---|---|---|---|---|---|---|
310 | 310 | Trump | Chief of Staff | Reince Priebus | 1/20/17 | 7/28/17 | 189 | 190 | Male | ||
311 | 311 | Trump | Secretary of Homeland Security | John Kelly | 1/20/17 | 7/28/17 | 189 | 190 | Male | ||
312 | 312 | Trump | Secretary of Health & Human Services | Tom Price | 2/10/17 | 9/29/17 | 231 | 253 | Male | ||
313 | 313 | Trump | Secretary of Veterans Affairs | David Shulkin | 2/14/17 | 3/28/18 | 407 | 433 | Male | ||
314 | 314 | Trump | Secretary of State | Rex Tillerson | 2/1/17 | 3/31/18 | 423 | 436 | Male | ||
315 | 315 | Trump | CIA Director | Mike Pompeo | 1/23/17 | 4/26/18 | 458 | 462 | Male | ||
316 | 316 | Trump | EPA Administrator | Scott Pruitt | 2/17/17 | 7/6/18 | 504 | 533 | Male | ||
317 | 317 | Trump | Attorney General | Jeff Sessions | 2/9/17 | 11/7/18 | 636 | 657 | Male | ||
318 | 318 | Trump | Secretary of Defense | Jim Mattis | 1/20/17 | 12/31/18 | 710 | 711 | Male | ||
319 | 319 | Trump | UN Ambassador | Nikki Haley | 1/25/17 | 12/31/18 | 705 | 711 | Female | ||
320 | 320 | Trump | Chief of Staff | John Kelly | 7/31/17 | 12/31/18 | 518 | 711 | Male | ||
321 | 321 | Trump | Secretary of the Interior | Ryan Zinke | 3/1/17 | 1/2/19 | 672 | 713 | Male | ||
322 | 322 | Trump | Secretary of Homeland Security | Kirstjen Nielsen | 12/6/17 | 4/7/19 | 487 | 808 | Female | ||
323 | 323 | Trump | SBA Administrator | Linda McMahon | 2/14/17 | 4/12/19 | 787 | 813 | Female | ||
324 | 324 | Trump | CEA Chair | Kevin Hassett | 9/13/17 | 6/28/19 | 653 | 890 | Male | ||
325 | 325 | Trump | Secretary of Labor | Alexander Acosta | 4/28/17 | 7/19/19 | 812 | 911 | Male | ||
326 | 326 | Trump | Director of National Intelligence | Dan Coats | 3/16/17 | 8/15/19 | 882 | 938 | Male | ||
327 | 327 | Trump | Secretary of Energy | Rick Perry | 3/2/17 | 12/1/19 | 1004 | 1046 | Male | ||
328 | 328 | Trump | OMB Director | Mick Mulvaney | 2/16/17 | 3/31/20 | 1139 | 1167 | Male | ||
329 | 329 | Trump | Secretary of Defense | Mark Esper | 7/23/19 | 11/9/20 | 475 | 1390 | Male | ||
330 | 330 | Trump | Attorney General | William Barr | 2/14/19 | 12/23/20 | 678 | 1434 | Male | ||
331 | 331 | Trump | Secretary of Education | Betsy DeVos | 2/7/17 | 1/8/21 | 1431 | 1450 | Female | ||
332 | 332 | Trump | Secretary of Transportation | Elaine Chao | 1/31/17 | 1/11/21 | 1441 | 1453 | Female | ||
333 | 333 | Trump | OSTP Director | Kelvin Droegemeier | 1/11/19 | 1/20/21 | 740 | 1462 | Male | ||
334 | 334 | Trump | Vice President | Mike Pence | 1/20/17 | 1/20/21 | 1461 | 1462 | Male | ||
335 | 335 | Trump | Secretary of the Treasury | Steve Mnuchin | 2/13/17 | 1/20/21 | 1437 | 1462 | Male | ||
336 | 336 | Trump | Secretary of Commerce | Wilbur Ross | 2/28/17 | 1/20/21 | 1422 | 1462 | Male | ||
337 | 337 | Trump | Secretary of Housing & Urban Development | Ben Carson | 3/2/17 | 1/20/21 | 1420 | 1462 | Male | ||
338 | 338 | Trump | Secretary of Agriculture | Sonny Perdue | 4/25/17 | 1/20/21 | 1366 | 1462 | Male | ||
339 | 339 | Trump | U.S. Trade Representative | Robert Lighthizer | 5/15/17 | 1/20/21 | 1346 | 1462 | Male | ||
340 | 340 | Trump | Secretary of Health & Human Services | Alex Azar | 1/29/18 | 1/20/21 | 1087 | 1462 | Male | ||
341 | 341 | Trump | Secretary of State | Mike Pompeo | 4/26/18 | 1/20/21 | 1000 | 1462 | Male | ||
342 | 342 | Trump | CIA Director | Gina Haspel | 5/21/18 | 1/20/21 | 975 | 1462 | Female | ||
343 | 343 | Trump | Secretary of Veterans Affairs | Robert Wilkie | 7/30/18 | 1/20/21 | 905 | 1462 | Male | ||
344 | 344 | Trump | EPA Administrator | Andrew Wheeler | 2/28/19 | 1/20/21 | 692 | 1462 | Male | ||
345 | 345 | Trump | Secretary of the Interior | David Bernhardt | 4/11/19 | 1/20/21 | 650 | 1462 | Male | ||
346 | 346 | Trump | UN Ambassador | Kelly Craft | 9/10/19 | 1/20/21 | 498 | 1462 | Female | ||
347 | 347 | Trump | Secretary of Labor | Eugene Scalia | 9/27/19 | 1/20/21 | 481 | 1462 | Male | ||
348 | 348 | Trump | Secretary of Energy | Dan Brouillette | 12/11/19 | 1/20/21 | 406 | 1462 | Male | ||
349 | 349 | Trump | SBA Administrator | Jovita Carranza | 1/14/20 | 1/20/21 | 372 | 1462 | Female | ||
350 | 350 | Trump | Chief of Staff | Mark Meadows | 3/31/20 | 1/20/21 | 295 | 1462 | Male | ||
351 | 351 | Trump | Director of National Intelligence | John Ratcliffe | 5/26/20 | 1/20/21 | 239 | 1462 | Male | ||
352 | 352 | Trump | OMB Director | Russ Vought | 7/22/20 | 1/20/21 | 182 | 1462 | Male | ||
36 | 36 | Reagan | SBA Administrator | Michael Cardenas | 3/30/81 | 2/3/82 | 310 | 380 | Male | ||
37 | 37 | Reagan | Secretary of State | Alexander Haig | 1/22/81 | 7/5/82 | 529 | 532 | Male | ||
38 | 38 | Reagan | CEA Chair | Murray Weidenbaum | 2/27/81 | 8/25/82 | 544 | 583 | Male | ||
39 | 39 | Reagan | Secretary of Energy | James Edwards | 1/23/81 | 11/5/82 | 651 | 655 | Male | ||
40 | 40 | Reagan | Secretary of Transportation | Drew Lewis | 1/23/81 | 2/1/83 | 739 | 743 | Male | ||
41 | 41 | Reagan | Secretary of Health & Human Services | Richard Schweiker | 1/22/81 | 2/3/83 | 742 | 745 | Male | ||
42 | 42 | Reagan | EPA Administrator | Anne Gorsuch | 5/20/81 | 3/9/83 | 658 | 779 | Female | ||
43 | 43 | Reagan | Secretary of the Interior | James Watt | 1/23/81 | 11/8/83 | 1019 | 1023 | Male | ||
44 | 44 | Reagan | CEA Chair | Martin Feldstein | 10/14/82 | 7/10/84 | 635 | 1268 | Male | ||
45 | 45 | Reagan | Secretary of Education | T.H. Bell | 1/23/81 | 12/31/84 | 1438 | 1442 | Male | ||
46 | 46 | Reagan | EPA Administrator | William Ruckelshaus | 5/18/83 | 1/4/85 | 597 | 1446 | Male | ||
47 | 47 | Reagan | Secretary of the Treasury | Don Regan | 1/22/81 | 2/2/85 | 1472 | 1475 | Male | ||
48 | 48 | Reagan | Chief of Staff | James Baker | 1/20/81 | 2/3/85 | 1475 | 1476 | Male | ||
49 | 49 | Reagan | Secretary of Energy | Donald Hodel | 11/5/82 | 2/7/85 | 825 | 1480 | Male | ||
50 | 50 | Reagan | Secretary of the Interior | William Clark | 11/18/83 | 2/7/85 | 447 | 1480 | Male | ||
51 | 51 | Reagan | Attorney General | William French Smith | 1/23/81 | 2/25/85 | 1494 | 1498 | Male | ||
52 | 52 | Reagan | Secretary of Labor | Ray Donovan | 2/4/81 | 3/15/85 | 1500 | 1516 | Male | ||
53 | 53 | Reagan | UN Ambassador | Jeane Kirkpatrick | 2/4/81 | 4/1/85 | 1517 | 1533 | Female | ||
54 | 54 | Reagan | U.S. Trade Representative | Bill Brock | 1/23/81 | 4/29/85 | 1557 | 1561 | Male | ||
55 | 55 | Reagan | OMB Director | David Stockman | 1/21/81 | 8/1/85 | 1653 | 1655 | Male | ||
56 | 56 | Reagan | Secretary of Health & Human Services | Margaret Heckler | 3/9/83 | 12/13/85 | 1010 | 1789 | Female | ||
57 | 57 | Reagan | OSTP Director | George A. Keyworth II | Aug. 1981 | 12/31/85 | Approx. 1613 | 1807 | Male | ||
58 | 58 | Reagan | Secretary of Agriculture | John Block | 1/23/81 | 2/14/86 | 1848 | 1852 | Male | ||
59 | 59 | Reagan | SBA Administrator | James Sanders | 3/29/82 | 3/31/86 | 1463 | 1897 | Male | ||
60 | 60 | Reagan | Director of Central Intelligence | William Casey | 1/28/81 | 1/29/87 | 2192 | 2201 | Male | ||
61 | 61 | Reagan | Chief of Staff | Don Regan | 2/4/85 | 2/27/87 | 753 | 2230 | Male | ||
62 | 62 | Reagan | Secretary of Commerce | Mac Baldrige | 1/20/81 | 7/25/87 | 2377 | 2378 | Male | ||
63 | 63 | Reagan | Secretary of Transportation | Elizabeth Dole | 2/7/83 | 9/30/87 | 1696 | 2445 | Female | ||
64 | 64 | Reagan | Secretary of Labor | Bill Brock | 4/29/85 | 10/31/87 | 915 | 2476 | Male | ||
65 | 65 | Reagan | Secretary of Defense | Caspar Weinberger | 1/21/81 | 11/23/87 | 2497 | 2499 | Male | ||
66 | 66 | Reagan | Chief of Staff | Howard Baker | 3/2/87 | 7/1/88 | 487 | 2720 | Male | ||
67 | 67 | Reagan | Attorney General | Ed Meese | 2/25/85 | 8/12/88 | 1264 | 2762 | Male | ||
68 | 68 | Reagan | Secretary of the Treasury | James Baker | 2/3/85 | 8/17/88 | 1291 | 2767 | Male | ||
69 | 69 | Reagan | Secretary of Education | Bill Bennett | 2/6/85 | 9/20/88 | 1322 | 2801 | Male | ||
70 | 70 | Reagan | OMB Director | Jim Miller | 10/8/85 | 10/15/88 | 1103 | 2826 | Male | ||
71 | 71 | Reagan | CEA Chair | Beryl Sprinkel | 4/18/85 | 1/20/89 | 1373 | 2923 | Male | ||
72 | 72 | Reagan | Chief of Staff | Kenneth Duberstein | 7/1/88 | 1/20/89 | 203 | 2923 | Male | ||
73 | 73 | Reagan | EPA Administrator | Lee Thomas | 2/8/85 | 1/20/89 | 1442 | 2923 | Male | ||
74 | 74 | Reagan | OMB Director | Joseph Wright Jr. | 11/8/88 | 1/20/89 | 73 | 2923 | Male | ||
75 | 75 | Reagan | Secretary of Agriculture | Richard Edmund Lyng | 3/7/86 | 1/20/89 | 1050 | 2923 | Male | ||
76 | 76 | Reagan | Secretary of Defense | Frank Carlucci | 11/23/87 | 1/20/89 | 424 | 2923 | Male | ||
77 | 77 | Reagan | Secretary of Energy | John Herrington | 2/7/85 | 1/20/89 | 1443 | 2923 | Male | ||
78 | 78 | Reagan | Secretary of Health & Human Services | Otis Bowen | 12/13/85 | 1/20/89 | 1134 | 2923 | Male | ||
79 | 79 | Reagan | Secretary of Housing & Urban Development | Samuel Pierce Jr. | 1/23/81 | 1/20/89 | 2919 | 2923 | Male | ||
80 | 80 | Reagan | Secretary of Labor | Ann McLaughlin | 12/14/87 | 1/20/89 | 403 | 2923 | Female | ||
81 | 81 | Reagan | Secretary of State | George Shultz | 7/16/82 | 1/20/89 | 2380 | 2923 | Male | ||
82 | 82 | Reagan | Secretary of the Interior | Donald Hodel | 2/8/85 | 1/20/89 | 1442 | 2923 | Male | ||
83 | 83 | Reagan | Secretary of Transportation | James Burnley IV | 12/3/87 | 1/20/89 | 414 | 2923 | Male | ||
84 | 84 | Reagan | U.S. Trade Representative | Clayton Yeutter | 7/1/85 | 1/20/89 | 1299 | 2923 | Male | ||
85 | 85 | Reagan | Vice President | George H.W. Bush | 1/20/81 | 1/20/89 | 2922 | 2923 | Male | ||
86 | 86 | Reagan | Secretary of Commerce | William Verity Jr. | 10/19/87 | 1/30/89 | 469 | 2933 | Male | ||
87 | 87 | Reagan | UN Ambassador | Vernon Walters | 5/22/85 | 3/15/89 | 1393 | 2977 | Male | ||
88 | 88 | Reagan | SBA Administrator | James Abdnor | 3/23/87 | 4/20/89 | 759 | 3013 | Male | ||
89 | 89 | Reagan | OSTP Director | William R. Graham | 10/2/86 | Bush admin | 977 combined | Male | |||
90 | 90 | Reagan | Director of Central Intelligence | Bill Webster | 5/26/87 | Bush admin | 1558 combined | Male | |||
91 | 91 | Reagan | Attorney General | Dick Thornburgh | 8/12/88 | Bush admin | 1098 combined | Male | |||
92 | 92 | Reagan | Secretary of Education | Lauro Cavazos | 9/20/88 | Bush admin | 816 combined | Male |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "cabinet-turnover/cabinet-turnover" ( "president" TEXT, "position" TEXT, "appointee" TEXT, "start_date" TEXT, "end_date" TEXT, "length" TEXT, "departure_day" INTEGER, "gender" TEXT, "Unnamed: 8" INTEGER, "Unnamed: 9" INTEGER );