Every dataset powering Schoolgle tools — where it comes from, when it refreshes, and what needs attention.
Pupil Attendance
Termly (autumn, spring, full year). Full year ~March, autumn term ~October
School Funding Allocations
Annually in March/April
Suspensions & Permanent Exclusions
Termly releases + annual. Autumn ~November, spring ~April, full year ~July
School Census
Annually in June (based on January census)
School Workforce
Annually in June (based on November census)
EHCP / SEND Statistics
Annually in June (based on January SEN2 return + calendar year activity)
SEN in Schools
Annually in June
Ofsted: Most Recent Per School (Aug 2025)
Official statistics published annually (~November). Monthly management info also available.
School Financial Data (CFR)
Annually in December (LA & school expenditure)
KS4 Results (GCSE / Secondary)
Published annually in October; school-level tables updated in February
All schools in England — URN, name, LA, phase, type, postcode, head teacher, FSM%, capacity
27,731 have FSM%. Head teacher data partially populated. Should re-extract quarterly.
Strong coverage 2013-2025. Missing 2019-20 (COVID). Weekly attendance dashboard also available.
Fixed-period exclusions, permanent exclusions, reasons for exclusion
Large dataset. Some years fully populated, others partial. permanent_exclusions_count often null in recent data.
Expected standard %, higher standard %, progress scores in reading, writing, maths
1M+ rows but expected_standard_pct is NULL for all records. Needs re-import with actual values from EES download. 2024-25 revised now available on GOV.UK.
Table exists but is empty. 2024-25 data available on EES. Needs full import.
164k rows but fte_teachers, pupil_teacher_ratio etc. all NULL. 2024 data (Nov 2024 census) published June 2025 on EES. Needs re-import with actual values.
Overall effectiveness, sub-grades, safeguarding, deprivation band for all inspections 2019-2024
This is the LAST complete graded dataset. From Sep 2024, Ofsted removed overall effectiveness grade. Powers our five-year trend analysis.
Current inspection status of every school — grade, sub-grades, safeguarding, previous inspection
22,005 schools, 18,618 graded (93.1% Good+), 3,269 not judged (post Sep 2024). Powers the Current Snapshot on the Ofsted Explorer.
2025 data (Jan 2025 + CY 2024) published June 2025 on EES. Not yet imported. Key for SEND tools — EHCP volumes, waiting times, placement types by LA.
Income, expenditure, per-pupil spend, staff costs from Consistent Financial Reporting
2024-25 data published Dec 2025 on EES. Not imported. FBIT also has school-level CFR data. Would power budget tools with real comparisons.
Re-import KS2 with actual values from EES (2024-25 revised)
Powers school-level attainment comparisons for all primary schools
Import KS4 data from EES (2024-25, published Oct 2025)
Enables secondary school performance analysis — Attainment 8, % grade 5+ in English & maths
Import EHCP/SEND data from EES (2025)
Powers SEND Funding Explorer and EHCP Readiness tools with real LA data
Re-import workforce data with actual values (2024)
Enables Workforce Calculator with real pupil:teacher ratios
Import school financial data (CFR 2024-25)
Real budget comparisons for Budget Calculator and NI Cost tools
Refresh GIAS school directory
Latest head teachers, school status changes, new academies
All data is sourced from official DfE publications under the Open Government Licence v3.0.