The Care Quality Commission (CQC) has to date assessed 72 local authorities across 9 quality statements. I wanted to look at how the outcome of Kent County Council’s CQC assessment compared nationally with other local authorities.
The CQC website has several pages of links to all the local authority assessments completed. Each assessment page has another link to the outcome summary for the respective local authority. I could not find an aggregated table of results to make easy comparisons between them. Clicking link after link to diplay each summary page in a new tab was not going to work.
I spent a few hours today coding with prompts to Claude Sonnet 4.5 via Perplexity to create the interactive reports linked below:
📊 Comprehensive Analysis of All 72 Authorities
Complete breakdown of ratings for each quality statement, top/bottom performers, and full dataset.
📍 Kent-Focused Analysis
Detailed analysis focusing specifically on Kent County Council’s assessment.
🏆 CQC Local Authority Assessment League Tables Interactive rankings across all 9 quality statements with theme-based comparisons and performance heat maps
Each report includes sortable tables and detailed metrics for each authority’s performance. It’s kind of work related. They display the data in a way that works for me and enable making the comparisons I was after.
It was close to 100% vibe coding. One of many DiY coding projects I have completed this way. Prompt, test, iterate. Job done. Good enough will do.