Scotland Counted

Free to download and reuse

Download Scotland data

This is the proof behind the simple pages. Twenty four downloadable files: 19 CSVs, two Excel workbooks, two method notes and one source manifest. Seventeen I prepared and documented; the other seven are the publishers' own files, served exactly as they came, so you can check my working against them.

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

CSV

The 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

CSV

Every 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

CSV

The 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

CSV

Each 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

CSV

Neighbourhood, 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

CSV

What 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

CSV

All 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

CSV

A 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

MD

Every 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

MD

A 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

JSON

Publisher, 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

CSV

The 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

CSV

Every 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

CSV

Ten 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

CSV

Every 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

CSV

Five 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

CSV

Life 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

CSV

Annual 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

CSV

Claimants 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

CSV

ASHE 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

CSV

ASHE 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

CSV

Jobs 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

XLSX

The 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

XLSX

The 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.