Reporting year 2024

Children's social work workforce

Data guidance

Published

Description

This guidance describes the data included in the underlying data files of the 2024 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 2024.

File formats and conventions

Symbology

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

     z        Data is not applicable

     x        Data is unavailable for unknown or other reasons    

     c        Suppressed to protect confidential information

     low   Rounds to 0, but is not 0

     u        low reliability

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 release are listed below with guidance on their content. To download any of these files, please visit our data catalogue.

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_2024.csv
Geographic levels
Local authority; National; Regional
Time period
2017 to 2024
Content
FTE and headcount figures on: social workers in post; starters; leavers; agency social workers in post; vacancies; caseload; and 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)

2. Characteristics (in post, starters, leavers)

Filename
csww_characteristics_inpost_starters_leavers_2017_to_2024.csv
Geographic levels
Local authority; National; Regional
Time period
2017 to 2024
Content
FTE and headcount figures on characteristics of social workers in post, starters and leavers by: sex; age; ethnicity; role; and 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. Age of the children and family social worker at 30 September of the reporting year.
  2. Age of social worker starter at 30 September of the reporting year.
  3. Age of social worker leaver on the date they left their post at the local authority.
  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.

3. Role by characteristics (in post)

Filename
csww_role_by_characteristics_inpost_2019_to_2024.csv
Geographic levels
Local authority; National; Regional
Time period
2019 to 2024
Content
FTE and headcount figures on the role of social workers in post by: sex; age; and ethnicity.
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. Age of the children and family social worker at 30 September of the reporting year.
  2. White comprises white British, white Irish, or any other white background.
  3. Black or Black British comprises black Caribbean, black African, or any other black background.
  4. Asian or Asian British comprises Indian, Pakistani, Bangladeshi, Chinese, or any other Asian background.
  5. Mixed comprises white and black Caribbean, white and black African, white and Asian, or any other mixed background.
  6. For certain years, there can be small differences in the totals for different characteristics. This is due to social workers with unknown characteristics being excluded from the respective totals.

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

Filename
csww_cross_characteristics_inpost_2017_to_2024.csv
Geographic levels
National
Time period
2017 to 2024
Content
FTE and headcount figures on the cross-characteristics of social workers in post by: sex; age; and ethnicity.
Variable names and descriptions

Variable names and descriptions for this file are provided below:

Variable nameVariable description
age_groupAge group
ethnicity_majorEthnicity major
inpost_fteSocial workers in post - FTE (as at 30 September)
inpost_headcountSocial workers in post - headcount (as at 30 September)
sexSex
Footnotes
  1. Age of the children and family social worker at 30 September of the reporting year.
  2. White comprises white British, white Irish, or any other white background.
  3. Black or Black British comprises black Caribbean, black African, or any other black background.
  4. Asian or Asian British comprises Indian, Pakistani, Bangladeshi, Chinese, or any other Asian background.
  5. 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_2024.csv
Geographic levels
National
Time period
2017 to 2024
Content
These are official statistics in development. FTE figures on the number and rate of social worker leavers due to: total attrition; full attrition; agency attrition; and movers between local authorities.
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)
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)