Covid-19 (Update)

Covid-19 Statistics for Germany

Posted by Daniel Schmidtke on Sunday, February 19, 2023

About this blog post

This post provides some basic visualizations of recent Covid-19 data (cumulative cases and day-to day changes in these number by state) from Germany. I am well aware of the fact that there are plenty of such visualizations all across the internet. Since I am quite new to blogging, my main motivation for writing this post was teaching myself how to include data from other repositories in R-Markdown documents for static and interactive visualizations using ggplot and Plotly. The topic was secondary, but still I will try to keep this blog up to date for those of you who came here for the Covid-19 data. A link to the .rmd file can be found at the bottom of this page for those of you interested in the R code, instead.

On mobile devices, use landscape mode for the interactive graphs to be displayed correctly.

Cumulative, verified cases of Covid-19 in Germany

Source: Center for Systems Science and Engineering (CSSE) at Johns Hopkins University (COVID-19 Data Repository).

Please note that there is an obvious error (as of February, the 14th, 2021) in the estimation of recovered cases in the original data from Johns Hopkins University for the 27th of January 2021. I “smoothed” the plot at this point by interpolating the number of recovered cases between the reported numbers from January 26th and January 28th, 2021. Non-cumulative, active cases were calculated as the difference between the cumulative active and the cumulative recovered and deceased curves. Also, in August 2021 Johns Hopkins University stopped listing the number of recovered cases for Germany, i.e. recovered and active cases are no longer depicted (from the 4th of August, 2021, onward).

Cumulative, verified cases by state

Source: Center for Systems Science and Engineering (CSSE) at Johns Hopkins University (COVID-19 Data Repository).

Please note that the graphs only present reported values. Occasionally, these values remain stable for two days, suggesting that no new cases occurred. This is, of course, highly unlikely given the current dynamics of the pandemic. My guess is that in these cases numbers were, for some reason (e.g. weekends), not reported on the second of two such days and added to the report of the subsequent day, which would also explain the high fluctuations in the day-to-day differences in reported cumulative cases of some states (e.g. Bavaria or North Rhine-Westphalia; see below).

Day-to-day difference in cumulative cases

Source: Center for Systems Science and Engineering (CSSE) at Johns Hopkins University (COVID-19 Data Repository).

Individual values were calculated as the difference of confirmed cases as reported by the CSSE on a given day to the reported cases of the preceding day. Blue lines represent LOESS regression lines.

R-Markdown

All graphs presented in this blog were created with up-to-date data at the time of page rendering using R-Markdown. If you would like to know how, you will find the .rmd file here.