Dataset: Airport Codes

About this Dataset

Airport Codes

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).

Tables

Airport Codes

@kaggle.joebeachcapital_airport_codes.airport_codes

3.52 MB
57421 rows
12 columns


CREATE TABLE airport_codes (
  "ident" VARCHAR,
  "type" VARCHAR,
  "name" VARCHAR,
  "elevation_ft" DOUBLE,
  "continent" VARCHAR,
  "iso_country" VARCHAR,
  "iso_region" VARCHAR,
  "municipality" VARCHAR,
  "gps_code" VARCHAR,
  "iata_code" VARCHAR,
  "local_code" VARCHAR,
  "coordinates" VARCHAR
);

Airports

@kaggle.joebeachcapital_airport_codes.airports

5.27 MB
76517 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
);