Providing social workers in Children's Social Care with more complete information on people relevant to the social work assessment to improve outcomes for children.

Family Context is a tool that allows social workers to easily access ​ service involvement information on relevant individuals ​ in order to then facilitate conversations with lead practitioners. ​ We want to ensure that social workers always have the information they need so that:​ - More young people are well looked after by their families and…

In this Alpha, we developed a prototype that could help local councils identify and resolve errors in their children in care data throughout the year. We focused on a common statutory process (SSDA903) and built a prototype that users can access by simply loading a URL in a web browser.

Conducting varied pieces of analysis off of Annex A data required us to repeatedly clean the data of typos, inconsistencies, incorrect column labels, and many more fun things. We realised that there was value in writing a "cleaner" that would standardize the data so that we could get on with the analysis without re-cleaning each time.

This code provides cleaning for 1) Annex A, aligning it to the Ofsted guidance (column headings, column values) and for 2) CIN Census (lighter cleaning taking out empty values and checking value categories). Finally the code offers a "LOG" option that aggregates Annex A and/or CIN Census data into a master table easy to use for analysis.

This code is for data analysts from a Local Authority or from another body wishing to analyse CIN Census and Postcode data. We hope the analysis provided will help them to understand more about what the needs identified at assessment look like in their area, and to see where there are geographic hotspots or pockets of need.

Extracts children journeys from Annex A: each child unique ID is associated to a string representing all the events that happened to them.

This code is for data analysts from a Local Authority or from another body wishing to analyse Annex A data. We are happy to share this code hoping that others may benefit from a quick way to analyse their Annex A returns and get new insights about their Front Door and MASH.

Providing social workers in Children's Social Care with more complete information on people relevant to the social work assessment to improve outcomes for children.

Understanding the pain points in the Looked After Children (LAC) dataset statutory return process