covid_summary.html

   1 <!DOCTYPE html>
   2 <html xmlns="http://www.w3.org/1999/xhtml" lang="" xml:lang="">
   3 <head>
   4   <meta charset="utf-8" />
   5   <meta name="generator" content="pandoc" />
   6   <meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=yes" />
   7   <meta name="author" content="Neil Smith" />
   8   <title>Covid death data summary</title>
   9   <style type="text/css">
  10       code{white-space: pre-wrap;}
  11       span.smallcaps{font-variant: small-caps;}
  12       span.underline{text-decoration: underline;}
  13       div.column{display: inline-block; vertical-align: top; width: 50%;}
  14   </style>
  15   <!--[if lt IE 9]>
  16     <script src="//cdnjs.cloudflare.com/ajax/libs/html5shiv/3.7.3/html5shiv-printshiv.min.js"></script>
  17   <![endif]-->
  18 </head>
  19 <body>
  20 <header>
  21 <h1 class="title">Covid death data summary</h1>
  22 <p class="author">Neil Smith</p>
  23 <p class="date">Created on 2020-05-24</p>
  24 </header>
  25 <blockquote>
  26 <p>Last UK data from 2020-05-23</p>
  27 </blockquote>
  28 <h2 id="headlines">Headlines</h2>
  29 <table>
  30 <thead>
  31 <tr class="header">
  32 <th style="text-align: left;"><a href=""></a></th>
  33 <th style="text-align: right;"></th>
  34 </tr>
  35 </thead>
  36 <tbody>
  37 <tr class="odd">
  38 <td style="text-align: left;">Deaths reported so far</td>
  39 <td style="text-align: right;">30615</td>
  40 </tr>
  41 <tr class="even">
  42 <td style="text-align: left;">Total Covid deaths to date</td>
  43 <td style="text-align: right;">64827</td>
  44 </tr>
  45 <tr class="odd">
  46 <td style="text-align: left;">Projected total deaths up to 2020-06-09</td>
  47 <td style="text-align: right;">71110</td>
  48 </tr>
  49 </tbody>
  50 </table>
  51 <h2 id="total-deaths">Total deaths</h2>
  52 <p>Time based on days since 10 deaths</p>
  53 <figure>
  54 <img src="covid_deaths_total_linear.png" alt="Total deaths" /><figcaption>Total deaths</figcaption>
  55 </figure>
  56 <table>
  57 <thead>
  58 <tr class="header">
  59 <th style="text-align: left;">Country ID</th>
  60 <th style="text-align: left;">Country name</th>
  61 <th style="text-align: right;">Total deaths</th>
  62 </tr>
  63 </thead>
  64 <tbody>
  65 <tr class="odd">
  66 <td style="text-align: left;">DE</td>
  67 <td style="text-align: left;">Germany</td>
  68 <td style="text-align: right;">8216</td>
  69 </tr>
  70 <tr class="even">
  71 <td style="text-align: left;">ES</td>
  72 <td style="text-align: left;">Spain</td>
  73 <td style="text-align: right;">28628</td>
  74 </tr>
  75 <tr class="odd">
  76 <td style="text-align: left;">FR</td>
  77 <td style="text-align: left;">France</td>
  78 <td style="text-align: right;">28289</td>
  79 </tr>
  80 <tr class="even">
  81 <td style="text-align: left;">IE</td>
  82 <td style="text-align: left;">Ireland</td>
  83 <td style="text-align: right;">1592</td>
  84 </tr>
  85 <tr class="odd">
  86 <td style="text-align: left;">IT</td>
  87 <td style="text-align: left;">Italy</td>
  88 <td style="text-align: right;">32616</td>
  89 </tr>
  90 <tr class="even">
  91 <td style="text-align: left;">UK</td>
  92 <td style="text-align: left;">United_Kingdom</td>
  93 <td style="text-align: right;">36393</td>
  94 </tr>
  95 </tbody>
  96 </table>
  97 <h2 id="all-causes-deaths-uk">All-causes deaths, UK</h2>
  98 <figure>
  99 <img src="deaths-radar.png" alt="All-causes deaths" /><figcaption>All-causes deaths</figcaption>
 100 </figure>
 101 <h3 id="excess-deaths">Excess deaths</h3>
 102 <p>From week ending 20 March 2020, there have been approximately <strong>54535</strong> excess deaths, over the average for the previous five years.</p>
 103 <p>In that period, the UK reported 30615 Covid deaths. That means the actual number of Covid death is about 1.78 times higher than the reported figures.</p>
 104 <p>The UK has reported 36393 deaths so far. Using the scaling factor above, I infer that there have been <strong>64827</strong> total deaths so far.</p>
 105 <h2 id="deaths-per-day">Deaths per day</h2>
 106 <p>Based on a 7-day moving average</p>
 107 <figure>
 108 <img src="covid_deaths_per_day_7.png" alt="Deaths per day" /><figcaption>Deaths per day</figcaption>
 109 </figure>
 110 <h2 id="projected-deaths">Projected deaths</h2>
 111 <p>The UK’s daily deaths data is very similar to Italy’s. If I use the Italian data for the next 16 days, the UK will report 39920 deaths on day 87 of the epidemic.</p>
 112 <p>Using the excess deaths scaling from above, that will translate into <strong>71110</strong> Covid deaths total.</p>
 113 <h2 id="deaths-doubling-times">Deaths doubling times</h2>
 114 <p>Based on a 7-day moving average</p>
 115 <figure>
 116 <img src="covid_doubling_times_7.png" alt="Deaths doubling times" /><figcaption>Deaths doubling times</figcaption>
 117 </figure>
 118 <h1 id="data-sources">Data sources</h1>
 119 <blockquote>
 120 <p>Covid data from <a href="https://www.ecdc.europa.eu/en/publications-data/download-todays-data-geographic-distribution-covid-19-cases-worldwide">European Centre for Disease Prevention and Control</a></p>
 121 </blockquote>
 122 <blockquote>
 123 <p>Population data from:</p>
 124 </blockquote>
 125 <ul>
 126 <li><a href="https://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/datasets/weeklyprovisionalfiguresondeathsregisteredinenglandandwales">Office of National Statistics</a> (Endland and Wales) Weeks start on a Saturday.</li>
 127 <li><a href="https://www.nisra.gov.uk/publications/weekly-deaths">Northern Ireland Statistics and Research Agency</a> (Northern Ireland). Weeks start on a Saturday. Note that the week numbers don’t match the England and Wales data.</li>
 128 <li><a href="https://www.nrscotland.gov.uk/statistics-and-data/statistics/statistics-by-theme/vital-events/general-publications/weekly-and-monthly-data-on-births-and-deaths/weekly-data-on-births-and-deaths">National Records of Scotland</a> (Scotland). Note that Scotland uses ISO8601 week numbers, which start on a Monday.</li>
 129 </ul>
 130 <blockquote>
 131 <p><a href="https://git.njae.me.uk/?p=covid19.git;a=tree">Souce code available</a></p>
 132 </blockquote>
 133 </body>
 134 </html>