WhereToLearn is a directory of every nursery, school, college and university in the UK, for parents and students choosing where to go next. Each place gets one page built from official open data, and places can be compared side by side.

Stack
- Languages: PHP 8.5, JavaScript, SQL
- Frameworks: Laravel 13 with Blade, Tailwind CSS 4, Vite
- OpenSpout (via spatie/simple-excel) – streaming ODS and XLSX imports
- Leaflet – maps, loaded only when one scrolls into view
- Laravel Fortify and @laravel/passkeys – magic links, two-factor and passkeys
- GD – a share image drawn for each place on request
- Pest – tests against fixtures cut from the real source files
- Infrastructure: MySQL 8, Laravel queues with a dedicated import worker, Deployer, Cloudflare (tunnel and edge caching), Resend for email, Rollbar for errors
Data sources and APIs
- England schools and childcare: DfE Get Information About Schools (the spine of the directory), Ofsted management information and Parent View, the Ofsted reports site, the Explore Education Statistics API and data catalogue (results, census, attendance, workforce, admissions), the Financial Benchmarking and Insights Tool and the Companies House API for academy trusts
- Universities and colleges: the Office for Students register and National Student Survey, the Discover Uni dataset and HESA open data, REF 2021 results, and the DfE apprenticeship provider register
- Wales, Scotland and Northern Ireland: Welsh Government and StatsWales, Scottish Government school lists and statistics, the Department of Education (Northern Ireland), the Care Inspectorate and Care Inspectorate Wales
- Everything else: postcodes.io for geocoding, Wikidata and Wikimedia Commons for logos, OpenStreetMap for map tiles
How it works
- 27 import commands run in daily, weekly and monthly queued batches. Every run is recorded; failures are retried, then emailed.
- Schools are keyed by URN and universities by UKPRN, with Scottish and Northern Irish identifiers mapped into the same space. Academy conversions are linked so a school’s history follows it to its new URN.
- File URLs change every release, so importers find the newest file through the gov.uk and EES APIs or the publication page. Two HESA files are downloaded by hand, with an email reminder when due.
- New Ofsted reports are read from the reports site daily, ahead of the official data, and trigger shortlist alerts.
- Server-rendered Blade, cached at Cloudflare’s edge for signed-out visitors.
Features
- Search by name, town or postcode, with a radius and a map
- School pages with Ofsted report cards, applications and offers, the parent survey, exam results against England and the local authority, destinations, attendance and finances
- University and course pages with student satisfaction, TEF and REF, graduate jobs and salaries, and a course search by subject
- Compare up to four places side by side
- A shortlist, saved searches with a weekly email, and new Ofsted report alerts
- Academy trust pages totalling up their schools
Read more
The story behind it: Building WhereToLearn.