List of world countries, as MySQL dump, with national flags

Get the latest updates on this project via RSS

You are currently browsing comments. If you would like to return to the full story, you can read the full entry here: “List of world countries, as MySQL dump, with national flags”.

28 responses to “List of world countries, as MySQL dump, with national flags”

Follow the comments via RSS
  •, 2011-06-27, 12:33

    List of world countries, with national flags…

    A list of world’s countries as an SQL file containing the official short names in English as given in ISO 3166-1, the ISO 3166-1-alpha-2 code provided by the International Organization for Standardization and the ISO alpha-3 code provided by the United…

  •, 2011-12-23, 11:35

    Is possible add a telephone area code with country?


    • Stefan Gabos, 2011-12-24, 04:25

      i’ll look into it. thanks

  • Martin, 2012-08-14, 00:54

    Thanks a lot!!

  • Rubi86, 2012-11-02, 00:36

    Thank you very much!

  • 4D4M4STOS, 2012-12-01, 16:50

    Thanks, Dude! Great job!

  • JACKMAN, 2012-12-03, 18:34

    missing one: South Sudan SS SSD 728 ISO 3166-2:SS

    • Stefan Gabos, 2012-12-05, 22:04

      thanks! I’ll update the list

  • Nikola, 2013-01-11, 03:49

    Thank you very much Stefan!

    This is of great help for me at the moment.
    Greetings from Belgrade.

  • Emil, 2013-02-09, 13:02

    I don’t know which, but you are maybe missing 8 countries? According to this list at least:

  • Ndiritu N, 2013-08-01, 20:20

    Thanks for maintaining this and sharing it.

  • Alexander Bondarenko, 2013-08-08, 19:22

    Please add missing alpha-3 codes for Antarctica, Bouvet Island etc. All info available at wiki page:

    • Stefan Gabos, 2013-08-08, 19:56

      Now I am confused: my source is which seems like trustful enough…should I trust Wikipedia?

    • Alexander Bondarenko, 2013-08-11, 21:09

      I found the alpha-3 codes you’re missing not just on wiki website. Check this page for example:

    • Stefan Gabos, 2013-08-12, 06:45

      oh, i can find them anywhere, that’s not the problem. the problem is that my source seems to be a more trustworthy one when compared to wikipedia or the other one. and it also seems that the list is up to date as of February 2013

  • Michael, 2013-12-03, 10:36

    thanks for the list its great

  • maniax willie, 2014-04-02, 16:11

    Hello. Someone help me on how to import them to my db.

  • Gvanto, 2014-09-29, 09:28

    Thanks very much for awesome list & images too. Do you by any chance have images larger than 16×16 of these countries?

  • MRG, 2014-11-12, 00:33

    Iti multumesc! Mi-ai usurat munca!

    Succes in proiecte!

  • Ferdinand, 2016-01-29, 07:47

    Hi Stefan Gabos!
    Great Job and thank you!
    In the flags-package 24×24 the do.png (Dominican Republic) is the wrong size (64×64)
    kind regards to Bucharest 😉

    • Stefan Gabos, 2016-01-29, 09:41

      Thanks – it is fixed now

Leave a Reply

Your email address will not be published
You can use <strong>, <em>, <a>, <img>, <code>
Characters are not case-sensitive