cabinet-turnover/cabinet-turnover

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

312 rows sorted by position

descending

Link	rowid	president	position ▼	appointee	start	end	length	days
6	6	Carter	Attorney General	Griffin Bell	1/26/77	8/16/79	932	939
15	15	Carter	Attorney General	Ben Civiletti	8/16/79	1/19/81	522	1461
47	47	Reagan	Attorney General	William French Smith	1/23/81	2/25/85	1494	1498
62	62	Reagan	Attorney General	Ed Meese	2/25/85	8/12/88	1264	2762
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
100	100	Bush 41	Attorney General	William Barr	11/26/91	1/15/93	416	1457
157	157	Clinton	Attorney General	Janet Reno	3/12/93	1/20/01	2871	2923
186	186	Bush 43	Attorney General	John Ashcroft	2/2/01	2/3/05	1462	1476
201	201	Bush 43	Attorney General	Alberto Gonzales	2/3/05	9/17/07	956	2432
209	209	Bush 43	Attorney General	Michael Mukasey	11/9/07	1/20/09	438	2923
257	257	Obama	Attorney General	Eric Holder	2/3/09	4/24/15	2271	2286
280	280	Obama	Attorney General	Loretta Lynch	4/27/15	1/20/17	634	2923
290	290	Trump	Attorney General	Jeff Sessions	2/9/17	11/7/18	636	657
227	227	Bush 43	CIA Director	Michael Hayden	5/30/06	2/12/09	989	2946
232	232	Obama	CIA Director	Leon Panetta	2/13/09	6/30/11	867	892
238	238	Obama	CIA Director	David Petraeus	9/6/11	11/9/12	430	1390
266	266	Obama	CIA Director	John Brennan	3/8/13	1/20/17	1414	2923
288	288	Trump	CIA Director	Mike Pompeo	1/23/17	4/26/18	458	462
311	311	Trump	CIA Director	Gina Haspel	5/21/18	Still in office
12	12	Carter	Chief of Staff	Hamilton Jordan	7/18/79	6/11/80	329	1239
17	17	Carter	Chief of Staff	Jack Watson	6/11/80	1/20/81	223	1462
44	44	Reagan	Chief of Staff	James Baker	1/20/81	2/3/85	1475	1476
56	56	Reagan	Chief of Staff	Don Regan	2/4/85	2/27/87	753	2230
61	61	Reagan	Chief of Staff	Howard Baker	3/2/87	7/1/88	487	2720
66	66	Reagan	Chief of Staff	Kenneth Duberstein	7/1/88	1/20/89	203	2923
94	94	Bush 41	Chief of Staff	John Sununu	1/20/89	12/15/91	1059	1060
97	97	Bush 41	Chief of Staff	Sam Skinner	12/16/91	8/23/92	251	1312
104	104	Bush 41	Chief of Staff	James Baker	8/23/92	1/20/93	150	1462
122	122	Clinton	Chief of Staff	Mack McLarty	1/20/93	7/17/94	543	544
135	135	Clinton	Chief of Staff	Leon Panetta	7/17/94	1/20/97	918	1462
146	146	Clinton	Chief of Staff	Erskine Bowles	1/20/97	10/20/98	638	2100
158	158	Clinton	Chief of Staff	John Podesta	10/20/98	1/20/01	823	2923
190	190	Bush 43	Chief of Staff	Andy Card	1/20/01	4/14/06	1910	1911
210	210	Bush 43	Chief of Staff	Josh Bolten	4/14/06	1/20/09	1012	2923
231	231	Obama	Chief of Staff	Rahm Emanuel	1/20/09	10/1/10	619	620
236	236	Obama	Chief of Staff	Bill Daley	1/13/11	1/27/12	379	1103
241	241	Obama	Chief of Staff	Jack Lew	1/30/12	1/25/13	361	1467
263	263	Obama	Chief of Staff	Denis McDonough	1/25/13	1/20/17	1456	2923
283	283	Trump	Chief of Staff	Reince Priebus	1/20/17	7/28/17	189	190
293	293	Trump	Chief of Staff	John Kelly	7/31/17	12/31/18	518	711
18	18	Carter	Director of Central Intelligence	Stansfield Turner	3/9/77	1/20/81	1413	1462
55	55	Reagan	Director of Central Intelligence	William Casey	1/28/81	1/29/87	2192	2201
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
127	127	Clinton	Director of Central Intelligence	Jim Woolsey	2/5/93	1/10/95	704	721
131	131	Clinton	Director of Central Intelligence	John Deutch	5/10/95	12/15/96	585	1426
170	170	Clinton	Director of Central Intelligence	George Tenet	7/11/97	Bush admin	2557 combined
176	176	Bush 43	Director of Central Intelligence	George Tenet	Clinton admin	7/11/04	2557 combined	1269
192	192	Bush 43	Director of Central Intelligence/CIA Director	Porter Goss	9/24/04	5/5/06	588	1932
199	199	Bush 43	Director of National Intelligence	John Negroponte	4/21/05	2/13/07	663	2216
226	226	Bush 43	Director of National Intelligence	Mike McConnell	2/13/07	1/27/09	714	2930
229	229	Obama	Director of National Intelligence	Dennis Blair	1/29/09	5/28/10	484	494
262	262	Obama	Director of National Intelligence	James Clapper	8/9/10	1/20/17	2356	2923
304	304	Trump	Director of National Intelligence	Dan Coats	3/16/17	Still in office
19	19	Carter	EPA Administrator	Douglas Costle	3/7/77	1/20/81	1415	1462
39	39	Reagan	EPA Administrator	Anne Gorsuch	5/20/81	3/9/83	658	779
42	42	Reagan	EPA Administrator	William Ruckelshaus	5/18/83	1/4/85	597	1446
67	67	Reagan	EPA Administrator	Lee Thomas	2/8/85	1/20/89	1442	2923
106	106	Bush 41	EPA Administrator	William Reilly	2/6/89	1/20/93	1444	1462
151	151	Clinton	EPA Administrator	Carol Browner	1/22/93	1/19/01	2919	2922
173	173	Bush 43	EPA Administrator	Christine Todd Whitman	1/31/01	6/27/03	877	889
180	180	Bush 43	EPA Administrator	Mike Leavitt	11/6/03	1/25/05	446	1467
211	211	Bush 43	EPA Administrator	Stephen Johnson	5/2/05	1/20/09	1359	2923
243	243	Obama	EPA Administrator	Lisa Jackson	1/26/09	2/14/13	1480	1487
272	272	Obama	EPA Administrator	Gina McCarthy	7/19/13	1/20/17	1281	2923
289	289	Trump	EPA Administrator	Scott Pruitt	2/17/17	7/6/18	504	533
1	1	Carter	OMB Director	Bert Lance	1/21/77	9/23/77	245	247
20	20	Carter	OMB Director	Jim McIntyre	9/24/77	1/20/81	1214	1462
51	51	Reagan	OMB Director	David Stockman	1/21/81	8/1/85	1653	1655
65	65	Reagan	OMB Director	Jim Miller	10/8/85	10/15/88	1103	2826
68	68	Reagan	OMB Director	Joseph Wright Jr.	11/8/88	1/20/89	73	2923
107	107	Bush 41	OMB Director	Dick Darman	1/25/89	1/20/93	1456	1462
123	123	Clinton	OMB Director	Leon Panetta	1/21/93	7/17/94	542	544
130	130	Clinton	OMB Director	Alice Rivlin	10/17/94	4/26/96	557	1193
143	143	Clinton	OMB Director	Frank Raines	9/13/96	5/21/98	615	1948
152	152	Clinton	OMB Director	Jack Lew	5/21/98	1/19/01	974	2922
172	172	Bush 43	OMB Director	Mitch Daniels	1/23/01	6/6/03	864	868
191	191	Bush 43	OMB Director	Josh Bolten	6/26/03	4/14/06	1023	1911
200	200	Bush 43	OMB Director	Rob Portman	5/26/06	8/3/07	434	2387
206	206	Bush 43	OMB Director	Jim Nussle	9/4/07	1/19/09	503	2922
230	230	Obama	OMB Director	Peter Orszag	1/20/09	7/30/10	556	557
235	235	Obama	OMB Director	Jack Lew	11/18/10	1/26/12	434	1102
254	254	Obama	OMB Director	Sylvia Burwell	4/26/13	6/8/14	408	1966
277	277	Obama	OMB Director	Shaun Donovan	7/28/14	1/20/17	907	2923
300	300	Trump	OMB Director	Mick Mulvaney	2/16/17	Still in office
21	21	Carter	SBA Administrator	A. Vernon Weaver	4/1/77	1/20/81	1390	1462
34	34	Reagan	SBA Administrator	Michael Cardenas	3/30/81	2/3/82	310	380
54	54	Reagan	SBA Administrator	James Sanders	3/29/82	3/31/86	1463	1897
82	82	Reagan	SBA Administrator	James Abdnor	3/23/87	4/20/89	759	3013
90	90	Bush 41	SBA Administrator	Susan Engeleiter	4/20/89	3/27/91	706	797
108	108	Bush 41	SBA Administrator	Pat Saiki	3/27/91	1/20/93	665	1462
124	124	Clinton	SBA Administrator	Erskine Bowles	5/12/93	10/6/94	512	625
140	140	Clinton	SBA Administrator	Philip Lader	10/8/94	2/11/97	857	1484
159	159	Clinton	SBA Administrator	Aida Alvarez	3/7/97	1/20/01	1415	2923
195	195	Bush 43	SBA Administrator	Hector Barreto	7/25/01	7/2/06	1803	1990
205	205	Bush 43	SBA Administrator	Steve Preston	7/10/06	6/5/08	696	2694
250	250	Obama	SBA Administrator	Karen Mills	4/6/09	9/1/13	1609	1686
275	275	Obama	SBA Administrator	Maria Contreras-Sweet	4/7/14	1/20/17	1019	2923

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