Skip to content

CSC Dashboard Early Adopters – Data to Insight API Solution

Status

Version Spec Platform SSD%20Compatible DfE%20API
Data%20Format Code-Python Code-PowerShell Code-SQL Data%20Transfer

This repository contains solution overview details for the Data to Insight (D2I) approach within the CSC Dashboard Early Adopters Scheme.
It provides documentation, technical resource(s), and updates for local authorities (LAs) using or looking to deploy the Standard Safeguarding Dataset (SSD) API connection to share agreed timely children’s social care (CSC) data with the Department for Education (DfE).

Purpose of this Front End

  • Explain the D2I API approach — what it is, how it works, and what’s needed to participate
  • Provide step-by-step onboarding materials for LAs implementing as part of the pilot scheme or exploring the SSD API connection
  • Offer reference documentation for data items, API endpoints, and validation rules
  • Share updates and troubleshooting guidance based on live pilot experience

Context

The Early Adopters Scheme is part of DfE’s ambition to improve CSC data flows, reduce burden on LAs, and provide more timely insights through a secure, private-access dashboard.
This front end focuses entirely on the Data to Insight API solution — including the needed SSD deployment — and serves as the main resource for Phase 1(pilot) and Phase 2 participants as well as those with a contextual longer-term interest in the project details or progress.

There are three key elements:

If you are arriving here without previous knowledge of the wider scheme, please see:

DfE Published Project Documentation

SSD schema Technical aspects and Published Project Documentation

Audience

This site is aimed at: - Local authority teams using or preparing to implement the D2I SSD API solution
- DfE & D2I project teams supporting onboarding and technical testing
- Stakeholders interested in the Standard Safeguarding Dataset(SSD)

How will the D2I solution work?

The Standard Safeguarding Dataset (SSD) acts as a middleware layer between a local authority’s case management system (CMS) and standardised LA reporting, but also in this use-case towards a Department for Education’s CSC API. It standardises CSC data into a cross-LA, cross-CMS consistent schema, thus enabling automated, low-burden data sharing.

Deployment
For many LAs, SSD installation is close to plug-and-play; others may need adaptations to align with local|bespoke CMS or reporting structures. Once deployed, the SSD unlocks additional benefits such as:
- Enabling standardised reporting and dashboards
- Easier data sharing(if desirable/agreed) and collaboration across the sector
- Re-use of proven reports and insight tools developed by other LAs (i.e. SSD-LA1 reporting tools will now also works in SSD-LA2, SSD-LA3...)

Data flow
1. Extract — Agreed CSC data is drawn directly from the SSD schema 2. Format — Data is packaged in JSON format, either as:
- a daily snapshot (initial approach)
- or daily deltas showing only changes since the previous day
3. Transmit — JSON data is securely sent to DfE via an authenticated API connection 4. Acknowledge — DfE systems confirm receipt and log any errors 5. Log & store — The D2I solution keeps a local copy of submitted files and DfE responses within the SSD for audit and troubleshooting

Outcome
The DfE uses this data to produce up-to-date indicators for the private CSC dashboard, enabling faster benchmarking against the National Framework and earlier identification of trends across the sector. Interested LA's should read the DfE published project details regarding the data use for details.

More detail on SSD benefits and deployment can be found in the SSD project documentation (opens in new tab).