All Valid Permits By Age, Sex And Citizenship On 31 December Of Each Year

Eurostat code: migr_resvas · (2008 - 2023)

@eurostat.migr_resvas

Table List

2 tables(9.41 MB)

All Valid Permits By Age, Sex And Citizenship On 31 December Of Each Year - Raw

All Valid Permits By Age, Sex And Citizenship On 31 December Of Each Year - Unpivoted

All Valid Permits By Age, Sex And Citizenship On 31 December Of Each Year - Unpivoted

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

4.45 MB
4979395 rows
8 columns

freq Freq	sex Sex	age Age	citizen Citizen	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Females	Total	Andorra	Person	Belgium	2010
Annual	Females	Total	Andorra	Person	Estonia	2010
Annual	Females	Total	Andorra	Person	Greece	2010
Annual	Females	Total	Andorra	Person	Spain	2010	340
Annual	Females	Total	Andorra	Person	Ireland	2010
Annual	Females	Total	Andorra	Person	Iceland	2010	3
Annual	Females	Total	Andorra	Person	Italy	2010
Annual	Females	Total	Andorra	Person	Norway	2010
Annual	Females	Total	Andorra	Person	Poland	2010
Annual	Females	Total	Andorra	Person	Portugal	2010	1


CREATE TABLE tidy (
  "freq" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "citizen" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" VARCHAR
);

Share link

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