Data set from Pupil attendance in schools

Pupil attendance since week commencing 12 September - year to date

Not the latest data

Published 18 May 2023

Last updated 18 May 2023

Year-to-date local authority, regional and national attendance since 12 September 2022, including reasons for absence. Figures are provided for state-funded primary, secondary and special schools. Totals for all schools are also included that include estimates for non-response.

---

On this page

Data set details

• Theme: Pupils and schools
• Publication: Pupil attendance in schools
• Release: Week 18 2023
• Geographic levels: Local authority, National, Regional
• Indicators:
  • Afternoon sessions
  • Attendance rate
  • Authorised absence rate
• Filters:
  • School Type
• Time period: 2022/23

---

Data set preview

Table showing first 5 rows, from underlying data

time_period	geographic_level	country_code	country_name	region_code	region_name	new_la_code	la_name	old_la_code	school_type	num_schools	enrolments	present_sessions	overall_attendance	approved_educational_activity	overall_absence	authorised_absence	unauthorised_absence	late_sessions	possible_sessions	reason_present_am	reason_present_pm	reason_present	reason_l_present_late_before_registers_closed	reason_i_authorised_illness	reason_m_authorised_medical_dental	reason_r_authorised_religious_observance	reason_s_authorised_study_leave	reason_t_authorised_grt_absence	reason_h_authorised_holiday	reason_e_authorised_excluded	reason_c_authorised_other	reason_b_aea_education_off_site	reason_d_aea_dual_registration	reason_j_aea_interview	reason_p_aea_approved_sporting_activity	reason_v_aea_educational_visit_trip	reason_w_aea_work_experience	reason_g_unauthorised_holiday	reason_u_unauthorised_late_after_registers_closed	reason_o_other_unauthorised	reason_n_no_reason_yet	reason_x_not_attending_covid_non_compulsory	total_num_schools	total_enrolments	attendance_perc	overall_absence_perc	authorised_absence_perc	unauthorised_absence_perc	illness_perc	appointments_perc	unauth_hol_perc	unauth_oth_perc	unauth_late_registers_closed_perc	unauth_not_yet_perc	auth_religious_perc	auth_study_perc	auth_grt_perc	auth_holiday_perc	auth_excluded_perc	auth_other_perc	covid_non_compulsory_perc	pa_perc	time_identifier
202223	Local authority	E92000001	England	E12000008	South East	E06000044	Portsmouth	851	Primary	44.16058394	13994.49635	5889123	5926520	37397	393742	282314	111428	85883	6320262	2876865	2936668	5813533	75590	241025	13388	4176	4	4	5079	1007	17527	3826	10165	60	1168	32343	0	28483	10293	67995	4657	104	46	15904	93.77016333	6.229836674	4.466808496	1.763028178	3.813528616	0.211826662	0.450661697	1.075825654	0.162857173	0.073683654	0.06607321	6.33E-05	6.33E-05	0.080360593	0.015932884	0.277314453	0.001645501	18.92679901	Academic year
202223	Local authority	E92000001	England	E12000009	South West	E06000054	Wiltshire	865	Primary	158.5255474	26957.31387	9870907	9958501	87594	589635	481610	108025	72799	10548136	4902798	4906758	9809556	61351	391808	24178	1286	0	1282	8219	3770	49561	24551	1228	133	7963	54947	0	32620	11448	50263	13694	1506	202	38763	94.41005501	5.589944991	4.565830399	1.024114592	3.714476188	0.229215854	0.309248952	0.476510731	0.108531024	0.129823885	0.012191728	0	0.012153806	0.07791898	0.035740912	0.469855527	0.014277404	14.26134535	Academic year
202223	Local authority	E92000001	England	E12000007	London	E09000021	Kingston upon Thames	314	Primary	26.76642336	8920.313869	3176247	3209352	33105	184034	139981	44053	40624	3393386	1556824	1581450	3138274	37973	118618	7459	2279	37	32	1279	111	8469	4549	182	2862	3575	22119	0	14327	2651	25266	1809	1697	35	14179	94.57668535	5.423314648	4.125112793	1.298201855	3.495564607	0.219809948	0.422203663	0.744566047	0.07812256	0.053309585	0.067160058	0.001090356	0.000943011	0.037690967	0.003271069	0.24957373	0.050009047	15.63288478	Academic year
202223	Local authority	E92000001	England	E12000007	London	E09000016	Havering	311	Primary	35.86131387	11632.25547	3458953	3479000	20047	224861	175895	48966	41867	3703861	1694742	1725890	3420632	38321	149409	7152	2964	0	140	455	646	15053	2416	153	120	1919	15591	1	16622	3546	24108	4690	76	59	24414	93.92901083	6.070989165	4.748963312	1.322025854	4.033871681	0.193095799	0.448774941	0.650888357	0.095737934	0.126624622	0.080024601	0	0.003779839	0.012284478	0.017441259	0.40641374	0.002051913	18.49948613	Academic year
202223	Local authority	E92000001	England	E12000008	South East	E06000042	Milton Keynes	826	Primary	71.64233577	18144.78832	6264777	6302700	37923	404949	326972	77977	76738	6707649	3071787	3124150	6195937	68840	274601	14999	5192	4	362	2396	1431	27257	4469	6913	114	907	32430	3	23818	7898	37971	8290	730	89	27205	93.96287731	6.037122694	4.874614041	1.162508652	4.093848679	0.223610389	0.355087155	0.566085077	0.117746173	0.123590247	0.077404169	5.96E-05	0.005396824	0.035720414	0.021333853	0.406356981	0.010883098	16.94871795	Academic year

---

Variables in this data set

Table showing first 5 of 54 variables

Variable name	Variable description
appointments_perc	Authorised appointments absence rate
approved_educational_activity	Sessions marked as approved educational activity
attendance_perc	Attendance rate
auth_excluded_perc	Authorised exclusions absence rate
auth_grt_perc	Authorised traveller absence rate

---

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

---