Name: Aircraft Traffic Data By Reporting Country
Creator: Eurostat
License: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Copyright/licence_policy

About this Dataset

Aircraft Traffic Data By Reporting Country

This Eurostat dataset contains data on aircraft traffic data by reporting country, 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-22T23:00:00+0200

Tables

Aircraft Traffic Data By Reporting Country - Raw

@eurostat.avia_tf_acc.raw

29.49 MB
260,847 rows
288 columns

CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "tra_meas" VARCHAR,
  "tra_cov" VARCHAR,
  "aircraft" VARCHAR,
  "geo" 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_2007_q1" DOUBLE  -- 2007-Q1,
  "n_2007_q2" DOUBLE  -- 2007-Q2,
  "n_2007_q3" DOUBLE  -- 2007-Q3,
  "n_2007_q4" DOUBLE  -- 2007-Q4,
  "n_2008" DOUBLE  -- 2008,
  "n_2008_q1" DOUBLE  -- 2008-Q1,
  "n_2008_q2" DOUBLE  -- 2008-Q2,
  "n_2008_q3" DOUBLE  -- 2008-Q3,
  "n_2008_q4" DOUBLE  -- 2008-Q4,
  "n_2009" DOUBLE  -- 2009,
  "n_2009_q1" DOUBLE  -- 2009-Q1,
  "n_2009_q2" DOUBLE  -- 2009-Q2,
  "n_2009_q3" DOUBLE  -- 2009-Q3,
  "n_2009_q4" DOUBLE  -- 2009-Q4,
  "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_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
);

Aircraft Traffic Data By Reporting Country - Unpivoted

@eurostat.avia_tf_acc.tidy

28.74 MB
8,345,760 rows
8 columns

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