Airline Route Database


In order to facilitate my job as an airline award travel consultant at JuicyMiles (now Points.me), I created a database of worldwide commercial airline routes that could be booked with airline miles. I designed a Python script that scraped airline route data from Wikipedia and cleaned and published this data to an SQL server. I created an additional Python script that could take an origin and destination airport as input and provide a list of possible connecting itineraries grouped by airline partnerships and alliances.at JuicyMiles (now Points.me), I created a database of worldwide commercial airline routes that could be booked with airline miles.

Date: December 2016 - October 2017