Retail Trade Confidence Indicator And Survey Results- Monthly Data
Eurostat code: ei_bsrt_m_r2 ยท (1984-02 - 2025-09)
@eurostat.ei_bsrt_m_r2
Eurostat code: ei_bsrt_m_r2 ยท (1984-02 - 2025-09)
@eurostat.ei_bsrt_m_r2
This Eurostat dataset contains data on retail trade confidence indicator and survey results- 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-29T11:00:00+0200
CREATE TABLE raw (
"freq" VARCHAR,
"indic" VARCHAR,
"s_adj" VARCHAR,
"unit" VARCHAR,
"geo" VARCHAR,
"n_1984_02" DOUBLE -- 1984-02,
"n_1984_03" DOUBLE -- 1984-03,
"n_1984_04" DOUBLE -- 1984-04,
"n_1984_05" DOUBLE -- 1984-05,
"n_1984_06" DOUBLE -- 1984-06,
"n_1984_07" DOUBLE -- 1984-07,
"n_1984_08" DOUBLE -- 1984-08,
"n_1984_09" DOUBLE -- 1984-09,
"n_1984_10" DOUBLE -- 1984-10,
"n_1984_11" DOUBLE -- 1984-11,
"n_1984_12" DOUBLE -- 1984-12,
"n_1985_01" DOUBLE -- 1985-01,
"n_1985_02" DOUBLE -- 1985-02,
"n_1985_03" DOUBLE -- 1985-03,
"n_1985_04" DOUBLE -- 1985-04,
"n_1985_05" DOUBLE -- 1985-05,
"n_1985_06" DOUBLE -- 1985-06,
"n_1985_07" DOUBLE -- 1985-07,
"n_1985_08" DOUBLE -- 1985-08,
"n_1985_09" DOUBLE -- 1985-09,
"n_1985_10" DOUBLE -- 1985-10,
"n_1985_11" DOUBLE -- 1985-11,
"n_1985_12" DOUBLE -- 1985-12,
"n_1986_01" DOUBLE -- 1986-01,
"n_1986_02" DOUBLE -- 1986-02,
"n_1986_03" DOUBLE -- 1986-03,
"n_1986_04" DOUBLE -- 1986-04,
"n_1986_05" DOUBLE -- 1986-05,
"n_1986_06" DOUBLE -- 1986-06,
"n_1986_07" DOUBLE -- 1986-07,
"n_1986_08" DOUBLE -- 1986-08,
"n_1986_09" DOUBLE -- 1986-09,
"n_1986_10" DOUBLE -- 1986-10,
"n_1986_11" DOUBLE -- 1986-11,
"n_1986_12" DOUBLE -- 1986-12,
"n_1987_01" DOUBLE -- 1987-01,
"n_1987_02" DOUBLE -- 1987-02,
"n_1987_03" DOUBLE -- 1987-03,
"n_1987_04" DOUBLE -- 1987-04,
"n_1987_05" DOUBLE -- 1987-05,
"n_1987_06" DOUBLE -- 1987-06,
"n_1987_07" DOUBLE -- 1987-07,
"n_1987_08" DOUBLE -- 1987-08,
"n_1987_09" DOUBLE -- 1987-09,
"n_1987_10" DOUBLE -- 1987-10,
"n_1987_11" DOUBLE -- 1987-11,
"n_1987_12" DOUBLE -- 1987-12,
"n_1988_01" DOUBLE -- 1988-01,
"n_1988_02" DOUBLE -- 1988-02,
"n_1988_03" DOUBLE -- 1988-03,
"n_1988_04" DOUBLE -- 1988-04,
"n_1988_05" DOUBLE -- 1988-05,
"n_1988_06" DOUBLE -- 1988-06,
"n_1988_07" DOUBLE -- 1988-07,
"n_1988_08" DOUBLE -- 1988-08,
"n_1988_09" DOUBLE -- 1988-09,
"n_1988_10" DOUBLE -- 1988-10,
"n_1988_11" DOUBLE -- 1988-11,
"n_1988_12" DOUBLE -- 1988-12,
"n_1989_01" DOUBLE -- 1989-01,
"n_1989_02" DOUBLE -- 1989-02,
"n_1989_03" DOUBLE -- 1989-03,
"n_1989_04" DOUBLE -- 1989-04,
"n_1989_05" DOUBLE -- 1989-05,
"n_1989_06" DOUBLE -- 1989-06,
"n_1989_07" DOUBLE -- 1989-07,
"n_1989_08" DOUBLE -- 1989-08,
"n_1989_09" DOUBLE -- 1989-09,
"n_1989_10" DOUBLE -- 1989-10,
"n_1989_11" DOUBLE -- 1989-11,
"n_1989_12" DOUBLE -- 1989-12,
"n_1990_01" DOUBLE -- 1990-01,
"n_1990_02" DOUBLE -- 1990-02,
"n_1990_03" DOUBLE -- 1990-03,
"n_1990_04" DOUBLE -- 1990-04,
"n_1990_05" DOUBLE -- 1990-05,
"n_1990_06" DOUBLE -- 1990-06,
"n_1990_07" DOUBLE -- 1990-07,
"n_1990_08" DOUBLE -- 1990-08,
"n_1990_09" DOUBLE -- 1990-09,
"n_1990_10" DOUBLE -- 1990-10,
"n_1990_11" DOUBLE -- 1990-11,
"n_1990_12" DOUBLE -- 1990-12,
"n_1991_01" DOUBLE -- 1991-01,
"n_1991_02" DOUBLE -- 1991-02,
"n_1991_03" DOUBLE -- 1991-03,
"n_1991_04" DOUBLE -- 1991-04,
"n_1991_05" DOUBLE -- 1991-05,
"n_1991_06" DOUBLE -- 1991-06,
"n_1991_07" DOUBLE -- 1991-07,
"n_1991_08" DOUBLE -- 1991-08,
"n_1991_09" DOUBLE -- 1991-09,
"n_1991_10" DOUBLE -- 1991-10,
"n_1991_11" DOUBLE -- 1991-11,
"n_1991_12" DOUBLE -- 1991-12
);
CREATE TABLE tidy (
"freq" VARCHAR,
"indic" VARCHAR,
"s_adj" VARCHAR,
"unit" VARCHAR,
"geo" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);
Anyone who has the link will be able to view this.