Baselight
Sign In

Residents Who Acquired Citizenship As A Share Of Resident Non-citizens By Former Citizenship And Sex

Eurostat code: migr_acqs ยท (2009 - 2023)

@eurostat.migr_acqs

Residents Who Acquired Citizenship As A Share Of Resident Non-citizens By Former Citizenship And Sex - Unpivoted
@eurostat.migr_acqs.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.

  • 14.94 KB
  • 4162 rows
  • 7 columns
freq

Freq

unit

Unit

sex

Sex

indic_mg

Indic Mg

geo

Geo

time_period

Time Period

value

Value

AnnualPercentageFemalesShare of EU citizens who have acquired citizenshipAustria20090.34
AnnualPercentageFemalesShare of EU citizens who have acquired citizenshipBelgium20090.88
AnnualPercentageFemalesShare of EU citizens who have acquired citizenshipBulgaria2009
AnnualPercentageFemalesShare of EU citizens who have acquired citizenshipSwitzerland20091.76
AnnualPercentageFemalesShare of EU citizens who have acquired citizenshipCyprus20091.28
AnnualPercentageFemalesShare of EU citizens who have acquired citizenshipCzechia20090.31
AnnualPercentageFemalesShare of EU citizens who have acquired citizenshipGermany20090.75
AnnualPercentageFemalesShare of EU citizens who have acquired citizenshipDenmark20090.55
AnnualPercentageFemalesShare of EU citizens who have acquired citizenshipEstonia20090.03
AnnualPercentageFemalesShare of EU citizens who have acquired citizenshipGreece20090.17

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

Share link

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