Reporting year 2025

Children's social work workforce

Data guidance

Published

Description

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

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

The methodology page should be referenced alongside this data.

Coverage

This annual release contains statistics on child 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 for Education from all local authorities in England in the annual Children’s social work workforce census (opens in new tab)

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

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 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_2025.csv
Geographic levels
Local authority; National; Regional
Time period
2017 to 2025
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 for 1. Indicators (in post, starters, leavers, agency workers, vacancies, caseload and absence)

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 for 1. Indicators (in post, starters, leavers, agency workers, vacancies, caseload and absence)
  1. Kensington and Chelsea and Westminster were unable to provide data for 2025 following a cyberattack which had a significant impact on their information management systems. Therefore, figures from the previous year were used as best estimates for these local authorities to calculate 2025 totals for England, London, and Inner London.

2. Characteristics (in post, starters, leavers)

Filename
csww_characteristics_inpost_starters_leavers_2017_to_2025.csv
Geographic levels
Local authority; National; Regional
Time period
2017 to 2025
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 for 2. Characteristics (in post, starters, leavers)

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 for 2. Characteristics (in post, starters, leavers)
  1. Kensington and Chelsea and Westminster were unable to provide data for 2025 following a cyberattack which had a significant impact on their information management systems. Therefore, figures from the previous year were used as best estimates for these local authorities to calculate 2025 totals for England, London, and Inner London.
  2. Age of the child and family social worker at 30 September of the reporting year.
  3. Age of social worker starter at 30 September of the reporting year.
  4. Age of social worker leaver on the date they left their post at the local authority.
  5. White comprises white British, white Irish, or any other white background.
  6. Mixed / Multiple ethnic groups comprises white and black Caribbean, white and black African, white and Asian, or any other mixed background.
  7. Asian / Asian British comprises Indian, Pakistani, Bangladeshi, Chinese, or any other Asian background.
  8. Black / African / Caribbean / Black British comprises black Caribbean, black African, or any other black background.

3. Role by characteristics (in post)

Filename
csww_role_by_characteristics_inpost_2019_to_2025.csv
Geographic levels
Local authority; National; Regional
Time period
2019 to 2025
Content
FTE and headcount figures on the role of social workers in post by: sex; age; and ethnicity.
Variable names and descriptions for 3. Role by characteristics (in post)

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 for 3. Role by characteristics (in post)
  1. Kensington and Chelsea and Westminster were unable to provide data for 2025 following a cyberattack which had a significant impact on their information management systems. Therefore, figures from the previous year were used as best estimates for these local authorities to calculate 2025 totals for England, London, and Inner London.
  2. 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.
  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. Mixed / Multiple ethnic groups comprises white and black Caribbean, white and black African, white and Asian, or any other mixed background.
  6. Asian / Asian British comprises Indian, Pakistani, Bangladeshi, Chinese, or any other Asian background.
  7. Black / African / Caribbean / Black British comprises black Caribbean, black African, or any other black background.

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

Filename
csww_cross_characteristics_inpost_2017_to_2025.csv
Geographic levels
National
Time period
2017 to 2025
Content
FTE and headcount figures on the cross-characteristics of social workers in post by: sex; age; and ethnicity.
Variable names and descriptions for 4. Cross-characteristics (in post) - national only

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 for 4. Cross-characteristics (in post) - national only
  1. Kensington and Chelsea and Westminster were unable to provide data for 2025 following a cyberattack which had a significant impact on their information management systems. Therefore, figures from the previous year were used as best estimates for these local authorities to calculate 2025 totals for England, London, and Inner London.
  2. Age of the child and family social worker at 30 September of the reporting year.
  3. White comprises white British, white Irish, or any other white background.
  4. Mixed / Multiple ethnic groups comprises white and black Caribbean, white and black African, white and Asian, or any other mixed background.
  5. Asian / Asian British comprises Indian, Pakistani, Bangladeshi, Chinese, or any other Asian background.
  6. Black / African / Caribbean / Black British comprises black Caribbean, black African, or any other black background.

5. Attrition (leavers) - national only

Filename
csww_attrition_2017_to_2025.csv
Geographic levels
National
Time period
2017 to 2025
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 for 5. Attrition (leavers) - national only

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)

6. Base salary full-time (in post) - national and regional only

Filename
csww_full_time_base_salary_2025.csv
Geographic levels
National; Regional
Time period
2025
Content
These are official statistics in development. Base salary information of full-time social workers in post by role, sex, ethnicity, age and time in service.
Variable names and descriptions for 6. Base salary full-time (in post) - national and regional only

Variable names and descriptions for this file are provided below:

Variable nameVariable description
age_groupAge group
ethnicity_majorEthnicity major
inpost_full_time_base_salary_meanMean base salary of full time social workers in post (as at 30 September)
inpost_full_time_base_salary_medianMedian base salary of full time social workers in post (as at 30 September)
inpost_full_time_base_salary_recordedNumber of full time social workers in post with base salary recorded (as at 30 September)
roleOrganisation role
sexSex
time_in_serviceTime in service
Footnotes for 6. Base salary full-time (in post) - national and regional only
  1. Age of the child and family social worker at 30 September of the reporting year.
  2. White comprises white British, white Irish, or any other white background.
  3. Mixed / Multiple ethnic groups comprises white and black Caribbean, white and black African, white and Asian, or any other mixed background.
  4. Asian / Asian British comprises Indian, Pakistani, Bangladeshi, Chinese, or any other Asian background.
  5. Black / African / Caribbean / Black British comprises black Caribbean, black African, or any other black background.

7. Allowances and additional payments - national and regional only

Filename
csww_allowances_and_additional_payments_2025.csv
Geographic levels
National; Regional
Time period
2025
Content
These are official statistics in development. Figures on the eligibility of social workers in post for eight types of local authority allowances and additional payments.
Variable names and descriptions for 7. Allowances and additional payments - national and regional only

Variable names and descriptions for this file are provided below:

Variable nameVariable description
allowances_and_additional_paymentsAllowances and additional payments
eligibilityEligibility
number_local_authoritiesNumber of local authorities
percentage_local_authoritiesPercentage of local authorities