Commercial Aircraft Fleet By Age Of Aircraft And Country Of Operator

Eurostat code: avia_eq_arc_age · (2000 - 2023)

@eurostat.avia_eq_arc_age

Table List

2 tables(45.96 KB)

Commercial Aircraft Fleet By Age Of Aircraft And Country Of Operator - Raw

Commercial Aircraft Fleet By Age Of Aircraft And Country Of Operator - Unpivoted

Commercial Aircraft Fleet By Age Of Aircraft And Country Of Operator - Unpivoted

@eurostat.avia_eq_arc_age.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

12.22 KB
4938 rows
5 columns

freq Freq	age Age	geo Geo	time_period Time Period	value Value
Annual	Total	Austria	2000	146
Annual	Total	Belgium	2000	194
Annual	Total	Bulgaria	2000	76
Annual	Total	Switzerland	2000	302
Annual	Total	Cyprus	2000	23
Annual	Total	Czechia	2000	46
Annual	Total	Germany	2000	863
Annual	Total	Denmark	2000	183
Annual	Total	Estonia	2000	24
Annual	Total	Greece	2000	93


CREATE TABLE tidy (
  "freq" VARCHAR,
  "age" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.