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 sorted by appointee

✎ 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
22 22 Carter SBA Administrator A. Vernon Weaver 4/1/77 1/20/81 1390 1462 Male    
174 174 Clinton SBA Administrator Aida Alvarez 3/7/97 1/20/01 1415 2923 Female    
184 184 Clinton Vice President Al Gore 1/20/93 1/20/01 2922 2923 Male    
274 274 Obama CEA Chair Alan Krueger 11/7/11 8/2/13 634 1656 Male    
221 221 Bush 43 Attorney General Alberto Gonzales 2/3/05 9/17/07 956 2432 Male    
370 370 Biden Secretary of Homeland Security Alejandro Mayorkas 2/2/21 Still in office     Male    
340 340 Trump Secretary of Health & Human Services Alex Azar 1/29/18 1/20/21 1087 1462 Male    
325 325 Trump Secretary of Labor Alexander Acosta 4/28/17 7/19/19 812 911 Male    
37 37 Reagan Secretary of State Alexander Haig 1/22/81 7/5/82 529 532 Male    
180 180 Clinton Secretary of Labor Alexis Herman 5/1/97 1/20/01 1360 2923 Female    
141 141 Clinton OMB Director Alice Rivlin 10/17/94 4/26/96 557 1193 Female    
224 224 Bush 43 Secretary of Housing & Urban Development Alphonso Jackson 3/31/04 4/18/08 1479 2646 Male    
179 179 Clinton Secretary of Housing & Urban Development Andrew Cuomo 1/29/97 1/20/01 1452 2923 Male    
344 344 Trump EPA Administrator Andrew Wheeler 2/28/19 1/20/21 692 1462 Male    
9 9 Carter UN Ambassador Andrew Young 1/30/77 9/23/79 966 977 Male    
126 126 Bush 41 Secretary of Transportation Andy Card 3/11/92 1/20/93 315 1462 Male    
210 210 Bush 43 Chief of Staff Andy Card 1/20/01 4/14/06 1910 1911 Male    
80 80 Reagan Secretary of Labor Ann McLaughlin 12/14/87 1/20/89 403 2923 Female    
194 194 Bush 43 Secretary of Agriculture Ann Veneman 1/20/01 1/20/05 1461 1462 Female    
42 42 Reagan EPA Administrator Anne Gorsuch 5/20/81 3/9/83 658 779 Female    
298 298 Obama Secretary of Transportation Anthony Foxx 7/2/13 1/20/17 1298 2923 Male    
200 200 Bush 43 Secretary of Veterans Affairs Anthony Principi 1/23/01 1/26/05 1464 1468 Male    
356 356 Biden Secretary of State Antony Blinken 1/26/21 Still in office     Male    
378 378 Biden OSTP Director Arati Prabhakar 10/1/22 Still in office     Female    
283 283 Obama Secretary of Education Arne Duncan 1/20/09 12/31/15 2536 2537 Male    
286 286 Obama Secretary of Defense Ash Carter 2/17/15 1/19/17 702 2922 Male    
258 258 Obama CEA Chair Austan Goolsbee 9/10/10 8/5/11 329 928 Male    
373 373 Biden Director of National Intelligence Avril Haines 1/21/21 Still in office     Female    
119 119 Bush 41 Secretary of Commerce Barbara Franklin 2/27/92 1/20/93 328 1462 Female    
208 208 Bush 43 CEA Chair Ben Bernanke 6/21/05 1/31/06 224 1838 Male    
337 337 Trump Secretary of Housing & Urban Development Ben Carson 3/2/17 1/20/21 1420 1462 Male    
15 15 Carter Attorney General Ben Civiletti 8/16/79 1/19/81 522 1461 Male    
1 1 Carter OMB Director Bert Lance 1/21/77 9/23/77 245 247 Male    
71 71 Reagan CEA Chair Beryl Sprinkel 4/18/85 1/20/89 1373 2923 Male    
331 331 Trump Secretary of Education Betsy DeVos 2/7/17 1/8/21 1431 1450 Female    
69 69 Reagan Secretary of Education Bill Bennett 2/6/85 9/20/88 1322 2801 Male    
54 54 Reagan U.S. Trade Representative Bill Brock 1/23/81 4/29/85 1557 1561 Male    
64 64 Reagan Secretary of Labor Bill Brock 4/29/85 10/31/87 915 2476 Male    
162 162 Clinton Secretary of Commerce Bill Daley 1/30/97 7/19/00 1266 2738 Male    
260 260 Obama Chief of Staff Bill Daley 1/13/11 1/27/12 379 1103 Male    
158 158 Clinton UN Ambassador Bill Richardson 2/18/97 8/18/98 546 2037 Male    
177 177 Clinton Secretary of Energy Bill Richardson 8/18/98 1/20/01 886 2923 Male    
90 90 Reagan Director of Central Intelligence Bill Webster 5/26/87 Bush admin 1558 combined   Male    
100 100 Bush 41 Director of Central Intelligence Bill Webster Reagan admin 8/31/91 1558 combined 954 Male    
114 114 Bush 41 Director of Central Intelligence Bob Gates 11/6/91 1/20/93 441 1462 Male    
250 250 Bush 43 Secretary of Defense Bob Gates 12/18/06 Obama admin 1655 combined   Male    
256 256 Obama Secretary of Defense Bob Gates Bush admin 6/30/11 1655 combined 892 Male    
306 306 Obama Secretary of Veterans Affairs Bob McDonald 7/30/14 1/20/17 905 2923 Male    
160 160 Clinton Secretary of the Treasury Bob Rubin 1/10/95 7/2/99 1634 2355 Male    
2 2 Carter Secretary of Transportation Brock Adams 1/23/77 7/20/79 908 912 Male    
164 164 Clinton Secretary of the Interior Bruce Babbitt 1/22/93 1/2/01 2902 2905 Male    
127 127 Bush 41 U.S. Trade Representative Carla Hills 2/6/89 1/20/93 1444 1462 Female    
227 227 Bush 43 Secretary of Commerce Carlos Gutierrez 2/7/05 1/19/09 1442 2922 Male    
166 166 Clinton EPA Administrator Carol Browner 1/22/93 1/19/01 2919 2922 Female    
65 65 Reagan Secretary of Defense Caspar Weinberger 1/21/81 11/23/87 2497 2499 Male    
30 30 Carter Secretary of the Interior Cecil Andrus 1/23/77 1/20/81 1458 1462 Male    
376 376 Biden CEA Chair Cecilia Rouse 3/12/21 Still in office     Female    
183 183 Clinton U.S. Trade Representative Charlene Barshefsky 3/18/97 1/20/01 1404 2923 Female    
26 26 Carter Secretary of Energy Charles Duncan 8/24/79 1/20/81 515 1462 Male    
17 17 Carter CEA Chair Charles Schultze 1/22/77 1/20/81 1459 1462 Male    
253 253 Obama CEA Chair Christina Romer 1/29/09 9/3/10 582 592 Female    
190 190 Bush 43 EPA Administrator Christine Todd Whitman 1/31/01 6/27/03 877 889 Female    
281 281 Obama Secretary of Defense Chuck Hagel 2/27/13 2/17/15 720 2220 Male    
84 84 Reagan U.S. Trade Representative Clayton Yeutter 7/1/85 1/20/89 1299 2923 Male    
97 97 Bush 41 Secretary of Agriculture Clayton Yeutter 2/16/89 3/1/91 743 771 Male    
198 198 Bush 43 Secretary of State Colin Powell 1/20/01 1/25/05 1466 1467 Male    
239 239 Bush 43 Secretary of State Condoleezza Rice 1/26/05 1/20/09 1455 2923 Female    
11 11 Carter Secretary of State Cyrus Vance 1/23/77 4/28/80 1191 1195 Male    
129 129 Bush 41 OSTP Director D. Allan Bromley 10/13/89 1/20/93 1195 1462 Male    
348 348 Trump Secretary of Energy Dan Brouillette 12/11/19 1/20/21 406 1462 Male    
326 326 Trump Director of National Intelligence Dan Coats 3/16/17 8/15/19 882 938 Male    
168 168 Clinton Secretary of Agriculture Dan Glickman 3/30/95 1/19/01 2122 2922 Male    
128 128 Bush 41 Vice President Dan Quayle 1/20/89 1/20/93 1461 1462 Male    
345 345 Trump Secretary of the Interior David Bernhardt 4/11/19 1/20/21 650 1462 Male    
262 262 Obama CIA Director David Petraeus 9/6/11 11/9/12 430 1390 Male    
313 313 Trump Secretary of Veterans Affairs David Shulkin 2/14/17 3/28/18 407 433 Male    
55 55 Reagan OMB Director David Stockman 1/21/81 8/1/85 1653 1655 Male    
360 360 Biden Secretary of the Interior Deb Haaland 3/16/21 Still in office     Female    
290 290 Obama Chief of Staff Denis McDonough 1/25/13 1/20/17 1456 2923 Male    
369 369 Biden Secretary of Veterans Affairs Denis McDonough 2/9/21 Still in office     Male    
251 251 Obama Director of National Intelligence Dennis Blair 1/29/09 5/28/10 484 494 Male    
120 120 Bush 41 Secretary of Defense Dick Cheney 3/21/89 1/20/93 1401 1462 Male    
244 244 Bush 43 Vice President Dick Cheney 1/20/01 1/20/09 2922 2923 Male    
116 116 Bush 41 OMB Director Dick Darman 1/25/89 1/20/93 1456 1462 Male    
176 176 Clinton Secretary of Education Dick Riley 1/21/93 1/20/01 2921 2923 Male    
91 91 Reagan Attorney General Dick Thornburgh 8/12/88 Bush admin 1098 combined   Male    
99 99 Bush 41 Attorney General Dick Thornburgh Reagan admin 8/15/91 1098 combined 938 Male    
228 228 Bush 43 Secretary of the Interior Dirk Kempthorne 5/29/06 1/19/09 966 2922 Male    
47 47 Reagan Secretary of the Treasury Don Regan 1/22/81 2/2/85 1472 1475 Male    
61 61 Reagan Chief of Staff Don Regan 2/4/85 2/27/87 753 2230 Male    
204 204 Bush 43 Secretary of Commerce Donald Evans 1/20/01 2/3/05 1475 1476 Male    
49 49 Reagan Secretary of Energy Donald Hodel 11/5/82 2/7/85 825 1480 Male    
82 82 Reagan Secretary of the Interior Donald Hodel 2/8/85 1/20/89 1442 2923 Male    
33 33 Carter UN Ambassador Donald McHenry 9/23/79 1/20/81 485 1462 Male    
217 217 Bush 43 Secretary of Defense Donald Rumsfeld 1/20/01 12/18/06 2158 2159 Male    
178 178 Clinton Secretary of Health & Human Services Donna Shalala 1/22/93 1/20/01 2920 2923 Female    
20 20 Carter EPA Administrator Douglas Costle 3/7/77 1/20/81 1415 1462 Male    
40 40 Reagan Secretary of Transportation Drew Lewis 1/23/81 2/1/83 739 743 Male    
107 107 Bush 41 Secretary of Veterans Affairs Ed Derwinski 3/15/89 9/26/92 1291 1346 Male    
118 118 Bush 41 Secretary of Agriculture Ed Madigan 3/12/91 1/20/93 680 1462 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
);