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 - Raw

@eurostat.migr_reslong.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

403.03 KB
17622 rows
21 columns

freq Freq	leg_fram Leg Fram	citizen Citizen	unit Unit	geo Geo	n_2020 2020
Annual	EU framework	Andorra	Person	Austria
Annual	EU framework	Andorra	Person	Belgium
Annual	EU framework	Andorra	Person	Bulgaria
Annual	EU framework	Andorra	Person	Switzerland	8
Annual	EU framework	Andorra	Person	Cyprus
Annual	EU framework	Andorra	Person	Czechia
Annual	EU framework	Andorra	Person	Germany
Annual	EU framework	Andorra	Person	Denmark
Annual	EU framework	Andorra	Person	Estonia
Annual	EU framework	Andorra	Person	Greece


CREATE TABLE raw (
  "freq" VARCHAR,
  "leg_fram" VARCHAR,
  "citizen" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE
);

Share link

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