Long-term Residents By Age, Sex And Citizenship On 31 December Of Each Year

Eurostat code: migr_reslas$dv_1283

@eurostat.migr_reslas_dv_1283

Table List

2 tables(25 KB)

Long-term Residents By Age, Sex And Citizenship On 31 December Of Each Year - Raw

Long-term Residents By Age, Sex And Citizenship On 31 December Of Each Year - Unpivoted

Long-term Residents By Age, Sex And Citizenship On 31 December Of Each Year - Unpivoted

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

9.82 KB
1070 rows
8 columns

freq Freq	sex Sex	age Age	citizen Citizen	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Females	4 years or less	Total	Person	Austria	2014	380
Annual	Females	4 years or less	Total	Person	Belgium	2014	2629
Annual	Females	4 years or less	Total	Person	Bulgaria	2014
Annual	Females	4 years or less	Total	Person	Switzerland	2014	14710
Annual	Females	4 years or less	Total	Person	Cyprus	2014	118
Annual	Females	4 years or less	Total	Person	Czechia	2014	5281
Annual	Females	4 years or less	Total	Person	Estonia	2014	723
Annual	Females	4 years or less	Total	Person	Greece	2014
Annual	Females	4 years or less	Total	Person	Spain	2014	343
Annual	Females	4 years or less	Total	Person	France	2014


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.