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 gender
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
4 | 4 | Carter | Secretary of Housing & Urban Development | Patricia Harris | 1/23/77 | 8/3/79 | 922 | 926 | Female | ||
10 | 10 | Carter | Secretary of Commerce | Juanita Kreps | 1/23/77 | 10/31/79 | 1011 | 1015 | Female | ||
25 | 25 | Carter | Secretary of Education | Shirley Hufstedler | 12/6/79 | 1/20/81 | 411 | 1462 | Female | ||
27 | 27 | Carter | Secretary of Health, Education & Welfare/Secretary of Health & Human Services | Patricia Harris | 8/3/79 | 1/20/81 | 536 | 1462 | Female | ||
42 | 42 | Reagan | EPA Administrator | Anne Gorsuch | 5/20/81 | 3/9/83 | 658 | 779 | Female | ||
53 | 53 | Reagan | UN Ambassador | Jeane Kirkpatrick | 2/4/81 | 4/1/85 | 1517 | 1533 | Female | ||
56 | 56 | Reagan | Secretary of Health & Human Services | Margaret Heckler | 3/9/83 | 12/13/85 | 1010 | 1789 | Female | ||
63 | 63 | Reagan | Secretary of Transportation | Elizabeth Dole | 2/7/83 | 9/30/87 | 1696 | 2445 | Female | ||
80 | 80 | Reagan | Secretary of Labor | Ann McLaughlin | 12/14/87 | 1/20/89 | 403 | 2923 | Female | ||
95 | 95 | Bush 41 | Secretary of Labor | Elizabeth Dole | 1/25/89 | 11/23/90 | 667 | 673 | Female | ||
98 | 98 | Bush 41 | SBA Administrator | Susan Engeleiter | 4/20/89 | 3/27/91 | 706 | 797 | Female | ||
117 | 117 | Bush 41 | SBA Administrator | Pat Saiki | 3/27/91 | 1/20/93 | 665 | 1462 | Female | ||
119 | 119 | Bush 41 | Secretary of Commerce | Barbara Franklin | 2/27/92 | 1/20/93 | 328 | 1462 | Female | ||
124 | 124 | Bush 41 | Secretary of Labor | Lynn Morley Martin | 2/7/91 | 1/20/93 | 713 | 1462 | Female | ||
127 | 127 | Bush 41 | U.S. Trade Representative | Carla Hills | 2/6/89 | 1/20/93 | 1444 | 1462 | Female | ||
138 | 138 | Clinton | CEA Chair | Laura D'Andrea Tyson | 2/5/93 | 4/20/95 | 804 | 821 | Female | ||
141 | 141 | Clinton | OMB Director | Alice Rivlin | 10/17/94 | 4/26/96 | 557 | 1193 | Female | ||
147 | 147 | Clinton | Secretary of Energy | Hazel O'Leary | 1/22/93 | 1/20/97 | 1459 | 1462 | Female | ||
149 | 149 | Clinton | UN Ambassador | Madeleine Albright | 1/27/93 | 1/21/97 | 1455 | 1463 | Female | ||
161 | 161 | Clinton | CEA Chair | Janet Yellen | 2/18/97 | 8/3/99 | 896 | 2387 | Female | ||
166 | 166 | Clinton | EPA Administrator | Carol Browner | 1/22/93 | 1/19/01 | 2919 | 2922 | Female | ||
170 | 170 | Clinton | Secretary of State | Madeleine Albright | 1/23/97 | 1/19/01 | 1457 | 2922 | Female | ||
172 | 172 | Clinton | Attorney General | Janet Reno | 3/12/93 | 1/20/01 | 2871 | 2923 | Female | ||
174 | 174 | Clinton | SBA Administrator | Aida Alvarez | 3/7/97 | 1/20/01 | 1415 | 2923 | Female | ||
178 | 178 | Clinton | Secretary of Health & Human Services | Donna Shalala | 1/22/93 | 1/20/01 | 2920 | 2923 | Female | ||
180 | 180 | Clinton | Secretary of Labor | Alexis Herman | 5/1/97 | 1/20/01 | 1360 | 2923 | Female | ||
183 | 183 | Clinton | U.S. Trade Representative | Charlene Barshefsky | 3/18/97 | 1/20/01 | 1404 | 2923 | Female | ||
190 | 190 | Bush 43 | EPA Administrator | Christine Todd Whitman | 1/31/01 | 6/27/03 | 877 | 889 | Female | ||
194 | 194 | Bush 43 | Secretary of Agriculture | Ann Veneman | 1/20/01 | 1/20/05 | 1461 | 1462 | Female | ||
209 | 209 | Bush 43 | Secretary of the Interior | Gale Norton | 1/31/01 | 3/31/06 | 1885 | 1897 | Female | ||
234 | 234 | Bush 43 | Secretary of Education | Margaret Spellings | 1/24/05 | 1/20/09 | 1457 | 2923 | Female | ||
238 | 238 | Bush 43 | Secretary of Labor | Elaine Chao | 1/29/01 | 1/20/09 | 2913 | 2923 | Female | ||
239 | 239 | Bush 43 | Secretary of State | Condoleezza Rice | 1/26/05 | 1/20/09 | 1455 | 2923 | Female | ||
241 | 241 | Bush 43 | Secretary of Transportation | Mary Peters | 10/17/06 | 1/20/09 | 826 | 2923 | Female | ||
243 | 243 | Bush 43 | U.S. Trade Representative | Susan Schwab | 6/8/06 | 1/20/09 | 957 | 2923 | Female | ||
253 | 253 | Obama | CEA Chair | Christina Romer | 1/29/09 | 9/3/10 | 582 | 592 | Female | ||
263 | 263 | Obama | Secretary of Labor | Hilda Solis | 2/24/09 | 1/22/13 | 1428 | 1464 | Female | ||
266 | 266 | Obama | Secretary of State | Hillary Clinton | 1/21/09 | 2/1/13 | 1472 | 1474 | Female | ||
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 | ||
275 | 275 | Obama | SBA Administrator | Karen Mills | 4/6/09 | 9/1/13 | 1609 | 1686 | Female | ||
276 | 276 | Obama | Secretary of Homeland Security | Janet Napolitano | 1/21/09 | 9/6/13 | 1689 | 1691 | Female | ||
278 | 278 | Obama | Secretary of Health & Human Services | Kathleen Sebelius | 4/28/09 | 6/6/14 | 1865 | 1964 | Female | ||
279 | 279 | Obama | OMB Director | Sylvia Burwell | 4/26/13 | 6/8/14 | 408 | 1966 | Female | ||
294 | 294 | Obama | Secretary of the Interior | Sally Jewell | 4/12/13 | 1/20/17 | 1379 | 2923 | Female | ||
297 | 297 | Obama | Secretary of Commerce | Penny Pritzker | 6/26/13 | 1/20/17 | 1304 | 2923 | Female | ||
299 | 299 | Obama | EPA Administrator | Gina McCarthy | 7/19/13 | 1/20/17 | 1281 | 2923 | Female | ||
302 | 302 | Obama | SBA Administrator | Maria Contreras-Sweet | 4/7/14 | 1/20/17 | 1019 | 2923 | Female | ||
303 | 303 | Obama | Secretary of Health & Human Services | Sylvia Burwell | 6/9/14 | 1/20/17 | 956 | 2923 | Female | ||
307 | 307 | Obama | Attorney General | Loretta Lynch | 4/27/15 | 1/20/17 | 634 | 2923 | Female | ||
309 | 309 | Obama | UN Ambassador | Samantha Power | 8/5/13 | 1/21/17 | 1265 | 2924 | Female | ||
319 | 319 | Trump | UN Ambassador | Nikki Haley | 1/25/17 | 12/31/18 | 705 | 711 | Female | ||
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 | ||
331 | 331 | Trump | Secretary of Education | Betsy DeVos | 2/7/17 | 1/8/21 | 1431 | 1450 | Female | ||
332 | 332 | Trump | Secretary of Transportation | Elaine Chao | 1/31/17 | 1/11/21 | 1441 | 1453 | Female | ||
342 | 342 | Trump | CIA Director | Gina Haspel | 5/21/18 | 1/20/21 | 975 | 1462 | Female | ||
346 | 346 | Trump | UN Ambassador | Kelly Craft | 9/10/19 | 1/20/21 | 498 | 1462 | Female | ||
349 | 349 | Trump | SBA Administrator | Jovita Carranza | 1/14/20 | 1/20/21 | 372 | 1462 | Female | ||
355 | 355 | Biden | Vice President | Kamala Harris | 1/20/21 | Still in office | Female | ||||
357 | 357 | Biden | Secretary of the Treasury | Janet Yellen | 1/26/21 | Still in office | Female | ||||
360 | 360 | Biden | Secretary of the Interior | Deb Haaland | 3/16/21 | Still in office | Female | ||||
362 | 362 | Biden | Secretary of Commerce | Gina Raimondo | 3/3/21 | Still in office | Female | ||||
365 | 365 | Biden | Secretary of Housing & Urban Development | Marcia Fudge | 3/10/21 | Still in office | Female | ||||
367 | 367 | Biden | Secretary of Energy | Jennifer Granholm | 2/25/21 | Still in office | Female | ||||
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 | ||||
1 | 1 | Carter | OMB Director | Bert Lance | 1/21/77 | 9/23/77 | 245 | 247 | Male | ||
2 | 2 | Carter | Secretary of Transportation | Brock Adams | 1/23/77 | 7/20/79 | 908 | 912 | Male | ||
3 | 3 | Carter | Secretary of Health, Education & Welfare | Joseph Califano Jr. | 1/25/77 | 8/3/79 | 920 | 926 | Male | ||
5 | 5 | Carter | Secretary of the Treasury | W. Michael Blumenthal | 1/23/77 | 8/4/79 | 923 | 927 | Male | ||
6 | 6 | Carter | Attorney General | Griffin Bell | 1/26/77 | 8/16/79 | 932 | 939 | Male | ||
7 | 7 | Carter | U.S. Trade Representative | Robert Strauss | 3/30/77 | 8/17/79 | 870 | 940 | Male | ||
8 | 8 | Carter | Secretary of Energy | James Schlesinger | 8/6/77 | 8/23/79 | 747 | 946 | Male | ||
9 | 9 | Carter | UN Ambassador | Andrew Young | 1/30/77 | 9/23/79 | 966 | 977 | Male | ||
11 | 11 | Carter | Secretary of State | Cyrus Vance | 1/23/77 | 4/28/80 | 1191 | 1195 | Male | ||
12 | 12 | Carter | Chief of Staff | Hamilton Jordan | 7/18/79 | 6/11/80 | 329 | 1239 | Male | ||
13 | 13 | Carter | U.S. Trade Representative | Reubin Askew | 10/1/79 | 12/31/80 | 457 | 1442 | Male | ||
14 | 14 | Carter | Secretary of State | Ed Muskie | 5/8/80 | 1/18/81 | 255 | 1460 | Male | ||
15 | 15 | Carter | Attorney General | Ben Civiletti | 8/16/79 | 1/19/81 | 522 | 1461 | Male | ||
16 | 16 | Carter | Secretary of Commerce | Philip Klutznick | 1/9/80 | 1/19/81 | 376 | 1461 | Male | ||
17 | 17 | Carter | CEA Chair | Charles Schultze | 1/22/77 | 1/20/81 | 1459 | 1462 | Male | ||
18 | 18 | Carter | Chief of Staff | Jack Watson | 6/11/80 | 1/20/81 | 223 | 1462 | Male | ||
19 | 19 | Carter | Director of Central Intelligence | Stansfield Turner | 3/9/77 | 1/20/81 | 1413 | 1462 | Male | ||
20 | 20 | Carter | EPA Administrator | Douglas Costle | 3/7/77 | 1/20/81 | 1415 | 1462 | Male | ||
21 | 21 | Carter | OMB Director | Jim McIntyre | 9/24/77 | 1/20/81 | 1214 | 1462 | Male | ||
22 | 22 | Carter | SBA Administrator | A. Vernon Weaver | 4/1/77 | 1/20/81 | 1390 | 1462 | Male | ||
23 | 23 | Carter | Secretary of Agriculture | Robert Bergland | 1/23/77 | 1/20/81 | 1458 | 1462 | Male | ||
24 | 24 | Carter | Secretary of Defense | Harold Brown | 1/21/77 | 1/20/81 | 1460 | 1462 | Male | ||
26 | 26 | Carter | Secretary of Energy | Charles Duncan | 8/24/79 | 1/20/81 | 515 | 1462 | Male | ||
28 | 28 | Carter | Secretary of Housing & Urban Development | Moon Landrieu | 9/24/79 | 1/20/81 | 484 | 1462 | Male | ||
29 | 29 | Carter | Secretary of Labor | Ray Marshall | 1/27/77 | 1/20/81 | 1454 | 1462 | Male | ||
30 | 30 | Carter | Secretary of the Interior | Cecil Andrus | 1/23/77 | 1/20/81 | 1458 | 1462 | Male | ||
31 | 31 | Carter | Secretary of the Treasury | G. William Miller | 8/6/79 | 1/20/81 | 533 | 1462 | Male | ||
32 | 32 | Carter | Secretary of Transportation | Neil Goldschmidt | 8/15/79 | 1/20/81 | 524 | 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 );