Data set from Children's social work workforce

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

Not the 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,300
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)
  • Social and agency workers holding cases - FTE (as at 30 September)
  • Cases held (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 2024

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
2024Reporting yearNationalE92000001England34328.2364025613.458224728.7507313.813.96520.7670416.215.75313.281.37188.617.376.220803.532046115.4287194.93.4
2024Reporting yearRegionalE92000001EnglandE12000001North East2158.12279295.8310271.530912.613.6250.625810.410.2183.573.2299.712.261.21365.92299416.823171.44.2
2024Reporting yearRegionalE92000001EnglandE12000002North West4887.25168848.4882755.479715.515.41145.311571918.3862.375.31102.618.478.22982.14955516.649509.84
2024Reporting yearRegionalE92000001EnglandE12000003Yorkshire and The Humber3858.64152600.8617473.352012.312.5507.851211.61137573.9597.113.462.82198.33479015.836170.53.7
2024Reporting yearRegionalE92000001EnglandE12000004East Midlands24312615381.6410276.531711.412.1439.545015.314.7345.878.7471.916.373.31604.3240991522559.93.7

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)

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