The COVID-Schulen Dashboard

Table of Contents

Data source
Data
How to render
Used Packages
Deployment and reproducibly

Introduction

This Covid19 Schulen dashboard provides an overview of reported infection of SARS-CoV-2 infections in German school. The dashboard is built with R.

Data source

The data source is the documentation of the German Kultusministerium, which is weekly updated. The data is scrapped with this function.

Data

The raw data are excel files, containing information about infected pupils, infected teacher and quarantie on state (Bundesland) level.

How to render

step 1

• run kmk_cleaning.R
• creating rds (data) file in the data_clean folder "_clean_kpi_bl.rds"

step 2

• run leaflet_bl.R
• generates the most recent data (calendar week) in data_clean folder "_kmkdata_bl.rds"
• generates leaflet in "leaflet_maps/recent_maps_bl.RData"

step 3

• run gen_verlauf.R
• generates the large facet map with trend ind "leaflet_maps/gall_bl.RData"

step 4

• run leaflet_quara.RData
• generates quartine leaflet graphs in "leaflet_maps/recent_maps_bl_quara.RData"

step 5

• run run_county_render.R
  -> generates the tables in tab "tabellen-bundesländer"

step 6

• run forecast.R
• put all new files (stundent|teacher|kmk_data.csv) in the "data_clean" folder
• generates ggplot forecasts "leaflet_maps/forecast.RData"

step 7

• knit index.Rmd
• hint: chunck test - crtl+f -> replace eval=TRUE with eval=FALSE

Used Packages

• Visualisation:

  • ggplot2
  • leaflet
  • DT
  • flexdashboard

• Data wrangling:

  • purrr
  • dplyr
  • stringr
  • tidyr
  • lubridate
  • broom
  • forcats

• Data scrapping & data import:

  • rvest
  • readr
  • readxl

• Helper:

  • leaflet.extras
  • leafpop
  • htmltools
  • htmlwidgets

Deployment and reproducibly

The dashboard is deployed via Github actions/Github pages.

For any question or feedback, you can either open an issue or look in the imprint/impressum of the dashboard for more contacts.