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 end_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 |
---|---|---|---|---|---|---|---|---|---|---|---|
137 | 137 | Clinton | Director of Central Intelligence | Jim Woolsey | 2/5/93 | 1/10/95 | 704 | 721 | Male | ||
143 | 143 | Clinton | Secretary of Labor | Robert Reich | 1/22/93 | 1/10/97 | 1449 | 1452 | Male | ||
332 | 332 | Trump | Secretary of Transportation | Elaine Chao | 1/31/17 | 1/11/21 | 1441 | 1453 | Female | ||
108 | 108 | Bush 41 | CEA Chair | Michael Boskin | 2/2/89 | 1/12/93 | 1440 | 1454 | Male | ||
284 | 284 | Obama | Secretary of Agriculture | Tom Vilsack | 1/20/09 | 1/13/17 | 2915 | 2916 | Male | ||
103 | 103 | Bush 41 | Secretary of Commerce | Robert Mosbacher | 1/31/89 | 1/15/92 | 1079 | 1091 | 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 | ||
144 | 144 | Clinton | Secretary of State | Warren Christopher | 1/20/93 | 1/17/97 | 1458 | 1459 | Male | ||
285 | 285 | Obama | CEA Chair | Jason Furman | 8/4/13 | 1/18/17 | 1263 | 2921 | Male | ||
14 | 14 | Carter | Secretary of State | Ed Muskie | 5/8/80 | 1/18/81 | 255 | 1460 | Male | ||
165 | 165 | Clinton | CEA Chair | Martin Baily | 8/12/99 | 1/19/01 | 526 | 2922 | Male | ||
166 | 166 | Clinton | EPA Administrator | Carol Browner | 1/22/93 | 1/19/01 | 2919 | 2922 | Female | ||
167 | 167 | Clinton | OMB Director | Jack Lew | 5/21/98 | 1/19/01 | 974 | 2922 | Male | ||
168 | 168 | Clinton | Secretary of Agriculture | Dan Glickman | 3/30/95 | 1/19/01 | 2122 | 2922 | Male | ||
169 | 169 | Clinton | Secretary of Commerce | Norman Mineta | 7/21/00 | 1/19/01 | 182 | 2922 | Male | ||
170 | 170 | Clinton | Secretary of State | Madeleine Albright | 1/23/97 | 1/19/01 | 1457 | 2922 | Female | ||
171 | 171 | Clinton | UN Ambassador | Richard Holbrooke | 9/7/99 | 1/19/01 | 500 | 2922 | Male | ||
226 | 226 | Bush 43 | OMB Director | Jim Nussle | 9/4/07 | 1/19/09 | 503 | 2922 | Male | ||
227 | 227 | Bush 43 | Secretary of Commerce | Carlos Gutierrez | 2/7/05 | 1/19/09 | 1442 | 2922 | Male | ||
228 | 228 | Bush 43 | Secretary of the Interior | Dirk Kempthorne | 5/29/06 | 1/19/09 | 966 | 2922 | Male | ||
286 | 286 | Obama | Secretary of Defense | Ash Carter | 2/17/15 | 1/19/17 | 702 | 2922 | Male | ||
287 | 287 | Obama | OSTP Director | John Holdren | 3/19/09 | 1/19/17 | 2863 | 2922 | 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 | ||
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 | ||
145 | 145 | Clinton | Secretary of Housing & Urban Development | Henry Cisneros | 1/22/93 | 1/19/97 | 1458 | 1461 | Male | ||
164 | 164 | Clinton | Secretary of the Interior | Bruce Babbitt | 1/22/93 | 1/2/01 | 2902 | 2905 | Male | ||
321 | 321 | Trump | Secretary of the Interior | Ryan Zinke | 3/1/17 | 1/2/19 | 672 | 713 | Male | ||
172 | 172 | Clinton | Attorney General | Janet Reno | 3/12/93 | 1/20/01 | 2871 | 2923 | Female | ||
173 | 173 | Clinton | Chief of Staff | John Podesta | 10/20/98 | 1/20/01 | 823 | 2923 | Male | ||
174 | 174 | Clinton | SBA Administrator | Aida Alvarez | 3/7/97 | 1/20/01 | 1415 | 2923 | Female | ||
175 | 175 | Clinton | Secretary of Defense | William Cohen | 1/24/97 | 1/20/01 | 1457 | 2923 | Male | ||
176 | 176 | Clinton | Secretary of Education | Dick Riley | 1/21/93 | 1/20/01 | 2921 | 2923 | Male | ||
177 | 177 | Clinton | Secretary of Energy | Bill Richardson | 8/18/98 | 1/20/01 | 886 | 2923 | Male | ||
178 | 178 | Clinton | Secretary of Health & Human Services | Donna Shalala | 1/22/93 | 1/20/01 | 2920 | 2923 | Female | ||
179 | 179 | Clinton | Secretary of Housing & Urban Development | Andrew Cuomo | 1/29/97 | 1/20/01 | 1452 | 2923 | Male | ||
180 | 180 | Clinton | Secretary of Labor | Alexis Herman | 5/1/97 | 1/20/01 | 1360 | 2923 | Female | ||
181 | 181 | Clinton | Secretary of the Treasury | Larry Summers | 7/2/99 | 1/20/01 | 568 | 2923 | Male | ||
182 | 182 | Clinton | Secretary of Transportation | Rodney Slater | 2/14/97 | 1/20/01 | 1436 | 2923 | Male | ||
183 | 183 | Clinton | U.S. Trade Representative | Charlene Barshefsky | 3/18/97 | 1/20/01 | 1404 | 2923 | Female | ||
184 | 184 | Clinton | Vice President | Al Gore | 1/20/93 | 1/20/01 | 2922 | 2923 | Male | ||
185 | 185 | Clinton | OSTP Director | Neal Lane | 8/4/98 | 1/20/01 | 900 | 2923 | 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 | ||
229 | 229 | Bush 43 | Attorney General | Michael Mukasey | 11/9/07 | 1/20/09 | 438 | 2923 | Male | ||
230 | 230 | Bush 43 | CEA Chair | Edward Lazear | 2/27/06 | 1/20/09 | 1058 | 2923 | Male | ||
231 | 231 | Bush 43 | Chief of Staff | Josh Bolten | 4/14/06 | 1/20/09 | 1012 | 2923 | Male | ||
232 | 232 | Bush 43 | EPA Administrator | Stephen Johnson | 5/2/05 | 1/20/09 | 1359 | 2923 | Male | ||
233 | 233 | Bush 43 | Secretary of Agriculture | Ed Schafer | 1/28/08 | 1/20/09 | 358 | 2923 | Male | ||
234 | 234 | Bush 43 | Secretary of Education | Margaret Spellings | 1/24/05 | 1/20/09 | 1457 | 2923 | Female | ||
235 | 235 | Bush 43 | Secretary of Energy | Samuel Bodman | 2/1/05 | 1/20/09 | 1449 | 2923 | Male | ||
236 | 236 | Bush 43 | Secretary of Health & Human Services | Mike Leavitt | 1/26/05 | 1/20/09 | 1455 | 2923 | Male | ||
237 | 237 | Bush 43 | Secretary of Housing & Urban Development | Steve Preston | 6/5/08 | 1/20/09 | 229 | 2923 | Male | ||
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 | ||
240 | 240 | Bush 43 | Secretary of the Treasury | Hank Paulson | 7/10/06 | 1/20/09 | 925 | 2923 | Male | ||
241 | 241 | Bush 43 | Secretary of Transportation | Mary Peters | 10/17/06 | 1/20/09 | 826 | 2923 | Female | ||
242 | 242 | Bush 43 | Secretary of Veterans Affairs | James Peake | 12/20/07 | 1/20/09 | 397 | 2923 | Male | ||
243 | 243 | Bush 43 | U.S. Trade Representative | Susan Schwab | 6/8/06 | 1/20/09 | 957 | 2923 | Female | ||
244 | 244 | Bush 43 | Vice President | Dick Cheney | 1/20/01 | 1/20/09 | 2922 | 2923 | Male | ||
245 | 245 | Bush 43 | OSTP Director | John H. Marburger | 10/29/01 | 1/20/09 | 2640 | 2923 | Male | ||
288 | 288 | Obama | Vice President | Joe Biden | 1/20/09 | 1/20/17 | 2922 | 2923 | Male | ||
289 | 289 | Obama | Director of National Intelligence | James Clapper | 8/9/10 | 1/20/17 | 2356 | 2923 | Male | ||
290 | 290 | Obama | Chief of Staff | Denis McDonough | 1/25/13 | 1/20/17 | 1456 | 2923 | Male | ||
291 | 291 | Obama | Secretary of State | John Kerry | 2/1/13 | 1/20/17 | 1449 | 2923 | Male | ||
292 | 292 | Obama | Secretary of the Treasury | Jack Lew | 2/28/13 | 1/20/17 | 1422 | 2923 | Male | ||
293 | 293 | Obama | CIA Director | John Brennan | 3/8/13 | 1/20/17 | 1414 | 2923 | Male | ||
294 | 294 | Obama | Secretary of the Interior | Sally Jewell | 4/12/13 | 1/20/17 | 1379 | 2923 | Female | ||
295 | 295 | Obama | Secretary of Energy | Ernest Moniz | 5/21/13 | 1/20/17 | 1340 | 2923 | Male | ||
296 | 296 | Obama | U.S. Trade Representative | Michael Froman | 6/21/13 | 1/20/17 | 1309 | 2923 | Male | ||
297 | 297 | Obama | Secretary of Commerce | Penny Pritzker | 6/26/13 | 1/20/17 | 1304 | 2923 | Female | ||
298 | 298 | Obama | Secretary of Transportation | Anthony Foxx | 7/2/13 | 1/20/17 | 1298 | 2923 | Male | ||
299 | 299 | Obama | EPA Administrator | Gina McCarthy | 7/19/13 | 1/20/17 | 1281 | 2923 | Female | ||
300 | 300 | Obama | Secretary of Labor | Tom Perez | 7/23/13 | 1/20/17 | 1277 | 2923 | Male | ||
301 | 301 | Obama | Secretary of Homeland Security | Jeh Johnson | 12/23/13 | 1/20/17 | 1124 | 2923 | Male | ||
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 | ||
304 | 304 | Obama | OMB Director | Shaun Donovan | 7/28/14 | 1/20/17 | 907 | 2923 | Male | ||
305 | 305 | Obama | Secretary of Housing & Urban Development | Julián Castro | 7/28/14 | 1/20/17 | 907 | 2923 | Male | ||
306 | 306 | Obama | Secretary of Veterans Affairs | Bob McDonald | 7/30/14 | 1/20/17 | 905 | 2923 | Male | ||
307 | 307 | Obama | Attorney General | Loretta Lynch | 4/27/15 | 1/20/17 | 634 | 2923 | Female | ||
308 | 308 | Obama | Secretary of Education | John King Jr. | 3/14/16 | 1/20/17 | 312 | 2923 | Male | ||
333 | 333 | Trump | OSTP Director | Kelvin Droegemeier | 1/11/19 | 1/20/21 | 740 | 1462 | Male | ||
334 | 334 | Trump | Vice President | Mike Pence | 1/20/17 | 1/20/21 | 1461 | 1462 | Male | ||
335 | 335 | Trump | Secretary of the Treasury | Steve Mnuchin | 2/13/17 | 1/20/21 | 1437 | 1462 | Male | ||
336 | 336 | Trump | Secretary of Commerce | Wilbur Ross | 2/28/17 | 1/20/21 | 1422 | 1462 | Male | ||
337 | 337 | Trump | Secretary of Housing & Urban Development | Ben Carson | 3/2/17 | 1/20/21 | 1420 | 1462 | Male | ||
338 | 338 | Trump | Secretary of Agriculture | Sonny Perdue | 4/25/17 | 1/20/21 | 1366 | 1462 | Male | ||
339 | 339 | Trump | U.S. Trade Representative | Robert Lighthizer | 5/15/17 | 1/20/21 | 1346 | 1462 | Male | ||
340 | 340 | Trump | Secretary of Health & Human Services | Alex Azar | 1/29/18 | 1/20/21 | 1087 | 1462 | Male | ||
341 | 341 | Trump | Secretary of State | Mike Pompeo | 4/26/18 | 1/20/21 | 1000 | 1462 | Male | ||
342 | 342 | Trump | CIA Director | Gina Haspel | 5/21/18 | 1/20/21 | 975 | 1462 | Female | ||
343 | 343 | Trump | Secretary of Veterans Affairs | Robert Wilkie | 7/30/18 | 1/20/21 | 905 | 1462 | Male | ||
344 | 344 | Trump | EPA Administrator | Andrew Wheeler | 2/28/19 | 1/20/21 | 692 | 1462 | Male | ||
345 | 345 | Trump | Secretary of the Interior | David Bernhardt | 4/11/19 | 1/20/21 | 650 | 1462 | Male | ||
346 | 346 | Trump | UN Ambassador | Kelly Craft | 9/10/19 | 1/20/21 | 498 | 1462 | Female | ||
347 | 347 | Trump | Secretary of Labor | Eugene Scalia | 9/27/19 | 1/20/21 | 481 | 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 );