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 start_date
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
160 | 160 | Clinton | Secretary of the Treasury | Bob Rubin | 1/10/95 | 7/2/99 | 1634 | 2355 | Male | ||
333 | 333 | Trump | OSTP Director | Kelvin Droegemeier | 1/11/19 | 1/20/21 | 740 | 1462 | Male | ||
260 | 260 | Obama | Chief of Staff | Bill Daley | 1/13/11 | 1/27/12 | 379 | 1103 | Male | ||
349 | 349 | Trump | SBA Administrator | Jovita Carranza | 1/14/20 | 1/20/21 | 372 | 1462 | Female | ||
194 | 194 | Bush 43 | Secretary of Agriculture | Ann Veneman | 1/20/01 | 1/20/05 | 1461 | 1462 | Female | ||
198 | 198 | Bush 43 | Secretary of State | Colin Powell | 1/20/01 | 1/25/05 | 1466 | 1467 | Male | ||
201 | 201 | Bush 43 | Secretary of Energy | Spencer Abraham | 1/20/01 | 1/31/05 | 1472 | 1473 | Male | ||
204 | 204 | Bush 43 | Secretary of Commerce | Donald Evans | 1/20/01 | 2/3/05 | 1475 | 1476 | Male | ||
210 | 210 | Bush 43 | Chief of Staff | Andy Card | 1/20/01 | 4/14/06 | 1910 | 1911 | Male | ||
217 | 217 | Bush 43 | Secretary of Defense | Donald Rumsfeld | 1/20/01 | 12/18/06 | 2158 | 2159 | Male | ||
244 | 244 | Bush 43 | Vice President | Dick Cheney | 1/20/01 | 1/20/09 | 2922 | 2923 | Male | ||
252 | 252 | Obama | OMB Director | Peter Orszag | 1/20/09 | 7/30/10 | 556 | 557 | Male | ||
254 | 254 | Obama | Chief of Staff | Rahm Emanuel | 1/20/09 | 10/1/10 | 619 | 620 | Male | ||
270 | 270 | Obama | Secretary of the Interior | Ken Salazar | 1/20/09 | 4/12/13 | 1543 | 1544 | Male | ||
283 | 283 | Obama | Secretary of Education | Arne Duncan | 1/20/09 | 12/31/15 | 2536 | 2537 | Male | ||
284 | 284 | Obama | Secretary of Agriculture | Tom Vilsack | 1/20/09 | 1/13/17 | 2915 | 2916 | Male | ||
288 | 288 | Obama | Vice President | Joe Biden | 1/20/09 | 1/20/17 | 2922 | 2923 | Male | ||
310 | 310 | Trump | Chief of Staff | Reince Priebus | 1/20/17 | 7/28/17 | 189 | 190 | Male | ||
311 | 311 | Trump | Secretary of Homeland Security | John Kelly | 1/20/17 | 7/28/17 | 189 | 190 | Male | ||
318 | 318 | Trump | Secretary of Defense | Jim Mattis | 1/20/17 | 12/31/18 | 710 | 711 | Male | ||
334 | 334 | Trump | Vice President | Mike Pence | 1/20/17 | 1/20/21 | 1461 | 1462 | Male | ||
354 | 354 | Biden | Chief of Staff | Ron Klain | 1/20/21 | 2/8/23 | 749 | 750 | Male | ||
355 | 355 | Biden | Vice President | Kamala Harris | 1/20/21 | Still in office | Female | ||||
34 | 34 | Carter | Vice President | Walter Mondale | 1/20/77 | 1/20/81 | 1461 | 1462 | Male | ||
48 | 48 | Reagan | Chief of Staff | James Baker | 1/20/81 | 2/3/85 | 1475 | 1476 | Male | ||
62 | 62 | Reagan | Secretary of Commerce | Mac Baldrige | 1/20/81 | 7/25/87 | 2377 | 2378 | Male | ||
85 | 85 | Reagan | Vice President | George H.W. Bush | 1/20/81 | 1/20/89 | 2922 | 2923 | Male | ||
102 | 102 | Bush 41 | Chief of Staff | John Sununu | 1/20/89 | 12/15/91 | 1059 | 1060 | Male | ||
128 | 128 | Bush 41 | Vice President | Dan Quayle | 1/20/89 | 1/20/93 | 1461 | 1462 | Male | ||
132 | 132 | Clinton | Chief of Staff | Mack McLarty | 1/20/93 | 7/17/94 | 543 | 544 | Male | ||
144 | 144 | Clinton | Secretary of State | Warren Christopher | 1/20/93 | 1/17/97 | 1458 | 1459 | Male | ||
184 | 184 | Clinton | Vice President | Al Gore | 1/20/93 | 1/20/01 | 2922 | 2923 | Male | ||
159 | 159 | Clinton | Chief of Staff | Erskine Bowles | 1/20/97 | 10/20/98 | 638 | 2100 | Male | ||
222 | 222 | Bush 43 | Secretary of Agriculture | Mike Johanns | 1/21/05 | 9/20/07 | 972 | 2435 | Male | ||
266 | 266 | Obama | Secretary of State | Hillary Clinton | 1/21/09 | 2/1/13 | 1472 | 1474 | Female | ||
271 | 271 | Obama | Secretary of Energy | Steven Chu | 1/21/09 | 4/22/13 | 1552 | 1554 | Male | ||
276 | 276 | Obama | Secretary of Homeland Security | Janet Napolitano | 1/21/09 | 9/6/13 | 1689 | 1691 | Female | ||
277 | 277 | Obama | Secretary of Veterans Affairs | Eric Shinseki | 1/21/09 | 5/30/14 | 1955 | 1957 | Male | ||
373 | 373 | Biden | Director of National Intelligence | Avril Haines | 1/21/21 | Still in office | Female | ||||
1 | 1 | Carter | OMB Director | Bert Lance | 1/21/77 | 9/23/77 | 245 | 247 | Male | ||
24 | 24 | Carter | Secretary of Defense | Harold Brown | 1/21/77 | 1/20/81 | 1460 | 1462 | Male | ||
55 | 55 | Reagan | OMB Director | David Stockman | 1/21/81 | 8/1/85 | 1653 | 1655 | Male | ||
65 | 65 | Reagan | Secretary of Defense | Caspar Weinberger | 1/21/81 | 11/23/87 | 2497 | 2499 | Male | ||
131 | 131 | Clinton | Secretary of Defense | Les Aspin | 1/21/93 | 2/3/94 | 378 | 380 | Male | ||
133 | 133 | Clinton | OMB Director | Leon Panetta | 1/21/93 | 7/17/94 | 542 | 544 | Male | ||
153 | 153 | Clinton | Secretary of Transportation | Federico Peña | 1/21/93 | 2/14/97 | 1485 | 1487 | Male | ||
176 | 176 | Clinton | Secretary of Education | Dick Riley | 1/21/93 | 1/20/01 | 2921 | 2923 | Male | ||
358 | 358 | Biden | Secretary of Defense | Lloyd Austin | 1/22/21 | Still in office | Male | ||||
17 | 17 | Carter | CEA Chair | Charles Schultze | 1/22/77 | 1/20/81 | 1459 | 1462 | Male | ||
37 | 37 | Reagan | Secretary of State | Alexander Haig | 1/22/81 | 7/5/82 | 529 | 532 | Male | ||
41 | 41 | Reagan | Secretary of Health & Human Services | Richard Schweiker | 1/22/81 | 2/3/83 | 742 | 745 | Male | ||
47 | 47 | Reagan | Secretary of the Treasury | Don Regan | 1/22/81 | 2/2/85 | 1472 | 1475 | Male | ||
135 | 135 | Clinton | Secretary of the Treasury | Lloyd Bentsen | 1/22/93 | 12/22/94 | 699 | 702 | Male | ||
136 | 136 | Clinton | Secretary of Agriculture | Mike Espy | 1/22/93 | 12/31/94 | 708 | 711 | 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 | ||
143 | 143 | Clinton | Secretary of Labor | Robert Reich | 1/22/93 | 1/10/97 | 1449 | 1452 | Male | ||
145 | 145 | Clinton | Secretary of Housing & Urban Development | Henry Cisneros | 1/22/93 | 1/19/97 | 1458 | 1461 | Male | ||
147 | 147 | Clinton | Secretary of Energy | Hazel O'Leary | 1/22/93 | 1/20/97 | 1459 | 1462 | Female | ||
164 | 164 | Clinton | Secretary of the Interior | Bruce Babbitt | 1/22/93 | 1/2/01 | 2902 | 2905 | Male | ||
166 | 166 | Clinton | EPA Administrator | Carol Browner | 1/22/93 | 1/19/01 | 2919 | 2922 | Female | ||
178 | 178 | Clinton | Secretary of Health & Human Services | Donna Shalala | 1/22/93 | 1/20/01 | 2920 | 2923 | Female | ||
189 | 189 | Bush 43 | OMB Director | Mitch Daniels | 1/23/01 | 6/6/03 | 864 | 868 | Male | ||
200 | 200 | Bush 43 | Secretary of Veterans Affairs | Anthony Principi | 1/23/01 | 1/26/05 | 1464 | 1468 | Male | ||
273 | 273 | Obama | Secretary of Transportation | Ray LaHood | 1/23/09 | 7/2/13 | 1621 | 1625 | Male | ||
315 | 315 | Trump | CIA Director | Mike Pompeo | 1/23/17 | 4/26/18 | 458 | 462 | Male | ||
2 | 2 | Carter | Secretary of Transportation | Brock Adams | 1/23/77 | 7/20/79 | 908 | 912 | Male | ||
4 | 4 | Carter | Secretary of Housing & Urban Development | Patricia Harris | 1/23/77 | 8/3/79 | 922 | 926 | Female | ||
5 | 5 | Carter | Secretary of the Treasury | W. Michael Blumenthal | 1/23/77 | 8/4/79 | 923 | 927 | Male | ||
10 | 10 | Carter | Secretary of Commerce | Juanita Kreps | 1/23/77 | 10/31/79 | 1011 | 1015 | Female | ||
11 | 11 | Carter | Secretary of State | Cyrus Vance | 1/23/77 | 4/28/80 | 1191 | 1195 | Male | ||
23 | 23 | Carter | Secretary of Agriculture | Robert Bergland | 1/23/77 | 1/20/81 | 1458 | 1462 | Male | ||
30 | 30 | Carter | Secretary of the Interior | Cecil Andrus | 1/23/77 | 1/20/81 | 1458 | 1462 | Male | ||
39 | 39 | Reagan | Secretary of Energy | James Edwards | 1/23/81 | 11/5/82 | 651 | 655 | Male | ||
40 | 40 | Reagan | Secretary of Transportation | Drew Lewis | 1/23/81 | 2/1/83 | 739 | 743 | Male | ||
43 | 43 | Reagan | Secretary of the Interior | James Watt | 1/23/81 | 11/8/83 | 1019 | 1023 | Male | ||
45 | 45 | Reagan | Secretary of Education | T.H. Bell | 1/23/81 | 12/31/84 | 1438 | 1442 | Male | ||
51 | 51 | Reagan | Attorney General | William French Smith | 1/23/81 | 2/25/85 | 1494 | 1498 | Male | ||
54 | 54 | Reagan | U.S. Trade Representative | Bill Brock | 1/23/81 | 4/29/85 | 1557 | 1561 | Male | ||
58 | 58 | Reagan | Secretary of Agriculture | John Block | 1/23/81 | 2/14/86 | 1848 | 1852 | Male | ||
79 | 79 | Reagan | Secretary of Housing & Urban Development | Samuel Pierce Jr. | 1/23/81 | 1/20/89 | 2919 | 2923 | Male | ||
154 | 154 | Clinton | Secretary of Veterans Affairs | Jesse Brown | 1/23/93 | 7/3/97 | 1622 | 1626 | Male | ||
170 | 170 | Clinton | Secretary of State | Madeleine Albright | 1/23/97 | 1/19/01 | 1457 | 2922 | Female | ||
191 | 191 | Bush 43 | Secretary of Housing & Urban Development | Mel Martinez | 1/24/01 | 12/12/03 | 1052 | 1057 | Male | ||
195 | 195 | Bush 43 | Secretary of Education | Rod Paige | 1/24/01 | 1/20/05 | 1457 | 1462 | Male | ||
202 | 202 | Bush 43 | Secretary of Homeland Security | Tom Ridge | 1/24/03 | 2/1/05 | 739 | 1474 | Male | ||
234 | 234 | Bush 43 | Secretary of Education | Margaret Spellings | 1/24/05 | 1/20/09 | 1457 | 2923 | Female | ||
175 | 175 | Clinton | Secretary of Defense | William Cohen | 1/24/97 | 1/20/01 | 1457 | 2923 | Male | ||
216 | 216 | Bush 43 | Secretary of Transportation | Norman Mineta | 1/25/01 | 7/7/06 | 1989 | 1995 | Male | ||
290 | 290 | Obama | Chief of Staff | Denis McDonough | 1/25/13 | 1/20/17 | 1456 | 2923 | Male | ||
319 | 319 | Trump | UN Ambassador | Nikki Haley | 1/25/17 | 12/31/18 | 705 | 711 | Female | ||
3 | 3 | Carter | Secretary of Health, Education & Welfare | Joseph Califano Jr. | 1/25/77 | 8/3/79 | 920 | 926 | Male | ||
95 | 95 | Bush 41 | Secretary of Labor | Elizabeth Dole | 1/25/89 | 11/23/90 | 667 | 673 | Female | ||
106 | 106 | Bush 41 | Secretary of State | James Baker | 1/25/89 | 8/23/92 | 1306 | 1312 | Male | ||
116 | 116 | Bush 41 | OMB Director | Dick Darman | 1/25/89 | 1/20/93 | 1456 | 1462 | Male | ||
236 | 236 | Bush 43 | Secretary of Health & Human Services | Mike Leavitt | 1/26/05 | 1/20/09 | 1455 | 2923 | Male | ||
239 | 239 | Bush 43 | Secretary of State | Condoleezza Rice | 1/26/05 | 1/20/09 | 1455 | 2923 | Female | ||
264 | 264 | Obama | Secretary of the Treasury | Tim Geithner | 1/26/09 | 1/25/13 | 1460 | 1467 | Male | ||
267 | 267 | Obama | EPA Administrator | Lisa Jackson | 1/26/09 | 2/14/13 | 1480 | 1487 | Female | ||
272 | 272 | Obama | UN Ambassador | Susan Rice | 1/26/09 | 6/30/13 | 1616 | 1623 | 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 );