cabinet-turnover/cabinet-turnover
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
14 rows where position = "Secretary of Labor" sorted by appointee
This data as json, copyable, CSV (advanced)
Suggested facets: president, departure_day, gender
Link | rowid | president | position | appointee ▼ | start_date | end_date | length | departure_day | gender | Unnamed: 8 | Unnamed: 9 |
---|---|---|---|---|---|---|---|---|---|---|---|
325 | 325 | Trump | Secretary of Labor | Alexander Acosta | 4/28/17 | 7/19/19 | 812 | 911 | Male | ||
180 | 180 | Clinton | Secretary of Labor | Alexis Herman | 5/1/97 | 1/20/01 | 1360 | 2923 | Female | ||
80 | 80 | Reagan | Secretary of Labor | Ann McLaughlin | 12/14/87 | 1/20/89 | 403 | 2923 | Female | ||
64 | 64 | Reagan | Secretary of Labor | Bill Brock | 4/29/85 | 10/31/87 | 915 | 2476 | Male | ||
238 | 238 | Bush 43 | Secretary of Labor | Elaine Chao | 1/29/01 | 1/20/09 | 2913 | 2923 | Female | ||
95 | 95 | Bush 41 | Secretary of Labor | Elizabeth Dole | 1/25/89 | 11/23/90 | 667 | 673 | Female | ||
347 | 347 | Trump | Secretary of Labor | Eugene Scalia | 9/27/19 | 1/20/21 | 481 | 1462 | Male | ||
263 | 263 | Obama | Secretary of Labor | Hilda Solis | 2/24/09 | 1/22/13 | 1428 | 1464 | Female | ||
124 | 124 | Bush 41 | Secretary of Labor | Lynn Morley Martin | 2/7/91 | 1/20/93 | 713 | 1462 | Female | ||
363 | 363 | Biden | Secretary of Labor | Marty Walsh | 3/23/21 | Still in office | Male | ||||
52 | 52 | Reagan | Secretary of Labor | Ray Donovan | 2/4/81 | 3/15/85 | 1500 | 1516 | Male | ||
29 | 29 | Carter | Secretary of Labor | Ray Marshall | 1/27/77 | 1/20/81 | 1454 | 1462 | Male | ||
143 | 143 | Clinton | Secretary of Labor | Robert Reich | 1/22/93 | 1/10/97 | 1449 | 1452 | Male | ||
300 | 300 | Obama | Secretary of Labor | Tom Perez | 7/23/13 | 1/20/17 | 1277 | 2923 | 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 );