Covid dashboard

Covid “dashboard” I made over the winter. Data is sourced from the Dutch national corona dashboard.

In order to reflect the spatio-temporal effects of corona, the data consists of three categories per municipality. Namely, it consists of total cases, number of people hospitalized, and the total number of deceased due to corona at per publication date. I designed a metric which I dubbed “relative severity” which had the goal to:

1. Reflect the relative contribution to the source vectors at each time point;
2. Include a memory effect of the contribution over time;
3. Take into account the number of people living in that municipality.

For municipality $j$ the relative severity for source $s_i \in \{\textrm{total reported, hospitalized, deceased}\}$ at time $t$ was computed as

$$ R_j(s_{ij}^t) = \frac{1}{Z_j \sum_k R_k(s_i^t)}\sum_{\tau =0}^t s_{ij}^{\tau},$$

were $Z_j$ is the number of people living in municipality $j$, and $s_{ij}$ is one of the sources (total cases, hospitalized, deceased) in municipality $j$. The percentile of $R_j(s_i^t)$ at each time $t$ is then computed and plotted above.