Market Production - Monthly Data
Eurostat code: sts_tot_prod_m · (2010-01 - 2025-07)
@eurostat.sts_tot_prod_m
Eurostat code: sts_tot_prod_m · (2010-01 - 2025-07)
@eurostat.sts_tot_prod_m
This Eurostat dataset contains data on market production - 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-10-08T11:00:00+0200
CREATE TABLE raw (
"freq" VARCHAR,
"indic_bt" VARCHAR,
"nace_r2" VARCHAR,
"s_adj" VARCHAR,
"unit" VARCHAR,
"geo" VARCHAR,
"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_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_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_2013_01" DOUBLE -- 2013-01,
"n_2013_02" DOUBLE -- 2013-02,
"n_2013_03" DOUBLE -- 2013-03,
"n_2013_04" DOUBLE -- 2013-04,
"n_2013_05" DOUBLE -- 2013-05,
"n_2013_06" DOUBLE -- 2013-06,
"n_2013_07" DOUBLE -- 2013-07,
"n_2013_08" DOUBLE -- 2013-08,
"n_2013_09" DOUBLE -- 2013-09,
"n_2013_10" DOUBLE -- 2013-10,
"n_2013_11" DOUBLE -- 2013-11,
"n_2013_12" DOUBLE -- 2013-12,
"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,
"n_2014_09" DOUBLE -- 2014-09,
"n_2014_10" DOUBLE -- 2014-10,
"n_2014_11" DOUBLE -- 2014-11,
"n_2014_12" DOUBLE -- 2014-12,
"n_2015_01" DOUBLE -- 2015-01,
"n_2015_02" DOUBLE -- 2015-02,
"n_2015_03" DOUBLE -- 2015-03,
"n_2015_04" DOUBLE -- 2015-04,
"n_2015_05" DOUBLE -- 2015-05,
"n_2015_06" DOUBLE -- 2015-06,
"n_2015_07" DOUBLE -- 2015-07,
"n_2015_08" DOUBLE -- 2015-08,
"n_2015_09" DOUBLE -- 2015-09,
"n_2015_10" DOUBLE -- 2015-10,
"n_2015_11" DOUBLE -- 2015-11,
"n_2015_12" DOUBLE -- 2015-12,
"n_2016_01" DOUBLE -- 2016-01,
"n_2016_02" DOUBLE -- 2016-02,
"n_2016_03" DOUBLE -- 2016-03,
"n_2016_04" DOUBLE -- 2016-04,
"n_2016_05" DOUBLE -- 2016-05,
"n_2016_06" DOUBLE -- 2016-06,
"n_2016_07" DOUBLE -- 2016-07,
"n_2016_08" DOUBLE -- 2016-08,
"n_2016_09" DOUBLE -- 2016-09,
"n_2016_10" DOUBLE -- 2016-10,
"n_2016_11" DOUBLE -- 2016-11,
"n_2016_12" DOUBLE -- 2016-12,
"n_2017_01" DOUBLE -- 2017-01,
"n_2017_02" DOUBLE -- 2017-02,
"n_2017_03" DOUBLE -- 2017-03,
"n_2017_04" DOUBLE -- 2017-04,
"n_2017_05" DOUBLE -- 2017-05,
"n_2017_06" DOUBLE -- 2017-06,
"n_2017_07" DOUBLE -- 2017-07,
"n_2017_08" DOUBLE -- 2017-08,
"n_2017_09" DOUBLE -- 2017-09,
"n_2017_10" DOUBLE -- 2017-10
);
CREATE TABLE tidy (
"freq" VARCHAR,
"indic_bt" VARCHAR,
"nace_r2" VARCHAR,
"s_adj" VARCHAR,
"unit" VARCHAR,
"geo" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);
Anyone who has the link will be able to view this.