Name | n3zm_Airline_airlineupdate_com |
---|---|
Data | 10.23M (+ 0B) |
Tables | 10 (+ 0) |
Columns | 98 (+ 0) |
Table Rows | 17,186 (+ 0) |
Media | 0B (+ 0B) |
Files | 0 (+ 0) |
Last Commit | 2021-01-29 23:19:23 (+ 120 d) |
This is a world airline database with 216 records that are grouped by country, and then alphabetically by airline name. All these countries are from Africa, Caribbean, Central America, Central Asia, Europe, Far East, South Asia, Middle East, North America, Oceania, South America and Southeast Asia. In the whole airlines database, there are 3 tables related with the world airlines, they are airline present existing table of 1,101 records with airline IATA code, main base, IATA prefix, start of ops, airline info, tel, fax, sita, website, freight prefix, callsign, established, hubs, equipment, executives, description, managing director, ops director, other airline, aircraft destroyed and more detail; airlines defunct since 2000 table of 1,369 records with airline, fate, IATA code, ICAO code, start of ops and end of ops; fatal air accidents table of 5,747 records with date, airline, aircraft type, reg, location, fatal, cat, status, time, type, operator, registration, msn, first flight, engines, crew, passengers, total, airplane damage, phase, nature, departure airport, destination airport, narrative, classification, sources and map. The whole world airlines database consists of 10 tables.
Tables | Rows | Columns | Non-empty |
---|---|---|---|
airline | 216 | title |
100%
|
airline_present_existing | 1,101 | airline |
100%
|
iata_code |
0.18%
|
||
main_base |
98.27%
|
||
iata_prefix |
97.28%
|
||
start_of_ops |
96.82%
|
||
airline_info |
16.89%
|
||
tel |
69.75%
|
||
fax |
64.03%
|
||
sita |
2.82%
|
||
website |
8.63%
|
||
freight_prefix |
1.73%
|
||
callsign |
16.71%
|
||
established |
16.71%
|
||
hubs |
2.45%
|
||
equipment |
35.6%
|
||
executives |
16.62%
|
||
description |
16.71%
|
||
managing_director |
0.09%
|
||
ops_director |
0.09%
|
||
other_airline |
16.8%
|
||
aircraft_destroyed |
16.8%
|
||
more_detail |
0.54%
|
||
airline_x_airline_present_existing | 1,101 | airline_id |
100%
|
airline_present_existing_id |
100%
|
||
airline_x_airlines_defunct_since_2000 | 1,457 | airline_id |
100%
|
airlines_defunct_since_2000_id |
100%
|
||
airline_x_fatal_air_accidents | 5,747 | airline_id |
100%
|
fatal_air_accidents_id |
100%
|
||
airlines_defunct_since_2000 | 1,369 | airline |
99.93%
|
fate |
99.42%
|
||
iata_code |
98.1%
|
||
icao_code |
97.81%
|
||
start_of_ops |
97.81%
|
||
end_of_ops |
97.81%
|
||
category_1 | 12 | title |
100%
|
category_2 | 219 | title |
100%
|
category_1_id |
100%
|
||
category_1 |
100%
|
||
category_2_x_airline | 217 | category_2_id |
100%
|
airline_id |
100%
|
||
fatal_air_accidents | 5,747 | date |
100%
|
airline |
99.7%
|
||
aircraft_type |
99.7%
|
||
reg |
98.82%
|
||
location |
98.8%
|
||
fatal |
92.31%
|
||
cat |
99.7%
|
||
status |
28.78%
|
||
time |
44.46%
|
||
type |
99.93%
|
||
operator |
95.82%
|
||
registration |
99.93%
|
||
msn |
96.26%
|
||
first_flight |
86.81%
|
||
engines |
53.65%
|
||
crew |
99.93%
|
||
passengers |
99.93%
|
||
total |
99.93%
|
||
airplane_damage |
99.93%
|
||
phase |
99.93%
|
||
nature |
99.93%
|
||
departure_airport |
99.93%
|
||
destination_airport |
99.93%
|
||
narrative |
99.44%
|
||
classification |
39.12%
|
||
sources |
74.82%
|
||
map |
13.45%
|
No media sets.
Time | Data | Tables | Columns | Rows | Media | Files |
---|---|---|---|---|---|---|
2021-01-29 (+ 120 d) | 10.23M (+ 0B) | 10 (+ 0) | 98 (+ 0) | 17,186 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2020-10-01 (+ 38 d) | 10.23M (+ 0B) | 10 (+ 0) | 98 (+ 0) | 17,186 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2020-08-23 (+ 141 d) | 10.23M (+ 0B) | 10 (+ 0) | 98 (+ 0) | 17,186 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2020-04-04 (+ 196 d) | 10.23M (+ 0B) | 10 (+ 0) | 98 (+ 0) | 17,186 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2019-09-21 (+ 197 d) | 10.23M (+ 0B) | 10 (+ 0) | 98 (+ 0) | 17,186 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2019-03-07 (+ 43 d) | 10.23M (+ 0B) | 10 (+ 0) | 98 (+ 0) | 17,186 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2019-01-23 (+ 44 d) | 10.23M (+ 0B) | 10 (+ 0) | 98 (+ 0) | 17,186 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-12-09 (+ 29 d) | 10.23M (+ 0B) | 10 (+ 0) | 98 (+ 0) | 17,186 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-11-09 (+ 27 d) | 10.23M (+ 4.72M) | 10 (+ 0) | 98 (+ 0) | 17,186 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-10-13 (+ 30 d) | 5.52M (+ 0B) | 10 (+ 0) | 98 (+ 0) | 17,186 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-09-13 (+ 34 d) | 5.52M (+ 0B) | 10 (+ 0) | 98 (+ 0) | 17,186 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-08-09 (+ 27 d) | 5.52M (+ 0B) | 10 (+ 0) | 98 (+ 0) | 17,186 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-07-12 (+ 31 d) | 5.52M (+ 0B) | 10 (+ 0) | 98 (+ 0) | 17,186 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-06-10 (+ 31 d) | 5.52M (+ 0B) | 10 (+ 0) | 98 (+ 0) | 17,186 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-05-10 (+ 28 d) | 5.52M (+ 0B) | 10 (+ 0) | 98 (+ 0) | 17,186 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-04-11 (+ 38 d) | 5.52M (+ 0B) | 10 (+ 0) | 98 (+ 0) | 17,186 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-03-03 (+ 35 d) | 5.52M (+ 0B) | 10 (+ 0) | 98 (+ 0) | 17,186 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
2018-01-27 (+ 29 d) | 5.52M (- 0.81M) | 10 (- 1) | 98 (+ 42) | 17,186 (- 231) | 0B (- 32.47K) | 0 (- 210) |
2017-12-29 (+ 20 d) | 6.33M (+ 0B) | 11 (+ 0) | 56 (+ 0) | 17,417 (+ 0) | 32.47K (+ 0B) | 210 (+ 0) |
2017-12-08 | 6.33M | 11 | 56 | 17,417 | 32.47K | 210 |
Contact us for pricing to download the latest commit / release of this database.
In the same time, you can also access this data set via API.
Select a membership plan and sign up. Return to this page, click Online Query to access the API query maker. Create and open an API call to acquire the data.
The scanning and profiling of data size increments are done separately from those of the number of rows.
Subscribe to be notified of major data releases and updates.
STAY IN THE LOOP.