Data set from Pupil attendance in schools

Pupil attendance since week commencing 12 September - daily

Not the latest data

Published 18 May 2023

Last updated 18 May 2023

Daily 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:
  • Attendance Date
  • School Type
• Time period: 2022 Week 37 to 2023 Week 9

---

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	new_la_code	la_name	old_la_code	attendance_date	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
2022	Week 37	Local authority	E92000001	England	E12000004	East Midlands	E06000062	West Northamptonshire	941	12/09/2022	Primary	122	27521	71596	71720	124	3154	2178	976	350	74874	35532	35775	71307	289	1591	160	0	0	12	10	7	246	42	20	0	0	82	0	348	61	451	116	152	148	35220	95.78758982	4.212410182	2.90888693	1.303523252	2.124903171	0.213692336	0.464780832	0.602345273	0.081470203	0.154926944	0	0	0.016026925	0.013355771	0.00934904	0.328551967	0.20300772
2022	Week 37	Local authority	E92000001	England	E12000005	West Midlands	E08000028	Sandwell	333	12/09/2022	Primary	89	28419	82352	82613	261	4055	1881	2174	1877	86668	39520	41101	80621	1731	1445	116	0	0	8	34	0	242	39	20	0	2	220	0	424	146	1291	313	36	94	36569	95.32122583	4.678774173	2.170351225	2.508422947	1.667282042	0.133844095	0.489223243	1.489592468	0.168458947	0.36114829	0	0	0.009230627	0.039230166	0	0.279226473	0.041537822
2022	Week 37	Local authority	E92000001	England	E12000002	North West	E10000017	Lancashire	888	12/09/2022	Primary	366	67888	172091	172520	429	7449	5054	2395	1765	179969	85500	84989	170489	1602	3884	374	8	0	78	148	19	509	36	154	0	6	387	0	1131	163	957	144	34	481	99581	95.86095383	4.139046169	2.808261423	1.330784746	2.158149459	0.207813568	0.628441565	0.531758247	0.090571154	0.08001378	0.00444521	0	0.043340798	0.082236385	0.010557374	0.282826487	0.018892143
2022	Week 37	Local authority	E92000001	England	E12000009	South West	E06000058	Bournemouth, Christchurch and Poole	839	12/09/2022	Primary	64	22829	50661	50742	81	1993	1452	541	432	52735	24955	25326	50281	380	1162	101	0	0	16	14	2	150	50	18	2	0	29	0	166	52	286	37	7	66	26983	96.22072627	3.779273727	2.753389589	1.025884138	2.203470181	0.191523656	0.314781454	0.542334313	0.098606239	0.070162131	0	0	0.030340381	0.026547834	0.003792548	0.284441073	0.013273917
2022	Week 37	Local authority	E92000001	England	E12000009	South West	E06000026	Plymouth	879	12/09/2022	Primary	69	18150	44588	44629	41	2093	1351	742	374	46722	22026	22230	44256	332	985	160	0	0	10	52	3	140	28	2	0	13	0	0	302	42	282	116	1	69	20543	95.52031163	4.47968837	2.891571422	1.588116947	2.108214546	0.342451094	0.646376439	0.603570053	0.089893412	0.248277043	0	0	0.021403193	0.111296605	0.006420958	0.299644707	0.002140319

---

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_date	Attendance Date
attendance_perc	Attendance rate
auth_excluded_perc	Authorised exclusions 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

---