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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
355 | 355 | Biden | Vice President | Kamala Harris | 1/20/21 | Still in office | Female | ||||
356 | 356 | Biden | Secretary of State | Antony Blinken | 1/26/21 | Still in office | Male | ||||
357 | 357 | Biden | Secretary of the Treasury | Janet Yellen | 1/26/21 | Still in office | Female | ||||
358 | 358 | Biden | Secretary of Defense | Lloyd Austin | 1/22/21 | Still in office | Male | ||||
359 | 359 | Biden | Attorney General | Merrick Garland | 3/11/21 | Still in office | Male | ||||
360 | 360 | Biden | Secretary of the Interior | Deb Haaland | 3/16/21 | Still in office | Female | ||||
361 | 361 | Biden | Secretary of Agriculture | Tom Vilsack | 2/24/21 | Still in office | Male | ||||
362 | 362 | Biden | Secretary of Commerce | Gina Raimondo | 3/3/21 | Still in office | Female | ||||
363 | 363 | Biden | Secretary of Labor | Marty Walsh | 3/23/21 | Still in office | Male | ||||
364 | 364 | Biden | Secretary of Health & Human Services | Xavier Becerra | 3/19/21 | Still in office | Male | ||||
365 | 365 | Biden | Secretary of Housing & Urban Development | Marcia Fudge | 3/10/21 | Still in office | Female | ||||
366 | 366 | Biden | Secretary of Transportation | Pete Buttigieg | 2/3/21 | Still in office | Male | ||||
367 | 367 | Biden | Secretary of Energy | Jennifer Granholm | 2/25/21 | Still in office | Female | ||||
368 | 368 | Biden | Secretary of Education | Miguel Cardona | 3/2/21 | Still in office | Male | ||||
369 | 369 | Biden | Secretary of Veterans Affairs | Denis McDonough | 2/9/21 | Still in office | Male | ||||
370 | 370 | Biden | Secretary of Homeland Security | Alejandro Mayorkas | 2/2/21 | Still in office | Male | ||||
371 | 371 | Biden | EPA Administrator | Michael Regan | 3/11/21 | Still in office | Male | ||||
372 | 372 | Biden | OMB Director | Shalanda Young | 3/17/22 | Still in office | Female | ||||
373 | 373 | Biden | Director of National Intelligence | Avril Haines | 1/21/21 | Still in office | Female | ||||
374 | 374 | Biden | U.S. Trade Representative | Katherine Tai | 3/18/21 | Still in office | Female | ||||
375 | 375 | Biden | UN Ambassador | Linda Thomas-Greenfield | 2/24/21 | Still in office | Female | ||||
376 | 376 | Biden | CEA Chair | Cecilia Rouse | 3/12/21 | Still in office | Female | ||||
377 | 377 | Biden | SBA Administrator | Isabel Guzman | 3/17/21 | Still in office | Female | ||||
378 | 378 | Biden | OSTP Director | Arati Prabhakar | 10/1/22 | Still in office | Female | ||||
379 | 379 | Biden | Chief of Staff | Jeff Zients | 2/8/23 | Still in office | Male | ||||
341 | 341 | Trump | Secretary of State | Mike Pompeo | 4/26/18 | 1/20/21 | 1000 | 1462 | Male | ||
327 | 327 | Trump | Secretary of Energy | Rick Perry | 3/2/17 | 12/1/19 | 1004 | 1046 | Male | ||
192 | 192 | Bush 43 | UN Ambassador | John Negroponte | 9/19/01 | 6/23/04 | 1008 | 1251 | Male | ||
56 | 56 | Reagan | Secretary of Health & Human Services | Margaret Heckler | 3/9/83 | 12/13/85 | 1010 | 1789 | Female | ||
10 | 10 | Carter | Secretary of Commerce | Juanita Kreps | 1/23/77 | 10/31/79 | 1011 | 1015 | Female | ||
231 | 231 | Bush 43 | Chief of Staff | Josh Bolten | 4/14/06 | 1/20/09 | 1012 | 2923 | Male | ||
43 | 43 | Reagan | Secretary of the Interior | James Watt | 1/23/81 | 11/8/83 | 1019 | 1023 | Male | ||
302 | 302 | Obama | SBA Administrator | Maria Contreras-Sweet | 4/7/14 | 1/20/17 | 1019 | 2923 | Female | ||
211 | 211 | Bush 43 | OMB Director | Josh Bolten | 6/26/03 | 4/14/06 | 1023 | 1911 | Male | ||
101 | 101 | Bush 41 | Secretary of Transportation | Sam Skinner | 2/6/89 | 12/13/91 | 1040 | 1058 | Male | ||
75 | 75 | Reagan | Secretary of Agriculture | Richard Edmund Lyng | 3/7/86 | 1/20/89 | 1050 | 2923 | Male | ||
191 | 191 | Bush 43 | Secretary of Housing & Urban Development | Mel Martinez | 1/24/01 | 12/12/03 | 1052 | 1057 | Male | ||
230 | 230 | Bush 43 | CEA Chair | Edward Lazear | 2/27/06 | 1/20/09 | 1058 | 2923 | Male | ||
102 | 102 | Bush 41 | Chief of Staff | John Sununu | 1/20/89 | 12/15/91 | 1059 | 1060 | Male | ||
207 | 207 | Bush 43 | CEA Chair | Harvey Rosen | 2/23/05 | 6/10/05 | 107 | 1603 | Male | ||
103 | 103 | Bush 41 | Secretary of Commerce | Robert Mosbacher | 1/31/89 | 1/15/92 | 1079 | 1091 | Male | ||
150 | 150 | Clinton | Secretary of Defense | William Perry | 2/3/94 | 1/23/97 | 1085 | 1465 | Male | ||
340 | 340 | Trump | Secretary of Health & Human Services | Alex Azar | 1/29/18 | 1/20/21 | 1087 | 1462 | 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 | ||
70 | 70 | Reagan | OMB Director | Jim Miller | 10/8/85 | 10/15/88 | 1103 | 2826 | Male | ||
301 | 301 | Obama | Secretary of Homeland Security | Jeh Johnson | 12/23/13 | 1/20/17 | 1124 | 2923 | Male | ||
78 | 78 | Reagan | Secretary of Health & Human Services | Otis Bowen | 12/13/85 | 1/20/89 | 1134 | 2923 | Male | ||
328 | 328 | Trump | OMB Director | Mick Mulvaney | 2/16/17 | 3/31/20 | 1139 | 1167 | Male | ||
104 | 104 | Bush 41 | UN Ambassador | Tom Pickering | 3/20/89 | 5/7/92 | 1144 | 1204 | Male | ||
139 | 139 | Clinton | Secretary of Commerce | Ron Brown | 1/22/93 | 4/3/96 | 1167 | 1170 | Male | ||
140 | 140 | Clinton | U.S. Trade Representative | Mickey Kantor | 1/22/93 | 4/12/96 | 1176 | 1179 | Male | ||
11 | 11 | Carter | Secretary of State | Cyrus Vance | 1/23/77 | 4/28/80 | 1191 | 1195 | Male | ||
129 | 129 | Bush 41 | OSTP Director | D. Allan Bromley | 10/13/89 | 1/20/93 | 1195 | 1462 | Male | ||
21 | 21 | Carter | OMB Director | Jim McIntyre | 9/24/77 | 1/20/81 | 1214 | 1462 | Male | ||
214 | 214 | Bush 43 | Secretary of the Treasury | John Snow | 2/3/03 | 6/29/06 | 1242 | 1987 | Male | ||
285 | 285 | Obama | CEA Chair | Jason Furman | 8/4/13 | 1/18/17 | 1263 | 2921 | Male | ||
67 | 67 | Reagan | Attorney General | Ed Meese | 2/25/85 | 8/12/88 | 1264 | 2762 | Male | ||
309 | 309 | Obama | UN Ambassador | Samantha Power | 8/5/13 | 1/21/17 | 1265 | 2924 | Female | ||
162 | 162 | Clinton | Secretary of Commerce | Bill Daley | 1/30/97 | 7/19/00 | 1266 | 2738 | 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 | ||
68 | 68 | Reagan | Secretary of the Treasury | James Baker | 2/3/85 | 8/17/88 | 1291 | 2767 | Male | ||
107 | 107 | Bush 41 | Secretary of Veterans Affairs | Ed Derwinski | 3/15/89 | 9/26/92 | 1291 | 1346 | Male | ||
298 | 298 | Obama | Secretary of Transportation | Anthony Foxx | 7/2/13 | 1/20/17 | 1298 | 2923 | Male | ||
84 | 84 | Reagan | U.S. Trade Representative | Clayton Yeutter | 7/1/85 | 1/20/89 | 1299 | 2923 | Male | ||
297 | 297 | Obama | Secretary of Commerce | Penny Pritzker | 6/26/13 | 1/20/17 | 1304 | 2923 | Female | ||
106 | 106 | Bush 41 | Secretary of State | James Baker | 1/25/89 | 8/23/92 | 1306 | 1312 | Male | ||
296 | 296 | Obama | U.S. Trade Representative | Michael Froman | 6/21/13 | 1/20/17 | 1309 | 2923 | Male | ||
69 | 69 | Reagan | Secretary of Education | Bill Bennett | 2/6/85 | 9/20/88 | 1322 | 2801 | Male | ||
35 | 35 | Carter | OSTP Director | Frank Press | 6/1/77 | 1/20/81 | 1329 | 1462 | Male | ||
295 | 295 | Obama | Secretary of Energy | Ernest Moniz | 5/21/13 | 1/20/17 | 1340 | 2923 | Male | ||
339 | 339 | Trump | U.S. Trade Representative | Robert Lighthizer | 5/15/17 | 1/20/21 | 1346 | 1462 | Male | ||
232 | 232 | Bush 43 | EPA Administrator | Stephen Johnson | 5/2/05 | 1/20/09 | 1359 | 2923 | Male | ||
180 | 180 | Clinton | Secretary of Labor | Alexis Herman | 5/1/97 | 1/20/01 | 1360 | 2923 | Female | ||
338 | 338 | Trump | Secretary of Agriculture | Sonny Perdue | 4/25/17 | 1/20/21 | 1366 | 1462 | Male | ||
71 | 71 | Reagan | CEA Chair | Beryl Sprinkel | 4/18/85 | 1/20/89 | 1373 | 2923 | Male | ||
294 | 294 | Obama | Secretary of the Interior | Sally Jewell | 4/12/13 | 1/20/17 | 1379 | 2923 | Female | ||
22 | 22 | Carter | SBA Administrator | A. Vernon Weaver | 4/1/77 | 1/20/81 | 1390 | 1462 | Male | ||
87 | 87 | Reagan | UN Ambassador | Vernon Walters | 5/22/85 | 3/15/89 | 1393 | 2977 | Male | ||
120 | 120 | Bush 41 | Secretary of Defense | Dick Cheney | 3/21/89 | 1/20/93 | 1401 | 1462 | Male | ||
183 | 183 | Clinton | U.S. Trade Representative | Charlene Barshefsky | 3/18/97 | 1/20/01 | 1404 | 2923 | Female | ||
19 | 19 | Carter | Director of Central Intelligence | Stansfield Turner | 3/9/77 | 1/20/81 | 1413 | 1462 | Male | ||
293 | 293 | Obama | CIA Director | John Brennan | 3/8/13 | 1/20/17 | 1414 | 2923 | Male | ||
20 | 20 | Carter | EPA Administrator | Douglas Costle | 3/7/77 | 1/20/81 | 1415 | 1462 | Male | ||
174 | 174 | Clinton | SBA Administrator | Aida Alvarez | 3/7/97 | 1/20/01 | 1415 | 2923 | Female | ||
337 | 337 | Trump | Secretary of Housing & Urban Development | Ben Carson | 3/2/17 | 1/20/21 | 1420 | 1462 | Male | ||
122 | 122 | Bush 41 | Secretary of Energy | James Watkins | 3/1/89 | 1/20/93 | 1421 | 1462 | Male | ||
123 | 123 | Bush 41 | Secretary of Health & Human Services | Louis Sullivan | 3/1/89 | 1/20/93 | 1421 | 1462 | Male | ||
292 | 292 | Obama | Secretary of the Treasury | Jack Lew | 2/28/13 | 1/20/17 | 1422 | 2923 | Male | ||
336 | 336 | Trump | Secretary of Commerce | Wilbur Ross | 2/28/17 | 1/20/21 | 1422 | 1462 | Male | ||
263 | 263 | Obama | Secretary of Labor | Hilda Solis | 2/24/09 | 1/22/13 | 1428 | 1464 | Female | ||
331 | 331 | Trump | Secretary of Education | Betsy DeVos | 2/7/17 | 1/8/21 | 1431 | 1450 | Female | ||
111 | 111 | Bush 41 | Secretary of Housing & Urban Development | Jack Kemp | 2/13/89 | 1/19/93 | 1436 | 1461 | Male | ||
182 | 182 | Clinton | Secretary of Transportation | Rodney Slater | 2/14/97 | 1/20/01 | 1436 | 2923 | Male | ||
246 | 246 | Bush 43 | Secretary of Homeland Security | Michael Chertoff | 2/15/05 | 1/21/09 | 1436 | 2924 | Male | ||
335 | 335 | Trump | Secretary of the Treasury | Steve Mnuchin | 2/13/17 | 1/20/21 | 1437 | 1462 | Male | ||
45 | 45 | Reagan | Secretary of Education | T.H. Bell | 1/23/81 | 12/31/84 | 1438 | 1442 | Male | ||
108 | 108 | Bush 41 | CEA Chair | Michael Boskin | 2/2/89 | 1/12/93 | 1440 | 1454 | Male | ||
332 | 332 | Trump | Secretary of Transportation | Elaine Chao | 1/31/17 | 1/11/21 | 1441 | 1453 | Female |
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 );