Data set from Children's social work workforce

FTE and Headcount rates

Not the latest data
Published
Last updated

Data set details

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

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_fteworking_days_lost_fteabsence_rate_fteagency_fteagency_worker_rate_fteagency_cover_fteagency_cover_rate_ftevacancy_ftevacancy_rate_ftevacancy_agency_cover_rate_ftecase_holders_ftecasescaseload_ftesocial_worker_headcountleaver_headcountturnover_headcountagency_headcountagency_worker_rate_headcountagency_cover_headcountagency_cover_rate_headcount
2019Reporting yearNationalE92000001England 30720.14652.615.1242753.63.15753.515.8441476.76036.616.473.120006.633741116.932917528916.1609015.6468676.9
2019Reporting yearRegionalE92000001EnglandE12000001North East 1939.9290.21516606.53.4159.37.6102.764.5165.37.962.212552285018.2206731915.41677.510462.3
2019Reporting yearRegionalE92000001EnglandE12000002North West 4327.7583.313.5413863.8645.213408.763.3738.414.655.42669.74988118.7458363813.965912.642464.3
2019Reporting yearRegionalE92000001EnglandE12000003Yorkshire and the Humber 3580.7486.613.638085.24.240710.2266.765.5358.29.174.521893943018388556114.44159.727967.2
2019Reporting yearRegionalE92000001EnglandE12000004East Midlands 2310.3350.815.220371.83.5428.915.7381.188.9336.112.7113.41434.72547217.8250641216.444014.939289.1

Variables in this data set

Table showing first 5 of 21 variables
Variable nameVariable description
absence_rate_fteAbsence rate throughout year (FTE)
agency_cover_fteNumber of agency workers at 30 Sept of which covering vacancies (FTE)
agency_cover_headcountNumber of agency workers at 30 Sept of which covering vacancies (Headcount)
agency_cover_rate_fteAgency cover rate (FTE)
agency_cover_rate_headcountAgency cover rate (Headcount)

Footnotes

  1. Turnover rates have been calculated as follows: 100 * ( Number of leavers during the year / Number of children's social workers at 30 September)
  2. Headcount is a count of all distinct children and family social workers: where a social worker holds more than one post only one record is counted.
  3. 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.
  4. Agency worker rates have been calculated as follows: 100 * { Number of agency workers / (Number of children's social workers + Number of agency workers) } and are based on a snapshot at 30 September.
  5. Children and family social worker vacancies including vacancies covered by agency workers, on a FTE basis only.
  6. Absence rate has been calculated as follows: 100 * {Number of days missed due to sickness absence/ ( FTE number of children’s social workers x 253)}, where 253 is the number of working days in a year accounting for bank holidays. The number of days sickness is counted during year ending 30 September.
  7. Vacancy rates have been calculated as follows: 100 * { FTE number of vacancies / (FTE number of children's social workers + FTE number of vacancies)} and are based on a snapshot at 30 September.
  8. 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, for example moving to adult social care.
  9. Social workers included in this table are those registered with the Health and Care Professionals Council and either work in a local authority in a children’s services department or, if working in an authority where the services are joined up, work exclusively on children and families work.

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