Data set from Children in need

B6 Episodes of need ending by reason for closure and local authority

Not the latest data

Published 27 October 2022

Last updated 27 October 2022

Episodes of need ending during the year by reason for case closure.

---

On this page

Data set details

• Theme: Children's social care
• Publication: Children in need
• Release: Reporting year 2022
• Geographic levels: Local authority, National, Regional
• Indicators:
  • Number of episodes of need ending in the year
  • RC1 - Adopted - Number
  • RC1 - Adopted - Percentage
• Time period: 2013 to 2022

---

Data set preview

Table showing first 5 rows, from underlying data

time_period	time_identifier	geographic_level	country_code	country_name	region_code	region_name	old_la_code	new_la_code	la_name	category	Ended_episodes	unknown	unknown_percent	RC1_Adopted	RC1_Adopted_percent	RC2_Died	RC2_Died_percent	RC3_Residence_Order	RC3_Residence_Order_percent	RC4_Special_Guardianship_Order	RC4_Special_Guardianship_Order_percent	RC5_Transfer_to_another_LA	RC5_Transfer_to_another_LA_percent	RC6_Transfer_to_Adult_Social_Service	RC6_Transfer_to_Adult_Social_Service_percent	RC7_Other	RC7_Other_percent
2022	Reporting year	National	E92000001	England						Reason for episode closure	359830	3450	1	2800	0.8	880	0.2	800	0.2	2960	0.8	12590	3.5	2570	0.7	333790	92.8
2022	Reporting year	Regional	E92000001	England	E12000001	North East				Reason for episode closure	21710	90	0.4	290	1.3	50	0.2	110	0.5	520	2.4	570	2.6	170	0.8	19900	91.7
2022	Reporting year	Regional	E92000001	England	E12000002	North West				Reason for episode closure	51110	210	0.4	500	1	150	0.3	50	0.1	510	1	1430	2.8	390	0.8	47870	93.7
2022	Reporting year	Regional	E92000001	England	E12000003	Yorkshire and The Humber				Reason for episode closure	38580	320	0.8	340	0.9	90	0.2	90	0.2	380	1	930	2.4	220	0.6	36220	93.9
2022	Reporting year	Regional	E92000001	England	E12000004	East Midlands				Reason for episode closure	26060	350	1.3	140	0.5	70	0.3	30	0.1	150	0.6	410	1.6	100	0.4	24820	95.2

---

Variables in this data set

Table showing first 5 of 17 variables

Variable name	Variable description
Ended_episodes	Number of episodes of need ending in the year
RC1_Adopted	RC1 - Adopted - Number
RC1_Adopted_percent	RC1 - Adopted - Percentage
RC2_Died	RC2 - Died - Number
RC2_Died_percent	RC2 - Died -Percentage

---

Footnotes

1. Unknown includes episodes ending during the year where reason for closure was not known and episodes closed after an assessment where no further action was taken.
2. Data for the years ending 31 March 2021 and 2022 is not available for Hackney local authority, therefore 2020 data for Hackney has been included in 2021 and 2022 national totals, and regional totals for inner London and London. Refer to the methodology section for more information.

---

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

---