Long-term Residents By Citizenship On 31 December Of Each Year

Eurostat code: migr_reslong · (2008 - 2023)

@eurostat.migr_reslong

Table List

2 tables(774.5 KB)

Long-term Residents By Citizenship On 31 December Of Each Year - Raw

Long-term Residents By Citizenship On 31 December Of Each Year - Unpivoted

Long-term Residents By Citizenship On 31 December Of Each Year - Unpivoted

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

371.47 KB
229792 rows
7 columns

freq Freq	leg_fram Leg Fram	citizen Citizen	unit Unit	geo Geo	time_period Time Period
Annual	EU framework	Andorra	Person	Austria	2008
Annual	EU framework	Andorra	Person	Belgium	2008
Annual	EU framework	Andorra	Person	Bulgaria	2008
Annual	EU framework	Andorra	Person	Cyprus	2008
Annual	EU framework	Andorra	Person	Czechia	2008
Annual	EU framework	Andorra	Person	Germany	2008
Annual	EU framework	Andorra	Person	Estonia	2008
Annual	EU framework	Andorra	Person	Greece	2008
Annual	EU framework	Andorra	Person	Spain	2008
Annual	EU framework	Andorra	Person	Finland	2008


CREATE TABLE tidy (
  "freq" VARCHAR,
  "leg_fram" VARCHAR,
  "citizen" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.