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: LA - Children looked after numbers and rates per 10,000 children aged under 18 years

3. Step 3

   • Local authority:
     • Barking and Dagenham
     • Barnet
     • Barnsley
     • Bath and North East Somerset
     • Bedford Borough
   • National:
     • England
   • Regional:
     • East Midlands
     • East of England
     • Inner London
     • London
     • North East

4. Step 4

   • Time period: 2018 to 2020

5. Step 5

   • Indicators:
     • Number of children looked after
     • Rate per 10 000 children aged under 18 years
   • CLA population count:
     • Children ceasing to be looked after each year
     • Children looked after at 31 March each year
     • Children starting to be looked after each year

6. Step 6 Explore data

   This data is not from the latest release

   View latest data: Reporting year 2023

   'LA - Children looked after numbers and rates per 10,000 children aged under 18 years' for Children ceasing to be looked after each year, Children looked after at 31 March each year and Children starting to be looked after each year in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford Borough and 161 other locations between 2018 and 2020

   		Children looked after at 31 March each year						Children starting to be looked after each year						Children ceasing to be looked after each year
   		Number of children looked after			Rate per 10 000 children aged under 18 years			Number of children looked after			Rate per 10 000 children aged under 18 years			Number of children looked after			Rate per 10 000 children aged under 18 years
   		2018	2019	2020	2018	2019	2020	2018	2019	2020	2018	2019	2020	2018	2019	2020	2018	2019	2020
   England		75,370	78,140	80,080	64	65	67	32,190	31,770	30,970	27	27	26	30,050	29,570	29,590	25	25	25
   North East		5,040	5,340	5,730	96	101	108	2,280	2,410	2,420	43	45	46	2,110	2,130	2,080	40	40	39
   North West		14,050	14,660	15,130	91	94	97	5,390	5,150	4,980	35	33	32	4,650	4,630	4,590	30	30	29
   Yorkshire and the Humber		8,190	8,570	8,970	71	74	77	3,170	3,170	3,330	27	27	28	2,780	2,840	2,990	24	24	26
   East Midlands		5,620	5,840	6,110	57	59	61	2,390	2,360	2,380	24	24	24	2,160	2,180	2,140	22	22	21
   West Midlands		10,060	10,560	10,700	78	82	82	3,640	3,450	3,150	28	27	24	3,130	3,000	3,060	24	23	24
   East of England		6,530	6,740	6,710	49	50	50	2,940	2,930	2,600	22	22	19	2,910	2,770	2,690	22	21	20
   London		9,880	10,020	10,010	49	50	49	5,360	5,480	5,160	27	27	25	5,510	5,450	5,290	28	27	26
   Inner London		4,260	4,210	4,280	58	56	57	2,320	2,340	2,180	31	31	29	2,340	2,420	2,180	32	32	29
   Outer London		5,620	5,800	5,740	44	46	45	3,030	3,140	2,980	24	25	23	3,170	3,030	3,110	25	24	24
   South East		10,000	10,270	10,450	51	52	53	4,370	4,360	4,380	22	22	22	4,310	4,160	4,260	22	21	22
   South West		6,010	6,140	6,280	55	56	57	2,660	2,470	2,570	24	22	23	2,500	2,410	2,490	23	22	22
   Outer London	Barking and Dagenham	409	414	402	65	65	63	194	201	180	31	32	28	199	200	198	32	32	31
   	Barnet	329	312	325	36	34	35	173	159	188	19	17	20	190	177	179	21	19	19
   Yorkshire and the Humber (E12000003)	Barnsley	310	301	300	62	59	59	129	106	127	26	21	25	110	119	128	22	23	25
   South West (E12000009)	Bath and North East Somerset	169	192	181	48	53	50	70	90	73	20	25	20	61	69	85	17	19	23
   East of England	Bedford Borough	239	232	253	61	58	62	102	95	108	26	24	27	131	102	89	33	25	22
   Outer London	Bexley	240	227	222	42	40	39	127	96	122	22	17	21	125	115	135	22	20	24
   West Midlands	Birmingham	1,921	1,944	1,928	67	67	67	753	664	629	26	23	22	689	661	668	24	23	23
   North West	Blackburn with Darwen	375	400	411	97	104	106	162	172	151	42	45	39	157	146	142	41	38	37
   	Blackpool	533	568	652	185	197	223	210	196	241	73	68	82	206	165	162	72	57	55
   	Bolton	615	644	632	91	95	92	201	200	197	30	30	29	168	179	214	25	26	31
   South West (E12000009)	Bournemouth (up to 2019)	246	253	z	68	70	z	93	99	z	26	27	z	89	95	z	25	26	z
   	Bournemouth, Christchurch and Poole (2020 onwards)	z	z	526	z	z	70	z	z	220	z	z	29	z	z	140	z	z	19
   South East	Bracknell Forest	138	158	142	49	56	50	84	84	47	30	30	17	67	65	62	24	23	22
   Yorkshire and the Humber (E12000003)	Bradford	986	1,159	1,245	70	82	87	338	492	508	24	35	36	298	328	425	21	23	30
   Outer London	Brent	317	300	299	41	39	38	166	164	170	21	21	22	176	184	172	23	24	22
   South East	Brighton and Hove	419	392	370	82	77	74	140	157	154	27	31	31	176	186	178	35	36	35
   SOUTH WEST (E12000009)	Bristol, City of	639	617	623	68	66	66	239	211	210	25	22	22	286	233	210	30	25	22
   Outer London	Bromley	310	348	331	42	46	44	161	182	123	22	24	16	148	147	148	20	20	20
   South East	Buckinghamshire	472	514	484	38	41	38	193	209	203	16	17	16	180	171	235	15	14	19
   North West	Bury	333	335	342	77	78	79	125	123	91	29	29	21	147	125	87	34	29	20
   Yorkshire and the Humber (E12000003)	Calderdale	297	334	330	64	73	72	75	112	99	16	24	21	96	79	107	21	17	23
   East of England	Cambridgeshire	700	773	714	52	57	52	327	332	233	24	24	17	318	262	297	24	19	22
   Inner London	Camden	201	189	190	41	37	36	106	89	102	22	17	19	104	102	102	21	20	19
   East of England	Central Bedfordshire	312	320	314	51	51	49	127	113	93	21	18	15	123	103	100	20	16	16
   North West	Cheshire East	477	485	534	63	63	69	195	155	179	26	20	23	146	147	132	19	19	17
   	Cheshire West and Chester	488	477	488	73	70	71	204	121	124	30	18	18	199	133	120	30	20	17
   Inner London	City of London	10	20	24	80	138	148	14	28	25	112	193	154	16	18	21	128	124	130
   South West (E12000009)	Cornwall	465	454	473	43	42	44	276	223	230	26	21	21	230	242	220	21	22	20
   West Midlands	Coventry	653	705	701	84	89	88	256	300	263	33	38	33	227	255	266	29	32	33
   Outer London	Croydon	771	819	791	81	86	83	426	515	357	45	54	38	454	475	388	48	50	41
   North West	Cumbria	666	683	721	72	74	78	250	219	211	27	24	23	224	208	175	24	22	19
   North East	Darlington	214	264	270	95	118	120	76	134	109	34	60	48	82	86	102	36	38	45
   East Midlands	Derby	491	562	588	82	94	98	268	277	216	45	46	36	225	212	191	38	35	32
   	Derbyshire	709	801	861	46	52	56	338	369	393	22	24	25	265	283	336	17	18	22
   South West (E12000009)	Devon	698	750	749	48	51	51	310	299	321	21	20	22	306	259	334	21	18	23
   Yorkshire and the Humber (E12000003)	Doncaster	569	532	504	86	80	75	246	206	184	37	31	27	195	245	215	30	37	32
   South West (E12000009)	Dorset (2020 onwards)	z	z	474	z	z	70	z	z	199	z	z	29	z	z	139	z	z	20
   	Dorset (up to 2019)	449	412	z	58	54	z	170	157	z	22	20	z	202	199	z	26	26	z
   West Midlands	Dudley	662	659	623	96	95	90	171	169	123	25	24	18	189	174	162	27	25	23
   North East	Durham	803	845	914	80	84	90	357	388	413	36	38	41	374	348	352	37	34	35
   Outer London	Ealing	341	351	332	42	43	40	180	209	187	22	26	23	189	196	209	23	24	25
   Yorkshire and the Humber (E12000003)	East Riding of Yorkshire	312	334	340	50	53	54	109	124	119	17	20	19	92	105	115	15	17	18
   South East	East Sussex	602	590	592	57	55	56	203	193	174	19	18	16	162	203	176	15	19	17
   Outer London	Enfield	330	374	374	39	44	44	174	217	230	21	26	27	172	179	233	20	21	28
   East of England	Essex	1,016	1,059	1,071	33	34	34	456	491	444	15	16	14	460	466	444	15	15	14
   North East	Gateshead	395	379	414	99	96	105	176	166	159	44	42	40	168	185	126	42	47	32
   South West (E12000009)	Gloucestershire	656	716	731	52	56	57	281	313	352	22	24	27	243	275	346	19	21	27
   Outer London	Greenwich	497	479	462	73	70	67	237	182	169	35	26	24	239	206	190	35	30	28
   Inner London	Hackney	382	405	432	61	64	68	216	212	229	34	33	36	205	195	208	33	31	33
   North West	Halton	262	265	278	92	93	97	76	61	94	27	21	33	82	58	84	29	20	29
   Inner London	Hammersmith and Fulham	226	245	252	63	66	68	119	171	151	33	46	41	118	153	148	33	41	40
   South East	Hampshire	1,594	1,664	1,602	56	59	56	629	652	549	22	23	19	486	593	624	17	21	22
   Inner London	Haringey	433	428	403	71	71	67	203	220	179	33	36	30	214	226	208	35	37	35
   Outer London	Harrow	160	170	185	28	29	31	107	125	138	19	21	23	159	118	130	27	20	22
   North East	Hartlepool	278	285	316	139	142	158	101	111	144	50	55	72	80	106	116	40	53	58
   Outer London	Havering	251	247	232	44	43	40	129	122	123	23	21	21	127	131	138	22	23	24
   West Midlands	Herefordshire	313	332	351	87	92	97	111	95	94	31	26	26	99	78	77	28	22	21
   East of England	Hertfordshire	891	929	948	33	34	35	396	412	360	15	15	13	417	376	358	15	14	13
   Outer London	Hillingdon	290	325	337	40	44	45	214	222	209	29	30	28	236	193	200	32	26	27
   	Hounslow	248	277	269	39	43	41	140	144	143	22	22	22	147	123	155	23	19	24
   South East	Isle of Wight	226	244	264	90	98	107	76	75	72	30	30	29	82	61	53	33	25	21
   South West (E12000009)	Isles Of Scilly	0	0	c	0	0	c	0	0	c	0	0	c	0	0	0	0	0	0
   Inner London	Islington	335	313	366	81	74	86	184	153	186	44	36	44	193	179	136	47	43	32
   	Kensington and Chelsea	85	93	106	30	32	37	78	67	68	27	23	24	79	59	58	28	21	20
   South East	Kent	1,641	1,588	1,807	49	47	53	768	696	946	23	20	28	1,049	765	738	31	22	21
   YORKSHIRE AND THE HUMBER (E12000003)	Kingston Upon Hull, City of	757	793	867	134	139	151	290	269	330	51	47	58	229	235	260	41	41	45
   Outer London	Kingston upon Thames	134	130	125	35	33	32	76	58	67	20	15	17	61	63	74	16	16	19
   Yorkshire and the Humber (E12000003)	Kirklees	673	622	669	67	62	67	226	149	248	23	15	25	253	200	204	25	20	20
   North West	Knowsley	288	301	307	87	90	91	85	103	77	26	31	23	87	93	71	26	28	21
   Inner London	Lambeth	411	348	358	66	56	58	202	163	165	32	26	27	205	229	159	33	37	26
   North West	Lancashire	1,950	2,114	2,096	79	85	83	763	817	717	31	33	29	662	672	739	27	27	29
   Yorkshire and the Humber (E12000003)	Leeds	1,267	1,286	1,346	76	76	79	421	386	411	25	23	24	410	375	364	25	22	21
   East Midlands	Leicester	676	642	611	81	76	73	246	187	194	29	22	23	218	224	225	26	27	27
   	Leicestershire	554	582	654	40	41	46	218	207	239	16	15	17	179	185	172	13	13	12
   Inner London	Lewisham	481	484	472	70	71	69	240	230	211	35	34	31	221	232	227	32	34	33
   East Midlands	Lincolnshire	656	611	622	45	42	42	276	261	281	19	18	19	318	309	280	22	21	19
   North West	Liverpool	1,190	1,332	1,424	127	140	148	421	525	424	45	55	44	363	388	337	39	41	35
   East of England	Luton	379	406	387	66	71	67	200	185	136	35	32	24	193	170	159	34	30	28
   North West	Manchester	1,257	1,290	1,407	104	106	114	558	519	602	46	43	49	472	495	494	39	41	40
   South East	Medway	414	424	426	65	66	66	175	167	174	27	26	27	159	159	180	25	25	28
   Outer London	Merton	155	159	154	33	34	32	84	74	82	18	16	17	84	70	87	18	15	18
   North East	Middlesbrough	466	518	619	144	159	189	185	205	296	57	63	90	167	152	198	52	47	60
   South East	Milton Keynes	394	382	403	58	56	59	140	164	168	21	24	24	145	174	148	21	25	22
   North East	Newcastle upon Tyne	566	678	662	98	117	113	294	374	214	51	64	37	265	270	238	46	47	41
   Inner London	Newham	405	380	411	47	44	48	241	220	219	28	25	25	240	253	194	28	29	23
   East of England	Norfolk	1,182	1,186	1,106	70	69	64	484	454	341	28	27	20	429	459	434	25	27	25
   Yorkshire and the Humber (E12000003)	North East Lincolnshire	354	449	572	103	130	166	160	200	263	47	58	76	104	108	142	30	31	41
   	North Lincolnshire	226	251	231	63	70	65	89	129	51	25	36	14	95	105	72	27	29	20
   South West (E12000009)	North Somerset	236	242	230	55	56	53	101	86	84	23	20	19	92	79	98	21	18	22
   North East	North Tyneside	282	308	299	69	74	71	138	141	160	34	34	38	161	117	172	39	28	41
   Yorkshire and the Humber (E12000003)	North Yorkshire	437	430	443	37	37	38	193	146	144	16	12	12	186	156	136	16	13	12
   East Midlands	Northamptonshire	1,094	1,122	1,163	65	66	68	502	450	439	30	26	26	419	432	401	25	25	23
   North East	Northumberland	386	370	434	66	63	73	177	148	199	30	25	34	200	165	136	34	28	23
   East Midlands	Nottingham	616	628	656	91	91	95	212	227	242	31	33	35	219	219	220	32	32	32
   	Nottinghamshire	790	862	916	48	52	55	316	371	350	19	22	21	303	307	304	18	18	18
   North West	Oldham	551	512	520	93	86	87	267	198	179	45	33	30	207	239	172	35	40	29
   South East	Oxfordshire	684	779	767	48	54	52	303	355	309	21	25	21	298	273	322	21	19	22
   East of England	Peterborough	369	374	372	74	73	72	174	180	153	35	35	30	164	178	156	33	35	30
   South West (E12000009)	Plymouth	418	412	434	80	78	82	213	160	165	41	30	31	190	165	146	36	31	28
   	Poole (up to 2019)	190	192	z	63	64	z	77	88	z	26	29	z	83	89	z	27	29	z
   South East	Portsmouth	415	487	466	94	111	106	237	229	179	54	52	41	186	160	204	42	36	47
   	Reading	277	271	280	75	73	76	107	88	116	29	24	31	92	94	109	25	25	29
   Outer London	Redbridge	223	236	237	29	31	31	142	137	132	19	18	17	148	127	130	19	17	17
   North East	Redcar and Cleveland	283	297	348	103	108	126	123	120	152	45	43	55	76	112	104	28	41	38
   Outer London	Richmond upon Thames	104	114	122	23	25	27	61	73	72	14	16	16	65	64	67	14	14	15
   North West	Rochdale	497	568	535	95	108	100	196	205	116	38	39	22	160	134	150	31	25	28
   Yorkshire and the Humber (E12000003)	Rotherham	620	642	595	109	112	103	323	266	206	57	47	36	192	248	258	34	43	45
   East Midlands	Rutland	30	33	43	39	42	55	9	11	25	12	14	32	18	8	15	23	10	19
   North West	Salford	572	583	558	103	103	97	214	193	182	38	34	32	169	188	210	30	33	37
   West Midlands	Sandwell	751	897	865	93	109	105	350	334	184	43	41	22	210	194	217	26	24	26
   North West	Sefton	480	527	566	90	98	105	184	175	167	34	33	31	163	132	129	30	25	24
   Yorkshire and the Humber (E12000003)	Sheffield	628	631	626	54	54	53	289	266	267	25	23	23	257	265	276	22	23	23
   West Midlands	Shropshire	338	395	399	57	66	66	135	153	104	23	26	17	88	96	99	15	16	16
   South East	Slough	206	213	196	49	50	45	125	134	107	30	31	25	112	127	125	27	30	29
   West Midlands	Solihull	412	424	461	88	90	97	172	131	149	37	28	31	151	120	116	32	26	24
   South West (E12000009)	Somerset	516	532	529	47	48	48	258	194	191	23	18	17	223	185	197	20	17	18
   	South Gloucestershire	194	195	210	33	33	35	95	99	113	16	17	19	82	98	100	14	17	17
   North East	South Tyneside	320	306	294	108	102	97	131	120	92	44	40	30	88	135	106	30	45	35
   South East	Southampton	522	481	486	104	95	95	178	170	197	35	33	38	197	214	199	39	42	39
   East of England	Southend-on-Sea	289	306	314	74	77	79	121	115	115	31	29	29	115	99	108	29	25	27
   Inner London	Southwark	491	460	458	76	71	70	229	210	204	36	32	31	242	244	222	38	37	34
   North West	St. Helens	442	466	496	121	127	135	113	126	187	31	34	51	98	103	162	27	28	44
   West Midlands	Staffordshire	1,100	1,173	1,217	65	69	72	433	401	368	26	24	22	330	331	330	20	20	19
   North West	Stockport	362	361	368	58	57	58	194	159	169	31	25	27	167	162	163	27	26	26
   North East	Stockton-on-Tees	468	500	576	108	115	131	161	142	214	37	33	49	130	110	140	30	25	32
   West Midlands	Stoke-on-Trent	740	851	919	129	148	159	220	257	248	38	45	43	134	148	181	23	26	31
   East of England	Suffolk	855	866	936	56	57	61	363	351	380	24	23	25	338	345	316	22	23	21
   North East	Sunderland	581	594	582	107	109	106	359	358	270	66	66	49	322	348	286	59	64	52
   South East	Surrey	930	970	981	36	37	37	456	436	373	18	17	14	409	398	365	16	15	14
   Outer London	Sutton	215	237	233	45	49	48	96	121	119	20	25	25	111	98	122	23	20	25
   South West (E12000009)	Swindon	360	349	301	72	69	60	178	137	107	36	27	21	155	148	155	31	29	31
   North West	Tameside	617	664	704	124	132	139	244	249	261	49	50	52	147	210	229	30	42	45
   West Midlands	Telford and Wrekin	370	388	403	92	96	98	106	110	105	26	27	26	118	95	92	29	23	22
   East of England	Thurrock	299	290	297	70	66	67	187	201	234	44	46	52	220	210	233	51	48	52
   South West (E12000009)	Torbay	329	362	357	129	142	140	138	147	135	54	58	53	102	118	141	40	46	55
   Inner London	Tower Hamlets	286	329	307	42	46	42	137	208	146	20	29	20	186	168	169	27	24	23
   North West	Trafford	383	416	378	69	74	67	129	157	99	23	28	18	138	126	136	25	22	24
   Yorkshire and the Humber (E12000003)	Wakefield	558	602	639	78	83	87	223	253	262	31	35	35	187	213	230	26	29	31
   West Midlands	Walsall	636	614	671	95	90	97	208	153	237	31	22	34	220	177	184	33	26	27
   Outer London	Waltham Forest	296	285	304	44	43	46	147	142	168	22	21	25	135	159	155	20	24	23
   Inner London	Wandsworth	308	309	277	49	48	43	193	194	153	31	30	24	180	194	188	29	30	29
   North West	Warrington	401	385	364	90	87	82	141	114	113	32	26	25	123	132	139	28	30	31
   West Midlands	Warwickshire	717	722	754	63	62	64	264	303	298	23	26	25	247	301	273	22	26	23
   South East	West Berkshire	145	172	157	41	48	44	68	79	59	19	22	17	86	54	74	24	15	21
   	West Sussex	704	705	808	41	40	46	378	347	457	22	20	26	338	354	355	20	20	20
   Inner London	Westminster	204	209	219	45	44	45	161	175	145	36	37	30	141	172	136	31	36	28
   North West	Wigan	479	448	533	70	66	77	180	151	207	26	22	30	149	186	129	22	27	19
   South West (E12000009)	Wiltshire	444	459	458	42	43	43	156	163	170	15	15	16	154	151	176	15	14	17
   South East	Windsor and Maidenhead	107	124	116	31	36	33	46	65	52	13	19	15	49	52	62	14	15	18
   North West	Wirral	834	832	812	123	123	120	278	208	192	41	31	28	211	212	212	31	31	31
   South East	Wokingham	106	110	98	27	28	24	66	62	44	17	16	11	36	58	55	9	15	14
   West Midlands	Wolverhampton	649	625	588	108	102	94	179	132	123	30	22	20	170	158	163	28	26	26
   	Worcestershire	796	833	819	68	71	69	281	243	220	24	21	19	255	207	235	22	18	20
   Yorkshire and the Humber (E12000003)	York	195	207	262	53	57	72	62	69	111	17	19	30	71	58	58	19	16	16

   Footnotes

   1. Rates per 10,000 children are calculated using the most recent mid-year population estimates from the Office for National Statistics.
   2. National and regional numbers have been rounded to the nearest 10. Rates rounded to the nearest whole number. See the methodology document for further information. Figures exclude children looked after under a series of short-term placements. Historical data may differ from older publications which is mainly due to amendments made by local authorities after the previous publication.

   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)