Baselight
Sign In

Oil Stocks - Stock Levels - Monthly Data

Eurostat code: nrg_141m ยท (2013-01 - 2019-12)

@eurostat.nrg_141m

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.26 MB
  • 61504 rows
  • 89 columns
Loading...
 

CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "indic_en" VARCHAR,
  "product" VARCHAR,
  "geo" VARCHAR,
  "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,
  "n_2019_02" DOUBLE,
  "n_2019_03" DOUBLE,
  "n_2019_04" DOUBLE,
  "n_2019_05" DOUBLE,
  "n_2019_06" DOUBLE,
  "n_2019_07" DOUBLE,
  "n_2019_08" DOUBLE,
  "n_2019_09" DOUBLE,
  "n_2019_10" DOUBLE,
  "n_2019_11" DOUBLE,
  "n_2019_12" DOUBLE
);

Oil Stocks - Stock Levels - Monthly Data - Unpivoted

@eurostat.nrg_141m.tidy
  • 2.83 MB
  • 4615269 rows
  • 7 columns
Loading...
 

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