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

Eurostat code: migr_reslas · (2010 - 2023)

@eurostat.migr_reslas

Table List

2 tables(7.4 MB)

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

3.43 MB
4798114 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	Spain	2010	237
Annual	Females	Total	Andorra	Person	France	2010	188
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	1
Annual	Females	Total	Andorra	Person	Slovenia	2010
Annual	Females	Total	United Arab Emirates	Person	Belgium	2010


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.