Data set from Schools, pupils and their characteristics

School characteristics by age, sex and attendance pattern

Latest data
API data set version 1.0
Published
Last updated
Number of schools and pupils in England, by type, phase, denomination, admissions policy, sex, urban or rural classification and academy status, including pupil counts by age.

Data set details

Theme
Pupils and schools
Publication
Schools, pupils and their characteristics
API data set ID
019e7401-bedb-711a-ae3d-836fbca519f3
How do I use this ID?
Release type
Number of rows
2,846,580
Geographic levels
Local authority, National, Parliamentary constituency, Regional
Indicators
  • Count of pupils aged 0
  • Count of pupils aged 1
  • Count of pupils aged 10
  • Count of pupils aged 11
  • Count of pupils aged 12
  • Count of pupils aged 13
  • Count of pupils aged 14
  • Count of pupils aged 15
  • Count of pupils aged 16
  • Count of pupils aged 17
  • Count of pupils aged 18
  • Count of pupils aged 19
  • Count of pupils aged 2
  • Count of pupils aged 3
  • Count of pupils aged 4
  • Count of pupils aged 5
  • Count of pupils aged 6
  • Count of pupils aged 7
  • Count of pupils aged 8
  • Count of pupils aged 9
  • Count of pupils of all ages
  • Number of schools
Filters
  • Academy indicator
  • Attendance type
  • Denomination
  • Pupil sex
  • School admissions policy
  • School type
  • School type (detailed)
  • Sex of school description
  • Urban or rural indicator
Time period
2015/16 to 2025/26

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameregion_coderegion_namenew_la_codeold_la_codela_namepcon_codepcon_namesex_of_school_descriptionphase_type_groupingtype_of_establishmentdenominationadmissions_policyurban_ruralacademy_flagattendance_patternsexschool_counttotal_pupil_countaged_0_pupil_countaged_1_pupil_countaged_2_pupil_countaged_3_pupil_countaged_4_pupil_countaged_5_pupil_countaged_6_pupil_countaged_7_pupil_countaged_8_pupil_countaged_9_pupil_countaged_10_pupil_countaged_11_pupil_countaged_12_pupil_countaged_13_pupil_countaged_14_pupil_countaged_15_pupil_countaged_16_pupil_countaged_17_pupil_countaged_18_pupil_countaged_19_pupil_count
202526Academic yearLocal authorityE92000001EnglandE12000004East MidlandsE10000007830DerbyshireMixedIndependent schoolTotalTotalTotalTotalTotalTotalTotal283252819409711476110131173154202239255276358343318294378
202526Academic yearLocal authorityE92000001EnglandE12000004East MidlandsE10000007830DerbyshireMixedIndependent schoolTotalTotalTotalTotalTotalTotalMale281866492053633660709687106156152147216201198171174
202526Academic yearLocal authorityE92000001EnglandE12000004East MidlandsE10000007830DerbyshireMixedIndependent schoolTotalTotalTotalTotalTotalTotalFemale28138641020445140506177679683103129142142120123204
202526Academic yearLocal authorityE92000001EnglandE12000004East MidlandsE10000007830DerbyshireMixedIndependent schoolTotalTotalTotalTotalTotalFull timeTotal28310702153111071106127170151201238254275356343318294378
202526Academic yearLocal authorityE92000001EnglandE12000004East MidlandsE10000007830DerbyshireMixedIndependent schoolTotalTotalTotalTotalTotalPart timeTotal2814581725664544331111200000

Variables in this data set

Table showing all 31 variables
Variable nameVariable description
academy_flagAcademy indicator - Academy or otherwise
admissions_policySchool admissions policy - Selective or otherwise
aged_0_pupil_countCount of pupils aged 0
aged_1_pupil_countCount of pupils aged 1
aged_10_pupil_countCount of pupils aged 10
aged_11_pupil_countCount of pupils aged 11
aged_12_pupil_countCount of pupils aged 12
aged_13_pupil_countCount of pupils aged 13
aged_14_pupil_countCount of pupils aged 14
aged_15_pupil_countCount of pupils aged 15
aged_16_pupil_countCount of pupils aged 16
aged_17_pupil_countCount of pupils aged 17
aged_18_pupil_countCount of pupils aged 18
aged_19_pupil_countCount of pupils aged 19
aged_2_pupil_countCount of pupils aged 2
aged_3_pupil_countCount of pupils aged 3
aged_4_pupil_countCount of pupils aged 4
aged_5_pupil_countCount of pupils aged 5
aged_6_pupil_countCount of pupils aged 6
aged_7_pupil_countCount of pupils aged 7
aged_8_pupil_countCount of pupils aged 8
aged_9_pupil_countCount of pupils aged 9
attendance_patternAttendance type - Pupil attendance full time or part time
denominationDenomination - Religious denomination
phase_type_groupingSchool type - Filter by school type
school_countNumber of schools
sexPupil sex - Sex of pupils
sex_of_school_descriptionSex of school description - Mixed, boys, girls
total_pupil_countCount of pupils of all ages
type_of_establishmentSchool type (detailed) - Filter by school type (further detail)
urban_ruralUrban or rural indicator - Urban or rural indicator

Footnotes

  1. Totals include state-funded nursery, primary, secondary, alternative provision (AP) schools and special schools, and non-maintained special schools. Does not include independent schools nor general hospital schools. This is because independent and hospital schools submit an aggregate school level census that does not include characteristics breakdowns such as ethnicity, age and language.
  2. Prior to 2023/24 schools were required to record pupils' gender, which was coded as male /female and reported in the publication as boys/girls. From 2023/24 the variable has been clarified to reflect the pupil's legal sex and is both recorded and reported as male/female. The figures are reported here as constituting a single time series.

Using this data

  • Download the underlying data as a compressed ZIP file

  • View or create your own tables

    View tables that we have built for you, or create your own tables from open data using our table tool


Using the API

  • API documentation

    This data set is available via an API, follow the link to get all the information to get started. The documentation provides full guidance and examples on how to make the most from our data sets.

  • Building API integrations

    To support building integrations on top of the explore education statistics API, software development kits (SDKs) are provided to streamline common tasks and communication with the API.

API data set details

API data set name
School characteristics by age ,sex and attendance pattern
API data set ID
019e7401-bedb-711a-ae3d-836fbca519f3
API data set version
1.0

Download data set as CSV

Get familiar with the data. The CSV response will render its categories and column headers in a human-readable format (instead of machine-readable IDs).

Guidance: Download data set as CSV

Data set metadata

Look up human-readable labels and their corresponding machine-readable IDs to help you create data set queries.

Guidance: Get data set metadata

Query data set using GET

Quickly test the machine-readable IDs in a range of basic queries.

Guidance: Query data set (GET)

Query data set using POST

The POST endpoint is recommended for production level pipeline queries. POST requires a query to be built and supplied in JSON format using third party software such as Postman and Insomnia or programming languages such as Python, R, etc.

Guidance: Query data set (POST)

Get data set summary

Guidance: Get data set summary


API data set version history

API data set updates come in 3 forms: Major, Minor and Patch.

  • Major update (e.g. 1.x.x to 2.0.0): a breaking change meaning the removal of columns or rows from the data set.
  • Minor update (e.g. 1.1.x to 1.2.0): non-breaking changes made as part of a new release (likely with new / additional data).
  • Patch update (e.g. 1.1.0 to 1.1.1): a non-breaking change made as part of a release amendment (e.g. data corrections).

More detailed information on versioning can be found in our Versioning - Explore education statistics API.


Contact us

If you have a specific enquiry about School characteristics by age, sex and attendance pattern statistics and data:

Schools and Pupils Statistics Team

Email: schools.statistics@education.gov.uk
Contact name: Schools and Pupils Statistics Team