{"id":2496,"date":"2020-04-24T15:02:36","date_gmt":"2020-04-24T14:02:36","guid":{"rendered":"https:\/\/marriott-stats.com\/nigels-blog\/?p=2496"},"modified":"2020-04-26T23:36:13","modified_gmt":"2020-04-26T22:36:13","slug":"how-many-people-have-died-of-covid19","status":"publish","type":"post","link":"https:\/\/marriott-stats.com\/nigels-blog\/how-many-people-have-died-of-covid19\/","title":{"rendered":"Coronavirus #3 &#8211; How many people have died of COVID19 in the UK?"},"content":{"rendered":"<p>The Financial Times (<strong>FT<\/strong>) has estimated <a href=\"https:\/\/www.ft.com\/content\/67e6a4ee-3d05-43bc-ba03-e239799fa6ab\" target=\"_blank\" rel=\"noopener noreferrer\">the true number of COVID19 related deaths in the UK as of 20th April 2020 is 42,000<\/a> not 17,000 as published by the Department of Health &amp; Social Care (<strong>DHSC<\/strong>).\u00a0 In this article, I show that the FT headline is incorrect and is the result of either the FT comparing apples with pears due to a misunderstanding over what the various data sets measure or the FT attempting to estimate a number that can never be verified.<\/p>\n<p><!--more--><\/p>\n<h4><strong><span style=\"color: #008000\">Who provides data on COVID19 related deaths?<\/span><\/strong><\/h4>\n<p>In section A1 of <a href=\"https:\/\/marriott-stats.com\/nigels-blog\/coronavirus-useful-data-and-links\/\" target=\"_blank\" rel=\"noopener noreferrer\">my collection of COVID19 links<\/a>, I list three sources of data for the number of deaths due to or with COVID19 in the UK which are:-<\/p>\n<ol>\n<li><a href=\"https:\/\/coronavirus.data.gov.uk\/\" target=\"_blank\" rel=\"noopener noreferrer\"><span style=\"color: #ff0000\"><strong>DHSC<\/strong><\/span> for UK as a whole and for the 4 nations of England, Wales, Scotland &amp; Northern Ireland<\/a>.\u00a0 This used to be published by Public Health England (<strong>PHE)<\/strong> but is now done by DHSC.\u00a0 DHSC in turn source their data from the relevant body in England, Wales, Scotland and Northern Ireland.<\/li>\n<li><a href=\"https:\/\/www.england.nhs.uk\/statistics\/statistical-work-areas\/covid-19-daily-deaths\/\" target=\"_blank\" rel=\"noopener noreferrer\">NHS England (<span style=\"color: #0000ff\"><strong>NHS<\/strong><\/span>) for England only<\/a>.\u00a0 They use the same dataset provided by PHE for England only.<\/li>\n<li><a href=\"https:\/\/www.ons.gov.uk\/peoplepopulationandcommunity\/birthsdeathsandmarriages\/deaths\/datasets\/weeklyprovisionalfiguresondeathsregisteredinenglandandwales\" target=\"_blank\" rel=\"noopener noreferrer\">Office of National Statistics (<span style=\"color: #008000\"><strong>ONS<\/strong><\/span>) for England &amp; Wales only<\/a>.<\/li>\n<\/ol>\n<p>Anthony Masters, an ambassador for the Royal Statistical Society (RSS), wrote this useful <a href=\"https:\/\/medium.com\/@theintersectuk\/death-counts-with-covid-19-6eb924ba7425\" target=\"_blank\" rel=\"noopener noreferrer\">article on the differences between the 3 datasets of PHE, NHS &amp; ONS<\/a>.\u00a0 The differences arise from geographical coverage and data timings.\u00a0 When the devolved governments of Scotland, Northern Ireland &amp; Wales came into being at the start of the millennium, responsibility for the collection of statistics was devolved in some areas and not in others.\u00a0 The result is that geographical coverage varies between sources and can be frustrating depending on what statistic you are looking for.<\/p>\n<p>When someone dies in the UK, a death certificate has to be completed by either a doctor or coroner.\u00a0 These are then submitted to the General Register&#8217;s Office (GRO) which records these certificates.\u00a0 On the certificate, a cause of death (such as COVID19) will be stated along with other conditions that may have contributed to or been present at the time of death.\u00a0 For example, if someone is run over by a bus and killed then clearly the cause of death is the accident but if the post-mortem shows the person had COVID19, the death certificate should list that as well.\u00a0 If COVID19 is the cause of death, we say the death is <strong>DUE TO<\/strong> the disease but if COVID19 is present but not the cause we say the death is <strong>WITH<\/strong> the disease.\u00a0 That explains the terminology I use throughout of saying &#8220;<em>the number of deaths due to or with COVID19<\/em>&#8220;.<\/p>\n<p>There is no requirement for COVID19 to be confirmed with a test.\u00a0 A doctor can still list COVID19 if he or she suspects its presence by writing COVID19* with an asterisk.\u00a0 COVID19 is a notifiable disease which means doctors are obliged to notify authorities if they spot it.\u00a0 Unfortunately COVID19 tests have a high false negative rate which means that someone who has COVID19 can still give a negative test result.\u00a0 In that instance, the doctor has to use their judgement such as the presence of typical symptoms.\u00a0 This places a lot of responsibility on the doctor though and it is possible that some doctors won&#8217;t state COVID19 on the death certificate without a positive test.\u00a0 An analysis of COVID19 death certificates in March 2020 showed less than 2% of COVID19 deaths were marked with an asterisk.<\/p>\n<p>All 3 data sources are counting the number of deaths where the death certificate states it was due to or with COVID19 on it.\u00a0 However, the NHS &amp; DHSC are only counting the death certificates that they get to sign which means a doctor in a hospital.\u00a0 The process is that someone dies in an NHS hospital, the doctor fills out a death certificate and records the details in the NHS data system.\u00a0 The certificate is then sent to the General Register Office.\u00a0 The NHS &amp; DHSC are not seeing the death certificates signed by doctors and coroners outside of the hospitals.<\/p>\n<p>The ONS on the other hand has access to all the death certificates received by the GRO.\u00a0 They go through all certificates and record both causes of death and conditions that were present with the death.\u00a0 Consequently the ONS are counting all deaths in England &amp; Wales and can also count the number of certificates where COVID19 is stated anywhere.<\/p>\n<p>The differences between the 3 sources in terms of timing is the whole point of this article so I want to spend time explaining these.\u00a0 It motivated the FT&#8217;s article in the first place but also might have contributed to the error I think they have made.<\/p>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #008000\"><strong>How many COVID19 deaths have there been in England as of 20th April 2020?<\/strong><\/span><\/h4>\n<p>At the time of FT article, the 3 sources reported the following number of deaths due to or with COVID19 in England only.<\/p>\n<ul>\n<li>DHSC\/PHE Hospitals only = <strong>15,606<\/strong> by 20th April<\/li>\n<li>NHS Hospitals only = <strong>15,605<\/strong> by 20th April<\/li>\n<li>ONS All Deaths Registrations = <strong>9.863<\/strong> by 10th April<\/li>\n<li>ONS All Deaths Occurrences = <strong>12,516<\/strong> by 10th April<\/li>\n<li>ONS All Excess Deaths Registrations = <strong>14,590<\/strong> between 21st March &amp; 10th April<\/li>\n<\/ul>\n<p>ONS publish their figures weekly on a Tuesday for data up to the previous Friday whereas NHS\/DHSC publish their figures daily for data up to previous day.\u00a0 That explains why the ONS are 10 days behind.<\/p>\n<p>There are two ways of allocating death certificates to specific dates.<\/p>\n<ul>\n<li><strong>Date of registration <\/strong>&#8211; Known as <strong>Registrations<\/strong> by the ONS, this is the date on which the certificate is submitted to the GRO and can be a number of days after the day of death itself.\u00a0 There are many reasons for the time lag ranging from the time taken to do a post mortem, to inform the family and to complete and process the certificate through the hospitals administrative system.<\/li>\n<li><strong>Date of death<\/strong> &#8211;\u00a0Known as <b>Occurrences<\/b> by the ONS, this is the actual day on which the person died.<\/li>\n<\/ul>\n<p>For deaths in English hospitals only, <strong>the DHSC\/PHE dataset publishes daily data by date of registrations<\/strong> whilst <strong>NHS England takes the same data and publishes it by date of death<\/strong>.\u00a0 That is why the total figures are the same but with a difference is in the timing of the data as shown in this chart.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2508 alignnone\" src=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/NHS-v-DHSC-300x197.png\" alt=\"\" width=\"681\" height=\"447\" srcset=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/NHS-v-DHSC-300x197.png 300w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/NHS-v-DHSC-1024x673.png 1024w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/NHS-v-DHSC-768x505.png 768w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/NHS-v-DHSC-1536x1009.png 1536w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/NHS-v-DHSC-450x296.png 450w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/NHS-v-DHSC.png 1542w\" sizes=\"auto, (max-width: 681px) 100vw, 681px\" \/><\/p>\n<p><strong>Whilst the ONS only publish weekly, they are calculating daily data for both date of registration &amp; date of death using death certificates <\/strong>from all sources in England, not just hospitals.\u00a0 However, they face exactly the same issue as DHSC\/NHS in that they are reliant on doctors recording COVID19 on the death certificate.\u00a0 If doctors are unable to or reluctant to do so because they want a positive test result, then even the ONS will be undercounting the extent of COVID19 mortality.<\/p>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #008000\"><strong>What are Excess Deaths?<\/strong><\/span><\/h4>\n<p>For this reason, the Excess Deaths measure will become the most important statistic of all but what does it mean?\u00a0 The ONS count and record all deaths from all causes in England by date of registration only (remember this point for later!) and have been doing so for decades.\u00a0 Consequently, they can estimate for each week in 2020 how many death registrations would be expected based on historical patterns.\u00a0 Typically they use the average of the last 5 years but more sophisticated estimates (usually based on weather patterns) are possible.\u00a0 These estimates are sometimes called the <strong>baseline<\/strong>.\u00a0 The difference between actual number of death registrations and the baseline number of death registrations is what is known as <strong>Excess Deaths<\/strong>.<\/p>\n<p>The chart here shows actual, baseline and excess deaths (from all causes) for the first 15 weeks of 2020 in England only.\u00a0 For the first 12 weeks, excess deaths were in line with the baseline or were negative i.e. deaths from all causes were below the baseline.\u00a0 This is attributed to <a href=\"https:\/\/marriott-stats.com\/nigels-blog\/uk-weather-trends-12-winter-2020\/\" target=\"_blank\" rel=\"noopener noreferrer\">a milder winter than usual<\/a> and an associated lower death toll from seasonal flu.\u00a0 Excess deaths became positive in week 13 and set new all time records in weeks 14 &amp; 15.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2509 alignnone\" src=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-Excess-2020-300x197.png\" alt=\"\" width=\"728\" height=\"478\" srcset=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-Excess-2020-300x197.png 300w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-Excess-2020-1024x673.png 1024w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-Excess-2020-768x505.png 768w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-Excess-2020-1536x1009.png 1536w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-Excess-2020-450x296.png 450w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-Excess-2020.png 1542w\" sizes=\"auto, (max-width: 728px) 100vw, 728px\" \/><\/p>\n<p>Can these excess deaths all be attributed to COVID19?\u00a0 The answer is yes if you not going to distinguish between direct and indirect causes.\u00a0 In theory direct deaths should be measured by the death certificates but as mentioned above, there is evidence that doctors are being cautious with stating this on the certificate if they don&#8217;t have a positive test for COVID19 which means the count of direct deaths is likely to be understated.\u00a0 Indirect deaths are those deaths that have occurred that would not have occurred if the pandemic was not taking place.\u00a0 For example, if the NHS is focusing too much on treating COVID19 patients and not enough on cancer patients then one might expect cancer deaths to be higher than usual.\u00a0 The cause of such deaths is not COVID19 directly but it is an indirect consequence of COVID19.\u00a0 Alternatively, if doctors fail to state COVID19 as reason for death when the person really did die of COVID19, then the excess deaths will pick this up as an indirect death.\u00a0 It should be direct but it&#8217;s indirect instead.<\/p>\n<p>For a more in depth analysis of the difference between direct and indirect COVID19 deaths, please read <a href=\"https:\/\/medium.com\/@d_spiegel\/covid-and-excess-deaths-in-the-week-ending-april-10th-20ca7d355ec4\" target=\"_blank\" rel=\"noopener noreferrer\">this article published today by David Spigelhalte<\/a>r, former president of the RSS.<\/p>\n<p>In general, epidemiologists prefer to use excess deaths to evaluate the severity of an outbreak as it captures all outcomes from this disease.\u00a0 It is also a method that can be applied<img loading=\"lazy\" decoding=\"async\" class=\"alignright size-medium wp-image-2511\" src=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-Excess-weekly-300x240.png\" alt=\"\" width=\"300\" height=\"240\" srcset=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-Excess-weekly-300x240.png 300w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-Excess-weekly-437x350.png 437w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-Excess-weekly.png 543w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/> in any country that has good death recording systems and thus makes international comparisons straightforward.\u00a0 Both the Financial Times and I are assuming that excess deaths are a reasonable proxy for all direct and indirect causes of death from COVID19 and in their article, the FT wanted to estimate what the excess deaths recorded by the ONS between 11th &amp; 20th April would be.\u00a0 If this could be done, we could then directly compare total excess deaths to 20th April with the total number of death registrations to 20th April published by DHSC.\u00a0 The table here shows what was known as of 20th April which is when the FT wrote their article.<\/p>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #008000\"><strong>What is my estimate of true number of COVID19 deaths?<\/strong><\/span><\/h4>\n<p>Both the DHSC data and ONS Excess Deaths data are based on Death Registrations.\u00a0 In theory, since both use death certificates, there should be a relationship between the ONS and DHSC figures even though DHSC only measure deaths in hospitals whilst ONS measure deaths from everywhere. One problem though is that DHSC data is daily whilst the ONS Excess Deaths is weekly.\u00a0 To identify a relationship, I need to first convert the ONS Excess Deaths into daily data.<\/p>\n<p>Around the time the UK went into lockdown, the ONS starting publishing daily death registrations due to or with COVID19.\u00a0 I decided to use the weekday patterns displayed in this data to estimate what the weekday pattern would be for all excess deaths.\u00a0 For example, ONS said there were 5,899 death registrations due to or with COVID19 in England in the week ending 10th April.\u00a0 Of these, only 22 (0.4%) were recorded on Sunday 5th April whereas 1,431 (24.6%) were recorded on Thursday 9th April.\u00a0 Excess Deaths from all causes for week ending 10th April were 7,762 in England so using these percentages, I estimate there were 29 &amp; 1883 excess deaths respectively on the Sunday and Thursday of that week.\u00a0 Using this method, I can generate my time series of ONS Excess Deaths by day.<\/p>\n<p>The next step is to look at the relationship between this and the DHSC daily series.\u00a0 The chart here shows the ONS Excess Deaths divided by DHSC Covid19 deaths by day of the week for weeks 13 to 15 of 2020 which are the weeks when excess deaths became strongly positive.\u00a0 The first week shown is not particularly stable but the last two weeks show a clear and consistent pattern of a small ratio at the weekend of 0.1 or so but rising to 2.4 during the week.\u00a0 Interestingly the last day Friday 10th April was Good Friday, a public holiday in the UK and the ratio was only half that of the previous week.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2507 alignnone\" src=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-v-DHSC-300x197.png\" alt=\"\" width=\"637\" height=\"418\" srcset=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-v-DHSC-300x197.png 300w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-v-DHSC-1024x673.png 1024w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-v-DHSC-768x505.png 768w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-v-DHSC-1536x1009.png 1536w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-v-DHSC-450x296.png 450w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-v-DHSC.png 1542w\" sizes=\"auto, (max-width: 637px) 100vw, 637px\" \/><\/p>\n<p>I decided to take a weighted average of the 3 weeks shown for each weekday to arrive at the fitted black line.\u00a0 The weights were the total number of excess deaths in each week.\u00a0 For the Friday, I excluded the Good Friday from this calculation since this is a known one-off public holiday.\u00a0 Since I know what the DHSC death registrations are for each day from 11th to 20th April, I can multiply these numbers by the relevant ratio from the fitted black line to arrive at my estimate of ONS Excess Deaths in England for this period.\u00a0 This works out to be 10,375.\u00a0 When I add this to the 14,590 excess deaths in England registered in the 3 weeks to 10th April by ONS, I arrive at a total of 24,965.<\/p>\n<p>One minor point to be aware of regarding my estimate of 10375.\u00a0 From the chart above, Good Friday was below the fitted ratio which implies that some ONS registrations would be carried over to the following week.\u00a0 I therefore added a quantity to the following week by multiplying the DHSC death registrations for Good Friday by the difference between the fitted ratio and the actual ratio.\u00a0 A similar effect could be expected for Easter Monday with registrations less than expected but I have assumed that the Monday backlog would be cleared by Friday.<\/p>\n<p>&nbsp;<\/p>\n<h4><strong><span style=\"color: #008000\">How did the FT make their estimate?<\/span><\/strong><\/h4>\n<p>The FT and I agree on the ONS Excess Deaths in England as of 10th April 2020.\u00a0 They state in their article that they expect the total in England and Wales by 20th April to be 38,000. <img loading=\"lazy\" decoding=\"async\" class=\"alignright size-medium wp-image-2510\" src=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-Excess-forecast-300x227.png\" alt=\"\" width=\"300\" height=\"227\" srcset=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-Excess-forecast-300x227.png 300w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-Excess-forecast-450x341.png 450w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-Excess-forecast.png 574w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/> Knocking off a bit for Wales and have inferred that they are expecting 21,297 excess deaths in England for the period 11th to 2oth April.\u00a0 This is almost twice what I am expecting.<\/p>\n<p>To sense check the FT estimate I have worked backwards to estimate the implied ratio between ONS excess deaths and DHSC deaths in this chart that I showed before.\u00a0 I do not see how they can arrive at such a ratio.\u00a0 I can accept some variation from my fitted line but they are on a different level altogether.\u00a0 So how did they arrive at their estimates?<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2506 alignnone\" src=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-v-DHSC-2-300x197.png\" alt=\"\" width=\"659\" height=\"433\" srcset=\"https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-v-DHSC-2-300x197.png 300w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-v-DHSC-2-1024x673.png 1024w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-v-DHSC-2-768x505.png 768w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-v-DHSC-2-1536x1009.png 1536w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-v-DHSC-2-450x296.png 450w, https:\/\/marriott-stats.com\/nigels-blog\/wp-content\/uploads\/2020\/04\/ONS-v-DHSC-2.png 1542w\" sizes=\"auto, (max-width: 659px) 100vw, 659px\" \/><\/p>\n<p>I have read both the <a href=\"https:\/\/www.ft.com\/content\/67e6a4ee-3d05-43bc-ba03-e239799fa6ab\" target=\"_blank\" rel=\"noopener noreferrer\">FT article<\/a> and an associated <a href=\"https:\/\/twitter.com\/ChrisGiles_\/status\/1252841436317315072\" target=\"_blank\" rel=\"noopener noreferrer\">twitter thread by the author Chris Giles<\/a>, Economics Editor of the FT.\u00a0 It is not entirely clear what method they use but I noted a few references in Chris&#8217;s twitter thread of time lags between the ONS and DHSC figures.\u00a0 We already know that the timing of death registrations and death occurrences are different so I am left with the conclusion that the FT have made one or more assumptions.\u00a0 I have listed what I think the FT might have assumed along with what I think is problematic about these.<\/p>\n<ol>\n<li><em><strong>ONS Excess deaths are death occurrences whilst DHSC are death registrations<\/strong> <\/em>&#8211; Incorrect, both DHSC and ONS Excess deaths are registrations dates not date of death.<\/li>\n<li><em><strong>ONS intend to publish Excess Deaths based on the date death occurred<\/strong><\/em> &#8211; I have seen no such indication whatsoever the ONS will be doing this.\u00a0 They would have to redo the last 5 years first of all to convert all death registrations into death occurrences.\u00a0 At the same time, they would have to calculate this by day, not just by week.<\/li>\n<li><em><strong>FT have access to an additional dataset that predicts the ratio between ONS &amp; DHSC will change<\/strong><\/em> &#8211; For example, it could be that there is going to be a massive spike in care home deaths not captured by the DHSC data.\u00a0 If so, the FT haven&#8217;t mentioned this explicitly.<\/li>\n<li><strong><em>ONS &amp; DHSC are working to different timetables to register deaths<\/em> <\/strong>&#8211; My ratio charts above show this is the case in that ONS do very few registrations at weekends whereas PHE on behalf of DHSC do.\u00a0 Presumably this is due to ONS staff working office hours and PHE staff working shifts?<\/li>\n<\/ol>\n<p>Of the 4 explanations, I think the last is the most plausible.\u00a0 But the difference of 10,500 excess deaths equates to one of the two sources being at least a week apart in their registrations.\u00a0 I think this is completely implausible and I would like the FT to respond to my article here.\u00a0 If they do, I will publish their response here.<\/p>\n<p><em><span style=\"color: #993300\"><strong>&#8211; Update 26th April &#8211;<\/strong><\/span> <a href=\"https:\/\/twitter.com\/MarriottNigel\/status\/1253687537773809664\" target=\"_blank\" rel=\"noopener noreferrer\">I had a twitter exchange with the writer of the FT article, Chris Giles<\/a>.\u00a0 This seems to confirm that the FT are indeed estimating something cannot be verified (point 2 above).\u00a0 In addition, Chris seems to accept that they have been extrapolating data into the future when originally they said they hadn&#8217;t.\u00a0 All in all, I think FT are basically estimating what the published excess deaths will be as of week ending 24th April and then shifting that estimate back 4 days to the 20th April to account for time lags.\u00a0 \u00a0Chris stated that he is estimating similar number of excess deaths for England as of week ending 17th April which implies that it will be week ending 24th April that will see a major difference.<\/em><\/p>\n<p><em>I have rechecked all my numbers by creating a new spreadsheet and I stand by my estimates in this article.\u00a0 On Tuesday 28th April, I will be publishing a new blog post which will contain a link to my spreadsheet which contains my estimates as well as other COVID19 death data for the UK.<\/em><\/p>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #993300\"><strong>&#8211; More posts about COVID19 &#8211;<\/strong><\/span><\/h4>\n<ol>\n<li>A very useful <a href=\"https:\/\/www.statslife.org.uk\/features\/4474-a-statistician-s-guide-to-coronavirus-numbers\" target=\"_blank\" rel=\"noopener noreferrer\">guidance to interpreting statistics of COVID19<\/a> published by the Royal Statistical Society.<\/li>\n<li><a href=\"https:\/\/marriott-stats.com\/nigels-blog\/coronavirus-useful-data-and-links\/\" target=\"_blank\" rel=\"noopener noreferrer\">My collection of links to all kinds of material<\/a> related to the statistics of COVID19, epidemiological modelling and testing.<\/li>\n<li><a href=\"https:\/\/marriott-stats.com\/nigels-blog\/be-more-accurate-with-a-smaller-sample-size\/\" target=\"_blank\" rel=\"noopener noreferrer\">How large a sample is needed<\/a> in order to decide whether COVID19 restrictions can be lifted?\u00a0 A lot, lot less than you think!<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>The Financial Times (FT) has estimated the true number of COVID19 related deaths in the UK as of 20th April 2020 is 42,000 not 17,000 as published by the Department of Health &amp; Social Care (DHSC).\u00a0 In this article, I show that the FT headline is incorrect and is the result of either the FT [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":2510,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[1],"tags":[164,163,37,70,181,180,179,169,182,168],"class_list":{"0":"post-2496","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-misc","8":"tag-coronavirus","9":"tag-covid19","10":"tag-data-journalism","11":"tag-data-quality","12":"tag-dhsc","13":"tag-nhs","14":"tag-ons","15":"tag-pandemic","16":"tag-phe","17":"tag-sars-cov-2","18":"entry","19":"override"},"_links":{"self":[{"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/posts\/2496","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/comments?post=2496"}],"version-history":[{"count":12,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/posts\/2496\/revisions"}],"predecessor-version":[{"id":2517,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/posts\/2496\/revisions\/2517"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/media\/2510"}],"wp:attachment":[{"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/media?parent=2496"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/categories?post=2496"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/marriott-stats.com\/nigels-blog\/wp-json\/wp\/v2\/tags?post=2496"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}