Transport - Functional Urban Areas

Eurostat code: urb_ltran · (1990 - 2023)

@eurostat.urb_ltran

Table List

2 tables(352.22 KB)

Transport - Functional Urban Areas - Raw

Transport - Functional Urban Areas - Unpivoted

Transport - Functional Urban Areas - Unpivoted

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

156.85 KB
36527 rows
5 columns

freq Freq	indic_ur Indic Ur	cities Cities	time_period Time Period	value Value
Annual	Share of journeys to work by car -%	Switzerland	1990	47.92
Annual	Share of journeys to work by car -%	Bern	1990	33.64
Annual	Share of journeys to work by car -%	Zürich	1990	43.21
Annual	Share of journeys to work by car -%	Genève	1990	48.23
Annual	Share of journeys to work by car -%	Basel	1990	33.59
Annual	Share of journeys to work by car -%	Lausanne	1990	50.21
Annual	Share of journeys to work by car -%	Luzern	1990	41.3
Annual	Share of journeys to work by car -%	Lugano	1990	59.31
Annual	Share of journeys to work by car -%	St. Gallen	1990	38.52
Annual	Share of journeys to work by car -%	Biel/Bienne	1990	44.23


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.