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: CLA on 31 March by LA of placement net gain - LA

3. Step 3

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

4. Step 4

   • Time period: 2018 to 2021

5. Step 5

   • Indicators:
     • Number
   • Characteristic:
     • 1. Children who are the responsibility of other LAs placed within this LA boundary
     • 2. Children who are the responsibility of this LA placed outside the LA boundary
     • Net gain of children by responsible LA

6. Step 6 Explore data

   This data is not from the latest release

   View latest data: Reporting year 2023

   Number for 'CLA on 31 March by LA of placement net gain - LA' for 1. Children who are the responsibility of other LAs placed within this LA boundary, 2. Children who are the responsibility of this LA placed outside the LA boundary and Net gain of children by responsible LA in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford and 161 other locations between 2018 and 2021

   		1. Children who are the responsibility of other LAs placed within this LA boundary				2. Children who are the responsibility of this LA placed outside the LA boundary				Net gain of children by responsible LA
   		2018	2019	2020	2021	2018	2019	2020	2021	2018	2019	2020	2021
   England		29,850	31,380	32,110	33,000	30,890	32,360	33,160	34,060	-1,040	-980	-1,050	-1,060
   North East		1,850	2,030	2,120	2,130	1,980	2,080	2,240	2,280	-130	-50	-120	-150
   North West		5,130	5,420	5,580	5,720	5,270	5,600	5,670	5,760	-140	-170	-100	-40
   Yorkshire and The Humber		2,500	2,720	2,830	2,990	2,720	2,870	3,040	3,170	-220	-140	-220	-180
   East of England		2,340	2,380	2,520	2,640	2,340	2,470	2,480	2,510	-10	-90	50	130
   East Midlands		2,670	2,810	2,960	3,170	2,160	2,290	2,520	2,750	510	510	440	420
   West Midlands		4,220	4,460	4,600	4,930	4,190	4,490	4,600	4,930	30	-40	10	0
   London		4,820	5,120	5,110	4,900	6,360	6,430	6,480	6,230	-1,530	-1,310	-1,370	-1,330
   Inner London		1,270	1,300	1,310	1,230	3,080	3,060	3,180	2,980	-1,810	-1,770	-1,870	-1,750
   Outer London		3,550	3,830	3,800	3,670	3,270	3,360	3,300	3,250	280	460	500	420
   South East		4,330	4,360	4,400	4,460	3,790	3,950	3,990	4,230	540	410	410	230
   South West		1,990	2,070	1,990	2,080	2,090	2,180	2,140	2,230	-100	-110	-150	-150
   Outer London	Barking and Dagenham	155	155	166	149	256	251	246	239	-101	-96	-80	-90
   	Barnet	90	87	105	105	212	193	205	216	-122	-106	-100	-111
   Yorkshire and The Humber	Barnsley	175	185	191	232	99	94	80	85	76	91	111	147
   South West	Bath and North East Somerset	53	59	46	61	114	124	126	126	-61	-65	-80	-65
   East of England	Bedford	136	148	128	144	103	109	132	140	33	39	-4	4
   Outer London	Bexley	190	212	186	196	122	112	103	122	68	100	83	74
   West Midlands	Birmingham	645	682	673	772	711	775	768	765	-66	-93	-95	7
   North West	Blackburn with Darwen	113	136	127	131	162	175	181	176	-49	-39	-54	-45
   	Blackpool	119	141	138	131	252	248	318	302	-133	-107	-180	-171
   	Bolton	210	200	214	224	151	184	206	206	59	16	8	18
   South West	Bournemouth	97	94	z	z	123	111	z	z	-26	-17	z	z
   	Bournemouth, Christchurch and Poole	z	z	158	177	z	z	161	123	z	z	-3	54
   South East	Bracknell Forest	81	87	77	76	69	72	60	66	12	15	17	10
   Yorkshire and The Humber	Bradford	272	275	265	262	220	257	292	351	52	18	-27	-89
   Outer London	Brent	196	209	204	176	185	182	180	164	11	27	24	12
   South East	Brighton and Hove	56	67	70	78	252	233	209	228	-196	-166	-139	-150
   South West	Bristol, City of	111	111	99	117	273	260	271	292	-162	-149	-172	-175
   Outer London	Bromley	187	185	192	209	184	213	191	199	3	-28	1	10
   South East	Buckinghamshire	185	182	185	192	262	293	246	271	-77	-111	-61	-79
   North West	Bury	185	233	201	220	135	140	138	164	50	93	63	56
   Yorkshire and The Humber	Calderdale	134	150	182	180	118	121	121	128	16	29	61	52
   East of England	Cambridgeshire	232	232	256	273	344	425	392	350	-112	-193	-136	-77
   Inner London	Camden	56	58	57	46	118	100	98	104	-62	-42	-41	-58
   East of England	Central Bedfordshire	167	167	190	199	185	186	181	198	-18	-19	9	1
   North West	Cheshire East	142	137	175	183	208	213	234	216	-66	-76	-59	-33
   	Cheshire West and Chester	163	177	186	167	199	198	193	201	-36	-21	-7	-34
   Inner London	City of London	0	0	0	0	10	20	24	20	-10	-20	-24	-20
   South West	Cornwall	127	146	144	147	89	79	102	95	38	67	42	52
   North East	County Durham	444	489	495	496	207	214	231	257	237	275	264	239
   West Midlands	Coventry	141	164	192	180	308	308	299	311	-167	-144	-107	-131
   Outer London	Croydon	622	658	639	623	365	380	385	338	257	278	254	285
   North West	Cumbria	156	171	177	188	206	227	192	206	-50	-56	-15	-18
   North East	Darlington	136	144	157	155	91	112	128	136	45	32	29	19
   East Midlands	Derby	74	71	89	110	319	356	404	457	-245	-285	-315	-347
   	Derbyshire	452	489	491	534	250	312	374	399	202	177	117	135
   South West	Devon	315	320	327	307	173	181	169	222	142	139	158	85
   Yorkshire and The Humber	Doncaster	211	259	242	228	216	207	190	201	-5	52	52	27
   South West	Dorset (E06000059)	z	z	199	182	z	z	197	188	z	z	2	-6
   	Dorset (E10000009)	194	201	z	z	177	159	z	z	17	42	z	z
   West Midlands	Dudley	244	265	273	272	303	292	279	281	-59	-27	-6	-9
   Outer London	Ealing	167	160	155	149	205	227	208	202	-38	-67	-53	-53
   Yorkshire and The Humber	East Riding of Yorkshire	291	300	311	319	94	117	111	109	197	183	200	210
   South East	East Sussex	277	275	285	295	102	88	106	129	175	187	179	166
   Outer London	Enfield	227	248	257	237	144	157	153	172	83	91	104	65
   East of England	Essex	599	618	664	692	215	233	218	229	384	385	446	463
   North East	Gateshead	118	118	126	145	175	175	186	199	-57	-57	-60	-54
   South West	Gloucestershire	182	186	165	178	121	177	166	223	61	9	-1	-45
   Outer London	Greenwich	136	173	165	163	365	355	337	298	-229	-182	-172	-135
   Inner London	Hackney	99	94	99	85	292	301	324	319	-193	-207	-225	-234
   North West	Halton	130	143	141	131	114	118	100	111	16	25	41	20
   Inner London	Hammersmith and Fulham	25	28	35	36	165	173	204	189	-140	-145	-169	-153
   South East	Hampshire	642	626	644	677	508	580	590	635	134	46	54	42
   Inner London	Haringey	113	123	120	116	324	322	310	305	-211	-199	-190	-189
   Outer London	Harrow	120	125	124	131	90	90	102	112	30	35	22	19
   North East	Hartlepool	77	98	102	100	106	95	102	116	-29	3	0	-16
   Outer London	Havering	207	252	258	230	132	135	115	102	75	117	143	128
   West Midlands	Herefordshire, County of	84	90	99	115	76	82	105	99	8	8	-6	16
   East of England	Hertfordshire	261	238	243	261	304	329	347	386	-43	-91	-104	-125
   Outer London	Hillingdon	158	185	158	148	127	135	169	168	31	50	-11	-20
   	Hounslow	168	163	152	176	137	157	147	154	31	6	5	22
   South East	Isle of Wight	79	76	69	66	48	50	46	58	31	26	23	8
   South West	Isles of Scilly	1	0	1	0	0	0	0	0	1	0	1	0
   Inner London	Islington	60	66	74	70	227	218	255	234	-167	-152	-181	-164
   	Kensington and Chelsea	50	45	45	41	64	65	83	87	-14	-20	-38	-46
   South East	Kent	1,158	1,176	1,189	1,195	251	214	258	264	907	962	931	931
   Yorkshire and The Humber	Kingston upon Hull, City of	71	74	83	81	246	279	299	363	-175	-205	-216	-282
   Outer London	Kingston upon Thames	41	49	40	38	91	91	89	104	-50	-42	-49	-66
   Yorkshire and The Humber	Kirklees	148	178	199	218	307	278	295	285	-159	-100	-96	-67
   North West	Knowsley	183	201	216	223	151	148	149	171	32	53	67	52
   Inner London	Lambeth	211	213	231	205	305	261	273	266	-94	-48	-42	-61
   North West	Lancashire	886	952	1,014	1,101	411	486	431	412	475	466	583	689
   Yorkshire and The Humber	Leeds	299	335	320	331	366	377	417	393	-67	-42	-97	-62
   East Midlands	Leicester	122	130	123	135	337	327	349	362	-215	-197	-226	-227
   	Leicestershire	457	491	525	547	183	197	205	228	274	294	320	319
   Inner London	Lewisham	277	292	261	240	304	323	304	296	-27	-31	-43	-56
   East Midlands	Lincolnshire	487	477	505	553	116	101	107	131	371	376	398	422
   North West	Liverpool	251	252	261	276	532	572	614	679	-281	-320	-353	-403
   East of England	Luton	169	154	167	172	200	220	217	204	-31	-66	-50	-32
   North West	Manchester	293	305	294	288	716	727	767	722	-423	-422	-473	-434
   South East	Medway	423	389	407	353	204	185	232	263	219	204	175	90
   Outer London	Merton	140	161	155	140	100	110	90	93	40	51	65	47
   North East	Middlesbrough	107	128	130	106	249	279	323	298	-142	-151	-193	-192
   South East	Milton Keynes	174	183	194	188	149	156	169	176	25	27	25	12
   North East	Newcastle upon Tyne	114	116	114	128	318	357	356	367	-204	-241	-242	-239
   Inner London	Newham	189	172	183	188	265	239	283	255	-76	-67	-100	-67
   East of England	Norfolk	227	238	272	282	263	258	217	214	-36	-20	55	68
   East Midlands	Northamptonshire	295	301	328	307	265	277	295	287	30	24	33	20
   Yorkshire and The Humber	North East Lincolnshire	51	51	47	38	93	111	175	201	-42	-60	-128	-163
   	North Lincolnshire	85	90	110	120	49	51	43	30	36	39	67	90
   South West	North Somerset	67	82	87	91	101	109	85	76	-34	-27	2	15
   North East	North Tyneside	157	152	152	144	86	105	108	103	71	47	44	41
   	Northumberland	185	214	227	234	110	107	117	122	75	107	110	112
   Yorkshire and The Humber	North Yorkshire	282	291	299	318	70	71	98	80	212	220	201	238
   East Midlands	Nottingham	163	187	199	240	389	391	418	435	-226	-204	-219	-195
   	Nottinghamshire	604	642	677	715	278	312	339	421	326	330	338	294
   North West	Oldham	196	230	237	259	227	219	218	230	-31	11	19	29
   South East	Oxfordshire	102	107	108	125	242	306	321	341	-140	-199	-213	-216
   East of England	Peterborough	121	145	168	182	218	226	220	221	-97	-81	-52	-39
   South West	Plymouth	68	74	77	94	149	141	162	194	-81	-67	-85	-100
   	Poole	95	91	z	z	94	90	z	z	1	1	z	z
   South East	Portsmouth	90	83	99	96	252	262	240	214	-162	-179	-141	-118
   	Reading	50	46	53	60	200	185	187	175	-150	-139	-134	-115
   Outer London	Redbridge	357	402	428	395	133	127	122	116	224	275	306	279
   North East	Redcar and Cleveland	75	97	117	106	141	154	158	123	-66	-57	-41	-17
   Outer London	Richmond upon Thames	23	42	39	47	78	89	95	98	-55	-47	-56	-51
   North West	Rochdale	272	286	294	277	191	246	235	221	81	40	59	56
   Yorkshire and The Humber	Rotherham	125	146	149	172	332	363	343	325	-207	-217	-194	-153
   East Midlands	Rutland	13	17	21	26	24	20	30	25	-11	-3	-9	1
   North West	Salford	137	123	128	153	241	231	210	220	-104	-108	-82	-67
   West Midlands	Sandwell	294	316	297	298	417	504	487	516	-123	-188	-190	-218
   North West	Sefton	258	269	275	286	188	214	211	236	70	55	64	50
   Yorkshire and The Humber	Sheffield	147	174	179	204	226	217	209	237	-79	-43	-30	-33
   West Midlands	Shropshire	301	324	353	372	103	116	127	165	198	208	226	207
   South East	Slough	65	69	55	66	133	147	138	158	-68	-78	-83	-92
   West Midlands	Solihull	140	127	142	168	267	278	289	340	-127	-151	-147	-172
   South West	Somerset	205	210	212	220	155	171	173	193	50	39	39	27
   South East	Southampton	102	123	130	156	281	282	290	309	-179	-159	-160	-153
   East of England	Southend-on-Sea	81	91	100	85	144	145	153	151	-63	-54	-53	-66
   South West	South Gloucestershire	177	187	158	172	72	78	86	100	105	109	72	72
   North East	South Tyneside	62	53	60	68	141	128	138	144	-79	-75	-78	-76
   Inner London	Southwark	75	87	92	79	381	340	346	336	-306	-253	-254	-257
   West Midlands	Staffordshire	815	846	880	971	365	389	386	397	450	457	494	574
   North West	St. Helens	175	177	165	175	214	220	240	227	-39	-43	-75	-52
   	Stockport	280	292	297	267	113	127	107	124	167	165	190	143
   North East	Stockton-on-Tees	188	219	235	233	163	165	199	203	25	54	36	30
   West Midlands	Stoke-on-Trent	138	143	127	149	338	402	435	514	-200	-259	-308	-365
   East of England	Suffolk	251	265	237	238	188	172	206	215	63	93	31	23
   North East	Sunderland	189	205	208	214	195	187	192	207	-6	18	16	7
   South East	Surrey	280	289	264	280	468	509	482	481	-188	-220	-218	-201
   Outer London	Sutton	107	108	124	118	154	170	169	166	-47	-62	-45	-48
   South West	Swindon	65	73	72	71	128	142	112	112	-63	-69	-40	-41
   North West	Tameside	242	251	261	265	244	278	323	293	-2	-27	-62	-28
   West Midlands	Telford and Wrekin	146	153	160	181	146	173	192	200	0	-20	-32	-19
   East of England	Thurrock	91	88	98	110	176	170	194	197	-85	-82	-96	-87
   South West	Torbay	67	59	61	76	157	180	150	140	-90	-121	-89	-64
   Inner London	Tower Hamlets	33	39	34	37	238	268	256	237	-205	-229	-222	-200
   North West	Trafford	172	171	172	158	147	149	136	146	25	22	36	12
   Yorkshire and The Humber	Wakefield	180	183	219	249	202	242	257	256	-22	-59	-38	-7
   West Midlands	Walsall	310	334	343	340	293	287	332	357	17	47	11	-17
   Outer London	Waltham Forest	257	254	251	238	193	190	189	183	64	64	62	55
   Inner London	Wandsworth	66	64	60	59	219	253	221	182	-153	-189	-161	-123
   North West	Warrington	143	138	157	148	163	155	164	161	-20	-17	-7	-13
   West Midlands	Warwickshire	348	353	362	356	292	302	360	428	56	51	2	-72
   South East	West Berkshire	100	132	116	103	71	73	72	62	29	59	44	41
   Inner London	Westminster	19	14	16	27	170	181	200	150	-151	-167	-184	-123
   South East	West Sussex	355	340	325	325	162	177	221	269	193	163	104	56
   North West	Wigan	248	266	272	273	115	112	114	171	133	154	158	102
   South West	Wiltshire	165	179	179	188	161	178	179	147	4	1	0	41
   South East	Windsor and Maidenhead	33	43	54	58	72	74	69	74	-39	-31	-15	-16
   North West	Wirral	180	172	173	195	192	208	190	164	-12	-36	-17	31
   South East	Wokingham	77	71	80	70	59	68	57	53	18	3	23	17
   West Midlands	Wolverhampton	218	241	252	285	365	349	303	282	-147	-108	-51	3
   	Worcestershire	396	417	451	468	206	233	236	270	190	184	215	198
   Yorkshire and The Humber	York	28	33	32	33	80	82	113	121	-52	-49	-81	-88

   Footnotes

   1. National and regional numbers have been rounded to the nearest 10. Historical data may differ from older publications which is mainly due to amendments made by local authorities after the previous publication. See the methodology document for further information.
   2. Net gain is the difference between the number of children who are the responsibility of other LAs placed within this LA boundary and the number of children who are the responsibility of this LA placed outside the LA boundary.

   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)