Name: Airport Codes
Creator: Kaggle
License: https://opendatacommons.org/licenses/pddl/1.0/

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.69 MB
57,421 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.52 MB
76,517 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
);