Energy Consumption

Eurostat code: med_eg30 · (2005 - 2018)

@eurostat.med_eg30

Table List

2 tables(20.86 KB)

Energy Consumption - Unpivoted

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

6.74 KB
177 rows
7 columns

freq Freq	unit Unit	indic_en Indic En	product Product	geo Geo	time_period Time Period	value Value
Annual	Thousand tonnes of oil equivalent	Final energy consumption - industry	All products	Algeria	2005	3703
Annual	Thousand tonnes of oil equivalent	Final energy consumption - industry	All products	Egypt	2005	17132
Annual	Thousand tonnes of oil equivalent	Final energy consumption - industry	All products	Israel	2005	2889.7
Annual	Thousand tonnes of oil equivalent	Final energy consumption - industry	All products	Jordan	2005	1158.7
Annual	Thousand tonnes of oil equivalent	Final energy consumption - industry	All products	Lebanon	2005	520
Annual	Thousand tonnes of oil equivalent	Final energy consumption - industry	All products	Morocco	2005	2444.2
Annual	Thousand tonnes of oil equivalent	Final energy consumption - industry	All products	Palestine*	2005	61.5
Annual	Thousand tonnes of oil equivalent	Final energy consumption - transport	All products	Algeria	2005	5220
Annual	Thousand tonnes of oil equivalent	Final energy consumption - transport	All products	Egypt	2005	7787
Annual	Thousand tonnes of oil equivalent	Final energy consumption - transport	All products	Israel	2005	6323


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

Share link

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