Data set from Children's social work workforce: attrition, caseload, and agency workforce

Attrition by age

Latest data

Published 23 May 2022

Last updated 23 May 2022

Data on the breakdown of attrition based on the age of the social worker on 30 September 2021.

---

On this page

Data set details

• Theme: Children's social care
• Publication: Children's social work workforce: attrition, caseload, and agency workforce
• Release: Reporting year 2021
• Number of rows: 14
• Geographic levels: National
• Indicators:
  • Attrition into agency FTE
  • Attrition rate into agency
  • Full attrition FTE out of CSC
  • Full attrition rate out of CSC
  • LA social workers
  • Leaver FTE
  • Total attrition FTE
  • Total attrition rate
  • Turnover rate
• Filters:
  • Age group
• Time period: 2020 to 2021

---

Data set preview

Table showing first 5 rows, from underlying data

geographic_level	time_period	time_identifier	country_code	country_name	age_group	la_social_worker_fte	leaver_fte	turnover_rate	total_attrition_fte	total_attrition_proportion	full_attrition_out_of_csc_fte	full_attrition_out_of_csc_proportion	attrition_into_agency_fte	attrition_into_agency_proportion
National	2020	Reporting year	E92000001	England	20-29	5064.1	697.6	13.8	430.7	8.5	308.2	6.1	122.5	2.4
National	2020	Reporting year	E92000001	England	30-39	9858	1347.6	13.7	880.2	8.9	667.2	6.8	212.9	2.2
National	2020	Reporting year	E92000001	England	40-49	7716.2	981.2	12.7	664.8	8.6	462	6	202.7	2.6
National	2020	Reporting year	E92000001	England	50-59	7138.3	830.1	11.6	608.4	8.5	480	6.7	128.5	1.8
National	2020	Reporting year	E92000001	England	60+	2077.6	437.6	21.1	389.9	18.8	365.8	17.6	24.1	1.2

---

Variables in this data set

Table showing all 10 variables

Variable name	Variable description
age_group	Age group
attrition_into_agency_fte	Attrition into agency FTE
attrition_into_agency_proportion	Attrition rate into agency
full_attrition_out_of_csc_fte	Full attrition FTE out of CSC
full_attrition_out_of_csc_proportion	Full attrition rate out of CSC
la_social_worker_fte	LA social workers
leaver_fte	Leaver FTE
total_attrition_fte	Total attrition FTE
total_attrition_proportion	Total attrition rate
turnover_rate	Turnover rate

---

Footnotes

1. Components may not sum to totals due to rounding.
2. Rates are based on the number of LA social workers in post at 30 September.

---

Using this data

• Download the underlying data as a compressed ZIP file

• View or create your own tables

  View tables that we have built for you, or create your own tables from open data using our table tool

Download this data using code

Access this data using common programming languages using the URL below.

Example code

Python

import pandas as pd

pd.read_csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/ef69733b-c120-4296-8d88-6503da48375f/csv")

R

read.csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/ef69733b-c120-4296-8d88-6503da48375f/csv")

---

Contact us

If you have a specific enquiry about Attrition by age statistics and data:

Social work workforce analysis

Email: CSCWorkforce.ANALYSIS@education.gov.uk
Contact name: Daniel Knowles
Telephone: 0

---