Baselight

Commercial Aircraft Fleet By Aircraft Category And Country Of Operator

Eurostat code: avia_eq_arc_typ ยท (2000 - 2023)

@eurostat.avia_eq_arc_typ

Commercial Aircraft Fleet By Aircraft Category And Country Of Operator - Unpivoted
@eurostat.avia_eq_arc_typ.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.

  • 16.94 KB
  • 8230 rows
  • 5 columns
freq

Freq

airc_cat

Airc Cat

geo

Geo

time_period

Time Period

value

Value

AnnualCargo aircraft with a maximum take-off weight of over 100 000 lbsAustria20002
AnnualCargo aircraft with a maximum take-off weight of over 100 000 lbsBelgium200042
AnnualCargo aircraft with a maximum take-off weight of over 100 000 lbsBulgaria200015
AnnualCargo aircraft with a maximum take-off weight of over 100 000 lbsSwitzerland2000
AnnualCargo aircraft with a maximum take-off weight of over 100 000 lbsCyprus2000
AnnualCargo aircraft with a maximum take-off weight of over 100 000 lbsCzechia2000
AnnualCargo aircraft with a maximum take-off weight of over 100 000 lbsGermany200021
AnnualCargo aircraft with a maximum take-off weight of over 100 000 lbsDenmark200013
AnnualCargo aircraft with a maximum take-off weight of over 100 000 lbsEstonia2000
AnnualCargo aircraft with a maximum take-off weight of over 100 000 lbsGreece2000

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

Share link

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