awesome-data icon indicating copy to clipboard operation
awesome-data copied to clipboard

Published 20 hours ago • verified publisher icon datasets

UN M.49 3-digit area codes

Open rufuspollock opened this issue 8 years ago • 11 comments

UN M.49 is a standard for 3-digit area codes used by UN for statistical purposes. These codes refer a wide variety of geographical, political, or economic regions including continents and countries, and codes for countries correspond to ISO 3166-1 Alpha-3.

rufuspollock avatar May 04 '16 20:05 rufuspollock

@jgkim could you update on your scraping efforts here?

rufuspollock avatar May 04 '16 20:05 rufuspollock

@rgrp Sorry for the late reply. The work I've been doing can be found at https://github.com/jgkim/country-data-package. I scraped codes for geographical regions only. It is a JSON data package, but I guess it can be easily converted into CSV or other forms.

jgkim avatar May 11 '16 07:05 jgkim

@jgkim we would need it in CSV. Can you convert it over?

rufuspollock avatar May 12 '16 10:05 rufuspollock

@rgrp @jgkim I could try writing python script, that takes already scraped JSON data as input and outputs CSV file, if @jgkim would like to receive PR. As a first glance CSV file would look something like this (for continents.json):

unM49Code,wikipediaSlug,wikidataId,geoNamesId,country,wikipediaLabel,officialName,alternateName,name,larirude,longtitude
002,Africa,Q15,6255146,en,Africa,Africa,Africa,7.1881,21.09375
002,Africa,Q15,6255146,de,Afrika,,Africa,7.1881,21.09375
002,Africa,Q15,6255146,en,Afrique,,Afrique,Africa,7.1881,21.09375
...
...
009,Oceania,Q538,6255151,jam,Uoshania,,Oceania,-18.31281,138.51562

zelima avatar Jul 05 '16 13:07 zelima

@jgkim would be great if you were up for contributing (@zelima can support if needed).

rufuspollock avatar Jul 06 '16 11:07 rufuspollock

@jgkim Did you have chance to look at this?

zelima avatar Aug 08 '16 08:08 zelima

@zelima Sorry for being late. I didn't have a chance to see this, and actually really really busy these days. I'm so sorry for that. :(

Do you want to make a PR to the existing my personal repo? What about forking or making a new repo in this organization datasets? @rgrp

jgkim avatar Aug 13 '16 10:08 jgkim

@jgkim That's ok, think I can help with finishing this one. :) I'll make PR as soon as I have script ready and we can transfer to datasets org after.

zelima avatar Aug 16 '16 08:08 zelima

@jgkim i'd suggest transferring the repo into the datasets org if we can? If you can make @zelima an admin on your repo he can do that for you - and then he can add you as an admin here ...

rufuspollock avatar Sep 13 '16 08:09 rufuspollock

@zelima What do you think? Are you still working on it? I'm OK with transferring the repo. @rgrp

jgkim avatar Sep 19 '16 08:09 jgkim

@jgkim I have problem with finding time for now, but I'll finish as soon as I find one

zelima avatar Sep 19 '16 11:09 zelima