Dataset: Airports, Train Stations, And Ferry Terminals

About this Dataset

Airports, Train Stations, And Ferry Terminals

Context

This is a database of airports, train stations, and ferry terminals around the world. Some of the data come from public sources and some of it comes from OpenFlights.org user contributions.

Content

Airport ID Unique OpenFlights identifier for this airport.
Name Name of airport. May or may not contain the City name.
City Main city served by airport. May be spelled differently from Name.
Country Country or territory where airport is located. See countries.dat to cross-reference to ISO 3166-1 codes.
IATA 3-letter IATA code. Null if not assigned/unknown.
ICAO 4-letter ICAO code.
Null if not assigned.
Latitude Decimal degrees, usually to six significant digits. Negative is South, positive is North.
Longitude Decimal degrees, usually to six significant digits. Negative is West, positive is East.
Altitude In feet.
Timezone Hours offset from UTC. Fractional hours are expressed as decimals, eg. India is 5.5.
DST Daylight savings time. One of E (Europe), A (US/Canada), S (South America), O (Australia), Z (New Zealand), N (None) or U (Unknown). See also: Help: Time
Tz database time zone Timezone in "tz" (Olson) format, eg. "America/Los_Angeles".
Type Type of the airport. Value "airport" for air terminals, "station" for train stations, "port" for ferry terminals and "unknown" if not known.
Source Source of this data. "OurAirports" for data sourced from OurAirports, "Legacy" for old data not matched to OurAirports (mostly DAFIF), "User" for unverified user contributions. In airports.csv, only source=OurAirports is included.

Acknowledgements

This dataset was downloaded from Openflights.org under the Open Database license. This is an excellent resource and there is a lot more on their website, so check them out!

Tables

Airports Extended

@kaggle.open_flights_airports_train_stations_and_ferry_terminals.airports_extended

664.49 KB
10667 rows
14 columns


CREATE TABLE airports_extended (
  "n_1" BIGINT,
  "goroka_airport" VARCHAR,
  "goroka" VARCHAR,
  "papua_new_guinea" VARCHAR,
  "gka" VARCHAR,
  "ayga" VARCHAR,
  "n__6_081689834590001" DOUBLE,
  "n_145_391998291" DOUBLE,
  "n_5282" BIGINT,
  "n_10" VARCHAR,
  "u" VARCHAR,
  "pacific_port_moresby" VARCHAR,
  "airport" VARCHAR,
  "ourairports" VARCHAR
);