Data cleaning
The children in need census data is collected through the DfE COLLECT (collections online for learning, education, children and teachers) system.
When local authorities upload their data to COLLECT a series of validation rules are run to identify any errors or queries with the data. Local authorities then undertake cleaning of their data to resolve these issues; with the department providing help and support throughout this period. A local authority can also add notes to their data return to explain any outstanding issues. These notes are examined by the department during the quality assurance process and, where applicable, followed up and resolved with the individual local authority.
Once all errors and queries have been resolved or explained, local authorities submit a final return. A full list of validation rules for checking queries and errors is available in the children in need census guide to submitting data (opens in a new tab).
DfE then carry out further quality assurance of the data so that it can make an assessment of the data quality and highlight any issues to users.
Further validation checks are built into COLLECT to highlight where key measures (for example the number of referrals) have increased or decreased substantially between census years. Where changes exceed the threshold DfE requests local authorities to check their data and confirm that it is correct. It should be noted that a large change between years does not necessarily imply the information provided is inaccurate and may be explained, for example, by changes in local practice.
Time series data
A time series of data is provided for 2013 onwards in this statistics publication and is the earliest year for which the revised method for calculating episodes of need (introduced in 2018) is available. More information on the methodology introduced from 2018 onwards is provided in section ‘2.2 Children in need population figures time series changes’ (page 6) of the Characteristics of children in need data quality document: 2018 (opens in a new tab).
Missing and incomplete data in the earlier collection years means that it is not possible to reliably calculate episodes of need using the revised method. Data for earlier years is published on GOV.UK (opens in a new tab).
Issues relating to specific local authorities
Hampshire, 2024
Hampshire local authority moved to a new case management and reporting system and their return in 2024 had significant data quality issues and was assessed to not be sufficiently reliable to use. Therefore, their data for 2024 is presented in all of the underlying data files as ‘u’ to indicate low reliability and 2023 figures for Hampshire are included in the 2024 totals for the South East region and England.
Halton, 2024
Halton local authority provided incorrect data for the latest category of abuse data item (which relates to child protection plans) in 2024. Their data for 2024 for latest category of abuse is presented in the underlying data files D2 and D4 as ‘u’ to indicate low reliability and has been omitted from the totals for the North West region and England.
Herefordshire, 2024
Herefordshire local authority considerably underreported their data on factors identified at the end of assessment and referrals in 2024.
Their data for 2024 for these items is presented in the underlying data files C1, C3, C5, and C6 as ‘u’ to indicate low reliability but are included in the totals for the West Midlands region and England (this also applies to the overall national referrals figure in A1 and the headline figures underlying data files).
In addition, their figures in the file C2, completed assessments by duration of assessment, should be treated with caution due to an undercount in the figures reported.
Cumberland, and Westmorland and Furness, 2024
As per underlying data file C1, re-referrals for Cumberland, and Westmorland and Furness in 2024 should be treated with caution due to being an undercount of the true number due to Cumbria being reorganised into Cumberland, and Westmorland and Furness on 1 April 2023.
North Northamptonshire and West Northamptonshire, 2024, 2023, 2022
As per underlying data file B6, the reason for closure codes RC1 to RC7 should be used by local authorities to categorise a case for a child who they assess as in need following a referral and for whom they provide services and whose case is subsequently closed, with the child no longer being deemed to be in need of children’s social care services. West Northamptonshire and North Northamptonshire reported that they had inadvertently used RC7 in all such instances for the 2024, 2023, and 2022 collections but are planning to improve recording for future collections going forward to capture codes ranging from RC1 to RC7.
Herefordshire, 2023
It was determined at the end of the 2024 collection that the re-referrals data initially reported for 2023 in the 2023 release was unreliable, so data on re-referrals for Herefordshire for 2023 was replaced with ‘u’ to indicate low reliability in the C1 underlying data file for the 2024 statistics.
It was also determined at the end of the 2024 collection that the 2023 episodes of need figure at 31 March (file B1) was an undercount of the true number so should be treated with caution.
Lambeth, 2023
It was determined at the end of the 2024 collection that the 2023 episodes of need figure at 31 March (file B1) was an overcount of the true picture so should be treated with caution.
West Sussex, 2022
The data on child in need plans at any point in the year for West Sussex for 2022 in underlying data file B7 needs to be treated with caution due to being an overcount of the true picture.
Central Bedfordshire, 2022
In February 2024, Central Bedfordshire local authority informed DfE that the data they had submitted on section 47 enquiries for the 2022 collection was incorrect and an undercount of the true number. Caution should therefore be taken when interpreting this figure. The affects underlying data file C4.
North Northamptonshire and West Northamptonshire, 2022
As per underlying data file C1, re-referrals for North Northamptonshire and West Northamptonshire need to be treated with caution due to being an undercount of the true number due to Northamptonshire being reorganised into North Northamptonshire and West Northamptonshire on 1 April 2021.
Hackney, 2022, 2021
Hackney had a cyberattack in December 2020, which had a significant impact on their information management systems. As a result, 2020 figures for Hackney have been included in the 2021 and 2022 national and regional totals, but data in the underlying data files for Hackey has been presented as ‘x’ to indicate not available.
Dorset and Bournemouth, Christchurch and Poole, 2020
As per underlying data file C1, re-referrals for the year ending 31 March 2020 exclude Dorset and exclude Bournemouth, Christchurch and Poole local authorities due to the reorganisation of these areas on 1 April 2019.
Shropshire, 2019
Shropshire local authority were unable to provide reliable primary need at assessment data for 2019. Their data for 2019 is presented in the underlying data file B3 as ‘x’ to indicate not available and has been excluded from the totals for the West Midlands region and England (also excluded from the national figure for 2019 in the A3 underlying data file).
Data flows
The overall number of children in need and children who were the subject of a child protection plan at 31 March does not equal:
- the number at 31 March in the previous year, plus
- the number started in the year, minus
- those ceased in the year
Possible reasons are:
- better data quality over time as local authority systems further improve on returning the census data. For example, where a local authority finds children that had been incorrectly omitted in a previous return, but includes them in the latest census.
- the census is a snapshot taken each year and local authorities do not have the facility to amend previous year’s data returns. Therefore, it reflects the position at that point in time and any retrospective changes cannot be included in the following year’s data return as they fall outside the collection period.
Referrals resulting in no further action and children assessed not to be in need
There is considerable variation between local authorities in the number of referrals which resulted in no further action without an assessment taking place. Some local authorities record no referrals resulting in no further action, whereas some record more than 1,000. This is likely to be explained by differences in local procedures.
Similarly, there is considerable variation between local authorities in the number of referrals which resulted in an assessment where the child was assessed as not in need and no further action was taken. Again, this is likely to be explained by differences in local practice.
Factors identified at the end of assessment
Factors identified at the end of assessment were collected and reported for the first time in 2014; however, data was only published at national level due to concerns about its quality. Since 2015 data has been published at local authority level, with coverage continuing to improve.
It should be noted that not all episodes have factors recorded, but this has improved over time. Nonetheless, there can be differences in the recording practices between local authorities therefore this data should be treated with caution and shouldn’t be taken to represent the national, regional or local authority level prevalence of particular issues.
In addition, local authorities have been encouraged to report all relevant factors identified at the end of assessment, which may account for some of the increases seen in recent years and means the majority of children have more than one factor recorded for each episode of need. This should be taken into consideration when assessing time series assessment factor data.
Physical and sexual abuse factors (codes 18B, 18C, 19B and 19C)
Information on child on child and adult on child physical and sexual abuse was collected and reported for the first time in 2021. Previously the only information collected was whether the abuse was physical or sexual.
Since 2021, some local authorities have provided information on the old basis only, or a mixture of the old and new basis, but the number of local authorities doing this has reduced each year.
The old physical and sexual abuse codes (18A and 19A) have therefore been included in 2021 to 2024 data to provide a more complete account of this category of assessment.
Child in need (CIN) plans
Official statistics in development are official statistics that are undergoing development (previously called experimental statistics). Data on child in need (CIN) plans were collected and reported on for the third year in these 2024 statistics and evaluation is ongoing.
In 2024, 150 out of 153 local authorities provided usable data, an increase of three from 2023. Of those that did, it is likely that recording practices varied across local authorities therefore the data should be treated with caution.