Energy Balance

Eurostat code: enps_nrg_bal_c · (2005 - 2022)

@eurostat.enps_nrg_bal_c

Table List

2 tables(29.18 KB)

Energy Balance - Unpivoted

@eurostat.enps_nrg_bal_c.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.62 KB
693 rows
6 columns

freq Freq	unit Unit	nrg_bal Nrg Bal	geo Geo	time_period Time Period	value Value
Annual	Thousand tonnes of oil equivalent	Available for final consumption	Morocco	2005	11488.7
Annual	Thousand tonnes of oil equivalent	Available for final consumption	Palestine*	2005	1268.1
Annual	Thousand tonnes of oil equivalent	Exports	Algeria	2005	144391
Annual	Thousand tonnes of oil equivalent	Exports	Egypt	2005	25440
Annual	Thousand tonnes of oil equivalent	Exports	Israel	2005	3965.5
Annual	Thousand tonnes of oil equivalent	Exports	Jordan	2005	1
Annual	Thousand tonnes of oil equivalent	Exports	Lebanon	2005
Annual	Thousand tonnes of oil equivalent	Exports	Morocco	2005	1381.4
Annual	Thousand tonnes of oil equivalent	Exports	Palestine*	2005
Annual	Thousand tonnes of oil equivalent	Gross inland consumption	Algeria	2005	36255


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

Share link

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