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 Select a data set or featured table

    Data set
    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
  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
  6. Step 6 (current) Explore data

    This data is not from the latest release
    View latest data: Financial year 2023-24
    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:

    Related information

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