UK Ofsted URN Portfolio Inspection Outcome Event Monitor

Watch a book of England state-funded school URNs and emit typed inspection-outcome / overall-effectiveness / safeguarding–inclusion–curriculum standard events when the official Ofsted monthly management-information CSV on GOV.UK changes — not another nationwide Ofsted directory dump, not an HTML scrape of reports.ofsted.gov.uk, and not a MATpulse / Angel Solutions Observatory seat scrape.

What this Actor does

1. Takes your URN watchlist (urns).
2. In live mode, downloads the official Ofsted latest inspections MI CSV once (discovers the newest file from the GOV.UK monthly MI page, or uses miCsvUrl / pinned fallback).
3. Diffs watched URNs against a durable Key-Value Store checkpoint.
4. Pushes only material change events for URNs on your book (PPE), plus one non-billable RUN_STATUS health row.

First observation of a URN is baseline only (no charge). Quiet months ≈ $0 product charges.

Coverage honesty (read this)

In scope	Out of scope
England state-funded schools Ofsted monthly MI (latest inspections CSV on GOV.UK, OGL)	Early years / FE / independent / non-state registers
Typed events for watched URNs only	Nationwide “download every school and bill rows” dump SKU
Report-card standards: Safeguarding / Inclusion / Curriculum and teaching	HTML scrape of https://reports.ofsted.gov.uk as primary
Latest OEIF overall effectiveness where present (legacy graded taxonomy)	Overclaiming Outstanding/Good labels where OEIF/report-card fields differ
Monthly Ofsted MI publish cadence	Intra-day report publish alerts
Official GOV.UK HTTP CSV under OGL	MATpulse / Observatory unpaid scrape or seat replacement

Scope: England Ofsted URN book. Cite Ofsted + GOV.UK; retrieval date is as_of / fetchedAt on events. No individual pupil data in the product payload.

Input

Field	Notes
urns	State-funded school Unique Reference Numbers (typically 5–6 digits).
signalGroups	publication (new inspection / publication date), overall (OEIF overall effectiveness), standards (Safeguarding / Inclusion / Curriculum). Default: all three.
sourceMode	fixture (default — Store health) or live (GOV.UK MI CSV; no API key).
emitFixtureDemoEvents	Default false. Only enable for local demos; Store auto-tests must stay false.
miCsvUrl	Optional pin to a specific assets.publishing.service.gov.uk CSV.
discoverFromMiPage	Default true — resolve newest latest-inspections CSV from the MI page when miCsvUrl empty.

Output events (billable)

event_type	When
OFSTED_NEW_INSPECTION_PUBLISHED	Latest full inspection number and/or publication date changes on the MI CSV
OFSTED_OVERALL_EFFECTIVENESS_CHANGED	Latest OEIF overall effectiveness flips
OFSTED_SAFEGUARDING_STANDARD_CHANGED	Safeguarding standards flips
OFSTED_INCLUSION_STANDARD_CHANGED	Inclusion flips
OFSTED_CURRICULUM_STANDARD_CHANGED	Curriculum and teaching flips
OFSTED_URN_GONE	Explicit watched URN absent from CSV after prior presence

Every successful run also pushes RUN_STATUS with billable: false (FIXTURE_HEALTH / MONITOR_IDLE / CATCHUP_COMPLETE / HEALTH_OK).

Pricing (PPE)

Event	Price
ofsted-inspection-outcome-event-delivered	$0.02 ($20 / 1k)
apify-actor-start	$0.00005

You pay when a URN on your watchlist has a material inspection-outcome / grade / standard change and we deliver it. Not charged: baselines, quiet books, duplicates, invalids, RUN_STATUS, fixture health, full CSV rows not on the book.

Modes

• Fixture (default): no network; emits RUN_STATUS / FIXTURE_HEALTH only → 0 product charges (Store daily auto-test safe).
• Live: official GOV.UK Ofsted MI CSV — no key required.

Legal

Ofsted management information published on GOV.UK for reuse under the UK Open Government Licence. Product default = URN + school name + inspection dates + standards/grades (minimise unnecessary PII; no pupil-level data in source).

Not this product

• parseforge/uk-ofsted-inspections-scraper — full-register / dump SKU (different job).
• nexgenwatch/uk-ofsted-provider-inspection-check — one-shot official answer per URN.
• muhammadafzal/uk-ofsted-inspections-scraper, spookyweb/uk-ofsted-inspections, danielainsworth/ofsted-register, solidcode/ofsted-reports-data-scraper — dump/lookup shelf.
• alkausari_mujahid/ofsted-providers-companies-house-enrichment — enrichment adjacency.
• MATpulse / Angel Solutions Observatory seats (external SaaS; not scraped here).
• HTML scrape of reports.ofsted.gov.uk as primary.

Example input (live baseline)

{
  "urns": ["100033", "100125", "100193", "100234"],
  "sourceMode": "live",
  "signalGroups": ["publication", "overall", "standards"],
  "resumeFromCheckpoint": true,
  "emitFixtureDemoEvents": false
}

First live run stores baselines only. Subsequent scheduled monthly runs emit events when inspection outcomes / standards flip on the book.