Baselight
Sign In

Local Pollution

Eurostat code: med_en3 ยท (2000 - 2013)

@eurostat.med_en3

Local Pollution - Unpivoted
@eurostat.med_en3.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.

  • 5.59 KB
  • 200 rows
  • 5 columns
freq

Freq

indic_md

Indic Md

geo

Geo

time_period

Time Period

value

Value

AnnualTotal number of gasoline fueled vehicles (number)Algeria20002059370
AnnualTotal number of gasoline fueled vehicles (number)Israel20001586
AnnualTotal number of gasoline fueled vehicles (number)Morocco2000818389
AnnualTotal number of gasoline fueled vehicles (number)Palestine*200055279
AnnualTotal number of diesel powered engines (number)Algeria2000760522
AnnualTotal number of diesel powered engines (number)Israel2000245
AnnualTotal number of diesel powered engines (number)Morocco2000808492
AnnualTotal number of diesel powered engines (number)Palestine*200019369
AnnualTotal number of other vehicles (number)Israel2000
AnnualTotal number of other vehicles (number)Morocco2000

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

Share link

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