Population On 1 January By Age Groups And Sex - Functional Urban Areas

Eurostat code: urb_lpop1 · (1989 - 2024)

@eurostat.urb_lpop1

Table List

2 tables(4.07 MB)

Population On 1 January By Age Groups And Sex - Functional Urban Areas - Raw

Population On 1 January By Age Groups And Sex - Functional Urban Areas - Unpivoted

Population On 1 January By Age Groups And Sex - Functional Urban Areas - Unpivoted

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

1.82 MB
401331 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	605415
Annual	Population on the 1st of January, total	Tartu	1989	161813
Annual	Population on the 1st of January, total	Vilnius	1989	767981
Annual	Population on the 1st of January, total	Kaunas	1989	502368
Annual	Population on the 1st of January, total	Panevežys	1989	168424
Annual	Population on the 1st of January, male	Tallinn	1989	284699
Annual	Population on the 1st of January, male	Tartu	1989	74278
Annual	Population on the 1st of January, male	Vilnius	1989	366093
Annual	Population on the 1st of January, male	Kaunas	1989	233442
Annual	Population on the 1st of January, male	Panevežys	1989	78168


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.