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
    School capacity - national only
  3. Step 3 Choose Countries

    National
    • England
  4. Step 4 Choose time period

    Time period
    2009/10 to 2020/21
  5. Step 5 Choose your filters

    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
    • 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
    School phase
    • Primary
    • Secondary
  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
    Primary
    Secondary
    Row group 2
    2009/10
    2010/11
    2011/12
    2012/13
    2013/14
    2014/15
    2015/16
    2016/17
    2017/18
    2018/19
    2019/20
    2020/21
    Column groups
    Column group 1
    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
    This is the latest data
    'School capacity - national only' for Primary and Secondary in England between 2009/10 and 2020/21
    Number of schoolsNumber of school placesNumber of pupils on rollNumber of schools at or in excess of capacityPupils in places that exceed their school's capacityPupils in places that exceed their school's capacity as a percentage of total placesNumber of schools with one or more unfilled placesUnfilled placesUnfilled places as a percentage of total places
    Primary2009/1016,9644,227,5273,810,7793,44441,6771.0%13,520458,42510.8%
    2010/1116,8734,253,3013,845,7383,43836,8450.9%13,435444,40810.4%
    2011/1216,8124,313,7703,912,5383,42331,4940.7%13,389432,72610.0%
    2012/1316,7754,416,2084,011,4253,51430,2760.7%13,261435,0599.9%
    2013/1416,7664,528,0234,111,6603,69730,7370.7%13,069447,1009.9%
    2014/1516,7594,633,9344,210,5033,80730,5390.7%12,952453,9709.8%
    2015/1616,7714,737,9004,307,0083,78130,1730.6%12,990461,0659.7%
    2016/1716,7824,804,1574,381,2703,82629,9740.6%12,955452,7919.4%
    2017/1816,7714,863,3294,423,8563,51927,4410.6%13,251466,8249.6%
    2018/1916,7694,896,4694,439,5713,34025,4810.5%13,428482,3359.9%
    2019/20xxxxxxxxx
    2020/2116,7914,943,1114,403,2352,78520,9300.4%14,003560,58511.3%
    Secondary2009/103,3123,563,1183,263,40593055,5411.6%2,382355,25410.0%
    2010/113,3003,608,9713,252,98383740,2561.1%2,463396,24411.0%
    2011/123,2603,600,7933,225,54369430,7690.9%2,566406,01911.3%
    2012/133,2743,637,3013,191,47258223,6120.6%2,692469,44112.9%
    2013/143,3213,711,8073,167,11549818,9800.5%2,823563,67215.2%
    2014/153,3563,755,5453,163,19150019,7900.5%2,856612,14416.3%
    2015/163,3753,787,8363,171,44748720,0730.5%2,888636,46216.8%
    2016/173,3793,811,2843,197,51954824,1710.6%2,831637,93616.7%
    2017/183,3763,848,0423,230,94151222,1620.6%2,863639,16716.6%
    2018/193,3893,897,5123,301,02356224,9150.6%2,826621,30815.9%
    2019/20xxxxxxxxx
    2020/213,3923,962,8563,469,50075235,4380.9%2,639528,74613.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.
    6. 2009/10 national, regional and local authority aggregations exclude 13 secondary academies where no school capacity figure was provided. They are included in the school-level underlying data.
    7. For free schools, number of school places includes final intended capacity. Some free schools are initially in temporary accommodation and may not reach final intended capacity for varying periods of time.

    Save table

    Download Table

    Select file format:

    Related information