Baselight
Sign In

Disaggregated Final Energy Consumption In Services - Calorific Values

Eurostat code: nrg_d_sercv ยท (2020 - 2022)

@eurostat.nrg_d_sercv

Disaggregated Final Energy Consumption In Services - Calorific Values - Unpivoted
@eurostat.nrg_d_sercv.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.

  • 6.71 KB
  • 115 rows
  • 7 columns
freq

Freq

unit

Unit

siec

Siec

calval

Calval

geo

Geo

time_period

Time Period

value

Value

AnnualMegajoule per tonne (net calorific value - NCV)Oil and petroleum productsNet calorific value - averageDenmark202043617.812
AnnualMegajoule per tonne (net calorific value - NCV)Oil and petroleum productsNet calorific value - averageIreland202044566.576
AnnualMegajoule per tonne (net calorific value - NCV)Oil and petroleum productsNet calorific value - averageLatvia202042866.609
AnnualMegajoule per tonne (net calorific value - NCV)Oil and petroleum productsNet calorific value - averageMontenegro202043806.393
AnnualMegajoule per tonne (net calorific value - NCV)Liquefied petroleum gasesNet calorific value - averageDenmark202046000
AnnualMegajoule per tonne (net calorific value - NCV)Liquefied petroleum gasesNet calorific value - averageIreland202047155.928
AnnualMegajoule per tonne (net calorific value - NCV)Liquefied petroleum gasesNet calorific value - averageLatvia202045540
AnnualMegajoule per tonne (net calorific value - NCV)Liquefied petroleum gasesNet calorific value - averageMontenegro202046890
AnnualMegajoule per tonne (net calorific value - NCV)Gas oil and diesel oilNet calorific value - averageDenmark202042700
AnnualMegajoule per tonne (net calorific value - NCV)Gas oil and diesel oilNet calorific value - averageIreland202043308.259

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

Share link

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