Energy Efficiency

Eurostat code: nrg_ind_eff · (2005 - 2023)

@eurostat.nrg_ind_eff

Table List

2 tables(48.31 KB)

Energy Efficiency - Unpivoted

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

17.38 KB
2280 rows
6 columns

freq Freq	nrg_bal Nrg Bal	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Final energy consumption - distance to 2020 target	Million tonnes of oil equivalent	European Union - 27 countries (from 2020)	2005	58.18
Annual	Final energy consumption - distance to 2020 target	Percentage	European Union - 27 countries (from 2020)	2005	6.07
Annual	Final energy consumption - distance to 2030 target	Million tonnes of oil equivalent	European Union - 27 countries (from 2020)	2005	254.18
Annual	Final energy consumption - distance to 2030 target	Percentage	European Union - 27 countries (from 2020)	2005	33.31
Annual	Final energy consumption - Energy Efficiency Directive	Index, 2005=100	Austria	2005	100
Annual	Final energy consumption - Energy Efficiency Directive	Index, 2005=100	Belgium	2005	100
Annual	Final energy consumption - Energy Efficiency Directive	Index, 2005=100	Bulgaria	2005	100
Annual	Final energy consumption - Energy Efficiency Directive	Index, 2005=100	Cyprus	2005	100
Annual	Final energy consumption - Energy Efficiency Directive	Index, 2005=100	Czechia	2005	100
Annual	Final energy consumption - Energy Efficiency Directive	Index, 2005=100	Germany	2005	100


CREATE TABLE tidy (
  "freq" 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.