Dataset: OpenFlights Airports Database 2017

About this Dataset

OpenFlights Airports Database 2017

Context

As of January 2017, the OpenFlights Airports Database contains over 10,000 airports, train stations and ferry terminals spanning the globe

Content

Each entry contains the following information:
Airport ID, Name, City, Country, IATA, ICAO, Latitude, Longitude, Altitude, Timezone, DST, Database Timezone, Type, Source

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.

This data is not suitable for navigation

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

Airports

@kaggle.divyanshrai_openflights_airports_database_2017.airports

510.1 KB
7698 rows
14 columns


CREATE TABLE airports (
  "airport_id" BIGINT,
  "name" VARCHAR,
  "city" VARCHAR,
  "country" VARCHAR,
  "iata" VARCHAR,
  "icao" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "altitude" BIGINT,
  "timezone" VARCHAR,
  "dst" VARCHAR,
  "database_timezone" VARCHAR,
  "type" VARCHAR,
  "source" VARCHAR
);