CSSEGISandData / COVID-19

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

France is not NA #1619

Open petermott opened 4 years ago

petermott commented 4 years ago

Recently the tables have changed so that European France, Miainland France, France métropolitaine, or simply la Metropole has disappeared and become NA.. It should be restored either with one of the standardly accepted names or just "France" as before.

JiPiBi commented 4 years ago

At the beginning it was as now(Null in the Province field for France , only China and US had Province field filled ) , so in my code I was in the habit of copying the Country Value in the Province field when the Province value was null. I didn't change , so this new evolution doesnt disturb me

More important is to know that the row France is in fact an aggregation of the values : Mainland + overseas territories, so when you add France + overseas territories in this dataset , you make an error, you count twice the overseas territories ( not really in fact , because I discovered today that France doesnt aggregate Polynesie Francaise and Nouvelle Caledonie in the daily reports of Sante Publique France)

jpfairbanks commented 4 years ago

That is really important. When we see this section of the table

image

Is the line for (N/A, France) the total for Metropolitan France or for the entirety of France? The same applies for the UK

image

JiPiBi commented 4 years ago

In fact the line France contains already all the territories, at the exception of Nouvelle Calédonie and Polynesie Francaise. The same on worldometers.