Change Of Immigration Status Permits By Reason And Citizenship

Eurostat code: migr_reschange · (2008 - 2023)

@eurostat.migr_reschange

Table List

2 tables(1.93 MB)

Change Of Immigration Status Permits By Reason And Citizenship - Raw

Change Of Immigration Status Permits By Reason And Citizenship - Unpivoted

Change Of Immigration Status Permits By Reason And Citizenship - Unpivoted

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

944.63 KB
1336873 rows
7 columns

freq Freq	reason Reason	citizen Citizen	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Change from education reasons	Andorra	Person	Belgium	2008
Annual	Change from education reasons	Andorra	Person	Cyprus	2008
Annual	Change from education reasons	Andorra	Person	Czechia	2008
Annual	Change from education reasons	Andorra	Person	Germany	2008
Annual	Change from education reasons	Andorra	Person	Greece	2008
Annual	Change from education reasons	Andorra	Person	Spain	2008	2
Annual	Change from education reasons	Andorra	Person	Finland	2008
Annual	Change from education reasons	Andorra	Person	Hungary	2008
Annual	Change from education reasons	Andorra	Person	Iceland	2008
Annual	Change from education reasons	Andorra	Person	Italy	2008


CREATE TABLE tidy (
  "freq" VARCHAR,
  "reason" 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.