Diversity Index Of Final Energy Consumption By Sector

Eurostat code: nrg_ind_difec · (1990 - 2022)

@eurostat.nrg_ind_difec

Table List

2 tables(262.16 KB)

Diversity Index Of Final Energy Consumption By Sector - Raw

Diversity Index Of Final Energy Consumption By Sector - Unpivoted

Diversity Index Of Final Energy Consumption By Sector - Unpivoted

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

76.37 KB
22484 rows
6 columns

freq Freq	nrg_bal Nrg Bal	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Final consumption - energy use	Index	Austria	1990	0.1415
Annual	Final consumption - energy use	Index	Belgium	1990	0.1875
Annual	Final consumption - energy use	Index	Bulgaria	1990	0.1686
Annual	Final consumption - energy use	Index	Cyprus	1990	0.2248
Annual	Final consumption - energy use	Index	Czechia	1990	0.102
Annual	Final consumption - energy use	Index	Germany	1990	0.1502
Annual	Final consumption - energy use	Index	Denmark	1990	0.1738
Annual	Final consumption - energy use	Index	Estonia	1990	0.2101
Annual	Final consumption - energy use	Index	Greece	1990	0.1916
Annual	Final consumption - energy use	Index	Spain	1990	0.1536


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.