For some context, please read the article "Isdal Woman: Connecting the Scattered Dots"! 😃

Isdal Woman Travel dataset

This script generates a SQLite database containing place names, geolocation and airport / train station information - to facilitate analysis on the notes of the "Isdal woman". You can read more about the case of the Isdal Woman here.

Generating the dataset

• Go to GeoNames and download the file called allCountries.zip
• Go to OpenDataSoft and download the file containing the list of european train stations, european-train-stations.csv
• Go to openflights.org and download the file containing the OpenFlights Airports Database, airports-extended.dat
• Copy all files downloaded above to the data/ directory
• Run load-data.py
• The database will be saved to isdal-geo.sqlite