Dataset: OpenFlights Route Database 2014

About this Dataset

OpenFlights Route Database 2014

Context

As of June 2014, the OpenFlights/Airline Route Mapper Route Database contains 67663 routes between 3321 airports on 548 airlines spanning the globe

Content

Each entry contains the following information:
Airline,Airline ID,Source airport,Source airport ID,Destination airport,Destination airport ID,Codeshare,Stops,Equipment

The OpenFlights Airport, Airline, Plane and Route Databases are made available under the Open Database License. Any rights in individual contents of the database are licensed under the Database Contents License.

Notes:
Routes are directional: if an airline operates services from A to B and from B to A, both A-B and B-A are listed separately.
Routes where one carrier operates both its own and codeshare flights are listed only once.

Sample entries
BA,1355,SIN,3316,LHR,507,,0,744 777
BA,1355,SIN,3316,MEL,3339,Y,0,744
TOM,5013,ACE,1055,BFS,465,,0,320

Acknowledgements

Data taken from - OpenFlights
Airport base data was generated by from DAFIF (October 2006 cycle) and OurAirports, plus timezone information from EarthTools. All DST information added manually. Significant revisions and additions made by the users of OpenFlights.

Tables

Routes

@kaggle.divyanshrai_openflights_route_database_2014.routes

476.43 KB
67663 rows
9 columns


CREATE TABLE routes (
  "airline" VARCHAR,
  "airline_id" VARCHAR,
  "source_airport" VARCHAR,
  "source_airport_id" VARCHAR,
  "destination_airport" VARCHAR,
  "destination_airport_id" VARCHAR,
  "codeshare" VARCHAR,
  "stops" BIGINT,
  "equipment" VARCHAR
);