Name: International Intra-EU Air Passenger Transport Between Main Airports And EU Partner Countries
Creator: Eurostat
License: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Copyright/licence_policy

About this Dataset

International Intra-EU Air Passenger Transport Between Main Airports And EU Partner Countries

This Eurostat dataset contains data on international intra-eu air passenger transport between main airports and eu partner countries, 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

International Intra-EU Air Passenger Transport Between Main Airports And EU Partner Countries - Raw

@eurostat.avia_painac.raw

62.2 MB
284,868 rows
483 columns

CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "tra_meas" VARCHAR,
  "partner" 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_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
);

International Intra-EU Air Passenger Transport Between Main Airports And EU Partner Countries - Unpivoted

@eurostat.avia_painac.tidy

54.21 MB
14,404,238 rows
7 columns

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