cabinet-turnover/cabinet-turnover

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

312 rows sorted by president

descending

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

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "cabinet-turnover/cabinet-turnover" (
"president" TEXT,
  "position" TEXT,
  "appointee" TEXT,
  "start" TEXT,
  "end" TEXT,
  "length" TEXT,
  "days" INTEGER
);