Premature Deaths Due To Exposure To Fine Particulate Matter (PM2.5)

Eurostat code: sdg_11_52 · (2005 - 2022)

@eurostat.sdg_11_52

Table List

2 tables(33.26 KB)

Premature Deaths Due To Exposure To Fine Particulate Matter (PM2.5) - Raw

Premature Deaths Due To Exposure To Fine Particulate Matter (PM2.5) - Unpivoted

Premature Deaths Due To Exposure To Fine Particulate Matter (PM2.5) - Unpivoted

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

10.96 KB
1292 rows
7 columns

freq Freq	airpol Airpol	indic_he Indic He	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Particulates < 2.5µm	Premature death	Number	Albania	2005	6513
Annual	Particulates < 2.5µm	Premature death	Number	Austria	2005	7167
Annual	Particulates < 2.5µm	Premature death	Number	Bosnia and Herzegovina	2005	7699
Annual	Particulates < 2.5µm	Premature death	Number	Belgium	2005	9333
Annual	Particulates < 2.5µm	Premature death	Number	Bulgaria	2005	19288
Annual	Particulates < 2.5µm	Premature death	Number	Switzerland	2005	4698
Annual	Particulates < 2.5µm	Premature death	Number	Cyprus	2005	1136
Annual	Particulates < 2.5µm	Premature death	Number	Czechia	2005	13121
Annual	Particulates < 2.5µm	Premature death	Number	Germany	2005	66678
Annual	Particulates < 2.5µm	Premature death	Number	Denmark	2005	2994


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

Share link

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