Data Analyst
Below I have put together a table showing the 20 highest reported daily deaths for the 50 countries who have reported the most deaths due to the Covid-19 pandemic. The table is sorted on the 10th deadliest day since many countries have reported on a single day backlogs of data from previous weeks – e.g.…
Below is a table to show the current rapid increase in positive Covid-19 tests throughout the states of the USA. The table gives the population of each state, the total positive Covid-19 tests it has so far seen, the percentage of its population which has been detected to be positive, what percentage of the overall…
The chart below shows when a selection of badly affected countries suffered their peak rates of Covid-19 infection. The data (from https://www.europeandataportal.eu/) has been processed to show for each country the highest reported day of positive cases, the date when that occurred, their trend of cases, and a heatmap to visualise the data. Yesterday, 19th June…
Pictured below is my Excel Covid-19 heatmap to show 7-day rolling average reported daily deaths for countries around the world. Also shown is the peak date, and the current death rate (percentage of total deaths suffered so far seen for a country in yesterday’s 7-day rolling average of its reported daily deaths). Countries at the…
I downloaded ten seasons of Premier League football results and betting odds data (Bet365) from https://datahub.io/sports-data/english-premier-league (2009-2019 inclusive in ten CSV files). After drawing some charts with the data just looking at the relationships between the betting odds and the results, one potential strategy that stood out was betting on matches to be drawn under certain circumstances…
The chart below shows what happened next for four countries after they reported their peak of Covid-19 deaths per day. The countries chosen are UK, Italy, Spain, and France. These countries all reached rolling 7 day average peaks of 800-950 deaths per day. Italy peaked first followed by Spain a week later, France another few…
The chart below shows where different countries are on their Covid-19 trajectory in terms of deaths suffered. It shows the country name, total Covid deaths reported since the start of the pandemic, the deaths reported on 10th June, what percentage of the total that daily number is, the date of their highest daily death report,…
On 1st April 2020, Institute for Health Metrics and Evaluation (IHME) released a model estimating the progression of Covid-19 within the USA and the total number of deaths likely to be suffered as a result by its population. The chart below shows how well this projection predicted what has actually happened in the USA. The USA did…
I have been paying particular attention to the success or otherwise of certain countries’ responses to the Coronavirus Pandemic. In particular, UK, France, Spain, Italy, and USA. Below is a table showing the 100 worst days in terms of reported Covid deaths from amongst those countries since the start of the pandemic. Click on the…
Here are summaries of the runs I completed during 2019. Click on the larger chart images to better see the details.