Acquisition Of Citizenship By Age Group, Sex And Former Citizenship

Eurostat code: migr_acq · (1998 - 2023)

@eurostat.migr_acq

Table List

2 tables(16.91 MB)

Acquisition Of Citizenship By Age Group, Sex And Former Citizenship - Raw

Acquisition Of Citizenship By Age Group, Sex And Former Citizenship - Unpivoted

Acquisition Of Citizenship By Age Group, Sex And Former Citizenship - Unpivoted

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

7.55 MB
12275536 rows
9 columns

freq Freq	citizen Citizen	agedef Agedef	age Age	unit Unit	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Total	Age in completed years	Total	Number	Total	Austria	1998	17786
Annual	Total	Age in completed years	Total	Number	Total	Belgium	1998	34034
Annual	Total	Age in completed years	Total	Number	Total	Switzerland	1998	21277
Annual	Total	Age in completed years	Total	Number	Total	Germany	1998	106790
Annual	Total	Age in completed years	Total	Number	Total	Denmark	1998	10262
Annual	Total	Age in completed years	Total	Number	Total	Estonia	1998	9969
Annual	Total	Age in completed years	Total	Number	Total	Greece	1998	807
Annual	Total	Age in completed years	Total	Number	Total	Spain	1998	12550
Annual	Total	Age in completed years	Total	Number	Total	Finland	1998	4017
Annual	Total	Age in completed years	Total	Number	Total	France	1998	123761


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

Share link

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