For the upcoming release of iCapital 2.0 I needed a list of all the countries and capitals of the world in json format. I searched the web, but couldn’t find a proper solution until I found these lists on GitHub.
Sadly they only contained the countries of the world, so on a boring Sunday night, I’ve extended the list with all the capitals for those countries!
For those in need, I’ve created a SQL dump with all the cities of Belgium linked to their provinces in two tables (cities & provinces). Most SQL dumps have all the Belgian cities and provinces stored in one table which is not always very convenient.
Thanks to @anthonyvanoyen and @jverdeyen for pointing me to some start files.