Population On 1 January By Age Groups And Sex - Cities And Greater Cities

Eurostat code: urb_cpop1 · (1989 - 2024)

@eurostat.urb_cpop1

Table List

2 tables(4.67 MB)

Population On 1 January By Age Groups And Sex - Cities And Greater Cities - Raw

Population On 1 January By Age Groups And Sex - Cities And Greater Cities - Unpivoted

Population On 1 January By Age Groups And Sex - Cities And Greater Cities - Unpivoted

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

2.14 MB
539543 rows
5 columns

freq Freq	indic_ur Indic Ur	cities Cities	time_period Time Period	value Value
Annual	Population on the 1st of January, total	Tallinn	1989	478974
Annual	Population on the 1st of January, total	Tartu	1989	113420
Annual	Population on the 1st of January, total	Vilnius	1989	576747
Annual	Population on the 1st of January, total	Kaunas	1989	418087
Annual	Population on the 1st of January, total	Panevėžys	1989	126483
Annual	Population on the 1st of January, total	Warszawa	1989	1655272
Annual	Population on the 1st of January, total	Łódź	1989	854261
Annual	Population on the 1st of January, total	Kraków	1989	746627
Annual	Population on the 1st of January, total	Wrocław	1989	638986
Annual	Population on the 1st of January, total	Poznań	1989	587971


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.