Daily Case Trends by Health Board

URL: https://www.opendata.nhs.scot/dataset/b318bddf-a4dc-4262-971f-0ba329e09b87/resource/2dd8534b-0a6f-4744-9253-9565d62f96c2/download/trend_hb_20231004.csv

Daily and cumulative counts and rates for positive COVID-19 cases, negative cases, deaths, Testing by NHS Labs (Pillar 1) and UK Government (Pillar 2) at Health board level. New Covid-19 Hospital Admissions and New Covid-19 ICU admissions are provided in this file for Scotland only. Daily figures of hospital and ICU occupancy at Health Board and Scottish level are also reported in this file.

The number of deaths is defined as the total number of individuals who die within 28 days of a laboratory confirmed report of COVID-19 and are registered with National Records for Scotland. Please note that the updated methodology for determining COVID-19 related ICU admissions has been applied to the historic data. The updated definition is as follows: A patient who has tested positive for COVID at any time in the 21 days prior to admission to ICU, or who have tested positive from the data of admission up to and including the date of ICU discharge. COVID-19 admissions have been identified as the following: A patient's first positive PCR test for COVID-19 up to 14 days prior to admission to hospital, on the day of their admission or during their stay in hospital. If a patient's first positive PCR test is after their date of discharge from hospital, they are not included in the analysis.

In the data presented here, an admission is defined as a period of stay in a single hospital. There may be multiple admissions for a single patient if they have moved between locations during a continuous inpatient stay (CIS), or if they have been admitted to hospital on separate occasions.

The number of reported acute hospitalisations does not take into account the reason for hospitalisation. Therefore, people that were admitted for a non-COVID-19 related reason (and tested positive upon admission) may be included and result in an overestimation of COVID-19 related acute hospitalisations.

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

Download resource

Data Dictionary

Column Type Label Description
Date numeric
HB text
HBName text
DailyPositive numeric
CumulativePositive numeric
DailyPositivePCROnly text
CumulativePositivePCROnly text
DailyPositiveLFDOnly text
CumulativePositiveLFDOnly text
DailyPositivePCRAndLFD text
CumulativePositivePCRAndLFD text
DailyDeaths numeric
DailyDeathsQF text
CumulativeDeaths numeric
CumulativeDeathsQF text
CrudeRateDeaths numeric
CrudeRateDeathsQF text
PositiveTests numeric
PositiveTestsLFDOnly text
HospitalAdmissions numeric
HospitalAdmissionsQF text
ICUAdmissions numeric
ICUAdmissionsQF text
PositivePillar1 numeric
PositivePillar2 numeric
FirstInfections numeric
FirstInfectionsCumulative numeric
Reinfections numeric
ReinfectionsCumulative numeric
PercentReinfections numeric
PercentReinfectionsCumulative numeric
TotalTests numeric
TotalPillar1 numeric
TotalPillar2 numeric
TotalLFD text
HospitalOccupancy numeric
ICUOccupancy28daysless numeric
ICUOccupancy28daysmore numeric

Additional Information

Field Value
Data last updated October 5, 2023
Metadata last updated July 29, 2020
Created July 29, 2020
Format text/csv
License UK Open Government Licence (OGL)
createdover 3 years ago
datastore activeTrue
formatCSV
has viewsTrue
id2dd8534b-0a6f-4744-9253-9565d62f96c2
last modified5 months ago
mimetypetext/csv
on same domainTrue
package idb318bddf-a4dc-4262-971f-0ba329e09b87
position4
revision id5e388852-278b-4293-8cb4-ff7fc8ef718d
size2.9 MiB
stateactive
url typeupload