home / fivethirtyeight

Menu
  • GraphQL API

cabinet-turnover/cabinet-turnover

Table actions
  • GraphQL API for 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

✎ 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
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    

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
);
Powered by Datasette · Queries took 473.548ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette