Data set from Local authority school places scorecards

Quantity of school places added - national, local authority

Latest data
Published
Last updated
Quantity of school places added since academic year 2009/10 and planned for 2027/28

Data set details

Theme
Pupils and schools
Publication
Local authority school places scorecards
Release
Reporting year 2025
Release type
Number of rows
308
Geographic levels
Local authority, National
Indicators
  • Actual Number on Roll 2009/10
  • Actual Number on Roll 2014/15
  • Actual Number on Roll 2018/19
  • Anticipated Change in Pupil Numbers from 2025/26 to 2027/28
  • Capacity at May 2010
  • Capacity at May 2025
  • Estimated Number of Additional Places Needed to Meet Demand in 2027/28
  • Estimated Number of Spare Places in 2027/28
  • Estimated Percentage of Spare Places in 2027/28
  • Forecast Pupil Numbers in 2027/28
  • Number of New Places Planned for Delivery between 2025/26 and 2027/28
  • Percentage Change in Pupil Numbers between 2009/10 and 2014/15
  • Percentage Change in Pupil Numbers between 2009/10 and 2018/19
  • Percentage Change in Pupil Numbers between 2009/10 and 2025/26
  • Percentage Change in Pupil Numbers between 2014/15 and 2025/26
  • Percentage Change in Pupil Numbers between 2018/19 and 2025/26
  • Percentage of Unfilled Places in 2024/25
  • Total Places created between 2009/10 and 2024/25
Filters
  • School phase
Time period
2025

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameregion_coderegion_nameold_la_codenew_la_codela_nameeducation_phaseestimated_spare_places_in_202728_countestimated_spare_places_202728_percentageactual_pupil_numbers_200910_countforecast_pupil_numbers_202728_countactual_pupil_numbers_201819_countactual_pupil_numbers_201415_countchange_in_pupil_numbers_202526_202728_percentagechange_in_pupil_numbers_200910_201819_percentagechange_in_pupil_numbers_200910_201415_percentagechange_in_pupil_numbers_201819_202526_percentagechange_in_pupil_numbers_201415_202526_percentagechange_in_pupil_numbers_200910_202526_percentagecapacity_may_2010_countcapacity_may_2025_countunfilled_places_202425_percentageplaces_created_200910_202425_totalestimated_additional_places_needed_202728_countnew_places_planned_for_202526_202728_count
2025Reporting yearNationalE92000001EnglandPrimary828662.701316.406862213854572424056645155254270211-0.84884506717.147247480.10783013-5.2852104680.00155940810.955768894227527495138313.834781117238561852010815
2025Reporting yearNationalE92000001EnglandSecondary399137.665111.1116622128205113210150284415726796012.1023838680.838358723-0.04995903210.544178820.17332767111.470935593563118411584712.450754365527291723019726.45402
2025Reporting yearLocal authorityE92000001EnglandE12000004East Midlands831E06000015DerbyPrimary3780.6647714.3784314819498227862374922069-0.66265585521.802236130.131859678-3.4148806270.03937650117.64283516218732592211.33785973404927042
2025Reporting yearLocal authorityE92000001EnglandE12000004East Midlands831E06000015DerbySecondary1428.7685377.41424125144931793214967140152.0719489983.270544401-0.03298143917.378232110.25351409221.2171393117340217388.52884354398900
2025Reporting yearLocal authorityE92000001EnglandE12000004East Midlands830E10000007DerbyshirePrimary11991.8933417.84322076547445565159647575660.2937572098.9562326470.051549028-6.972689322-0.0360976971.359053047621396690616.282545664767440301

Variables in this data set

Table showing all 19 variables
Variable nameVariable description
actual_pupil_numbers_200910_countActual Number on Roll 2009/10
actual_pupil_numbers_201415_countActual Number on Roll 2014/15
actual_pupil_numbers_201819_countActual Number on Roll 2018/19
capacity_may_2010_countCapacity at May 2010
capacity_may_2025_countCapacity at May 2025
change_in_pupil_numbers_200910_201415_percentagePercentage Change in Pupil Numbers between 2009/10 and 2014/15
change_in_pupil_numbers_200910_201819_percentagePercentage Change in Pupil Numbers between 2009/10 and 2018/19
change_in_pupil_numbers_200910_202526_percentagePercentage Change in Pupil Numbers between 2009/10 and 2025/26
change_in_pupil_numbers_201415_202526_percentagePercentage Change in Pupil Numbers between 2014/15 and 2025/26
change_in_pupil_numbers_201819_202526_percentagePercentage Change in Pupil Numbers between 2018/19 and 2025/26
change_in_pupil_numbers_202526_202728_percentageAnticipated Change in Pupil Numbers from 2025/26 to 2027/28
education_phaseSchool phase
estimated_additional_places_needed_202728_countEstimated Number of Additional Places Needed to Meet Demand in 2027/28
estimated_spare_places_202728_percentageEstimated Percentage of Spare Places in 2027/28
estimated_spare_places_in_202728_countEstimated Number of Spare Places in 2027/28
forecast_pupil_numbers_202728_countForecast Pupil Numbers in 2027/28
new_places_planned_for_202526_202728_countNumber of New Places Planned for Delivery between 2025/26 and 2027/28
places_created_200910_202425_totalTotal Places created between 2009/10 and 2024/25
unfilled_places_202425_percentagePercentage of Unfilled Places in 2024/25

Footnotes

  1. z indicates data is not applicable
  2. x indicates data is not available

Using this data

  • Download the underlying data as a compressed ZIP file

  • View or create your own tables

    View tables that we have built for you, or create your own tables from open data using our table tool

Download this data using code

Access this data using common programming languages using the URL below.

Example code

Python
import pandas as pd

pd.read_csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/a95b219c-6c51-4459-81ca-94a1e240cb7c/csv")
R
read.csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/a95b219c-6c51-4459-81ca-94a1e240cb7c/csv")

Contact us

If you have a specific enquiry about Quantity of school places added - national, local authority statistics and data:

Pupil Place Planning team

Email: SCAP.PPP@education.gov.uk
Contact name: Josie Brett