World Airports

Code, Area Code, Runway, Longitude, Latitude and Country of World Airports

Data Structure

airport [9,433]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ airport_code (100%)
char(3)
+ world_area_code (100%)
char(2)
+ country_abbreviation (100%)
varchar(255)
+ country_name (100%)
varchar(255)
+ runway_length (100%)
varchar(255)
+ runway_elevation (100%)
varchar(255)
+ city (100%)
varchar(255)
+ longitude (100%)
varchar(255)
+ latitude (100%)
varchar(255)
+ gmt_offset (100%)
varchar(255)
+ telephone (6.9%)
varchar(255)
+ fax (4.1%)
varchar(255)
+ website (8.7%)
varchar(255)
+ email (3.7%)

Description

This is simple one table database of 9,433 airports (unique, with 9,433 distinct airport codes) around the globe. Each airport record has a name, an airport code, a world area code, city name, country (both abbreviation and common name), length of runway, elevation of runway, longitude, latitude, GMT offset, telephone number, fax number, website URL and email address.

655 airports have a telephone number. 389 airports have a fax number. 816 airports have a website URL. 347 airports have an email address. All other fields are fully populated with usable data.

Data Profile

Size 3.06M
Tables 1
Last Commit 2016-12-07 00:25:22

Updates / Commits

Time Size Tables Columns Rows
2016-12-07 00:25:22 3.06M 1 17 9433
2016-08-31 03:17:51 3.06M 1 17 9433

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
airport 9,433 .001 9.433
Total Credits 9.433 Credits (1) (2)
(1). Plus cost by query time at 0.1 credits per second. A typical query takes about 0.001 seconds which would then charge you 0.0001 credits.
(2). This is the total amount of credits required for ALL rows in these tables. You are free to query for only a selected part of them, even a single row, and pay only for that.

How to Access

Click to see how to access this dataset.