Name: OpenFlights Airports Database 2017
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

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

522.35 kB
7,698 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
);