Environment - Functional Urban Areas

Eurostat code: urb_lenv · (1990 - 2023)

@eurostat.urb_lenv

Table List

2 tables(109.32 KB)

Environment - Functional Urban Areas - Raw

Environment - Functional Urban Areas - Unpivoted

Environment - Functional Urban Areas - Unpivoted

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

44.59 KB
6407 rows
5 columns

freq Freq	indic_ur Indic Ur	cities Cities	time_period Time Period	value Value
Annual	Total number of hours of sunshine per day	Sweden	1990	4.48
Annual	Total number of hours of sunshine per day	Belgium	1991	4.6
Annual	Average temperature of warmest month - degrees	Belgium	1991	19
Annual	Average temperature of coldest month - degrees	Belgium	1991
Annual	Rainfall - litre/m²	Belgium	1991	794
Annual	Number of days ozone O3 concentrations exceed 120 µg/m³	Belgium	1991	32
Annual	Total use of water - m³	Switzerland	1991	1193000000
Annual	Total use of water - m³	Cyprus	1991	57200000000
Annual	Total number of hours of sunshine per day	Belgium	1992	4.1
Annual	Average temperature of warmest month - degrees	Belgium	1992	18.4


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.