cabinet-turnover/cabinet-turnover
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
43 rows where president = "Trump" sorted by appointee
This data as json, copyable, CSV (advanced)
Suggested facets: position, end_date, departure_day, gender
Link | rowid | president | position | appointee ▼ | start_date | end_date | length | departure_day | gender | Unnamed: 8 | Unnamed: 9 |
---|---|---|---|---|---|---|---|---|---|---|---|
340 | 340 | Trump | Secretary of Health & Human Services | Alex Azar | 1/29/18 | 1/20/21 | 1087 | 1462 | Male | ||
325 | 325 | Trump | Secretary of Labor | Alexander Acosta | 4/28/17 | 7/19/19 | 812 | 911 | Male | ||
344 | 344 | Trump | EPA Administrator | Andrew Wheeler | 2/28/19 | 1/20/21 | 692 | 1462 | Male | ||
337 | 337 | Trump | Secretary of Housing & Urban Development | Ben Carson | 3/2/17 | 1/20/21 | 1420 | 1462 | Male | ||
331 | 331 | Trump | Secretary of Education | Betsy DeVos | 2/7/17 | 1/8/21 | 1431 | 1450 | Female | ||
348 | 348 | Trump | Secretary of Energy | Dan Brouillette | 12/11/19 | 1/20/21 | 406 | 1462 | Male | ||
326 | 326 | Trump | Director of National Intelligence | Dan Coats | 3/16/17 | 8/15/19 | 882 | 938 | Male | ||
345 | 345 | Trump | Secretary of the Interior | David Bernhardt | 4/11/19 | 1/20/21 | 650 | 1462 | Male | ||
313 | 313 | Trump | Secretary of Veterans Affairs | David Shulkin | 2/14/17 | 3/28/18 | 407 | 433 | Male | ||
332 | 332 | Trump | Secretary of Transportation | Elaine Chao | 1/31/17 | 1/11/21 | 1441 | 1453 | Female | ||
347 | 347 | Trump | Secretary of Labor | Eugene Scalia | 9/27/19 | 1/20/21 | 481 | 1462 | Male | ||
342 | 342 | Trump | CIA Director | Gina Haspel | 5/21/18 | 1/20/21 | 975 | 1462 | Female | ||
317 | 317 | Trump | Attorney General | Jeff Sessions | 2/9/17 | 11/7/18 | 636 | 657 | Male | ||
318 | 318 | Trump | Secretary of Defense | Jim Mattis | 1/20/17 | 12/31/18 | 710 | 711 | Male | ||
311 | 311 | Trump | Secretary of Homeland Security | John Kelly | 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 | ||
351 | 351 | Trump | Director of National Intelligence | John Ratcliffe | 5/26/20 | 1/20/21 | 239 | 1462 | Male | ||
349 | 349 | Trump | SBA Administrator | Jovita Carranza | 1/14/20 | 1/20/21 | 372 | 1462 | Female | ||
346 | 346 | Trump | UN Ambassador | Kelly Craft | 9/10/19 | 1/20/21 | 498 | 1462 | Female | ||
333 | 333 | Trump | OSTP Director | Kelvin Droegemeier | 1/11/19 | 1/20/21 | 740 | 1462 | Male | ||
324 | 324 | Trump | CEA Chair | Kevin Hassett | 9/13/17 | 6/28/19 | 653 | 890 | Male | ||
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 | ||
329 | 329 | Trump | Secretary of Defense | Mark Esper | 7/23/19 | 11/9/20 | 475 | 1390 | Male | ||
350 | 350 | Trump | Chief of Staff | Mark Meadows | 3/31/20 | 1/20/21 | 295 | 1462 | Male | ||
328 | 328 | Trump | OMB Director | Mick Mulvaney | 2/16/17 | 3/31/20 | 1139 | 1167 | Male | ||
334 | 334 | Trump | Vice President | Mike Pence | 1/20/17 | 1/20/21 | 1461 | 1462 | Male | ||
315 | 315 | Trump | CIA Director | Mike Pompeo | 1/23/17 | 4/26/18 | 458 | 462 | Male | ||
341 | 341 | Trump | Secretary of State | Mike Pompeo | 4/26/18 | 1/20/21 | 1000 | 1462 | Male | ||
319 | 319 | Trump | UN Ambassador | Nikki Haley | 1/25/17 | 12/31/18 | 705 | 711 | Female | ||
310 | 310 | Trump | Chief of Staff | Reince Priebus | 1/20/17 | 7/28/17 | 189 | 190 | Male | ||
314 | 314 | Trump | Secretary of State | Rex Tillerson | 2/1/17 | 3/31/18 | 423 | 436 | Male | ||
327 | 327 | Trump | Secretary of Energy | Rick Perry | 3/2/17 | 12/1/19 | 1004 | 1046 | Male | ||
339 | 339 | Trump | U.S. Trade Representative | Robert Lighthizer | 5/15/17 | 1/20/21 | 1346 | 1462 | Male | ||
343 | 343 | Trump | Secretary of Veterans Affairs | Robert Wilkie | 7/30/18 | 1/20/21 | 905 | 1462 | Male | ||
352 | 352 | Trump | OMB Director | Russ Vought | 7/22/20 | 1/20/21 | 182 | 1462 | Male | ||
321 | 321 | Trump | Secretary of the Interior | Ryan Zinke | 3/1/17 | 1/2/19 | 672 | 713 | Male | ||
316 | 316 | Trump | EPA Administrator | Scott Pruitt | 2/17/17 | 7/6/18 | 504 | 533 | Male | ||
338 | 338 | Trump | Secretary of Agriculture | Sonny Perdue | 4/25/17 | 1/20/21 | 1366 | 1462 | Male | ||
335 | 335 | Trump | Secretary of the Treasury | Steve Mnuchin | 2/13/17 | 1/20/21 | 1437 | 1462 | Male | ||
312 | 312 | Trump | Secretary of Health & Human Services | Tom Price | 2/10/17 | 9/29/17 | 231 | 253 | Male | ||
336 | 336 | Trump | Secretary of Commerce | Wilbur Ross | 2/28/17 | 1/20/21 | 1422 | 1462 | Male | ||
330 | 330 | Trump | Attorney General | William Barr | 2/14/19 | 12/23/20 | 678 | 1434 | 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 );