Change Of Immigration Status Permits By Age, Sex And Citizenship

Eurostat code: migr_reschst$dv_1285

@eurostat.migr_reschst_dv_1285

Table List

2 tables(13.83 KB)

Change Of Immigration Status Permits By Age, Sex And Citizenship - Raw

Change Of Immigration Status Permits By Age, Sex And Citizenship - Unpivoted

Change Of Immigration Status Permits By Age, Sex And Citizenship - Unpivoted

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

6.3 KB
85 rows
8 columns

freq Freq	citizen Citizen	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total	From 0 to 17 years	Total	Person	France	2020	115
Annual	Total	From 0 to 17 years	Total	Person	Austria	2021	1
Annual	Total	From 0 to 17 years	Total	Person	Belgium	2021	136
Annual	Total	From 0 to 17 years	Total	Person	Bulgaria	2021	225
Annual	Total	From 0 to 17 years	Total	Person	Cyprus	2021	65
Annual	Total	From 0 to 17 years	Total	Person	Czechia	2021	433
Annual	Total	From 0 to 17 years	Total	Person	Germany	2021	5613
Annual	Total	From 0 to 17 years	Total	Person	Denmark	2021	414
Annual	Total	From 0 to 17 years	Total	Person	Estonia	2021	9
Annual	Total	From 0 to 17 years	Total	Person	Greece	2021	159


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.