How I built an Ofsted school data API on Apify (without scraping a single webpage)
Daniel Ainsworth developed an Ofsted school data API using Apify without web scraping. The API accesses official government CSV files containing inspection data for over 22,000 state-funded schools in England. The project highlights a straightforward approach to data accessibility through parsing rather than scraping.
- ▪The Ofsted data API was built using official government CSV files published on GOV.UK.
- ▪The API allows users to filter school data based on various criteria such as name and postcode.
- ▪Ofsted recently updated their grading system, which required adjustments in the API to accommodate new grading formats.
Opening excerpt (first ~120 words) tap to expand
try { if(localStorage) { let currentUser = localStorage.getItem('current_user'); if (currentUser) { currentUser = JSON.parse(currentUser); if (currentUser.id === 3954791) { document.getElementById('article-show-container').classList.add('current-user-is-article-author'); } } } } catch (e) { console.error(e); } Daniel Ainsworth Posted on May 28 How I built an Ofsted school data API on Apify (without scraping a single webpage) #webdev #typescript #opensource #datascience Most scraping projects start by finding a website to scrape. This one started from the opposite direction: I knew the data existed as official government downloads, and my job was to make it accessible via a clean API.
…
Excerpt limited to ~120 words for fair-use compliance. The full article is at DEV.to (Top).