CSSEGISandData / COVID-19

Novel Coronavirus (COVID-19) Cases, provided by JHU CSSE
https://systems.jhu.edu/research/public-health/ncov/
29.13k stars 18.43k forks source link

Incorrect Active Cases = 0 #2140

Open MelbourneDeveloper opened 4 years ago

MelbourneDeveloper commented 4 years ago

From the date 2020 - 3 - 22 the Active column appears. It is inaccurate. It mostly has zeros in it. If the active column value is not known, the column should be blank - not 0. This is a false reading.

This is the row for NYC:

36061 New York City New York US 3/22/20 23:45 40.7672726 -73.97152637 9654 63 0 0 New York City, New York, US

It incorrectly states that there were no active cases on that day for many cities including New York City. The incorrect results in the column go on and on until around line 3191

Discovered with this tool: https://github.com/MelbourneDeveloper/COVID-19-DB

MelbourneDeveloper commented 4 years ago

The problem happens often in the data. This is another example: https://github.com/CSSEGISandData/COVID-19/blob/master/csse_covid_19_data/csse_covid_19_daily_reports/04-11-2020.csv#L2783