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 appointee
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
22 | 22 | Carter | SBA Administrator | A. Vernon Weaver | 4/1/77 | 1/20/81 | 1390 | 1462 | Male | ||
174 | 174 | Clinton | SBA Administrator | Aida Alvarez | 3/7/97 | 1/20/01 | 1415 | 2923 | Female | ||
184 | 184 | Clinton | Vice President | Al Gore | 1/20/93 | 1/20/01 | 2922 | 2923 | Male | ||
274 | 274 | Obama | CEA Chair | Alan Krueger | 11/7/11 | 8/2/13 | 634 | 1656 | Male | ||
221 | 221 | Bush 43 | Attorney General | Alberto Gonzales | 2/3/05 | 9/17/07 | 956 | 2432 | Male | ||
370 | 370 | Biden | Secretary of Homeland Security | Alejandro Mayorkas | 2/2/21 | Still in office | Male | ||||
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 | ||
37 | 37 | Reagan | Secretary of State | Alexander Haig | 1/22/81 | 7/5/82 | 529 | 532 | Male | ||
180 | 180 | Clinton | Secretary of Labor | Alexis Herman | 5/1/97 | 1/20/01 | 1360 | 2923 | Female | ||
141 | 141 | Clinton | OMB Director | Alice Rivlin | 10/17/94 | 4/26/96 | 557 | 1193 | Female | ||
224 | 224 | Bush 43 | Secretary of Housing & Urban Development | Alphonso Jackson | 3/31/04 | 4/18/08 | 1479 | 2646 | Male | ||
179 | 179 | Clinton | Secretary of Housing & Urban Development | Andrew Cuomo | 1/29/97 | 1/20/01 | 1452 | 2923 | Male | ||
344 | 344 | Trump | EPA Administrator | Andrew Wheeler | 2/28/19 | 1/20/21 | 692 | 1462 | Male | ||
9 | 9 | Carter | UN Ambassador | Andrew Young | 1/30/77 | 9/23/79 | 966 | 977 | Male | ||
126 | 126 | Bush 41 | Secretary of Transportation | Andy Card | 3/11/92 | 1/20/93 | 315 | 1462 | Male | ||
210 | 210 | Bush 43 | Chief of Staff | Andy Card | 1/20/01 | 4/14/06 | 1910 | 1911 | Male | ||
80 | 80 | Reagan | Secretary of Labor | Ann McLaughlin | 12/14/87 | 1/20/89 | 403 | 2923 | Female | ||
194 | 194 | Bush 43 | Secretary of Agriculture | Ann Veneman | 1/20/01 | 1/20/05 | 1461 | 1462 | Female | ||
42 | 42 | Reagan | EPA Administrator | Anne Gorsuch | 5/20/81 | 3/9/83 | 658 | 779 | Female | ||
298 | 298 | Obama | Secretary of Transportation | Anthony Foxx | 7/2/13 | 1/20/17 | 1298 | 2923 | Male | ||
200 | 200 | Bush 43 | Secretary of Veterans Affairs | Anthony Principi | 1/23/01 | 1/26/05 | 1464 | 1468 | Male | ||
356 | 356 | Biden | Secretary of State | Antony Blinken | 1/26/21 | Still in office | Male | ||||
378 | 378 | Biden | OSTP Director | Arati Prabhakar | 10/1/22 | Still in office | Female | ||||
283 | 283 | Obama | Secretary of Education | Arne Duncan | 1/20/09 | 12/31/15 | 2536 | 2537 | Male | ||
286 | 286 | Obama | Secretary of Defense | Ash Carter | 2/17/15 | 1/19/17 | 702 | 2922 | Male | ||
258 | 258 | Obama | CEA Chair | Austan Goolsbee | 9/10/10 | 8/5/11 | 329 | 928 | Male | ||
373 | 373 | Biden | Director of National Intelligence | Avril Haines | 1/21/21 | Still in office | Female | ||||
119 | 119 | Bush 41 | Secretary of Commerce | Barbara Franklin | 2/27/92 | 1/20/93 | 328 | 1462 | Female | ||
208 | 208 | Bush 43 | CEA Chair | Ben Bernanke | 6/21/05 | 1/31/06 | 224 | 1838 | Male | ||
337 | 337 | Trump | Secretary of Housing & Urban Development | Ben Carson | 3/2/17 | 1/20/21 | 1420 | 1462 | Male | ||
15 | 15 | Carter | Attorney General | Ben Civiletti | 8/16/79 | 1/19/81 | 522 | 1461 | Male | ||
1 | 1 | Carter | OMB Director | Bert Lance | 1/21/77 | 9/23/77 | 245 | 247 | Male | ||
71 | 71 | Reagan | CEA Chair | Beryl Sprinkel | 4/18/85 | 1/20/89 | 1373 | 2923 | Male | ||
331 | 331 | Trump | Secretary of Education | Betsy DeVos | 2/7/17 | 1/8/21 | 1431 | 1450 | Female | ||
69 | 69 | Reagan | Secretary of Education | Bill Bennett | 2/6/85 | 9/20/88 | 1322 | 2801 | Male | ||
54 | 54 | Reagan | U.S. Trade Representative | Bill Brock | 1/23/81 | 4/29/85 | 1557 | 1561 | Male | ||
64 | 64 | Reagan | Secretary of Labor | Bill Brock | 4/29/85 | 10/31/87 | 915 | 2476 | Male | ||
162 | 162 | Clinton | Secretary of Commerce | Bill Daley | 1/30/97 | 7/19/00 | 1266 | 2738 | Male | ||
260 | 260 | Obama | Chief of Staff | Bill Daley | 1/13/11 | 1/27/12 | 379 | 1103 | Male | ||
158 | 158 | Clinton | UN Ambassador | Bill Richardson | 2/18/97 | 8/18/98 | 546 | 2037 | Male | ||
177 | 177 | Clinton | Secretary of Energy | Bill Richardson | 8/18/98 | 1/20/01 | 886 | 2923 | 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 | ||
250 | 250 | Bush 43 | Secretary of Defense | Bob Gates | 12/18/06 | Obama admin | 1655 combined | Male | |||
256 | 256 | Obama | Secretary of Defense | Bob Gates | Bush admin | 6/30/11 | 1655 combined | 892 | Male | ||
306 | 306 | Obama | Secretary of Veterans Affairs | Bob McDonald | 7/30/14 | 1/20/17 | 905 | 2923 | Male | ||
160 | 160 | Clinton | Secretary of the Treasury | Bob Rubin | 1/10/95 | 7/2/99 | 1634 | 2355 | Male | ||
2 | 2 | Carter | Secretary of Transportation | Brock Adams | 1/23/77 | 7/20/79 | 908 | 912 | Male | ||
164 | 164 | Clinton | Secretary of the Interior | Bruce Babbitt | 1/22/93 | 1/2/01 | 2902 | 2905 | Male | ||
127 | 127 | Bush 41 | U.S. Trade Representative | Carla Hills | 2/6/89 | 1/20/93 | 1444 | 1462 | Female | ||
227 | 227 | Bush 43 | Secretary of Commerce | Carlos Gutierrez | 2/7/05 | 1/19/09 | 1442 | 2922 | Male | ||
166 | 166 | Clinton | EPA Administrator | Carol Browner | 1/22/93 | 1/19/01 | 2919 | 2922 | Female | ||
65 | 65 | Reagan | Secretary of Defense | Caspar Weinberger | 1/21/81 | 11/23/87 | 2497 | 2499 | Male | ||
30 | 30 | Carter | Secretary of the Interior | Cecil Andrus | 1/23/77 | 1/20/81 | 1458 | 1462 | Male | ||
376 | 376 | Biden | CEA Chair | Cecilia Rouse | 3/12/21 | Still in office | Female | ||||
183 | 183 | Clinton | U.S. Trade Representative | Charlene Barshefsky | 3/18/97 | 1/20/01 | 1404 | 2923 | Female | ||
26 | 26 | Carter | Secretary of Energy | Charles Duncan | 8/24/79 | 1/20/81 | 515 | 1462 | Male | ||
17 | 17 | Carter | CEA Chair | Charles Schultze | 1/22/77 | 1/20/81 | 1459 | 1462 | Male | ||
253 | 253 | Obama | CEA Chair | Christina Romer | 1/29/09 | 9/3/10 | 582 | 592 | Female | ||
190 | 190 | Bush 43 | EPA Administrator | Christine Todd Whitman | 1/31/01 | 6/27/03 | 877 | 889 | Female | ||
281 | 281 | Obama | Secretary of Defense | Chuck Hagel | 2/27/13 | 2/17/15 | 720 | 2220 | Male | ||
84 | 84 | Reagan | U.S. Trade Representative | Clayton Yeutter | 7/1/85 | 1/20/89 | 1299 | 2923 | Male | ||
97 | 97 | Bush 41 | Secretary of Agriculture | Clayton Yeutter | 2/16/89 | 3/1/91 | 743 | 771 | Male | ||
198 | 198 | Bush 43 | Secretary of State | Colin Powell | 1/20/01 | 1/25/05 | 1466 | 1467 | Male | ||
239 | 239 | Bush 43 | Secretary of State | Condoleezza Rice | 1/26/05 | 1/20/09 | 1455 | 2923 | Female | ||
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 | ||
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 | ||
168 | 168 | Clinton | Secretary of Agriculture | Dan Glickman | 3/30/95 | 1/19/01 | 2122 | 2922 | Male | ||
128 | 128 | Bush 41 | Vice President | Dan Quayle | 1/20/89 | 1/20/93 | 1461 | 1462 | Male | ||
345 | 345 | Trump | Secretary of the Interior | David Bernhardt | 4/11/19 | 1/20/21 | 650 | 1462 | Male | ||
262 | 262 | Obama | CIA Director | David Petraeus | 9/6/11 | 11/9/12 | 430 | 1390 | Male | ||
313 | 313 | Trump | Secretary of Veterans Affairs | David Shulkin | 2/14/17 | 3/28/18 | 407 | 433 | Male | ||
55 | 55 | Reagan | OMB Director | David Stockman | 1/21/81 | 8/1/85 | 1653 | 1655 | Male | ||
360 | 360 | Biden | Secretary of the Interior | Deb Haaland | 3/16/21 | Still in office | Female | ||||
290 | 290 | Obama | Chief of Staff | Denis McDonough | 1/25/13 | 1/20/17 | 1456 | 2923 | Male | ||
369 | 369 | Biden | Secretary of Veterans Affairs | Denis McDonough | 2/9/21 | Still in office | Male | ||||
251 | 251 | Obama | Director of National Intelligence | Dennis Blair | 1/29/09 | 5/28/10 | 484 | 494 | Male | ||
120 | 120 | Bush 41 | Secretary of Defense | Dick Cheney | 3/21/89 | 1/20/93 | 1401 | 1462 | Male | ||
244 | 244 | Bush 43 | Vice President | Dick Cheney | 1/20/01 | 1/20/09 | 2922 | 2923 | Male | ||
116 | 116 | Bush 41 | OMB Director | Dick Darman | 1/25/89 | 1/20/93 | 1456 | 1462 | Male | ||
176 | 176 | Clinton | Secretary of Education | Dick Riley | 1/21/93 | 1/20/01 | 2921 | 2923 | 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 | ||
228 | 228 | Bush 43 | Secretary of the Interior | Dirk Kempthorne | 5/29/06 | 1/19/09 | 966 | 2922 | Male | ||
47 | 47 | Reagan | Secretary of the Treasury | Don Regan | 1/22/81 | 2/2/85 | 1472 | 1475 | Male | ||
61 | 61 | Reagan | Chief of Staff | Don Regan | 2/4/85 | 2/27/87 | 753 | 2230 | Male | ||
204 | 204 | Bush 43 | Secretary of Commerce | Donald Evans | 1/20/01 | 2/3/05 | 1475 | 1476 | Male | ||
49 | 49 | Reagan | Secretary of Energy | Donald Hodel | 11/5/82 | 2/7/85 | 825 | 1480 | Male | ||
82 | 82 | Reagan | Secretary of the Interior | Donald Hodel | 2/8/85 | 1/20/89 | 1442 | 2923 | Male | ||
33 | 33 | Carter | UN Ambassador | Donald McHenry | 9/23/79 | 1/20/81 | 485 | 1462 | Male | ||
217 | 217 | Bush 43 | Secretary of Defense | Donald Rumsfeld | 1/20/01 | 12/18/06 | 2158 | 2159 | Male | ||
178 | 178 | Clinton | Secretary of Health & Human Services | Donna Shalala | 1/22/93 | 1/20/01 | 2920 | 2923 | Female | ||
20 | 20 | Carter | EPA Administrator | Douglas Costle | 3/7/77 | 1/20/81 | 1415 | 1462 | Male | ||
40 | 40 | Reagan | Secretary of Transportation | Drew Lewis | 1/23/81 | 2/1/83 | 739 | 743 | Male | ||
107 | 107 | Bush 41 | Secretary of Veterans Affairs | Ed Derwinski | 3/15/89 | 9/26/92 | 1291 | 1346 | Male | ||
118 | 118 | Bush 41 | Secretary of Agriculture | Ed Madigan | 3/12/91 | 1/20/93 | 680 | 1462 | 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 );