Last Updated: 27th July
Cases and Deaths by Council Area and Specimen Date
Daily Increase by Council Area
Breakdown by Council Area
Totals by Council Area and NHS Region
Cases by Intermediate Zone
Cases by Intermediate Zone Map
Support the Page!
If you are finding this page useful and want to help keep it running, maybe consider giving a donation below.
Any help is really appreciated!! 🙂
Let me know if you spot an error / Have a suggestion!
About Coronavirus (COVID-19)
Main Data Sources
Share this Page
Me! I’m John, a 26-year-old student and Cat lover at the University of the Highlands and Islands. I started tracking the Coronavirus (COVID-19) data in a spreadsheet out of interest, which eventually led to me making this page.
Rather than buying a new domain to host it, I just added it to my ‘Travelling Tabby’ website. This is a travel blog, and has absolutely nothing to do with the Coronavirus. But still, feel free to look around if you want! (although there isn’t much on the blog, as most of my free time since the start of 2020 has been spent on this page)
If you need to contact me, you can use the contact form on this page, or email me at [email protected]. I will respond when I can, but I’m quite busy right now and get a lot of emails, so replies may take a while!
Loads! Here are some of them:
UK Coronavirus Tracker – Another page by me, keeping track of all the UK and worldwide data (with lots of national/regional comparisons included)
Worldometers – Worldwide Data in an easy table format
WHO – Worldwide Data with an attractive design
Our World in Data – A large website with heaps of data on the pandemic across the world
NYT – USA Data
Public Health Scotland – The official Scottish dashboard, with some additional figures on there
Covidvax.live – Worldwide vaccine tracker in real time
Covid-19 Risk – A neat website that lets you calculate the level of risk involved in attending an event in your area, based on recent case rates
Yeah! I routinely post different types of charts and comparisons on Twitter!
Also, here is a link to the spreadsheet I use. Feel free to download a copy. It is a bit of a mess, but it could be useful if you were looking for some raw data.
Here is a list of all the official pages involving Coronavirus figures for Scotland (that I know of):
ScotGov – Daily headline figures on cases, deaths, testing, hospital occupancy, and vaccinations
PHS Dashboard – Daily figures going into the above in more detail, including local figures, demographics, and detailed vaccination figures
NRS Weekly Report – A weekly report looking at deaths by an alternative death count. Also includes extra information, like excess deaths, location of death, more detailed ages of death. Once a month a very detailed report comes out, looking at factors such as deprivation, pre existing conditions, and so forth.
PHS Weekly Report – A weekly report looking at a whole range of things, including lateral flow tests, cases in children, contact tracing, quarantining stats, lateral flow tests, community testing, and cases by profession.
PHS Weekly Dashboard – A dashboard that is updated once a week, consisting of data included in the PHS weekly report above.
PHS Wider Impacts Dashboard – A dashboard looking at a range of general health factors and how the pandemic has impacted them (primarily through comparisons to previous years). Such as total hospital appointments, A&E attendances, cancer diagnoses, and much more.
PHS Education Dashboard – A weekly dashboard looking at cases, testing, and hospital admissions in children and those working in the education sector.
ScotGov Impact Dashboard – A weekly dashboard looking at covids impact throughout society. Includes stuff like public opinion polls, school attendance, crime rates, unemployment rate, and more.
ScotGov Modelling the Pandemic – A weekly report which provides an update of the current R number, and covers other areas relating to the current prevalence of the virus in Scotland.
UK Gov – A page looking at the UK covid wide data, but a lot of it shows each nation separately.
ONS Weekly Infection Survey – A weekly report that looks at covid rates throughout the UK (which includes a section Scotland specifically), and estimates the total number of people who currently have the virus.
One issue might be that you’re using Firefox. This browser seems to break the page for a lot of people, and I have no idea what is causing it. My only suggestion would be to try viewing the page on another browser, as it just seems to be Firefox which has issues, on a range of devices.
If things in general aren’t updating, then it might just be that the page your browser is showing you hasn’t updated to show the most recent version. This seems to be an issue for only some people, for whatever reason. But if you view the page in private/incognito mode, then the issue should go away.
It’s a WordPress site, built with Elementor. That covers most of the page, but all the graphs/charts/tables are embeds from a range of different places!
These are Datawrapper, Flourish, and Everviz. The Datawrapper and Flourish charts will mention their name in the footer, and if there’s no mention, it is an Everviz chart. Oh, and the non Datawrapper maps are made with MapSVG!
I’d be happy to answer any other questions about it, but it is quite simple. I’m not really any good at programming/automation, and I’m new to all of this, so it is mostly just a lot of copying/pasting to get the website updated daily.
Additional Information / Clarifications
When someone tests positive in Scotland, the case is assigned to an NHS health board region. Normally by their postcode, but if there’s no postcode available, then they are assigned to the health board in which they took the test.
So even if there’s no postcode available for the person who tested positive, the case will still be counted nationally and as a health board case. So as a result, the daily health board increases we get told about will exactly match the nationwide increase.
The case will also be assigned to the relevant council area, again going off their postcode. However, if there’s no postcode available, then this infection won’t be assigned to any council region. As a result, the council region totals won’t sum to match the nationwide total, and the sum of the council areas within a health board may not match the actual health board figure.
E.g, we might see 15 new cases reported in the ‘Highlands’ health board, but only 13 cases reported between the ‘Highlands’ and ‘Argyll & Bute’ council areas. That would mean there are 2 extra cases within the Highlands health board, but they’ve just not been assigned to a specific council area.
To make things more confusing, I think postcodes can be assigned at a later date, which results in the council area having an ‘increase’, which actually happened weeks ago.
Again using the above example, we might see the ‘Highlands’ health board report 15 new cases in a day, and the ‘Highlands’ and ‘Argyll & Bute’ council areas report 20 new cases between them. So 5 old cases were added to the council area totals, which were already counted in the health board at a previous date.
So if you see the council area infections not matching the nationwide totals, then this will be why! To give a better representation of the daily increases, I try to add those unknown cases into my “Total by Council Area and NHS Region” chart, under the “New Cases Today” tab as “unknown” cases (on the Scotland local page). But if the council areas sum to a figure greater than the health board figure, then there’s nothing I can really do about that.
Scot Gov Daily Trends Spreadsheet – The headline figure of cases, deaths, tests, test positivity, and vaccinations. This also has the current number of people in hospital / ICU in it.
Scot Gov Modelling the Epidemic – The R number comes from here
PHS General Data – The data files here are where I get council area case/death/test data (including intermediate zone case data), cases/death data by age, and case/death data by specimen date.
PHS Vaccination Data – The data files here are where I get all of the detailed vaccinations data. Including figures by age group, priority group, council area, and vaccine type.
PHS Weekly Report Dashboard – This is where I get the data on hospital/ICU admissions, and also hospital admissions by age group.
NRS Weekly Report – This is where I get the death certificate deaths for the additional death data page, and also the excess death figures (I work them out with the data provided here). The deaths by age group figures are included in the ‘related statistics’ page, and I personally get them from the “Weekly deaths by sex and age group in NHS health boards, 2020 and 2021” sheet. The deaths by intermediate zone data is also released here, but only once a month. Go to the archive page to see the previous releases of the monthly report on it.
I think that covers all of it! A lot of the figures on the page aren’t included in these sources, as I just work it out myself (stuff like the percentage change from last week). But if you need help finding anything else, just send me a message I’d be happy to help!
I aim to update this page every day, for 3pm. Although unfortunately this isn’t always possible due to data not being released on time, or something else in my life taking priority.
But it is updated by 3pm or shortly after most days! If a delay or more than 10-15 minutes is expected, I will put out a tweet to let people know.
On public holidays, the amount of data being released can vary, so the page will only be partially updated, or potentially not updated at all. I’ll include a header banner on this page to let people know when/if that is occurring.
But in general, here are things to be aware of each day:
Monday: The hospital, individual people tested, and 7-day positivity rate figures are updated again
Tuesday: Updated as normal
Wednesday: The weekly NRS death data page, and the hospital admission data is updated
Thursday: Updated as normal
Friday: The R number is updated
Saturday: The hospital, individual people tested, and 7-day positivity rate figures are not updated
Sunday: The hospital, individual people tested, and 7-day positivity rate figures are not updated
The data on this page is obtained from official sources, and it is accurate to the best of my knowledge. However, I am only human! I sometimes make miscalculations, or typos. Don’t always take the information on this page as fact and base decisions off it.
All the sources are listed above, as is the spreadsheet I make all my calculations in, so feel free to double check the data and let me know if you think something isn’t correct!
This website is not associated with the Scottish government, UK government, NHS, or any other organization. It is just run by an individual who does not value his free time.