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

Caseload breakdown

Latest data
Last updated

Breakdown and distribution of how many cases were held by social workers on 30 September 2021.

Data set details

Children's social care
Children's social work workforce: attrition, caseload, and agency workforce
Release type
Geographic levels
  • Cumulative FTE
  • Cumulative FTE Proportion
  • Total FTE
  • Cases Held
Time period

Data set preview

Table showing first 5 rows, from underlying data
National2021Reporting yearE92000001England1648.5648.53.17
National2021Reporting yearE92000001England2486.241134.745.55
National2021Reporting yearE92000001England3383.031517.777.42
National2021Reporting yearE92000001England4341.241859.019.09
National2021Reporting yearE92000001England5404.292263.311.06

Variables in this data set

Table showing all 4 variables
Variable nameVariable description
cumulative_fteCumulative FTE
cumulative_proportionCumulative FTE Proportion
rounded_casesCases Held
total_fteTotal FTE


  1. Components may not sum to totals due to rounding.
  2. Social workers who do not hold cases (0 cases per FTE) are excluded – 17,930 FTE social workers.
  3. Social workers who held cases, but had 0 FTE recorded are excluded – 26 social worker with 0 FTE were holding 309 cases.
  4. Social workers holding more than 50 cases per FTE are excluded – 91.0 FTE social workers were holding 4,878 cases.

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