Baselight
Sign In

Population Structure - Cities And Greater Cities

Eurostat code: urb_cpopstr · (1989 - 2024)

@eurostat.urb_cpopstr

Population Structure - Cities And Greater Cities - Unpivoted
@eurostat.urb_cpopstr.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.

  • 345.85 KB
  • 174379 rows
  • 5 columns
freq

Freq

indic_ur

Indic Ur

cities

Cities

time_period

Time Period

value

Value

AnnualWomen per 100 menTallinn1989115.2
AnnualWomen per 100 menTartu1989119.7
AnnualWomen per 100 menVilnius1989110.6
AnnualWomen per 100 menKaunas1989116.5
AnnualWomen per 100 menPanevėžys1989116.3
AnnualWomen per 100 menWarszawa1989114.2
AnnualWomen per 100 menŁódź1989117.5
AnnualWomen per 100 menKraków1989109.9
AnnualWomen per 100 menWrocław1989109.9
AnnualWomen per 100 menPoznań1989112.8

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