Baselight
Sign In

Calorific Values

Eurostat code: nrg_bal_cv · (1990 - 2023)

@eurostat.nrg_bal_cv

Calorific Values - Unpivoted
@eurostat.nrg_bal_cv.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.

  • 580.53 KB
  • 176263 rows
  • 7 columns
freq

Freq

calval

Calval

siec

Siec

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualGross calorific value - averageNatural gasKilojoule per cubic metre (gross calorific value - GCV)Albania199038901.235
AnnualGross calorific value - averageNatural gasKilojoule per cubic metre (gross calorific value - GCV)Austria199037914.241
AnnualGross calorific value - averageNatural gasKilojoule per cubic metre (gross calorific value - GCV)Belgium199039680.902
AnnualGross calorific value - averageNatural gasKilojoule per cubic metre (gross calorific value - GCV)Bulgaria199037530.951
AnnualGross calorific value - averageNatural gasKilojoule per cubic metre (gross calorific value - GCV)Czechia199037117.683
AnnualGross calorific value - averageNatural gasKilojoule per cubic metre (gross calorific value - GCV)Germany199035724.795
AnnualGross calorific value - averageNatural gasKilojoule per cubic metre (gross calorific value - GCV)Denmark199041085.52
AnnualGross calorific value - averageNatural gasKilojoule per cubic metre (gross calorific value - GCV)Euro area – 20 countries (from 2023)1990663292.327
AnnualGross calorific value - averageNatural gasKilojoule per cubic metre (gross calorific value - GCV)Estonia199038367.746
AnnualGross calorific value - averageNatural gasKilojoule per cubic metre (gross calorific value - GCV)Greece199052243.902

CREATE TABLE tidy (
  "freq" VARCHAR,
  "calval" 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.