Data set from Pupil attendance in schools

Pupil attendance between 03 January and 31 March 2023 - Spring term

Not the latest data

Published 18 May 2023

Last updated 18 May 2023

Spring term local authority, regional and national attendance between 03 January and 31 March 2023, 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 Spring term

---

Data set preview

Table showing first 5 rows, from underlying data

academic_year	time_period	time_identifier	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
202223	202223	Spring term	Local authority	E92000001	England	E12000008	South East	E06000044	Portsmouth	851	Primary	43.93220339	13915.33898	2557103	2575341	18238	155735	105584	50151	38015	2731076	1248773	1274889	2523662	33441	89386	6263	118	4	4	1337	507	7897	1384	4202	34	440	16380	0	10232	4574	33163	2182	68	46	15904	94.29766876	5.702331242	3.866022037	1.836309206	3.272922467	0.229323534	0.37465087	1.214283308	0.167479777	0.07989525	0.004320641	0.000146462	0.000146462	0.048955064	0.018564112	0.289153433	0.002489861	17.40616622
202223	202223	Spring term	Local authority	E92000001	England	E12000009	South West	E06000054	Wiltshire	865	Primary	157.3050847	26030.79661	4162771	4199022	36251	238708	193140	45568	32831	4437730	2065426	2069602	4135028	27743	155214	9939	151	0	472	2499	1372	22816	11132	307	77	4238	20804	0	11104	5088	23323	6053	677	202	38763	94.62094359	5.379056409	4.352225124	1.026831285	3.497598998	0.223965856	0.250218017	0.525561492	0.114653212	0.136398564	0.003402641	0	0.010636068	0.056312574	0.030916707	0.514136732	0.015255547	15.62591401
202223	202223	Spring term	Local authority	E92000001	England	E12000007	London	E09000021	Kingston upon Thames	314	Primary	26.88135593	8807.644068	1337536	1350316	12780	73475	54057	19418	16968	1423791	656705	665013	1321718	15818	45448	3124	97	20	22	656	69	3522	1277	86	531	1931	9041	0	6623	1150	10769	876	1099	35	14179	94.83948136	5.160518644	3.79669488	1.363823763	3.192041529	0.219414226	0.465166587	0.756361011	0.080770282	0.061525884	0.006812798	0.001404701	0.001545171	0.046074178	0.004846217	0.247367767	0.077188295	15.82830315
202223	202223	Spring term	Local authority	E92000001	England	E12000007	London	E09000016	Havering	311	Primary	36.3220339	11829.25424	1506514	1514771	8257	88189	66584	21605	18710	1602960	737833	751607	1489440	17074	57775	2989	74	0	10	214	372	5143	888	50	33	914	6422	0	7199	1636	10900	1870	7	59	24414	94.49836552	5.501634476	4.153815441	1.347819035	3.604269601	0.186467535	0.449106653	0.679992015	0.102061187	0.116659181	0.00461646	0	0.000623846	0.013350302	0.023207067	0.320843939	0.000436692	17.00708285
202223	202223	Spring term	Local authority	E92000001	England	E12000008	South East	E06000042	Milton Keynes	826	Primary	71.50847458	17911.64407	2635527	2651837	16310	160643	127175	33468	33536	2812480	1291748	1314014	2605762	29765	107839	6456	119	0	104	1039	590	10857	1916	2925	45	354	13995	0	8924	3771	17338	3435	171	89	27205	94.28820827	5.711791728	4.521809933	1.189981795	3.834302822	0.229548299	0.317300034	0.616466606	0.134080953	0.122134202	0.004231141	0	0.003697804	0.036942485	0.020977927	0.386029412	0.006080043	17.5764847

---

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

---