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: Schools, pupils and their characteristics

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.

   • Alternative provision - by gender - 2017/18 to 2021/22

     Table showing the number of pupils in other local authority funded alternative provision from 2017/18 to 2021/22, by gender

   • Class sizes for state-funded primary and state-funded secondary, 2015/16 to 2021/22

     Table showing the average class size across all classes in primary and secondary schools, 2015/16 to 2021/22

   • Cross border movements - National, by school type (non-boarders), 2021/22

     Location of pupil residence (local authority) by location of school (local authority) for pupils in years reception to year 11 or year X attending state-funded primary and secondary schools or special schools.

   • English spoken as an additional language by local authority and region

     Percentage of pupils who spoke English as an additional language in 2021/22 by region and local authority for pupils in state-funded nursery, state-funded primary, state-funded secondary, state-funded and non-maintained special schools and pupil referral units

   • First language, number and percentage of pupils by school type, 2020/21 to 2021/22

     Table showing the number and percentage of pupils whose first language is known or believed to be English, or known or believed not to be English, by school type, 2020/21 to 2021/22

   • Free school meals, by region, 2015/16 to 2021/22

     Percentage of pupils known to be eligible for free school meals by region, England, 2015/16 and 2021/22

   • Free School Meals - Number and percentage of pupil, by school type, 2015/16 to 2021/22

     Includes the number and percentage of pupils eligible for free school meals in England, by school type, 2015/16 to 2021/22

   • FSM eligibility by region and local authority 2021/22

     Percentage of pupils eligible for free school meals in 2021/22 by region and local authority, including state-funded nursery, state-funded primary, state-funded secondary, state-funded and non-maintained special schools and pupil referral units

   • Number and percentage of pupils by ethnicity, 2019/20 to 2021/22

     Table showing the number and percentage of pupils by ethnicity for schools in England, 2019/20 to 2021/22

   • Number of schools and number of pupils attending by type of school (Academy/Local Authority maintained/Independent), 2015/16 to 2021/22

     Table showing the number of schools and number of pupils attending by type of school (Academy/Local Authority maintained/Independent), 2015/16 to 2021/22

   • Number of schools and pupils, by school type, 2015/16 to 2021/22

     Number of schools and pupils, by school type, 2015/16 to 2020/22, includes state-funded schools, non-maintained special schools and independent schools

   • Time series - Number of pupils, by school type, 2015/16 to 2021/22

     Table shows headcount for all pupils, by school type, 2015/16 to 2021/22. Includes state-funded nursery, primary, secondary, special, non-maintained special, pupil referral units and independent schools

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