Air Pollutants

Eurostat code: enps_env_air_emis · (2005 - 2022)

@eurostat.enps_env_air_emis

Table List

2 tables(23.28 KB)

Air Pollutants - Unpivoted

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

6.67 KB
276 rows
6 columns

freq Freq	unit Unit	airpol Airpol	geo Geo	time_period Time Period	value Value
Annual	Thousand tonnes	Methane	Egypt	2005	2058.1
Annual	Thousand tonnes	Methane	Israel	2005	262.5
Annual	Thousand tonnes	Methane	Morocco	2005	10909.3
Annual	Thousand tonnes	Methane	Palestine*	2005	15.1
Annual	Thousand tonnes	Carbon dioxide	Egypt	2005	142600
Annual	Thousand tonnes	Carbon dioxide	Israel	2005	62358.6
Annual	Thousand tonnes	Carbon dioxide	Morocco	2005	38300.7
Annual	Thousand tonnes	Carbon dioxide	Palestine*	2005	2583
Annual	Thousand tonnes	Greenhouse gases (CO2, N2O in CO2 equivalent, CH4 in CO2 equivalent, HFC in CO2 equivalent, PFC in CO2 equivalent, SF6 in CO2 equivalent, NF3 in CO2 equivalent)	Egypt	2005	216100
Annual	Thousand tonnes	Greenhouse gases (CO2, N2O in CO2 equivalent, CH4 in CO2 equivalent, HFC in CO2 equivalent, PFC in CO2 equivalent, SF6 in CO2 equivalent, NF3 in CO2 equivalent)	Israel	2005	71363.7


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

Share link

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