Data Analyst
On 20th April 2020, IHME published a model projecting the number of Covid-19 deaths in the UK. The lower boundary projected a total of 19,642, the mean projected 33,142, and the upper projected 67,161. (These figures were far below their model of 5th April which had projected total figures of 27,557, 66,314, and 15,030 respectively.)…
Below is a table to show the test positivity rate for the states of the USA as of 24th June 2020. The number of tests is given as a 7-day rolling average (to smooth out weekend reporting delays), and the percentage shown is the percentage of tests administered in each state which returned a positive…
Pictured below is a table showing the number of days it has taken a selection of badly affected countries to suffer their reported total number of Covid-19 deaths doubling – i.e. how many days is it since their total death count was half what it is today (25th June 2020). The countries at the top…
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,…