White House Salaries

Salaries from the 2017 Trump White House

@kaggle.rishidamarla_white_house_salaries

Table List

1 table(15.47 KB)

White House 2017 Salaries Clean

@kaggle.rishidamarla_white_house_salaries.white_house_2017_salaries_clean

15.47 KB
377 rows
11 columns

name NAME	status STATUS	salary SALARY	pay_basis PAY BASIS	title TITLE	gender GENDER	unnamed_8 Unnamed: 8	unnamed_9 Unnamed: 9	unnamed_10 Unnamed: 10
Eissenstat, Everett H.	Employee	165000	Per Annum	DEPUTY ASSISTANT TO THE PRESIDENT	M	nan	nan	nan
Morrone, Vanessa M.	Employee	62000	Per Annum	ADVISOR TO THE PRESS SECRETARY	F	nan	nan	nan
McCathran, William W.	Employee	116914	Per Annum	ASSISTANT EXECUTIVE CLERK	M	nan	nan	nan
Thomas, III, Edwin R.	Employee	119489	Per Annum	ASSISTANT EXECUTIVE CLERK	M	nan	nan	nan
Fetalvo, Ninio J.	Employee	56000	Per Annum	ASSISTANT PRESS SECRETARY	M	nan	nan	nan
Strom, Natalie M.	Employee	56000	Per Annum	ASSISTANT PRESS SECRETARY	F	nan	nan	nan
Butterfield, Nicholas W.	Employee	70000	Per Annum	ASSISTANT STAFF SECRETARY	M	nan	nan	nan
Davis, Sylvia M.	Employee	70000	Per Annum	ASSISTANT STAFF SECRETARY	F	nan	nan	nan
Edmonds, Anita J.	Employee	66008	Per Annum	ASSISTANT SUPERVISOR	F	nan	nan	nan
Jones, Crystal B.	Employee	98323	Per Annum	ASSISTANT SUPERVISOR	F	nan	nan	nan


CREATE TABLE white_house_2017_salaries_clean (
  "name" VARCHAR,
  "status" VARCHAR,
  "salary" BIGINT,
  "pay_basis" VARCHAR,
  "title" VARCHAR,
  "gender" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR
);