A | B | C | D | E | F | G | H | I | |
---|---|---|---|---|---|---|---|---|---|
1 | SARS-Cov2: tCFR & tMortality - Proxies (Germany) | ||||||||
2 | "proxies" = These numbers underestimate already infected as there is an "invisible" incubation period ( during which the number of KNOWN cases was DOUBLING in the beginning ) when ill person appears healthy. Plus future deads are not yet dead: Both rates (M and CFR) can only be calculated when the pandemic is over (thus t for temporary). Anyways, these are the best numbers we have. For now. In short: UNDER-ESTIMATED. | ||||||||
3 | THIS TABLE: @DrAndreasKruger 5/Apr/2020 no guarantees = might just be wrong. INPUT DATA: Risklayer-CEDIM SARS-CoV-2 Crowdsourcing Contributors through Risklayer GmbH & Center for Disaster Management & Risk Reduction Technology (CEDIM) at the Karlsruhe Institute of Technology (KIT). SEE: RiskLayer.com and RiskLayer-explorer.com and @RiskLayer on Twitter. | ||||||||
4 | Some simplistic statistics measures over all rows But careful: All this might just be WRONG, so do your own calculations. Moreover: probably there's missing data! | ||||||||
5 | count of zeroes | 16 | 33 | 14 | 0 | 16 | 0 | v03.4.7 | |
6 | sum | 9779 | 320 877 | 83,019,213 | RiskLayer updated their data between 12-Oct_00:00 and 15-Oct_09:50 | ||||
7 | min | 0 | 44 | #DIV/0! | 34,209 | 0.00 | 1 | ||
8 | max | 278 | 19 536 | #DIV/0! | 3,644,826 | 1917 | 401 | ||
9 | median | 13 | 540 | #DIV/0! | 154,201 | 82.2 | 201.0 | ||
10 | average per district, all districts treated equally | 24.39 | 872 | #DIV/0! | 207,030 | 126 | 200.7 | source table cloned on 15-Oct_12:30 | |
11 | average, but weighted with district population | 51.40 | 2377 | #DIV/0! | 493,603 | 117.8 | 207.9 | ||
12 | AGS | city / district / region (CLICK FOR DETAILS) | dead | infected cases | (unresolved / underestimated !) case fatality rate tCFR | Population | (unresolved / underestimated !) Mortality per 1 million tM_mio | tM_mio Rank | Bundesland |
13 | 9377 | Tirschenreuth | 139 | 1 269 | 11% | 72,504 | 1917 | 401 | Bayern |
14 | 9263 | Straubing | 48 | 511 | 9% | 47,794 | 1004 | 400 | Bayern |
15 | 9374 | Neustadt a.d. Waldnaab | 74 | #DIV/0! | 94,352 | 784 | 399 | Bayern | |
16 | 9187 | Rosenheim | 199 | #DIV/0! | 260,983 | 763 | 398 | Bayern | |
17 | 6437 | Odenwaldkreis | 63 | 519 | 12% | 96,798 | 651 | 397 | Hessen |
18 | 9479 | Wunsiedel i. Fichtelgebirge | 46 | 801 | 6% | 73,178 | 629 | 396 | Bayern |
19 | 9371 | Amberg-Sulzbach | 54 | 563 | 10% | 103,109 | 524 | 395 | Bayern |
20 | 9171 | Altötting | 57 | 761 | 7% | 111,210 | 513 | 394 | Bayern |
21 | 9189 | Traunstein | 88 | 1 525 | 6% | 177,089 | 497 | 393 | Bayern |
22 | 9573 | Fürth | 58 | 641 | 9% | 117,387 | 494 | 392 | Bayern |
23 | 16076 | Greiz | 48 | 719 | 7% | 98,159 | 489 | 391 | Thüringen |
24 | 9363 | Weiden i.d. OPf. | 20 | #DIV/0! | 42,520 | 470 | 390 | Bayern | |
25 | 16072 | Sonneberg | 24 | 326 | 7% | 56,196 | 427 | 389 | Thüringen |
26 | 5966 | Olpe | 57 | 904 | 6% | 134,775 | 423 | 388 | Nordrhein-Westfalen |
27 | 9277 | Rottal-Inn | 51 | 1 015 | 5% | 120,659 | 423 | 387 | Bayern |
28 | 8126 | Hohenlohekreis | 47 | 906 | 5% | 112,010 | 420 | 386 | Baden-Württemberg |
29 | 3103 | Wolfsburg | 52 | 476 | 11% | 124,151 | 419 | 385 | Niedersachsen |
30 | 8417 | Zollernalbkreis | 78 | 1 449 | 5% | 188,935 | 413 | 384 | Baden-Württemberg |
31 | 9663 | Würzburg | 52 | #DIV/0! | 127,880 | 407 | 383 | Bayern | |
32 | 9262 | Passau | 21 | 242 | 9% | 52,469 | 400 | 382 | Bayern |
33 | 5370 | Heinsberg | 97 | 2 270 | 4% | 254,322 | 381 | 381 | Nordrhein-Westfalen |
34 | 9163 | Rosenheim | 23 | #DIV/0! | 63,324 | 363 | 380 | Bayern | |
35 | 8311 | Freiburg im Breisgau | 81 | 1 418 | 6% | 230,241 | 352 | 379 | Baden-Württemberg |
36 | 10041 | Regionalverband Saarbrücken | 114 | 1 511 | 8% | 329,708 | 346 | 378 | Saarland |
37 | 9473 | Coburg | 30 | 458 | 7% | 86,906 | 345 | 377 | Bayern |
38 | 8211 | Baden-Baden | 19 | 272 | 7% | 55,123 | 345 | 376 | Baden-Württemberg |
39 | 9475 | Hof | 32 | 570 | 6% | 95,311 | 336 | 375 | Bayern |
40 | 8237 | Freudenstadt | 39 | 699 | 6% | 117,935 | 331 | 374 | Baden-Württemberg |
41 | 9662 | Schweinfurt | 17 | 307 | 6% | 54,032 | 315 | 373 | Bayern |
42 | 8415 | Reutlingen | 90 | 2 135 | 4% | 286,748 | 314 | 372 | Baden-Württemberg |
43 | 8135 | Heidenheim | 41 | #DIV/0! | 132,472 | 309 | 371 | Baden-Württemberg | |
44 | 8127 | Schwäbisch Hall | 60 | 1 471 | 4% | 195,861 | 306 | 370 | Baden-Württemberg |
45 | 9773 | Dillingen a.d. Donau | 29 | 419 | 7% | 96,021 | 302 | 369 | Bayern |
46 | 9563 | Fürth | 38 | 663 | 6% | 127,748 | 297 | 368 | Bayern |
47 | 8317 | Ortenaukreis | 127 | 1 880 | 7% | 429,479 | 296 | 367 | Baden-Württemberg |
48 | 8315 | Breisgau-Hochschwarzwald | 76 | 1 642 | 5% | 262,795 | 289 | 366 | Baden-Württemberg |
49 | 9278 | Straubing-Bogen | 29 | 653 | 4% | 100,649 | 288 | 365 | Bayern |
50 | 9777 | Ostallgäu | 40 | 755 | 5% | 140,316 | 285 | 364 | Bayern |
51 | 9161 | Ingolstadt | 39 | 892 | 4% | 136,981 | 285 | 363 | Bayern |
52 | 8336 | Lörrach | 65 | 955 | 7% | 228,639 | 284 | 362 | Baden-Württemberg |
53 | 9461 | Bamberg | 22 | 287 | 8% | 77,592 | 284 | 361 | Bayern |
54 | 8437 | Sigmaringen | 37 | 937 | 4% | 130,873 | 283 | 360 | Baden-Württemberg |
55 | 12054 | Potsdam | 50 | 823 | 6% | 178,089 | 281 | 359 | Brandenburg |
56 | 9273 | Kelheim | 34 | 705 | 5% | 122,258 | 278 | 358 | Bayern |
57 | 9184 | München | 96 | 2 323 | 4% | 348,871 | 275 | 357 | Bayern |
58 | 8316 | Emmendingen | 44 | 785 | 6% | 165,383 | 266 | 356 | Baden-Württemberg |
59 | 9577 | Weißenburg-Gunzenhausen | 25 | #DIV/0! | 94,393 | 265 | 355 | Bayern | |
60 | 9574 | Nürnberger Land | 45 | 852 | 5% | 170,365 | 264 | 354 | Bayern |
61 | 8116 | Esslingen | 141 | 3 609 | 4% | 533,859 | 264 | 353 | Baden-Württemberg |
62 | 8416 | Tübingen | 60 | 1 708 | 4% | 227,331 | 264 | 352 | Baden-Württemberg |
63 | 9178 | Freising | 47 | 1 415 | 3% | 179,116 | 262 | 351 | Bayern |
64 | 9472 | Bayreuth | 27 | 468 | 6% | 103,656 | 260 | 350 | Bayern |
65 | 9471 | Bamberg | 38 | 565 | 7% | 147,086 | 258 | 349 | Bayern |
66 | 3159 | Göttingen | 84 | 1 530 | 5% | 328,074 | 256 | 348 | Niedersachsen |
67 | 5124 | Wuppertal | 88 | 2 238 | 4% | 354,382 | 248 | 347 | Nordrhein-Westfalen |
68 | 9174 | Dachau | 37 | 1 356 | 3% | 153,884 | 240 | 346 | Bayern |
69 | 9478 | Lichtenfels | 16 | 406 | 4% | 66,838 | 239 | 345 | Bayern |
70 | 9172 | Berchtesgadener Land | 25 | 540 | 5% | 105,722 | 236 | 344 | Bayern |
71 | 9671 | Aschaffenburg | 41 | 733 | 6% | 174,208 | 235 | 343 | Bayern |
72 | 9183 | Mühldorf a. Inn | 27 | 709 | 4% | 115,250 | 234 | 342 | Bayern |
73 | 16052 | Gera | 22 | #DIV/0! | 94,152 | 234 | 341 | Thüringen | |
74 | 8119 | Rems-Murr-Kreis | 99 | 2 583 | 4% | 426,158 | 232 | 340 | Baden-Württemberg |
75 | 9180 | Garmisch-Partenkirchen | 20 | 519 | 4% | 88,467 | 226 | 339 | Bayern |
76 | 16067 | Gotha | 30 | 398 | 8% | 135,452 | 221 | 338 | Thüringen |
77 | 5915 | Hamm | 39 | 1 380 | 3% | 179,111 | 218 | 337 | Nordrhein-Westfalen |
78 | 9678 | Schweinfurt | 25 | 774 | 3% | 115,106 | 217 | 336 | Bayern |
79 | 6634 | Schwalm-Eder-Kreis | 39 | 748 | 5% | 180,222 | 216 | 335 | Hessen |
80 | 9274 | Landshut | 34 | 926 | 4% | 158,698 | 214 | 334 | Bayern |
81 | 8235 | Calw | 33 | 1 054 | 3% | 158,397 | 208 | 333 | Baden-Württemberg |
82 | 5566 | Steinfurt | 92 | 2 048 | 4% | 447,614 | 206 | 332 | Nordrhein-Westfalen |
83 | 8337 | Waldshut | 35 | 481 | 7% | 170,619 | 205 | 331 | Baden-Württemberg |
84 | 9762 | Kaufbeuren | 9 | 226 | 4% | 43,893 | 205 | 330 | Bayern |
85 | 8215 | Karlsruhe | 91 | 1 715 | 5% | 444,232 | 205 | 329 | Baden-Württemberg |
86 | 12069 | Potsdam-Mittelmark | 43 | 725 | 6% | 214,664 | 200 | 328 | Brandenburg |
87 | 5334 | Städteregion Aachen | 109 | 3 257 | 3% | 555,465 | 196 | 327 | Nordrhein-Westfalen |
88 | 5116 | Mönchengladbach | 51 | #DIV/0! | 261,454 | 195 | 326 | Nordrhein-Westfalen | |
89 | 9779 | Donau-Ries | 26 | 539 | 5% | 133,496 | 195 | 325 | Bayern |
90 | 8325 | Rottweil | 27 | 821 | 3% | 139,455 | 194 | 324 | Baden-Württemberg |
91 | 3459 | Osnabrück | 69 | 1 779 | 4% | 357,343 | 193 | 323 | Niedersachsen |
92 | 7111 | Koblenz | 22 | 401 | 5% | 114,024 | 193 | 322 | Rheinland-Pfalz |
93 | 9561 | Ansbach | 8 | 210 | 4% | 41,847 | 191 | 321 | Bayern |
94 | 6632 | Hersfeld-Rotenburg | 23 | #DIV/0! | 120,829 | 190 | 320 | Hessen | |
95 | 9185 | Neuburg-Schrobenhausen | 18 | 500 | 4% | 96,680 | 186 | 319 | Bayern |
96 | 8426 | Biberach | 37 | 932 | 4% | 199,742 | 185 | 318 | Baden-Württemberg |
97 | 5158 | Mettmann | 89 | 2 415 | 4% | 485,684 | 183 | 317 | Nordrhein-Westfalen |
98 | 3153 | Goslar | 25 | 335 | 7% | 137,014 | 182 | 316 | Niedersachsen |
99 | 8327 | Tuttlingen | 25 | 693 | 4% | 140,152 | 178 | 315 | Baden-Württemberg |
100 | 9672 | Bad Kissingen | 18 | 308 | 6% | 103,218 | 174 | 314 | Bayern |