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

LA - Key Stage 2 (KS2)

Not the latest data
Published
Last updated
Key Stage 2 attainment and progress for children in need (excluding children on a child protection plan and children looked after), children on a child protection plan (excluding children looked after) and children looked after.

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
3,438
Geographic levels
Local authority, National, Regional
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
  • Social care group
Time period
2016/17 to 2022/23

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameregion_coderegion_nameold_la_codela_namenew_la_codesocial_care_groupversiont_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
202223Academic yearNationalE92000001EnglandCINO at 31 MarchRevised1078046004310620416039107804250391062030302910780437041106205040479660-23284.01-2.41-2.54-2.289770-24049.63-2.46-2.58-2.349610-26660.46-2.77-2.89-2.65
202223Academic yearRegionalE92000001EnglandE12000001North EastCINO at 31 MarchRevised650290456402704265029044640200316502904564032049600-1711.96-2.88-3.38-2.37600-1627.02-2.72-3.21-2.24590-1524.59-2.58-3.06-2.1
202223Academic yearRegionalE92000001EnglandE12000002North WestCINO at 31 MarchRevised1460650451450560391460600411450410281460630431450690481340-2445.9-1.83-2.17-1.491350-2993.1-2.22-2.54-1.891330-3154.83-2.37-2.69-2.05
202223Academic yearRegionalE92000001EnglandE12000003Yorkshire and The HumberCINO at 31 MarchRevised1100500451100450411100470421100330301100470421100550501020-2324.86-2.29-2.67-1.91020-2213.94-2.17-2.54-1.81010-2256.69-2.25-2.61-1.88
202223Academic yearRegionalE92000001EnglandE12000004East MidlandsCINO at 31 MarchRevised740330447402903974031042740210297403104174036048680-1574.22-2.31-2.78-1.84690-1622.07-2.35-2.81-1.9680-1652.99-2.43-2.88-1.99

Variables in this data set

Table showing all 34 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
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
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

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/9bc43747-04e8-4cb1-905b-68a150286535/csv")
R
read.csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/9bc43747-04e8-4cb1-905b-68a150286535/csv")

Contact us

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

Children Looked After Data Team

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