Population By Citizenship And Country Of Birth - Functional Urban Areas

Eurostat code: urb_lpopcb · (1990 - 2024)

@eurostat.urb_lpopcb

Table List

2 tables(674.93 KB)

Population By Citizenship And Country Of Birth - Functional Urban Areas - Raw

Population By Citizenship And Country Of Birth - Functional Urban Areas - Unpivoted

Population By Citizenship And Country Of Birth - Functional Urban Areas - Unpivoted

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

314.15 KB
70270 rows
5 columns

freq Freq	indic_ur Indic Ur	cities Cities	time_period Time Period	value Value
Annual	Nationals as a proportion of population	Switzerland	1990	82
Annual	Nationals as a proportion of population	Zürich	1990	80
Annual	Nationals as a proportion of population	Biel/Bienne	1990	84
Annual	Nationals	Switzerland	1990	5628255
Annual	Nationals	Bern	1990	308879
Annual	Nationals	Zürich	1990	815655
Annual	Nationals	Genève	1990	277230
Annual	Nationals	Geneva crossborder FUA	1990	448903
Annual	Nationals	Basel	1990	384946
Annual	Nationals	Lausanne	1990	216940


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.