First Permits By Reason, Age, Sex And Citizenship

Eurostat code: migr_resfas$dv_1281

@eurostat.migr_resfas_dv_1281

Table List

2 tables(44.52 KB)

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_dv_1281.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.

18.49 KB
5384 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	4 years or less	Total	Person	Austria	2014	1
Annual	Education reasons	Females	4 years or less	Total	Person	Belgium	2014
Annual	Education reasons	Females	4 years or less	Total	Person	Bulgaria	2014	1
Annual	Education reasons	Females	4 years or less	Total	Person	Switzerland	2014	2
Annual	Education reasons	Females	4 years or less	Total	Person	Cyprus	2014	11
Annual	Education reasons	Females	4 years or less	Total	Person	Czechia	2014
Annual	Education reasons	Females	4 years or less	Total	Person	Denmark	2014
Annual	Education reasons	Females	4 years or less	Total	Person	Estonia	2014
Annual	Education reasons	Females	4 years or less	Total	Person	Greece	2014
Annual	Education reasons	Females	4 years or less	Total	Person	Spain	2014	13


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.