Data set from Key stage 4 performance

Local authority characteristics data

Latest data

Published 1 February 2024

Last updated 1 February 2024

Local authority and regional level headline entry and attainment measures for the latest year broken down by gender, major and minor ethnicity, free school meal eligibility, special educational need status and description, disadvantaged status and first language. State-funded schools only.

Data set details

Theme: School and college outcomes and performance
Publication: Key stage 4 performance
Release: Academic year 2022/23
Release type
Geographic levels: Local authority, National, Regional
Indicators: Average Attainment 8 score of all pupils
Average EBacc APS score per pupil
Average Progress 8 score of all pupils
Filters: Gender
Major ethnic group
Minor ethnic group
Time period: 2018/19 to 2022/23

Data set preview

Table showing first 5 rows, from underlying data
time_period	time_identifier	geographic_level	country_code	country_name	version	establishment_type	breakdown	gender	ethnicity_major	ethnicity_minor	free_school_meals	sen_status	sen_description	disadvantage	first_language	t_schools	t_pupils	t_att8	avg_att8	t_entbasics	pt_entbasics	t_l2basics_95	pt_l2basics_95	t_l2basics_94	pt_l2basics_94	t_ebacc_e_ptq_ee	pt_ebacc_e_ptq_ee	t_ebacc_95	pt_ebacc_95	t_ebacc_94	pt_ebacc_94	t_ebaccaps	avg_ebaccaps	t_inp8calc	t_p8score	avg_p8score	p8score_ci_low	p8score_ci_upp
202223	Academic year	National	E92000001	England	Revised	State-funded schools (LA)	Ethnicity minor	Boys	Asian	Any other Asian background	Total	Total	Total	Total	Total	1779	6179	328320.26	53.1	5973	96.7	3798	61.5	4732	76.6	3029	49	1493	24.2	1996	32.3	29706.24	4.81	5345	2853.537	0.53	0.5	0.57
202223	Academic year	National	E92000001	England	Revised	State-funded schools (LA)	Ethnicity minor	Boys	Asian	Bangladeshi	Total	Total	Total	Total	Total	1067	5561	278999.75	50.2	5373	96.6	3144	56.5	4108	73.9	2735	49.2	1064	19.1	1528	27.5	24824.88	4.46	5184	1873.612	0.36	0.32	0.4
202223	Academic year	National	E92000001	England	Revised	State-funded schools (LA)	Ethnicity minor	Boys	Asian	Chinese	Total	Total	Total	Total	Total	944	1668	107434.51	64.4	1630	97.7	1286	77.1	1456	87.3	1004	60.2	696	41.7	826	49.5	10121.03	6.07	1078	1018.732	0.95	0.86	1.03
202223	Academic year	National	E92000001	England	Revised	State-funded schools (LA)	Ethnicity minor	Boys	Asian	Indian	Total	Total	Total	Total	Total	1681	9976	576664.83	57.8	9778	98	6879	69	8222	82.4	5522	55.4	3031	30.4	3841	38.5	52484.39	5.26	8645	6067.505	0.7	0.67	0.73
202223	Academic year	National	E92000001	England	Revised	State-funded schools (LA)	Ethnicity minor	Boys	Asian	Pakistani	Total	Total	Total	Total	Total	1535	13834	620305.39	44.8	13392	96.8	6190	44.7	8893	64.3	5530	40	1726	12.5	2643	19.1	54222.38	3.92	12740	586.117	0.05	0.02	0.07

Variables in this data set

Table showing first 5 of 31 variables
Variable name	Variable description
avg_att8	Average Attainment 8 score of all pupils
avg_ebaccaps	Average EBacc APS score per pupil
avg_p8score	Average Progress 8 score of all pupils
disadvantage	Disadvantaged status
ethnicity_major	Major ethnic group

Footnotes

All state-funded schools include local authority maintained mainstream schools, academies, free schools, city technology colleges, further education colleges with provision for 14 to 16 year-olds and state-funded special schools. They exclude independent schools, independent special schools, non-maintained special schools, hospital schools, pupil referral units and alternative provision. Alternative provision includes academy and free school alternative provision.
Some zero percentages may represent small numbers due to rounding.
z = When an observation is not applicable
: = When data is unavailable for other reasons
c = a cell that has been suppressed due to low number of pupils. Suppression was applied where deemed necessary for all data up to 2018/19. For 2019/20, DfE suppression policy changed. For 2020 and 2021 results where a geographical area contains only one school (for example Isles of Scilly) the data for that area has been suppressed. This is in line with the announcement that school level data would not be published using either summer 2020 or summer 2021 exam grades awarded. Data has not being supressed at local authority or national level from 2022 onwards.
In 2020 and 2021 Progress 8 data was not published because of the cancellation of GCSE exams (due to COVID-19). Calculating Progress 8 has an element of modelling (estimating the average Attainment 8 score for pupils with similar prior attainment) and with the lack of exam data, the Progress 8 measure is not meaningful as a measure of Progress. Progress 8 was reintroduced from 2022.
Reformed GCSEs were introduced in phases for first examination between 2017 and 2020. The last phase of reformed GCSEs was first examined in 2022. This was due to the cancellation of exams and assessments in summer 2020 and 2021 due to the impact of the pandemic. All GCSEs now use the 9-1 grading system. Results for 2020 and 2021 are not comparable with earlier years due to the cancellation of exams (due to Covid-19) and changes to way GCSE grades were awarded in those years. GCSE exams returned in 2022 and grades were awarded at a midpoint between 2021 and pre-pandemic grading. Changes were made to the methodology for calculating performance data due to the commitment not to use qualification results awarded between January 2020 and August 2021 in future measures. In 2023 there was a return to pre-pandemic grading, with some protections.
English includes pupils whose first language is English and pupils whose first language is not known but believed to be English.
Other than English includes pupils whose first language is other than English and pupils whose first language is not known but believed to be other than English.
Free school meals (FSM) does not relate to pupils who actually received free school meals but those who are eligible to receive free school meals. Pupils not eligible for free school meals or unclassified pupils are described as 'FSM all other’.
Sub totals may not sum to the grand total due to a small number of pupils with missing information e.g. for SEN, EAL, prior attainment level, religious denomination and admission type.
From 2014/15, disadvantaged pupils include pupils known to be eligible for free school meals (FSM) in any spring, autumn, summer, alternative provision or pupil referral unit census from year 6 to year 11 or are looked after children for at least one day or are adopted from care. For 2013/14 and earlier years, they include pupils known to be eligible for FSM in any spring, autumn, summer, alternative provision or pupil referral unit census from year 6 to year 11 or are looked after children.
Disadvantaged all other includes pupils for whom free school meal eligibility could not be determined.
Statement/EHC plan indicates whether a pupil a pupil has a statement of SEN or an education, health and care (EHC) plan when a formal assessment has been made.
SEN support indicates whether a pupil has extra or different help given from that provided as part of the school’s usual curriculum. The class teacher and SEN coordinator (SENCO) may receive advice or support from outside specialists. This category replaces the former ‘school action’ and ‘school action plus’ categories.
'Total' includes pupils for whom Free School Meal eligibility (FSM), Special Educational Needs status (SEN provision) or SEN primary need could not be determined. This figure also includes pupils at further education colleges: as FE colleges do not complete the school census, we do not have matched pupil characteristics data of pupils in FE colleges and therefore these pupils are not included in characteristics breakdowns. This means that there are some cases where the individual characteristics breakdowns will not add up to the all pupils figure.
Following special educational needs and disability (SEND) reforms in 2014/15, SEN pupils are categorised as 'SEN with a statement or Education, health and care (EHC) plan' and 'SEN support'. SEN support replaces 'school action' and 'school action plus' (grouped as SEN without a statement up to and including 2013/14) but some pupils remain with these provision types in first year of transition. More detailed information on the reforms can be found at this link: https://www.gov.uk/government/publications/send-code-of-practice-0-to-25
'Any SEN' indicates whether a pupil has learning difficulties or disabilities that make it harder for them to learn than most children of the same age. This includes 'SEN with a statement 'EHC plan' or 'SEN support'.
Unclassified ethnicity includes pupils whom ethnicity was not obtained, refused or could not be determined.
Local authority, region and the total (state-funded sector) figures cover achievements in state-funded schools only. They do not include pupils recently arrived from overseas and so will not match with state-funded figures in the national tables.
City of London does not have any state funded secondary schools, therefore there are no entries present in the data for this local authority.
In 2019, two new local authorities were created from a merger of others. Bournemouth, Christchurch and Poole was created on 1 April 2019 from areas that were previously administered by the unitary authorities of Bournemouth and Poole, and the district of Christchurch. Dorset was created on 1 April 2019 from the districts of Weymouth and Portland, West Dorset, North Dorset, Purbeck and East Dorset. 2019 data is not comparable to previous years.
In 2021, two new local authorities were introduced (North Northamptonshire and West Northamptonshire) which replaced Northamptonshire.
In 2023, two new local authorities were introduced (Cumberland and Westmorland & Furness) which replaced Cumbria.

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.

URL

Local authority characteristics data

On this page