Weekly Tests and Cases by Council Area

URL: https://www.opendata.nhs.scot/dataset/49dc2d88-1cb0-4420-a5ea-d1bbada62fb2/resource/591a0262-6827-4261-a115-46f33e3a9225/download/weekly_tests_cases_ca_20250423.csv

Weekly counts of all COVID-19 tests, positive tests and cases at Council Area (Local Authority) level.

Please note, the sum of tests and cases from all Council Areas may not match the number of tests and cases in the “Weekly Tests and Cases by Health Board” file. This is due to some tests being recorded with incomplete postcodes.

This resource view is not available at the moment. Click here for more information.

Download resource

Data Dictionary

Column Type Label Description
WeekEnding numeric

This represents the week a test or case was recorded, as the last day (Sunday) of that week. This is stored as a numeric in the format CCYYMMDD.

CA text

Council Area code, based on boundaries as at 1st April 2019. Council area (Local authority) is assigned based on ECOSS postcode, if ECOSS postcode is missing we will then use the postcode on Community Health Index database, if the postcode is blank after the previous attempts, no council area is assigned.

WeeklyTotalTests numeric

Total number of COVID-19 tests recorded in the last seven days

WeeklyTotalPositiveTests numeric

Total number of positive COVID-19 tests recorded in the last seven days

WeeklyCases numeric

Number of cases recorded in the last seven days

WeeklyPCROnlyCases numeric

Number of PCR only cases recorded in the last seven days

WeeklyLFDOnlyCases numeric

Number of LFD only cases recorded in the last seven days

WeeklyPCRAndLFDCases numeric

Number of PCR and LFD cases recorded in the last seven days

CumulativeCases numeric

Cumulative number of cases recorded to date

CumulativePCROnlyCases numeric

Cumulative number of PCR only cases recorded to date

CumulativeLFDOnlyCases numeric

Cumulative number of LFD only cases recorded to date

CumulativePCRAndLFDCases numeric

Cumulative number of PCR and LFD cases recorded to date

Additional Information

Field Value
Data last updated April 24, 2025
Metadata last updated November 23, 2023
Created November 23, 2023
Format text/csv
License UK Open Government Licence (OGL)
createdover 1 year ago
datastore activeTrue
formatCSV
has viewsTrue
id591a0262-6827-4261-a115-46f33e3a9225
last modified5 days ago
mimetypetext/csv
on same domainTrue
package id49dc2d88-1cb0-4420-a5ea-d1bbada62fb2
position6
revision id53dbb1b4-4139-4e0e-8134-42d351eb7a38
size457.6 KiB
stateactive
url typeupload