search

boogheta / coronavirus-countries

COVID-19 interactive dashboard for the whole world
https://boogheta.github.io/coronavirus-countries/
GNU Affero General Public License v3.0
55 stars 16 forks source link

Complete missing population data #22

Closed boogheta closed 4 years ago

boogheta commented 4 years ago

JHU's data is adding new provinces and countries when new ones are reported, so the list will need to be completed from time to time @robindemourat Here are the few missing as of tonight:

WARNING: missing population for Canada / Northwest Territories
WARNING: missing population for Canada / Recovered
WARNING: missing population for Canada / Yukon
WARNING: missing population for World / Saint Kitts and Nevis
WARNING: missing population for World / Mali
WARNING: missing population for World / Guinea-Bissau
WARNING: missing population for World / Kosovo
WARNING: missing population for World / West Bank and Gaza
WARNING: missing population for World / MS Zaandam
WARNING: missing population for World / Burma

https://docs.google.com/spreadsheets/d/1e703pe3GmBQt0i2yAOS0F6Bhxy91U1-NTB6JMRSTzc0/edit?usp=sharing

Originally posted by @boogheta in https://github.com/boogheta/coronavirus-countries/issues/1#issuecomment-605720022

robindemourat commented 4 years ago

The data was just updated. New column was added for mentionning additional sources used to retrieve some populations.

Isn't the "Canada / Recovered" territory a glitch in the data ?

boogheta commented 4 years ago

It looks like it yes, will investigate! Thanks for all the rest! I fixed a remnant 5 that was at the end of id "Northwest Territories 5" in the Canada tab, can you check whether the 5 should have been in the population column?

boogheta commented 4 years ago

So I confirm, this is an issue on the source side, reported already by different people here: https://github.com/CSSEGISandData/COVID-19/issues/1800

WIll hardfix it in the data download on our side

robindemourat commented 4 years ago

@boogheta I confirm it does not come from the population column (it was a footnote in the scraped source) !

boogheta commented 4 years ago

I proposed a PR at the source https://github.com/CSSEGISandData/COVID-19/pull/1816 Hardfixing it for now

boogheta commented 4 years ago

Fixed in 008d7a6fdadbca3683ee5b630667c571a961f1b2 (and added population data for Botswana newly appeared)

boogheta commented 4 years ago

In prevision of current work in progress on #10, we're gonna need more population data for some countries regions, so I'm reopening this with a checklist that I will complete progressively.

robindemourat commented 4 years ago

I just added France's départments and Italy's province in the populations spreadsheet - I was not able to check if it is 100% aligned but it seems so mostly.

boogheta commented 4 years ago

Thank you!!