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-07-31T11:00:00+0200

Tables

Aircraft Traffic Data By Reporting Country - Raw

@eurostat.avia_tf_acc.raw

27.78 MB
260531 rows
284 columns


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

Aircraft Traffic Data By Reporting Country - Unpivoted

@eurostat.avia_tf_acc.tidy

27.07 MB
8244251 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
);