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
    National - Children who ceased to be looked after during the years ending 31 March by number of periods of care and placements, by age on ceasing

  3. Step 3 Choose Countries

    National
    • England

  4. Step 4 Choose time period

    Time period
    2018 to 2020

  5. Step 5 Choose your filters

    Indicators
    • Number
    • Percent
    Age on ceasing
    • Total
    • 1 to 4 years
    • 10 to 15 years
    • 16 to 17 years
    • 18 years and over
    Number of periods of care or placements
    • Total
    • 1
    • 10 or more
    • 2
    • 3

  6. Step 6 (current) Explore data

    This data is not from the latest release
    View latest data: Reporting year 2023
    'National - Children who ceased to be looked after during the years ending 31 March by number of periods of care and placements, by age on ceasing' for 1, 1, 1 to 4 years, 10 or more, 10 or more and 21 other filters in England between 2018 and 2020
    201820192020
    TotalUnder 1 year1 to 4 years5 to 9 years10 to 15 years16 to 17 years18 years and overTotalUnder 1 year1 to 4 years5 to 9 years10 to 15 years16 to 17 years18 years and overTotalUnder 1 year1 to 4 years5 to 9 years10 to 15 years16 to 17 years18 years and over
    NumberNumber of PlacementsTotal30,0502,2706,4804,0104,7203,3209,25029,5702,2406,5303,8704,3702,9609,61029,5902,1406,5103,4304,3702,82010,330
    111,6901,1902,1401,8402,6301,6602,23010,8701,1102,0401,7602,1801,5702,22010,5201,0401,8601,5902,1901,4102,430
    27,5406902,3401,0809706401,8207,4507002,2701,0801,0305801,8007,6006802,2409001,0305702,180
    34,1803001,2205504803101,3304,4903201,4205205602701,4104,5103201,4404605303001,460
    42,260705103102601909202,390905302802601501,0902,450806102602501401,110
    51,290201801201501506801,210201801301401006501,43020240120160100800
    6840c7050100100510880c706080120550890c70409070610
    7580c20305090390610c20205070450560c30305060390
    8370010105060240340010102020290350020102030270
    92900cc1040240330ccc20302703300cc1030280
    10 or more1,0000cc30808901,00000c40608809400c103090810
    Number of periods of careTotal30,0502,2706,4804,0104,7203,3209,25029,5702,2406,5303,8704,3702,9609,61029,5902,1406,5103,4304,3702,82010,330
    125,5802,2505,9803,5003,8902,6107,35025,3602,2206,1103,4303,5802,4007,63025,7202,1306,1203,0403,6502,2508,540
    23,440204704406305001,3803,230203903806103801,4602,940103603505503901,290
    3710c20501401503507000304015012037064003040120120350
    41700c104040801700c10205090180cc103040100
    51000cc2020606000c10104060000202030
    62000cc1010200c0c10102000010c10
    7100cc0cc100000010100000c10
    8c00000cc00000cc00c000
    9c000c0000000000000000
    10 or more100cc00c1000c00c1000c0010
    PercentNumber of PlacementsTotal100%8%22%13%16%11%31%100%8%22%13%15%10%32%100%7%22%12%15%10%35%
    139%10%18%16%22%14%19%37%10%19%16%20%14%20%36%10%18%15%21%13%23%
    225%9%31%14%13%9%24%25%9%30%14%14%8%24%26%9%30%12%14%8%29%
    314%7%29%13%11%7%32%15%7%32%12%12%6%31%15%7%32%10%12%7%32%
    48%3%22%14%11%9%41%8%4%22%12%11%6%46%8%3%25%11%10%6%45%
    54%1%14%10%11%12%52%4%1%15%10%11%8%54%5%1%17%8%11%7%56%
    63%c8%6%12%12%61%3%c7%7%10%13%62%3%c8%5%10%8%68%
    72%c4%6%8%15%67%2%c3%3%8%11%74%2%c4%5%9%11%70%
    81%0%2%3%13%17%66%1%0%2%4%5%6%84%1%0%4%3%7%8%78%
    91%0%cc3%13%82%1%ccc6%9%83%1%0%cc4%10%84%
    10 or more3%0%cc3%8%89%3%0%0%c4%7%89%3%0%c1%3%9%86%
    Number of periods of careTotal100%8%22%13%16%11%31%100%8%22%13%15%10%32%100%7%22%12%15%10%35%
    185%9%23%14%15%10%29%86%9%24%14%14%9%30%87%8%24%12%14%9%33%
    211%1%14%13%18%14%40%11%1%12%12%19%12%45%10%~12%12%19%13%44%
    32%c3%7%19%21%49%2%0%4%5%22%17%53%2%0%4%5%18%18%54%
    41%0%c3%25%24%47%1%0%c7%13%27%51%1%cc3%19%20%56%
    5~0%cc16%16%62%~0%0%c10%21%62%~0%0%0%24%25%51%
    6~0%0%cc26%53%~0%c0%c38%38%~0%0%0%41%c44%
    7c0%cc0%ccc0%0%0%0%0%c~0%0%0%0%c75%
    8c0%0%0%0%0%cc0%0%0%0%0%cc0%0%c0%0%0%
    9c0%0%0%c0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%0%
    10 or morec0%cc0%0%cc0%0%c0%0%cc0%0%c0%0%c

    Footnotes

    1. Numbers have been rounded to the nearest 10. Percentages 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.
    2. Only the last occasion on which a child ceased to be looked after in the year has been counted.

    Save table

    Download Table

    Select file format:

    Related information

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