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 during the year who were looked after exclusively under a series of short term placements - 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

6. Step 6 Explore data

   This data is not from the latest release

   View latest data: Reporting year 2023

   Number for 'CLA during the year who were looked after exclusively under a series of short term placements - LA' in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford and 161 other locations between 2018 and 2021

   		2018	2019	2020	2021
   England		1,540	1,270	1,040	880
   North East		180	160	110	80
   North West		190	150	120	110
   Yorkshire and The Humber		170	150	110	120
   East of England		90	80	70	50
   East Midlands		310	270	240	200
   West Midlands		70	10	10	10
   London		180	180	180	150
   Inner London		80	70	90	80
   Outer London		100	100	90	70
   South East		120	120	100	70
   South West		240	170	120	100
   Outer London	Barking and Dagenham	0	0	0	0
   	Barnet	0	0	0	0
   Yorkshire and The Humber	Barnsley	c	c	c	c
   South West	Bath and North East Somerset	c	c	0	0
   East of England	Bedford	0	0	0	0
   Outer London	Bexley	c	0	0	0
   West Midlands	Birmingham	0	0	c	0
   North West	Blackburn with Darwen	0	c	c	c
   	Blackpool	28	30	23	21
   	Bolton	c	c	c	c
   South West	Bournemouth	0	0	z	z
   	Bournemouth, Christchurch and Poole	z	z	c	c
   South East	Bracknell Forest	0	0	0	0
   Yorkshire and The Humber	Bradford	0	0	0	0
   Outer London	Brent	0	0	0	0
   South East	Brighton and Hove	15	13	11	13
   South West	Bristol, City of	0	0	0	0
   Outer London	Bromley	57	65	60	55
   South East	Buckinghamshire	0	0	0	0
   North West	Bury	14	11	7	c
   Yorkshire and The Humber	Calderdale	0	0	0	0
   East of England	Cambridgeshire	7	c	c	c
   Inner London	Camden	0	0	0	0
   East of England	Central Bedfordshire	c	c	c	0
   North West	Cheshire East	35	32	32	32
   	Cheshire West and Chester	c	0	0	0
   Inner London	City of London	0	0	0	0
   South West	Cornwall	78	73	61	56
   North East	County Durham	18	15	c	0
   West Midlands	Coventry	14	c	c	0
   Outer London	Croydon	0	0	0	0
   North West	Cumbria	c	c	c	c
   North East	Darlington	0	0	0	0
   East Midlands	Derby	0	0	0	0
   	Derbyshire	0	0	0	0
   South West	Devon	18	12	10	8
   Yorkshire and The Humber	Doncaster	c	c	0	0
   South West	Dorset (E06000059)	z	z	8	8
   	Dorset (E10000009)	12	11	z	z
   West Midlands	Dudley	0	c	0	0
   Outer London	Ealing	0	c	0	0
   Yorkshire and The Humber	East Riding of Yorkshire	c	c	c	c
   South East	East Sussex	c	c	c	c
   Outer London	Enfield	0	0	0	0
   East of England	Essex	13	9	7	c
   North East	Gateshead	15	12	7	c
   South West	Gloucestershire	18	10	8	c
   Outer London	Greenwich	c	0	0	0
   Inner London	Hackney	0	0	0	0
   North West	Halton	17	15	20	16
   Inner London	Hammersmith and Fulham	c	c	c	0
   South East	Hampshire	6	c	c	c
   Inner London	Haringey	7	6	c	c
   Outer London	Harrow	0	0	0	0
   North East	Hartlepool	10	7	7	7
   Outer London	Havering	0	0	0	0
   West Midlands	Herefordshire, County of	c	c	0	0
   East of England	Hertfordshire	0	0	0	0
   Outer London	Hillingdon	7	c	c	c
   	Hounslow	c	c	0	0
   South East	Isle of Wight	c	c	c	c
   South West	Isles of Scilly	0	0	0	0
   Inner London	Islington	0	0	0	0
   	Kensington and Chelsea	0	c	0	c
   South East	Kent	9	8	c	c
   Yorkshire and The Humber	Kingston upon Hull, City of	c	c	c	c
   Outer London	Kingston upon Thames	0	0	0	0
   Yorkshire and The Humber	Kirklees	c	c	0	c
   North West	Knowsley	0	0	0	0
   Inner London	Lambeth	0	0	0	0
   North West	Lancashire	13	20	11	9
   Yorkshire and The Humber	Leeds	19	17	11	14
   East Midlands	Leicester	0	0	0	0
   	Leicestershire	27	23	16	10
   Inner London	Lewisham	29	26	27	28
   East Midlands	Lincolnshire	124	114	114	102
   North West	Liverpool	43	0	0	0
   East of England	Luton	46	48	48	39
   North West	Manchester	c	0	c	0
   South East	Medway	41	50	45	32
   Outer London	Merton	c	0	0	0
   North East	Middlesbrough	15	10	0	0
   South East	Milton Keynes	c	c	c	c
   North East	Newcastle upon Tyne	c	c	c	c
   Inner London	Newham	0	0	0	0
   East of England	Norfolk	c	c	0	0
   East Midlands	Northamptonshire	62	53	44	30
   Yorkshire and The Humber	North East Lincolnshire	c	c	0	0
   	North Lincolnshire	c	c	0	0
   South West	North Somerset	0	0	0	0
   North East	North Tyneside	83	73	67	58
   	Northumberland	c	c	c	0
   Yorkshire and The Humber	North Yorkshire	19	11	8	7
   East Midlands	Nottingham	73	65	49	47
   	Nottinghamshire	22	18	15	12
   North West	Oldham	c	0	0	c
   South East	Oxfordshire	17	13	11	c
   East of England	Peterborough	8	8	8	6
   South West	Plymouth	25	0	c	c
   	Poole	c	c	z	z
   South East	Portsmouth	0	0	0	c
   	Reading	c	c	c	c
   Outer London	Redbridge	0	0	0	0
   North East	Redcar and Cleveland	0	0	c	c
   Outer London	Richmond upon Thames	0	0	0	0
   North West	Rochdale	0	0	0	0
   Yorkshire and The Humber	Rotherham	21	12	7	c
   East Midlands	Rutland	0	0	0	0
   North West	Salford	24	27	15	9
   West Midlands	Sandwell	0	0	c	c
   North West	Sefton	0	0	0	0
   Yorkshire and The Humber	Sheffield	0	c	c	0
   West Midlands	Shropshire	0	0	0	0
   South East	Slough	7	c	c	c
   West Midlands	Solihull	0	0	0	0
   South West	Somerset	c	0	0	c
   South East	Southampton	0	0	0	c
   East of England	Southend-on-Sea	0	0	0	0
   South West	South Gloucestershire	28	16	12	9
   North East	South Tyneside	0	0	0	0
   Inner London	Southwark	0	c	20	9
   West Midlands	Staffordshire	9	c	c	c
   North West	St. Helens	0	0	0	0
   	Stockport	c	c	0	0
   North East	Stockton-on-Tees	29	32	13	c
   West Midlands	Stoke-on-Trent	37	0	0	0
   East of England	Suffolk	c	c	c	0
   North East	Sunderland	c	c	0	c
   South East	Surrey	c	c	c	0
   Outer London	Sutton	0	0	0	0
   South West	Swindon	21	20	c	0
   North West	Tameside	0	0	0	0
   West Midlands	Telford and Wrekin	0	0	0	0
   East of England	Thurrock	0	0	0	0
   South West	Torbay	14	19	10	10
   Inner London	Tower Hamlets	0	0	0	0
   North West	Trafford	0	0	0	c
   Yorkshire and The Humber	Wakefield	94	93	66	78
   West Midlands	Walsall	c	c	c	c
   Outer London	Waltham Forest	28	30	22	8
   Inner London	Wandsworth	34	36	40	38
   North West	Warrington	0	0	0	c
   West Midlands	Warwickshire	c	c	c	0
   South East	West Berkshire	c	c	c	0
   Inner London	Westminster	c	c	0	0
   South East	West Sussex	9	6	c	c
   North West	Wigan	0	0	0	c
   South West	Wiltshire	22	c	c	0
   South East	Windsor and Maidenhead	0	c	c	0
   North West	Wirral	0	0	c	c
   South East	Wokingham	c	c	c	c
   West Midlands	Wolverhampton	0	0	0	0
   	Worcestershire	c	0	0	0
   Yorkshire and The Humber	York	c	c	c	c

   Footnotes

   1. Children looked after exclusively under one or more agreed series of short term placements at any time during the years ending 31 March.
   2. National and regional numbers have been rounded to the nearest 10. Percentages rounded to the nearest whole number. 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)