School Rating Converter & Equivalence API

Different sites rate schools differently: 1-10 deciles, A-F letters, 5 stars, Ofsted bands, colour dashboards. This actor converts any of them to one 0-100 scale, matches the school to federal data and returns a combined score with an explanation.

What does School Rating Converter & Equivalence API do?

• Supports deciles, relative letter grades, state report-card letters, stars, Ofsted and dashboard colours
• Matches the school name and state to federal open data
• Returns the converted score for each rating plus a blended score
• Clear notes on what each scale means so users do not compare apples to oranges

How to use it

1. Click Try for free and open the Input tab.
2. Fill in the fields below, or keep the defaults for a quick test.
3. Press Start. Results appear in the Output tab within seconds to a few minutes.
4. Download as JSON, CSV or Excel, or call the actor from the API, a schedule, Make, Zapier or an AI agent through the Apify MCP server.

Input

Field	Type	Description
schools	array	List of schools. Each item: name, state (2-letter), optional city or ncessch, and ratings [{source, value, weight?}]. Sources: GreatSchools, Niche, Fraser, letter, stars, percent, GPA, Ofsted, dashboard, or use values like 7/10.
matchNcesRecord	boolean	For US schools, match the official NCES record (enrollment, grades, ratios).
includeOpenDataScore	boolean	Add an estimated score from public graduation and proficiency data.

Example input

{
  "schools": [
    {
      "name": "Roosevelt High School",
      "state": "DC",
      "city": "Washington",
      "ratings": [
        {
          "source": "GreatSchools",
          "value": "2"
        },
        {
          "source": "Niche",
          "value": "C+"
        },
        {
          "source": "Fraser",
          "value": "4.5"
        }
      ]
    }
  ],
  "matchNcesRecord": true,
  "includeOpenDataScore": true
}

Output

Each result is a flat JSON object that you can open in the Output tab, export to CSV or Excel, or read through the API. See the dataset views for the main columns.

How much does it cost to use School Rating Converter & Equivalence API?

Pricing is pay per event: $0.003 per school. You pay only for results saved to the dataset, plus nothing extra for platform usage on the free plan limits. Apify's free monthly credit lets you test it before paying.

FAQ

Does it scrape rating sites? No. You supply the ratings; the actor only converts and combines them with open federal data.

Why are relative and absolute letter grades separate? A C on Niche-style grades is average, while a C on a state report card is a pass. They are mapped to different scores.

Is the combined score official? No. It is a normalisation aid, not an official rating.

Is it legal?

The actor reads public, open-licence or government data only and does not collect private information. You are responsible for using the results in line with the source's terms and applicable laws.

Use it with AI agents (MCP)

This actor is agent-ready: it is a plain tool with a documented JSON input and a flat JSON output, so Claude, ChatGPT, Cursor and other agents can call it through the Apify MCP server.

Add it to an MCP client with this URL (Apify account or agentic payment required):

https://mcp.apify.com/?tools=flyingnimbus/school-rating-normalizer

Example prompt: "Use the School Rating Converter & Equivalence API tool with the example input below and summarise the results."

Calls are pay per event ($0.003 per school), so an agent can estimate the cost before it runs. Empty or failed lookups return a status record instead of failing the run.

More actors by flyingnimbus

• Property Details by Address API
• Schools Near Address Finder API
• Building Permits Multi-City API
• Company Registry Lookup (LEI + SEC)
• Restaurant Inspections API - NYC, Chicago, Toronto
• CVE Risk Enricher - NVD, CISA KEV & EPSS
• SEC Insider Trades (Form 4) - Buys & Sells
• SEC 13F Holdings Tracker
• EU Company Registry Search
• Canada Recalls & Safety Alerts Monitor
• Sitemap & Robots.txt Analyzer
• Email Validator - MX, SPF & DMARC
• Website Tech Stack Detector
• PDF Text & Table Extractor
• URL to Markdown + Metadata
• SSL Certificate Expiry Checker
• VIN Decoder + Recalls API
• ClinicalTrials.gov Search API
• US Federal Contracts & Grants (USAspending)
• Federal Register Search API
• FDA Recalls & Drug Labels API
• Eurostat Data API
• UK Government Tenders (Contracts Finder)

Feedback

Found a bug or need another field or city? Open an issue on the actor's Issues tab and it will be looked at quickly.