Name: Oil Stocks - Stock Levels - Monthly Data
Creator: Eurostat
License: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Copyright/licence_policy

About this Dataset

Oil Stocks - Stock Levels - Monthly Data

This Eurostat dataset contains data on oil stocks - stock levels - 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: 2020-03-09T23:00:00+0100

Tables

Oil Stocks - Stock Levels - Monthly Data - Raw

@eurostat.nrg_141m.raw

3.42 MB
61,504 rows
89 columns

CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "indic_en" VARCHAR,
  "product" VARCHAR,
  "geo" VARCHAR,
  "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,
  "n_2017_11" DOUBLE  -- 2017-11,
  "n_2017_12" DOUBLE  -- 2017-12,
  "n_2018_01" DOUBLE  -- 2018-01,
  "n_2018_02" DOUBLE  -- 2018-02,
  "n_2018_03" DOUBLE  -- 2018-03,
  "n_2018_04" DOUBLE  -- 2018-04,
  "n_2018_05" DOUBLE  -- 2018-05,
  "n_2018_06" DOUBLE  -- 2018-06,
  "n_2018_07" DOUBLE  -- 2018-07,
  "n_2018_08" DOUBLE  -- 2018-08,
  "n_2018_09" DOUBLE  -- 2018-09,
  "n_2018_10" DOUBLE  -- 2018-10,
  "n_2018_11" DOUBLE  -- 2018-11,
  "n_2018_12" DOUBLE  -- 2018-12,
  "n_2019_01" DOUBLE  -- 2019-01,
  "n_2019_02" DOUBLE  -- 2019-02,
  "n_2019_03" DOUBLE  -- 2019-03,
  "n_2019_04" DOUBLE  -- 2019-04,
  "n_2019_05" DOUBLE  -- 2019-05,
  "n_2019_06" DOUBLE  -- 2019-06,
  "n_2019_07" DOUBLE  -- 2019-07,
  "n_2019_08" DOUBLE  -- 2019-08,
  "n_2019_09" DOUBLE  -- 2019-09,
  "n_2019_10" DOUBLE  -- 2019-10,
  "n_2019_11" DOUBLE  -- 2019-11,
  "n_2019_12" DOUBLE  -- 2019-12
);

Oil Stocks - Stock Levels - Monthly Data - Unpivoted

@eurostat.nrg_141m.tidy

2.97 MB
4,615,269 rows
7 columns

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