Dataset: Realised Sample Size - Monthly Data, Experimental Statistics

About this Dataset

Realised Sample Size - Monthly Data, Experimental Statistics

This Eurostat dataset contains data on realised sample size - monthly data, experimental statistics, 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: 2023-03-16T23:00:00+0100

Tables

Realised Sample Size - Monthly Data, Experimental Statistics - Raw

@eurostat.lfsi_siz_m.raw

125.33 KB
33 rows
147 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2011_01" DOUBLE,
  "n_2011_02" DOUBLE,
  "n_2011_03" DOUBLE,
  "n_2011_04" DOUBLE,
  "n_2011_05" DOUBLE,
  "n_2011_06" DOUBLE,
  "n_2011_07" DOUBLE,
  "n_2011_08" DOUBLE,
  "n_2011_09" DOUBLE,
  "n_2011_10" DOUBLE,
  "n_2011_11" DOUBLE,
  "n_2011_12" DOUBLE,
  "n_2012_01" DOUBLE,
  "n_2012_02" DOUBLE,
  "n_2012_03" DOUBLE,
  "n_2012_04" DOUBLE,
  "n_2012_05" DOUBLE,
  "n_2012_06" DOUBLE,
  "n_2012_07" DOUBLE,
  "n_2012_08" DOUBLE,
  "n_2012_09" DOUBLE,
  "n_2012_10" DOUBLE,
  "n_2012_11" DOUBLE,
  "n_2012_12" DOUBLE,
  "n_2013_01" DOUBLE,
  "n_2013_02" DOUBLE,
  "n_2013_03" DOUBLE,
  "n_2013_04" DOUBLE,
  "n_2013_05" DOUBLE,
  "n_2013_06" DOUBLE,
  "n_2013_07" DOUBLE,
  "n_2013_08" DOUBLE,
  "n_2013_09" DOUBLE,
  "n_2013_10" DOUBLE,
  "n_2013_11" DOUBLE,
  "n_2013_12" DOUBLE,
  "n_2014_01" DOUBLE,
  "n_2014_02" DOUBLE,
  "n_2014_03" DOUBLE,
  "n_2014_04" DOUBLE,
  "n_2014_05" DOUBLE,
  "n_2014_06" DOUBLE,
  "n_2014_07" DOUBLE,
  "n_2014_08" DOUBLE,
  "n_2014_09" DOUBLE,
  "n_2014_10" DOUBLE,
  "n_2014_11" DOUBLE,
  "n_2014_12" DOUBLE,
  "n_2015_01" DOUBLE,
  "n_2015_02" DOUBLE,
  "n_2015_03" DOUBLE,
  "n_2015_04" DOUBLE,
  "n_2015_05" DOUBLE,
  "n_2015_06" DOUBLE,
  "n_2015_07" DOUBLE,
  "n_2015_08" DOUBLE,
  "n_2015_09" DOUBLE,
  "n_2015_10" DOUBLE,
  "n_2015_11" DOUBLE,
  "n_2015_12" DOUBLE,
  "n_2016_01" DOUBLE,
  "n_2016_02" DOUBLE,
  "n_2016_03" DOUBLE,
  "n_2016_04" DOUBLE,
  "n_2016_05" DOUBLE,
  "n_2016_06" DOUBLE,
  "n_2016_07" DOUBLE,
  "n_2016_08" DOUBLE,
  "n_2016_09" DOUBLE,
  "n_2016_10" DOUBLE,
  "n_2016_11" DOUBLE,
  "n_2016_12" DOUBLE,
  "n_2017_01" DOUBLE,
  "n_2017_02" DOUBLE,
  "n_2017_03" DOUBLE,
  "n_2017_04" DOUBLE,
  "n_2017_05" DOUBLE,
  "n_2017_06" DOUBLE,
  "n_2017_07" DOUBLE,
  "n_2017_08" DOUBLE,
  "n_2017_09" DOUBLE,
  "n_2017_10" DOUBLE,
  "n_2017_11" DOUBLE,
  "n_2017_12" DOUBLE,
  "n_2018_01" DOUBLE,
  "n_2018_02" DOUBLE,
  "n_2018_03" DOUBLE,
  "n_2018_04" DOUBLE,
  "n_2018_05" DOUBLE,
  "n_2018_06" DOUBLE,
  "n_2018_07" DOUBLE,
  "n_2018_08" DOUBLE,
  "n_2018_09" DOUBLE,
  "n_2018_10" DOUBLE,
  "n_2018_11" DOUBLE,
  "n_2018_12" DOUBLE,
  "n_2019_01" DOUBLE
);

Realised Sample Size - Monthly Data, Experimental Statistics - Unpivoted

@eurostat.lfsi_siz_m.tidy

30.5 KB
4579 rows
5 columns


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