Crude Oil Supply - Monthly Data

Eurostat code: nrg_cb_cosm · (2005-01 - 2025-02)

@eurostat.nrg_cb_cosm

Table List

2 tables(454.61 KB)

Crude Oil Supply - Monthly Data - Unpivoted

Crude Oil Supply - Monthly Data - Unpivoted

@eurostat.nrg_cb_cosm.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

143.02 KB
23375 rows
6 columns

freq Freq	nrg_bal Nrg Bal	indic_nrg Indic Nrg	geo Geo	time_period Time Period	value Value
Monthly	Imports	Average price - USD per barrel	Austria	2005-01	42.31
Monthly	Imports	Average price - USD per barrel	Belgium	2005-01	39.48
Monthly	Imports	Average price - USD per barrel	Czechia	2005-01	40.7
Monthly	Imports	Average price - USD per barrel	Germany	2005-01	41.01
Monthly	Imports	Average price - USD per barrel	Denmark	2005-01	45.69
Monthly	Imports	Average price - USD per barrel	Greece	2005-01	37.95
Monthly	Imports	Average price - USD per barrel	Spain	2005-01	39.49
Monthly	Imports	Average price - USD per barrel	Finland	2005-01	40.25
Monthly	Imports	Average price - USD per barrel	France	2005-01	41.88
Monthly	Imports	Average price - USD per barrel	Hungary	2005-01	36.46


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

Share link

Anyone who has the link will be able to view this.