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 position
This data as json, copyable, CSV (advanced)
Link | rowid | president | position ▼ | appointee | start_date | end_date | length | departure_day | gender | Unnamed: 8 | Unnamed: 9 |
---|---|---|---|---|---|---|---|---|---|---|---|
302 | 302 | Obama | SBA Administrator | Maria Contreras-Sweet | 4/7/14 | 1/20/17 | 1019 | 2923 | Female | ||
323 | 323 | Trump | SBA Administrator | Linda McMahon | 2/14/17 | 4/12/19 | 787 | 813 | Female | ||
349 | 349 | Trump | SBA Administrator | Jovita Carranza | 1/14/20 | 1/20/21 | 372 | 1462 | Female | ||
377 | 377 | Biden | SBA Administrator | Isabel Guzman | 3/17/21 | Still in office | Female | ||||
23 | 23 | Carter | Secretary of Agriculture | Robert Bergland | 1/23/77 | 1/20/81 | 1458 | 1462 | Male | ||
58 | 58 | Reagan | Secretary of Agriculture | John Block | 1/23/81 | 2/14/86 | 1848 | 1852 | Male | ||
75 | 75 | Reagan | Secretary of Agriculture | Richard Edmund Lyng | 3/7/86 | 1/20/89 | 1050 | 2923 | Male | ||
97 | 97 | Bush 41 | Secretary of Agriculture | Clayton Yeutter | 2/16/89 | 3/1/91 | 743 | 771 | Male | ||
118 | 118 | Bush 41 | Secretary of Agriculture | Ed Madigan | 3/12/91 | 1/20/93 | 680 | 1462 | Male | ||
136 | 136 | Clinton | Secretary of Agriculture | Mike Espy | 1/22/93 | 12/31/94 | 708 | 711 | Male | ||
168 | 168 | Clinton | Secretary of Agriculture | Dan Glickman | 3/30/95 | 1/19/01 | 2122 | 2922 | Male | ||
194 | 194 | Bush 43 | Secretary of Agriculture | Ann Veneman | 1/20/01 | 1/20/05 | 1461 | 1462 | Female | ||
222 | 222 | Bush 43 | Secretary of Agriculture | Mike Johanns | 1/21/05 | 9/20/07 | 972 | 2435 | Male | ||
233 | 233 | Bush 43 | Secretary of Agriculture | Ed Schafer | 1/28/08 | 1/20/09 | 358 | 2923 | Male | ||
284 | 284 | Obama | Secretary of Agriculture | Tom Vilsack | 1/20/09 | 1/13/17 | 2915 | 2916 | Male | ||
338 | 338 | Trump | Secretary of Agriculture | Sonny Perdue | 4/25/17 | 1/20/21 | 1366 | 1462 | Male | ||
361 | 361 | Biden | Secretary of Agriculture | Tom Vilsack | 2/24/21 | Still in office | Male | ||||
10 | 10 | Carter | Secretary of Commerce | Juanita Kreps | 1/23/77 | 10/31/79 | 1011 | 1015 | Female | ||
16 | 16 | Carter | Secretary of Commerce | Philip Klutznick | 1/9/80 | 1/19/81 | 376 | 1461 | Male | ||
62 | 62 | Reagan | Secretary of Commerce | Mac Baldrige | 1/20/81 | 7/25/87 | 2377 | 2378 | Male | ||
86 | 86 | Reagan | Secretary of Commerce | William Verity Jr. | 10/19/87 | 1/30/89 | 469 | 2933 | Male | ||
103 | 103 | Bush 41 | Secretary of Commerce | Robert Mosbacher | 1/31/89 | 1/15/92 | 1079 | 1091 | Male | ||
119 | 119 | Bush 41 | Secretary of Commerce | Barbara Franklin | 2/27/92 | 1/20/93 | 328 | 1462 | Female | ||
139 | 139 | Clinton | Secretary of Commerce | Ron Brown | 1/22/93 | 4/3/96 | 1167 | 1170 | Male | ||
148 | 148 | Clinton | Secretary of Commerce | Mickey Kantor | 4/12/96 | 1/21/97 | 284 | 1463 | Male | ||
162 | 162 | Clinton | Secretary of Commerce | Bill Daley | 1/30/97 | 7/19/00 | 1266 | 2738 | Male | ||
169 | 169 | Clinton | Secretary of Commerce | Norman Mineta | 7/21/00 | 1/19/01 | 182 | 2922 | Male | ||
204 | 204 | Bush 43 | Secretary of Commerce | Donald Evans | 1/20/01 | 2/3/05 | 1475 | 1476 | Male | ||
227 | 227 | Bush 43 | Secretary of Commerce | Carlos Gutierrez | 2/7/05 | 1/19/09 | 1442 | 2922 | Male | ||
257 | 257 | Obama | Secretary of Commerce | Gary Locke | 3/26/09 | 8/1/11 | 858 | 924 | Male | ||
261 | 261 | Obama | Secretary of Commerce | John Bryson | 10/21/11 | 6/21/12 | 244 | 1249 | Male | ||
297 | 297 | Obama | Secretary of Commerce | Penny Pritzker | 6/26/13 | 1/20/17 | 1304 | 2923 | Female | ||
336 | 336 | Trump | Secretary of Commerce | Wilbur Ross | 2/28/17 | 1/20/21 | 1422 | 1462 | Male | ||
362 | 362 | Biden | Secretary of Commerce | Gina Raimondo | 3/3/21 | Still in office | Female | ||||
24 | 24 | Carter | Secretary of Defense | Harold Brown | 1/21/77 | 1/20/81 | 1460 | 1462 | Male | ||
65 | 65 | Reagan | Secretary of Defense | Caspar Weinberger | 1/21/81 | 11/23/87 | 2497 | 2499 | Male | ||
76 | 76 | Reagan | Secretary of Defense | Frank Carlucci | 11/23/87 | 1/20/89 | 424 | 2923 | Male | ||
120 | 120 | Bush 41 | Secretary of Defense | Dick Cheney | 3/21/89 | 1/20/93 | 1401 | 1462 | Male | ||
131 | 131 | Clinton | Secretary of Defense | Les Aspin | 1/21/93 | 2/3/94 | 378 | 380 | Male | ||
150 | 150 | Clinton | Secretary of Defense | William Perry | 2/3/94 | 1/23/97 | 1085 | 1465 | Male | ||
175 | 175 | Clinton | Secretary of Defense | William Cohen | 1/24/97 | 1/20/01 | 1457 | 2923 | Male | ||
217 | 217 | Bush 43 | Secretary of Defense | Donald Rumsfeld | 1/20/01 | 12/18/06 | 2158 | 2159 | 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 | ||
268 | 268 | Obama | Secretary of Defense | Leon Panetta | 7/1/11 | 2/26/13 | 606 | 1499 | Male | ||
281 | 281 | Obama | Secretary of Defense | Chuck Hagel | 2/27/13 | 2/17/15 | 720 | 2220 | Male | ||
286 | 286 | Obama | Secretary of Defense | Ash Carter | 2/17/15 | 1/19/17 | 702 | 2922 | Male | ||
318 | 318 | Trump | Secretary of Defense | Jim Mattis | 1/20/17 | 12/31/18 | 710 | 711 | Male | ||
329 | 329 | Trump | Secretary of Defense | Mark Esper | 7/23/19 | 11/9/20 | 475 | 1390 | Male | ||
358 | 358 | Biden | Secretary of Defense | Lloyd Austin | 1/22/21 | Still in office | Male | ||||
25 | 25 | Carter | Secretary of Education | Shirley Hufstedler | 12/6/79 | 1/20/81 | 411 | 1462 | Female | ||
45 | 45 | Reagan | Secretary of Education | T.H. Bell | 1/23/81 | 12/31/84 | 1438 | 1442 | Male | ||
69 | 69 | Reagan | Secretary of Education | Bill Bennett | 2/6/85 | 9/20/88 | 1322 | 2801 | Male | ||
92 | 92 | Reagan | Secretary of Education | Lauro Cavazos | 9/20/88 | Bush admin | 816 combined | Male | |||
96 | 96 | Bush 41 | Secretary of Education | Lauro Cavazos | Reagan admin | 12/15/90 | 816 combined | 695 | Male | ||
121 | 121 | Bush 41 | Secretary of Education | Lamar Alexander | 3/18/91 | 1/20/93 | 674 | 1462 | Male | ||
176 | 176 | Clinton | Secretary of Education | Dick Riley | 1/21/93 | 1/20/01 | 2921 | 2923 | Male | ||
195 | 195 | Bush 43 | Secretary of Education | Rod Paige | 1/24/01 | 1/20/05 | 1457 | 1462 | Male | ||
234 | 234 | Bush 43 | Secretary of Education | Margaret Spellings | 1/24/05 | 1/20/09 | 1457 | 2923 | Female | ||
283 | 283 | Obama | Secretary of Education | Arne Duncan | 1/20/09 | 12/31/15 | 2536 | 2537 | Male | ||
308 | 308 | Obama | Secretary of Education | John King Jr. | 3/14/16 | 1/20/17 | 312 | 2923 | Male | ||
331 | 331 | Trump | Secretary of Education | Betsy DeVos | 2/7/17 | 1/8/21 | 1431 | 1450 | Female | ||
368 | 368 | Biden | Secretary of Education | Miguel Cardona | 3/2/21 | Still in office | Male | ||||
8 | 8 | Carter | Secretary of Energy | James Schlesinger | 8/6/77 | 8/23/79 | 747 | 946 | Male | ||
26 | 26 | Carter | Secretary of Energy | Charles Duncan | 8/24/79 | 1/20/81 | 515 | 1462 | Male | ||
39 | 39 | Reagan | Secretary of Energy | James Edwards | 1/23/81 | 11/5/82 | 651 | 655 | Male | ||
49 | 49 | Reagan | Secretary of Energy | Donald Hodel | 11/5/82 | 2/7/85 | 825 | 1480 | Male | ||
77 | 77 | Reagan | Secretary of Energy | John Herrington | 2/7/85 | 1/20/89 | 1443 | 2923 | Male | ||
122 | 122 | Bush 41 | Secretary of Energy | James Watkins | 3/1/89 | 1/20/93 | 1421 | 1462 | Male | ||
147 | 147 | Clinton | Secretary of Energy | Hazel O'Leary | 1/22/93 | 1/20/97 | 1459 | 1462 | Female | ||
157 | 157 | Clinton | Secretary of Energy | Federico Peña | 3/12/97 | 6/30/98 | 475 | 1988 | Male | ||
177 | 177 | Clinton | Secretary of Energy | Bill Richardson | 8/18/98 | 1/20/01 | 886 | 2923 | Male | ||
201 | 201 | Bush 43 | Secretary of Energy | Spencer Abraham | 1/20/01 | 1/31/05 | 1472 | 1473 | Male | ||
235 | 235 | Bush 43 | Secretary of Energy | Samuel Bodman | 2/1/05 | 1/20/09 | 1449 | 2923 | Male | ||
271 | 271 | Obama | Secretary of Energy | Steven Chu | 1/21/09 | 4/22/13 | 1552 | 1554 | Male | ||
295 | 295 | Obama | Secretary of Energy | Ernest Moniz | 5/21/13 | 1/20/17 | 1340 | 2923 | Male | ||
327 | 327 | Trump | Secretary of Energy | Rick Perry | 3/2/17 | 12/1/19 | 1004 | 1046 | Male | ||
348 | 348 | Trump | Secretary of Energy | Dan Brouillette | 12/11/19 | 1/20/21 | 406 | 1462 | Male | ||
367 | 367 | Biden | Secretary of Energy | Jennifer Granholm | 2/25/21 | Still in office | Female | ||||
41 | 41 | Reagan | Secretary of Health & Human Services | Richard Schweiker | 1/22/81 | 2/3/83 | 742 | 745 | Male | ||
56 | 56 | Reagan | Secretary of Health & Human Services | Margaret Heckler | 3/9/83 | 12/13/85 | 1010 | 1789 | Female | ||
78 | 78 | Reagan | Secretary of Health & Human Services | Otis Bowen | 12/13/85 | 1/20/89 | 1134 | 2923 | Male | ||
123 | 123 | Bush 41 | Secretary of Health & Human Services | Louis Sullivan | 3/1/89 | 1/20/93 | 1421 | 1462 | Male | ||
178 | 178 | Clinton | Secretary of Health & Human Services | Donna Shalala | 1/22/93 | 1/20/01 | 2920 | 2923 | Female | ||
199 | 199 | Bush 43 | Secretary of Health & Human Services | Tommy Thompson | 2/2/01 | 1/26/05 | 1454 | 1468 | Male | ||
236 | 236 | Bush 43 | Secretary of Health & Human Services | Mike Leavitt | 1/26/05 | 1/20/09 | 1455 | 2923 | Male | ||
278 | 278 | Obama | Secretary of Health & Human Services | Kathleen Sebelius | 4/28/09 | 6/6/14 | 1865 | 1964 | Female | ||
303 | 303 | Obama | Secretary of Health & Human Services | Sylvia Burwell | 6/9/14 | 1/20/17 | 956 | 2923 | Female | ||
312 | 312 | Trump | Secretary of Health & Human Services | Tom Price | 2/10/17 | 9/29/17 | 231 | 253 | Male | ||
340 | 340 | Trump | Secretary of Health & Human Services | Alex Azar | 1/29/18 | 1/20/21 | 1087 | 1462 | Male | ||
364 | 364 | Biden | Secretary of Health & Human Services | Xavier Becerra | 3/19/21 | Still in office | Male | ||||
3 | 3 | Carter | Secretary of Health, Education & Welfare | Joseph Califano Jr. | 1/25/77 | 8/3/79 | 920 | 926 | Male | ||
27 | 27 | Carter | Secretary of Health, Education & Welfare/Secretary of Health & Human Services | Patricia Harris | 8/3/79 | 1/20/81 | 536 | 1462 | Female | ||
202 | 202 | Bush 43 | Secretary of Homeland Security | Tom Ridge | 1/24/03 | 2/1/05 | 739 | 1474 | Male | ||
246 | 246 | Bush 43 | Secretary of Homeland Security | Michael Chertoff | 2/15/05 | 1/21/09 | 1436 | 2924 | Male | ||
276 | 276 | Obama | Secretary of Homeland Security | Janet Napolitano | 1/21/09 | 9/6/13 | 1689 | 1691 | Female | ||
301 | 301 | Obama | Secretary of Homeland Security | Jeh Johnson | 12/23/13 | 1/20/17 | 1124 | 2923 | Male | ||
311 | 311 | Trump | Secretary of Homeland Security | John Kelly | 1/20/17 | 7/28/17 | 189 | 190 | Male | ||
322 | 322 | Trump | Secretary of Homeland Security | Kirstjen Nielsen | 12/6/17 | 4/7/19 | 487 | 808 | Female | ||
370 | 370 | Biden | Secretary of Homeland Security | Alejandro Mayorkas | 2/2/21 | Still in office | 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 );