cabinet-turnover/cabinet-turnover
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
379 rows
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | president | position | appointee | start_date | end_date | length | departure_day | gender | Unnamed: 8 | Unnamed: 9 |
---|---|---|---|---|---|---|---|---|---|---|---|
101 | 101 | Bush 41 | Secretary of Transportation | Sam Skinner | 2/6/89 | 12/13/91 | 1040 | 1058 | Male | ||
102 | 102 | Bush 41 | Chief of Staff | John Sununu | 1/20/89 | 12/15/91 | 1059 | 1060 | Male | ||
103 | 103 | Bush 41 | Secretary of Commerce | Robert Mosbacher | 1/31/89 | 1/15/92 | 1079 | 1091 | Male | ||
104 | 104 | Bush 41 | UN Ambassador | Tom Pickering | 3/20/89 | 5/7/92 | 1144 | 1204 | Male | ||
105 | 105 | Bush 41 | Chief of Staff | Sam Skinner | 12/16/91 | 8/23/92 | 251 | 1312 | Male | ||
106 | 106 | Bush 41 | Secretary of State | James Baker | 1/25/89 | 8/23/92 | 1306 | 1312 | Male | ||
107 | 107 | Bush 41 | Secretary of Veterans Affairs | Ed Derwinski | 3/15/89 | 9/26/92 | 1291 | 1346 | Male | ||
108 | 108 | Bush 41 | CEA Chair | Michael Boskin | 2/2/89 | 1/12/93 | 1440 | 1454 | Male | ||
109 | 109 | Bush 41 | Attorney General | William Barr | 11/26/91 | 1/15/93 | 416 | 1457 | Male | ||
110 | 110 | Bush 41 | Secretary of the Treasury | Nicholas Brady | Reagan admin | 1/17/93 | 1584 combined | 1459 | Male | ||
111 | 111 | Bush 41 | Secretary of Housing & Urban Development | Jack Kemp | 2/13/89 | 1/19/93 | 1436 | 1461 | Male | ||
112 | 112 | Bush 41 | Secretary of State | Lawrence Eagleburger | 12/8/92 | 1/19/93 | 42 | 1461 | Male | ||
113 | 113 | Bush 41 | Chief of Staff | James Baker | 8/23/92 | 1/20/93 | 150 | 1462 | Male | ||
114 | 114 | Bush 41 | Director of Central Intelligence | Bob Gates | 11/6/91 | 1/20/93 | 441 | 1462 | Male | ||
115 | 115 | Bush 41 | EPA Administrator | William Reilly | 2/6/89 | 1/20/93 | 1444 | 1462 | Male | ||
116 | 116 | Bush 41 | OMB Director | Dick Darman | 1/25/89 | 1/20/93 | 1456 | 1462 | Male | ||
117 | 117 | Bush 41 | SBA Administrator | Pat Saiki | 3/27/91 | 1/20/93 | 665 | 1462 | Female | ||
118 | 118 | Bush 41 | Secretary of Agriculture | Ed Madigan | 3/12/91 | 1/20/93 | 680 | 1462 | Male | ||
119 | 119 | Bush 41 | Secretary of Commerce | Barbara Franklin | 2/27/92 | 1/20/93 | 328 | 1462 | Female | ||
120 | 120 | Bush 41 | Secretary of Defense | Dick Cheney | 3/21/89 | 1/20/93 | 1401 | 1462 | Male | ||
121 | 121 | Bush 41 | Secretary of Education | Lamar Alexander | 3/18/91 | 1/20/93 | 674 | 1462 | Male | ||
122 | 122 | Bush 41 | Secretary of Energy | James Watkins | 3/1/89 | 1/20/93 | 1421 | 1462 | Male | ||
123 | 123 | Bush 41 | Secretary of Health & Human Services | Louis Sullivan | 3/1/89 | 1/20/93 | 1421 | 1462 | Male | ||
124 | 124 | Bush 41 | Secretary of Labor | Lynn Morley Martin | 2/7/91 | 1/20/93 | 713 | 1462 | Female | ||
125 | 125 | Bush 41 | Secretary of the Interior | Manuel Luján Jr. | 2/3/89 | 1/20/93 | 1447 | 1462 | Male | ||
126 | 126 | Bush 41 | Secretary of Transportation | Andy Card | 3/11/92 | 1/20/93 | 315 | 1462 | Male | ||
127 | 127 | Bush 41 | U.S. Trade Representative | Carla Hills | 2/6/89 | 1/20/93 | 1444 | 1462 | Female | ||
128 | 128 | Bush 41 | Vice President | Dan Quayle | 1/20/89 | 1/20/93 | 1461 | 1462 | Male | ||
129 | 129 | Bush 41 | OSTP Director | D. Allan Bromley | 10/13/89 | 1/20/93 | 1195 | 1462 | Male | ||
130 | 130 | Bush 41 | UN Ambassador | Edward Perkins | 5/12/92 | 1/27/93 | 260 | 1469 | 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 | |||
187 | 187 | Bush 43 | Secretary of the Treasury | Paul O'Neill | 1/30/01 | 12/31/02 | 700 | 711 | Male | ||
188 | 188 | Bush 43 | CEA Chair | Glenn Hubbard | 5/11/01 | 2/28/03 | 658 | 770 | Male | ||
189 | 189 | Bush 43 | OMB Director | Mitch Daniels | 1/23/01 | 6/6/03 | 864 | 868 | Male | ||
190 | 190 | Bush 43 | EPA Administrator | Christine Todd Whitman | 1/31/01 | 6/27/03 | 877 | 889 | Female | ||
191 | 191 | Bush 43 | Secretary of Housing & Urban Development | Mel Martinez | 1/24/01 | 12/12/03 | 1052 | 1057 | Male | ||
192 | 192 | Bush 43 | UN Ambassador | John Negroponte | 9/19/01 | 6/23/04 | 1008 | 1251 | Male | ||
193 | 193 | Bush 43 | Director of Central Intelligence | George Tenet | Clinton admin | 7/11/04 | 2557 combined | 1269 | Male | ||
194 | 194 | Bush 43 | Secretary of Agriculture | Ann Veneman | 1/20/01 | 1/20/05 | 1461 | 1462 | Female | ||
195 | 195 | Bush 43 | Secretary of Education | Rod Paige | 1/24/01 | 1/20/05 | 1457 | 1462 | Male | ||
196 | 196 | Bush 43 | UN Ambassador | John Danforth | 7/23/04 | 1/20/05 | 181 | 1462 | Male | ||
197 | 197 | Bush 43 | EPA Administrator | Mike Leavitt | 11/6/03 | 1/25/05 | 446 | 1467 | Male | ||
198 | 198 | Bush 43 | Secretary of State | Colin Powell | 1/20/01 | 1/25/05 | 1466 | 1467 | Male | ||
199 | 199 | Bush 43 | Secretary of Health & Human Services | Tommy Thompson | 2/2/01 | 1/26/05 | 1454 | 1468 | Male | ||
200 | 200 | Bush 43 | Secretary of Veterans Affairs | Anthony Principi | 1/23/01 | 1/26/05 | 1464 | 1468 | 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 );