April, 17th 2020 – Reading time: 8 minutes
The CoE Analytics & Sensorics analyses on a regular base available COVID-19 data to give insights into possibilities and constraints of Data Analysis
Established as Think-Tank for statistics and data analysis, the CoE AS normally enables companies to understand themselves better by analyzing their data (process, metrology, manufacturing…) to extract hidden information and parameters.
With this project we want to share our daily analysis about the actual COVID-19 outbreak and about impacts of these statistics. Everyone shall have the opportunity to understand how decisions in politics, society and in our daily life may have an impact and why data can be interpreted in such different ways from different stakeholders.
Any additional comments, adds and corrections are gratefully received.
COVID-19 Key Facts
- Current doubling time: 16.969±1.243 days
- After March 29th the doubling time has increased again, which is a strong indicator for the success of government actions as we could confirm
- Parameters can be extracted from the data, which can be used to calculate models predicting the future behavior
- The basic reproduction rate currently is R0 ≈ 0.80, i.e. an infectious person infects less than one additional person: the number of infectious persons is currently decreasing
Model parameters from past data
To predict the future, we will use standard models. However, they rely on measured data obtained from the actual pandemic. The most relevant parameter used for the model is the infection rate, which is β = ln(2)/τ2, i.e. it is directly connected to the doubling time.
Figures 1 and 2 show logarithmic visualisations of the daily reported and the accumulated COVID-19 cases displayed versus the reporting date. Figure 1 shows the reported COVID-19 cases and deaths against the reporting date. From the March 19th onwards, it can be seen that the growth of newly reported cases decreases, which repeats after March 29th, which is a clear indicator for the success of the contact prohibition as we already mentioned in another article.
Extracting the doubling time
Figure 2 shows the accumulated cases against their respective reporting dates. Here, too, a bending of the curve can be seen from March 19th and again from March 29th onwards.This also coincides with the three fitted exponential curves (note again the logarithmic scale, figure 3 presents the same graph using linear scale), which intersect each other on March 19th and March 28th. The doubling time has increased to τ2 = 16.969 days (β = 0.041 days-1) at the transition from the grey to the green curve, which means that it takes nearly 17 days for the number of reported infections to double, which is far more than the target doubling time. This time is required from the government and the Robert Koch Institute and shall be about 13-14 days. For the reasons see the model calculations below.
Extracting parameters from data
Parameters are important quantities from mathematical models and can influence the behavior of models significantly. Parameters of linear models are quite easy to obtain by applying a linear regression, however most models are not linear. To find the best fitting parameters for those models, applying a non-linear least-squares fitting method will yield the requested values. An important algorithm for least-squares fitting is Levenberg-Marquardt.
Predicting the future
It should actually be obvious that it is not possible to predict the future of a pandemic because it is a far too complex system that depends on too many influencing variables. Among other things, government, the existing health care system, general hygienic conditions and wealth have a great influence on the spread of an infection. In order to make statements about the behaviour of a system in the future, it is necessary to simplify it to such an extent that the number of influencing factors remains controllable. Models are used for this purpose.
Various models are used in epidemiology, including the very simple SI model (susceptible-infected model) , the somewhat more advanced SIR model (susceptible-infected-removed model)  and the SEIR (susceptible-exposed-infected-removed model) , from which we have picked the latter two for the model calculations here. Both models are strong simplifications of reality, but can still give orientation in dealing with COVID-19.
The SIR model
The SIR takes into account the persons removed from the system (by immunity or death). In figure 4 the model with the three doubling times from figure 2 was calculated. You can see the susceptible (grey), infected (blue) and already immune persons (green) for the three scenarios. Note that the current doubling time is already higher than the target, so the third and thickest curves are already fairly flat and difficult to see.Interesting results of this model are that for each scenario there is a maximum in the curve of infected persons. In addition, this model shows how high the target immunity of the society (in this idealized case) will be. For example, if the disease spreads rapidly, an immunity of almost 100% is achieved, whereas at the current rate of spread we can probably expect an immunity of less than 1% of the population. As a consequence, the current situation will most likely repeat itself with a new wave of COVID-19, if no vaccine is available by then. Flattening the infection curve therefore has its price: we gain time for research but have to live longer with the current restrictions. If we look at the current doubling time of about 15 days, we can expect the maximum number of infectious of about 55,000 patients today.
The basic reproduction number as indicator for the spread
With the quotient R0 = β / γ, where γ is the recovery rate of the disease, which we assume to 1/20 days-1, the SIR model provides an additional important quantity, the so-called basic reproduction rate. This figure indicates the average number of people infected by an infected person. With the current data it is approximately 0.80, so one infected person infects 0.80 more people. In order to prevent the spread of the epidemic, the basic reproduction rate must be kept below 1 constantly, i.e. less than one additional person is infected per infected person, and the epidemic thus comes to a standstill over time. Calculating the doubling time for a basic reproduction number of 1 (linear spread) gives ln(2) / (1 × γ) ≈ 13-14 days.
If the value 0.99 is used for the basic reproduction rate in the model equations, the dashed lines in figure 5 are obtained. As can be guessed, neither the infections nor the removed (immune) persons increase. If the numerical values are examined, a similar picture emerges here: the number of infections decreases over time (albeit very slowly), while the immunities slowly increase. After 600 days 31,000 infected persons and 140,000 immune persons remain.The SEIR model considers the delay in infectiousness
The SEIR model takes into account the case where an infected individual is not immediately infectious and thus, despite being infected, cannot immediately infect other people. It is therefore closer to reality than the SIR model. Using the calculated parameters in this model, one obtains the graph of figure 5 with the susceptible (grey), the exposed (red), the infectious (blue) and the remote (green) persons. This model shows a very similar course to the SIR model. The central difference is the progression of the infectious persons, which in this model are automatically flattened out somewhat by considering the temporal shift. Another difference between these models is that the planned infestation (see the dashed lines) of the society is marginally higher. In this case, after 600 days about 8,000 exposed, 46,000 infectious and 224,000 immune persons remain. Using the current numbers, we may expect the maximum number of 89,200 infectious persons in about 12 days, however, this estimation is strongly dependent on the (unknown therefore guessed) number of exposed people.
Models can fail
Models are based on simplifications and idealizations. No computer has the computing capacity to calculate a real system. Of course, it is also just as impossible to capture all influencing variables at a certain point in time. Therefore, a model also describes an idealized system which, in the best case, approximates reality. Nevertheless, deviations and completely different outcomes are possible in such complex systems as pandemics (a good example of such unexpected behaviors is weather forecasting). In order to stay as close as possible to reality, models must be repeatedly calculated with updated parameters (weather models are calculated several times a day). And last but not least, a model is only as good as the previously determined parameters. If the data source is insufficient, even the best model cannot provide a good forecast. See also our analysis of data sources in another article.
Deriving the growth rate
The growth rate of COVID-19 can be described by the basic reproduction rate. This rate contains the information about how many more people are infected by an infectious person on average. With a number greater than 1, the growth is exponential, with 1 it is linear, and with less than 1 the growth is inverse-exponential, i.e. exponentially decreasing.
Example of a wave of 15 generations of infected persons (15 infection cycles):
- R0 = 1.5: 1.515 ≈ 438 (times the number of initial infections)
- R0 = 1: 115 = 1 (times the number of initial infections)
- R0 = 0.5: 0.515 ≈ 0.000031 (times the number of initial infections)
How can we accelerate your development?
Center of Excellence Analytics & Sensorics
- Core Competences
- Modelling & Simulation
- Measurement & Sensoric
- Statistics & Data Analysis
- Predictive Maintenance
The presented analysis is based upon the data provided by the Robert Koch Institute. This data is updated daily (see status). The statements, which we derived today, may already be invalidated through new data provided tomorrow. We try to keep this analysis as up-to-date as possible.
Because not every health department updates their data during the weekends, data updates provided by the Robert Koch Institute on Sun- and Monday cannot be trusted and will be ignored for our analysis. The next update will be performed on Tuesday.
- Doubling time: 16.969±1.243 days
- Doubling time: 15.211±0.915 days
- Doubling time: 11.529±0.93 days
- Added target COVID-19 behavior to the model calculations
- Doubling time: 10.622±0.902 days
- Added model calculations to predict the future behavior of the pandemic
- Doubling time: 9.692±0.586 days
- Exponential growth decreased again after March 29th
- Success of the contact prohibition could be confirmed
- Doubling time: 7.213±0.346 days
- Highlighted the COVID-19 key facts
- Doubling time: 6.939±0.345 days
- Doubling time: 6.623±0.417 days
- Added estimated number of recoveries based upon WHO estimation
- Doubling time: 6.231±0.274 days
- Added population and population density of the German federal states
- Added incidences and case densities of the German federal states
- Added an initial analysis on the spread in the federal states
- Doubling time: 5.849±0.172 days
- Added major government actions
- Last two days are now ignored for fit, because their data is quite incomplete
- Added initial analysis about government actions
- Doubling time: 6.182 days
- Initial version
- WHO. Report of the WHO-China Joint Mission on Coronavirus Disease 2019 (COVID-19). Report. World Health Organization (WHO); 2020 16-24.02.2020.
- RKI. COVID-19 Dashboard. Robert Koch Institute; 2020
- RKI. SARS-CoV2-Steckbrief. Robert Koch Institute; 2020
- Finn Bauer et al. CovidCountries. 2020. Data source for government actions
- RKI. COVID-19 data set. NPGEO Corona; 2020. Main data source
- RKI. Federal state data set. NPGEO Corona; 2020
- Tagesschau.de. Interview with Martin Eichner. Tagesschau.de; 2020
- BR. Recherche zum Casus Ischgl. Tagesschau.de; 2020
- Martin Eichner et al. COVIDsim. 2020
- DIVI. Momentane Auslastung der Intensivbetten in Deutschland. Deutsche Interdisziplinäre Vereinigung für Intensiv- und Notfallmedizin; 2020
- Wikipedia. SI-Modell. Wikipedia; 2020
- Wikipedia. SIR-Modell. Wikipedia; 2020
- Wikipedia. SEIR-Modell. Wikipedia; 2020
Reference: Robert Koch-Institut (RKI), dl-de/by-2-0
The data are the „Case Figures in Germany“ of the Robert Koch Institute (RKI) and are available under the Open Data Data License Germany – Attribution – Version 2.0.