Attrition by time in LA
Latest data
Published
Last updated
Data on the breakdown of attrition by time in local authority (LA) are presented.
Time in local authority is a measure for how long a social worker has worked in their current local authority. Where time in LA is provided for leaver and attrition groups, this is how long the social worker had worked in their LA before leaving the local authority. time in local authority is not a measure of the duration an individual has been registered as a social worker.
On this page
Data set details
- Theme
- Children's social care
- Publication
- Children's social work workforce: attrition, caseload, and agency workforce
- Release
- Reporting year 2021
- Release type
- Geographic levels
- National
- Indicators
- Full Attrition FTE
- Full Attrition Proportion
- LA Workforce FTE
- Filters
- Years in LA
- Time period
- 2020 to 2021
Data set preview
| geographic_level | time_period | time_identifier | country_code | country_name | years_in_la | la_workforce_fte | la_workforce_proportion | leaver_fte | leaver_proportion | total_attrition_fte30 | proportion_of_total_attrition | total_attrition_relative_to_la_workforce | moved_into_agency_fte | moved_into_agency_rate | full_attrition_fte | full_attrition_rate |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| National | 2020 | Reporting year | E92000001 | England | Less than 2 years | 10506.3 | 33 | 1483.7 | 34.6 | 1053.2 | 35.4 | 10 | 328.3 | 47.5 | 724.9 | 31.8 |
| National | 2020 | Reporting year | E92000001 | England | 2 years or more but less than 5 years | 8644.6 | 27.1 | 1505.5 | 35.1 | 971.8 | 32.7 | 11.2 | 275 | 39.8 | 696.8 | 30.5 |
| National | 2020 | Reporting year | E92000001 | England | 5 years or more but less than 10 years | 5561.4 | 17.5 | 622.4 | 14.5 | 417.4 | 14 | 7.5 | 44.7 | 6.5 | 372.7 | 16.3 |
| National | 2020 | Reporting year | E92000001 | England | 10 years or more but less than 20 years | 5217.7 | 16.4 | 454.4 | 10.6 | 335.6 | 11.3 | 6.4 | 34.8 | 5 | 300.8 | 13.2 |
| National | 2020 | Reporting year | E92000001 | England | 20 years or more but less than 30 years | 1420.1 | 4.5 | 154.1 | 3.6 | 129 | 4.3 | 9.1 | 6 | 0.9 | 123 | 5.4 |
Variables in this data set
| Variable name | Variable description |
|---|---|
| full_attrition_fte | Full Attrition FTE |
| full_attrition_rate | Full Attrition Proportion |
| la_workforce_fte | LA Workforce FTE |
| la_workforce_proportion | LA Workforce Proportion |
| leaver_fte | Leaver FTE |
Footnotes
- Time in local authority (LA) calculations are not relative to the LA-employed workforce. The proportions of time in LA groups are of the group they are in, with the full column summing to 100%.
- For social workers in post at 30 September, time in local authority is calculated as the time in years from when the worker started in a children's social worker role at the local authority to 30 September of the reporting year. Therefore time in local authority does not necessarily represent the amount of time an individual has been registered as a social worker, or how long they have spent in the social work profession.
- Components may not sum to totals due to rounding.
- For social workers belonging to one of the attrition groups, time in local authority is calculated as the time in years from when the worker started in a children's social worker role at the local authority, to the date they left a children's social worker role at the local authority. Therefore time in local authority does not necessarily represent the amount of time an individual has been registered as a social worker, or how long they have spent in the social work profession.
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.