Data set from Key stage 2 attainment

Attainment by parliamentary constituency

Not the latest data
API data set version 1.1
Published
Last updated
This file contains data on the attainment of pupils in key stage 2 assessments in England, broken down by parliamentary constituency.

Data set details

Theme
School and college outcomes and performance
Publication
Key stage 2 attainment
API data set ID
c52e9901-e8ef-0376-b9e9-59abfb4db747
How do I use this ID?
Release type
Number of rows
16,320
Geographic levels
National, Parliamentary constituency
Indicators
  • Average progress score
  • Average scaled score
  • Lower confidence interval
  • Number of average scaled score calculation
  • Number of eligible pupils at the end of key stage 2
  • Number of eligible pupils included in the progress measure
  • Number of pupils absent
  • Number of pupils disapplied
  • Number of pupils just arrived or unable to access
  • Number of pupils meeting the expected standard
  • Number of pupils meeting the higher standard
  • Number of pupils not achieved expected standard
  • Number of pupils working at pre-key stage standard 1 in writing TA
  • Number of pupils working at pre-key stage standard 2 in writing TA
  • Number of pupils working at pre-key stage standard 3 in writing TA
  • Number of pupils working at pre-key stage standard 4 in writing TA
  • Number of pupils working at pre-key stage standard 5 in writing TA
  • Number of pupils working at pre-key stage standard 6 in writing TA
  • Number of pupils working at the engagement model or below pre-key stage standards in writing TA
  • Number of pupils working below the standard
  • Number of pupils working towards the expected standard in writing TA
  • Number of schools
  • Percentage of pupils absent
  • Percentage of pupils disapplied
  • Percentage of pupils just arrived or unable to access
  • Percentage of pupils meeting the expected standard
  • Percentage of pupils meeting the higher standard
  • Percentage of pupils not achieved expected standard
  • Percentage of pupils working at pre-key stage standard 1 in writing TA
  • Percentage of pupils working at pre-key stage standard 2 in writing TA
  • Percentage of pupils working at pre-key stage standard 3 in writing TA
  • Percentage of pupils working at pre-key stage standard 4 in writing TA
  • Percentage of pupils working at pre-key stage standard 5 in writing TA
  • Percentage of pupils working at pre-key stage standard 6 in writing TA
  • Percentage of pupils working at the engagement model or below pre-key stage standards in writing TA
  • Percentage of pupils working below the standard
  • Percentage of pupils working towards the expected standard in writing TA
  • Sum of scaled scores
  • Total number of progress scores
  • Upper confidence interval
Filters
  • Subjects
Time period
2018/19 to 2024/25

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_namepcon_codepcon_nameversionestablishment_type_groupsubjectsexestablishment_counteligible_pupil_countexpected_standard_pupil_counthigher_standard_pupil_countnot_meeting_pupil_countworking_below_pupil_countabsent_pupil_countunable_to_access_arrived_pupil_countscaled_scores_eligible_pupil_countscaled_scores_totalprogress_measure_eligible_pupil_countprogress_measure_total_scoreworking_towards_pupil_countpre_ks_std_6_pupil_countpre_ks_std_5_pupil_countpre_ks_std_4_pupil_countpre_ks_std_3_pupil_countpre_ks_std_2_pupil_countpre_ks_std_1_pupil_countengagement_model_or_below_pre_ks_std_pupil_countdisapplied_pupil_countexpected_standard_pupil_percenthigher_standard_pupil_percentnot_meeting_pupil_percentworking_below_pupil_percentabsent_pupil_percentunable_to_access_arrived_pupil_percentaverage_scaled_scoreprogress_measure_scoreprogress_measure_upper_conf_intervalprogress_measure_lower_conf_intervalworking_towards_pupil_percentpre_ks_std_6_pupil_percentpre_ks_std_5_pupil_percentpre_ks_std_4_pupil_percentpre_ks_std_3_pupil_percentpre_ks_std_2_pupil_percentpre_ks_std_1_pupil_percentengagement_model_or_below_pre_ks_std_pupil_percentdisapplied_pupil_percentunable_to_access_pupil_countgrowing_dev_of_expected_std_pupil_countearly_dev_of_expected_std_pupil_countfoundations_of_expected_std_pupil_countbelow_interim_pre_ks_std_pupil_countunable_to_access_pupil_percentgrowing_dev_of_expected_std_pupil_percentearly_dev_of_expected_std_pupil_percentfoundations_of_expected_std_pupil_percentbelow_interim_pre_ks_std_pupil_percent
201819Academic yearNationalE92000001EnglandFinalAll state fundedReading, writing and mathsTotal1586863972941812668077zzzzzzzzzzzzzzzzz6511zzzzzzzzzzzzzzzzzzzzzzzzzzz
201819Academic yearNationalE92000001EnglandFinalAll state fundedReadingTotal158686398924720991743201485701694213576646196466473460960929517921.48753zzzzzzzzz7427233001040.0294134820.0449151920.013911772zzzzzzzzzzzzzzzzzzz
201819Academic yearNationalE92000001EnglandFinalAll state fundedGrammar, punctuation and spellingTotal1586863985350238723001411876016338146462462093966054006zzzzzzzzzzz793619300106zzzzzzzzzzzzzzzzzzzzzz
201819Academic yearNationalE92000001EnglandFinalAll state fundedMathsTotal158686398475061891716631149901598716836446207556523013860894221274.15906zzzzzzzzz7927182001050.0349362650.048473980.02139855zzzzzzzzzzzzzzzzzzz
201819Academic yearNationalE92000001EnglandFinalAll state fundedWritingTotal15868639781505114129783zz491zzz61263318464.1422610614311291625426641909160416492194z7920zz0zz0.0301389940.0443977450.015880243172100000zzzzzzzzzzz

Variables in this data set

Table showing all 41 variables
Variable nameVariable description
absent_pupil_countNumber of pupils absent
absent_pupil_percentPercentage of pupils absent
average_scaled_scoreAverage scaled score
disapplied_pupil_countNumber of pupils disapplied
disapplied_pupil_percentPercentage of pupils disapplied
eligible_pupil_countNumber of eligible pupils at the end of key stage 2
engagement_model_or_below_pre_ks_std_pupil_countNumber of pupils working at the engagement model or below pre-key stage standards in writing TA
engagement_model_or_below_pre_ks_std_pupil_percentPercentage of pupils working at the engagement model or below pre-key stage standards in writing TA
establishment_countNumber of schools
expected_standard_pupil_countNumber of pupils meeting the expected standard
expected_standard_pupil_percentPercentage of pupils meeting the expected standard
higher_standard_pupil_countNumber of pupils meeting the higher standard
higher_standard_pupil_percentPercentage of pupils meeting the higher standard
not_meeting_pupil_countNumber of pupils not achieved expected standard
not_meeting_pupil_percentPercentage of pupils not achieved expected standard
pre_ks_std_1_pupil_countNumber of pupils working at pre-key stage standard 1 in writing TA
pre_ks_std_1_pupil_percentPercentage of pupils working at pre-key stage standard 1 in writing TA
pre_ks_std_2_pupil_countNumber of pupils working at pre-key stage standard 2 in writing TA
pre_ks_std_2_pupil_percentPercentage of pupils working at pre-key stage standard 2 in writing TA
pre_ks_std_3_pupil_countNumber of pupils working at pre-key stage standard 3 in writing TA
pre_ks_std_3_pupil_percentPercentage of pupils working at pre-key stage standard 3 in writing TA
pre_ks_std_4_pupil_countNumber of pupils working at pre-key stage standard 4 in writing TA
pre_ks_std_4_pupil_percentPercentage of pupils working at pre-key stage standard 4 in writing TA
pre_ks_std_5_pupil_countNumber of pupils working at pre-key stage standard 5 in writing TA
pre_ks_std_5_pupil_percentPercentage of pupils working at pre-key stage standard 5 in writing TA
pre_ks_std_6_pupil_countNumber of pupils working at pre-key stage standard 6 in writing TA
pre_ks_std_6_pupil_percentPercentage of pupils working at pre-key stage standard 6 in writing TA
progress_measure_eligible_pupil_countNumber of eligible pupils included in the progress measure
progress_measure_lower_conf_intervalLower confidence interval
progress_measure_scoreAverage progress score
progress_measure_total_scoreTotal number of progress scores
progress_measure_upper_conf_intervalUpper confidence interval
scaled_scores_eligible_pupil_countNumber of average scaled score calculation
scaled_scores_totalSum of scaled scores
subjectSubjects
unable_to_access_arrived_pupil_countNumber of pupils just arrived or unable to access
unable_to_access_arrived_pupil_percentPercentage of pupils just arrived or unable to access
working_below_pupil_countNumber of pupils working below the standard
working_below_pupil_percentPercentage of pupils working below the standard
working_towards_pupil_countNumber of pupils working towards the expected standard in writing TA
working_towards_pupil_percentPercentage of pupils working towards the expected standard in writing TA

Footnotes

  1. Data is not available for 2020 and 2021 as assessments were cancelled in these years due to the COVID-19 pandemic.
  2. Figures for 2025 are based on revised data. Figures for other years are based on final data.
  3. Science teacher assessment measures from 2019 onwards are not directly comparable to previous years due to changes in the science teacher assessment frameworks.
  4. 'All state funded' includes local authority maintained schools, academy sponsor led, academy converter, free schools and state funded special schools (including hospital schools).
  5. 'All state funded' includes local authority maintained schools, academy sponsor led, academy converter, free schools and state funded special schools (excluding hospital schools).

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
Attainment by parliamentary constituency
API data set ID
c52e9901-e8ef-0376-b9e9-59abfb4db747
API data set version
1.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.


Contact us

If you have a specific enquiry about Attainment by parliamentary constituency statistics and data:

Primary Attainment Statistics

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