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 rowid 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 |
---|---|---|---|---|---|---|---|---|---|---|---|
379 | 379 | Biden | Chief of Staff | Jeff Zients | 2/8/23 | Still in office | Male | ||||
378 | 378 | Biden | OSTP Director | Arati Prabhakar | 10/1/22 | Still in office | Female | ||||
377 | 377 | Biden | SBA Administrator | Isabel Guzman | 3/17/21 | Still in office | Female | ||||
376 | 376 | Biden | CEA Chair | Cecilia Rouse | 3/12/21 | Still in office | Female | ||||
375 | 375 | Biden | UN Ambassador | Linda Thomas-Greenfield | 2/24/21 | Still in office | Female | ||||
374 | 374 | Biden | U.S. Trade Representative | Katherine Tai | 3/18/21 | Still in office | Female | ||||
373 | 373 | Biden | Director of National Intelligence | Avril Haines | 1/21/21 | Still in office | Female | ||||
372 | 372 | Biden | OMB Director | Shalanda Young | 3/17/22 | Still in office | Female | ||||
371 | 371 | Biden | EPA Administrator | Michael Regan | 3/11/21 | Still in office | Male | ||||
370 | 370 | Biden | Secretary of Homeland Security | Alejandro Mayorkas | 2/2/21 | Still in office | Male | ||||
369 | 369 | Biden | Secretary of Veterans Affairs | Denis McDonough | 2/9/21 | Still in office | Male | ||||
368 | 368 | Biden | Secretary of Education | Miguel Cardona | 3/2/21 | Still in office | Male | ||||
367 | 367 | Biden | Secretary of Energy | Jennifer Granholm | 2/25/21 | Still in office | Female | ||||
366 | 366 | Biden | Secretary of Transportation | Pete Buttigieg | 2/3/21 | Still in office | Male | ||||
365 | 365 | Biden | Secretary of Housing & Urban Development | Marcia Fudge | 3/10/21 | Still in office | Female | ||||
364 | 364 | Biden | Secretary of Health & Human Services | Xavier Becerra | 3/19/21 | Still in office | Male | ||||
363 | 363 | Biden | Secretary of Labor | Marty Walsh | 3/23/21 | Still in office | Male | ||||
362 | 362 | Biden | Secretary of Commerce | Gina Raimondo | 3/3/21 | Still in office | Female | ||||
361 | 361 | Biden | Secretary of Agriculture | Tom Vilsack | 2/24/21 | Still in office | Male | ||||
360 | 360 | Biden | Secretary of the Interior | Deb Haaland | 3/16/21 | Still in office | Female | ||||
359 | 359 | Biden | Attorney General | Merrick Garland | 3/11/21 | Still in office | Male | ||||
358 | 358 | Biden | Secretary of Defense | Lloyd Austin | 1/22/21 | Still in office | Male | ||||
357 | 357 | Biden | Secretary of the Treasury | Janet Yellen | 1/26/21 | Still in office | Female | ||||
356 | 356 | Biden | Secretary of State | Antony Blinken | 1/26/21 | Still in office | Male | ||||
355 | 355 | Biden | Vice President | Kamala Harris | 1/20/21 | Still in office | Female | ||||
354 | 354 | Biden | Chief of Staff | Ron Klain | 1/20/21 | 2/8/23 | 749 | 750 | Male | ||
353 | 353 | Biden | OSTP Director | Eric Lander | 6/2/21 | 2/18/22 | 261 | 395 | Male | ||
352 | 352 | Trump | OMB Director | Russ Vought | 7/22/20 | 1/20/21 | 182 | 1462 | Male | ||
351 | 351 | Trump | Director of National Intelligence | John Ratcliffe | 5/26/20 | 1/20/21 | 239 | 1462 | Male | ||
350 | 350 | Trump | Chief of Staff | Mark Meadows | 3/31/20 | 1/20/21 | 295 | 1462 | Male | ||
349 | 349 | Trump | SBA Administrator | Jovita Carranza | 1/14/20 | 1/20/21 | 372 | 1462 | Female | ||
348 | 348 | Trump | Secretary of Energy | Dan Brouillette | 12/11/19 | 1/20/21 | 406 | 1462 | Male | ||
347 | 347 | Trump | Secretary of Labor | Eugene Scalia | 9/27/19 | 1/20/21 | 481 | 1462 | Male | ||
346 | 346 | Trump | UN Ambassador | Kelly Craft | 9/10/19 | 1/20/21 | 498 | 1462 | Female | ||
345 | 345 | Trump | Secretary of the Interior | David Bernhardt | 4/11/19 | 1/20/21 | 650 | 1462 | Male | ||
344 | 344 | Trump | EPA Administrator | Andrew Wheeler | 2/28/19 | 1/20/21 | 692 | 1462 | Male | ||
343 | 343 | Trump | Secretary of Veterans Affairs | Robert Wilkie | 7/30/18 | 1/20/21 | 905 | 1462 | Male | ||
342 | 342 | Trump | CIA Director | Gina Haspel | 5/21/18 | 1/20/21 | 975 | 1462 | Female | ||
341 | 341 | Trump | Secretary of State | Mike Pompeo | 4/26/18 | 1/20/21 | 1000 | 1462 | Male | ||
340 | 340 | Trump | Secretary of Health & Human Services | Alex Azar | 1/29/18 | 1/20/21 | 1087 | 1462 | Male | ||
339 | 339 | Trump | U.S. Trade Representative | Robert Lighthizer | 5/15/17 | 1/20/21 | 1346 | 1462 | Male | ||
338 | 338 | Trump | Secretary of Agriculture | Sonny Perdue | 4/25/17 | 1/20/21 | 1366 | 1462 | Male | ||
337 | 337 | Trump | Secretary of Housing & Urban Development | Ben Carson | 3/2/17 | 1/20/21 | 1420 | 1462 | Male | ||
336 | 336 | Trump | Secretary of Commerce | Wilbur Ross | 2/28/17 | 1/20/21 | 1422 | 1462 | Male | ||
335 | 335 | Trump | Secretary of the Treasury | Steve Mnuchin | 2/13/17 | 1/20/21 | 1437 | 1462 | Male | ||
334 | 334 | Trump | Vice President | Mike Pence | 1/20/17 | 1/20/21 | 1461 | 1462 | Male | ||
333 | 333 | Trump | OSTP Director | Kelvin Droegemeier | 1/11/19 | 1/20/21 | 740 | 1462 | Male | ||
332 | 332 | Trump | Secretary of Transportation | Elaine Chao | 1/31/17 | 1/11/21 | 1441 | 1453 | Female | ||
331 | 331 | Trump | Secretary of Education | Betsy DeVos | 2/7/17 | 1/8/21 | 1431 | 1450 | Female | ||
330 | 330 | Trump | Attorney General | William Barr | 2/14/19 | 12/23/20 | 678 | 1434 | Male | ||
329 | 329 | Trump | Secretary of Defense | Mark Esper | 7/23/19 | 11/9/20 | 475 | 1390 | Male | ||
328 | 328 | Trump | OMB Director | Mick Mulvaney | 2/16/17 | 3/31/20 | 1139 | 1167 | Male | ||
327 | 327 | Trump | Secretary of Energy | Rick Perry | 3/2/17 | 12/1/19 | 1004 | 1046 | Male | ||
326 | 326 | Trump | Director of National Intelligence | Dan Coats | 3/16/17 | 8/15/19 | 882 | 938 | Male | ||
325 | 325 | Trump | Secretary of Labor | Alexander Acosta | 4/28/17 | 7/19/19 | 812 | 911 | Male | ||
324 | 324 | Trump | CEA Chair | Kevin Hassett | 9/13/17 | 6/28/19 | 653 | 890 | Male | ||
323 | 323 | Trump | SBA Administrator | Linda McMahon | 2/14/17 | 4/12/19 | 787 | 813 | Female | ||
322 | 322 | Trump | Secretary of Homeland Security | Kirstjen Nielsen | 12/6/17 | 4/7/19 | 487 | 808 | Female | ||
321 | 321 | Trump | Secretary of the Interior | Ryan Zinke | 3/1/17 | 1/2/19 | 672 | 713 | Male | ||
320 | 320 | Trump | Chief of Staff | John Kelly | 7/31/17 | 12/31/18 | 518 | 711 | Male | ||
319 | 319 | Trump | UN Ambassador | Nikki Haley | 1/25/17 | 12/31/18 | 705 | 711 | Female | ||
318 | 318 | Trump | Secretary of Defense | Jim Mattis | 1/20/17 | 12/31/18 | 710 | 711 | Male | ||
317 | 317 | Trump | Attorney General | Jeff Sessions | 2/9/17 | 11/7/18 | 636 | 657 | Male | ||
316 | 316 | Trump | EPA Administrator | Scott Pruitt | 2/17/17 | 7/6/18 | 504 | 533 | Male | ||
315 | 315 | Trump | CIA Director | Mike Pompeo | 1/23/17 | 4/26/18 | 458 | 462 | Male | ||
314 | 314 | Trump | Secretary of State | Rex Tillerson | 2/1/17 | 3/31/18 | 423 | 436 | Male | ||
313 | 313 | Trump | Secretary of Veterans Affairs | David Shulkin | 2/14/17 | 3/28/18 | 407 | 433 | Male | ||
312 | 312 | Trump | Secretary of Health & Human Services | Tom Price | 2/10/17 | 9/29/17 | 231 | 253 | Male | ||
311 | 311 | Trump | Secretary of Homeland Security | John Kelly | 1/20/17 | 7/28/17 | 189 | 190 | Male | ||
310 | 310 | Trump | Chief of Staff | Reince Priebus | 1/20/17 | 7/28/17 | 189 | 190 | Male | ||
309 | 309 | Obama | UN Ambassador | Samantha Power | 8/5/13 | 1/21/17 | 1265 | 2924 | Female | ||
308 | 308 | Obama | Secretary of Education | John King Jr. | 3/14/16 | 1/20/17 | 312 | 2923 | Male | ||
307 | 307 | Obama | Attorney General | Loretta Lynch | 4/27/15 | 1/20/17 | 634 | 2923 | Female | ||
306 | 306 | Obama | Secretary of Veterans Affairs | Bob McDonald | 7/30/14 | 1/20/17 | 905 | 2923 | Male | ||
305 | 305 | Obama | Secretary of Housing & Urban Development | Julián Castro | 7/28/14 | 1/20/17 | 907 | 2923 | Male | ||
304 | 304 | Obama | OMB Director | Shaun Donovan | 7/28/14 | 1/20/17 | 907 | 2923 | Male | ||
303 | 303 | Obama | Secretary of Health & Human Services | Sylvia Burwell | 6/9/14 | 1/20/17 | 956 | 2923 | Female | ||
302 | 302 | Obama | SBA Administrator | Maria Contreras-Sweet | 4/7/14 | 1/20/17 | 1019 | 2923 | Female | ||
301 | 301 | Obama | Secretary of Homeland Security | Jeh Johnson | 12/23/13 | 1/20/17 | 1124 | 2923 | Male | ||
300 | 300 | Obama | Secretary of Labor | Tom Perez | 7/23/13 | 1/20/17 | 1277 | 2923 | Male | ||
299 | 299 | Obama | EPA Administrator | Gina McCarthy | 7/19/13 | 1/20/17 | 1281 | 2923 | Female | ||
298 | 298 | Obama | Secretary of Transportation | Anthony Foxx | 7/2/13 | 1/20/17 | 1298 | 2923 | Male | ||
297 | 297 | Obama | Secretary of Commerce | Penny Pritzker | 6/26/13 | 1/20/17 | 1304 | 2923 | Female | ||
296 | 296 | Obama | U.S. Trade Representative | Michael Froman | 6/21/13 | 1/20/17 | 1309 | 2923 | Male | ||
295 | 295 | Obama | Secretary of Energy | Ernest Moniz | 5/21/13 | 1/20/17 | 1340 | 2923 | Male | ||
294 | 294 | Obama | Secretary of the Interior | Sally Jewell | 4/12/13 | 1/20/17 | 1379 | 2923 | Female | ||
293 | 293 | Obama | CIA Director | John Brennan | 3/8/13 | 1/20/17 | 1414 | 2923 | Male | ||
292 | 292 | Obama | Secretary of the Treasury | Jack Lew | 2/28/13 | 1/20/17 | 1422 | 2923 | Male | ||
291 | 291 | Obama | Secretary of State | John Kerry | 2/1/13 | 1/20/17 | 1449 | 2923 | Male | ||
290 | 290 | Obama | Chief of Staff | Denis McDonough | 1/25/13 | 1/20/17 | 1456 | 2923 | Male | ||
289 | 289 | Obama | Director of National Intelligence | James Clapper | 8/9/10 | 1/20/17 | 2356 | 2923 | Male | ||
288 | 288 | Obama | Vice President | Joe Biden | 1/20/09 | 1/20/17 | 2922 | 2923 | Male | ||
287 | 287 | Obama | OSTP Director | John Holdren | 3/19/09 | 1/19/17 | 2863 | 2922 | Male | ||
286 | 286 | Obama | Secretary of Defense | Ash Carter | 2/17/15 | 1/19/17 | 702 | 2922 | Male | ||
285 | 285 | Obama | CEA Chair | Jason Furman | 8/4/13 | 1/18/17 | 1263 | 2921 | Male | ||
284 | 284 | Obama | Secretary of Agriculture | Tom Vilsack | 1/20/09 | 1/13/17 | 2915 | 2916 | Male | ||
283 | 283 | Obama | Secretary of Education | Arne Duncan | 1/20/09 | 12/31/15 | 2536 | 2537 | Male | ||
282 | 282 | Obama | Attorney General | Eric Holder | 2/3/09 | 4/24/15 | 2271 | 2286 | Male | ||
281 | 281 | Obama | Secretary of Defense | Chuck Hagel | 2/27/13 | 2/17/15 | 720 | 2220 | Male | ||
280 | 280 | Obama | Secretary of Housing & Urban Development | Shaun Donovan | 1/26/09 | 7/28/14 | 2009 | 2016 | 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 );