Simplified Energy Balances

Eurostat code: nrg_bal_s$dv_650

@eurostat.nrg_bal_s_dv_650

Table List

2 tables(23.59 KB)

Simplified Energy Balances - Unpivoted

@eurostat.nrg_bal_s_dv_650.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.16 KB
401 rows
7 columns

freq Freq	nrg_bal Nrg Bal	siec Siec	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Final consumption - other sectors - agriculture and forestry - energy use	Total	Thousand tonnes of oil equivalent	Albania	2014	81.246
Annual	Final consumption - other sectors - agriculture and forestry - energy use	Total	Thousand tonnes of oil equivalent	Austria	2014	527.326
Annual	Final consumption - other sectors - agriculture and forestry - energy use	Total	Thousand tonnes of oil equivalent	Bosnia and Herzegovina	2014	13.026
Annual	Final consumption - other sectors - agriculture and forestry - energy use	Total	Thousand tonnes of oil equivalent	Belgium	2014	720.677
Annual	Final consumption - other sectors - agriculture and forestry - energy use	Total	Thousand tonnes of oil equivalent	Bulgaria	2014	190.326
Annual	Final consumption - other sectors - agriculture and forestry - energy use	Total	Thousand tonnes of oil equivalent	Cyprus	2014	35.505
Annual	Final consumption - other sectors - agriculture and forestry - energy use	Total	Thousand tonnes of oil equivalent	Czechia	2014	615.141
Annual	Final consumption - other sectors - agriculture and forestry - energy use	Total	Thousand tonnes of oil equivalent	Germany	2014	1514.096
Annual	Final consumption - other sectors - agriculture and forestry - energy use	Total	Thousand tonnes of oil equivalent	Denmark	2014	626.725
Annual	Final consumption - other sectors - agriculture and forestry - energy use	Total	Thousand tonnes of oil equivalent	Estonia	2014	130.375


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

Share link

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