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 Choose a publication

    Publication
    Children looked after in England including adoptions
  2. Step 2 Select a data set or featured table

    Data set
    LA - Children looked after numbers and rates per 10,000 children aged under 18 years
  3. Step 3 Choose locations

    Local authority
    • Barking and Dagenham
    • Barnet
    • Barnsley
    • Bath and North East Somerset
    • Bedford Borough
  4. Step 4 Choose time period

    Time period
    2020
  5. Step 5 Choose your filters

    Indicators
    • Number of children looked after
    • Rate per 10 000 children aged under 18 years
    CLA population count
    • Children looked after at 31 March each year
  6. Step 6 (current) 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 looked after at 31 March each year in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford Borough and 149 other locations for 2020
    Number of children looked afterRate per 10 000 children aged under 18 years
    Outer LondonBarking and Dagenham40263
    Barnet32535
    Yorkshire and the Humber (E12000003)Barnsley30059
    South West (E12000009)Bath and North East Somerset18150
    East of EnglandBedford Borough25362
    Outer LondonBexley22239
    West MidlandsBirmingham1,92867
    North WestBlackburn with Darwen411106
    Blackpool652223
    Bolton63292
    South West (E12000009)Bournemouth (up to 2019)zz
    Bournemouth, Christchurch and Poole (2020 onwards)52670
    South EastBracknell Forest14250
    Yorkshire and the Humber (E12000003)Bradford1,24587
    Outer LondonBrent29938
    South EastBrighton and Hove37074
    SOUTH WEST (E12000009)Bristol, City of62366
    Outer LondonBromley33144
    South EastBuckinghamshire48438
    North WestBury34279
    Yorkshire and the Humber (E12000003)Calderdale33072
    East of EnglandCambridgeshire71452
    Inner LondonCamden19036
    East of EnglandCentral Bedfordshire31449
    North WestCheshire East53469
    Cheshire West and Chester48871
    Inner LondonCity of London24148
    South West (E12000009)Cornwall47344
    West MidlandsCoventry70188
    Outer LondonCroydon79183
    North WestCumbria72178
    North EastDarlington270120
    East MidlandsDerby58898
    Derbyshire86156
    South West (E12000009)Devon74951
    Yorkshire and the Humber (E12000003)Doncaster50475
    South West (E12000009)Dorset (2020 onwards)47470
    Dorset (up to 2019)zz
    West MidlandsDudley62390
    North EastDurham91490
    Outer LondonEaling33240
    Yorkshire and the Humber (E12000003)East Riding of Yorkshire34054
    South EastEast Sussex59256
    Outer LondonEnfield37444
    East of EnglandEssex1,07134
    North EastGateshead414105
    South West (E12000009)Gloucestershire73157
    Outer LondonGreenwich46267
    Inner LondonHackney43268
    North WestHalton27897
    Inner LondonHammersmith and Fulham25268
    South EastHampshire1,60256
    Inner LondonHaringey40367
    Outer LondonHarrow18531
    North EastHartlepool316158
    Outer LondonHavering23240
    West MidlandsHerefordshire35197
    East of EnglandHertfordshire94835
    Outer LondonHillingdon33745
    Hounslow26941
    South EastIsle of Wight264107
    South West (E12000009)Isles Of Scillycc
    Inner LondonIslington36686
    Kensington and Chelsea10637
    South EastKent1,80753
    YORKSHIRE AND THE HUMBER (E12000003)Kingston Upon Hull, City of867151
    Outer LondonKingston upon Thames12532
    Yorkshire and the Humber (E12000003)Kirklees66967
    North WestKnowsley30791
    Inner LondonLambeth35858
    North WestLancashire2,09683
    Yorkshire and the Humber (E12000003)Leeds1,34679
    East MidlandsLeicester61173
    Leicestershire65446
    Inner LondonLewisham47269
    East MidlandsLincolnshire62242
    North WestLiverpool1,424148
    East of EnglandLuton38767
    North WestManchester1,407114
    South EastMedway42666
    Outer LondonMerton15432
    North EastMiddlesbrough619189
    South EastMilton Keynes40359
    North EastNewcastle upon Tyne662113
    Inner LondonNewham41148
    East of EnglandNorfolk1,10664
    Yorkshire and the Humber (E12000003)North East Lincolnshire572166
    North Lincolnshire23165
    South West (E12000009)North Somerset23053
    North EastNorth Tyneside29971
    Yorkshire and the Humber (E12000003)North Yorkshire44338
    East MidlandsNorthamptonshire1,16368
    North EastNorthumberland43473
    East MidlandsNottingham65695
    Nottinghamshire91655
    North WestOldham52087
    South EastOxfordshire76752
    East of EnglandPeterborough37272
    South West (E12000009)Plymouth43482
    Poole (up to 2019)zz
    South EastPortsmouth466106
    Reading28076
    Outer LondonRedbridge23731
    North EastRedcar and Cleveland348126
    Outer LondonRichmond upon Thames12227
    North WestRochdale535100
    Yorkshire and the Humber (E12000003)Rotherham595103
    East MidlandsRutland4355
    North WestSalford55897
    West MidlandsSandwell865105
    North WestSefton566105
    Yorkshire and the Humber (E12000003)Sheffield62653
    West MidlandsShropshire39966
    South EastSlough19645
    West MidlandsSolihull46197
    South West (E12000009)Somerset52948
    South Gloucestershire21035
    North EastSouth Tyneside29497
    South EastSouthampton48695
    East of EnglandSouthend-on-Sea31479
    Inner LondonSouthwark45870
    North WestSt. Helens496135
    West MidlandsStaffordshire1,21772
    North WestStockport36858
    North EastStockton-on-Tees576131
    West MidlandsStoke-on-Trent919159
    East of EnglandSuffolk93661
    North EastSunderland582106
    South EastSurrey98137
    Outer LondonSutton23348
    South West (E12000009)Swindon30160
    North WestTameside704139
    West MidlandsTelford and Wrekin40398
    East of EnglandThurrock29767
    South West (E12000009)Torbay357140
    Inner LondonTower Hamlets30742
    North WestTrafford37867
    Yorkshire and the Humber (E12000003)Wakefield63987
    West MidlandsWalsall67197
    Outer LondonWaltham Forest30446
    Inner LondonWandsworth27743
    North WestWarrington36482
    West MidlandsWarwickshire75464
    South EastWest Berkshire15744
    West Sussex80846
    Inner LondonWestminster21945
    North WestWigan53377
    South West (E12000009)Wiltshire45843
    South EastWindsor and Maidenhead11633
    North WestWirral812120
    South EastWokingham9824
    West MidlandsWolverhampton58894
    Worcestershire81969
    Yorkshire and the Humber (E12000003)York26272

    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

    Download Table

    Select file format:

    Related information

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