Data set from Outcomes for children in need, including children looked after by local authorities in England

National - Key Stage 2 (KS2)

Not the latest data
Published
Last updated
Key Stage 2 attainment by special educational need, ethnicity, placement (children looked after only) and social care group.

Data set details

Theme
Children's social care
Publication
Outcomes for children in need, including children looked after by local authorities in England
Release type
Number of rows
1,177
Geographic levels
National
Indicators
  • Average progress score for maths
  • Average progress score for reading
  • Average progress score for writing TA
  • Lower confidence interval for maths progress
  • Lower confidence interval for reading progress
  • Lower confidence interval for writing TA progress
  • Number of eligible pupils in grammar, punctuation and spelling
  • Number of eligible pupils in maths
  • Number of eligible pupils in reading
  • Number of eligible pupils in reading, writing and maths
  • Number of eligible pupils in science TA
  • Number of eligible pupils in writing TA
  • Number of pupils meeting the expected standard in grammar, punctuation and spelling
  • Number of pupils meeting the expected standard in maths
  • Number of pupils meeting the expected standard in reading
  • Number of pupils meeting the expected standard in reading, writing and maths
  • Number of pupils meeting the expected standard in science TA
  • Number of pupils meeting the expected standard in writing TA
  • Percentage of pupils meeting the expected standard in grammar, punctuation and spelling
  • Percentage of pupils meeting the expected standard in maths
  • Percentage of pupils meeting the expected standard in reading
  • Percentage of pupils meeting the expected standard in reading, writing and maths (combined)
  • Percentage of pupils meeting the expected standard in science TA
  • Percentage of pupils meeting the expected standard in writing TA
  • Total number of pupils at the end of key stage 2 included in the maths progress scores
  • Total number of pupils at the end of key stage 2 included in the reading progress scores
  • Total number of pupils at the end of key stage 2 included in the writing TA progress scores
  • Total number of pupils progress scores for maths
  • Total number of pupils progress scores for reading
  • Total number of pupils progress scores for writing TA
  • Upper confidence interval for maths progress
  • Upper confidence interval for reading progress
  • Upper confidence interval for writing TA progress
Filters
  • Ethnicity
  • Placement
  • Social care group
  • Special Educational Needs provision
Time period
2017/18 to 2023/24

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_namesocial_care_groupsen_provisionethnicity_majorplacementversiont_read_eligible_pupilst_read_met_expected_standardpt_read_met_expected_standardt_writta_eligible_pupilst_writta_met_expected_standardpt_writta_met_expected_standardt_mat_eligible_pupilst_mat_met_expected_standardpt_mat_met_expected_standardt_rwm_eligible_pupilst_rwm_met_expected_standardpt_rwm_met_expected_standardt_gps_eligible_pupilst_gps_met_expected_standardpt_gps_met_expected_standardt_scita_eligible_pupilst_scita_met_expected_standardpt_scita_met_expected_standardt_read_progress_eligible_pupilst_read_progress_scoreavg_read_progress_scoreavg_read_progress_score_lower_ciavg_read_progress_score_upper_cit_writta_progress_eligible_pupilst_writta_progress_scoreavg_writta_progress_scoreavg_writta_progress_score_lower_ciavg_writta_progress_score_upper_cit_mat_progress_eligible_pupilst_mat_progress_scoreavg_mat_progress_scoreavg_mat_progress_score_lower_ciavg_mat_progress_score_upper_ci
202324Academic yearNationalE92000001EnglandAll pupils comparisonAll pupilsAll pupilsAll pupilsRevised662970493300746615404746307266295048527073661500401410616629804792607266139053633081xxxxxxxxxxxxxxx
202324Academic yearNationalE92000001EnglandAll pupils comparisonAll pupilsAsian/Asian BritishAll pupilsRevised864106586076862706613077864207093082862705846068864207002081862507195083xxxxxxxxxxxxxxx
202324Academic yearNationalE92000001EnglandAll pupils comparisonAll pupilsBlack/African/Caribbean/Black BritishAll pupilsRevised424503171075423503069072424503119073423502609062424503269077423403411081xxxxxxxxxxxxxxx
202324Academic yearNationalE92000001EnglandAll pupils comparisonAll pupilsMixed/Multiple ethnic groupsAll pupilsRevised442703424077441903283074442703277074441902809064442703343076441703644083xxxxxxxxxxxxxxx
202324Academic yearNationalE92000001EnglandAll pupils comparisonAll pupilsOther ethnic groupAll pupilsRevised15740104306615700102706515740113807215690883056157401088069156901178075xxxxxxxxxxxxxxx

Variables in this data set

Table showing all 37 variables
Variable nameVariable description
avg_mat_progress_scoreAverage progress score for maths
avg_mat_progress_score_lower_ciLower confidence interval for maths progress
avg_mat_progress_score_upper_ciUpper confidence interval for maths progress
avg_read_progress_scoreAverage progress score for reading
avg_read_progress_score_lower_ciLower confidence interval for reading progress
avg_read_progress_score_upper_ciUpper confidence interval for reading progress
avg_writta_progress_scoreAverage progress score for writing TA
avg_writta_progress_score_lower_ciLower confidence interval for writing TA progress
avg_writta_progress_score_upper_ciUpper confidence interval for writing TA progress
ethnicity_majorEthnicity - Filter by ethnicity
placementPlacement - Filter by placement
pt_gps_met_expected_standardPercentage of pupils meeting the expected standard in grammar, punctuation and spelling
pt_mat_met_expected_standardPercentage of pupils meeting the expected standard in maths
pt_read_met_expected_standardPercentage of pupils meeting the expected standard in reading
pt_rwm_met_expected_standardPercentage of pupils meeting the expected standard in reading, writing and maths (combined)
pt_scita_met_expected_standardPercentage of pupils meeting the expected standard in science TA
pt_writta_met_expected_standardPercentage of pupils meeting the expected standard in writing TA
sen_provisionSpecial Educational Needs provision - Filter by Special Educational Needs provision
social_care_groupSocial care group - Filter by social care group
t_gps_eligible_pupilsNumber of eligible pupils in grammar, punctuation and spelling
t_gps_met_expected_standardNumber of pupils meeting the expected standard in grammar, punctuation and spelling
t_mat_eligible_pupilsNumber of eligible pupils in maths
t_mat_met_expected_standardNumber of pupils meeting the expected standard in maths
t_mat_progress_eligible_pupilsTotal number of pupils at the end of key stage 2 included in the maths progress scores
t_mat_progress_scoreTotal number of pupils progress scores for maths
t_read_eligible_pupilsNumber of eligible pupils in reading
t_read_met_expected_standardNumber of pupils meeting the expected standard in reading
t_read_progress_eligible_pupilsTotal number of pupils at the end of key stage 2 included in the reading progress scores
t_read_progress_scoreTotal number of pupils progress scores for reading
t_rwm_eligible_pupilsNumber of eligible pupils in reading, writing and maths
t_rwm_met_expected_standardNumber of pupils meeting the expected standard in reading, writing and maths
t_scita_eligible_pupilsNumber of eligible pupils in science TA
t_scita_met_expected_standardNumber of pupils meeting the expected standard in science TA
t_writta_eligible_pupilsNumber of eligible pupils in writing TA
t_writta_met_expected_standardNumber of pupils meeting the expected standard in writing TA
t_writta_progress_eligible_pupilsTotal number of pupils at the end of key stage 2 included in the writing TA progress scores
t_writta_progress_scoreTotal number of pupils progress scores for writing TA

Footnotes

  1. 'All pupils comparison' includes all state-funded schools, alternative provision, and non-maintained special schools with pupils eligible for assessment at Key Stage 2. Participation by independent schools is voluntary, therefore the figures for all pupils includes results from independent schools that chose to submit data and met the requirements for assessment and moderation.
  2. Writing teacher assessment and reading, writing and maths (combined) measures from 2018 onwards are not directly comparable to previous years due to changes in the writing teacher assessment frameworks.

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

Download this data using code

Access this data using common programming languages using the URL below.

Example code

Python
import pandas as pd

pd.read_csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/6f343b08-119e-4d9d-9177-097711cc3b5f/csv")
R
read.csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/6f343b08-119e-4d9d-9177-097711cc3b5f/csv")

Contact us

If you have a specific enquiry about National - Key Stage 2 (KS2) statistics and data:

Children Looked After Data Team

Email: CLA.STATS@education.gov.uk
Contact name: Bree Waine