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
    School capacity
  2. Step 2 Select a data set or featured table

    Data set
    Local authority pupil forecasts and forecast housing developer contribution places
  3. Step 3 Choose locations

    Local authority
    • Barking and Dagenham
    • Barnet
    • Barnsley
    • Bath and North East Somerset
    • Bedford Borough
  4. Step 4 Choose time period

    Time period
    2018/19 to 2023/24
  5. Step 5 Choose your filters

    Indicators
    • Local authority pupil forecasts (includes 2018/19 actual pupil numbers)
    Year group
    • Primary total
  6. Step 6 (current) Explore data

    This data is not from the latest release
    View latest data: Academic year 2022/23
    Local authority pupil forecasts (includes 2018/19 actual pupil numbers) for 'Local authority pupil forecasts and forecast housing developer contribution places' for Primary total in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford Borough and 146 other locations between 2018/19 and 2023/24
    2018/192019/202020/212021/222022/232023/24
    Outer LondonBarking and Dagenham25,01425,38325,94026,40327,04427,451
    Barnet30,09730,10130,49630,71330,82030,718
    Yorkshire and the Humber (E12000003)Barnsley20,05920,01420,11720,29920,24520,063
    South West (E12000009)Bath and North East Somerset12,94213,21013,56013,80113,99914,137
    East of EnglandBedford Borough15,59916,08916,55116,87116,92817,071
    Outer LondonBexley22,49222,55822,75822,85722,93223,046
    West MidlandsBirmingham113,448112,482113,125113,759114,317115,118
    North WestBlackburn with Darwen15,34115,32815,20815,14414,93114,690
    Blackpool11,72211,81111,81111,77111,75911,679
    Bolton28,07328,44428,59428,67028,72428,564
    South West (E12000009)Bournemouth Christchurch and Poole27,70427,64227,54127,22026,63626,311
    South EastBracknell Forest10,4069,9739,9079,7379,5759,412
    Yorkshire and the Humber (E12000003)Bradford55,03154,77654,52853,86452,83951,996
    Outer LondonBrent26,36626,34926,42926,70226,92527,098
    South EastBrighton and Hove18,60718,45918,41818,15417,74017,383
    SOUTH WEST (E12000009)Bristol, City of36,17936,41736,67336,60936,07735,450
    Outer LondonBromley27,27027,54227,82527,76627,62827,577
    South EastBuckinghamshire44,00144,10744,38444,23243,90943,848
    North WestBury16,74416,61716,49116,16815,80715,422
    Yorkshire and the Humber (E12000003)Calderdale19,15019,22519,09218,75518,49218,160
    East of EnglandCambridgeshire50,66351,16851,72252,65453,73755,093
    Inner LondonCamden10,75710,71010,58010,48010,27010,180
    East of EnglandCentral Bedfordshire24,79925,45626,19226,84627,35628,073
    North WestCheshire East29,31629,48629,86630,13930,21630,092
    Cheshire West and Chester27,43227,35128,74028,90228,75028,423
    Inner LondonCity of London234240241240240210
    South West (E12000009)Cornwall41,62542,06142,39642,50542,09041,867
    West MidlandsCoventry31,25731,41231,69031,58431,34831,027
    Outer LondonCroydon32,70633,14633,39233,38633,53133,561
    North WestCumbria35,84335,58335,25034,87334,48334,286
    North EastDarlington8,9448,8878,7428,5038,3488,143
    East MidlandsDerby23,74923,80623,74123,74123,59023,295
    Derbyshire59,64759,26259,31559,02658,08157,350
    South West (E12000009)Devon55,78057,02457,82258,09157,65356,141
    Yorkshire and the Humber (E12000003)Doncaster26,07325,98026,02426,00025,88125,699
    South West (E12000009)Dorset25,45025,10925,01524,85124,67524,499
    West MidlandsDudley27,14427,21327,38027,38427,30726,996
    North EastDurham39,48239,20239,38339,33939,16939,119
    Outer LondonEaling30,62630,48029,95529,41028,78628,023
    Yorkshire and the Humber (E12000003)East Riding of Yorkshire24,82624,55624,38724,10723,93423,509
    South EastEast Sussex38,66438,60638,60238,16837,91637,649
    Outer LondonEnfield31,70032,27232,32632,15231,91731,625
    East of EnglandEssex117,487118,126119,611120,989122,526124,027
    North EastGateshead14,94315,04614,98515,07915,05115,167
    South West (E12000009)Gloucestershire47,52447,37648,79049,75850,64251,268
    Outer LondonGreenwich24,63724,80625,06325,05125,12025,421
    Inner LondonHackney18,37917,99917,75317,49517,29317,186
    North WestHalton10,71510,68010,72110,66110,68110,645
    Inner LondonHammersmith and Fulham9,8569,8019,8679,8799,8999,919
    South EastHampshire106,164106,578107,586108,574108,716109,116
    Inner LondonHaringey21,31120,95120,71420,44220,27320,282
    Outer LondonHarrow21,16921,91222,13622,20222,17222,105
    North EastHartlepool8,0878,0007,9297,7747,6137,458
    Outer LondonHavering22,16822,70323,36124,15924,94325,425
    West MidlandsHerefordshire13,46813,44313,43913,39613,32113,253
    East of EnglandHertfordshire100,05899,881101,068101,009100,352100,140
    Outer LondonHillingdon27,93627,91527,95227,97427,85027,761
    Hounslow23,62623,54823,68423,85424,09524,108
    South EastIsle of Wight9,2459,2769,1318,9568,7098,446
    South West (E12000009)Isles Of Scilly147155153148143144
    Inner LondonIslington13,54113,45513,31713,14613,03413,014
    Kensington and Chelsea6,7636,6726,5636,4136,2916,190
    South EastKent126,062126,576126,944127,247127,266126,532
    YORKSHIRE AND THE HUMBER (E12000003)Kingston Upon Hull, City of23,38623,48223,59223,49323,25022,923
    Outer LondonKingston upon Thames13,47013,43013,41713,44313,47713,614
    Yorkshire and the Humber (E12000003)Kirklees38,22737,92837,70937,48436,87236,427
    North WestKnowsley12,79713,07113,02613,15613,21613,190
    Inner LondonLambeth21,47821,59821,30021,08220,74920,464
    North WestLancashire98,07798,74699,43699,65799,39099,231
    Yorkshire and the Humber (E12000003)Leeds69,55070,84071,74472,23972,46971,989
    East MidlandsLeicester33,37233,80334,17934,34034,61034,777
    Leicestershire54,44555,16357,07558,60859,92160,744
    Inner LondonLewisham25,52024,66024,54224,35524,05423,861
    East MidlandsLincolnshire56,43556,43956,54856,08755,09154,406
    North WestLiverpool37,27437,43237,81138,16638,32038,524
    East of EnglandLuton22,76422,78423,08023,23022,94022,675
    North WestManchester49,59350,37050,96250,86451,24151,920
    South EastMedway24,58525,21625,56725,65325,54525,376
    Outer LondonMerton16,68016,51016,37316,13915,90415,721
    North EastMiddlesbrough13,55113,72913,72113,72613,52613,417
    South EastMilton Keynes26,52726,53227,01827,61728,41629,103
    North EastNewcastle upon Tyne21,78721,97022,19522,23922,06621,902
    Inner LondonNewham34,26334,59735,17235,46135,85436,110
    East of EnglandNorfolk64,36364,40264,73564,86164,12863,740
    Yorkshire and the Humber (E12000003)North East Lincolnshire13,62513,90113,81713,68613,52813,343
    North Lincolnshire13,73913,73713,69513,61413,46713,330
    South West (E12000009)North Somerset16,94116,82316,86416,58016,18315,907
    North EastNorth Tyneside16,43416,37416,39716,27716,22516,189
    Yorkshire and the Humber (E12000003)North Yorkshire42,94943,00143,25343,36343,39243,420
    East MidlandsNorthamptonshire66,14666,15466,62966,78866,86166,966
    North EastNorthumberland23,45423,50823,74823,51323,02522,580
    East MidlandsNottingham26,69826,89926,91026,56926,08025,629
    Nottinghamshire66,82767,99368,50068,80868,37167,311
    North WestOldham24,33724,69124,87725,21725,35525,694
    South EastOxfordshire52,38853,46054,73155,36255,21655,423
    East of EnglandPeterborough21,69122,00422,21922,35422,58122,801
    South West (E12000009)Plymouth20,71420,61420,40919,99719,52119,235
    South EastPortsmouth16,25016,33516,43716,39616,26716,121
    Reading13,36713,27513,25213,22013,22113,184
    Outer LondonRedbridge29,58430,21630,66731,12731,97833,044
    North EastRedcar and Cleveland11,39611,39611,29411,27811,22210,958
    Outer LondonRichmond upon Thames16,82516,80516,75416,68616,60216,621
    North WestRochdale21,19421,49421,74822,07322,13722,056
    Yorkshire and the Humber (E12000003)Rotherham23,30123,07923,32823,20623,17123,102
    East MidlandsRutland2,7832,8252,9272,9422,9763,012
    North WestSalford21,64721,62021,62321,78221,87021,884
    West MidlandsSandwell33,77933,86034,05734,14334,01133,799
    North WestSefton21,04521,16421,23021,12620,89120,716
    Yorkshire and the Humber (E12000003)Sheffield44,49945,23245,48445,46645,08344,371
    West MidlandsShropshire20,96021,13421,56221,76921,82621,625
    South EastSlough16,81616,76116,76916,66416,51316,366
    West MidlandsSolihull19,51319,28019,34319,54819,53319,486
    South West (E12000009)Somerset41,43041,41241,38841,17040,73240,421
    South Gloucestershire23,54923,77124,06124,38224,63824,834
    North EastSouth Tyneside11,68111,74411,88911,81911,79011,739
    South EastSouthampton20,19020,12020,02619,76519,24718,773
    East of EnglandSouthend-on-Sea16,10315,08415,06214,89614,66214,369
    Inner LondonSouthwark23,25722,87822,69722,54222,29422,161
    North WestSt Helens14,81714,70414,70414,72714,68614,645
    West MidlandsStaffordshire66,71666,17366,92067,19067,05567,301
    North WestStockport24,42724,46624,52224,56524,51624,424
    North EastStockton-on-Tees17,38617,54517,21517,29217,22217,088
    West MidlandsStoke-on-Trent22,69222,84422,70222,44522,00321,647
    East of EnglandSuffolk56,01056,59357,16357,34457,05956,874
    North EastSunderland21,64721,33321,27721,20421,10020,936
    South EastSurrey90,10494,07094,87895,20295,06694,761
    Outer LondonSutton17,63017,77217,76417,63517,58417,444
    South West (E12000009)Swindon20,66720,66520,73720,81720,63320,421
    North WestTameside20,97621,25321,36121,24521,21320,968
    West MidlandsTelford and Wrekin16,09916,21016,21016,20116,04915,937
    East of EnglandThurrock17,07917,91918,07318,37018,44218,535
    South West (E12000009)Torbay9,97810,04510,10910,0129,9739,911
    Inner LondonTower Hamlets23,49223,21023,08523,04622,96122,834
    North WestTrafford21,05921,44921,31121,12620,76220,214
    Yorkshire and the Humber (E12000003)Wakefield28,92329,58329,99230,33930,36330,188
    West MidlandsWalsall26,59426,42126,60226,89026,76926,338
    Outer LondonWaltham Forest24,27824,63825,05525,43425,52425,563
    Inner LondonWandsworth18,68118,78918,85318,95519,09419,152
    North WestWarrington17,89817,94818,02917,94417,59217,194
    West MidlandsWarwickshire44,65946,26347,03347,76447,85047,869
    South EastWest Berkshire13,29013,22713,16812,96612,60012,278
    West Sussex65,82265,53366,18266,98467,33867,353
    Inner LondonWestminster9,6839,5299,3249,0878,9078,945
    North WestWigan26,52826,55026,36826,22125,85125,571
    South West (E12000009)Wiltshire38,22939,86140,62640,69240,48040,656
    South EastWindsor and Maidenhead11,36211,30111,32811,22111,10211,104
    North WestWirral25,91225,81925,70725,49025,32425,011
    South EastWokingham15,14315,33015,69015,82715,83215,800
    West MidlandsWolverhampton24,67624,72525,09125,32625,32225,387
    Worcestershire44,02644,71045,43345,81346,14046,112
    Yorkshire and the Humber (E12000003)York13,78413,76113,76913,68313,51813,421

    Footnotes

    1. z - Indicates data is not applicable.
    2. Pupil forecasts are provided by local authorities. They include pupils expected to be educated in maintained community, foundation and voluntary schools, city technology colleges, academies, free schools, studio schools and university technology colleges. They also include pupils expected to be educated in new schools (or expanded schools) funded through housing developer contribution (HDC) agreements.

    Save table

    Download Table

    Select file format:

    Related information

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