Talk:Country codes - Revision history

Nils Duepont at 14:25, 18 August 2020

2020-08-18T14:25:35Z

Nils Duepont: /* Country-Code: Reunion */

2020-08-18T14:24:48Z

‎Country-Code: Reunion

Nils Duepont at 13:50, 18 August 2020

2020-08-18T13:50:24Z

Nils Duepont: /* Country name East Timor */

2020-08-18T13:49:07Z

‎Country name East Timor

Jenny Hahs: outdated country name Macedonia/North Macedonia

2020-06-30T17:28:07Z

outdated country name Macedonia/North Macedonia

Jenny Hahs: outdated country name Swaziland/Eswatini

2020-06-30T17:12:07Z

outdated country name Swaziland/Eswatini

Jenny Hahs: outdated country name for Bolivia/Plurinational State of Bolivia

2020-06-30T13:34:46Z

outdated country name for Bolivia/Plurinational State of Bolivia

Jenny Hahs: minor edit of my own comment

2020-06-30T13:17:24Z

minor edit of my own comment

Jenny Hahs: outdated country name for East Timor/Timor-Leste

2020-06-30T13:05:31Z

outdated country name for East Timor/Timor-Leste

Nils Duepont at 08:15, 16 June 2020

2020-06-16T08:15:12Z

@@ Line 56: / Line 56: @@
 == Gran Colombia ==
 It was a small empire including Ecuador, Panama and Venzuela <- these countries should be listed as 'related entities' no?
@@ Line 62: / Line 63: @@
 == 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.
@@ Line 94: / Line 96: @@
 ND: I'll keep it in mind, but for now we won't add it as it is a subnational unit and WeSIS (at least not now) is not prepared for subnational data. For such data one would need to define the relations to the federal state, define aggregation routines and rules for displaying the data. In short: for the database it is not just "simply" a new entity. Keep the data of course, maybe WeSIS will be extended and/or you could still publish the more encompassing data in a repository.
 == Codes for Scotland, Northern Ireland, Wales ==

@@ Line 93: / Line 93: @@
 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?
-ND: I'll keep it in mind, but for now we won't add it as it is a subnational unit and WeSIS (at least not now) is not prepared for subnational data. Fur such data one would need to define the relations to the federal state, define aggregation routines and rules for displaying the data. In short: for the database it is not just "simply" a new entity. Keep the data of course, maybe WeSIS will be extended and/or you could still publish the more encompassing data in a repository.
+ND: I'll keep it in mind, but for now we won't add it as it is a subnational unit and WeSIS (at least not now) is not prepared for subnational data. For such data one would need to define the relations to the federal state, define aggregation routines and rules for displaying the data. In short: for the database it is not just "simply" a new entity. Keep the data of course, maybe WeSIS will be extended and/or you could still publish the more encompassing data in a repository.
 == Codes for Scotland, Northern Ireland, Wales ==

@@ Line 106: / Line 106: @@
 == 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.
@@ Line 111: / Line 112: @@
 ND: It is fixed now in WeSIS and here, so it should be recognized (haven't tested it though) (June 16, 2020).
 == Country name East Timor ==
 The country name for East Timor seems to be pretty outdated. Wiki explains that in 2002 the country name changed into Timor-Leste:
 "On 27 September 2002, East Timor was renamed to Timor-Leste, using the Portuguese language, and was admitted as a member state by the UN. [...] The International Organization for Standardization (ISO) official short form in English and all other languages is Timor-Leste (codes: TLS & TL), which has been adopted by the United Nations,[21] the European Union,[22] and the national standards organisations of France (AFNOR), the United States (ANSI),[23] United Kingdom (BSI), Germany (DIN), and Sweden (SIS), all diplomatic missions to the country by protocol and the CIA World Factbook.[24]"
@@ Line 118: / Line 121: @@
 ND: I'll check what the status is; we @A01 already looked into the topic of using alternative names (as well), but we (aka Core Group?!) need to discuss for which "step" we would like to allow alternative names (for selecting data in WeSIS, even for downloading (what about time-series then?), already while uploading (also time-sensitive?!). I assume, for some steps it is easy to implement, others are probably much more difficult... (August 18, 2020)
 == Country name Bolivia ==
 Similar issue as with East Timor. The new official naming of Bolivia is the Plurinational State of Bolivia (from UN databases you usually get the output "Bolivia, Plurinational State of". We should be able somehow to recognize and use the up-to-date country names.
 == Country name Swaziland/Eswatini ==
 Swaziland is the outdated name for Eswatini: "On 19 April 2018, King Mswati III announced that the Kingdom of Swaziland had renamed itself the Kingdom of Eswatini, reflecting the extant Swazi name for the state eSwatini, to mark the 50th anniversary of Swazi independence. The new name, Eswatini, means "land of the Swazis" in the Swazi language and was partially intended to prevent confusion with the similarly named Switzerland.[10][11]"(source is also the wikipage)
 Consider also in this case to use the up-to-date countryname not only as "altname"?
 == Country name Macedonia ==
 New official name is North Macedonia.
 Wiki: "The vote to amend the constitution and change the name of the country passed on 11 January 2019 in favour of the amendment.[35] The amendment entered into force on 12 February, following the ratification of the Prespa agreement and the Protocol on the Accession of North Macedonia to NATO by the Greek Parliament.[36]"

@@ Line 116: / Line 116: @@
 "On 27 September 2002, East Timor was renamed to Timor-Leste, using the Portuguese language, and was admitted as a member state by the UN. [...] The International Organization for Standardization (ISO) official short form in English and all other languages is Timor-Leste (codes: TLS & TL), which has been adopted by the United Nations,[21] the European Union,[22] and the national standards organisations of France (AFNOR), the United States (ANSI),[23] United Kingdom (BSI), Germany (DIN), and Sweden (SIS), all diplomatic missions to the country by protocol and the CIA World Factbook.[24]"
 I've seen that the actual country name is renowned under the alt names category but would nevertheless suggest to use the up-to-date country name or politely insist on extending WeSIS' future capacity to use alternative country name schemes for the display of country-specific results.
 == Country name Bolivia ==

← Older revision		Revision as of 17:28, 30 June 2020
Line 123:		Line 123:
	Swaziland is the outdated name for Eswatini: "On 19 April 2018, King Mswati III announced that the Kingdom of Swaziland had renamed itself the Kingdom of Eswatini, reflecting the extant Swazi name for the state eSwatini, to mark the 50th anniversary of Swazi independence. The new name, Eswatini, means "land of the Swazis" in the Swazi language and was partially intended to prevent confusion with the similarly named Switzerland.[10][11]"(source is also the wikipage)		Swaziland is the outdated name for Eswatini: "On 19 April 2018, King Mswati III announced that the Kingdom of Swaziland had renamed itself the Kingdom of Eswatini, reflecting the extant Swazi name for the state eSwatini, to mark the 50th anniversary of Swazi independence. The new name, Eswatini, means "land of the Swazis" in the Swazi language and was partially intended to prevent confusion with the similarly named Switzerland.[10][11]"(source is also the wikipage)
	Consider also in this case to use the up-to-date countryname not only as "altname"?		Consider also in this case to use the up-to-date countryname not only as "altname"?
		+
		+	== Country name Macedonia ==
		+	New official name is North Macedonia.
		+	Wiki: "The vote to amend the constitution and change the name of the country passed on 11 January 2019 in favour of the amendment.[35] The amendment entered into force on 12 February, following the ratification of the Prespa agreement and the Protocol on the Accession of North Macedonia to NATO by the Greek Parliament.[36]"

← Older revision		Revision as of 17:12, 30 June 2020
Line 119:		Line 119:
	== Country name Bolivia ==		== Country name Bolivia ==
	Similar issue as with East Timor. The new official naming of Bolivia is the Plurinational State of Bolivia (from UN databases you usually get the output "Bolivia, Plurinational State of". We should be able somehow to recognize and use the up-to-date country names.		Similar issue as with East Timor. The new official naming of Bolivia is the Plurinational State of Bolivia (from UN databases you usually get the output "Bolivia, Plurinational State of". We should be able somehow to recognize and use the up-to-date country names.
		+
		+	== Country name Swaziland/Eswatini ==
		+	Swaziland is the outdated name for Eswatini: "On 19 April 2018, King Mswati III announced that the Kingdom of Swaziland had renamed itself the Kingdom of Eswatini, reflecting the extant Swazi name for the state eSwatini, to mark the 50th anniversary of Swazi independence. The new name, Eswatini, means "land of the Swazis" in the Swazi language and was partially intended to prevent confusion with the similarly named Switzerland.[10][11]"(source is also the wikipage)
		+	Consider also in this case to use the up-to-date countryname not only as "altname"?

← Older revision		Revision as of 13:05, 30 June 2020
Line 111:		Line 111:

	ND: It is fixed now in WeSIS and here, so it should be recognized (haven't tested it though) (June 16, 2020).		ND: It is fixed now in WeSIS and here, so it should be recognized (haven't tested it though) (June 16, 2020).
		+
		+	== Countrynaming East Timor ==
		+	The country name for East Timor seems to be pretty outdated. Wiki explains that in 2002 the country name changed into Timor-Leste:
		+	"On 27 September 2002, East Timor was renamed to Timor-Leste, using the Portuguese language, and was admitted as a member state by the UN. [...] The International Organization for Standardization (ISO) official short form in English and all other languages is Timor-Leste (codes: TLS & TL), which has been adopted by the United Nations,[21] the European Union,[22] and the national standards organisations of France (AFNOR), the United States (ANSI),[23] United Kingdom (BSI), Germany (DIN), and Sweden (SIS), all diplomatic missions to the country by protocol and the CIA World Factbook.[24]"
		+	I would suggest using the up-to-date country name or politely insist on extending WeSIS' capacity to use alternative country name schemes.

@@ Line 10: / Line 10: @@
 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 ==
@@ Line 16: / Line 17: @@
 ND: It is fixed now (February 21, 2020)
 == Spelling Mistake in Bosnia and Herzegovina ==
@@ Line 44: / Line 46: @@
 ND: It is fixed now.
 == Why ignore some countries ==
@@ Line 68: / Line 71: @@
 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" ==
@@ Line 74: / Line 78: @@
 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.
@@ Line 80: / Line 86: @@
 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.
+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 or typos in the country name). 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 ==
@@ Line 87: / Line 94: @@
 ND: I'll keep it in mind, but for now we won't add it as it is a subnational unit and WeSIS (at least not now) is not prepared for subnational data. Fur such data one would need to define the relations to the federal state, define aggregation routines and rules for displaying the data. In short: for the database it is not just "simply" a new entity. Keep the data of course, maybe WeSIS will be extended and/or you could still publish the more encompassing data in a repository.
 == Codes for Scotland, Northern Ireland, Wales ==
@@ Line 95: / Line 103: @@
 ND: Similar to the Reunion issue. In addition: those entities do neither have a CoW code nor an ISO code on their own; they only have subcodes such as GB-EAW or GB-SCT. Thus, we won't add it for now, but keep the data!
 == Code for Cook Islands ==
@@ Line 100: / Line 109: @@
 ND: True. The CoW code is 925. I will add it to the list but it may take a while until the validation will recognize this new entity.