Data set from Pupil attendance in schools

Pupil attendance since week commencing 12 September - year to date

Not the latest data

Published 23 March 2023

Last updated 23 March 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 10 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	E12000007	London	E09000016	Havering	311	Primary	34.74074074	11400.62963	2646250	2659179	12929	173972	134897	39075	32472	2833151	1295905	1320296	2616201	30049	116543	5510	147	0	140	250	447	11791	1637	96	110	1514	9667	1	12539	2423	18822	5291	69	59	24414	93.8594166	6.1405834	4.761376997	1.379206403	4.113547072	0.194483104	0.442581423	0.664348635	0.085523151	0.186753195	0.005188569	0	0.004941494	0.008824097	0.015777486	0.416179724	0.002435451	19.43611764	Academic year
202223	Local authority	E92000001	England	E12000002	North West	E08000014	Sefton	343	Primary	73.46296296	18131.78704	4259772	4281604	21832	278184	209403	68781	57150	4559788	2081341	2127385	4208726	51046	183730	11937	116	6	533	2143	345	9519	4935	2827	57	1973	14867	0	22943	6104	27380	12354	1074	74	22578	93.89919005	6.10080995	4.592384558	1.508425392	4.029353996	0.261788487	0.503159357	0.600466513	0.133865873	0.270933649	0.002543978	0.000131585	0.01168914	0.046997799	0.007566141	0.208759705	0.023553727	19.68725152	Academic year
202223	Local authority	E92000001	England	E12000007	London	E09000004	Bexley	303	Primary	44.7037037	13013.23148	3319738	3344900	25162	226659	164952	61707	47351	3571559	1620040	1655737	3275777	43961	145079	9338	342	2	55	503	479	7713	7980	1211	301	258	16619	4	13270	3390	38897	6150	1441	59	22662	93.65377976	6.346220236	4.618487333	1.727732903	4.062063653	0.261454452	0.371546431	1.089076227	0.094916534	0.172193711	0.00957565	5.60E-05	0.001539944	0.014083486	0.01341151	0.215956113	0.040346527	19.6041343	Academic year
202223	Local authority	E92000001	England	E12000008	South East	E10000014	Hampshire	850	Primary	304.5648148	71813.25	18795724	18965632	169908	1101396	928622	172774	151619	20067028	9316462	9352267	18668729	126995	787863	44214	1480	49	1988	18576	3674	67455	21295	2034	403	10405	137799	6	57341	24624	69518	21291	3319	423	106090	94.51141445	5.488585554	4.627601058	0.860984497	3.926156878	0.220331581	0.285747346	0.346428978	0.122708754	0.106099418	0.007375282	0.000244182	0.009906798	0.092569762	0.01830864	0.336148432	0.016539569	15.19293363	Academic year
202223	Local authority	E92000001	England	E12000005	West Midlands	E06000051	Shropshire	893	Primary	104.537037	15187.53704	3799771	3827148	27377	234162	202274	31888	27328	4061310	1888112	1890089	3778201	21570	170697	10773	71	18	188	2908	1034	14944	4310	1879	2	4147	18918	0	9589	5758	11644	4897	1641	126	22806	94.23432341	5.765676592	4.980511214	0.785165378	4.203003464	0.265259239	0.236106084	0.286705521	0.141776914	0.120576858	0.001748204	0.000443207	0.004629048	0.071602512	0.025459765	0.367960092	0.040405682	17.53715499	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

Download this data using code

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

Example code

---