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

    Subject
    S251 Budget - planned expenditure on early years education
  3. Step 3 Choose locations

    Local Authority
    • Barking and Dagenham
    • Barnet
    • Barnsley
    • Bath and North East Somerset
    • Bedford
    • Bexley
    • Birmingham
    • Blackburn with Darwen
    • Blackpool
    • Bolton
    • Bournemouth
    • Bournemouth, Christchurch and Poole
    • Bracknell Forest
    • Bradford
    • Brent
    • Brighton and Hove
    • Bristol, City of
    • Bromley
    • Buckinghamshire
    • Bury
    • Calderdale
    • Cambridgeshire
    • Camden
    • Central Bedfordshire
    • Cheshire East
    • Cheshire West and Chester
    • City of London
    • Cornwall
    • County Durham
    • Coventry
    • Croydon
    • Cumbria
    • Darlington
    • Derby
    • Derbyshire
    • Devon
    • Doncaster
    • Dorset (E06000059)
    • Dorset (E10000009)
    • Dudley
    • Ealing
    • East Riding of Yorkshire
    • East Sussex
    • Enfield
    • Essex
    • Gateshead
    • Gloucestershire
    • Greenwich
    • Hackney
    • Halton
    • Hammersmith and Fulham
    • Hampshire
    • Haringey
    • Harrow
    • Hartlepool
    • Havering
    • Herefordshire, County of
    • Hertfordshire
    • Hillingdon
    • Hounslow
    • Isle of Wight
    • Isles of Scilly
    • Islington
    • Kensington and Chelsea
    • Kent
    • Kingston upon Hull, City of
    • Kingston upon Thames
    • Kirklees
    • Knowsley
    • Lambeth
    • Lancashire
    • Leeds
    • Leicester
    • Leicestershire
    • Lewisham
    • Lincolnshire
    • Liverpool
    • Luton
    • Manchester
    • Medway
    • Merton
    • Middlesbrough
    • Milton Keynes
    • Newcastle upon Tyne
    • Newham
    • Norfolk
    • North East Lincolnshire
    • North Lincolnshire
    • North Northamptonshire
    • North Somerset
    • North Tyneside
    • North Yorkshire
    • Northamptonshire
    • Northumberland
    • Nottingham
    • Nottinghamshire
    • Oldham
    • Oxfordshire
    • Peterborough
    • Plymouth
    • Poole
    • Portsmouth
    • Reading
    • Redbridge
    • Redcar and Cleveland
    • Richmond upon Thames
    • Rochdale
    • Rotherham
    • Rutland
    • Salford
    • Sandwell
    • Sefton
    • Sheffield
    • Shropshire
    • Slough
    • Solihull
    • Somerset
    • South Gloucestershire
    • South Tyneside
    • Southampton
    • Southend-on-Sea
    • Southwark
    • St. Helens
    • Staffordshire
    • Stockport
    • Stockton-on-Tees
    • Stoke-on-Trent
    • Suffolk
    • Sunderland
    • Surrey
    • Sutton
    • Swindon
    • Tameside
    • Telford and Wrekin
    • Thurrock
    • Torbay
    • Tower Hamlets
    • Trafford
    • Wakefield
    • Walsall
    • Waltham Forest
    • Wandsworth
    • Warrington
    • Warwickshire
    • West Berkshire
    • West Northamptonshire
    • West Sussex
    • Westminster
    • Wigan
    • Wiltshire
    • Windsor and Maidenhead
    • Wirral
    • Wokingham
    • Wolverhampton
    • Worcestershire
    • York
  4. Step 4 Choose time period

    Time period
    2021-22
  5. Step 5 Choose your filters

    Indicators
    • Average base rate for entitlement hours for 2 year olds (spend per hour)
    • Average funding rate for 2 year olds (spend per hour)
    • Number of hours funded for 2 year olds
    • Other spend on early education - centrally retained budget for 2 year olds
    • Other spend on early education - contingency budget for 2 year olds
    • SEN inclusion fund - from early years block funding for 2 year olds
    • SEN inclusion fund - from high needs block funding for 2 year olds
    • Total SEN inclusion fund for 2 year olds
    • Total planned spend on EYSFF - 2 year olds
  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
    Barking and Dagenham
    Barnet
    Barnsley
    Bath and North East Somerset
    Bedford
    Bexley
    Birmingham
    Blackburn with Darwen
    Blackpool
    Bolton
    Bournemouth, Christchurch and Poole
    Bracknell Forest
    Bradford
    Brent
    Brighton and Hove
    Bristol, City of
    Bromley
    Buckinghamshire
    Bury
    Calderdale
    Cambridgeshire
    Camden
    Central Bedfordshire
    Cheshire East
    Cheshire West and Chester
    City of London
    Cornwall
    County Durham
    Coventry
    Croydon
    Cumbria
    Darlington
    Derby
    Derbyshire
    Devon
    Doncaster
    Dorset
    Dudley
    Ealing
    East Riding of Yorkshire
    East Sussex
    Enfield
    Essex
    Gateshead
    Gloucestershire
    Greenwich
    Hackney
    Halton
    Hammersmith and Fulham
    Hampshire
    Haringey
    Harrow
    Hartlepool
    Havering
    Herefordshire, County of
    Hertfordshire
    Hillingdon
    Hounslow
    Isle of Wight
    Isles of Scilly
    Islington
    Kensington and Chelsea
    Kent
    Kingston upon Hull, City of
    Kingston upon Thames
    Kirklees
    Knowsley
    Lambeth
    Lancashire
    Leeds
    Leicester
    Leicestershire
    Lewisham
    Lincolnshire
    Liverpool
    Luton
    Manchester
    Medway
    Merton
    Middlesbrough
    Milton Keynes
    Newcastle upon Tyne
    Newham
    Norfolk
    North East Lincolnshire
    North Lincolnshire
    North Northamptonshire
    North Somerset
    North Tyneside
    Northumberland
    North Yorkshire
    Nottingham
    Nottinghamshire
    Oldham
    Oxfordshire
    Peterborough
    Plymouth
    Portsmouth
    Reading
    Redbridge
    Redcar and Cleveland
    Richmond upon Thames
    Rochdale
    Rotherham
    Rutland
    Salford
    Sandwell
    Sefton
    Sheffield
    Shropshire
    Slough
    Solihull
    Somerset
    Southampton
    Southend-on-Sea
    South Gloucestershire
    South Tyneside
    Southwark
    Staffordshire
    St. Helens
    Stockport
    Stockton-on-Tees
    Stoke-on-Trent
    Suffolk
    Sunderland
    Surrey
    Sutton
    Swindon
    Tameside
    Telford and Wrekin
    Thurrock
    Torbay
    Tower Hamlets
    Trafford
    Wakefield
    Walsall
    Waltham Forest
    Wandsworth
    Warrington
    Warwickshire
    West Berkshire
    Westminster
    West Northamptonshire
    West Sussex
    Wigan
    Wiltshire
    Windsor and Maidenhead
    Wirral
    Wokingham
    Wolverhampton
    Worcestershire
    York
    Column groups
    Column group 1
    2021-22
    Column group 2
    Total planned spend on EYSFF - 2 year olds
    SEN inclusion fund - from early years block funding for 2 year olds
    SEN inclusion fund - from high needs block funding for 2 year olds
    Total SEN inclusion fund for 2 year olds
    Number of hours funded for 2 year olds
    Average funding rate for 2 year olds (spend per hour)
    Average base rate for entitlement hours for 2 year olds (spend per hour)
    Other spend on early education - contingency budget for 2 year olds
    Other spend on early education - centrally retained budget for 2 year olds
    This is the latest data
    WarningSome rows and columns are not shown in this table as the data does not exist in the underlying file.
    'S251 Budget - planned expenditure on early years education' in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford and 147 other locations for 2021-22
    2021-22
    Total planned spend on EYSFF - 2 year oldsSEN inclusion fund - from early years block funding for 2 year oldsSEN inclusion fund - from high needs block funding for 2 year oldsTotal SEN inclusion fund for 2 year oldsNumber of hours funded for 2 year oldsAverage funding rate for 2 year olds (spend per hour)Average base rate for entitlement hours for 2 year olds (spend per hour)Other spend on early education - contingency budget for 2 year oldsOther spend on early education - centrally retained budget for 2 year olds
    Outer LondonBarking and Dagenham£4,232,137£69,105£0£69,105768,083£5.60£5.51£0£0
    Barnet£2,728,467£0£0£0448,761£6.08£6.08£0£0
    Yorkshire and The HumberBarnsley£2,417,152£30,748£0£30,748473,951£5.16£5.10£0£96,471
    South WestBath and North East Somerset£1,413,974£0£0£0252,947£5.59£5.59£0£0
    East of EnglandBedford£1,184,753£0£0£0220,624£5.37£5.37£0£0
    Outer LondonBexley£2,666£0£0£0458£5.82£5.82£0£196,800
    West MidlandsBirmingham£2,527,362£0£0£0468,030£5.40£5.40£0£0
    North WestBlackburn with Darwen£1,665,967£0£0£0330,549£5.04£5.04£0£106,300
    Blackpool£1,664,616£0£0£0321,976£5.17£5.17£0£322,743
    Bolton£3,141,600£0£0£0597,262£5.26£5.26£0£141,000
    South WestBournemouth, Christchurch and Poole£2,287,382£58,535£0£58,535450,272£5.21£5.08£0£81,049
    South EastBracknell Forest£491,495£12,941£0£12,94187,455£5.77£5.62£0£23,790
    Yorkshire and The HumberBradford£7,986,478£100,000£0£100,0001,490,014£5.43£5.36£0£0
    Outer LondonBrent£3,770,573£0£0£0620,160£6.08£6.08£0£0
    South EastBrighton and Hove£1,801,346£100,000£0£100,000336,072£5.66£5.36£0£0
    South WestBristol, City of£3,429,078£0£0£0616,741£5.56£5.56£0£18,771
    Outer LondonBromley£2,108,819£162,225£0£162,225362,340£6.27£5.82£0£29,708
    South EastBuckinghamshire£2,767,802£0£0£0496,022£5.58£5.58£0£145,674
    North WestBury£1,825,316£112,500£0£112,500340,544£5.69£5.36£400,000£87,785
    Yorkshire and The HumberCalderdale£2,058,729£0£0£0389,219£5.29£5.29£0£0
    East of EnglandCambridgeshire£2,915,210£0£0£0523,377£5.57£5.57£0£0
    Inner LondonCamden£1,772,450£0£175,000£175,000218,821£8.90£8.10£0£88,623
    East of EnglandCentral Bedfordshire£1,303,931£0£0£0234,943£5.55£5.55£0£0
    North WestCheshire East£1,992,310£39,804£0£39,804385,360£5.27£5.17£31,424£31,424
    Cheshire West and Chester£2,324,119£40,000£0£40,000438,513£5.39£5.30£0£25,199
    Inner LondonCity of London£27,360£2,000£0£2,0003,420£8.58£8.00£0£30,000
    South WestCornwall£3,155,258£0£0£0588,668£5.36£5.36£0£0
    North EastCounty Durham£5,382,579£0£0£01,023,304£5.26£5.26£0£102,367
    West MidlandsCoventry£2,813,030£27,880£0£27,880552,658£5.14£5.09£0£62,348
    Outer LondonCroydon£3,346,593£0£0£0575,016£5.82£5.82£0£0
    North WestCumbria£3,331,106£12,000£0£12,000621,475£5.38£5.36£259,233£100,000
    North EastDarlington£1,084,596£0£0£0202,350£5.36£5.36£0£0
    East MidlandsDerby£2,680,572£0£0£0500,107£5.36£5.36£0£0
    Derbyshire£4,396,769£0£0£0820,293£5.36£5.36£0£0
    South WestDevon£4,062,000£0£0£0805,952£5.04£5.04£20,916£102,621
    Yorkshire and The HumberDoncaster£3,527,382£0£30,931£30,931658,094£5.41£5.36£0£0
    South WestDorset£1,923,537£0£0£0356,871£5.39£5.39£0£0
    West MidlandsDudley£3,168,801£0£0£0586,815£5.40£5.40£0£0
    Outer LondonEaling£3,182,114£0£0£0523,374£6.08£6.08£0£0
    Yorkshire and The HumberEast Riding of Yorkshire£1,974,002£0£0£0368,284£5.36£5.36£0£0
    South EastEast Sussex£3,437,270£0£44,100£44,100637,133£5.46£5.39£0£0
    Outer LondonEnfield£3,829,076£0£0£0657,917£5.82£5.82£0£0
    East of EnglandEssex£8,768,928£0£191,563£191,5631,635,994£5.48£5.36£0£354,195
    North EastGateshead£2,192,382£0£0£0409,026£5.36£5.36£0£0
    South WestGloucestershire£2,915,995£0£0£0575,147£5.07£5.07£44,824£0
    Outer LondonGreenwich£2,900,427£235,424£0£235,424470,849£6.66£6.16£0£0
    Inner LondonHackney£4,061,886£0£0£0619,190£6.56£6.56£61,919£0
    North WestHalton£1,326,433£0£0£0254,594£5.21£5.21£121,567£44,230
    Inner LondonHammersmith and Fulham£1,161,030£0£0£0174,329£6.66£6.66£0£0
    South EastHampshire£6,065,000£61,000£0£61,0001,131,530£5.41£5.36£0£100,000
    Inner LondonHaringey£228,726£0£42,000£42,0002,402,827£0.11£0.10£0£0
    Outer LondonHarrow£1,704,521£0£0£0280,349£6.08£6.08£0£0
    North EastHartlepool£1,312,514£0£0£0252,407£5.20£5.20£0£0
    Outer LondonHavering£1,888,464£0£0£0327,858£5.76£5.76£0£0
    West MidlandsHerefordshire, County of£906,967£0£10,000£10,000169,210£5.42£5.36£0£50,955
    East of EnglandHertfordshire£7,098,000£0£0£01,288,203£5.51£5.51£0£277,100
    Outer LondonHillingdon£2,187,216£0£0£0364,536£6.00£6.00£0£0
    Hounslow£2,605,432£0£0£0428,525£6.08£6.08£0£20,000
    South EastIsle of Wight£924,154£12,372£0£12,372173,713£5.39£5.32£0£34,117
    South WestIsles of Scilly£32,251£0£0£06,017£5.36£5.36£0£0
    Inner LondonIslington£2,544,175£0£0£0360,960£7.05£7.05£0£118,693
    Kensington and Chelsea£687,112£0£0£0103,170£6.66£6.66£0£0
    South EastKent£8,492,609£0£0£01,639,500£5.18£5.18£0£457,800
    Yorkshire and The HumberKingston upon Hull, City of£3,543,037£0£0£0677,445£5.23£5.23£0£272,485
    Outer LondonKingston upon Thames£1,134,097£0£0£0187,454£6.05£6.05£0£0
    Yorkshire and The HumberKirklees£4,633,163£0£0£0896,163£5.17£5.17£0£236,200
    North WestKnowsley£1,987,978£0£0£0383,040£5.19£5.19£49,740£23,038
    Inner LondonLambeth£2,983,813£0£0£0448,020£6.66£6.66£0£0
    North WestLancashire£9,056,447£0£0£01,755,125£5.16£5.16£0£0
    Yorkshire and The HumberLeeds£7,540,877£0£0£01,406,880£5.36£5.36£0£0
    East MidlandsLeicester£3,617,968£0£0£0717,851£5.04£5.04£0£0
    Leicestershire£2,792,655£7,392£0£7,392550,820£5.08£5.07£0£137,705
    Inner LondonLewisham£2,759,257£0£0£0459,876£6.00£6.00£0£0
    East MidlandsLincolnshire£5,396,330£0£0£01,072,829£5.03£5.03£310,000£43,374
    North WestLiverpool£5,889,291£0£0£01,115,396£5.28£5.28£0£113,571
    East of EnglandLuton£2,463,978£34,224£0£34,224470,225£5.31£5.24£64,017£202,892
    North WestManchester£7,547,147£0£0£01,410,682£5.35£5.35£0£155,175
    South EastMedway£3,405,368£0£0£0665,111£5.12£5.12£0£99,261
    Outer LondonMerton£1,427,795£39,844£0£39,844246,172£5.96£5.80£29,033£0
    North EastMiddlesbrough£2,831,093£0£0£0545,490£5.19£5.19£0£92,734
    South EastMilton Keynes£2,440,321£0£0£0456,989£5.34£5.34£96,000£0
    North EastNewcastle upon Tyne£4,090,237£0£0£0786,584£5.20£5.20£0£334,180
    Inner LondonNewham£4,944,681£0£0£0849,602£5.82£5.82£0£33,091
    East of EnglandNorfolk£4,531,091£0£0£0848,519£5.34£5.34£0£0
    Yorkshire and The HumberNorth East Lincolnshire£1,649,167£0£0£0319,606£5.16£5.16£0£86,799
    North Lincolnshire£1,442,965£5,000£30,000£35,000271,234£5.45£5.32£0£0
    East MidlandsNorth Northamptonshire£2,126,617£0£0£0406,619£5.23£5.23£0£82,855
    South WestNorth Somerset£911,074£23,157£13,742£36,899167,785£5.65£5.43£0£125,603
    North EastNorth Tyneside£1,821,725£0£0£0341,147£5.34£5.34£0£0
    Northumberland£2,310,835£0£0£0431,126£5.36£5.36£0£0
    Yorkshire and The HumberNorth Yorkshire£2,910,416£0£72,600£72,600542,988£5.49£5.36£0£0
    East MidlandsNottingham£3,513,766£0£0£0670,566£5.24£5.24£0£0
    Nottinghamshire£5,526,330£0£0£01,025,293£5.39£5.39£0£0
    North WestOldham£3,884,043£0£0£0748,371£5.19£5.19£0£152,438
    South EastOxfordshire£2,984,971£0£0£0525,523£5.68£5.68£0£0
    East of EnglandPeterborough£2,321,331£0£0£0437,987£5.30£5.30£73,973£105,584
    South WestPlymouth£2,519,807£8,150£0£8,150470,113£5.38£5.36£0£0
    South EastPortsmouth£1,707,946£13,138£0£13,138328,451£5.24£5.20£42,700£72,300
    Reading£1,016,174£0£0£0177,964£5.71£5.71£0£55,000
    Outer LondonRedbridge£2,663,939£0£0£0457,721£5.82£5.82£0£0
    North EastRedcar and Cleveland£1,549,536£0£0£0289,093£5.36£5.36£0£0
    Outer LondonRichmond upon Thames£821,400£0£0£0135,099£6.08£6.08£0£0
    North WestRochdale£2,593,023£0£0£0474,913£5.46£5.46£0£0
    Yorkshire and The HumberRotherham£2,827,834£174,500£0£174,500527,581£5.69£5.36£0£0
    East MidlandsRutland£128,442£0£0£023,963£5.36£5.36£0£0
    North WestSalford£3,086,100£0£0£0615,988£5.01£5.01£0£255,314
    West MidlandsSandwell£4,369,496£0£0£0812,174£5.38£5.38£0£0
    North WestSefton£2,439,804£0£0£0480,276£5.08£5.08£0£134,178
    Yorkshire and The HumberSheffield£4,952,986£0£0£0971,174£5.10£5.10£0£260,683
    West MidlandsShropshire£1,456,205£50,000£0£50,000289,504£5.20£5.03£0£0
    South EastSlough£1,078,091£0£0£0187,494£5.75£5.75£0£64,263
    West MidlandsSolihull£1,794,813£0£0£0332,373£5.40£5.40£0£70,000
    South WestSomerset£3,021,548£0£35,000£35,000581,067£5.26£5.20£0£93,400
    South EastSouthampton£2,679,647£0£0£0503,693£5.32£5.32£0£0
    East of EnglandSouthend-on-Sea£1,332,587£0£0£0248,617£5.36£5.36£0£9,945
    South WestSouth Gloucestershire£1,413,348£0£0£0266,167£5.31£5.31£0£74,394
    North EastSouth Tyneside£1,759,399£0£0£0328,246£5.36£5.36£0£0
    Inner LondonSouthwark£3,208,006£0£0£0472,416£6.79£6.79£0£58,469
    West MidlandsStaffordshire£5,961,610£50,460£4,990£55,4501,150,890£5.23£5.18£99,580£0
    North WestSt. Helens£1,733,751£0£0£0339,286£5.11£5.11£0£91,612
    Stockport£2,250,270£0£0£0427,808£5.26£5.26£0£0
    North EastStockton-on-Tees£2,211,751£0£0£0419,687£5.27£5.27£0£0
    West MidlandsStoke-on-Trent£3,120,276£0£0£0582,141£5.36£5.36£0£0
    East of EnglandSuffolk£4,333,892£0£0£0808,562£5.36£5.36£0£0
    North EastSunderland£3,092,871£0£0£0577,028£5.36£5.36£0£0
    South EastSurrey£4,764,732£215,000£0£215,000788,863£6.31£6.04£0£0
    Outer LondonSutton£1,127,198£30,000£0£30,000190,405£6.08£5.92£0£0
    South WestSwindon£1,929,042£0£0£0352,015£5.48£5.48£0£0
    North WestTameside£2,981,536£15,960£0£15,960562,554£5.33£5.30£0£69,180
    West MidlandsTelford and Wrekin£1,831,075£0£0£0352,808£5.19£5.19£0£0
    East of EnglandThurrock£1,606,185£70,000£0£70,000307,110£5.46£5.23£0£0
    South WestTorbay£1,004,776£34,000£20,000£54,000199,360£5.31£5.04£0£55,091
    Inner LondonTower Hamlets£3,141,015£0£0£0477,358£6.58£6.58£0£38,189
    North WestTrafford£1,833,923£0£0£0358,889£5.11£5.11£0£125,611
    Yorkshire and The HumberWakefield£3,519,683£51,360£0£51,360666,607£5.36£5.28£0£0
    West MidlandsWalsall£3,231,578£20,000£0£20,000598,440£5.43£5.40£537,629£100,000
    Outer LondonWaltham Forest£1,902,399£72,842£0£72,842326,873£6.04£5.82£0£104,060
    Inner LondonWandsworth£2,125,186£0£0£0319,097£6.66£6.66£0£0
    North WestWarrington£1,337,854£16,000£0£16,000263,357£5.14£5.08£34,897£35,000
    West MidlandsWarwickshire£3,025,048£0£0£0555,055£5.45£5.45£0£0
    South EastWest Berkshire£635,548£0£0£0114,513£5.55£5.55£0£27,400
    Inner LondonWestminster£1,248,950£0£0£0187,530£6.66£6.66£0£0
    East MidlandsWest Northamptonshireuuuuuuuuu
    South EastWest Sussex£4,414,280£90,000£0£90,000839,217£5.37£5.26£77,844£0
    North WestWigan£3,140,562£0£0£0585,926£5.36£5.36£58,593£0
    South WestWiltshire£2,416,980£0£0£0441,055£5.48£5.48£0£0
    South EastWindsor and Maidenhead£575,678£10,000£0£10,00098,239£5.96£5.86£0£40,000
    North WestWirral£3,090,859£81,642£0£81,642585,390£5.42£5.28£0£195,711
    South EastWokingham£304,950£50,000£0£50,00053,594£6.62£5.69£0£18,749
    West MidlandsWolverhampton£2,850,506£0£0£0527,871£5.40£5.40£0£0
    Worcestershire£3,722,026£0£0£0699,629£5.32£5.32£0£100,000
    Yorkshire and The HumberYork£873,423£0£0£0162,952£5.36£5.36£0£0

    Footnotes

    1. Before using this data, please check the methodology section for important information such as definitions, limitations and caveats.
    2. To reduce burden on local authorities during the pandemic, data on planned expenditure was not collected for the financial year 2020-21. As a result, there is a break in the time series.

    Save table

    Download Table

    Select file format: