fivethirtyeight

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

Custom SQL query returning 101 rows (hide)

rowidpresidentpositionappointeestartendlengthdays
83 Reagan Attorney General Dick Thornburgh 8/12/88 Bush admin 1098 combined  
84 Reagan Director of Central Intelligence Bill Webster 5/26/87 Bush admin 1558 combined  
85 Reagan Secretary of Education Lauro Cavazos 9/20/88 Bush admin 816 combined  
86 Reagan Secretary of the Treasury Nicholas Brady 9/16/88 Bush admin 1584 combined  
170 Clinton Director of Central Intelligence George Tenet 7/11/97 Bush admin 2557 combined  
228 Bush 43 Secretary of Defense Bob Gates 12/18/06 Obama admin 1655 combined  
295 Trump Vice President Mike Pence 1/20/17 Still in office    
296 Trump Secretary of Transportation Elaine Chao 1/31/17 Still in office    
297 Trump Secretary of Education Betsy DeVos 2/7/17 Still in office    
298 Trump Secretary of the Treasury Steve Mnuchin 2/13/17 Still in office    
299 Trump SBA Administrator Linda McMahon 2/14/17 Still in office    
300 Trump OMB Director Mick Mulvaney 2/16/17 Still in office    
301 Trump Secretary of Commerce Wilbur Ross 2/28/17 Still in office    
302 Trump Secretary of Energy Rick Perry 3/2/17 Still in office    
303 Trump Secretary of Housing & Urban Development Ben Carson 3/2/17 Still in office    
304 Trump Director of National Intelligence Dan Coats 3/16/17 Still in office    
305 Trump Secretary of Agriculture Sonny Perdue 4/25/17 Still in office    
306 Trump Secretary of Labor Alexander Acosta 4/28/17 Still in office    
307 Trump U.S. Trade Representative Robert Lighthizer 5/15/17 Still in office    
308 Trump Secretary of Homeland Security Kirstjen Nielsen 12/6/17 Still in office    
309 Trump Secretary of Health & Human Services Alex Azar 1/29/18 Still in office    
310 Trump Secretary of State Mike Pompeo 4/26/18 Still in office    
311 Trump CIA Director Gina Haspel 5/21/18 Still in office    
312 Trump Secretary of Veterans Affairs Robert Wilkie 7/30/18 Still in office    
283 Trump Chief of Staff Reince Priebus 1/20/17 7/28/17 189 190
284 Trump Secretary of Homeland Security John Kelly 1/20/17 7/28/17 189 190
1 Carter OMB Director Bert Lance 1/21/77 9/23/77 245 247
285 Trump Secretary of Health & Human Services Tom Price 2/10/17 9/29/17 231 253
34 Reagan SBA Administrator Michael Cardenas 3/30/81 2/3/82 310 380
121 Clinton Secretary of Defense Les Aspin 1/21/93 2/3/94 378 380
286 Trump Secretary of Veterans Affairs David Shulkin 2/14/17 3/28/18 407 433
287 Trump Secretary of State Rex Tillerson 2/1/17 3/31/18 423 436
288 Trump CIA Director Mike Pompeo 1/23/17 4/26/18 458 462
229 Obama Director of National Intelligence Dennis Blair 1/29/09 5/28/10 484 494
35 Reagan Secretary of State Alexander Haig 1/22/81 7/5/82 529 532
289 Trump EPA Administrator Scott Pruitt 2/17/17 7/6/18 504 533
122 Clinton Chief of Staff Mack McLarty 1/20/93 7/17/94 543 544
123 Clinton OMB Director Leon Panetta 1/21/93 7/17/94 542 544
230 Obama OMB Director Peter Orszag 1/20/09 7/30/10 556 557
231 Obama Chief of Staff Rahm Emanuel 1/20/09 10/1/10 619 620
124 Clinton SBA Administrator Erskine Bowles 5/12/93 10/6/94 512 625
36 Reagan Secretary of Energy James Edwards 1/23/81 11/5/82 651 655
290 Trump Attorney General Jeff Sessions 2/9/17 11/7/18 636 657
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
125 Clinton Secretary of the Treasury Lloyd Bentsen 1/22/93 12/22/94 699 702
126 Clinton Secretary of Agriculture Mike Espy 1/22/93 12/31/94 708 711
171 Bush 43 Secretary of the Treasury Paul O'Neill 1/30/01 12/31/02 700 711
291 Trump Secretary of Defense Jim Mattis 1/20/17 12/31/18 710 711
292 Trump UN Ambassador Nikki Haley 1/27/17 12/31/18 703 711
293 Trump Chief of Staff John Kelly 7/31/17 12/31/18 518 711
294 Trump Secretary of the Interior Ryan Zinke 3/1/17 1/2/19 672 713
127 Clinton Director of Central Intelligence Jim Woolsey 2/5/93 1/10/95 704 721
37 Reagan Secretary of Transportation Drew Lewis 1/23/81 2/1/83 739 743
38 Reagan Secretary of Health & Human Services Richard Schweiker 1/22/81 2/3/83 742 745
89 Bush 41 Secretary of Agriculture Clayton Yeutter 2/16/89 3/1/91 743 771
39 Reagan EPA Administrator Anne Gorsuch 5/20/81 3/9/83 658 779
90 Bush 41 SBA Administrator Susan Engeleiter 4/20/89 3/27/91 706 797
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
232 Obama CIA Director Leon Panetta 2/13/09 6/30/11 867 892
233 Obama Secretary of Defense Bob Gates Bush admin 6/30/11 1655 combined 892
2 Carter Secretary of Transportation Brock Adams 1/23/77 7/20/79 908 912
234 Obama Secretary of Commerce Gary Locke 3/26/09 8/1/11 858 924
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
91 Bush 41 Attorney General Dick Thornburgh Reagan admin 8/15/91 1098 combined 938
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
92 Bush 41 Director of Central Intelligence Bill Webster Reagan admin 8/31/91 1558 combined 954
9 Carter UN Ambassador Andrew Young 1/30/77 9/23/79 966 977
10 Carter Secretary of Commerce Juanita Kreps 1/23/77 10/31/79 1011 1015
40 Reagan Secretary of the Interior James Watt 1/23/81 11/8/83 1019 1023
174 Bush 43 Secretary of Housing & Urban Development Mel Martinez 1/24/01 12/12/03 1052 1057
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
235 Obama OMB Director Jack Lew 11/18/10 1/26/12 434 1102
236 Obama Chief of Staff Bill Daley 1/13/11 1/27/12 379 1103
128 Clinton Secretary of Commerce Ron Brown 1/22/93 4/3/96 1167 1170
129 Clinton U.S. Trade Representative Mickey Kantor 1/22/93 4/12/96 1176 1179
130 Clinton OMB Director Alice Rivlin 10/17/94 4/26/96 557 1193
11 Carter Secretary of State Cyrus Vance 1/23/77 4/28/80 1191 1195
96 Bush 41 UN Ambassador Tom Pickering 3/20/89 5/7/92 1144 1204
12 Carter Chief of Staff Hamilton Jordan 7/18/79 6/11/80 329 1239
237 Obama Secretary of Commerce John Bryson 10/21/11 6/21/12 244 1249
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
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
238 Obama CIA Director David Petraeus 9/6/11 11/9/12 430 1390
131 Clinton Director of Central Intelligence John Deutch 5/10/95 12/15/96 585 1426
13 Carter U.S. Trade Representative Reubin Askew 10/1/79 12/31/80 457 1442
41 Reagan Secretary of Education T.H. Bell 1/23/81 12/31/84 1438 1442
42 Reagan EPA Administrator William Ruckelshaus 5/18/83 1/4/85 597 1446
132 Clinton Secretary of Labor Robert Reich 1/22/93 1/10/97 1449 1452
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
Powered by Datasette · Query took 1.567ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub