Talk:Country codes

Regions

Shall we list countries in alphabetical order by continents? Or further refer to regions like V-Dem (e.g. Central Africa, East/Horn of Africa etc.)

-> I think it would be good if the countries are listed alphabetically but the table has a column for regions and sub-regions to filter them. I would suggest to use the UN defintions for regions and sub-regions, see https://unstats.un.org/unsd/methodology/m49/

ND: Hm, not sure if the table gets too wide... Anyone else having a strong preference for including it?

FaB: I do not need it for this list, it does however make sense to have that as a variable in Wesis.

ND: Update on this topic: We are in the process of adding country groupings to WeSIS, but I still would not display them all here, as the table would get too wide (June 11, 2020)

Legacy list and December testing bug

ND: For the current testing, there is a "legacy" list in WeSIS that - unfortunately - does not recognize all "related entities"; we @A01 will fix it soon!

ND: It is fixed now (February 21, 2020)

Spelling Mistake in Bosnia and Herzegovina

I think there is a spelling mistake in one of the entries in the country table of Bosnia and Herzegovina (o instead of e). I cannot edit the page, would be great if someone who has access can correct it. Thanks!

ND: It is fixed now.

Code for Palestine

We suggest a code for Palestine: 667 Israel has 666, thats why we suggest this code

ND: The CoW code for Palestine is 665!

Code for Puerto Rico

We suggest a code for Puerto Rico: 43 Dominican Republic (regionally close) has 42

ND: The CoW code for Puerto Rico is 6!

FB: The Code is however not in the list in Wesispedia. Doesn't that give parsing errors?

ND: True. I will add it soon.

ND: It is fixed now.

Why ignore some countries

for example, we have data for North Vietnam during the split, why would we not incorporate this into Wesis? You have it listed as a related entry cow_code 817 there are other examples like this (eg., Serbia, Serbia and Montenegro)

ND: If there is a CoW code, you can upload it; in other words, 817 is valid for WeSIS!

Gran Colombia

It was a small empire including Ecuador, Panama and Venzuela <- these countries should be listed as 'related entities' no?

ND: But from what I can read of the CoW codebook this was prior to 1880, right? If so, it is missing as it is beyond the CRC's scope. If you, nevertheless want to upload data for it we should talk about adding it manually to the list of valid country-year observations. In this case just get in touch with us @A01.

East and West , North and South

Most of the data we have is radically different for East and West Germany. You have country codes for both (260 and 265), why not use them? Please let me upload data for both. We are throwing away both data and history by forcing Germany to be one code. Or please tell me how I am supposed to choose which data to upload. Should I upload data for East Germany for 1965 and have it coded as Germany (code number 355, i.e., West Germany)? This seems like a bad idea. Also if we ever go public with our data, this would really look not so good in my opinion.

ND: Of course you could use both - and should, as it was agreed upon to collect data as "disaggregated as possible". As 260 and 265 are valid CoW codes, you can upload data for both entities separately. In fact, because we rely on CoW, you can upload data for every entity that has a CoW code.

NB: Fixed, thank you. There is only one remaining issue I am encountering. It seems like "Republic of Vietnam" with country code 817 is not there, also in CoW, "Vietnam" should be 818, perhaps there is a mistake here? Otherwise I am able to upload all countries. Very nicely done!

ND: True. It has to do with the fact that the "related entities" were not covered in the initial list. We are working on fixing it!

ND: It is fixed now with the new version of WeSIS relying on the extendend entity list (June 11, 2020)

Missing values for related entities, such as "population over 500K"

Entities like Hong Kong only appear on the "related entity" column and therefore, the following values are not given for it: population over 500K, start-end, wiki URL

ND: This is related to the legacy list and we are working on updating and extending the list to have an entry for each entity on its own.

Country names (for Wesis upload)

We (A04) discovered when trying to upload data to Wesis that also the country names (not only cow codes) seem to be standardized according to how the name is written in cow. For other spelling of country names, an error is returned in the upload if we interpreted it correctly. Is that correct? Do we need to standardize the spelling of the country names as well? Another possibility would be to just add the respective country name to the cow code during the upload, but this maybe is too prone to mistakes?

ND: This is correct, it checks both the numeric code and the CoW-standardized name to prevent errors (e.g. transposed digits in the code). For some countries that actually changed their name, we will look into the possibility of having valid, alternative names. Until then, CoW names should be used as well.

Country-Code: Reunion

We (A05) have the first case of actually having data on a subnational unit. We want to have Reunion as an entity in WESIS. There is however no Cow-Code assigned to it, because it formally is a french department. We suggest to use 2201 (220 is France). This then needs to be added to the country-list becausde of validation, right? Who can do that?

Codes for Scotland, Northern Ireland, Wales

We propose to include Country Codes for Scotland, Northern Ireland, Wales. Sorry if we did not find it beforehand but we actually looked in most COW datsets and most importantly it is not in the Wesispedia list. I understand that it will give parsing errors if it is not included. We suggest to use the following codes based on the knowledge that United Kingdom = 200 and Ireland = 205: Scotland = 201, Wales: 202, Northern Ireland = 203. Please give us Feedback on that and then the Entity list in wesispedia should be uploaded.

Code for Cook Islands

The code for Cook Islands is missing either in COW and in our list. Since they are recognised by and/or member of several UN Organisations, I suggest to add them although they have less than 500000 inhabitants.