Energy Self-reliance

Eurostat code: nrg_ind_esr · (1990 - 2022)

@eurostat.nrg_ind_esr

Table List

2 tables(39.33 KB)

Energy Self-reliance - Unpivoted

@eurostat.nrg_ind_esr.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.48 KB
891 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Percentage	Austria	1990	30.57
Annual	Percentage	Belgium	1990	17.64
Annual	Percentage	Bulgaria	1990	31.75
Annual	Percentage	Cyprus	1990	0.37
Annual	Percentage	Czechia	1990	63.75
Annual	Percentage	Germany	1990	49.15
Annual	Percentage	Denmark	1990	38.83
Annual	Percentage	Estonia	1990	53.45
Annual	Percentage	Greece	1990	28.45
Annual	Percentage	Spain	1990	32.86


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.