Data set from Key stage 4 performance

Local authority data

Not the 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 gender. State-funded schools only.

---

On this page

Data set details

• Theme: School and college outcomes and performance
• Publication: Key stage 4 performance
• Release: Academic year 2022/23
• Geographic levels: Local authority, National, Regional
• Indicators:
  • Average Attainment 8 score of all pupils
  • Average Progress 8 score of all pupils
  • Average EBacc APS score per pupil
• Filters:
  • Gender
• 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	region_code	region_name	old_la_code	new_la_code	la_name	version	education_investment_area_flag	priority_area_flag	establishment_type	gender	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	t_p8eng	avg_p8eng	p8eng_ci_low	p8eng_ci_upp	t_p8mat	avg_p8mat	p8mat_ci_low	p8mat_ci_upp	t_p8ebac	avg_p8ebac	p8ebac_ci_low	p8ebac_ci_upp	t_p8open	avg_p8open	p8open_ci_low	p8open_ci_upp	t_entry_1	pt_entry_1	t_anypass	pt_anypass	t_ebaceng_e	pt_ebaceng_e	t_ebacmat_e	pt_ebacmat_e	t_ebac2sci_e	pt_ebac2sci_e	t_ebachum_e	pt_ebachum_e	t_ebaclan_e	pt_ebaclan_e	t_ebaceng_95	pt_ebaceng_95	t_ebacmat_95	pt_ebacmat_95	t_ebac2sci_95	pt_ebac2sci_95	t_ebachum_95	pt_ebachum_95	t_ebaclan_95	pt_ebaclan_95	t_ebaceng_94	pt_ebaceng_94	t_ebacmat_94	pt_ebacmat_94	t_ebac2sci_94	pt_ebac2sci_94	t_ebachum_94	pt_ebachum_94	t_ebaclan_94	pt_ebaclan_94	t_ebptseng_ll	avg_ebptseng_ll	t_ebptsmat	avg_ebptsmat	t_ebptssci	avg_ebptssci	t_ebptshum	avg_ebptshum	t_ebptslan	avg_ebptslan	t_att8_eng	avg_att8_eng	t_att8_mat	avg_att8_mat	t_att8_ebac	avg_att8_ebac	t_att8_open	avg_att8_open	t_att8_open_g	avg_att8_open_g	t_att8_open_ng	avg_att8_open_ng	t_ebac_fill	avg_ebac_fill	t_open_fill	avg_open_fill
202223	Academic year	National	E92000001	England						Revised	0	0	State-funded schools (LA)	Boys	3833	308635	13644699.13	44.2	294810	95.5	134044	43.4	194511	63	108128	35	42782	13.9	62516	20.3	1198991.89	3.88	290165	-48535.086	-0.17	-0.17	-0.16	-96529.265	-0.33	-0.34	-0.33	25462.615	0.09	0.08	0.09	-25235.861	-0.09	-0.09	-0.08	-96091.917	-0.33	-0.34	-0.33	298194	96.6	296719	96.1	288249	93.4	296161	96	290142	94	250866	81.3	121160	39.3	166799	54	158717	51.4	134909	46.5	118325	47.2	60935	50.3	214524	69.5	217363	70.4	188020	64.8	150981	60.2	79354	65.5	1404647	4.55	1415648.39	4.59	1356906.27	4.4	1092804	3.54	567037.28	1.84	2823998	9.1	2831296.78	9.2	4015725.79	13	3973678.56	12.9	3176522.81	10.3	797155.75	2.6	837439	2.7	840060	2.7
202223	Academic year	National	E92000001	England						Revised	0	0	State-funded schools (LA)	Girls	3793	294978	14376889.07	48.7	286218	97	140557	47.6	200087	67.8	129650	44	60262	20.4	84211	28.5	1255416.66	4.26	278365	33554.384	0.12	0.12	0.13	73257.305	0.26	0.26	0.27	-38128.67	-0.14	-0.14	-0.13	7525.254	0.03	0.02	0.03	73362.81	0.26	0.26	0.27	288747	97.9	287825	97.6	281648	95.5	286904	97.3	282070	95.6	243886	82.7	148530	50.4	200119	67.8	149006	50.5	137327	48.7	129989	53.3	88255	59.4	238100	80.7	207448	70.3	187875	66.6	159531	65.4	109780	73.9	1564957	5.31	1340641.03	4.54	1349642.84	4.58	1163179	3.94	764444.75	2.59	3143480	10.7	2681286.06	9.1	4096423.5	13.9	4455699.51	15.1	3642546.01	12.3	813153.5	2.8	821362	2.8	828589	2.8
202223	Academic year	National	E92000001	England						Revised	0	0	State-funded schools (LA)	Total	4047	603613	28021588.2	46.4	581028	96.3	274601	45.5	394598	65.4	237778	39.4	103044	17.1	146727	24.3	2454408.55	4.07	568530	-14980.702	-0.03	-0.03	-0.02	-23271.96	-0.04	-0.05	-0.04	-12666.055	-0.02	-0.03	-0.02	-17710.607	-0.03	-0.04	-0.03	-22729.107	-0.04	-0.04	-0.04	586941	97.2	584544	96.8	569897	94.4	583065	96.6	572212	94.8	494752	82	269690	44.7	366918	60.8	307723	51	272236	47.6	248314	50.2	149190	55.3	452624	75	424811	70.4	375895	65.7	310512	62.8	189134	70.1	2969604	4.92	2756289.42	4.57	2706549.11	4.48	2255983	3.74	1331482.03	2.21	5967478	9.9	5512582.84	9.1	8112149.29	13.4	8429378.07	14	6819068.82	11.3	1610309.25	2.7	1658801	2.7	1668649	2.8
202223	Academic year	Regional	E92000001	England	E12000001	North East				Revised	0	0	State-funded schools (LA)	Boys	191	14189	599033.5	42.2	13400	94.4	5619	39.6	8503	59.9	4608	32.5	1679	11.8	2632	18.5	51860.76	3.65	13692	-5452.613	-0.4	-0.42	-0.37	-7708.2	-0.56	-0.59	-0.54	-2895.345	-0.21	-0.24	-0.19	-5591.769	-0.41	-0.44	-0.38	-6000.096	-0.44	-0.47	-0.41	13584	95.7	13501	95.2	13039	91.9	13481	95	13120	92.5	11472	80.9	5007	35.3	7291	51.4	6696	47.2	5635	42.9	5189	45.2	2169	43.3	9453	66.6	9566	67.4	8190	62.4	6702	58.4	3108	62.1	61834	4.36	61415	4.33	58792	4.14	48495	3.42	21838	1.54	124453	8.8	122830	8.7	172256	12.1	179494.5	12.7	122630	8.6	56864.5	4	37729	2.7	37800	2.7
202223	Academic year	Regional	E92000001	England	E12000001	North East				Revised	0	0	State-funded schools (LA)	Girls	185	13531	635260.75	46.9	13098	96.8	6009	44.4	8806	65.1	5628	41.6	2450	18.1	3586	26.5	54450.28	4.02	13128	-1782.876	-0.14	-0.16	-0.11	-207.855	-0.02	-0.04	0.01	-5690.22	-0.43	-0.46	-0.41	-4499.33	-0.34	-0.37	-0.31	1983.564	0.15	0.12	0.18	13235	97.8	13164	97.3	12882	95.2	13127	97	12914	95.4	11260	83.2	6238	46.1	8774	64.8	6393	47.2	5797	44.9	5703	50.6	3255	52.2	10635	78.6	9152	67.6	8128	62.9	7128	63.3	4381	70.2	69194	5.11	58667	4.34	58889	4.35	51596	3.81	29462	2.18	139016	10.3	117334	8.7	175982	13	202928.75	15	143372.5	10.6	59556.25	4.4	37330	2.8	37501	2.8

---

Variables in this data set

Table showing first 5 of 100 variables

Variable name	Variable description
avg_att8	Average Attainment 8 score of all pupils
avg_att8_ebac	Average Attainment 8 score per pupil in Ebacc subjects
avg_att8_eng	Average Attainment 8 score per pupil in English
avg_att8_mat	Average Attainment 8 score per pupil in Mathematics
avg_att8_open	Average score per pupil from open Attainment 8 slots

---

Footnotes

1. 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. 
2. Some zero percentages may represent small numbers due to rounding.
3. z = When an observation is not applicable
4. : = When data is unavailable for other reasons
5. 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.
6. 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.
7. EBacc sciences includes the double award GCSE in combined science, and single GCSEs in biology, chemistry, physics and computer science.
8. 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. 
9. The open element contains the three highest point scores in any three other subjects, including English language or literature (if not counted in the English slot), further GCSE qualifications (including English Baccalaureate subjects) or any other non-GCSE qualifications on the DfE approved list.
10. Average number of slots filled that contains U grades or other qualifications scoring 0 points are counted as a non-filled slot.
11. 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. 
12. City of London does not have any state funded secondary schools, therefore there are no entries present in the data for this local authority.
13. 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.
14. In 2021, two new local authorities were introduced (North Northamptonshire and West Northamptonshire) which replaced Northamptonshire.
15. In 2023, two new local authorities were introduced (Cumberland and Westmorland & Furness) which replaced Cumbria.
16. Gateshead district boundary was changed in 2014. The local authority district code was changed from E08000020 to E08000037 to reflect this.

---

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

---