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

countries_codes_and_coordinates.csv

Oh you saved me so much time 🙇‍♂️ ❤️ 🚀

Found something new that was added in 2011 😅

Country: South Sudan
iso2-alpha2: SS
iso3-alpha3: SSD

• Countries codes and coordinates XML version
• Countries codes and coordinates JSON version
• Countries codes and coordinates CSV version
• Countries codes and coordinates Markdown table version
• Countries codes and coordinates HTML table version
• Countries codes and coordinates LaTex table version
• Countries codes and coordinates create and insert sql version
• Countries codes and coordinates plain text table version

This is brilliant! thanks so much

BRN CIV LBY MMR RUS VCT TTO and VNM is duplicate. Should it be merged?

@Thaina well spotted :) I don't remember the source of this or the reason I created this gist, but the country names seem to be different, this is perhaps to accommodate UI drop down lists where a user might search their country based on either of the two names?

@tadast I just try to use your file to create dictionary by country code. It error so I have log to log a list of duplication

@Thaina, feel free to fork this gist, remove the duplicates and link to your fork in the comments, people who have the same use-case as you will find it useful. Thanks :)

@tadast nice work, thanks!
How about a licence? Is your list dedicated to the public domain?

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

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

Great, thanks!

Thanks!

Can you add south sudan??

@msgoussi if you could please fork this gist and add South Sudan, I can port it back to "master" :) Thanks

@tadast I do not know about forking. Also what is your lat and long source, so i can get South Sudan coordinates for consistency issues.

@msgoussi sorry, I don't remember where I got this data from, this whole gist was supposed to be helpful only for future self, but it looks people come here from google and use it.

I've added South Sudan data based on info on https://en.wikipedia.org/wiki/South_Sudan

Trinidad and Tobago appears two times.

been looking everywhere for these, thank you so much!!

This is very helpful, thank you very much!

Thanks for this file, really helpful 👍

A more official but less parsable list is here: https://www.iana.org/domains/root/db

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.

In this list I don't see: ÅLAND (AX), INDIA (IN), CURAZAO (CW), SINT MAARTEN (SX), CARIBE NEERLANDES (BQ), SAN BARTOLOME (BL), SAN 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 😄