cabinet-turnover/cabinet-turnover

Table actions

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

379 rows

✎ View and edit SQL

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
1 1 Carter OMB Director Bert Lance 1/21/77 9/23/77 245 247 Male    
2 2 Carter Secretary of Transportation Brock Adams 1/23/77 7/20/79 908 912 Male    
3 3 Carter Secretary of Health, Education & Welfare Joseph Califano Jr. 1/25/77 8/3/79 920 926 Male    
4 4 Carter Secretary of Housing & Urban Development Patricia Harris 1/23/77 8/3/79 922 926 Female    
5 5 Carter Secretary of the Treasury W. Michael Blumenthal 1/23/77 8/4/79 923 927 Male    
6 6 Carter Attorney General Griffin Bell 1/26/77 8/16/79 932 939 Male    
7 7 Carter U.S. Trade Representative Robert Strauss 3/30/77 8/17/79 870 940 Male    
8 8 Carter Secretary of Energy James Schlesinger 8/6/77 8/23/79 747 946 Male    
9 9 Carter UN Ambassador Andrew Young 1/30/77 9/23/79 966 977 Male    
10 10 Carter Secretary of Commerce Juanita Kreps 1/23/77 10/31/79 1011 1015 Female    
11 11 Carter Secretary of State Cyrus Vance 1/23/77 4/28/80 1191 1195 Male    
12 12 Carter Chief of Staff Hamilton Jordan 7/18/79 6/11/80 329 1239 Male    
13 13 Carter U.S. Trade Representative Reubin Askew 10/1/79 12/31/80 457 1442 Male    
14 14 Carter Secretary of State Ed Muskie 5/8/80 1/18/81 255 1460 Male    
15 15 Carter Attorney General Ben Civiletti 8/16/79 1/19/81 522 1461 Male    
16 16 Carter Secretary of Commerce Philip Klutznick 1/9/80 1/19/81 376 1461 Male    
17 17 Carter CEA Chair Charles Schultze 1/22/77 1/20/81 1459 1462 Male    
18 18 Carter Chief of Staff Jack Watson 6/11/80 1/20/81 223 1462 Male    
19 19 Carter Director of Central Intelligence Stansfield Turner 3/9/77 1/20/81 1413 1462 Male    
20 20 Carter EPA Administrator Douglas Costle 3/7/77 1/20/81 1415 1462 Male    
21 21 Carter OMB Director Jim McIntyre 9/24/77 1/20/81 1214 1462 Male    
22 22 Carter SBA Administrator A. Vernon Weaver 4/1/77 1/20/81 1390 1462 Male    
23 23 Carter Secretary of Agriculture Robert Bergland 1/23/77 1/20/81 1458 1462 Male    
24 24 Carter Secretary of Defense Harold Brown 1/21/77 1/20/81 1460 1462 Male    
25 25 Carter Secretary of Education Shirley Hufstedler 12/6/79 1/20/81 411 1462 Female    
26 26 Carter Secretary of Energy Charles Duncan 8/24/79 1/20/81 515 1462 Male    
27 27 Carter Secretary of Health, Education & Welfare/Secretary of Health & Human Services Patricia Harris 8/3/79 1/20/81 536 1462 Female    
28 28 Carter Secretary of Housing & Urban Development Moon Landrieu 9/24/79 1/20/81 484 1462 Male    
29 29 Carter Secretary of Labor Ray Marshall 1/27/77 1/20/81 1454 1462 Male    
30 30 Carter Secretary of the Interior Cecil Andrus 1/23/77 1/20/81 1458 1462 Male    
31 31 Carter Secretary of the Treasury G. William Miller 8/6/79 1/20/81 533 1462 Male    
32 32 Carter Secretary of Transportation Neil Goldschmidt 8/15/79 1/20/81 524 1462 Male    
33 33 Carter UN Ambassador Donald McHenry 9/23/79 1/20/81 485 1462 Male    
34 34 Carter Vice President Walter Mondale 1/20/77 1/20/81 1461 1462 Male    
35 35 Carter OSTP Director Frank Press 6/1/77 1/20/81 1329 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    
93 93 Reagan Secretary of the Treasury Nicholas Brady 9/16/88 Bush admin 1584 combined   Male    
94 94 Bush 41 OSTP Director William R. Graham Reagan admin 6/5/89 977 combined 137 Male    
95 95 Bush 41 Secretary of Labor Elizabeth Dole 1/25/89 11/23/90 667 673 Female    
96 96 Bush 41 Secretary of Education Lauro Cavazos Reagan admin 12/15/90 816 combined 695 Male    
97 97 Bush 41 Secretary of Agriculture Clayton Yeutter 2/16/89 3/1/91 743 771 Male    
98 98 Bush 41 SBA Administrator Susan Engeleiter 4/20/89 3/27/91 706 797 Female    
99 99 Bush 41 Attorney General Dick Thornburgh Reagan admin 8/15/91 1098 combined 938 Male    
100 100 Bush 41 Director of Central Intelligence Bill Webster Reagan admin 8/31/91 1558 combined 954 Male    

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_date" TEXT,
  "end_date" TEXT,
  "length" TEXT,
  "departure_day" INTEGER,
  "gender" TEXT,
  "Unnamed: 8" INTEGER,
  "Unnamed: 9" INTEGER
);