Github link to Python 2.7 code, data and analysis.
All data provided by Ministerio de Sanidad, Gobierno de España
Table of projections of main indicators using data available since 23rd february and up to 5th April – 17th April (for proyections made earlier go to previous days).
– Casos totales: Estimated total cases at the end of the pandemic
– Pico de casos x dia: Estimated day when the number of new cases will get to the maximum value.
– Fallecimients totales: Estimated total number of deaths at the end of the pandemics
– Pico de fallecientos x dia: Estimated day when the number of deaths will get to the macimum value.
– Pico de altas x dia: Estimated day when the number of recovereds will get to the maximum value.
Predicted total numer of cases at the end of the pandemics shows a reduced but systematic incease from 143.000 – 149.000 cases predicted on 31st march () up to 189.000-210.000 cases predicted on April 17th. This continuos increase can be due to several resasons: i) the sigmoid can be not fitting well into the real problem, ii) there are more cases detected now than before (more tests, more means available, etc), iii) measures to content the spread of the disease are not working
The registered number of cases, according to the Spanish Health Ministry on April 15th was: 188.086
The estimated day with the maximum number of cases x day remained rather fixed and around 29 March -1st April
The projection is also rather stable for the total number of deaths expected at the end of the pandemics. This projection is arond 20.000 – 22.000 and it is stable since 29th March. Only on April 16th this increases up to 23.000. The registered number of deaths, according to the Spanish Health Ministry on April 17th was: 19.478
Also the peak of deaths x day remain constant since the estimation made with the data available at 29 March: this peak is expected in April 3rd. Only on April 11th, this day shifted to April 4th and then to April 5th.
The estimated day for the maximum cases (x day) cured also remained rather constant since 29th march and is expected for April 13th – 17th.
Finally the estimated day with the maximum number of active cases also remained rather constant and predictions have not changed significantly since the firs analysis performed on march 27th. This day is expected between the 4th and the 11th of April
OBTAINED RESULTS FOR THE COMPLETE SERIES OF DATA UP TO APRIL 17th
Registered cases of COVID-19 in Spain (17th April) fitting and future trend using a logistic function
From 14th April it is observed a marked incresea of the number of cases compared with the sgimoid estimations
Registered cases of COVID-19 in Spain (17th April) fitting and future trend using a logistic function and comparison with similar fitting but using the Gompertz sigmoid and the SIR model
Estimated total number at the end of the pandemic (Cmax) in Spain for the confirmed cases was: 174 (VS), 191 (SIR) and 221 (GS) -on April 11th-, and 178 (VS) , 193 (SIR), 217 (GS) on April 13th and 189 (VR), 218 (SIR), 216 (GS). So although Cmax estimation increased from 13th to 17th April for VS and SIR models, it slightly decreased for the GS model.
The same marked incresea of the number of cases, from 14th April, is observed comparing data with the the three different sigmoids analyzed. This can only be due to i) an increase of the number of cases registered due to an increase of the number of tests realized (no more infections taking place), ii) an incease of the number of registered cases due to an increase of the real cases (more infections taking pplace)
Registered deaths due to COVID-19 in Spain (17th April) fitting and future trend using a logistic function (allowed a delay of 5 to 10 days compared to the detected cases sigmoid)
Registered admissions in ICU due to COVID-19 in Spain (17th April) fitting and future trend using a logistic function (allowed a delay of -2 to 10 days compared to the detected cases sigmoid).
It is a strange feature that ICU admission sigmoid is placed a few days before the sigmoide obtained for the number of cases.
There is a significant drop of ICU cases on April 17th that must be due to an error in the data provided by the Spanish Health Ministry
Registered medical discharge due to COVID-19 in Spain (17th April) fitting and future trend using a logistic function (allowed a delay of 10 to 20 days compared to the detected cases sigmoid)
Estimated active cases vs days
An estimation of the mortality can be obtained by dividing the sigmoids of no. of deaths / no. cases. The use of the sigmoids and not the date permit to eliminate the propagation of errors and have a more clear view of the mortality rate. Results show a reduced variation (probably a constant time is not reached until an stationary state is achieved, around 10%). However, mortality rate observed is very high compared with data available from China, where a value of 4% were reported.
However, as it can be supposed that many cases where not diagnosed, this figure can be closer to the 14% mortality rate reported for cases that required hospital admission (Información científica y técnica sobre la enfermedad por coronavirus, COVID-19, del Centro de Coordinación y Alertas Sanitarias del Ministerio de Sanidad español, 4 de abril de 2020)