Deckzero Forum

Gov.UK Covid-19 Page: https://www.gov.uk/guidance/coronavirus-covid-19-information-for-the-public This page contains the daily announcement made by @DHSCgovuk on Twitter. It also has detailed daily notes explaining any discrepancy on the tests, cases and deaths data. There is a Time Series section with daily update of historical testing data in excel format. Slides, datasets and transcripts from press conferences at 10 Downing Street in response to coronavirus. https://www.gov.uk/government/collections/slides-and-datasets-to-accompany-coronavirus-press-conferences England PHE Dashboard: https://coronavirus.data.gov.uk/ Updated daily with latest cumulative positive cases from Pillar 1 tests, split by country, region, upper tier local authority, as well as lower tier local authority. Time series data split by local authority in excel format are available on their archive page: https://coronavirus.data.gov.uk/archive The time series case data are recorded as specimen date, for detailed explanation on how PHE update their daily numbers please refer to their 'About Data' page: https://coronavirus.data.gov.uk/about NHS Covid-19 Daily Death Report: https://www.england.nhs.uk/statistics/statistical-work-areas/covid-19-daily-deaths/ Deaths of patients who have died in hospitals in England and had tested positive for COVID-19 or where COVID-19 was mentioned on the death certificate. All deaths are recorded against the date of death rather than the date the deaths were announced. Also include deaths data split by region, NHS trust and Age. Office of National Statistics (ONS) weekly death report: https://www.ons.gov.uk/peoplepopulationandcommunity/healthandsocialcare/conditionsanddiseases Updated weekly with registered deaths in England and Wales with age, gender and regional split. Scotland Daily announcement is made on Scottish Government official Covid-19 portal: https://www.gov.scot/publications/coronavirus-covid-19-daily-data-for-scotland/ Time series data and case split by NHS Board with excel download: https://www.gov.scot/publications/coronavirus-covid-19-trends-in-daily-data/ PHS Scotland open data page with links to all official data: https://www.opendata.nhs.scot/dataset/covid-19-in-scotland PHS dashboard with case data split by local authority: https://www.arcgis.com/apps/opsdashboard/index.html#/658feae0ab1d432f9fdb53aa082e4130 Northern Ireland PHNI daily dashboard: https://app.powerbi.com/view?r=eyJrIjoiZGYxNjYzNmUtOTlmZS00ODAxLWE1YTEtMjA0NjZhMzlmN2JmIiwidCI6IjljOWEzMGRlLWQ4ZDctNGFhNC05NjAwLTRiZTc2MjVmZjZjNSIsImMiOjh9 Historical report: https://www.health-ni.gov.uk/articles/covid-19-daily-dashboard-updates Wales PHW dashboard (there is a 'Local Authorities table' tab for local case update): https://public.tableau.com/profile/public.health.wales.health.protection#!/vizhome/RapidCOVID-19virology-Public/Headlinesummary Time series data split by local authority can be downloaded from the link at the bottom of the headline page. Office of National Statistics (ONS) weekly death report: https://www.ons.gov.uk/peoplepopulationandcommunity/healthandsocialcare/conditionsanddiseases Updated weekly with registered deaths in England and Wales with age, gender and regional split. Other: ICU data provided by Intensive Care National Audit & Research Centre (ICNARC) https://www.icnarc.org/Our-Audit/Audits/Cmp/Reports Covid-19 data repository on GitHub: https://github.com/tomwhite/covid-19-uk-data

8 June update: We have received a lot of warm messages acknowledging our work, as well as enquiring about the local data that we used so that they could look on. Here we provide a summary with all the data sources used in our Covid-19 Portal: https://www.deckzero.com/forum/content-discussion/covid-19-data-sources We would like to thank everyone again for their support. 7 June 2020 Thank you for your attention to our Covid-19 portal and the RZ Index heatmap. We have a message for you. Deckzero is a startup company aiming at providing a platform and tools for building and sharing quantitative analytics. As a platform provider, Deckzero does not have a view or take positions on individual research decks published. The COVID-19 decks are one of our personal projects stemming from the desire to answer our own questions on how we are positioned in the pandemic based on limited official data, drawing from our quantitative experiences. Throughout the project we have been using government-sourced data and have been compiling statistics with the full view of the context of the test data. We have procedures in place to check the correctness and relevance of our data and presentation, and in case of an error, a way to quickly address and fix it. The RZ Index heatmap was our attempt to visualise the live case dynamic changes in a local area. This index had a similar scale and trend with Rt, but was sensitive to weekly case reporting changes in local areas (an intended feature), therefore we had made very clear that the index was specific to the time and local area context. The original disclaimer on the deck carried the following statement: "RZ Index is provided here to indicate and signal changes in new cases, rather than to replicate the scientific R number. It is not official or governmental guidance and shall not be used in any scenario or situation where the government guidance should be followed, including but not limited to policy making by local organisations. " Deckzero never issued any press releases on any part of our Covid-19 analysis, nor commissioned any paid promotion activities through any social media channels. However, t he index had since attracted considerably more attention than initially expected, and was later on quoted and interpreted out of the context and scope of its original intention, which was to help our local friends to increase the daily awareness of Covid development in their areas. To avoid further misunderstanding, we removed the relevant pages from public access on 2 June, which contained the local RZ indices based on case data from 14 May to 29 May. Having reviewed our resourcing, we have decided to draw a conclusion on publishing the Covid-19 set of decks. As with many other data and case analysis projects arisen from this pandemic, we believe we have provided value in pioneering a number of new ways to better understand the government data. What we have learnt from closely following the global pandemic figures since mid January is that every increase in new cases counts, no matter how small the initial case number is; without individual awareness and effective chain-breaking, the pandemic grew exponentially from a tiny number to what we had all seen in the past months. Aside from building quantitative analytics platform to further the spread of sciences, our team, like many others in this country, have also been actively helping our local communities and key workers by donating essential supplies including PPEs. We would like to thank everyone who have helped us through this journey by means of likes, feedbacks, and constructive comments. Going forward, as we try to kick-start the recovery from the pandemic, our team will refocus on platform building for research and education in quantitative sciences. Keep well and #StayAlert 🌈 Best wishes, Deckzero Team