cabinet-turnover/cabinet-turnover
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
59 rows where president = "Obama" sorted by appointee
This data as json, copyable, CSV (advanced)
Suggested facets: position, gender
Link | rowid | president | position | appointee ▼ | start_date | end_date | length | departure_day | gender | Unnamed: 8 | Unnamed: 9 |
---|---|---|---|---|---|---|---|---|---|---|---|
274 | 274 | Obama | CEA Chair | Alan Krueger | 11/7/11 | 8/2/13 | 634 | 1656 | Male | ||
298 | 298 | Obama | Secretary of Transportation | Anthony Foxx | 7/2/13 | 1/20/17 | 1298 | 2923 | Male | ||
283 | 283 | Obama | Secretary of Education | Arne Duncan | 1/20/09 | 12/31/15 | 2536 | 2537 | Male | ||
286 | 286 | Obama | Secretary of Defense | Ash Carter | 2/17/15 | 1/19/17 | 702 | 2922 | Male | ||
258 | 258 | Obama | CEA Chair | Austan Goolsbee | 9/10/10 | 8/5/11 | 329 | 928 | Male | ||
260 | 260 | Obama | Chief of Staff | Bill Daley | 1/13/11 | 1/27/12 | 379 | 1103 | Male | ||
256 | 256 | Obama | Secretary of Defense | Bob Gates | Bush admin | 6/30/11 | 1655 combined | 892 | Male | ||
306 | 306 | Obama | Secretary of Veterans Affairs | Bob McDonald | 7/30/14 | 1/20/17 | 905 | 2923 | Male | ||
253 | 253 | Obama | CEA Chair | Christina Romer | 1/29/09 | 9/3/10 | 582 | 592 | Female | ||
281 | 281 | Obama | Secretary of Defense | Chuck Hagel | 2/27/13 | 2/17/15 | 720 | 2220 | Male | ||
262 | 262 | Obama | CIA Director | David Petraeus | 9/6/11 | 11/9/12 | 430 | 1390 | Male | ||
290 | 290 | Obama | Chief of Staff | Denis McDonough | 1/25/13 | 1/20/17 | 1456 | 2923 | Male | ||
251 | 251 | Obama | Director of National Intelligence | Dennis Blair | 1/29/09 | 5/28/10 | 484 | 494 | Male | ||
282 | 282 | Obama | Attorney General | Eric Holder | 2/3/09 | 4/24/15 | 2271 | 2286 | Male | ||
277 | 277 | Obama | Secretary of Veterans Affairs | Eric Shinseki | 1/21/09 | 5/30/14 | 1955 | 1957 | Male | ||
295 | 295 | Obama | Secretary of Energy | Ernest Moniz | 5/21/13 | 1/20/17 | 1340 | 2923 | Male | ||
257 | 257 | Obama | Secretary of Commerce | Gary Locke | 3/26/09 | 8/1/11 | 858 | 924 | Male | ||
299 | 299 | Obama | EPA Administrator | Gina McCarthy | 7/19/13 | 1/20/17 | 1281 | 2923 | 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 | ||
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 | ||
289 | 289 | Obama | Director of National Intelligence | James Clapper | 8/9/10 | 1/20/17 | 2356 | 2923 | Male | ||
276 | 276 | Obama | Secretary of Homeland Security | Janet Napolitano | 1/21/09 | 9/6/13 | 1689 | 1691 | Female | ||
285 | 285 | Obama | CEA Chair | Jason Furman | 8/4/13 | 1/18/17 | 1263 | 2921 | Male | ||
301 | 301 | Obama | Secretary of Homeland Security | Jeh Johnson | 12/23/13 | 1/20/17 | 1124 | 2923 | Male | ||
288 | 288 | Obama | Vice President | Joe Biden | 1/20/09 | 1/20/17 | 2922 | 2923 | 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 | ||
287 | 287 | Obama | OSTP Director | John Holdren | 3/19/09 | 1/19/17 | 2863 | 2922 | 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 | ||
305 | 305 | Obama | Secretary of Housing & Urban Development | Julián Castro | 7/28/14 | 1/20/17 | 907 | 2923 | Male | ||
275 | 275 | Obama | SBA Administrator | Karen Mills | 4/6/09 | 9/1/13 | 1609 | 1686 | Female | ||
278 | 278 | Obama | Secretary of Health & Human Services | Kathleen Sebelius | 4/28/09 | 6/6/14 | 1865 | 1964 | Female | ||
270 | 270 | Obama | Secretary of the Interior | Ken Salazar | 1/20/09 | 4/12/13 | 1543 | 1544 | Male | ||
255 | 255 | Obama | CIA Director | Leon Panetta | 2/13/09 | 6/30/11 | 867 | 892 | Male | ||
268 | 268 | Obama | Secretary of Defense | Leon Panetta | 7/1/11 | 2/26/13 | 606 | 1499 | Male | ||
267 | 267 | Obama | EPA Administrator | Lisa Jackson | 1/26/09 | 2/14/13 | 1480 | 1487 | Female | ||
307 | 307 | Obama | Attorney General | Loretta Lynch | 4/27/15 | 1/20/17 | 634 | 2923 | Female | ||
302 | 302 | Obama | SBA Administrator | Maria Contreras-Sweet | 4/7/14 | 1/20/17 | 1019 | 2923 | Female | ||
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 | ||
252 | 252 | Obama | OMB Director | Peter Orszag | 1/20/09 | 7/30/10 | 556 | 557 | Male | ||
254 | 254 | Obama | Chief of Staff | Rahm Emanuel | 1/20/09 | 10/1/10 | 619 | 620 | Male | ||
273 | 273 | Obama | Secretary of Transportation | Ray LaHood | 1/23/09 | 7/2/13 | 1621 | 1625 | Male | ||
269 | 269 | Obama | U.S. Trade Representative | Ron Kirk | 3/20/09 | 3/15/13 | 1456 | 1516 | Male | ||
294 | 294 | Obama | Secretary of the Interior | Sally Jewell | 4/12/13 | 1/20/17 | 1379 | 2923 | Female | ||
309 | 309 | Obama | UN Ambassador | Samantha Power | 8/5/13 | 1/21/17 | 1265 | 2924 | Female | ||
280 | 280 | Obama | Secretary of Housing & Urban Development | Shaun Donovan | 1/26/09 | 7/28/14 | 2009 | 2016 | Male | ||
304 | 304 | Obama | OMB Director | Shaun Donovan | 7/28/14 | 1/20/17 | 907 | 2923 | Male | ||
271 | 271 | Obama | Secretary of Energy | Steven Chu | 1/21/09 | 4/22/13 | 1552 | 1554 | Male | ||
272 | 272 | Obama | UN Ambassador | Susan Rice | 1/26/09 | 6/30/13 | 1616 | 1623 | Female | ||
279 | 279 | Obama | OMB Director | Sylvia Burwell | 4/26/13 | 6/8/14 | 408 | 1966 | Female | ||
303 | 303 | Obama | Secretary of Health & Human Services | Sylvia Burwell | 6/9/14 | 1/20/17 | 956 | 2923 | Female | ||
264 | 264 | Obama | Secretary of the Treasury | Tim Geithner | 1/26/09 | 1/25/13 | 1460 | 1467 | Male | ||
300 | 300 | Obama | Secretary of Labor | Tom Perez | 7/23/13 | 1/20/17 | 1277 | 2923 | Male | ||
284 | 284 | Obama | Secretary of Agriculture | Tom Vilsack | 1/20/09 | 1/13/17 | 2915 | 2916 | 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 );