Supply, Transformation And Consumption Of Derived Heat

Eurostat code: nrg_cb_h · (1990 - 2023)

@eurostat.nrg_cb_h

Table List

2 tables(353.13 KB)

Supply, Transformation And Consumption Of Derived Heat - Raw

Supply, Transformation And Consumption Of Derived Heat - Unpivoted

Supply, Transformation And Consumption Of Derived Heat - Unpivoted

@eurostat.nrg_cb_h.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.

157.25 KB
63028 rows
7 columns

freq Freq	nrg_bal Nrg Bal	siec Siec	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Available for final consumption	Heat	Terajoule	Albania	1990	252
Annual	Available for final consumption	Heat	Terajoule	Austria	1990	25637
Annual	Available for final consumption	Heat	Terajoule	Belgium	1990	9237
Annual	Available for final consumption	Heat	Terajoule	Bulgaria	1990	200782
Annual	Available for final consumption	Heat	Terajoule	Cyprus	1990
Annual	Available for final consumption	Heat	Terajoule	Czechia	1990	143125
Annual	Available for final consumption	Heat	Terajoule	Germany	1990	398822
Annual	Available for final consumption	Heat	Terajoule	Denmark	1990	74002
Annual	Available for final consumption	Heat	Terajoule	Euro area – 20 countries (from 2023)	1990	908983
Annual	Available for final consumption	Heat	Terajoule	Estonia	1990	99470


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.