Energy - Historical Data (2004-2007, Former Methodology And Source)

Eurostat code: med_eg_all · (1990 - 2011)

@eurostat.med_eg_all

Table List

2 tables(28.44 KB)

Energy - Historical Data (2004-2007, Former Methodology And Source) - Raw

Energy - Historical Data (2004-2007, Former Methodology And Source) - Unpivoted

Energy - Historical Data (2004-2007, Former Methodology And Source) - Unpivoted

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

10.43 KB
927 rows
6 columns

freq Freq	indic_en Indic En	product Product	geo Geo	time_period Time Period	value Value
Annual	Primary production	All products	Israel	1990	422
Annual	Primary production	All products	Jordan	1990	132
Annual	Total imports	All products	Israel	1990	12318
Annual	Total imports	All products	Jordan	1990	3471
Annual	Total imports	Electrical energy	Israel	1990
Annual	Total imports	Electrical energy	Jordan	1990
Annual	Total exports	All products	Israel	1990	1126
Annual	Total exports	All products	Jordan	1990
Annual	Total exports	Electrical energy	Israel	1990	39.3
Annual	Gross inland consumption	All products	Israel	1990	11495


CREATE TABLE tidy (
  "freq" 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.