Data set from Children's social work workforce

Caseloads, absence, vacancies, turnover and agency workers

Not the latest data
Published
Last updated

Figures on social workers (FTE and headcount), leavers and turnover (FTE and headcount), absence (FTE), agency workers (FTE and headcount), vacancies (FTE) and caseload (FTE). 


Data set details

Theme
Children's social care
Publication
Children's social work workforce
Release type
Geographic levels
Local authority, National, Regional
Indicators
  • Agency cover rate (FTE)
  • Agency worker rate (FTE)
  • Agency worker rate (Headcount)
Time period
2017 to 2021

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameregion_coderegion_nameold_la_codenew_la_codela_namesocial_worker_fteleaver_fteturnover_rate_fte_%working_days_lost_fteabsence_rate_fte_%agency_fteagency_worker_rate_fte_%agency_cover_fteagency_cover_rate_fte_%vacancy_ftevacancy_rate_fte_%vacancy_agency_cover_rate_fte_%case_holders_ftecasescaseload_ftesocial_worker_headcountleaver_headcountturnover_rate_headcount_%agency_headcountagency_worker_rate_headcount_%
2021Reporting yearNationalE92000001England325024994.515.4258371.23.15976.515.54557.876.36521.916.769.920548.933551016.334679572916.5614815.1
2021Reporting yearRegionalE92000001EnglandE12000001North East2101.4272.61317955.63.4212.49.2116.855200.68.758.21414.82594018.3219130814.12179
2021Reporting yearRegionalE92000001EnglandE12000002North West4541.2660.214.545375.73.9778.414.6565.872.7877.316.264.52698.24949218.3481473115.279514.2
2021Reporting yearRegionalE92000001EnglandE12000003Yorkshire and The Humber3687.3524.514.234436.43.754212.8386.971.4684.415.756.522223763016.940106021555812.2
2021Reporting yearRegionalE92000001EnglandE12000004East Midlands2421.3355.414.719105.53.1405.414.3270.466.7386.213.8701578.32559016.2265042015.841113.4

Variables in this data set

Table showing first 5 of 20 variables
Variable nameVariable description
absence_rate_fte_%Sickness absence rate throughout year (FTE)
agency_cover_fteNumber of agency workers at 30 September covering vacancies (FTE)
agency_cover_rate_fte_%Agency cover rate (FTE)
agency_fteNumber of agency workers at 30 September (FTE)
agency_headcountNumber of agency workers at 30 September (Headcount)

Footnotes

  1. Caseload is calculated as the total number of cases held by FTE social workers (including agency workers) in post at the 30 September divided by the number of FTE social workers (including agency workers) at 30 September that hold one or more cases.
  2. Full-time Equivalent (FTE) figures are calculated by aggregating the total number of hours that social workers are contracted to work and dividing by the standard hours for their grade. FTE figures exclude social workers for whom FTE information was missing or not known.
  3. Leavers are social workers who left a child and family social worker post at a local authority in the year ending 30 September. This includes social workers who are staying at a local authority, but moving to a non-child and family role and those continuing as children’s social workers but moving to a different local authority. Leavers also include social workers who have begun a career break, those seconded out of an organisation or those leaving the profession altogether. They do not include social workers who have started maternity or sick leave, or moved from one children’s social work position to another children’s social work position within a local authority.
  4. The rate of agency workers covering vacancies at 30 September is calculated as the number of FTE agency workers divided by the number of FTE vacancies at 30 September. Where a local authority has reported more than one agency worker covering the same vacancy, this rate may exceed 100%.
  5. The agency worker rate is calculated as the number of FTE (or headcount) agency staff working as social workers at 30 September divided by the sum of the number of FTE (or headcount) agency staff working as social workers at 30 September and the number of FTE (or headcount) social workers.
  6. The FTE vacancy rate is calculated as the number of FTE vacancies at 30 September divided by the sum of the number of FTE vacancies at 30 September and the number of FTE social workers at 30 September.
  7. The absence rate is calculated as the number of days missed due to sickness absence during the year divided by the number of FTE social workers at 30 September multiplied by 253 days (the number of working days in a non-leap year, taking account of bank holidays). The rate for a leap year is based on 254 working days.
  8. The turnover rate is calculated as the number of FTE (or headcount) social workers leaving a social work role in the year divided by the number of FTE (or headcount) social workers in post at the 30 September.
  9. Headcount is a count of all individual children and family social workers, regardless of their working pattern: where a social worker holds more than one post within a local authority, only one post is counted (refer to the methodology section for more information).

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