{"id":17179,"date":"2020-09-09T11:50:00","date_gmt":"2020-09-09T11:50:00","guid":{"rendered":"http:\/\/www.wjst.de\/blog\/?p=17179"},"modified":"2020-09-11T06:38:08","modified_gmt":"2020-09-11T06:38:08","slug":"corona-spillover-risk","status":"publish","type":"post","link":"https:\/\/www.wjst.de\/blog\/sciencesurf\/2020\/09\/corona-spillover-risk\/","title":{"rendered":"Corona Spillover Risk"},"content":{"rendered":"<p>In Antwort auf einen <a href=\"https:\/\/twitter.com\/vincentglad\/status\/1303243869933404161\">Tweet von Vincent Glad<\/a>, der das \u00dcberschwappen der Infektion von der j\u00fcngeren\/mittleren auf die \u00e4ltere Altersgruppe in Marseille zeigt<\/p>\n<p><a href=\"https:\/\/twitter.com\/vincentglad\/status\/1303243869933404161\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-17182 size-full alignnone\" src=\"https:\/\/www.wjst.de\/blog\/wp-content\/uploads\/2020\/09\/Bildschirmfoto-2020-09-09-um-13.38.54.jpg\" alt=\"\" width=\"616\" height=\"491\" \/><\/a><\/p>\n<p>dto <a href=\"https:\/\/twitter.com\/paulg\/status\/1303969347577282567\">aus Spanien<\/a><a href=\"https:\/\/twitter.com\/paulg\/status\/1303969347577282567\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-17196 size-large alignleft\" src=\"https:\/\/www.wjst.de\/blog\/wp-content\/uploads\/2020\/09\/Bildschirmfoto-2020-09-10-um-16.23.26-523x500.jpg\" alt=\"\" width=\"523\" height=\"500\" srcset=\"https:\/\/www.wjst.de\/blog\/wp-content\/uploads\/2020\/09\/Bildschirmfoto-2020-09-10-um-16.23.26-523x500.jpg 523w, https:\/\/www.wjst.de\/blog\/wp-content\/uploads\/2020\/09\/Bildschirmfoto-2020-09-10-um-16.23.26.jpg 595w\" sizes=\"auto, (max-width: 523px) 100vw, 523px\" \/><\/a>hier nun eine Analyse des aktuellen RKI Datensatzes.<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\r\n# Daten von https:\/\/opendata.arcgis.com\/datasets\/dd4580c810204019a7b8eb3e0b329dd6_0.csv\r\nrki %&gt;%\r\n  select(Landkreis,Bundesland,dt,Altersgruppe,AnzahlFall) %&gt;%\r\n  mutate(Altersgruppe = str_replace_all(Altersgruppe, &quot;A&quot;,&quot;&quot;) ) %&gt;%\r\n  mutate(Bundesland = str_replace(Bundesland, &quot;-(.).*&quot;,&quot;-\\\\1&quot;) ) %&gt;%\r\n  mutate(Landkreis = str_replace(Landkreis, &quot;-(.).*&quot;,&quot;-\\\\1&quot;) ) %&gt;%\r\n  filter(dt &gt;= as.Date('2020-9-1') ) %&gt;%\r\n  filter(AnzahlFall &gt;= 0 &amp; Altersgruppe != &quot;unbekannt&quot;) %&gt;%\r\n  group_by(Landkreis,Altersgruppe) %&gt;%\r\n  summarise_at(c(&quot;AnzahlFall&quot;), sum, na.rm = TRUE) %&gt;%\r\n  filter(AnzahlFall&gt;20) %&gt;%\r\n  ggplot( aes(x=Landkreis, y=Altersgruppe, fill= AnzahlFall)) + \r\n    geom_rect(aes(xmin=-Inf, xmax=Inf, ymin=-Inf, ymax=Inf), fill=&quot;darkgreen&quot;) +\r\n    geom_tile() +\r\n    geom_text(aes(label = AnzahlFall), colour=&quot;white&quot;) +\r\n    scale_fill_gradientn(colours = c(&quot;darkgreen&quot;, &quot;yellow&quot;,&quot;red&quot;), n.breaks=8, name=&quot;x&quot; ) +\r\n    guides(fill=guide_legend(title=&quot;Corona+\\nletzte 7 Tage\\nRKI opendata\\nStand 9.9.2020&quot;), reverse=TRUE)\r\n<\/pre>\n<p>Auch hier besteht die Gefahr v.a. in Bayern, NRW und Baden-W\u00fcrttemberg.<\/p>\n<figure id=\"attachment_17190\" aria-describedby=\"caption-attachment-17190\" style=\"width: 667px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-17190 size-large\" src=\"https:\/\/www.wjst.de\/blog\/wp-content\/uploads\/2020\/09\/Rplot-667x500.png\" alt=\"\" width=\"667\" height=\"500\" srcset=\"https:\/\/www.wjst.de\/blog\/wp-content\/uploads\/2020\/09\/Rplot-667x500.png 667w, https:\/\/www.wjst.de\/blog\/wp-content\/uploads\/2020\/09\/Rplot-620x465.png 620w, https:\/\/www.wjst.de\/blog\/wp-content\/uploads\/2020\/09\/Rplot-768x576.png 768w, https:\/\/www.wjst.de\/blog\/wp-content\/uploads\/2020\/09\/Rplot.png 1200w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><figcaption id=\"caption-attachment-17190\" class=\"wp-caption-text\">RKI Daten Stand 9.9.2020<\/figcaption><\/figure>\n<p>In St\u00e4dten ist die Situation in M\u00fcnchen am kritischsten \u00fcber die vielen F\u00e4lle diese Woche.<\/p>\n<figure id=\"attachment_17191\" aria-describedby=\"caption-attachment-17191\" style=\"width: 667px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.wjst.de\/blog\/wp-content\/uploads\/2020\/09\/Rplot02.png\" data-rel=\"key-image-0\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-17191 size-large\" src=\"https:\/\/www.wjst.de\/blog\/wp-content\/uploads\/2020\/09\/Rplot-1-667x500.png\" alt=\"\" width=\"667\" height=\"500\" srcset=\"https:\/\/www.wjst.de\/blog\/wp-content\/uploads\/2020\/09\/Rplot-1-667x500.png 667w, https:\/\/www.wjst.de\/blog\/wp-content\/uploads\/2020\/09\/Rplot-1-620x465.png 620w, https:\/\/www.wjst.de\/blog\/wp-content\/uploads\/2020\/09\/Rplot-1-768x576.png 768w, https:\/\/www.wjst.de\/blog\/wp-content\/uploads\/2020\/09\/Rplot-1.png 1200w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/a><figcaption id=\"caption-attachment-17191\" class=\"wp-caption-text\">RKI Daten Stand 9.9.2020<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<div class=\"bottom-note\">\n  <span class=\"mod1\">CC-BY-NC Science Surf , accessed 26.04.2026<\/span>\n <\/div>","protected":false},"excerpt":{"rendered":"<p>In Antwort auf einen Tweet von Vincent Glad, der das \u00dcberschwappen der Infektion von der j\u00fcngeren\/mittleren auf die \u00e4ltere Altersgruppe in Marseille zeigt dto aus Spanienhier nun eine Analyse des aktuellen RKI Datensatzes. # Daten von https:\/\/opendata.arcgis.com\/datasets\/dd4580c810204019a7b8eb3e0b329dd6_0.csv rki %&gt;% select(Landkreis,Bundesland,dt,Altersgruppe,AnzahlFall) %&gt;% mutate(Altersgruppe = str_replace_all(Altersgruppe, &quot;A&quot;,&quot;&quot;) ) %&gt;% mutate(Bundesland = str_replace(Bundesland, &quot;-(.).*&quot;,&quot;-\\\\1&quot;) ) %&gt;% mutate(Landkreis = &hellip; <a href=\"https:\/\/www.wjst.de\/blog\/sciencesurf\/2020\/09\/corona-spillover-risk\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Corona Spillover Risk<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3102],"tags":[3390],"class_list":["post-17179","post","type-post","status-publish","format-standard","hentry","category-one-world","tag-corona"],"_links":{"self":[{"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/posts\/17179","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/comments?post=17179"}],"version-history":[{"count":10,"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/posts\/17179\/revisions"}],"predecessor-version":[{"id":17205,"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/posts\/17179\/revisions\/17205"}],"wp:attachment":[{"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/media?parent=17179"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/categories?post=17179"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wjst.de\/blog\/wp-json\/wp\/v2\/tags?post=17179"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}