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 length 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 |
---|---|---|---|---|---|---|---|---|---|---|---|
57 | 57 | Reagan | OSTP Director | George A. Keyworth II | Aug. 1981 | 12/31/85 | Approx. 1613 | 1807 | Male | ||
249 | 249 | Bush 43 | CIA Director | Michael Hayden | 5/30/06 | 2/12/09 | 989 | 2946 | Male | ||
89 | 89 | Reagan | OSTP Director | William R. Graham | 10/2/86 | Bush admin | 977 combined | Male | |||
94 | 94 | Bush 41 | OSTP Director | William R. Graham | Reagan admin | 6/5/89 | 977 combined | 137 | Male | ||
342 | 342 | Trump | CIA Director | Gina Haspel | 5/21/18 | 1/20/21 | 975 | 1462 | Female | ||
167 | 167 | Clinton | OMB Director | Jack Lew | 5/21/98 | 1/19/01 | 974 | 2922 | Male | ||
222 | 222 | Bush 43 | Secretary of Agriculture | Mike Johanns | 1/21/05 | 9/20/07 | 972 | 2435 | Male | ||
223 | 223 | Bush 43 | Secretary of Veterans Affairs | Jim Nicholson | 2/1/05 | 10/1/07 | 972 | 2446 | Male | ||
9 | 9 | Carter | UN Ambassador | Andrew Young | 1/30/77 | 9/23/79 | 966 | 977 | Male | ||
228 | 228 | Bush 43 | Secretary of the Interior | Dirk Kempthorne | 5/29/06 | 1/19/09 | 966 | 2922 | Male | ||
243 | 243 | Bush 43 | U.S. Trade Representative | Susan Schwab | 6/8/06 | 1/20/09 | 957 | 2923 | Female | ||
221 | 221 | Bush 43 | Attorney General | Alberto Gonzales | 2/3/05 | 9/17/07 | 956 | 2432 | Male | ||
303 | 303 | Obama | Secretary of Health & Human Services | Sylvia Burwell | 6/9/14 | 1/20/17 | 956 | 2923 | Female | ||
6 | 6 | Carter | Attorney General | Griffin Bell | 1/26/77 | 8/16/79 | 932 | 939 | Male | ||
240 | 240 | Bush 43 | Secretary of the Treasury | Hank Paulson | 7/10/06 | 1/20/09 | 925 | 2923 | Male | ||
5 | 5 | Carter | Secretary of the Treasury | W. Michael Blumenthal | 1/23/77 | 8/4/79 | 923 | 927 | Male | ||
4 | 4 | Carter | Secretary of Housing & Urban Development | Patricia Harris | 1/23/77 | 8/3/79 | 922 | 926 | Female | ||
3 | 3 | Carter | Secretary of Health, Education & Welfare | Joseph Califano Jr. | 1/25/77 | 8/3/79 | 920 | 926 | Male | ||
146 | 146 | Clinton | Chief of Staff | Leon Panetta | 7/17/94 | 1/20/97 | 918 | 1462 | Male | ||
64 | 64 | Reagan | Secretary of Labor | Bill Brock | 4/29/85 | 10/31/87 | 915 | 2476 | Male | ||
2 | 2 | Carter | Secretary of Transportation | Brock Adams | 1/23/77 | 7/20/79 | 908 | 912 | Male | ||
304 | 304 | Obama | OMB Director | Shaun Donovan | 7/28/14 | 1/20/17 | 907 | 2923 | Male | ||
305 | 305 | Obama | Secretary of Housing & Urban Development | Julián Castro | 7/28/14 | 1/20/17 | 907 | 2923 | Male | ||
306 | 306 | Obama | Secretary of Veterans Affairs | Bob McDonald | 7/30/14 | 1/20/17 | 905 | 2923 | Male | ||
343 | 343 | Trump | Secretary of Veterans Affairs | Robert Wilkie | 7/30/18 | 1/20/21 | 905 | 1462 | Male | ||
185 | 185 | Clinton | OSTP Director | Neal Lane | 8/4/98 | 1/20/01 | 900 | 2923 | Male | ||
161 | 161 | Clinton | CEA Chair | Janet Yellen | 2/18/97 | 8/3/99 | 896 | 2387 | Female | ||
177 | 177 | Clinton | Secretary of Energy | Bill Richardson | 8/18/98 | 1/20/01 | 886 | 2923 | Male | ||
326 | 326 | Trump | Director of National Intelligence | Dan Coats | 3/16/17 | 8/15/19 | 882 | 938 | Male | ||
190 | 190 | Bush 43 | EPA Administrator | Christine Todd Whitman | 1/31/01 | 6/27/03 | 877 | 889 | Female | ||
7 | 7 | Carter | U.S. Trade Representative | Robert Strauss | 3/30/77 | 8/17/79 | 870 | 940 | Male | ||
255 | 255 | Obama | CIA Director | Leon Panetta | 2/13/09 | 6/30/11 | 867 | 892 | Male | ||
189 | 189 | Bush 43 | OMB Director | Mitch Daniels | 1/23/01 | 6/6/03 | 864 | 868 | Male | ||
257 | 257 | Obama | Secretary of Commerce | Gary Locke | 3/26/09 | 8/1/11 | 858 | 924 | Male | ||
152 | 152 | Clinton | SBA Administrator | Philip Lader | 10/8/94 | 2/11/97 | 857 | 1484 | Male | ||
241 | 241 | Bush 43 | Secretary of Transportation | Mary Peters | 10/17/06 | 1/20/09 | 826 | 2923 | Female | ||
49 | 49 | Reagan | Secretary of Energy | Donald Hodel | 11/5/82 | 2/7/85 | 825 | 1480 | Male | ||
173 | 173 | Clinton | Chief of Staff | John Podesta | 10/20/98 | 1/20/01 | 823 | 2923 | Male | ||
92 | 92 | Reagan | Secretary of Education | Lauro Cavazos | 9/20/88 | Bush admin | 816 combined | Male | |||
96 | 96 | Bush 41 | Secretary of Education | Lauro Cavazos | Reagan admin | 12/15/90 | 816 combined | 695 | Male | ||
163 | 163 | Clinton | Secretary of Veterans Affairs | Togo West Jr. | 5/5/98 | 7/25/00 | 812 | 2744 | Male | ||
325 | 325 | Trump | Secretary of Labor | Alexander Acosta | 4/28/17 | 7/19/19 | 812 | 911 | Male | ||
138 | 138 | Clinton | CEA Chair | Laura D'Andrea Tyson | 2/5/93 | 4/20/95 | 804 | 821 | Female | ||
323 | 323 | Trump | SBA Administrator | Linda McMahon | 2/14/17 | 4/12/19 | 787 | 813 | Female | ||
88 | 88 | Reagan | SBA Administrator | James Abdnor | 3/23/87 | 4/20/89 | 759 | 3013 | Male | ||
61 | 61 | Reagan | Chief of Staff | Don Regan | 2/4/85 | 2/27/87 | 753 | 2230 | Male | ||
354 | 354 | Biden | Chief of Staff | Ron Klain | 1/20/21 | 2/8/23 | 749 | 750 | Male | ||
8 | 8 | Carter | Secretary of Energy | James Schlesinger | 8/6/77 | 8/23/79 | 747 | 946 | Male | ||
97 | 97 | Bush 41 | Secretary of Agriculture | Clayton Yeutter | 2/16/89 | 3/1/91 | 743 | 771 | Male | ||
41 | 41 | Reagan | Secretary of Health & Human Services | Richard Schweiker | 1/22/81 | 2/3/83 | 742 | 745 | Male | ||
333 | 333 | Trump | OSTP Director | Kelvin Droegemeier | 1/11/19 | 1/20/21 | 740 | 1462 | Male | ||
40 | 40 | Reagan | Secretary of Transportation | Drew Lewis | 1/23/81 | 2/1/83 | 739 | 743 | Male | ||
202 | 202 | Bush 43 | Secretary of Homeland Security | Tom Ridge | 1/24/03 | 2/1/05 | 739 | 1474 | Male | ||
74 | 74 | Reagan | OMB Director | Joseph Wright Jr. | 11/8/88 | 1/20/89 | 73 | 2923 | Male | ||
281 | 281 | Obama | Secretary of Defense | Chuck Hagel | 2/27/13 | 2/17/15 | 720 | 2220 | Male | ||
248 | 248 | Bush 43 | Director of National Intelligence | Mike McConnell | 2/13/07 | 1/27/09 | 714 | 2930 | Male | ||
124 | 124 | Bush 41 | Secretary of Labor | Lynn Morley Martin | 2/7/91 | 1/20/93 | 713 | 1462 | Female | ||
318 | 318 | Trump | Secretary of Defense | Jim Mattis | 1/20/17 | 12/31/18 | 710 | 711 | Male | ||
136 | 136 | Clinton | Secretary of Agriculture | Mike Espy | 1/22/93 | 12/31/94 | 708 | 711 | Male | ||
98 | 98 | Bush 41 | SBA Administrator | Susan Engeleiter | 4/20/89 | 3/27/91 | 706 | 797 | Female | ||
319 | 319 | Trump | UN Ambassador | Nikki Haley | 1/25/17 | 12/31/18 | 705 | 711 | Female | ||
137 | 137 | Clinton | Director of Central Intelligence | Jim Woolsey | 2/5/93 | 1/10/95 | 704 | 721 | Male | ||
286 | 286 | Obama | Secretary of Defense | Ash Carter | 2/17/15 | 1/19/17 | 702 | 2922 | Male | ||
187 | 187 | Bush 43 | Secretary of the Treasury | Paul O'Neill | 1/30/01 | 12/31/02 | 700 | 711 | Male | ||
135 | 135 | Clinton | Secretary of the Treasury | Lloyd Bentsen | 1/22/93 | 12/22/94 | 699 | 702 | Male | ||
225 | 225 | Bush 43 | SBA Administrator | Steve Preston | 7/10/06 | 6/5/08 | 696 | 2694 | Male | ||
344 | 344 | Trump | EPA Administrator | Andrew Wheeler | 2/28/19 | 1/20/21 | 692 | 1462 | Male | ||
118 | 118 | Bush 41 | Secretary of Agriculture | Ed Madigan | 3/12/91 | 1/20/93 | 680 | 1462 | Male | ||
330 | 330 | Trump | Attorney General | William Barr | 2/14/19 | 12/23/20 | 678 | 1434 | Male | ||
121 | 121 | Bush 41 | Secretary of Education | Lamar Alexander | 3/18/91 | 1/20/93 | 674 | 1462 | Male | ||
321 | 321 | Trump | Secretary of the Interior | Ryan Zinke | 3/1/17 | 1/2/19 | 672 | 713 | Male | ||
95 | 95 | Bush 41 | Secretary of Labor | Elizabeth Dole | 1/25/89 | 11/23/90 | 667 | 673 | Female | ||
117 | 117 | Bush 41 | SBA Administrator | Pat Saiki | 3/27/91 | 1/20/93 | 665 | 1462 | Female | ||
219 | 219 | Bush 43 | Director of National Intelligence | John Negroponte | 4/21/05 | 2/13/07 | 663 | 2216 | Male | ||
42 | 42 | Reagan | EPA Administrator | Anne Gorsuch | 5/20/81 | 3/9/83 | 658 | 779 | Female | ||
188 | 188 | Bush 43 | CEA Chair | Glenn Hubbard | 5/11/01 | 2/28/03 | 658 | 770 | Male | ||
324 | 324 | Trump | CEA Chair | Kevin Hassett | 9/13/17 | 6/28/19 | 653 | 890 | Male | ||
39 | 39 | Reagan | Secretary of Energy | James Edwards | 1/23/81 | 11/5/82 | 651 | 655 | Male | ||
345 | 345 | Trump | Secretary of the Interior | David Bernhardt | 4/11/19 | 1/20/21 | 650 | 1462 | Male | ||
159 | 159 | Clinton | Chief of Staff | Erskine Bowles | 1/20/97 | 10/20/98 | 638 | 2100 | Male | ||
317 | 317 | Trump | Attorney General | Jeff Sessions | 2/9/17 | 11/7/18 | 636 | 657 | Male | ||
44 | 44 | Reagan | CEA Chair | Martin Feldstein | 10/14/82 | 7/10/84 | 635 | 1268 | Male | ||
274 | 274 | Obama | CEA Chair | Alan Krueger | 11/7/11 | 8/2/13 | 634 | 1656 | Male | ||
307 | 307 | Obama | Attorney General | Loretta Lynch | 4/27/15 | 1/20/17 | 634 | 2923 | Female | ||
247 | 247 | Bush 43 | UN Ambassador | Zalmay Khalilzad | 4/30/07 | 1/22/09 | 633 | 2925 | Male | ||
205 | 205 | Bush 43 | CEA Chair | Greg Mankiw | 5/29/03 | 2/18/05 | 631 | 1491 | Male | ||
254 | 254 | Obama | Chief of Staff | Rahm Emanuel | 1/20/09 | 10/1/10 | 619 | 620 | Male | ||
156 | 156 | Clinton | OMB Director | Frank Raines | 9/13/96 | 5/21/98 | 615 | 1948 | Male | ||
268 | 268 | Obama | Secretary of Defense | Leon Panetta | 7/1/11 | 2/26/13 | 606 | 1499 | Male | ||
46 | 46 | Reagan | EPA Administrator | William Ruckelshaus | 5/18/83 | 1/4/85 | 597 | 1446 | Male | ||
151 | 151 | Clinton | CEA Chair | Joseph Stiglitz | 6/28/95 | 2/10/97 | 593 | 1483 | Male | ||
212 | 212 | Bush 43 | Director of Central Intelligence/CIA Director | Porter Goss | 9/24/04 | 5/5/06 | 588 | 1932 | Male | ||
142 | 142 | Clinton | Director of Central Intelligence | John Deutch | 5/10/95 | 12/15/96 | 585 | 1426 | Male | ||
253 | 253 | Obama | CEA Chair | Christina Romer | 1/29/09 | 9/3/10 | 582 | 592 | Female | ||
181 | 181 | Clinton | Secretary of the Treasury | Larry Summers | 7/2/99 | 1/20/01 | 568 | 2923 | Male | ||
141 | 141 | Clinton | OMB Director | Alice Rivlin | 10/17/94 | 4/26/96 | 557 | 1193 | Female | ||
252 | 252 | Obama | OMB Director | Peter Orszag | 1/20/09 | 7/30/10 | 556 | 557 | Male | ||
158 | 158 | Clinton | UN Ambassador | Bill Richardson | 2/18/97 | 8/18/98 | 546 | 2037 | Male | ||
38 | 38 | Reagan | CEA Chair | Murray Weidenbaum | 2/27/81 | 8/25/82 | 544 | 583 | Male | ||
132 | 132 | Clinton | Chief of Staff | Mack McLarty | 1/20/93 | 7/17/94 | 543 | 544 | 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 );