Dataset: Retail Sale - Monthly Data

About this Dataset

Retail Sale - Monthly Data

This Eurostat dataset contains data on retail sale - monthly data, 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-05-27T11:00:00+0200

Tables

Retail Sale - Monthly Data - Raw

@eurostat.ei_bsrt_m_r2.raw

953.2 KB
462 rows
501 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "indic" VARCHAR,
  "s_adj" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_1984_02" DOUBLE,
  "n_1984_03" DOUBLE,
  "n_1984_04" DOUBLE,
  "n_1984_05" DOUBLE,
  "n_1984_06" DOUBLE,
  "n_1984_07" DOUBLE,
  "n_1984_08" DOUBLE,
  "n_1984_09" DOUBLE,
  "n_1984_10" DOUBLE,
  "n_1984_11" DOUBLE,
  "n_1984_12" DOUBLE,
  "n_1985_01" DOUBLE,
  "n_1985_02" DOUBLE,
  "n_1985_03" DOUBLE,
  "n_1985_04" DOUBLE,
  "n_1985_05" DOUBLE,
  "n_1985_06" DOUBLE,
  "n_1985_07" DOUBLE,
  "n_1985_08" DOUBLE,
  "n_1985_09" DOUBLE,
  "n_1985_10" DOUBLE,
  "n_1985_11" DOUBLE,
  "n_1985_12" DOUBLE,
  "n_1986_01" DOUBLE,
  "n_1986_02" DOUBLE,
  "n_1986_03" DOUBLE,
  "n_1986_04" DOUBLE,
  "n_1986_05" DOUBLE,
  "n_1986_06" DOUBLE,
  "n_1986_07" DOUBLE,
  "n_1986_08" DOUBLE,
  "n_1986_09" DOUBLE,
  "n_1986_10" DOUBLE,
  "n_1986_11" DOUBLE,
  "n_1986_12" DOUBLE,
  "n_1987_01" DOUBLE,
  "n_1987_02" DOUBLE,
  "n_1987_03" DOUBLE,
  "n_1987_04" DOUBLE,
  "n_1987_05" DOUBLE,
  "n_1987_06" DOUBLE,
  "n_1987_07" DOUBLE,
  "n_1987_08" DOUBLE,
  "n_1987_09" DOUBLE,
  "n_1987_10" DOUBLE,
  "n_1987_11" DOUBLE,
  "n_1987_12" DOUBLE,
  "n_1988_01" DOUBLE,
  "n_1988_02" DOUBLE,
  "n_1988_03" DOUBLE,
  "n_1988_04" DOUBLE,
  "n_1988_05" DOUBLE,
  "n_1988_06" DOUBLE,
  "n_1988_07" DOUBLE,
  "n_1988_08" DOUBLE,
  "n_1988_09" DOUBLE,
  "n_1988_10" DOUBLE,
  "n_1988_11" DOUBLE,
  "n_1988_12" DOUBLE,
  "n_1989_01" DOUBLE,
  "n_1989_02" DOUBLE,
  "n_1989_03" DOUBLE,
  "n_1989_04" DOUBLE,
  "n_1989_05" DOUBLE,
  "n_1989_06" DOUBLE,
  "n_1989_07" DOUBLE,
  "n_1989_08" DOUBLE,
  "n_1989_09" DOUBLE,
  "n_1989_10" DOUBLE,
  "n_1989_11" DOUBLE,
  "n_1989_12" DOUBLE,
  "n_1990_01" DOUBLE,
  "n_1990_02" DOUBLE,
  "n_1990_03" DOUBLE,
  "n_1990_04" DOUBLE,
  "n_1990_05" DOUBLE,
  "n_1990_06" DOUBLE,
  "n_1990_07" DOUBLE,
  "n_1990_08" DOUBLE,
  "n_1990_09" DOUBLE,
  "n_1990_10" DOUBLE,
  "n_1990_11" DOUBLE,
  "n_1990_12" DOUBLE,
  "n_1991_01" DOUBLE,
  "n_1991_02" DOUBLE,
  "n_1991_03" DOUBLE,
  "n_1991_04" DOUBLE,
  "n_1991_05" DOUBLE,
  "n_1991_06" DOUBLE,
  "n_1991_07" DOUBLE,
  "n_1991_08" DOUBLE,
  "n_1991_09" DOUBLE,
  "n_1991_10" DOUBLE,
  "n_1991_11" DOUBLE,
  "n_1991_12" DOUBLE
);

Retail Sale - Monthly Data - Unpivoted

@eurostat.ei_bsrt_m_r2.tidy

240.22 KB
152778 rows
7 columns


CREATE TABLE tidy (
  "freq" VARCHAR,
  "indic" VARCHAR,
  "s_adj" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);