Data Analyst
Below is a CSV file containing data on the number of positive Covid-19 tests reported in the UK per day since the start of the pandemic (downloaded from https://coronavirus.data.gov.uk/) The chart below uses this data to show the number of reported Covid cases only on Tuesdays throughout the pandemic. This required a lot of learning…
The chart above shows the percentage drop in detected Covid-19 cases comparing each day to the same day one week earlier, and covering the dates from 1st Nov 2020 to 21st Feb 2021. The trend shows that (even before the lifting of restrictions from lockdown #3), cases could start increasing again by mid-March 2021. [Raw…
Recently many politicians and other people have been claiming that Sweden’s death rate was unaffected by Coronavirus despite their controversial decision to keep restrictions looser than almost anywhere in the world while chasing herd immunity. Statistics Sweden (scb.se) have freely downloadable and comprehensive datasets on a wide range of national statistics. Included are data on…
Below is a chart to showing the percentage of positive Covid-19 tests in the UK each day for 1st October 2020 to 17th January 2021. The red trend line shows the 7 day rolling average test positivity rate. The first downward slope shows the effect of the second national lockdown, followed by a steep peak…
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 number of deaths likely to be suffered as a result by its population. This mean of this projection predicted single-digit deaths per day by 1st July 2020 after a peak of…
Tomorrow, 3rd August 2020, the USA will finally overtake the UK for the number of Covid-19 deaths they have suffered after their peak relative to before their peak. Both countries have suffered over 3x as many deaths since peaking than they did before peaking. The chart below shows how Italy, Spain, and France are now…
The chart below shows all of the countries in the world that have reported more than 1,000 Covid-19 deaths since the start of the pandemic. Using a 7-day rolling average for each country the maximum deaths in a day, the date it occurred, and yesterday’s figure are given. The daily percentage increase in the total…
My chart below shows the growth of total Covid-19 deaths in all USA states which have recorded >500 deaths so far during the pandemic until today, 11th July 2020. It is sorted on the percentage by which the the total recorded deaths has increased over the last 14 days. For each state the total deaths,…
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…