Final Energy Consumption By Product

Eurostat code: ten00123 · (2012 - 2023)

@eurostat.ten00123

Table List

2 tables(79.82 KB)

Final Energy Consumption By Product - Raw

Final Energy Consumption By Product - Unpivoted

Final Energy Consumption By Product - Unpivoted

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

36.13 KB
5280 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	Solid fossil fuels	Thousand tonnes of oil equivalent	Albania	2012	77.225
Annual	Final consumption - energy use	Solid fossil fuels	Thousand tonnes of oil equivalent	Austria	2012	344.577
Annual	Final consumption - energy use	Solid fossil fuels	Thousand tonnes of oil equivalent	Belgium	2012	451.367
Annual	Final consumption - energy use	Solid fossil fuels	Thousand tonnes of oil equivalent	Bulgaria	2012	410.24
Annual	Final consumption - energy use	Solid fossil fuels	Thousand tonnes of oil equivalent	Cyprus	2012	0.124
Annual	Final consumption - energy use	Solid fossil fuels	Thousand tonnes of oil equivalent	Czechia	2012	1899.92
Annual	Final consumption - energy use	Solid fossil fuels	Thousand tonnes of oil equivalent	Germany	2012	4341.927
Annual	Final consumption - energy use	Solid fossil fuels	Thousand tonnes of oil equivalent	Denmark	2012	115.252
Annual	Final consumption - energy use	Solid fossil fuels	Thousand tonnes of oil equivalent	Estonia	2012	40.999
Annual	Final consumption - energy use	Solid fossil fuels	Thousand tonnes of oil equivalent	Greece	2012	227.248


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.