Free to download and reuse
Download Scotland data
Files I prepared
Built from the sources below and documented so the working can be checked. The data files open cleanly in a spreadsheet, with readable columns and one row per observation; the council index also includes its method, validation report and hashed source manifest.
Council performance index, all 32 results
CSVThe main and like for like result for every Scottish council, with all five parts of the score, the data available and the usual rank from 10,000 reruns.
Columns: council, score and rank, peer score and rank, coverage, five pillars, median and 5th–95th percentile rank, winner/top-five/top-ten frequency
6 KB · 32 rows · scottish-council-performance-index-2026.csv
Download
Council index: all 29 groups of figures
CSVEvery topic used for every council, including its label, part of the score, official source codes, score and how much data was available.
Columns: council, evidence family, score, coverage, label, pillar, domain, indicator count and source codes
175 KB · 928 rows · scottish-council-performance-evidence-2026.csv
Download
Council index: every official figure used
CSVThe official numbers behind the ranking, with their year, unit, whether higher or lower is better, missing data notes and converted score.
Columns: council, indicator and year, raw value, direction, unit, family, missing/modelled flags and normalised score
408 KB · 1,914 rows · scottish-council-performance-indicators-2026.csv
Download
Council index: what happened in 10,000 reruns
CSVEach council's usual rank, middle 90% range and how often it won or reached the top five and top ten when we changed the rules.
Columns: council, median rank, rank 5th and 95th percentiles, winner probability, top five probability and top ten probability
3 KB · 32 rows · scottish-council-performance-robustness-2026.csv
Download
Council index: place and accountability context
CSVNeighbourhood, loneliness, housing, crime, poverty, drug death, budget gap and Crisis Grant figures kept outside the performance score so circumstances are not mistaken for council competence.
Columns: council, neighbourhood, loneliness, housing, crime, child poverty, drug deaths, budget gap and Crisis Grant measures
7 KB · 32 rows · scottish-council-performance-context-2026.csv
Download
Council index: checks on every measure
CSVWhat we used or left out, with the meaning, service, year, whether higher or lower is better and how many councils had data.
Columns: indicator, period, evidence family, use, title, service area, category, unit, direction and coverage
15 KB · 81 rows · scottish-council-performance-indicator-audit-2026.csv
Download
Council index: residents' verdict
CSVAll five council perception questions from the 2024 Scottish Household Survey, with the equal weight average, rank and local respondent base used in the article.
Columns: council, five perception estimates, average, relative score, rank and survey base
4 KB · 32 rows · scottish-council-resident-verdict-2024.csv
Download
Council landlord comparison
CSVA separate comparison for the 26 councils with comparable housing stock. It stays outside the headline score because six councils cannot be assessed on the same basis.
Columns: council, council landlord score, rank and metrics used
1 KB · 26 rows · scottish-council-landlord-index-2026.csv
Download
Council index: how we worked it out
MDEvery public rule: what counted, how much it counted, how figures became scores, what happened when data was missing and what we left out.
5 KB · scottish-council-performance-methodology-2026.md
Download
Council index: a separate check of the maths
MDA second calculation checked the source files, council matches, scores, value for money rules, 10,000 reruns and warnings shown to readers.
3 KB · scottish-council-performance-validation-2026.md
Download
Council index source manifest
JSONPublisher, direct source URL, period, retrieval date, byte size and SHA-256 hash for all 11 frozen input files used to build and validate the index.
5 KB · scottish-council-performance-source-manifest-2026.json
Download
Scotland wide poverty headline
CSVThe latest official relative poverty rates after housing costs for all people, children, working age adults and pensioners, 2022–25.
Columns: period, group, relative_poverty_after_housing_costs_pct, people, source
252 B · 4 rows · scotland-poverty-headline-2022-25.csv
Download
All headline indicators
CSVEvery series plotted on this site in one tidy file, with the source and any caveat attached to each row.
Columns: indicator, period, glasgow, scotland, glasgow_count, source, note
5 KB · 61 rows · glasgow-poverty-indicators.csv
Download
Child poverty, all 32 council areas
CSVTen years of rates for every Scottish council area, ranked by current level, with the change over the decade.
Columns: council, area_code, then one column per year from 2014/15 to 2023/24
3 KB · 32 rows · scottish-councils-child-poverty.csv
Download
Council performance and budgets, all 32 councils
CSVEvery council on the seven measures they all report the same way, plus the extra money each said it needed for 2026/27. A Scotland row sits at the bottom to compare against. Regenerate with npm run data:build:councils.
Columns: council, council_code, budget_gap_2026_27_gbp_m, then a value and a rank for each measure. Years are in the column names because the road figures are a year fresher than the rest.
4 KB · 32 councils plus a Scotland row · scottish-councils-benchmarks.csv
Download
Crisis Grants, all 32 councils
CSVFive years of council award rates, plus 2025/26 applications, decisions, awards, rejections, spending, average awards and the latest processing performance. Ranked by the published award rate with the Scotland comparison beside every row.
Columns: council, applications, decisions, awards, rejections, five annual award rates, rank, difference from Scotland, spend, average award, latest quarter processing, source and notes
12 KB · 32 rows · scottish-crisis-grants-by-council-2025-26.csv
Download
Life expectancy
CSVLife expectancy at birth by sex for Glasgow and Scotland, 2001–03 to 2022–24, taken from the National Records of Scotland council area tables so you do not have to open the 5 MB workbook.
Columns: period, glasgow_male, glasgow_female, scotland_male, scotland_female
669 B · 22 rows · nrs-life-expectancy-glasgow-scotland.csv
Download
Original files, exactly as published
Saved and served unaltered, down to the publisher's own column names, NOMIS uses DATE_NAME, GEOGRAPHY_NAME and OBS_VALUE. Nothing has been renamed, reordered, rounded or filtered. Use these to check my working.
Employment
CSVAnnual Population Survey table T01 for Glasgow and Scotland, exactly as returned by the NOMIS API.
29 KB · 344 rows · nomis-employment-aps-2004-2025.csv
Download
Claimant count
CSVClaimants as a share of residents aged 16–64, each January from 2000 to 2026.
2 KB · 54 rows · nomis-claimant-count-2000-2026.csv
Download
Restricted full time pay | workplace basis
CSVASHE median gross weekly pay for selected full time PAYE employee jobs located in Glasgow and Scotland. This is not the average wage of everyone working there.
1 KB · 58 rows · nomis-ashe-pay-workplace.csv
Download
Restricted full time pay | residence basis
CSVASHE median gross weekly pay for selected full time PAYE employee jobs held by Glasgow and Scottish residents. Part time jobs and self employment are excluded.
1 KB · 48 rows · nomis-ashe-pay-residence.csv
Download
Jobs density
CSVJobs per working age resident for Glasgow and Scotland. Glasgow is published to 2021.
1 KB · 50 rows · nomis-jobs-density-2000-2024.csv
Download
End Child Poverty source workbook
XLSXThe publisher's own spreadsheet, covering every UK local authority and constituency. Several sheets, and the figures are not on the first one.
272 KB · end-child-poverty-AHC-2015-2024.xlsx
Download
NRS drug related deaths source workbook
XLSXThe publisher's complete workbook for Scotland in 2024, including deprivation quintiles, every council area, trends, definitions and substances implicated.
226 KB · nrs-drug-related-deaths-scotland-2024.xlsx
Download
Can I reuse it?
Yes. The original data belongs to , , the Scottish Government, End Child Poverty and Loughborough University. Their licence rules still apply to the original files.
My cleaned files, charts and words are free to reuse if you credit Scotland Counted. You do not need permission. Journalists and researchers can ask for a different file format.
Any calculation I made is explained on the how I counted it page.
If a number does not match, tell me
People can make mistakes when copying or cleaning data. I check reported errors, fix confirmed mistakes and keep a public record.
One simple next step