home / fivethirtyeight

cabinet-turnover/cabinet-turnover

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

312 rows

View and edit SQL

Suggested facets: president, position

Link rowid president position appointee start end length days
1 Carter OMB Director Bert Lance 1/21/77 9/23/77 245 247
2 Carter Secretary of Transportation Brock Adams 1/23/77 7/20/79 908 912
3 Carter Secretary of Health, Education & Welfare Joseph Califano Jr. 1/25/77 8/3/79 920 926
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
6 Carter Attorney General Griffin Bell 1/26/77 8/16/79 932 939
7 Carter U.S. Trade Representative Robert Strauss 3/30/77 8/17/79 870 940
8 Carter Secretary of Energy James Schlesinger 8/6/77 8/23/79 747 946
9 Carter UN Ambassador Andrew Young 1/30/77 9/23/79 966 977
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
12 Carter Chief of Staff Hamilton Jordan 7/18/79 6/11/80 329 1239
13 Carter U.S. Trade Representative Reubin Askew 10/1/79 12/31/80 457 1442
14 Carter Secretary of State Ed Muskie 5/8/80 1/18/81 255 1460
15 Carter Attorney General Ben Civiletti 8/16/79 1/19/81 522 1461
16 Carter Secretary of Commerce Philip Klutznick 1/9/80 1/19/81 376 1461
17 Carter Chief of Staff Jack Watson 6/11/80 1/20/81 223 1462
18 Carter Director of Central Intelligence Stansfield Turner 3/9/77 1/20/81 1413 1462
19 Carter EPA Administrator Douglas Costle 3/7/77 1/20/81 1415 1462
20 Carter OMB Director Jim McIntyre 9/24/77 1/20/81 1214 1462
21 Carter SBA Administrator A. Vernon Weaver 4/1/77 1/20/81 1390 1462
22 Carter Secretary of Agriculture Robert Bergland 1/23/77 1/20/81 1458 1462
23 Carter Secretary of Defense Harold Brown 1/21/77 1/20/81 1460 1462
24 Carter Secretary of Education Shirley Hufstedler 12/6/79 1/20/81 411 1462
25 Carter Secretary of Energy Charles Duncan 8/24/79 1/20/81 515 1462
26 Carter Secretary of Health, Education & Welfare/Secretary of Health & Human Services Patricia Harris 8/3/79 1/20/81 536 1462
27 Carter Secretary of Housing & Urban Development Moon Landrieu 9/24/79 1/20/81 484 1462
28 Carter Secretary of Labor Ray Marshall 1/27/77 1/20/81 1454 1462
29 Carter Secretary of the Interior Cecil Andrus 1/23/77 1/20/81 1458 1462
30 Carter Secretary of the Treasury G. William Miller 8/6/79 1/20/81 533 1462
31 Carter Secretary of Transportation Neil Goldschmidt 8/15/79 1/20/81 524 1462
32 Carter UN Ambassador Donald McHenry 9/23/79 1/20/81 485 1462
33 Carter Vice President Walter Mondale 1/20/77 1/20/81 1461 1462
34 Reagan SBA Administrator Michael Cardenas 3/30/81 2/3/82 310 380
35 Reagan Secretary of State Alexander Haig 1/22/81 7/5/82 529 532
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
38 Reagan Secretary of Health & Human Services Richard Schweiker 1/22/81 2/3/83 742 745
39 Reagan EPA Administrator Anne Gorsuch 5/20/81 3/9/83 658 779
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
42 Reagan EPA Administrator William Ruckelshaus 5/18/83 1/4/85 597 1446
43 Reagan Secretary of the Treasury Don Regan 1/22/81 2/2/85 1472 1475
44 Reagan Chief of Staff James Baker 1/20/81 2/3/85 1475 1476
45 Reagan Secretary of Energy Donald Hodel 11/5/82 2/7/85 825 1480
46 Reagan Secretary of the Interior William Clark 11/18/83 2/7/85 447 1480
47 Reagan Attorney General William French Smith 1/23/81 2/25/85 1494 1498
48 Reagan Secretary of Labor Ray Donovan 2/4/81 3/15/85 1500 1516
49 Reagan UN Ambassador Jeane Kirkpatrick 2/4/81 4/1/85 1517 1533
50 Reagan U.S. Trade Representative Bill Brock 1/23/81 4/29/85 1557 1561
51 Reagan OMB Director David Stockman 1/21/81 8/1/85 1653 1655
52 Reagan Secretary of Health & Human Services Margaret Heckler 3/9/83 12/13/85 1010 1789
53 Reagan Secretary of Agriculture John Block 1/23/81 2/14/86 1848 1852
54 Reagan SBA Administrator James Sanders 3/29/82 3/31/86 1463 1897
55 Reagan Director of Central Intelligence William Casey 1/28/81 1/29/87 2192 2201
56 Reagan Chief of Staff Don Regan 2/4/85 2/27/87 753 2230
57 Reagan Secretary of Commerce Mac Baldrige 1/20/81 7/25/87 2377 2378
58 Reagan Secretary of Transportation Elizabeth Dole 2/7/83 9/30/87 1696 2445
59 Reagan Secretary of Labor Bill Brock 4/29/85 10/31/87 915 2476
60 Reagan Secretary of Defense Caspar Weinberger 1/21/81 11/23/87 2497 2499
61 Reagan Chief of Staff Howard Baker 3/2/87 7/1/88 487 2720
62 Reagan Attorney General Ed Meese 2/25/85 8/12/88 1264 2762
63 Reagan Secretary of the Treasury James Baker 2/3/85 8/17/88 1291 2767
64 Reagan Secretary of Education Bill Bennett 2/6/85 9/20/88 1322 2801
65 Reagan OMB Director Jim Miller 10/8/85 10/15/88 1103 2826
66 Reagan Chief of Staff Kenneth Duberstein 7/1/88 1/20/89 203 2923
67 Reagan EPA Administrator Lee Thomas 2/8/85 1/20/89 1442 2923
68 Reagan OMB Director Joseph Wright Jr. 11/8/88 1/20/89 73 2923
69 Reagan Secretary of Agriculture Richard Edmund Lyng 3/7/86 1/20/89 1050 2923
70 Reagan Secretary of Defense Frank Carlucci 11/23/87 1/20/89 424 2923
71 Reagan Secretary of Energy John Herrington 2/7/85 1/20/89 1443 2923
72 Reagan Secretary of Health & Human Services Otis Bowen 12/13/85 1/20/89 1134 2923
73 Reagan Secretary of Housing & Urban Development Samuel Pierce Jr. 1/23/81 1/20/89 2919 2923
74 Reagan Secretary of Labor Ann McLaughlin 12/14/87 1/20/89 403 2923
75 Reagan Secretary of State George Shultz 7/16/82 1/20/89 2380 2923
76 Reagan Secretary of the Interior Donald Hodel 2/8/85 1/20/89 1442 2923
77 Reagan Secretary of Transportation James Burnley IV 12/3/87 1/20/89 414 2923
78 Reagan U.S. Trade Representative Clayton Yeutter 7/1/85 1/20/89 1299 2923
79 Reagan Vice President George H.W. Bush 1/20/81 1/20/89 2922 2923
80 Reagan Secretary of Commerce William Verity Jr. 10/19/87 1/30/89 469 2933
81 Reagan UN Ambassador Vernon Walters 5/22/85 3/15/89 1393 2977
82 Reagan SBA Administrator James Abdnor 3/23/87 4/20/89 759 3013
83 Reagan Attorney General Dick Thornburgh 8/12/88 Bush admin 1098 combined #VALUE!
84 Reagan Director of Central Intelligence Bill Webster 5/26/87 Bush admin 1558 combined #VALUE!
85 Reagan Secretary of Education Lauro Cavazos 9/20/88 Bush admin 816 combined #VALUE!
86 Reagan Secretary of the Treasury Nicholas Brady 9/16/88 Bush admin 1584 combined #VALUE!
87 Bush 41 Secretary of Labor Elizabeth Dole 1/25/89 11/23/90 667 673
88 Bush 41 Secretary of Education Lauro Cavazos Reagan admin 12/15/90 816 combined 695
89 Bush 41 Secretary of Agriculture Clayton Yeutter 2/16/89 3/1/91 743 771
90 Bush 41 SBA Administrator Susan Engeleiter 4/20/89 3/27/91 706 797
91 Bush 41 Attorney General Dick Thornburgh Reagan admin 8/15/91 1098 combined 938
92 Bush 41 Director of Central Intelligence Bill Webster Reagan admin 8/31/91 1558 combined 954
93 Bush 41 Secretary of Transportation Sam Skinner 2/6/89 12/13/91 1040 1058
94 Bush 41 Chief of Staff John Sununu 1/20/89 12/15/91 1059 1060
95 Bush 41 Secretary of Commerce Robert Mosbacher 1/31/89 1/15/92 1079 1091
96 Bush 41 UN Ambassador Tom Pickering 3/20/89 5/7/92 1144 1204
97 Bush 41 Chief of Staff Sam Skinner 12/16/91 8/23/92 251 1312
98 Bush 41 Secretary of State James Baker 1/25/89 8/23/92 1306 1312
99 Bush 41 Secretary of Veterans Affairs Ed Derwinski 3/15/89 9/26/92 1291 1346
100 Bush 41 Attorney General William Barr 11/26/91 1/15/93 416 1457

Next page

Advanced export

JSON shape: default, array

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 68.767ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub