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 View a featured table or create your own

    Subject
    National - Children looked after at 31 March by characteristics
  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
    • Percentage
    Characteristic
    • 1 to 4 years
    • 10 to 15 years
    • 16 years and over
    • 5 to 9 years
    • Total children
    • Under 1 year
    • N1. Abuse or neglect
    • N2. Child disability
    • N3. Parents illness or disability
    • N4. Family in acute distress
    • N5. Family dysfunction
    • N6. Socially unacceptable behaviour
    • N7. Low income
    • N8. Absent parenting
    • Total children
    • 1. Total White
    • 1a White British
    • 1b White Irish
    • 1c Traveller of Irish Heritage
    • 1d Gypsy Roma
    • 1e Any other White background
    • 2. Total White and Asian, Black African or Black Caribbean
    • 2a White and Black Caribbean
    • 2b White and Black African
    • 2c White and Asian
    • 2d Any other Mixed background
    • 3. Total Asian or Asian British
    • 3a Indian
    • 3b Pakistani
    • 3c Bangladeshi
    • 3d Any other Asian background
    • 4. Total Black or Black British
    • 4a Caribbean
    • 4b African
    • 4c Any other Black background
    • 5. Total Other ethnic groups
    • 5a Chinese
    • 5b Any other ethnic group
    • 6. Total Refused or information not yet available
    • 6a Refused
    • 6b Information not yet obtained
    • Total children
    • Female
    • Male
    • Total children
    • Care Orders
    • Detained for child protection
    • Placement Order granted
    • Total children
    • Voluntary agreements under S20 CA 1989
    • Youth Justice legal statuses
    • All females aged 12 or over looked after at 31 March
    • All mothers aged 12 or over looked after at 31 March
  6. Step 6 (current) Explore data

    Re-order table headers

    Drag and drop the options below to re-order the table headers. Hold the Ctrl key and click to select multiple items to drag and drop. For keyboard users, select and deselect a draggable item with space and use the arrow keys to move a selected item.

    To move an item with your keyboard, select or deselect the item with Space and use the Up and Down arrow keys to move the selected item. To move multiple items, you can press Ctrl and Enter to add an item to your selected items. If you are using a screen reader disable scan mode.

    Row groups
    Row group 1
    Total children
    Under 1 year
    1 to 4 years
    5 to 9 years
    10 to 15 years
    16 years and over
    Total children
    N1. Abuse or neglect
    N2. Child disability
    N3. Parents illness or disability
    N4. Family in acute distress
    N5. Family dysfunction
    N6. Socially unacceptable behaviour
    N7. Low income
    N8. Absent parenting
    Total children
    1. Total White
    1a White British
    1b White Irish
    1c Traveller of Irish Heritage
    1d Gypsy Roma
    1e Any other White background
    2. Total White and Asian, Black African or Black Caribbean
    2a White and Black Caribbean
    2b White and Black African
    2c White and Asian
    2d Any other Mixed background
    3. Total Asian or Asian British
    3a Indian
    3b Pakistani
    3c Bangladeshi
    3d Any other Asian background
    4. Total Black or Black British
    4a Caribbean
    4b African
    4c Any other Black background
    5. Total Other ethnic groups
    5a Chinese
    5b Any other ethnic group
    6. Total Refused or information not yet available
    6a Refused
    6b Information not yet obtained
    Total children
    Male
    Female
    Total children
    Care Orders
    Placement Order granted
    Voluntary agreements under S20 CA 1989
    Detained for child protection
    Youth Justice legal statuses
    All females aged 12 or over looked after at 31 March
    All mothers aged 12 or over looked after at 31 March
    Column groups
    Column group 1
    Number
    Percentage
    Column group 2
    2018
    2019
    2020
    This data is not from the latest release
    View latest data: Reporting Year 2021
    'National - Children looked after at 31 March by characteristics' for 1 to 4 years, 1. Total White, 10 to 15 years, 16 years and over, 1a White British and 48 other filters in England between 2018 and 2020
    NumberPercentage
    201820192020201820192020
    Age groupTotal children75,37078,14080,080100%100%100%
    Under 1 year4,2604,1104,1306%5%5%
    1 to 4 years9,79010,46010,85013%13%14%
    5 to 9 years14,30014,42014,70019%18%18%
    10 to 15 years29,74030,77031,37039%39%39%
    16 years and over17,28018,39019,03023%24%24%
    Category of needTotal children75,37078,14080,080100%100%100%
    N1. Abuse or neglect47,54049,68051,78063%64%65%
    N2. Child disability2,2702,2602,1803%3%3%
    N3. Parents illness or disability2,3102,2602,3003%3%3%
    N4. Family in acute distress5,9506,0306,0908%8%8%
    N5. Family dysfunction11,22011,28011,23015%14%14%
    N6. Socially unacceptable behaviour1,1001,0901,0701%1%1%
    N7. Low income100120110~~~
    N8. Absent parenting4,8805,4305,3306%7%7%
    EthnicityTotal children75,37078,14080,080100%100%100%
    1. Total White56,38057,84059,32075%74%74%
    1a White British52,83054,13055,57070%69%69%
    1b White Irish210200200~~~
    1c Traveller of Irish Heritage110120130~~~
    1d Gypsy Roma3904604901%1%1%
    1e Any other White background2,8402,9302,9304%4%4%
    2. Total White and Asian, Black African or Black Caribbean7,3607,6707,78010%10%10%
    2a White and Black Caribbean2,6202,6802,7003%3%3%
    2b White and Black African8209108901%1%1%
    2c White and Asian1,4001,5201,5402%2%2%
    2d Any other Mixed background2,5202,5702,6603%3%3%
    3. Total Asian or Asian British3,3903,4803,4804%4%4%
    3a Indian320310300~~~
    3b Pakistani9401,0201,0201%1%1%
    3c Bangladeshi4104104201%1%1%
    3d Any other Asian background1,7301,7401,7502%2%2%
    4. Total Black or Black British5,4205,9605,8607%8%7%
    4a Caribbean1,3501,3401,3702%2%2%
    4b African2,9803,4203,2604%4%4%
    4c Any other Black background1,0901,2001,2301%2%2%
    5. Total Other ethnic groups2,5102,7902,9303%4%4%
    5a Chinese9010090~~~
    5b Any other ethnic group2,4202,6902,8403%3%4%
    6. Total Refused or information not yet available310410710~1%1%
    6a Refused303050~~~
    6b Information not yet obtained280380660~~1%
    GenderTotal children75,37078,14080,080100%100%100%
    Male42,29044,02044,99056%56%56%
    Female33,08034,12035,09044%44%44%
    Legal statusTotal children75,37078,14080,080100%100%100%
    Care Orders55,33058,36061,32073%75%77%
    Placement Order granted5,5905,5804,8507%7%6%
    Voluntary agreements under S20 CA 198914,14013,90013,60019%18%17%
    Detained for child protection205040~~~
    Youth Justice legal statuses290250280~~~
    Motherhood statusAll females aged 12 or over looked after at 31 March16,31016,97017,480100%100%100%
    All mothers aged 12 or over looked after at 31 March2902702502%2%1%

    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. Category of need is the main category of the eight “need codes” at the time the child started to be looked after.
    3. No new applications for freeing orders may be made on or after 30 December 2005, they were replaced by placement orders.
    4. 'Youth Justice legal statuses' refers to children: remanded to LA accommodation or youth detention accommodation under the Legal Aid, Sentencing and Punishment of Offenders Act 2012; placed in LA accommodation under the Police and Criminal Evidence Act 1984; or, sentenced to a youth rehabilitation order with residence or intensive fostering requirement under the Criminal Justice and Immigration Act 2008 (as amended).
    5. Percentages for all mothers aged 12 or over looked after at 31 March are the number of looked after mothers aged 12 and over as a percentage of all looked after females aged 12 and over.

    Save table

    Download Table

    Select file format: