Data set from Children's social work workforce

1. Indicators (in post, starters, leavers, agency workers, vacancies, caseload and absence)

Latest data
Published
Last updated
FTE and headcount figures on: social workers in post; starters; leavers; agency social workers in post; vacancies; caseload; and sickness absence.

Data set details

Theme
Children's social care
Publication
Children's social work workforce
Release type
Number of rows
1,463
Geographic levels
Local authority, National, Regional
Indicators
  • Social workers in post - FTE (as at 30 September)
  • Social workers in post - headcount (as at 30 September)
  • Social worker starters - FTE (year to 30 September)
  • Social worker starters - headcount (year to 30 September)
  • Social worker leavers - FTE (year to 30 September)
  • Social worker leavers - headcount (year to 30 September)
  • Turnover rate - FTE (year to 30 September)
  • Turnover rate - headcount (year to 30 September)
  • Agency workers in post - FTE (as at 30 September)
  • Agency workers in post - headcount (as at 30 September)
  • Agency worker rate - FTE (as at 30 September)
  • Agency worker rate - headcount (as at 30 September)
  • Agency workers in post covering vacancies - FTE (as at 30 September)
  • Agency workers covering vacancies rate - FTE (as at 30 September)
  • Vacancies - FTE (as at 30 September)
  • Vacancy rate - FTE (as at 30 September)
  • Vacancy agency worker cover rate - FTE (as at 30 September)
  • Cases held (as at 30 September)
  • Social and agency workers holding cases - FTE (as at 30 September)
  • Average caseload - per FTE (as at 30 September)
  • Working days missed due to sickness absence (year to 30 September)
  • Sickness absence rate - FTE (year to 30 September)
Time period
2017 to 2025

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameregion_coderegion_nameold_la_codenew_la_codela_nameinpost_fteinpost_headcountstarters_ftestarters_headcountleavers_fteleavers_headcountturnover_rate_fteturnover_rate_headcountagency_fteagency_headcountagency_rate_fteagency_rate_headcountagency_cover_fteagency_cover_rate_ftevacancy_ftevacancy_rate_ftevacancy_agency_cover_rate_ftecase_holders_ftecasescaseload_fteworking_days_lost_fteabsence_rate_fte
2025Reporting yearNationalE92000001England36186.3382925837.860434276.3461111.8125415.955661312.74390.881.15965.414.273.621105.432166115.2322786.33.5
2025Reporting yearRegionalE92000001EnglandE12000001North East2299.32434363.2375269.928911.711.92062108.27.9158.577223.98.970.81378.92273616.522947.53.9
2025Reporting yearRegionalE92000001EnglandE12000002North West5239.25538930.1966637.768512.212.41044.5105716.616741.97197515.776.13116.74935115.854697.24.1
2025Reporting yearRegionalE92000001EnglandE12000003Yorkshire and The Humber41164405600.1618408.84459.910.1353.13587.97.5221.362.7330.87.466.92172.43454415.942690.24.1
2025Reporting yearRegionalE92000001EnglandE12000004East Midlands2626.62802425.8454257.23069.810.9300.430810.39.925885.9352.411.873.21613.62468215.3275164.1

Variables in this data set

Table showing all 22 variables
Variable nameVariable description
absence_rate_fteSickness absence rate - FTE (year to 30 September)
agency_cover_fteAgency workers in post covering vacancies - FTE (as at 30 September)
agency_cover_rate_fteAgency workers covering vacancies rate - FTE (as at 30 September)
agency_fteAgency workers in post - FTE (as at 30 September)
agency_headcountAgency workers in post - headcount (as at 30 September)
agency_rate_fteAgency worker rate - FTE (as at 30 September)
agency_rate_headcountAgency worker rate - headcount (as at 30 September)
case_holders_fteSocial and agency workers holding cases - FTE (as at 30 September)
caseload_fteAverage caseload - per FTE (as at 30 September)
casesCases held (as at 30 September)
inpost_fteSocial workers in post - FTE (as at 30 September)
inpost_headcountSocial workers in post - headcount (as at 30 September)
leavers_fteSocial worker leavers - FTE (year to 30 September)
leavers_headcountSocial worker leavers - headcount (year to 30 September)
starters_fteSocial worker starters - FTE (year to 30 September)
starters_headcountSocial worker starters - headcount (year to 30 September)
turnover_rate_fteTurnover rate - FTE (year to 30 September)
turnover_rate_headcountTurnover rate - headcount (year to 30 September)
vacancy_agency_cover_rate_fteVacancy agency worker cover rate - FTE (as at 30 September)
vacancy_fteVacancies - FTE (as at 30 September)
vacancy_rate_fteVacancy rate - FTE (as at 30 September)
working_days_lost_fteWorking days missed due to sickness absence (year to 30 September)

Footnotes

  1. Kensington and Chelsea and Westminster were unable to provide data for 2025 following a cyberattack which had a significant impact on their information management systems. Therefore, figures from the previous year were used as best estimates for these local authorities to calculate 2025 totals for England, London, and Inner London.

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


Contact us

If you have a specific enquiry about 1. Indicators (in post, starters, leavers, agency workers, vacancies, caseload and absence) statistics and data:

Children’s Services Statistics Team

Email: csww.stats@education.gov.uk
Contact name: Andy Brook