owid / owid-datasets Goto Github PK

Hi there,

First off huge thanks for the work you're doing at OWID. It's one of my favorite projects out there. I'm delighted that you've also taken steps to make this data available here on github.

I've been trying to prototype my own data exploration tool, and I'd love to offer some of the datasets for users to explore. I've been noticing that there are a bunch of entries (59) where the output CSV seems to have existed at one point, but then was removed by a later commit. The folder + datapackage.json still exist, it's only the CSV output that seems to be gone.

Was the goal to remove those CSVs, or was it a mistake? And if it's intentional, is the idea that I should start fetching data from the datapackage.json files directly?

Thank you!

https://ourworldindata.org/grapher/annual-number-of-deaths-by-cause?country=~OWID_WRL lists "Nutritional deficiencies" and
"Protein-energy malnutrition" with ~500,000 deaths in 2017, source being http://ghdx.healthdata.org/gbd-results-tool.

Other sources say those numbers are in the 5-9 millions:

• https://www.oxfam.org/en/press-releases/six-fold-increase-people-suffering-famine-conditions-pandemic-began
• https://www.dailysabah.com/world/7m-people-died-of-hunger-in-2020-world-food-programme-says/news
• https://www.npr.org/sections/coronavirus-live-updates/2020/05/05/850470436/u-n-warns-number-of-people-starving-to-death-could-double-amid-pandemic?t=1633419705488

Is there a mistake in the GBD data or am I missing something?

Hi, thanks for your work!

It will be very interesting to "join" several datasets and study correlations among possibly vastly different topics such as sanitation and transportation. Using the 3-letter ISO country code as the joining key between different tables (instead of the full country name) would make it much easier. Therefore I wrote a small program country-encode.py to prepend every row with the 3-letter code and the continent in which the country is located. Might it be possible to integrate this idea and code into the entire dataset?

BTW, during the process I found that "Faroe Islands" are misspelled as "Faeroe Islands" in some files. Presently I see 52 files have this problem using this command: grep -l Faeroe */*.csv | wc