Dataset: AirStats: Data On Airports Around The World

About this Dataset

AirStats: Data On Airports Around The World

Content

The airport codes may refer to either IATA
airport code, a three-letter code which is used in passenger reservation, ticketing and baggage-handling systems, or the ICAO airport code
which is a four letter code used by ATC systems and for airports that do not have an IATA airport code (from wikipedia).

Airport codes from around the world. Downloaded from public domain source http://ourairports.com/data/ who compiled this data from multiple different sources. This data is updated nightly.

Data

"airports.csv" contains the list of all airport codes. Some of the columns contain attributes identifying airport locations, other codes (IATA, local if exist) that are relevant to identification of an airport.

License

The source specifies that the data can be used as is without any warranty. Given size and factual nature of the data and its source from a US company would imagine this was public domain and as such have licensed the Data Package under the Public Domain Dedication and License (PDDL).

Tables

Airports

@kaggle.patrasaurabh_airstats_data_on_airports_around_the_world.airports

4.63 MB
67312 rows
18 columns


CREATE TABLE airports (
  "id" BIGINT,
  "ident" VARCHAR,
  "type" VARCHAR,
  "name" VARCHAR,
  "latitude_deg" DOUBLE,
  "longitude_deg" DOUBLE,
  "elevation_ft" DOUBLE,
  "continent" VARCHAR,
  "iso_country" VARCHAR,
  "iso_region" VARCHAR,
  "municipality" VARCHAR,
  "scheduled_service" VARCHAR,
  "gps_code" VARCHAR,
  "iata_code" VARCHAR,
  "local_code" VARCHAR,
  "home_link" VARCHAR,
  "wikipedia_link" VARCHAR,
  "keywords" VARCHAR
);

Countries

@kaggle.patrasaurabh_airstats_data_on_airports_around_the_world.countries

15 KB
247 rows
6 columns


CREATE TABLE countries (
  "id" BIGINT,
  "code" VARCHAR,
  "name" VARCHAR,
  "continent" VARCHAR,
  "wikipedia_link" VARCHAR,
  "keywords" VARCHAR
);

Regions

@kaggle.patrasaurabh_airstats_data_on_airports_around_the_world.regions

165.08 KB
3963 rows
8 columns


CREATE TABLE regions (
  "id" BIGINT,
  "code" VARCHAR,
  "local_code" VARCHAR,
  "name" VARCHAR,
  "continent" VARCHAR,
  "iso_country" VARCHAR,
  "wikipedia_link" VARCHAR,
  "keywords" VARCHAR
);