Reporting year 2023

Children's social work workforce

Data guidance

Published

Description

This guidance describes the data included in the underlying data files of the 2023 official statistics release ‘Children's social work workforce’.

This data is released under the terms of the Open Government Licence (opens in a new tab) and is intended to meet at least 3 stars for Open Data (opens in a new tab)

The methodology page should be referenced alongside this data.

Coverage

This annual release contains statistics on children and family social workers, including agency social workers, employed in local authorities in England. Each reporting year covers the period 1 October to 30 September.

The information is based on data collected by the department from local authorities in the annual Children’s social work workforce census (opens in a new tab)

The underlying data files include national, regional and local authority level information for the years 2017 to 2023.

Symbology

The following symbols are used in the underlying data files as follows: 

     c     to protect confidentiality - secondary suppression may also be applied to figures to protect confidentiality

     u      low reliability

     x      data not available 

     z      data not applicable 

Rounding

Figures for full-time equivalents (FTEs), rates, percentages, caseload and working days have been rounded to one decimal place. Therefore component parts may not sum to totals if applicable.

Headcounts and cases held are reported to the nearest whole number.

Data files

All data files associated with this releases are listed below with guidance on their content. To download any of these files, please visit our data catalogue.

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

Filename
csww_indicators_2017_to_2023.csv
Geographic levels
Local authority; National; Regional
Time period
2017 to 2023
Content

FTE and headcount figures on:

  • social workers in post
  • starters
  • leavers 
  • agency social workers in post
  • vacancies 
  • caseload
  • sickness absence
Variable names and descriptions

Variable names and descriptions for this file are provided below:

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. 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.
  2. 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 (the more senior role where applicable). 
  3. The vacancy rate, as at 30 September, is calculated as FTE vacancies divided by the sum of FTE vacancies and FTE social workers.
  4. The sickness absence rate is calculated as the number of days missed due to sickness absence during the year to 30 September divided by the number of FTE social workers in post 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.
  5. The turnover rate is calculated as (the number of) children and family social worker leavers in the year to 30 September divided by children and family social workers in post at 30 September. The turnover rate is a measure of churn in the workforce (although it doesn’t capture the movement of social workers to different children and family social work positions within the same local authority).
  6. The agency worker rate, as at 30 September, is calculated as (the number of) FTE agency (children and family) social workers divided by the sum of FTE agency social workers and FTE social workers.
  7. Average caseload at 30 September is calculated as the total number of cases held by FTE social workers, including agency workers, in post divided by the number of FTE social workers, including agency workers, in post that held one or more cases. 
  8. Starters are social workers who joined a vacant children and family social worker post at a local authority in the year ending 30 September. The following are included in the social worker starters figures: those joining from the same local authority, but from a non-children and family social work position; those joining from a children and family social work position in another local authority in England; and those joining from an agency children and family social work position. The following are not included in the social worker starters figures: those moving or being promoted from one children and family social work position to another within the same local authority; those returning from maternity or sick leave; and those who started and left in the same reporting year.
  9. Leavers are social workers who left a children and family social worker post at a local authority in the year ending 30 September. The following are included in the social worker leavers figures: those who are staying at the same local authority, but are moving to a non-children and family social work position; those moving to a children and family social work position in a different local authority in England; those moving to an agency children and family social work position; those who have begun a career break; those seconded out of an organisation; and those leaving the profession altogether. The following are not included in the social worker leavers figures: those moving or being promoted from one children and family social work position to another within the same local authority; those who have started maternity or sick leave; and those who started and left in the same reporting year. 
  10. The agency workers covering vacancies rate, as at 30 September, is calculated as (the number of) FTE agency workers covering vacancies divided by FTE agency workers.
  11. The vacancy agency cover rate, as at 30 September, is calculated as FTE agency workers in post covering vacancies, divided by FTE vacancies.

2. Characteristics (in post, starters, leavers)

Filename
csww_characteristics_inpost_starters_leavers_2017_to_2023.csv
Geographic levels
Local authority; National; Regional
Time period
2017 to 2023
Content

FTE and headcount figures on characteristics of social workers in post, starters and leavers by:

  • age
  • ethnicity
  • gender
  • role
  • time in service
Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
breakdownBreakdown
inpost_FTESocial workers in post - FTE (as at 30 September)
inpost_FTE_percentagePercentage of social workers in post - FTE (as at 30 September)
inpost_headcountSocial workers in post - headcount (as at 30 September)
inpost_headcount_percentagePercentage of social workers in post - headcount (as at 30 September)
leavers_FTESocial worker leavers - FTE (year to 30 September)
leavers_FTE_percentagePercentage of social worker leavers - FTE (year to 30 September)
leavers_headcountSocial worker leavers - headcount (year to 30 September)
leavers_headcount_percentagePercentage of social worker leavers - headcount (year to 30 September)
starters_FTESocial worker starters - FTE (year to 30 September)
starters_FTE_percentagePercentage of social worker starters - FTE (year to 30 September)
starters_headcountSocial worker starters - headcount (year to 30 September)
starters_headcount_percentagePercentage of social worker starters - headcount (year to 30 September)
Footnotes
  1. 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.
  2. 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 (the more senior role where applicable). 
  3. For children and family social workers, time in service is calculated as the time in years from when the social worker started in a child and family social worker role to 30 September of the reporting year or, for leavers, the date they left a child and family social worker role at the local authority. It is a measure of the total time that a social worker has been employed continuously in any children and family social worker role at their current local authority, rather than only the time in their latest role.
  4. Starters are social workers who joined a vacant children and family social worker post at a local authority in the year ending 30 September. The following are included in the social worker starters figures: those joining from the same local authority, but from a non-children and family social work position; those joining from a children and family social work position in another local authority in England; and those joining from an agency children and family social work position. The following are not included in the social worker starters figures: those moving or being promoted from one children and family social work position to another within the same local authority; those returning from maternity or sick leave; and those who started and left in the same reporting year.
  5. Leavers are social workers who left a children and family social worker post at a local authority in the year ending 30 September. The following are included in the social worker leavers figures: those who are staying at the same local authority, but are moving to a non-children and family social work position; those moving to a children and family social work position in a different local authority in England; those moving to an agency children and family social work position; those who have begun a career break; those seconded out of an organisation; and those leaving the profession altogether. The following are not included in the social worker leavers figures: those moving or being promoted from one children and family social work position to another within the same local authority; those who have started maternity or sick leave; and those who started and left in the same reporting year. 
  6. Age of the child and family social worker at 30 September of the reporting year.
  7. Age of starter at 30 September of the reporting year.
  8. Age of leaver on the date they left their post at the local authority.
  9. White comprises white British, white Irish, or any other white background.
  10. Black or Black British comprises black Caribbean, black African or any other black background.
  11. Asian or Asian British comprises Indian, Pakistani, Bangladeshi, Chinese or any other Asian background. 
  12. Mixed comprises white and black Caribbean, white and black African, white and Asian, or any other mixed background.

3. Role by characteristics (in post)

Filename
csww_role_by_characteristics_inpost_2019_to_2023.csv
Geographic levels
Local authority; National; Regional
Time period
2019 to 2023
Content

FTE and headcount figures on the role of social workers in post by: 

  • age
  • ethnicity
  • gender
Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
breakdownBreakdown
inpost_FTESocial workers in post - FTE (as at 30 September)
inpost_FTE_percentagePercentage of social workers in post - FTE (as at 30 September)
inpost_headcountSocial workers in post - headcount (as at 30 September)
inpost_headcount_percentagePercentage of social workers in post - headcount (as at 30 September)
roleOrganisation role
Footnotes
  1. 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.
  2. 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 (the more senior role where applicable). 
  3. Age of the child and family social worker at 30 September of the reporting year.
  4. White comprises white British, white Irish, or any other white background.
  5. Black or Black British comprises black Caribbean, black African or any other black background.
  6. Asian or Asian British comprises Indian, Pakistani, Bangladeshi, Chinese or any other Asian background. 
  7. Mixed comprises white and black Caribbean, white and black African, white and Asian, or any other mixed background.

4. Cross-characteristics (in post) - national only

Filename
csww_cross_characteristics_inpost_2017_to_2023.csv
Geographic levels
National
Time period
2017 to 2023
Content

FTE and headcount figures on the cross-characteristics of social workers in post by:

  • age
  • ethnicity
  • gender
Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
age_groupAge group
ethnicity_majorEthnicity major
genderGender
inpost_fteSocial workers in post - FTE (as at 30 September)
inpost_headcountSocial workers in post - headcount (as at 30 September)
Footnotes
  1. 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.
  2. 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 (the more senior role where applicable). 
  3. Age of the child and family social worker at 30 September of the reporting year.
  4. White comprises white British, white Irish, or any other white background.
  5. Black or Black British comprises black Caribbean, black African or any other black background.
  6. Asian or Asian British comprises Indian, Pakistani, Bangladeshi, Chinese or any other Asian background. 
  7. Mixed comprises white and black Caribbean, white and black African, white and Asian, or any other mixed background.

5. Attrition (leavers) - national only

Filename
csww_attrition_2017_to_2023.csv
Geographic levels
National
Time period
2017 to 2023
Content

These are official statistics in development (opens in a new tab)

FTE figures on the number and rate of social worker leavers due to:

  • total attrition
  • full attrition
  • agency attrition 
  • movers between local authorities

Figures on the total number of social workers in post and leavers, as well as the associated turnover rate, are included from file 1 for context and comparison.

Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
agency_attrition_fteAgency attrition - FTE (year to 30 September)
agency_attrition_rate_fteAgency attrition rate - FTE (year to 30 September)
full_attrition_fteFull attrition - FTE (year to 30 September)
full_attrition_rate_fteFull attrition rate - FTE (year to 30 September)
inpost_fteSocial workers in post - FTE (as at 30 September)
leavers_fteSocial worker leavers - FTE (year to 30 September)
movers_las_fteMovers between local authorities - FTE (year to 30 September)
movers_las_rate_fteMovers between local authorities rate - FTE (year to 30 September)
total_attrition_fteTotal attrition - FTE (year to 30 September)
total_attrition_rate_fteTotal attrition rate - FTE (year to 30 September)
turnover_rate_fteTurnover rate - FTE (year to 30 September)
Footnotes
  1. 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.
  2. The turnover rate is calculated as (the number of) children and family social worker leavers in the year to 30 September divided by children and family social workers in post at 30 September. The turnover rate is a measure of churn in the workforce (although it doesn’t capture the movement of social workers to different children and family social work positions within the same local authority).
  3. Leavers are social workers who left a children and family social worker post at a local authority in the year ending 30 September. The following are included in the social worker leavers figures: those who are staying at the same local authority, but are moving to a non-children and family social work position; those moving to a children and family social work position in a different local authority in England; those moving to an agency children and family social work position; those who have begun a career break; those seconded out of an organisation; and those leaving the profession altogether. The following are not included in the social worker leavers figures: those moving or being promoted from one children and family social work position to another within the same local authority; those who have started maternity or sick leave; and those who started and left in the same reporting year. 
  4. The attrition rate (either agency or full) is calculated as the number of FTE children and family social workers leaving due to attrition during the year ending 30 September divided by the number of FTE children and family social workers in post at 30 September.
  5. The movers rate is calculated as the number of FTE children and family social workers moving to a children and family social work position in a different local authority divided by the number of FTE children and family social workers in post at 30 September.
  6. Movers between local authorities refers to FTE children and family social worker leavers who have moved to a children and family social work position in a different local authority in England.
  7. Agency attrition refers to FTE children and family social worker leavers now working as an agency children and family social worker, either in the same or a different local authority in England.
  8. Full attrition refers to FTE children and family social worker leavers who are not identified as a children and family social worker or agency children and family social worker within any local authority in England.