Final Energy Consumption By Sector

Eurostat code: ten00124 · (2012 - 2023)

@eurostat.ten00124

Table List

2 tables(56.46 KB)

Final Energy Consumption By Sector - Raw

Final Energy Consumption By Sector - Unpivoted

Final Energy Consumption By Sector - Unpivoted

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

24.26 KB
2400 rows
7 columns

freq Freq	nrg_bal Nrg Bal	siec Siec	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Final consumption - energy use	Total	Thousand tonnes of oil equivalent	Albania	2012	1790.623
Annual	Final consumption - energy use	Total	Thousand tonnes of oil equivalent	Austria	2012	25201.329
Annual	Final consumption - energy use	Total	Thousand tonnes of oil equivalent	Belgium	2012	32979.933
Annual	Final consumption - energy use	Total	Thousand tonnes of oil equivalent	Bulgaria	2012	9103.369
Annual	Final consumption - energy use	Total	Thousand tonnes of oil equivalent	Cyprus	2012	1492.799
Annual	Final consumption - energy use	Total	Thousand tonnes of oil equivalent	Czechia	2012	23326.229
Annual	Final consumption - energy use	Total	Thousand tonnes of oil equivalent	Germany	2012	202662.536
Annual	Final consumption - energy use	Total	Thousand tonnes of oil equivalent	Denmark	2012	13611.792
Annual	Final consumption - energy use	Total	Thousand tonnes of oil equivalent	Estonia	2012	2827.225
Annual	Final consumption - energy use	Total	Thousand tonnes of oil equivalent	Greece	2012	16402.985


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.