First Permits By Reason, Age, Sex And Citizenship

Eurostat code: migr_resfas · (2010 - 2023)

@eurostat.migr_resfas

Table List

2 tables(23.26 MB)

First Permits By Reason, Age, Sex And Citizenship - Raw

First Permits By Reason, Age, Sex And Citizenship - Unpivoted

First Permits By Reason, Age, Sex And Citizenship - Unpivoted

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

11.06 MB
25926951 rows
9 columns

freq Freq	reason Reason	sex Sex	age Age	citizen Citizen	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Education reasons	Females	Total	Andorra	Person	Belgium	2010
Annual	Education reasons	Females	Total	Andorra	Person	Denmark	2010
Annual	Education reasons	Females	Total	Andorra	Person	Estonia	2010
Annual	Education reasons	Females	Total	Andorra	Person	Greece	2010
Annual	Education reasons	Females	Total	Andorra	Person	Spain	2010	3
Annual	Education reasons	Females	Total	Andorra	Person	Hungary	2010
Annual	Education reasons	Females	Total	Andorra	Person	Ireland	2010
Annual	Education reasons	Females	Total	Andorra	Person	Iceland	2010
Annual	Education reasons	Females	Total	Andorra	Person	Italy	2010
Annual	Education reasons	Females	Total	Andorra	Person	Lithuania	2010


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