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 position
This data as json, copyable, CSV (advanced)
Suggested facets: president, gender
position 30 ✖
- Chief of Staff 24
- OMB Director 21
- CEA Chair 20
- UN Ambassador 18
- Secretary of Commerce 17
- Attorney General 16
- SBA Administrator 16
- Secretary of Defense 16
- Secretary of Energy 16
- Secretary of the Treasury 16
- Secretary of State 15
- Secretary of Transportation 15
- EPA Administrator 14
- Secretary of Labor 14
- U.S. Trade Representative 14
- Secretary of Agriculture 13
- Secretary of Education 13
- Secretary of Housing & Urban Development 13
- Secretary of the Interior 13
- OSTP Director 12
- Secretary of Health & Human Services 12
- Secretary of Veterans Affairs 11
- Director of Central Intelligence 9
- Vice President 8
- Director of National Intelligence 7
- Secretary of Homeland Security 7
- CIA Director 6
- Director of Central Intelligence/CIA Director 1
- Secretary of Health, Education & Welfare 1
- Secretary of Health, Education & Welfare/Secretary of Health & Human Services 1
Link | rowid | president | position ▼ | appointee | start_date | end_date | length | departure_day | gender | Unnamed: 8 | Unnamed: 9 |
---|---|---|---|---|---|---|---|---|---|---|---|
6 | 6 | Carter | Attorney General | Griffin Bell | 1/26/77 | 8/16/79 | 932 | 939 | Male | ||
15 | 15 | Carter | Attorney General | Ben Civiletti | 8/16/79 | 1/19/81 | 522 | 1461 | Male | ||
51 | 51 | Reagan | Attorney General | William French Smith | 1/23/81 | 2/25/85 | 1494 | 1498 | Male | ||
67 | 67 | Reagan | Attorney General | Ed Meese | 2/25/85 | 8/12/88 | 1264 | 2762 | 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 | ||
109 | 109 | Bush 41 | Attorney General | William Barr | 11/26/91 | 1/15/93 | 416 | 1457 | Male | ||
172 | 172 | Clinton | Attorney General | Janet Reno | 3/12/93 | 1/20/01 | 2871 | 2923 | Female | ||
203 | 203 | Bush 43 | Attorney General | John Ashcroft | 2/2/01 | 2/3/05 | 1462 | 1476 | Male | ||
221 | 221 | Bush 43 | Attorney General | Alberto Gonzales | 2/3/05 | 9/17/07 | 956 | 2432 | Male | ||
229 | 229 | Bush 43 | Attorney General | Michael Mukasey | 11/9/07 | 1/20/09 | 438 | 2923 | Male | ||
282 | 282 | Obama | Attorney General | Eric Holder | 2/3/09 | 4/24/15 | 2271 | 2286 | Male | ||
307 | 307 | Obama | Attorney General | Loretta Lynch | 4/27/15 | 1/20/17 | 634 | 2923 | Female | ||
317 | 317 | Trump | Attorney General | Jeff Sessions | 2/9/17 | 11/7/18 | 636 | 657 | Male | ||
330 | 330 | Trump | Attorney General | William Barr | 2/14/19 | 12/23/20 | 678 | 1434 | Male | ||
359 | 359 | Biden | Attorney General | Merrick Garland | 3/11/21 | Still in office | Male | ||||
17 | 17 | Carter | CEA Chair | Charles Schultze | 1/22/77 | 1/20/81 | 1459 | 1462 | Male | ||
38 | 38 | Reagan | CEA Chair | Murray Weidenbaum | 2/27/81 | 8/25/82 | 544 | 583 | Male | ||
44 | 44 | Reagan | CEA Chair | Martin Feldstein | 10/14/82 | 7/10/84 | 635 | 1268 | Male | ||
71 | 71 | Reagan | CEA Chair | Beryl Sprinkel | 4/18/85 | 1/20/89 | 1373 | 2923 | Male | ||
108 | 108 | Bush 41 | CEA Chair | Michael Boskin | 2/2/89 | 1/12/93 | 1440 | 1454 | Male | ||
138 | 138 | Clinton | CEA Chair | Laura D'Andrea Tyson | 2/5/93 | 4/20/95 | 804 | 821 | Female | ||
151 | 151 | Clinton | CEA Chair | Joseph Stiglitz | 6/28/95 | 2/10/97 | 593 | 1483 | Male | ||
161 | 161 | Clinton | CEA Chair | Janet Yellen | 2/18/97 | 8/3/99 | 896 | 2387 | Female | ||
165 | 165 | Clinton | CEA Chair | Martin Baily | 8/12/99 | 1/19/01 | 526 | 2922 | Male | ||
188 | 188 | Bush 43 | CEA Chair | Glenn Hubbard | 5/11/01 | 2/28/03 | 658 | 770 | Male | ||
205 | 205 | Bush 43 | CEA Chair | Greg Mankiw | 5/29/03 | 2/18/05 | 631 | 1491 | Male | ||
207 | 207 | Bush 43 | CEA Chair | Harvey Rosen | 2/23/05 | 6/10/05 | 107 | 1603 | Male | ||
208 | 208 | Bush 43 | CEA Chair | Ben Bernanke | 6/21/05 | 1/31/06 | 224 | 1838 | Male | ||
230 | 230 | Bush 43 | CEA Chair | Edward Lazear | 2/27/06 | 1/20/09 | 1058 | 2923 | Male | ||
253 | 253 | Obama | CEA Chair | Christina Romer | 1/29/09 | 9/3/10 | 582 | 592 | Female | ||
258 | 258 | Obama | CEA Chair | Austan Goolsbee | 9/10/10 | 8/5/11 | 329 | 928 | Male | ||
274 | 274 | Obama | CEA Chair | Alan Krueger | 11/7/11 | 8/2/13 | 634 | 1656 | Male | ||
285 | 285 | Obama | CEA Chair | Jason Furman | 8/4/13 | 1/18/17 | 1263 | 2921 | Male | ||
324 | 324 | Trump | CEA Chair | Kevin Hassett | 9/13/17 | 6/28/19 | 653 | 890 | Male | ||
376 | 376 | Biden | CEA Chair | Cecilia Rouse | 3/12/21 | Still in office | Female | ||||
249 | 249 | Bush 43 | CIA Director | Michael Hayden | 5/30/06 | 2/12/09 | 989 | 2946 | Male | ||
255 | 255 | Obama | CIA Director | Leon Panetta | 2/13/09 | 6/30/11 | 867 | 892 | Male | ||
262 | 262 | Obama | CIA Director | David Petraeus | 9/6/11 | 11/9/12 | 430 | 1390 | Male | ||
293 | 293 | Obama | CIA Director | John Brennan | 3/8/13 | 1/20/17 | 1414 | 2923 | Male | ||
315 | 315 | Trump | CIA Director | Mike Pompeo | 1/23/17 | 4/26/18 | 458 | 462 | Male | ||
342 | 342 | Trump | CIA Director | Gina Haspel | 5/21/18 | 1/20/21 | 975 | 1462 | Female | ||
12 | 12 | Carter | Chief of Staff | Hamilton Jordan | 7/18/79 | 6/11/80 | 329 | 1239 | Male | ||
18 | 18 | Carter | Chief of Staff | Jack Watson | 6/11/80 | 1/20/81 | 223 | 1462 | Male | ||
48 | 48 | Reagan | Chief of Staff | James Baker | 1/20/81 | 2/3/85 | 1475 | 1476 | Male | ||
61 | 61 | Reagan | Chief of Staff | Don Regan | 2/4/85 | 2/27/87 | 753 | 2230 | Male | ||
66 | 66 | Reagan | Chief of Staff | Howard Baker | 3/2/87 | 7/1/88 | 487 | 2720 | Male | ||
72 | 72 | Reagan | Chief of Staff | Kenneth Duberstein | 7/1/88 | 1/20/89 | 203 | 2923 | Male | ||
102 | 102 | Bush 41 | Chief of Staff | John Sununu | 1/20/89 | 12/15/91 | 1059 | 1060 | Male | ||
105 | 105 | Bush 41 | Chief of Staff | Sam Skinner | 12/16/91 | 8/23/92 | 251 | 1312 | Male | ||
113 | 113 | Bush 41 | Chief of Staff | James Baker | 8/23/92 | 1/20/93 | 150 | 1462 | Male | ||
132 | 132 | Clinton | Chief of Staff | Mack McLarty | 1/20/93 | 7/17/94 | 543 | 544 | Male | ||
146 | 146 | Clinton | Chief of Staff | Leon Panetta | 7/17/94 | 1/20/97 | 918 | 1462 | Male | ||
159 | 159 | Clinton | Chief of Staff | Erskine Bowles | 1/20/97 | 10/20/98 | 638 | 2100 | Male | ||
173 | 173 | Clinton | Chief of Staff | John Podesta | 10/20/98 | 1/20/01 | 823 | 2923 | Male | ||
210 | 210 | Bush 43 | Chief of Staff | Andy Card | 1/20/01 | 4/14/06 | 1910 | 1911 | Male | ||
231 | 231 | Bush 43 | Chief of Staff | Josh Bolten | 4/14/06 | 1/20/09 | 1012 | 2923 | Male | ||
254 | 254 | Obama | Chief of Staff | Rahm Emanuel | 1/20/09 | 10/1/10 | 619 | 620 | Male | ||
260 | 260 | Obama | Chief of Staff | Bill Daley | 1/13/11 | 1/27/12 | 379 | 1103 | Male | ||
265 | 265 | Obama | Chief of Staff | Jack Lew | 1/30/12 | 1/25/13 | 361 | 1467 | Male | ||
290 | 290 | Obama | Chief of Staff | Denis McDonough | 1/25/13 | 1/20/17 | 1456 | 2923 | Male | ||
310 | 310 | Trump | Chief of Staff | Reince Priebus | 1/20/17 | 7/28/17 | 189 | 190 | Male | ||
320 | 320 | Trump | Chief of Staff | John Kelly | 7/31/17 | 12/31/18 | 518 | 711 | Male | ||
350 | 350 | Trump | Chief of Staff | Mark Meadows | 3/31/20 | 1/20/21 | 295 | 1462 | Male | ||
354 | 354 | Biden | Chief of Staff | Ron Klain | 1/20/21 | 2/8/23 | 749 | 750 | Male | ||
379 | 379 | Biden | Chief of Staff | Jeff Zients | 2/8/23 | Still in office | Male | ||||
19 | 19 | Carter | Director of Central Intelligence | Stansfield Turner | 3/9/77 | 1/20/81 | 1413 | 1462 | Male | ||
60 | 60 | Reagan | Director of Central Intelligence | William Casey | 1/28/81 | 1/29/87 | 2192 | 2201 | 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 | ||
137 | 137 | Clinton | Director of Central Intelligence | Jim Woolsey | 2/5/93 | 1/10/95 | 704 | 721 | Male | ||
142 | 142 | Clinton | Director of Central Intelligence | John Deutch | 5/10/95 | 12/15/96 | 585 | 1426 | Male | ||
186 | 186 | Clinton | Director of Central Intelligence | George Tenet | 7/11/97 | Bush admin | 2557 combined | Male | |||
193 | 193 | Bush 43 | Director of Central Intelligence | George Tenet | Clinton admin | 7/11/04 | 2557 combined | 1269 | Male | ||
212 | 212 | Bush 43 | Director of Central Intelligence/CIA Director | Porter Goss | 9/24/04 | 5/5/06 | 588 | 1932 | Male | ||
219 | 219 | Bush 43 | Director of National Intelligence | John Negroponte | 4/21/05 | 2/13/07 | 663 | 2216 | Male | ||
248 | 248 | Bush 43 | Director of National Intelligence | Mike McConnell | 2/13/07 | 1/27/09 | 714 | 2930 | Male | ||
251 | 251 | Obama | Director of National Intelligence | Dennis Blair | 1/29/09 | 5/28/10 | 484 | 494 | Male | ||
289 | 289 | Obama | Director of National Intelligence | James Clapper | 8/9/10 | 1/20/17 | 2356 | 2923 | Male | ||
326 | 326 | Trump | Director of National Intelligence | Dan Coats | 3/16/17 | 8/15/19 | 882 | 938 | Male | ||
351 | 351 | Trump | Director of National Intelligence | John Ratcliffe | 5/26/20 | 1/20/21 | 239 | 1462 | Male | ||
373 | 373 | Biden | Director of National Intelligence | Avril Haines | 1/21/21 | Still in office | Female | ||||
20 | 20 | Carter | EPA Administrator | Douglas Costle | 3/7/77 | 1/20/81 | 1415 | 1462 | Male | ||
42 | 42 | Reagan | EPA Administrator | Anne Gorsuch | 5/20/81 | 3/9/83 | 658 | 779 | Female | ||
46 | 46 | Reagan | EPA Administrator | William Ruckelshaus | 5/18/83 | 1/4/85 | 597 | 1446 | Male | ||
73 | 73 | Reagan | EPA Administrator | Lee Thomas | 2/8/85 | 1/20/89 | 1442 | 2923 | Male | ||
115 | 115 | Bush 41 | EPA Administrator | William Reilly | 2/6/89 | 1/20/93 | 1444 | 1462 | Male | ||
166 | 166 | Clinton | EPA Administrator | Carol Browner | 1/22/93 | 1/19/01 | 2919 | 2922 | Female | ||
190 | 190 | Bush 43 | EPA Administrator | Christine Todd Whitman | 1/31/01 | 6/27/03 | 877 | 889 | Female | ||
197 | 197 | Bush 43 | EPA Administrator | Mike Leavitt | 11/6/03 | 1/25/05 | 446 | 1467 | Male | ||
232 | 232 | Bush 43 | EPA Administrator | Stephen Johnson | 5/2/05 | 1/20/09 | 1359 | 2923 | Male | ||
267 | 267 | Obama | EPA Administrator | Lisa Jackson | 1/26/09 | 2/14/13 | 1480 | 1487 | Female | ||
299 | 299 | Obama | EPA Administrator | Gina McCarthy | 7/19/13 | 1/20/17 | 1281 | 2923 | Female | ||
316 | 316 | Trump | EPA Administrator | Scott Pruitt | 2/17/17 | 7/6/18 | 504 | 533 | Male | ||
344 | 344 | Trump | EPA Administrator | Andrew Wheeler | 2/28/19 | 1/20/21 | 692 | 1462 | Male | ||
371 | 371 | Biden | EPA Administrator | Michael Regan | 3/11/21 | Still in office | Male | ||||
1 | 1 | Carter | OMB Director | Bert Lance | 1/21/77 | 9/23/77 | 245 | 247 | Male | ||
21 | 21 | Carter | OMB Director | Jim McIntyre | 9/24/77 | 1/20/81 | 1214 | 1462 | Male | ||
55 | 55 | Reagan | OMB Director | David Stockman | 1/21/81 | 8/1/85 | 1653 | 1655 | 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 );