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! Saved me a lot of time 😃

Hi,
If anyone needs a list without duplicates, I've made one:
https://gist.github.com/cpl/3dc2d19137588d9ae202d67233715478

Cheers for the original!

THX 🤩

Woohooo! Great job mate, I was really looking for this list!

Hello @tadast , and thanks for putting this up.

I forked and added duplicate lines for complete https://en.wikipedia.org/wiki/ISO_3166-1 text label coverage in addition to to the short names you used.

Please consider this a pull request 😄

Thanks a lot.

Comparing with https://en.wikipedia.org/wiki/List_of_ISO_3166_country_codes

In this list I don't see: ÅLAND ISLANDS (AX), INDIA (IN), CURAZAO (CW), SINT MAARTEN (SX), BONAIRE, SINT EUSTATIUS, SABA (BQ), SAINT BARTHÉLEMY (BL), THE COLLECTIVITY OF SAINT-MARTIN (MF).

Some coordinates randomly inside each one are:

AX 60.2, 19.9
IN 17, 77
CW 12.2, -69
SX 18.05, -63.05
BQ 12.2, -68.3
BL 17.9, -62.85
MF 18.1, -63.05

Russia (RUS) is duplicate. Fix please

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"

Thanks

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.

This is helpful, thank you

Anyone seen the same list of coordinates but for the capitals, instead of the average coordinates for the countries?