Energy Flow - Sankey Diagram Data

Eurostat code: nrg_bal_sd · (1990 - 2023)

@eurostat.nrg_bal_sd

Table List

2 tables(6.71 MB)

Energy Flow - Sankey Diagram Data - Unpivoted

Energy Flow - Sankey Diagram Data - Unpivoted

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

3.35 MB
956221 rows
7 columns

freq Freq	nrg_bal Nrg Bal	siec Siec	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Available from all sources	Coking coal	Thousand tonnes of oil equivalent	Albania	1990	40.3
Annual	Available from all sources	Coking coal	Thousand tonnes of oil equivalent	Austria	1990	1649.7
Annual	Available from all sources	Coking coal	Thousand tonnes of oil equivalent	Belgium	1990	5010
Annual	Available from all sources	Coking coal	Thousand tonnes of oil equivalent	Bulgaria	1990	1146
Annual	Available from all sources	Coking coal	Thousand tonnes of oil equivalent	Czechia	1990	9700
Annual	Available from all sources	Coking coal	Thousand tonnes of oil equivalent	Germany	1990	32019.4
Annual	Available from all sources	Coking coal	Thousand tonnes of oil equivalent	Spain	1990	3201.1
Annual	Available from all sources	Coking coal	Thousand tonnes of oil equivalent	European Union - 27 countries (from 2020)	1990	97971.8
Annual	Available from all sources	Coking coal	Thousand tonnes of oil equivalent	Finland	1990	447.9
Annual	Available from all sources	Coking coal	Thousand tonnes of oil equivalent	France	1990	6812.7


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.