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
    LA and school expenditure
  2. Step 2 View a featured table or create your own

    Subject
    S251 Outturn - Children and Young People's Services (National, Regional, LA levels)
  3. Step 3 Choose locations

    National
    • England
  4. Step 4 Choose time period

    Time period
    2015-16 to 2020-21
  5. Step 5 Choose your filters

    Indicators
    • Per capita net current expenditure (£)
    • Total gross expenditure (£ million)
    • Total net current expenditure (£ million)
    Category of expenditure
    • 5.0.2 Total Children and Young Peoples Services Expenditure (excluding CERA)
    • 5.0.3 Total Children and Young Peoples Services Expenditure (including CERA)
    • 3.1.1 Residential care
    • 3.1.10 Asylum seeker services children
    • 3.1.11 Total Children Looked After
    • 3.1.2 Fostering services
    • 3.1.2a Fostering services (excluding fees and allowances for LA foster carers)
    • 3.1.2b Fostering services (fees and allowances for LA foster carers)
    • 3.1.3 Adoption services
    • 3.1.4 Special guardianship support
    • 3.1.5 Other children looked after services
    • 3.1.6 Short breaks (respite) for looked after disabled children
    • 3.1.7 Children placed with family and friends
    • 3.1.8 Education of looked after children
    • 3.1.9 Leaving care support services
    • 3.4.1 Direct payments
    • 3.4.2 Short breaks (respite) for disabled children
    • 3.4.3 Other support for disabled children
    • 3.4.4 Targeted family support
    • 3.4.5 Universal family support
    • 3.4.6 Total Family Support Services
    • 3.3.1 Social work (including LA functions in relation to child protection)
    • 3.3.2 Commissioning and Childrens Services Strategy
    • 3.3.3 Local Safeguarding Children Board
    • 3.3.4 Total Safeguarding Children and Young Peoples Services
    • 3.5.1 Universal services for young people
    • 3.5.2 Targeted services for young people
    • 3.5.3 Total Services for young people
    • 8a.1 Substance misuse services (Drugs, Alcohol and Volatile substances) (included in 3.5.1 and 3.5.2 above)
    • 8a.2 Teenage pregnancy services (included in 3.5.1 and 3.5.2 above)
    • 3.0.1 Spend on individual Sure Start Childrens Centres
    • 3.0.2 Spend for services delivered through Sure Start Childrens Centres
    • 3.0.3 Spend on management costs relating to Sure Start Childrens Centres
    • 3.0.4 Other spend on children under 5
    • 3.0.5 Total Sure Start childrens centres and other spend on children under 5
    • 3.6.1 Youth justice
  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
    3.0.1 Spend on individual Sure Start Childrens Centres
    3.0.2 Spend for services delivered through Sure Start Childrens Centres
    3.0.3 Spend on management costs relating to Sure Start Childrens Centres
    3.0.4 Other spend on children under 5
    3.0.5 Total Sure Start childrens centres and other spend on children under 5
    3.1.1 Residential care
    3.1.2a Fostering services (excluding fees and allowances for LA foster carers)
    3.1.2b Fostering services (fees and allowances for LA foster carers)
    3.1.2 Fostering services
    3.1.3 Adoption services
    3.1.4 Special guardianship support
    3.1.5 Other children looked after services
    3.1.6 Short breaks (respite) for looked after disabled children
    3.1.7 Children placed with family and friends
    3.1.8 Education of looked after children
    3.1.9 Leaving care support services
    3.1.10 Asylum seeker services children
    3.1.11 Total Children Looked After
    3.3.1 Social work (including LA functions in relation to child protection)
    3.3.2 Commissioning and Childrens Services Strategy
    3.3.3 Local Safeguarding Children Board
    3.3.4 Total Safeguarding Children and Young Peoples Services
    3.4.1 Direct payments
    3.4.2 Short breaks (respite) for disabled children
    3.4.3 Other support for disabled children
    3.4.4 Targeted family support
    3.4.5 Universal family support
    3.4.6 Total Family Support Services
    3.5.1 Universal services for young people
    3.5.2 Targeted services for young people
    3.5.3 Total Services for young people
    3.6.1 Youth justice
    5.0.2 Total Children and Young Peoples Services Expenditure (excluding CERA)
    5.0.3 Total Children and Young Peoples Services Expenditure (including CERA)
    8a.1 Substance misuse services (Drugs, Alcohol and Volatile substances) (included in 3.5.1 and 3.5.2 above)
    8a.2 Teenage pregnancy services (included in 3.5.1 and 3.5.2 above)
    Column groups
    Column group 1
    2015-16
    2016-17
    2017-18
    2018-19
    2019-20
    2020-21
    Column group 2
    Total gross expenditure (£ million)
    Total net current expenditure (£ million)
    Per capita net current expenditure (£)
    This is the latest data
    'S251 Outturn - Children and Young People's Services (National, Regional, LA levels)' for 3.0.1 Spend on individual Sure Start Childrens Centres, 3.0.2 Spend for services delivered through Sure Start Childrens Centres, 3.0.3 Spend on management costs relating to Sure Start Childrens Centres, 3.0.4 Other spend on children under 5, 3.0.5 Total Sure Start childrens centres and other spend on children under 5 and 31 other filters in England between 2015-16 and 2020-21
    2015-162016-172017-182018-192019-202020-21
    Total gross expenditure (£ million)Total net current expenditure (£ million)Per capita net current expenditure (£)Total gross expenditure (£ million)Total net current expenditure (£ million)Per capita net current expenditure (£)Total gross expenditure (£ million)Total net current expenditure (£ million)Per capita net current expenditure (£)Total gross expenditure (£ million)Total net current expenditure (£ million)Per capita net current expenditure (£)Total gross expenditure (£ million)Total net current expenditure (£ million)Per capita net current expenditure (£)Total gross expenditure (£ million)Total net current expenditure (£ million)Per capita net current expenditure (£)
    Sure Start and children aged under 53.0.1 Spend on individual Sure Start Childrens Centres£548.5£467.6£40£500.1£448.0£38£417.5£366.5£31£393.2£334.6£28£369.2£307.8£25£335.9£292.8£24
    3.0.2 Spend for services delivered through Sure Start Childrens Centres£101.6£91.4£8£80.4£73.7£6£78.1£71.0£6£67.4£61.6£5£63.9£59.4£5£53.0£49.1£4
    3.0.3 Spend on management costs relating to Sure Start Childrens Centres£40.6£38.3£3£42.3£39.1£3£36.7£34.0£3£32.5£28.1£2£31.1£25.9£2£26.5£24.0£2
    3.0.4 Other spend on children under 5£153.3£130.3£11£151.5£126.8£11£132.4£107.4£9£98.5£83.7£7£93.2£76.6£6£95.3£80.4£7
    3.0.5 Total Sure Start childrens centres and other spend on children under 5£844.0£727.6£63£774.3£687.6£59£664.8£578.8£49£591.6£508.1£42£557.4£469.6£39£510.7£446.3£37
    Children looked after3.1.1 Residential care£1,103.2£1,037.4£89£1,200.5£1,130.5£96£1,383.8£1,307.1£111£1,479.9£1,397.0£117£1,609.0£1,517.0£126£1,836.6£1,729.5£142
    3.1.2a Fostering services (excluding fees and allowances for LA foster carers)no datano datano datano datano datano datano datano datano data£1,004.5£990.4£83£1,056.3£1,036.2£86£1,106.5£1,088.1£89
    3.1.2b Fostering services (fees and allowances for LA foster carers)no datano datano datano datano datano datano datano datano data£697.8£688.2£58£743.2£735.6£61£728.9£715.5£59
    3.1.2 Fostering services£1,567.6£1,527.6£132£1,599.2£1,549.3£132£1,650.1£1,611.2£136no datano datano datano datano datano datano datano datano data
    3.1.3 Adoption services£316.0£282.2£24£325.9£281.0£24£308.9£273.4£23£329.8£283.2£24£325.4£277.3£23£336.7£283.9£23
    3.1.4 Special guardianship support£204.5£204.1£18£228.6£228.4£19£255.7£255.1£22£286.9£286.0£24£317.0£314.6£26£350.1£346.4£28
    3.1.5 Other children looked after services£229.1£212.8£18£234.1£211.0£18£268.1£250.4£21£301.6£281.6£24£343.0£313.2£26£359.9£331.2£27
    3.1.6 Short breaks (respite) for looked after disabled children£42.7£40.6£4£39.4£37.1£3£43.0£40.1£3£45.9£43.9£4£51.8£49.2£4£36.2£33.9£3
    3.1.7 Children placed with family and friends£88.8£88.3£8£101.7£100.9£9£98.5£97.4£8£101.6£101.0£8£124.4£123.4£10£133.5£132.7£11
    3.1.8 Education of looked after children£39.6£33.0£3£44.4£34.9£3£44.6£36.1£3£46.8£37.5£3£54.9£43.8£4£57.8£46.2£4
    3.1.9 Leaving care support services£292.1£282.1£24£319.7£301.8£26£379.0£359.9£30£429.1£411.5£34£466.0£438.0£36£526.2£491.7£40
    3.1.10 Asylum seeker services children£58.0£53.5£5£63.2£57.6£5£104.9£91.1£8£157.7£138.1£12£186.9£149.6£12£181.0£129.2£11
    3.1.11 Total Children Looked After£3,941.6£3,761.6£324£4,156.7£3,932.5£335£4,536.6£4,321.9£366£4,881.4£4,658.5£389£5,278.1£4,997.8£414£5,653.6£5,328.4£437
    Safeguarding children and young peoples services3.3.1 Social work (including LA functions in relation to child protection)£1,915.5£1,868.1£161£2,036.3£1,981.0£169£2,069.6£2,005.4£170£2,156.6£2,101.5£176£2,321.1£2,241.5£186£2,527.3£2,430.0£199
    3.3.2 Commissioning and Childrens Services Strategy£265.6£239.8£21£251.3£221.9£19£231.8£210.0£18£240.5£213.5£18£313.0£205.3£17£279.1£248.0£20
    3.3.3 Local Safeguarding Children Board£45.7£27.7£2£46.7£28.5£2£45.4£27.8£2£44.3£26.6£2£42.8£24.5£2£41.5£25.2£2
    3.3.4 Total Safeguarding Children and Young Peoples Services£2,226.8£2,135.6£184£2,334.3£2,231.4£190£2,346.8£2,243.2£190£2,441.3£2,341.6£196£2,676.9£2,471.4£205£2,847.8£2,703.2£222
    Family support servcies3.4.1 Direct payments£97.7£90.2£8£98.9£91.5£8£109.8£100.5£8£115.3£105.6£9£127.2£115.5£10£136.7£124.5£10
    3.4.2 Short breaks (respite) for disabled children£226.0£204.6£18£217.6£197.4£17£212.6£194.1£16£211.1£191.5£16£222.5£200.3£17£212.4£188.7£15
    3.4.3 Other support for disabled children£40.5£37.4£3£38.3£36.5£3£36.1£33.3£3£45.0£42.8£4£51.3£46.5£4£67.0£61.0£5
    3.4.4 Targeted family support£633.8£550.1£47£648.6£559.1£48£663.0£570.2£48£715.1£618.2£52£740.5£635.5£53£771.3£663.8£54
    3.4.5 Universal family support£75.9£61.0£5£83.6£65.2£6£66.9£61.0£5£67.8£62.3£5£73.0£68.0£6£85.4£76.3£6
    3.4.6 Total Family Support Services£1,073.9£943.3£81£1,087.1£949.7£81£1,088.3£959.1£81£1,154.4£1,020.4£85£1,214.5£1,065.8£88£1,272.7£1,114.3£91
    Services for young people3.5.1 Universal services for young people£272.4£236.7£20£215.4£185.4£16£180.7£155.5£13£167.4£142.3£12£156.0£132.7£11£153.5£133.7£11
    3.5.2 Targeted services for young people£255.6£225.5£19£232.2£202.2£17£235.3£196.9£17£230.5£192.8£16£216.1£177.6£15£225.9£189.7£16
    3.5.3 Total Services for young people£528.0£462.2£40£447.5£387.6£33£415.9£352.4£30£397.9£335.1£28£372.1£310.3£26£379.4£323.4£27
    Youth justice3.6.1 Youth justice£295.1£171.7£15£271.2£152.6£13£271.6£149.8£13£276.1£153.1£13£289.0£154.6£13£286.5£151.1£12
    Total5.0.2 Total Children and Young Peoples Services Expenditure (excluding CERA)£9,012.3£8,291.8£715£9,158.4£8,422.4£718£9,419.0£8,692.2£735£9,854.9£9,117.9£762£10,530.8£9,591.6£794£11,061.3£10,165.9£834
    5.0.3 Total Children and Young Peoples Services Expenditure (including CERA)£9,138.0£8,409.4£725£9,179.3£8,441.7£719£9,497.7£8,756.0£741£9,878.1£9,135.4£764£10,557.5£9,615.8£796£11,077.9£10,180.1£835
    Services for young people8a.1 Substance misuse services (Drugs, Alcohol and Volatile substances) (included in 3.5.1 and 3.5.2 above)£13.9:£0£11.0:£0£10.9:£0£10.9:£0£8.7:£0£7.9:£0
    8a.2 Teenage pregnancy services (included in 3.5.1 and 3.5.2 above)£5.9:£0£4.7:£0£4.4:£0£3.2:£0£2.6:£0£2.7:£0

    Save table

    Download Table

    Select file format: