search

stefangabos / world_countries

Constantly updated lists of world countries and their associated alpha-2, alpha-3 and numeric country codes as defined by the ISO 3166 standard, available in CSV, JSON , PHP, SQL and XML formats, in multiple languages and with national flags included; also available are the ISO 3166-2 codes of provinces/ states associated with the countries
http://stefangabos.github.io/world_countries/
Other
1.34k stars 374 forks source link

Looks like St Helen is missing #59

Closed Dom911 closed 2 years ago

Dom911 commented 2 years ago

Hi,

the country(?) St Helen is missing: Saint Helena (and/or) Ascension Island (and/or) Tristan da Cunha

ISO 3166-1 Alpha-2 code: SH Alpha-3 code: SHN Numeric code: 654

stefangabos commented 2 years ago

It's not, it is in the world.* files

Dom911 commented 2 years ago

Yes, I have seen that it was some times present but not always like in bg and others (present in pl). I guess that some other country translations are missing too in other languages (need to be checked).

In order to find the missing items, you would have to add a field in all the world.sql files. This field will contain the language in which the countries have been translated. After that it will be possible to search for the missing translations (1st use count, then if one or more are missing then join between 2 tables)

PS: Thanks for your valuable work ! There maybe an item or more missing but your work is great !!