cabinet-turnover/cabinet-turnover

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

312 rows sorted by president

View and edit SQL

Suggested facets: president, position

Link rowid president ▼ position appointee start end length days
87 Bush 41 Secretary of Labor Elizabeth Dole 1/25/89 11/23/90 667 673
88 Bush 41 Secretary of Education Lauro Cavazos Reagan admin 12/15/90 816 combined 695
89 Bush 41 Secretary of Agriculture Clayton Yeutter 2/16/89 3/1/91 743 771
90 Bush 41 SBA Administrator Susan Engeleiter 4/20/89 3/27/91 706 797
91 Bush 41 Attorney General Dick Thornburgh Reagan admin 8/15/91 1098 combined 938
92 Bush 41 Director of Central Intelligence Bill Webster Reagan admin 8/31/91 1558 combined 954
93 Bush 41 Secretary of Transportation Sam Skinner 2/6/89 12/13/91 1040 1058
94 Bush 41 Chief of Staff John Sununu 1/20/89 12/15/91 1059 1060
95 Bush 41 Secretary of Commerce Robert Mosbacher 1/31/89 1/15/92 1079 1091
96 Bush 41 UN Ambassador Tom Pickering 3/20/89 5/7/92 1144 1204
97 Bush 41 Chief of Staff Sam Skinner 12/16/91 8/23/92 251 1312
98 Bush 41 Secretary of State James Baker 1/25/89 8/23/92 1306 1312
99 Bush 41 Secretary of Veterans Affairs Ed Derwinski 3/15/89 9/26/92 1291 1346
100 Bush 41 Attorney General William Barr 11/26/91 1/15/93 416 1457
101 Bush 41 Secretary of the Treasury Nicholas Brady Reagan admin 1/17/93 1584 combined 1459
102 Bush 41 Secretary of Housing & Urban Development Jack Kemp 2/13/89 1/19/93 1436 1461
103 Bush 41 Secretary of State Lawrence Eagleburger 12/8/92 1/19/93 42 1461
104 Bush 41 Chief of Staff James Baker 8/23/92 1/20/93 150 1462
105 Bush 41 Director of Central Intelligence Bob Gates 11/6/91 1/20/93 441 1462
106 Bush 41 EPA Administrator William Reilly 2/6/89 1/20/93 1444 1462
107 Bush 41 OMB Director Dick Darman 1/25/89 1/20/93 1456 1462
108 Bush 41 SBA Administrator Pat Saiki 3/27/91 1/20/93 665 1462
109 Bush 41 Secretary of Agriculture Ed Madigan 3/12/91 1/20/93 680 1462
110 Bush 41 Secretary of Commerce Barbara Franklin 2/27/92 1/20/93 328 1462
111 Bush 41 Secretary of Defense Dick Cheney 3/21/89 1/20/93 1401 1462
112 Bush 41 Secretary of Education Lamar Alexander 3/18/91 1/20/93 674 1462
113 Bush 41 Secretary of Energy James Watkins 3/1/89 1/20/93 1421 1462
114 Bush 41 Secretary of Health & Human Services Louis Sullivan 3/1/89 1/20/93 1421 1462
115 Bush 41 Secretary of Labor Lynn Morley Martin 2/7/91 1/20/93 713 1462
116 Bush 41 Secretary of the Interior Manuel Luján Jr. 2/3/89 1/20/93 1447 1462
117 Bush 41 Secretary of Transportation Andy Card 3/11/92 1/20/93 315 1462
118 Bush 41 U.S. Trade Representative Carla Hills 2/6/89 1/20/93 1444 1462
119 Bush 41 Vice President Dan Quayle 1/20/89 1/20/93 1461 1462
120 Bush 41 UN Ambassador Edward Perkins 5/12/92 1/27/93 260 1469
171 Bush 43 Secretary of the Treasury Paul O'Neill 1/30/01 12/31/02 700 711
172 Bush 43 OMB Director Mitch Daniels 1/23/01 6/6/03 864 868
173 Bush 43 EPA Administrator Christine Todd Whitman 1/31/01 6/27/03 877 889
174 Bush 43 Secretary of Housing & Urban Development Mel Martinez 1/24/01 12/12/03 1052 1057
175 Bush 43 UN Ambassador John Negroponte 9/19/01 6/23/04 1008 1251
176 Bush 43 Director of Central Intelligence George Tenet Clinton admin 7/11/04 2557 combined 1269
177 Bush 43 Secretary of Agriculture Ann Veneman 1/20/01 1/20/05 1461 1462
178 Bush 43 Secretary of Education Rod Paige 1/24/01 1/20/05 1457 1462
179 Bush 43 UN Ambassador John Danforth 7/23/04 1/20/05 181 1462
180 Bush 43 EPA Administrator Mike Leavitt 11/6/03 1/25/05 446 1467
181 Bush 43 Secretary of State Colin Powell 1/20/01 1/25/05 1466 1467
182 Bush 43 Secretary of Health & Human Services Tommy Thompson 2/2/01 1/26/05 1454 1468
183 Bush 43 Secretary of Veterans Affairs Anthony Principi 1/23/01 1/26/05 1464 1468
184 Bush 43 Secretary of Energy Spencer Abraham 1/20/01 1/31/05 1472 1473
185 Bush 43 Secretary of Homeland Security Tom Ridge 1/24/03 2/1/05 739 1474
186 Bush 43 Attorney General John Ashcroft 2/2/01 2/3/05 1462 1476
187 Bush 43 Secretary of Commerce Donald Evans 1/20/01 2/3/05 1475 1476
188 Bush 43 U.S. Trade Representative Robert Zoellick 2/7/01 2/22/05 1476 1495
189 Bush 43 Secretary of the Interior Gale Norton 1/31/01 3/31/06 1885 1897
190 Bush 43 Chief of Staff Andy Card 1/20/01 4/14/06 1910 1911
191 Bush 43 OMB Director Josh Bolten 6/26/03 4/14/06 1023 1911
192 Bush 43 Director of Central Intelligence/CIA Director Porter Goss 9/24/04 5/5/06 588 1932
193 Bush 43 U.S. Trade Representative Rob Portman 5/17/05 5/26/06 374 1953
194 Bush 43 Secretary of the Treasury John Snow 2/3/03 6/29/06 1242 1987
195 Bush 43 SBA Administrator Hector Barreto 7/25/01 7/2/06 1803 1990
196 Bush 43 Secretary of Transportation Norman Mineta 1/25/01 7/7/06 1989 1995
197 Bush 43 Secretary of Defense Donald Rumsfeld 1/20/01 12/18/06 2158 2159
198 Bush 43 UN Ambassador John Bolton 8/2/05 12/31/06 516 2172
199 Bush 43 Director of National Intelligence John Negroponte 4/21/05 2/13/07 663 2216
200 Bush 43 OMB Director Rob Portman 5/26/06 8/3/07 434 2387
201 Bush 43 Attorney General Alberto Gonzales 2/3/05 9/17/07 956 2432
202 Bush 43 Secretary of Agriculture Mike Johanns 1/21/05 9/20/07 972 2435
203 Bush 43 Secretary of Veterans Affairs Jim Nicholson 2/1/05 10/1/07 972 2446
204 Bush 43 Secretary of Housing & Urban Development Alphonso Jackson 3/31/04 4/18/08 1479 2646
205 Bush 43 SBA Administrator Steve Preston 7/10/06 6/5/08 696 2694
206 Bush 43 OMB Director Jim Nussle 9/4/07 1/19/09 503 2922
207 Bush 43 Secretary of Commerce Carlos Gutierrez 2/7/05 1/19/09 1442 2922
208 Bush 43 Secretary of the Interior Dirk Kempthorne 5/29/06 1/19/09 966 2922
209 Bush 43 Attorney General Michael Mukasey 11/9/07 1/20/09 438 2923
210 Bush 43 Chief of Staff Josh Bolten 4/14/06 1/20/09 1012 2923
211 Bush 43 EPA Administrator Stephen Johnson 5/2/05 1/20/09 1359 2923
212 Bush 43 Secretary of Agriculture Ed Schafer 1/28/08 1/20/09 358 2923
213 Bush 43 Secretary of Education Margaret Spellings 1/24/05 1/20/09 1457 2923
214 Bush 43 Secretary of Energy Samuel Bodman 2/1/05 1/20/09 1449 2923
215 Bush 43 Secretary of Health & Human Services Mike Leavitt 1/26/05 1/20/09 1455 2923
216 Bush 43 Secretary of Housing & Urban Development Steve Preston 6/5/08 1/20/09 229 2923
217 Bush 43 Secretary of Labor Elaine Chao 1/29/01 1/20/09 2913 2923
218 Bush 43 Secretary of State Condoleezza Rice 1/26/05 1/20/09 1455 2923
219 Bush 43 Secretary of the Treasury Hank Paulson 7/10/06 1/20/09 925 2923
220 Bush 43 Secretary of Transportation Mary Peters 10/17/06 1/20/09 826 2923
221 Bush 43 Secretary of Veterans Affairs James Peake 12/20/07 1/20/09 397 2923
222 Bush 43 U.S. Trade Representative Susan Schwab 6/8/06 1/20/09 957 2923
223 Bush 43 Vice President Dick Cheney 1/20/01 1/20/09 2922 2923
224 Bush 43 Secretary of Homeland Security Michael Chertoff 2/15/05 1/21/09 1436 2924
225 Bush 43 UN Ambassador Zalmay Khalilzad 4/30/07 1/22/09 633 2925
226 Bush 43 Director of National Intelligence Mike McConnell 2/13/07 1/27/09 714 2930
227 Bush 43 CIA Director Michael Hayden 5/30/06 2/12/09 989 2946
228 Bush 43 Secretary of Defense Bob Gates 12/18/06 Obama admin 1655 combined  
1 Carter OMB Director Bert Lance 1/21/77 9/23/77 245 247
2 Carter Secretary of Transportation Brock Adams 1/23/77 7/20/79 908 912
3 Carter Secretary of Health, Education & Welfare Joseph Califano Jr. 1/25/77 8/3/79 920 926
4 Carter Secretary of Housing & Urban Development Patricia Harris 1/23/77 8/3/79 922 926
5 Carter Secretary of the Treasury W. Michael Blumenthal 1/23/77 8/4/79 923 927
6 Carter Attorney General Griffin Bell 1/26/77 8/16/79 932 939
7 Carter U.S. Trade Representative Robert Strauss 3/30/77 8/17/79 870 940
8 Carter Secretary of Energy James Schlesinger 8/6/77 8/23/79 747 946

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" TEXT,
  "end" TEXT,
  "length" TEXT,
  "days" INTEGER
);
Powered by Datasette · Query took 59.698ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub