theleadio/corona-web

The main web application for CoronaTracker

corona-web's Issues

Can we add 2 missing columns from worldmeters source?

Those two columns

are missed in result of /v3/stats/worldometer/country.
If they exists in worldmeters table, than we can easy add them. I can make PR if someone can tell names of those columns in DB table.
I suppose it is someting like death_cases_per_million_pop and first_case_date

Add columns "Total Tests" and Tests/1M pop from worldmeters

https://www.worldometers.info/coronavirus/

Here is those two columns, can we add them to result of /v3/stats/worldometer/country?
If there already is such columns in table, tell please there names and I could send PR.

Fine tuning - /v2/stats

If we are getting the data for the country then why not pass the country code to the query.

corona-web/routes/v2/stats.js

Line 269 in 4254d95

const customStats = await getCustomStats();

Clear retrospective data for some countries

For example,
http://api.coronatracker.com/v3/stats/worldometer/country?date=2020-01-22
Return this result for USA

{
        "countryCode": "US",
        "country": "USA",
        "lat": 37.09024,
        "lng": -95.712891,
        "totalConfirmed": 85594,
        "totalDeaths": 1300,
        "totalRecovered": 1868,
        "dailyConfirmed": 0,
        "dailyDeaths": 0,
        "activeCases": 0,
        "totalCritical": 0,
        "totalConfirmedPerMillionPopulation": 0,
        "totalDeathsPerMillionPopulation": null,
        "FR": "0.0000",
        "PR": "0.0000",
        "lastUpdated": "2020-01-22T17:00:00.000Z"
    }

Which is obviously wrong for "lastUpdated": "2020-01-22T17:00:00.000Z".
Unfortunately, this issue will not be fixed by #62 because customStats writes lastUpdated as actual datetime of request, so it can't be datetime from long past.