This is a list of airports from all over the world. The world airports data is filled with 2,771 records by 26 categories with airport name, IATA, ICAO, country, country code, time zone, telephone, fax, airport data, etc. in each. The whole world airports database has 3 tables.
| Name | n3_chennan_airport_name_azworldairports_com |
|---|---|
| Data | 4.52M (+ 0B) |
| Tables | 3 (+ 0) |
| Columns | 52 (+ 0) |
| Table Rows | 5,568 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| airport | 2,771 | airport_name |
100%
|
| iata |
99.57%
|
||
| icao |
99.78%
|
||
| country |
100%
|
||
| cargo_facilities |
11.98%
|
||
| passenger_facilities |
53.48%
|
||
| additional_information |
22.05%
|
||
| country_code |
100%
|
||
| time_zone |
100%
|
||
| telephone |
94.3%
|
||
| telephone_1 |
11.98%
|
||
| telephone_2 |
5.12%
|
||
| fax |
84.41%
|
||
| website |
67.09%
|
||
| sita |
19.81%
|
||
| aftn |
13.97%
|
||
| managing_director |
42.51%
|
||
| operations_director |
34.64%
|
||
| finance_manager |
30.49%
|
||
| marketing_manager |
25.01%
|
||
| cargo_manager |
15.52%
|
||
| passenger_manager |
15.23%
|
||
| air_traffic_controller |
23.42%
|
||
| public_relations_manager |
20.17%
|
||
| security_manager |
29.63%
|
||
| operator |
42.8%
|
||
| airport_data |
99.93%
|
||
| customs_telephone |
27.35%
|
||
| customs_fax |
17.68%
|
||
| customs_hours |
48.39%
|
||
| team_leader |
0.07%
|
||
| airfield_data |
63.84%
|
||
| airfield_data_emergency_services |
28.29%
|
||
| navigational_aids |
60.56%
|
||
| airfield_restrictions |
23.71%
|
||
| aircraft_maintenance |
29.23%
|
||
| runawy_1 |
99.71%
|
||
| airlines_serving_airport |
59.58%
|
||
| cargo_handling_agents |
11.12%
|
||
| category_1 | 26 | title |
100%
|
| category_1_x_airport | 2,771 | category_1_id |
100%
|
| airport_id |
100%
|
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.
