Data set from Pupil attendance in schools

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

Not the latest data

Published 4 May 2023

Last updated 4 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 16 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	E12000002	North West	E08000015	Wirral	344	Primary	85.91525424	20714.66102	2962161	2976042	13881	176199	130767	45432	40565	3152241	1448260	1478379	2926639	35522	108767	7882	48	4	2	2330	572	10863	3320	3282	64	1059	9438	0	8994	5043	26604	4791	299	90	27052	94.41035758	5.589642416	4.148382056	1.44126036	3.450465875	0.250044334	0.285320824	0.843971003	0.159981423	0.15198711	0.001522726	0.000126894	6.34E-05	0.073915668	0.018145821	0.344611976	0.009485315	17.26126797
202223	202223	Spring term	Local authority	E92000001	England	E12000005	West Midlands	E08000026	Coventry	331	Primary	72.54237288	31928.71186	4869835	4903197	33362	323723	228411	95312	78138	5226920	2374704	2424276	4798980	70855	197825	9305	150	0	9	774	1449	18571	7027	843	50	1785	24500	0	22908	7283	57607	7514	328	85	32907	93.80662034	6.193379658	4.369896612	1.823483045	3.784733648	0.178020708	0.438269574	1.102121326	0.139336359	0.143755787	0.002869759	0	0.000172186	0.014807956	0.027721871	0.355295279	0.006275206	20.29146301
202223	202223	Spring term	Local authority	E92000001	England	E12000008	South East	E06000036	Bracknell Forest	867	Primary	23.96610169	6635.084746	971612	980064	8452	53205	41069	12136	7176	1033269	481000	484632	965632	5980	34432	2379	92	0	4	426	227	3496	583	1040	3	1294	6572	0	3160	1196	7352	428	13	29	10336	94.85080845	5.149191546	3.97466681	1.174524737	3.332336497	0.230240141	0.305825492	0.711528169	0.115749142	0.041421934	0.00890378	0	0.000387121	0.041228373	0.02196911	0.338343645	0.001258143	14.76549785
202223	202223	Spring term	Local authority	E92000001	England	E12000007	London	E09000017	Hillingdon	312	Primary	56.77966102	19343.64407	2638687	2652348	13661	189435	135854	53581	40042	2841783	1286267	1315567	2601834	36853	110713	6549	273	0	221	1526	531	13366	2449	163	126	621	10465	0	14531	3189	29341	6520	2675	67	29331	93.33393859	6.666061413	4.780590214	1.885471199	3.895899159	0.230453909	0.511333906	1.032485591	0.11221828	0.229433423	0.009606645	0	0.007776808	0.053698681	0.018685452	0.470338516	0.094131044	21.6675948
202223	202223	Spring term	Local authority	E92000001	England	E12000009	South West	E10000027	Somerset	933	Primary	130.8813559	20656.40678	5456358	5496588	40230	347363	271038	76325	63362	5843951	2689272	2716435	5405707	50651	225227	14728	213	0	568	3308	2559	24039	9487	2141	219	3571	26950	3	18751	12711	37544	7319	396	216	38804	94.05602477	5.943975232	4.637923898	1.306051334	3.85401931	0.252021278	0.320861691	0.642442074	0.217506957	0.125240612	0.003644794	0	0.009719452	0.05660554	0.043788868	0.411348418	0.006776238	18.14562263

---

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

Download this data using code

Access this data using common programming languages using the URL below.

Example code

---