Dataset Design

[rufuspollock]

Value: (new confirmed) cases, deaths, recovered

Dimensions:

• Time
• Country
  • SubCountry i.e. Province/State

Province/State,Country/Region,Lat,Long,date,case
Anhui,Mainland China,31.8257,117.2264,2020-03-04,6
Anhui,Mainland China,31.8257,117.2264,2020-03-05,6
Anhui,Mainland China,31.8257,117.2264,2020-03-06,6
Beijing,Mainland China,40.1824,116.4142,2020-01-22,0
Beijing,Mainland China,40.1824,116.4142,2020-01-23,0
Beijing,Mainland China,40.1824,116.4142,2020-01-24,0
Beijing,Mainland China,40.1824,116.4142,2020-01-25,0

Perfect dataset

Would go with cumulative numbers (we can always difference to get per day)

• What about country totals? Do we compute and put in file e.g. if country is null it is the total ... or we can aggregate in browser / elsewhere.

Country,Province,Date,Confirmed,Death,Recovered

province2latlon

Province,Lat,Lon