Baselight
Sign In

Transport - Cities And Greater Cities

Eurostat code: urb_ctran · (1989 - 2024)

@eurostat.urb_ctran

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

AnnualPeople commuting into the cityŁódź198942866
AnnualPeople commuting into the cityKraków198993070
AnnualPeople commuting into the cityPoznań198954159
AnnualPeople commuting into the cityGdańsk198949779
AnnualPeople commuting into the citySzczecin198919402
AnnualPeople commuting into the cityBydgoszcz198925283
AnnualPeople commuting into the cityLublin198934706
AnnualPeople commuting into the cityKatowice198994895
AnnualPeople commuting into the cityBiałystok198919874
AnnualPeople commuting into the cityKielce198934880

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