Final Energy Consumption

Eurostat code: sdg_07_11 · (2005 - 2023)

@eurostat.sdg_07_11

Table List

2 tables(34.04 KB)

Final Energy Consumption - Unpivoted

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

9.78 KB
1596 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Index, 2005=100	Austria	2005	100
Annual	Index, 2005=100	Belgium	2005	100
Annual	Index, 2005=100	Bulgaria	2005	100
Annual	Index, 2005=100	Cyprus	2005	100
Annual	Index, 2005=100	Czechia	2005	100
Annual	Index, 2005=100	Germany	2005	100
Annual	Index, 2005=100	Denmark	2005	100
Annual	Index, 2005=100	Estonia	2005	100
Annual	Index, 2005=100	Greece	2005	100
Annual	Index, 2005=100	Spain	2005	100


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.