Transport - Cities And Greater Cities

Eurostat code: urb_ctran · (1989 - 2024)

@eurostat.urb_ctran

Table List

2 tables(672.29 KB)

Transport - Cities And Greater Cities - Raw

Transport - Cities And Greater Cities - Unpivoted

Transport - Cities And Greater Cities - Unpivoted

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

311.57 KB
74110 rows
5 columns

freq Freq	indic_ur Indic Ur	cities Cities	time_period Time Period	value Value
Annual	People commuting into the city	Łódź	1989	42866
Annual	People commuting into the city	Kraków	1989	93070
Annual	People commuting into the city	Poznań	1989	54159
Annual	People commuting into the city	Gdańsk	1989	49779
Annual	People commuting into the city	Szczecin	1989	19402
Annual	People commuting into the city	Bydgoszcz	1989	25283
Annual	People commuting into the city	Lublin	1989	34706
Annual	People commuting into the city	Katowice	1989	94895
Annual	People commuting into the city	Białystok	1989	19874
Annual	People commuting into the city	Kielce	1989	34880


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.