datameet / covid19

Novel Corona Virus - COVID-19 India Datasets by DataMeet. Sunsetted on 2022-10-21. Will not update anymore.
https://projects.datameet.org/covid19/
Other
121 stars 110 forks source link

Data Issue in 2020-10-09 #25

Closed thejeshgn closed 4 years ago

thejeshgn commented 4 years ago

Screenshot from 2020-10-11 13-21-34

thejeshgn commented 4 years ago

The issue seems to be a problem with MH data.

From downloads/mohfw-backup/data_json/2020-10-09T08:00:00.00+05:30_md5_d3328442a2caa36de3a8aba4c5051bda.json

    {
        "sno": "22",
        "state_name": "Maharashtra",
        "active": "244976",
        "positive": "1480489",
        "cured": "1196441",
        "death": "39072",
        "new_active": "242438",
        "new_positive": "149388",
        "new_cured": "1212016",
        "new_death": "39430",
        "state_code": "27"
    },

The `new_1 attributes don't add up.

For example, from 2020-10-08T08:00:00.00+05:30_md5_be9d5c75c0991416e8adc2b70c9fa7ab.json

    {
        "sno": "22",
        "state_name": "Maharashtra",
        "active": "247468",
        "positive": "1465911",
        "cured": "1179726",
        "death": "38717",
        "new_active": "244976",
        "new_positive": "1480489",
        "new_cured": "1196441",
        "new_death": "39072",
        "state_code": "27"
    },

new_positive = new_active + new_cured + new_death = 1480489

not the same on 8th.

problem is new_positive is missing the last digit.

So new positive is 242438 + 1212016 + 39430 = 1493884 and not 149388 and hence making the change to add 1493884 into the final result and but not updating the downloads/mohfw-backup/data_json/2020-10-09T08:00:00.00+05:30_md5_d3328442a2caa36de3a8aba4c5051bda.json as it will break the hash.