search

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

RFE: Unified data 'China' and USA additionally. #1936

Open udippel opened 4 years ago

udippel commented 4 years ago

Like we have countries at the bottom, I'd prefer to have also unified data; like the addition of all Chinese provinces as a single row 'China' or likewise. Having Chinese provinces is fine, but ever more difficult as overwiew. The same might apply to USA: by now there is an ever-increasing amount of cities.

cipriancraciun commented 4 years ago

As described in #1281 I have derived and augmented the JHU dataset and made it available at https://github.com/cipriancraciun/covid19-datasets

Among other changes there is also this summation of world countries with provinces and US provinces. (And then also at higher levels, like subcontinent, continent, and the entire world.)

texadactyl commented 4 years ago

@udippel The Python, C/C++, Java, etc. code to consolidate by country and/or state/province and/or county isn't terribly difficult. If using Python, the pandas package is valuable in reading and filtering CSV files. You can load the daily CSV file information into your own local database (E.g. Sqlite3, MySql, Postgres, etc.).