Name: Air Transport By Airline Licence (EU Or Non-EU), Main Airports And Transport Coverage
Creator: Eurostat
License: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Copyright/licence_policy

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-10-24T23:00:00+0200

Tables

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

@eurostat.avia_tf_ala.raw

51.85 MB
332,690 rows
290 columns

CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "tra_meas" VARCHAR,
  "tra_cov" VARCHAR,
  "airline" VARCHAR,
  "rep_airp" VARCHAR,
  "n_1993" DOUBLE  -- 1993,
  "n_1994" DOUBLE  -- 1994,
  "n_1995" DOUBLE  -- 1995,
  "n_1996" DOUBLE  -- 1996,
  "n_1997" DOUBLE  -- 1997,
  "n_1998" DOUBLE  -- 1998,
  "n_1999" DOUBLE  -- 1999,
  "n_2000" DOUBLE  -- 2000,
  "n_2001" DOUBLE  -- 2001,
  "n_2002" DOUBLE  -- 2002,
  "n_2003" DOUBLE  -- 2003,
  "n_2004" DOUBLE  -- 2004,
  "n_2005" DOUBLE  -- 2005,
  "n_2006" DOUBLE  -- 2006,
  "n_2007" DOUBLE  -- 2007,
  "n_2008" DOUBLE  -- 2008,
  "n_2009" DOUBLE  -- 2009,
  "n_2010" DOUBLE  -- 2010,
  "n_2010_01" DOUBLE  -- 2010-01,
  "n_2010_02" DOUBLE  -- 2010-02,
  "n_2010_03" DOUBLE  -- 2010-03,
  "n_2010_04" DOUBLE  -- 2010-04,
  "n_2010_05" DOUBLE  -- 2010-05,
  "n_2010_06" DOUBLE  -- 2010-06,
  "n_2010_07" DOUBLE  -- 2010-07,
  "n_2010_08" DOUBLE  -- 2010-08,
  "n_2010_09" DOUBLE  -- 2010-09,
  "n_2010_10" DOUBLE  -- 2010-10,
  "n_2010_11" DOUBLE  -- 2010-11,
  "n_2010_12" DOUBLE  -- 2010-12,
  "n_2010_q1" DOUBLE  -- 2010-Q1,
  "n_2010_q2" DOUBLE  -- 2010-Q2,
  "n_2010_q3" DOUBLE  -- 2010-Q3,
  "n_2010_q4" DOUBLE  -- 2010-Q4,
  "n_2011" DOUBLE  -- 2011,
  "n_2011_01" DOUBLE  -- 2011-01,
  "n_2011_02" DOUBLE  -- 2011-02,
  "n_2011_03" DOUBLE  -- 2011-03,
  "n_2011_04" DOUBLE  -- 2011-04,
  "n_2011_05" DOUBLE  -- 2011-05,
  "n_2011_06" DOUBLE  -- 2011-06,
  "n_2011_07" DOUBLE  -- 2011-07,
  "n_2011_08" DOUBLE  -- 2011-08,
  "n_2011_09" DOUBLE  -- 2011-09,
  "n_2011_10" DOUBLE  -- 2011-10,
  "n_2011_11" DOUBLE  -- 2011-11,
  "n_2011_12" DOUBLE  -- 2011-12,
  "n_2011_q1" DOUBLE  -- 2011-Q1,
  "n_2011_q2" DOUBLE  -- 2011-Q2,
  "n_2011_q3" DOUBLE  -- 2011-Q3,
  "n_2011_q4" DOUBLE  -- 2011-Q4,
  "n_2012" DOUBLE  -- 2012,
  "n_2012_01" DOUBLE  -- 2012-01,
  "n_2012_02" DOUBLE  -- 2012-02,
  "n_2012_03" DOUBLE  -- 2012-03,
  "n_2012_04" DOUBLE  -- 2012-04,
  "n_2012_05" DOUBLE  -- 2012-05,
  "n_2012_06" DOUBLE  -- 2012-06,
  "n_2012_07" DOUBLE  -- 2012-07,
  "n_2012_08" DOUBLE  -- 2012-08,
  "n_2012_09" DOUBLE  -- 2012-09,
  "n_2012_10" DOUBLE  -- 2012-10,
  "n_2012_11" DOUBLE  -- 2012-11,
  "n_2012_12" DOUBLE  -- 2012-12,
  "n_2012_q1" DOUBLE  -- 2012-Q1,
  "n_2012_q2" DOUBLE  -- 2012-Q2,
  "n_2012_q3" DOUBLE  -- 2012-Q3,
  "n_2012_q4" DOUBLE  -- 2012-Q4,
  "n_2013" DOUBLE  -- 2013,
  "n_2013_01" DOUBLE  -- 2013-01,
  "n_2013_02" DOUBLE  -- 2013-02,
  "n_2013_03" DOUBLE  -- 2013-03,
  "n_2013_04" DOUBLE  -- 2013-04,
  "n_2013_05" DOUBLE  -- 2013-05,
  "n_2013_06" DOUBLE  -- 2013-06,
  "n_2013_07" DOUBLE  -- 2013-07,
  "n_2013_08" DOUBLE  -- 2013-08,
  "n_2013_09" DOUBLE  -- 2013-09,
  "n_2013_10" DOUBLE  -- 2013-10,
  "n_2013_11" DOUBLE  -- 2013-11,
  "n_2013_12" DOUBLE  -- 2013-12,
  "n_2013_q1" DOUBLE  -- 2013-Q1,
  "n_2013_q2" DOUBLE  -- 2013-Q2,
  "n_2013_q3" DOUBLE  -- 2013-Q3,
  "n_2013_q4" DOUBLE  -- 2013-Q4,
  "n_2014" DOUBLE  -- 2014,
  "n_2014_01" DOUBLE  -- 2014-01,
  "n_2014_02" DOUBLE  -- 2014-02,
  "n_2014_03" DOUBLE  -- 2014-03,
  "n_2014_04" DOUBLE  -- 2014-04,
  "n_2014_05" DOUBLE  -- 2014-05,
  "n_2014_06" DOUBLE  -- 2014-06,
  "n_2014_07" DOUBLE  -- 2014-07,
  "n_2014_08" DOUBLE  -- 2014-08
);

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

@eurostat.avia_tf_ala.tidy

55.74 MB
15,908,674 rows
8 columns

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