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 president
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
353 | 353 | Biden | OSTP Director | Eric Lander | 6/2/21 | 2/18/22 | 261 | 395 | 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 | ||||
356 | 356 | Biden | Secretary of State | Antony Blinken | 1/26/21 | Still in office | Male | ||||
357 | 357 | Biden | Secretary of the Treasury | Janet Yellen | 1/26/21 | Still in office | Female | ||||
358 | 358 | Biden | Secretary of Defense | Lloyd Austin | 1/22/21 | Still in office | Male | ||||
359 | 359 | Biden | Attorney General | Merrick Garland | 3/11/21 | Still in office | Male | ||||
360 | 360 | Biden | Secretary of the Interior | Deb Haaland | 3/16/21 | Still in office | Female | ||||
361 | 361 | Biden | Secretary of Agriculture | Tom Vilsack | 2/24/21 | Still in office | Male | ||||
362 | 362 | Biden | Secretary of Commerce | Gina Raimondo | 3/3/21 | Still in office | Female | ||||
363 | 363 | Biden | Secretary of Labor | Marty Walsh | 3/23/21 | Still in office | Male | ||||
364 | 364 | Biden | Secretary of Health & Human Services | Xavier Becerra | 3/19/21 | Still in office | Male | ||||
365 | 365 | Biden | Secretary of Housing & Urban Development | Marcia Fudge | 3/10/21 | Still in office | Female | ||||
366 | 366 | Biden | Secretary of Transportation | Pete Buttigieg | 2/3/21 | Still in office | Male | ||||
367 | 367 | Biden | Secretary of Energy | Jennifer Granholm | 2/25/21 | Still in office | Female | ||||
368 | 368 | Biden | Secretary of Education | Miguel Cardona | 3/2/21 | Still in office | Male | ||||
369 | 369 | Biden | Secretary of Veterans Affairs | Denis McDonough | 2/9/21 | Still in office | Male | ||||
370 | 370 | Biden | Secretary of Homeland Security | Alejandro Mayorkas | 2/2/21 | Still in office | Male | ||||
371 | 371 | Biden | EPA Administrator | Michael Regan | 3/11/21 | Still in office | Male | ||||
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 | ||||
379 | 379 | Biden | Chief of Staff | Jeff Zients | 2/8/23 | Still in office | Male | ||||
94 | 94 | Bush 41 | OSTP Director | William R. Graham | Reagan admin | 6/5/89 | 977 combined | 137 | Male | ||
95 | 95 | Bush 41 | Secretary of Labor | Elizabeth Dole | 1/25/89 | 11/23/90 | 667 | 673 | Female | ||
96 | 96 | Bush 41 | Secretary of Education | Lauro Cavazos | Reagan admin | 12/15/90 | 816 combined | 695 | Male | ||
97 | 97 | Bush 41 | Secretary of Agriculture | Clayton Yeutter | 2/16/89 | 3/1/91 | 743 | 771 | Male | ||
98 | 98 | Bush 41 | SBA Administrator | Susan Engeleiter | 4/20/89 | 3/27/91 | 706 | 797 | Female | ||
99 | 99 | Bush 41 | Attorney General | Dick Thornburgh | Reagan admin | 8/15/91 | 1098 combined | 938 | Male | ||
100 | 100 | Bush 41 | Director of Central Intelligence | Bill Webster | Reagan admin | 8/31/91 | 1558 combined | 954 | Male | ||
101 | 101 | Bush 41 | Secretary of Transportation | Sam Skinner | 2/6/89 | 12/13/91 | 1040 | 1058 | Male | ||
102 | 102 | Bush 41 | Chief of Staff | John Sununu | 1/20/89 | 12/15/91 | 1059 | 1060 | Male | ||
103 | 103 | Bush 41 | Secretary of Commerce | Robert Mosbacher | 1/31/89 | 1/15/92 | 1079 | 1091 | Male | ||
104 | 104 | Bush 41 | UN Ambassador | Tom Pickering | 3/20/89 | 5/7/92 | 1144 | 1204 | Male | ||
105 | 105 | Bush 41 | Chief of Staff | Sam Skinner | 12/16/91 | 8/23/92 | 251 | 1312 | Male | ||
106 | 106 | Bush 41 | Secretary of State | James Baker | 1/25/89 | 8/23/92 | 1306 | 1312 | Male | ||
107 | 107 | Bush 41 | Secretary of Veterans Affairs | Ed Derwinski | 3/15/89 | 9/26/92 | 1291 | 1346 | Male | ||
108 | 108 | Bush 41 | CEA Chair | Michael Boskin | 2/2/89 | 1/12/93 | 1440 | 1454 | Male | ||
109 | 109 | Bush 41 | Attorney General | William Barr | 11/26/91 | 1/15/93 | 416 | 1457 | Male | ||
110 | 110 | Bush 41 | Secretary of the Treasury | Nicholas Brady | Reagan admin | 1/17/93 | 1584 combined | 1459 | Male | ||
111 | 111 | Bush 41 | Secretary of Housing & Urban Development | Jack Kemp | 2/13/89 | 1/19/93 | 1436 | 1461 | Male | ||
112 | 112 | Bush 41 | Secretary of State | Lawrence Eagleburger | 12/8/92 | 1/19/93 | 42 | 1461 | Male | ||
113 | 113 | Bush 41 | Chief of Staff | James Baker | 8/23/92 | 1/20/93 | 150 | 1462 | Male | ||
114 | 114 | Bush 41 | Director of Central Intelligence | Bob Gates | 11/6/91 | 1/20/93 | 441 | 1462 | Male | ||
115 | 115 | Bush 41 | EPA Administrator | William Reilly | 2/6/89 | 1/20/93 | 1444 | 1462 | Male | ||
116 | 116 | Bush 41 | OMB Director | Dick Darman | 1/25/89 | 1/20/93 | 1456 | 1462 | Male | ||
117 | 117 | Bush 41 | SBA Administrator | Pat Saiki | 3/27/91 | 1/20/93 | 665 | 1462 | Female | ||
118 | 118 | Bush 41 | Secretary of Agriculture | Ed Madigan | 3/12/91 | 1/20/93 | 680 | 1462 | Male | ||
119 | 119 | Bush 41 | Secretary of Commerce | Barbara Franklin | 2/27/92 | 1/20/93 | 328 | 1462 | Female | ||
120 | 120 | Bush 41 | Secretary of Defense | Dick Cheney | 3/21/89 | 1/20/93 | 1401 | 1462 | Male | ||
121 | 121 | Bush 41 | Secretary of Education | Lamar Alexander | 3/18/91 | 1/20/93 | 674 | 1462 | Male | ||
122 | 122 | Bush 41 | Secretary of Energy | James Watkins | 3/1/89 | 1/20/93 | 1421 | 1462 | Male | ||
123 | 123 | Bush 41 | Secretary of Health & Human Services | Louis Sullivan | 3/1/89 | 1/20/93 | 1421 | 1462 | Male | ||
124 | 124 | Bush 41 | Secretary of Labor | Lynn Morley Martin | 2/7/91 | 1/20/93 | 713 | 1462 | Female | ||
125 | 125 | Bush 41 | Secretary of the Interior | Manuel Luján Jr. | 2/3/89 | 1/20/93 | 1447 | 1462 | Male | ||
126 | 126 | Bush 41 | Secretary of Transportation | Andy Card | 3/11/92 | 1/20/93 | 315 | 1462 | Male | ||
127 | 127 | Bush 41 | U.S. Trade Representative | Carla Hills | 2/6/89 | 1/20/93 | 1444 | 1462 | Female | ||
128 | 128 | Bush 41 | Vice President | Dan Quayle | 1/20/89 | 1/20/93 | 1461 | 1462 | Male | ||
129 | 129 | Bush 41 | OSTP Director | D. Allan Bromley | 10/13/89 | 1/20/93 | 1195 | 1462 | Male | ||
130 | 130 | Bush 41 | UN Ambassador | Edward Perkins | 5/12/92 | 1/27/93 | 260 | 1469 | Male | ||
187 | 187 | Bush 43 | Secretary of the Treasury | Paul O'Neill | 1/30/01 | 12/31/02 | 700 | 711 | Male | ||
188 | 188 | Bush 43 | CEA Chair | Glenn Hubbard | 5/11/01 | 2/28/03 | 658 | 770 | Male | ||
189 | 189 | Bush 43 | OMB Director | Mitch Daniels | 1/23/01 | 6/6/03 | 864 | 868 | Male | ||
190 | 190 | Bush 43 | EPA Administrator | Christine Todd Whitman | 1/31/01 | 6/27/03 | 877 | 889 | Female | ||
191 | 191 | Bush 43 | Secretary of Housing & Urban Development | Mel Martinez | 1/24/01 | 12/12/03 | 1052 | 1057 | Male | ||
192 | 192 | Bush 43 | UN Ambassador | John Negroponte | 9/19/01 | 6/23/04 | 1008 | 1251 | Male | ||
193 | 193 | Bush 43 | Director of Central Intelligence | George Tenet | Clinton admin | 7/11/04 | 2557 combined | 1269 | Male | ||
194 | 194 | Bush 43 | Secretary of Agriculture | Ann Veneman | 1/20/01 | 1/20/05 | 1461 | 1462 | Female | ||
195 | 195 | Bush 43 | Secretary of Education | Rod Paige | 1/24/01 | 1/20/05 | 1457 | 1462 | Male | ||
196 | 196 | Bush 43 | UN Ambassador | John Danforth | 7/23/04 | 1/20/05 | 181 | 1462 | Male | ||
197 | 197 | Bush 43 | EPA Administrator | Mike Leavitt | 11/6/03 | 1/25/05 | 446 | 1467 | Male | ||
198 | 198 | Bush 43 | Secretary of State | Colin Powell | 1/20/01 | 1/25/05 | 1466 | 1467 | Male | ||
199 | 199 | Bush 43 | Secretary of Health & Human Services | Tommy Thompson | 2/2/01 | 1/26/05 | 1454 | 1468 | Male | ||
200 | 200 | Bush 43 | Secretary of Veterans Affairs | Anthony Principi | 1/23/01 | 1/26/05 | 1464 | 1468 | Male | ||
201 | 201 | Bush 43 | Secretary of Energy | Spencer Abraham | 1/20/01 | 1/31/05 | 1472 | 1473 | Male | ||
202 | 202 | Bush 43 | Secretary of Homeland Security | Tom Ridge | 1/24/03 | 2/1/05 | 739 | 1474 | Male | ||
203 | 203 | Bush 43 | Attorney General | John Ashcroft | 2/2/01 | 2/3/05 | 1462 | 1476 | Male | ||
204 | 204 | Bush 43 | Secretary of Commerce | Donald Evans | 1/20/01 | 2/3/05 | 1475 | 1476 | Male | ||
205 | 205 | Bush 43 | CEA Chair | Greg Mankiw | 5/29/03 | 2/18/05 | 631 | 1491 | Male | ||
206 | 206 | Bush 43 | U.S. Trade Representative | Robert Zoellick | 2/7/01 | 2/22/05 | 1476 | 1495 | Male | ||
207 | 207 | Bush 43 | CEA Chair | Harvey Rosen | 2/23/05 | 6/10/05 | 107 | 1603 | Male | ||
208 | 208 | Bush 43 | CEA Chair | Ben Bernanke | 6/21/05 | 1/31/06 | 224 | 1838 | Male | ||
209 | 209 | Bush 43 | Secretary of the Interior | Gale Norton | 1/31/01 | 3/31/06 | 1885 | 1897 | Female | ||
210 | 210 | Bush 43 | Chief of Staff | Andy Card | 1/20/01 | 4/14/06 | 1910 | 1911 | Male | ||
211 | 211 | Bush 43 | OMB Director | Josh Bolten | 6/26/03 | 4/14/06 | 1023 | 1911 | Male | ||
212 | 212 | Bush 43 | Director of Central Intelligence/CIA Director | Porter Goss | 9/24/04 | 5/5/06 | 588 | 1932 | Male | ||
213 | 213 | Bush 43 | U.S. Trade Representative | Rob Portman | 5/17/05 | 5/26/06 | 374 | 1953 | Male | ||
214 | 214 | Bush 43 | Secretary of the Treasury | John Snow | 2/3/03 | 6/29/06 | 1242 | 1987 | Male | ||
215 | 215 | Bush 43 | SBA Administrator | Hector Barreto | 7/25/01 | 7/2/06 | 1803 | 1990 | Male | ||
216 | 216 | Bush 43 | Secretary of Transportation | Norman Mineta | 1/25/01 | 7/7/06 | 1989 | 1995 | Male | ||
217 | 217 | Bush 43 | Secretary of Defense | Donald Rumsfeld | 1/20/01 | 12/18/06 | 2158 | 2159 | Male | ||
218 | 218 | Bush 43 | UN Ambassador | John Bolton | 8/2/05 | 12/31/06 | 516 | 2172 | Male | ||
219 | 219 | Bush 43 | Director of National Intelligence | John Negroponte | 4/21/05 | 2/13/07 | 663 | 2216 | Male | ||
220 | 220 | Bush 43 | OMB Director | Rob Portman | 5/26/06 | 8/3/07 | 434 | 2387 | Male | ||
221 | 221 | Bush 43 | Attorney General | Alberto Gonzales | 2/3/05 | 9/17/07 | 956 | 2432 | Male | ||
222 | 222 | Bush 43 | Secretary of Agriculture | Mike Johanns | 1/21/05 | 9/20/07 | 972 | 2435 | 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 );