Data set from Key stage 2 attainment

Key stage 2 institution level - Schools (School information)

Latest data
API data set version 1.0.1
Published
Last updated
This file contains data on the information of primary schools at institution level.

Data set details

Theme
School and college outcomes and performance
Publication
Key stage 2 attainment
API data set ID
019afee4-ba17-73cb-85e0-f88c101bb734
How do I use this ID?
Release type
Number of rows
16,408
Geographic levels
School
Indicators
  • Cohort level key stage 1 average points score
  • Eligible boys on school roll at time of tests
  • Eligible girls on school roll at time of tests
Filters
  • Age range
  • Closed Flag
  • Converter academy: URN
Time period
2024/25

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_namealphaindversionold_la_codenew_la_codela_nameschool_laestabestabschool_urnschool_namefull_addressaddress1address2address3telnumpcon_codepcon_nameurn_acschool_name_acopen_acnftypeiclosereldenomagerangetab15tab1618totpupstpupyearteligbeliggeligpbeligpgeligtks1averagetks1group_lptks1group_ltks1group_mptks1group_mtks1group_hptks1group_htks1group_naptks1group_natfsm6cla1aptfsm6cla1atnotfsm6cla1aptnotfsm6cla1atealgrp2ptealgrp2tmobnptmobntealgrp1ptealgrp1tealgrp3ptealgrp3tsenelepseneletsenelkpsenelktsenelekpsenelektelig_3yrtelig_23ptfsm6cla1a_23ptnotfsm6cla1a_23
202425Academic yearSchoolE92000001England372Final201E09000001City of London20136143614100000The Aldgate SchoolSt James's Passage, Duke's Place, z, London, EC3A 5DESt James's PassageDuke's Placez02072831147E14001172Cities of London and Westminster0zzVA0Church of England3 to 1100249303018126040zzzzzzzzz5172583217027909300013827930116582278
202425Academic yearSchoolE92000001England24800Final202E09000007Camden20220002000136807St Luke's Church of England SchoolKidderpore Avenue, z, z, London, NW3 7SUKidderpore Avenuezz02074355604E14001265Hampstead and Highgate0zzF0Church of England4 to 1100901210464060zzzzzzzzz33077022010100880000033033041153367
202425Academic yearSchoolE92000001England4Final202E09000007Camden20220012001139837Abacus Belsize Primary SchoolJubilee Waterside Centre, 105 Camley Street, z, London, N1C 4PFJubilee Waterside Centre105 Camley Streetz02073878018E14001290Holborn and St Pancras0zzF0None4 to 110015818198114258zzzzzzzzz842115831614741684000042142138102080
202425Academic yearSchoolE92000001England14096Final202E09000007Camden20220022002140686Kings Cross AcademyPlimsoll Building, 4 Wollstonecraft Street, z, London, N1C 4BTPlimsoll Building4 Wollstonecraft Streetz02075040533E14001290Holborn and St Pancras0zzAC0None3 to 1100388565432225941zzzzzzzzz31572343112045834380001213241426152464159
202425Academic yearSchoolE92000001England910Final202E09000007Camden20220192019100008Argyle Primary SchoolTonbridge Street, z, z, London, WC1H 9EGTonbridge Streetzz02078374590E14001290Holborn and St Pancras0zzCY0Does not apply3 to 110027830278193070zzzzzzzzz1659114125932696270014415519104516139

Variables in this data set

Table showing first 5 of 49 variables
Variable nameVariable description
agerangeAge range
beligEligible boys on school roll at time of tests
full_addressFull address of the school
geligEligible girls on school roll at time of tests
icloseClosed Flag

Footnotes

  1. Figures for all years based on Final data as of April 2026 update.

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
Key stage 2 institution level - Schools (School information)
API data set ID
019afee4-ba17-73cb-85e0-f88c101bb734
API data set version
1.0.1

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.


API data set changelog

Patch changes for version 1.0.1

This version introduces patch changes that are unlikely to affect consumers of the previous version. You may wish to check the list of changes below before upgrading.

Updated Age range filter options

  • 0-11 (id: zqJFQ):
    • label changed to: 0 to 11
  • 0-16 (id: kVahs):
    • label changed to: 0 to 16
  • 0-18 (id: uz4o4):
    • label changed to: 0 to 18
  • 01-Nov (id: XwFfK):
    • label changed to: 1 to 11
  • 02-Dec (id: Tf9PJ):
    • label changed to: 2 to 12
  • 02-Nov (id: coK31):
    • label changed to: 2 to 11
  • 03-Nov (id: 5Bmdi):
    • label changed to: 3 to 11
  • 04-Nov (id: tZIEm):
    • label changed to: 4 to 11
  • 05-Dec (id: fbVYF):
    • label changed to: 5 to 12
  • 05-Nov (id: jMYAM):
    • label changed to: 5 to 11
  • 05-Oct (id: eHLuS):
    • label changed to: 5 to 10
  • 06-Nov (id: TfaPJ):
    • label changed to: 6 to 11
  • 07-Nov (id: h5KyW):
    • label changed to: 7 to 11
  • 09-Dec (id: mJ89K):
    • label changed to: 9 to 12
  • Apr-13 (id: giSO9):
    • label changed to: 4 to 13
  • Apr-14 (id: AKpGK):
    • label changed to: 4 to 14
  • Apr-15 (id: VIL5X):
    • label changed to: 4 to 15
  • Apr-16 (id: PY8eb):
    • label changed to: 4 to 16
  • Apr-17 (id: 1y7i3):
    • label changed to: 4 to 17
  • Apr-18 (id: d730Z):
    • label changed to: 4 to 18
  • Apr-19 (id: uzKo4):
    • label changed to: 4 to 19
  • Aug-16 (id: luGcB):
    • label changed to: 8 to 16
  • Aug-18 (id: UpQRF):
    • label changed to: 8 to 18
  • Aug-19 (id: oFrmX):
    • label changed to: 8 to 19
  • Feb-16 (id: rWnNj):
    • label changed to: 2 to 16
  • Feb-17 (id: G1mgr):
    • label changed to: 2 to 17
  • Feb-18 (id: 3mX8u):
    • label changed to: 2 to 18
  • Feb-19 (id: SCMVx):
    • label changed to: 2 to 19
  • Jul-13 (id: ydOaB):
    • label changed to: 7 to 13
  • Jul-14 (id: RSGka):
    • label changed to: 7 to 14
  • Jul-16 (id: b8otT):
    • label changed to: 7 to 16
  • Jul-18 (id: DleQe):
    • label changed to: 7 to 18
  • Jul-19 (id: eHEuS):
    • label changed to: 7 to 19
  • Jun-16 (id: 5BQdi):
    • label changed to: 6 to 16
  • Jun-19 (id: 4nCUZ):
    • label changed to: 6 to 19
  • Mar-14 (id: mJO9K):
    • label changed to: 3 to 14
  • Mar-16 (id: 0XqT5):
    • label changed to: 3 to 16
  • Mar-18 (id: WPv2b):
    • label changed to: 3 to 18
  • Mar-19 (id: EsLqF):
    • label changed to: 3 to 19
  • May-14 (id: Qchwb):
    • label changed to: 5 to 14
  • May-16 (id: 9vf4v):
    • label changed to: 5 to 16
  • May-18 (id: 2e5lz):
    • label changed to: 5 to 18
  • May-19 (id: PYBeb):
    • label changed to: 5 to 19
  • Nov-16 (id: N2aDC):
    • label changed to: 11 to 16
  • Nov-19 (id: w3lbx):
    • label changed to: 11 to 19
  • Oct-13 (id: oFzmX):
    • label changed to: 10 to 13
  • Oct-16 (id: 9vv4v):
    • label changed to: 10 to 16
  • Oct-18 (id: d7X0Z):
    • label changed to: 10 to 18
  • Oct-19 (id: O6NCL):
    • label changed to: 10 to 19
  • Sep-13 (id: 7QtXo):
    • label changed to: 9 to 13
  • Sep-16 (id: pO7So):
    • label changed to: 9 to 16
  • Sep-18 (id: INtBz):
    • label changed to: 9 to 18
  • Sep-19 (id: ia36X):
    • label changed to: 9 to 19

Updated School telephone number filter options

  • 4.41236E+11 (id: f5rIY):
    • label changed to: 441235532358
  • 4.41255E+11 (id: jY3tA):
    • label changed to: 441254812581
  • 4.41442E+11 (id: eaBTu):
    • label changed to: 441442217893

Changes to indicators

Updated
  • Cohort level key stage 1 average points score (id: jiFAM, column: tks1average):
    • Eligible boys on school roll at time of tests (id: eJluS, column: belig):
      • Eligible girls on school roll at time of tests (id: Tz2PJ, column: gelig):
        • No. of pupils in KS1 group not calculable (id: hT6yW, column: tks1group_na):
          • Number of eligible pupils 2023 (id: mpx9K, column: telig_23):
            • Number of eligible pupils classified as non-mobile (id: gNdO9, column: tmobn):
              • Number of eligible pupils with EHC plan (id: A65GK, column: tsenele):
                • Number of eligible pupils with English as additional language (EAL) (id: VXl5X, column: tealgrp2):
                  • Number of eligible pupils with English as first language (id: PFxeb, column: tealgrp1):
                    • Number of eligible pupils with SEN (EHC plan or SEN support) (id: 1WYi3, column: tsenelek):
                      • Number of eligible pupils with SEN support (id: dYs0Z, column: tsenelk):
                        • Number of eligible pupils with unclassified language (id: uv6o4, column: tealgrp3):
                          • Number of key stage 2 disadvantaged pupils (id: l9CcB, column: tfsm6cla1a):
                            • Number of key stage 2 pupils who are not disadvantaged (id: U5tRF, column: tnotfsm6cla1a):
                              • Number of pupils aged 11 (id: onQmX, column: tpupyear):
                                • Number of pupils in cohort high KS1 attainment (id: rcVNj, column: tks1group_h):
                                  • Number of pupils in cohort with low KS1 attainment (id: GrUgr, column: tks1group_l):
                                    • Number of pupils in cohort with medium KS1 attainment (id: 3UH8u, column: tks1group_m):
                                      • Published eligible pupil number (id: ws8bx, column: telig):
                                        • School published in school and college (key stage 5) performance tables (id: onvmX, column: tab1618):
                                          • School published in secondary school (key stage 4) performance tables (id: 9SS4v, column: tab15):
                                            • Total number of pupils (including part-time pupils) (id: dYH0Z, column: totpups):
                                              New
                                              • Number of pupils at the end of key stage 2 over the past three years (id: PoXOe)


                                              Contact us

                                              If you have a specific enquiry about Key stage 2 institution level - Schools (School information) statistics and data:

                                              Primary Attainment Statistics

                                              Email: Primary.Attainment@education.gov.uk
                                              Contact name: Lilian Williams