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 position descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
34 | 34 | Carter | Vice President | Walter Mondale | 1/20/77 | 1/20/81 | 1461 | 1462 | Male | ||
85 | 85 | Reagan | Vice President | George H.W. Bush | 1/20/81 | 1/20/89 | 2922 | 2923 | Male | ||
128 | 128 | Bush 41 | Vice President | Dan Quayle | 1/20/89 | 1/20/93 | 1461 | 1462 | 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 | ||
334 | 334 | Trump | Vice President | Mike Pence | 1/20/17 | 1/20/21 | 1461 | 1462 | Male | ||
355 | 355 | Biden | Vice President | Kamala Harris | 1/20/21 | Still in office | Female | ||||
9 | 9 | Carter | UN Ambassador | Andrew Young | 1/30/77 | 9/23/79 | 966 | 977 | Male | ||
33 | 33 | Carter | UN Ambassador | Donald McHenry | 9/23/79 | 1/20/81 | 485 | 1462 | Male | ||
53 | 53 | Reagan | UN Ambassador | Jeane Kirkpatrick | 2/4/81 | 4/1/85 | 1517 | 1533 | Female | ||
87 | 87 | Reagan | UN Ambassador | Vernon Walters | 5/22/85 | 3/15/89 | 1393 | 2977 | Male | ||
104 | 104 | Bush 41 | UN Ambassador | Tom Pickering | 3/20/89 | 5/7/92 | 1144 | 1204 | Male | ||
130 | 130 | Bush 41 | UN Ambassador | Edward Perkins | 5/12/92 | 1/27/93 | 260 | 1469 | Male | ||
149 | 149 | Clinton | UN Ambassador | Madeleine Albright | 1/27/93 | 1/21/97 | 1455 | 1463 | Female | ||
158 | 158 | Clinton | UN Ambassador | Bill Richardson | 2/18/97 | 8/18/98 | 546 | 2037 | Male | ||
171 | 171 | Clinton | UN Ambassador | Richard Holbrooke | 9/7/99 | 1/19/01 | 500 | 2922 | Male | ||
192 | 192 | Bush 43 | UN Ambassador | John Negroponte | 9/19/01 | 6/23/04 | 1008 | 1251 | Male | ||
196 | 196 | Bush 43 | UN Ambassador | John Danforth | 7/23/04 | 1/20/05 | 181 | 1462 | Male | ||
218 | 218 | Bush 43 | UN Ambassador | John Bolton | 8/2/05 | 12/31/06 | 516 | 2172 | Male | ||
247 | 247 | Bush 43 | UN Ambassador | Zalmay Khalilzad | 4/30/07 | 1/22/09 | 633 | 2925 | Male | ||
272 | 272 | Obama | UN Ambassador | Susan Rice | 1/26/09 | 6/30/13 | 1616 | 1623 | Female | ||
309 | 309 | Obama | UN Ambassador | Samantha Power | 8/5/13 | 1/21/17 | 1265 | 2924 | Female | ||
319 | 319 | Trump | UN Ambassador | Nikki Haley | 1/25/17 | 12/31/18 | 705 | 711 | Female | ||
346 | 346 | Trump | UN Ambassador | Kelly Craft | 9/10/19 | 1/20/21 | 498 | 1462 | Female | ||
375 | 375 | Biden | UN Ambassador | Linda Thomas-Greenfield | 2/24/21 | Still in office | Female | ||||
7 | 7 | Carter | U.S. Trade Representative | Robert Strauss | 3/30/77 | 8/17/79 | 870 | 940 | Male | ||
13 | 13 | Carter | U.S. Trade Representative | Reubin Askew | 10/1/79 | 12/31/80 | 457 | 1442 | Male | ||
54 | 54 | Reagan | U.S. Trade Representative | Bill Brock | 1/23/81 | 4/29/85 | 1557 | 1561 | Male | ||
84 | 84 | Reagan | U.S. Trade Representative | Clayton Yeutter | 7/1/85 | 1/20/89 | 1299 | 2923 | Male | ||
127 | 127 | Bush 41 | U.S. Trade Representative | Carla Hills | 2/6/89 | 1/20/93 | 1444 | 1462 | Female | ||
140 | 140 | Clinton | U.S. Trade Representative | Mickey Kantor | 1/22/93 | 4/12/96 | 1176 | 1179 | Male | ||
183 | 183 | Clinton | U.S. Trade Representative | Charlene Barshefsky | 3/18/97 | 1/20/01 | 1404 | 2923 | Female | ||
206 | 206 | Bush 43 | U.S. Trade Representative | Robert Zoellick | 2/7/01 | 2/22/05 | 1476 | 1495 | Male | ||
213 | 213 | Bush 43 | U.S. Trade Representative | Rob Portman | 5/17/05 | 5/26/06 | 374 | 1953 | Male | ||
243 | 243 | Bush 43 | U.S. Trade Representative | Susan Schwab | 6/8/06 | 1/20/09 | 957 | 2923 | Female | ||
269 | 269 | Obama | U.S. Trade Representative | Ron Kirk | 3/20/09 | 3/15/13 | 1456 | 1516 | Male | ||
296 | 296 | Obama | U.S. Trade Representative | Michael Froman | 6/21/13 | 1/20/17 | 1309 | 2923 | Male | ||
339 | 339 | Trump | U.S. Trade Representative | Robert Lighthizer | 5/15/17 | 1/20/21 | 1346 | 1462 | Male | ||
374 | 374 | Biden | U.S. Trade Representative | Katherine Tai | 3/18/21 | Still in office | Female | ||||
5 | 5 | Carter | Secretary of the Treasury | W. Michael Blumenthal | 1/23/77 | 8/4/79 | 923 | 927 | Male | ||
31 | 31 | Carter | Secretary of the Treasury | G. William Miller | 8/6/79 | 1/20/81 | 533 | 1462 | Male | ||
47 | 47 | Reagan | Secretary of the Treasury | Don Regan | 1/22/81 | 2/2/85 | 1472 | 1475 | Male | ||
68 | 68 | Reagan | Secretary of the Treasury | James Baker | 2/3/85 | 8/17/88 | 1291 | 2767 | 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 | ||
135 | 135 | Clinton | Secretary of the Treasury | Lloyd Bentsen | 1/22/93 | 12/22/94 | 699 | 702 | Male | ||
160 | 160 | Clinton | Secretary of the Treasury | Bob Rubin | 1/10/95 | 7/2/99 | 1634 | 2355 | Male | ||
181 | 181 | Clinton | Secretary of the Treasury | Larry Summers | 7/2/99 | 1/20/01 | 568 | 2923 | Male | ||
187 | 187 | Bush 43 | Secretary of the Treasury | Paul O'Neill | 1/30/01 | 12/31/02 | 700 | 711 | Male | ||
214 | 214 | Bush 43 | Secretary of the Treasury | John Snow | 2/3/03 | 6/29/06 | 1242 | 1987 | Male | ||
240 | 240 | Bush 43 | Secretary of the Treasury | Hank Paulson | 7/10/06 | 1/20/09 | 925 | 2923 | Male | ||
264 | 264 | Obama | Secretary of the Treasury | Tim Geithner | 1/26/09 | 1/25/13 | 1460 | 1467 | Male | ||
292 | 292 | Obama | Secretary of the Treasury | Jack Lew | 2/28/13 | 1/20/17 | 1422 | 2923 | Male | ||
335 | 335 | Trump | Secretary of the Treasury | Steve Mnuchin | 2/13/17 | 1/20/21 | 1437 | 1462 | Male | ||
357 | 357 | Biden | Secretary of the Treasury | Janet Yellen | 1/26/21 | Still in office | Female | ||||
30 | 30 | Carter | Secretary of the Interior | Cecil Andrus | 1/23/77 | 1/20/81 | 1458 | 1462 | Male | ||
43 | 43 | Reagan | Secretary of the Interior | James Watt | 1/23/81 | 11/8/83 | 1019 | 1023 | Male | ||
50 | 50 | Reagan | Secretary of the Interior | William Clark | 11/18/83 | 2/7/85 | 447 | 1480 | Male | ||
82 | 82 | Reagan | Secretary of the Interior | Donald Hodel | 2/8/85 | 1/20/89 | 1442 | 2923 | Male | ||
125 | 125 | Bush 41 | Secretary of the Interior | Manuel Luján Jr. | 2/3/89 | 1/20/93 | 1447 | 1462 | Male | ||
164 | 164 | Clinton | Secretary of the Interior | Bruce Babbitt | 1/22/93 | 1/2/01 | 2902 | 2905 | Male | ||
209 | 209 | Bush 43 | Secretary of the Interior | Gale Norton | 1/31/01 | 3/31/06 | 1885 | 1897 | Female | ||
228 | 228 | Bush 43 | Secretary of the Interior | Dirk Kempthorne | 5/29/06 | 1/19/09 | 966 | 2922 | Male | ||
270 | 270 | Obama | Secretary of the Interior | Ken Salazar | 1/20/09 | 4/12/13 | 1543 | 1544 | Male | ||
294 | 294 | Obama | Secretary of the Interior | Sally Jewell | 4/12/13 | 1/20/17 | 1379 | 2923 | Female | ||
321 | 321 | Trump | Secretary of the Interior | Ryan Zinke | 3/1/17 | 1/2/19 | 672 | 713 | Male | ||
345 | 345 | Trump | Secretary of the Interior | David Bernhardt | 4/11/19 | 1/20/21 | 650 | 1462 | Male | ||
360 | 360 | Biden | Secretary of the Interior | Deb Haaland | 3/16/21 | Still in office | Female | ||||
107 | 107 | Bush 41 | Secretary of Veterans Affairs | Ed Derwinski | 3/15/89 | 9/26/92 | 1291 | 1346 | Male | ||
154 | 154 | Clinton | Secretary of Veterans Affairs | Jesse Brown | 1/23/93 | 7/3/97 | 1622 | 1626 | Male | ||
163 | 163 | Clinton | Secretary of Veterans Affairs | Togo West Jr. | 5/5/98 | 7/25/00 | 812 | 2744 | Male | ||
200 | 200 | Bush 43 | Secretary of Veterans Affairs | Anthony Principi | 1/23/01 | 1/26/05 | 1464 | 1468 | Male | ||
223 | 223 | Bush 43 | Secretary of Veterans Affairs | Jim Nicholson | 2/1/05 | 10/1/07 | 972 | 2446 | Male | ||
242 | 242 | Bush 43 | Secretary of Veterans Affairs | James Peake | 12/20/07 | 1/20/09 | 397 | 2923 | Male | ||
277 | 277 | Obama | Secretary of Veterans Affairs | Eric Shinseki | 1/21/09 | 5/30/14 | 1955 | 1957 | Male | ||
306 | 306 | Obama | Secretary of Veterans Affairs | Bob McDonald | 7/30/14 | 1/20/17 | 905 | 2923 | Male | ||
313 | 313 | Trump | Secretary of Veterans Affairs | David Shulkin | 2/14/17 | 3/28/18 | 407 | 433 | Male | ||
343 | 343 | Trump | Secretary of Veterans Affairs | Robert Wilkie | 7/30/18 | 1/20/21 | 905 | 1462 | Male | ||
369 | 369 | Biden | Secretary of Veterans Affairs | Denis McDonough | 2/9/21 | Still in office | Male | ||||
2 | 2 | Carter | Secretary of Transportation | Brock Adams | 1/23/77 | 7/20/79 | 908 | 912 | Male | ||
32 | 32 | Carter | Secretary of Transportation | Neil Goldschmidt | 8/15/79 | 1/20/81 | 524 | 1462 | Male | ||
40 | 40 | Reagan | Secretary of Transportation | Drew Lewis | 1/23/81 | 2/1/83 | 739 | 743 | Male | ||
63 | 63 | Reagan | Secretary of Transportation | Elizabeth Dole | 2/7/83 | 9/30/87 | 1696 | 2445 | Female | ||
83 | 83 | Reagan | Secretary of Transportation | James Burnley IV | 12/3/87 | 1/20/89 | 414 | 2923 | Male | ||
101 | 101 | Bush 41 | Secretary of Transportation | Sam Skinner | 2/6/89 | 12/13/91 | 1040 | 1058 | Male | ||
126 | 126 | Bush 41 | Secretary of Transportation | Andy Card | 3/11/92 | 1/20/93 | 315 | 1462 | Male | ||
153 | 153 | Clinton | Secretary of Transportation | Federico Peña | 1/21/93 | 2/14/97 | 1485 | 1487 | Male | ||
182 | 182 | Clinton | Secretary of Transportation | Rodney Slater | 2/14/97 | 1/20/01 | 1436 | 2923 | Male | ||
216 | 216 | Bush 43 | Secretary of Transportation | Norman Mineta | 1/25/01 | 7/7/06 | 1989 | 1995 | Male | ||
241 | 241 | Bush 43 | Secretary of Transportation | Mary Peters | 10/17/06 | 1/20/09 | 826 | 2923 | Female | ||
273 | 273 | Obama | Secretary of Transportation | Ray LaHood | 1/23/09 | 7/2/13 | 1621 | 1625 | Male | ||
298 | 298 | Obama | Secretary of Transportation | Anthony Foxx | 7/2/13 | 1/20/17 | 1298 | 2923 | Male | ||
332 | 332 | Trump | Secretary of Transportation | Elaine Chao | 1/31/17 | 1/11/21 | 1441 | 1453 | Female | ||
366 | 366 | Biden | Secretary of Transportation | Pete Buttigieg | 2/3/21 | Still in office | Male | ||||
11 | 11 | Carter | Secretary of State | Cyrus Vance | 1/23/77 | 4/28/80 | 1191 | 1195 | Male | ||
14 | 14 | Carter | Secretary of State | Ed Muskie | 5/8/80 | 1/18/81 | 255 | 1460 | Male | ||
37 | 37 | Reagan | Secretary of State | Alexander Haig | 1/22/81 | 7/5/82 | 529 | 532 | Male | ||
81 | 81 | Reagan | Secretary of State | George Shultz | 7/16/82 | 1/20/89 | 2380 | 2923 | Male | ||
106 | 106 | Bush 41 | Secretary of State | James Baker | 1/25/89 | 8/23/92 | 1306 | 1312 | 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 );