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)
Link | rowid | president | position | appointee ▼ | start_date | end_date | length | departure_day | gender | Unnamed: 8 | Unnamed: 9 |
---|---|---|---|---|---|---|---|---|---|---|---|
156 | 156 | Clinton | OMB Director | Frank Raines | 9/13/96 | 5/21/98 | 615 | 1948 | Male | ||
31 | 31 | Carter | Secretary of the Treasury | G. William Miller | 8/6/79 | 1/20/81 | 533 | 1462 | Male | ||
209 | 209 | Bush 43 | Secretary of the Interior | Gale Norton | 1/31/01 | 3/31/06 | 1885 | 1897 | Female | ||
257 | 257 | Obama | Secretary of Commerce | Gary Locke | 3/26/09 | 8/1/11 | 858 | 924 | Male | ||
57 | 57 | Reagan | OSTP Director | George A. Keyworth II | Aug. 1981 | 12/31/85 | Approx. 1613 | 1807 | Male | ||
85 | 85 | Reagan | Vice President | George H.W. Bush | 1/20/81 | 1/20/89 | 2922 | 2923 | Male | ||
81 | 81 | Reagan | Secretary of State | George Shultz | 7/16/82 | 1/20/89 | 2380 | 2923 | Male | ||
186 | 186 | Clinton | Director of Central Intelligence | George Tenet | 7/11/97 | Bush admin | 2557 combined | Male | |||
193 | 193 | Bush 43 | Director of Central Intelligence | George Tenet | Clinton admin | 7/11/04 | 2557 combined | 1269 | Male | ||
342 | 342 | Trump | CIA Director | Gina Haspel | 5/21/18 | 1/20/21 | 975 | 1462 | Female | ||
299 | 299 | Obama | EPA Administrator | Gina McCarthy | 7/19/13 | 1/20/17 | 1281 | 2923 | Female | ||
362 | 362 | Biden | Secretary of Commerce | Gina Raimondo | 3/3/21 | Still in office | Female | ||||
188 | 188 | Bush 43 | CEA Chair | Glenn Hubbard | 5/11/01 | 2/28/03 | 658 | 770 | Male | ||
205 | 205 | Bush 43 | CEA Chair | Greg Mankiw | 5/29/03 | 2/18/05 | 631 | 1491 | Male | ||
6 | 6 | Carter | Attorney General | Griffin Bell | 1/26/77 | 8/16/79 | 932 | 939 | Male | ||
12 | 12 | Carter | Chief of Staff | Hamilton Jordan | 7/18/79 | 6/11/80 | 329 | 1239 | Male | ||
240 | 240 | Bush 43 | Secretary of the Treasury | Hank Paulson | 7/10/06 | 1/20/09 | 925 | 2923 | Male | ||
24 | 24 | Carter | Secretary of Defense | Harold Brown | 1/21/77 | 1/20/81 | 1460 | 1462 | Male | ||
207 | 207 | Bush 43 | CEA Chair | Harvey Rosen | 2/23/05 | 6/10/05 | 107 | 1603 | Male | ||
147 | 147 | Clinton | Secretary of Energy | Hazel O'Leary | 1/22/93 | 1/20/97 | 1459 | 1462 | Female | ||
215 | 215 | Bush 43 | SBA Administrator | Hector Barreto | 7/25/01 | 7/2/06 | 1803 | 1990 | Male | ||
145 | 145 | Clinton | Secretary of Housing & Urban Development | Henry Cisneros | 1/22/93 | 1/19/97 | 1458 | 1461 | Male | ||
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 | ||
66 | 66 | Reagan | Chief of Staff | Howard Baker | 3/2/87 | 7/1/88 | 487 | 2720 | Male | ||
377 | 377 | Biden | SBA Administrator | Isabel Guzman | 3/17/21 | Still in office | Female | ||||
111 | 111 | Bush 41 | Secretary of Housing & Urban Development | Jack Kemp | 2/13/89 | 1/19/93 | 1436 | 1461 | Male | ||
167 | 167 | Clinton | OMB Director | Jack Lew | 5/21/98 | 1/19/01 | 974 | 2922 | Male | ||
259 | 259 | Obama | OMB Director | Jack Lew | 11/18/10 | 1/26/12 | 434 | 1102 | Male | ||
265 | 265 | Obama | Chief of Staff | Jack Lew | 1/30/12 | 1/25/13 | 361 | 1467 | Male | ||
292 | 292 | Obama | Secretary of the Treasury | Jack Lew | 2/28/13 | 1/20/17 | 1422 | 2923 | Male | ||
18 | 18 | Carter | Chief of Staff | Jack Watson | 6/11/80 | 1/20/81 | 223 | 1462 | Male | ||
88 | 88 | Reagan | SBA Administrator | James Abdnor | 3/23/87 | 4/20/89 | 759 | 3013 | Male | ||
48 | 48 | Reagan | Chief of Staff | James Baker | 1/20/81 | 2/3/85 | 1475 | 1476 | Male | ||
68 | 68 | Reagan | Secretary of the Treasury | James Baker | 2/3/85 | 8/17/88 | 1291 | 2767 | Male | ||
106 | 106 | Bush 41 | Secretary of State | James Baker | 1/25/89 | 8/23/92 | 1306 | 1312 | Male | ||
113 | 113 | Bush 41 | Chief of Staff | James Baker | 8/23/92 | 1/20/93 | 150 | 1462 | Male | ||
83 | 83 | Reagan | Secretary of Transportation | James Burnley IV | 12/3/87 | 1/20/89 | 414 | 2923 | Male | ||
289 | 289 | Obama | Director of National Intelligence | James Clapper | 8/9/10 | 1/20/17 | 2356 | 2923 | Male | ||
39 | 39 | Reagan | Secretary of Energy | James Edwards | 1/23/81 | 11/5/82 | 651 | 655 | Male | ||
242 | 242 | Bush 43 | Secretary of Veterans Affairs | James Peake | 12/20/07 | 1/20/09 | 397 | 2923 | Male | ||
59 | 59 | Reagan | SBA Administrator | James Sanders | 3/29/82 | 3/31/86 | 1463 | 1897 | Male | ||
8 | 8 | Carter | Secretary of Energy | James Schlesinger | 8/6/77 | 8/23/79 | 747 | 946 | Male | ||
122 | 122 | Bush 41 | Secretary of Energy | James Watkins | 3/1/89 | 1/20/93 | 1421 | 1462 | Male | ||
43 | 43 | Reagan | Secretary of the Interior | James Watt | 1/23/81 | 11/8/83 | 1019 | 1023 | Male | ||
276 | 276 | Obama | Secretary of Homeland Security | Janet Napolitano | 1/21/09 | 9/6/13 | 1689 | 1691 | Female | ||
172 | 172 | Clinton | Attorney General | Janet Reno | 3/12/93 | 1/20/01 | 2871 | 2923 | Female | ||
161 | 161 | Clinton | CEA Chair | Janet Yellen | 2/18/97 | 8/3/99 | 896 | 2387 | Female | ||
357 | 357 | Biden | Secretary of the Treasury | Janet Yellen | 1/26/21 | Still in office | Female | ||||
285 | 285 | Obama | CEA Chair | Jason Furman | 8/4/13 | 1/18/17 | 1263 | 2921 | Male | ||
53 | 53 | Reagan | UN Ambassador | Jeane Kirkpatrick | 2/4/81 | 4/1/85 | 1517 | 1533 | Female | ||
317 | 317 | Trump | Attorney General | Jeff Sessions | 2/9/17 | 11/7/18 | 636 | 657 | Male | ||
379 | 379 | Biden | Chief of Staff | Jeff Zients | 2/8/23 | Still in office | Male | ||||
301 | 301 | Obama | Secretary of Homeland Security | Jeh Johnson | 12/23/13 | 1/20/17 | 1124 | 2923 | Male | ||
367 | 367 | Biden | Secretary of Energy | Jennifer Granholm | 2/25/21 | Still in office | Female | ||||
154 | 154 | Clinton | Secretary of Veterans Affairs | Jesse Brown | 1/23/93 | 7/3/97 | 1622 | 1626 | Male | ||
318 | 318 | Trump | Secretary of Defense | Jim Mattis | 1/20/17 | 12/31/18 | 710 | 711 | Male | ||
21 | 21 | Carter | OMB Director | Jim McIntyre | 9/24/77 | 1/20/81 | 1214 | 1462 | Male | ||
70 | 70 | Reagan | OMB Director | Jim Miller | 10/8/85 | 10/15/88 | 1103 | 2826 | Male | ||
223 | 223 | Bush 43 | Secretary of Veterans Affairs | Jim Nicholson | 2/1/05 | 10/1/07 | 972 | 2446 | Male | ||
226 | 226 | Bush 43 | OMB Director | Jim Nussle | 9/4/07 | 1/19/09 | 503 | 2922 | Male | ||
137 | 137 | Clinton | Director of Central Intelligence | Jim Woolsey | 2/5/93 | 1/10/95 | 704 | 721 | Male | ||
288 | 288 | Obama | Vice President | Joe Biden | 1/20/09 | 1/20/17 | 2922 | 2923 | Male | ||
203 | 203 | Bush 43 | Attorney General | John Ashcroft | 2/2/01 | 2/3/05 | 1462 | 1476 | Male | ||
58 | 58 | Reagan | Secretary of Agriculture | John Block | 1/23/81 | 2/14/86 | 1848 | 1852 | Male | ||
218 | 218 | Bush 43 | UN Ambassador | John Bolton | 8/2/05 | 12/31/06 | 516 | 2172 | Male | ||
293 | 293 | Obama | CIA Director | John Brennan | 3/8/13 | 1/20/17 | 1414 | 2923 | Male | ||
261 | 261 | Obama | Secretary of Commerce | John Bryson | 10/21/11 | 6/21/12 | 244 | 1249 | Male | ||
196 | 196 | Bush 43 | UN Ambassador | John Danforth | 7/23/04 | 1/20/05 | 181 | 1462 | Male | ||
142 | 142 | Clinton | Director of Central Intelligence | John Deutch | 5/10/95 | 12/15/96 | 585 | 1426 | Male | ||
155 | 155 | Clinton | OSTP Director | John H. Gibbons | 2/2/93 | 4/3/98 | 1886 | 1900 | Male | ||
245 | 245 | Bush 43 | OSTP Director | John H. Marburger | 10/29/01 | 1/20/09 | 2640 | 2923 | Male | ||
77 | 77 | Reagan | Secretary of Energy | John Herrington | 2/7/85 | 1/20/89 | 1443 | 2923 | Male | ||
287 | 287 | Obama | OSTP Director | John Holdren | 3/19/09 | 1/19/17 | 2863 | 2922 | Male | ||
311 | 311 | Trump | Secretary of Homeland Security | John Kelly | 1/20/17 | 7/28/17 | 189 | 190 | Male | ||
320 | 320 | Trump | Chief of Staff | John Kelly | 7/31/17 | 12/31/18 | 518 | 711 | Male | ||
291 | 291 | Obama | Secretary of State | John Kerry | 2/1/13 | 1/20/17 | 1449 | 2923 | Male | ||
308 | 308 | Obama | Secretary of Education | John King Jr. | 3/14/16 | 1/20/17 | 312 | 2923 | Male | ||
192 | 192 | Bush 43 | UN Ambassador | John Negroponte | 9/19/01 | 6/23/04 | 1008 | 1251 | Male | ||
219 | 219 | Bush 43 | Director of National Intelligence | John Negroponte | 4/21/05 | 2/13/07 | 663 | 2216 | Male | ||
173 | 173 | Clinton | Chief of Staff | John Podesta | 10/20/98 | 1/20/01 | 823 | 2923 | Male | ||
351 | 351 | Trump | Director of National Intelligence | John Ratcliffe | 5/26/20 | 1/20/21 | 239 | 1462 | Male | ||
214 | 214 | Bush 43 | Secretary of the Treasury | John Snow | 2/3/03 | 6/29/06 | 1242 | 1987 | Male | ||
102 | 102 | Bush 41 | Chief of Staff | John Sununu | 1/20/89 | 12/15/91 | 1059 | 1060 | Male | ||
3 | 3 | Carter | Secretary of Health, Education & Welfare | Joseph Califano Jr. | 1/25/77 | 8/3/79 | 920 | 926 | Male | ||
151 | 151 | Clinton | CEA Chair | Joseph Stiglitz | 6/28/95 | 2/10/97 | 593 | 1483 | Male | ||
74 | 74 | Reagan | OMB Director | Joseph Wright Jr. | 11/8/88 | 1/20/89 | 73 | 2923 | Male | ||
211 | 211 | Bush 43 | OMB Director | Josh Bolten | 6/26/03 | 4/14/06 | 1023 | 1911 | Male | ||
231 | 231 | Bush 43 | Chief of Staff | Josh Bolten | 4/14/06 | 1/20/09 | 1012 | 2923 | Male | ||
349 | 349 | Trump | SBA Administrator | Jovita Carranza | 1/14/20 | 1/20/21 | 372 | 1462 | Female | ||
10 | 10 | Carter | Secretary of Commerce | Juanita Kreps | 1/23/77 | 10/31/79 | 1011 | 1015 | Female | ||
305 | 305 | Obama | Secretary of Housing & Urban Development | Julián Castro | 7/28/14 | 1/20/17 | 907 | 2923 | Male | ||
355 | 355 | Biden | Vice President | Kamala Harris | 1/20/21 | Still in office | Female | ||||
275 | 275 | Obama | SBA Administrator | Karen Mills | 4/6/09 | 9/1/13 | 1609 | 1686 | Female | ||
374 | 374 | Biden | U.S. Trade Representative | Katherine Tai | 3/18/21 | Still in office | Female | ||||
278 | 278 | Obama | Secretary of Health & Human Services | Kathleen Sebelius | 4/28/09 | 6/6/14 | 1865 | 1964 | Female | ||
346 | 346 | Trump | UN Ambassador | Kelly Craft | 9/10/19 | 1/20/21 | 498 | 1462 | Female | ||
333 | 333 | Trump | OSTP Director | Kelvin Droegemeier | 1/11/19 | 1/20/21 | 740 | 1462 | Male | ||
270 | 270 | Obama | Secretary of the Interior | Ken Salazar | 1/20/09 | 4/12/13 | 1543 | 1544 | Male | ||
72 | 72 | Reagan | Chief of Staff | Kenneth Duberstein | 7/1/88 | 1/20/89 | 203 | 2923 | 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 );