December 2018
Intermediate to advanced
642 pages
15h 5m
English
Getting a list of countries was easy: I used the data from https://github.com/datasets/country-codes, which I pruned down to just the country two-character code (as in the ISO 3166-1 norm) and name. For regions and cities, I used GeoNames' data from http://download.geonames.org/export/dump/; in particular, I used admin1CodesASCII.txt, which I reworked into regions.csv, and cities15000.zip, which I edited into cities.csv.
What you need to know about these three tables is as follows:
Read now
Unlock full access