cabinet-turnover/cabinet-turnover
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
64 rows where president = "Bush 43" sorted by appointee
This data as json, copyable, CSV (advanced)
Suggested facets: position, gender
Link | rowid | president | position | appointee ▼ | start_date | end_date | length | departure_day | gender | Unnamed: 8 | Unnamed: 9 |
---|---|---|---|---|---|---|---|---|---|---|---|
221 | 221 | Bush 43 | Attorney General | Alberto Gonzales | 2/3/05 | 9/17/07 | 956 | 2432 | Male | ||
224 | 224 | Bush 43 | Secretary of Housing & Urban Development | Alphonso Jackson | 3/31/04 | 4/18/08 | 1479 | 2646 | Male | ||
210 | 210 | Bush 43 | Chief of Staff | Andy Card | 1/20/01 | 4/14/06 | 1910 | 1911 | Male | ||
194 | 194 | Bush 43 | Secretary of Agriculture | Ann Veneman | 1/20/01 | 1/20/05 | 1461 | 1462 | Female | ||
200 | 200 | Bush 43 | Secretary of Veterans Affairs | Anthony Principi | 1/23/01 | 1/26/05 | 1464 | 1468 | Male | ||
208 | 208 | Bush 43 | CEA Chair | Ben Bernanke | 6/21/05 | 1/31/06 | 224 | 1838 | Male | ||
250 | 250 | Bush 43 | Secretary of Defense | Bob Gates | 12/18/06 | Obama admin | 1655 combined | Male | |||
227 | 227 | Bush 43 | Secretary of Commerce | Carlos Gutierrez | 2/7/05 | 1/19/09 | 1442 | 2922 | Male | ||
190 | 190 | Bush 43 | EPA Administrator | Christine Todd Whitman | 1/31/01 | 6/27/03 | 877 | 889 | Female | ||
198 | 198 | Bush 43 | Secretary of State | Colin Powell | 1/20/01 | 1/25/05 | 1466 | 1467 | Male | ||
239 | 239 | Bush 43 | Secretary of State | Condoleezza Rice | 1/26/05 | 1/20/09 | 1455 | 2923 | Female | ||
244 | 244 | Bush 43 | Vice President | Dick Cheney | 1/20/01 | 1/20/09 | 2922 | 2923 | Male | ||
228 | 228 | Bush 43 | Secretary of the Interior | Dirk Kempthorne | 5/29/06 | 1/19/09 | 966 | 2922 | Male | ||
204 | 204 | Bush 43 | Secretary of Commerce | Donald Evans | 1/20/01 | 2/3/05 | 1475 | 1476 | Male | ||
217 | 217 | Bush 43 | Secretary of Defense | Donald Rumsfeld | 1/20/01 | 12/18/06 | 2158 | 2159 | Male | ||
233 | 233 | Bush 43 | Secretary of Agriculture | Ed Schafer | 1/28/08 | 1/20/09 | 358 | 2923 | Male | ||
230 | 230 | Bush 43 | CEA Chair | Edward Lazear | 2/27/06 | 1/20/09 | 1058 | 2923 | Male | ||
238 | 238 | Bush 43 | Secretary of Labor | Elaine Chao | 1/29/01 | 1/20/09 | 2913 | 2923 | Female | ||
209 | 209 | Bush 43 | Secretary of the Interior | Gale Norton | 1/31/01 | 3/31/06 | 1885 | 1897 | Female | ||
193 | 193 | Bush 43 | Director of Central Intelligence | George Tenet | Clinton admin | 7/11/04 | 2557 combined | 1269 | Male | ||
188 | 188 | Bush 43 | CEA Chair | Glenn Hubbard | 5/11/01 | 2/28/03 | 658 | 770 | Male | ||
205 | 205 | Bush 43 | CEA Chair | Greg Mankiw | 5/29/03 | 2/18/05 | 631 | 1491 | Male | ||
240 | 240 | Bush 43 | Secretary of the Treasury | Hank Paulson | 7/10/06 | 1/20/09 | 925 | 2923 | Male | ||
207 | 207 | Bush 43 | CEA Chair | Harvey Rosen | 2/23/05 | 6/10/05 | 107 | 1603 | Male | ||
215 | 215 | Bush 43 | SBA Administrator | Hector Barreto | 7/25/01 | 7/2/06 | 1803 | 1990 | Male | ||
242 | 242 | Bush 43 | Secretary of Veterans Affairs | James Peake | 12/20/07 | 1/20/09 | 397 | 2923 | Male | ||
223 | 223 | Bush 43 | Secretary of Veterans Affairs | Jim Nicholson | 2/1/05 | 10/1/07 | 972 | 2446 | Male | ||
226 | 226 | Bush 43 | OMB Director | Jim Nussle | 9/4/07 | 1/19/09 | 503 | 2922 | Male | ||
203 | 203 | Bush 43 | Attorney General | John Ashcroft | 2/2/01 | 2/3/05 | 1462 | 1476 | Male | ||
218 | 218 | Bush 43 | UN Ambassador | John Bolton | 8/2/05 | 12/31/06 | 516 | 2172 | Male | ||
196 | 196 | Bush 43 | UN Ambassador | John Danforth | 7/23/04 | 1/20/05 | 181 | 1462 | Male | ||
245 | 245 | Bush 43 | OSTP Director | John H. Marburger | 10/29/01 | 1/20/09 | 2640 | 2923 | Male | ||
192 | 192 | Bush 43 | UN Ambassador | John Negroponte | 9/19/01 | 6/23/04 | 1008 | 1251 | Male | ||
219 | 219 | Bush 43 | Director of National Intelligence | John Negroponte | 4/21/05 | 2/13/07 | 663 | 2216 | Male | ||
214 | 214 | Bush 43 | Secretary of the Treasury | John Snow | 2/3/03 | 6/29/06 | 1242 | 1987 | Male | ||
211 | 211 | Bush 43 | OMB Director | Josh Bolten | 6/26/03 | 4/14/06 | 1023 | 1911 | Male | ||
231 | 231 | Bush 43 | Chief of Staff | Josh Bolten | 4/14/06 | 1/20/09 | 1012 | 2923 | Male | ||
234 | 234 | Bush 43 | Secretary of Education | Margaret Spellings | 1/24/05 | 1/20/09 | 1457 | 2923 | Female | ||
241 | 241 | Bush 43 | Secretary of Transportation | Mary Peters | 10/17/06 | 1/20/09 | 826 | 2923 | Female | ||
191 | 191 | Bush 43 | Secretary of Housing & Urban Development | Mel Martinez | 1/24/01 | 12/12/03 | 1052 | 1057 | Male | ||
246 | 246 | Bush 43 | Secretary of Homeland Security | Michael Chertoff | 2/15/05 | 1/21/09 | 1436 | 2924 | Male | ||
249 | 249 | Bush 43 | CIA Director | Michael Hayden | 5/30/06 | 2/12/09 | 989 | 2946 | Male | ||
229 | 229 | Bush 43 | Attorney General | Michael Mukasey | 11/9/07 | 1/20/09 | 438 | 2923 | Male | ||
222 | 222 | Bush 43 | Secretary of Agriculture | Mike Johanns | 1/21/05 | 9/20/07 | 972 | 2435 | Male | ||
197 | 197 | Bush 43 | EPA Administrator | Mike Leavitt | 11/6/03 | 1/25/05 | 446 | 1467 | Male | ||
236 | 236 | Bush 43 | Secretary of Health & Human Services | Mike Leavitt | 1/26/05 | 1/20/09 | 1455 | 2923 | Male | ||
248 | 248 | Bush 43 | Director of National Intelligence | Mike McConnell | 2/13/07 | 1/27/09 | 714 | 2930 | Male | ||
189 | 189 | Bush 43 | OMB Director | Mitch Daniels | 1/23/01 | 6/6/03 | 864 | 868 | Male | ||
216 | 216 | Bush 43 | Secretary of Transportation | Norman Mineta | 1/25/01 | 7/7/06 | 1989 | 1995 | Male | ||
187 | 187 | Bush 43 | Secretary of the Treasury | Paul O'Neill | 1/30/01 | 12/31/02 | 700 | 711 | Male | ||
212 | 212 | Bush 43 | Director of Central Intelligence/CIA Director | Porter Goss | 9/24/04 | 5/5/06 | 588 | 1932 | Male | ||
213 | 213 | Bush 43 | U.S. Trade Representative | Rob Portman | 5/17/05 | 5/26/06 | 374 | 1953 | Male | ||
220 | 220 | Bush 43 | OMB Director | Rob Portman | 5/26/06 | 8/3/07 | 434 | 2387 | Male | ||
206 | 206 | Bush 43 | U.S. Trade Representative | Robert Zoellick | 2/7/01 | 2/22/05 | 1476 | 1495 | Male | ||
195 | 195 | Bush 43 | Secretary of Education | Rod Paige | 1/24/01 | 1/20/05 | 1457 | 1462 | Male | ||
235 | 235 | Bush 43 | Secretary of Energy | Samuel Bodman | 2/1/05 | 1/20/09 | 1449 | 2923 | Male | ||
201 | 201 | Bush 43 | Secretary of Energy | Spencer Abraham | 1/20/01 | 1/31/05 | 1472 | 1473 | Male | ||
232 | 232 | Bush 43 | EPA Administrator | Stephen Johnson | 5/2/05 | 1/20/09 | 1359 | 2923 | Male | ||
225 | 225 | Bush 43 | SBA Administrator | Steve Preston | 7/10/06 | 6/5/08 | 696 | 2694 | Male | ||
237 | 237 | Bush 43 | Secretary of Housing & Urban Development | Steve Preston | 6/5/08 | 1/20/09 | 229 | 2923 | Male | ||
243 | 243 | Bush 43 | U.S. Trade Representative | Susan Schwab | 6/8/06 | 1/20/09 | 957 | 2923 | Female | ||
202 | 202 | Bush 43 | Secretary of Homeland Security | Tom Ridge | 1/24/03 | 2/1/05 | 739 | 1474 | Male | ||
199 | 199 | Bush 43 | Secretary of Health & Human Services | Tommy Thompson | 2/2/01 | 1/26/05 | 1454 | 1468 | Male | ||
247 | 247 | Bush 43 | UN Ambassador | Zalmay Khalilzad | 4/30/07 | 1/22/09 | 633 | 2925 | Male |
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 );