Baselight

Primary Energy Production

Eurostat code: med_eg10 ยท (2005 - 2018)

@eurostat.med_eg10

Primary Energy Production - Unpivoted
@eurostat.med_eg10.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.

  • 7.97 KB
  • 391 rows
  • 7 columns
freq

Freq

unit

Unit

indic_en

Indic En

product

Product

geo

Geo

time_period

Time Period

value

Value

AnnualThousand tonnes of oil equivalentPrimary productionAll productsAlgeria2005179741
AnnualThousand tonnes of oil equivalentPrimary productionAll productsEgypt200578234
AnnualThousand tonnes of oil equivalentPrimary productionAll productsIsrael20051831
AnnualThousand tonnes of oil equivalentPrimary productionAll productsJordan2005252
AnnualThousand tonnes of oil equivalentPrimary productionAll productsLebanon200599
AnnualThousand tonnes of oil equivalentPrimary productionAll productsMorocco20052630.2
AnnualThousand tonnes of oil equivalentPrimary productionAll productsPalestine*2005229.3
AnnualThousand tonnes of oil equivalentTotal importsAll productsAlgeria20051174
AnnualThousand tonnes of oil equivalentTotal importsAll productsEgypt20057053
AnnualThousand tonnes of oil equivalentTotal importsAll productsIsrael200523446.6

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.