Energy Productivity

Eurostat code: sdg_07_30 · (2000 - 2023)

@eurostat.sdg_07_30

Table List

2 tables(39.46 KB)

Energy Productivity - Unpivoted

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

10.73 KB
1723 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Euro per kilogram of oil equivalent (KGOE)	Albania	2000	2.83
Annual	Euro per kilogram of oil equivalent (KGOE)	Austria	2000	8.63
Annual	Euro per kilogram of oil equivalent (KGOE)	Belgium	2000	4.73
Annual	Euro per kilogram of oil equivalent (KGOE)	Bulgaria	2000	1.31
Annual	Euro per kilogram of oil equivalent (KGOE)	Cyprus	2000	5.34
Annual	Euro per kilogram of oil equivalent (KGOE)	Czechia	2000	2.85
Annual	Euro per kilogram of oil equivalent (KGOE)	Germany	2000	6.95
Annual	Euro per kilogram of oil equivalent (KGOE)	Denmark	2000	10.84
Annual	Euro per kilogram of oil equivalent (KGOE)	Estonia	2000	2.19
Annual	Euro per kilogram of oil equivalent (KGOE)	Greece	2000	5.76


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

Share link

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