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

   • Subject: Local authority pupil forecasts

3. Step 3

   • National:
     • England

4. Step 4

   • Time period: 2020/21 to 2027/28

5. Step 5

   • Indicators:
     • Local authority pupil forecasts (includes 2020/21 actual pupil numbers)
   • Year group:
     • Reception
     • Year 01
     • Year 02
     • Year 03
     • Year 04

6. Step 6 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.

   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

   	Primary							Secondary
   	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
   2020/21	625,103	627,186	629,153	639,982	655,353	654,309	642,534	619,739	623,167	598,878	578,734	562,578	222,343	189,552
   2021/22	619,732	630,242	631,317	632,554	643,748	658,982	657,877	635,621	622,558	626,094	601,782	578,603	223,129	203,821
   2022/23	610,912	624,695	634,167	634,085	636,032	646,935	661,962	648,759	637,804	625,017	628,237	600,893	229,038	205,085
   2023/24	599,908	615,558	628,518	636,873	637,472	639,278	649,906	651,287	650,774	640,173	627,221	627,404	236,331	210,405
   2024/25	590,398	604,626	619,091	631,044	640,113	640,348	642,135	639,260	653,017	652,638	642,123	626,169	244,426	216,990
   2025/26	594,633	594,443	607,812	621,386	633,964	642,511	642,706	631,256	640,812	654,804	654,447	641,026	244,524	224,135
   2026/27	no data	no data	no data	no data	no data	no data	no data	631,227	632,466	642,186	656,159	652,877	249,070	224,171
   2027/28	no data	no data	no data	no data	no data	no data	no data	632,410	632,110	633,672	643,757	654,604	253,045	228,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

   Related information

   • Publication: School capacity, Academic Year 2020/21