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 length
This data as json, copyable, CSV (advanced)
Link | rowid | president | position | appointee | start_date | end_date | length ▼ | departure_day | gender | Unnamed: 8 | Unnamed: 9 |
---|---|---|---|---|---|---|---|---|---|---|---|
30 | 30 | Carter | Secretary of the Interior | Cecil Andrus | 1/23/77 | 1/20/81 | 1458 | 1462 | Male | ||
144 | 144 | Clinton | Secretary of State | Warren Christopher | 1/20/93 | 1/17/97 | 1458 | 1459 | Male | ||
145 | 145 | Clinton | Secretary of Housing & Urban Development | Henry Cisneros | 1/22/93 | 1/19/97 | 1458 | 1461 | Male | ||
17 | 17 | Carter | CEA Chair | Charles Schultze | 1/22/77 | 1/20/81 | 1459 | 1462 | Male | ||
147 | 147 | Clinton | Secretary of Energy | Hazel O'Leary | 1/22/93 | 1/20/97 | 1459 | 1462 | Female | ||
24 | 24 | Carter | Secretary of Defense | Harold Brown | 1/21/77 | 1/20/81 | 1460 | 1462 | Male | ||
264 | 264 | Obama | Secretary of the Treasury | Tim Geithner | 1/26/09 | 1/25/13 | 1460 | 1467 | Male | ||
34 | 34 | Carter | Vice President | Walter Mondale | 1/20/77 | 1/20/81 | 1461 | 1462 | Male | ||
128 | 128 | Bush 41 | Vice President | Dan Quayle | 1/20/89 | 1/20/93 | 1461 | 1462 | Male | ||
194 | 194 | Bush 43 | Secretary of Agriculture | Ann Veneman | 1/20/01 | 1/20/05 | 1461 | 1462 | Female | ||
334 | 334 | Trump | Vice President | Mike Pence | 1/20/17 | 1/20/21 | 1461 | 1462 | Male | ||
203 | 203 | Bush 43 | Attorney General | John Ashcroft | 2/2/01 | 2/3/05 | 1462 | 1476 | Male | ||
59 | 59 | Reagan | SBA Administrator | James Sanders | 3/29/82 | 3/31/86 | 1463 | 1897 | Male | ||
200 | 200 | Bush 43 | Secretary of Veterans Affairs | Anthony Principi | 1/23/01 | 1/26/05 | 1464 | 1468 | Male | ||
198 | 198 | Bush 43 | Secretary of State | Colin Powell | 1/20/01 | 1/25/05 | 1466 | 1467 | Male | ||
47 | 47 | Reagan | Secretary of the Treasury | Don Regan | 1/22/81 | 2/2/85 | 1472 | 1475 | Male | ||
201 | 201 | Bush 43 | Secretary of Energy | Spencer Abraham | 1/20/01 | 1/31/05 | 1472 | 1473 | Male | ||
266 | 266 | Obama | Secretary of State | Hillary Clinton | 1/21/09 | 2/1/13 | 1472 | 1474 | Female | ||
48 | 48 | Reagan | Chief of Staff | James Baker | 1/20/81 | 2/3/85 | 1475 | 1476 | Male | ||
204 | 204 | Bush 43 | Secretary of Commerce | Donald Evans | 1/20/01 | 2/3/05 | 1475 | 1476 | Male | ||
206 | 206 | Bush 43 | U.S. Trade Representative | Robert Zoellick | 2/7/01 | 2/22/05 | 1476 | 1495 | Male | ||
224 | 224 | Bush 43 | Secretary of Housing & Urban Development | Alphonso Jackson | 3/31/04 | 4/18/08 | 1479 | 2646 | Male | ||
267 | 267 | Obama | EPA Administrator | Lisa Jackson | 1/26/09 | 2/14/13 | 1480 | 1487 | Female | ||
153 | 153 | Clinton | Secretary of Transportation | Federico Peña | 1/21/93 | 2/14/97 | 1485 | 1487 | Male | ||
51 | 51 | Reagan | Attorney General | William French Smith | 1/23/81 | 2/25/85 | 1494 | 1498 | Male | ||
113 | 113 | Bush 41 | Chief of Staff | James Baker | 8/23/92 | 1/20/93 | 150 | 1462 | Male | ||
52 | 52 | Reagan | Secretary of Labor | Ray Donovan | 2/4/81 | 3/15/85 | 1500 | 1516 | Male | ||
53 | 53 | Reagan | UN Ambassador | Jeane Kirkpatrick | 2/4/81 | 4/1/85 | 1517 | 1533 | Female | ||
270 | 270 | Obama | Secretary of the Interior | Ken Salazar | 1/20/09 | 4/12/13 | 1543 | 1544 | Male | ||
271 | 271 | Obama | Secretary of Energy | Steven Chu | 1/21/09 | 4/22/13 | 1552 | 1554 | Male | ||
54 | 54 | Reagan | U.S. Trade Representative | Bill Brock | 1/23/81 | 4/29/85 | 1557 | 1561 | Male | ||
90 | 90 | Reagan | Director of Central Intelligence | Bill Webster | 5/26/87 | Bush admin | 1558 combined | Male | |||
100 | 100 | Bush 41 | Director of Central Intelligence | Bill Webster | Reagan admin | 8/31/91 | 1558 combined | 954 | Male | ||
93 | 93 | Reagan | Secretary of the Treasury | Nicholas Brady | 9/16/88 | Bush admin | 1584 combined | Male | |||
110 | 110 | Bush 41 | Secretary of the Treasury | Nicholas Brady | Reagan admin | 1/17/93 | 1584 combined | 1459 | Male | ||
275 | 275 | Obama | SBA Administrator | Karen Mills | 4/6/09 | 9/1/13 | 1609 | 1686 | Female | ||
272 | 272 | Obama | UN Ambassador | Susan Rice | 1/26/09 | 6/30/13 | 1616 | 1623 | Female | ||
273 | 273 | Obama | Secretary of Transportation | Ray LaHood | 1/23/09 | 7/2/13 | 1621 | 1625 | Male | ||
154 | 154 | Clinton | Secretary of Veterans Affairs | Jesse Brown | 1/23/93 | 7/3/97 | 1622 | 1626 | Male | ||
160 | 160 | Clinton | Secretary of the Treasury | Bob Rubin | 1/10/95 | 7/2/99 | 1634 | 2355 | Male | ||
55 | 55 | Reagan | OMB Director | David Stockman | 1/21/81 | 8/1/85 | 1653 | 1655 | Male | ||
250 | 250 | Bush 43 | Secretary of Defense | Bob Gates | 12/18/06 | Obama admin | 1655 combined | Male | |||
256 | 256 | Obama | Secretary of Defense | Bob Gates | Bush admin | 6/30/11 | 1655 combined | 892 | Male | ||
276 | 276 | Obama | Secretary of Homeland Security | Janet Napolitano | 1/21/09 | 9/6/13 | 1689 | 1691 | Female | ||
63 | 63 | Reagan | Secretary of Transportation | Elizabeth Dole | 2/7/83 | 9/30/87 | 1696 | 2445 | Female | ||
215 | 215 | Bush 43 | SBA Administrator | Hector Barreto | 7/25/01 | 7/2/06 | 1803 | 1990 | Male | ||
196 | 196 | Bush 43 | UN Ambassador | John Danforth | 7/23/04 | 1/20/05 | 181 | 1462 | Male | ||
169 | 169 | Clinton | Secretary of Commerce | Norman Mineta | 7/21/00 | 1/19/01 | 182 | 2922 | Male | ||
352 | 352 | Trump | OMB Director | Russ Vought | 7/22/20 | 1/20/21 | 182 | 1462 | Male | ||
58 | 58 | Reagan | Secretary of Agriculture | John Block | 1/23/81 | 2/14/86 | 1848 | 1852 | Male | ||
278 | 278 | Obama | Secretary of Health & Human Services | Kathleen Sebelius | 4/28/09 | 6/6/14 | 1865 | 1964 | Female | ||
209 | 209 | Bush 43 | Secretary of the Interior | Gale Norton | 1/31/01 | 3/31/06 | 1885 | 1897 | Female | ||
155 | 155 | Clinton | OSTP Director | John H. Gibbons | 2/2/93 | 4/3/98 | 1886 | 1900 | Male | ||
310 | 310 | Trump | Chief of Staff | Reince Priebus | 1/20/17 | 7/28/17 | 189 | 190 | Male | ||
311 | 311 | Trump | Secretary of Homeland Security | John Kelly | 1/20/17 | 7/28/17 | 189 | 190 | Male | ||
210 | 210 | Bush 43 | Chief of Staff | Andy Card | 1/20/01 | 4/14/06 | 1910 | 1911 | Male | ||
277 | 277 | Obama | Secretary of Veterans Affairs | Eric Shinseki | 1/21/09 | 5/30/14 | 1955 | 1957 | Male | ||
216 | 216 | Bush 43 | Secretary of Transportation | Norman Mineta | 1/25/01 | 7/7/06 | 1989 | 1995 | Male | ||
280 | 280 | Obama | Secretary of Housing & Urban Development | Shaun Donovan | 1/26/09 | 7/28/14 | 2009 | 2016 | Male | ||
72 | 72 | Reagan | Chief of Staff | Kenneth Duberstein | 7/1/88 | 1/20/89 | 203 | 2923 | Male | ||
168 | 168 | Clinton | Secretary of Agriculture | Dan Glickman | 3/30/95 | 1/19/01 | 2122 | 2922 | Male | ||
217 | 217 | Bush 43 | Secretary of Defense | Donald Rumsfeld | 1/20/01 | 12/18/06 | 2158 | 2159 | Male | ||
60 | 60 | Reagan | Director of Central Intelligence | William Casey | 1/28/81 | 1/29/87 | 2192 | 2201 | Male | ||
18 | 18 | Carter | Chief of Staff | Jack Watson | 6/11/80 | 1/20/81 | 223 | 1462 | Male | ||
208 | 208 | Bush 43 | CEA Chair | Ben Bernanke | 6/21/05 | 1/31/06 | 224 | 1838 | Male | ||
282 | 282 | Obama | Attorney General | Eric Holder | 2/3/09 | 4/24/15 | 2271 | 2286 | Male | ||
237 | 237 | Bush 43 | Secretary of Housing & Urban Development | Steve Preston | 6/5/08 | 1/20/09 | 229 | 2923 | Male | ||
312 | 312 | Trump | Secretary of Health & Human Services | Tom Price | 2/10/17 | 9/29/17 | 231 | 253 | Male | ||
289 | 289 | Obama | Director of National Intelligence | James Clapper | 8/9/10 | 1/20/17 | 2356 | 2923 | Male | ||
62 | 62 | Reagan | Secretary of Commerce | Mac Baldrige | 1/20/81 | 7/25/87 | 2377 | 2378 | Male | ||
81 | 81 | Reagan | Secretary of State | George Shultz | 7/16/82 | 1/20/89 | 2380 | 2923 | Male | ||
351 | 351 | Trump | Director of National Intelligence | John Ratcliffe | 5/26/20 | 1/20/21 | 239 | 1462 | Male | ||
261 | 261 | Obama | Secretary of Commerce | John Bryson | 10/21/11 | 6/21/12 | 244 | 1249 | Male | ||
1 | 1 | Carter | OMB Director | Bert Lance | 1/21/77 | 9/23/77 | 245 | 247 | Male | ||
65 | 65 | Reagan | Secretary of Defense | Caspar Weinberger | 1/21/81 | 11/23/87 | 2497 | 2499 | Male | ||
105 | 105 | Bush 41 | Chief of Staff | Sam Skinner | 12/16/91 | 8/23/92 | 251 | 1312 | Male | ||
283 | 283 | Obama | Secretary of Education | Arne Duncan | 1/20/09 | 12/31/15 | 2536 | 2537 | Male | ||
14 | 14 | Carter | Secretary of State | Ed Muskie | 5/8/80 | 1/18/81 | 255 | 1460 | 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 | ||
130 | 130 | Bush 41 | UN Ambassador | Edward Perkins | 5/12/92 | 1/27/93 | 260 | 1469 | Male | ||
353 | 353 | Biden | OSTP Director | Eric Lander | 6/2/21 | 2/18/22 | 261 | 395 | Male | ||
245 | 245 | Bush 43 | OSTP Director | John H. Marburger | 10/29/01 | 1/20/09 | 2640 | 2923 | Male | ||
148 | 148 | Clinton | Secretary of Commerce | Mickey Kantor | 4/12/96 | 1/21/97 | 284 | 1463 | Male | ||
287 | 287 | Obama | OSTP Director | John Holdren | 3/19/09 | 1/19/17 | 2863 | 2922 | Male | ||
172 | 172 | Clinton | Attorney General | Janet Reno | 3/12/93 | 1/20/01 | 2871 | 2923 | Female | ||
164 | 164 | Clinton | Secretary of the Interior | Bruce Babbitt | 1/22/93 | 1/2/01 | 2902 | 2905 | Male | ||
238 | 238 | Bush 43 | Secretary of Labor | Elaine Chao | 1/29/01 | 1/20/09 | 2913 | 2923 | Female | ||
284 | 284 | Obama | Secretary of Agriculture | Tom Vilsack | 1/20/09 | 1/13/17 | 2915 | 2916 | Male | ||
79 | 79 | Reagan | Secretary of Housing & Urban Development | Samuel Pierce Jr. | 1/23/81 | 1/20/89 | 2919 | 2923 | Male | ||
166 | 166 | Clinton | EPA Administrator | Carol Browner | 1/22/93 | 1/19/01 | 2919 | 2922 | Female | ||
178 | 178 | Clinton | Secretary of Health & Human Services | Donna Shalala | 1/22/93 | 1/20/01 | 2920 | 2923 | Female | ||
176 | 176 | Clinton | Secretary of Education | Dick Riley | 1/21/93 | 1/20/01 | 2921 | 2923 | Male | ||
85 | 85 | Reagan | Vice President | George H.W. Bush | 1/20/81 | 1/20/89 | 2922 | 2923 | Male | ||
184 | 184 | Clinton | Vice President | Al Gore | 1/20/93 | 1/20/01 | 2922 | 2923 | Male | ||
244 | 244 | Bush 43 | Vice President | Dick Cheney | 1/20/01 | 1/20/09 | 2922 | 2923 | Male | ||
288 | 288 | Obama | Vice President | Joe Biden | 1/20/09 | 1/20/17 | 2922 | 2923 | Male | ||
350 | 350 | Trump | Chief of Staff | Mark Meadows | 3/31/20 | 1/20/21 | 295 | 1462 | Male | ||
36 | 36 | Reagan | SBA Administrator | Michael Cardenas | 3/30/81 | 2/3/82 | 310 | 380 | Male | ||
308 | 308 | Obama | Secretary of Education | John King Jr. | 3/14/16 | 1/20/17 | 312 | 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 );