Available Energy, Energy Supply And Final Energy Consumption Per Capita

Eurostat code: nrg_ind_esc · (1990 - 2023)

@eurostat.nrg_ind_esc

Table List

2 tables(590.8 KB)

Available Energy, Energy Supply And Final Energy Consumption Per Capita - Raw

Available Energy, Energy Supply And Final Energy Consumption Per Capita - Unpivoted

Available Energy, Energy Supply And Final Energy Consumption Per Capita - Unpivoted

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

267.08 KB
49428 rows
7 columns

freq Freq	siec Siec	nrg_bal Nrg Bal	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total	Final consumption - energy use	Gigajoule per capita	Albania	1990	24.7
Annual	Total	Final consumption - energy use	Gigajoule per capita	Austria	1990	97.96
Annual	Total	Final consumption - energy use	Gigajoule per capita	Belgium	1990	119.36
Annual	Total	Final consumption - energy use	Gigajoule per capita	Bulgaria	1990	76.64
Annual	Total	Final consumption - energy use	Gigajoule per capita	Cyprus	1990	61.59
Annual	Total	Final consumption - energy use	Gigajoule per capita	Czechia	1990	126.31
Annual	Total	Final consumption - energy use	Gigajoule per capita	Germany	1990	144.86
Annual	Total	Final consumption - energy use	Gigajoule per capita	Denmark	1990	105.26
Annual	Total	Final consumption - energy use	Gigajoule per capita	Estonia	1990	141.4
Annual	Total	Final consumption - energy use	Gigajoule per capita	Greece	1990	57.03


CREATE TABLE tidy (
  "freq" VARCHAR,
  "siec" VARCHAR,
  "nrg_bal" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.