Workforce Management Information - Department For Work And Pensions

unnamed_0 Unnamed: 0	unnamed_1 Unnamed: 1	unnamed_2 Unnamed: 2	admin_officers_admin_assistants Admin Officers/admin Assistants	unnamed_4 Unnamed: 4	executive_officers Executive Officers	unnamed_6 Unnamed: 6	higher_executive_officers_senior_executive_officers Higher Executive Officers/Senior Executive Officers	unnamed_8 Unnamed: 8	grade_6_7 Grade 6/7	unnamed_10 Unnamed: 10	senior_civil_service Senior Civil Service	unnamed_12 Unnamed: 12	other_unknown_or_unspecified Other, Unknown, Or Unspecified	unnamed_14 Unnamed: 14	total_employees Total Employees	unnamed_16 Unnamed: 16	agency_staff_clerical_admin Agency Staff (clerical/admin)	unnamed_18 Unnamed: 18	interim_managers Interim Managers	unnamed_20 Unnamed: 20	specialist_contractors Specialist Contractors	unnamed_22 Unnamed: 22	consultants_consultancy Consultants/consultancy	unnamed_24 Unnamed: 24	total Total	unnamed_26 Unnamed: 26	unnamed_27 Unnamed: 27	unnamed_28 Unnamed: 28	salary Salary	allowances Allowances	non_consolidated_performance_payments Non-consolidated Performance Payments	overtime Overtime	employer_pension_contributions Employer Pension Contributions	employer_national_insurance_contributions Employer National Insurance Contributions	total_paybill_for_payroll_staff Total Paybill For Payroll Staff	total_cost_of_contingent_labour_agency_clerical_and_ad_841da9c8 Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors	total_cost_of_consultants_consultancy Total Cost Of Consultants/ Consultancy	total_non_payroll_ccl_staff_costs Total Non-payroll (CCL) Staff Costs	unnamed_39 Unnamed: 39
			Headcount	Full-time equivalent	Headcount	Full-time equivalent	Headcount	Full-time equivalent	Headcount	Full-time equivalent	Headcount	Full-time equivalent	Headcount	Full-time equivalent	Headcount	Full-time equivalent	Headcount	Full-time equivalent	Headcount	Full-time equivalent	Headcount	Full-time equivalent	Headcount	Full-time equivalent	Headcount	Full-time equivalent	Headcount	Full-time equivalent
Department for Work and Pensions	Ministerial Department	Department for Work and Pensions	28,979	24,449.64	36,836	32,576.81	9,685	9,145.24	2,466	2,366.01	209	204.5	.	.	78,175	68,742.20	.	.	525	525	.	.	.	.	525	525	78,700	69,267.20	£155,687,366.58	£2,172,023.87	£756,889.76	£1,967,462.10	£42,029,363.84	£14,292,806.38	£216,905,912.53	£9,523,691.66	£39,682.00	£9,563,373.66	£226,469,286.19
Health and Safety Executive	Crown Non Departmental Public Body	Department for Work and Pensions	316	274.72	377	346.37	1,313	1,239.19	447	426.43	27	26.6	.	.	2,480	2,313.31	1	1	17	16.6	.	.	.	.	18	17.6	2,498	2,330.91	£6,871,568.35	£150,487.10	£1,512,843.99	£12,490.47	£2,300,889.78	£961,111.65	£11,809,391.34	£151,568.00	£0.00	£151,568.00	£11,960,959.34
The Pensions Regulator	Executive Non-Departmental Public Body	Department for Work and Pensions	.	.	.	.	.	.	.	.	.	.	710	689.53	710	689.53	31	29.75	.	.	1	1	7	6.61	39	37.36	749	726.89	£3,003,818.67	£0.00	£108,754.08	£6,082.07	£821,657.08	£344,884.00	£4,285,195.90	£300,537.70	£198,407.94	£498,945.64	£4,784,141.54
Money and Pensions Service	Executive Non-Departmental Public Body	Department for Work and Pensions	.	.	.	.	.	.	.	.	.	.	301	288.1	301	288.1	6	6	35	32.8	.	.	.	.	41	38.8	342	326.9	£1,434,452.59	£38,174.39	£0.00	£498.56	£175,474.11	£172,028.12	£1,820,627.77	£661,251.35	£0.00	£661,251.35	£2,481,879.12


CREATE TABLE december_2019 (
  "unnamed_0" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "admin_officers_admin_assistants" VARCHAR,
  "unnamed_4" VARCHAR,
  "executive_officers" VARCHAR,
  "unnamed_6" VARCHAR,
  "higher_executive_officers_senior_executive_officers" VARCHAR,
  "unnamed_8" VARCHAR,
  "grade_6_7" VARCHAR,
  "unnamed_10" VARCHAR,
  "senior_civil_service" VARCHAR,
  "unnamed_12" VARCHAR,
  "other_unknown_or_unspecified" VARCHAR,
  "unnamed_14" VARCHAR,
  "total_employees" VARCHAR,
  "unnamed_16" VARCHAR,
  "agency_staff_clerical_admin" VARCHAR,
  "unnamed_18" VARCHAR,
  "interim_managers" VARCHAR,
  "unnamed_20" VARCHAR,
  "specialist_contractors" VARCHAR,
  "unnamed_22" VARCHAR,
  "consultants_consultancy" VARCHAR,
  "unnamed_24" VARCHAR,
  "total" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "salary" VARCHAR,
  "allowances" VARCHAR,
  "non_consolidated_performance_payments" VARCHAR,
  "overtime" VARCHAR,
  "employer_pension_contributions" VARCHAR,
  "employer_national_insurance_contributions" VARCHAR,
  "total_paybill_for_payroll_staff" VARCHAR,
  "total_cost_of_contingent_labour_agency_clerical_and_ad_841da9c8" VARCHAR,
  "total_cost_of_consultants_consultancy" VARCHAR,
  "total_non_payroll_ccl_staff_costs" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR
);