This is a database of world airports with 7,586 records from 218 countries around the world. Each record is identified by airport name, airport code, IATA code, location city, country abbreviation, longitude and latitude. With 6,285 airport communication record, 4,574 runway information and 13,129 remarks, this world airports database is really the one to quick search the airport information of any city you need in the world.
There are 9 tables in this world airports data set.
| Name | n3_chennan_airport_airport_data_com_world |
|---|---|
| Data | 18.62M (+ 0B) |
| Tables | 9 (+ 0) |
| Columns | 77 (+ 0) |
| Table Rows | 71,329 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| airport | 7,586 | name |
100%
|
| icao |
100%
|
||
| iata |
100%
|
||
| location |
98.81%
|
||
| country |
98.81%
|
||
| airport_type |
16.68%
|
||
| longitude_or_latitude |
60.69%
|
||
| elevation |
60.66%
|
||
| magnetic_variation |
60.59%
|
||
| time_zone |
45.1%
|
||
| airport_communication | 6,285 | type |
99.98%
|
| name |
100%
|
||
| freq_1 |
99.65%
|
||
| freq_2 |
47.61%
|
||
| freq_3 |
16.72%
|
||
| freq_4 |
8.21%
|
||
| freq_5 |
3.66%
|
||
| airport_x_airport_communication | 9,318 | airport_id |
100%
|
| airport_communication_id |
100%
|
||
| airport_x_remark | 17,685 | airport_id |
100%
|
| remark_id |
100%
|
||
| airport_x_runway_information | 4,948 | airport_id |
100%
|
| runway_information_id |
100%
|
||
| country | 218 | title |
100%
|
| country_x_airport | 7,586 | country_id |
100%
|
| airport_id |
100%
|
||
| remark | 13,129 | value |
99.99%
|
| runway_information | 4,574 | dimension |
100%
|
| surface |
99.98%
|
||
| runway |
100%
|
||
| runway_1 |
100%
|
||
| longitude |
97.31%
|
||
| longitude_1 |
97.31%
|
||
| latitude |
97.35%
|
||
| latitude_1 |
97.35%
|
||
| end_elevation |
59.42%
|
||
| end_elevation_1 |
59.42%
|
||
| alignment |
96.76%
|
||
| alignment_1 |
96.76%
|
||
| slope |
77.09%
|
||
| slope_1 |
77.09%
|
||
| touchdown_zone_elev |
77.09%
|
||
| touchdown_zone_elev_1 |
77.09%
|
||
| displaced_threshold |
20.55%
|
||
| displaced_threshold_1 |
20.55%
|
||
| lighting_system_1 |
56.86%
|
||
| lighting_system_1_1 |
55.86%
|
||
| lighting_system_2 |
48.93%
|
||
| lighting_system_2_2 |
45.58%
|
||
| lighting_system_3 |
36.88%
|
||
| lighting_system_3_3 |
30.3%
|
||
| lighting_system_4 |
19.9%
|
||
| lighting_system_4_4 |
14.39%
|
||
| lighting_system_5 |
9.27%
|
||
| lighting_system_5_5 |
5.66%
|
Notes:
- Meta columns id and ts are not shown here, but included in columns total.
- Some statistical or memo columns are not shown here, but included in columns total.
- Non-empty percentage indicates the percent of values that are non-empty for that particular column.
Media Sets
No media sets.
