Baselight
Sign In

Prices (annual Series)

Eurostat code: med_ec8 ยท (2005 - 2019)

@eurostat.med_ec8

Prices (annual Series) - Unpivoted
@eurostat.med_ec8.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.

  • 4.85 KB
  • 114 rows
  • 5 columns
freq

Freq

indic_md

Indic Md

geo

Geo

time_period

Time Period

value

Value

AnnualConsumer price index (2015 = 100)Algeria200564.6
AnnualConsumer price index (2015 = 100)Israel200582.3
AnnualConsumer price index (2015 = 100)Jordan200565.1
AnnualConsumer price index (2015 = 100)Morocco200584.3
AnnualConsumer price index (2015 = 100)Palestine*200572.7
AnnualConsumer price index (2015 = 100)Tunisia200564.7
AnnualConsumer price index (2015 = 100)Algeria200666.1
AnnualConsumer price index (2015 = 100)Israel200684.1
AnnualConsumer price index (2015 = 100)Jordan200669.2
AnnualConsumer price index (2015 = 100)Morocco200687.2

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