Adding continent codes for countries about country-codes HOT 13 CLOSED

@ewheeler any thoughts - would you be happy to get a pull request here?

from country-codes.

@zelima @rgrp absolutely! great suggestion

from country-codes.

@rgrp the best way would be to add the data manually, right?
Working directly with CSV file - adding one last column with name "Continent" and filling with data one by one

from country-codes.

@zelima it would be worth scripting this - the overall built is scripted so hand done stuff may get lost: https://github.com/datasets/country-codes/tree/master/scripts

Probably you want a separate csv which matches country ids to continents and we merge that into the final CSV as part of the build.

from country-codes.

@zelima @rgrp
i agree. i've been meaning to refactor the existing script and have the process executed by a makefile so that we can accommodate a cleaner build process that would let us substitute upstream sources more easily.
generating a separate csv that can be merged would be ideal at this point

from country-codes.

@rgrp @ewheeler Ok, got it. Will start as soon as I find time.

from country-codes.

Please consider using Unicode CLDR resources here instead:

http://www.unicode.org/repos/cldr/trunk/common/supplemental/subdivisions.xml

from country-codes.

I have done the scripts and data generation based on UN M.49 region categorization by two sources: United Nations Statistics Division and Unicode CLDR.
https://github.com/hanteng/m49

The integrated table here: https://github.com/hanteng/m49/blob/master/data/_cf_m49_cldr__join.tsv

In the table, "left" refers to the data provided by United Nations Statistics Division whereas 'right' refers to the data provided by Unicode CLDR

from country-codes.

@rgrp @ewheeler
Datapackage for country-continents is ready.
You can view data here
Repository itself
Could you suggest how to merge with country-codes?

from country-codes.

Thanks, @zelima !

I've adapted your script here: 2ab638a

Once I finish a bit of testing, we'll get these in.

from country-codes.

@ewheeler Great!

from country-codes.

What about transcontinental countries such as Russia? It is in Asia and Europe. Not only Europe. In fact, most of it's land is in Asia. I think it should be a one-on-multiple relation, right? Any official reference on this?

See: https://en.wikipedia.org/wiki/List_of_transcontinental_countries

from country-codes.

The UN places Russian Federation squarely in Europe (https://unstats.un.org/unsd/methodology/m49/ select 'geographic regions') but wikipedia has them (unofficially) aggregated in both: https://en.m.wikipedia.org/wiki/List_of_sovereign_states_and_dependent_territories_by_continent_(data_file)

Unfortunately there appears to be no ISO standard.

from country-codes.