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

Eurostat code: migr_resvas$dv_1282

@eurostat.migr_resvas_dv_1282

Table List

2 tables(44.43 KB)

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

19.3 KB
2848 rows
8 columns

freq Freq	sex Sex	age Age	citizen Citizen	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Females	From 5 to 9 years	Total	Person	Austria	2014	12250
Annual	Females	From 5 to 9 years	Total	Person	Belgium	2014	7594
Annual	Females	From 5 to 9 years	Total	Person	Bulgaria	2014	547
Annual	Females	From 5 to 9 years	Total	Person	Switzerland	2014	19646
Annual	Females	From 5 to 9 years	Total	Person	Czechia	2014	5762
Annual	Females	From 5 to 9 years	Total	Person	Estonia	2014	1365
Annual	Females	From 5 to 9 years	Total	Person	Greece	2014	20499
Annual	Females	From 5 to 9 years	Total	Person	Spain	2014	65935
Annual	Females	From 5 to 9 years	Total	Person	France	2014
Annual	Females	From 5 to 9 years	Total	Person	Croatia	2014	139


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