Last Updated: 24th October
Breakdown by Council Area
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)
Share this Page
Me! I’m John, a 25-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 web 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. Still, feel free to look around!
If you’re interested in visiting Scotland, maybe check out my Scotland page! If you are Scottish, then you could visit one of the other destination pages to get some ideas of where to go once this all blows over. 🙂
If you need to contact me, you can visit my contact page here, use the contact form on this page, or email me at [email protected]. I will try to respond when I can, although I’m quite busy right now and get a lot of emails, so replies may take a week or two!
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’s not very well laid out, and I’m normally messing around with something in it.. so if you see any random numbers just ignore them!
There’s not much ‘new’ data on there, it is just the current stuff on this page and a lot of historical data. But I’m sure some people will have a use for it 🙂
ScotGov also provide more information than I mention on my website. You can view the rest of that here.
NRS provide a monthly report on all Coronavirus deaths, and include more than I mention on my website. You can view that here.
HPS also provide a weekly report, which shows more information about who is being infected, who is being hospitalized, etc! You can view that here.
HPS has also recently created a dashboard here, with lots of additional information. The data on their page is mostly based on specimen date (the date the test was conducted), whereas the data on my page is mostly using the reported date (the date the result of the test was conducted). That is why the numbers may not exactly match up!
Sorry! A lot of people have this issue, 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 on Mac that doesn’t work. If you can, try to refresh your cache and see if it works better after that!
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 the MapSVG plugin!
I’d be happy to answer any other questions about it, but it is quite simple. A lot of manual data entry!
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. And 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 in those unknown cases into my “Total by Council Area and NHS Region” chart, under the “New Cases Today” tab as “unknown” cases. 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.
The data on this page is mostly 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.