In 2019 all 151 local authorities provided an ASC-WDS return, however the coverage for each individual data item varied. The number of local authorities contributing to the analysis of each data item is specified under each table or chart throughout the publication and is summarised in Table 1 below.
The figures in Table 1 show the number of local authorities contributing to the analysis of each metric. A local authority is only excluded from a metric when all of the related records supplied by the local authority cannot be included. For the majority of measures, the number of local authorities submitting data that can be used within analysis has increased since 2012.
Table 1: Number of local authorities included in each metric, 2019
Metric
|
2012
|
2013
|
2014
|
2015
|
2016
|
2017
|
2018
|
2019
|
Total Jobs
|
152
|
152
|
152
|
152
|
152
|
152
|
152
|
151
|
Headcount1
|
98
|
122
|
105
|
99
|
103
|
100
|
102
|
97
|
Whole Time Equivalent
|
152
|
152
|
152
|
152
|
152
|
152
|
152
|
151
|
Total Starters and Leavers2
|
-
|
-
|
151
|
152
|
152
|
152
|
152
|
151
|
Starters3
|
128
|
141
|
147
|
151
|
151
|
152
|
152
|
151
|
Leavers3
|
128
|
141
|
147
|
150
|
152
|
151
|
151
|
151
|
Vacancies
|
97
|
122
|
121
|
133
|
145
|
149
|
151
|
150
|
Employment Status
|
152
|
152
|
152
|
152
|
152
|
152
|
152
|
151
|
Capacity and Utilisation4
|
124
|
131
|
129
|
126
|
122
|
135
|
136
|
136
|
Gender
|
152
|
152
|
152
|
152
|
152
|
152
|
152
|
151
|
Age
|
152
|
152
|
152
|
152
|
152
|
152
|
152
|
151
|
Ethnicity
|
152
|
152
|
152
|
152
|
152
|
152
|
152
|
151
|
Whole Time Equivalent Pay
|
152
|
152
|
152
|
152
|
152
|
152
|
152
|
151
|
Sickness Days5
|
149
|
141
|
146
|
146
|
147
|
149
|
151
|
149
|
Qualifications6
|
-
|
-
|
142
|
152
|
152
|
-
|
-
|
-
|
Social Care Qualification6
|
-
|
-
|
-
|
-
|
-
|
152
|
152
|
151
|
Zero hours contract
|
-
|
-
|
-
|
-
|
-
|
-
|
150
|
150
|
1These fields were not specified as mandatory
2Only collected via the confirmation form from 2014 onwards
3Starters and leavers by job role were separated in 2015 to allow local authorities to be included if they had completed only one of the two data items
4In 2017, local authorities submitting capacity and utilisation data for any service have been included. Previously, only local authorities submitting capacity and utilisation data for one of the four services reported on were included.
5Sickness days methodology changed in 2018 and is now based on directly employed (permanent or temporary) workers. Figures for previous years have been updated.
6In 2017, the fields used to collect a worker's qualification data changed. Therefore 2017 onwards may not be directly comparable with previous years
Source: Skills for Care - ASC-WDS, Confirmation form, establishment / team and worker sections, 2019
Whilst Table 1 above showed the number of local authorities included in each metric, Table 2 below shows the proportion of workers.
Table 2: Percentage of workers included in each metric, 2019
Metric
|
2012
|
2013
|
2014
|
2015
|
2016
|
2017
|
2018
|
2019
|
Total Jobs
|
99%
|
100%
|
100%
|
100%
|
100%
|
100%
|
100%
|
100%
|
Headcount1
|
81%
|
84%
|
82%
|
82%
|
80%
|
80%
|
81%
|
82%
|
Whole Time Equivalent
|
90%
|
92%
|
93%
|
94%
|
95%
|
94%
|
94%
|
98%
|
Total Starters and Leavers2
|
-
|
-
|
100%
|
100%
|
100%
|
100%
|
100%
|
100%
|
Starters3
|
90%
|
95%
|
98%
|
100%
|
100%
|
100%
|
100%
|
100%
|
Leavers3
|
90%
|
95%
|
98%
|
99%
|
100%
|
100%
|
100%
|
100%
|
Vacancies4
|
56%
|
72%
|
77%
|
85%
|
93%
|
95%
|
99%
|
99%
|
Employment Status
|
99%
|
100%
|
100%
|
100%
|
100%
|
100%
|
100%
|
100%
|
Gender
|
99%
|
99%
|
99%
|
98%
|
98%
|
98%
|
98%
|
98%
|
Age
|
99%
|
99%
|
98%
|
98%
|
98%
|
98%
|
98%
|
98%
|
Ethnicity
|
92%
|
92%
|
90%
|
89%
|
89%
|
88%
|
85%
|
84%
|
Whole Time Equivalent Pay4
|
90%
|
92%
|
93%
|
94%
|
95%
|
94%
|
94%
|
98%
|
Sickness Days5
|
-
|
-
|
-
|
-
|
-
|
-
|
98%
|
99%
|
Qualifications6
|
-
|
-
|
86%
|
84%
|
88%
|
-
|
-
|
-
|
Social Care Qualification6
|
-
|
-
|
-
|
-
|
-
|
82%
|
84%
|
79%
|
1These fields were not specified as mandatory
2Only collected via the confirmation form from 2014 onwards
3Starters and leavers by job role were separated in 2015 to allow local authorities to be included if they had completed only one of the two data items
4The 2016 NMDS-SC publication understated the 2016 vacancy figure and overstated the whole time equivalent pay figures for this table. It has been corrected in this publication.
5Sickness days methodology changed in 2018 and is now based on directly employed (permanent or temporary) workers.
6In 2017, the fields used to collect a worker's qualification data changed. Therefore 2017 may not be directly comparable with previous years
Source: Skills for Care - ASC-WDS, Confirmation form, establishment / team and worker sections, 2019
The percentage of workers included in each metric has remained similar to 2019. There has therefore been little need for estimations within this reporting period, apart from the headcount calculations (this is discussed in detail later in this section).
For a more detailed summary of the individual completion rate of each local authority based on records submitted, please see Table 3 of the Data Quality tables accompanying this publication.