Baselight

Supply, Transformation And Consumption Of Oil And Petroleum Products

Eurostat code: nrg_cb_oil · (1990 - 2023)

@eurostat.nrg_cb_oil

Supply, Transformation And Consumption Of Oil And Petroleum Products - Unpivoted
@eurostat.nrg_cb_oil.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.

  • 4.06 MB
  • 8593880 rows
  • 7 columns
freq

Freq

nrg_bal

Nrg Bal

siec

Siec

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualBackflowsOil and petroleum productsThousand tonnesAlbania1990
AnnualBackflowsOil and petroleum productsThousand tonnesAustria1990
AnnualBackflowsOil and petroleum productsThousand tonnesBelgium1990
AnnualBackflowsOil and petroleum productsThousand tonnesBulgaria1990
AnnualBackflowsOil and petroleum productsThousand tonnesCyprus1990
AnnualBackflowsOil and petroleum productsThousand tonnesCzechia1990
AnnualBackflowsOil and petroleum productsThousand tonnesGermany1990
AnnualBackflowsOil and petroleum productsThousand tonnesDenmark1990
AnnualBackflowsOil and petroleum productsThousand tonnesEuro area – 20 countries (from 2023)1990
AnnualBackflowsOil and petroleum productsThousand tonnesEstonia1990

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

Share link

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