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

   • Publication: Planned LA and school expenditure

2. Step 2

   • Data set: Early years - unrounded data

3. Step 3

   • Local authority:
     • Barking and Dagenham
     • Barnet
     • Barnsley
     • Bath and North East Somerset
     • Bedford

4. Step 4

   • Time period: 2023-24

5. Step 5

   • 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 Explore data

   This is the latest data

   Some 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 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 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 via early years single funding formula (EYSFF) - 2 year olds
   North East	County Durham	984,724	£5.53	£5.53	£100,283	£0	£0	£0	£0	£5,445,524
   	Darlington	193,589	£5.63	£5.63	£0	£0	£0	£0	£0	£1,089,906
   	Gateshead	325,013	£5.63	£5.71	£0	£184,723	£27,420	£0	£27,420	£1,829,820
   	Hartlepool	250,515	£5.63	£5.63	£0	£0	£0	£0	£0	£1,410,399
   	Middlesbrough	444,030	£5.63	£5.63	£0	£0	£0	£0	£0	£2,499,889
   	Newcastle upon Tyne	558,341	£5.63	£5.63	£0	£0	£0	£0	£0	£3,143,460
   	North Tyneside	324,560	£5.60	£5.60	£0	£0	£0	£0	£0	£1,817,538
   	Northumberland	442,047	£5.63	£5.68	£0	£0	£0	£20,000	£20,000	£2,488,722
   	Redcar and Cleveland	273,451	£5.45	£5.45	£0	£0	£0	£0	£0	£1,490,307
   	South Tyneside	294,753	£5.63	£5.63	£0	£0	£0	£0	£0	£1,659,459
   	Stockton-on-Tees	376,907	£5.54	£5.54	£0	£0	£0	£0	£0	£2,088,066
   	Sunderland	503,692	£5.63	£5.63	£0	£0	£0	£0	£0	£2,835,786
   North West	Blackburn with Darwen	290,200	£5.23	£5.23	£116,100	£0	£0	£0	£0	£1,517,746
   	Blackpool	307,840	£5.48	£5.48	£46,176	£0	£0	£0	£0	£1,686,963
   	Bolton	469,946	£5.53	£5.53	£141,000	£0	£0	£0	£0	£2,598,800
   	Bury	278,522	£5.62	£5.98	£104,190	£309,000	£100,000	£0	£100,000	£1,565,294
   	Cheshire East	348,866	£5.43	£5.53	£27,441	£27,441	£34,758	£0	£34,758	£1,894,342
   	Cheshire West and Chester	458,592	£5.51	£5.60	£0	£25,000	£40,000	£0	£40,000	£2,526,844
   	Cumberland	363,139	£5.63	£5.70	£0	£37,836	£25,580	£0	£25,580	£2,044,471
   	Halton	241,002	£5.37	£5.37	£44,906	£1,407	£0	£0	£0	£1,294,181
   	Knowsley	358,416	£5.46	£5.46	£40,501	£27,599	£0	£0	£0	£1,956,951
   	Lancashire	2,006,958	£5.43	£5.43	£0	£0	£0	£0	£0	£10,897,782
   	Liverpool	967,785	£5.54	£5.54	£119,490	£457,808	£0	£0	£0	£5,361,529
   	Manchester	1,281,360	£5.62	£5.62	£100,841	£0	£0	£0	£0	£7,201,243
   	Oldham	640,238	£5.46	£5.46	£172,729	£0	£0	£0	£0	£3,495,699
   	Rochdale	456,201	£5.56	£5.56	£75,000	£0	£0	£0	£0	£2,536,476
   	Salford	652,366	£5.34	£5.34	£255,822	£0	£0	£0	£0	£3,483,634
   	Sefton	432,887	£5.35	£5.35	£129,850	£0	£0	£0	£0	£2,315,943
   	St. Helens	326,593	£5.48	£5.48	£88,181	£0	£0	£0	£0	£1,789,729
   	Stockport	393,729	£5.50	£5.50	£170,000	£0	£0	£0	£0	£2,165,510
   	Tameside	457,010	£5.46	£5.60	£60,965	£0	£66,000	£0	£66,000	£2,495,272
   	Trafford	305,910	£5.42	£5.42	£107,062	£0	£0	£0	£0	£1,658,032
   	Warrington	259,538	£5.31	£5.31	£0	£0	£0	£0	£0	£1,378,147
   	Westmorland and Furness	211,275	£5.63	£5.73	£0	£465,734	£20,420	£0	£20,420	£1,189,477
   	Wigan	566,968	£5.63	£5.63	£0	£56,697	£0	£0	£0	£3,192,028
   	Wirral	574,457	£5.55	£5.55	£463,727	£0	£0	£0	£0	£3,188,239
   Yorkshire and The Humber	Barnsley	448,497	£5.37	£5.44	£96,471	£0	£30,288	£0	£30,288	£2,408,430
   	Bradford	1,335,915	£5.61	£5.68	£0	£0	£100,000	£0	£100,000	£7,494,486
   	Calderdale	398,326	£5.58	£5.88	£16,500	£0	£0	£120,000	£120,000	£2,222,659
   	Doncaster	656,731	£5.63	£5.63	£0	£0	£0	£0	£0	£3,697,397
   	East Riding of Yorkshire	346,504	£5.63	£5.63	£0	£0	£0	£0	£0	£1,950,818
   	Kingston upon Hull, City of	645,702	£5.53	£5.76	£174,640	£0	£0	£150,000	£150,000	£3,570,732
   	Kirklees	787,475	£5.60	£5.60	£0	£0	£0	£0	£0	£4,409,860
   	Leeds	1,244,123	£5.87	£5.87	£0	£0	£0	£0	£0	£7,303,002
   	North East Lincolnshire	334,481	£5.43	£5.52	£95,591	£0	£0	£30,000	£30,000	£1,816,232
   	North Lincolnshire	226,792	£5.63	£5.63	£0	£0	£0	£0	£0	£1,276,837
   	North Yorkshire	580,744	£5.64	£5.78	£33,000	£0	£0	£81,000	£81,000	£3,275,396
   	Rotherham	494,156	£5.63	£6.01	£0	£0	£188,440	£0	£188,440	£2,782,098
   	Sheffield	957,902	£5.63	£5.63	£0	£0	£0	£0	£0	£5,392,989
   	Wakefield	522,770	£5.63	£5.66	£0	£0	£15,000	£0	£15,000	£2,943,197
   	York	173,548	£5.77	£5.77	£0	£0	£0	£0	£0	£1,001,372
   East Midlands	Derby	481,536	£5.68	£5.68	£0	£0	£0	£0	£0	£2,735,125
   	Derbyshire	825,947	£5.63	£5.63	£0	£0	£0	£0	£0	£4,650,082
   	Leicester	717,985	£5.30	£5.30	£0	£0	£0	£0	£0	£3,805,319
   	Leicestershire	572,651	£5.33	£5.35	£152,611	£0	£9,071	£0	£9,071	£3,052,227
   	Lincolnshire	878,644	£5.29	£5.29	£0	£249,434	£0	£0	£0	£4,648,027
   	North Northamptonshire	403,110	£5.75	£5.75	£0	£0	£0	£0	£0	£2,317,881
   	Nottingham	540,694	£5.66	£5.68	£65,000	£0	£10,000	£0	£10,000	£3,060,330
   	Nottinghamshire	1,057,213	£5.66	£5.66	£0	£0	£0	£0	£0	£5,983,827
   	Rutland	20,828	£5.63	£5.63	£0	£0	£0	£0	£0	£117,261
   	West Northamptonshire	365,899	£5.63	£5.63	£0	£0	£0	£0	£0	£2,060,010
   West Midlands	Birmingham	2,384,481	£5.81	£5.81	£0	£0	£0	£0	£0	£13,853,835
   	Coventry	582,823	£5.55	£5.64	£82,230	£0	£51,090	£0	£51,090	£3,234,665
   	Dudley	509,846	£5.67	£5.67	£0	£0	£0	£0	£0	£2,890,827
   	Herefordshire, County of	198,934	£5.63	£5.68	£353,700	£0	£0	£10,000	£10,000	£1,119,998
   	Sandwell	748,701	£5.81	£5.81	£0	£0	£0	£0	£0	£4,349,951
   	Shropshire	325,830	£5.29	£5.90	£0	£0	£200,000	£0	£200,000	£1,723,641
   	Solihull	334,373	£5.85	£5.85	£75,000	£0	£0	£0	£0	£1,956,084
   	Staffordshire	1,048,920	£5.67	£5.67	£0	£104,890	£0	£0	£0	£5,947,376
   	Stoke-on-Trent	530,895	£5.63	£5.63	£0	£0	£0	£0	£0	£2,988,939
   	Telford and Wrekin	325,636	£5.48	£5.57	£0	£0	£30,000	£0	£30,000	£1,784,485
   	Walsall	677,691	£5.51	£5.54	£100,000	£0	£20,000	£0	£20,000	£3,734,077
   	Warwickshire	535,623	£5.90	£5.90	£0	£0	£0	£0	£0	£3,160,177
   	Wolverhampton	516,200	£5.67	£5.67	£0	£0	£0	£0	£0	£2,926,853
   	Worcestershire	684,676	£5.50	£6.31	£0	£0	£0	£555,000	£555,000	£3,765,718
   East of England	Bedford	196,406	£5.86	£5.86	£75,249	£0	£0	£0	£0	£1,150,939
   	Cambridgeshire	457,733	£6.12	£6.12	£0	£0	£0	£0	£0	£2,801,326
   	Central Bedfordshire	239,514	£5.96	£5.96	£0	£0	£0	£0	£0	£1,427,503
   	Essex	1,721,010	£5.89	£5.89	£0	£0	£0	£0	£0	£10,136,749
   	Hertfordshire	1,320,708	£6.32	£6.32	£245,671	£0	£0	£0	£0	£8,346,875
   	Luton	436,347	£5.61	£5.77	£208,929	£0	£70,000	£0	£70,000	£2,447,907
   	Norfolk	876,361	£5.64	£5.70	£0	£0	£50,000	£0	£50,000	£4,942,678
   	Peterborough	439,076	£6.01	£6.01	£53,849	£30,000	£0	£0	£0	£2,638,848
   	Southend-on-Sea	241,133	£5.68	£5.68	£9,645	£0	£0	£0	£0	£1,369,634
   	Suffolk	833,126	£5.74	£5.74	£0	£0	£0	£0	£0	£4,782,144
   	Thurrock	286,104	£5.50	£5.99	£0	£0	£140,000	£0	£140,000	£1,573,573
   South East	Bracknell Forest	92,200	£6.38	£6.53	£31,671	£0	£13,507	£0	£13,507	£588,236
   	Brighton and Hove	294,177	£6.13	£6.51	£75,727	£0	£0	£111,300	£111,300	£1,803,306
   	Buckinghamshire	441,045	£6.36	£6.36	£147,634	£0	£0	£0	£0	£2,805,043
   	East Sussex	630,317	£6.13	£6.20	£0	£0	£0	£44,100	£44,100	£3,863,846
   	Hampshire	1,076,599	£5.94	£6.01	£263,438	£36,000	£75,000	£0	£75,000	£6,395,000
   	Isle of Wight	160,941	£5.55	£5.66	£39,199	£0	£17,325	£0	£17,325	£893,221
   	Kent	1,527,437	£5.68	£5.68	£425,900	£0	£0	£0	£0	£8,675,842
   	Medway	370,671	£5.76	£5.76	£139,339	£0	£0	£0	£0	£2,135,065
   	Milton Keynes	360,696	£5.68	£5.68	£0	£0	£0	£0	£0	£2,048,753
   	Oxfordshire	550,261	£6.21	£6.21	£0	£0	£0	£0	£0	£3,417,121
   	Portsmouth	335,918	£5.90	£5.94	£104,100	£43,700	£13,437	£0	£13,437	£1,981,917
   	Reading	187,019	£6.51	£6.51	£0	£0	£0	£0	£0	£1,217,494
   	Slough	208,573	£6.52	£6.52	£71,318	£0	£0	£0	£0	£1,359,896
   	Southampton	351,281	£6.11	£6.11	£0	£40,000	£0	£0	£0	£2,146,327
   	Surrey	728,104	£6.65	£6.95	£0	£0	£215,100	£0	£215,100	£4,841,892
   	West Berkshire	118,192	£6.13	£6.13	£34,816	£0	£0	£0	£0	£724,514
   	West Sussex	840,043	£6.04	£6.24	£0	£0	£168,009	£0	£168,009	£5,073,861
   	Windsor and Maidenhead	88,195	£6.66	£6.77	£71,039	£20,000	£10,000	£0	£10,000	£587,381
   	Wokingham	75,417	£6.40	£6.40	£50,352	£0	£0	£0	£0	£482,669
   South West	Bath and North East Somerset	153,524	£6.01	£6.01	£0	£0	£0	£0	£0	£922,679
   	Bournemouth, Christchurch and Poole	412,253	£5.57	£5.72	£66,058	£0	£61,838	£0	£61,838	£2,296,249
   	Bristol, City of	610,453	£5.86	£5.86	£18,314	£0	£0	£0	£0	£3,577,254
   	Cornwall	701,545	£5.63	£5.63	£0	£0	£0	£0	£0	£3,949,697
   	Devon	771,536	£5.34	£5.47	£100,443	£15,170	£100,000	£0	£100,000	£4,120,002
   	Dorset	305,948	£5.68	£5.68	£0	£0	£0	£0	£0	£1,737,782
   	Gloucestershire	547,200	£5.36	£5.36	£0	£18,255	£0	£0	£0	£2,932,992
   	Isles of Scilly	6,204	£5.63	£5.63	£0	£0	£0	£0	£0	£34,929
   	North Somerset	214,713	£5.72	£6.02	£13,603	£0	£45,718	£18,221	£63,939	£1,228,160
   	Plymouth	353,206	£5.80	£5.87	£0	£0	£23,284	£0	£23,284	£2,048,596
   	Somerset	472,300	£5.46	£5.66	£79,600	£0	£0	£96,000	£96,000	£2,578,758
   	South Gloucestershire	276,392	£5.80	£5.80	£84,430	£0	£0	£0	£0	£1,603,074
   	Swindon	304,464	£5.78	£5.78	£54,400	£0	£0	£0	£0	£1,759,800
   	Torbay	191,335	£5.42	£5.60	£55,519	£0	£20,000	£13,770	£33,770	£1,037,036
   	Wiltshire	472,017	£5.75	£5.75	£0	£0	£0	£0	£0	£2,714,100
   Inner London	Camden	225,254	£8.10	£8.92	£299,384	£0	£185,000	£0	£185,000	£1,824,557
   	City of London	2,340	£8.40	£8.40	£0	£0	£0	£0	£0	£19,656
   	Hackney	660,122	£7.34	£7.34	£98,886	£0	£0	£0	£0	£4,845,295
   	Hammersmith and Fulham	152,532	£7.56	£7.56	£0	£0	£0	£0	£0	£1,153,142
   	Haringey	381,932	£6.63	£6.74	£0	£0	£0	£42,000	£42,000	£2,532,209
   	Islington	336,458	£7.48	£7.48	£127,853	£0	£0	£0	£0	£2,516,159
   	Kensington and Chelsea	99,206	£7.56	£7.56	£0	£0	£0	£0	£0	£749,997
   	Lambeth	408,536	£7.56	£7.56	£0	£0	£0	£0	£0	£3,088,533
   	Lewisham	454,376	£6.78	£6.78	£0	£0	£0	£0	£0	£3,080,666
   	Newham	676,676	£6.39	£6.39	£0	£0	£0	£0	£0	£4,323,957
   	Southwark	434,568	£7.27	£7.27	£0	£126,806	£0	£0	£0	£3,158,529
   	Tower Hamlets	462,892	£7.40	£7.40	£37,032	£0	£0	£0	£0	£3,425,401
   	Wandsworth	261,789	£7.56	£7.56	£0	£0	£0	£0	£0	£1,979,125
   	Westminster	170,014	£7.56	£7.56	£0	£0	£0	£0	£0	£1,285,306
   Outer London	Barking and Dagenham	634,923	£6.36	£6.70	£0	£0	£214,981	£0	£214,981	£4,038,110
   	Barnet	457,985	£6.92	£6.92	£0	£0	£0	£0	£0	£3,169,253
   	Bexley	258,968	£6.63	£6.63	£222,600	£0	£0	£0	£0	£1,716,958
   	Brent	509,312	£6.84	£6.84	£0	£0	£0	£0	£0	£3,483,695
   	Bromley	272,985	£6.70	£6.70	£33,259	£0	£0	£0	£0	£1,829,000
   	Croydon	484,749	£6.63	£6.63	£515,528	£0	£0	£0	£0	£3,213,883
   	Ealing	463,410	£6.92	£6.92	£0	£0	£0	£0	£0	£3,206,797
   	Enfield	604,679	£6.63	£6.63	£0	£0	£0	£0	£0	£4,009,020
   	Greenwich	460,845	£7.06	£7.56	£0	£0	£230,423	£0	£230,423	£3,253,566
   	Harrow	301,365	£6.92	£6.92	£0	£0	£0	£0	£0	£2,085,444
   	Havering	306,827	£6.46	£6.46	£0	£0	£0	£0	£0	£1,982,105
   	Hillingdon	16,789	£6.79	£6.79	£0	£0	£0	£0	£0	£113,997
   	Hounslow	421,063	£6.92	£6.92	£0	£0	£0	£0	£0	£2,913,754
   	Kingston upon Thames	159,881	£6.75	£6.75	£0	£0	£0	£0	£0	£1,079,200
   	Merton	224,175	£7.22	£7.22	£0	£0	£0	£0	£0	£1,618,649
   	Redbridge	391,978	£6.63	£6.63	£0	£0	£0	£0	£0	£2,598,811
   	Richmond upon Thames	129,003	£6.92	£6.92	£0	£0	£0	£0	£0	£892,700
   	Sutton	219,853	£6.13	£6.27	£0	£0	£30,000	£0	£30,000	£1,347,699
   	Waltham Forest	380,732	£6.15	£6.15	£123,237	£0	£0	£0	£0	£2,341,503

   Footnotes

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

   Save table

   Related information

   • Release type:
   • Publication: Planned LA and school expenditure, Financial year 2023-24

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