FTE and headcount rates
Not the latest data
Published
Last updated
Absence, vacancy, turnover and agency worker rates, and caseload of children and family social workers. These measures are reported on a full-time equivalent (FTE) and headcount basis where applicable.
On this page
Data set details
- Theme
- Children's social care
- Publication
- Children's social work workforce
- Release
- Reporting year 2020
- Release type
- Geographic levels
- Local authority, National, Regional
- Indicators
- Absence rate throughout year (FTE)
- Agency cover rate (FTE)
- Agency cover rate (Headcount)
- Time period
- 2017 to 2020
Data set preview
| time_period | time_identifier | geographic_level | country_code | country_name | region_code | region_name | old_la_code | new_la_code | la_name | social_worker_fte | leaver_fte | turnover_rate_fte_% | working_days_lost_fte | absence_rate_fte_% | agency_fte | agency_worker_rate_fte_% | agency_cover_fte | agency_cover_rate_fte_% | vacancy_fte | vacancy_rate_fte_% | vacancy_agency_cover_rate_fte_% | case_holders_fte | cases | caseload_fte | social_worker_headcount | leaver_headcount | turnover_rate_headcount_% | agency_headcount | agency_worker_rate_headcount_% | agency_cover_headcount | agency_cover_rate_headcount_% |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2020 | Reporting year | National | E92000001 | England | 31854.3 | 4294.2 | 13.5 | 231924.5 | 2.9 | 5805.5 | 15.4 | 4531.6 | 78.1 | 6112.6 | 16.1 | 74.1 | 20530.8 | 334841 | 16.3 | 33966 | 4865 | 14.3 | 5980 | 15 | 4730 | 79.1 | |||||
| 2020 | Reporting year | Regional | E92000001 | England | E12000001 | North East | 2028.2 | 248.7 | 12.3 | 15253.3 | 3 | 230.5 | 10.2 | 117 | 50.7 | 165.6 | 7.5 | 70.6 | 1348 | 24283 | 18 | 2152 | 287 | 13.3 | 237 | 9.9 | 120 | 50.6 | |||
| 2020 | Reporting year | Regional | E92000001 | England | E12000002 | North West | 4514.6 | 607.6 | 13.5 | 42064.6 | 3.7 | 707 | 13.5 | 546.9 | 77.4 | 799.6 | 15 | 68.4 | 2733.9 | 48928 | 17.9 | 4791 | 674 | 14.1 | 716 | 13 | 556 | 77.7 | |||
| 2020 | Reporting year | Regional | E92000001 | England | E12000003 | Yorkshire and the Humber | 3702.8 | 471.4 | 12.7 | 35796.1 | 3.8 | 461.4 | 11.1 | 320 | 69.3 | 543.4 | 12.8 | 58.9 | 2247.9 | 38077 | 16.9 | 4024 | 527 | 13.1 | 474 | 10.5 | 341 | 71.9 | |||
| 2020 | Reporting year | Regional | E92000001 | England | E12000004 | East Midlands | 2390.1 | 283.9 | 11.9 | 15984.4 | 2.6 | 393 | 14.1 | 299.7 | 76.3 | 340.9 | 12.5 | 87.9 | 1551.2 | 26265 | 16.9 | 2595 | 341 | 13.1 | 401 | 13.4 | 307 | 76.6 |
Variables in this data set
| Variable name | Variable description |
|---|---|
| absence_rate_fte_% | Absence rate throughout year (FTE) |
| agency_cover_fte | Number of agency workers at 30 Sept of which covering vacancies (FTE) |
| agency_cover_headcount | Number of agency workers at 30 Sept of which covering vacancies (Headcount) |
| agency_cover_rate_fte_% | Agency cover rate (FTE) |
| agency_cover_rate_headcount_% | Agency cover rate (Headcount) |
Footnotes
- The 2020 absence rate is calculated as the number of days missed due to sickness absence during the year divided by the number of FTE social workers at 30 September multiplied by 254 days (the number of working days in a leap year, taking account of bank holidays). The rate for non-leap years is based on 253 working days.
- The turnover rate is calculated as the number of FTE (or headcount) social workers leaving a social work role in the year divided by the number of FTE (or headcount) social workers in post at the 30 September.
- 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.
- 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).
- The FTE vacancy rate is calculated as the number of FTE vacancies at 30 September divided by the sum of the number of FTE vacancies at 30 September and the number of FTE social workers at 30 September.
- The agency worker rate is calculated as the number of FTE (or headcount) agency staff working as social workers at 30 September divided by the sum of the number of FTE (or headcount) agency staff working as social workers at 30 September and the number of FTE (or headcount) social workers.
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.