Sandbird/covid19-Greece

Fix the cases and deaths by date

Closed this issue · 8 comments

cases-greece-fixed.csv
You have to fix cases and deaths by date now. For example:
From November 13 to November 19, 2023: 7792 cases and 29 deaths, you have to put it at 2023-11-19
From November 20 to November 26, 2023: 8299 cases and 46 deaths, you have to put it at 2023-11-26
From November 27 to December 3, 2023: 9842 cases and 44 deaths, you have to put it at 2023-12-03

As I mentioned earlier, you need the cases_weekly_ecdc.csv file.
Screenshot_1

The cases.csv file is used to hold values (in the old daily format) for the Greek NPHO reports, which are released every Thursday (https://eody.gov.gr/en). Once that is completed, and when ECDC reports the latest changes, the correct and updated values are recorded in the cases_weekly_ecdc.csv file.

cases.csv was intended for the daily reports. Hoping that the daily report would resume at some point, I continued updating it. Subsequently, all of these values were transferred to the cases_weekly_ecdc.csv file and I can't make significant changes to cases.csv as other people are still using it.
Why cant you use cases_weekly_ecdc instead? Please explain.

Add cases from 4 December to 10 December please:
https://www.covidstats.gr/eody.html

They are not out yet. We only have the cases+reinfections values from the Greek NPHO (28.539), but ECDC hasn't updated their dataset (https://github.com/EU-ECDC/Respiratory_viruses_weekly_data/tree/main/data/snapshots) yet, which includes ONLY the cases. I can't just add 28.539 cases...it's wrong. Need to separate the 2 totals.
It's not that I am slacking, I've already sent 2 messages to ECDC and raised one issue ticket at their new github repo (EU-ECDC/Respiratory_viruses_weekly_data#1).

This whole thing is a mess....doing the best I can to keep an up-to-date database.

Yes, this is the weekly GR report.
181.775 PCR/Rapid weekly tests with 15.7% positivity rate = 28,539 cases.
But these are not the cases they report to TESSy and these are not the cases that ECDC reports every week.
These are the cases+reinfections. IF ECDC (because they stopped updating their last dashboard/dataset, and now they have erviss.org) doesn't update their latest erviss database anymore, I will be forced to use that number, yes. If that's the case, then every Thursday (when the GR report comes out, I'll be updating the db), but up until now ECDC was releasing their dataset on Fridays or worst case scenario Mondays which included corrections for cases & deaths on previous weeks as well.....which we'll be losing now if they stop updating their new dataset.

image

ECDC just updated their data, i've updated the repo