293 - Covid-19   charts

The chart to the right below (Worldometers again) shows cases/population, which as much as anything else demonstrates the counting problems. China, nearing the end of the outbreak, has stabilised at 57 cases per million, while Italy is over 400 (past 500 on 17th, then 600 and past 1000 on the 23rd, 1700 at the end of the month).  I copy the top of the table here. I simply don't believe the figures for some countries lower down the table. I repeat, this issue has a counting problem. If you go to the linked external page, the columns are sortable and doing that to the rightmost column moves many small countries to the top of the list, then Italy, Switzerland, Spain Norway, Austria, Germany, Belgium, Iran; all of these 250-1000 cases per million of population. On 23rd (data for 22nd), USA has risen to 106 and the UK 84. I've put a second derivative graph lower down this page to illustrate this better. All graphs have been updated daily from the 17th.

Here's a complicated chart I made, based on the data published by Wikipedia up to 14th March and then extended using the data found at Worldometers. I've not looked at counting cases, but at the growth of cases, so that the curves are expected to return to the x-axis, as the Chinese one does, though I removed it at the end of March. I've added a polynomial trendline for each dataset at the higher index levels Excel allows (5 or 6; index 6 sometimes finds a good reason to turn downwards). Trendlines are strongly affected by the delay from the first recorded case in-country to a significant expansion in case numbers. 

It is interesting to see the effects of intervention. It is interesting how that intervention can be done; the differences in law and culture and things like trust and co-operation are themselves interesting factors affecting the spread of disease. Yet again, what is known is confused by what is only partially understood and contaminated with the downright wrong.

There are significant changes each day and the changes in trendlines are themselves evidence of how risky it is to graph results beyond the data. But we want foreknowledge, so we must do this. I mess with these and choose what I think makes the most sense at the time. ¹

Below I've displayed a selection of countries in Europe plus the USA, but still looking at new cases, not at case counts. This may yet show the effects of different approaches to action. I have not necessarily used the same index on the predictions; Spain may be turning the corner (16th, 17th) but equally there may be a change in the way counting is done. The table at the top provides a better measure in the last column. It is significant that for any state nation, action has a significant delay of perhaps a week before the figures reflect any effect.


Here's a graph, started on 22nd March, using data up to a day earlier. This looks at the second differential, the acceleration of the curve. I've added trendlines of index 3. This shows that, today, 5th April, Italy, Germany and Spain are close to peak, while France and UK have get to reach that. The trendlines at index 4 all curl downwards, but (of course) for the USA.


DJS 20200324



Related pages:

Essay 291 - Effects of an outbreak  what it says, effects, but some description of what we have (and not)

Coronavirus (Y10+)  modelling problems

Epidemics    more general theory

Infectious disease  looking at the 2020 problem, particularly effects of the reproduction number changing.

1 31Mar, a method to show changing trendlines dreamt up and placed at the foot of this page. The idea being to show the effect of each new data point on the trendlines; they wave around like live things, emphasising how prediction is a dangerous thing on which to build assumption. Building national capacity to cope with the possible is sufficient understanding, I think. 


Here's a new graph made from an early model of mine. This reflects whatever numbers I'd set at the time, but if you look at the leftmost blue line, the one with the odd kink in it, and think of that as the toll if the spread is unchecked (close to 100% of possible), you get the general idea, which is all I was trying to display. None of this takes into account the increased deaths from having the medical services stretched past the breaking point; this is the very simplest modelling, the sort of thing I'd attempt (would have attempted) with a Y8 class.

23rd March 2020: Comment on the BBC that the UK is three weeks behind Italy. I checked this out and in terms of cases recorded the gap is close to 14 days. I changed my spreadsheet to allow me to shift a dataset by several days. The two case-count curves for UK and Italy are very much the same, 14 days different. Looking at deaths, the figures push the UK curve well below that of Italy, at the point well before the Italian health system was swamped with numbers.  Note that Italy has more older folk than most countries, so we might expect mortality to be higher, especially once swamping occurs. The UK too has a large proportion of the aged, which is one reason why so much effort is going into trying to 'flatten the curve'. A cubic (23rdMar) fits the Italian death rate very well, second differential a bit over 2.5, while the equivalent UK number is 0.57. Of course, the delay in reaction to any national change—and here too it is the actual reaction, not the change in instructions—causes concern at all levels of governance. Again, it is bad practice to extend beyond the data set (i.e., into the future), but that is what we require with immediate time-sensitive data.

Having said all that, the yellow curve has been moving upwards, 25-29 March, as I renew the graph, so something is not working as it was expected to. As I wrote above earlier today, I think we're due some tightening of the screws on Monday. The yellow line has been moving towards the grey one, below, as the last few days have passed. On 5th April for the first time the predicted curves cross; Italy is perhaps at peak and the restrictions in Britain are not yet showing any significant bite into the case count. Others are latching on to the issues of counting, at last.


The graphs here compare recorded cases and deaths, with a shift of 14 days to make them overlap somewhat. They are much more similar than they were earlier.


The lockdown required from 23rd March is no doubt influenced by the demonstrable failure in London for people to follow the instructions. Perhaps a reduced tube service caused higher numbers per train, but several video clips of a tube train crowded much as usual (pre-virus) were, I suspect, the trigger to move the goalposts again. As of Monday evening, too, the boss (her indoors) is permitted to work from home; while delighted to be labelled a key worker (she teaches secondary), the rooms on offer at school yesterday were all cold and the little teaching that occurred was affected by this. That said, the boarding staff are having a hard time, helped only partially by so many leaving the premises. I wondered immediately what additional value an independent school offers to this teaching model; I suspect that the difference is not enough to justify the money. If this goes long-term....

Mar 26th  India is beginning to report and I expect this to become well out of hand, perhaps to the point where the numbers simply are not available. [But, read this, from 02APR]   Italy is in heavy lockdown but the numbers have got out of hand, so there is a sense in which they need to reduce the reproduction number to below 1. I think the Italian care system is already overloaded.  Mar25th Infectious disease written, to be further developed.

29th March: It looks to me as though Germany now has a grip and is making progress at peaking. The USA has no grip at all, the UK may want to squeeze harder soon and, relatively, the French should be worried all over again. Spain, on the other hand, has a lower gradient, as if measures are working, at last.

The UK reports that of those moved to intensive care, we're losing a whole half. What we do not know is what proportion of all infected that is; it may be lower than 1 in a thousand. If we use 'hospitalised' as a measure of illness, then we want to know how that compares with death and with 'infected'. Soon, we'll want to know numbers for 'immune', however temporary that immunity may prove to be. Worldwide (28th Mar figures) 4.6% of recognised cases have died. New deaths are about 10% of the current critical cases. The variability across nations is high and we will eventually learn something about those care systems — but only if the counting methods are equivalent. Bad data cannot give good results. I think eventually we will only learn reliably what effects the various interventions had within a country, as the ability to compare different nations is compromised by the differences in reporting, even within something relatively homogeneous, like Europe.                                          DJS 20200329


30th March: the 2nd derivative graph implies that all but the UK and USA can see when peak may occur; even Spain's 2nd derivative has peaked (4th derivative now negative), implying that the acceleration will lessen, that things are going to get worse, but not by as much as previous. Small comfort, I think. The US is in for a severe shock. For the first time the press heard 'six months' instead of three months, though the information was given to them weeks ago; they persist in treating the population as complete idiots, even when they think they are explaining what we need to understand.  China, who came out from the explosion weeks ago is beginning to relax, but one might note how little they have allowed business to restart (and the press should have been commenting, but has not, or not where I have seen comment). The 'new cases' graph suggests that Germany, Spain, Iran and Italy have peaked, and the US, the UK and France are among those that have not. Yesterday, we began to have sensible predictions of total deaths per nation. For example, Trump rescinded previous statements (he does that so easily) and, having heard at last that 200 thousand deaths was quite likely, put in place restrictions and suggested that half as many deaths would be good going. In Britain, we're looking at 20 thousand severe cases and maybe half of those dying, but that figure is mine, not matched by published predictions seen by me. It is quite difficult to separate capacity from prediction, which is somewhat silly as they ought to be very obviously different. I ought to spend longer on the modelling.                                                                                                                     DJS 20200330


1st April:  a report in the Guardian says that China has been looking at their asymptomatic cases, producing a suggestion that there were 40,000 asymptomatic cases to add to their 80,000 counted. This does not tally with the US CDC comment that about one case in four has no symptoms, so there is more to be discovered. New Chinese comment says about 60% of those (recognised as) having caught the virus had no symptoms. Further, that a symptomatic carrier infected 6.3% of close contacts, while an asymptomatic carrier infected 4.4%. The issues I expected to see yesterday, about freeing up the movement restrictions in China, were found this morning. Meanwhile, migrants are returning from Iran to Afghanistan, of course moving the virus in volume. I noticed last night that we were shown tv clips from around the world (and London is not in England in this regard) demonstrating a lack of understanding of what two metres is and how to measure it— or that this is a regulation simply ignored as yet. Local to home, the understanding is either well understood or simply ignored. That, or there are very many more gentlemen sharing the same roof than I thought, many of whom wear hi-vis jackets at work. I wonder how a house of multiple occupation (HMO) acts—as one household, or many?

Here's a graph, new on 01April, showing the variability of prediction. Next update on this, 10April.





4th April: The apparent leap in the French figures is because of a problem that all reporting has. In this case, the deaths from nursing homes (i.e., not hospital) were delayed (not included until someone noticed). So the French numbers may well have correction, by which I mean that this jump might well be spread backwards as the date of death is correctly attributed.   That jump moves the French trendline to nowhere helpful, but upwards.

No doubt this applies to other nations too. I saw comment this morning that the same applies to the British data; delivery of information is not uniform in terms of timeliness. Also commented is that death is pretty definite, unlike whether or not someone has had the disease. That doesn't recognise that what the death is attributed to is itself part of the problem. For example did someone die because of Covid-19 or simply with it?  I remember wife No1 commenting on her work with old records, that it was quite apparent that on occasion the 'reason for death' given was a matter of expedience, that 'don't know' or 'haven't time' were unacceptable, so whatever was currently being blamed was the choice that no-one would argue with.

Trending downwards:  Italy, perhaps Spain and Germany.  Trending upwards: US, UK and France. Iran,too.  Today the US is found to have been throwing its weight around so as to have more 'protection', something that will come back to bite them later in the year. Britain seems to be on the losing end of such tussles and I predict we will move the manufacturing ability to be within these shores, as we are showing can be done, by redirecting some of the relatively small but very inventive manufacturers. So, while there is a shortage of the materials for the sort of testing we'd like to do, and a shortage of protective equipment, we have the technology with which to make such stuff, once the message has gone out. I think we will have some sensible legislation that allows us to move to such a footing more easily in the future — what I think has happened, is that those in need have commissioned material to be made; the necessity of invention, coupled with the available capacity, from businesses being deprived of their 'normal' work. So because of need we have businesses such as clothing manufacture becoming key.

5th/6th April There is a weekend effect reflected in the reporting. So the US shows relatively fewer new cases, which moves their second difference trendline downwards. Britain needs to show some tempering of the upward trend. All the idiots who think the restrictions apply only to other people only add restrictions to those who are already observing them. I wish there was a comeuppance available. Yesterday the PM was admitted to hospital, not getting noticeably better. If Raab has to stand in (confirmed late on the 6th, as BoJo is moved to ICU).

8/9th April I am bothered by the French figures, which do not show a tendency to peak, though thte second difference curve looks far better. I am bothered how similar the UK cases and deaths are to the Italian curve; I had hoped our figures would remain consistently below as a week ago (end of March) suggested. The second difference curve suggests that the UK is not yet improveming, while the case count graph says that France and the US have real problems as yet. Germany seems to have peaked, Iran possibly so too. I noticed that petrol pump prices have dropped a lot, but one has so little use for fuel at the moment. Social distancing is seen to be observed in Blackpool, but, as one of my neighbours remarked, the pond life is absent. In my pond that is also true.










Email: David@Scoins.net      © David Scoins 2018