Local Pollution

Eurostat code: med_en3 · (2000 - 2013)

@eurostat.med_en3

Table List

2 tables(18.51 KB)

Local Pollution - Raw

Local Pollution - Unpivoted

Local Pollution - Raw

@eurostat.med_en3.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

12.92 KB
22 rows
17 columns

freq Freq	indic_md Indic Md	geo Geo	n_2000 2000	n_2001 2001	n_2002 2002	n_2003 2003	n_2004 2004	n_2005 2005	n_2006 2006	n_2007 2007	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012	n_2013 2013
Annual	Frequency of ozone peaks (Number)	Egypt			2
Annual	Frequency of ozone peaks (Number)	Israel			4	9	3	3	2	2	3	2	6
Annual	Total number of gasoline fueled vehicles (number)	Algeria	2059370	2066345	2089283	2085664	2131391	2163379	2245371	2369112	2572596	2677120		2892585
Annual	Total number of gasoline fueled vehicles (number)	Israel	1586	1637	1656	1665	1701	1760	1814	1909	2003	2064	2162	2268	2337	2414
Annual	Total number of gasoline fueled vehicles (number)	Morocco	818389	841487	873538	904948	939115	978204	1029137		1160927	1246739	1323054
Annual	Total number of gasoline fueled vehicles (number)	Palestine*	55279	44500	26294								110775	77261	126687
Annual	Total number of gasoline fueled vehicles (number)	Tunisia			446872	467726	494081	519762	544931	574316
Annual	Total number of diesel powered engines (number)	Algeria	760522	776937	792894	845044	877598	947412	1053895	1179490	1301248	1378735		1533889
Annual	Total number of diesel powered engines (number)	Israel	245	278	304	317	336	348	361	375	387	387	395	405	412	422
Annual	Total number of diesel powered engines (number)	Morocco	808492	877825	912671	948034	989383	1034898	1093354	1166702	1248456	1349335	1436597


CREATE TABLE raw (
  "freq" VARCHAR,
  "indic_md" VARCHAR,
  "geo" VARCHAR,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE
);

Share link

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