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 2 year olds (spend per hour)
    • Average funding rate for 2 year olds (spend per hour)
    • Number of hours funded for 2 year olds (millions)
    • 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.
    '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) - 2 year oldsNumber of hours funded for 2 year olds (millions)Average base rate for entitlement hours for 2 year olds (spend per hour)Average funding rate for 2 year olds (spend per hour)Other spend on early education - centrally retained budget for 2 year oldsOther spend on early education - contingency budget for 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 olds
    North EastCounty Durham£4,651,474850,361£5.47£5.47£86,620£0£0£0£0
    Darlington£1,005,903180,593£5.57£5.57£0£0£0£0£0
    Gateshead£1,943,198348,869£5.57£5.64£0£0£24,957£0£24,957
    Hartlepool£1,197,065221,269£5.41£5.41£0£0£0£0£0
    Middlesbrough£2,546,905457,254£5.57£5.57£0£0£0£0£0
    Newcastle upon Tyne£3,319,741596,004£5.57£5.57£0£0£0£0£0
    North Tyneside£1,792,866323,622£5.54£5.54£0£0£0£0£0
    Northumberland£2,295,960412,201£5.57£5.57£0£0£0£0£0
    Redcar and Cleveland£1,434,420266,126£5.39£5.39£0£0£0£0£0
    South Tyneside£1,633,804293,322£5.57£5.57£0£0£0£0£0
    Stockton-on-Tees£1,949,389355,728£5.48£5.48£0£0£0£0£0
    Sunderland£2,867,157514,750£5.57£5.57£0£0£0£0£0
    North WestBlackburn with Darwen£1,644,650317,500£5.18£5.18£104,000£0£0£0£0
    Blackpool£1,499,590278,217£5.39£5.50£50,079£0£30,000£0£30,000
    Bolton£2,728,993498,902£5.47£5.47£141,000£0£0£0£0
    Bury£2,028,527364,843£5.56£5.83£100,000£50,000£100,000£0£100,000
    Cheshire East£1,779,375331,355£5.37£5.49£31,424£31,424£39,804£0£39,804
    Cheshire West and Chester£2,499,446453,620£5.51£5.60£25,000£0£40,000£0£40,000
    Cumbria£3,136,012563,018£5.57£5.59£100,000£118,918£12,000£0£12,000
    Halton£1,455,667274,137£5.31£5.31£45,908£0£0£0£0
    Knowsley£1,809,864335,160£5.40£5.40£18,735£44,945£0£0£0
    Lancashire£9,916,5021,846,648£5.37£5.37£0£0£0£0£0
    Liverpool£5,363,436976,946£5.49£5.49£76,853£0£0£0£0
    Manchester£7,124,3621,281,360£5.56£5.56£128,634£0£0£0£0
    Oldham£3,186,670590,124£5.40£5.40£167,719£0£0£0£0
    Rochdale£2,632,913478,711£5.50£5.50£75,000£0£0£0£0
    Salford£3,125,955592,037£5.28£5.33£197,950£0£30,000£0£30,000
    Sefton£2,160,161408,348£5.29£5.29£122,504£0£0£0£0
    St. Helens£1,589,069298,697£5.32£5.32£80,648£0£0£0£0
    Stockport£2,213,786406,946£5.44£5.44£0£0£0£0£0
    Tameside£2,783,734515,506£5.40£5.52£65,940£0£61,000£0£61,000
    Trafford£1,621,394304,773£5.32£5.32£106,671£0£0£0£0
    Warrington£1,342,765255,765£5.25£5.25£0£0£0£0£0
    Wigan£3,196,458573,870£5.57£5.57£0£57,387£0£0£0
    Wirral£3,140,470572,035£5.49£5.49£431,964£0£0£0£0
    Yorkshire and The HumberBarnsley£2,211,987416,570£5.31£5.36£96,471£0£19,949£0£19,949
    Bradford£6,711,3431,209,251£5.55£5.63£0£0£100,000£0£100,000
    Calderdale£2,218,842402,598£5.51£5.81£21,700£0£0£120,000£120,000
    Doncaster£3,305,007593,359£5.57£5.64£0£0£0£43,070£43,070
    East Riding of Yorkshire£1,623,872291,539£5.57£5.57£0£0£0£0£0
    Kingston upon Hull, City of£3,127,254571,710£5.47£5.52£169,648£0£30,000£0£30,000
    Kirklees£4,148,846771,161£5.38£5.38£0£0£0£0£0
    Leeds£7,449,8691,337,499£5.57£5.57£0£0£0£0£0
    North East Lincolnshire£1,627,759303,121£5.37£5.37£85,672£0£0£0£0
    North Lincolnshire£1,377,265247,265£5.57£5.72£0£0£0£37,500£37,500
    North Yorkshire£3,197,508580,310£5.51£5.64£32,000£0£0£72,600£72,600
    Rotherham£2,572,527461,854£5.57£5.90£0£0£151,200£0£151,200
    Sheffield£4,290,782808,057£5.31£5.31£225,831£0£0£0£0
    Wakefield£3,109,349566,366£5.49£5.58£0£0£51,360£0£51,360
    York£1,016,854182,559£5.57£5.57£0£0£0£0£0
    East MidlandsDerby£2,440,673438,182£5.57£5.57£0£0£0£0£0
    Derbyshire£4,031,615723,809£5.57£5.57£0£0£0£0£0
    Leicester£2,949,292562,842£5.24£5.24£0£0£0£0£0
    Leicestershire£2,670,617506,759£5.27£5.29£133,531£0£7,741£0£7,741
    Lincolnshire£5,023,435960,504£5.23£5.23£43,573£321,147£0£0£0
    North Northamptonshire£1,753,670323,555£5.42£5.42£0£0£0£0£0
    Nottingham£3,290,029601,468£5.47£5.49£65,000£0£10,000£0£10,000
    Nottinghamshire£4,967,663887,083£5.60£5.60£0£0£0£0£0
    Rutland£86,48415,527£5.57£5.57£0£0£0£0£0
    West Northamptonshire£1,850,708341,459£5.42£5.42£0£0£0£0£0
    West MidlandsBirmingham£11,583,2532,064,751£5.61£5.61£0£0£0£0£0
    Coventry£3,249,236614,222£5.29£5.35£85,849£0£39,022£0£39,022
    Dudley£2,673,851476,622£5.61£5.61£0£0£0£0£0
    Herefordshire, County of£980,854176,096£5.57£5.63£37,288£0£0£10,000£10,000
    Sandwell£4,493,320803,814£5.59£5.59£0£0£0£0£0
    Shropshire£1,524,362291,465£5.23£5.57£0£330,791£100,000£0£100,000
    Solihull£1,731,778308,695£5.61£5.61£75,000£0£0£0£0
    Staffordshire£7,414,0221,355,397£5.47£5.47£0£297,050£0£0£0
    Stoke-on-Trent£2,933,006526,572£5.57£5.57£0£0£0£0£0
    Telford and Wrekin£1,749,944319,333£5.48£5.58£0£0£31,056£0£31,056
    Walsall£3,305,877606,583£5.45£5.48£100,000£100,000£20,000£0£20,000
    Warwickshire£2,982,042526,863£5.66£5.66£0£0£0£0£0
    Wolverhampton£2,575,780459,141£5.61£5.61£0£0£0£0£0
    Worcestershire£3,113,527570,243£5.46£5.92£50,000£0£0£261,000£261,000
    East of EnglandBedford£990,965177,911£5.57£5.57£30,505£0£0£0£0
    Cambridgeshire£2,295,070397,071£5.78£5.78£0£0£0£0£0
    Central Bedfordshire£1,413,613254,705£5.55£5.55£0£0£0£0£0
    Essex£9,322,4961,691,923£5.51£5.51£477,718£0£0£0£0
    Hertfordshire£7,411,6181,295,737£5.72£5.72£243,383£0£0£0£0
    Luton£2,446,233448,850£5.45£5.53£204,278£0£34,200£0£34,200
    Norfolk£4,192,842762,335£5.50£5.57£0£0£50,000£0£50,000
    Peterborough£2,374,850439,787£5.40£5.40£50,712£0£0£0£0
    Southend-on-Sea£1,231,353221,069£5.57£5.57£8,843£0£0£0£0
    Suffolk£4,611,794827,970£5.57£5.57£0£0£0£0£0
    Thurrock£1,036,400171,874£6.03£6.44£0£0£70,000£0£70,000
    South EastBracknell Forest£524,64090,299£5.81£5.94£28,219£0£11,511£0£11,511
    Brighton and Hove£1,673,205300,396£5.57£5.94£73,572£0£0£111,300£111,300
    Buckinghamshire£2,398,035414,168£5.79£5.89£151,545£0£40,000£0£40,000
    East Sussex£3,225,635576,072£5.60£5.68£0£0£0£44,100£44,100
    Hampshire£5,658,0001,017,626£5.56£5.63£164,000£22,000£75,000£0£75,000
    Isle of Wight£828,294150,873£5.49£5.57£34,779£0£12,026£0£12,026
    Kent£8,115,6071,505,678£5.39£5.39£425,900£0£0£0£0
    Medway£1,955,808367,633£5.32£5.37£102,937£0£18,105£0£18,105
    Milton Keynes£2,125,685390,034£5.45£5.45£0£0£0£0£0
    Oxfordshire£2,961,038502,723£5.89£5.89£0£0£0£0£0
    Portsmouth£1,586,475294,884£5.38£5.42£73,700£38,300£11,795£0£11,795
    Reading£1,247,673211,470£5.90£5.90£0£0£0£0£0
    Slough£1,043,812175,726£5.94£5.94£54,914£0£0£0£0
    Southampton£2,087,033377,402£5.53£5.53£0£0£0£0£0
    Surrey£4,387,857715,800£6.13£6.43£0£0£215,000£0£215,000
    West Berkshire£736,937129,061£5.71£5.71£31,150£0£0£0£0
    West Sussex£4,427,324809,383£5.47£5.67£0£0£161,878£0£161,878
    Windsor and Maidenhead£567,70893,681£6.06£6.17£0£0£10,000£0£10,000
    Wokingham£410,41669,562£5.90£5.90£42,396£0£0£0£0
    South WestBath and North East Somerset£828,878142,910£5.80£5.80£0£0£0£0£0
    Bournemouth, Christchurch and Poole£2,307,217436,973£5.28£5.44£69,916£0£69,916£0£69,916
    Bristol, City of£3,088,271535,229£5.77£5.77£15,974£0£0£0£0
    Cornwall£3,252,022583,846£5.57£5.57£0£0£0£0£0
    Devon£4,255,003808,936£5.26£5.26£105,505£39,347£0£0£0
    Dorset£1,725,564308,136£5.60£5.60£0£0£0£0£0
    Gloucestershire£2,918,230552,695£5.28£5.28£0£131,346£0£0£0
    Isles of Scilly£31,8215,713£5.57£5.57£0£0£0£0£0
    North Somerset£1,167,551207,013£5.64£5.92£143,961£0£36,845£21,865£58,710
    Plymouth£1,961,104352,083£5.57£5.60£0£0£11,744£0£11,744
    Somerset£2,405,700445,500£5.40£5.40£39,900£0£0£0£0
    South Gloucestershire£1,445,907262,415£5.51£5.51£76,100£0£0£0£0
    Swindon£1,711,360310,029£5.52£5.52£52,642£0£0£0£0
    Torbay£864,400167,195£5.17£5.35£46,550£0£20,000£10,260£30,260
    Wiltshire£2,174,860382,225£5.69£5.69£0£0£0£0£0
    Inner LondonCamden£2,061,426254,497£8.10£8.83£200,000£0£185,000£0£185,000
    City of London£9,9451,170£8.50£8.50£0£0£0£0£0
    Hackney£4,468,897660,103£6.77£6.77£0£66,010£0£0£0
    Hammersmith and Fulham£1,197,639174,329£6.87£6.87£0£0£0£0£0
    Haringey£2,058,823341,430£6.03£6.15£0£0£0£42,000£42,000
    Islington£2,233,459307,710£7.26£7.26£104,691£0£0£0£0
    Kensington and Chelsea£644,28293,782£6.87£6.87£0£0£0£0£0
    Lambeth£2,896,014421,545£6.87£6.87£0£0£0£0£0
    Lewisham£2,303,980372,210£6.19£6.19£0£0£0£0£0
    Newham£3,291,711559,815£5.88£5.88£0£0£0£0£0
    Southwark£2,836,209411,251£6.90£6.90£149,274£0£0£0£0
    Tower Hamlets£2,281,535336,014£6.79£6.79£26,890£0£0£0£0
    Wandsworth£1,557,197226,666£6.87£6.87£0£0£0£0£0
    Westminster£1,174,770171,000£6.87£6.87£0£0£0£0£0
    Outer LondonBarking and Dagenham£3,776,117655,576£5.76£5.95£195,532£0£122,305£0£122,305
    Barnet£2,822,707448,761£6.29£6.29£0£0£0£0£0
    Bexley£1,293,526214,515£6.03£6.03£193,500£0£0£0£0
    Brent£2,793,511453,492£6.16£6.16£58,954£0£0£0£0
    Bromley£1,826,518313,835£5.82£5.82£430,000£0£0£0£0
    Croydon£2,591,917429,837£6.03£6.03£0£0£0£0£0
    Ealing£2,598,267413,079£6.29£6.29£0£0£0£0£0
    Enfield£3,433,253569,362£6.03£6.03£0£0£0£0£0
    Greenwich£2,477,643389,567£6.36£6.86£0£0£194,783£0£194,783
    Harrow£1,599,008254,214£6.29£6.29£0£0£0£0£0
    Havering£1,663,110278,578£5.97£5.97£0£0£0£0£0
    Hillingdon£1,403,845226,062£6.21£6.21£0£0£0£0£0
    Hounslow£2,892,903459,921£6.29£6.29£20,000£0£0£0£0
    Kingston upon Thames£959,000153,195£6.26£6.26£0£0£0£0£0
    Merton£1,252,449199,175£6.29£6.29£0£0£0£0£0
    Redbridge£2,051,949340,290£6.03£6.03£0£0£0£0£0
    Richmond upon Thames£773,800127,270£6.08£6.08£0£0£0£0£0
    Sutton£1,182,299192,871£6.13£6.29£0£0£30,000£0£30,000
    Waltham Forest£1,839,411306,569£6.00£6.00£96,811£225,900£0£0£0

    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)