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
    2023-24
  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 is the latest data
    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 148 other locations for 2023-24
    2023-24
    Number 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 oldsTotal planned spend via early years single funding formula (EYSFF) - 3 and 4 year olds
    North EastCounty Durham5,555,384£4.22£4.91£0£1,283,000£0£250,056£544,032£443,000£0£443,000£26,815,323
    Darlington1,252,645£4.70£5.16£0£113,754£0£38,916£97,892£220,000£0£220,000£6,247,441
    Gateshead2,304,100£4.18£4.89£0£376,709£0£87,768£182,560£171,897£0£171,897£11,085,490
    Hartlepool1,034,995£4.56£4.84£0£263,406£0£51,336£178,369£31,609£0£31,609£4,972,905
    Middlesbrough1,828,976£4.58£5.15£0£144,531£0£86,112£248,819£150,000£0£150,000£9,271,014
    Newcastle upon Tyne3,012,226£4.75£5.33£0£623,639£695,560£129,996£400,894£250,000£0£250,000£15,807,330
    North Tyneside2,548,220£4.64£4.95£0£656,297£0£92,736£120,934£200,000£0£200,000£12,403,783
    Northumberland3,222,629£4.58£4.86£0£859,830£0£109,296£225,505£0£145,000£145,000£15,526,470
    Redcar and Cleveland1,343,832£4.37£4.79£0£0£0£63,200£117,648£150,000£0£150,000£6,284,046
    South Tyneside1,638,722£4.33£5.13£0£417,900£0£76,176£149,623£0£47,000£47,000£8,367,819
    Stockton-on-Tees2,213,636£4.36£4.78£0£556,423£0£115,920£190,437£120,000£0£120,000£10,452,029
    Sunderland2,989,924£4.53£5.50£0£700,000£0£191,268£387,634£500,000£0£500,000£15,952,811
    North WestBlackburn with Darwen1,904,127£4.60£5.10£0£621,000£3,400£57,132£113,696£25,000£145,000£170,000£9,532,084
    Blackpool1,465,963£4.59£4.82£0£292,294£0£74,520£117,916£60,000£30,000£90,000£6,980,604
    Bolton3,877,155£4.52£4.97£0£824,000£0£148,200£289,600£500,000£0£500,000£18,760,200
    Bury2,236,284£4.57£4.92£258,720£310,000£640,000£86,112£157,889£200,000£0£200,000£10,810,998
    Cheshire East4,719,115£4.48£4.73£0£1,149,105£0£159,804£132,066£0£465,000£465,000£21,835,362
    Cheshire West and Chester4,114,217£4.34£4.65£0£0£818,756£115,920£154,447£479,469£200,000£679,469£18,457,054
    Cumberland2,829,437£4.48£4.84£0£333,531£249,635£107,640£155,519£196,853£0£196,853£13,488,864
    Halton1,472,330£4.65£5.38£0£274,339£8,593£62,100£164,013£75,000£0£75,000£7,850,038
    Knowsley2,204,888£4.53£5.13£0£585,214£42,241£105,984£176,347£110,000£0£110,000£11,205,687
    Lancashire14,315,440£4.75£5.16£0£0£0£437,184£974,805£500,000£0£500,000£73,400,504
    Liverpool5,796,210£4.52£5.11£0£1,492,383£3,030,661£284,832£563,486£820,000£0£820,000£28,817,070
    Manchester6,151,060£4.70£5.30£0£783,734£97,097£269,928£856,335£0£489,063£489,063£32,133,393
    Oldham3,160,764£4.60£4.80£0£686,536£0£129,996£270,016£194,000£0£194,000£14,986,556
    Rochdale2,759,780£4.44£4.87£0£641,600£81,006£133,308£273,044£280,000£0£280,000£13,147,764
    Salford3,574,965£4.32£4.98£0£958,489£400,000£166,428£313,703£500,000£0£500,000£17,298,685
    Sefton3,075,047£4.49£4.95£0£184,500£30,750£96,900£182,000£276,750£61,500£338,250£14,889,063
    St. Helens2,097,278£4.44£4.73£0£523,000£159,051£86,940£148,782£250,000£0£250,000£9,663,341
    Stockport3,954,601£4.56£4.96£0£710,000£70,000£109,000£219,000£500,000£0£500,000£19,096,468
    Tameside2,882,262£4.49£4.86£0£760,050£0£131,652£204,290£500,000£0£500,000£13,518,361
    Trafford3,264,361£4.38£4.81£0£770,004£55,000£73,692£111,887£719,000£0£719,000£14,970,403
    Warrington2,593,352£4.91£5.08£0£32,376£19,574£74,520£145,948£0£235,000£235,000£12,932,572
    Westmorland and Furness2,278,011£4.48£4.77£0£272,455£191,934£46,368£121,634£157,147£0£157,147£10,711,219
    Wigan3,975,885£4.57£4.76£0£765,807£0£111,780£173,414£100,000£0£100,000£18,844,260
    Wirral3,708,157£4.22£5.04£0£107,932£274,243£149,040£255,049£450,000£225,000£675,000£18,001,098
    Yorkshire and The HumberBarnsley2,763,913£4.57£4.75£0£583,529£0£111,780£170,693£100,000£0£100,000£13,037,496
    Bradford6,724,276£4.46£5.19£0£649,330£0£120,000£437,089£550,000£0£550,000£34,349,007
    Calderdale2,521,664£4.61£4.90£0£543,056£0£107,640£209,952£0£450,000£450,000£11,895,726
    Doncaster3,539,147£4.50£4.82£0£792,470£0£136,620£316,240£0£304,308£304,308£16,761,701
    East Riding of Yorkshire3,623,270£4.57£4.83£0£360,000£0£101,016£134,222£0£101,016£101,016£17,393,304
    Kingston upon Hull, City of2,915,224£4.38£4.80£0£677,525£0£30,000£518,721£300,000£138,600£438,600£13,552,870
    Kirklees5,061,829£4.70£4.81£0£744,100£0£149,040£481,310£50,000£50,000£100,001£24,236,802
    Leeds9,351,859£4.84£5.08£0£1,832,000£0£292,000£606,000£467,000£0£467,000£47,037,998
    North East Lincolnshire1,794,695£4.57£4.89£0£435,910£0£60,444£156,415£0£270,000£270,000£8,503,674
    North Lincolnshire1,650,078£4.58£4.81£0£393,000£0£48,057£205,686£0£275,000£275,000£7,658,658
    North Yorkshire6,586,538£4.57£4.79£0£1,559,100£0£159,804£290,619£0£591,800£591,800£30,931,369
    Rotherham3,052,348£4.56£5.14£0£748,319£0£145,728£336,211£484,560£0£484,560£15,215,582
    Sheffield6,036,923£4.59£4.94£0£1,555,824£0£258,336£787,146£630,000£0£630,000£29,215,048
    Wakefield4,113,575£4.70£4.89£0£812,177£0£178,020£414,493£200,000£0£200,000£19,898,721
    York2,108,688£4.53£4.70£0£509,180£0£52,992£109,784£20,000£105,000£125,000£9,783,263
    East MidlandsDerby3,195,821£4.70£5.33£492,628£470,000£112,477£137,448£322,135£0£450,000£450,000£16,567,834
    Derbyshire7,869,420£4.47£4.86£0£1,396,223£57,000£258,336£500,606£0£163,200£163,200£38,098,052
    Leicester4,130,512£4.42£4.83£0£231,463£0£101,016£481,204£1,026,000£0£1,026,000£18,904,845
    Leicestershire7,242,665£4.44£4.54£0£1,681,915£946,000£232,668£372,767£311,452£0£311,452£32,557,282
    Lincolnshire7,615,894£4.42£4.75£723,163£1,676,905£0£274,896£798,596£698,370£0£698,370£35,486,865
    North Northamptonshire4,000,000£4.25£4.78£0£991,385£736,315£125,856£252,982£300,000£0£300,000£18,816,850
    Nottingham3,219,244£4.96£5.41£0£960,000£0£134,136£389,861£283,000£0£283,000£17,136,697
    Nottinghamshire9,448,900£4.70£4.88£0£1,214,416£0£267,444£765,005£250,000£300,000£550,000£45,529,600
    Rutland344,044£4.64£4.79£0£83,775£0£10,764£6,316£0£50,000£50,000£1,596,906
    West Northamptonshire5,036,712£4.29£4.74£0£1,240,000£570,000£140,000£245,000£1,030,000£0£1,030,000£22,867,494
    West MidlandsBirmingham13,384,123£4.70£5.47£0£3,400,000£0£570,492£1,471,434£1,250,000£0£1,250,000£71,897,058
    Coventry4,104,443£4.43£4.88£0£1,042,528£0£152,352£401,530£313,910£0£313,910£19,723,272
    Dudley3,452,908£4.48£4.73£0£419,100£409,438£128,340£286,530£120,000£0£120,000£16,205,919
    Herefordshire, County of1,920,312£4.48£4.74£0£39,300£0£49,680£122,598£0£140,000£140,000£8,967,723
    Sandwell4,035,790£4.44£4.82£0£1,046,286£150,000£134,964£339,452£480,000£0£480,000£18,971,268
    Shropshire3,366,632£4.44£4.68£0£376,340£0£86,940£145,008£300,000£0£300,000£15,447,846
    Solihull2,933,881£4.45£4.76£0£750,399£40,986£101,016£216,069£250,000£135,000£385,000£13,582,360
    Staffordshire10,133,351£4.52£4.72£0£2,484,470£202,670£245,916£552,393£970,000£0£970,000£46,870,033
    Stoke-on-Trent2,953,696£4.56£4.85£0£601,269£182,000£118,404£451,575£100,000£0£100,000£14,231,983
    Telford and Wrekin2,283,602£4.30£4.96£0£190,000£0£93,564£185,325£170,000£0£170,000£11,165,410
    Walsall3,238,005£4.86£5.43£0£400,000£500,001£139,992£294,665£70,000£0£70,000£17,515,292
    Warwickshire6,859,619£4.54£4.83£0£1,660,030£0£199,548£226,920£0£485,000£485,000£32,677,742
    Wolverhampton2,960,026£4.56£5.56£0£0£118,395£107,640£377,760£266,402£0£266,402£16,184,195
    Worcestershire6,560,165£4.60£4.97£0£1,590,000£300,000£205,344£293,655£529,000£1,420,000£1,949,000£30,642,201
    East of EnglandBedford2,193,125£4.86£5.59£0£782,424£0£44,712£163,197£217,988£593,220£811,208£11,444,563
    Cambridgeshire6,844,033£4.63£5.07£0£0£1,200,000£213,624£443,740£975,813£0£975,813£33,709,957
    Central Bedfordshire3,635,148£4.48£4.91£0£795,000£190,252£111,780£191,201£500,000£0£500,000£17,333,861
    Essex16,264,356£4.77£5.03£0£3,213,027£3,610,021£616,032£723,900£0£2,599,822£2,599,822£79,227,398
    Hertfordshire14,611,861£5.47£5.93£0£2,722,276£0£388,000£1,054,000£598,000£0£598,000£85,980,111
    Luton2,763,299£4.84£5.59£0£208,929£334,008£108,468£252,339£386,919£0£386,919£15,058,122
    Norfolk8,376,828£4.31£4.68£0£2,052,320£210,784£275,724£631,229£850,000£0£850,000£38,316,803
    Peterborough2,848,425£5.43£5.99£0£586,555£170,000£85,179£192,167£20,000£439,000£459,000£16,592,185
    Southend-on-Sea1,861,899£4.83£5.01£0£273,295£0£78,660£198,747£65,000£100,000£165,000£9,156,821
    Suffolk6,828,591£4.60£4.71£0£1,338,962£0£187,575£322,628£170,126£0£170,126£32,001,635
    Thurrock2,240,304£4.79£5.05£0£490,000£0£83,628£67,652£260,000£0£260,000£11,063,844
    South EastBracknell Forest1,406,346£4.92£5.30£0£398,042£103,491£40,042£55,590£103,491£0£103,491£7,355,809
    Brighton and Hove2,617,203£4.56£5.29£0£543,073£0£105,894£191,561£489,700£430,000£919,700£12,932,249
    Buckinghamshire6,329,878£4.77£5.02£0£1,666,827£315,269£147,384£206,665£440,010£0£440,010£31,340,700
    East Sussex5,019,459£4.61£4.74£0£934,600£0£162,288£303,649£305,900£0£305,900£23,474,675
    Hampshire15,083,567£4.77£5.10£0£4,022,562£1,200,396£450,000£734,000£1,417,000£0£1,417,000£75,441,604
    Isle of Wight1,186,042£4.16£4.63£0£288,871£0£52,992£89,439£127,675£0£127,675£5,360,908
    Kent16,902,811£4.55£5.03£0£3,847,900£0£737,748£841,818£0£1,640,400£1,640,400£83,393,018
    Medway3,348,750£4.24£4.78£0£842,211£0£119,232£176,160£160,020£0£160,020£15,839,588
    Milton Keynes3,636,292£4.91£5.22£0£593,000£1,723,983£95,220£173,841£280,000£79,000£359,000£18,622,094
    Oxfordshire7,853,437£4.58£4.92£0£1,646,603£0£211,968£371,162£823,566£0£823,566£37,797,017
    Portsmouth2,346,810£4.69£4.96£0£610,200£140,800£89,400£173,600£93,872£0£93,872£11,546,304
    Reading1,874,948£5.33£5.99£0£738,600£0£56,304£138,692£50,000£250,000£300,000£10,935,396
    Slough2,059,357£5.82£6.41£0£648,854£63,826£52,164£128,051£80,000£0£80,000£13,128,263
    Southampton2,514,159£5.03£5.74£0£761,300£234,000£127,512£225,353£141,200£0£141,200£14,284,598
    Surrey13,088,647£5.14£5.72£0£3,675,455£22,778£410,688£396,745£4,416,200£0£4,416,200£70,487,144
    West Berkshire1,735,977£4.69£5.41£0£446,434£0£43,060£78,917£108,000£0£108,000£9,290,075
    West Sussex9,476,256£4.97£5.18£0£2,534,732£0£302,220£489,315£691,991£0£691,991£48,360,315
    Windsor and Maidenhead1,779,306£4.82£5.66£0£290,000£80,000£33,948£41,182£180,000£0£180,000£9,896,620
    Wokingham2,094,908£5.06£5.45£0£562,015£0£52,164£61,729£150,000£0£150,000£11,256,920
    South WestBath and North East Somerset2,005,665£4.54£4.85£0£487,752£0£63,756£100,755£0£458,734£458,734£9,267,320
    Bournemouth, Christchurch and Poole3,931,404£4.49£4.84£0£117,942£0£118,404£117,418£1,061,479£0£1,061,479£17,966,516
    Bristol, City of5,499,537£4.94£5.98£0£1,502,000£0£151,524£382,528£1,828,597£0£1,828,597£31,066,275
    Cornwall5,420,925£4.70£4.86£0£361,000£189,000£165,600£279,717£0£250,000£250,000£26,076,867
    Devon7,691,646£4.46£4.84£0£1,018,557£153,830£248,000£480,000£1,293,235£0£1,293,235£35,905,734
    Dorset3,003,155£4.41£4.68£0£700,500£35,129£81,972£147,149£20,000£0£20,000£14,019,822
    Gloucestershire7,011,114£4.50£4.76£0£2,364,100£233,893£431,746£343,555£149,529£452,538£602,067£32,741,902
    Isles of Scilly17,107£4.87£5.05£0£73,498£0£0£0£3,000£0£3,000£83,310
    North Somerset2,224,995£4.40£4.84£0£221,983£23,888£69,552£92,747£411,459£169,985£581,444£10,196,071
    Plymouth2,763,542£4.47£5.01£0£687,896£0£125,856£155,684£442,392£22,500£464,892£13,392,620
    Somerset5,692,034£4.65£4.86£0£830,900£0£155,700£141,500£0£777,000£777,000£26,866,400
    South Gloucestershire3,637,888£4.51£4.89£0£889,472£0£91,910£115,580£342,080£900,040£1,242,120£16,558,975
    Swindon2,859,907£4.34£4.84£0£726,400£0£77,000£219,900£400,000£0£400,000£13,451,401
    Torbay1,321,551£4.40£4.76£0£326,970£0£62,928£105,816£175,000£86,230£261,230£6,035,251
    Wiltshire6,059,690£4.68£4.81£0£468,700£0£175,500£183,400£539,000£0£539,000£28,584,660
    Inner LondonCamden1,554,537£6.65£8.13£47,652£299,383£0£28,800£116,280£462,000£250,000£712,000£11,927,680
    City of London38,376£8.40£8.94£0£0£0£0£0£10,000£10,000£20,000£323,138
    Hackney4,015,930£5.36£6.37£0£1,313,209£0£155,664£232,866£1,312,364£0£1,312,364£24,272,292
    Hammersmith and Fulham1,586,424£6.48£8.50£0£650,000£20,000£55,476£94,228£547,318£0£547,318£12,940,432
    Haringey2,654,365£5.33£6.50£0£819,016£166,436£91,908£145,601£393,168£273,999£667,167£16,586,921
    Islington1,958,550£6.20£8.49£0£783,114£112,484£118,404£199,530£1,327,916£1,496,904£2,824,820£13,799,776
    Kensington and Chelsea1,352,033£7.19£8.12£0£570,000£430,000£23,184£82,873£150,000£0£150,000£10,834,787
    Lambeth3,083,860£6.33£7.36£0£1,104,990£0£77,832£260,810£370,064£0£370,064£22,336,226
    Lewisham3,501,499£5.51£6.12£0£1,085,465£462,408£124,200£89,644£854,249£0£854,249£20,586,341
    Newham4,131,440£5.38£6.33£0£1,137,600£0£134,137£112,735£942,077£0£942,077£25,227,810
    Southwark2,852,205£6.15£7.24£0£875,001£0£111,780£293,489£250,000£0£250,000£20,408,969
    Tower Hamlets3,057,966£7.40£8.25£0£1,090,274£0£120,888£260,647£642,173£0£642,173£24,585,033
    Wandsworth3,354,736£5.80£6.56£0£1,077,520£735,076£113,436£154,083£1,014,464£0£1,014,464£20,984,221
    Westminster1,228,150£7.00£8.51£0£497,000£283,000£57,960£122,630£170,000£0£170,000£10,283,516
    Outer LondonBarking and Dagenham3,051,005£6.01£6.64£0£0£0£114,264£214,981£910,049£0£910,049£19,338,948
    Barnet4,411,034£5.87£6.26£0£1,414,048£0£150,696£173,333£400,000£0£400,000£27,211,413
    Bexley2,976,237£5.22£5.48£0£519,400£0£73,069£89,859£110,000£0£110,000£16,196,366
    Brent3,379,097£4.84£5.86£0£998,265£0£119,232£92,945£439,003£0£439,003£19,366,044
    Bromley3,563,173£5.20£5.42£0£836,069£0£96,050£128,180£410,670£0£410,670£18,918,170
    Croydon4,517,953£5.78£6.32£0£773,292£0£134,136£168,855£188,000£1,200,000£1,388,000£27,159,316
    Ealing3,739,091£4.73£6.27£181,374£1,186,000£773,000£107,640£157,440£2,118,000£769,754£2,887,754£20,556,796
    Enfield3,602,326£5.44£5.82£0£1,103,479£0£152,352£251,925£468,798£0£468,798£20,497,234
    Greenwich3,497,444£5.47£6.69£0£1,176,891£466,920£120,888£296,015£1,398,977£535,096£1,934,073£21,446,981
    Harrow2,907,285£4.90£5.78£0£876,548£0£62,928£122,560£832,719£0£832,719£15,965,084
    Havering3,330,463£5.34£5.68£0£790,000£0£112,608£120,365£420,044£149,283£569,327£18,361,780
    Hillingdon3,751,164£6.00£7.21£0£293,000£0£114,000£185,000£2,200,000£0£2,200,000£24,842,124
    Hounslow3,049,212£5.99£6.34£0£307,000£0£101,016£136,848£890,000£0£890,000£18,434,563
    Kingston upon Thames1,968,690£5.65£6.02£0£217,200£137,000£56,300£67,500£300,000£0£300,000£11,552,100
    Merton2,439,562£6.18£6.29£0£0£0£67,068£101,780£8,151£0£8,151£15,335,905
    Redbridge4,022,701£5.06£5.35£0£1,144,458£223,260£96,876£107,187£643,632£0£643,632£20,877,818
    Richmond upon Thames2,328,723£5.63£5.83£0£198,300£234,200£53,000£51,100£249,000£0£249,000£13,326,900
    Sutton2,260,004£5.36£6.01£0£620,400£302,800£79,500£85,600£177,000£0£177,000£13,407,036
    Waltham Forest3,469,458£5.14£5.85£0£1,045,189£0£99,360£159,670£940,670£0£940,670£19,341,127

    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)