cabinet-turnover/cabinet-turnover

Table actions

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

379 rows sorted by president

✎ View and edit SQL

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    

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);