17th April

Github link to Python 2.7 code, data and analysis.

All data provided by Ministerio de Sanidad, Gobierno de España

For analysis obtained using data for previous days follow this link

Analysis and projections of COVID-19 data in Spain using data available up to April 17th.

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

Estimated mortality

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)