Long-term Residence Permits Issued During The Year By Age, Sex And Citizenship

Eurostat code: migr_resltra · (2020 - 2023)

@eurostat.migr_resltra

Table List

2 tables(1.33 MB)

Long-term Residence Permits Issued During The Year By Age, Sex And Citizenship - Raw

Long-term Residence Permits Issued During The Year By Age, Sex And Citizenship - Unpivoted

Long-term Residence Permits Issued During The Year By Age, Sex And Citizenship - Unpivoted

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

632.54 KB
1465933 rows
8 columns

freq Freq	citizen Citizen	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Andorra	Total	Females	Person	France	2020	47
Annual	Andorra	Total	Females	Person	Iceland	2020
Annual	Andorra	Total	Females	Person	Sweden	2020
Annual	Andorra	Total	Males	Person	France	2020	34
Annual	Andorra	Total	Males	Person	Iceland	2020
Annual	Andorra	Total	Males	Person	Sweden	2020
Annual	Andorra	Total	Total	Person	France	2020	81
Annual	Andorra	Total	Total	Person	Iceland	2020
Annual	Andorra	Total	Total	Person	Sweden	2020
Annual	Andorra	Total	Unknown	Person	France	2020


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

Share link

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