Environment - Cities And Greater Cities

Eurostat code: urb_cenv · (1989 - 2023)

@eurostat.urb_cenv

Table List

2 tables(469.43 KB)

Environment - Cities And Greater Cities - Raw

Environment - Cities And Greater Cities - Unpivoted

Environment - Cities And Greater Cities - Unpivoted

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

209.18 KB
59304 rows
5 columns

freq Freq	indic_ur Indic Ur	cities Cities	time_period Time Period	value Value
Annual	Number of days ozone O3 concentrations exceed 120 µg/m³	Linz (greater city)	1989	6
Annual	Number of days ozone O3 concentrations exceed 120 µg/m³	Salzburg	1989	93
Annual	Number of days ozone O3 concentrations exceed 120 µg/m³	Berlin	1989	31.5
Annual	Number of days ozone O3 concentrations exceed 120 µg/m³	Hamburg	1989	30
Annual	Number of days ozone O3 concentrations exceed 120 µg/m³	Köln	1989	27
Annual	Number of days ozone O3 concentrations exceed 120 µg/m³	Stuttgart	1989	24
Annual	Number of days ozone O3 concentrations exceed 120 µg/m³	Dortmund	1989	33
Annual	Number of days ozone O3 concentrations exceed 120 µg/m³	Darmstadt	1989	28
Annual	Number of days ozone O3 concentrations exceed 120 µg/m³	Kaiserslautern	1989	61
Annual	Number of days ozone O3 concentrations exceed 120 µg/m³	Amsterdam (greater city)	1989	24


CREATE TABLE tidy (
  "freq" VARCHAR,
  "indic_ur" VARCHAR,
  "cities" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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