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 View a featured table or create your own

    Subject
    Local authority pupil forecasts
  3. Step 3 Choose locations

    National
    • England
  4. Step 4 Choose time period

    Time period
    2020/21 to 2027/28
  5. Step 5 Choose your filters

    Indicators
    • Local authority pupil forecasts (includes 2020/21 actual pupil numbers)
    Year group
    • Reception
    • Year 01
    • Year 02
    • Year 03
    • Year 04
    • Year 05
    • Year 06
    • Year 07
    • Year 08
    • Year 09
    • Year 10
    • Year 11
    • Year 12
    • Year 13
  6. Step 6 (current) Explore data

    Re-order table headers

    Drag and drop the options below to re-order the table headers. Hold the Ctrl key and click to select multiple items to drag and drop. For keyboard users, select and deselect a draggable item with space and use the arrow keys to move a selected item.

    To move an item with your keyboard, select or deselect the item with Space and use the Up and Down arrow keys to move the selected item. To move multiple items, you can press Ctrl and Enter to add an item to your selected items. If you are using a screen reader disable scan mode.

    Row groups
    Row group 1
    2020/21
    2021/22
    2022/23
    2023/24
    2024/25
    2025/26
    2026/27
    2027/28
    Column groups
    Column group 1
    Reception
    Year 01
    Year 02
    Year 03
    Year 04
    Year 05
    Year 06
    Year 07
    Year 08
    Year 09
    Year 10
    Year 11
    Year 12
    Year 13
    Column group 2
    Local authority pupil forecasts (includes 2020/21 actual pupil numbers)
    This is the latest data
    Local authority pupil forecasts (includes 2020/21 actual pupil numbers) for 'Local authority pupil forecasts' for Reception, Year 01, Year 02, Year 03, Year 04 and 9 other filters in England between 2020/21 and 2027/28
    PrimarySecondary
    ReceptionYear 01Year 02Year 03Year 04Year 05Year 06Year 07Year 08Year 09Year 10Year 11Year 12Year 13
    2020/21625,103627,186629,153639,982655,353654,309642,534619,739623,167598,878578,734562,578222,343189,552
    2021/22619,732630,242631,317632,554643,748658,982657,877635,621622,558626,094601,782578,603223,129203,821
    2022/23610,912624,695634,167634,085636,032646,935661,962648,759637,804625,017628,237600,893229,038205,085
    2023/24599,908615,558628,518636,873637,472639,278649,906651,287650,774640,173627,221627,404236,331210,405
    2024/25590,398604,626619,091631,044640,113640,348642,135639,260653,017652,638642,123626,169244,426216,990
    2025/26594,633594,443607,812621,386633,964642,511642,706631,256640,812654,804654,447641,026244,524224,135
    2026/27no datano datano datano datano datano datano data631,227632,466642,186656,159652,877249,070224,171
    2027/28no datano datano datano datano datano datano data632,410632,110633,672643,757654,604253,045228,165

    Footnotes

    1. 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) and housing infrastructure fund (HIF) agreements.
    2. Number of pupils on roll in 2020/21 taken from January 2021 School Census.
    3. Year 13 figures include Year 14 figures.
    4. National pupil forecast figures will differ to the National Pupil Projections published annually by the Department for Education due to methodological and timing reasons. More information can be found in 'Methodology: School capacity'.
    5. Pupil forecasts, places expected to be funded through housing developer contributions and places expected to be funded through housing infrastructure contributions are provided from 2021/22 to 2025/26 for primary (Reception to Year 6) and from 2021/22 to 2027/28 for secondary (Year 7 to Year 13).

    Save table

    Download Table

    Select file format:

    Related information