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
2,946
Geographic levels
Local authority, National, Regional
Indicators
  • Average progress score for reading
  • Average progress score for writing TA
  • Average progress score for maths
  • Lower confidence interval for reading progress
  • Upper confidence interval for reading progress
  • Lower confidence interval for writing TA progress
  • Upper confidence interval for writing TA progress
  • Lower confidence interval for maths progress
  • Upper confidence interval for maths progress
  • Percentage of pupils meeting the expected standard in reading
  • Percentage of pupils meeting the expected standard in writing TA
  • Percentage of pupils meeting the expected standard in maths
  • Percentage of pupils meeting the expected standard in reading, writing and maths (combined)
  • Percentage of pupils meeting the expected standard in grammar, punctuation and spelling
  • Percentage of pupils meeting the expected standard in science TA
  • Number of eligible pupils in reading
  • Number of pupils meeting the expected standard in reading
  • Number of eligible pupils in writing TA
  • Number of pupils meeting the expected standard in writing TA
  • Number of eligible pupils in maths
  • Number of pupils meeting the expected standard in maths
  • Number of eligible pupils in reading, writing and maths
  • Number of pupils meeting the expected standard in reading, writing and maths
  • Number of eligible pupils in grammar, punctuation and spelling
  • Number of pupils meeting the expected standard in grammar, punctuation and spelling
  • Number of eligible pupils in science TA
  • Number of pupils meeting the expected standard in science TA
  • Total number of pupils at the end of key stage 2 included in the reading progress scores
  • Total number of pupils progress scores for reading
  • 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 writing TA
  • Total number of pupils at the end of key stage 2 included in the maths progress scores
  • Total number of pupils progress scores for maths
Filters
  • Social care group
Time period
2016/17 to 2021/22

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
202122Academic yearNationalE92000001EnglandCINO at 31 MarchRevised1089048704510790407038108904240391077029802810880447041107805020479890-19950.82225-2.02-2.14-1.8910020-19990.1684-2-2.11-1.889850-23999.2987-2.44-2.55-2.32
202122Academic yearRegionalE92000001EnglandE12000001North EastCINO at 31 MarchRevised680310456802603868029042680200296802704068031045640-1460.312165-2.29-2.78-1.8650-1242.197188-1.92-2.39-1.45640-1452.790963-2.28-2.74-1.83
202122Academic yearRegionalE92000001EnglandE12000002North WestCINO at 31 MarchRevised1550740481550600391550620401550440281550670431540740481400-1669.433681-1.19-1.52-0.861440-2203.824284-1.53-1.85-1.221400-2771.788383-1.98-2.28-1.67
202122Academic yearRegionalE92000001EnglandE12000003Yorkshire and The HumberCINO at 31 MarchRevised1150560491150460401150490431150350311150500431150560491060-1300.029933-1.23-1.61-0.851070-1586.380323-1.48-1.84-1.121050-1658.800555-1.57-1.93-1.22
202122Academic yearRegionalE92000001EnglandE12000004East MidlandsCINO at 31 MarchRevised810360448002803581029036800200258103204080037046730-1887.118705-2.59-3.04-2.13740-1798.817918-2.44-2.87-2730-2076.603757-2.85-3.27-2.42

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/c21294ed-04aa-406f-bc05-243d281baca5/csv")
R
read.csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/c21294ed-04aa-406f-bc05-243d281baca5/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