search

open-numbers / ddf--gapminder--co2_emission

0 stars 5 forks source link

Country Names in CDIAC but not in gapminder's geo domain #1

Open semio opened 7 years ago

semio commented 7 years ago

Here is a list of country names in CDIAC but not found in gapminder's geo domain. We need to find out the geo id for these countries. They are also mentioned in https://github.com/semio/ddf--gapminder--geo_entity_domain/issues/1#issuecomment-239717329

jheeffer commented 7 years ago

Okay! And conversely, and maybe more importantly, are all geo's in gapminder entity domain covered? That's what we need to construct this dataset (though the above list is also good to see if we're missing some or need to do aggregrations etc).

semio commented 7 years ago

Ah, didn't check that. I will take a look

semio commented 7 years ago

@jheeffer here is the countries not covered:

country
ala                                                         Åland
mmr                                                       Myanmar
yem_north                                    North Yemen (former)
hkg                                              Hong Kong, China
sgero_a_ssandw       South Georgia and the South Sandwich Islands
myt                                                       Mayotte
north_mar                                       Northern Marianas
sosset                                              South Ossetia
yug                                                    Yugoslavia
gbm                                                   Isle of Man
maf                                      St. Martin (French part)
vir                                         Virgin Islands (U.S.)
bouisl                                              Bouvet Island
pse_west_bank                                           West Bank
chanisl                                           Channel Islands
fra_antarc                    French Southern and Antarctic Lands
heard_a_mcd                            Heard and McDonald Islands
asm                                                American Samoa
deu_east                                             East Germany
pse_gaza                                               Gaza Strip
transn                                               Transnistria
virg_isl                                           Virgin Islands
som_somland                                            Somaliland
mco                                                        Monaco
nfk                                                Norfolk Island
usa_minor_out_isl                       US Minor Outlying Islands
akr_a_dhe                                   Akrotiri and Dhekelia
kos                                                        Kosovo
abkh                                                     Abkhazia
yem_south                                    South Yemen (former)
ata                                                    Antarctica
stbar                                              St. Barthélemy
sjm                                                      Svalbard
deu_west                                             West Germany
nld_curacao                                               Curaçao
cck                                                  Cocos Island
mnp                                      Northern Mariana Islands
fra_clipperton                                         Clipperton
pcn                                                      Pitcairn
esh                                                Western Sahara
jey                                                        Jersey
sxm                                     Sint Maarten (Dutch part)
stmar                                                  St. Martin
mac                                                  Macao, China
bol                                                       Bolivia
scg                                         Serbia and Montenegro
iot                                British Indian Ocean Territory
ssd                                                   South Sudan
tkl                                                       Tokelau
gbg                                                      Guernsey
smr                                                    San Marino
hos                                                      Holy See
scg_ex_kos                                Serbia excluding Kosovo
gum                                                          Guam
tuv                                                        Tuvalu
ngokar                                            Ngorno-Karabakh
eri_a_eth                                    Eritrea and Ethiopia
cyp_nor                                           Northern Cyprus
jheeffer commented 7 years ago

Let's first of all make this list (or did you do it in a different/better way before?) I made the following overview of all unmapped geo's

https://docs.google.com/spreadsheets/d/1MY4mnYHubQjrS-AOcz5q00J51_q4LJm_IYcqCdvQCts/edit#gid=0

Three things needed:

semio commented 7 years ago

pushed commit fc0b28c for merge/split countries