Long-term Residents Among All Non-EU Citizens Holding Residence Permits By Citizenship On 31 December (%)

Eurostat code: migr_resshare · (2008 - 2023)

@eurostat.migr_resshare

Table List

2 tables(895.59 KB)

Long-term Residents Among All Non-EU Citizens Holding Residence Permits By Citizenship On 31 December (%) - Raw

Long-term Residents Among All Non-EU Citizens Holding Residence Permits By Citizenship On 31 December (%) - Unpivoted

Long-term Residents Among All Non-EU Citizens Holding Residence Permits By Citizenship On 31 December (%) - Unpivoted

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

401.24 KB
181218 rows
7 columns

freq Freq	leg_fram Leg Fram	citizen Citizen	unit Unit	geo Geo	time_period Time Period
Annual	EU framework	Andorra	Percentage	Belgium	2008
Annual	EU framework	Andorra	Percentage	Germany	2008
Annual	EU framework	Andorra	Percentage	Spain	2008
Annual	EU framework	Andorra	Percentage	Finland	2008
Annual	EU framework	Andorra	Percentage	France	2008
Annual	EU framework	Andorra	Percentage	Iceland	2008
Annual	EU framework	Andorra	Percentage	Italy	2008
Annual	EU framework	Andorra	Percentage	Netherlands	2008
Annual	EU framework	Andorra	Percentage	Portugal	2008
Annual	EU framework	United Arab Emirates	Percentage	Austria	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.