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: School capacity - national only

3. Step 3

   • National:
     • England

4. Step 4

   • Time period: 2009/10 to 2020/21

5. Step 5

   • Indicators:
     • Number of pupils on roll
     • Number of school places
     • Number of schools
     • Number of schools at or in excess of capacity
     • Pupils in places that exceed their school's capacity
   • School phase:
     • Primary
     • Secondary

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

   'School capacity - national only' for Primary and Secondary in England between 2009/10 and 2020/21

   		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	Unfilled places as a percentage of total places
   Primary	2009/10	16,964	4,227,527	3,810,779	3,444	41,677	1.0%	13,520	458,425	10.8%
   	2010/11	16,873	4,253,301	3,845,738	3,438	36,845	0.9%	13,435	444,408	10.4%
   	2011/12	16,812	4,313,770	3,912,538	3,423	31,494	0.7%	13,389	432,726	10.0%
   	2012/13	16,775	4,416,208	4,011,425	3,514	30,276	0.7%	13,261	435,059	9.9%
   	2013/14	16,766	4,528,023	4,111,660	3,697	30,737	0.7%	13,069	447,100	9.9%
   	2014/15	16,759	4,633,934	4,210,503	3,807	30,539	0.7%	12,952	453,970	9.8%
   	2015/16	16,771	4,737,900	4,307,008	3,781	30,173	0.6%	12,990	461,065	9.7%
   	2016/17	16,782	4,804,157	4,381,270	3,826	29,974	0.6%	12,955	452,791	9.4%
   	2017/18	16,771	4,863,329	4,423,856	3,519	27,441	0.6%	13,251	466,824	9.6%
   	2018/19	16,769	4,896,469	4,439,571	3,340	25,481	0.5%	13,428	482,335	9.9%
   	2019/20	x	x	x	x	x	x	x	x	x
   	2020/21	16,791	4,943,111	4,403,235	2,785	20,930	0.4%	14,003	560,585	11.3%
   Secondary	2009/10	3,312	3,563,118	3,263,405	930	55,541	1.6%	2,382	355,254	10.0%
   	2010/11	3,300	3,608,971	3,252,983	837	40,256	1.1%	2,463	396,244	11.0%
   	2011/12	3,260	3,600,793	3,225,543	694	30,769	0.9%	2,566	406,019	11.3%
   	2012/13	3,274	3,637,301	3,191,472	582	23,612	0.6%	2,692	469,441	12.9%
   	2013/14	3,321	3,711,807	3,167,115	498	18,980	0.5%	2,823	563,672	15.2%
   	2014/15	3,356	3,755,545	3,163,191	500	19,790	0.5%	2,856	612,144	16.3%
   	2015/16	3,375	3,787,836	3,171,447	487	20,073	0.5%	2,888	636,462	16.8%
   	2016/17	3,379	3,811,284	3,197,519	548	24,171	0.6%	2,831	637,936	16.7%
   	2017/18	3,376	3,848,042	3,230,941	512	22,162	0.6%	2,863	639,167	16.6%
   	2018/19	3,389	3,897,512	3,301,023	562	24,915	0.6%	2,826	621,308	15.9%
   	2019/20	x	x	x	x	x	x	x	x	x
   	2020/21	3,392	3,962,856	3,469,500	752	35,438	0.9%	2,639	528,746	13.3%

   Footnotes

   1. z - Indicates data is not applicable.
   2. Includes community, foundation, voluntary and middle schools as deemed. Includes academies/free schools. Includes sixth form places. Excludes all special schools. Excludes nursery places.
   3. Primary places include all reported capacity in middle deemed primary schools and secondary places include all reported capacity in middle-deemed secondary and all-through schools.
   4. Number of pupils in places that exceed their school's capacity is the difference between school capacity and number of pupils on roll, calculated at school level and then aggregated to national, regional or local authority level.
   5. X - indicates data not available. 2019/20 data not available due to the cancellation of the 2020 School Capacity survey due to Covid-19.

   Save table

   Related information

   • Publication: School capacity, Academic Year 2020/21