Data set from Schools, pupils and their characteristics

School level

Latest data
API data set version 1.0
Published
Last updated
Number and percentage of pupils in England at school level, by phase, school type, admissions policy, sex, urban or rural classification, and other breakdowns including age and denomination.

Data set details

Theme
Pupils and schools
Publication
Schools, pupils and their characteristics
API data set ID
019e7403-4523-7749-b530-159f451dd83c
How do I use this ID?
Release type
Number of rows
5,071,293
Geographic levels
School
Indicators
  • Breakdown topic
  • Number of pupils
  • Percentage of pupils
  • School open date
  • School postcode
Filters
  • Admissions policy
  • All through school description
  • Attendance
  • Breakdown
  • Hospital school flag
  • Middle school description
  • Phase type of school
  • Religious denomination
  • School type (detailed)
  • Sex
  • Sex of school description
  • Urban or rural flag
Time period
2025/26

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameregion_nameregion_codeschool_urnold_la_codenew_la_codela_nameestabschool_nameschool_laestabphase_type_groupingtrustopen_datesex_of_school_descriptionestablishment_typemiddle_schoolall_throughhospital_schoolreligious_denominationadmissions_policydistrict_administrative_codedistrict_administrative_namepcon_codepcon_nameward_codeward_nameurban_ruralschool_postcodeacademy_flagschool_sizeschool_timeattendance_patternsexbreakdown_topicbreakdownpupil_countpupil_percent
202526Academic yearSchoolE92000001EnglandLondonE120000071e+05201E09000001City of London3614The Aldgate School2013614State-funded primaryzMixedVoluntary aided schoolNoNoNoChurch of EnglandNot applicableE09000001City of LondonE14001172Cities of London and WestminsterE05009291BillingsgateUrban: Nearer to a major town or cityEC3A 5DELA Maintained201 to 300 pupils32.50Part-timeFemaleAgeAged 00x
202526Academic yearSchoolE92000001EnglandLondonE120000071e+05201E09000001City of London3614The Aldgate School2013614State-funded primaryzMixedVoluntary aided schoolNoNoNoChurch of EnglandNot applicableE09000001City of LondonE14001172Cities of London and WestminsterE05009291BillingsgateUrban: Nearer to a major town or cityEC3A 5DELA Maintained201 to 300 pupils32.50Part-timeFemaleAgeAged 10x
202526Academic yearSchoolE92000001EnglandLondonE120000071e+05201E09000001City of London3614The Aldgate School2013614State-funded primaryzMixedVoluntary aided schoolNoNoNoChurch of EnglandNot applicableE09000001City of LondonE14001172Cities of London and WestminsterE05009291BillingsgateUrban: Nearer to a major town or cityEC3A 5DELA Maintained201 to 300 pupils32.50Part-timeFemaleAgeAged 20x
202526Academic yearSchoolE92000001EnglandLondonE120000071e+05201E09000001City of London3614The Aldgate School2013614State-funded primaryzMixedVoluntary aided schoolNoNoNoChurch of EnglandNot applicableE09000001City of LondonE14001172Cities of London and WestminsterE05009291BillingsgateUrban: Nearer to a major town or cityEC3A 5DELA Maintained201 to 300 pupils32.50Part-timeFemaleAgeAged 30x
202526Academic yearSchoolE92000001EnglandLondonE120000071e+05201E09000001City of London3614The Aldgate School2013614State-funded primaryzMixedVoluntary aided schoolNoNoNoChurch of EnglandNot applicableE09000001City of LondonE14001172Cities of London and WestminsterE05009291BillingsgateUrban: Nearer to a major town or cityEC3A 5DELA Maintained201 to 300 pupils32.50Part-timeFemaleAgeAged 40x

Variables in this data set

Table showing all 17 variables
Variable nameVariable description
admissions_policyAdmissions policy
all_throughAll through school description
attendance_patternAttendance - Full-time, Part-time
breakdownBreakdown - filter by breakdown
breakdown_topicBreakdown topic
establishment_typeSchool type (detailed) - For example - academy converter, community school, independent special
hospital_schoolHospital school flag - Yes/No
middle_schoolMiddle school description
open_dateSchool open date
phase_type_groupingPhase type of school - Phase (primary, secondary, special, PRU, independent)
pupil_countNumber of pupils
pupil_percentPercentage of pupils
religious_denominationReligious denomination
school_postcodeSchool postcode
sexSex - male, female
sex_of_school_descriptionSex of school description - Mixed, boys, girls
urban_ruralUrban or rural flag

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 level
API data set ID
019e7403-4523-7749-b530-159f451dd83c
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 level statistics and data:

Schools and Pupils Statistics Team

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