emmadoughty / daily_covid-19 Goto Github PK

Any thoughts on the government's assumption of a 5-day doubling time?
@robchallen?
(https://www.imperial.ac.uk/media/imperial-college/medicine/sph/ide/gida-fellowships/Imperial-College-COVID19-NPI-modelling-16-03-2020.pdf)

Hi, please could you reinstate the spreadsheet of cumulative local counts of confirmed cases? Although there do appear to be some problems with data quality (e.g. Sheffield dropped from 15 to 1 yesterday), I think it's important that these issues are identifiable, because these local counts presumably form the basis for the total UK counts.

Hello,

Thank you so much for collating this data! We are hoping to use it to produce estimates of the time-varying reproduction number at the regional level (we are currently doing this at the country level and regional level for Italy).

1. We'd like to add you as an author to the work we produce to recognise the work you are putting in doing this. Let me know name and institution if you would like to be added as an author.
2. Can you keep the date format consistent in the csv files please, saves me a bit of a headache trying to re-format the dates later!

Thanks,
Joel

Thanks for recording this data from PHE. We have been using it to power our site.

I'd like to know if this dataset is being maintained and in what capacity? I notice that the data for March 17th (by UTLA) is not yet added. I also notice that yesterday the values for Wales, Scotland and Northern Ireland were included, but they've since gone. I'm happy to assist with the data collection if I can be helpful.

I'm maintaining timeseries data also: Am cross referencing your site and pulling data from PHE:

https://docs.google.com/spreadsheets/d/1snb-vYuH7fVpTuyoQrM8zWiABYoXbSrnn44w-zlhM90/edit?usp=sharing

Feel free to borrow / steal

UK = list(
  regional=read.csv(file="https://docs.google.com/spreadsheets/d/e/2PACX-1vQod-HdDk4Nl8BFcunG5P-QA2CuKdIXCfK53HJDxcsaYlOov4FFc-yQciJyQFrqX5_n_ixz56S7uNBh/pub?gid=163112336&single=true&output=csv"),
  englandNHS=read.csv(file="https://docs.google.com/spreadsheets/d/e/2PACX-1vQod-HdDk4Nl8BFcunG5P-QA2CuKdIXCfK53HJDxcsaYlOov4FFc-yQciJyQFrqX5_n_ixz56S7uNBh/pub?gid=0&single=true&output=csv"),
  englandLA=read.csv(file="https://docs.google.com/spreadsheets/d/e/2PACX-1vQod-HdDk4Nl8BFcunG5P-QA2CuKdIXCfK53HJDxcsaYlOov4FFc-yQciJyQFrqX5_n_ixz56S7uNBh/pub?gid=796246456&single=true&output=csv")
)

Will get you the data in R. Finding lots of data quality issues - cumulative counts decreasing for example.

Hi Emma,

We were using this as a historical data source, is there a reason beyond the fact it will no longer be updated that it has been deleted?

I'm comparing COVID19_deaths.csv with the data I've been collating on https://github.com/tomwhite/covid-19-uk-data, and came across a few discrepancies.

• NI on 24/03/2020, the file in this repo has 4, mine has 5. According to this tweet (https://twitter.com/healthdpt/status/1242528268844138497) from the NI Dept of Health the correct figure is 5.
• Wales on 17/03/2020, the file in this repo has 2, mine has 1. I'm not sure which is correct!
• Wales on 21/03/2020, the file in this repo has 5, mine has 3. The archived page from PHW from that day says "Three people in Wales who tested positive for Novel Coronavirus (COVID-19) have now died" (see https://github.com/tomwhite/covid-19-uk-data/blob/master/data/raw/coronavirus-covid-19-number-of-cases-in-wales-2020-03-21.html). However, this tweet (https://twitter.com/PublicHealthW/status/1241402961189888001) says a further 2 people died (so the total would be 5). I think which figure is correct depends on reporting cut off times.

Otherwise all the figures match. One thing this shows is that inferring the figures for England is not straightforward, since we don't know if the reporting times match up.

I'd be interested to see what you think, and if you have any more information about what the reported figures were for these days. Thanks again for all your work on collecting the data.

Thanks for your work to help the people in need! Your site has been added! I currently maintain the Open-Source-COVID-19 page, which collects all open source projects related to COVID-19, including maps, data, news, api, analysis, medical and supply information, etc. Please share to anyone who might need the information in the list, or will possibly contribute to some of those projects. You are also welcome to recommend more projects.

https://weileizeng.github.io/Open-Source-COVID-19/

Cheers!