Data set from Children's social work workforce

2. Characteristics (in post, starters, leavers)

Latest data
Published
Last updated

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

  • age
  • ethnicity
  • gender
  • role
  • time in service

Data set details

Theme
Children's social care
Publication
Children's social work workforce
Release type
Geographic levels
Local authority, National, Regional
Indicators
  • Social workers in post - FTE (as at 30 September)
  • Percentage of social workers in post - FTE (as at 30 September)
  • Social workers in post - headcount (as at 30 September)
Filters
  • Breakdown
Time period
2017 to 2023

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameregion_coderegion_nameold_la_codenew_la_codela_namebreakdown_topicbreakdowninpost_FTEinpost_FTE_percentageinpost_headcountinpost_headcount_percentagestarters_FTEstarters_FTE_percentagestarters_headcountstarters_headcount_percentageleavers_FTEleavers_FTE_percentageleavers_headcountleavers_headcount_percentage
2023Reporting yearNationalE92000001EnglandTotalTotal33119.1100351991006027.510062471005254.61005640100
2023Reporting yearNationalE92000001EnglandAge group20 to 29 years old5214.315.7530915.11873.431.1190030.4837.615.985615.2
2023Reporting yearNationalE92000001EnglandAge group30 to 39 years old10108.330.51082630.81927.732200932.21620.630.8173730.8
2023Reporting yearNationalE92000001EnglandAge group40 to 49 years old8464.825.6902325.61332.822.1138722.21291.724.6138124.5
2023Reporting yearNationalE92000001EnglandAge group50 to 59 years old6910.320.9727320.7736.712.277512.4974.118.5104318.5

Variables in this data set

Table showing first 5 of 13 variables
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)

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.

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

Download this data using code

Access this data using common programming languages using the URL below.

Example code