Secondary Energy Production (transformation)

Eurostat code: med_eg20 · (2000 - 2015)

@eurostat.med_eg20

Table List

2 tables(27.25 KB)

Secondary Energy Production (transformation) - Raw

Secondary Energy Production (transformation) - Unpivoted

Secondary Energy Production (transformation) - Unpivoted

@eurostat.med_eg20.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.3 KB
776 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	Transformation input	All products	Israel	2000	9282.6
Annual	Thousand tonnes of oil equivalent	Transformation input	Total petroleum products	Israel	2000	2940
Annual	Thousand tonnes of oil equivalent	Transformation input	Total petroleum products	Jordan	2000	1419
Annual	Thousand tonnes of oil equivalent	Transformation input	Gas	Israel	2000	3.3
Annual	Thousand tonnes of oil equivalent	Transformation input	Gas	Jordan	2000	213
Annual	Thousand tonnes of oil equivalent	Transformation output	All products	Israel	2000	3694
Annual	Thousand tonnes of oil equivalent	Transformation output	All products	Jordan	2000	634
Annual	Thousand tonnes of oil equivalent	Transformation output	All products	Libya	2000	1332
Annual	Thousand tonnes of oil equivalent	Transformation output	All products	Morocco	2000	997
Annual	Thousand tonnes of oil equivalent	Transformation output	Renewable energies	Jordan	2000	75


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.