Population By Citizenship And Country Of Birth - Cities And Greater Cities

Eurostat code: urb_cpopcb · (1990 - 2024)

@eurostat.urb_cpopcb

Table List

2 tables(1008.81 KB)

Population By Citizenship And Country Of Birth - Cities And Greater Cities - Raw

Population By Citizenship And Country Of Birth - Cities And Greater Cities - Unpivoted

Population By Citizenship And Country Of Birth - Cities And Greater Cities - Unpivoted

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

463.41 KB
114210 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	Winterthur	1990	79
Annual	Nationals as a proportion of population	St. Gallen (greater city)	1990	77
Annual	Nationals as a proportion of population	Biel/Bienne (greater city)	1990	78
Annual	Nationals as a proportion of population	Lille (greater city)	1990	93
Annual	Nationals as a proportion of population	Marseille (greater city)	1990	93
Annual	Nationals as a proportion of population	Bordeaux (greater city)	1990	94
Annual	Nationals as a proportion of population	Nantes (greater city)	1990	97
Annual	Nationals as a proportion of population	Montpellier (greater city)	1990	93
Annual	Nationals as a proportion of population	Reims (greater city)	1990	94


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.