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
  3. Step 3 Choose locations

    National
    • England
  4. Step 4 Choose time period

    Time period
    2021/22 to 2028/29
  5. Step 5 Choose your filters

    Indicators
    • Local authority pupil forecasts (includes 2021/22 actual pupil numbers)
    Year group
    • Reception
    • Year 01
    • Year 02
    • Year 03
    • Year 04
  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 2021/22 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 2021/22 and 2028/29
    Local authority pupil forecasts (includes 2021/22 actual pupil numbers)
    PrimarySecondary
    ReceptionYear 01Year 02Year 03Year 04Year 05Year 06Year 07Year 08Year 09Year 10Year 11Year 12Year 13
    2021/22613,569632,089631,121630,796642,560657,010656,470629,975620,259622,151598,292574,206220,029200,870
    2022/23608,805620,167637,711635,760635,633646,964661,523648,574632,777623,790625,366598,674227,725203,335
    2023/24597,470615,034625,233642,017640,193639,702651,366650,979651,336635,709626,723626,021236,097209,841
    2024/25583,203603,088619,639629,261646,143644,050643,982640,863653,571653,903638,413627,249244,721217,835
    2025/26578,689588,298607,498623,125633,156649,606647,756634,040643,040655,915656,221638,579245,330225,471
    2026/27581,568583,334592,271610,858626,774636,290652,846635,296635,772645,205658,024656,248249,210226,166
    2027/28no datano datano datano datano datano datano data638,779636,956637,706647,036657,698255,104229,714
    2028/29no datano datano datano datano datano datano data627,029640,107638,626639,527646,585255,766234,904

    Footnotes

    1. Number of actual pupils on roll in 2021/22 taken from January 2022 School Census.
    2. Pupil forecasts are provided from 2022/23 to 2026/27 for primary (Reception to Year 6) and from 2022/23 to 2028/29 for secondary (Year 7 to Year 13).

    Save table

    Download Table

    Select file format:

    Related information

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