Data Analyst
Below is a chart to show the growth in the number of reported Covid-19 cases for all countries reporting >10,000 new cases in the last 28 days. “GROWTH” measures the increase in the number of reported cases of the last 7 days relative to the first 7 days of the 28 days leading up to…
The chart below shows the weekly percentage growth in the number of cases of Covid-19 detected in the UK. On the second axis it shows the 7-day rolling average of the number of daily cases. It certainly looks as though we will be seeing 50k new cases detected per day before the end of July…
I have continued to experiment with Python to draw data charts, this time setting up Python (and Pandas, Numpy, SciPy, and Matplotlib) on Google Cloud Platform (https://cloud.google.com). Today (6th April 2021) I downloaded the latest official UK Coronavirus reported case data from https://coronavirus.data.gov.uk/details/cases and tried out some Matplotlib formatting and labelling.I made a column chart…
I took a look at the latest Covid-19 daily deaths in English hospitals statistics, available to download from the NHS website here: https://www.england.nhs.uk/statistics/statistical-work-areas/covid-19-daily-deaths/. They include a weekly breakdown by age of those who have lost their lives after testing positive for coronavirus. The Excel chart above shows the number in each age-group who died with…
Using the Coronavirus Pandemic Dataset, downloadable: https://ourworldindata.org/coronavirus-data from Our World in Data, I looked at how the number of deaths attributed to Coronavirus is changing for various countries. I selected only those countries which have a population in excess of 2 million, and which had already suffered a total of at least 500 deaths per…
Our World in Data have a comprehensive Coronavirus Pandemic downloadable dataset available in Excel, CSV, and JSON formats. I read the Our World in Data have a comprehensive downloadable Coronavirus Pandemic dataset available in Excel, CSV, and JSON formats. I imported the CSV datafile directly from the web into Power BI, pre-processed the data a…
Pictured below is a chart to show the numbers of positive Covid-19 tests and deaths attributed to Covid-19 in Jordan between the dates of 1st Sept 2020 to 17th March 2021.(Data sourced from the Our World in Data Covid-19 Dataset: https://ourworldindata.org/coronavirus-source-data, and processed with Excel.) Click on the image to view in full resolution. The…
Below is a table to show how Covid-19 is affecting various countries – those which have suffered >200 deaths in the last 7 days (as of 14th March 2021). Some countries were not included in this dataset from https://ourworldindata.org/coronavirus-source-data including major nations such as USA, and countries suffering at the moment such as Czechia. Looking…
Looking at the data from Johns Hopkins (https://data.humdata.org/) to see how various countries are doing at the moment with regards to their respective fights against the Coronavirus pandemic. The chart below shows the percentage increase in deaths due to Covid-19 for last week compared to the reports from the week before for countries with >500…
Looking at the Covid-19 data for Brazil today (4th March 2021) – sourced from https://ourworldindata.org/coronavirus-source-data – daily reported cases are heading upwards exponentially. ….and daily deaths heading the same way.