UKHSA-Internal/coronavirus-dashboard

Inconsistent Behaviour in CSV download for daily deaths with covid 19 on the death certificate

Closed this issue · 3 comments

Describe the bug
The csv download button for Daily deaths with COVID-19 on the death certificate by date of death is not consistent. In the last couple of weeks incomplete deaths are provided. However more than 2 weeks ago incomplete deaths were not provided.

To Reproduce
Steps to reproduce the behaviour:
Download the data and compare it to the visualisation.

Expected behaviour
I would expect that incomplete data be either consistently provided, or consistently not provided in the download. This is not the case

This is not really a development issue, but the methodologies for all metrics are outlined in their documentations.

I'm not sure I understand your query, but have a look at the docs. Feel free to get back to us if the answer isn't clear.

Please bear in mind that we are reliant on external sources for the data and can only publish that which we receive. It may be that the data were delayed. We do our best to provide consistent data, but that depends on the consistency of the data we receive.

I have looked at the documentation. It seems like documentation exists for the deaths within 28 days of a covid test, but does not exists for daily deaths with covid 19 on the death certificate.

From https://coronavirus.data.gov.uk/details/deaths it says "There is a lag in reporting of at least 11 days because the data are based on death registrations"

In this screen shot I compare two data extracts taken a week a part. The left most plot has incomplete data present - and we know this because a week later the number is higher.
incomplete data

So to clarify this bug relates to whether you supply the data that relate to the 11 day window (reporting lag). Mid September you were not providing it. and at some point in October you started providing it.

The documentation for the death certificate deaths is here https://coronavirus.data.gov.uk/metrics/doc/newDailyNsoDeathsByDeathDate

If you are still experiencing issues with the data please email coronavirus-tracker@phe.gov.uk