Is there somewhere a Yaml or SQL insert list of all countries?

Question

Possible Duplicate:
Where can I get a list of all countries/cities to populate a listbox?

I am looking for a script to create all the countries. Somebody knows an free ISO list i can easily use in Ruby?

I can find lists on google but I am not lucky with a yaml, csv or SQL inserts.

I am also very interested in all the cities in Spain.

EDIT: Countries + Country code

Edit2: Just interested in all cities of Spain.

Is this any good: http://www.iso.org/iso/list-en1-semic-3.txt ? — matt, Mar 26 '11 at 20:02

score 6 · Accepted Answer · answered Mar 26 '11 at 19:28

6

I believe this is what you're looking for: http://download.geonames.org/export/dump/

answered Mar 26 '11 at 19:28

roberttdev

42,762
2
20
23

Thanks for this! That list is perfect if i want to have the cities for the country. Now only the list of Countries. – Michael Koper Mar 26 '11 at 19:42

mrcook · Answer 2 · 2011-08-21T13:27:09.947

I've just been searching for something similar myself and came across the World Countries API, which has a link there to a JSON file; http://www.geognos.com/api/en/countries/info/all.json.

You can also pull out info on a per country basis. Here's Spain; http://www.geognos.com/api/en/countries/info/ES.json

One really nice thing about this API is that it provides plenty more info than the basic country name/code. Here's an example of the output;

"ES": {
   "Name": "Spain",
   "Capital": {
      "DLST": 1,
      "TD": 1,
      "Flg": 2,
      "Name": "Madrid",
      "GeoPt": [
         40.24,
         -3.41
      ]
   },
   "GeoRectangle": {
      "West": -18.169641,
      "East": 4.3153896,
      "North": 43.791725,
      "South": 27.638817
   },
   "SeqID": 66,
   "GeoPt": [
      40,
      -4
   ],
   "TelPref": "34",
   "CountryCodes": {
      "tld": "es",
      "iso3": "ESP",
      "iso2": "ES",
      "fips": "SP",
      "isoN": 724
   },
   "CountryInfo": "http://www.geognos.com/geo/en/cc/es.html"
},

I didn't look but perhaps they have cities per country info.

It's also a shame they don't include the native language(s) that are spoken but hey, it's still a good resource.

P.S. I know you asked for YAML, but you can use JSON in Ruby and there are also YAML/JSON converters about.

score 1 · Answer 3 · answered Mar 26 '11 at 19:28

1

If CSV is okay, this is based on ISO 3166: http://www.guavastudios.com/downloads/countries/countries.csv

answered Mar 26 '11 at 19:28

Rafe Kettler

75,757
21
156
151

Thanks for your answer. Looks very nice but it is without country code. Sorry didnt mention that in the question. I updated my question – Michael Koper Mar 26 '11 at 19:41

score 0 · Answer 4 · answered Mar 06 '12 at 14:43

0

A great place to find this kind of data is http://thedatahub.org/ service. It supports a RESTful API.

answered Mar 06 '12 at 14:43

Aleksander Pohl

1,675
10
14

Is there somewhere a Yaml or SQL insert list of all countries?

4 Answers4