Data set from Children's social work workforce

Starters and leavers characteristics

Not the latest data
Published
Last updated

Characteristics of children and family social worker starters and leavers (FTE and headcount).

Data for overall totals, age, gender and time in service  at local authority (leavers only).


Data set details

Theme
Children's social care
Publication
Children's social work workforce
Release type
Geographic levels
Local authority, National, Regional
Indicators
  • Number of children and family social workers leaving during year
  • Number of children and family social workers starting during year
  • Percentage of children and family social workers leaving during year
Filters
  • Characteristic type
  • Count type
Time period
2017 to 2022

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameregion_coderegion_nameold_la_codenew_la_codela_namecountcharacteristiccharacteristic_typenumber_of_startersstarters_percentagenumber_of_leaversleavers_percentage
2022Reporting yearNationalE92000001EnglandFTETotalTotal4825.6z5422z
2022Reporting yearRegionalE92000001EnglandE12000001North EastFTETotalTotal268.8z282.3z
2022Reporting yearRegionalE92000001EnglandE12000002North WestFTETotalTotal604.1z718.1z
2022Reporting yearRegionalE92000001EnglandE12000003Yorkshire and The HumberFTETotalTotal523.5z548.3z
2022Reporting yearRegionalE92000001EnglandE12000004East MidlandsFTETotalTotal298.7z380.7z

Variables in this data set

Table showing first 5 of 6 variables
Variable nameVariable description
characteristic_typeCharacteristic type
countCount type
leavers_percentagePercentage of children and family social workers leaving during year
number_of_leaversNumber of children and family social workers leaving during year
number_of_startersNumber of children and family social workers starting during year

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 (refer to the methodology section for more information).
  3. Starters are social workers who joined a vacant child and family social worker post at a local authority in the year ending 30 September. This includes social workers who have previously worked in the same local authority, but in a non-child and family role. A move or promotion from one child and family social work position to another within the same local authority is not counted as a starter. Similarly, social workers returning from maternity or sick leave are not counted as starters.
  4. 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 and those continuing as children’s social workers but moving to a different local authority. Leavers also include social workers who have begun a career break, those seconded out of an organisation or those leaving the profession altogether. They do not include social workers who have started maternity or sick leave, or moved from one children’s social work position to another children’s social work position within a local authority.
  5. Age of starter at 30 September of the reporting year.
  6. Age of leaver on the date they left their post at the local authority.
  7. For children and family social worker leavers, time in service is calculated as the time in years from when the worker started in a child and family social worker role at the local authority to the date they left a child and family social worker role at the local authority.
  8. Time in service is a measure of the total time in years 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 they have spent in their current children and family social worker role.

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