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

   • Publication: School capacity

2. Step 2 View a featured table or create your own

   Choose a table

   Use the links below to quickly select existing featured tables for this publication. After viewing a table you can also adjust and change filters to quickly see different results.

   • Actual pupil numbers and pupil forecasts by local authority, 2021/22 to 2026/27 - Primary

     Local authority level primary forecasts and actual pupil numbers for 2021/22 - 2026/27

   • Actual pupil numbers and pupil forecasts by local authority, 2021/22 to 2028/29 - Secondary

     Local authority level secondary forecasts and actual pupil numbers for 2021/22 to 2028/29

   • Actual pupil numbers and pupil forecasts in England, 2021/22 to 2028/29

     Pupil forecasts and actual pupil numbers for 2021/22 to 2028/29 for year groups reception to year 13

   • Estimated school places needed by local authority, 2022/23 to 2026/27 – Primary

     This includes primary local authority level data on the estimated number of primary places needed to meet modelled demand from 2022/23 to 2026/27.

   • Estimated school places needed by local authority, 2022/23 to 2028/29 – Secondary

     This includes secondary local authority level data on the estimated number of secondary places needed to meet modelled demand from 2022/23 to 2028/29.

   • Planned places by local authority, 2022/23 to 2024/25

     This includes local authority level data for primary and secondary schools on: planned additional places (permanent), bulge places (temporary for large cohort) and p laces to remove (permanent) from 2022/23 to 2024/25

   • School capacity by local authority, 2021/22 – Primary

     School capacity in 2021/22 by local authority for primary schools. This includes: number of schools, number of school places, number of pupils on roll, number of schools at or in excess of capacity, pupils in places that exceed their school's capacity, pupils in places that exceed their school's capacity as a percentage of total places, number of schools with one or more unfilled places, unfilled places and unfilled places as a percentage of total places

   • School capacity by local authority, 2021/22 – Secondary

     School capacity in 2021/22 by local authority for secondary schools. This includes: number of schools, number of school places, number of pupils on roll, number of schools at or in excess of capacity, pupils in places that exceed their school's capacity, pupils in places that exceed their school's capacity as a percentage of total places, number of schools with one or more unfilled places, unfilled places and unfilled places as a percentage of total places

   • School capacity in England, 2009/10 to 2021/22

     School capacity in England from 2009/10 to 2021/22. This includes: number of schools , number of school places, number of pupils on roll, number of schools at or in excess of capacity, pupils in places that exceed their school's capacity, pupils in places that exceed their school's capacity as a percentage of total places, number of schools with one or more unfilled places, unfilled places and unfilled places as a percentage of total places

   • School sixth form capacity, by local authority, 2021/22

     Number of schools with reported sixth form capacity, reported sixth form places and Sixth form pupils on roll in schools with reported sixth form capacity, by local authority, 2021/22

   If you can't find the table you're looking for, then you can