cabinet-turnover/cabinet-turnover
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
379 rows sorted by president
This data as json, copyable, CSV (advanced)
Link | rowid | president ▼ | position | appointee | start_date | end_date | length | departure_day | gender | Unnamed: 8 | Unnamed: 9 |
---|---|---|---|---|---|---|---|---|---|---|---|
9 | 9 | Carter | UN Ambassador | Andrew Young | 1/30/77 | 9/23/79 | 966 | 977 | Male | ||
10 | 10 | Carter | Secretary of Commerce | Juanita Kreps | 1/23/77 | 10/31/79 | 1011 | 1015 | Female | ||
11 | 11 | Carter | Secretary of State | Cyrus Vance | 1/23/77 | 4/28/80 | 1191 | 1195 | Male | ||
12 | 12 | Carter | Chief of Staff | Hamilton Jordan | 7/18/79 | 6/11/80 | 329 | 1239 | Male | ||
13 | 13 | Carter | U.S. Trade Representative | Reubin Askew | 10/1/79 | 12/31/80 | 457 | 1442 | Male | ||
14 | 14 | Carter | Secretary of State | Ed Muskie | 5/8/80 | 1/18/81 | 255 | 1460 | Male | ||
15 | 15 | Carter | Attorney General | Ben Civiletti | 8/16/79 | 1/19/81 | 522 | 1461 | Male | ||
16 | 16 | Carter | Secretary of Commerce | Philip Klutznick | 1/9/80 | 1/19/81 | 376 | 1461 | Male | ||
17 | 17 | Carter | CEA Chair | Charles Schultze | 1/22/77 | 1/20/81 | 1459 | 1462 | Male | ||
18 | 18 | Carter | Chief of Staff | Jack Watson | 6/11/80 | 1/20/81 | 223 | 1462 | Male | ||
19 | 19 | Carter | Director of Central Intelligence | Stansfield Turner | 3/9/77 | 1/20/81 | 1413 | 1462 | Male | ||
20 | 20 | Carter | EPA Administrator | Douglas Costle | 3/7/77 | 1/20/81 | 1415 | 1462 | Male | ||
21 | 21 | Carter | OMB Director | Jim McIntyre | 9/24/77 | 1/20/81 | 1214 | 1462 | Male | ||
22 | 22 | Carter | SBA Administrator | A. Vernon Weaver | 4/1/77 | 1/20/81 | 1390 | 1462 | Male | ||
23 | 23 | Carter | Secretary of Agriculture | Robert Bergland | 1/23/77 | 1/20/81 | 1458 | 1462 | Male | ||
24 | 24 | Carter | Secretary of Defense | Harold Brown | 1/21/77 | 1/20/81 | 1460 | 1462 | Male | ||
25 | 25 | Carter | Secretary of Education | Shirley Hufstedler | 12/6/79 | 1/20/81 | 411 | 1462 | Female | ||
26 | 26 | Carter | Secretary of Energy | Charles Duncan | 8/24/79 | 1/20/81 | 515 | 1462 | Male | ||
27 | 27 | Carter | Secretary of Health, Education & Welfare/Secretary of Health & Human Services | Patricia Harris | 8/3/79 | 1/20/81 | 536 | 1462 | Female | ||
28 | 28 | Carter | Secretary of Housing & Urban Development | Moon Landrieu | 9/24/79 | 1/20/81 | 484 | 1462 | Male | ||
29 | 29 | Carter | Secretary of Labor | Ray Marshall | 1/27/77 | 1/20/81 | 1454 | 1462 | Male | ||
30 | 30 | Carter | Secretary of the Interior | Cecil Andrus | 1/23/77 | 1/20/81 | 1458 | 1462 | Male | ||
31 | 31 | Carter | Secretary of the Treasury | G. William Miller | 8/6/79 | 1/20/81 | 533 | 1462 | Male | ||
32 | 32 | Carter | Secretary of Transportation | Neil Goldschmidt | 8/15/79 | 1/20/81 | 524 | 1462 | Male | ||
33 | 33 | Carter | UN Ambassador | Donald McHenry | 9/23/79 | 1/20/81 | 485 | 1462 | Male | ||
34 | 34 | Carter | Vice President | Walter Mondale | 1/20/77 | 1/20/81 | 1461 | 1462 | Male | ||
35 | 35 | Carter | OSTP Director | Frank Press | 6/1/77 | 1/20/81 | 1329 | 1462 | Male | ||
131 | 131 | Clinton | Secretary of Defense | Les Aspin | 1/21/93 | 2/3/94 | 378 | 380 | Male | ||
132 | 132 | Clinton | Chief of Staff | Mack McLarty | 1/20/93 | 7/17/94 | 543 | 544 | Male | ||
133 | 133 | Clinton | OMB Director | Leon Panetta | 1/21/93 | 7/17/94 | 542 | 544 | Male | ||
134 | 134 | Clinton | SBA Administrator | Erskine Bowles | 5/12/93 | 10/6/94 | 512 | 625 | Male | ||
135 | 135 | Clinton | Secretary of the Treasury | Lloyd Bentsen | 1/22/93 | 12/22/94 | 699 | 702 | Male | ||
136 | 136 | Clinton | Secretary of Agriculture | Mike Espy | 1/22/93 | 12/31/94 | 708 | 711 | Male | ||
137 | 137 | Clinton | Director of Central Intelligence | Jim Woolsey | 2/5/93 | 1/10/95 | 704 | 721 | Male | ||
138 | 138 | Clinton | CEA Chair | Laura D'Andrea Tyson | 2/5/93 | 4/20/95 | 804 | 821 | Female | ||
139 | 139 | Clinton | Secretary of Commerce | Ron Brown | 1/22/93 | 4/3/96 | 1167 | 1170 | Male | ||
140 | 140 | Clinton | U.S. Trade Representative | Mickey Kantor | 1/22/93 | 4/12/96 | 1176 | 1179 | Male | ||
141 | 141 | Clinton | OMB Director | Alice Rivlin | 10/17/94 | 4/26/96 | 557 | 1193 | Female | ||
142 | 142 | Clinton | Director of Central Intelligence | John Deutch | 5/10/95 | 12/15/96 | 585 | 1426 | Male | ||
143 | 143 | Clinton | Secretary of Labor | Robert Reich | 1/22/93 | 1/10/97 | 1449 | 1452 | Male | ||
144 | 144 | Clinton | Secretary of State | Warren Christopher | 1/20/93 | 1/17/97 | 1458 | 1459 | Male | ||
145 | 145 | Clinton | Secretary of Housing & Urban Development | Henry Cisneros | 1/22/93 | 1/19/97 | 1458 | 1461 | Male | ||
146 | 146 | Clinton | Chief of Staff | Leon Panetta | 7/17/94 | 1/20/97 | 918 | 1462 | Male | ||
147 | 147 | Clinton | Secretary of Energy | Hazel O'Leary | 1/22/93 | 1/20/97 | 1459 | 1462 | Female | ||
148 | 148 | Clinton | Secretary of Commerce | Mickey Kantor | 4/12/96 | 1/21/97 | 284 | 1463 | Male | ||
149 | 149 | Clinton | UN Ambassador | Madeleine Albright | 1/27/93 | 1/21/97 | 1455 | 1463 | Female | ||
150 | 150 | Clinton | Secretary of Defense | William Perry | 2/3/94 | 1/23/97 | 1085 | 1465 | Male | ||
151 | 151 | Clinton | CEA Chair | Joseph Stiglitz | 6/28/95 | 2/10/97 | 593 | 1483 | Male | ||
152 | 152 | Clinton | SBA Administrator | Philip Lader | 10/8/94 | 2/11/97 | 857 | 1484 | Male | ||
153 | 153 | Clinton | Secretary of Transportation | Federico Peña | 1/21/93 | 2/14/97 | 1485 | 1487 | Male | ||
154 | 154 | Clinton | Secretary of Veterans Affairs | Jesse Brown | 1/23/93 | 7/3/97 | 1622 | 1626 | Male | ||
155 | 155 | Clinton | OSTP Director | John H. Gibbons | 2/2/93 | 4/3/98 | 1886 | 1900 | Male | ||
156 | 156 | Clinton | OMB Director | Frank Raines | 9/13/96 | 5/21/98 | 615 | 1948 | Male | ||
157 | 157 | Clinton | Secretary of Energy | Federico Peña | 3/12/97 | 6/30/98 | 475 | 1988 | Male | ||
158 | 158 | Clinton | UN Ambassador | Bill Richardson | 2/18/97 | 8/18/98 | 546 | 2037 | Male | ||
159 | 159 | Clinton | Chief of Staff | Erskine Bowles | 1/20/97 | 10/20/98 | 638 | 2100 | Male | ||
160 | 160 | Clinton | Secretary of the Treasury | Bob Rubin | 1/10/95 | 7/2/99 | 1634 | 2355 | Male | ||
161 | 161 | Clinton | CEA Chair | Janet Yellen | 2/18/97 | 8/3/99 | 896 | 2387 | Female | ||
162 | 162 | Clinton | Secretary of Commerce | Bill Daley | 1/30/97 | 7/19/00 | 1266 | 2738 | Male | ||
163 | 163 | Clinton | Secretary of Veterans Affairs | Togo West Jr. | 5/5/98 | 7/25/00 | 812 | 2744 | Male | ||
164 | 164 | Clinton | Secretary of the Interior | Bruce Babbitt | 1/22/93 | 1/2/01 | 2902 | 2905 | Male | ||
165 | 165 | Clinton | CEA Chair | Martin Baily | 8/12/99 | 1/19/01 | 526 | 2922 | Male | ||
166 | 166 | Clinton | EPA Administrator | Carol Browner | 1/22/93 | 1/19/01 | 2919 | 2922 | Female | ||
167 | 167 | Clinton | OMB Director | Jack Lew | 5/21/98 | 1/19/01 | 974 | 2922 | Male | ||
168 | 168 | Clinton | Secretary of Agriculture | Dan Glickman | 3/30/95 | 1/19/01 | 2122 | 2922 | Male | ||
169 | 169 | Clinton | Secretary of Commerce | Norman Mineta | 7/21/00 | 1/19/01 | 182 | 2922 | Male | ||
170 | 170 | Clinton | Secretary of State | Madeleine Albright | 1/23/97 | 1/19/01 | 1457 | 2922 | Female | ||
171 | 171 | Clinton | UN Ambassador | Richard Holbrooke | 9/7/99 | 1/19/01 | 500 | 2922 | Male | ||
172 | 172 | Clinton | Attorney General | Janet Reno | 3/12/93 | 1/20/01 | 2871 | 2923 | Female | ||
173 | 173 | Clinton | Chief of Staff | John Podesta | 10/20/98 | 1/20/01 | 823 | 2923 | Male | ||
174 | 174 | Clinton | SBA Administrator | Aida Alvarez | 3/7/97 | 1/20/01 | 1415 | 2923 | Female | ||
175 | 175 | Clinton | Secretary of Defense | William Cohen | 1/24/97 | 1/20/01 | 1457 | 2923 | Male | ||
176 | 176 | Clinton | Secretary of Education | Dick Riley | 1/21/93 | 1/20/01 | 2921 | 2923 | Male | ||
177 | 177 | Clinton | Secretary of Energy | Bill Richardson | 8/18/98 | 1/20/01 | 886 | 2923 | Male | ||
178 | 178 | Clinton | Secretary of Health & Human Services | Donna Shalala | 1/22/93 | 1/20/01 | 2920 | 2923 | Female | ||
179 | 179 | Clinton | Secretary of Housing & Urban Development | Andrew Cuomo | 1/29/97 | 1/20/01 | 1452 | 2923 | Male | ||
180 | 180 | Clinton | Secretary of Labor | Alexis Herman | 5/1/97 | 1/20/01 | 1360 | 2923 | Female | ||
181 | 181 | Clinton | Secretary of the Treasury | Larry Summers | 7/2/99 | 1/20/01 | 568 | 2923 | Male | ||
182 | 182 | Clinton | Secretary of Transportation | Rodney Slater | 2/14/97 | 1/20/01 | 1436 | 2923 | Male | ||
183 | 183 | Clinton | U.S. Trade Representative | Charlene Barshefsky | 3/18/97 | 1/20/01 | 1404 | 2923 | Female | ||
184 | 184 | Clinton | Vice President | Al Gore | 1/20/93 | 1/20/01 | 2922 | 2923 | Male | ||
185 | 185 | Clinton | OSTP Director | Neal Lane | 8/4/98 | 1/20/01 | 900 | 2923 | Male | ||
186 | 186 | Clinton | Director of Central Intelligence | George Tenet | 7/11/97 | Bush admin | 2557 combined | Male | |||
251 | 251 | Obama | Director of National Intelligence | Dennis Blair | 1/29/09 | 5/28/10 | 484 | 494 | Male | ||
252 | 252 | Obama | OMB Director | Peter Orszag | 1/20/09 | 7/30/10 | 556 | 557 | Male | ||
253 | 253 | Obama | CEA Chair | Christina Romer | 1/29/09 | 9/3/10 | 582 | 592 | Female | ||
254 | 254 | Obama | Chief of Staff | Rahm Emanuel | 1/20/09 | 10/1/10 | 619 | 620 | Male | ||
255 | 255 | Obama | CIA Director | Leon Panetta | 2/13/09 | 6/30/11 | 867 | 892 | Male | ||
256 | 256 | Obama | Secretary of Defense | Bob Gates | Bush admin | 6/30/11 | 1655 combined | 892 | Male | ||
257 | 257 | Obama | Secretary of Commerce | Gary Locke | 3/26/09 | 8/1/11 | 858 | 924 | Male | ||
258 | 258 | Obama | CEA Chair | Austan Goolsbee | 9/10/10 | 8/5/11 | 329 | 928 | Male | ||
259 | 259 | Obama | OMB Director | Jack Lew | 11/18/10 | 1/26/12 | 434 | 1102 | Male | ||
260 | 260 | Obama | Chief of Staff | Bill Daley | 1/13/11 | 1/27/12 | 379 | 1103 | Male | ||
261 | 261 | Obama | Secretary of Commerce | John Bryson | 10/21/11 | 6/21/12 | 244 | 1249 | Male | ||
262 | 262 | Obama | CIA Director | David Petraeus | 9/6/11 | 11/9/12 | 430 | 1390 | Male | ||
263 | 263 | Obama | Secretary of Labor | Hilda Solis | 2/24/09 | 1/22/13 | 1428 | 1464 | Female | ||
264 | 264 | Obama | Secretary of the Treasury | Tim Geithner | 1/26/09 | 1/25/13 | 1460 | 1467 | Male | ||
265 | 265 | Obama | Chief of Staff | Jack Lew | 1/30/12 | 1/25/13 | 361 | 1467 | Male | ||
266 | 266 | Obama | Secretary of State | Hillary Clinton | 1/21/09 | 2/1/13 | 1472 | 1474 | Female | ||
267 | 267 | Obama | EPA Administrator | Lisa Jackson | 1/26/09 | 2/14/13 | 1480 | 1487 | Female |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "cabinet-turnover/cabinet-turnover" ( "president" TEXT, "position" TEXT, "appointee" TEXT, "start_date" TEXT, "end_date" TEXT, "length" TEXT, "departure_day" INTEGER, "gender" TEXT, "Unnamed: 8" INTEGER, "Unnamed: 9" INTEGER );