International Intra-EU Freight And Mail Air Transport Between Main Airports And EU Partner Countries
Eurostat code: avia_goinac ยท (1993 - 2025-Q3)
@eurostat.avia_goinac
Eurostat code: avia_goinac ยท (1993 - 2025-Q3)
@eurostat.avia_goinac
This Eurostat dataset contains data on international intra-eu freight and mail air transport between main airports and eu partner countries, as collected and published by the Statistical Office of the European Union.
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
CREATE TABLE raw (
"freq" VARCHAR,
"unit" VARCHAR,
"tra_meas" VARCHAR,
"rep_airp" VARCHAR,
"partner" VARCHAR,
"n_1993" DOUBLE -- 1993,
"n_1994" DOUBLE -- 1994,
"n_1995" DOUBLE -- 1995,
"n_1996" DOUBLE -- 1996,
"n_1997" DOUBLE -- 1997,
"n_1997_q1" DOUBLE -- 1997-Q1,
"n_1997_q2" DOUBLE -- 1997-Q2,
"n_1997_q3" DOUBLE -- 1997-Q3,
"n_1997_q4" DOUBLE -- 1997-Q4,
"n_1998" DOUBLE -- 1998,
"n_1998_01" DOUBLE -- 1998-01,
"n_1998_02" DOUBLE -- 1998-02,
"n_1998_03" DOUBLE -- 1998-03,
"n_1998_04" DOUBLE -- 1998-04,
"n_1998_05" DOUBLE -- 1998-05,
"n_1998_06" DOUBLE -- 1998-06,
"n_1998_07" DOUBLE -- 1998-07,
"n_1998_08" DOUBLE -- 1998-08,
"n_1998_09" DOUBLE -- 1998-09,
"n_1998_10" DOUBLE -- 1998-10,
"n_1998_11" DOUBLE -- 1998-11,
"n_1998_12" DOUBLE -- 1998-12,
"n_1998_q1" DOUBLE -- 1998-Q1,
"n_1998_q2" DOUBLE -- 1998-Q2,
"n_1998_q3" DOUBLE -- 1998-Q3,
"n_1998_q4" DOUBLE -- 1998-Q4,
"n_1999" DOUBLE -- 1999,
"n_1999_01" DOUBLE -- 1999-01,
"n_1999_02" DOUBLE -- 1999-02,
"n_1999_03" DOUBLE -- 1999-03,
"n_1999_04" DOUBLE -- 1999-04,
"n_1999_05" DOUBLE -- 1999-05,
"n_1999_06" DOUBLE -- 1999-06,
"n_1999_07" DOUBLE -- 1999-07,
"n_1999_08" DOUBLE -- 1999-08,
"n_1999_09" DOUBLE -- 1999-09,
"n_1999_10" DOUBLE -- 1999-10,
"n_1999_11" DOUBLE -- 1999-11,
"n_1999_12" DOUBLE -- 1999-12,
"n_1999_q1" DOUBLE -- 1999-Q1,
"n_1999_q2" DOUBLE -- 1999-Q2,
"n_1999_q3" DOUBLE -- 1999-Q3,
"n_1999_q4" DOUBLE -- 1999-Q4,
"n_2000" DOUBLE -- 2000,
"n_2000_01" DOUBLE -- 2000-01,
"n_2000_02" DOUBLE -- 2000-02,
"n_2000_03" DOUBLE -- 2000-03,
"n_2000_04" DOUBLE -- 2000-04,
"n_2000_05" DOUBLE -- 2000-05,
"n_2000_06" DOUBLE -- 2000-06,
"n_2000_07" DOUBLE -- 2000-07,
"n_2000_08" DOUBLE -- 2000-08,
"n_2000_09" DOUBLE -- 2000-09,
"n_2000_10" DOUBLE -- 2000-10,
"n_2000_11" DOUBLE -- 2000-11,
"n_2000_12" DOUBLE -- 2000-12,
"n_2000_q1" DOUBLE -- 2000-Q1,
"n_2000_q2" DOUBLE -- 2000-Q2,
"n_2000_q3" DOUBLE -- 2000-Q3,
"n_2000_q4" DOUBLE -- 2000-Q4,
"n_2001" DOUBLE -- 2001,
"n_2001_01" DOUBLE -- 2001-01,
"n_2001_02" DOUBLE -- 2001-02,
"n_2001_03" DOUBLE -- 2001-03,
"n_2001_04" DOUBLE -- 2001-04,
"n_2001_05" DOUBLE -- 2001-05,
"n_2001_06" DOUBLE -- 2001-06,
"n_2001_07" DOUBLE -- 2001-07,
"n_2001_08" DOUBLE -- 2001-08,
"n_2001_09" DOUBLE -- 2001-09,
"n_2001_10" DOUBLE -- 2001-10,
"n_2001_11" DOUBLE -- 2001-11,
"n_2001_12" DOUBLE -- 2001-12,
"n_2001_q1" DOUBLE -- 2001-Q1,
"n_2001_q2" DOUBLE -- 2001-Q2,
"n_2001_q3" DOUBLE -- 2001-Q3,
"n_2001_q4" DOUBLE -- 2001-Q4,
"n_2002" DOUBLE -- 2002,
"n_2002_01" DOUBLE -- 2002-01,
"n_2002_02" DOUBLE -- 2002-02,
"n_2002_03" DOUBLE -- 2002-03,
"n_2002_04" DOUBLE -- 2002-04,
"n_2002_05" DOUBLE -- 2002-05,
"n_2002_06" DOUBLE -- 2002-06,
"n_2002_07" DOUBLE -- 2002-07,
"n_2002_08" DOUBLE -- 2002-08,
"n_2002_09" DOUBLE -- 2002-09,
"n_2002_10" DOUBLE -- 2002-10,
"n_2002_11" DOUBLE -- 2002-11,
"n_2002_12" DOUBLE -- 2002-12,
"n_2002_q1" DOUBLE -- 2002-Q1,
"n_2002_q2" DOUBLE -- 2002-Q2,
"n_2002_q3" DOUBLE -- 2002-Q3,
"n_2002_q4" DOUBLE -- 2002-Q4,
"n_2003" DOUBLE -- 2003
);CREATE TABLE tidy (
"freq" VARCHAR,
"unit" VARCHAR,
"tra_meas" VARCHAR,
"rep_airp" VARCHAR,
"partner" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);Anyone who has the link will be able to view this.