# Ofsted School Register Scraper (`danielainsworth/ofsted-register`) Actor

Search 22,000+ UK state-funded schools with Ofsted inspection grades. Filter by local authority, region, postcode or name. Official GOV.UK data, updated monthly.

- **URL**: https://apify.com/danielainsworth/ofsted-register.md
- **Developed by:** [Daniel Ainsworth](https://apify.com/danielainsworth) (community)
- **Categories:** Developer tools, Automation, Other
- **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, NaN bookmarks
- **User rating**: No ratings yet

## Pricing

from $50.00 / 1,000 record scrapeds

This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events.

Learn more: https://docs.apify.com/platform/actors/running/actors-in-store#pay-per-event

## What's an Apify Actor?

Actors are a software tools running on the Apify platform, for all kinds of web data extraction and automation use cases.
In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours,
and optionally produces a well-defined JSON output, datasets with results, or files in key-value store.
In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server.
Actors are written with capital "A".

## How to integrate an Actor?

If asked about integration, you help developers integrate Actors into their projects.
You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready.
The best way to integrate Actors is as follows.

In JavaScript/TypeScript projects, use official [JavaScript/TypeScript client](https://docs.apify.com/api/client/js.md):

```bash
npm install apify-client
```

In Python projects, use official [Python client library](https://docs.apify.com/api/client/python.md):

```bash
pip install apify-client
```

In shell scripts, use [Apify CLI](https://docs.apify.com/cli/docs.md):

````bash
# MacOS / Linux
curl -fsSL https://apify.com/install-cli.sh | bash
# Windows
irm https://apify.com/install-cli.ps1 | iex
```bash

In AI frameworks, you might use the [Apify MCP server](https://docs.apify.com/platform/integrations/mcp.md).

If your project is in a different language, use the [REST API](https://docs.apify.com/api/v2.md).

For usage examples, see the [API](#api) section below.

For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt).


# README

## Ofsted School Register Scraper

Extract inspection data for all 22,000+ UK state-funded schools directly from Ofsted's official monthly dataset. Filter by local authority, region, postcode prefix, or school name — and get structured JSON with the latest inspection grades for every matched school.

Data is sourced from GOV.UK's published management information files, updated monthly. No authentication required.

---

### What data you get

Every school record includes:

- **Identity**: URN, LAESTAB, school name, phase (Primary / Secondary / Nursery etc.), type of education
- **Location**: local authority, region, Ofsted region, parliamentary constituency, postcode
- **Size**: total pupils, age range (statutory lowest/highest age)
- **Trust**: multi-academy trust name (if applicable)
- **Latest inspection**: date, type (S5, S8 etc.), publication date
- **Report card grades** (November 2025 framework):
  - Safeguarding standards (Met / Not met)
  - Inclusion
  - Curriculum and teaching
  - Achievement
  - Attendance and behaviour
  - Personal development and wellbeing
  - Early years (where applicable)
- **Direct link** to the Ofsted inspection report

> **Note on grades:** Ofsted introduced a new inspection framework in November 2025. Schools inspected since then receive report card grades instead of the old single-word "Outstanding/Good/Requires Improvement/Inadequate" judgements. The new scale is: **Exceptional → Strong → Expected standard → Needs attention → Urgent improvement**. Schools not yet inspected under the new framework will have null grades.

---

### Input parameters

| Parameter | Type | Description |
|---|---|---|
| `mode` | string | **Required.** `searchSchools` or `lookupUrns` |
| `nameQuery` | string | Partial name match (case-insensitive). E.g. `"St Mary"` |
| `localAuthority` | string | Filter by LA name. E.g. `"Manchester"`, `"Leeds"` |
| `region` | string | Filter by region. E.g. `"North West"`, `"London"` |
| `postcode` | string | Filter by postcode prefix. E.g. `"M1"`, `"SW1"` |
| `urns` | array | List of URNs for `lookupUrns` mode |
| `maxResults` | integer | Max records to return (default: 1000; 0 = unlimited) |

All filter parameters for `searchSchools` are optional and combinable — e.g. set both `localAuthority` and `nameQuery` to narrow results.

---

### Example output

```json
{
  "urn": "105413",
  "laestab": "3522076",
  "name": "Crowcroft Park Primary School",
  "phase": "Primary",
  "type": "Community School",
  "religiousCharacter": null,
  "ofstedRegion": "North West",
  "region": "North West",
  "localAuthority": "Manchester",
  "constituency": "Gorton and Denton",
  "postcode": "M12 5SY",
  "multiAcademyTrustName": null,
  "totalPupils": 251,
  "lowestAge": 3,
  "highestAge": 11,
  "latestInspectionDate": "2025-11-18",
  "inspectionPublicationDate": "2026-01-18",
  "inspectionType": "S5 Inspection",
  "categoryOfConcern": null,
  "safeguarding": "Met",
  "inclusion": "Expected standard",
  "curriculumAndTeaching": "Expected standard",
  "achievement": "Expected standard",
  "attendanceAndBehaviour": "Expected standard",
  "personalDevelopmentAndWellbeing": "Expected standard",
  "earlyYears": "Expected standard",
  "sourceUrl": "https://reports.ofsted.gov.uk/inspection-reports/find-inspection-report/provider/ELS/105413",
  "scrapedAt": "2026-05-28T10:00:00.000Z"
}
````

***

### Pricing

This actor uses Pay Per Event (PPE) pricing:

| Event | Price |
|---|---|
| Actor start | **$1.00** |
| Per school returned | **$0.05** |

The $1.00 startup covers downloading and parsing the full 16 MB GOV.UK CSV. After that, you only pay for the records you receive.

**Example costs:**

| Use case | Results | Estimated cost |
|---|---|---|
| All schools in Manchester | ~450 | $1 + $22.50 = **$23.50** |
| All primaries in Yorkshire (by postcode prefix) | ~800 | $1 + $40.00 = **$41.00** |
| All schools in London rated Exceptional for safeguarding | ~200 | $1 + $10.00 = **$11.00** |
| Lookup 50 specific schools by URN | 50 | $1 + $2.50 = **$3.50** |

***

### Use cases

**EdTech and school resource vendors**
Find every school in your target region and contact them directly. Filter by phase (Primary/Secondary) to target the right audience. Use MAT name to identify trust procurement contacts.

**Ofsted preparation consultants**
Monitor which schools in your region have recently been inspected and what grades they received. Identify schools rated "Needs attention" or "Urgent improvement" — these are your highest-value prospects.

**School uniform, catering, and facilities suppliers**
Build targeted prospect lists by local authority or postcode area. Filter by total pupils to prioritise larger schools. Export to CSV and import directly into your CRM.

**EdTech market researchers and investors**
Map the UK schools landscape — how many primaries in the North West? What proportion of schools in London have been inspected under the new framework? What does the distribution of grades look like by region?

**Multi-academy trust analysis**
Cross-reference school records with MAT name to identify trust-level patterns. Which trusts have schools with Urgent improvement grades? Which trusts are expanding in your region?

***

### Data source and licence

Data is sourced from [GOV.UK monthly management information on state-funded school inspection outcomes](https://www.gov.uk/government/statistical-data-sets/monthly-management-information-ofsteds-school-inspections-outcomes), published by Ofsted.

Licensed under the [Open Government Licence v3.0](https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/), which permits commercial use, redistribution, and adaptation.

Data is updated monthly. The actor always fetches the most recently published release.

***

### Modes

#### `searchSchools`

Filter the full 22,000+ school register by any combination of: name, local authority, region, or postcode prefix. Set `maxResults: 0` to return all matching schools.

#### `lookupUrns`

Provide a list of school URNs (Unique Reference Numbers) and get the full record for each. Useful when you already have a list of schools to look up. URNs can be found on [reports.ofsted.gov.uk](https://reports.ofsted.gov.uk/).

***

### See also

**[FCA Register Scraper](https://apify.com/danielainsworth/fca-register)** — Extract UK Financial Conduct Authority regulated firm profiles: status, permissions, addresses, and approved individuals. Free API key, no proxy needed.

**[CQC Care Register Scraper](https://apify.com/danielainsworth/cqc-register)** — Search 55,000+ CQC-registered care locations in England. Filter by rating, local authority, postcode or service type. Includes care homes, GP surgeries, dental practices and home care agencies.

# Actor input Schema

## `mode` (type: `string`):

searchSchools: filter the full register by name, location, or postcode. lookupUrns: fetch records for specific school URNs.

## `nameQuery` (type: `string`):

Partial name to search for (case-insensitive). Leave blank to match all schools. Only applies to searchSchools mode.

## `localAuthority` (type: `string`):

Filter by local authority name (case-insensitive, partial match). Examples: Manchester, Leeds, Birmingham, Cornwall. Only applies to searchSchools mode.

## `region` (type: `string`):

Filter by Ofsted region (case-insensitive, partial match). Examples: North West, London, South East, East Midlands. Only applies to searchSchools mode.

## `postcode` (type: `string`):

Filter by postcode prefix (e.g. 'M1' matches M1 7AB, M14 5HZ etc). Case-insensitive. Only applies to searchSchools mode.

## `urns` (type: `array`):

List of Ofsted URNs (Unique Reference Numbers) to look up. Find URNs on reports.ofsted.gov.uk. Required for lookupUrns mode.

## `maxResults` (type: `integer`):

Maximum number of schools to return. Use 0 for unlimited (returns all matching records — can be thousands). Only applies to searchSchools mode.

## Actor input object example

```json
{
  "mode": "searchSchools",
  "nameQuery": "St Mary",
  "localAuthority": "Manchester",
  "region": "North West",
  "postcode": "M1",
  "urns": [
    "100000",
    "100001",
    "100002"
  ],
  "maxResults": 1000
}
```

# API

You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup.

## JavaScript example

```javascript
import { ApifyClient } from 'apify-client';

// Initialize the ApifyClient with your Apify API token
// Replace the '<YOUR_API_TOKEN>' with your token
const client = new ApifyClient({
    token: '<YOUR_API_TOKEN>',
});

// Prepare Actor input
const input = {};

// Run the Actor and wait for it to finish
const run = await client.actor("danielainsworth/ofsted-register").call(input);

// Fetch and print Actor results from the run's dataset (if any)
console.log('Results from dataset');
console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
const { items } = await client.dataset(run.defaultDatasetId).listItems();
items.forEach((item) => {
    console.dir(item);
});

// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs

```

## Python example

```python
from apify_client import ApifyClient

# Initialize the ApifyClient with your Apify API token
# Replace '<YOUR_API_TOKEN>' with your token.
client = ApifyClient("<YOUR_API_TOKEN>")

# Prepare the Actor input
run_input = {}

# Run the Actor and wait for it to finish
run = client.actor("danielainsworth/ofsted-register").call(run_input=run_input)

# Fetch and print Actor results from the run's dataset (if there are any)
print("💾 Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"])
for item in client.dataset(run["defaultDatasetId"]).iterate_items():
    print(item)

# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

```

## CLI example

```bash
echo '{}' |
apify call danielainsworth/ofsted-register --silent --output-dataset

```

## MCP server setup

```json
{
    "mcpServers": {
        "apify": {
            "command": "npx",
            "args": [
                "mcp-remote",
                "https://mcp.apify.com/?tools=danielainsworth/ofsted-register",
                "--header",
                "Authorization: Bearer <YOUR_API_TOKEN>"
            ]
        }
    }
}

```

## OpenAPI specification

```json
{
    "openapi": "3.0.1",
    "info": {
        "title": "Ofsted School Register Scraper",
        "description": "Search 22,000+ UK state-funded schools with Ofsted inspection grades. Filter by local authority, region, postcode or name. Official GOV.UK data, updated monthly.",
        "version": "0.1",
        "x-build-id": "yFFhSD4SNLh7wk5Wx"
    },
    "servers": [
        {
            "url": "https://api.apify.com/v2"
        }
    ],
    "paths": {
        "/acts/danielainsworth~ofsted-register/run-sync-get-dataset-items": {
            "post": {
                "operationId": "run-sync-get-dataset-items-danielainsworth-ofsted-register",
                "x-openai-isConsequential": false,
                "summary": "Executes an Actor, waits for its completion, and returns Actor's dataset items in response.",
                "tags": [
                    "Run Actor"
                ],
                "requestBody": {
                    "required": true,
                    "content": {
                        "application/json": {
                            "schema": {
                                "$ref": "#/components/schemas/inputSchema"
                            }
                        }
                    }
                },
                "parameters": [
                    {
                        "name": "token",
                        "in": "query",
                        "required": true,
                        "schema": {
                            "type": "string"
                        },
                        "description": "Enter your Apify token here"
                    }
                ],
                "responses": {
                    "200": {
                        "description": "OK"
                    }
                }
            }
        },
        "/acts/danielainsworth~ofsted-register/runs": {
            "post": {
                "operationId": "runs-sync-danielainsworth-ofsted-register",
                "x-openai-isConsequential": false,
                "summary": "Executes an Actor and returns information about the initiated run in response.",
                "tags": [
                    "Run Actor"
                ],
                "requestBody": {
                    "required": true,
                    "content": {
                        "application/json": {
                            "schema": {
                                "$ref": "#/components/schemas/inputSchema"
                            }
                        }
                    }
                },
                "parameters": [
                    {
                        "name": "token",
                        "in": "query",
                        "required": true,
                        "schema": {
                            "type": "string"
                        },
                        "description": "Enter your Apify token here"
                    }
                ],
                "responses": {
                    "200": {
                        "description": "OK",
                        "content": {
                            "application/json": {
                                "schema": {
                                    "$ref": "#/components/schemas/runsResponseSchema"
                                }
                            }
                        }
                    }
                }
            }
        },
        "/acts/danielainsworth~ofsted-register/run-sync": {
            "post": {
                "operationId": "run-sync-danielainsworth-ofsted-register",
                "x-openai-isConsequential": false,
                "summary": "Executes an Actor, waits for completion, and returns the OUTPUT from Key-value store in response.",
                "tags": [
                    "Run Actor"
                ],
                "requestBody": {
                    "required": true,
                    "content": {
                        "application/json": {
                            "schema": {
                                "$ref": "#/components/schemas/inputSchema"
                            }
                        }
                    }
                },
                "parameters": [
                    {
                        "name": "token",
                        "in": "query",
                        "required": true,
                        "schema": {
                            "type": "string"
                        },
                        "description": "Enter your Apify token here"
                    }
                ],
                "responses": {
                    "200": {
                        "description": "OK"
                    }
                }
            }
        }
    },
    "components": {
        "schemas": {
            "inputSchema": {
                "type": "object",
                "required": [
                    "mode"
                ],
                "properties": {
                    "mode": {
                        "title": "Scraping mode",
                        "enum": [
                            "searchSchools",
                            "lookupUrns"
                        ],
                        "type": "string",
                        "description": "searchSchools: filter the full register by name, location, or postcode. lookupUrns: fetch records for specific school URNs.",
                        "default": "searchSchools"
                    },
                    "nameQuery": {
                        "title": "School name search",
                        "type": "string",
                        "description": "Partial name to search for (case-insensitive). Leave blank to match all schools. Only applies to searchSchools mode."
                    },
                    "localAuthority": {
                        "title": "Local authority",
                        "type": "string",
                        "description": "Filter by local authority name (case-insensitive, partial match). Examples: Manchester, Leeds, Birmingham, Cornwall. Only applies to searchSchools mode."
                    },
                    "region": {
                        "title": "Region",
                        "type": "string",
                        "description": "Filter by Ofsted region (case-insensitive, partial match). Examples: North West, London, South East, East Midlands. Only applies to searchSchools mode."
                    },
                    "postcode": {
                        "title": "Postcode prefix",
                        "type": "string",
                        "description": "Filter by postcode prefix (e.g. 'M1' matches M1 7AB, M14 5HZ etc). Case-insensitive. Only applies to searchSchools mode."
                    },
                    "urns": {
                        "title": "School URNs",
                        "type": "array",
                        "description": "List of Ofsted URNs (Unique Reference Numbers) to look up. Find URNs on reports.ofsted.gov.uk. Required for lookupUrns mode.",
                        "items": {
                            "type": "string"
                        }
                    },
                    "maxResults": {
                        "title": "Max results",
                        "minimum": 0,
                        "type": "integer",
                        "description": "Maximum number of schools to return. Use 0 for unlimited (returns all matching records — can be thousands). Only applies to searchSchools mode.",
                        "default": 1000
                    }
                }
            },
            "runsResponseSchema": {
                "type": "object",
                "properties": {
                    "data": {
                        "type": "object",
                        "properties": {
                            "id": {
                                "type": "string"
                            },
                            "actId": {
                                "type": "string"
                            },
                            "userId": {
                                "type": "string"
                            },
                            "startedAt": {
                                "type": "string",
                                "format": "date-time",
                                "example": "2025-01-08T00:00:00.000Z"
                            },
                            "finishedAt": {
                                "type": "string",
                                "format": "date-time",
                                "example": "2025-01-08T00:00:00.000Z"
                            },
                            "status": {
                                "type": "string",
                                "example": "READY"
                            },
                            "meta": {
                                "type": "object",
                                "properties": {
                                    "origin": {
                                        "type": "string",
                                        "example": "API"
                                    },
                                    "userAgent": {
                                        "type": "string"
                                    }
                                }
                            },
                            "stats": {
                                "type": "object",
                                "properties": {
                                    "inputBodyLen": {
                                        "type": "integer",
                                        "example": 2000
                                    },
                                    "rebootCount": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "restartCount": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "resurrectCount": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "computeUnits": {
                                        "type": "integer",
                                        "example": 0
                                    }
                                }
                            },
                            "options": {
                                "type": "object",
                                "properties": {
                                    "build": {
                                        "type": "string",
                                        "example": "latest"
                                    },
                                    "timeoutSecs": {
                                        "type": "integer",
                                        "example": 300
                                    },
                                    "memoryMbytes": {
                                        "type": "integer",
                                        "example": 1024
                                    },
                                    "diskMbytes": {
                                        "type": "integer",
                                        "example": 2048
                                    }
                                }
                            },
                            "buildId": {
                                "type": "string"
                            },
                            "defaultKeyValueStoreId": {
                                "type": "string"
                            },
                            "defaultDatasetId": {
                                "type": "string"
                            },
                            "defaultRequestQueueId": {
                                "type": "string"
                            },
                            "buildNumber": {
                                "type": "string",
                                "example": "1.0.0"
                            },
                            "containerUrl": {
                                "type": "string"
                            },
                            "usage": {
                                "type": "object",
                                "properties": {
                                    "ACTOR_COMPUTE_UNITS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATASET_READS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATASET_WRITES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "KEY_VALUE_STORE_READS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "KEY_VALUE_STORE_WRITES": {
                                        "type": "integer",
                                        "example": 1
                                    },
                                    "KEY_VALUE_STORE_LISTS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "REQUEST_QUEUE_READS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "REQUEST_QUEUE_WRITES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATA_TRANSFER_INTERNAL_GBYTES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATA_TRANSFER_EXTERNAL_GBYTES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "PROXY_RESIDENTIAL_TRANSFER_GBYTES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "PROXY_SERPS": {
                                        "type": "integer",
                                        "example": 0
                                    }
                                }
                            },
                            "usageTotalUsd": {
                                "type": "number",
                                "example": 0.00005
                            },
                            "usageUsd": {
                                "type": "object",
                                "properties": {
                                    "ACTOR_COMPUTE_UNITS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATASET_READS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATASET_WRITES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "KEY_VALUE_STORE_READS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "KEY_VALUE_STORE_WRITES": {
                                        "type": "number",
                                        "example": 0.00005
                                    },
                                    "KEY_VALUE_STORE_LISTS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "REQUEST_QUEUE_READS": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "REQUEST_QUEUE_WRITES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATA_TRANSFER_INTERNAL_GBYTES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "DATA_TRANSFER_EXTERNAL_GBYTES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "PROXY_RESIDENTIAL_TRANSFER_GBYTES": {
                                        "type": "integer",
                                        "example": 0
                                    },
                                    "PROXY_SERPS": {
                                        "type": "integer",
                                        "example": 0
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
    }
}
```
