Acquisition Of Citizenship By Age Group, Sex And Level Of Human Development Of Former Citizenship

Eurostat code: migr_acq1ctz · (2013 - 2023)

@eurostat.migr_acq1ctz

Table List

2 tables(1.62 MB)

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

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

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

@eurostat.migr_acq1ctz.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

849.5 KB
67541 rows
18 columns

freq Freq	citizen Citizen	agedef Agedef	age Age	unit Unit	sex Sex	geo Geo	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019
Annual	Candidate countries in 2013 (5 countries) except reporting country and Iceland	Age in completed years	Total	Number	Females	Austria	1038	894	911	954		1007	1215
Annual	Candidate countries in 2013 (5 countries) except reporting country and Iceland	Age in completed years	Total	Number	Females	Belgium	1413		584	626		652	712
Annual	Candidate countries in 2013 (5 countries) except reporting country and Iceland	Age in completed years	Total	Number	Females	Bulgaria	131	78	232	154		132	155
Annual	Candidate countries in 2013 (5 countries) except reporting country and Iceland	Age in completed years	Total	Number	Females	Switzerland	2735	2240	2404	2466		2366	2577
Annual	Candidate countries in 2013 (5 countries) except reporting country and Iceland	Age in completed years	Total	Number	Females	Cyprus	26	52	36	37	38	34	13
Annual	Candidate countries in 2013 (5 countries) except reporting country and Iceland	Age in completed years	Total	Number	Females	Czechia	17	37	37	46		25	30
Annual	Candidate countries in 2013 (5 countries) except reporting country and Iceland	Age in completed years	Total	Number	Females	Germany	13256		10376	9872		10220	10285
Annual	Candidate countries in 2013 (5 countries) except reporting country and Iceland	Age in completed years	Total	Number	Females	Denmark	98	84	395	625		95	70
Annual	Candidate countries in 2013 (5 countries) except reporting country and Iceland	Age in completed years	Total	Number	Females	Estonia
Annual	Candidate countries in 2013 (5 countries) except reporting country and Iceland	Age in completed years	Total	Number	Females	Greece	92	80	90	141		86	65


CREATE TABLE raw (
  "freq" VARCHAR,
  "citizen" VARCHAR,
  "agedef" VARCHAR,
  "age" VARCHAR,
  "unit" VARCHAR,
  "sex" VARCHAR,
  "geo" VARCHAR,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE
);

Share link

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