Countries with their (ISO 3166-1) Alpha-2 code, Alpha-3 code, UN M49, average latitude and longitude coordinates

countries_codes_and_coordinates.csv

Thank you so much for putting this together.

For those who, like me, has got problem with quoted numbers, spaces and duplicates with Pandas:

coord = pd.read_csv('https://gist.githubusercontent.com/tadast/8827699/raw/f5cac3d42d16b78348610fc4ec301e9234f82821/countries_codes_and_coordinates.csv', doublequote=False)
for c in coord.columns:
    coord[c] = coord[c].str.replace('"', "").str.strip()

for c in ['Longitude (average)', 'Latitude (average)']:
    coord[c] = coord[c].astype(float)

coord = coord.drop_duplicates(subset=['Alpha-3 code'], keep='first')

Longitude and Latitude are now floating, it removes double quotes and strip strings, and it also removes duplicates by keeping the first one. The new dataframe has length 244 instead of 256.

Removed duplicates, and floating point values, striped string... Usable with Pandas:

https://gist.github.com/metal3d/5b925077e66194551df949de64e910f6

Generated with the code I gave above.

Thanks to the original author 😄

"Viet Nam" is correct one. Should remove "Vietnam"

Thanks!
However, Netherlands Antilles is not part of iso anymore...

Netherlands Antilles	AN	ANT	530	12.25	-68.75

Very very handy indeed. In addition to the suggestions made by @vtamara I found another one missing:

XK Kosovo 42.5773 20.8905

Not sure whether it's ISO since Kosovo being a state is disputed. Anyway I encountered it in a large dataset. Provided coordinates are as given on wikipedia.

Very very handy indeed. In addition to the suggestions made by @vtamara I found another one missing:

XK Kosovo 42.5773 20.8905

Not sure whether it's ISO since Kosovo being a state is disputed. Anyway I encountered it in a large dataset. Provided coordinates are as given on wikipedia.

What is the ISO Code for Kosovo? I cannot find in https://en.wikipedia.org/wiki/List_of_ISO_3166_country_codes

https://en.m.wikipedia.org/wiki/.xk

It's a temporary code due to the status of Kosovo being disputed.

There's a lot more of unassigned and user assigned / temporary codes to be found at https://en.m.wikipedia.org/wiki/ISO_3166-1_alpha-2

Adding missing:

Wallis and Futuna, WF, WFL with ISO Code 876, latitude -13.283333, longitude -176.183333

I copied this without duplicates and with the improvements in:
https://gitlab.com/pasosdeJesus/division-politica/-/blob/main/PAISES_ISO_2022-ampliado.csv

Besides I added:

• Name in french and name in english corrected based on https://www.iso.org/obp/ui/
• Name in spanish based specially in Wikipedia.

Your Pull Requests are welcome there.

Thank you @trilobiet

@TobiasGoerke thanks. Feel free to use it as if it's under The MIT license.

Thanks

Hi. This is useful. Is there a similar list but in JSON format?

Hi. This is useful. Is there a similar list but in JSON format?

https://csvjson.com/csv2json

Missing countries

"Åland Islands", "AX", "ALA", "248",  "60.116667", "19.9"
"Bonaire, Sint Eustatius and Saba", "BQ', "BES", "535", "12.183333", "-68.233333"
"Curaçao", "CW, "CUW", "531", "12.166667", "-68.966667"
"Saint Barthélemy", "BL", "BLM", "652", "17.897728", "-62.834244"
"Saint Martin (French part)", "MF", "MAF", "663", "18.075278", "-63.06"
"Sint Maarten (Dutch part)", "SX", "SXM", "534", "18.033333", "-63.05"
"Kosovo", "XK", "XKX", "-1", "42.583333", "21"

I can't find numeric code for Kosovo

thanks for this. Here is javascript object literal version if anyone needs. (includes flags :D)
https://gist.github.com/Fanna1119/955dc26ffee95b96978beb0150cb78f6

Vietnam appears twice in the file:

For Kosovo:
"Kosovo", "XK", "XKX", "095"