Euro Area International Trade - Monthly Data
Eurostat code: ei_etea_m ยท (2002-01 - 2025-07)
@eurostat.ei_etea_m
Eurostat code: ei_etea_m ยท (2002-01 - 2025-07)
@eurostat.ei_etea_m
This Eurostat dataset contains data on euro area international trade - monthly data, 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-09-15T11:00:00+0200
CREATE TABLE raw (
"freq" VARCHAR,
"stk_flow" VARCHAR,
"unit" VARCHAR,
"partner" VARCHAR,
"indic" VARCHAR,
"geo" VARCHAR,
"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_2003_01" DOUBLE -- 2003-01,
"n_2003_02" DOUBLE -- 2003-02,
"n_2003_03" DOUBLE -- 2003-03,
"n_2003_04" DOUBLE -- 2003-04,
"n_2003_05" DOUBLE -- 2003-05,
"n_2003_06" DOUBLE -- 2003-06,
"n_2003_07" DOUBLE -- 2003-07,
"n_2003_08" DOUBLE -- 2003-08,
"n_2003_09" DOUBLE -- 2003-09,
"n_2003_10" DOUBLE -- 2003-10,
"n_2003_11" DOUBLE -- 2003-11,
"n_2003_12" DOUBLE -- 2003-12,
"n_2004_01" DOUBLE -- 2004-01,
"n_2004_02" DOUBLE -- 2004-02,
"n_2004_03" DOUBLE -- 2004-03,
"n_2004_04" DOUBLE -- 2004-04,
"n_2004_05" DOUBLE -- 2004-05,
"n_2004_06" DOUBLE -- 2004-06,
"n_2004_07" DOUBLE -- 2004-07,
"n_2004_08" DOUBLE -- 2004-08,
"n_2004_09" DOUBLE -- 2004-09,
"n_2004_10" DOUBLE -- 2004-10,
"n_2004_11" DOUBLE -- 2004-11,
"n_2004_12" DOUBLE -- 2004-12,
"n_2005_01" DOUBLE -- 2005-01,
"n_2005_02" DOUBLE -- 2005-02,
"n_2005_03" DOUBLE -- 2005-03,
"n_2005_04" DOUBLE -- 2005-04,
"n_2005_05" DOUBLE -- 2005-05,
"n_2005_06" DOUBLE -- 2005-06,
"n_2005_07" DOUBLE -- 2005-07,
"n_2005_08" DOUBLE -- 2005-08,
"n_2005_09" DOUBLE -- 2005-09,
"n_2005_10" DOUBLE -- 2005-10,
"n_2005_11" DOUBLE -- 2005-11,
"n_2005_12" DOUBLE -- 2005-12,
"n_2006_01" DOUBLE -- 2006-01,
"n_2006_02" DOUBLE -- 2006-02,
"n_2006_03" DOUBLE -- 2006-03,
"n_2006_04" DOUBLE -- 2006-04,
"n_2006_05" DOUBLE -- 2006-05,
"n_2006_06" DOUBLE -- 2006-06,
"n_2006_07" DOUBLE -- 2006-07,
"n_2006_08" DOUBLE -- 2006-08,
"n_2006_09" DOUBLE -- 2006-09,
"n_2006_10" DOUBLE -- 2006-10,
"n_2006_11" DOUBLE -- 2006-11,
"n_2006_12" DOUBLE -- 2006-12,
"n_2007_01" DOUBLE -- 2007-01,
"n_2007_02" DOUBLE -- 2007-02,
"n_2007_03" DOUBLE -- 2007-03,
"n_2007_04" DOUBLE -- 2007-04,
"n_2007_05" DOUBLE -- 2007-05,
"n_2007_06" DOUBLE -- 2007-06,
"n_2007_07" DOUBLE -- 2007-07,
"n_2007_08" DOUBLE -- 2007-08,
"n_2007_09" DOUBLE -- 2007-09,
"n_2007_10" DOUBLE -- 2007-10,
"n_2007_11" DOUBLE -- 2007-11,
"n_2007_12" DOUBLE -- 2007-12,
"n_2008_01" DOUBLE -- 2008-01,
"n_2008_02" DOUBLE -- 2008-02,
"n_2008_03" DOUBLE -- 2008-03,
"n_2008_04" DOUBLE -- 2008-04,
"n_2008_05" DOUBLE -- 2008-05,
"n_2008_06" DOUBLE -- 2008-06,
"n_2008_07" DOUBLE -- 2008-07,
"n_2008_08" DOUBLE -- 2008-08,
"n_2008_09" DOUBLE -- 2008-09,
"n_2008_10" DOUBLE -- 2008-10,
"n_2008_11" DOUBLE -- 2008-11,
"n_2008_12" DOUBLE -- 2008-12,
"n_2009_01" DOUBLE -- 2009-01,
"n_2009_02" DOUBLE -- 2009-02,
"n_2009_03" DOUBLE -- 2009-03,
"n_2009_04" DOUBLE -- 2009-04,
"n_2009_05" DOUBLE -- 2009-05,
"n_2009_06" DOUBLE -- 2009-06,
"n_2009_07" DOUBLE -- 2009-07,
"n_2009_08" DOUBLE -- 2009-08,
"n_2009_09" DOUBLE -- 2009-09,
"n_2009_10" DOUBLE -- 2009-10
);
CREATE TABLE tidy (
"freq" VARCHAR,
"stk_flow" VARCHAR,
"unit" VARCHAR,
"partner" VARCHAR,
"indic" VARCHAR,
"geo" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);
Anyone who has the link will be able to view this.