cabinet-turnover/cabinet-turnover

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

312 rows sorted by appointee

descending

Link	rowid	president	position	appointee ▼	start	end	length	days
21	21	Carter	SBA Administrator	A. Vernon Weaver	4/1/77	1/20/81	1390	1462
159	159	Clinton	SBA Administrator	Aida Alvarez	3/7/97	1/20/01	1415	2923
169	169	Clinton	Vice President	Al Gore	1/20/93	1/20/01	2922	2923
201	201	Bush 43	Attorney General	Alberto Gonzales	2/3/05	9/17/07	956	2432
309	309	Trump	Secretary of Health & Human Services	Alex Azar	1/29/18	Still in office
306	306	Trump	Secretary of Labor	Alexander Acosta	4/28/17	Still in office
35	35	Reagan	Secretary of State	Alexander Haig	1/22/81	7/5/82	529	532
165	165	Clinton	Secretary of Labor	Alexis Herman	5/1/97	1/20/01	1360	2923
130	130	Clinton	OMB Director	Alice Rivlin	10/17/94	4/26/96	557	1193
204	204	Bush 43	Secretary of Housing & Urban Development	Alphonso Jackson	3/31/04	4/18/08	1479	2646
164	164	Clinton	Secretary of Housing & Urban Development	Andrew Cuomo	1/29/97	1/20/01	1452	2923
9	9	Carter	UN Ambassador	Andrew Young	1/30/77	9/23/79	966	977
117	117	Bush 41	Secretary of Transportation	Andy Card	3/11/92	1/20/93	315	1462
190	190	Bush 43	Chief of Staff	Andy Card	1/20/01	4/14/06	1910	1911
74	74	Reagan	Secretary of Labor	Ann McLaughlin	12/14/87	1/20/89	403	2923
177	177	Bush 43	Secretary of Agriculture	Ann Veneman	1/20/01	1/20/05	1461	1462
39	39	Reagan	EPA Administrator	Anne Gorsuch	5/20/81	3/9/83	658	779
271	271	Obama	Secretary of Transportation	Anthony Foxx	7/2/13	1/20/17	1298	2923
183	183	Bush 43	Secretary of Veterans Affairs	Anthony Principi	1/23/01	1/26/05	1464	1468
258	258	Obama	Secretary of Education	Arne Duncan	1/20/09	12/31/15	2536	2537
260	260	Obama	Secretary of Defense	Ash Carter	2/17/15	1/19/17	702	2922
110	110	Bush 41	Secretary of Commerce	Barbara Franklin	2/27/92	1/20/93	328	1462
303	303	Trump	Secretary of Housing & Urban Development	Ben Carson	3/2/17	Still in office
15	15	Carter	Attorney General	Ben Civiletti	8/16/79	1/19/81	522	1461
1	1	Carter	OMB Director	Bert Lance	1/21/77	9/23/77	245	247
297	297	Trump	Secretary of Education	Betsy DeVos	2/7/17	Still in office
64	64	Reagan	Secretary of Education	Bill Bennett	2/6/85	9/20/88	1322	2801
50	50	Reagan	U.S. Trade Representative	Bill Brock	1/23/81	4/29/85	1557	1561
59	59	Reagan	Secretary of Labor	Bill Brock	4/29/85	10/31/87	915	2476
148	148	Clinton	Secretary of Commerce	Bill Daley	1/30/97	7/19/00	1266	2738
236	236	Obama	Chief of Staff	Bill Daley	1/13/11	1/27/12	379	1103
145	145	Clinton	UN Ambassador	Bill Richardson	2/18/97	8/18/98	546	2037
162	162	Clinton	Secretary of Energy	Bill Richardson	8/18/98	1/20/01	886	2923
84	84	Reagan	Director of Central Intelligence	Bill Webster	5/26/87	Bush admin	1558 combined
92	92	Bush 41	Director of Central Intelligence	Bill Webster	Reagan admin	8/31/91	1558 combined	954
105	105	Bush 41	Director of Central Intelligence	Bob Gates	11/6/91	1/20/93	441	1462
228	228	Bush 43	Secretary of Defense	Bob Gates	12/18/06	Obama admin	1655 combined
233	233	Obama	Secretary of Defense	Bob Gates	Bush admin	6/30/11	1655 combined	892
279	279	Obama	Secretary of Veterans Affairs	Bob McDonald	7/30/14	1/20/17	905	2923
147	147	Clinton	Secretary of the Treasury	Bob Rubin	1/10/95	7/2/99	1634	2355
2	2	Carter	Secretary of Transportation	Brock Adams	1/23/77	7/20/79	908	912
150	150	Clinton	Secretary of the Interior	Bruce Babbitt	1/22/93	1/2/01	2902	2905
118	118	Bush 41	U.S. Trade Representative	Carla Hills	2/6/89	1/20/93	1444	1462
207	207	Bush 43	Secretary of Commerce	Carlos Gutierrez	2/7/05	1/19/09	1442	2922
151	151	Clinton	EPA Administrator	Carol Browner	1/22/93	1/19/01	2919	2922
60	60	Reagan	Secretary of Defense	Caspar Weinberger	1/21/81	11/23/87	2497	2499
29	29	Carter	Secretary of the Interior	Cecil Andrus	1/23/77	1/20/81	1458	1462
168	168	Clinton	U.S. Trade Representative	Charlene Barshefsky	3/18/97	1/20/01	1404	2923
25	25	Carter	Secretary of Energy	Charles Duncan	8/24/79	1/20/81	515	1462
173	173	Bush 43	EPA Administrator	Christine Todd Whitman	1/31/01	6/27/03	877	889
256	256	Obama	Secretary of Defense	Chuck Hagel	2/27/13	2/17/15	720	2220
78	78	Reagan	U.S. Trade Representative	Clayton Yeutter	7/1/85	1/20/89	1299	2923
89	89	Bush 41	Secretary of Agriculture	Clayton Yeutter	2/16/89	3/1/91	743	771
181	181	Bush 43	Secretary of State	Colin Powell	1/20/01	1/25/05	1466	1467
218	218	Bush 43	Secretary of State	Condoleezza Rice	1/26/05	1/20/09	1455	2923
11	11	Carter	Secretary of State	Cyrus Vance	1/23/77	4/28/80	1191	1195
304	304	Trump	Director of National Intelligence	Dan Coats	3/16/17	Still in office
153	153	Clinton	Secretary of Agriculture	Dan Glickman	3/30/95	1/19/01	2122	2922
119	119	Bush 41	Vice President	Dan Quayle	1/20/89	1/20/93	1461	1462
238	238	Obama	CIA Director	David Petraeus	9/6/11	11/9/12	430	1390
286	286	Trump	Secretary of Veterans Affairs	David Shulkin	2/14/17	3/28/18	407	433
51	51	Reagan	OMB Director	David Stockman	1/21/81	8/1/85	1653	1655
263	263	Obama	Chief of Staff	Denis McDonough	1/25/13	1/20/17	1456	2923
229	229	Obama	Director of National Intelligence	Dennis Blair	1/29/09	5/28/10	484	494
111	111	Bush 41	Secretary of Defense	Dick Cheney	3/21/89	1/20/93	1401	1462
223	223	Bush 43	Vice President	Dick Cheney	1/20/01	1/20/09	2922	2923
107	107	Bush 41	OMB Director	Dick Darman	1/25/89	1/20/93	1456	1462
161	161	Clinton	Secretary of Education	Dick Riley	1/21/93	1/20/01	2921	2923
83	83	Reagan	Attorney General	Dick Thornburgh	8/12/88	Bush admin	1098 combined
91	91	Bush 41	Attorney General	Dick Thornburgh	Reagan admin	8/15/91	1098 combined	938
208	208	Bush 43	Secretary of the Interior	Dirk Kempthorne	5/29/06	1/19/09	966	2922
43	43	Reagan	Secretary of the Treasury	Don Regan	1/22/81	2/2/85	1472	1475
56	56	Reagan	Chief of Staff	Don Regan	2/4/85	2/27/87	753	2230
187	187	Bush 43	Secretary of Commerce	Donald Evans	1/20/01	2/3/05	1475	1476
45	45	Reagan	Secretary of Energy	Donald Hodel	11/5/82	2/7/85	825	1480
76	76	Reagan	Secretary of the Interior	Donald Hodel	2/8/85	1/20/89	1442	2923
32	32	Carter	UN Ambassador	Donald McHenry	9/23/79	1/20/81	485	1462
197	197	Bush 43	Secretary of Defense	Donald Rumsfeld	1/20/01	12/18/06	2158	2159
163	163	Clinton	Secretary of Health & Human Services	Donna Shalala	1/22/93	1/20/01	2920	2923
19	19	Carter	EPA Administrator	Douglas Costle	3/7/77	1/20/81	1415	1462
37	37	Reagan	Secretary of Transportation	Drew Lewis	1/23/81	2/1/83	739	743
99	99	Bush 41	Secretary of Veterans Affairs	Ed Derwinski	3/15/89	9/26/92	1291	1346
109	109	Bush 41	Secretary of Agriculture	Ed Madigan	3/12/91	1/20/93	680	1462
62	62	Reagan	Attorney General	Ed Meese	2/25/85	8/12/88	1264	2762
14	14	Carter	Secretary of State	Ed Muskie	5/8/80	1/18/81	255	1460
212	212	Bush 43	Secretary of Agriculture	Ed Schafer	1/28/08	1/20/09	358	2923
120	120	Bush 41	UN Ambassador	Edward Perkins	5/12/92	1/27/93	260	1469
217	217	Bush 43	Secretary of Labor	Elaine Chao	1/29/01	1/20/09	2913	2923
296	296	Trump	Secretary of Transportation	Elaine Chao	1/31/17	Still in office
58	58	Reagan	Secretary of Transportation	Elizabeth Dole	2/7/83	9/30/87	1696	2445
87	87	Bush 41	Secretary of Labor	Elizabeth Dole	1/25/89	11/23/90	667	673
257	257	Obama	Attorney General	Eric Holder	2/3/09	4/24/15	2271	2286
252	252	Obama	Secretary of Veterans Affairs	Eric Shinseki	1/21/09	5/30/14	1955	1957
268	268	Obama	Secretary of Energy	Ernest Moniz	5/21/13	1/20/17	1340	2923
124	124	Clinton	SBA Administrator	Erskine Bowles	5/12/93	10/6/94	512	625
146	146	Clinton	Chief of Staff	Erskine Bowles	1/20/97	10/20/98	638	2100
141	141	Clinton	Secretary of Transportation	Federico Peña	1/21/93	2/14/97	1485	1487
144	144	Clinton	Secretary of Energy	Federico Peña	3/12/97	6/30/98	475	1988
70	70	Reagan	Secretary of Defense	Frank Carlucci	11/23/87	1/20/89	424	2923
143	143	Clinton	OMB Director	Frank Raines	9/13/96	5/21/98	615	1948

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