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 departure_day
This data as json, copyable, CSV (advanced)
Suggested facets: position, gender
Link | rowid | president | position | appointee | start_date | end_date | length | departure_day ▼ | gender | Unnamed: 8 | Unnamed: 9 |
---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
186 | 186 | Clinton | Director of Central Intelligence | George Tenet | 7/11/97 | Bush admin | 2557 combined | Male | |||
250 | 250 | Bush 43 | Secretary of Defense | Bob Gates | 12/18/06 | Obama admin | 1655 combined | Male | |||
355 | 355 | Biden | Vice President | Kamala Harris | 1/20/21 | Still in office | Female | ||||
356 | 356 | Biden | Secretary of State | Antony Blinken | 1/26/21 | Still in office | Male | ||||
357 | 357 | Biden | Secretary of the Treasury | Janet Yellen | 1/26/21 | Still in office | Female | ||||
358 | 358 | Biden | Secretary of Defense | Lloyd Austin | 1/22/21 | Still in office | Male | ||||
359 | 359 | Biden | Attorney General | Merrick Garland | 3/11/21 | Still in office | Male | ||||
360 | 360 | Biden | Secretary of the Interior | Deb Haaland | 3/16/21 | Still in office | Female | ||||
361 | 361 | Biden | Secretary of Agriculture | Tom Vilsack | 2/24/21 | Still in office | Male | ||||
362 | 362 | Biden | Secretary of Commerce | Gina Raimondo | 3/3/21 | Still in office | Female | ||||
363 | 363 | Biden | Secretary of Labor | Marty Walsh | 3/23/21 | Still in office | Male | ||||
364 | 364 | Biden | Secretary of Health & Human Services | Xavier Becerra | 3/19/21 | Still in office | Male | ||||
365 | 365 | Biden | Secretary of Housing & Urban Development | Marcia Fudge | 3/10/21 | Still in office | Female | ||||
366 | 366 | Biden | Secretary of Transportation | Pete Buttigieg | 2/3/21 | Still in office | Male | ||||
367 | 367 | Biden | Secretary of Energy | Jennifer Granholm | 2/25/21 | Still in office | Female | ||||
368 | 368 | Biden | Secretary of Education | Miguel Cardona | 3/2/21 | Still in office | Male | ||||
369 | 369 | Biden | Secretary of Veterans Affairs | Denis McDonough | 2/9/21 | Still in office | Male | ||||
370 | 370 | Biden | Secretary of Homeland Security | Alejandro Mayorkas | 2/2/21 | Still in office | Male | ||||
371 | 371 | Biden | EPA Administrator | Michael Regan | 3/11/21 | Still in office | Male | ||||
372 | 372 | Biden | OMB Director | Shalanda Young | 3/17/22 | Still in office | Female | ||||
373 | 373 | Biden | Director of National Intelligence | Avril Haines | 1/21/21 | Still in office | Female | ||||
374 | 374 | Biden | U.S. Trade Representative | Katherine Tai | 3/18/21 | Still in office | Female | ||||
375 | 375 | Biden | UN Ambassador | Linda Thomas-Greenfield | 2/24/21 | Still in office | Female | ||||
376 | 376 | Biden | CEA Chair | Cecilia Rouse | 3/12/21 | Still in office | Female | ||||
377 | 377 | Biden | SBA Administrator | Isabel Guzman | 3/17/21 | Still in office | Female | ||||
378 | 378 | Biden | OSTP Director | Arati Prabhakar | 10/1/22 | Still in office | Female | ||||
379 | 379 | Biden | Chief of Staff | Jeff Zients | 2/8/23 | Still in office | Male | ||||
94 | 94 | Bush 41 | OSTP Director | William R. Graham | Reagan admin | 6/5/89 | 977 combined | 137 | Male | ||
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 | ||
1 | 1 | Carter | OMB Director | Bert Lance | 1/21/77 | 9/23/77 | 245 | 247 | Male | ||
312 | 312 | Trump | Secretary of Health & Human Services | Tom Price | 2/10/17 | 9/29/17 | 231 | 253 | Male | ||
36 | 36 | Reagan | SBA Administrator | Michael Cardenas | 3/30/81 | 2/3/82 | 310 | 380 | Male | ||
131 | 131 | Clinton | Secretary of Defense | Les Aspin | 1/21/93 | 2/3/94 | 378 | 380 | Male | ||
353 | 353 | Biden | OSTP Director | Eric Lander | 6/2/21 | 2/18/22 | 261 | 395 | 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 | ||
251 | 251 | Obama | Director of National Intelligence | Dennis Blair | 1/29/09 | 5/28/10 | 484 | 494 | Male | ||
37 | 37 | Reagan | Secretary of State | Alexander Haig | 1/22/81 | 7/5/82 | 529 | 532 | Male | ||
316 | 316 | Trump | EPA Administrator | Scott Pruitt | 2/17/17 | 7/6/18 | 504 | 533 | Male | ||
132 | 132 | Clinton | Chief of Staff | Mack McLarty | 1/20/93 | 7/17/94 | 543 | 544 | Male | ||
133 | 133 | Clinton | OMB Director | Leon Panetta | 1/21/93 | 7/17/94 | 542 | 544 | Male | ||
252 | 252 | Obama | OMB Director | Peter Orszag | 1/20/09 | 7/30/10 | 556 | 557 | Male | ||
38 | 38 | Reagan | CEA Chair | Murray Weidenbaum | 2/27/81 | 8/25/82 | 544 | 583 | Male | ||
253 | 253 | Obama | CEA Chair | Christina Romer | 1/29/09 | 9/3/10 | 582 | 592 | Female | ||
254 | 254 | Obama | Chief of Staff | Rahm Emanuel | 1/20/09 | 10/1/10 | 619 | 620 | Male | ||
134 | 134 | Clinton | SBA Administrator | Erskine Bowles | 5/12/93 | 10/6/94 | 512 | 625 | Male | ||
39 | 39 | Reagan | Secretary of Energy | James Edwards | 1/23/81 | 11/5/82 | 651 | 655 | Male | ||
317 | 317 | Trump | Attorney General | Jeff Sessions | 2/9/17 | 11/7/18 | 636 | 657 | 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 | ||
135 | 135 | Clinton | Secretary of the Treasury | Lloyd Bentsen | 1/22/93 | 12/22/94 | 699 | 702 | Male | ||
136 | 136 | Clinton | Secretary of Agriculture | Mike Espy | 1/22/93 | 12/31/94 | 708 | 711 | Male | ||
187 | 187 | Bush 43 | Secretary of the Treasury | Paul O'Neill | 1/30/01 | 12/31/02 | 700 | 711 | 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 | ||
137 | 137 | Clinton | Director of Central Intelligence | Jim Woolsey | 2/5/93 | 1/10/95 | 704 | 721 | 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 | ||
354 | 354 | Biden | Chief of Staff | Ron Klain | 1/20/21 | 2/8/23 | 749 | 750 | Male | ||
188 | 188 | Bush 43 | CEA Chair | Glenn Hubbard | 5/11/01 | 2/28/03 | 658 | 770 | Male | ||
97 | 97 | Bush 41 | Secretary of Agriculture | Clayton Yeutter | 2/16/89 | 3/1/91 | 743 | 771 | Male | ||
42 | 42 | Reagan | EPA Administrator | Anne Gorsuch | 5/20/81 | 3/9/83 | 658 | 779 | Female | ||
98 | 98 | Bush 41 | SBA Administrator | Susan Engeleiter | 4/20/89 | 3/27/91 | 706 | 797 | Female | ||
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 | ||
138 | 138 | Clinton | CEA Chair | Laura D'Andrea Tyson | 2/5/93 | 4/20/95 | 804 | 821 | Female | ||
189 | 189 | Bush 43 | OMB Director | Mitch Daniels | 1/23/01 | 6/6/03 | 864 | 868 | Male | ||
190 | 190 | Bush 43 | EPA Administrator | Christine Todd Whitman | 1/31/01 | 6/27/03 | 877 | 889 | Female | ||
324 | 324 | Trump | CEA Chair | Kevin Hassett | 9/13/17 | 6/28/19 | 653 | 890 | Male | ||
255 | 255 | Obama | CIA Director | Leon Panetta | 2/13/09 | 6/30/11 | 867 | 892 | Male | ||
256 | 256 | Obama | Secretary of Defense | Bob Gates | Bush admin | 6/30/11 | 1655 combined | 892 | Male | ||
325 | 325 | Trump | Secretary of Labor | Alexander Acosta | 4/28/17 | 7/19/19 | 812 | 911 | Male | ||
2 | 2 | Carter | Secretary of Transportation | Brock Adams | 1/23/77 | 7/20/79 | 908 | 912 | Male | ||
257 | 257 | Obama | Secretary of Commerce | Gary Locke | 3/26/09 | 8/1/11 | 858 | 924 | 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 | ||
258 | 258 | Obama | CEA Chair | Austan Goolsbee | 9/10/10 | 8/5/11 | 329 | 928 | Male | ||
99 | 99 | Bush 41 | Attorney General | Dick Thornburgh | Reagan admin | 8/15/91 | 1098 combined | 938 | Male | ||
326 | 326 | Trump | Director of National Intelligence | Dan Coats | 3/16/17 | 8/15/19 | 882 | 938 | 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 | ||
100 | 100 | Bush 41 | Director of Central Intelligence | Bill Webster | Reagan admin | 8/31/91 | 1558 combined | 954 | 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 | ||
43 | 43 | Reagan | Secretary of the Interior | James Watt | 1/23/81 | 11/8/83 | 1019 | 1023 | Male | ||
327 | 327 | Trump | Secretary of Energy | Rick Perry | 3/2/17 | 12/1/19 | 1004 | 1046 | Male | ||
191 | 191 | Bush 43 | Secretary of Housing & Urban Development | Mel Martinez | 1/24/01 | 12/12/03 | 1052 | 1057 | Male | ||
101 | 101 | Bush 41 | Secretary of Transportation | Sam Skinner | 2/6/89 | 12/13/91 | 1040 | 1058 | Male | ||
102 | 102 | Bush 41 | Chief of Staff | John Sununu | 1/20/89 | 12/15/91 | 1059 | 1060 | 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 );