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
    Early years - unrounded data
  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
    2022-23
  5. Step 5 Choose your filters

    Indicators
    • Average base rate for entitlement hours for 3 and 4 year olds (spend per hour)
    • Average funding rate for 3 and 4 year olds (spend per hour)
    • Number of hours funded for 3 and 4 year olds (millions)
    • Other spend on early education - budget for extra local hours for 3 and 4 year olds
    • Other spend on early education - centrally retained budget for 3 and 4 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.
    'Early years - unrounded data' in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford and 147 other locations for 2022-23
    2022-23
    Total planned spend via early years single funding formula (EYSFF) - 3 and 4 year oldsNumber of hours funded for 3 and 4 year olds (millions)Average base rate for entitlement hours for 3 and 4 year olds (spend per hour)Average funding rate for 3 and 4 year olds (spend per hour)Other spend on early education - budget for extra local hours for 3 and 4 year oldsOther spend on early education - centrally retained budget for 3 and 4 year oldsOther spend on early education - contingency budget for 3 and 4 year oldsOther spend on early education - disability access fund for 3 and 4 year oldsOther spend on early education - early years pupil premium for 3 and 4 year oldsSEN inclusion fund - from early years block funding for 3 and 4 year oldsSEN inclusion fund - from high needs block funding for 3 and 4 year oldsTotal SEN inclusion fund for 3 and 4 year olds
    North EastCounty Durham£23,593,1885,066,560£4.01£4.70£0£1,220,000£0£220,800£453,701£220,000£0£220,000
    Darlington£5,447,6051,156,096£4.48£4.89£0£113,754£0£31,200£106,386£200,000£0£200,000
    Gateshead£10,928,4132,345,185£4.14£4.73£0£332,403£8,500£88,000£177,864£160,420£0£160,420
    Hartlepool£4,444,443985,464£4.50£4.54£0£234,883£20,000£42,400£164,017£28,186£0£28,186
    Middlesbrough£8,695,2321,806,883£4.35£4.95£0£134,980£0£68,800£232,766£150,000£100,000£250,000
    Newcastle upon Tyne£15,718,9913,038,668£4.71£5.26£0£511,680£0£118,400£405,558£250,000£0£250,000
    North Tyneside£11,203,9582,408,879£4.60£4.73£0£599,619£0£63,200£111,150£200,000£0£200,000
    Northumberland£14,546,9693,204,730£4.45£4.63£0£779,830£0£112,000£178,576£0£286,000£286,000
    Redcar and Cleveland£6,277,5351,435,020£4.27£4.56£0£0£329,027£63,200£127,224£0£260,000£260,000
    South Tyneside£7,747,0981,588,117£4.19£4.91£0£391,608£0£47,000£154,745£47,000£0£47,000
    Stockton-on-Tees£10,440,7242,335,323£4.31£4.52£0£555,828£0£94,400£164,160£120,000£0£120,000
    Sunderland£14,884,4902,983,035£4.48£5.16£0£770,000£0£174,400£333,334£500,000£0£500,000
    North WestBlackburn with Darwen£8,375,2851,788,600£4.50£4.78£0£588,500£3,763£52,800£93,411£25,000£145,000£170,000
    Blackpool£6,578,4051,478,442£4.36£4.49£0£290,921£0£69,600£100,083£60,000£0£60,000
    Bolton£17,070,0073,741,862£4.31£4.64£0£824,000£0£113,600£280,900£300,000£0£300,000
    Bury£10,447,2522,245,419£4.30£4.74£0£300,000£50,000£71,200£139,150£200,000£0£200,000
    Cheshire East£20,136,3134,592,025£4.25£4.49£0£1,040,349£0£101,600£131,346£0£465,000£465,000
    Cheshire West and Chester£17,550,5474,087,354£4.05£4.46£0£822,855£0£108,645£164,677£479,469£200,000£679,469
    Cumbria£22,514,8405,050,672£4.31£4.51£0£402,231£853,769£137,600£247,766£248,000£0£248,000
    Halton£7,382,1931,457,210£4.57£5.09£0£205,933£9,947£54,400£167,180£40,000£0£40,000
    Knowsley£9,936,1912,035,268£4.45£4.92£0£552,850£62,074£73,600£171,684£80,000£0£80,000
    Lancashire£68,117,89814,205,929£4.48£4.83£0£0£0£363,200£937,727£500,000£0£500,000
    Liverpool£27,904,9795,738,793£4.40£5.05£0£1,007,344£14,960£234,400£547,269£801,699£300,000£1,101,699
    Manchester£29,909,8816,027,539£4.65£5.04£0£811,092£0£232,000£830,421£489,063£0£489,063
    Oldham£13,695,0773,137,345£4.24£4.43£0£731,004£0£106,400£219,900£194,000£0£194,000
    Rochdale£13,013,5432,801,555£4.38£4.68£0£617,400£127,629£115,200£206,695£94,000£0£94,000
    Salford£15,344,0183,573,031£4.08£4.52£0£862,531£250,000£136,000£375,174£794,091£0£794,091
    Sefton£13,989,3863,064,189£4.33£4.67£0£176,250£58,573£80,000£159,178£255,450£61,285£316,735
    St. Helens£9,264,1782,111,663£4.31£4.51£0£498,000£153,300£72,800£106,978£250,000£0£250,000
    Stockport£17,587,1723,828,586£4.53£4.69£0£806,824£19,301£99,000£217,000£350,000£0£350,000
    Tameside£12,940,3332,905,279£4.35£4.58£0£698,120£0£94,400£179,390£378,000£0£378,000
    Trafford£14,020,0553,231,692£4.23£4.56£0£775,940£3,859£63,200£107,313£719,000£0£719,000
    Warrington£11,770,5002,569,138£4.54£4.65£0£22,230£34,918£60,800£99,533£175,000£0£175,000
    Wigan£17,712,1814,010,873£4.28£4.44£0£765,878£0£112,000£184,133£100,000£0£100,000
    Wirral£16,552,2533,632,952£3.99£4.68£0£102,297£102,907£102,000£244,080£450,000£0£450,000
    Yorkshire and The HumberBarnsley£12,161,0102,727,285£4.31£4.50£0£583,529£0£101,600£210,833£100,000£0£100,000
    Bradford£32,907,4096,650,495£4.39£5.01£0£194,648£0£248,000£436,605£400,000£0£400,000
    Calderdale£11,534,1082,561,701£4.19£4.69£0£463,750£0£92,000£168,367£0£480,000£480,000
    Doncaster£15,607,0493,421,932£4.31£4.62£0£715,570£0£109,600£267,831£0£206,930£206,930
    East Riding of Yorkshire£15,415,9343,390,936£4.31£4.57£0£523,360£0£83,200£145,670£0£89,000£89,000
    Kingston upon Hull, City of£12,676,3162,871,296£4.15£4.54£0£698,517£0£30,000£317,462£170,000£200,000£370,000
    Kirklees£22,963,0465,029,938£4.48£4.59£0£708,600£0£142,400£452,179£50,000£50,000£100,000
    Leeds£47,625,8919,739,446£4.70£4.94£0£1,753,100£0£253,600£617,810£487,000£0£487,000
    North East Lincolnshire£7,771,8751,755,294£4.31£4.54£0£402,799£0£60,800£150,138£0£200,000£200,000
    North Lincolnshire£7,116,2871,616,078£4.35£4.53£0£352,000£157,641£52,800£181,609£0£212,500£212,500
    North Yorkshire£27,666,7846,261,427£4.31£4.50£0£1,443,000£0£118,400£282,092£0£531,000£531,000
    Rotherham£14,152,1423,015,049£4.29£4.82£0£695,406£0£123,200£272,403£388,800£0£388,800
    Sheffield£27,764,9855,981,825£4.43£4.75£53,426£1,495,886£0£249,600£719,678£630,000£0£630,000
    Wakefield£18,131,6533,986,262£4.41£4.59£0£748,964£0£134,400£311,604£150,000£0£150,000
    York£9,118,5542,084,444£4.29£4.43£0£476,536£0£40,800£77,662£20,000£105,000£125,000
    East MidlandsDerby£15,819,3833,065,990£4.54£5.26£0£200,000£96,703£102,400£273,279£300,000£0£300,000
    Derbyshire£35,730,3217,800,593£4.30£4.60£0£1,338,051£10,000£208,000£464,475£0£163,200£163,200
    Leicester£17,888,0994,037,369£4.27£4.68£0£240,000£0£100,800£250,726£1,026,000£0£1,026,000
    Leicestershire£30,895,3977,086,354£4.31£4.40£0£1,635,977£0£188,800£328,064£312,782£0£312,782
    Lincolnshire£31,488,4147,264,133£4.20£4.42£0£1,561,410£230,541£236,800£536,814£650,000£0£650,000
    North Northamptonshire£17,956,4103,948,480£4.21£4.67£0£925,742£324,494£113,600£255,847£482,996£0£482,996
    Nottingham£16,320,0303,198,227£4.76£5.19£0£960,000£0£116,000£355,403£279,941£0£279,941
    Nottinghamshire£43,589,7409,682,024£4.48£4.55£0£1,251,258£0£241,600£687,178£185,000£300,000£485,000
    Rutland£1,629,332371,868£4.38£4.52£0£0£120,000£9,600£1,026£0£50,000£50,000
    West Northamptonshire£20,945,6374,746,104£4.18£4.59£0£1,114,740£0£126,000£216,000£827,000£0£827,000
    West MidlandsBirmingham£65,731,35013,149,273£4.52£5.17£0£2,950,000£0£543,200£1,399,020£750,000£1,512,850£2,262,850
    Coventry£18,131,3674,052,954£4.21£4.54£0£958,524£0£128,000£322,195£260,978£0£260,978
    Dudley£14,071,2333,168,666£4.31£4.48£0£385,300£360,092£115,200£256,386£120,000£0£120,000
    Herefordshire, County of£8,300,1931,878,390£4.24£4.49£0£335,596£0£44,800£86,745£0£140,000£140,000
    Sandwell£18,054,8264,015,739£4.23£4.62£0£961,326£0£118,400£307,551£480,000£0£480,000
    Shropshire£14,393,1983,315,799£4.19£4.42£0£330,791£330,791£69,600£140,713£250,000£0£250,000
    Solihull£12,219,2212,849,105£4.21£4.42£0£724,867£36,233£81,600£187,074£385,000£0£385,000
    Staffordshire£28,202,8246,360,388£4.26£4.52£0£2,247,000£108,700£208,800£467,005£496,000£66,582£562,582
    Stoke-on-Trent£12,773,7042,815,123£4.30£4.57£0£601,269£171,400£119,200£415,076£100,000£0£100,000
    Telford and Wrekin£10,320,7122,216,850£4.13£4.73£0£190,000£0£72,000£156,568£170,000£0£170,000
    Walsall£16,028,7053,123,664£4.64£5.15£0£400,000£400,000£124,000£287,109£69,000£0£69,000
    Warwickshire£29,519,9216,501,345£4.30£4.60£0£1,549,227£0£164,800£210,330£0£385,000£385,000
    Wolverhampton£14,559,4132,806,589£4.51£5.28£0£0£112,264£112,800£336,009£252,594£0£252,594
    Worcestershire£27,632,6666,273,640£4.37£4.57£0£1,816,706£1,000,000£188,000£283,792£0£1,020,000£1,020,000
    East of EnglandBedford£9,434,6622,043,252£4.32£4.98£22,075£736,711£38,043£45,600£148,268£215,720£531,840£747,560
    Cambridgeshire£29,213,0206,260,788£4.37£4.83£0£1,200,000£0£170,400£437,466£500,000£534,013£1,034,013
    Central Bedfordshire£14,727,7923,377,495£4.19£4.51£0£375,000£36,852£108,800£165,717£500,000£0£500,000
    Essex£72,354,43115,759,176£4.50£4.71£0£4,392,483£0£527,200£548,245£0£1,937,343£1,937,343
    Hertfordshire£80,560,00714,213,263£5.41£5.71£0£2,698,993£0£303,000£1,006,000£598,000£0£598,000
    Luton£14,129,9362,698,138£4.67£5.32£0£204,279£408,880£84,800£228,706£221,770£0£221,770
    Norfolk£33,797,4237,890,284£4.08£4.39£0£1,818,710£192,250£227,200£581,715£850,000£0£850,000
    Peterborough£14,255,9692,735,981£4.77£5.37£0£548,750£0£118,400£192,486£30,000£409,000£439,000
    Southend-on-Sea£8,494,6721,839,470£4.53£4.64£0£296,231£0£68,000£153,104£40,000£0£40,000
    Suffolk£31,319,9967,030,088£4.36£4.48£0£1,474,085£0£187,575£322,628£170,126£0£170,126
    Thurrock£8,895,4051,817,616£4.77£4.97£0£446,000£0£68,800£88,042£130,000£0£130,000
    South EastBracknell Forest£6,767,3661,386,053£4.60£4.96£0£367,000£102,760£37,600£38,540£102,760£0£102,760
    Brighton and Hove£12,096,4112,606,127£4.36£4.92£0£531,928£0£84,000£183,350£389,700£330,000£719,700
    Buckinghamshire£27,519,7495,899,792£4.55£4.73£0£1,620,524£95,000£130,400£159,020£400,000£0£400,000
    East Sussex£19,865,5154,533,600£4.33£4.45£0£952,500£0£152,000£230,567£305,900£0£305,900
    Hampshire£70,207,00014,710,955£4.56£4.85£0£3,753,000£1,495,000£394,000£578,000£1,170,000£0£1,170,000
    Isle of Wight£5,069,7551,179,013£3.95£4.38£0£271,774£0£44,800£73,486£93,974£0£93,974
    Kent£77,972,41116,761,694£4.31£4.74£0£3,847,900£0£602,400£734,418£0£1,440,400£1,440,400
    Medway£13,091,2232,901,598£4.06£4.56£0£777,544£0£92,000£163,562£133,892£0£133,892
    Milton Keynes£16,443,8343,320,696£4.80£5.04£0£524,000£1,270,140£84,800£112,426£230,000£79,000£309,000
    Oxfordshire£33,302,2597,495,312£4.35£4.53£0£1,521,066£262,293£189,600£283,409£640,000£0£640,000
    Portsmouth£10,606,2672,280,918£4.45£4.69£0£570,300£136,900£92,000£122,100£91,237£0£91,237
    Reading£10,458,8871,987,590£5.06£5.34£0£669,200£0£50,400£154,242£50,000£100,000£150,000
    Slough£12,459,6722,047,565£5.65£6.13£0£624,510£0£51,200£122,696£100,000£0£100,000
    Southampton£12,851,3542,504,118£4.74£5.19£0£1,115,300£0£0£0£141,200£0£141,200
    Surrey£63,002,44812,460,925£4.87£5.41£0£3,276,967£24,722£361,689£316,800£4,416,201£0£4,416,201
    West Berkshire£9,052,3591,780,543£4.50£5.13£0£382,645£0£42,400£82,218£90,000£0£90,000
    West Sussex£43,833,7459,091,255£4.72£4.90£0£2,313,724£0£273,600£468,383£683,141£0£683,141
    Windsor and Maidenhead£9,035,7301,754,824£4.60£5.25£0£191,265£0£24,000£32,467£180,000£0£180,000
    Wokingham£9,757,6581,967,236£4.76£5.01£0£507,542£162,792£42,400£55,883£100,000£0£100,000
    South WestBath and North East Somerset£8,389,3391,904,569£4.32£4.65£0£441,544£0£60,000£73,086£0£458,733£458,733
    Bournemouth, Christchurch and Poole£17,414,9133,982,664£4.26£4.58£0£115,084£0£100,800£125,798£830,084£0£830,084
    Bristol, City of£27,523,7875,242,418£4.88£5.62£0£1,334,026£0£140,000£356,375£1,930,000£0£1,930,000
    Cornwall£23,911,2145,196,575£4.48£4.67£0£0£200,000£138,400£306,593£350,000£0£350,000
    Devon£33,513,7457,579,070£4.30£4.52£0£988,495£368,653£221,000£374,000£741,000£0£741,000
    Dorset£13,691,2183,086,753£4.19£4.44£0£700,446£23,806£80,800£136,448£10,000£0£10,000
    Gloucestershire£30,002,5186,803,292£4.24£4.47£0£2,266,319£1,616,779£352,338£277,147£392,748£0£392,748
    Isles of Scilly£75,89916,464£4.61£4.79£0£61,142£0£0£0£3,000£0£3,000
    North Somerset£9,706,3452,229,658£4.18£4.55£0£91,425£28,760£48,000£81,475£270,199£160,341£430,540
    Plymouth£12,444,1672,687,563£4.36£4.83£0£490,664£0£100,800£187,239£501,074£22,500£523,574
    Somerset£24,552,7865,493,600£4.41£4.53£0£485,000£0£138,400£129,400£314,400£0£314,400
    South Gloucestershire£15,435,2983,568,770£4.28£4.52£0£828,963£0£77,600£82,070£315,000£375,000£690,000
    Swindon£12,938,5552,884,114£4.12£4.61£0£699,400£0£86,400£178,928£350,000£0£350,000
    Torbay£5,363,5781,241,916£4.15£4.53£0£291,501£0£57,600£101,315£175,000£89,740£264,740
    Wiltshire£25,254,3185,671,520£4.42£4.52£0£430,030£0£161,600£143,151£357,000£0£357,000
    Inner LondonCamden£11,849,5131,572,454£6.57£7.83£0£537,000£0£48,500£135,000£462,000£0£462,000
    City of London£383,38646,683£8.20£8.66£0£0£0£0£0£21,000£0£21,000
    Hackney£22,850,7484,015,968£4.99£5.94£0£1,232,000£100,000£119,200£178,200£1,000,000£0£1,000,000
    Hammersmith and Fulham£14,450,8961,843,640£6.39£8.18£0£759,000£67,424£51,200£94,598£629,000£0£629,000
    Haringey£16,298,1762,637,370£5.65£6.43£0£786,557£0£82,400£83,400£393,168£273,999£667,167
    Islington£13,885,2392,031,030£6.02£8.21£0£793,168£6,266£94,400£229,893£1,289,239£1,496,868£2,786,107
    Kensington and Chelsea£10,359,8311,329,611£7.05£7.90£0£545,140£414,307£27,200£69,016£150,000£0£150,000
    Lambeth£21,227,2053,023,050£6.27£7.13£0£1,104,000£158,614£82,000£229,000£339,000£0£339,000
    Lewisham£19,378,9843,532,775£5.15£5.70£0£1,047,468£446,393£105,600£99,180£758,793£0£758,793
    Newham£22,474,5963,849,895£5.29£6.08£0£1,114,414£0£136,800£117,744£942,077£0£942,077
    Southwark£19,561,3842,829,621£6.00£7.00£0£978,306£0£109,600£284,021£250,000£0£250,000
    Tower Hamlets£23,356,9523,050,818£7.16£7.86£0£1,220,727£0£112,000£318,402£610,163£0£610,163
    Wandsworth£21,535,8413,526,493£5.67£6.40£0£1,077,520£717,894£100,000£143,982£1,020,083£0£1,020,083
    Westminster£10,319,3061,256,702£6.80£8.35£0£493,884£281,514£49,600£89,854£175,000£0£175,000
    Outer LondonBarking and Dagenham£16,476,0543,040,009£5.09£5.54£0£701,943£0£96,800£171,051£377,761£0£377,761
    Barnet£22,566,5363,881,858£5.45£5.92£0£1,228,327£488,622£140,000£161,766£400,000£0£400,000
    Bexley£14,381,9142,794,978£4.97£5.18£0£451,500£0£77,805£77,674£110,000£0£110,000
    Brent£17,625,1603,207,550£4.74£5.62£0£910,944£0£98,400£55,062£416,981£0£416,981
    Bromley£18,411,8883,543,474£5.05£5.31£0£461,750£0£86,400£144,133£387,420£0£387,420
    Croydon£25,252,6294,501,598£5.44£5.86£0£0£0£125,600£154,584£0£1,131,000£1,131,000
    Ealing£19,589,6223,938,853£4.64£5.70£103,837£1,148,000£754,000£103,200£167,922£2,118,000£742,754£2,860,754
    Enfield£19,685,3403,572,657£5.40£5.64£0£1,036,071£0£118,400£220,279£464,446£0£464,446
    Greenwich£20,636,4133,553,483£5.24£6.36£0£1,141,011£461,953£116,000£304,298£1,421,393£535,096£1,956,489
    Harrow£15,236,1062,857,598£4.81£5.61£0£842,311£0£62,400£108,257£800,196£0£800,196
    Havering£16,550,6733,109,913£5.19£5.47£0£790,000£0£64,800£100,641£400,000£50,000£450,000
    Hillingdon£19,491,7973,441,300£5.08£5.72£0£0£791,000£125,000£124,800£204,000£0£204,000
    Hounslow£17,266,4672,968,825£5.76£6.09£0£292,785£0£100,800£133,329£800,000£0£800,000
    Kingston upon Thames£11,137,4001,982,547£5.49£5.90£0£348,200£0£44,000£66,800£563,200£0£563,200
    Merton£12,568,7352,364,308£5.16£5.56£0£703,382£227,734£56,800£108,301£568,132£0£568,132
    Redbridge£19,316,3693,840,233£4.90£5.19£0£1,059,904£207,373£80,800£118,849£614,437£0£614,437
    Richmond upon Thames£13,023,6002,393,088£5.31£5.76£0£192,300£0£47,200£39,400£764,500£0£764,500
    Sutton£12,492,5602,250,892£5.12£5.62£0£575,400£37,000£64,800£84,400£167,200£0£167,200
    Waltham Forest£17,922,1673,342,525£5.12£5.59£0£973,373£60,000£76,000£123,493£778,698£0£778,698

    Footnotes

    1. To reduce burdens on local authorities during the COVID-19 pandemic, data for 2020-21 was not collected.

    Save table

    Download Table

    Select file format:

    Related information

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