Daily Case Trends By Council Area

URL: https://www.opendata.nhs.scot/dataset/b318bddf-a4dc-4262-971f-0ba329e09b87/resource/427f9a25-db22-4014-a3bc-893b68243055/download/trend_ca_20201129.csv

Daily and cumulative counts and rates for positive COVID-19 cases, negative tests and deaths at Council area level.

Please note that from 18 June, the data released includes testing results from the UK Government’s Regional Testing Centres, as well as data from NHS Laboratories, including historic test results.

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

Download resource

Data Dictionary

Column Type Label Description
Date numeric Date of specimens taken or patient date of death.
CA text Council Area code, based on boundaries as at 1st April 2019. Council area is assigned based on postcode of residence, if postcode of residence is missing no council area is assigned.

Council area labels

CAName text Name of the Council Area
DailyPositive numeric Daily number of positive COVID-19 cases.
CumulativePositive numeric Cumulative number of positive COVID-19 cases.
CrudeRatePositive numeric Crude rate of total positive cases per 100,000 population.
DailyDeaths numeric Daily number of COVID-19 deaths, defined as the total number of individuals who die within 28 days of a laboratory confirmed report of COVID-19 infection and are registered with National Records for Scotland.
CumulativeDeaths numeric Cumulative number of COVID-19 deaths, defined as the total number of individuals who die within 28 days of a laboratory confirmed report of COVID-19 infection and are registered with National Records for Scotland.
CrudeRateDeaths numeric Crude rate of total COVID-19 deaths per 100 000 population.
CumulativeNegative numeric Total number of negative COVID-19 cases at each specimen date.
CrudeRateNegative numeric Crude rate of total negative cases per 100,000 population.
TotalTests numeric Total number of tests performed on this date.
PositiveTests numeric Number of positive tests performed on this date.
PositivePercentage numeric Percentage of positive tests performed on this date.
TotalPillar1 numeric Total number of tests carried out by NHS Labs (Pillar 1) on this date.
TotalPillar2 numeric Total number of tests carried out by UK Gov testing programme (Pillar 2) on this date.

Additional Information

Field Value
Data last updated November 29, 2020
Metadata last updated July 29, 2020
Created July 29, 2020
Format text/csv
License UK Open Government Licence (OGL)
created4 months ago
datastore activeTrue
formatCSV
has viewsTrue
id427f9a25-db22-4014-a3bc-893b68243055
last modified23 hours ago
mimetypetext/csv
on same domainTrue
package idb318bddf-a4dc-4262-971f-0ba329e09b87
position6
revision id2f1a18cd-8ddc-4f8e-9d22-2da60813aaad
size1 MiB
stateactive
url typeupload