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 2025/26
  5. Step 5 Choose your filters

    Indicators
    • Local authority pupil forecasts (includes 2018/19 actual pupil numbers)
    Year group
    • Secondary 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 Secondary total in Barking and Dagenham, Barnet, Barnsley, Bath and North East Somerset, Bedford Borough and 146 other locations between 2018/19 and 2025/26
    2018/192019/202020/212021/222022/232023/242024/252025/26
    Outer LondonBarking and Dagenham15,82717,39018,61119,52920,44120,99421,80522,384
    Barnet25,40626,31927,23127,93828,55829,00029,19129,265
    Yorkshire and the Humber (E12000003)Barnsley11,76812,29412,63612,98013,38513,66613,67013,643
    South West (E12000009)Bath and North East Somerset13,13413,40213,86014,29614,76015,14815,55115,793
    East of EnglandBedford Borough11,12412,36813,01513,83514,39815,04115,46415,797
    Outer LondonBexley19,58520,27720,68720,78720,91821,17821,17921,065
    West MidlandsBirmingham77,84380,84383,47985,63888,34591,03891,62491,935
    North WestBlackburn with Darwen10,74311,03511,49011,71212,07112,27112,42212,322
    Blackpool6,3216,4656,5236,6516,8897,0637,1537,308
    Bolton19,08720,01220,74421,45622,06222,67022,89123,100
    South West (E12000009)Bournemouth Christchurch and Poole21,72722,26223,01923,70824,53625,19925,53425,702
    South EastBracknell Forest7,1067,3887,7027,9098,0468,2078,3598,301
    Yorkshire and the Humber (E12000003)Bradford37,40238,17938,91439,72140,23640,59140,42840,078
    Outer LondonBrent18,97019,58320,14620,79921,45222,10622,58222,875
    South EastBrighton and Hove12,50112,86512,92413,14313,26513,28813,14713,079
    SOUTH WEST (E12000009)Bristol, City of20,84121,11622,10223,03924,06024,83125,42125,717
    Outer LondonBromley22,83423,82024,71925,59626,23626,62226,78726,755
    South EastBuckinghamshire37,19837,96038,64639,38940,07440,60040,79440,859
    North WestBury11,17711,39711,56111,64911,77311,86611,86511,719
    Yorkshire and the Humber (E12000003)Calderdale15,65216,29316,74917,13417,36117,63417,48217,364
    East of EnglandCambridgeshire32,78333,81735,30536,78038,48839,96440,51940,866
    Inner LondonCamden10,21710,29010,32010,34010,40010,50010,54010,510
    East of EnglandCentral Bedfordshire16,57517,35718,26319,23420,30921,30122,21423,080
    North WestCheshire East22,78723,71824,83725,75626,72027,48527,86028,034
    Cheshire West and Chester20,20120,60121,58222,08122,39622,58222,61822,568
    Inner LondonCity of Londonzzzzzzzz
    South West (E12000009)Cornwall29,22130,04530,92131,59432,44033,04933,39633,387
    West MidlandsCoventry21,58022,73923,49824,30525,13425,99226,58126,848
    Outer LondonCroydon22,03122,20723,22723,73224,30824,62324,73724,729
    North WestCumbria29,43729,90130,25930,50030,56930,52730,45830,227
    North EastDarlington6,2236,1946,2786,3686,3866,4796,5196,390
    East MidlandsDerby16,71817,18317,82018,41418,93319,47819,81819,908
    Derbyshire42,76543,48944,18444,72445,17445,39445,18744,985
    South West (E12000009)Devon38,72740,20341,91343,23444,62545,76746,09446,262
    Yorkshire and the Humber (E12000003)Doncaster17,60018,49519,34719,87520,41520,92721,08521,206
    South West (E12000009)Dorset21,96622,67123,07723,33923,61323,75823,76923,565
    West MidlandsDudley17,72918,07318,18918,43118,78819,34319,55219,753
    North EastDurham27,17028,74029,49030,19030,80131,05331,16131,121
    Outer LondonEaling19,48020,16320,88021,54322,11422,48122,58322,553
    Yorkshire and the Humber (E12000003)East Riding of Yorkshire18,72818,86718,95519,09119,26819,39519,39119,271
    South EastEast Sussex25,95926,41127,03027,83928,50529,07929,38729,416
    Outer LondonEnfield22,66523,91424,62525,18725,74426,13726,17326,079
    East of EnglandEssex86,92489,69492,29095,28797,691100,253102,268103,878
    North EastGateshead11,44411,80012,15512,32812,44212,48512,53712,504
    South West (E12000009)Gloucestershire38,59039,68041,32843,06544,52945,69646,41646,495
    Outer LondonGreenwich15,50116,30117,00917,49917,94418,42618,78718,990
    Inner LondonHackney13,96514,05514,59315,04115,38615,61015,61715,747
    North WestHalton7,8668,0478,1528,3868,4038,5358,5438,539
    Inner LondonHammersmith and Fulham8,2389,3689,6299,7909,97610,17310,28510,302
    South EastHampshire67,93669,72770,71971,72872,97173,53274,05374,636
    Inner LondonHaringey14,16614,39814,60514,85115,05915,14415,25515,293
    Outer LondonHarrow13,83514,65115,30615,77616,25216,54216,73916,812
    North EastHartlepool5,5545,6945,8495,9386,0156,0956,0195,942
    Outer LondonHavering15,86716,07116,28916,43916,90417,27717,62617,764
    West MidlandsHerefordshire9,2499,3389,2859,3589,4129,2839,5049,690
    East of EnglandHertfordshire83,36785,82788,72491,54994,52296,89198,915100,350
    Outer LondonHillingdon20,02620,92921,91622,73523,41623,96724,19824,305
    Hounslow17,58018,45919,23319,99620,74021,32321,68521,876
    South EastIsle of Wight6,3757,2997,2927,2897,3257,3797,4537,487
    South West (E12000009)Isles Of Scilly92991011061099699107
    Inner LondonIslington8,2908,1698,4248,5818,7218,8648,8698,860
    Kensington and Chelsea5,7105,7855,8595,9536,0236,0416,0496,017
    South EastKent100,754104,965108,584111,686114,517117,605119,110119,719
    YORKSHIRE AND THE HUMBER (E12000003)Kingston Upon Hull, City of14,35415,14215,68916,17816,59617,06517,28717,300
    Outer LondonKingston upon Thames10,85711,29711,71612,06512,36912,60212,78312,920
    Yorkshire and the Humber (E12000003)Kirklees26,03526,74327,18627,64527,99928,30428,27028,213
    North WestKnowsley5,4085,7906,0506,2236,3176,5336,5506,507
    Inner LondonLambeth13,22614,01814,48114,96915,24115,44115,63615,618
    North WestLancashire67,70969,87171,25372,20273,31773,97073,91073,492
    Yorkshire and the Humber (E12000003)Leeds46,06647,94450,08452,25454,13755,78556,63156,717
    East MidlandsLeicester19,91721,04021,88322,73823,63024,38124,91025,427
    Leicestershire41,57542,38944,05445,93247,83148,84448,98448,827
    Inner LondonLewisham12,50412,36412,26112,20612,31412,39712,48112,516
    East MidlandsLincolnshire46,02247,28548,56249,82651,08652,08352,50053,014
    North WestLiverpool29,17630,00630,76531,71732,62933,46533,85434,179
    East of EnglandLuton14,23014,75915,11215,46915,87316,12816,09515,958
    North WestManchester29,12130,70732,40734,02635,17136,20137,01137,357
    South EastMedway19,18919,65520,22820,68621,20921,69621,90022,055
    Outer LondonMerton9,3149,74510,18610,57510,93711,16011,26911,265
    North EastMiddlesbrough8,2148,7219,0359,4059,84510,16810,41410,563
    South EastMilton Keynes18,62719,82920,81122,10523,51824,79425,88526,495
    North EastNewcastle upon Tyne15,29515,95616,44117,10017,77818,31718,64918,885
    Inner LondonNewham23,52325,47926,94827,91928,75129,37429,79129,829
    East of EnglandNorfolk45,53247,29748,69250,00851,48752,65352,94553,198
    Yorkshire and the Humber (E12000003)North East Lincolnshire8,4779,2779,5289,6989,92410,11810,19110,170
    North Lincolnshire9,72010,29910,61110,84911,10611,33311,50811,453
    South West (E12000009)North Somerset12,61912,99113,43413,89614,22214,41314,47314,371
    North EastNorth Tyneside11,82712,17112,51012,72012,89113,05113,08313,247
    Yorkshire and the Humber (E12000003)North Yorkshire36,20736,97337,54938,09138,49238,77038,60238,491
    East MidlandsNorthamptonshire46,87248,61450,53552,11153,50754,35955,04155,188
    North EastNorthumberland18,45418,74519,01219,03618,97318,99118,84318,629
    East MidlandsNottingham16,03316,69417,36917,93818,45918,85919,10519,100
    Nottinghamshire48,02850,34952,21154,15556,05157,45757,94158,161
    North WestOldham16,54417,77218,33818,82919,26219,48819,66419,751
    South EastOxfordshire38,23739,58341,09342,57944,45545,75946,49947,135
    East of EnglandPeterborough15,15815,83616,53817,33318,04718,76819,12919,308
    South West (E12000009)Plymouth16,24816,64317,10317,45517,82618,07018,16218,075
    South EastPortsmouth8,9829,5039,91010,41510,79511,05111,26611,389
    Reading7,7368,7959,2959,73410,10410,48310,77611,090
    Outer LondonRedbridge24,92725,58426,30527,14928,28429,85531,59933,411
    North EastRedcar and Cleveland8,2578,2578,3728,4068,5248,6728,9118,990
    Outer LondonRichmond upon Thames9,77410,26610,66611,12011,54811,90912,11512,286
    North WestRochdale12,88213,48114,00914,48515,02215,44415,79115,987
    Yorkshire and the Humber (E12000003)Rotherham18,07118,75819,31119,75720,01120,19520,21320,149
    East MidlandsRutland2,5862,6962,7662,8262,8712,8722,8232,808
    North WestSalford11,56311,65511,89712,15912,48312,74012,95513,151
    West MidlandsSandwell22,02123,04224,05324,79725,55326,22726,60026,649
    North WestSefton15,93916,32016,59516,77316,94116,95716,83016,794
    Yorkshire and the Humber (E12000003)Sheffield31,06132,42033,34734,03534,60835,14035,34635,240
    West MidlandsShropshire15,77316,20116,50316,75716,95417,05417,19517,407
    South EastSlough12,78513,52614,32614,97815,56216,00616,23616,296
    West MidlandsSolihull17,62018,03218,34618,57418,79318,84418,99219,078
    South West (E12000009)Somerset27,01227,56228,20828,79529,33129,77329,80529,911
    South Gloucestershire15,14615,59015,94616,32516,77917,27617,61517,860
    North EastSouth Tyneside8,5389,1079,2569,3889,5039,7019,6459,628
    South EastSouthampton10,86011,39311,89412,56513,32813,82213,90213,989
    East of EnglandSouthend-on-Sea13,22613,56114,02414,48414,81415,05615,14715,219
    Inner LondonSouthwark16,74417,30017,67417,82918,03818,05118,10718,087
    North WestSt Helens10,22310,57510,72311,14811,09011,14310,99710,900
    West MidlandsStaffordshire49,51851,63953,12254,61956,06457,04557,65258,128
    North WestStockport14,70615,33315,67415,93516,17816,30916,32216,368
    North EastStockton-on-Tees11,18011,85112,09312,58913,07713,36713,54413,579
    West MidlandsStoke-on-Trent13,66814,34714,82515,19815,82116,09216,08216,153
    East of EnglandSuffolk40,91842,33443,56644,60845,74346,66746,52446,216
    North EastSunderland15,24615,69016,11116,47016,79717,02416,95816,810
    South EastSurrey60,80765,23867,42069,88772,32874,28375,54276,367
    Outer LondonSutton19,34019,98720,84221,58422,20122,74323,06923,172
    South West (E12000009)Swindon11,74112,71913,18313,60414,11114,32714,25714,309
    North WestTameside13,41414,13114,55715,17915,58115,96116,08016,039
    West MidlandsTelford and Wrekin11,76512,20912,60912,93513,40313,67413,89913,984
    East of EnglandThurrock10,40011,12311,64711,95712,43412,72912,76612,766
    South West (E12000009)Torbay8,6809,0309,2799,5409,7579,97310,09110,199
    Inner LondonTower Hamlets17,57617,76818,05218,33718,48518,74618,86618,991
    North WestTrafford18,07519,22219,77820,29420,59820,98721,03120,916
    Yorkshire and the Humber (E12000003)Wakefield19,77020,75121,34122,14022,54522,86023,01623,145
    West MidlandsWalsall20,55920,99621,40021,74921,96222,22522,33322,353
    Outer LondonWaltham Forest14,85315,38815,81416,31716,79517,24717,46417,499
    Inner LondonWandsworth12,59412,94613,36513,88514,30914,80915,16815,382
    North WestWarrington12,89913,32213,64014,01014,46014,79514,95415,130
    West MidlandsWarwickshire35,39637,59639,06540,61242,08843,06243,87644,676
    South EastWest Berkshire11,55812,04712,27612,53312,83413,09313,21713,225
    West Sussex45,91247,35949,10551,28353,29954,95655,80956,245
    Inner LondonWestminster10,95511,34011,52611,69811,83611,98311,96911,913
    North WestWigan18,30319,18119,84320,37620,85421,22721,00120,676
    South West (E12000009)Wiltshire28,94529,98131,05032,06733,23834,23434,85835,437
    South EastWindsor and Maidenhead9,7519,99810,33710,72411,01611,32411,51511,516
    North WestWirral20,95821,55022,03522,41222,70923,00722,96522,891
    South EastWokingham10,91811,31911,73012,12812,53312,95413,22513,431
    West MidlandsWolverhampton17,67318,53919,29320,10721,00121,64521,92522,155
    Worcestershire32,53233,62934,77035,93536,94537,85138,62339,000
    Yorkshire and the Humber (E12000003)York10,53610,89611,13011,29811,43111,51011,44911,432

    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)