Table Tool

Create your own tables

Choose the data and area of interest you want to explore and then use filters to create your table.
Once you've created your table, you can download the data it contains for your own offline analysis.

1. Step 1

   • Publication: Children looked after in England including adoptions

2. Step 2

   • Data set: National - Conviction and health outcomes for children looked after continuously for 12 months

3. Step 3

   • National:
     • England

4. Step 4

   • Time period: 2018 to 2020

5. Step 5

   • Indicators:
     • Number
     • Percentage
   • Characteristic by age groups:
     • 10 to 12 years
     • 13 to 15 years
     • 16 to 17 years
     • 18 years and over
     • 9 years and under
   • Gender:
     • Total
     • Female
     • Male

6. Step 6 Explore data

   This data is not from the latest release

   View latest data: Reporting year 2023

   'National - Conviction and health outcomes for children looked after continuously for 12 months' for 10 to 12 years, 10 to 12 years, 10 to 12 years, 10 to 12 years, 13 to 15 years and 21 other filters in England between 2018 and 2020

   			Number			Percentage
   			2018	2019	2020	2018	2019	2020
   Total	2a. Substance misuse: Children looked after age groups	Total all ages	52,110	54,540	56,780	100%	100%	100%
   		9 years and under	15,370	16,440	17,140	28%	29%	29%
   		10 to 12 years	10,300	10,800	10,960	19%	19%	19%
   		13 to 15 years	13,450	14,040	14,700	26%	26%	26%
   		16 to 17 years	12,990	13,250	13,970	26%	26%	26%
   		18 years and over	c	10	10	c	~	~
   	2a.1 Identified as having a substance misuse problem	Total all ages	1,940	2,010	1,920	4%	4%	3%
   		9 years and under	10	10	10	~	~	~
   		10 to 12 years	50	20	20	1%	~	~
   		13 to 15 years	560	570	520	4%	4%	4%
   		16 to 17 years	1,320	1,410	1,380	10%	11%	10%
   		18 years and over	0	0	0	0%	0%	0%
   	2a.1i Received an intervention for their substance misuse problem	Total all ages	900	920	870	46%	46%	45%
   		9 years and under	c	c	c	c	c	c
   		10 to 12 years	c	10	10	c	30%	40%
   		13 to 15 years	260	290	240	46%	50%	47%
   		16 to 17 years	630	620	610	48%	44%	44%
   		18 years and over	0	0	0	z	z	z
   	2a.1ii Offered intervention but refused it	Total all ages	690	830	700	36%	41%	36%
   		9 years and under	0	c	c	0%	c	c
   		10 to 12 years	10	10	c	17%	48%	c
   		13 to 15 years	190	200	160	34%	36%	31%
   		16 to 17 years	490	610	540	37%	43%	39%
   		18 years and over	0	0	0	z	z	z
   Male	2a. Substance misuse: Children looked after age groups	Total all ages	29,230	30,490	31,680	100%	100%	100%
   		9 years and under	8,380	8,820	9,220	28%	28%	28%
   		10 to 12 years	5,780	6,130	6,180	19%	19%	19%
   		13 to 15 years	7,600	7,860	8,100	26%	26%	26%
   		16 to 17 years	7,470	7,680	8,180	27%	27%	27%
   		18 years and over	c	c	10	c	c	~
   	2a.1 Identified as having a substance misuse problem	Total all ages	1,180	1,260	1,210	4%	4%	4%
   		9 years and under	10	10	c	~	~	c
   		10 to 12 years	30	20	10	~	~	~
   		13 to 15 years	340	350	330	4%	4%	4%
   		16 to 17 years	810	890	860	11%	12%	11%
   		18 years and over	0	0	0	0%	0%	0%
   	2a.1i Received an intervention for their substance misuse problem	Total all ages	570	580	550	48%	46%	45%
   		9 years and under	c	c	c	c	c	c
   		10 to 12 years	c	c	c	c	c	c
   		13 to 15 years	170	170	160	49%	50%	49%
   		16 to 17 years	400	400	380	49%	45%	44%
   		18 years and over	0	0	0	z	z	z
   	2a.1ii Offered intervention but refused it	Total all ages	410	530	450	35%	42%	37%
   		9 years and under	0	c	c	0%	c	c
   		10 to 12 years	c	10	0	c	53%	0%
   		13 to 15 years	110	130	100	31%	37%	30%
   		16 to 17 years	300	390	350	37%	44%	40%
   		18 years and over	0	0	0	z	z	z
   Female	2a. Substance misuse: Children looked after age groups	Total all ages	22,890	24,050	25,090	100%	100%	100%
   		9 years and under	6,990	7,620	7,930	30%	31%	31%
   		10 to 12 years	4,520	4,670	4,780	19%	19%	19%
   		13 to 15 years	5,850	6,180	6,590	26%	26%	26%
   		16 to 17 years	5,520	5,570	5,790	25%	25%	24%
   		18 years and over	0	c	c	0%	c	c
   	2a.1 Identified as having a substance misuse problem	Total all ages	760	750	710	3%	3%	3%
   		9 years and under	c	c	c	c	c	c
   		10 to 12 years	30	c	10	1%	c	~
   		13 to 15 years	220	220	190	4%	4%	3%
   		16 to 17 years	510	520	510	9%	9%	9%
   		18 years and over	0	0	0	z	0%	0%
   	2a.1i Received an intervention for their substance misuse problem	Total all ages	330	340	320	43%	45%	44%
   		9 years and under	c	c	c	c	c	c
   		10 to 12 years	c	c	c	c	c	c
   		13 to 15 years	90	110	80	41%	50%	43%
   		16 to 17 years	230	220	230	46%	43%	45%
   		18 years and over	0	0	0	z	z	z
   	2a.1ii Offered intervention but refused it	Total all ages	290	300	250	38%	39%	35%
   		9 years and under	0	0	0	0%	0%	0%
   		10 to 12 years	10	c	c	21%	c	c
   		13 to 15 years	80	80	60	38%	34%	32%
   		16 to 17 years	200	220	190	38%	42%	37%
   		18 years and over	0	0	0	z	z	z

   Save table

   Related information

   • Release type:
   • Publication: Children looked after in England including adoptions, Reporting year 2023

   Our statistical practice is regulated by the Office for Statistics Regulation (OSR)