Baselight

Air Transport By Airline Licence (EU Or Non-EU), Main Airports And Transport Coverage

Eurostat code: avia_tf_ala ยท (1993 - 2025-Q1)

@eurostat.avia_tf_ala

Loading...
Loading...

About this Dataset

Air Transport By Airline Licence (EU Or Non-EU), Main Airports And Transport Coverage

This Eurostat dataset contains data on air transport by airline licence (eu or non-eu), main airports and transport coverage, as collected and published by the Statistical Office of the European Union.

Tables included:

  • raw: Original table as downloaded from Eurostat.
  • tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).

Last updated: 2025-07-31T11:00:00+0200

Tables

Air Transport By Airline Licence (EU Or Non-EU), Main Airports And Transport Coverage - Raw

@eurostat.avia_tf_ala.raw
  • 48.17 MB
  • 329344 rows
  • 283 columns
Loading...

CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "tra_meas" VARCHAR,
  "tra_cov" VARCHAR,
  "airline" VARCHAR,
  "rep_airp" VARCHAR,
  "n_1993" DOUBLE,
  "n_1994" DOUBLE,
  "n_1995" DOUBLE,
  "n_1996" DOUBLE,
  "n_1997" DOUBLE,
  "n_1998" DOUBLE,
  "n_1999" DOUBLE,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2010_01" DOUBLE,
  "n_2010_02" DOUBLE,
  "n_2010_03" DOUBLE,
  "n_2010_04" DOUBLE,
  "n_2010_05" DOUBLE,
  "n_2010_06" DOUBLE,
  "n_2010_07" DOUBLE,
  "n_2010_08" DOUBLE,
  "n_2010_09" DOUBLE,
  "n_2010_10" DOUBLE,
  "n_2010_11" DOUBLE,
  "n_2010_12" DOUBLE,
  "n_2010_q1" DOUBLE,
  "n_2010_q2" DOUBLE,
  "n_2010_q3" DOUBLE,
  "n_2010_q4" DOUBLE,
  "n_2011" DOUBLE,
  "n_2011_01" DOUBLE,
  "n_2011_02" DOUBLE,
  "n_2011_03" DOUBLE,
  "n_2011_04" DOUBLE,
  "n_2011_05" DOUBLE,
  "n_2011_06" DOUBLE,
  "n_2011_07" DOUBLE,
  "n_2011_08" DOUBLE,
  "n_2011_09" DOUBLE,
  "n_2011_10" DOUBLE,
  "n_2011_11" DOUBLE,
  "n_2011_12" DOUBLE,
  "n_2011_q1" DOUBLE,
  "n_2011_q2" DOUBLE,
  "n_2011_q3" DOUBLE,
  "n_2011_q4" DOUBLE,
  "n_2012" DOUBLE,
  "n_2012_01" DOUBLE,
  "n_2012_02" DOUBLE,
  "n_2012_03" DOUBLE,
  "n_2012_04" DOUBLE,
  "n_2012_05" DOUBLE,
  "n_2012_06" DOUBLE,
  "n_2012_07" DOUBLE,
  "n_2012_08" DOUBLE,
  "n_2012_09" DOUBLE,
  "n_2012_10" DOUBLE,
  "n_2012_11" DOUBLE,
  "n_2012_12" DOUBLE,
  "n_2012_q1" DOUBLE,
  "n_2012_q2" DOUBLE,
  "n_2012_q3" DOUBLE,
  "n_2012_q4" DOUBLE,
  "n_2013" DOUBLE,
  "n_2013_01" DOUBLE,
  "n_2013_02" DOUBLE,
  "n_2013_03" DOUBLE,
  "n_2013_04" DOUBLE,
  "n_2013_05" DOUBLE,
  "n_2013_06" DOUBLE,
  "n_2013_07" DOUBLE,
  "n_2013_08" DOUBLE,
  "n_2013_09" DOUBLE,
  "n_2013_10" DOUBLE,
  "n_2013_11" DOUBLE,
  "n_2013_12" DOUBLE,
  "n_2013_q1" DOUBLE,
  "n_2013_q2" DOUBLE,
  "n_2013_q3" DOUBLE,
  "n_2013_q4" DOUBLE,
  "n_2014" DOUBLE,
  "n_2014_01" DOUBLE,
  "n_2014_02" DOUBLE,
  "n_2014_03" DOUBLE,
  "n_2014_04" DOUBLE,
  "n_2014_05" DOUBLE,
  "n_2014_06" DOUBLE,
  "n_2014_07" DOUBLE,
  "n_2014_08" DOUBLE
);

Air Transport By Airline Licence (EU Or Non-EU), Main Airports And Transport Coverage - Unpivoted

@eurostat.avia_tf_ala.tidy
  • 52.36 MB
  • 15683734 rows
  • 8 columns
Loading...

CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "tra_meas" VARCHAR,
  "tra_cov" VARCHAR,
  "airline" VARCHAR,
  "rep_airp" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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